} else {
$gender = "<img src='{$florensia->layer_rel}/gender_female.gif' border='0' alt='male' style='height:12px;'>";
}
if (strlen($character->data['guild'])) {
if ($character->data['guildid']) {
$guild = "<a href='" . $florensia->outlink(array('guilddetails', $character->data['guildid'], $character->data['server'], $character->data['guild'])) . "'>" . $florensia->escape($character->data['guild']) . "</a>";
} else {
$guild = $florensia->escape($character->data['guild']);
}
if ($character->data['guildgrade']) {
$guild .= " " . class_character::guildgrade($character->data['guildgrade']);
}
} else {
$guild = "-";
}
if (!$character->is_archiv()) {
$ranking = array(array('rankingtype' => 'g', 'leveltype' => 'levelsum', 'level' => $character->data['levelsum']), array('rankingtype' => 's', 'leveltype' => 'levelsea', 'level' => $character->data['levelsea']), array('rankingtype' => 'l', 'leveltype' => 'levelland', 'level' => $character->data['levelland']));
$rankingresults = array('local' => array(), 'global' => array());
//global ranking
foreach ($ranking as $s) {
if (!($result = MYSQL_FETCH_ARRAY(MYSQL_QUERY("SELECT rank, lastupdated from flobase_character_ranking_global WHERE type='{$s['rankingtype']}' AND level='{$s['level']}'"))) or $result['lastupdated'] < bcsub(date("U"), 60 * 60 * 24)) {
list($result) = MYSQL_FETCH_ARRAY(MYSQL_QUERY("SELECT COUNT(characterid) FROM flobase_character_data WHERE {$s['leveltype']}>'{$s['level']}'"));
$result++;
$rankingresults['global'][$s['leveltype']] = $result;
MYSQL_QUERY("REPLACE INTO flobase_character_ranking_global (type, level, rank, lastupdated) VALUES('{$s['rankingtype']}', '{$s['level']}', '{$result}', '" . date("U") . "')");
} else {
$rankingresults['global'][$s['leveltype']] = $result['rank'];
}
}
//local ranking
foreach ($ranking as $s) {
