Topplayers.php

[Fu Manchu]

<?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>';
?>

I need to make this ignore gms cms and god :S can anyone help me you or just give me the code to stop it from happening and then I figure out where it goes?


Thanks guys!

 

[Bogart]

maybe something like this:

<?php
    $ots = POT::getInstance();
    $ots->connect(POT::DB_MYSQL, connection());
    $SQL = $ots->getDBHandle(); 
    $get = $SQL->query("SELECT name,level FROM players WHERE group_id > 2 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>';
?>

 

[Fu Manchu]

It only removed my acc :s lol but my bodies god and then a cm or gm is still showing up :s

 

[Cykotitan]

WHERE group_id < 4 ?

 

[Bogart]

wops. change > for < at line 5 and change 2 to 4 <,<

edit:
Cyko stop being fast!

 

[Fu Manchu]

hahahah fuckin love that guy haha thx bogart and cyko