charsearch.php

<?php

$pagetitle = 'Account Search';

require 'common.php';

if (!$logged)
{
	$tpl->message = 'You must be logged in to view this page.';
	$tpl->Execute('header');
	$tpl->Execute('footer');
	exit;
}

if (!$GM)
{
	$tpl->message = 'You must be a Game Master to view this page.';
	$tpl->Execute('header');
	$tpl->Execute('footer');
	exit;
}

$tpl->Execute('header');

if (isset($_POST['name']))
{
	$name = strtolower($_POST['name']);
	
	$characters = $db->SQL("SELECT * FROM characters WHERE name LIKE '$' LIMIT 0,100", $name);

	foreach ($characters as &$character)
	{
		$character['name'] = ucfirst($character['name']);
		$character['gender'] = $character['gender']?'Male':'Female';
		$character['title'] = empty($character['title'])?'-':ucfirst($character['title']);
		$character['exp'] = number_format($character['exp']);
		switch ($character['admin'])
		{
			case ADMIN_PLAYER: $character['admin_str'] = 'Player'; break;
			case ADMIN_GUIDE: $character['admin_str'] = 'Light Guide'; $character['gm'] = true; break;
			case ADMIN_GUARDIAN: $character['admin_str'] = 'Guardian'; $character['gm'] = true; break;
			case ADMIN_GM: $character['admin_str'] = 'Game Master'; $character['gm'] = true; break;
			case ADMIN_HGM: $character['admin_str'] = 'High Game Master'; $character['gm'] = true; break;
			default: $character['admin_str'] = 'Unknown'; break;
		}
	}
	unset($character);

	$tpl->characters = $characters;

	$tpl->Execute('charsearch_results');
}
else
{
	$tpl->Execute('charsearch');
}

$tpl->Execute('footer');