// We need this function later, to convert from a MySQL DATETIME to our own date format

function ToDateTime($datestamp, $format)

{

   if ($datestamp!=0)

   {

      list($date, $time)=split(" ", $datestamp);

      list($year, $month, $day)=split("-", $date);

      list($hour, $minute, $second)=split(":", $time);

      $stampeddate=mktime($hour,$minute,$second,$month,$day,$year);

      $datestamp=date($format,$stampeddate);

      return $datestamp;

   }

}



// Get the values from the database, order by visitor IP so that we have them grouped by visitor

$LogQ = mysql_query("SELECT VisID, VisIP, VisRef, VisUrl, VisAgent, VisDate FROM logs ORDER BY VisIP");

echo "<table border='1' cellpadding='8'>";

echo "<tr>";

echo "<td align='center'><b>ID</b></td>";

echo "<td><b>IP</b></td>";

echo "<td><b>Host</b></td>";


echo "<td><b>URL</b></td>";

echo "<td><b>Referrer</b></td>";

echo "<td><b>User Agent</b></td>";

echo "<td><b>Date</b></td>";

echo "</tr>";

// Store the current date in a variable, in the Year-Day-Month format

$CurrDate = date("Y")."-".date("d")."-".date("m");

// Loop through the values in the database

while($LogF = mysql_fetch_array($LogQ))

{

   // Store the date of the visit in a variable

   $Date = $LogF['VisDate'];

   // Compare the current date to the date in the database

   //
if it matches we highlight the row since it means the visit was made recently

   if($CurrDate == ToDateTime($Date, "Y-d-m"))

   {

      $NewBGColor = "#FFD7D7";

   }   

   else

   {

      $NewBGColor = "";

   }

   // Reverse DNS

   $Host = gethostbyaddr($LogF['VisIP']);



      // Highlight visits from the same IP with the same color

   if($LogF['VisIP'] != $LastIP)

   {


      if($BGColor == "#FFFBEA")

      {

         $BGColor = "#FFF3CA";

      }

      else

      {

         $BGColor = "#FFFBEA";

      }

   }

   echo "<tr bgcolor='".$BGColor."'>";

   // Unique ID for the visitor

   echo "<td bgcolor='".$NewBGColor."'>".$LogF['VisID']."</td>";

   // Link the IP to a WhoIs service. If clicked you get more information about the IP

   echo "<td><a href='http://www.whois.sc/".$LogF['VisIP']."' target='_blank'>".$LogF['VisIP']."</a></td>";



   // If the reverse DNS function returns a domain containing microsoft.com, highlight with red

   if(strstr(strtolower($Host), "microsoft"))

   {

      echo "<td><font color='#CC0000'><b>".$Host."</b></font></td>";

   }

   // If it's my hostname (or IP since some IPs don't reverse DNS), use a distinct color

   else if($Host == "myhost.astral.ro")

   {

      echo "<td><font color='#999999'>".$Host."</font></td>";

   }

   // Else simply show the reverse DNS result

   else

   {

      echo "<td>".$Host."</td>";

   }

   // Show the page the visitor was visiting at the time; since it's relative don't forget to add the domain

   echo "<td><a href='http://www.geekpedia.com".$LogF['VisUrl']."' target='_blank'>".$LogF['VisUrl']."</a></td>";

   // If the referrer is specified, link to it

   if($LogF['VisRef'] != "")

   {

      echo "<td><a href='".$LogF['VisRef']."' target='_blank'>".$LogF['VisRef']."</a></td>";

   }

   else

   {

      echo "<td>&nbsp;</td>";

   }

   // Display the user agent in one of the cells

   echo "<td>".$LogF['VisAgent']."</td>";

   // Display the date and time when the visit was made

   echo "<td>".$Date."</td>";

   echo "</tr>";

   // We need to store the last IP so that we can highlight the same IPs

   $LastIP = $LogF['VisIP'];

}

echo "</table>";