rendered paste body<?phprequire('config.php');$extra_string = "pos1,pos2,pos3";$ruler = "pureone";if($_GET['user']) {$ruler = $_GET['user'];$url_string = "&user=$ruler";}switch($_GET['sort']) {case cords: $string = "ORDER BY pos1,pos2,pos3"; break;case name: $string = "ORDER BY name,$extra_string"; break;case stt: $string = "ORDER BY stt DESC,$extra_string"; break;case sp: $string = "ORDER BY sp DESC,$extra_string"; break;case arc: $string = "ORDER BY arc DESC,$extra_string"; break;case lws: $string = "ORDER BY lws DESC,$extra_string"; break;case sws: $string = "ORDER BY sws DESC,$extra_string"; break;case lms: $string = "ORDER BY lms DESC,$extra_string"; break;case sms: $string = "ORDER BY sms DESC,$extra_string"; break;case cat: $string = "ORDER BY cat DESC,$extra_string"; break;case cs: $string = "ORDER BY coly DESC,$extra_string"; break; }switch($_GET['sort_limit']) {case cords: $string = "ORDER BY pos1,pos2,pos3"; break;case name: $string = "ORDER BY name,$extra_string"; break;case stt: $string = "AND stt > 0 ORDER BY pos1,pos2,pos3"; break;case sp: $string = "AND sp > 0 ORDER BY pos1,pos2,pos3"; break;case arc: $string = "AND arc > 0 ORDER BY pos1,pos2,pos3"; break;case lws: $string = "AND lws > 0 ORDER BY pos1,pos2,pos3"; break;case sws: $string = "AND sws > 0 ORDER BY pos1,pos2,pos3"; break;case lms: $string = "AND lms > 0 ORDER BY pos1,pos2,pos3"; break;case sms: $string = "AND sms > 0 ORDER BY pos1,pos2,pos3"; break;case cat: $string = "AND cat > 0 ORDER BY pos1,pos2,pos3"; break;case cs: $string = "AND coly > 0 ORDER BY pos1,pos2,pos3"; break; }$query = mysql_query("SELECT * FROM `isles` $string ") or die(mysql_error());/*if($_GET['action'] == "src") { highlight_file("index.php"); exit; }*/echo "<table width=\"900\" border=\"0\" cellspacing=\"2\" cellpadding=\"2\"><tr bgcolor=\"#CACACA\"><td></td><td colspan=\"9\"></td></tr><tr bgcolor=\"#CACACA\"><td><a href=\"?sort=cords$url_string\">Isle</a> <a href=\"?sort=name$url_string\"> Name</a></td><td><a href=\"?sort=stt$url_string\">ST</a></td><td><a href=\"?sort=sp$url_string\">SF</a></td><td><a href=\"?sort=arc$url_string\">AR</a></td><td><a href=\"?sort=lws$url_string\">LWS</a></td><td><a href=\"?sort=sws$url_string\">SWS</a></td><td><a href=\"?sort=lms$url_string\">LMS</a></td><td><a href=\"?sort=sms$url_string\">SMS</a></td><td><a href=\"?sort=cat$url_string\">Catapult</a></td><td><a href=\"?sort=cs$url_string\">CS</a></td></tr>";echo "<td></td><td><a href=\"?sort_limit=stt$url_string\">ST only</a></td><td><a href=\"?sort_limit=sp$url_string\">SF only</a></td><td><a href=\"?sort_limit=arc$url_string\">AR only</a></td><td><a href=\"?sort_limit=lws$url_string\">LWS only</a></td><td><a href=\"?sort_limit=sws$url_string\">SWS only</a></td><td><a href=\"?sort_limit=lms$url_string\">LMS only</a></td><td><a href=\"?sort_limit=sms$url_string\">SMS only</a></td><td><a href=\"?sort_limit=cat$url_string\">Catapult only</a></td><td><a href=\"?sort_limit=cs$url_string\">CS only</a> </td></tr>";$i = 0;$qry = mysql_query("SELECT SUM(stt) from `isles` $string");$qry = mysql_fetch_array($qry);$total_stt = $qry[0];$qry = mysql_query("SELECT SUM(sp) from `isles` $string");$qry = mysql_fetch_array($qry);$total_sp = $qry[0];$qry = mysql_query("SELECT SUM(arc) from `isles` $string");$qry = mysql_fetch_array($qry);$total_arc = $qry[0];$qry = mysql_query("SELECT SUM(lws) from `isles` $string");$qry = mysql_fetch_array($qry);$total_lws = $qry[0];$qry = mysql_query("SELECT SUM(sws) from `isles` $string");$qry = mysql_fetch_array($qry);$total_sws = $qry[0];$qry = mysql_query("SELECT SUM(lms) from `isles` $string");$qry = mysql_fetch_array($qry);$total_lms = $qry[0];$qry = mysql_query("SELECT SUM(sms) from `isles` $string");$qry = mysql_fetch_array($qry);$total_sms = $qry[0];$qry = mysql_query("SELECT SUM(cat) from `isles` $string");$qry = mysql_fetch_array($qry);$total_cat = $qry[0];$qry = mysql_query("SELECT SUM(coly) from `isles` $string");$qry = mysql_fetch_array($qry);$total_cs = $qry[0];$qry = mysql_query("SELECT COUNT(pos1) from `isles` $string");$qry = mysql_fetch_array($qry);$i = $qry[0];if ($i % 2 == 0 ) { $colour = "bgcolor=\"#E2E2E2\""; } else { $colour = "bgcolor=\"#F0F0F0\""; } echo "<tr $colour><td>Total isles: $i</td>"; echo "<td>$total_stt</td><td>$total_sp</td><td>$total_arc</td><td>$total_lws</td><td>$total_sws</td>"; echo "<td>$total_lms</td><td>$total_sms</td><td>$total_cat</td><td>$total_cs</td>"; echo "<tr bgcolor=\"#CACACA\"><td></td><td colspan=\"9\"></td></tr>";$i = 0;while($foo = mysql_fetch_array($query)) { if ($i % 2 == 0 ) { $colour = "bgcolor=\"#E2E2E2\""; } else { $colour = "bgcolor=\"#F0F0F0\""; } echo "<tr $colour><td>".$foo['name']." (".$foo['pos1'].":".$foo['pos2'].":".$foo['pos3'].")</td>"; echo "<td>".$foo['stt']."</td><td>".$foo['sp']."</td><td>".$foo['arc']."</td><td>".$foo['lws']."</td><td>".$foo['sws']." </td><td>".$foo['lms']."</td><td>".$foo['sms']."</td><td>".$foo['cat']."</td><td>".$foo['coly']."</td>"; $i++; }?>