d4xyjen 0 Posted November 21, 2013 im just new here i want to know where to find on the database the points for each account on cash shop thanks Quote Share this post Link to post Share on other sites
0 jaBote 438 Posted November 21, 2013 They are stored as account variable on the scripting engine, named #CASHPOINTS and #KAFRAPOINTS if I remember well. Quote Share this post Link to post Share on other sites
0 d4xyjen 0 Posted November 21, 2013 (edited) i was referring to the FreeCash and CashPoints on the cash shop menuwhere i could find them on the database i mean on the sql Edited November 21, 2013 by d4xyjen Quote Share this post Link to post Share on other sites
0 jaBote 438 Posted November 21, 2013 On the global_reg_value table, associated with the respective account ID they belong to. Quote Share this post Link to post Share on other sites
0 d4xyjen 0 Posted November 21, 2013 (edited) 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 Quote Share this post Link to post Share on other sites
0 quesoph 105 Posted November 21, 2013 (edited) 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 Quote Share this post Link to post Share on other sites
0 jaBote 438 Posted November 21, 2013 I'd avoid to directly insert cashpoints to people on the SQL, just update the value if it is available there. Quote Share this post Link to post Share on other sites
0 d4xyjen 0 Posted November 21, 2013 Thanks for the reply problem solved Quote Share this post Link to post Share on other sites
im just new here i want to know where to find on the database the points for each account on cash shop thanks
Share this post
Link to post
Share on other sites