sourlib.php

<?php

// sour reader main library
// steve "mookie" kong
// http://ultramookie.com
//
// licensed under gplv3
// http://www.gnu.org/licenses/gpl-3.0.html

error_reporting(E_ERROR | E_PARSE);

$sitename = getSiteName();
$siteurl = getSiteUrl();

function showUpdateForm() {
	$ua = $_SERVER['HTTP_USER_AGENT'];
        echo "<form action=\"";
        echo $_SERVER['PHP_SELF'];
        echo "\"";
        echo " method=\"post\">";
	echo "<input type=\"text\" name=\"url\" />";
        echo "<input type=\"hidden\" name=\"checksubmit\" value=\"1\">";
        echo "<input type=\"submit\" name=\"submit\" value=\"shorten\" id=\"submitbutton1\">";
        echo "</form>";
}


function showFeedsFrontPage() {

	$query = "select count(*) from main where status='N';";
        $result = mysql_query($query);
	$row = mysql_fetch_array($result);
	$count = $row['count(*)'];

	echo "<p class=\"entry\"><a href=\"showfeed.php?feedid=all\"><b>all new ($count)</b></a></p>";
	echo "<p class=\"entry\"><a href=\"showfeed.php?feedid=saved\"><b>saved</b></a></p>";

        $query = "select catid from categories order by catname";
        $result = mysql_query($query);

        while ($row = mysql_fetch_array($result)) {
		$catid=$row['catid'];

		$catcountquery = "select count(main.id),categories.catname from main,feeds,categories where feeds.feedcat='$catid' and main.status='N' and categories.catid='$catid' and feeds.feedid=main.feedid";
		$catcountresult = mysql_query($catcountquery);
		$catcountrow = mysql_fetch_array($catcountresult);
		$catname = $catcountrow['catname'];
		$catcount = $catcountrow['count(main.id)'];

		if ($catcount > 0) {
			echo "<p class=\"entry\"><b><a href=\"showfeed.php?feedid=category&catid=$catid\">$catname</a> ($catcount)</b></p>";
       	 		$query = "select feedid, feedname from feeds where feedcat='$catid' order by feedname;";
        		$feedresult = mysql_query($query);

			while ($feedrow = mysql_fetch_array($feedresult)) {
				$feedid = $feedrow['feedid'];
				$feedname = $feedrow['feedname'];

        			$query = "select count(*) from main where status='N' and feedid='$feedid';";
        			$indfeedresult = mysql_query($query);
		
				$indfeedrow = mysql_fetch_array($indfeedresult)	;
	
				$feedcount = $indfeedrow['count(*)'];

				if ($feedcount > 0) {
					echo "<p class=\"entryind\"><a href=\"showfeed.php?feedid=$feedid\">$feedname</a> (<b>$feedcount</b>)</p>";
				}
			}
		}
        }
}

function printFeedbar($feedid,$action,$catid = 0) {

	if (preg_match("/^category$/",$feedid)) {
		echo "<p class=\"menusecond\"><a href=\"index.php?action=markcatread&catid=$catid\">mark read</a> | <a href=\"showfeed.php?action=read&feedid=$feedid\">show read</a> | <a href=\"editfeed.php?feedid=$feedid\">edit feed</a> | <a href=\"deletefeed.php?feedid=$feedid\">unsubscribe</a></p>";
	} else {
		echo "<p class=\"menusecond\"><a href=\"index.php?action=markread&feedid=$feedid\">mark read</a> | <a href=\"showfeed.php?action=read&feedid=$feedid\">show read</a> | <a href=\"editfeed.php?feedid=$feedid\">edit feed</a> | <a href=\"deletefeed.php?feedid=$feedid\">unsubscribe</a></p>";
	}
}

function printEntrybar($id,$catid = 0) {

	if ($catid > 0) {
		$query = "select catname from categories where catid='$catid'";
		$result = mysql_query($query);
		$row = mysql_fetch_array($result);
		$catname = $row['catname'];

		echo "<p class=\"menusecond\"><a href=\"showfeed.php?feedid=category&catid=$catid\">&#171; $catname</a> | <a href=\"showentry.php?action=save&id=$id\">save</a> | <a href=\"showentry.php?action=unread&id=$id\">mark unread</a></p>";
	} else {

		$feedid = getFeedID($id);
		$feedname = getFeedName($feedid);

		echo "<p class=\"menusecond\"><a href=\"showfeed.php?feedid=$feedid\">&#171; $feedname</a> | <a href=\"showentry.php?action=save&id=$id\">save</a> | <a href=\"showentry.php?action=unread&id=$id\">mark unread</a></p>";
	}
}

