Kido Posted June 10, 2014 Posted June 10, 2014 Nowhere in the script has it delete from the players storage. Peopleperson49 query_sql("DELETE FROM `atcommandlog` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `BalanceRank` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `bonus_script` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `branchlog` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `buyingstore_items` WHERE `buyingstore_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `buyingstores` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `cashlog` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `cp_charprefs` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `cp_choko_rename_log` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `elemental` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `emprank` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `friends` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `guild` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `guild_member` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `homunculus` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `hotkey` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `memo` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `mercenary` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `mercenary_owner` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `mvplog` WHERE `kill_char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `mvprank` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `npclog` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `party` WHERE `leader_char`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `pet` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `picklog` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `pvprank` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `quest` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `sc_data` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `skill` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `skillcooldown` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `vendings` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `zenylog` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `inventory` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `cart_inventory` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `global_reg_value` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); query_sql("DELETE FROM `char` WHERE `char_id`='"+escape_sql(.@char_id)+"'"); as Zell said, looks liek the player need to logoff so the emulator saves the items in the storage, because if not then the items of the player will be deleted because the emulator haven't save the data in storage so it's like the items are still equiped or in the inventory and the script deletes that D:! Quote
Peopleperson49 Posted June 14, 2014 Author Posted June 14, 2014 It's not really a bug, but I will script in a warning of this condition. A valid point though. Thanks. Peopleperson49 1 Quote
Kido Posted June 14, 2014 Posted June 14, 2014 It's not really a bug, but I will script in a warning of this condition. A valid point though. Thanks. Peopleperson49 Thanks to you, you are always so cool :DD Quote
Peopleperson49 Posted June 14, 2014 Author Posted June 14, 2014 (edited) I added a version 1.2 now. The warning is a simple message, but atleast people will have a clue. As long as they actually read it... Peopleperson49 Edited June 14, 2014 by Peopleperson49 Quote
Kido Posted June 14, 2014 Posted June 14, 2014 I added a version 1.2 now. The warning is a simple message, but atleast people will have a clue. As long as they actually read it... Peopleperson49 May i suggest to make them wait a few seconds util the server stores the data D: ? thanks again! Quote
Cancel Posted February 5, 2015 Posted February 5, 2015 (edited) thanks @Peopleperson49, it works in my server that use md5 hash user password Edited February 5, 2015 by Cancel Quote
robothautis Posted February 12, 2015 Posted February 12, 2015 excuse me .. i haave same problem with this, where should i put this command to ? Quote
trenzerai Posted February 9, 2016 Posted February 9, 2016 (edited) This works great since im having problems deleting some characters on my test server but i got errors on my map-serv. It shows like this I dont know if I should create a table on my "ragnarok" schema, everything on those errors are exist on my "logs" schema Edited February 9, 2016 by trenzerai Quote
Auryn Posted October 9, 2016 Posted October 9, 2016 (edited) I'm having the same issue as above, I have separated logs and ragnarok shemas, the script fails deleting those logs tables. Edited October 9, 2016 by Auryn Quote
ADMSarah Posted December 15, 2024 Posted December 15, 2024 On 3/29/2014 at 1:57 AM, Peopleperson49 said: Delete Characters This script allows you to delete characters in-game. When used it will ask the player to confirm and then kick them out of the server. When they log back their character and in all variables will be gone forever. It is handy since some of the new clients won't properly delete characters. The map server will get an error that says, "charif_ack_login_req failed - player not online". However all functions work great. I'm working on what error but I think it has to do with the script still going after the player is kicked. If anybody has any ideas let me know. Delete_Character.txt Version 1.0 Delete_Character.txt Version 1.1 Delete_Character.txt Version 1.2 Hi... do you have a latest version for this that works on the latest commit? Quote
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.