| joeroberts |
6th October 2009 14:18 |
Looks cool
Why not just add the wanted query info to first query rather then make a second one?
PHP Code:
$sql = "SELECT seedbonus, avatar, uploaded, downloaded, invites, can_do, level, uploaded/downloaded AS ratio FROM ".$db_prefix."_users WHERE id = '".$user->id."';";
$res = $db->sql_query($sql);
list ($seedbonus, $avatar, $uploaded, $downloaded, $invites, $can_do, $level, $ratio) = $db->sql_fetchrow($res);
$db->sql_freeresult($res);
then in switch use $can_do
PHP Code:
switch ($can_do) {
case "banned": {
echo _btclassbanned;
break;
}
case "user": {
echo "<img src=\"themes/pmbt/pics/newbie.gif\">";
break;
}
case "moderator": {
echo "<img src=\"themes/pmbt/pics/moderator.gif\">";
break;
}
case "premium": {
echo "<img src=\"themes/pmbt/pics/elitemember.gif\">";
break;
}
case "admin": {
echo "<img src=\"themes/pmbt/pics/Administrator.gif\">";
break;
}
}
can you offer up some sample icons? |