function showFeed($feedid,$action = "unread",$catid = 0) {

	if (preg_match("/^read$/",$action)) {
		$pullstatus = " status='N' or status='R' ";
	} else {
		$pullstatus = " status='N' ";
	}

	if ( preg_match("/^all$/",$feedid) ) {
        	$query = "select id, title, date_format(pubDate, '%H:%i') as time, date_format(pubDate, '%m%d%y') as date from main where $pullstatus order by pubDate DESC";
		$feedname = "all";
	} elseif ( preg_match("/^saved$/",$feedid) ) {
        	$query = "select id, title, date_format(pubDate, '%H:%i') as time, date_format(pubDate, '%m%d%y') as date from main where status='S' order by pubDate DESC";
		$feedname = "saved";
	} elseif ( preg_match("/^category$/",$feedid) ) {
		$query = "select catname from categories where catid='$catid'";
        	$result = mysql_query($query);
		$row = mysql_fetch_array($result);
		$catname = $row['catname'];
        	$query = "select id, title, date_format(pubDate, '%H:%i') as time, date_format(pubDate, '%m.%d.%y') as date from main,feeds,categories where feeds.feedcat='$catid' and main.status='N' and categories.catid='$catid' and feeds.feedid=main.feedid order by pubDate DESC";
		$feedname = "$catname";
	} else {
        	$query = "select id, title, date_format(pubDate, '%H:%i') as time, date_format(pubDate, '%m.%d.%y') as date from main where feedid='$feedid' and ($pullstatus) order by pubDate DESC";
        	$fnquery = "select feedname from feeds where feedid='$feedid'";
        	$fnresult = mysql_query($fnquery);
		$fnrow = mysql_fetch_array($fnresult);
		$feedname = $fnrow['feedname'];
	}
        $result = mysql_query($query);

	$lightdark="containerlight";

	echo "<h2 class=\"feedname\">$feedname</h2>";

        while ($row = mysql_fetch_array($result)) {
		$id=$row['id'];
		$title=$row['title'];
		$time=$row['time'];
		$date=$row['date'];

		if(preg_match("/^containerlight$/",$lightdark)) {
			$lightdark="containerdark";
		} else {
			$lightdark="containerlight";
		}
		if ($catid > 0) {
			$realfeedid = getFeedID($id);
			$realfeedname = getFeedName($realfeedid);
			$title = $title . " [ <i>" . $realfeedname . "</i> ] ";
		}

		print "<div class=\"$lightdark\"><div class=\"left-element\"><a href=\"showentry.php?id=$id&catid=$catid\">$title</a></div><div class=\"right-element\">$time &#149; $date</div></div>";
        }
}

function addEntry($title,$description,$pubDate,$link,$guid,$feed,$updated) {
	$title = mysql_real_escape_string($title);
	$description = mysql_real_escape_string($description);
	$link = mysql_real_escape_string($link);
	$guid = mysql_real_escape_string($guid);

	$query = "select guid,feedid from main where guid='$guid' and feedid='$feed'";
	$status = mysql_query($query);
	if (mysql_num_rows($status) >= 1) {
	} else {
		$timestamp = strtotime($pubDate);
		$updatestamp = strtotime($updated);
		$mypubDate = date('YmdHis',$timestamp);
		$updateDate = date('YmdHis',$updatestamp);
		$query = "insert into main (title, description, pubDate, link, guid, feedid, status,updateTime) values ('$title', '$description', '$mypubDate', '$link', '$guid', '$feed', 'N', '$updateDate')";
		$result = mysql_query($query);

		$query = "update feeds set lastUpdate='$updateDate' where feedid='$feed'";
		$result = mysql_query($query);
	}

}

