Скрипты для сайта

Administrator — Fri, 09 Sep 2011 16:08:26 GMT

Code

$ip             ="127.0.0.1";           // IP сервера
$dbip           ="127.0.0.1";           // IP mysql
$dbport         ="3306";                // порт mysql
$gameport       ="8085";                // игровой порт
$dblogin        ="login";               // логин mysql
$dbpass         ="password";            // пароль mysql
$mdb            ="mangos";              // название базы mangos
$rdb            ="realmd";              // название базы realmd
$cdb            ="characters";          // название базы characters
?>

Подключение к базе

Code

require_once ('config.php');
mysql_connect ("$dbip:$dbport","$dblogin","$dbpass");
?>

Проверка статуса сервера

Код:

$fp = @fsockopen ("$ip","$gameport",$errno,$errstr,1);
if ($fp)
echo "Статус Сервера: online
";
else
echo "Статус Сервера: offline
";
?>

Кол-во аккаунтов, персонажей, орды, альянса, гильдий

Код:

mysql_selectdb ($rdb);
$acc = mysql_query ("select count(*) from account");
$acc = mysql_result ($acc,0);
mysql_selectdb ("$cdb");
$char = mysql_query ("select count(*) from characters");
$char = mysql_result ($char,0);
$alliance = mysql_query ("select count(*) from characters where race in (1,3,4,7,11)");
$alliance = mysql_result ($alliance,0);
$horde = mysql_query ("select count(*) from characters where race in (2,5,6,8,10)");
$horde = mysql_result ($horde,0);
$guild = mysql_query ("select count(*) from guild");
$guild = mysql_result ($guild,0);
echo "Аккаунтов: $acc
";
echo "Персонажей: $char
";
echo "Альянса: $alliance
";
echo "Орды: $horde
";
echo "Гильдий: $guild
";
?>

Кол-во игроков онлайн, орды онлайн, альянса онлайн, максимальный онлайн

Код:

mysql_selectdb ("$cdb");
$online = mysql_query ("select count(*) from characters where online = 1");
$online = mysql_result ($online,0);
$allianceonline = mysql_query ("select count(*) from characters where online = 1 and race in (1,3,4,7,11)");
$allianceonline = mysql_result ($allianceonline,0);
$hordeonline = mysql_query ("select count(*) from characters where online = 1 and race in (2,5,6,8,10)");
$hordeonline = mysql_result ($hordeonline,0);
mysql_selectdb ("$rdb");
$max = mysql_query ("select max(`maxplayers`) from uptime");
$max = mysql_result ($max,0);
echo "Игроков Онлайн: $online
";
echo "Альянса Онлайн: $allianceonline
";
echo "Орды Онлайн: $hordeonline
";
echo "Максимальный Онлайн: $max
";
?>

Время работы сервера

Код:

mysql_select_db ("$rdb");
$uptime = mysql_query ("select max(`starttime`) from `uptime`");
$uptime = time()-mysql_result ($uptime,0);
$sec = $uptime%60;
$uptime = intval ($uptime/60);
$min = $uptime%60;
$uptime = intval ($uptime/60);
$hours = $uptime%24;
$uptime = intval($uptime/24);
$days = $uptime;
echo "Время Работы: $days д $hours ч $min м $sec с
";
?>

Статистика по расам и классам

Код:

