Save character data

[hthuong]

How to save character data to SQL with script?

[Nana]

You have to use something like this

query_sql "SELECT `str` FROM global_reg_value WHERE account_id = " +.@idcuenta[0], .@array$[0]; // check cash points

if (.@array$[0] != "#CASHPOINTS") { // if not then null

query_sql "INSERT INTO `global_reg_value` (`char_id`,`str`,`value`,`type`,`account_id`) VALUES ('0','#CASHPOINTS','" +.@cantidad +"','2','" +.@idcuenta[0] +"')"; // Create cash points SQL

} else { // Cash exist

// update

} // End if

this is just an example of Rokimoki's guide n_n ~

Edited December 31, 2012 by aisha

[Euphy]

Query_sql