function showLoginForm() {
	echo "<form action=\"";
	echo $_SERVER['PHP_SELF'];
	echo "\"";
	echo " method=\"post\">";
	echo "user: <input type=\"text\" name=\"user\"><br />";
	echo "pass: <input type=\"password\" name=\"pass\"><br />";
	echo "<input type=\"hidden\" name=\"checksubmit\" value=\"1\">";
	echo "<input type=\"submit\" name=\"submit\" value=\"login\">";
	echo "</form>";
	echo "<hr />";
	echo "<a href='forgot.php'>forgot password</a>";
}

function getSecret() {
        $query = "select secret from user limit 1";
        $result = mysql_query($query);

        $row = mysql_fetch_array($result);

        return($row['secret']);
}

function getCookie() {
        $query = "select cookie from user limit 1";
        $result = mysql_query($query);

        $row = mysql_fetch_array($result);

        return($row['cookie']);
}

function checkCookie() {
	$secret = getSecret();
	$cookie = $_COOKIE['sourreader'];
	$user = $_COOKIE['user'];
	$storedcookie = getCookie();

	$loggedin = 0;

	$test = sha1($user . $secret);

	if ( (strlen($cookie) > 0) && ($cookie == $storedcookie) && ($cookie == $test) ) {
		$loggedin = 1;
	}

	return $loggedin;
}

function getUserName() {
	if(checkCookie()) {
		$name = $_COOKIE['user'];
	} else {
		$name = "not logged in";
	}
	return $name;
}

function getEmail() {
        $query = "select email from user limit 1";
        $result = mysql_query($query);

        $row = mysql_fetch_array($result);

        return($row['email']);
}

function getUser() {
        $query = "select name from user limit 1";
        $result = mysql_query($query);

        $row = mysql_fetch_array($result);

        return($row['name']);
}

function getSiteName() {
	$query = "select name from site limit 1";
	$result = mysql_query($query);

	$row = mysql_fetch_array($result);

	return($row['name']);
}

function getSiteUrl() {
	$query = "select url from site limit 1";
	$result = mysql_query($query);

	$row = mysql_fetch_array($result);

	return("http://" . $row['url']);
}

function getRawSiteURl() {
	$query = "select url from site limit 1";
	$result = mysql_query($query);

	$row = mysql_fetch_array($result);

	return($row['url']);
}

function setLoginCookie($user) {
		$secret = getSecret();
                $login = sha1($user . $secret);
                $expiry = time()+60*60*24*30;
		setcookie('user',$user,"$expiry");
                setcookie('sourreader',$login,"$expiry");

	        $query = "update user set cookie='$login' where name='$user'";
        	$result = mysql_query($query);
}

function killCookie() {
	if(checkCookie()) {
		$expiry = time() - 4800;
		setcookie('user','',"$expiry");
		setcookie('sourreader','',"$expiry");
	}
}

function checkLogin($user,$pass) {
        $salt = substr("$user",0,2);
        $epass = crypt($pass,$salt);

	$query = "select * from user where name='$user' and pass='$epass'";
	$result = mysql_query($query);

	if (mysql_num_rows($result)==1) {
		return 0;
	} else {
		return 1;
	}
}

function showAddform() {
	echo "<form action=\"";
	echo $_SERVER['PHP_SELF'];
	echo "\"";
	echo " method=\"post\">";
	echo "user: <input type=\"text\" name=\"user\"><br />";
	echo "email: <input type=\"text\" name=\"email\"><br />";
	echo "password: <input type=\"password\" name=\"pass1\"><br />";
	echo "password (again): <input type=\"password\" name=\"pass2\"><br />";
	echo "<input type=\"hidden\" name=\"checksubmit\" value=\"1\">";
	echo "<input type=\"submit\" name=\"submit\" value=\"install\">";
	echo "</form>";
}

function showSettingsform() {
	$query = "select purgedays from site";
	$result = mysql_query($query);
	$row = mysql_fetch_array($result);

	$purgedays = $row['purgedays'];
	
	echo "<p><b>general site settings:</b></p>";
	echo "<form action=\"";
	echo $_SERVER['PHP_SELF'];
	echo "\"";
	echo " method=\"post\">";
	echo "purge after: <input type=\"text\" name=\"purgedays\" value=\"$purgedays\" \"> days<br />";
	echo "<input type=\"hidden\" name=\"checksubmit\" value=\"1\">";
	echo "<input type=\"submit\" name=\"submit\" value=\"update\">";
	echo "</form>";
}

