| - Guild -
by Class, by Character, by Player
$active = "where players.active='1'";
if($admin) $active = "";
$resultcharacters = mysql_db_query("EQim12" , "select characters.*,players.nick from characters left join players on players.playerid=characters.playerid $active order by level desc, name");
while ($char=mysql_fetch_object($resultcharacters)) {
$where = $REQUEST_URI;
echo "id\">\n";
echo "[$char->level $char->class]\n";
echo EditUrl($char->id, "characters", $char->name, $where);
echo " ($char->race)\n";
if($admin) {
echo "playerid\">$char->nick";
} else
echo "playerid\">$char->nick";
echo " \n";
}
?>
|