L2jFrozen и StressWeb 11

halaymoon · 25.12.2012, 21:15

Установил SW 11, все ок. Начал соединять с базой - начались проблемы. Пробовал выбирать разные сборки, потом уже плюнул и нашел в нэте патч именно под фрозен, вернее 2 разных патча:

Код:

<?php
if (!defined("STRESSWEB")) die ("Доступ к данной странице запрещен!");
$sName = "L2Frozen";
$qList[$sName] = array (

	"fields" => array(
		"accessLevel"=>"access_level",
		"charID"=>"obj_Id",
		),
	
	"itemType" => array (
		0	=> "dress",
		1	=> "leftearring",
		2	=> "rightearring",
		4	=> "necklace",
		5	=> "leftring",
		6	=> "rightring",
		8	=> "helmet",
		9	=> "weapon",
		10	=> "shield",
		11	=> "gloves",
		12	=> "top",
		13	=> "lower",
		14	=> "bots",
		21	=> "righthair",
		22	=> "braslet",
		23	=> "ring",
		30	=> "cloak",
		7	=> "weapon",
		15	=> "righthair",
		16	=> "weapon",
		17	=> "lefthair",
		18	=> "lefthair",
		),

	"insAccount" => "
		INSERT INTO `accounts` (`login`,`password`,`access_level`,`l2question`,`l2answer`,`l2email`) 
		VALUES ('{login}','{pass}','0','{l2question}','{l2answer}','{l2email}')",
	
	"insItem" => "
			INSERT INTO `items` (`owner_id`,`object_id`,`item_id`,`count`,`loc`,`loc_data`) 
			VALUES ('{ownerID}', '{objectID}', '{itemID}', '{count}', 'INVENTORY', '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 
		WHERE race='0' AND accesslevel='0'",
	
	"getCountElf" => "
		SELECT count(0) 
		FROM characters 
		WHERE race='1' AND accesslevel='0'",
	
	"getCountDElf" => "
		SELECT count(0) 
		FROM characters 
		WHERE race='2' AND accesslevel='0'",
	
	"getCountOrc" => "
		SELECT count(0) 
		FROM characters 
		WHERE race='3' AND accesslevel='0'",
	
	"getCountDwarf" => "
		SELECT count(0) 
		FROM characters 
		WHERE race='4' AND accesslevel='0'",
	
	"getCountKamael" => "
		SELECT count(0) 
		FROM characters 
		WHERE race='5' AND 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,lastactive,access_level AS accessLevel,lastIP 
		FROM `accounts` 
		WHERE `login`='{login}' {where} 
		LIMIT 1",
		
	"getAccounts" => "
		SELECT login,lastactive,access_level,lastIP 
		FROM `accounts` {where}
		ORDER BY {order} 
		LIMIT {limit}",
		
	"getCharactersList" => "
		SELECT characters.account_name, characters.obj_Id, characters.char_name, characters.level, characters.accesslevel, characters.lastAccess, char_templates.ClassName 
		FROM `characters` 
		LEFT JOIN `char_templates` ON characters.base_class = char_templates.ClassId 
		ORDER BY characters.char_name 
		LIMIT {limit}",
	
	"getCharacter" => "
		SELECT characters.account_name, characters.char_name, characters.level, characters.sex, characters.base_class, characters.online, characters.exp, characters.sp, characters.karma, characters.pvpkills, characters.pkkills, characters.accesslevel, characters.onlinetime, characters.lastAccess, char_templates.ClassName, clan_data.clan_name 
		FROM `characters` 
		LEFT JOIN `char_templates` ON characters.base_class = char_templates.ClassId 
		LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id 
		WHERE characters.obj_Id='{charID}'",
		
	"getCharacterInfo" => "
		SELECT characters.account_name, characters.char_name, characters.level, characters.maxHp, characters.maxCp, characters.maxMp, characters.sex, characters.exp, characters.sp, characters.pvpkills, characters.pkkills, characters.karma, characters.race, characters.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 `char_templates` ON characters.base_class = char_templates.ClassId 
		WHERE characters.obj_Id='{charID}'",
		
	"getAccountCharacters" => "
		SELECT characters.account_name, characters.obj_Id AS charID, characters.char_name, characters.level, characters.accesslevel, characters.lastAccess, characters.online, characters.onlinetime, characters.punish_level AS in_jail, char_templates.ClassName, clan_data.clan_name 
		FROM `characters` 
		LEFT JOIN `char_templates` ON characters.base_class = char_templates.ClassId
		LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id
		WHERE characters.account_name='{account}' 
		ORDER BY characters.char_name",
	
	"getTopClan"=>"
		SELECT clan_data.clan_name, clan_data.clan_id, clan_data.ally_name, clan_data.clan_level, clan_data.reputation_score, clan_data.hasCastle, characters.char_name, ccount 
		FROM `clan_data` 
		LEFT JOIN `characters` ON characters.obj_Id = clan_data.leader_id 
		LEFT JOIN (
			SELECT clanid, count(level) AS ccount 
			FROM characters 
			WHERE clanid GROUP BY clanid
			) AS levels ON clan_data.clan_id = levels.clanid 
		ORDER BY clan_data.clan_level DESC, clan_data.reputation_score DESC 
		LIMIT {limit}",
	
	"getTop" => "
		SELECT characters.char_name, characters.level, characters.sex, characters.pvpkills, characters.pkkills, characters.online, characters.onlinetime, char_templates.ClassName, clan_data.clan_name, clan_data.clan_id 
		FROM `characters` 
		LEFT JOIN `char_templates` ON characters.classid = char_templates.ClassId 
		LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id 
		WHERE characters.accesslevel='0'
		ORDER BY characters.{order} DESC 
		LIMIT {limit}",
		
	"getClanCharacters" => "
		SELECT characters.char_name, characters.level, characters.sex, characters.pvpkills, characters.pkkills, characters.online, characters.onlinetime, char_templates.ClassName, clan_data.clan_name, clan_data.clan_id 
		FROM `characters` 
		LEFT JOIN `char_templates` ON characters.classid = char_templates.ClassId 
		LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id 
		WHERE characters.clanid='{clanid}'
		ORDER BY characters.level DESC",
	
	"getOnline" => "
		SELECT characters.char_name, characters.level, characters.sex, characters.pvpkills, characters.pkkills, characters.online, characters.onlinetime, char_templates.ClassName, clan_data.clan_name, clan_data.clan_id 
		FROM `characters` 
		LEFT JOIN `char_templates` ON characters.classid = char_templates.ClassId 
		LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id 
		WHERE characters.accesslevel='0' AND characters.online='1'
		ORDER BY characters.level DESC, characters.onlinetime DESC",
	
	"getEpicStatus" => "
		SELECT grandboss_data.respawn_time, npc.name, npc.level 
		FROM grandboss_data 
		LEFT JOIN npc ON grandboss_data.boss_id = npc.id 
		ORDER BY npc.level DESC",
	
	"getRaidStatus" => "
		SELECT raidboss_spawnlist.respawn_time, npc.level, npc.name
		FROM raidboss_spawnlist
		LEFT JOIN npc ON raidboss_spawnlist.boss_id = npc.id
		ORDER BY npc.level DESC, npc.name ASC",
		
	"getClan" => "
		SELECT clan_name
		FROM clan_data
		WHERE clan_id='{clanid}'",
		
	"getCastles" => "
		SELECT castle.name, castle.id, castle.taxPercent, castle.siegeDate, clan_data.clan_name, clan_data.clan_id
		FROM castle
		LEFT JOIN clan_data ON clan_data.hasCastle = castle.id",
	
	"getSiege" => "
		SELECT siege_clans.castle_id, siege_clans.clan_id, siege_clans.type, siege_clans.castle_owner, clan_data.clan_name
		FROM siege_clans
		LEFT JOIN clan_data ON clan_data.clan_id = siege_clans.clan_id
		WHERE castle_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`,`punish_level`,`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(
		
		"getVotersList" => "
			SELECT count(nick) AS votes,nick
			FROM `l2top`
			WHERE SUBSTR(date,6,2)='{time}'
			GROUP BY `nick`
			ORDER BY votes DESC, date DESC
			LIMIT {limit}",
		
		"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`,`loc`,`loc_data`) 
			VALUES ('{charID}', '{objectID}', '{itemID}', '{count}', 'INVENTORY', '0')",
		
		"insl2top" => "
			INSERT INTO `l2top` (`nick`,`ip`,`time`) 
			VALUES ('{nick}','{ip}','{time}')",
		
		"setItem" => "
			UPDATE `items` 
			SET `count`='{count}' 
			WHERE `owner_id`='{ownerID}' AND `item_id`='{itemID}' AND `loc`='INVENTORY'",
		),
		
);
?>

2.

Код:

<?php
/**
 * STRESS WEB
 * @author S.T.R.E.S.S.
 * @copyright 2008 - 2011 STRESS WEB
 * @version 12
 * @web http://stressweb.ru
*/
if (!defined("STRESSWEB")) die ("Access denied...");
$sName = "L2jFrozen";
$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",
		13	=> "lower",
		14	=> "weapon",
		15	=> "righthair",
		16	=> "righthair",
		17	=> "lefthair",
		18	=> "lefthair",
		20	=> "righthair",
		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`) 
			VALUES ('{ownerID}', '{objectID}', '{itemID}', '{count}', '{enchant}', 'INVENTORY', '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 
		WHERE race='0' AND accesslevel='0'",
	
	"getCountElf" => "
		SELECT count(0) 
		FROM characters 
		WHERE race='1' AND accesslevel='0'",
	
	"getCountDElf" => "
		SELECT count(0) 
		FROM characters 
		WHERE race='2' AND accesslevel='0'",
	
	"getCountOrc" => "
		SELECT count(0) 
		FROM characters 
		WHERE race='3' AND accesslevel='0'",
	
	"getCountDwarf" => "
		SELECT count(0) 
		FROM characters 
		WHERE race='4' AND accesslevel='0'",
	
	"getCountKamael" => "
		SELECT count(0) 
		FROM characters 
		WHERE race='5' AND 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,lastactive,access_level AS accessLevel,lastIP 
		FROM `accounts` 
		WHERE `login`='{login}' {where} 
		LIMIT 1",
		
	"getAccounts" => "
		SELECT login,lastactive,access_level,lastIP 
		FROM `accounts` {where}
		ORDER BY {order} 
		LIMIT {limit}",
		
	"getCharactersList" => "
		SELECT characters.account_name, characters.obj_Id, characters.char_name, characters.level, characters.accesslevel, characters.lastAccess, char_templates.ClassName 
		FROM `characters` 
		LEFT JOIN `char_templates` ON characters.base_class = char_templates.ClassId {where} 
		ORDER BY characters.char_name 
		LIMIT {limit}",
	
	"getCharacter" => "
		SELECT characters.account_name, characters.char_name, characters.level, characters.sex, characters.base_class, characters.online, characters.exp, characters.sp, characters.karma, characters.pvpkills, characters.pkkills, characters.accesslevel, characters.onlinetime, characters.lastAccess, char_templates.ClassName, clan_data.clan_name 
		FROM `characters` 
		LEFT JOIN `char_templates` ON characters.base_class = char_templates.ClassId 
		LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id 
		WHERE characters.obj_Id='{charID}'",
		
	"getCharacterInfo" => "
		SELECT characters.account_name, characters.char_name, characters.level, characters.maxHp, characters.maxCp, characters.maxMp, characters.sex, characters.exp, characters.sp, characters.pvpkills, characters.pkkills, characters.karma, characters.race, characters.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 `char_templates` ON characters.base_class = char_templates.ClassId 
		WHERE characters.obj_Id='{charID}'",
		
	"getAccountCharacters" => "
		SELECT characters.account_name, characters.obj_Id AS charID, characters.char_name, characters.level, characters.accesslevel, characters.lastAccess, characters.online, characters.onlinetime, char_templates.ClassName, clan_data.clan_name 
		FROM `characters` 
		LEFT JOIN `char_templates` ON characters.base_class = char_templates.ClassId
		LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id
		WHERE characters.account_name='{account}' 
		ORDER BY characters.char_name",
	
	"getTopClan"=>"
		SELECT clan_data.clan_name, clan_data.clan_id, clan_data.ally_name, clan_data.clan_level, clan_data.reputation_score, clan_data.hasCastle, characters.char_name, ccount 
		FROM `clan_data` 
		LEFT JOIN `characters` ON characters.obj_Id = clan_data.leader_id 
		LEFT JOIN (
			SELECT clanid, count(level) AS ccount 
			FROM characters 
			WHERE clanid GROUP BY clanid
			) AS levels ON clan_data.clan_id = levels.clanid 
		ORDER BY clan_data.clan_level DESC, clan_data.reputation_score DESC 
		LIMIT {limit}",
	
	"getTop" => "
		SELECT characters.char_name, characters.level, characters.sex, characters.pvpkills, characters.pkkills, characters.online, characters.onlinetime, char_templates.ClassName, clan_data.clan_name, clan_data.clan_id 
		FROM `characters` 
		LEFT JOIN `char_templates` ON characters.classid = char_templates.ClassId 
		LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id 
		WHERE characters.accesslevel='0'
		ORDER BY characters.{order} DESC 
		LIMIT {limit}",
		
	"getRich" => "
		SELECT characters.char_name, characters.level, characters.sex, characters.online, characters.onlinetime, char_templates.ClassName, clan_data.clan_name, clan_data.clan_id, count 
		FROM `characters` 
		LEFT JOIN `char_templates` ON characters.classid = char_templates.ClassId 
		LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id
		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, characters.level, characters.sex, characters.pvpkills, characters.pkkills, characters.online, characters.onlinetime, char_templates.ClassName, clan_data.clan_name, clan_data.clan_id 
		FROM `characters` 
		LEFT JOIN `char_templates` ON characters.classid = char_templates.ClassId 
		LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id 
		WHERE characters.clanid='{clanid}'
		ORDER BY characters.level DESC",
	
	"getOnline" => "
		SELECT characters.char_name, characters.level, characters.sex, characters.pvpkills, characters.pkkills, characters.online, characters.onlinetime, char_templates.ClassName, clan_data.clan_name, clan_data.clan_id 
		FROM `characters` 
		LEFT JOIN `char_templates` ON characters.classid = char_templates.ClassId 
		LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id 
		WHERE characters.accesslevel='0' AND characters.online='1'
		ORDER BY characters.level DESC, characters.onlinetime DESC",
	
	"getEpicStatus" => "
		SELECT grandboss_data.respawn_time, npc.name, npc.level 
		FROM grandboss_data 
		LEFT JOIN npc ON grandboss_data.boss_id = npc.id 
		ORDER BY npc.level DESC",
	
	"getRaidStatus" => "
		SELECT raidboss_spawnlist.respawn_time, npc.level, npc.name
		FROM raidboss_spawnlist
		LEFT JOIN npc ON raidboss_spawnlist.boss_id = npc.id
		ORDER BY npc.level DESC, npc.name ASC",
		
	"getClan" => "
		SELECT clan_name
		FROM clan_data
		WHERE clan_id='{clanid}'",
		
	"getCastles" => "
		SELECT castle.name, castle.id, castle.taxPercent, castle.siegeDate, clan_data.clan_name, clan_data.clan_id
		FROM castle
		LEFT JOIN clan_data ON clan_data.hasCastle = castle.id",
	
	"getSiege" => "
		SELECT siege_clans.castle_id, siege_clans.clan_id, siege_clans.type, siege_clans.castle_owner, clan_data.clan_name
		FROM siege_clans
		LEFT JOIN clan_data ON clan_data.clan_id = siege_clans.clan_id
		WHERE castle_id='{castle}'",
	
	"getOlympiad" => "
		SELECT olympiad_nobles.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`,`in_jail`,`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(
		
		"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`) 
			VALUES ('{charID}', '{objectID}', '{itemID}', '{count}', '0', 'INVENTORY', '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'",
		),
		
);
?>