function showFeedsform() {
	echo "<p><b>add feed:</b></p>";
	echo "<form action=\"";
	echo $_SERVER['PHP_SELF'];
	echo "\"";
	echo " method=\"post\">";
	echo "feed name: <input type=\"text\" name=\"site\" \"><br />";
	echo "feed url: <input type=\"text\" name=\"url\" \"><br />";
	echo "<input type=\"hidden\" name=\"checksubmit\" value=\"1\">";
	echo "<input type=\"submit\" name=\"submit\" value=\"update\">";
	echo "</form>";
}

function showCatform() {

	echo "<ul>";
	$query = "select catid,catname from categories order by catname";
        $status = mysql_query($query);

	$lightdark="containerlight";

       	while ($row = mysql_fetch_array($status)) {
		$catname = $row['catname'];
		$catid = $row['catid'];
		if(preg_match("/^containerlight$/",$lightdark)) {
			$lightdark="containerdark";
		} else {
			$lightdark="containerlight";
		}
		print "<div class=\"$lightdark\"><div class=\"left-element\">$catname</div><div class=\"right-element\">[<a href=\"deletecat.php?catid=$catid\">d</a>][<a href=\"editcat.php?catid=$catid\">e</a>]</div></div>";
	}
	echo "</ul>";
}

function showFeedlist() {

	echo "<ul>";
	$query = "select feedid, feedname from feeds order by feedname";
        $status = mysql_query($query);

	$lightdark="containerlight";
       
	while ($row = mysql_fetch_array($status)) {
		$feedname = $row['feedname'];
		$feedid = $row['feedid'];
		if(preg_match("/^containerlight$/",$lightdark)) {
			$lightdark="containerdark";
		} else {
			$lightdark="containerlight";
		}

		print "<div class=\"$lightdark\"><div class=\"left-element\"><a href=\"showfeed.php?feedid=$feedid&action=read\">$feedname</a></div><div class=\"right-element\">[<a href=\"deletefeed.php?feedid=$feedid\">d</a>][<a href=\"editfeed.php?feedid=$feedid\">e</a>]</div></div>";
	}
	echo "</ul>";
}

function showForgotform() {
        echo "Please enter the following information to reset your password: <br />";
        echo "<form action=\"";
        echo $_SERVER['PHP_SELF'];
        echo "\"";
        echo " method=\"post\">";
        echo "user: <input type=\"text\" name=\"user\"><br />";
        echo "email: <input type=\"text\" name=\"email\"><br />";
        echo "<input type=\"hidden\" name=\"checksubmit\" value=\"1\">";
        echo "<input type=\"submit\" name=\"submit\" value=\"Reset Password\">";
        echo "</form>";
}


function generateCode($length=16) {
	$chars = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPRQSTUVWXYZ0123456789";
        $code = "";
        $clen = strlen($chars) - 1;
        while (strlen($code) < $length) {
		$code .= $chars[mt_rand(0,$clen)];
        }
        return $code;
}

function showPasswordChangeform() {
	$username = getUserName();
	echo "changing password for ";
	echo $username;
	echo "<form action=\"";
	echo $_SERVER['PHP_SELF'];
	echo "\"";
	echo " method=\"post\">";
	echo "old pass: <input type=\"password\" name=\"oldpass\"><br />";
	echo "new pass: <input type=\"password\" name=\"newpass1\"><br />";
	echo "new pass (again): <input type=\"password\" name=\"newpass2\"><br />";
	echo "<input type=\"hidden\" name=\"checksubmit\" value=\"1\">";
	echo "<input type=\"submit\" name=\"submit\">";
	echo "</form>";
}

