?>
">
<?php
echo $guild['name'];
?>
</a>
</div>
<div class="under-name">
Гильдия <span class="level">
<?php
echo $guild['level'];
?>
</span>-го ур. (<?php
$faction_query = mysql_query("SELECT race FROM {$server_cdb}.guild_member inner join {$server_cdb}.characters on guild_member.guid = characters.guid WHERE guildid = '" . $_GET['guildid'] . "' LIMIT 1");
while ($faction = mysql_fetch_assoc($faction_query)) {
echo '' . $armory['Faction' . translateLet($faction['race'])] . '';
}
?>
)<span class="comma">,</span>
<span class="realm tip" id="profile-info-realm" data-battlegroup="Вихрь"> <?php
$realm_extra = mysql_fetch_assoc(mysql_query("SELECT * FROM realms WHERE id = '" . $_GET['guildid'] . "'"));
if (!$realm_extra) {
$realm_extra = mysql_fetch_assoc(mysql_query("SELECT * FROM realms WHERE id = '1'"));
}
$realm = mysql_fetch_assoc(mysql_query("SELECT * FROM {$server_adb}.realmlist WHERE id = '" . $realm_extra['realmid'] . "'"));
echo $realm['name'];
?>
</span><span class="comma">.</span>
<span class="members">Членов гильдии: 11</span>
</div>
<li class="last"><a href="" rel="np"><?php
echo $character->getObjectInfo()->name;
?>
@ <?php
echo @$name_realm1['realm'];
?>
</a></li>
</ol>
</div>
<div class="content-bot">
<?php
$raceNum = $character->getObjectInfo()->race;
//Numbre race for all armory references
echo '<div id="profile-wrapper" class="profile-wrapper profile-wrapper-advanced profile-wrapper-';
//Show horde/ally back image
if (translateLet($raceNum) == 0) {
echo 'alliance">';
} else {
echo 'horde">';
}
?>
<div class="profile-sidebar-anchor">
<div class="profile-sidebar-outer">
<div class="profile-sidebar-inner">
<div class="profile-sidebar-contents">
<div class="profile-info-anchor">
<div class="profile-info">
<div class="name"><a href="" rel="np"><?php
echo $character->getObjectInfo()->name;
?>
</a></div>
<a href="" class="sublink"><strong>' . $row['name'] . '</strong></a> - ' . $row['type'] . '<br />
<span data-tooltip="REALM NAME">' . $name_realm1['realm'] . '</span>
<span class="clear"><!-- --></span></div></div>';
}
if ($num_guild > 0) {
$sql = "SELECT guildid,G.name,C.race FROM `" . $server_cdb . "`.`guild` G,`" . $server_cdb . "`.`characters` C WHERE leaderguid=C.guid AND\n G.name LIKE '%" . mysql_real_escape_string($term) . "%' LIMIT 1";
$result = mysql_query($sql, $conn) or die(mysql_error());
$row = mysql_fetch_array($result);
echo '
<div class="grid">
<h4 class="subcategory "><a href="search_g.php?search=' . $term . '">' . $guild['Guilds'] . '</a>(' . $num_guild . ')</h4>
<div class="wowguild">
<img src="wow/static/images/icons/guild-flag.png" id="tabard-19804025" class="thumbnail" width="32" height="32" style="display: block; " />
<a href="guild.php?guildid=' . $row['guildid'] . '" rel="np">
<strong>' . $row['name'] . '</strong>
</a>- ' . $armory['Faction' . translateLet($row['race'])] . '<br /><span data-tooltip="' . $armory['Faction' . translateLet($row['race'])] . ' Guild">' . $name_realm1['realm'] . '</span>
<span class="clear"><!-- --></span>
</div>
</div>';
}
echo '<span class="clear"><!-- --></span>
</div>';
}
?>
<?php
if (!$error && $num_forum > 0) {
$sql = "SELECT T.id,forumid,T.name,author,replies,date,content,F.name as forum,F.id as fid,firstName as charac \n FROM `" . $server_db . "`.`forum_threads` T, `" . $server_db . "`.`forum_forums` F, `" . $server_db . "`.`users` U \n WHERE forumid=F.id AND U.id=author AND (T.name LIKE '" . mysql_real_escape_string($term) . "' OR \n T.name LIKE '% " . mysql_real_escape_string($term) . " %' OR T.name LIKE '" . mysql_real_escape_string($term) . " %' OR \n T.name LIKE '% " . mysql_real_escape_string($term) . "') LIMIT 10";
$result = mysql_query($sql, $conn) or die(mysql_error());
echo '<div class="results results-grid wow-results">
<h4 class="subcategory "><a href="search_f.php?search=' . $term . '">' . $search['forumResults'] . $term . '</a> (' . $num_forum . ')</h4>
<div class="view-list">';