 |
- Guild -
by Class, by Character, by Player
".$v."s
\n";
echo "\n";
$qry = mysql_db_query("EQim12",
"select characters.* from players left join characters on players.playerid=characters.playerid
where class='$v' and pri='1' $active order by level desc, name"
);
while ($char=mysql_fetch_object($qry)) {
$edit="";
$names=array();
if($admin) {
$edit=EditUrl($char->playerid,players,"(id $char->playerid)",$where) . " ";
}
$twinks=mysql_db_query("EQim12",
"select name from characters
where playerid='$char->playerid' and pri='0' order by level desc, name"
);
while ($twink=mysql_fetch_object($twinks)){
array_push($names, $twink->name);
}
mysql_free_result($twinks);
echo "\n";
if(admin)
echo "\t| $editplayerid\">$char->name | \n";
else
echo "\t$editplayerid\">$char->name | \n";
echo "\t$char->level $char->race | \n";
echo "\t".join($names,", ")." | \n";
echo " \n";
}
mysql_free_result($qry);
echo "\n";
echo "\t| | \n";
echo "\t | \n";
echo "\t | \n";
echo " \n";
echo " \n";
}
?>
|
 |
