while ($realm = mysql_fetch_array($get_realms)) {
$realm_extra = mysql_fetch_assoc(mysql_query("SELECT * FROM realms WHERE realmid = '" . $realm['id'] . "'"));
$server_cdb = $realm_extra['char_db'];
$check_chars = mysql_query("SELECT * FROM {$server_cdb}.characters WHERE account = '" . $account_information['id'] . "' ORDER BY `guid` DESC");
$current_realm = mysql_fetch_assoc(mysql_query("SELECT * FROM realms WHERE id = '" . $account_extra['char_realm'] . "'"));
if ($check_chars) {
while ($char = mysql_fetch_array($check_chars)) {
echo '
<a href="?cc=' . $char['guid'] . '&r=' . $realm['id'] . '" class="char ';
if ($char['guid'] == $actualchar['guid'] && $realm['id'] == $current_realm['realmid']) {
echo 'pinned';
}
echo '" rel="np">
<span class="pin"></span>
<span class="name">' . $char["name"] . '</span>
<span class="class color-c' . $char["class"] . '">' . $char["level"] . ' ' . racetxt($char['race']) . ' ' . classtxt($char['class']) . '</span>
<span class="realm';
$host = $realm['address'];
$world_port = $realm['port'];
$world = @fsockopen($host, $world_port, $err, $errstr, 2);
if (!$world) {
echo ' down';
}
echo '">' . $realm['name'] . '</span>
</a>
';
}
}
}
}
?>
<?php
if ($character) {
echo '<img src="' . $website['root'] . 'images/avatars/2d/' . $character['race'] . '-' . $character['gender'] . '.jpg" width="64" height="64" alt="" />';
} else {
echo '<img src="' . $website['root'] . 'images/avatars/2d/0-0.jpg" width="64" height="64" alt="" />';
}
?>
</div>
<div class="service-tag-description">
<span class="character-name caption"><?php
echo $character['name'];
?>
</span>
<span class="character-class"> <?php
echo $character['level'] . ' ' . racetxt($character['race']) . ' ' . classtxt($character['class']);
?>
</span>
<span class="character-realm"> <?php
echo $realm['name'];
?>
</span>
</div>
<span class="clear"><!-- --></span>
</div>
</div>
<div class="service-summary">
<p class="service-price headline">
<?php