mysql_selectdb ("$cdb");
$human = mysql_query ("select count(*) from characters where race = 1");
$human = mysql_result ($human,0);
$dwarv = mysql_query ("select count(*) from characters where race = 3");
$dwarv = mysql_result ($dwarv,0);
$night = mysql_query ("select count(*) from characters where race = 4");
$night = mysql_result ($night,0);
$gnome = mysql_query ("select count(*) from characters where race = 7");
$gnome = mysql_result ($gnome,0);
$draenei = mysql_query ("select count(*) from characters where race = 11");
$draenei = mysql_result ($draenei,0);
$orc = mysql_query ("select count(*) from characters where race = 2");
$orc = mysql_result ($orc,0);
$undead = mysql_query ("select count(*) from characters where race = 5");
$undead = mysql_result ($undead,0);
$tauren = mysql_query ("select count(*) from characters where race = 6");
$tauren = mysql_result ($tauren,0);
$troll = mysql_query ("select count(*) from characters where race = 8");
$troll = mysql_result ($troll,0);
$blood = mysql_query ("select count(*) from characters where race = 10");
$blood = mysql_result ($blood,0);
$druid = mysql_query ("select count(*) from characters where class = 11");
$druid = mysql_result ($druid,0);
$hunter = mysql_query ("select count(*) from characters where class = 3");
$hunter = mysql_result ($hunter,0);
$mage = mysql_query ("select count(*) from characters where class = 8");
$mage = mysql_result ($mage,0);
$paladin = mysql_query ("select count(*) from characters where class = 2");
$paladin = mysql_result ($paladin,0);
$priest = mysql_query ("select count(*) from characters where class = 5");
$priest = mysql_result ($priest,0);
$rogue = mysql_query ("select count(*) from characters where class = 4");
$rogue = mysql_result ($rogue,0);
$shaman = mysql_query ("select count(*) from characters where class = 7");
$shaman = mysql_result ($shaman,0);
$warlock = mysql_query ("select count(*) from characters where class = 9");
$warlock = mysql_result ($warlock,0);
$warrior = mysql_query ("select count(*) from characters where class = 1");
$warrior = mysql_result ($warrior,0);
$death = mysql_query ("select count(*) from characters where class = 6");
$death = mysql_result ($death,0);
echo "Людей: $human
";
echo "Дворфов: $dwarv
";
echo "Ночных Эльфов: $night
";
echo "Гномов: $gnome
";
echo "Дренейев: $draenei
";
echo "Орков: $orc
";
echo "Нежити: $undead
";
echo "Тауренов: $tauren
";
echo "Троллей: $troll
";
echo "Эльфов Крови: $blood

";
echo "Друидов: $druid
";
echo "Охотников: $hunter
";
echo "Магов: $mage
";
echo "Паладинов: $paladin
";
echo "Жрецов: $priest
";
echo "Разбойников: $rogue
";
echo "Шаманов: $shaman
";
echo "Чернокнижников: $warlock
";
echo "Воинов: $warrior
";
echo "Рыцарей Смерти: $death
";
?>

Список игроков онлайн

Код:

mysql_selectdb ("$cdb");
mysql_query ('set names cp1251');
$result = mysql_query ("select name, race, class, data from characters where online = 1");
$class = array
(1=>"Воин",2=>"Паладин",3=>"Охотник",4=>"Разбойник",5=>"Жрец",6=>"Рыцарь Смерти",7=>"Шаман",8=>"Маг",9=>"Чернокнижник",11=>"Друид");
$race = array
(1=>"Человек",2=>"Орк",3=>"Дворф",4=>"Ночной Эльф",5=>"Нежить",6=>"Таурен",7=>"Гном",8=>"Тролль",10=>"Эльф Крови",11=>"Дреней");
while ($row = mysql_fetch_array ($result))
{
$ch_name = $row['name'];
$ch_race = $row['race'];
$ch_class = $row['class'];
$char_data = explode(' ',$row['data']);
$ch_lvl = $char_data[53];
echo "";
echo "";
echo "";
echo "";
}

Скрипт Бегущая строка в поле формы со сменой сообщений

Set — Sat, 09 Apr 2011 05:02:44 GMT

Code

Ставим куда хотим!

Имя:	Раса:	Класс:	Уровень:
$ch_name	$race[$ch_race]	$class[$ch_class]	$ch_lvl

MMO Base News - World of Warcraft

Скрипты для сайта

Скрипт Бегущая строка в поле формы со сменой сообщений