Find items

[OceanusPT 3]

SELECT
    log.log.time AS "When",
    player.player.`name` AS Who,
    log.log.how AS WhatDid,
    log.log.what AS ItemID,
    log.log.vnum AS ItemVnum,
    player.item_proto.locale_name AS ItemName,
    player.item.count AS Count,
    player.item.Socket0,
    player.item.Socket1,
    player.item.Socket2,
    player.item.AttrType0,
    player.item.AttrValue0,
    player.item.AttrType1,
    player.item.AttrValue1,
    player.item.AttrType2,
    player.item.AttrValue2,
    player.item.AttrType3,
    player.item.AttrValue3,
    player.item.AttrType4,
    player.item.AttrValue4,
    player.item.AttrType5,
    player.item.AttrValue5,
    player.item.AttrType6,
    player.item.AttrValue6
FROM
    log.log
INNER JOIN player.player ON log.log.who = player.player.id
INNER JOIN player.item ON log.log.what = player.item.id
INNER JOIN player.item_proto ON log.log.vnum = player.item_proto.vnum
WHERE log.how in ("EXCHANGE_GIVE", "EXCHANGE_TAKE", "DROP", "SAFEBOX PUT", "SAFEBOX GET", "DEAD_DROP")
AND player.`name` = "Xeriesey"; 

Hi there,

 

i have found this query here in dev, but it's possible to change this query, so wee can see the player who have take the items?

 

 

[Shogun 5791]

Moved to questions and answers.

[Think 118]

What are you asking about exactly?

[OceanusPT 3]

in this query only show the player "Xeriesey" give itens. But dont show the name of the player who take this itens. I wanna see the name of player who take the itens from Xeriesey. It's possible?