motd.php

<?php
if (!defined('index_origin'))
{
	http_response_code(404);
	die();
}
?>
<?php
	$querylastchange = "SELECT quoteid,`change` FROM motd ORDER BY id DESC LIMIT 1;";
	$resultlastchange = mysqli_query($db, $querylastchange);
	$lastchangerow = mysqli_fetch_array($resultlastchange);

	$lastchange =  $lastchangerow['change'];
	$lastquoteid = $lastchangerow['quoteid'];
	$currentdate = date('Y-m-d');


	if ($lastchange == $currentdate) {
		$querymotd = "SELECT quote FROM quotes INNER JOIN motd ON quotes.id = motd.quoteid WHERE motd.quoteid = ?;";
		$prepmotd = mysqli_prepare($db, $querymotd);
		mysqli_stmt_bind_param ($prepmotd, 'i', $lastquoteid);
		mysqli_stmt_execute($prepmotd);
		$resultmotd = mysqli_stmt_get_result($prepmotd);
		$motdrow = mysqli_fetch_array($resultmotd);

		$motd = $motdrow['quote'];
		echo htmlspecialchars($motd);
	}
	else {
		$queryquotes = "SELECT id FROM quotes LIMIT 1;";
		$resultquotes = mysqli_query($db, $queryquotes);
		$resultquotes_count = mysqli_num_rows($resultquotes);

		if ($resultquotes_count == 1)
		{
			$querysetmotd = "INSERT INTO motd (`change`, quoteid) SELECT curdate(), quotes.id FROM quotes ORDER BY quotes.lastused LIMIT 1;";
			$resultsetmotd = mysqli_query($db, $querysetmotd);
	
			$querynewmotd = "SELECT quoteid FROM motd ORDER BY id DESC LIMIT 1;";
			$resultnewmotd = mysqli_query($db, $querynewmotd);
			$newmotdrow = mysqli_fetch_array($resultnewmotd);

			$newmotdid = $newmotdrow['quoteid'];	
	
			$queryupdatequote = "UPDATE quotes SET lastused = curdate() WHERE id = ?;";
			$prepupdatequote = mysqli_prepare($db, $queryupdatequote);
			mysqli_stmt_bind_param ($prepupdatequote, 'i', $newmotdid);
			mysqli_stmt_execute($prepupdatequote);
			$resultupdatequote = mysqli_stmt_get_result($prepupdatequote);
		}
		else
		{
			$queryaddquote = "INSERT INTO quotes (quote) VALUE ('Add your first quote!');";
			$resultaddquote = mysqli_query ($db, $queryaddquote);
		}
		header("Location: http://$_SERVER[HTTP_HOST]");
	}
?>