SQL Script Question

[Virtue]

Hi Scripting Pros,

 

is it possible to use this query on a script?

 

 

SELECT COUNT(account_id) AS OnlinePlayers FROM char WHERE online=1;
 

 

I will be using it for some script that checks the online player count

 

Thanks to those who will help.

[Patskie]

For what reason? you just need the data and not the column name

[Mootie]

For what reason? you just need the data and not the column name

Data..... what data? data folder? sql data?

 

 

You can revise this script

 

http://rathena.org/board/files/go/bd245e8b5202aa15932c5a1826e142fc/ingame-gm-list

[Euphy]

Yes, that query is valid. Alternately, you could just use the return value of Query_sql (or the array size, doesn't make much of a difference).

 

Data..... what data? data folder?

He's referring to the SQL data.

[Mootie]

Yes, that query is valid. Alternately, you could just use the return value of Query_sql (or the array size, doesn't make much of a difference).

 

Data..... what data? data folder? sql data?

He's referring to the SQL data.

 

this?

mysql_select_db($Srv_Database, $Connection);
    $query = "SELECT COUNT(*) as total FROM `char` WHERE online = '1'";
 

[Patskie]

For what reason? you just need the data and not the column name

Do data folder have column name? Topic title already implies what my answer is all about

[Emistry]

something like this ?

prontera,155,161,5	script	Sample	757,{
query_sql( "SELECT `name` FROM `char` WHERE `online` = 1 LIMIT 128",.@name$ );
.@size = getarraysize( .@name$ );
while( .@i < .@size ){
	if( !checkvending( .@name$[.@i ) )
		.@count++;
	.@i++;
}
mes "Total "+.@count+" Player online without Vending.";
mes "Total "+( .@size - .@count )+" Player online with Vending.";
close;
}

my current script only limited to max 128 players...if you want to extend this.... you can try make use of OFFSET in the SQL statement ...