SQL Ingame Control Panel

[OnNplay]

This NPC can be use to reset char location to default town by login into game using another char within the same account.

Else to reset errored equipment /hairstyle /card.

Else change password.

[Euphy]

http://code.google.com/p/llchrisll-scripts/downloads/detail?name=acc_editor.txt&can=2&q=

[OnNplay]

Thanks Euphy. Not aware is already exist.

[Cephaler]

Does it also work for rathena?

The same way of loading a normal NPC? /custom etc?

[OnNplay]

Yes, it work.

[Emistry]

most of the script in eA will also work in rA , except for rA script to work in eA fully.

to add the npc...

it's the same for ALL npc no matter it is custom or not....

Adding_a_Script

[OnNplay]

[info]: 'OnNplay' logged in. (AID/CID: '2000006/150002', Packet Ver: '25', IP: '180.73.172.999').
[sql]: DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' `hair_color` , `clothes_color` = '0' , '0' , '0' WHERE `name` = 'Testchar' at line 1
[Debug]: at script.c:12753 - UPDATE `char` SET `hair` , `hair_color` , `clothes_color` = '0' , '0' , '0' WHERE `name` = 'Testchar'
[Debug]: Source (NPC): Control Panel at prontera (166,206)
[info]: Character 'OnNplay' logged off.

How to correct this error?

[GmOcean]

Um your error is your not setting the values when needed. It should be like this if i'm not mistaken:

query_sql"UPDATE `char` SET `hair`='0', `hair_color`='0', `clothes_color`='0' WHERE `name`='Testchar'";
//OR
query_sql"UPDATE `char` SET `hair`='0', `hair_color`='0', `clothes_color`='0' WHERE `name`='"+strcharinfo(0)+"'";
//OR
query_sql"UPDATE `char` SET `hair`='0', `hair_color`='0', `clothes_color`='0' WHERE `name`='"+string_variable$+"'";

[OnNplay]

Sadly this still not fix the issue.

[Famous]

this is great

[Cephaler]

Guys it does work properly but I keep having this annoying message:

[Cephaler]

Bump