Jump to content
  • 0
Sign in to follow this  
IsabelaFernandez

NPC to delete SQL items

Question

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

Share this post


Link to post
Share on other sites

9 answers to this question

Recommended Posts

  • 1

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

Share this post


Link to post
Share on other sites
  • 0
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

Share this post


Link to post
Share on other sites
  • 0
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

Share this post


Link to post
Share on other sites
  • 0
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. 

Share this post


Link to post
Share on other sites
  • 0

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

  • Upvote 1

Share this post


Link to post
Share on other sites
  • 0
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.

Share this post


Link to post
Share on other sites
  • 0

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

Share this post


Link to post
Share on other sites
  • 0
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?

Share this post


Link to post
Share on other sites
  • 0
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

Share this post


Link to post
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.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use and Privacy Policy.