get stats of char

[mleo1]

what function do you use to get characters stat agi str dex etc.?

[Patskie]

Via SQL :

query_sql "SELECT `str` , `agi` , `vit` , `int` , `dex` , `luk` FROM `char` WHERE `account_id` = '"+getcharid(3)+"'",@str,@agi,@vit,@int,@dex,@luk;

Edit : getcharid(3) will get the current stats of the current account. If you intend to do this on GM side you must put a way for a GM to input other's account id.

 

For example : 

input @account_id;
 
query_sql "SELECT `str` , `agi` , `vit` , `int` , `dex` , `luk` FROM `char` WHERE `account_id` = '"+@account_id+"'",@str,@agi,@vit,@int,@dex,@luk;

Edited April 10, 2013 by Patskie

[Emistry]

mes "STR : "+readparam( bStr );
mes "AGI : "+readparam( bAgi );
mes "VIT : "+readparam( bVit );
mes "DEX : "+readparam( bDex );
mes "INT : "+readparam( bInt );
mes "LUK : "+readparam( bLuk );

refer readparam 

 

if you want to get the stats of other characters...then use the method from previous post..through SQL...

[mleo1]

thanks pats and emistry