Выводит людей, сделавших определённый квест
PHP код:
SELECT
cc.name, cc.level, a.username
FROM
characters.`character_queststatus` cq
INNER JOIN
characters.characters cc
ON
cc.guid = cq.guid
INNER JOIN
realmd.account a
ON
a.id = cc.account
WHERE
quest = xxx;
Когда выполняли квест
PHP код:
SELECT
cc.name, cc.level, a.username, from_unixtime(cq.time)
FROM
characters.`character_queststatus_daily` cq
INNER JOIN
characters.characters cc ON cc.guid = cq.guid
INNER JOIN
realmd.account a ON a.id = cc.account
WHERE
cq.quest = xxx
ORDER BY
from_unixtime(cq.time) DESC
LIMIT 0 , 300;
Выводит гм онлайн
PHP код:
SELECT
c.name, c.class, c.race, a.gmlevel
FROM
characters.characters c
INNER JOIN
realmd.account a
ON
a.id = c.account
WHERE
a.gmlevel != 0 && c.online = 1;