[Npc that calculates all Zeny in server for Admin]

You cannot use number formats other than integer, unfortunately =/

But if you use Emistry's way, you select the value as a string, which is not as limited as an integer.

ahhhhh now i understand coz of the $, sorry emistry didn't notice that, will try, thx so much emistry and deadlysilence

[Help, Check if Equipped]

if you have set the mapflag and the item_noequip.txt, players can wear the item but the effect will be disabled

[Npc that calculates all Zeny in server for Admin]

not sure if this really work ...

 

query_sql( "SELECT SUM(`zeny`) FROM `char`",.@zeny$ );
mes "Total Zeny : "+.@zeny$;

if run by query...you can retrieve all zeny...and by using char variable to save the data....perhap you can achieve what you want...

 

 

if you want to change the zeny limit in server...believe that are alot part you need to change...datatype...sql datatype...and etc...

 

 

 

edit :

if you are using flux cp ... or ceres cp....i think both have the function ...just view the "server info" page of your website....

Yes sir, i use something like that to retrieve the zeny and still shows the max int limit, would it be possible to assign the .@zeny$ to be double?

[Npc that calculates all Zeny in server for Admin]

i'm trying to make an npc for admins to be able to check current total zeny in server

 

i could load it from mysql no problem 

 

the problem is when the message appear it only shows 2,147,483,647 zeny, i know this is due to signed int on zeny

 

my question is how to turn zeny into double only on my script so that the npc will show the correct amount of zeny?

 

 

i have been testing on a very simple script to be able to show amount above 2,147,483,647 and i keep on getting 0

 

the simple script i made is 

 

set a, 4000000000;

mes " Zeny is "+ a;

close;

 

Please kindly help

[Errors on startup related to interreg table]

try changing it into
 

CREATE TABLE IF NOT EXISTS `interreg` (
`varname` varchar(11) NOT NULL ,
`value` varchar(20) NOT NULL ,
PRIMARY KEY ( `varname` )
) ENGINE = InnoDB;

 

and you can also try just incase to change ` into ' for varchars type