[help]l2archid Interlude и Hellevil Mode (dle)
7 ответов159 просмотровСейчас просматривают: 1
· 08.02.2009, 18:23
Здравствуйте уважаемые юзеры.
Я использую l2archid interlude 378 ревизию.
и использую DLE, 7.0 FINAL , + hellevil Mode.
Кто поможет переделать запросы регистрации акков и тд.. показывает только онлайн...
0
· 08.02.2009, 23:15
Какие ошибки выводит в Админке ?
*Именно SQL ошибки ...
Главная ошибка одится в полуметре от монитора...
0
· 09.02.2009, 13:26
---------ТАБЛИЦА АККАУНТ-------------
SELECT accounts.login, accounts.password, accounts.lastactive AS lastActive, accounts.accessLevel, accounts.lastIP, accounts.email, accounts.answer, accounts.question, accounts.hash
FROM `accounts`
ORDER BY `accessLevel` DESC , login ASC
LIMIT 0, 100
1054, Unknown column 'accounts.accessLevel' in 'field list'
<script type='text/javascript'>
mytagid = Math.floor( Math.random() * 100 );
document.write("
document.close();
SELECT accounts.login, accounts.password, accounts.lastactive AS lastActive, accounts.accessLevel, accounts.lastIP, accounts.email, accounts.answer, accounts.question, accounts.hash
FROM `accounts`
ORDER BY `accessLevel` DESC , login ASC
LIMIT 0, 100
1054, Unknown column 'accounts.accessLevel' in 'field list'
<script type='text/javascript'>
mytagid = Math.floor( Math.random() * 100 );
document.write("
» Нажмите, чтобы показать текст - нажмите опять, чтобы скрыть... «
-----ТАБЛИЦА ЧАРОВ-----
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
скрыть
");
-----ТАБЛИЦА ЧАРОВ-----
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
скрыть
document.close();
0
· 09.02.2009, 16:49
Так, начнёмс:
1. У тебя нету некоторых столбцов в таблице БД.
* Или же они есть, но по дрогому называются :)
Рассмотрим первую ошибочку:
Код
Трали-вали...*****
FROM `accounts`
ORDER BY `accessLevel` DESC , login ASC
LIMIT 0, 100
1054, Unknown column 'accounts.accessLevel' in 'field list'
FROM `accounts`
ORDER BY `accessLevel` DESC , login ASC
LIMIT 0, 100
1054, Unknown column 'accounts.accessLevel' in 'field list'
Обратим внимание на:
Код
1054, Unknown column 'accounts.accessLevel' in 'field list'
Означает, что в таблице 'accounts' нету столбца 'accessLevel', тем самым неоткуда получить информацию... *Тоже самое что ты заказал стакан воды, а тебе говорят: Извиняй, воды у нас нету... И с последующим заказом, тебе будут говорить тоже самое :)
Постапаем следующим образом:
Пишем запрос для этой ошибки
Код
ALTER TABLE `accounts` ADD `accessLevel` VARCHAR( 50 ) NULL;
Мы создали подходящие условия для того, чтобы "брались" от-туда данные.
** И так с каждой ошибкой сделай (всего вроде должно быть 4 ошибки) :)
PS: Это как один из вариантов выхода из такой ситуации. Можно сразу поменять установочный файл под твою сборку (чтобы потом не мучаться с запросами и доделками)
В общем наслаждаемся тем что есть или же ищем альтернативы.
Главная ошибка одится в полуметре от монитора...
0
· 09.02.2009, 17:39
может у него не accessLevel а access_Level, либо просто access
WebDeveloper сервера DARKWORLD
0
· 09.02.2009, 18:06
Вот это уже другой вариант :D
А вроде я ему в ICQ отписал что нужно сделать....
Главная ошибка одится в полуметре от монитора...
0
· 10.02.2009, 08:10
а где эти запросы найти???
0
Тема закрыта для ответов