Problem with php

[r00tme]

Hello, this php script show on my website top 50 statistic on all crated characters. But I would like to make exeption for the GMs and Admins. So only normal players to be displayed. What should I do with that php or it is something in the SQL database. Thanks for your help in advance.
<?php
$query = mssql_query('SELECT TOP 50 * FROM Character ORDER BY Resets DESC, cLevel DESC');
$i = 0;
while($row = mssql_fetch_array($query)):
$char_class = char_class($row['Class']);
$i++;
?>

[MentaL]

[MrQU3ST10N]

maybe this thread can help you

LINK

[2009x2014]

mssql meh
use CtlCode (0 = normal, no banned no gm, unless your gm level is not set in db, then filter by nickname or account id)

by ctl code
->
$query = mssql_query('SELECT TOP 50 * FROM Character where CtlCode = 0 ORDER BY Resets DESC, cLevel DESC');

[r00tme]

Thanks a lot, for your help guys. I did that change in my php which 4Funer suggest and it's working at 100%. Thanks again.