GM

Подарок от меня, всем кто сомневается в своих ГМ

SELECT p.name, c.account_name, c.char_name,c2.char_name
FROM `characters` c, `items_from_gm` i, `prices` p, npc n, `characters` c2
WHERE c.obj_Id = i.owner_id
AND p.item_id = i.item_id
AND i.source = n.id
AND i.destination = c2.obj_Id

Пример дропа с рейдов 40+
SELECT p.name, c.account_name, c.char_name, i.create_time, n.name, n.level
FROM `characters` c, `items` i, `prices` p, npc n
WHERE c.obj_Id = i.owner_id
AND p.item_id = i.item_id
AND i.source = n.id
AND i.`source`
IN (

SELECT id
FROM `npc`
WHERE `type` = 'L2Boss' or `type` = 'L2RaidBoss'
AND LEVEL >40
)

веши ГМ которые в данный момент у игроков

SELECT p.name, c.account_name, c.char_name,c2.char_name
FROM `characters` c, `items_from_gm` i, `prices` p, npc n, `characters` c2
WHERE c.obj_Id = i.owner_id
AND p.item_id = i.item_id
AND i.source = n.id
AND i.destination = c2.obj_Id

Действия ГМ и время


SELECT p.name, c.char_name, FROM_UNIXTIME(i.create_time) as date, c2.char_name
FROM
`characters` c, `prices` p,`items` i, `characters` c2
WHERE
c.obj_Id = i.owner_id AND
p.item_id = i.item_id AND
i.`create_type`="RequestBuyItem[145]" and
i.destination!=i.`owner_id` and
i.destination = c2.obj_Id AND
i.`destination` in (SELECT `obj_Id` FROM `characters` WHERE `accesslevel` >0)
order by i.create_time, c.char_name

Надеюсь много кому помог.