Guild Warehouse Log

[[GM]Precious]

Hi,

I search but no luck for me

Is it possible to know who put items from guild warehouse and also who took it? ActionType = ?

Hi I found the actiontype code.

ActionType = 200 --put item in GWH
ActionType = 201 --remove item from GWH

[nick4ever]

1. Create a toon named Precious
2. truncate table PS_GameLog.dbo.ActionLogs
3. Put item in GWH
4. Take that item out of GWH
5. Select * from PS_GameLog.dbo.ActionLogs where CharID = (select CharID from PS_GameData.dbo.Chars where Charname = 'Precious') order by ActionTime DESC
6. Get the ActionType of Put item in and Get Item out

Select Charname from PS_GameData.dbo.Chars where Charid = (Select CharID from PS_GameLog.dbo.ActionLog where Actiontype = 'put your action type here')

this is a sample you want more complex with full information?