NexTDZ 0 Опубликовано 22 декабря, 2014 (изменено) Проблемы с SW 11 c EmuRT HF5 .r.9 Здраствуйте вообщем, парился и так не решил проблему с: 1. Капча При неудачной авторизации, пишет что есть 3 попытки и типо вы 1 раз ошиблись, и так хоть до бесконечности. Т.е он не считает неудачные авторизации и не банит на время. 2. Статистика Кланов Эпик РБ РБ Замки - появляются, но правдивость не проверял 3. Выдача предметов через админцентер или л2топ сервис и тд. Если предмет есть у персонажа, то добавить можно (Админцентр), если предмета не было у персонажа еще, то "Ошибка базы данных" l2j_EmuRt.php - First Team и тд. <?php /** * STRESS WEB * @author S.T.R.E.S.S. * @copyright 2008 - 2011 STRESS WEB * @version 11 * @web http://stressweb.ru */ if (!defined("STRESSWEB")) die ("Access denied..."); $sName = "EmuRt"; $qList[$sName] = array ( "fields" => array( "accessLevel"=>"access_level", "charID"=>"obj_Id", ), "itemType" => array ( 0 => "dress", 1 => "leftearring", 2 => "rightearring", 3 => "necklace", 4 => "leftring", 5 => "rightring", 6 => "helmet", 7 => "weapon", 8 => "shield", 9 => "gloves", 10 => "top", 11 => "lower", 12 => "bots", 14 => "leftring", // 15 => "rightring", 16 => "lefthair", 17 => "braslet", 25 => "ring", // 22 => "braslet", ), "insAccount" => " INSERT INTO `accounts` (`login`,`password`,`access_level`,`l2email`) VALUES ('{login}','{pass}','0','{l2email}')", "insItem" => " INSERT INTO `items` (`owner_id`,`object_id`,`item_id`,`count`,`enchant_level`,`loc`,`loc_data`, `life_time`, `augmentation_id`, `attribute_fire` , `attribute_water`, `attribute_wind`, `attribute_earth`, `attribute_holy`, `attribute_unholy`, `custom_type1`, `custom_type2`, `custom_flags`, `agathion_energy`, `visualId`) VALUES ('{ownerID}', '{objectID}', '{itemID}', '{count}', '{enchant}', 'INVENTORY', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0')", "setPassword" => " UPDATE `accounts` SET `password`='{pass}' WHERE `login`='{login}'", "setAccessLevelAccount" => " UPDATE `accounts` SET `access_level`='{level}' WHERE `login`='{login}'", "setAccessLevelCharacter" => " UPDATE `characters` SET `accesslevel`='{level}' WHERE `obj_Id`='{charID}'", "setTeleport" => " UPDATE `characters` SET `x`='{x}',`y`='{y}',`z`='{z}',`lastteleport`='{lastteleport}' WHERE `obj_Id`='{charID}'", "setItem" => " UPDATE `items` SET `count`='{count}', `enchant_level`='{enchant}' WHERE `object_id`='{objectID}'", "setItemCount" => " UPDATE `items` SET `count` = '{count}' WHERE `owner_id` = '{ownerID}' AND `object_id` = '{objectID}'", "getCountAccounts" => " SELECT count(0) FROM accounts {where}", "getCountCharacters" => " SELECT count(0) FROM characters {where}", "getCountClans" => " SELECT count(0) FROM clan_data", "getCountHuman" => " SELECT count(0) FROM characters LEFT JOIN character_subclasses ON character_subclasses.char_obj_id = characters.obj_Id AND character_subclasses.isBase='1' LEFT JOIN char_templates ON character_subclasses.class_id = char_templates.ClassId WHERE char_templates.RaceId='0' AND characters.accesslevel='0'", "getCountElf" => " SELECT count(0) FROM characters LEFT JOIN character_subclasses ON character_subclasses.char_obj_id = characters.obj_Id AND character_subclasses.isBase='1' LEFT JOIN char_templates ON character_subclasses.class_id = char_templates.ClassId WHERE char_templates.RaceId='1' AND characters.accesslevel='0'", "getCountDElf" => " SELECT count(0) FROM characters LEFT JOIN character_subclasses ON character_subclasses.char_obj_id = characters.obj_Id AND character_subclasses.isBase='1' LEFT JOIN char_templates ON character_subclasses.class_id = char_templates.ClassId WHERE char_templates.RaceId='2' AND characters.accesslevel='0'", "getCountOrc" => " SELECT count(0) FROM characters LEFT JOIN character_subclasses ON character_subclasses.char_obj_id = characters.obj_Id AND character_subclasses.isBase='1' LEFT JOIN char_templates ON character_subclasses.class_id = char_templates.ClassId WHERE char_templates.RaceId='3' AND characters.accesslevel='0'", "getCountDwarf" => " SELECT count(0) FROM characters LEFT JOIN character_subclasses ON character_subclasses.char_obj_id = characters.obj_Id AND character_subclasses.isBase='1' LEFT JOIN char_templates ON character_subclasses.class_id = char_templates.ClassId WHERE char_templates.RaceId='4' AND characters.accesslevel='0'", "getCountKamael" => " SELECT count(0) FROM characters LEFT JOIN character_subclasses ON character_subclasses.char_obj_id = characters.obj_Id AND character_subclasses.isBase='1' LEFT JOIN char_templates ON character_subclasses.class_id = char_templates.ClassId WHERE char_templates.RaceId='5' AND characters.accesslevel='0'", "getCountDawn" => " SELECT count(0) FROM seven_signs WHERE cabal='dawn'", "getCountDusk" => " SELECT count(0) FROM seven_signs WHERE cabal='dusk'", "getAccount" => " SELECT login,password,last_access as lastactive,access_level AS accessLevel,last_ip as lastIP FROM `accounts` WHERE `login`='{login}' {where} LIMIT 1", "getAccounts" => " SELECT login,last_access as lastactive,access_level,last_ip as lastIP FROM `accounts` {where} ORDER BY {order} LIMIT {limit}", "getCharactersList" => " SELECT characters.account_name, characters.obj_Id, characters.char_name, character_subclasses.level, characters.accesslevel, characters.lastAccess, char_templates.ClassName FROM `characters` LEFT JOIN `character_subclasses` ON characters.obj_Id = character_subclasses.char_obj_id AND character_subclasses.isBase='1' LEFT JOIN `char_templates` ON character_subclasses.class_id = char_templates.ClassId {where} ORDER BY characters.char_name LIMIT {limit}", "getCharacter" => " SELECT characters.account_name, characters.char_name, character_subclasses.level, characters.sex, character_subclasses.class_id, characters.online, character_subclasses.exp, character_subclasses.sp, characters.karma, characters.pvpkills, characters.pkkills, characters.accesslevel, characters.onlinetime, characters.lastAccess, char_templates.ClassName, clan_subpledges.name as clan_name FROM `characters` LEFT JOIN `character_subclasses` ON characters.obj_Id = character_subclasses.char_obj_id AND character_subclasses.isBase='1' LEFT JOIN `char_templates` ON character_subclasses.class_id = char_templates.ClassId LEFT JOIN `clan_subpledges` ON characters.clanid = clan_subpledges.clan_id AND clan_subpledges.type='0' WHERE characters.obj_Id='{charID}'", "getCharacterInfo" => " SELECT characters.account_name, characters.char_name, character_subclasses.level, character_subclasses.maxHp, character_subclasses.maxCp, character_subclasses.maxMp, characters.sex, character_subclasses.exp, character_subclasses.sp, characters.pvpkills, characters.pkkills, characters.karma, char_templates.RaceId AS race, character_subclasses.class_id AS base_class, characters.accesslevel, characters.lastAccess, char_templates.ClassName, char_templates.STR, char_templates.CON, char_templates.DEX, char_templates._INT, char_templates.WIT, char_templates.MEN FROM `characters` LEFT JOIN `character_subclasses` ON characters.obj_Id = character_subclasses.char_obj_id LEFT JOIN `char_templates` ON character_subclasses.class_id = char_templates.ClassId WHERE characters.obj_Id='{charID}'", "getAccountCharacters" => " SELECT characters.account_name, characters.obj_Id AS charID, characters.char_name, character_subclasses.level, characters.accesslevel, characters.lastAccess, characters.online, characters.onlinetime, char_templates.ClassName, clan_subpledges.name as clan_name FROM `characters` LEFT JOIN `character_subclasses` ON characters.obj_Id = character_subclasses.char_obj_id AND character_subclasses.isBase='1' LEFT JOIN `char_templates` ON character_subclasses.class_id = char_templates.ClassId LEFT JOIN `clan_subpledges` ON characters.clanid = clan_subpledges.clan_id AND clan_subpledges.type='0' WHERE characters.account_name='{account}' ORDER BY characters.char_name", "getTopClan" => " SELECT clan_subpledges.name as clan_name, clan_data.clan_id, ally_data.ally_name, clan_data.clan_level, clan_data.reputation_score, clan_data.hasCastle, characters.char_name, ccount FROM `clan_data` LEFT JOIN `clan_subpledges` ON clan_data.clan_id = clan_subpledges.clan_id AND clan_subpledges.type='0' LEFT JOIN `characters` ON characters.obj_Id = clan_subpledges.leader_id LEFT JOIN ( SELECT clanid, count(0) AS ccount FROM characters WHERE clanid GROUP BY clanid ) AS levels ON clan_data.clan_id = levels.clanid LEFT JOIN `ally_data` ON clan_data.ally_id = ally_data.ally_id ORDER BY clan_data.clan_level DESC, clan_data.reputation_score DESC LIMIT {limit}", "getTop" => " SELECT characters.char_name, character_subclasses.level, characters.sex, characters.pvpkills, characters.pkkills, characters.online, characters.onlinetime, char_templates.ClassName, clan_subpledges.name as clan_name, clan_subpledges.clan_id FROM `characters` LEFT JOIN `character_subclasses` ON characters.obj_Id = character_subclasses.char_obj_id AND character_subclasses.isBase='1' LEFT JOIN `char_templates` ON character_subclasses.class_id = char_templates.ClassId LEFT JOIN `clan_subpledges` ON characters.clanid = clan_subpledges.clan_id AND clan_subpledges.type='0' WHERE characters.accesslevel='0' ORDER BY {order} DESC LIMIT {limit}", "getRich" => " SELECT characters.char_name, character_subclasses.level, characters.sex, characters.online, characters.onlinetime, char_templates.ClassName, clan_subpledges.name as clan_name, clan_subpledges.clan_id, count FROM `characters` LEFT JOIN `character_subclasses` ON characters.obj_Id = character_subclasses.char_obj_id AND character_subclasses.isBase='1' LEFT JOIN `char_templates` ON character_subclasses.class_id = char_templates.ClassId LEFT JOIN `clan_subpledges` ON characters.clanid = clan_subpledges.clan_id AND clan_subpledges.type='0' LEFT JOIN (SELECT owner_id,SUM(count) AS count FROM items WHERE items.item_id=57 GROUP BY owner_id) AS count ON characters.obj_Id=count.owner_id WHERE characters.accesslevel='0' ORDER BY count DESC, level DESC, onlinetime DESC LIMIT {limit}", "getClanCharacters" => " SELECT characters.char_name, character_subclasses.level, characters.sex, characters.pvpkills, characters.pkkills, characters.online, characters.onlinetime, char_templates.ClassName, clan_subpledges.name as clan_name, clan_subpledges.clan_id FROM `characters` LEFT JOIN `character_subclasses` ON characters.obj_Id = character_subclasses.char_obj_id AND character_subclasses.isBase='1' LEFT JOIN `char_templates` ON character_subclasses.class_id = char_templates.ClassId LEFT JOIN `clan_subpledges` ON characters.clanid = clan_subpledges.clan_id AND clan_subpledges.type='0' WHERE characters.clanid='{clanid}' ORDER BY character_subclasses.level DESC", "getOnline" => " SELECT characters.char_name, character_subclasses.level, characters.sex, characters.pvpkills, characters.pkkills, characters.online, characters.onlinetime, char_templates.ClassName, clan_subpledges.name as clan_name, clan_subpledges.clan_id FROM `characters` LEFT JOIN `character_subclasses` ON characters.obj_Id = character_subclasses.char_obj_id AND character_subclasses.isBase='1' LEFT JOIN `char_templates` ON character_subclasses.class_id = char_templates.ClassId LEFT JOIN `clan_subpledges` ON characters.clanid = clan_subpledges.clan_id AND clan_subpledges.type='0' WHERE characters.accesslevel='0' AND characters.online='1' ORDER BY character_subclasses.level DESC, characters.onlinetime DESC", "getEpicStatus" => " SELECT epic_boss_spawn.respawnDate AS respawn_time, npc.name, npc.level FROM epic_boss_spawn LEFT JOIN npc ON epic_boss_spawn.bossId = npc.id ORDER BY npc.level DESC", "getRaidStatus" => " SELECT raidboss_status.respawn_delay AS respawn_time, npc.level, npc.name FROM raidboss_status LEFT JOIN npc ON raidboss_status.id = npc.id ORDER BY npc.level DESC, npc.name ASC", "getClan" => " SELECT clan_subpledges.name as clan_name FROM clan_subpledges WHERE clan_id='{clanid}'", "getCastles" => " SELECT castle.name, castle.id, castle.tax_percent as taxPercent, castle.siege_date as siegeDate, clan_subpledges.name as clan_name, clan_data.clan_id FROM castle LEFT JOIN clan_data ON clan_data.hasCastle = castle.id LEFT JOIN clan_subpledges ON clan_subpledges.clan_id = clan_data.clan_id AND type='0'", "getSiege" => " SELECT siege_clans.residence_id as castle_id, siege_clans.clan_id, siege_clans.type, clan_subpledges.name as clan_name FROM siege_clans LEFT JOIN clan_data ON clan_data.clan_id = siege_clans.clan_id LEFT JOIN clan_subpledges ON clan_subpledges.clan_id = clan_data.clan_id AND clan_subpledges.type='0' WHERE residence_id='{castle}'", "getOlympiad" => " SELECT characters.char_name, olympiad_nobles.olympiad_points, olympiad_nobles.competitions_done, char_templates.ClassName, characters.sex FROM olympiad_nobles LEFT JOIN char_templates ON olympiad_nobles.class_id = char_templates.ClassId LEFT JOIN characters ON olympiad_nobles.char_id = characters.obj_Id ORDER BY olympiad_nobles.class_id, olympiad_nobles.olympiad_points DESC", "getInventory" => " SELECT items.object_id,items.item_id,items.count,items.enchant_level,items.loc, CASE WHEN armor.name != '' THEN armor.name WHEN weapon.name != '' THEN weapon.name WHEN etcitem.name != '' THEN etcitem.name END AS name, CASE WHEN armor.crystal_type != '' THEN 'armor' WHEN weapon.crystal_type != '' THEN 'weapon' WHEN etcitem.crystal_type != '' THEN 'etc' END AS `type` FROM `items` LEFT JOIN `armor` ON armor.item_id = items.item_id LEFT JOIN weapon ON weapon.item_id = items .item_id LEFT JOIN etcitem ON etcitem.item_id = items.item_id WHERE items.owner_id='{charID}' ORDER BY {order}", "getCharInventory" => " SELECT items.object_id,items.item_id,items.count,items.enchant_level,items.loc,items.loc_data,armorName,weaponName,etcName,armorType,weaponType,etcType FROM `items` LEFT JOIN ( SELECT item_id, name AS armorName, crystal_type AS armorType FROM `armor` ) AS aa ON aa.item_id = items.item_id LEFT JOIN ( SELECT item_id, name AS weaponName, crystal_type AS weaponType FROM `weapon` ) AS ww ON ww.item_id = items.item_id LEFT JOIN ( SELECT item_id, name AS etcName, crystal_type AS etcType FROM `etcitem` ) AS ee ON ee.item_id = items.item_id WHERE items.owner_id='{charID}' AND items.loc='{loc}' ORDER BY items.loc_data", "getItemByObjectID" => " SELECT `count`, `enchant_level`, `item_id` FROM `items` WHERE `object_id`='{objectID}'", "getLastTeleport" => " SELECT `char_name`,`online`,`accesslevel`,`lastteleport` FROM `characters` WHERE `obj_Id`='{charID}'", "getItem" => " SELECT `object_id`, `count` FROM `items` WHERE `owner_id` = '{charID}' AND `item_id` = '{itemID}' AND `loc` = 'INVENTORY' LIMIT 1", "getMax" => " SELECT MAX(`object_id`)+1 AS `max` FROM `items`", "delAccounts" => " DELETE FROM accounts WHERE login='{login}'", "delItemByID" => " DELETE FROM `items` WHERE `item_id`='{item}'", "delCharByID" => " DELETE FROM `characters` WHERE `obj_Id`='{charID}'", "delItemByOwner" => " DELETE FROM `items` WHERE `owner_id`='{charID}'", "delItemByObjectID" => " DELETE FROM `items` WHERE `object_id`='{objectID}'", "delItemByIDOwner" => " DELETE FROM `items` WHERE `item_id`='{item}' AND `owner_id`='{charID}'", "other" => array( "DELETE FROM character_friends WHERE char_id='{charID}' OR friend_id='{charID}'", "DELETE FROM character_hennas WHERE char_obj_id='{charID}'", "DELETE FROM character_macroses WHERE char_obj_id='{charID}'", "DELETE FROM character_quests WHERE char_id='{charID}'", "DELETE FROM character_recipebook WHERE char_id='{charID}'", "DELETE FROM character_shortcuts WHERE char_obj_id='{charID}'", "DELETE FROM character_skills WHERE char_obj_id='{charID}'", "DELETE FROM character_skills_save WHERE char_obj_id='{charID}'", "DELETE FROM character_subclasses WHERE char_obj_id='{charID}'", "DELETE FROM seven_signs WHERE char_obj_id='{charID}'", "DELETE FROM items WHERE owner_id='{charID}'", "DELETE FROM clan_data WHERE leader_id='{charID}'", ), "l2top" => array( "getName" => " SELECT * FROM `l2top` WHERE `nick`='{nick}' AND `time`='{time}'", "getChar" => " SELECT account_name, obj_Id AS charID, online FROM `characters` WHERE `char_name`='{name}'", "getItem" => " SELECT `item_id`,`count` FROM `items` WHERE `owner_id`='{ownerID}' AND `item_id`='{itemID}' AND `loc`='INVENTORY'", "getMax" => " SELECT MAX(`object_id`)+1 AS `max` FROM `items`", "insItem" => " INSERT INTO `items` (`owner_id`,`object_id`,`item_id`,`count`,`enchant_level`,`loc`,`loc_data`, `life_time`, `augmentation_id`, `attribute_fire` , `attribute_water`, `attribute_wind`, `attribute_earth`, `attribute_holy`, `attribute_unholy`, `custom_type1`, `custom_type2`, `custom_flags`, `agathion_energy`, `visualId`) VALUES ('{ownerID}', '{objectID}', '{itemID}', '{count}', '{enchant}', 'INVENTORY', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0')", "insl2top" => " INSERT INTO `l2top` (`nick`,`ip`,`time`) VALUES ('{nick}','{ip}','{time}')", "setItem" => " UPDATE `items` SET `count`=`count`+'{count}' WHERE `owner_id`='{ownerID}' AND `item_id`='{itemID}' AND `loc`='INVENTORY'", ), "getByLevel" => " SELECT characters.char_name FROM characters LEFT JOIN character_subclasses ON character_subclasses.char_obj_id = characters.obj_Id AND character_subclasses.isBase='1' WHERE characters.account_name='{account}' AND character_subclasses.level>={level} LIMIT 1", );?> Заранее спасибо за помощь. Изменено 22 декабря, 2014 пользователем NexTDZ Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
Fomik 17 Опубликовано 22 декабря, 2014 Под споллер бы еще засунуть, было бы вообще шик Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
Marchutan 71 Опубликовано 22 декабря, 2014 1. Капча При неудачной авторизации, пишет что есть 3 попытки и типо вы 1 раз ошиблись, и так хоть до бесконечности. Т.е он не считает неудачные авторизации и не банит на время. Если у тебя 11 null, у кого я не спрашивал она у всех не работает, я посоветую не пользуйся шарой до добра не доведет, лучше накопи денег и купи 13 у разрабов, если нету можешь у меня купить за 1к рублей отдам. Если то пиши в скайп. Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
NexTDZ 0 Опубликовано 22 декабря, 2014 1. Под споллер бы еще засунуть, было бы вообще шик Сразу не заметил, уже никак. 2. Приоритетно сделать выдачу предметов. Заранее благодарен. Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
NexTDZ 0 Опубликовано 23 декабря, 2014 Что никто не может помочь с выдачей предметов? Оо печалька. Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты