Location: PHPKode > projects > VampMan: V:tR Character Manager > vampman-1.0.2/phpnuke/modules/charactersheet/admin/charactersheet/viewuser.php
<?php
if (!eregi("admin.php", $_SERVER['PHP_SELF'])) { die (_accessdenied); }


$queryusername = "select username from ".$prefix."_users where user_id = '$charuserid'";
$resultusername = sql_query($queryusername, $dbi);
list($charusername) = sql_fetch_row($resultusername,$dbi);

echo $charusername._s_characters.": <br>";

$query = "Select charid,charname,active from ".$prefix."_character_characters where userid = '$charuserid'";

	$result = sql_query($query,$dbi);
	$num = sql_num_rows($result);

	for($i = 0; $i < $num; $i++)
	{
		$line = sql_fetch_array($result);

		$charid = $line['charid'];
		$charname = $line['charname'];
		$charactive = $line['active'];
		echo "$charname";
		if($charactive) echo " ("._active.")";
		echo " <a href=\"admin.php?op=character_viewcharacter&charid=$charid&firstload=1&submit="._edit."\">"._edit."</a>";
		echo " | <a href=\"admin.php?op=character_viewcharacter&charid=$charid&firstload=1&submit="._view."\">"._view."</a><br>";

	}

?>
Return current item: VampMan: V:tR Character Manager