[PowerF]

i know it by this

Код:

mysql_query("SELECT COUNT(`playerName`) FROM playerdata");

but how do i it when the player registered and the server says total registered to all online players?

[PowerF]

Help

[Vince]

cache_insert_id()

Use in callback after insert query.

[PowerF]

Can someone show me the full code of this?

[Jefff]

You can load all in OnGameModeInit

top
new TotalUsers;

OnGameModeInit
mysql_query("SELECT COUNT(*) FROM playerdata");
TotalUsers = mysql_fetch_int
mysql_free_result

and when new player is register
TotalUsers++;
format(str,sizeof(str),"total users: %d",TotalUsers);
SCMToAll

[PowerF]

If the server is restarted,is it gonna reset the value?

[Jefff]

No because its doing again
mysql_query("SELECT COUNT(*) FROM playerdata");
TotalUsers = mysql_fetch_int
mysql_free_result