How can i reset all the skills of all the characters in the servers?
- Thread starter jpnazar
- Start date
Don't know of an easy way of doing this except for making a NPC:
- script resetskill -1,{OnPCLoginEvent: if (!resetted) { resetskill; set resetted, 1; } end;}
You could also truncate the skill table, but that won't refund the used skill points to the players.
- script resetskill -1,{OnPCLoginEvent: if (!resetted) { resetskill; set resetted, 1; } end;}
You could also truncate the skill table, but that won't refund the used skill points to the players.
NOTE!! All used skillpoints WILL be gone if you do that, so you may experience buggyness on your server if you decide to proceed doing this.
For truncating the table you should issue the following command on your ragnarok database:
TRUNCATE TABLE `skill`;
If you don't have enough permissions for doing this, you could issue this command, which is slower but will do the job:
DELETE FROM `skill`;
Remember that all data will be gone and you can't undo these statements. A backup of the database is highly reccommended before doing this.
Hope I helped.
For truncating the table you should issue the following command on your ragnarok database:
TRUNCATE TABLE `skill`;
If you don't have enough permissions for doing this, you could issue this command, which is slower but will do the job:
DELETE FROM `skill`;
Remember that all data will be gone and you can't undo these statements. A backup of the database is highly reccommended before doing this.
Hope I helped.
Gepard
Community Contributors
This will, however, not reset skills of all characters on the server, just all characters that fully logged in to the game.
Well, it's a hotfix and if you're in a pserver open to public this will work for any active users, which is what you want and will do the job if you keep that NPC on the server forever, providing you won't unset that resetted var.
The TRUNCATE method works for every character on the server but all used skill points won't be back.
The TRUNCATE method works for every character on the server but all used skill points won't be back.
Gepard
Community Contributors
I think that NPC solution is good enough, but I also thought it's worth pointing out that it's not the exact solution to OP's question, just to avoid confusion. It might not be obvious to everyone that this script only works if player logs in (but it should be
)