Cash shop Points

[d4xyjen]

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

 

[jaBote]

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

 

[d4xyjen]

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

 

[jaBote]

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

 

[d4xyjen]

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',  '???',  '?',  ?'
);
 

 

[quesoph]

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

 

[jaBote]

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

 

[d4xyjen]

Thanks for the reply problem solved