I need help - ticket credits sql

[w000t]

Hi!

 

How do I add credits ( fluxcp) using sql?

 

If the player does not have credit it uses the INSERT INTO sql command. If the player has credits it uses only the UPDATE sql command to add more credit.

 

 

20400,Credits_ticket,Credits_ticket,0,50,,70,,,,,0xFFFFFFFF,7,2,,,,,,{ query_sql("UPDATE `rathenadb`.`cp_credits` SET `balance` = +'1000' WHERE `cp_credits`.`account_id` = 2000000;");},{},{}

 

 

Thanks!

Edited June 17, 2014 by w000t

[Emistry]

then....what you actually want ??

 

add credit into the database ??

or

insert credit into the database ??

or

both ??

[w000t]

Yes, both.

[Emistry]

INSERT INTO ........ ON DUPLICATE UPDATE `xyz` = `xyz + 1;

it should be something like this...