Ways to clean inventory

12/12/2017 17:45 djakao#1
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.
12/12/2017 19:01 SnickQ#2
USE PS_GameData
Delete from CharItems where CharID ='CharID here'
or
Delete from CharItems where ItemID = 'ItemID here'
12/12/2017 19:24 MC Flip#3
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
12/12/2017 19:27 djakao#4
how about player sided ?
12/19/2017 17:19 MC Flip#5
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
12/19/2017 17:24 AnimuNazi#6
Quote:
Originally Posted by MC Flip View Post
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..
12/19/2017 18:31 MC Flip#7
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."
07/12/2018 02:28 tiger86#8
i use macros like normal player
07/12/2018 09:50 nick4ever#9
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.
07/12/2018 22:31 wurstbrot123#10
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.