27.02.2015, 21:32
1. new field in database, preferably in users table called "ip"
2. when the player logs in / registers the ip would be updated to that value
3. make the command with a parameter (zcmd & sscanf is a good way to do that)
4. on the command, use the SELECT to count the amount of rows first
5. retrieve the rows and the other stuff you want to have (score, name, last login etc.)
6. once that's all done add it into a dialog or use SendClientMessage to each one that was found
7. go and test it
I'm not doing it for you, steps are the best way to learn.
2. when the player logs in / registers the ip would be updated to that value
3. make the command with a parameter (zcmd & sscanf is a good way to do that)
4. on the command, use the SELECT to count the amount of rows first
5. retrieve the rows and the other stuff you want to have (score, name, last login etc.)
6. once that's all done add it into a dialog or use SendClientMessage to each one that was found
7. go and test it
I'm not doing it for you, steps are the best way to learn.