Jump to content
  • 0

NPC to delete SQL items


IsabelaFernandez

Question


  • Group:  Members
  • Topic Count:  145
  • Topics Per Day:  0.07
  • Content Count:  354
  • Reputation:   8
  • Joined:  04/16/18
  • Last Seen:  

hello community,
as the title says, I would like an NPC (functional, I've tested others but none of them worked) to delete items. with the option to delete an item quantity per ID from all accounts and another option to delete only one specific account / char.
Sometimes some items are buggy either sprite or something missing and I can only log into the account by deleting the character and this delays a lot

Link to comment
Share on other sites

9 answers to this question

Recommended Posts

  • 1

  • Group:  Content Moderator
  • Topic Count:  55
  • Topics Per Day:  0.02
  • Content Count:  1676
  • Reputation:   702
  • Joined:  12/21/14
  • Last Seen:  

it's not a good  idea to delete items directly from the database

also it's better  if the server was offline when you edit the database

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  145
  • Topics Per Day:  0.07
  • Content Count:  354
  • Reputation:   8
  • Joined:  04/16/18
  • Last Seen:  

22 minutes ago, sader1992 said:

it's not a good  idea to delete items directly from the database

also it's better  if the server was offline when you edit the database

I have difficulty deleting in SQL, some items do not disappear and the buggy remain there ... do you have any suggestions to help me?

not to delete from the database, only from specific accounts.

Edited by IsabelaFernandez
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  177
  • Reputation:   25
  • Joined:  12/24/14
  • Last Seen:  

3 hours ago, IsabelaFernandez said:

I have difficulty deleting in SQL, some items do not disappear and the buggy remain there ... do you have any suggestions to help me?

not to delete from the database, only from specific accounts.

Cause your server still online

Make offline first and then delete

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  22
  • Topics Per Day:  0.01
  • Content Count:  241
  • Reputation:   18
  • Joined:  06/04/14
  • Last Seen:  

7 hours ago, IsabelaFernandez said:

I have difficulty deleting in SQL, some items do not disappear and the buggy remain there ... do you have any suggestions to help me?

not to delete from the database, only from specific accounts.

Do SQL query when your server is offline. 

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  50
  • Topics Per Day:  0.01
  • Content Count:  1702
  • Reputation:   238
  • Joined:  09/05/12
  • Last Seen:  

Whenever you delete the item of a player from SQL, the character must be offline else it will not reflect properly.

  • Upvote 1
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  145
  • Topics Per Day:  0.07
  • Content Count:  354
  • Reputation:   8
  • Joined:  04/16/18
  • Last Seen:  

On 9/19/2020 at 6:38 AM, Patskie said:

Whenever you delete the item of a player from SQL, the character must be offline else it will not reflect properly.

is it necessary for the "server" to be turned off or just the accounts that will be affected by the removal of the item?
I could shut down the server and put only high groups (90+) to connect, thus deleting the IDs desired by the NPC. I think it would be practical for an NPC to directly delete equipped items, inventory, storage, storage guild, alt W items, etc.

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  34
  • Topics Per Day:  0.01
  • Content Count:  159
  • Reputation:   58
  • Joined:  07/11/14
  • Last Seen:  

could use a web-CP to unequip the char and then ask the person to use an npc that deletes items from the inventory

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  145
  • Topics Per Day:  0.07
  • Content Count:  354
  • Reputation:   8
  • Joined:  04/16/18
  • Last Seen:  

18 hours ago, Hyroshima said:

could use a web-CP to unequip the char and then ask the person to use an npc that deletes items from the inventory

I'm using a custom web cp, does everyone have this unequip char option?

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  34
  • Topics Per Day:  0.01
  • Content Count:  159
  • Reputation:   58
  • Joined:  07/11/14
  • Last Seen:  

On 9/26/2020 at 7:52 PM, IsabelaFernandez said:

I'm using a custom web cp, does everyone have this unequip char option?

I don't know if they all have them, but the most well-known ones have flux-cp and ceres-cp

Link to comment
Share on other sites

Join the conversation

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

Guest
Answer this question...

×   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.

×
×
  • Create New...