барохлит статистика
сборка l2j-eqal
собствено статистика выдаёт ошибки,
прмиеры ошибок
Ошибка запроса (95.169.186.19, eqgs):
SELECT `characters`.`obj_Id` AS `charId`, `characters`.`account_name` AS `account_name`, `characters`.`clanid` AS `clanid`, `characters`.`lastAccess` AS `lastAccess`, `characters`.`accesslevel` AS `accessLevel`, `characters`.`char_name` AS `char_name`, `characters`.`online` AS `online`, `characters`.`level` AS `level`, `characters`.`sex` AS `sex`, `characters`.`pvpkills` AS `pvpkills`, `characters`.`pkkills` AS `pkkills`, `characters`.`onlinetime` AS `onlinetime`, `characters`.`base_class` AS `base_class`, `characters`.`exp` AS `exp`, `characters`.`sp` AS `sp`, `characters`.`race` AS `race`, `characters`.`karma` AS `karma`, `characters`.`maxHp` AS `maxHp`, `characters`.`maxMp` AS `maxMp`, `characters`.`x` AS `x`, `characters`.`y` AS `y`, `characters`.`z` AS `z`, `characters`.`nobless` AS `nobless`, `characters`.`title` AS `title`, `items`.`item_id` FROM `items` LEFT JOIN `characters` ON `characters`.`charId` = `items`.`owner_id` WHERE `items`.`item_id` = '8689' OR `items`.`item_id` = '8190'
1054, Unknown column 'characters.charId' in 'on clause'
такое в общей но такое не всегда выскакивает
Ошибка запроса (95.169.186.19, eqgs):
SELECT `clan_data`.`clan_id` AS `clan_id`, `clan_data`.`clan_name` AS `clan_name`, `clan_data`.`ally_id` AS `ally_id`, `clan_data`.`ally_name` AS `ally_name`, `clan_data`.`clan_level` AS `clan_level`, `clan_data`.`reputation_score` AS `reputation_score`, `clan_data`.`leader_id` AS `leader_id`, `characters`.`obj_Id` AS `charId`, `characters`.`account_name` AS `account_name`, `characters`.`clanid` AS `clanid`, `characters`.`lastAccess` AS `lastAccess`, `characters`.`accesslevel` AS `accessLevel`, `characters`.`char_name` AS `char_name`, `characters`.`online` AS `online`, `characters`.`level` AS `level`, `characters`.`sex` AS `sex`, `characters`.`pvpkills` AS `pvpkills`, `characters`.`pkkills` AS `pkkills`, `characters`.`onlinetime` AS `onlinetime`, `characters`.`base_class` AS `base_class`, `characters`.`exp` AS `exp`, `characters`.`sp` AS `sp`, `characters`.`race` AS `race`, `characters`.`karma` AS `karma`, `characters`.`maxHp` AS `maxHp`, `characters`.`maxMp` AS `maxMp`, `characters`.`x` AS `x`, `characters`.`y` AS `y`, `characters`.`z` AS `z`, `characters`.`nobless` AS `nobless`, `characters`.`title` AS `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 10
1054, Unknown column 'characters.charId' in 'on clause'
Такое у кланов
Unknown column 'characters.charId' - как бэ неизвестная колонка, мб статистика под другую структуру базы сделана!?)
Unknown column 'characters.charId' in 'on clause'
Открой в навикане таблицу characters и посмотри как пишется столбец где находится ид чара.
Скорее всего у тебя просто столбец называется objId или obj_Id, или char_Id.
Если стлбик называется не charId, то тебе придётся переписывать скрипт под свою сборку.
Жестокий запрос.
— Random Post Generator
Pikovit: собствено статистика выдаёт ошибки,
прмиеры ошибок
1054, Unknown column 'characters.charId' in 'on clause'
такое в общей но такое не всегда выскакивает
1054, Unknown column 'characters.charId' in 'on clause'
Такое у кланов
Вот это запросы...
Это не запросы а бред сивой кабылы...
В общем не проверял - проверь вот так:
`characters`.`clanid`, `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`.`race`,
`characters`.`karma`, `characters`.`maxHp`,
`characters`.`maxMp`, `characters`.`x`,
`characters`.`y`, `characters`.`z`,
`characters`.`nobless`, `characters`.`title`,
`items`.`item_id`
FROM `items` LEFT JOIN `characters` ON `characters`.`obj_Id` = `items`.`owner_id`
WHERE `items`.`item_id` = '8689' OR `items`.`item_id` = '8190'
`clan_data`.`ally_id`, `clan_data`.`ally_name`,
`clan_data`.`clan_level`, `clan_data`.`reputation_score`,
`clan_data`.`leader_id`, `characters`.`obj_Id`,
`characters`.`account_name`, `characters`.`clanid`,
`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`.`race`,
`characters`.`karma`, `characters`.`maxHp`,
`characters`.`maxMp`, `characters`.`x`,
`characters`.`y`, `characters`.`z`,
`characters`.`nobless`, `characters`.`title`,
csum, ccount, cavg
FROM clan_data LEFT JOIN characters ON clan_data.leader_id = characters.obj_Id
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 10
И там где выводится результат исправь charId на obj_Id.
Совершенно не понял задумку автора этих запросов, но чувствую он сильный любитель танцев с бубном.
Или я может что не понимаю?
На Форуме я тоже Radar!
Я везде Radar!