или ссылками:

http://rghost.ru/42511585
http://rghost.ru/42511587

Ни тот ни другой не работает. Начал сравнивать строчки, вроде бы во втором варианте все норм. Но ничего всеравно не работает=( не могу понять в чем дело...

Сто раз проверял значения IP/портов, и всех параметров соединения с дб. Все нормально.

Пробовал включать MySQL сообщ. об ошибках, пишет во всех случаях:

Код:

MySQL Error:
MySQL Error Number:
0

Помогите разобраться пожалуйста.

***NotSpecified*** · 26.12.2012, 01:29

Обратитесь за решением вопроса туда, откуда скачали. Поддержка 11 релиза давно никто не ведет, да и 12 заканчивается. Ну а ошибка "0", давно уже большинству известна.

26.12.2012, 01:29	#2
*NotSpecified* Олдфаг Регистрация: 30.01.2011 Адрес: Europe Сообщений: 2,800 Отблагодарили 1,263 раз(а) Рейтинг мнений: 46	Re: L2jFrozen и StressWeb 11 Обратитесь за решением вопроса туда, откуда скачали. Поддержка 11 релиза давно никто не ведет, да и 12 заканчивается. Ну а ошибка "0", давно уже большинству известна.

Похожие темы
Тема	Автор	Раздел	Ответов	Последнее сообщение
Привязка StressWeb 12	spartana	Lineage II	4	13.11.2012 19:04
Проблемы с донатом stressweb 11	grisha99	Движки сайтов (CMS)	1	26.05.2011 07:58
Настройка и доработка функционала сайта на StressWeb	HiDegger	Рынок / Marketplace	5	14.05.2011 18:58
Взлом StressWeb 7.0 Nulled	m095	Движки сайтов (CMS)	0	28.11.2009 04:12

Здесь присутствуют: 1 (пользователей: 0 , гостей: 1)