<?php
   $fp = mysql_connect("","","");
   mysql_select_db("vendetta_online");
   $query = "SELECT * FROM user_tracker WHERE nation='Itani'";
   $result = mysql_query($query);
   $Itani = mysql_num_rows($result);
   $query = "SELECT * FROM user_tracker WHERE nation='Serco'";
   $result = mysql_query($query);
   $Serco = mysql_num_rows($result);
   $query = "SELECT * FROM user_tracker WHERE nation='UIT'";
   $result = mysql_query($query);
   $UIT = mysql_num_rows($result);
   $query = "SELECT * FROM user_tracker WHERE nation='unaligned'";
   $result = mysql_query($query);
   $unaligned = mysql_num_rows($result);
   $query = "SELECT * FROM user_tracker";
   $result = mysql_query($query);
   $total = mysql_num_rows($result);
  
   $now = new DateTime();
   $today = $now->format("Y-m-d h:m:s");
   $now->modify("-1 day");
   $yesterday = $now->format("Y-m-d h:m:s");
   $now->modify("-1 week");
   $week = $now->format("Y-m-d h:m:s");

   $query = sprintf("SELECT user FROM user_tracker WHERE seen BETWEEN '%s' AND '%s'",$yesterday,$today);
   $result = mysql_query($query);

   $daily = mysql_num_rows($result);

   $query = sprintf("SELECT user FROM user_tracker WHERE seen BETWEEN '%s' AND '%s'",$week,$today);
   $result = mysql_query($query);

   $weekly = mysql_num_rows($result);   
   
   $query = "SELECT users FROM `user_growth` ORDER BY id DESC LIMIT 7";
   $result = mysql_query($query);

   $previous = 0;
   $average = 0;
   while ($row = mysql_fetch_assoc($result)) {
       if ($previous != 0) {
          $average += ($previous - (int) $row["users"] );
          $previous = (int) $row["users"];
       } else {
          $previous = (int) $row["users"];
       }  
   }
   $average = $average / 7;
   
   echo "Itani: " . $Itani . "\nSerco: " . $Serco . "\nUIT: " . $UIT . "\nUnaligned: " . $unaligned . "\n";
   echo "Total: " . $total . "\n" ;
   echo "Daily: " . $daily . "/" . $total . " \nWeekly: " . $weekly . "/" . $total . "\n";
   echo "New users per day: " . round($average) . "\n\n"; 

 
   mysql_close($fp);
   
?>