show all total #CASHPOINTS in server

[sumano98]

for easy check cash in server

[crazyarashi]

-	script	server_cash	-1,{
	query_sql("SELECT sum(`value`) FROM `acc_reg_num` WHERE `key` = '#CASHPOINTS'",.@total$);
	mes "Total Server Cash : " + .@total$;
	end;
}

 

Edited October 23, 2019 by crazyarashi
Correct Query

[sumano98]

15 hours ago, crazyarashi said:

-	script	server_cash	-1,{
	.@total = query_sql("SELECT sum(`value`) FROM `acc_reg_num` WHERE `key` = '#CASHPOINTS'");
	mes "Total Server Cash : " + .@total;
	end;
}

 

i not sure why i have cash 1000 but show in script 1 cash

Edited October 23, 2019 by sumano98

[crazyarashi]

25 minutes ago, sumano98 said:

i not sure why i have cash 1000 but show in script 1 cash

I updated the query

[LOOLP - OFF]

 

just select your database in the table that is saving all the variables #

[Balfear]

8 hours ago, sumano98 said:

for easy check cash in server

SELECT sum(`value`) FROM acc_reg_num where `key` = '#CASHPOINTS';

[n3ySkie]

-    script    zxzasasas    -1,{

OnCmdHour:
    dispbottom "Your Server Cash:";
    message strcharinfo(0),"Cash Points Total Balance = "+#CASHPOINTS+" Cash Points(s)";
    end;

OnInit:
    bindatcmd "points","playerpoints::OnCmdHour"; //@points to view time till next point.
}

 

 

just copy paste  "message strcharinfo(0),"Cash Points Total Balance = "+#CASHPOINTS+" Cash Points(s)";

and edit #CASHPOINTS+ depends on your #variables