$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>