ranking page

Hi all

How to Hide admins form ranking page
?
thanx

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.

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

i get errors
thanx for help anyway

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

Quote:

---

Originally Posted by 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

---

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