Daily calendar for $showDate
\n\n";
// start the table
?>
$showDay = date("M jS", mktime(0,0,0,$Month,$Day,$Year));
// this is the query results counter
$qr = 0;
echo "
$showDay ";
$queryDate = $Year."-".$Month."-".$Day;
$todaysDay = date("w", mktime(0,0,0,$Month, $Day, $Year));
// how many of today have happened this month? assume at least one
$numOfTodays = 1;
if ( date("m", mktime(0,0,0,$Month, $Day, $Year)) == date("m", mktime(0,0,0,$Month, ($Day - 7), $Year)) ) {
$numOfTodays = 2;
}
if ( date("m", mktime(0,0,0,$Month, $Day, $Year)) == date("m", mktime(0,0,0,$Month, ($Day - 14), $Year)) ) {
$numOfTodays = 3;
}
if ( date("m", mktime(0,0,0,$Month, $Day, $Year)) == date("m", mktime(0,0,0,$Month, ($Day - 21), $Year)) ) {
$numOfTodays = 4;
}
if ( date("m", mktime(0,0,0,$Month, $Day, $Year)) == date("m", mktime(0,0,0,$Month, ($Day - 28), $Year)) ) {
$numOfTodays = 5;
}
// we need to pre-query and then sort
// query the CalendarDaily table
$result = mysql("$DBName","SELECT CalendarDetailsID
FROM phpCalendar_Daily
WHERE ".$LocQuery." AND Active = '1' AND
( ('$queryDate' = StartDate AND StopDate = '0000-00-00') OR
(StopDate != '0000-00-00' AND '$queryDate' BETWEEN StartDate AND StopDate) )") or die(mysql_error());
while ($row = mysql_fetch_row($result)) {
$gotResults[$qr] = $row[0];
$qr++;
}
// query the CalendarWeekly table
$result = mysql("$DBName","SELECT CalendarDetailsID, DaysOfWeek
FROM phpCalendar_Weekly
WHERE ".$LocQuery." AND Active = '1' AND
( ('$queryDate' >= DisplayStart AND DisplayStop = '0000-00-00') OR
(DisplayStop != '0000-00-00' AND '$queryDate' BETWEEN DisplayStart AND DisplayStop) )") or die(mysql_error());
while ($row = mysql_fetch_row($result)) {
$CalendarDetailsID = $row[0];
$DaysOfWeek = $row[1];
if ($DaysOfWeek == $todaysDay) {
$gotResults[$qr] = $CalendarDetailsID;
$qr++;
} else {
$split = explode("|", $DaysOfWeek);
for ($x = 0; $split[$x]; $x++) {
if ($split[$x] == $todaysDay) {
$gotResults[$qr] = $CalendarDetailsID;
$qr++;
}
}
while ($split[0]) {
array_pop($split);
}
}
}
// query the CalendarMonthly table
$result = mysql("$DBName","SELECT CalendarDetailsID
FROM phpCalendar_Monthly
WHERE ".$LocQuery." AND Active = '1' AND DayOfMonth = '$Day' AND
( ('$queryDate' >= DisplayStart AND DisplayStop = '0000-00-00') OR
(DisplayStop != '0000-00-00' AND '$queryDate' BETWEEN DisplayStart AND DisplayStop) )") or die(mysql_error());
while ($row = mysql_fetch_row($result)) {
$gotResults[$qr] = $row[0];
$qr++;
}
// query the CalendarYearly table
$result = mysql("$DBName","SELECT CalendarDetailsID
FROM phpCalendar_Yearly
WHERE ".$LocQuery." AND Active = '1' AND DayOfMonth = '$Day' AND Month = '$Month' AND
( ('$queryDate' >= DisplayStart AND DisplayStop = '0000-00-00') OR
(DisplayStop != '0000-00-00' AND '$queryDate' BETWEEN DisplayStart AND DisplayStop) )") or die(mysql_error());
while ($row = mysql_fetch_row($result)) {
$gotResults[$qr] = $row[0];
$qr++;
}
// query the CalendarPeriodicalMonthly table
$result = mysql("$DBName","SELECT CalendarDetailsID, WeekDays
FROM phpCalendar_PeriodicalMonthly
WHERE ".$LocQuery." AND Active = '1' AND WeekNumber = '$numOfTodays' AND
( ('$queryDate' >= DisplayStart AND DisplayStop = '0000-00-00') OR
(DisplayStop != '0000-00-00' AND '$queryDate' BETWEEN DisplayStart AND DisplayStop) )") or die(mysql_error());
while ($row = mysql_fetch_row($result)) {
$CalendarDetailsID = $row[0];
$WeekDays = $row[1];
if ($WeekDays == $todaysDay) {
$gotResults[$qr] = $CalendarDetailsID;
$qr++;
} else {
$split = explode("|", $WeekDays);
for ($x = 0; $split[$x]; $x++) {
if ($split[$x] == $todaysDay) {
$gotResults[$qr] = $CalendarDetailsID;
$qr++;
}
}
while ($split[0]) {
array_pop($split);
}
}
}
// query the CalendarPeriodicalYearly table
$result = mysql("$DBName","SELECT CalendarDetailsID, WeekDays
FROM phpCalendar_PeriodicalYearly
WHERE ".$LocQuery." AND Active = '1' AND WeekNumber = '$numOfTodays' AND Month = '$Month' AND
( ('$queryDate' >= DisplayStart AND DisplayStop = '0000-00-00') OR
(DisplayStop != '0000-00-00' AND '$queryDate' BETWEEN DisplayStart AND DisplayStop) )") or die(mysql_error());
while ($row = mysql_fetch_row($result)) {
$CalendarDetailsID = $row[0];
$WeekDays = $row[1];
if ($WeekDays == $todaysDay) {
$gotResults[$qr] = $CalendarDetailsID;
$qr++;
} else {
$split = explode("|", $WeekDays);
for ($x = 0; $split[$x]; $x++) {
if ($split[$x] == $todaysDay) {
$gotResults[$qr] = $CalendarDetailsID;
$qr++;
}
}
while ($split[0]) {
array_pop($split);
}
}
}
for ($g = 0; $gotResults[$g]; $g++) {
$query .= " OR CalendarDetailsID = '$gotResults[$g]'";
}
while ($gotResults[0]) {
array_pop($gotResults);
}
if ($query) {
$query = "(".ereg_replace("^ OR ","",$query).")";
$result = mysql("$DBName","SELECT Title, CalendarDetailsID
FROM phpCalendar_Details
WHERE $query
ORDER BY StartTime, StopTime") or die(mysql_error());
while ($row = mysql_fetch_row($result)) {
$CDTi = $row[0];
$CDCI = $row[1];
echo " \n";
getEvent($CDCI, "$CDTi", $queryDate);
}
}
if (!$query) {
echo "There are no events to display for this day ";
}
echo " ";
echo " | ";
?>
|