OnNplay Posted September 29, 2012 Group: Members Topic Count: 9 Topics Per Day: 0.00 Content Count: 141 Reputation: 15 Joined: 01/08/12 Last Seen: July 26, 2014 Share Posted September 29, 2012 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. Quote Link to comment Share on other sites More sharing options...
Euphy Posted September 29, 2012 Group: Members Topic Count: 72 Topics Per Day: 0.02 Content Count: 2997 Reputation: 1130 Joined: 05/27/12 Last Seen: June 1, 2017 Share Posted September 29, 2012 http://code.google.com/p/llchrisll-scripts/downloads/detail?name=acc_editor.txt&can=2&q= Quote Link to comment Share on other sites More sharing options...
OnNplay Posted September 29, 2012 Group: Members Topic Count: 9 Topics Per Day: 0.00 Content Count: 141 Reputation: 15 Joined: 01/08/12 Last Seen: July 26, 2014 Author Share Posted September 29, 2012 Thanks Euphy. Not aware is already exist. Quote Link to comment Share on other sites More sharing options...
Cephaler Posted September 29, 2012 Group: Members Topic Count: 17 Topics Per Day: 0.00 Content Count: 132 Reputation: 2 Joined: 02/02/12 Last Seen: May 25, 2019 Share Posted September 29, 2012 Does it also work for rathena? The same way of loading a normal NPC? /custom etc? Quote Link to comment Share on other sites More sharing options...
OnNplay Posted September 29, 2012 Group: Members Topic Count: 9 Topics Per Day: 0.00 Content Count: 141 Reputation: 15 Joined: 01/08/12 Last Seen: July 26, 2014 Author Share Posted September 29, 2012 Yes, it work. Quote Link to comment Share on other sites More sharing options...
Emistry Posted September 29, 2012 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10015 Reputation: 2348 Joined: 10/28/11 Last Seen: Monday at 06:22 AM Share Posted September 29, 2012 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 Quote Link to comment Share on other sites More sharing options...
OnNplay Posted September 29, 2012 Group: Members Topic Count: 9 Topics Per Day: 0.00 Content Count: 141 Reputation: 15 Joined: 01/08/12 Last Seen: July 26, 2014 Author Share Posted September 29, 2012 [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? Quote Link to comment Share on other sites More sharing options...
GmOcean Posted September 30, 2012 Group: Members Topic Count: 31 Topics Per Day: 0.01 Content Count: 666 Reputation: 93 Joined: 04/27/12 Last Seen: August 17, 2015 Share Posted September 30, 2012 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$+"'"; Quote Link to comment Share on other sites More sharing options...
OnNplay Posted October 5, 2012 Group: Members Topic Count: 9 Topics Per Day: 0.00 Content Count: 141 Reputation: 15 Joined: 01/08/12 Last Seen: July 26, 2014 Author Share Posted October 5, 2012 Sadly this still not fix the issue. Quote Link to comment Share on other sites More sharing options...
Famous Posted October 10, 2012 Group: Members Topic Count: 145 Topics Per Day: 0.03 Content Count: 455 Reputation: 3 Joined: 06/19/12 Last Seen: February 26, 2018 Share Posted October 10, 2012 this is great Quote Link to comment Share on other sites More sharing options...
Cephaler Posted October 21, 2012 Group: Members Topic Count: 17 Topics Per Day: 0.00 Content Count: 132 Reputation: 2 Joined: 02/02/12 Last Seen: May 25, 2019 Share Posted October 21, 2012 Guys it does work properly but I keep having this annoying message: Quote Link to comment Share on other sites More sharing options...
Cephaler Posted October 23, 2012 Group: Members Topic Count: 17 Topics Per Day: 0.00 Content Count: 132 Reputation: 2 Joined: 02/02/12 Last Seen: May 25, 2019 Share Posted October 23, 2012 Bump Quote Link to comment Share on other sites More sharing options...
Question
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.
Link to comment
Share on other sites
11 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.