Ways to clean inventory

I was wondering if there was any way to clean the inventory faster than dragging each item to the npc and then pressing ok.
Something as fast as a click, same thing goes for purchasing items from item mall for example.

USE PS_GameData
Delete from CharItems where CharID ='CharID here'
or
Delete from CharItems where ItemID = 'ItemID here'

If you have a GM Char (which I assume you'd have if you are able to execute the querry posted above), an easier way to clean your inventory would simply be typing /iclear

how about player sided ?

There is nothing like that possible by default, at least of what I know of.

What you could do:
- Use one of the basic GM statuses for players, so that they have access to the /iclear command
- use Shaiya Server Extended and write a plugin that will allow players to clean their inventory

Quote:

Originally Posted by MC Flip There is nothing like that possible by default, at least of what I know of. What you could do: - Use one of the basic GM statuses for players, so that they have access to the /iclear command - use Shaiya Server Extended and write a plugin that will allow players to clean their inventory

bad idea as there are always people who will mess up and might clear their whole inventory with their pvp gears etc.. for example..

A simple addition to the Server ToS can solve that.

"Use the /iclear command at your own risk. XY Shaiya is not responsible for any gear loss."

i use macros like normal player

Take an unused item then name it like "Inventory wiper". Remember its itemid.

OK now write a trigger that monitor ps_gamelog, whoever throw that item to NPC (look up the actiontype), capture his/her charid and execute the following query.

update ps_gamedata.dbo.charitems set del = 0 where charid = 1234
or
delete from ps_gamedata.dbo.charitems where charid = 1234

of course, the player need to re log in.

Just a little funny way, try it at your own risk.

You could use Packets for a Clientside way and you could also
add a warning right there for the usage. Anyway dont ask me
for a Tutorial pls.