$sitetext[gobackdate]: EOF; for($y=1;$y<$num;$y++) { $date = mysql_result($sql, $y, "time"); echo <<$date EOF; } $sql = mysql_query("SELECT * FROM clanranking WHERE `server` = '$server' ORDER BY `time` DESC, `rank` ASC LIMIT 100"); echo << EOF; $last_grade = 6; $last_rank = 6; $num = mysql_num_rows($sql); for($y=0;$y<$num;$y++) { if (($y % 2) == 1) $dark = "class=nicetd"; else $dark = ""; mysql_data_seek($sql, $y); $row = mysql_fetch_array($sql); $np = number_format($row[np]); $subsql = mysql_query("SELECT grade, rank, id FROM clanranks WHERE server = '$server' AND name = '$row[name]'"); if (mysql_num_rows($subsql) == 1) { $grade = mysql_result($subsql, 0, "grade"); $rank = mysql_result($subsql, 0, "rank"); $clanid = mysql_result($subsql, 0, "id"); $link = "/claninfo.php?server=$server&id=$clanid"; $link = "$row[name]"; if ($rank == 2) $grade = 11 - $grade; elseif ($rank == 3) $grade = 16 - $grade; $nationsql = mysql_query("SELECT nation FROM survey WHERE server = '$server' AND clan_id = '$clanid' LIMIT 1"); if (mysql_num_rows($nationsql)) $nation = mysql_result($nationsql, 0, "nation"); else $nation = 1; $nationpic = ""; $gradepic = ""; } else { $gradepic = " "; $nationpic = " "; $link = $row["name"]; } echo << EOF; } echo << EOF; show_footer(); ?>

$sitetext[rank]			$sitetext[name]	$sitetext[np]
$nationpic	$gradepic	$row[rank]	$link	$np