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?