need to change vocations

[zerghel]

im looking how to change all players with vocation id 9 to 5 in sql database

can someone post the command to do it?

thanks in advanced

Solved!

use

UPDATE `players` SET vocation =5 WHERE vocation =9

 

[eddypump]

it helped me!

 

[kingsley666]

how i can do this with a lua script?, i mean i want to do this but when i use a scroll or somehting like that

 

[Loney]

doPlayerSetVocation function.

Or well, take a look at this post, can be useful to you: http://otland.net/f81/set-player-vocation-18272/