Utility: Delete Character Command

[Kido]

 

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:!

[Peopleperson49]

It's not really a bug, but I will script in a warning of this condition. A valid point though. Thanks.

 

Peopleperson49

[Kido]

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

[Peopleperson49]

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

[Kido]

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!

[Cancel]

thanks @Peopleperson49, it works in my server that use md5 hash user password

Edited February 5, 2015 by Cancel

[robothautis]

excuse me .. i haave same problem with this, where should i put this command to ?

[trenzerai]

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

[Auryn]

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

[ianisdigital]

Where can i paste this script?

[ADMSarah]

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?