function timecheck()
{
$db_server = mysqli_connect("localhost", "root", "root", "schedule");
$today = date("Y-m-d");
$currenthour = date("H");
echo $currenttime;
$db_server = mysqli_connect("localhost", "root", "root", "schedule");
$cycquery = "SELECT cycleday FROM days WHERE daate = '{$today}';";
mylog($cycquery);
$cycresult = mysqli_query($db_server, $cycquery);
if ($cycquery->connect_errno) {
echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
$row = mysqli_fetch_array($cycresult, MYSQLI_ASSOC);
mylog("fetched today's date");
mysqli_free_result($cycresult);
$cyclevalue = $row['cycleday'];
$dayoftheweek = date('D');
$currentminute = date("i");
$specquery = "SELECT specialsched FROM days WHERE daate = '{$today};";
$specresult = mysqli_query($db_server, $specquery);
if ($specquery->connect_errno) {
echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
$row = mysqli_fetch_array($specresult, MYSQLI_ASSOC);
mylog("fetched today's date");
mysqli_free_result($specresult);
$spec = $row['specialsched'];
if ($cyclevalue === 'D' || $dayoftheweek === 'Wed' || $spec === 'y') {
mylog("entered conditional of timecheck");
//check with dday mod times
$nextmodtimefortoday = ddaytimemath();
$ddaymodquery = "SELECT modd FROM ddaymodtimes WHERE timee = '0000-00-00 {$nextmodtimefortoday}';";
mylog($ddaymodquery);
$ddaymodqueryresult = mysqli_query($db_server, $ddaymodquery);
if ($ddayquery->connect_errno) {
echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
$row = mysqli_fetch_array($ddaymodqueryresult, MYSQLI_ASSOC);
mysqli_free_result($ddaymodqueryresult);
$mod = $row['modd'];
if (empty($mod)) {
echo "<h1 style='text-align: center'> Day is over! </h1>";
} else {
$nextmodtimequery = "SELECT timee FROM ddaymodtimes WHERE modd = '{$mod}';";
$nextmodtimequeryresult = mysqli_query($db_server, $nextmodtimequery);
if ($nextmodtimequery->connect_errno) {
echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
mylog("THE NEXT MODTIME QUERY SHOULD BE: {$nextmodtimequery}");
$row = mysqli_fetch_array($nextmodtimequeryresult, MYSQLI_ASSOC);
mysqli_free_result($nextmodtimequeryresult);
$timee = $row['timee'];
$substroftime = substr($timee, -8);
$dateandsubstroftime = $today . $substroftime;
$astime = strtotime($dateandsubstroftime);
$finalsubstroftime = date("h:i", $astime);
$mornorafternoon = date('A');
echo "<h2 style = 'text-align: center'> Mod {$mod} begins at {$finalsubstroftime} {$mornorafternoon}</h2>";
}
} else {
$db_server = mysqli_connect("localhost", "root", "root", "schedule");
//check with normal mod times
$THEformattedtime = date('H:i');
$THEFORMATTEDNOW = "0000-00-00 {$THEformattedtime}:00";
$normalmodquery = "SELECT modd FROM normalmodtimes WHERE timee > '{$THEFORMATTEDNOW}' LIMIT 1;";
$normalmodqueryresult = mysqli_query($db_server, $normalmodquery);
if ($normalmodquery->connect_errno) {
echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
mylog("THE NORMAL MOD QUERY SHOULD BE: {$normalmodquery}");
$row = mysqli_fetch_array($normalmodqueryresult, MYSQLI_ASSOC);
mysqli_free_result($normalmodqueryresult);
$mod = $row['modd'];
if (empty($mod)) {
echo "<h1 style='text-align: center'> Day is over! </h1>";
} else {
echo "<h1 style='text-align: center'> The next mod is mod {$mod} </h1>";
$nextmodtimequery = "SELECT timee FROM normalmodtimes WHERE modd = '{$mod}';";
$nextmodtimequeryresult = mysqli_query($db_server, $nextmodtimequery);
if ($nextmodtimequery->connect_errno) {
echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
mylog("THE NEXT MODTIME QUERY SHOULD BE: {$nextmodtimequery}");
$row = mysqli_fetch_array($nextmodtimequeryresult, MYSQLI_ASSOC);
mysqli_free_result($nextmodtimequeryresult);
$timee = $row['timee'];
$substroftime = substr($timee, -8);
$dateandsubstroftime = $today . $substroftime;
$astime = strtotime($dateandsubstroftime);
$finalsubstroftime = date("h:i", $astime);
$mornorafternoon = date('A');
echo "<h2 style = 'text-align: center'> Mod {$mod} begins at {$finalsubstroftime} {$mornorafternoon}</h2>";
/*
echo $interval->format("I:S");
$timetillnextmod = $interval; //timee minus current time
*/
}
}
}
function timecheck()
{
$db_server = mysqli_connect("localhost", "root", "root", "schedule");
$today = date("Y-m-d");
$currenthour = date("H");
echo $currenttime;
$db_server = mysqli_connect("localhost", "root", "root", "schedule");
$cycquery = "SELECT cycleday FROM days WHERE daate = '{$today}';";
mylog($cycquery);
$cycresult = mysqli_query($db_server, $cycquery);
if ($cycquery->connect_errno) {
echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
$row = mysqli_fetch_array($cycresult, MYSQLI_ASSOC);
mylog("fetched today's date");
mysqli_free_result($cycresult);
$cyclevalue = $row['cycleday'];
$dayoftheweek = date('D');
$currentminute = date("i");
if ($cyclevalue === 'D' || $dayoftheweek === 'Wed') {
mylog("entered conditional of timecheck");
//check with dday mod times
$nextmodtimefortoday = ddaytimemath();
$ddaymodquery = "SELECT modd FROM ddaymodtimes WHERE timee = '0000-00-00 {$nextmodtimefortoday}';";
mylog($ddaymodquery);
$ddaymodqueryresult = mysqli_query($db_server, $ddaymodquery);
if ($ddayquery->connect_errno) {
echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
$row = mysqli_fetch_array($ddaymodqueryresult, MYSQLI_ASSOC);
mysqli_free_result($ddaymodqueryresult);
$mod = $row['modd'];
echo "<h1 style='text-align: center'> The next mod is: {$mod} </h1>";
mylog($ddaymodquery);
} else {
$db_server = mysqli_connect("localhost", "root", "root", "schedule");
//check with normal mod times
$THEformattedtime = date('H:i');
$THEFORMATTEDNOW = "0000-00-00 {$THEformattedtime}:00";
$normalmodquery = "SELECT modd FROM normalmodtimes WHERE timee > '{$THEFORMATTEDNOW}' LIMIT 1;";
$normalmodqueryresult = mysqli_query($db_server, $normalmodquery);
if ($normalmodquery->connect_errno) {
echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
mylog("THE NORMAL MOD QUERY SHOULD BE: {$normalmodquery}");
$row = mysqli_fetch_array($normalmodqueryresult, MYSQLI_ASSOC);
mysqli_free_result($normalmodqueryresult);
$mod = $row['modd'];
echo "<h1 style='text-align: center'> The next mod is: {$mod} </h1>";
$nextmodtimequery = "SELECT timee FROM normalmodtimes WHERE modd = '{$mod}';";
$nextmodtimequeryresult = mysqli_query($db_server, $nextmodtimequery);
if ($nextmodtimequery->connect_errno) {
echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
mylog("THE NEXT MODTIME QUERY SHOULD BE: {$nextmodtimequery}");
$row = mysqli_fetch_array($nextmodtimequeryresult, MYSQLI_ASSOC);
mysqli_free_result($nextmodtimequeryresult);
$timee = $row['timee'];
$substroftime = substr($timee, -8);
echo "this is the next mod's time {$substroftime}";
echo "</br>";
echo " this is today: {$today} ";
echo "</br>";
echo " this is the next mod today! {$today} {$substroftime}";
echo "</br>";
$dateandsubstroftime = $today . $substroftime;
echo "</br>";
$astime = strtotime($dateandsubstroftime);
echo "</br>";
echo $astime;
echo "</br>";
echo date("h:i:s");
echo "</br>";
echo date("h:i:s", $astime);
echo $interval->format("I:S");
$timetillnextmod = $interval;
//timee minus current time
echo "<script>\n \$(function () {\n var austDay = new Date();\n austDay = new Date(austDay.getFullYear() + 1, 1 - 1, 26);\n \$('#defaultCountdown').countdown({until: {$astime}});\n \$('#year').text(austDay.getFullYear());\n });\n </script>";
}
}
