| "; $calendar_html .= "« | \n"; $calendar_html .= "" . $this_month["month"] . " " . $nYear . " | \n"; $calendar_html .= ""; $calendar_html .= "» | \n"; $calendar_html .= "
|---|---|---|
| "; $calendar_html .= $space . $daynames[$i] . $space . " | \n"; } $calendar_html .= "||
| \n";
$calendar_html .= " " . $date_to_print . " \n";
$calendar_html .= " | \n";
}
// now continue by printing all the rest of the matrix (all the days of THIS month)
$week_day = $first_week_day;
for($day_counter = 1; $day_counter <= $days_in_this_month; $day_counter++) {
$week_day %= 7;
if($week_day == 0) {
$calendar_html .= "||
| \n";
$calendar_html .= " " . $day_counter . " \n";
$lAnyEvents = "n";
$thisday = $nYear . "-" . $nMonth . "-" . $day_counter;
$query = "select * from tEvents where (evDateStart <= '" . $thisday . "') and (evDateEnd >= '" . $thisday . "')" . $WhereEvent;
$result = @mysql_query($query);
while ( $row = mysql_fetch_array($result) ) {
$calendar_html .= "\n";
$calendar_html .= "" . $row["evTime"] . "\n";
if ($row["evType"] == 1) {
$dClubName = "(unknown)";
$xClubNum = 0;
$q2 = "SELECT * from tEventHost where evhEvId=" . $row["evId"];
$res2 = @mysql_query($q2);
if (mysql_num_rows($res2 = @mysql_query($q2)) > 0) {
$row2 = mysql_fetch_array($res2);
$xClubNum = $row2["evhClubNum"];
}
if ($xClubNum > 0) {
$q2 = "SELECT * from tClubs where cClubNum=" . $xClubNum;
$res2 = @mysql_query($q2);
if (mysql_num_rows($res2 = @mysql_query($q2)) > 0) {
$row2 = mysql_fetch_array($res2);
$dClubName = $row2["cClubName"];
}
}
$evTitle = "TEST:" . substr($dClubName,0,25);
$evTitle = ereg_replace(" FSC", "", $evTitle);
$evTitle = ereg_replace(" SC", "", $evTitle);
} else {
$evTitle = substr($row["evTitle"],0,30);
$evTitle = ereg_replace("20[0-9]*", "", $evTitle);
$evTitle = ereg_replace("Invitational", "Invit", $evTitle);
$evTitle = ereg_replace("Championship", "Champ", $evTitle);
$evTitle = ereg_replace("Figure Skating", "FS", $evTitle);
$evTitle = ereg_replace("Competition", "Comp", $evTitle);
}
$calendar_html .= "" . $evTitle . "\n";
$calendar_html .= " \n";
$lAnyEvents = "y";
}
if ($lAnyEvents == "n") {
// dummy events to make it at least minimum height
$calendar_html .= " "; } $calendar_html .= " | \n";
$week_day++;
}
// now if we didn't finish on a saturday, fill out the rest of the week
if ($week_day < 7) {
$day_counter = 1;
for ($i=$week_day; $i<7; $i++) {
$calendar_html .= "\n";
$calendar_html .= " " . $day_counter++ . " \n";
$calendar_html .= " | \n";
}
}
$calendar_html .= "
| " . $month_name . " " . $year . " | |
| "; } $week_day = $first_week_day; for($day_counter = 1; $day_counter <= $days_in_this_month; $day_counter++) { $week_day %= 7; if($week_day == 0) $calendar_html .= " | |
| " . $day_counter . " | "; else $calendar_html .= "" . $day_counter . " | "; $week_day++; } $calendar_html .= "