Все скрипты сделаны под такой конфиг config.php
Code
<?
$ip="127.0.0.1"; // IP доступа к серверу (реалмлист)
$gameport="8085"; // Порт игрового сервера 8085 или 8086
$dbip="127.0.0.1"; // IP к mysql
$dbport="3306"; // порт к mysql
$dblogin="mangos"; // Логин для mysql
$dbpass="mangos"; // Пароль для mysql
$dbm="mangos"; // Имя базы мира (mangos)
$dbc="characters"; // Имя базы персонажей
$dbr="realmd"; // Имя базы аккаунтов
$dbc2="characters2" // Для тех у кого два мира
?>
Скрипт статуса сервера:
Code
<?
include('config.php');
$fp1 = @fsockopen('$ip', $gameport, $errno, $errstr, 1);
$onoff200=($fp1?"Включен":"Выключен");
?>
<b>Статус сервера:</b>
<?echo " $onoff200"; ?>
</p>
Скрипт по классам и расам:
Code
<?
include('config.php');
mysql_connect("$ip", "$dblogin", "$dbpass");
mysql_select_db ("$dbc");
$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<br>";
echo "Дварфов: $dwarv<br>";
echo "Ночных Эльфов: $night<br>";
echo "Гномов: $gnome<br>";
echo "Дренейев: $draenei<br>";
echo "Орков: $orc<br>";
echo "Нежити: $undead<br>";
echo "Тауренов: $tauren<br>";
echo "Троллей: $troll<br>";
echo "Эльфов Крови: $blood<br><br>";
echo "Друидов: $druid<br>";
echo "Охотников: $hunter<br>";
echo "Магов: $mage<br>";
echo "Паладинов: $paladin<br>";
echo "Жрецов: $priest<br>";
echo "Разбойников: $rogue<br>";
echo "Шаманов: $shaman<br>";
echo "Чернокнижников: $warlock<br>";
echo "Воинов: $warrior<br>";
echo "Рыцарей Смерти: $death<br>";
?>
Код для общего онлайна:
Code
<?
include('config.php');
$fp1 = @fsockopen ("$ip","8085",$errno,$errstr,1);
if ($fp1) {
mysql_connect("$dbip","$dblogin","$dbpass");
mysql_selectdb ("$dbc");
$online_tmp = mysql_query ("select count(guid) as kol from characters where online = 1");
$online_kol = mysql_fetch_array($online_tmp);
$online1 = $online_kol['kol'];
}
else $online1 = 0;
$fp2 = @fsockopen ("localhost","8086",$errno,$errstr,1);
if ($fp2) {
mysql_connect("$dbip","$dblogin","$dbpass");
mysql_selectdb ("$dbc2");
$online_tmp = mysql_query ("select count(guid) as kol from characters where online = 1");
$online_kol = mysql_fetch_array($online_tmp);
$online2 = $online_kol['kol'];
}
else $online2 = 0;
$online=$online1 + $online2;
echo $online;
?>
Скрипт регистрации Mangos и Trinity (Добавил Sira) - Внимание настройки бод сервер кода регистрации выполнять прям в нём!
Code
<?php
$config = array (
// Names of DBs
'wname' => 'mangos', // база мира
'rname' => 'realmd', // база реалмов
'cname' => 'characters', // база чаров
// DB settings
'host' => '127.0.0.1', // адрес БД
'user' => 'mangos', // логин к БД
'pass' => 'mangos', // пароль к БД
'port' => '3306', // порт к БД
);
$db1 = "realmd";
$db2 = "mangos";
$db3 = "characters";
Имя, Уровень ,Звани в Гильдии , Раса , Класс - таблица (Добавил garsuk)
Code
<?php
$realm = $realmdDB -> selectrow("SELECT * FROM `realmlist` WHERE `id` = ?d;", $CONF['realmID']);
$realmOnline = testRealm($realm);
if ($realmOnline) {
if (isset($_GET['id'])) {
$guild = $charactersDB -> selectrow(
"SELECT `c`.`name` as `lname`, `g`.`name`, `g`.`createdate`, `g`.`BankMoney`, `g`.`info`, `g`.`motd` ".
"FROM `guild` as `g` ".
"LEFT JOIN `characters` as `c` ON `c`.`guid` = `g`.`leaderguid` ".
"WHERE `g`.`guildid` = ?d;", $_GET['id']);
$members = $charactersDB -> select(
"SELECT `c`.`name`, `c`.`race`, `c`.`class`, `c`.`account`, `g_m`.`pnote`, `g_m`.`offnote`, `g_r`.`rname`, ".
"CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`c`.`data`, ' ', 54), ' ', -1) AS UNSIGNED) as `level`, ".
"CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`c`.`data`, ' ', 23), ' ', -1) AS UNSIGNED) as `gender` ".
"FROM `guild_member` as `g_m` ".
"LEFT JOIN `characters` as `c` ON `c`.`guid` = `g_m`.`guid` ".
"LEFT JOIN `guild_rank` as `g_r` ON (`g_r`.`rid` = `g_m`.`rank` AND `g_r`.`guildid` = `g_m`.`guildid`) ".
"WHERE `g_m`.`guildid` = ?d", $_GET['id']);
?>
<table cellpadding = "0" cellspacing = "0" style="{ border-collapse: collapse; margin: 3px; }" class="table">
<tr>
<td class="top">Название: </td>
<td><?php echo $guild['name']; ?></td>
</tr>
<tr>
<td class="top">Гильдмастер: </td>
<td><?php echo $guild['lname']; ?></td>
</tr>
<tr>
<td class="top">Дата создания: </td>
<td><?php echo date("d.m.Y H:m", $guild['createdate']); ?></td>
</tr>
<tr>
<td class="top">Денег в банке: </td>
<td><?php echo gold($guild['BankMoney']); ?></td>
</tr>
<tr>
<td class="top">Информация: </td>
<td><?php echo $guild['info']; ?></td>
</tr>
<tr>
<td class="top">Девиз: </td>
<td><?php echo $guild['motd']; ?></td>
</tr>
</table>
<br>
<h2>Участники гильдии:</h2>
<table cellpadding = "0" cellspacing = "0" style="{ border-collapse: collapse; margin: 3px; }" class="table">
<tr>
<td class="top">#</td>
<td class="top">Имя</td>
<td class="top">Уровень</td>
<td class="top">Звание в гильдии</td>
<td class="top">Раса</td>
<td class="top">Класс</td>
</tr>
<?php
$i = 1;
foreach ($members as $member) {
$member['aname'] = $realmdDB -> selectcell("SELECT `username` FROM `account` WHERE `id` = ?d;", $member['account']);
?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo $member['name']; ?></td>
<td><?php echo $member['level']; ?></td>
<td><?php echo $guild['lname']==$member['name']?"Guild Master":$member['rname']; ?></td>
<td><?php echo "<img src=\"./img/".$member['race']."-".gender($member['gender']).".gif\" alt=\"".$CONF['races'][$member['race']]."\">"; ?></td>
<td><?php echo "<img src=\"./img/".$member['class'].".gif\" alt=\"".$CONF['classes'][$member['class']]."\">"; ?></td>
</tr>
<?php
$i++;
}
echo "</table>\n";
} else {
!isset($_GET['sb'])? $_GET['sb'] = 'name': $_GET['sb'];
!isset($_GET['sc'])? $_GET['sc'] = 'ASC': $_GET['sc'];
if ($_GET['sc'] != 'ASC' && $_GET['sc'] != 'DESC') $_GET['sc'] = 'DESC';
$guilds = $charactersDB -> select(
"SELECT `c`.`name` as `lname`, `g`.`name`, `g`.`createdate`, `g`.`BankMoney`, `g`.`guildid` ".
"FROM `guild` as `g` ".
"LEFT JOIN `characters` as `c` ON `c`.`guid` = `g`.`leaderguid` ".
"ORDER BY ?# ".$_GET['sc'].";", $_GET['sb']);
$i = 1;
?>
<table cellpadding = "0" cellspacing = "0" style="{ border-collapse: collapse; margin: 3px; }" class="table">
<tr>
<td class="top">#</td>
<td class="top"><a href="?<?php echo "page=".$_GET['page']."&sb=name&sc=".(($_GET['sc']=='ASC' && $_GET['sb']=="name")? "DESC": "ASC");?>">Название</a></td>
<td class="top"><a href="?<?php echo "page=".$_GET['page']."&sb=lname&sc=".(($_GET['sc']=='ASC' && $_GET['sb']=="lname")? "DESC": "ASC");?>">Гильдмастер</a></td>
<td class="top"><a href="?<?php echo "page=".$_GET['page']."&sb=createdate&sc=".(($_GET['sc']=='DESC' && $_GET['sb']=="createdate")? "ASC": "DESC");?>">Дата создания</a></td>
<td class="top"><a href="?<?php echo "page=".$_GET['page']."&sb=BankMoney&sc=".(($_GET['sc']=='DESC' && $_GET['sb']=="BankMoney")? "ASC": "DESC");?>">Денег в банке</a></td>
</tr>
<?php
foreach ($guilds as $guild) {
?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo "<a href=\"?page=guilds&id=".$guild['guildid']."\">".$guild['name']."</a>"; ?></a></td>
<td><?php echo $guild['lname']; ?></td>
<td><?php echo date("d.m.Y H:m", $guild['createdate']); ?></td>
<td><?php echo gold($guild['BankMoney']); ?></td>
</tr>
<?php
$i++;
}
echo "</table>\n";
}
} else {
echo $realm['name']." выключен.<br>\n";
}
?>
Максимальный онлайн (Добавил Uncle_Razor)
Code
<?
include('config.php');
mysql_selectdb ("$dbr");
$max = mysql_query ("select max(`maxplayers`) from uptime");
$max = mysql_result ($max,0);
echo "Максимальный онлайн:$max <br>";
?>