<?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>
<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']." выключен.
\n";
}
?>
