<?php
//Script to connect to a database, get a list of websites
//check most recent post date against the database and determine which sites
//have been updated.
//It then sorts the data nicely and outputs it.
//Require and init the library
require_once('lastrss.php');
$rss = new lastRSS;
//Set cache information
$rss->cache_dir = 'tmp';
$rss->cache_time = 3600;
//Init connection to the database and query it for a list of all stored websites
$db = new mysqli('localhost','root','','startpage');
$q = $db->query("SELECT * FROM sitelist");
//Begin unordered list
echo "<ul>";
//Begin a loop through each item in the array
while ($site = $q->fetch_assoc()) {
	//Grab the RSS feed location, shortURL and item name
	$url = $site['rsslocation'];
	$surl = $site['url'];
	$name = $site['name'];
	//Parse the feed
	$feed = $rss->get($url);
	//Stop it from continuing if feed parsing failed
	if(!$feed) {
		echo "<li>Error: Failed to fetch RSS data for $name</li>";
	}
	//Hack to handle Concession's feed, which lacks publish dates.
	if($name=='Concession') {
		//Get most recent post's title, strip unnecessary data and add year
		$datething = $feed['items'][0]['title'];
		$datething = str_replace('Concession, ','',$datething);
		$date = $datething." ".date('Y');
		//Convert it to epoch
		$mostrecent = (int) strtotime($date);
	} else {
		//Get publish date and convert to epoch
		$pubdate = $feed['items'][0]['pubDate'];
		$mostrecent = (int) strtotime($pubdate);
	}
	//Get epoch of the latest known RSS update from the DB
	$lastupdate = (int) $site['lastupdated'];
	//Get epoch of the time that the last successful check was completed
	$lastcheck = (int) $site['timesincelastcheck'];
	//Get the time
	$lcheck = time();
	if($lastupdate == $mostrecent || $lastcheck > $lcheck + 3600) {
		//If there's no updates to the RSS, and the last update was found more than an hour ago, loop round to the next item
	} else {
		//Output website name
		echo "<li><a href=\"/go/$surl\">$name</a></li>";
		//Update database so that it doesn't keep showing the same websites.
		//Only perform this update if the check completed successfully and new RSS entries were found
		if($lastupdate != $mostrecent) {
			$udb = $db->query("UPDATE sitelist SET lastupdated='$mostrecent' timesincelastcheck='$lcheck' WHERE rsslocation='$url'");
			if(!$udb) {
				echo "database update failed";
			}
		}
	}
	//Loop round to the next website.
}
echo "</ul>";
?>