CREATE TABLE IF NOT EXISTS `LINES` (
  `Date` varchar(55) NOT NULL,
  `vRot` varchar(5) NOT NULL,
  `Away` varchar(55) NOT NULL,
  `vListed` varchar(55) NOT NULL,
  `vLine` varchar(12) NOT NULL,
  `vTotal` varchar(12) NOT NULL,
  `vML` int(11) NOT NULL,
  `hRot` varchar(5) NOT NULL,
  `Home` varchar(55) NOT NULL,
  `hListed` varchar(55) NOT NULL,
  `hLine` varchar(12) NOT NULL,
  `hTotal` varchar(12) NOT NULL,
  `hML` int(11) NOT NULL,
  `nowTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  UNIQUE KEY `ID` (`Date`,`vRot`,`vListed`,`hRot`,`hListed`,`hML`,`hTotal`,`hLine`,`vML`,`vTotal`,`vLine`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

//error_reporting(0);
$host='localhost';
$username='USER';
$pswrd='PASS';
 
$con = mysql_connect($host,$username,$pswrd);
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("MLB",$con) or die('Error while selecting db');
 
$xmldoc = new DOMDocument();
$url = 'http://xml.pinnaclesports.com/pinnacleFeed.aspx?sporttype=baseball&sportsubtype=MLB';
$xmldoc->load($url);
 
$doc = $xmldoc->documentElement;
$event = $doc->getElementsByTagName("event");
foreach( $event as $ev )
{
  $ml_v = $ev->getElementsbyTagName("moneyline_visiting")->item(0)->nodeValue;
  $ml_h = $ev->getElementsbyTagName("moneyline_home")->item(0)->nodeValue;
  if ($ml_h==""){
      continue;
  }
 
  $total_v = $ev->getElementsbyTagName("total_points")->item(0)->nodeValue . " " . $ev->getElementsbyTagName("over_adjust")->item(0)->nodeValue;
  $total_h = $ev->getElementsbyTagName("total_points")->item(0)->nodeValue . " " . $ev->getElementsbyTagName("under_adjust")->item(0)->nodeValue;
 
  $d = $ev->getElementsByTagName("event_datetimeGMT")->item(0)->nodeValue;
  $teamnames = $ev->getElementsByTagName("participant_name");
  $name_v = str_replace("'","",$teamnames->item(0)->nodeValue);
  $name_h = str_replace("'","",$teamnames->item(1)->nodeValue);
  $rot = $ev->getElementsByTagName("rotnum");
  $rotv = $rot->item(0)->nodeValue;
  $roth = $rot->item(1)->nodeValue;
  $pitcher = $ev->getElementsByTagName("pitcher");
  $pitch_v = mysql_real_escape_string($pitcher->item(0)->nodeValue);
  $pitch_h = mysql_real_escape_string($pitcher->item(1)->nodeValue);
 
  $spread_v = $ev->getElementsbyTagName("spread_visiting")->item(0)->nodeValue . " " . $ev->getElementsbyTagName("spread_adjust_visiting")->item(0)->nodeValue; 
  $spread_h = $ev->getElementsbyTagName("spread_home")->item(0)->nodeValue . " " . $ev->getElementsbyTagName("spread_adjust_home")->item(0)->nodeValue; 
 
  $sql = "INSERT IGNORE INTO MLB.LINES (Date,vRot,Away,vListed,vLine,vTotal,vML,hRot,Home,hListed,hLine,hTotal,hML) Values ('$d','$rotv','$name_v','$pitch_v','$spread_v','$total_v','$ml_v','$roth','$name_h','$pitch_h','$spread_h','$total_h','$ml_h')";
   $query = mysql_query($sql,$con);
   if(!$query)
    {
    die('Could not insert values: ' . mysql_error());
    }
  }
mysql_close($con);

...
$sql="SELECT * \n"
    . "FROM MLB.LINES AS m\n"
    . "INNER JOIN (\n"
    . "\n"
    . "SELECT c.vROT, MAX( c.nowTime ) AS maxtime\n"
    . "FROM MLB.LINES AS c\n"
    . "GROUP BY c.vROT\n"
    . ") AS a ON m.vROT = a.vROT\n"
    . "AND m.nowTime = a.maxtime WHERE NOW()<=DATE_SUB(m.Date,INTERVAL 4 HOUR)";
$results = mysql_query($sql);
while($row=mysql_fetch_assoc($results)){
  $array[$i]['D']=$row['Date'];
  $array[$i]['hRot'] = $row['hRot'];
  $array[$i]['vRot'] = $row['vRot'];
  $array[$i]['Away'] = $row['Away'];
  $array[$i]['Home'] = $row['Home'];
  $array[$i]['vListed'] = $row['vListed'];
  $array[$i]['hListed'] = $row['hListed'];
  $array[$i]['vML'] = $row['vML'];
  $array[$i]['hML'] = $row['hML'];
  $array[$i]['vTotal'] = $row['vTotal'];
  $array[$i]['hTotal'] = $row['hTotal'];
  $array[$i]['vLine'] = $row['vLine'];
  $array[$i]['hLine'] = $row['hLine'];
  $i++;
}
header('Content-type: application/json');
echo json_encode($array);
...

jQuery(document).ready( function( $ ){
	var timeout, d;
	getPinny();
	function getPinny() {
		$.getJSON('php/MLB_Pinny.php?'+new Date().getTime(), function(json_data){
			update = new Date();
			$('#update td:first').text('LAST UPDATE: '+update.toString("yyyy-MM-dd h:mm"));
			$('#today tr:not(:first)').empty();
			$('#tomorrow tr:not(:first)').empty();
    			$.each(json_data, function(i, item){
			d = Date.parse(item.D).addHours(-4);
			cur = (d.getDayName()==Date.today().getDayName()) ? "today" : "tomorrow";
         		$("#"+cur).append($('<tr><td rowspan="2">' + d.toString("yyyy-MM-dd h:mm") + '</td><td>' + item.vRot + '</td><td class="team">' + item.Away + '</td><td class="pitch">' + item.vListed + '</td><td class="ml">' + item.vML + '</td><td>' + item.vTotal + '</td><td>' + item.vLine + '</td></tr><tr><td>' + item.hRot + '</td><td class="team">' + item.Home + '</td><td class="pitch">' + item.hListed + '</td><td class="ml">' + item.hML + '</td><td>' + item.hTotal + '</td><td>' + item.hLine + '</td></tr>'));
   			 });
 
		});
	}
 
	timeout = setInterval(function() { getPinny() }, 120000);
});

	$('#today').children('tr:eq(0)').click(function () {
     		$('#today').children('tr:gt(0)').toggle();
 	});
	$('#tomorrow').children('tr:eq(0)').click(function () {
    		$('#tomorrow').children('tr:gt(0)').toggle();
        });

...
if(isset($_GET['pitch'])) {
	$query = str_replace("%",". ",$_GET['pitch']);
	$sql="SELECT * \n"
    . "FROM MLB.LINES AS m\n"
    . "WHERE vLISTED LIKE '%$query%' OR hLISTED LIKE '%$query%'\n"
    . "ORDER BY nowTime DESC";
}
else {
	header( 'HTTP/1.1 400 Bad Request' );
	die('Please use correct paramaters');
}
$result = mysql_query($sql,$con) or die ('Error while executing query' . mysql_error() . "\n");
echo '<html><head></head><body>
<table border=1><thead><th>Date</th><th>Away</th><th>vListed</th><th>vML</th><th>Home</th><th>hListed</th><th>hML</th></thead><tbody>';
while($row=mysql_fetch_assoc($result)){
	if ($d == $row['Date'])
		continue;
	if($row['vListed']==$query){
		$boldvml = "<strong>".$row['vML']."</strong>";
		$boldvnm = "<strong>".$row['vListed']."</strong>";
		$boldvtm = "<strong>".$row['Away']."</strong>";
		$boldhml = $row['hML'];
		$boldhnm = $row['hListed'];
		$boldhtm = $row['Home'];
	}
	else {
		$boldhml = "<strong>".$row['hML']."</strong>";
		$boldhnm = "<strong>".$row['hListed']."</strong>";
		$boldhtm = "<strong>".$row['Home']."</strong>";
		$boldvml = $row['vML'];
		$boldvnm = $row['vListed'];
		$boldvtm = $row['Away'];
	}
	$d = $row['Date'];
	echo '<tr><td>'.date("Y-m-d hh:MM",strtotime($row['Date'],'-4hours')).'</td><td>'.$boldvtm.'</td><td>'.$boldvnm.'</td><td>'.$boldvml.'</td><td>'.$boldhtm.'</td><td>'.$boldhnm.'</td><td>'.$boldhml.'</td></tr>';
}
echo '</tbody></table></body></html>';
...

	$('.pitch').live('click',function() {
		window.open('php/linedb.php?pitch='+$(this).text().replace(" ","%").replace(".",""));
});