I was looking at the top players page and noticed a GM was accounted for most CPs. I don't see that being too fair, but maybe an error on your part. You can use this SQL query to select, order, and limit the results to normal players only.
Silvers ordered from greatest to least, with 20 maximum results:
Code:
SELECT `CharName`,`Money` FROM `characters` WHERE (`Account` NOT IN(SELECT `AccountID` FROM `accounts` WHERE `Status`=8) AND `Money` > 0) ORDER BY `Money` DESC LIMIT 20;
CPs ordered from greatest to least, with 20 maximum results:
Code:
SELECT `CharName`,`CPs` FROM `characters` WHERE (`Account` NOT IN(SELECT `AccountID` FROM `accounts` WHERE `Status`=8) AND `CPs` > 0) ORDER BY `CPs` DESC LIMIT 20;
Very easy query, can be suited to fit your needs/wants easily.