[davidbull]

how to get player mysql id from name (GetPlayerName)?
I will rep+
thanks

[MikE1990]

Change field name and table name

Код:

SELECT `FIELD NAME` FROM `TABLE NAME` WHERE `Username` = '%s'

[davidbull]

can i get player rank from top 10 list? sorry for my bad english ^.^

[MikE1990]

of course you can.Change table name and if your field is not rank change it too.

Код:

SELECT `Rank` FROM `TABLE NAME` ORDER BY Rank LIMIT 10

[davidbull]

no, i mean get the player position on top 10 list.
example:
TOP NAME SCORES
1. abcd1 10
2. abcd2 9
3. abcd3 8
4. abcd4 7
5. abcd5 6
6. abcd6 5
...
to the player position exam is 10 ). how to do it

[Kaliber]

Код:

SELECT `Username` FROM `TABLE NAME` ORDER BY Rank LIMIT 10

Greekz

[davidbull]

Quote:

Originally Posted by Kaliber Код: SELECT `Username` FROM `TABLE NAME` ORDER BY Rank LIMIT 10 Greekz

no limit