Jump to content

Recommended Posts

Posted

 

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

Posted

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

Posted

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!

  • 7 months later...
  • 11 months later...
Posted (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

 

 

 

error_zpsnswp8mo4.png

 

I dont know if I should create a table on my "ragnarok" schema, everything on those errors are exist on my "logs" schema

Edited by trenzerai
  • 8 months later...
Posted (edited)

I'm having the same issue as above, I have separated logs and ragnarok shemas, the script fails deleting those logs tables.

Edited by Auryn
  • 8 months later...
  • 7 years later...
Posted
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?

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...