Topserverplayers

[Fu Manchu]

I just need the file to ignore admins so it dosnt show staff on the top 10 charts.

<?php
	$ots = POT::getInstance();
	$ots->connect(POT::DB_MYSQL, connection());
	$SQL = $ots->getDBHandle(); 
	$get = $SQL->query("SELECT name,level FROM players ORDER BY experience DESC LIMIT 1,10");
	$i = 0;
	echo '<table cellspacing="0" cellpadding="3" border="0" width="100%">
    	<tr><td></td><td></td><td align="center"><b>LVL</b></td></tr>';
		foreach($get as $player) {
			$i++;
			echo '<tr>
            	<td width="19">

                	<strong>'.$i.'.</strong>
                </td>
                <td>
                	<a href="'.WEBSITE.'/index.php/character/view/'.$player['name'].'"><strong>'.$player['name'].'</strong></a>
                </td>
                <td align="center">
					<strong>'.$player['level'].'</strong>

                </td>
            </tr>';
		}
	echo '</table>';
?>

 

[Bogart]

<?php
    $ots = POT::getInstance();
    $ots->connect(POT::DB_MYSQL, connection());
    $SQL = $ots->getDBHandle(); 
    $get = $SQL->query("SELECT name,level FROM players WHERE group_id < 3 ORDER BY experience DESC LIMIT 1,10");
    $i = 0;
    echo '<table cellspacing="0" cellpadding="3" border="0" width="100%">
        <tr><td></td><td></td><td align="center"><b>LVL</b></td></tr>';
        foreach($get as $player) {
            $i++;
            echo '<tr>
                <td width="19">

                    <strong>'.$i.'.</strong>
                </td>
                <td>
                    <a href="'.WEBSITE.'/index.php/character/view/'.$player['name'].'"><strong>'.$player['name'].'</strong></a>
                </td>
                <td align="center">
                    <strong>'.$player['level'].'</strong>

                </td>
            </tr>';
        }
    echo '</table>';
?>

maybe.

 

[Fu Manchu]

lol Thx My dumb ass was trying to add $admin somehwere in there haha