Array
(
    [0] => Array
        (
            [0] =>  Kick 
            [1] =>  Ban 
            [2] =>  Name: 
            [3] =>  Team: 
            [4] =>  Ping: 
            [5] =>  Score: 
            [6] =>  IP 
            [7] =>  Global ID 
        )
 
    [1] => Array
        (
            [0] => 
            [1] => 
            [2] => Bozo(Spectator) 
            [3] =>   Blue
            [4] => 60
            [5] => 0
            [6] =>  25.25.25.20
            [7] =>  e3e6654a9232bf22218e5f2c39e72538
        )
 
)

 
<?php
$mysqldate = date( ‘Y-m-d’, $phpdate );
$phpdate = strtotime( $mysqldate );
// Make a MySQL Connection
mysql_connect("localhost", "user", "pass") or die(mysql_error());
mysql_select_db("thedb") or die(mysql_error());
 
// Create a MySQL table in the selected database
mysql_query("CREATE TABLE playerdata (
id int(11) NOT NULL AUTO_INCREMENT, 
date varchar(30) NOT NULL default '', 
name varchar(60) NOT NULL default '', 
score varchar(30) NOT NULL default '', 
IP varchar(30) NOT NULL default '', 
GUID varchar(60) NOT NULL default '', 
PRIMARY KEY  (id)
);")or die(mysql_error()); 
 
echo "Table Created!";
 
?>

 
<?php
/*
Include the http class. Modify path according to where you put the class
file.
*/
require_once(dirname(__FILE__).'/class_http.php');
/* First, instantiate a new http object. */
$h = new http();
/*
Where do you want to store your cache files?
Default is current dir. You can set it here, or hard-code in the class.
You must end this value with a "/".
*/
$h->dir = "/cache/"; 
$url = "http://127.20.25.2/admin/players";
if (!$h->fetch($url, 0, null, "scrapeuser", "scrapepass")) { 
  echo "<h2>There is a problem with the http request!</h2>";
  echo "Status: ".$h->status; 
  echo "<pre>".$h->header."</pre>"; 
  echo $h->log; 
  exit(); 
} 
$current_players = http::table_into_array($h->body, "Kick", 1, null); 
/* Print out the array so you can see the stats data. */ 
echo "<pre>"; 
print_r($current_players); 
echo "</pre>"; 
$mysqldate = date("Y-m-d");
echo $mysqldate;
mysql_connect("localhost", "user", "pass") or die(mysql_error());
mysql_select_db("thedb") or die(mysql_error());
$playerdata=serialize($current_players);
 
$query=INSERT INTO playerdata VALUES('$mysqldate', '$playerdata');
?>

<META HTTP-EQUIV="refresh" content="60;URL=http://thehostedhost/php/dbPush.php"> 
<?php
/*Include the http class. Modify path according to where you put the class file.*/
require_once(dirname(__FILE__).'/class_http.php');
/* First, instantiate a new http object. */
$h = new http();
$h->dir = "/cache/"; //Cache directory for Screen Scrape
$url = "http://127.28.60.2/Admin"; // URL
if (!$h->fetch($url, 0, null, "urluser", "urlpass")) {  //Do the scrape with the username/password at the end to authenticate
  echo "<h2>There is a problem with the http request!</h2>";
  echo "Status: ".$h->status; 
  echo "<pre>".$h->header."</pre>"; 
  echo $h->log; 
  exit(); 
} 
$current_players = http::table_into_array($h->body, "Kick", 1, null); 
/* Print out the array so you can see the stats data. */ 
//echo "<pre>"; 
//print_r($current_players); 
//echo "</pre>"; 
$mysqldate = date("Y-m-d"); //DateStamp for entry into MySQL
$size=sizeof($current_players); //Check the size of the array (See how many rows are returned by the scrape)
$playernum=count($current_players)-1; //Scrub the Rows to remove the first Row of the Scrape.. Showing the Number of Players online.
$dbh = mysql_connect("thehost", "thetableuser", "thepasswd") or die(mysql_error()); //Connect to your MySQL DB
mysql_select_db("thedb") or die(mysql_error()); // Select the DB
for($c = 1; $c <= sizeof($current_players); $c++) {  //Insert in a loop the players that are online to the DB
   if ($current_players[$c][2] != ''){
     $playername = html_entity_decode($current_players[$c][2]);
     $playerIP = html_entity_decode($current_players[$c][6]);
     $playerGUID = html_entity_decode($current_players[$c][7]);
 
 //check for duplicates 
 $query="SELECT * FROM playerdata WHERE IP='$playerIP' AND GUID='$playerGUID' "; 
 $result=mysql_query($query); 
 if(mysql_num_rows($result)==0) { 
 //end check for duplicate 
      $query = "INSERT INTO playerdata (date, name, IP, GUID) VALUES ('$mysqldate', '$playername', '$playerIP', '$playerGUID')";
           $result = mysql_query($query) or die(mysql_error());
      }     
   }
}
echo "<H2>Insert Complete</H2>";
?>