Database Questions (Maybe Log questions too)

[lolobama]

How can I find out what items exist and on what accounts theyre on?
How can I See which accounts have traded to others?

[nubness]

• Existing items - PS_GameData
  • CharItems - Inventory
  • UserStoredItems - Warehouse
  • MarketItems - Auction Board
  • GuildStoredItems - Guild House Warehouse
• Transaction Logs - PS_GameLog
  • ActionLog
    • ActionType = 117

[IonutTheDawg]

You can find out wich characters have a specific item by running this query and replacing the 'itemid' with the item's id that you're intrested in. ( 's are optional)

USE PS_GameData SELECT CharID
FROM CharItems
WHERE ItemID= 'itemid'

[lolobama]

Thanks to both of you, is there a query that could be run to find specific user's trade logs?

[nubness]

• By UserID:
  

  SELECT * FROM PS_GameLog.dbo.ActionLog
  WHERE UserUID = (SELECT UserUID FROM PS_UserData.dbo.Users_Master
  WHERE UserID = '[B][U][I]USER ID HERE[/I][/U][/B]')

• By CharName:
  

  SELECT * FROM PS_GameLog.dbo.ActionLog
  WHERE CharID = (SELECT CharID FROM PS_GameData.dbo.Chars
  WHERE CharName = '[B][U][I]CHAR NAME HERE[/I][/U][/B]')

• All chars on that account, by specifying one CharID:
  

  SELECT * FROM PS_GameLog.dbo.ActionLog
  WHERE UserUID = (SELECT UserUID FROM PS_GameData.dbo.Chars
  WHERE CharName = '[B][U][I]CHAR NAME HERE[/I][/U][/B]')