-----ТАБЛИЦА ЧАРОВ-----
SELECT characters.charId, characters.account_name, characters.lastAccess, characters.accessLevel, characters.char_name, characters.online, characters.level, characters.sex, characters.pvpkills, characters.pkkills, characters.onlinetime, characters.base_class, characters.exp, characters.sp, characters.karma, characters.maxHp, characters.maxMp, characters.x, characters.y, characters.z, characters.in_jail, characters.jail_timer, characters.banchat_timer, characters.nobless, characters.title ,clan_data.clan_name, clan_data.clan_id, clan_data.ally_id, clan_data.ally_name, clan_data.clan_level, clan_data.reputation_score, clan_data.leader_id,char_templates.classname, char_templates.STR AS str, char_templates.CON AS con, char_templates.DEX AS dex, char_templates._INT AS _int, char_templates.MEN AS men, char_templates.WIT AS wit
FROM `characters`
LEFT JOIN `char_templates` ON characters.classid = char_templates.classid
LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id
ORDER BY online DESC, accesslevel DESC , char_name ASC
LIMIT 0
,100
-----ТАБЛИЦА КЛАНОВ-----
SELECT clan_data.clan_name, clan_data.clan_id, clan_data.ally_id, clan_data.ally_name, clan_data.clan_level, clan_data.reputation_score, clan_data.leader_id,characters.charId, characters.account_name, characters.lastAccess, characters.accessLevel, characters.char_name, characters.online, characters.level, characters.sex, characters.pvpkills, characters.pkkills, characters.onlinetime, characters.base_class, characters.exp, characters.sp, characters.karma, characters.maxHp, characters.maxMp, characters.x, characters.y, characters.z, characters.in_jail, characters.jail_timer, characters.banchat_timer, characters.nobless, characters.title ,castle.name AS castleName, castle.id AS castleID, castle.taxPercent, castle.siegeDate,clanhall.name AS clanhallName, clanhall.location AS clanhallLocation
FROM `clan_data`
LEFT JOIN `characters` ON characters.charId = clan_data.leader_id
LEFT JOIN `clanhall` ON clanhall.ownerId = clan_data.clan_id
LEFT JOIN `castle` ON castle.id = clan_data.hasCastle
ORDER BY clan_name ASC
LIMIT 0,100
ТОПЫ
---ТОП 100---
SELECT characters.charId, characters.account_name, characters.lastAccess, characters.accessLevel, characters.char_name, characters.online, characters.level, characters.sex, characters.pvpkills, characters.pkkills, characters.onlinetime, characters.base_class, characters.exp, characters.sp, characters.karma, characters.maxHp, characters.maxMp, characters.x, characters.y, characters.z, characters.in_jail, characters.jail_timer, characters.banchat_timer, characters.nobless, characters.title ,clan_data.clan_name, clan_data.clan_id, clan_data.ally_id, clan_data.ally_name, clan_data.clan_level, clan_data.reputation_score, clan_data.leader_id,char_templates.classname, char_templates.STR AS str, char_templates.CON AS con, char_templates.DEX AS dex, char_templates._INT AS _int, char_templates.MEN AS men, char_templates.WIT AS wit
FROM `characters`
LEFT JOIN char_templates ON char_templates.classid = characters.classid
LEFT JOIN clan_data ON clan_data.clan_id = characters.clanid
WHERE accesslevel=0
ORDER BY exp DESC
LIMIT 100
---ТОП ПВП---
SELECT characters.charId, characters.account_name, characters.lastAccess, characters.accessLevel, characters.char_name, characters.online, characters.level, characters.sex, characters.pvpkills, characters.pkkills, characters.onlinetime, characters.base_class, characters.exp, characters.sp, characters.karma, characters.maxHp, characters.maxMp, characters.x, characters.y, characters.z, characters.in_jail, characters.jail_timer, characters.banchat_timer, characters.nobless, characters.title ,clan_data.clan_name, clan_data.clan_id, clan_data.ally_id, clan_data.ally_name, clan_data.clan_level, clan_data.reputation_score, clan_data.leader_id,char_templates.classname, char_templates.STR AS str, char_templates.CON AS con, char_templates.DEX AS dex, char_templates._INT AS _int, char_templates.MEN AS men, char_templates.WIT AS wit
FROM `characters`
LEFT JOIN char_templates ON char_templates.ClassId = characters.classid
LEFT JOIN clan_data ON clan_data.clan_id = characters.clanid
WHERE accesslevel=0 AND pvpkills>0
ORDER BY pvpkills DESC, exp DESC
LIMIT 100
---ТОП ПК---
SELECT characters.charId, characters.account_name, characters.lastAccess, characters.accessLevel, characters.char_name, characters.online, characters.level, characters.sex, characters.pvpkills, characters.pkkills, characters.onlinetime, characters.base_class, characters.exp, characters.sp, characters.karma, characters.maxHp, characters.maxMp, characters.x, characters.y, characters.z, characters.in_jail, characters.jail_timer, characters.banchat_timer, characters.nobless, characters.title ,clan_data.clan_name, clan_data.clan_id, clan_data.ally_id, clan_data.ally_name, clan_data.clan_level, clan_data.reputation_score, clan_data.leader_id,char_templates.classname, char_templates.STR AS str, char_templates.CON AS con, char_templates.DEX AS dex, char_templates._INT AS _int, char_templates.MEN AS men, char_templates.WIT AS wit
FROM `characters`
LEFT JOIN char_templates ON char_templates.ClassId = characters.classid
LEFT JOIN clan_data ON clan_data.clan_id = characters.clanid
WHERE accesslevel=0 AND pkkills>0
ORDER BY pkkills DESC, exp DESC
LIMIT 100
---ТОП ОНЛАЙН---
SELECT characters.charId, characters.account_name, characters.lastAccess, characters.accessLevel, characters.char_name, characters.online, characters.level, characters.sex, characters.pvpkills, characters.pkkills, characters.onlinetime, characters.base_class, characters.exp, characters.sp, characters.karma, characters.maxHp, characters.maxMp, characters.x, characters.y, characters.z, characters.in_jail, characters.jail_timer, characters.banchat_timer, characters.nobless, characters.title ,clan_data.clan_name, clan_data.clan_id, clan_data.ally_id, clan_data.ally_name, clan_data.clan_level, clan_data.reputation_score, clan_data.leader_id,char_templates.classname, char_templates.STR AS str, char_templates.CON AS con, char_templates.DEX AS dex, char_templates._INT AS _int, char_templates.MEN AS men, char_templates.WIT AS wit
FROM `characters`
LEFT JOIN char_templates ON char_templates.ClassId = characters.classid
LEFT JOIN clan_data ON clan_data.clan_id = characters.clanid
WHERE accesslevel=0
ORDER BY onlinetime DESC, exp DESC
LIMIT 100
----ТОП КЛАНОВ----
SELECT clan_data.clan_name, clan_data.clan_id, clan_data.ally_id, clan_data.ally_name, clan_data.clan_level, clan_data.reputation_score, clan_data.leader_id,characters.charId, characters.account_name, characters.lastAccess, characters.accessLevel, characters.char_name, characters.online, characters.level, characters.sex, characters.pvpkills, characters.pkkills, characters.onlinetime, characters.base_class, characters.exp, characters.sp, characters.karma, characters.maxHp, characters.maxMp, characters.x, characters.y, characters.z, characters.in_jail, characters.jail_timer, characters.banchat_timer, characters.nobless, characters.title ,csum,ccount,cavg
FROM clan_data
LEFT JOIN characters ON clan_data.leader_id=characters.charId
LEFT JOIN (
SELECT clanid, SUM(level) AS csum, count(level) AS ccount,
AVG(level) AS cavg
FROM characters
WHERE clanid GROUP BY clanid
) AS levels ON clan_data.clan_id = levels.clanid
ORDER BY csum DESC
LIMIT 100
----КТО В ИГРЕ----
SELECT characters.charId, characters.account_name, characters.lastAccess, characters.accessLevel, characters.char_name, characters.online, characters.level, characters.sex, characters.pvpkills, characters.pkkills, characters.onlinetime, characters.base_class, characters.exp, characters.sp, characters.karma, characters.maxHp, characters.maxMp, characters.x, characters.y, characters.z, characters.in_jail, characters.jail_timer, characters.banchat_timer, characters.nobless, characters.title ,clan_data.clan_name, clan_data.clan_id, clan_data.ally_id, clan_data.ally_name, clan_data.clan_level, clan_data.reputation_score, clan_data.leader_id,char_templates.classname, char_templates.STR AS str, char_templates.CON AS con, char_templates.DEX AS dex, char_templates._INT AS _int, char_templates.MEN AS men, char_templates.WIT AS wit
FROM `characters`
LEFT JOIN char_templates ON char_templates.ClassId = characters.classid
LEFT JOIN clan_data ON clan_data.clan_id = characters.clanid
WHERE accesslevel=0 AND online=1
ORDER BY online DESC, accesslevel DESC, exp DESC
LIMIT 100
скрыть