function purgeOldArticles() {
	libxml_use_internal_errors(true);

        $query = "select purgedays from site limit 1";
	$result = mysql_query($query);
	$row = mysql_fetch_array($result);
	$purgedays = $row['purgedays'];
	$useragent = "SourReaderFeedUpdater/1.0 (http://github.com/ultramookie/sour-reader)";

	$ns = array ( 'content' => 'http://purl.org/rss/1.0/modules/content/' ); 

	$query = "select feedid, feedurl from feeds order by feedid";
	$status = mysql_query($query);

	while($row = mysql_fetch_array($status))
	{
        	$countquery = "select count(*) from main where feedid='$id'";
		$countresult = mysql_query($countquery);
		$countrow = mysql_fetch_array($countresult);
		$articlecount = $countrow['count(*)'];

		$url = $row['feedurl'];
		$id = $row['feedid'];

	        $session = curl_init();
        	curl_setopt ( $session, CURLOPT_URL, $url );
	        curl_setopt ( $session, CURLOPT_RETURNTRANSFER, TRUE );
        	curl_setopt ( $session, CURLOPT_CONNECTTIMEOUT, 2 );
		curl_setopt ( $session, CURLOPT_FOLLOWLOCATION, 1);
		curl_setopt ( $session, CURLOPT_USERAGENT, $useragent );
		curl_setopt ( $session, CURLOPT_ENCODING, "gzip" );
	        $result = curl_exec ( $session );
        	curl_close( $session );
        
		$xml = simplexml_load_string($result, 'SimpleXMLElement', LIBXML_NOCDATA);

		if ($result == FALSE) {
			print "<hr />There was an issue fetching $url<hr />";
			$count = $articlecount;
		} elseif ($xml->channel->item) {
			$count = count($xml->channel->item);
		} elseif ($xml->entry) {
			$count = count($xml->entry);
		} else {
			$count = $articlecount;
		}
	
		$totalremove = $articlecount - $count;

		if ($totalremove > $count) {	
			$deletequery = "delete from main where date_sub(curdate(), interval $purgedays day) >= updateTime AND status='R' AND feedid='$id' ORDER BY updateTime ASC LIMIT $totalremove";
			$deleteresult = mysql_query($deletequery);
		}
	}
}

function changePass($user,$pass) {
	$email = getEmail();
        $salt = substr("$user",0,2);
        $epass = crypt($pass,$salt);

	$query = "update user set pass='$epass' where name='$user'";
	$result = mysql_query($query);

	echo "password has been updated!";
}

function markEntryRead($id) {

	$query = "update main set status='R' where id='$id' AND status<>'S'";
	$result = mysql_query($query);
}

function markEntryUnread($id) {

	$query = "update main set status='N' where id='$id'";
	$result = mysql_query($query);
}

function saveEntry($id) {

	$query = "update main set status='S' where id='$id'";
	$result = mysql_query($query);
}

function getFeedName($feedid) {
       	$query = "select feedname from feeds where feedid='$feedid'";
       	$result = mysql_query($query);
	$row = mysql_fetch_array($result);
	$feedname = $row['feedname'];
	return($feedname);
}

function getFeedID($id) {

        $query = "select feedid from main where id='$id'";
	$result = mysql_query($query);
	$row = mysql_fetch_array($result);
	$feedid = $row['feedid'];
	return($feedid);
}

function showEntry($id) {

        $query = "select title, date_format(pubDate, '%r') as time, date_format(pubDate, '%m/%d/%y') as date, link, description, feedid from main where id='$id'";
	$result = mysql_query($query);
        
	$row = mysql_fetch_array($result);
	$title = $row['title'];
	$time = $row['time'];
	$date = $row['date'];
	$link = $row['link'];
	$description = $row['description'];
	$feedid = $row['feedid'];

	echo "<h2><a href=\"$link\" target=\"_blank\" >$title</a></h2>";
	echo "<p class=\"timedate\">$time &#149; $date</p>";
	echo "<p>$description</p>";

}	

function deleteCat($catid) {

	$query = "select count(*) from categories";
	$result = mysql_query($query);
	$row = mysql_fetch_array($result);

	$numcats = $row['count(*)'];

	if ( ($numcats > 1) && ($catid != 1) ) {
		$query = "update feeds set feedcat='1' where feedcat='$catid'";
		$result = mysql_query($query);

		$query = "delete from categories where catid='$catid'";
		$result = mysql_query($query);

		echo "category deleted.";
	} elseif ($catid == 1) {
		echo "can't remove the first category!";
	} else {
		echo "can't remove last category!";
	}
}

function deleteFeed($feedid) {
	
	$query = "delete from main where feedid='$feedid'";
	$result = mysql_query($query);
	
	$query = "delete from feeds where feedid='$feedid'";
	$result = mysql_query($query);

	echo "feed removed!";
}

