Вот мои конфиги посмотри, может ты ошибку найдешь
PHP код:
<?php
//-===заполняется обязательно===-
$hostname = "127.0.0.1"; // mysql Хост
$username = "root"; // Логин
$password = "********"; // Пароль
$dbcharacters = "characters"; // название бд
$dbrealmd= "realmd"; //
$dbmangos = "mangos";
$ip= "127.0.0.1"; // записываете ваш ip ( для отображения на главной странице)
//-=== для ссылки "с чего начать"===-
$servtype="PVP-RP";//тип сервера
$clientversion="3.1.3";// версия клиента
//-=== сколько выводить богачей сервера"===-
$title="********"; //название сайта
?>
и
PHP код:
<?
include('config.php');
$wellcome=($p_acc?"Добро пожаловать, $p_acc ,вам доступны аккаунты <br>":" ");
//ошибки
Error_Reporting(0);
mysql_connect($hostname,$username,$password) OR $error=(" ");
mysql_select_db($dbcharacters) OR $error=(" ");
//все кто в он-лайне
$ally=@mysql_num_rows(mysql_query("SELECT online FROM `characters` WHERE race IN (1,3,4,7,11) HAVING online = 1"));
$horde_=@mysql_num_rows(mysql_query("SELECT online FROM `characters`WHERE race IN(2,5,6,8,10) HAVING online = 1"));
$numonline=@mysql_num_rows(mysql_query("SELECT NULL FROM `characters` WHERE `online`='1';"));
if ($numonline==0) {$numonline= 1;}
// проценты
$alliance = round(($ally*100)/$numonline ,1);
$horder = round(($horde_*100)/$numonline ,1);
// -=АЛЬЯНС=-
@mysql_query ("SET NAMES cp1251");
$allies_line=@mysql_query("SELECT online, name,race,class,data FROM `characters` WHERE race IN (1,3,4,7,11) AND online = 1");
while ($ali=mysql_fetch_assoc($allies_line))
{
$data = explode(' ',$ali['data']);
$lvl = $data[53];
$onAlies.= "<font color=cc3300 >";
$onAlies.= "[".$lvl."]";
$onAlies.= "</font >";
if ($ali['race'] == 1 ) {$ali['race'] = '<img src=img/1-0.gif alt=Человек >';}
else if ($ali['race'] == 3 ) {$ali['race'] = '<img src=img/3-0.gif alt=Дварф >';}
else if ($ali['race'] == 4 ) {$ali['race'] = '<img src=img/4-0.gif alt=НочнойЭльф >';}
else if ($ali['race'] == 7 ) {$ali['race'] = '<img src=img/7-0.gif alt=Гном >';}
else if ($ali['race'] == 11 ) {$ali['race'] = '<img src=img/11-0.gif alt=Дреней >';}
$onAlies.=$ali["race"];
$onAlies.=" ";
if ($ali['class'] == 1 ) {$ali['class'] = '<img src=img/1.gif alt=Воин >';}
else if ($ali['class'] == 2 ) {$ali['class'] = '<img src=img/2.gif alt=Паладин >';}
else if ($ali['class'] == 3 ) {$ali['class'] = '<img src=img/3.gif alt=Хантер >';}
else if ($ali['class'] == 4 ) {$ali['class'] = '<img src=img/4.gif alt=Рог >';}
else if ($ali['class'] == 5 ) {$ali['class'] = '<img src=img/5.gif alt=Прист >';}
else if ($ali['class'] == 7 ) {$ali['class']= '<img src=img/7.gif alt=Шаман >';}
else if ($ali['class'] == 8 ) {$ali['class']= '<img src=img/8.gif alt=Маг >';}
else if ($ali['class'] == 9 ) {$ali['class'] = '<img src=img/9.gif alt=Варлок >';}
else if ($ali['class'] == 11 ) {$ali['class']= '<img src=img/11.gif alt=Друид >';}
$onAlies.=$ali["class"];
$onAlies.=" ";
$onAlies.= "<a href=\"userbar/ub.php?name=" . $ali["name"] . "\">" . $ali["name"] . "</a>";
$onAlies.=" ";
$onAlies.= "<br>";
}
// -=ОРДА=-
@mysql_query ("SET NAMES cp1251");
$horde_line=@mysql_query("SELECT online, name,race,class,data FROM `characters` WHERE race IN (2,5,6,8,10) AND online = 1");
while ($horde=mysql_fetch_assoc($horde_line))
{
$data = explode(' ',$horde['data']);
$lvl = $data[53];
$onhorde.= "<font color=cc3300 >";
$onhorde.= "[".$lvl."]";
$onhorde.= "</font >";
if ($horde['race'] == 2 ) {$horde['race'] = '<img src=img/2-0.gif alt=Орк >';}
else if ($horde['race'] == 5 ) {$horde['race'] = '<img src=img/5-0.gif alt=Нежить >';}
else if ($horde['race'] == 6 ) {$horde['race'] = '<img src=img/6-0.gif alt=Таурен >';}
else if ($horde['race'] == 8 ) {$horde['race'] = '<img src=img/8-0.gif alt=Троль >';}
else if ($horde['race'] == 9 ) {$horde['race'] = '<img src=img/9-0.gif alt=Гоблин >';}
else if ($horde['race'] == 10 ) {$horde['race'] = '<img src=img/10-0.gif alt=КровавыйЭльф >';}
$onhorde.=$horde["race"];
$onhorde.=" ";
if ($horde['class'] == 1 ) {$horde['class'] = '<img src=img/1.gif alt=Воин >';}
else if ($horde['class'] == 2 ) {$horde['class'] = '<img src=img/2.gif alt=Паладин >';}
else if ($horde['class'] == 3 ) {$horde['class'] = '<img src=img/3.gif alt=Хантер >';}
else if ($horde['class'] == 4 ) {$horde['class'] = '<img src=img/4.gif alt=Рог >';}
else if ($horde['class'] == 5 ) {$horde['class'] = '<img src=img/5.gif alt=Прист >';}
else if ($horde['class'] == 7 ) {$horde['class'] = '<img src=img/7.gif alt=Шаман >';}
else if ($horde['class'] == 8 ) {$horde['class'] = '<img src=img/8.gif alt=Маг >';}
else if ($horde['class'] == 9 ) {$horde['class'] = '<img src=img/9.gif alt=Варлок >';}
else if ($horde['class'] == 11 ) {$horde['class'] = '<img src=img/11.gif alt=Друид >';}
$onhorde.=$horde["class"];
$onhorde.=" ";
$onhorde.= "<a href=\"userbar/ub.php?name=" . $horde["name"] . "\">" . $horde["name"] . "</a>";
$onhorde.=" ";
$onhorde.= " <br>";
}
$ab=$horde_+$ally
?>
<?
//логин и пароль проверка и доступ начало
$link = mysql_connect($hostname,$username,$password) ;
mysql_select_db($dbrealmd) or print(mysql_error());
$sql = "SELECT * FROM account WHERE username='$p_acc'";
$result = mysql_query($sql);
$db = mysql_fetch_array($result);
$gmlevel=$db["gmlevel"];
if ($gmlevel==0){$uroven_dostupa="пользователь";}
if ($gmlevel==1) {$uroven_dostupa="модератор";}
if ($gmlevel==2) {$uroven_dostupa="модератор";}
if ($gmlevel==3) {$uroven_dostupa="Администратор";}
$id_=$db["id"];
$pass1=$db['sha_pass_hash'];
$hash = SHA1(strtoupper($p_acc.":".$p_pass));
if ($hash==$pass1){$xash="1";}
else {$xash="2";}
if ($xash==1) {
mysql_select_db($dbcharacters) or print(mysql_error());
$sql = "SELECT * FROM characters WHERE account='$id_'";
$result = mysql_query($sql);
while ($db=mysql_fetch_assoc($result))
{
$data = explode(' ',$db['data']);
$lvl = $data[53];
if ($db['race'] == 2 ) {$db['race'] = '<img src=img/2-0.gif alt=Орк >';}
else if ($db['race'] == 5 ) {$db['race'] = '<img src=img/5-0.gif alt=Нежить >';}
else if ($db['race'] == 6 ) {$db['race'] = '<img src=img/6-0.gif alt=Таурен >';}
else if ($db['race'] == 8 ) {$b['race'] = '<img src=img/8-0.gif alt=Троль >';}
else if ($db['race'] == 9 ) {$b['race'] = '<img src=img/9-0.gif alt=Гоблин >';}
else if ($db['race'] == 10 ) {$db['race'] = '<img src=img/10-0.gif alt=КровавыйЭльф >';}
if ($db['race'] == 1 ) {$db['race'] = '<img src=img/1-0.gif alt=Человек >';}
else if ($db['race'] == 3 ) {$db['race'] = '<img src=img/3-0.gif alt=Дварф >';}
else if ($db['race'] == 4 ) {$db['race'] = '<img src=img/4-0.gif alt=НочнойЭльф >';}
else if ($db['race'] == 7 ) {$db['race'] = '<img src=img/7-0.gif alt=Гном >';}
else if ($db['race'] == 11 ) {$db['race'] = '<img src=img/11-0.gif alt=Дреней >';}
$name.=$db["race"];
$name.=" ";
if ($db['class'] == 1 ) {$db['class'] = '<img src=img/1.gif alt=Воин >';}
else if ($db['class'] == 2 ) {$db['class'] = '<img src=img/2.gif alt=Паладин >';}
else if ($db['class'] == 3 ) {$db['class'] = '<img src=img/3.gif alt=Хантер >';}
else if ($db['class'] == 4 ) {$db['class'] = '<img src=img/4.gif alt=Рог >';}
else if ($db['class'] == 5 ) {$db['class'] = '<img src=img/5.gif alt=Прист >';}
else if ($db['class'] == 7 ) {$db['class'] = '<img src=img/7.gif alt=Шаман >';}
else if ($db['class'] == 8 ) {$db['class'] = '<img src=img/8.gif alt=Маг >';}
else if ($db['class'] == 9 ) {$db['class'] = '<img src=img/9.gif alt=Варлок >';}
else if ($db['class'] == 11 ) {$db['class'] = '<img src=img/11.gif alt=Друид >';}
$name.=$db["class"];
$name.=" ";
$name.="<a href=\"userbar/ub.php?name=".$db["name"]."\">".$db["name"]."</a>";
$name.=" ";
$name.= "[".$lvl."]";
//$name.="<br>";
$name.=" ";
}
}
else {echo " "; }
//логин и пароль проверка и доступ конец
?>
<?
//левое меню начало.
if ($page == news ) {include('news.php'); }
include('main.php');
if ($page == rega ) {include('registration.php'); }
if ($page == guild ) {include('guild.php'); }
if ($page == stat ) {include('stat.php'); }
//конец
?>
<p> </p>
а ошибка такого рода
PHP код:
":" "); //ошибки Error_Reporting(0); mysql_connect($hostname,$username,$password) OR $error=(" "); mysql_select_db($dbcharacters) OR $error=(" "); //все кто в он-лайне $ally=@mysql_num_rows(mysql_query("SELECT online FROM `characters` WHERE race IN (1,3,4,7,11) HAVING online = 1")); $horde_=@mysql_num_rows(mysql_query("SELECT online FROM `characters`WHERE race IN(2,5,6,8,10) HAVING online = 1")); $numonline=@mysql_num_rows(mysql_query("SELECT NULL FROM `characters` WHERE `online`='1';")); if ($numonline==0) {$numonline= 1;} // проценты $alliance = round(($ally*100)/$numonline ,1); $horder = round(($horde_*100)/$numonline ,1); // -=АЛЬЯНС=- @mysql_query ("SET NAMES cp1251"); $allies_line=@mysql_query("SELECT online, name,race,class,data FROM `characters` WHERE race IN (1,3,4,7,11) AND online = 1"); while ($ali=mysql_fetch_assoc($allies_line)) { $data = explode(' ',$ali['data']); $lvl = $data[53]; $onAlies.= ""; $onAlies.= "[".$lvl."]"; $onAlies.= ""; if ($ali['race'] == 1 ) {$ali['race'] = '';} else if ($ali['race'] == 3 ) {$ali['race'] = '';} else if ($ali['race'] == 4 ) {$ali['race'] = '';} else if ($ali['race'] == 7 ) {$ali['race'] = '';} else if ($ali['race'] == 11 ) {$ali['race'] = '';} $onAlies.=$ali["race"]; $onAlies.=" "; if ($ali['class'] == 1 ) {$ali['class'] = '';} else if ($ali['class'] == 2 ) {$ali['class'] = '';} else if ($ali['class'] == 3 ) {$ali['class'] = '';} else if ($ali['class'] == 4 ) {$ali['class'] = '';} else if ($ali['class'] == 5 ) {$ali['class'] = '';} else if ($ali['class'] == 7 ) {$ali['class']= '';} else if ($ali['class'] == 8 ) {$ali['class']= '';} else if ($ali['class'] == 9 ) {$ali['class'] = '';} else if ($ali['class'] == 11 ) {$ali['class']= '';} $onAlies.=$ali["class"]; $onAlies.=" "; $onAlies.= "" . $ali["name"] . ""; $onAlies.=" "; $onAlies.= "
"; } // -=ОРДА=- @mysql_query ("SET NAMES cp1251"); $horde_line=@mysql_query("SELECT online, name,race,class,data FROM `characters` WHERE race IN (2,5,6,8,10) AND online = 1"); while ($horde=mysql_fetch_assoc($horde_line)) { $data = explode(' ',$horde['data']); $lvl = $data[53]; $onhorde.= ""; $onhorde.= "[".$lvl."]"; $onhorde.= ""; if ($horde['race'] == 2 ) {$horde['race'] = '';} else if ($horde['race'] == 5 ) {$horde['race'] = '';} else if ($horde['race'] == 6 ) {$horde['race'] = '';} else if ($horde['race'] == 8 ) {$horde['race'] = '';} else if ($horde['race'] == 9 ) {$horde['race'] = '';} else if ($horde['race'] == 10 ) {$horde['race'] = '';} $onhorde.=$horde["race"]; $onhorde.=" "; if ($horde['class'] == 1 ) {$horde['class'] = '';} else if ($horde['class'] == 2 ) {$horde['class'] = '';} else if ($horde['class'] == 3 ) {$horde['class'] = '';} else if ($horde['class'] == 4 ) {$horde['class'] = '';} else if ($horde['class'] == 5 ) {$horde['class'] = '';} else if ($horde['class'] == 7 ) {$horde['class'] = '';} else if ($horde['class'] == 8 ) {$horde['class'] = '';} else if ($horde['class'] == 9 ) {$horde['class'] = '';} else if ($horde['class'] == 11 ) {$horde['class'] = '';} $onhorde.=$horde["class"]; $onhorde.=" "; $onhorde.= "" . $horde["name"] . ""; $onhorde.=" "; $onhorde.= "
"; } $ab=$horde_+$ally ?> ';} else if ($db['race'] == 5 ) {$db['race'] = '';} else if ($db['race'] == 6 ) {$db['race'] = '';} else if ($db['race'] == 8 ) {$b['race'] = '';} else if ($db['race'] == 9 ) {$b['race'] = '';} else if ($db['race'] == 10 ) {$db['race'] = '';} if ($db['race'] == 1 ) {$db['race'] = '';} else if ($db['race'] == 3 ) {$db['race'] = '';} else if ($db['race'] == 4 ) {$db['race'] = '';} else if ($db['race'] == 7 ) {$db['race'] = '';} else if ($db['race'] == 11 ) {$db['race'] = '';} $name.=$db["race"]; $name.=" "; if ($db['class'] == 1 ) {$db['class'] = '';} else if ($db['class'] == 2 ) {$db['class'] = '';} else if ($db['class'] == 3 ) {$db['class'] = '';} else if ($db['class'] == 4 ) {$db['class'] = '';} else if ($db['class'] == 5 ) {$db['class'] = '';} else if ($db['class'] == 7 ) {$db['class'] = '';} else if ($db['class'] == 8 ) {$db['class'] = '';} else if ($db['class'] == 9 ) {$db['class'] = '';} else if ($db['class'] == 11 ) {$db['class'] = '';} $name.=$db["class"]; $name.=" "; $name.="".$db["name"].""; $name.=" "; $name.= "[".$lvl."]"; //$name.="
"; $name.=" "; } } else {echo " "; } //логин и пароль проверка и доступ конец ?>
главное что модуль "игроки на карте" работает, берут настройки к конекту с одно и того же файла (первый конфиг)....