ranking page

[mhmd135]

Hi all

How to Hide admins form ranking page
?
thanx

[MentaL]

[Lifeles5]

Hmm, nice question btw :). I suggest you to try "NOT IN".

Try this:

SELECT * FROM Character WHERE AID NOT IN (SELECT AID FROM Account WHERE UGradeID = 255 OR PGradeID = 255) AND (DeleteFlag = 0 OR DeleteFlag = NULL) ORDER BY ... it's up to you

I have not tried this out, so it may have some errors. If it does, please let me know.

[Phoenix]

SELECT TOP 50 FROM Character WHERE AID NOT IN (SELECT AID FROM Account WHERE UGradeID = 255 OR UGradeID = 253) AND (DeleteFlag = 0 OR DeleteFlag = NULL) ORDER BY XP DESC

[mhmd135]

i get errors
thanx for help anyway

[Dawson]

for the 100th time, if you get errors post the errors, don't just say "I get errors"

[Lifeles5]

SELECT TOP 50 FROM Character WHERE AID NOT IN (SELECT AID FROM Account WHERE UGradeID = 255 OR UGradeID = 253) AND (DeleteFlag = 0 OR DeleteFlag = NULL) ORDER BY XP DESC

You will need the "*" anyways, since you request every row from the db not just a specified one. So in this way your script may look like something like this:

SELECT TOP 50 * FROM Character WHERE AID NOT IN (SELECT AID FROM Account WHERE UGradeID = 255 OR UGradeID = 253) AND (DeleteFlag = 0 OR DeleteFlag = NULL) ORDER BY XP DESC