Total Registered Players - MYSQL

Total Registered Players - MYSQL - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Total Registered Players - MYSQL (/showthread.php?tid=341737)

Total Registered Players - MYSQL - nGen.SoNNy - 11.05.2012

Hi! Can somebody tell me a function in mysql which can count the number of players from the database?

+REP

Re: Total Registered Players - MYSQL - Fj0rtizFredde - 11.05.2012

You could use COUNT() Like this:

PHP Code:



SELECT COUNT(*) FROM accounts

I think you also can use "mysql_num_rows" and do something like this:

pawn Code:

mysql_query("SELECT * FROM accounts");
mysql_store_result(); 
new rows = mysql_num_rows(); 
mysql_free_result();
 
printf("There are %d accounts",rows);

Re: Total Registered Players - MYSQL - Kar - 12.05.2012

pawn Code:

mysql_query("SELECT COUNT(`Username`) FROM Accounts");

Wouldn't this be better in terms of speed.

Re: Total Registered Players - MYSQL - nGen.SoNNy - 12.05.2012

Thx

Re: Total Registered Players - MYSQL - nGen.SoNNy - 12.05.2012

This works better

PHP Code:



SELECT COUNT(*) FROM accounts

Re: Total Registered Players - MYSQL - dEcooR - 24.07.2013

Can somebody tell me how to make it in normal example in Y_INI?

Re: Total Registered Players - MYSQL - x96664 - 28.09.2013

I know that I'm bumping an old topic, but how will this work for R33 plugin ?