RESET Char Position?

[Michael D.]

how to reset char position because my char is stuck in an unknown map.

here's the ss.

[Euphy]

UPDATE `char` SET `last_map`='prontera',`last_x`=156,`last_y`=191 WHERE `name`='<char name>';

[nanakiwurtz]

Thank Euphy for the SQL code, but I think if there's no security measure, someone could abuse the code

[Mystery]

UPDATE `char` SET `last_map`='prontera',`last_x`=156,`last_y`=191 WHERE `name`='<char name>';

Thank Euphy for the SQL code, but I think if there's no security measure, someone could abuse the code

You could use the code; there's no problem with the code cause all you gotta do is put the name of the char in the space indicated. Other then that, you can manually do it by heading to your char database and find the last map they were own and manually input the new name of the map for the char.

[Michael D.]

Thanks Euphy. it really helps me alot.

[nanakiwurtz]

You could use the code; there's no problem with the code cause all you gotta do is put the name of the char in the space indicated. Other then that, you can manually do it by heading to your char database and find the last map they were own and manually input the new name of the map for the char.

Yes, what I mean is, if we create a NPC with this code, then we should add another security to authenticate whether she/he is the correct account owner.

[Emistry]

in the first place....euphy doesnt create this script to be use using NPC.....

he just simple write your a SQL Command so that you can shutdown your server and run it in your SQL Machine .....