Web сайт

[Perfecto]

Превышено максимальное кол-во одновременных запросов.
Редактируется в my.ini строка:
max_connections

[[Red Dragon]]

my.ini где она находится

[Perfecto]

Это конфиг MySQL соответственно находится там, где у Вас MySQL.
И на всякий случай предоставьте код sql.inc.php

[[Red Dragon]]

sql.inc

<? if(!defined('Light_Engine')) {die("Hacking attempt!");}

# ========================================================================== #
# #
# Light_Engine | Модуль: Распределение запросов + подключение к БД #
# #
# ========================================================================== #

$db = mysql_connect($mysql['dbhost']locqalhost, $mysql['dbuser']12345, $mysql['dbpass']12345);
mysql_select_db ($mysql['dbname']l2jdb);
mysql_query("SET NAMES cp1251");

$queryList = array (

"auth" => "SELECT login,password FROM `accounts` WHERE login='{a}'",
"update" => "UPDATE accounts SET `password`='{a}' WHERE login='{b}'",

"register" => "INSERT INTO `accounts` (login, password, lastactive, accessLevel, lastIP, lastServer) VALUES ('{a}', '{b}', 0, '0', NULL, NULL)",
"registerCheck" => "SELECT * FROM `accounts` WHERE login = '{a}'",
"passwordCheck" => "SELECT password FROM `accounts` WHERE `password`='{a}'",

"online" => "SELECT count(`charid`) FROM characters WHERE online = '1' AND accesslevel = '0'",
"raceCount" => "SELECT count(`charid`) FROM `characters` WHERE `race` = '{a}'",
"sevenSigns" => "SELECT count(*) FROM `seven_signs` WHERE cabal like '%{a}%'",
"hellbound" => "SELECT `{a}` FROM `hellbound`",
"charactersCount" => "SELECT count(`{a}`) FROM `characters`",
"accountsCount" => "SELECT count(`{a}`) FROM `accounts`",
"clanDataCount" => "SELECT count(`{a}`) FROM `clan_data`",

"itemsNickAcc" => "SELECT char_name,(SELECT count FROM items WHERE item_id='{a}' AND owner_id=ch.charId and loc='INVENTORY') from characters AS ch WHERE account_name='{b}'",
"itemsSexTele" => "SELECT char_name,charId,sex,(SELECT count FROM items WHERE item_id='{a}' AND owner_id=ch.charId and loc='INVENTORY') FROM characters AS ch WHERE account_name='{b}'",
"itemsTeleport" => "SELECT char_name,level,(SELECT count FROM items WHERE item_id='{a}' AND owner_id=ch.charId and loc='INVENTORY'),charId,online FROM characters AS ch WHERE charId='{b}'",
"selectSex" => "SELECT char_name,sex,classid,base_class,charId FROM characters WHERE account_name='{a}'",
"selectDelevel" => "SELECT char_name,level,classid,base_class,charId FROM characters WHERE account_name='{a}'",
"selectDelevelSub" => "SELECT level, sp FROM character_subclasses WHERE charId='{a}' AND class_id='{b}'",
"setCharName" => "UPDATE `characters` SET char_name='{a}' WHERE charId='{b}' AND online='0'",
"setTeleport" => "UPDATE characters SET x='{a}',y='{b}',z='{c}' WHERE charId='{d}' AND online='0'",
"setSex" => "UPDATE characters SET sex='{a}' WHERE charId='{b}' AND online='0'",
"setAccount" => "UPDATE characters SET account_name='{a}' WHERE charId='{b}' AND online='0'",
"setDelevel" => "UPDATE characters SET level='{a}',exp='{b}' WHERE charId='{c}' AND online='0'",
"setDelevelSub" => "UPDATE character_subclasses SET level='{a}',exp='{b}' WHERE charId='{c}' and class_id='{d}'",
"itemsCount" => "SELECT count FROM `items` WHERE item_id='{a}' AND owner_id='{b}' AND loc='INVENTORY'",
"itemsSet" => "UPDATE items SET count='{a}' WHERE item_id='{b}' AND owner_id='{c}' AND loc='INVENTORY'",

"statsAdena" => "SELECT count,owner_id,charId,level,sex,online,accesslevel FROM `items`,`characters` WHERE item_id='57' AND loc='INVENTORY' AND accesslevel='0' AND count > '0' AND items.owner_id=characters.charID ORDER BY -count LIMIT {a}",
"statsOnline" => "SELECT char_name,level,sex,pvpkills,pkkills,clanid FROM `characters` WHERE online='1' AND accesslevel='0'",
"statsVote" => "SELECT char_name, count(char_name) as c FROM `character_vote` GROUP BY char_name ORDER BY 2 DESC LIMIT {a}",
"statsTop" => "SELECT char_name, level, pvpkills, pkkills, clanid, online FROM `characters` WHERE accesslevel='0' ORDER BY -exp LIMIT {a}",
"statsRb" => "SELECT name,respawn_time,level FROM `raidboss_spawnlist`,`npc` WHERE raidboss_spawnlist.boss_id=npc.id ORDER BY -level LIMIT {a}",
"statsCastle" => "SELECT id,name,siegeDate FROM `castle` ORDER BY name",
"statsFort" => "SELECT id,name,siegeDate,lastOwnedTime,owner FROM fort ORDER BY name",
"statsClan" => "SELECT clan_id,clan_name,clan_level,leader_id FROM `clan_data` WHERE clan_id > 0 ORDER BY -clan_level",

"clanLeader" => "SELECT char_name FROM `characters` WHERE accesslevel='0' AND charId='{a}'",
"clanMember" => "SELECT count(*) FROM `characters` WHERE accesslevel='0' AND clanid='{a}'",
"castleOwner" => "SELECT clan_name FROM `clan_data` WHERE hasCastle='{a}'",
"charIdToName" => "SELECT char_name FROM `characters` WHERE charId='{a}'",
"charNameToId" => "SELECT charId FROM `characters` WHERE char_name='{a}'",
"clanIdToClanName" => "SELECT clan_name FROM `clan_data` WHERE clan_id='{a}'",

"selectMaxItems" => "SELECT MAX{a} FROM `items`",
"selectVote" => "SELECT * FROM `character_vote` WHERE `char_name`='{a}' AND `date`='{b}' AND `type`='{c}'",
"selectItems" => "SELECT * FROM `items` WHERE `owner_id`='{a}' AND `item_id`='{b}' AND `loc`='INVENTORY'",
"insertVote" => "INSERT INTO `character_vote` (`char_name`, `date`, `type`,`ip`) VALUES ('{a}', '{b}', '{c}', '{d}')",
"insertItems" => "INSERT INTO `items` (`owner_id`, `object_id`, `item_id`, `count`, `enchant_level`, `loc`, `loc_data`, `time_of_use`, `custom_type1`, `custom_type2`, `mana_left`, `time`) VALUES ('{a}', '{b}', '{c}', '{d}', 0, 'INVENTORY', 0, 'NULL', NULL, 0, -1, -1)",
"updateItems" => "UPDATE `items` SET `count`=`count` + '{a}' WHERE `item_id`='{b}' AND `owner_id`='{c}' AND `loc`='INVENTORY'",

);

