Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- log_aoh.log.time AS "When",
- player_aoh.player.`name` AS Who,
- log_aoh.log.how AS WhatDid,
- log_aoh.log.what AS ItemID,
- log_aoh.log.vnum AS ItemVnum,
- player_aoh.item_proto.locale_name AS ItemName,
- player_aoh.item.count AS Count,
- player_aoh.item.Socket0,
- player_aoh.item.Socket1,
- player_aoh.item.Socket2,
- player_aoh.item.AttrType0,
- player_aoh.item.AttrValue0,
- player_aoh.item.AttrType1,
- player_aoh.item.AttrValue1,
- player_aoh.item.AttrType2,
- player_aoh.item.AttrValue2,
- player_aoh.item.AttrType3,
- player_aoh.item.AttrValue3,
- player_aoh.item.AttrType4,
- player_aoh.item.AttrValue4,
- player_aoh.item.AttrType5,
- player_aoh.item.AttrValue5,
- player_aoh.item.AttrType6,
- player_aoh.item.AttrValue6
- FROM
- log_aoh.log
- INNER JOIN player_aoh.player ON log_aoh.log.who = player_aoh.player.id
- INNER JOIN player_aoh.item ON log_aoh.log.what = player_aoh.item.id
- INNER JOIN player_aoh.item_proto ON log_aoh.log.vnum = player_aoh.item_proto.vnum
- WHERE log_aoh.log.how in ("EXCHANGE_GIVE", "EXCHANGE_TAKE", "DROP", "SAFEBOX PUT", "SAFEBOX GET", "DEAD_DROP")
- AND player_aoh.player.`name` = "[GA]T4UMP";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement