function cal($month, $year)
{
global $CAT_TB, $EVENTS_TB, $USER_TB, $mth, $week, $language, $m, $d, $y, $viewcalok, $viewweekok, $viewdayok, $searchmonthok, $popupevent, $popupeventwidth, $popupeventheight, $calstartyear, $caladvanceyear, $allowsearch, $weekstartday, $addeventok, $userview, $userlogin, $userid, $addeventwin_w, $addeventwin_h, $catview, $uname, $ugroup, $showuserentry, $publicview, $limitmthevt, $notimeentry, $overlibbgclr, $rssfeeds, $rssactive, $rssview;
if (isset($rssview)) {
$rsschannel = $rssfeeds[$rssview][0];
} else {
$rsschannel = "None";
}
if ($viewcalok == 1) {
// previous month
$pm = $month;
if ($month == "1") {
$pm = "12";
} else {
$pm--;
}
// previous year
$py = $year;
if ($pm == "12") {
$py--;
}
// next month
$nm = $month;
if ($month == "12") {
$nm = "1";
} else {
$nm++;
}
// next year
$ny = $year;
if ($nm == 1) {
$ny++;
}
// get month we want to see
$askedmonth = $mth[$month];
$askedyear = $year;
$firstday = date("w", mktime(12, 0, 0, $month, 1, $year));
$firstday;
// Check RSS Feed
if ($rssactive == 1) {
$RSSData = RSS(1, 1, 2007);
}
// number of days in askedmonth
$nr = date("t", mktime(12, 0, 0, $month, 1, $year));
echo "\n\n<table class=monthview align=center>";
echo "<tr>";
echo "<td align=left colspan=2 class=monthview width='28%' valign=middle> ";
if ($year > $calstartyear || $month > 1 && $year == $calstartyear) {
echo "<a href=calendar.php?op=cal&month=" . $pm . "&year=" . $py . "&catview={$catview} class=calfontnav>" . $mth[$pm] . " " . $py . "</a>";
$pdate = date("Y-m-d", mktime(0, 0, 0, $month - 1, 1, $year));
echo " <a href='Javascript:void(0);' onclick=\"Javascript:wopen('smallcal.php?op=smallcal&date={$pdate}','popupmonth',350,220,'no');\">";
echo "<img src='images/smallcal.gif' border=0 alt='" . translate("Popup Month") . "' valign=middle width=16 height=16/></a>";
} else {
echo " ";
}
echo "</td>";
echo "<td align=center colspan=3 class=monthview width='44%' >";
echo "<div class=calfontasked>" . $askedmonth . " ";
echo " <a href='Javascript:void(0);' onclick=\"Javascript:wopen('yearcal.php?op=yearcal&ycyear={$askedyear}','popupyear',610,600,'yes');\" class=calfontasked>";
echo $askedyear . "</a></div>\n";
echo "<td align=right colspan=2 class=monthview width='28%'>";
$calendyear = $y + $caladvanceyear;
if ($ny <= $calendyear) {
$ndate = date("Y-m-d", mktime(0, 0, 0, $month + 1, 1, $year));
echo " <a href='Javascript:void(0);' onclick=\"Javascript:wopen('smallcal.php?op=smallcal&date={$ndate}','popupmonth',350,220,'no');\">";
echo "<img src='images/smallcal.gif' border=0 alt='" . translate("Popup Month") . "' valign=middle width=16 height=16/></a> ";
echo "<a href=calendar.php?op=cal&month=" . $nm . "&year=" . $ny . "&catview={$catview} class=calfontnav>" . $mth[$nm] . " " . $ny . "</a>";
echo " ";
} else {
echo " ";
}
echo "</td></tr></table>\n\n";
echo "<table align=center class=monthview cellspacing=1>";
echo "<tr>";
// make the header days of week
for ($i = intval($weekstartday) + 1; $i <= intval($weekstartday) + 7; $i++) {
echo "<td align=center ";
if (dayinweek($i) == 1) {
echo "class=sundaytopcolor><div class=dayfont>" . $week[dayinweek($i)] . "</div></td>\n";
} else {
echo "class=weekdaytopcolor><div class=dayfont>" . $week[dayinweek($i)] . "</div></td>\n";
}
// rest of week
}
echo "</tr>\n\n<tr>\n";
// begin the days
// print initial blank squares
for ($i = 1; $i <= blankdays(intval($weekstartday), $firstday); $i++) {
echo "<td ";
if (dayinweek($i) == 1) {
echo "class=sundayemptyclr ";
} else {
echo "class=weekdayemptyclr ";
}
echo "> </td>";
}
$a = 0;
for ($i = 1; $i <= $nr; $i++) {
echo "<td ";
if ($i == $d && $month == $m && $year == $y) {
// highlight today's day
echo "class=todayclr ";
} else {
if (date("w", mktime(0, 0, 0, $month, $i, $year)) == 0) {
echo "class=sundayclr ";
} else {
echo "class=weekdayclr ";
}
}
// click on date number to view events for the date
echo " valign=top><table width='100%' border=0 cellspacing=1 cellpadding=1><tr><td align=left>";
echo "<b>";
if ($viewdayok == 1) {
echo "<a class=datenumfont href='cal_day.php?op=day&date=" . date("Y-m-d", mktime(0, 0, 0, $month, $i, $year)) . "&catview={$catview}'>";
}
echo $i;
if ($viewdayok == 1) {
echo "</a>";
}
echo "</b></td>";
echo "<td align=right> ";
if (date("w", mktime(0, 0, 0, $month, $i, $year)) == $weekstartday) {
if ($viewweekok == 1) {
echo "<a href='cal_week.php?op=week&date=" . date("Y-m-d", mktime(0, 0, 0, $month, $i, $year)) . "&catview={$catview}'><img src='images/week.gif' alt='" . translate("View week") . " " . weekNumber($i, $month, $year) . "' border=0 valign=middle width=11 height=11/></a> ";
}
}
if ($publicview == 1 && $uname != "" || $publicview == 0) {
if ($addeventok == 1) {
echo "<a href='Javascript:void(0);' onclick=\"Javascript:wopen('cal_addevent.php?op=eventform&add_day={$i}&add_month={$month}&add_year={$year}&catview={$catview}','popupwin'," . $addeventwin_w . "," . $addeventwin_h . ",'yes');\"><img src='images/plus.gif' alt='" . translate("Add Event") . "' border=0 valign=middle width=11 height=11/></a>";
}
}
echo "</td></tr></table>";
// now get RSS events
if ($rssactive == 1) {
if (isset($RSSData[$i][$month][$year])) {
echo "\n<table class=eventborder border=1 cellspacing=0 cellpadding=0 width=100%><tr><td align=center class=eventtimeborder valign=top>";
echo "\n<div class=smallcalev><b>";
// overlib line
echo "<a href='Javascript:void(0);' onmouseover=\"return overlib('";
echo "<table border=0 cellspacing=0 cellpadding=0 width=100%>";
for ($j = 0; $j <= $RSSData[$i][$month][$year]['count']; $j++) {
echo "<tr><td align=center valign=top>";
echo "<table class=eventborder border=1 cellspacing=0 cellpadding=0 width=100%><tr>";
if ($notimeentry == 0) {
echo "<td align=center class=eventtimeborder valign=top>";
echo "<div class=smallcalevtime>";
if (isset($RSSData[$i][$month][$year][$j]['starttime'])) {
if ($RSSData[$i][$month][$year][$j]['starttime'] == '') {
echo " ";
} else {
showtime($RSSData[$i][$month][$year][$j]['starttime'], $RSSData[$i][$month][$year][$j]['endtime'], 1);
}
echo "</div>";
echo "</td>";
}
}
echo "<td align=left valign=top width=80% class=eventborder>";
echo "<div class=smallcalevtime>";
echo "<a class=smallcalev href=\\'" . $RSSData[$i][$month][$year][$j]['link'] . "\\' target=_BLANK>";
echo subquot(stripslashes($RSSData[$i][$month][$year][$j]['title']));
echo "</a>";
echo "</td></tr></table>";
echo "</td></tr>";
}
echo "</table>";
// overlib line
echo "',FGCOLOR,'{$overlibbgclr}',TEXTSIZE,'1',WIDTH,'125',VAUTO,HAUTO,STICKY,CAPTION,'";
echo $i . " " . $askedmonth . " ');\" onmouseout=\"return nd();\">";
echo "[" . $rsschannel . "]";
echo "</a>";
echo "</b></div>\n";
echo "</td></tr></table>";
}
}
// now get eventual events on $i
$query = "select id,user,title,starttime,endtime from " . $EVENTS_TB . " left join " . $CAT_TB . " on " . $EVENTS_TB . ".cat=" . $CAT_TB . ".cat_id where day='{$i}' and month='{$month}' and year='{$year}' and approved='1' ";
if ($catview != 0) {
$query = $query . " and " . $EVENTS_TB . ".cat={$catview} ";
}
if ($userview == 1 && $userlogin == 1) {
// user view user specific events only
if ($ugroup != 0) {
$query = $query . " and " . $EVENTS_TB . ".user='******' ";
}
}
$query = $query . " order by day,month,year,starttime,title ASC";
$result = mysql_query($query);
$devtcnt = mysql_num_rows($result);
if ($limitmthevt != 0 && $devtcnt != 0 && $devtcnt >= $limitmthevt) {
echo "\n<div class=smallcalev><b> ## ";
// overlib line
echo "<a href='cal_day.php?op=day&date=" . date("Y-m-d", mktime(0, 0, 0, $month, $i, $year)) . "&catview={$catview}' onmouseover=\"return overlib('";
echo "<table border=0 cellspacing=0 cellpadding=0 width=100%>";
while ($row = mysql_fetch_object($result)) {
echo "<tr><td align=center valign=top>";
echo "<table class=eventborder border=1 cellspacing=0 cellpadding=0 width=100%><tr>";
if ($notimeentry == 0) {
echo "<td align=center class=eventtimeborder valign=top>";
echo "<div class=smallcalevtime>";
if ($row->starttime == '') {
echo " ";
} else {
showtime($row->starttime, $row->endtime, 1);
}
echo "</div>";
echo "</td>";
}
echo "<td align=left valign=top width=80% class=eventborder>";
echo "<div class=smallcalev>";
// bug in overlib when putting hyperlink
if ($popupevent == 1) {
echo "<a class=smallcalev href=\\'Javascript:void(0);\\' onclick=\\'Javascript:popup(" . $row->id . ");\\'>";
} else {
echo "<a class=smallcalev href=\\'cal_event.php?id=" . $row->id . "\\' >";
}
echo subquot(stripslashes($row->title));
echo "</a>";
echo "</div>";
echo "</td></tr>";
echo "</table>";
echo "</td></tr>";
}
echo "</table>";
// overlib line
echo "',FGCOLOR,'{$overlibbgclr}',TEXTSIZE,'1',WIDTH,'125',VAUTO,HAUTO,STICKY,CAPTION,'";
echo $i . " " . $askedmonth . " ');\" onmouseout=\"return nd();\">";
echo $devtcnt . " " . translate("events");
echo "</a>";
echo " ## </b></div>\n";
} else {
if ($devtcnt != 0) {
echo "\n<table border=0 cellspacing=0 cellpadding=0 width='100%'>";
while ($row = mysql_fetch_object($result)) {
echo "<tr><td align=center valign=top>\n";
echo "<table class=eventborder border=1 cellspacing=0 cellpadding=0 width='100%'><tr>";
if ($notimeentry == 0) {
echo "<td align=center class=eventtimeborder valign=top>";
echo "<div class=smallcalevtime>";
if ($row->starttime == '') {
echo " ";
} else {
showtime($row->starttime, $row->endtime, 1);
}
echo "</td>";
}
echo "<td align=left valign=top width='80%' class=eventborder>";
if ($showuserentry == 1 && $uname != "") {
echo "<" . $row->user . "> ";
}
if ($popupevent == 1) {
echo "<a class=smallcalev href=\"Javascript:void(0);\" onclick=\"Javascript:popup(" . $row->id . ");\">";
} else {
echo "<a class=smallcalev href=cal_event.php?id=" . $row->id . ">";
}
echo stripslashes($row->title) . "</a>";
echo "</td></tr>";
echo "</table>";
}
echo "</table>\n";
}
}
echo "</td>";
$a++;
if (blankdays(intval($weekstartday), date("w", mktime(0, 0, 0, $month, $i, $year))) == 6) {
echo "</tr>\n\n<tr>";
$a = 0;
}
}
// ending stuff (making 'white' td's to fill table
if ($a != 0) {
$last = 7 - $a;
for ($i = 1; $i <= $last; $i++) {
echo "<td class=weekdayemptyclr> </td>";
}
}
echo "</tr>";
echo "</table>";
echo "<table width='100%' align=center border=0 cellspacing=1 cellpadding=0>";
echo "<tr><td align=center width='30%' valign=top>";
echo "<table class=txtbox width=70 align=left cellpadding=2 cellspacing=0><tr><td align=center class=todayclr><i><div class=normalfont>" . translate("Today") . "</div></i></td></tr></table>\n</td>";
echo "<td align=right valign=top width='30%'>";
echo "<form action=POST><div class=menufont>\n";
echo "<b>" . translate("Go to") . ": </b>";
// get months
echo "<select name=gomonth onchange=\"javascript:gotomonth(this);\">\n";
for ($i = 1; $i < 13; $i++) {
echo "\t<option value=" . $i;
if ($month == $i) {
echo " selected ";
}
echo ">" . ucfirst($mth[$i]) . "\n";
}
echo "</select> \n";
// get year from "calstartyear" and give "caladvanceyear" years more to select
echo "<select name=goyear onchange=\"javascript:gotoyear(this);\">\n";
for ($i = $calstartyear; $i <= $y + $caladvanceyear; $i++) {
echo "\t<option value={$i}";
if ($year == $i) {
echo " selected ";
}
echo ">{$i}\n";
}
echo "</select><br/>\n";
echo "</div></form>";
echo "</td>";
// display search
echo "<td align=right valign=bottom width='40%'>";
if ($allowsearch == 1 && $searchmonthok == 1) {
search();
} else {
echo " ";
}
echo "</td></tr>";
echo "</table>";
} else {
echo "<br/><div class=titlefont>" . translate("disabled") . ".</div>";
}
}
// scroll right month
echo " ";
$pdate = date("Y-m-d", mktime(0, 0, 0, $smmonth, 1, $smyear + 1));
if (date("Y", mktime(0, 0, 0, $smmonth + 1, 1, $smyear)) <= $y + $caladvanceyear) {
echo "<a class=normalfont href=cal_date.php?op=smallcal&date={$pdate}&frmname=evfrm&frmday=bday&frmmth=bmonth&frmyear=byear&browse=yes>>></a>";
}
echo "</div></td></tr></table>\n\n";
echo "<table align=center class=smallcalmth >";
echo "<tr>";
// make the header days of week
for ($i = intval($weekstartday) + 1; $i <= intval($weekstartday) + 7; $i++) {
echo "<td align=center >";
if (dayinweek($i) == 1) {
echo "<div class=dayfont>" . substr($week[dayinweek($i)], 0, 3) . "</div></td>";
} else {
echo "<div class=dayfont>" . substr($week[dayinweek($i)], 0, 3) . "</div></td>";
}
// rest of week
}
echo "</tr>\n\n<tr>";
// print initial blank squares
for ($i = 1; $i <= blankdays(intval($weekstartday), $firstday); $i++) {
echo "<td> </td>";
}
$a = 0;
for ($i = 1; $i <= $nr; $i++) {
echo "<td align=center ";
if ($i == $d && $smmonth == $m && $smyear == $y) {
// highlight today's day
echo "class=todayclr ";
}
function smallmonth($smmonth, $smyear, $showyear, $ud, $um, $uy, $showeventcount)
{
global $EVENTS_TB, $USER_TB, $CAT_TB, $mth, $week, $todayclr, $viewcalok, $userid, $userview, $userlogin, $uname, $ugroup, $weekstartday, $overlibbgclr, $catview, $notimeentry;
// number of days in month
$firstday = date("w", mktime(12, 0, 0, $smmonth, 1, $smyear));
$nr = date("t", mktime(12, 0, 0, $smmonth, 1, $smyear));
echo "\n\n<table class='smallcalmth' align='center'>";
echo "<tr>";
echo "<td align='center' width='98%'><div class='smallcalmth'>";
if ($viewcalok == 1) {
echo "<a class='smallcalmth' href=\"#\" onclick='Javascript:top.opener.window.location = \"calendar.php?op=cal&month=" . $smmonth . "&year=" . $smyear . "\";'>";
}
echo $mth[$smmonth];
if ($viewcalok == 1) {
echo "</a> ";
}
if ($showyear) {
echo $smyear;
}
echo "</div></td></tr></table>\n\n";
echo "<table align='center' class='smallcalmth'>";
echo "<tr>";
// make the header days of week
for ($i = intval($weekstartday) + 1; $i <= intval($weekstartday) + 7; $i++) {
echo "<td align='center' width='14%'>";
if (dayinweek($i) == 1) {
echo "<div class='dayfont'>" . substr($week[dayinweek($i)], 0, 3) . "</div></td>";
} else {
echo "<div class='dayfont'>" . substr($week[dayinweek($i)], 0, 3) . "</div></td>";
}
// rest of week
}
echo "</tr>\n\n<tr>";
// print initial blank squares
for ($i = 1; $i <= blankdays(intval($weekstartday), $firstday); $i++) {
echo "<td> </td>";
}
$a = 0;
for ($i = 1; $i <= $nr; $i++) {
// now get eventual events on $i
$query = "select id,user,title,starttime,endtime from " . $EVENTS_TB . " left join " . $CAT_TB . " on " . $EVENTS_TB . ".cat=" . $CAT_TB . ".cat_id where day='{$i}' and month='{$smmonth}' and year='{$smyear}' and approved='1' ";
if ($catview != 0) {
$query = $query . " and " . $EVENTS_TB . ".cat={$catview} ";
}
if ($userview == 1 && $userlogin == 1) {
// user view user specific events only
if ($ugroup != 0) {
$query = $query . " and " . $EVENTS_TB . ".user='******' ";
}
}
$query = $query . " order by day,month,year,starttime,title ASC";
$result = mysql_query($query);
$devtcnt = mysql_num_rows($result);
echo "<td align='center' ";
if ($i == $ud && $smmonth == $um && $smyear == $uy) {
// highlight today's day
echo "class='todayclr' ";
} elseif ($devtcnt != 0) {
echo "class='smallcalmth' ";
}
echo "valign='top'>\n";
if ($devtcnt != 0) {
// overlib line
echo "<a href=\"javascript:void(0);\" onmouseover=\"return overlib('";
echo "<table border=0 cellspacing=0 cellpadding=0>";
while ($row = mysql_fetch_object($result)) {
echo "<tr><td align=center valign=top>";
echo "<table class=eventborder cellspacing=0 cellpadding=0><tr>";
if ($notimeentry == 0) {
echo "<td align=center class=eventtimeborder valign=top>";
echo "<div class=smallcalevtime>";
if ($row->starttime == '') {
echo " ";
} else {
showtime($row->starttime, $row->endtime, 1);
}
echo "</div>";
echo "</td>";
}
echo "<td align=left valign=top width=80% class=eventborder>";
echo "<div class=smallcalev>";
echo subquot(stripslashes($row->title));
echo "</div>";
echo "</td></tr>";
echo "</table>";
}
echo "</td></tr>";
echo "</table>";
// overlib line
echo "',FGCOLOR,'{$overlibbgclr}',TEXTSIZE,'1',WIDTH,'120',VAUTO,HAUTO);\" onmouseout=\"return nd();\">";
}
echo "<div class='datenumfont'>" . $i . "</div>";
if ($devtcnt != 0) {
echo "</a>";
}
echo "</td>\n";
$a++;
if (blankdays(intval($weekstartday), date("w", mktime(0, 0, 0, $smmonth, $i, $smyear))) == 6) {
echo "</tr>\n\n";
if ($a != 0 && $i != $nr) {
echo "<tr>";
}
$a = 0;
}
}
if ($a != 0) {
for ($i = $a; $i < 7; $i++) {
echo "<td> </td>";
}
echo "</tr>";
}
if ($showeventcount) {
echo "<tr><td align='center' valign='top' colspan='7'>";
// get total number of events for month
$tquery = "select id from " . $EVENTS_TB . " where " . $EVENTS_TB . ".month='" . $smmonth . "' and " . $EVENTS_TB . ".year='" . $smyear . "' and " . $EVENTS_TB . ".approved='1' ";
$normuser = false;
if ($userview == 1 && $userlogin == 1 && $uname != "") {
// view user specific events only
$uquery = "select group_id from " . $USER_TB . " where " . $USER_TB . ".user_id=" . $userid;
$uresult = mysql_query($uquery);
$urow = mysql_fetch_object($uresult);
if ($urow->group_id != 0) {
$normuser = true;
$tquery = "select * from " . $EVENTS_TB . "," . $USER_TB . " where " . $EVENTS_TB . ".month='" . $smmonth . "' and " . $EVENTS_TB . ".year='" . $smyear . "' and " . $EVENTS_TB . ".approved='1' and " . $EVENTS_TB . ".user="******".username and " . $USER_TB . ".user_id=" . $userid;
}
}
$tresult = mysql_query($tquery);
$trows = mysql_num_rows($tresult);
echo "<table class='txtbox' cellspacing='0' cellpadding='0'><tr><td align='center'><div class='normalfont'> " . $trows . " " . translate("events") . " </div></td></tr></table>";
echo "</td></tr>";
}
echo "</table>";
}
