Guild Warehouse Log

04/07/2015 08:40 [GM]Precious#1
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
04/08/2015 06:19 nick4ever#2
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?