<?php

$dbhost = 'localhost';
$dbuser = 'deb27663_MyBB';
$dbpass = 'MyBBForum';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die (mysql_error());

$dbname = 'deb27663_MyBB';
mysql_select_db($dbname, $conn);


function table_mods($username, $uid, $email, $realname, $country, $xfire) {
  return '                <td>
                       <table border="0" width="305" style="color: #BBB; font-family: Geneva, Tahoma, Nimbus Sans L, sans-serif; border-spacing: 2px; font-size: 12px; line-height: 1.7em;">
                               <tr style="text-align: left;">

                                       <th colspan="3" style="border-bottom: 2px solid #FFFFFF;"><strong><b>'.$username.'</b></strong></th>
                               </tr>
                               <tr>
                                       <td>Real Name</td>
                                       <td>::</td>
                                       <td>'.$realname.'</td>
                               </tr>
                               <tr>
                                       <td>Age</td>
                                       <td>::</td>
                                       <td>PRIV</td>
                               </tr>
                               <tr>
                                       <td>Country</td>
                                       <td>::</td>
                                       <td>'.$country.'</td>
                               </tr>
                               <tr>
                                       <td>Xfire</td>
                                       <td>::</td>
                                       <td><a href="xfire:add_friend?user='.$xfire.'" style="color: #048DE6; text-decoration: none;">'.$xfire.'</a></td>
                               </tr>
                               <tr>
                                       <td>Email</td>
                                       <td>::</td>
                                       <td>'.$email.'</td>
                               </tr>
                               <tr>
                                       <td>Function</td>
                                       <td>::</td>
                                       <td>PRIV</td>
                               </tr>
                       </table>
               </td>';
}

$moderators = mysql_query("SELECT * FROM `mybb_users` WHERE `usergroup` IN (3,4,6) ORDER BY `uid` ASC");
$mods_a = mysql_num_rows($moderators);

if(isset($_GET['test'])) {
    echo $mods_a;
}
?>
<table border="0">
        <tr>
<?php

if($mods_a == 1 OR $mods_a == 2) {
$query1 = mysql_query("SELECT u.`uid`, u.`username`, u.`email`, uf.`fid4`, uf.`fid5`, uf.`fid7`, u.`usergroup`
                                                       FROM `mybb_users` AS u
                                                       LEFT JOIN `mybb_userfields` AS uf
                                                       ON u.uid = uf.ufid
                                                       WHERE u.`usergroup` IN (3,4,6)
                                                       ORDER BY u.`uid`
                                                       ASC LIMIT 0,2");
}

if($mods_a == 3 OR $mods_a == 4) {
$query2 = mysql_query("SELECT u.`uid`, u.`username`, u.`email`, uf.`fid4`, uf.`fid5`, uf.`fid7`, u.`usergroup`
                                                       FROM `mybb_users` AS u
                                                       LEFT JOIN `mybb_userfields` AS uf
                                                       ON u.uid = uf.ufid
                                                       WHERE u.`usergroup` IN (3,4,6)
                                                       ORDER BY u.`uid`
                                                       ASC LIMIT 3,4");
}
if($mods_a == 5 OR $mods_a == 6) {
$query3 = mysql_query("SELECT u.`uid`, u.`username`, u.`email`, uf.`fid4`, uf.`fid5`, uf.`fid7`, u.`usergroup`
                                                       FROM `mybb_users` AS u
                                                       LEFT JOIN `mybb_userfields` AS uf
                                                       ON u.uid = uf.ufid
                                                       WHERE u.`usergroup` IN (3,4,6)
                                                       ORDER BY u.`uid`
                                                       ASC LIMIT 5,6");
}
if($mods_a == 7 OR $mods_a == 8) {
$query4 = mysql_query("SELECT u.`uid`, u.`username`, u.`email`, uf.`fid4`, uf.`fid5`, uf.`fid7`, u.`usergroup`
                                                       FROM `mybb_users` AS u
                                                       LEFT JOIN `mybb_userfields` AS uf
                                                       ON u.uid = uf.ufid
                                                       WHERE u.`usergroup` IN (3,4,6)
                                                       ORDER BY u.`uid`
                                                       ASC LIMIT 7,8");
}
if($mods_a == 9 OR $mods_a == 10) {
$query5 = mysql_query("SELECT u.`uid`, u.`username`, u.`email`, uf.`fid4`, uf.`fid5`, uf.`fid7`, u.`usergroup`
                                                       FROM `mybb_users` AS u
                                                       LEFT JOIN `mybb_userfields` AS uf
                                                       ON u.uid = uf.ufid
                                                       WHERE u.`usergroup` IN (3,4,6)
                                                       ORDER BY u.`uid`
                                                       ASC LIMIT 9,10");
}

if(isset($query1)) {
while($row1 = mysql_fetch_assoc($query1)) {
                echo table_mods($row1['username'], intval($row1['uid']), $row1['email'], $row1['fid5'], $row1['fid7'], $row1['fid4']);
}
}

if(isset($query2)) {
while($row2 = mysql_fetch_assoc($query2)) {
                echo table_mods($row2['username'], intval($row2['uid']), $row2['email'], $row2['fid5'], $row2['fid7'], $row2['fid4']);
}
}

if(isset($query3)) {
while($row3 = mysql_fetch_assoc($query3)) {
                echo table_mods($row3['username'], intval($row3['uid']), $row3['email'], $row3['fid5'], $row3['fid7'], $row3['fid4']);
}
}

if(isset($query4)) {
while($row4 = mysql_fetch_assoc($query4)) {
                echo table_mods($row4['username'], intval($row4['uid']), $row4['email'], $row4['fid5'], $row4['fid7'], $row4['fid4']);
}
}

if(isset($query5)) {
while($row5 = mysql_fetch_assoc($query5)) {
                echo table_mods($row5['username'], intval($row5['uid']), $row5['email'], $row5['fid5'], $row5['fid7'], $row5['fid4']);
}
}

?>
        </tr>
</table>