function showCatAddform() {
	echo "<p><b>add a category:</b></p>";
	echo "<form action=\"";
	echo $_SERVER['PHP_SELF'];
	echo "\"";
	echo " method=\"post\">";
	echo "category name: <input type=\"text\" name=\"cat\" \"><br />";
	echo "<input type=\"hidden\" name=\"checksubmit\" value=\"1\">";
	echo "<input type=\"submit\" name=\"submit\" value=\"update\">";
	echo "</form>";
}

function showEditCatform($catid) {

	$query = "select catname from categories where catid='$catid'";
	$result = mysql_query($query);
	$row = mysql_fetch_array($result);

	$catname = $row['catname'];

	echo "<form action=\"";
	echo $_SERVER['PHP_SELF'];
	echo "\"";
	echo " method=\"post\">";
	echo "category name: <input type=\"text\" name=\"catname\" value=\"" . $catname . "\"><br />";
	echo "<input type=\"hidden\" name=\"catidp\" value=\"" . $catid ."\">";
	echo "<input type=\"hidden\" name=\"checksubmit\" value=\"1\">";
	echo "<input type=\"submit\" name=\"submit\" value=\"change\">";
	echo "</form>";
}

function showFeedEditform($feedid) {

	$query = "select feedname, feedurl, feedcat from feeds where feedid='$feedid'";
	$result = mysql_query($query);
	$row = mysql_fetch_array($result);

	$feedname = $row['feedname'];
	$feedurl = $row['feedurl'];
	$feedcat = $row['feedcat'];
	$catname = $row['categories.catname'];

	$query = "select catid, catname from categories order by catname";
	$result = mysql_query($query);

	echo "<form action=\"";
	echo $_SERVER['PHP_SELF'];
	echo "\"";
	echo " method=\"post\">";
	echo "feed name: <input type=\"text\" name=\"feedname\" value=\"" . $feedname . "\"><br />";
	echo "feed url: <input type=\"text\" name=\"feedurl\" value=\"" . $feedurl . "\"><br />";
	echo "feed category: <select name=\"catid\">";
       	while ($row = mysql_fetch_array($result)) {
		$catname = $row['catname'];
		$catid = $row['catid'];

		if ($feedcat == $catid) {
			$selected = " selected ";
		} else {
			$selected = " ";
		}
		echo "<option value=\"$catid\" $selected>$catname</option>";
	}
	echo "</select>";
	echo "<input type=\"hidden\" name=\"feedidp\" value=\"$feedid\">";
	echo "<input type=\"hidden\" name=\"checksubmit\" value=\"1\">";
	echo "<input type=\"submit\" name=\"submit\" value=\"change\">";
	echo "</form>";
}

function changeCatName($catid,$catname) {

	$catid = mysql_real_escape_string($catid);
	$catname = mysql_real_escape_string($catname);

	$query = "update categories set catname='$catname' where catid='$catid'";
	$result = mysql_query($query);

	echo "category name changed to $catname!";
}

function changeFeed($feedidp,$feedname,$feedurl,$catid) {

	$feedidp = mysql_real_escape_string($feedidp);
	$feedname = mysql_real_escape_string($feedname);
	$feedurl = mysql_real_escape_string($feedurl);
	$catid = mysql_real_escape_string($catid);

	$query = "update feeds set feedname='$feedname', feedurl='$feedurl', feedcat='$catid' where feedid='$feedidp'";
	$result = mysql_query($query);

	echo "$feedname updated!";
}

function markFeedRead($feedid) {

	if ( preg_match("/^all$/",$feedid) ) {
		$query = "update main set status='R' where status='N'";
	} else {
		$query = "update main set status='R' where feedid='$feedid' and status='N'";
	}
	$result = mysql_query($query);

}

function markCatRead($catid) {

	$query = "update main,feeds,categories set main.status='R' where feeds.feedcat='$catid' and main.status='N' and categories.catid='$catid' and feeds.feedid=main.feedid";
	$result = mysql_query($query);

}

function changeSettings($purgedays) {

        $purgedays = mysql_real_escape_string($purgedays);

	$query = "update site set purgedays='$purgedays' limit 1";
	$result = mysql_query($query);

	echo "your settings have been updated!";

}

