A doubt about SQL script

I'm getting deeper into SQL, I already created some functions that can be executed from within the game and change table lines from the database, I was successful, but I tried something similar in creating an item that give status, similar to the reset status item, only it would be a pink reset where I would return all pink star points, but all my attempts do not work, a simple script changes practically all db.char lines but in the status line nothing works, someone could dig me a little bit into this, just want learn, do not need a script done, an example or explanation would help a lot

Please be more specific what you want to do. We can't guess what you're trying to do without seeing the SQL query. From what you have said till now I only can guess that you want to make an item which gives stat points.

Quote:

Originally Posted by oldjayy Please be more specific what you want to do. We can't guess what you're trying to do without seeing the SQL query. From what you have said till now I only can guess that you want to make an item which gives stat points.

and a simple query, can be done in several ways by selling an item in npc and relogando, after that the update action


I do the same thing with other lines and it works, but for statpoints it does not work and that's what I'm trying to say

Most likely stats are being saved during logout process so the game overwrites your value which leads to editing stat points when char is logged out. You can use the stored procedure which is being used when logging out.

Quote:

Originally Posted by oldjayy Most likely stats are being saved during logout process so the game overwrites your value which leads to editing stat points when char is logged out. You can use the stored procedure which is being used when logging out.

yea, it was just that, i understand the dynamics now, i'm having trouble redefining the status of each class, i set up a procedure that worked, but all classes get the same status, but i think i can solve it i'm going deeper into SQL knowledge every day i'm learning a little bit, thanks