if ($_GET["battleid"] == "") {
header("Location: battles.php");
}
?>
getbattledamagefromerev($_GET["battleid"]);
$query = "select * from wars where warid = ".$_GET["battleid"];
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) {
$query = "select * from wars where ((attacker = '".$row['attacker']."' and defender = '".$row['defender']."') or (attacker = '".$row['defender']."' and defender = '".$row['attacker']."')) and status = 'I'";
$result2 = mysql_query($query);
$won = 0;
$lost = 0;
while ($row2 = mysql_fetch_array($result2)) {
if ($row2['finalownerid'] == $row['attackerid']) {
$won++;
}
else {
$lost++;
}
}
mysql_free_result($result2);
$total = $won+$lost;
$query = "select side, sum(damage) as damage, sum(hits) as hits, count(*) as players from wars_playersdamage where warid = ".$row['warid']." group by side";
$result2 = mysql_query($query);
$attackdamage = 0;
$attackhits = 0;
$attackplayers = 0;
$defensedamage = 0;
$defensehits = 0;
$defenseplayers =0;
while ($row2 = mysql_fetch_array($result2)) {
if ($row2['side'] == "attack") {
$attackdamage = $row2['damage'];
$attackhits = $row2['hits'];
$attackplayers = $row2['players'];
}
else {
$defensedamage = $row2['damage'];
$defensehits = $row2['hits'];
$defenseplayers = $row2['players'];
}
}
mysql_free_result($result2);
echo "
"; $dateini = strtotime($row['date']); $date = strtotime(date('Y-m-d H:i:s')); if ($row['status'] == "A") { $diff = 86400 - ($date - ($dateini + ($gmt*60*60))); if ($diff < 0) { $diff = 0; } echo "Region: ".$row['region']."
Battle ID: ".$row['warid']."
Battle countdown: ".strftime('%H:%M:%S', $diff)."
"; } else { echo "Region: ".$row['region']."
Battle ID: ".$row['warid']."
"; } echo "
Battle start time: ".date('Y-m-d H:i:s', $dateini)."
Battle Type: ".$row['type']; $total2 = 0; $i = 1; $msg = ""; $query = "select if(defenderid = finalownerid, defender, attacker) as country, count(*) as total from wars where region = '".$row['region']."' and status = 'I' and date <= '".$row['date']."' group by country order by total desc"; $result2 = mysql_query($query); while ($row2 = mysql_fetch_array($result2)) { if ($i < 4) { $msg = $msg.$row2['country']." (".$row2['total'].") "; } $i++; $total2 = $total2 + $row2['total']; } mysql_free_result($result2); echo "
Battles in this region: ".$total2."
Past winnners: ".$msg; echo "";
?>
";
if ($row["status"] == 'A') {
if ($row["val"] > 0) { // Defender is the winner
echo "
";
}
else {
echo "
";
}
}
else {
if ($row["defenderid"] == $row["finalownerid"]) { // Defender is the winner
echo "
";
}
else {
echo "
";
}
}
echo "
".$row['attacker']."
Total Damage: ".number_format($attackdamage, 0, '.', ',')."
Total Hits: ".$attackhits."
Total Players: ".$attackplayers."
".$row['attacker']." victories against ".$row['defender'].": ".$won."/".$total."
".$row['attacker']."
Total Damage: ".number_format($attackdamage, 0, '.', ',')."
Total Hits: ".$attackhits."
Total Players: ".$attackplayers."
".$row['attacker']." victories against ".$row['defender'].": ".$won."/".$total."
"; $dateini = strtotime($row['date']); $date = strtotime(date('Y-m-d H:i:s')); if ($row['status'] == "A") { $diff = 86400 - ($date - ($dateini + ($gmt*60*60))); if ($diff < 0) { $diff = 0; } echo "Region: ".$row['region']."
Battle ID: ".$row['warid']."
Battle countdown: ".strftime('%H:%M:%S', $diff)."
"; } else { echo "Region: ".$row['region']."
Battle ID: ".$row['warid']."
"; } echo "
Battle start time: ".date('Y-m-d H:i:s', $dateini)."
Battle Type: ".$row['type']; $total2 = 0; $i = 1; $msg = ""; $query = "select if(defenderid = finalownerid, defender, attacker) as country, count(*) as total from wars where region = '".$row['region']."' and status = 'I' and date <= '".$row['date']."' group by country order by total desc"; $result2 = mysql_query($query); while ($row2 = mysql_fetch_array($result2)) { if ($i < 4) { $msg = $msg.$row2['country']." (".$row2['total'].") "; } $i++; $total2 = $total2 + $row2['total']; } mysql_free_result($result2); echo "
Battles in this region: ".$total2."
Past winnners: ".$msg; echo "
";
if ($row["status"] == 'A') {
if ($row["val"] > 0) { // Defender is the winner
echo "
";
}
else {
echo "
";
}
}
else {
if ($row["defenderid"] == $row["finalownerid"]) { // Defender is the winner
echo "
";
}
else {
echo "
";
}
}
echo "
".$row['defender']."
Total Damage: ".number_format($defensedamage, 0, '.', ',')."
Total Hits: ".$defensehits."
Total Players: ".$defenseplayers."
".$row['defender']." victories against ".$row['attacker'].": ".$lost."/".$total."
";
}
mysql_free_result($result);
echo "".$row['defender']."
Total Damage: ".number_format($defensedamage, 0, '.', ',')."
Total Hits: ".$defensehits."
Total Players: ".$defenseplayers."
".$row['defender']." victories against ".$row['attacker'].": ".$lost."/".$total."
echo "";
$i = 1;
$query = "select b.playerid, b.name, a.hits, a.damage, a.countryid from wars_playersdamage a, players b where a.playerid = b.playerid and a.warid = ".$_GET['battleid']." and a.side = 'attack' order by damage desc";
$result2 = mysql_query($query);
while ($row2 = mysql_fetch_array($result2)) {
echo "
";
echo "";
$i = 1;
$query = "select b.playerid, b.name, a.hits, a.damage, a.countryid from wars_playersdamage a, players b where a.playerid = b.playerid and a.warid = ".$_GET['battleid']." and a.side = 'defense' order by damage desc";
$result2 = mysql_query($query);
while ($row2 = mysql_fetch_array($result2)) {
echo "
";
echo "";
?>
".$i." | ![]() | ".$row2["name"]." | ".number_format($row2["hits"], 0, '.', ',')." | ".number_format($row2["damage"], 0, '.', ',')." |
".$i." | ![]() | ".$row2["name"]." | ".number_format($row2["hits"], 0, '.', ',')." | ".number_format($row2["damage"], 0, '.', ',')." |