Total Players : echo $count[0]; ?>
Total XP : echo $totalxp; ?>
Total Kills : echo $kills[0]; ?>
Total Suicides : echo $suicides[0]; ?>
Total Playtime : echo $totaltime;?> |
|
|
|
if ($dbinfo["canyonStrogg"]+$dbinfo["canyonGDF"] == 0)
{
$avgtime = 0;
}
else
{
$avgtime = $dbinfo["canyonTime"]/($dbinfo["canyonStrogg"]+$dbinfo["canyonGDF"]);
}
if ($kills[0] == 0){$kills[0] = 1;}
$sec = $avgtime % 60;
$min = $avgtime / 60;
$min = (int)$min;
$avgtime = sprintf("%02dm %02ds",$min,$sec);
$result2 = mysql_query("Select COUNT(*) FROM ". $TablePrefix ."weapons Where map='canyon'");
$mapkills = mysql_fetch_row($result2);
$pertotal = $mapkills[0] / $kills[0] * 100;
$pertotal = sprintf("%.1f%%",$pertotal);
?>
Kills : echo $mapkills[0]." (". $pertotal .")";?>
GDF Wins : echo $dbinfo["canyonGDF"]; ?>
Strogg Wins : echo $dbinfo["canyonStrogg"]; ?>
Avg Map Time : echo $avgtime; ?> |
|
|
if ($dbinfo["sewerStrogg"]+$dbinfo["sewerGDF"] == 0)
{
$avgtime = 0;
}
else
{
$avgtime = $dbinfo["sewerTime"]/($dbinfo["sewerStrogg"]+$dbinfo["sewerGDF"]);
}
$sec = $avgtime % 60;
$min = $avgtime / 60;
$min = (int)$min;
$avgtime = sprintf("%02dm %02ds",$min,$sec);
$result2 = mysql_query("Select COUNT(*) FROM ". $TablePrefix ."weapons Where map='sewer'");
$mapkills = mysql_fetch_row($result2);
$pertotal = $mapkills[0] / $kills[0] * 100;
$pertotal = sprintf("%.1f%%",$pertotal);
?>
Kills : echo $mapkills[0]." (". $pertotal .")";?>
GDF Wins : echo $dbinfo["sewerGDF"]; ?>
Strogg Wins : echo $dbinfo["sewerStrogg"]; ?>
Avg Map Time : echo $avgtime; ?> |
|
|
if ($dbinfo["volcanoStrogg"]+$dbinfo["volcanoGDF"] == 0)
{
$avgtime = 0;
}
else
{
$avgtime = $dbinfo["volcanoTime"]/($dbinfo["volcanoStrogg"]+$dbinfo["volcanoGDF"]);
}
$sec = $avgtime % 60;
$min = $avgtime / 60;
$min = (int)$min;
$avgtime = sprintf("%02dm %02ds",$min,$sec);
$result2 = mysql_query("Select COUNT(*) FROM ". $TablePrefix ."weapons Where map='volcano'");
$mapkills = mysql_fetch_row($result2);
$pertotal = $mapkills[0] / $kills[0] * 100;
$pertotal = sprintf("%.1f%%",$pertotal);
?>
Kills : echo $mapkills[0]." (". $pertotal .")";?>
GDF Wins : echo $dbinfo["volcanoGDF"]; ?>
Strogg Wins : echo $dbinfo["volcanoStrogg"]; ?>
Avg Map Time : echo $avgtime; ?> |
|
|
|
if ($dbinfo["quarryStrogg"]+$dbinfo["quarryGDF"] == 0)
{
$avgtime = 0;
}
else
{
$avgtime = $dbinfo["quarryTime"]/($dbinfo["quarryStrogg"]+$dbinfo["quarryGDF"]);
}
$sec = $avgtime % 60;
$min = $avgtime / 60;
$min = (int)$min;
$avgtime = sprintf("%02dm %02ds",$min,$sec);
$result2 = mysql_query("Select COUNT(*) FROM ". $TablePrefix ."weapons Where map='quarry'");
$mapkills = mysql_fetch_row($result2);
$pertotal = $mapkills[0] / $kills[0] * 100;
$pertotal = sprintf("%.1f%%",$pertotal);
?>
Kills : echo $mapkills[0]." (". $pertotal .")";?>
GDF Wins : echo $dbinfo["quarryGDF"]; ?>
Strogg Wins : echo $dbinfo["quarryStrogg"]; ?>
Avg Map Time : echo $avgtime; ?> |
|
|
if ($dbinfo["arkStrogg"]+$dbinfo["arkGDF"] == 0)
{
$avgtime = 0;
}
else
{
$avgtime = $dbinfo["arkTime"]/($dbinfo["arkStrogg"]+$dbinfo["arkGDF"]);
}
$sec = $avgtime % 60;
$min = $avgtime / 60;
$min = (int)$min;
$avgtime = sprintf("%02dm %02ds",$min,$sec);
$result2 = mysql_query("Select COUNT(*) FROM ". $TablePrefix ."weapons Where map='ark'");
$mapkills = mysql_fetch_row($result2);
$pertotal = $mapkills[0] / $kills[0] * 100;
$pertotal = sprintf("%.1f%%",$pertotal);
?>
Kills : echo $mapkills[0]." (". $pertotal .")";?>
GDF Wins : echo $dbinfo["arkGDF"]; ?>
Strogg Wins : echo $dbinfo["arkStrogg"]; ?>
Avg Map Time : echo $avgtime; ?> |
|
|
if ($dbinfo["salvageStrogg"]+$dbinfo["salvageGDF"] == 0)
{
$avgtime = 0;
}
else
{
$avgtime = $dbinfo["salvageTime"]/($dbinfo["salvageStrogg"]+$dbinfo["salvageGDF"]);
}
$sec = $avgtime % 60;
$min = $avgtime / 60;
$min = (int)$min;
$avgtime = sprintf("%02dm %02ds",$min,$sec);
$result2 = mysql_query("Select COUNT(*) FROM ". $TablePrefix ."weapons Where map='salvage'");
$mapkills = mysql_fetch_row($result2);
$pertotal = $mapkills[0] / $kills[0] * 100;
$pertotal = sprintf("%.1f%%",$pertotal);
?>
Kills : echo $mapkills[0]." (". $pertotal .")";?>
GDF Wins : echo $dbinfo["salvageGDF"]; ?>
Strogg Wins : echo $dbinfo["salvageStrogg"]; ?>
Avg Map Time : echo $avgtime; ?> |
|
|
|
if ($dbinfo["ValleyStrogg"]+$dbinfo["ValleyGDF"] == 0)
{
$avgtime = 0;
}
else
{
$avgtime = $dbinfo["ValleyTime"]/($dbinfo["ValleyStrogg"]+$dbinfo["ValleyGDF"]);
}
$sec = $avgtime % 60;
$min = $avgtime / 60;
$min = (int)$min;
$avgtime = sprintf("%02dm %02ds",$min,$sec);
$result2 = mysql_query("Select COUNT(*) FROM ". $TablePrefix ."weapons Where map='valley'");
$mapkills = mysql_fetch_row($result2);
$pertotal = $mapkills[0] / $kills[0] * 100;
$pertotal = sprintf("%.1f%%",$pertotal);
?>
Kills : echo $mapkills[0]." (". $pertotal .")";?>
GDF Wins : echo $dbinfo["ValleyGDF"]; ?>
Strogg Wins : echo $dbinfo["ValleyStrogg"]; ?>
Avg Map Time : echo $avgtime; ?> |
|
|
if ($dbinfo["outskirtsStrogg"]+$dbinfo["outskirtsGDF"] == 0)
{
$avgtime = 0;
}
else
{
$avgtime = $dbinfo["outskirtsTime"]/($dbinfo["outskirtsStrogg"]+$dbinfo["outskirtsGDF"]);
}
$sec = $avgtime % 60;
$min = $avgtime / 60;
$min = (int)$min;
$avgtime = sprintf("%02dm %02ds",$min,$sec);
$result2 = mysql_query("Select COUNT(*) FROM ". $TablePrefix ."weapons Where map='outskirts'");
$mapkills = mysql_fetch_row($result2);
$pertotal = $mapkills[0] / $kills[0] * 100;
$pertotal = sprintf("%.1f%%",$pertotal);
?>
Kills : echo $mapkills[0]." (". $pertotal .")";?>
GDF Wins : echo $dbinfo["outskirtsGDF"]; ?>
Strogg Wins : echo $dbinfo["outskirtsStrogg"]; ?>
Average Map Time : echo $avgtime; ?> |
|
|
if ($dbinfo["area22Strogg"]+$dbinfo["area22GDF"] == 0)
{
$avgtime = 0;
}
else
{
$avgtime = $dbinfo["area22Time"]/($dbinfo["area22Strogg"]+$dbinfo["area22GDF"]);
}
$sec = $avgtime % 60;
$min = $avgtime / 60;
$min = (int)$min;
$avgtime = sprintf("%02dm %02ds",$min,$sec);
$result2 = mysql_query("Select COUNT(*) FROM ". $TablePrefix ."weapons Where map='area22'");
$mapkills = mysql_fetch_row($result2);
$pertotal = $mapkills[0] / $kills[0] * 100;
$pertotal = sprintf("%.1f%%",$pertotal);
?>
Kills : echo $mapkills[0]." (". $pertotal .")";?>
GDF Wins : echo $dbinfo["area22GDF"]; ?>
Strogg Wins : echo $dbinfo["area22Strogg"]; ?>
Average Map Time : echo $avgtime; ?> |
|
|
|
if ($dbinfo["refineryStrogg"]+$dbinfo["refineryGDF"] == 0)
{
$avgtime = 0;
}
else
{
$avgtime = $dbinfo["refineryTime"]/($dbinfo["refineryStrogg"]+$dbinfo["refineryGDF"]);
}
$sec = $avgtime % 60;
$min = $avgtime / 60;
$min = (int)$min;
$avgtime = sprintf("%02dm %02ds",$min,$sec);
$result2 = mysql_query("Select COUNT(*) FROM ". $TablePrefix ."weapons Where map='refinery'");
$mapkills = mysql_fetch_row($result2);
$pertotal = $mapkills[0] / $kills[0] * 100;
$pertotal = sprintf("%.1f%%",$pertotal);
?>
Kills : echo $mapkills[0]." (". $pertotal .")";?>
GDF Wins : echo $dbinfo["refineryGDF"]; ?>
Strogg Wins : echo $dbinfo["refineryStrogg"]; ?>
Average Map Time : echo $avgtime; ?> |
|
|
if ($dbinfo["slipgateStrogg"]+$dbinfo["slipgateGDF"] == 0)
{
$avgtime = 0;
}
else
{
$avgtime = $dbinfo["slipgateTime"]/($dbinfo["slipgateStrogg"]+$dbinfo["slipgateGDF"]);
}
$sec = $avgtime % 60;
$min = $avgtime / 60;
$min = (int)$min;
$avgtime = sprintf("%02dm %02ds",$min,$sec);
$result2 = mysql_query("Select COUNT(*) FROM ". $TablePrefix ."weapons Where map='slipgate'");
$mapkills = mysql_fetch_row($result2);
$pertotal = $mapkills[0] / $kills[0] * 100;
$pertotal = sprintf("%.1f%%",$pertotal);
?>
Kills : echo $mapkills[0]." (". $pertotal .")";?>
GDF Wins : echo $dbinfo["slipgateGDF"]; ?>
Strogg Wins : echo $dbinfo["slipgateStrogg"]; ?>
Average Map Time : echo $avgtime; ?> |
|
|
if ($dbinfo["islandStrogg"]+$dbinfo["islandGDF"] == 0)
{
$avgtime = 0;
}
else
{
$avgtime = $dbinfo["islandTime"]/($dbinfo["islandStrogg"]+$dbinfo["islandGDF"]);
}
$sec = $avgtime % 60;
$min = $avgtime / 60;
$min = (int)$min;
$avgtime = sprintf("%02dm %02ds",$min,$sec);
$result2 = mysql_query("Select COUNT(*) FROM ". $TablePrefix ."weapons Where map='island'");
$mapkills = mysql_fetch_row($result2);
$pertotal = $mapkills[0] / $kills[0] * 100;
$pertotal = sprintf("%.1f%%",$pertotal);
?>
Kills : echo $mapkills[0]." (". $pertotal .")";?>
GDF Wins : echo $dbinfo["islandGDF"]; ?>
Strogg Wins : echo $dbinfo["islandStrogg"]; ?>
Average Map Time : echo $avgtime; ?> |
|
|
|
Top 20 by Time Played (No Bots) |
$result = mysql_query("Select id,name,PlayTime,TotalMaps,TotalWins,Rank FROM ". $TablePrefix ."player WHERE IsBot=2 ORDER BY PlayTime DESC LIMIT 20");
$CRow = "Textback";
$numrows = mysql_num_rows($result);
for($i=0;$i<$numrows;$i++)
{
if ($CRow == "Textback")
{
$CRow = "Text";
}
else
{
$CRow = "Textback";
}
$player = mysql_fetch_array($result,MYSQL_ASSOC);
$sec = $player[PlayTime] % 60;
$min = $player[PlayTime] / 60;
$min = (int)$min;
if ($min > 60)
{
$hour = $min / 60;
$hour = (int)$hour;
$min = $min % 60;
}
else
{
$hour = "0";
}
if ($hour > 0)
{
$ptime = sprintf("%1dh %02dm %02ds",$hour,$min,$sec);
}
else
{
$ptime = sprintf("%02dm %02ds",$min,$sec);
}
$Rank = RankName($player[Rank]);
echo " ";
echo " $player[name] | ";
echo " [View Stats] | ";
echo " $ptime | ";
echo " $player[TotalMaps] | ";
echo " $player[TotalWins] | ";
echo " $Rank | ";
echo " | ";
echo " | ";
echo " ";
}
?>
|
|