Jump to content
  • 0

Find items


OceanusPT

Question

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?

 

 

Link to comment
  • Answers 3
  • Created
  • Last Reply

Top Posters For This Question

Top Posters For This Question

3 answers to this question

Recommended Posts

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.