bots.php

<?php
/***************************************************************************
 *
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 *
 *   Portions of this program are derived from publicly licensed software
 *   projects including, but not limited to phpBB, Magelo Clone, 
 *   EQEmulator, EQEditor, and Allakhazam Clone.
 *
 *                                  Author:
 *                           Maudigan(Airwalking) 
 *
 *   April 16, 2020 - Maudigan
 *       Initial Revision
 *   April 25, 2020 - Maudigan
 *     implement multi-tenancy
 *
 ***************************************************************************/
  
 
/*********************************************
                 INCLUDES
*********************************************/ 
define('INCHARBROWSER', true);
include_once(__DIR__ . "/include/common.php");
include_once(__DIR__ . "/include/profile.php");
include_once(__DIR__ . "/include/db.php");
  
 
/*********************************************
         SETUP PROFILE/PERMISSIONS
*********************************************/
if(!$_GET['char']) cb_message_die($language['MESSAGE_ERROR'],$language['MESSAGE_NO_CHAR']);
else $charName = $_GET['char'];

//character initializations 
$char = new profile($charName, $cbsql, $cbsql_content, $language, $showsoftdelete, $charbrowser_is_admin_page); //the profile class will sanitize the character name
$charID = $char->char_id(); 
$name = $char->GetValue('name');
$mypermission = GetPermissions($char->GetValue('gm'), $char->GetValue('anon'), $char->char_id());
$userip = getIPAddress(); 

$tpl = 
	<<<TPL
		SELECT ai.ip as ip
		FROM character_data cd
		INNER JOIN account_ip AI on ai.accid = cd.account_id
		WHERE cd.id = $charID
		ORDER BY ai.lastused DESC
		LIMIT 1
	TPL;
	$result = $cbsql->query($tpl);
	$bots = $cbsql->fetch_all($result);  
foreach($bots as $bot) {
	if ($bot['ip'] == $userip || $userip == $defaultedlocalhost || $userip == $localipaddress || $userip == $defaultgateway) {
		$ownercheck = 1;
	}
}

//block view if user level doesnt have permission
if ($mypermission['bots'] && $ownercheck != 1) cb_message_die($language['MESSAGE_ERROR'],$language['MESSAGE_PERMISSIONS_ERROR']);
 
 
/*********************************************
        GATHER RELEVANT PAGE DATA
*********************************************/

if ($ownercheck == 1) {
	$botip = $bot['ip'];
	$tpl = <<<TPL
		SELECT bd.name AS name, bd.race AS race, bd.gender AS gender
				, bd.class AS class, bd.face AS face, bd.level AS level
				, bd.owner_id as ownerid, cd.name as ownername
				,	(CASE
						WHEN cd.id != $charID
							THEN cd.level
						ELSE 0
					END) as namescore
		FROM account_ip ai 
		LEFT JOIN character_data cd ON cd.account_id = ai.accid
		LEFT JOIN bot_data bd ON bd.owner_id = cd.id
		WHERE ai.ip = '$botip'
		AND bd.name NOT LIKE '%-deleted-%'
		GROUP BY ai.ip, bd.bot_id
		ORDER BY namescore ASC, cd.aa_points_spent DESC, bd.name ASC 
	TPL;
} else {
	$tpl = <<<TPL
	SELECT name, race, gender,
		class, face, level
	FROM bot_data 
	WHERE owner_id = $charID 
	ORDER BY name ASC 
	TPL;
}
$query = sprintf($tpl, $charID);
$result = $cbsql->query($tpl);
if (!$cbsql->rows($result)) cb_message_die($language['BOTS_BOTS']." - ".$name,$language['MESSAGE_NO_BOTS']);


$bots = $cbsql->fetch_all($result);  
 
 
/*********************************************
               DROP HEADER
*********************************************/
$d_title = " - ".$name.$language['PAGE_TITLES_BOTS'];
include(__DIR__ . "/include/header.php");
 
 
/*********************************************
            DROP PROFILE MENU
*********************************************/
output_profile_menu($name, 'bots');
 
 
/*********************************************
              POPULATE BODY
*********************************************/
$cb_template->set_filenames(array(
   'bots' => 'bots_body.tpl')
);


if ($ownercheck) {
	$cb_template->assign_both_vars(array(  
	'NAME'        => $name . ' + Owned')
	);
} else {
	$cb_template->assign_both_vars(array(  
		'NAME'        => $name)
	);
}
$cb_template->assign_vars(array(  
   'L_BOTS'  => $language['BOTS_BOTS'], 
   'L_DONE'      => $language['BUTTON_DONE'])
);
foreach($bots as $bot) {
	if ($ownercheck) {
		$ownedby = '<br> (Owned by ' . $bot['ownername'] . ')';
	} else {
		$ownedby = '';
	}
	$cb_template->assign_both_block_vars("bots", array( 
		'NAME'    => $bot['name'],
		'AVATAR_IMG' => getAvatarImage($bot['race'], $bot['gender'], $bot['face']),
		'RACE'    => $dbracenames[$bot['race']],
		'CLASS'   => $dbclassnames[$bot['class']] . '' . $ownedby,
		'LEVEL'    => $bot['level'])
	);
}
 
 
/*********************************************
           OUTPUT BODY AND FOOTER
*********************************************/
$cb_template->pparse('bots');

$cb_template->destroy;

include(__DIR__ . "/include/footer.php");

?>