How can i reset all the skills of all the characters in the servers?

[jpnazar 0]

How can i reset all the skills  of all the characters in the servers?

[jaBote 438]

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.

[jpnazar 0]

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.

how to truncate?

[jaBote 438]

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.

[Gepard 55]

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.

This will, however, not reset skills of all characters on the server, just all characters that fully logged in to the game.

[jaBote 438]

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.

[Gepard 55]

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 )