$jobs = readjobs();
$skills = readskills();
$Rank = array("Civilian", "Private", "Corporal", "Sergeant", "Master Sergeant", "Sergeant Major", "Knight", "Knight Lieutenant", "Knight Captain", "Knight Champion", "Lieutenant Commander", "Commander", "Marshal", "Field Marshal", "Grand Marshal");
function calc_rank($score)
{
$result = intval($score / 270);
if ($result > 14) {
$result = 14;
} else {
if ($result < 0) {
$result = 0;
}
}
return $result;
}
$post = calc_rank($data['score']);
$emblems[$data['guild_id']] = $data['emblem_data'];
$_SESSION[$CONFIG['Name'] . 'emblems'] = $emblems;
$bgs = array('bat_a01' => 'Tierra George', 'bat_a02' => '<font color="#4169E1">Tierra EoS</font>', 'bat_a03' => '<font color="#483D8B">Tierra Bossnia</font>', 'region_8' => '<font color="#696969">Tierra TI</font>', 'bat_b01' => 'Flavius', 'bat_b02' => '<font color="#A0522D">Flavius CTF</font>', 'bat_b03' => '<font color="#808000">Flavius TDM</font>', 'bat_b04' => '<font color="#9ACD32">Flavius SC</font>', 'bat_c01' => 'KvM 5vs5', 'bat_c02' => 'KvM 5vs5', 'bat_c03' => 'KvM 12vs12', 'bat_c04' => 'Duel Arena', 'schg_cas06' => '<font color="#FFA500">Castle Conquest</font>', 'schg_cas07' => '<font color="#FFA500">Castle Conquest</font>', 'schg_cas08' => '<font color="#FFA500">Castle Conquest</font>', 'arug_cas06' => '<font color="#FFA500">Castle Conquest</font>', 'arug_cas07' => '<font color="#FFA500">Castle Conquest</font>', 'arug_cas08' => '<font color="#FFA500">Castle Conquest</font>', 'rush_cas01' => '<font color="#DDA0DD">Castle Rush</font>', 'rush_cas02' => '<font color="#DDA0DD">Castle Rush</font>', 'rush_cas03' => '<font color="#DDA0DD">Castle Rush</font>', 'rush_cas04' => '<font color="#DDA0DD">Castle Rush</font>');
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>
Gaia Renewal - Character Battleground Profile
</title>
<link rel="stylesheet" type="text/css" href="./gaiaro.css">
<script type="text/javascript" language="javascript" src="gaiaro.js"></script>
</head>
<BODY style="margin-top:0; margin-bottom:0" background="world.jpg">
default:
$query = sprintf(PK_LADDER_JOB, $_GET['opt'], $SortType[$_GET['ser']], $SortOrder[$_GET['ord']]);
break;
}
if (isset($jobs[$_GET['opt']])) {
$string = $jobs[$_GET['opt']];
} else {
$string = "Unknown";
}
}
$result = $mysql->query($query, $CONFIG['DBMain']);
$count = 0;
while ($char = $mysql->fetcharray($result)) {
$count++;
$emblems[$char['guild_id']] = $char['emblem_data'];
$post = calc_rank($char['score']);
echo '
<table witdh="580" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFC300">
<tr>
<td>
<table width="580" border="0" cellpadding="0" cellspacing="0" bgcolor="#A92207">
<tr>
<td width="36" height="36" rowspan="2" align="center" valign="middle">
<img src="emblema.php?data=' . $char['guild_id'] . '" alt=".">
</td>
<td>
<font color="#FFFFFF" size="3"><b>' . htmlformat($char['name']) . '<b></font>
</td>
<td width="150" align="right" valign="middle">
<font size="3" color="#FFFFFF"><b>' . $count . '<b></font>
</td>
$_GET['ser'] = 0;
}
if ($_GET['opt'] == 0) {
// All Castles
$query = "\r\n\t\t\tSELECT\r\n\t\t\t\t`g`.`name`, `g`.`master`, `g`.`emblem_data`, `gr`.*\r\n\t\t\tFROM\r\n\t\t\t\t`guild` `g`, `guild_rank` `gr`, (\r\n\t\t\t\t\tSELECT\r\n\t\t\t\t\t\t`castle_id`, MAX(`" . $SortType[$_GET['ser']] . "`) AS `t" . $SortType[$_GET['ser']] . "`\r\n\t\t\t\t\tFROM\r\n\t\t\t\t\t\t`guild_rank`\r\n\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t" . ($_GET['ser'] != 1 ? "`" . $SortType[$_GET['ser']] . "` > 0" : "`off_kill` + `def_kill` + `ext_kill` + `ali_kill` > 100") . "\r\n\t\t\t\t\tGROUP BY\r\n\t\t\t\t\t\t`castle_id`\r\n\t\t\t\t) `tgr`\r\n\t\t\tWHERE\r\n\t\t\t\t`g`.`guild_id` = `gr`.`guild_id` AND `gr`.`castle_id` = `tgr`.`castle_id` AND `gr`.`" . $SortType[$_GET['ser']] . "` = `tgr`.`t" . $SortType[$_GET['ser']] . "`\r\n\t\t\tORDER BY\r\n\t\t\t\t`gr`.`castle_id` DESC\r\n\t\t";
} else {
// Per Castle - Top 25
$castle_id = $_GET['opt'] - 1;
$query = "\r\n\t\t\tSELECT\r\n\t\t\t\t`guild`.`name`, `guild`.`master`, `guild`.`emblem_data`, `guild_rank`.*\r\n\t\t\tFROM\r\n\t\t\t\t`guild` LEFT JOIN `guild_rank` ON `guild_rank`.`guild_id` = `guild`.`guild_id`\r\n\t\t\tWHERE\r\n\t\t\t\t`guild_rank`.`castle_id` = '{$castle_id}' AND \r\n\t\t\t\t" . ($_GET['ser'] != 1 ? "`guild_rank`.`" . $SortType[$_GET['ser']] . "` > 0" : "`guild_rank`.`off_kill` + `guild_rank`.`def_kill` + `guild_rank`.`ext_kill` + `guild_rank`.`ali_kill` > 100 ") . "\r\n\t\t\tORDER BY\r\n\t\t\t\t`guild_rank`.`" . $SortType[$_GET['ser']] . "` DESC\r\n\t\t\tLIMIT 25\r\n\t\t";
}
$mydata = $mysql->query($query, $CONFIG['DBMain']);
$castle_id = -1;
/* Build Data */
while ($data = $mysql->fetcharray($mydata)) {
$emblems[$data['guild_id']] = $data['emblem_data'];
$post = calc_rank($data['offensive_score']);
if ($castle_id != $data['castle_id']) {
// Post Image
echo '<center><img src="./images/castle_icon.jpg"><br>
<font size="2" color="#47bcff"><b>~ ' . $castles[$data['castle_id']] . ' ~<b></font><br><br></center>';
$castle_id = $data['castle_id'];
}
echo '
<table witdh="580" border="1" cellpadding="0" cellspacing="0" bordercolor="#c4c4c4">
<tr>
<td>
<table width="580" border="0" cellpadding="0" cellspacing="0" bgcolor="#919191">
<tr>
<td width="36" height="36" rowspan="2" align="center" valign="middle">
<img src="emblema.php?data=' . $data['guild_id'] . '" alt=".">
</td>
