Hi all
How to Hide admins form ranking page
?
thanx
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"
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