function addFeed($site,$url) {

        $site = mysql_real_escape_string($site);
        $url = mysql_real_escape_string($url);

	$query = "select url from feeds where url='$url'";
	$status = mysql_query($query);
	if (mysql_num_rows($status) >= 1) {
		echo "already subscribed to $url!";
	} else {
		$query = "insert into feeds (feedname,feedurl,feedcat) values ('$site', '$url', '1')";
		$result = mysql_query($query);
		echo "$site has been added!";
	}
}

function addCat($cat) {

        $cat = mysql_real_escape_string($cat);

	$query = "select catid from categories where catname='$cat'";
	$status = mysql_query($query);
	if (mysql_num_rows($status) >= 1) {
		echo "already have a category named $cat!";
	} else {
		$query = "insert into categories (catname) values ('$cat')";
		$result = mysql_query($query);
		echo "$cat has been added!";
	}
}

function addUser($user,$email,$pass) {
        $salt = substr("$user",0,2);
        $epass = crypt($pass,$salt);

	$query = "select * from user";
	$status = mysql_query($query);

	if (mysql_num_rows($status) >= 1) {
		echo "already installed!";
	} else {
		$user = mysql_real_escape_string($user);
		$email = mysql_real_escape_string($email);
		$pass = mysql_real_escape_string($pass);
		
		$query = "create table user ( name varchar(30) NOT NULL, email varchar(30) NOT NULL, pass varchar(30) NOT NULL, secret varchar(6), cookie varchar(300) )";
		$status = mysql_query($query);

		$query = "create table main ( id int NOT NULL AUTO_INCREMENT, title varchar(1024) NOT NULL, description varchar(50000), pubDate DATETIME NOT NULL, link varchar(1024) NOT NULL, guid varchar(1024) NOT NULL, status varchar(2), feedid int NOT NULL, updateTime DATETIME NOT NULL, PRIMARY KEY (id)); ";
		$status = mysql_query($query);
		
		$query = "create table feeds ( feedid int NOT NULL AUTO_INCREMENT, feedname varchar(1024) NOT NULL, feedurl varchar(1024) NOT NULL, feedcat int NOT NULL, lastUpdate DATETIME NOT NULL, PRIMARY KEY(feedid) ); ";
		$status = mysql_query($query);
		
		$query = "create table categories ( catid int NOT NULL AUTO_INCREMENT, catname varchar(1024) NOT NULL, PRIMARY KEY(catid)); ";
		$status = mysql_query($query);
	
		$query = "create table site ( purgedays int NOT NULL ); ";
		$status = mysql_query($query);
		
		$query = "insert into site (purgedays) values ('30')";
		$status = mysql_query($query);
		
		$query = "insert into categories (catname) values ('general')";
		$status = mysql_query($query);
		
		$secret = generateCode();
	
		$query = "insert into user (name,email,pass,secret) values ('$user','$email','$epass','$secret')";
		$status = mysql_query($query);
	
		echo "sour reader installed!  thanks!";
	}
}

function sendRandomPass($email,$func) {
	$query = "select name from user where email='$email'";
	$status = mysql_query($query);
        $row = mysql_fetch_array($status);

	$user = $row['name'];
	
        $pass = generateCode();
	$salt = substr("$user",0,2);
	$epass = crypt($pass,$salt);

	$email = mysql_real_escape_string($email);
	
	$to = "$email";
	$from = "From: enter@something.here.or.else.tld";
	$subject = "password";
	$body = "hi, your password is $pass. please login using your email address and the password.  feel free to change your password at anytime.";
	if (mail($to, $subject, $body, $from)) {
		if ((strcmp($func,"new")) == 0) {
			$query = "insert into user (email,pass) values ('$email','$epass')";
			$status = mysql_query($query);
		} else if ((strcmp($func,"lost")) == 0) {
			$query = "update user set pass='$epass' where email='$email'";
			$status = mysql_query($query);
		} else {
			echo "nothing to do!";
		}

		echo "<p>Your new password has been sent!  <a href='login.php'>login</a> after you receive your password.</p>";
	} else {
		echo("<p>Message delivery failed...</p>");
	}
}