Notice: Undefined index: language in /var/www/erevtools.com/public_html/config.php on line 21
eRevTools - Military Unit
".getmu($_GET["muid"])."
"; ?>
"; $query = "SELECT a.playerid, c.name, sum(case when b.regiontypeid = 0 then a.damage else 0 end) as landdmg, sum(case when b.regiontypeid = 1 then a.damage else 0 end) as coastaldmg, sum(case when b.regiontypeid = 0 then a.hits else 0 end) as landhits, sum(case when b.regiontypeid = 1 then a.hits else 0 end) as coastalhits FROM wars_playersdamage a, wars b, players c where a.playerid = c.playerid and a.warid = b.warid and a.muid = ".$_GET["muid"]." and a.playerid = ".$row['playerid']." and b.date >= '".date('Y-m-d H:i:s', strtotime(date('Y-m-d H:i:s')) - (7*24*60*60))."' group by a.playerid, c.name"; $result2 = mysql_query($query); $numrows = mysql_num_rows($result2); while ($row2 = mysql_fetch_array($result2)) { echo ""; $totallanddmg = $totallanddmg + $row2["landdmg"]; $totalcoastaldmg = $totalcoastaldmg + $row2["coastaldmg"]; } mysql_free_result($result2); if ($numrows == 0) { echo ""; } $totallanddmg1hit = $totallanddmg1hit + $row["damage"]; $totalplayers++; echo ""; } mysql_free_result($result); echo ""; // echo ""; ?>
eRev IDNameLevelStrengthIntelligenceCountryMilitary RankNavy RankLand Damage (1 hit)Land Damage (Last 7 days)Land Hits (Last 7 days)Navy Damage (1 hit)Navy Damage (Last 7 days)Navy Hits (Last 7 days)Last SeenLast Update
".$row["playerid"]."".$row["name"]."".$row["level"]."".$row["strength"]."".$row["intelligence"]."".$row["militaryrank"]." - ".getrank($row["militaryrank"])."".$row["navyrank"]." - ".getnavyrank($row["navyrank"])."".number_format($row["damage"], 0, '.', ',')."".number_format($row2["landdmg"], 0, '.', ',')."".number_format($row2["landhits"], 0, '.', ',')."".number_format($row["navydmg1hit"], 0, '.', ',')."".number_format($row2["coastaldmg"], 0, '.', ',')."".number_format($row2["coastalhits"], 0, '.', ',')."00".number_format($row["navydmg1hit"], 0, '.', ',')."00".$row["lastseen"]."".$row["lastupdate"]."
Total".number_format($totalplayers, 0, '.', ',')."".number_format($totallanddmg1hit, 0, '.', ',')."".number_format($totallanddmg, 0, '.', ',')."".number_format($totalcoastaldmg, 0, '.', ',')."