?>

[Perfecto]

Ну проблемы с сайтом, как думаете какой MySQL нужен?
У Вас что для сервера и сайта разные MySQL стоят?

И судя по всему выше написанному, сайт не может подключится к каким-то игровым базам

[[Red Dragon]]

думаю тот на каком сервер)

Добавлено через 1 минуту
Parse error: parse error, unexpected T_STRING in /home/l/l2zaken.hut2.ru/WWW/data/sql.inc.php on line 9

[Perfecto]

думаю тот на каком сервер)

Вот в этом и причина у Вас сервер и сайт на разных базах, а сайт должен подключаться к базе сервера т.е. разными они быть хоть как не могут.
Сделайте все на 1 MySQL и проблем с этим не будет

[[Red Dragon]]

sql.inc

<? if(!defined('Light_Engine')) {die("Hacking attempt!");}

# ========================================================================== #
# #
# Light_Engine | Модуль: Распределение запросов + подключение к БД #
# #
# ========================================================================== #

$db = mysql_connect($mysql['dbhost']locqalhost, $mysql['dbuser']12345, $mysql['dbpass']12345);
mysql_select_db ($mysql['dbname']l2jdb);
mysql_query("SET NAMES cp1251");

$queryList = array (

"auth" => "SELECT login,password FROM `accounts` WHERE login='{a}'",
"update" => "UPDATE accounts SET `password`='{a}' WHERE login='{b}'",

"register" => "INSERT INTO `accounts` (login, password, lastactive, accessLevel, lastIP, lastServer) VALUES ('{a}', '{b}', 0, '0', NULL, NULL)",
"registerCheck" => "SELECT * FROM `accounts` WHERE login = '{a}'",
"passwordCheck" => "SELECT password FROM `accounts` WHERE `password`='{a}'",

"online" => "SELECT count(`charid`) FROM characters WHERE online = '1' AND accesslevel = '0'",
"raceCount" => "SELECT count(`charid`) FROM `characters` WHERE `race` = '{a}'",
"sevenSigns" => "SELECT count(*) FROM `seven_signs` WHERE cabal like '%{a}%'",
"hellbound" => "SELECT `{a}` FROM `hellbound`",
"charactersCount" => "SELECT count(`{a}`) FROM `characters`",
"accountsCount" => "SELECT count(`{a}`) FROM `accounts`",
"clanDataCount" => "SELECT count(`{a}`) FROM `clan_data`",

"itemsNickAcc" => "SELECT char_name,(SELECT count FROM items WHERE item_id='{a}' AND owner_id=ch.charId and loc='INVENTORY') from characters AS ch WHERE account_name='{b}'",
"itemsSexTele" => "SELECT char_name,charId,sex,(SELECT count FROM items WHERE item_id='{a}' AND owner_id=ch.charId and loc='INVENTORY') FROM characters AS ch WHERE account_name='{b}'",
"itemsTeleport" => "SELECT char_name,level,(SELECT count FROM items WHERE item_id='{a}' AND owner_id=ch.charId and loc='INVENTORY'),charId,online FROM characters AS ch WHERE charId='{b}'",
"selectSex" => "SELECT char_name,sex,classid,base_class,charId FROM characters WHERE account_name='{a}'",
"selectDelevel" => "SELECT char_name,level,classid,base_class,charId FROM characters WHERE account_name='{a}'",
"selectDelevelSub" => "SELECT level, sp FROM character_subclasses WHERE charId='{a}' AND class_id='{b}'",
"setCharName" => "UPDATE `characters` SET char_name='{a}' WHERE charId='{b}' AND online='0'",
"setTeleport" => "UPDATE characters SET x='{a}',y='{b}',z='{c}' WHERE charId='{d}' AND online='0'",
"setSex" => "UPDATE characters SET sex='{a}' WHERE charId='{b}' AND online='0'",
"setAccount" => "UPDATE characters SET account_name='{a}' WHERE charId='{b}' AND online='0'",
"setDelevel" => "UPDATE characters SET level='{a}',exp='{b}' WHERE charId='{c}' AND online='0'",
"setDelevelSub" => "UPDATE character_subclasses SET level='{a}',exp='{b}' WHERE charId='{c}' and class_id='{d}'",
"itemsCount" => "SELECT count FROM `items` WHERE item_id='{a}' AND owner_id='{b}' AND loc='INVENTORY'",
"itemsSet" => "UPDATE items SET count='{a}' WHERE item_id='{b}' AND owner_id='{c}' AND loc='INVENTORY'",

"statsAdena" => "SELECT count,owner_id,charId,level,sex,online,accesslevel FROM `items`,`characters` WHERE item_id='57' AND loc='INVENTORY' AND accesslevel='0' AND count > '0' AND items.owner_id=characters.charID ORDER BY -count LIMIT {a}",
"statsOnline" => "SELECT char_name,level,sex,pvpkills,pkkills,clanid FROM `characters` WHERE online='1' AND accesslevel='0'",
"statsVote" => "SELECT char_name, count(char_name) as c FROM `character_vote` GROUP BY char_name ORDER BY 2 DESC LIMIT {a}",
"statsTop" => "SELECT char_name, level, pvpkills, pkkills, clanid, online FROM `characters` WHERE accesslevel='0' ORDER BY -exp LIMIT {a}",
"statsRb" => "SELECT name,respawn_time,level FROM `raidboss_spawnlist`,`npc` WHERE raidboss_spawnlist.boss_id=npc.id ORDER BY -level LIMIT {a}",
"statsCastle" => "SELECT id,name,siegeDate FROM `castle` ORDER BY name",
"statsFort" => "SELECT id,name,siegeDate,lastOwnedTime,owner FROM fort ORDER BY name",
"statsClan" => "SELECT clan_id,clan_name,clan_level,leader_id FROM `clan_data` WHERE clan_id > 0 ORDER BY -clan_level",

"clanLeader" => "SELECT char_name FROM `characters` WHERE accesslevel='0' AND charId='{a}'",
"clanMember" => "SELECT count(*) FROM `characters` WHERE accesslevel='0' AND clanid='{a}'",
"castleOwner" => "SELECT clan_name FROM `clan_data` WHERE hasCastle='{a}'",
"charIdToName" => "SELECT char_name FROM `characters` WHERE charId='{a}'",
"charNameToId" => "SELECT charId FROM `characters` WHERE char_name='{a}'",
"clanIdToClanName" => "SELECT clan_name FROM `clan_data` WHERE clan_id='{a}'",

"selectMaxItems" => "SELECT MAX{a} FROM `items`",
"selectVote" => "SELECT * FROM `character_vote` WHERE `char_name`='{a}' AND `date`='{b}' AND `type`='{c}'",
"selectItems" => "SELECT * FROM `items` WHERE `owner_id`='{a}' AND `item_id`='{b}' AND `loc`='INVENTORY'",
"insertVote" => "INSERT INTO `character_vote` (`char_name`, `date`, `type`,`ip`) VALUES ('{a}', '{b}', '{c}', '{d}')",
"insertItems" => "INSERT INTO `items` (`owner_id`, `object_id`, `item_id`, `count`, `enchant_level`, `loc`, `loc_data`, `time_of_use`, `custom_type1`, `custom_type2`, `mana_left`, `time`) VALUES ('{a}', '{b}', '{c}', '{d}', 0, 'INVENTORY', 0, 'NULL', NULL, 0, -1, -1)",
"updateItems" => "UPDATE `items` SET `count`=`count` + '{a}' WHERE `item_id`='{b}' AND `owner_id`='{c}' AND `loc`='INVENTORY'",

);

?>

вот так я пишу путь к базе например это

Добавлено через 3 минуты
а как их зделать на 1 базе подскожи у меня уже есть база с сервером я хочу к ней подконектится но ошибка Parse error: parse error, unexpected T_STRING in /home/l/l2zaken.hut2.ru/WWW/data/sql.inc.php on line 9

[Perfecto]

Надо конфиг сайта настраивать под MySQL сервера, т.е. адрес уже не 127.0.0.1, a IP где стоит сервер (логин и пароль менять). И еще доступ из вне открыть в MySQL сервера, чтобы обвязка к нему могла подключится

[[Red Dragon]]

это делать в лк сайта или где