[joeroberts]

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?