NPC to delete SQL items

[IsabelaFernandez]

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

[sader1992]

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

[IsabelaFernandez]

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 September 15, 2020 by IsabelaFernandez

[mR L]

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

[Ronald]

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. 

[Patskie]

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

[IsabelaFernandez]

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.

[Hyroshima]

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

[IsabelaFernandez]

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?

[Hyroshima]

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