" ; // now get number of events on $day_i not approved $query = "select count(id) from ".$EVENTS_TB." left join ".$CAT_TB." on ".$EVENTS_TB.".cat=".$CAT_TB.".cat_id where approved='0' order by day,month,year ASC"; $result = mysql_query($query); $row = mysql_fetch_row($result) ; } } /**************/ /* view event */ /**************/ function view($id){ global $EVENTS_TB,$CAT_TB,$language,$maand,$vieweventok,$popupeventtitlefont,$closefont,$popupeventfont,$addeventok,$addeventwin_w,$addeventwin_h,$time12hour; echo " \n" ; $query = "select id,title,cat_name,description,starttime,endtime,day,month,year,approved,url,email from ".$EVENTS_TB." left join ".$CAT_TB." on ".$EVENTS_TB.".cat=".$CAT_TB.".cat_id where id='$id'"; $result = mysql_query($query); $row = mysql_fetch_object($result); echo $popupeventtitlefont."".stripslashes($row->title)."".$closefont." \n"; echo "\n".$popupeventfont ; echo " ".translate("Date")." : ".$row->day ." ".$maand[$row->month]." ".$row->year."\n"; echo " ".translate("From")." : " ; if ($time12hour=='1') echo show12hour($row->starttime) ; else echo $row->starttime ; echo "\n"; echo " ".translate("To")." : " ; if ($time12hour=='1') echo show12hour($row->endtime) ; else echo $row->endtime ; echo "\n"; echo " ".translate("Category")." : ".stripslashes($row->cat_name)."\n"; echo " ".translate("Event Description")." : \n"; echo " ".stripslashes($row->description).""; echo " \n"; if ($row->email) echo " ".translate("Email")." : email.">".$row->email."\n"; if ($row->url){ echo " ".translate("More info")." : url." target=_blank>".$row->url."\n"; } echo " \n" ; if ($addeventok == 1){ echo " "; } echo "" ; echo " " ; if (($allowsearch==1)&&($vieweventok==1)) search(); } /**************************/ /* overview of categories */ /**************************/ function cats($catcolor,$year){ global $EVENTS_TB,$CAT_TB,$USER_TB,$viewcatsok,$searchcatsok,$allowsearch,$titlefont,$headerfont,$menufont,$closefont, $dayheaderbgclr,$maand,$normalfont,$titlebgclr,$secondcatcolor,$allowsearch,$calstartyear,$caladvanceyear,$y,$userview,$userlogin,$userid; if ($viewcatsok == 1){ $query = "select cat_id,cat_name from ".$CAT_TB." order by cat_name ASC"; $result = mysql_query($query); $rows = mysql_num_rows($result); // if no rows if ($rows == "0"){ echo " ".$headerfont.translate("No categories yet").$closefont.". \n"; } // show categories else { echo "
".$titlefont.translate("disabled").$closefont.". " ; } } /*******************************/ /* view events of one category */ /**??????A ?*****************************/ function cat($id,$firstcatevcolor,$secondcatevcolor,$year,$sort){ global $EVENTS_TB,$USER_TB,$CAT_TB,$language,$maand,$searchscatviews,$popupevent,$popupeventheight,$popupeventwidth,$allowsearch, $headerfont,$weekheaderbgclr,$titlefont,$normalfont,$menufont,$closefont,$y,$searchcatsok,$calstartyear,$caladvanceyear, $userid,$userview,$userlogin; if (!isset($_GET['catmonth'])) $catmonth = ''; else $catmonth = $_GET['catmonth']; $query = "select id,title,cat_name,day,month,year from ".$EVENTS_TB." left join ".$CAT_TB." on ".$EVENTS_TB.".cat=".$CAT_TB.".cat_id where approved='1' and ".$EVENTS_TB.".cat='$id' and ".$EVENTS_TB.".year='$year' " ; if ($catmonth!='') $query = $query . " and month='$catmonth' " ; if (($userview=='1')&&($userlogin==1)) { $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) { $query = "select * from ".$USER_TB.", ".$EVENTS_TB." where ".$EVENTS_TB.".approved='1' and ".$EVENTS_TB.".cat='$id' and ".$EVENTS_TB.".year='$year' and ".$EVENTS_TB.".user=".$USER_TB.".username and ".$USER_TB.".user_id=".$userid ; if ($catmonth!='') $query = $query . " and month='$catmonth' " ; } } if (($sort)&&($sort==1)) $query = $query . " order by title ASC, year ASC, month ASC, day ASC"; else $query = $query . " order by year ASC, month ASC, day ASC, title ASC"; $result = mysql_query($query); $rowname = mysql_fetch_object($result); $rows = mysql_num_rows($result); // this is for the category sort order redirection javascript echo "" ; $cquery = "select cat_name from ".$CAT_TB." where cat_id='$id' " ; $cresult = mysql_query($cquery) ; $crow = mysql_fetch_object($cresult) ; echo "
".$titlefont.translate("No events").$closefont.". \n"; } else { $result = mysql_query($query); $foo = ''; while ($row = mysql_fetch_object($result)){ $foo++ % 2 ? $color=$firstcatevcolor : $color=$secondcatevcolor; echo "
".$titlefont.translate("disabled").$closefont.". " ; } } /************************/ /* view events per week */ /************************/ function week($week,$date){ global $EVENTS_TB,$CAT_TB,$USER_TB,$maand,$week,$language,$m,$d,$y,$ld,$fd,$viewweekok,$searchweekok,$popupevent,$popupeventwidth,$popupeventheight,$menufont,$titlefont,$headerfont,$normalfont,$closefont,$weekstartday,$titlebgclr,$weekheaderbgclr,$weekeventbgclr,$calstartyear,$caladvanceyear,$allowsearch,$addeventok,$userid,$userview,$userlogin,$addeventwin_w,$addeventwin_h,$time12hour,$shortdesclen; if ($viewweekok == 1){ if (!$date){ $year = $y; $month = $m; $day = $d; } else{ $year = substr($date,0,4); $month = substr($date,5,2); $day = substr($date,8,2); } // offset to get correct day calculation when "date" is sent $day_offset = date("w", mktime(0,0,0,$month,$day,$year)); $dayoff = 0 ; // use to get back original url "date" while ($day_offset>date("w")) { /* if (date("Y", mktime(0,0,0,$month,$day-1,$year)) >= $calstartyear) */$day-- ; // else break ; $day_offset = date("w", mktime(0,0,0,$month,$day,$year)); $dayoff++ ; } while ($day_offset".$headerfont.translate("Events from ");
$fdy = substr($fd,0,4);
$fdm = substr($fd,5,2);
if (substr($fdm,0,1) == "0"){
$fdm = str_replace("0","",$fdm);}
$fdd = substr($fd,8,2);
echo $fdd." ".$maand[$fdm]." ".$fdy;
echo " ".translate("till")." ";
$ldy = substr($ld,0,4);
$ldm = substr($ld,5,2);
if (substr($ldm,0,1) == "0"){
$ldm = str_replace("0","",$ldm);}
$ldd = substr($ld,8,2);
echo $ldd." ".$maand[$ldm]." ".$ldy;
$weeknumber = weekNumber($day+$dayoff,$month,$year);
if ($ldy>($y+$caladvanceyear)) $weeknumber = 53 ; // to ensure weeks cannot go beyond restricted dates
if ($fdy<($calstartyear)) $weeknumber = 1 ; // to ensure weeks cannot go beyond restricted dates
echo " (".translate("week number")." : ".$weeknumber.")".$closefont."\n";
$gdy = $ldy ;
$gdm = $ldm ;
if ($gdy>($y+$caladvanceyear)) { $gdy = $fdy ; $gdm = $fdm ; }
echo " | ![".translate("View month")." ".$maand[$gdm]."](\"images/month.gif\") ";
echo "".$headerfont."(".translate("Week starts")." ".$week[$weekstartday+1].")".$closefont."\n" ; echo " | ||||||||||||||||||||||||||
![".translate("Current Year")."](\"images/year.gif\"){kind=small}
![".translate("Current Week")."](\"images/week.gif\"){kind=small}
![".translate("Today")."](\"images/today.gif\"){kind=small}
![".translate("Categories")."](\"images/category.gif\"){kind=small}
![Administration](\"images/admin.gif\"){kind=small}
| " ; if (($year > $calstartyear) || (($fdm >= 1)&&($fdy == $calstartyear))) { echo $menufont."<< ".translate("Previous week")." ".$closefont; } if ($ldy <= $calendyear) { echo $menufont."".translate("Next week")." >> ".$closefont."\n"; } // display the hyperlinks to each day echo " | ".$menufont."".translate("Go to").": "; $afd = $fd ; $ald = date("Y-m-d", mktime(0,0,0,$ldm,$ldd+1,$ldy)); while ($afd != $ald){ $fdy = substr($afd,0,4); $fdm = substr($afd,5,2); if (substr($fdm,0,1) == "0"){ $fdm = str_replace("0","",$fdm);} $fdd = substr($afd,8,2); $weekday = date ("w", mktime(12,0,0,$fdm,$fdd,$fdy)); $weekday++; echo "" ; echo ucfirst($week[$weekday])." - ".$fdd ; echo " " ; $afd = date("Y-m-d", mktime(0,0,0,$fdm,$fdd+1,$fdy)); } echo " |
| " ; $weekday = date ("w", mktime(12,0,0,$fdm,$fdd,$fdy)); $weekday++; echo "".$titlefont ; echo ucfirst($week[$weekday]).$closefont." " ; echo "".$titlefont.$fdd.$closefont."" ." ".$titlefont.ucfirst($maand[$fdm])." ".$fdy.$closefont."" ; if ($addeventok == 1){ echo " " ; } echo " |
| " ;
$query = "select id,title,description,url,email,cat_name,starttime,endtime,day,month,year from ".$EVENTS_TB." left join ".$CAT_TB." on ".$EVENTS_TB.".cat=".$CAT_TB.".cat_id where day='$fdd' and month='$fdm' and year='$fdy' and approved='1' order by starttime,title ASC";
if (($userview=='1')&&($userlogin==1)) { // user view user specific events only
$uquery = "select username,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) {
$query = "select id,title,description,url,email,cat_name,starttime,endtime,day,month,year from ".$EVENTS_TB." left join ".$CAT_TB." on ".$EVENTS_TB.".cat=".$CAT_TB.".cat_id where day='$fdd' and month='$fdm' and year='$fdy' and approved='1' and ".$EVENTS_TB.".user='".$urow->username."' order by starttime,title ASC";
}
}
$result = mysql_query($query);
if (mysql_num_rows($result)==0) echo " " ; while ($row = mysql_fetch_object($result)){ echo $normalfont ; if ($row->starttime=='') echo " "; echo $closefont ; echo $normalfont."".translate("Category")." : "."".stripslashes($row->cat_name).$closefont." "; $de = str_replace(" ","",$row->description); $de = str_replace(" ","",$row->description); echo $normalfont.substr(stripslashes($de),0,$shortdesclen) ; if (($row->email!="")||($row->url!="")||(strlen($de)>$shortdesclen)) echo " ...".$closefont."\n"; else echo $closefont."\n" ; echo " "; if ($popupevent == 1) echo $menufont."id."','Calendar','toolbar=no,location=no,status=no,menubar=no,scrollbars=yes,resizable=no,width=".$popupeventwidth.",height=".$popupeventheight."')\">"; else echo $menufont."id.">"; echo translate("Read more")."".$closefont; echo " "; } $fd = date("Y-m-d", mktime(0,0,0,$fdm,$fdd+1,$fdy)); echo " |
| " ; echo " | " ; echo "" ; echo " | " ; echo "" ; if (($allowsearch==1)&&($searchweekok == 1)) search(); echo " |
".$titlefont.translate("disabled").$closefont.".
" ; } } /*****************/ /* vie??????A ?w calendar */ /*****************/ function cal($month,$year,$monthborder,$calcells,$calcellp,$tablewidth,$trtopcolor,$calfontback,$calfontasked,$calfontnext,$sundaytopclr,$weekdaytopclr,$sundayemptyclr,$weekdayemptyclr,$todayclr,$sundayclr,$weekdayclr){ global $CAT_TB,$EVENTS_TB,$USER_TB,$maand,$week,$language,$m,$d,$y,$tdwidth,$tdtopheight,$tddayheight,$tdheight,$viewcalok,$searchmonthok,$popupevent,$popupeventwidth,$popupeventheight, $dayfont,$datenumfont,$caleventfont,$menufont,$closefont,$titlefont, $calstartyear,$caladvanceyear,$allowsearch,$weekstartday,$addeventok,$userview,$userlogin,$userid,$showeventborder,$showeventtimeborder,$addeventwin_w,$addeventwin_h,$time12hour; 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 = $maand[$month]; $askedyear = $year; $firstday = date ("w", mktime(12,0,0,$month,1,$year)); $firstday++; // number of days in askedmonth $nr = date("t",mktime(12,0,0,$month,1,$year)); echo "\n\n ";
if (($year > $calstartyear) || (($month > 1)&&($year == $calstartyear))) {
echo $calfontback."".$maand[$pm]." ".$py."".$closefont;
$pdate = date("Y-m-d",mktime(0,0,0,$month-1,1,$year)) ;
echo " " ;
echo " " ;
}
else echo " " ;
echo " | ";
echo ""; echo $calfontasked.$askedmonth.$closefont." " ; echo " " ; echo $calfontasked.$askedyear.$closefont."\n"; echo " | " ;
$calendyear = $y + $caladvanceyear ;
if ($ny <= $calendyear) {
$ndate = date("Y-m-d",mktime(0,0,0,$month+1,1,$year)) ;
echo " " ;
echo " " ;
echo $calfontnext."".$maand[$nm]." ".$ny."".$closefont ;
echo " ";
}
else echo " " ;
echo " | ||||
| 's (=days) for ($i=1;$i<=7;$i++){ echo " | ".$dayfont.$week[$i].$closefont." | \n"; // sunday } else{ echo "bgcolor=$weekdaytopclr>".$dayfont.$week[$i].$closefont."\n"; // rest of week } } echo "|||||
| "; } $a=0; for ($i=1;$i<=$nr;$i++){ echo " |
|
