<?php
$dbsocket=mysqli_connect ("localhost", "n8fq_wldb", "nq#q3%nm*hZz") or die ('I cannot connect to the database because: ' . mysql_error());
mysqli_select_db($dbsocket, 'n8fq_wldb');
$count = mysqli_num_rows(mysqli_query($dbsocket, "select * from `f_fp` where 1"));
$timeout = time()-(abs($_REQUEST['days'])*86400);
if($timeout <= 0 || $timeout >= time()-86400)
	$timeout = 0;
if(array_key_exists('mingifts', $_REQUEST))
	$mingifts = abs($_REQUEST['mingifts']);
else
	$mingifts = 0;
$i = 0;
while(True) {
	$linkquery = mysqli_query($dbsocket, sprintf("SELECT * FROM `f_fp` WHERE `Hits` = %d AND `ReqTime` > %d AND `Active` = 1 ORDER BY rand() LIMIT 1", $i, $mingifts, $timeout));
	if(mysqli_num_rows($linkquery) == 1) {
		$link = mysqli_fetch_assoc($linkquery);
		break;
	}
	else
		$i++;
	if($i == 500) {
		print "<html><body>Error: No users found with less than 500 hits with given parameters, aborting.<br>\n";
		printf("SELECT * FROM `f_fp` WHERE `Hits` = %d AND `ReqTime` > %d AND `Active` = 1 ORDER BY rand() LIMIT 1", $i, $mingifts, $timeout);
		print "</body></html>";
		die();
	}
}
mysqli_query($dbsocket, sprintf("UPDATE `f_fp` SET `Hits` = %s WHERE `User` = \"%s\"", abs($link['Hits'])+1, $link['User']));
mysqli_close($dbsocket);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<title>Random Wishlist</title>
<style type="text/css">
        body {
                background-color: #eeeeee;
                font-size: large;
                font-family: Verdana, Arial, Sans-serif;
                color: #888888;
        }
        table {
                width: 100%;
                text-align: right;
        }
        a {
                color: #666666;
                font-weight: bold;
                text-decoration: none;
        }
        a:hover {
                text-decoration: underline;
                color: orangered;
        }
        td.large {
                font-size: large;
                text-align: left;
        }
        td.small {
                font-size: x-small;
                padding-top: 0.25em;
        }
</style>
<script lang="javascript">
function rcpopup() {
 window.open("randomfp.php?remote=1","rcpopup","status=0,toolbar=0,menubar=0,scrollbars=0,height=300,width=500");
 window.name = 'wishlist';
}
function rcnav() {
 window.open("<?php echo $link['Link']; ?>","wishlist");
}
function goback() {
 window.open("http://www.reddit.com/r/Food_Pantry","wishlist");
 window.close("rcpopup");
}
</script>
</head>

<?php if(array_key_exists("remote", $_REQUEST)) { ?>
<body onLoad="rcnav()">
<p>This wishlist belongs to:<?php
echo "<p><ul>\n";
printf("<b>User:</b> <a href=\"http://www.reddit.com/u/%s\" target=\"wishlist\">%s</a><br>\n", $link['User'], $link['User']);
printf("<!-- <b>Link:</b> <a href=\"%s\" target=\"wishlist\">%s</a><br> -->\n", $link['Link'], $link['Link']);
printf("<b>Request link:</b> <a href=\"%s\" target=\"wishlist\">%s</a><br>\n", $link['ReqLink'], $link['ReqLink']);
printf("<b>Request date:</b> %s<br>\n", date("r", $link['ReqTime']));
printf("<b>Number of requests:</b> %s</br>\n", $link['ReqCount']);
printf("<!-- <b>Hits since last update:</b> %s<br> -->\n", $link['Hits']);
echo "</ul>\n";
?>
<p><a href="randomfp.php?remote=1">Roll again!</a>
<p>
<a href="javascript:goback()">Back to /r/Food_Pantry!</a>
<p><span style="font-size: x-small;">Developed and hosted by <a href="http://www.reddit.com/u/DersEvvak" target="wishlist">/u/DersEvvak</a> - <a href="http://redd.it/1rbhge" target="wishlist">Discussion thread</a></span>
</body>
<?php } else { ?>
<body>
<p>This wishlist belongs to:<?php
echo "<p><ul>\n";
printf("<b>User:</b> <a href=\"http://www.reddit.com/u/%s\" target=\"_blank\">%s</a><br>\n", $link['User'], $link['User']);
printf("<b>Wishlist link:</b> <a href=\"%s\" target=\"_blank\">%s</a><br>\n", $link['Link'], $link['Link']);
printf("<b>Request link:</b> <a href=\"%s\" target=\"_blank\">%s</a><br>\n", $link['ReqLink'], $link['ReqLink']);
printf("<b>Request date:</b> %s<br>\n", date("r", $link['ReqTime']));
printf("<b>Number of requests:</b> %s</br>\n", $link['ReqCount']);
printf("<!-- <b>Hits since last update:</b> %s<br> -->\n", $link['Hits']);
echo "</ul>\n";
?>
<p><a href="randomfp.php">Roll again!</a>
<p><a href="http://www.reddit.com/r/Food_Pantry">Back to /r/Food_Pantry!</a>
<p>
<a href="javascript:rcpopup()">Open Remote Control window!</a><br>(uses JavaScript and popups)
<p><span style="font-size: x-small;">Developed and hosted by <a href="http://www.reddit.com/u/DersEvvak">/u/DersEvvak</a> - <a href="http://redd.it/1rbhge">Discussion thread</a></span>
</body>
<?php } ?>
</html>
