Cash shop Points

[d4xyjen 0]

im just new here i want to know where to find on the database the points for each account on cash shop thanks

[jaBote 438]

I'd avoid to directly insert cashpoints to people on the SQL, just update the value if it is available there.

[jaBote 438]

They are stored as account variable on the scripting engine, named #CASHPOINTS and #KAFRAPOINTS if I remember well.

[d4xyjen 0]

i was referring to the FreeCash and CashPoints on the cash shop menu

where i could find them on the database i mean on the sql

Edited November 21, 2013 by d4xyjen

[jaBote 438]

On the global_reg_value table, associated with the respective account ID they belong to.

[d4xyjen 0]

thanks for the reply for example i want to add points on it what would be my values? on the querry?
 

INSERT INTO  `ragnarok`.`global_reg_value` (

`char_id` ,

`str` ,

`value` ,

`type` ,

`account_id`

)

  VALUES (

'???',  '???S',  '???',  '?',  ?'

);

 

Edited November 21, 2013 by d4xyjen

[quesoph 105]

Ingame.

key in

@cash 123 //for cash points@points 123 // for kafra points / free points

 

 

 

Script

set #CASHPOINTS, #CASHPOINTS + 123; //for cash pointsset #KAFRAPOINTS, #KAFRAPOINTS + 123; // for kafra points / free points

Edited November 21, 2013 by quesoph

[d4xyjen 0]

Thanks for the reply problem solved