require("setting.php");
$thisfile=$oSystem->getValue("calendar_pageurl");
if($calview==""){ $calview=$oSystem->getValue("calendar_defaultview"); }
if($year==""){ $year = date("Y",$localtime); }
if($month==""){ $month = date("m",$localtime); }
if($day==""){ $day = date("d",$localtime); }
$dayInterval = 24*60*60;
$weekInterval = 7*24*60*60;
$monthArr = array($lang['calendar']['january'], $lang['calendar']['february'], $lang['calendar']['march'], $lang['calendar']['april'], $lang['calendar']['may'], $lang['calendar']['june'], $lang['calendar']['july'], $lang['calendar']['august'], $lang['calendar']['september'], $lang['calendar']['october'], $lang['calendar']['november'], $lang['calendar']['december']);
$monthArr1 = array($lang['calendar']['jan'], $lang['calendar']['feb'], $lang['calendar']['mar'], $lang['calendar']['apr'], $lang['calendar']['may'], $lang['calendar']['jun'], $lang['calendar']['jul'], $lang['calendar']['aug'], $lang['calendar']['sep'], $lang['calendar']['oct'], $lang['calendar']['nov'], $lang['calendar']['dec']);
$dayArr = array($lang['calendar']['sunday'], $lang['calendar']['monday'], $lang['calendar']['tuesday'], $lang['calendar']['wednesday'], $lang['calendar']['thursday'], $lang['calendar']['friday'], $lang['calendar']['saturday']);
$dayArr1 = array($lang['calendar']['su'], $lang['calendar']['mo'], $lang['calendar']['tu'], $lang['calendar']['we'], $lang['calendar']['th'], $lang['calendar']['fr'], $lang['calendar']['sa']);
$oCalendar_Type->data = array("type_name","description");
$result=$oCalendar_Type->getDetail($type_id);
if($myrow=mysql_fetch_row($result)){
$type_name=stripslashes(htmlentities($myrow[0],ENT_NOQUOTES,'utf-8'));
if ($myrow[1]!="" && $oSystem->getValue("calendar_showcatdescp")=="Yes"){ $myrow[1]="
".stripslashes(nl2br($myrow[1])).""; } else {$myrow[1]="";}
if ($oSystem->getValue("calendar_enableprint")=="Yes" && $calview!="searchtitle"){ $print_version="
".$lang['calendar']['printversion'].""; }
echo"
".$lang['calendar']['eventtype']." : ".$type_name." ".$myrow[1]." | $print_version |
";
} else if ($oSystem->getValue("calendar_enableprint")=="Yes" && $calview!="searchtitle"){
echo"
";
}
mysql_free_result($result);
if($calview=="year"){
$prevyear = $year - 1; $nextyear = $year + 1;
echo "
";
echo "
";
for($month=1; $month<13; $month++){
echo "
" . $monthArr[$month-1] . " $year |
";
echo "";
for($i=0;$i$dayArr1[$i]"; }
echo " ";
$first = date("w", mktime(0,0,0,$month,1,$year));
$lastday = date("t", mktime(0,0,0,$month,1,$year));
$day=1; $end = 0; $div_id=0;
for($w=1; $w<7; $w++){
echo "";
for($wd=0; $wd<7; $wd++){
if(($w==1 && $wd<$first) || $day > $lastday){
echo " | ";
}else{
if ($day==$lastday){ $end=1; }
if($year==date("Y",$localtime) && $month==date("m",$localtime) && $day==date("d",$localtime)){ $cellstyle="cellnow"; }else{ $cellstyle="cellnone"; }
$div_id++;
if($oCalendar_Date->chkDay_Year($year,$month,$day,$type_id)==TRUE){
$event_list = "";
$oCalendar_Date->data = array("distinct event_id");
$oCalendar_Date->where = "event_day='$year-$month-$day'";
$detect_event="No";
$oCalendar_Date->order = "time_from ASC";
$rst = $oCalendar_Date->getList() or die();
while($myr = mysql_fetch_row($rst)){
if ($oCalendar_Event->chkType($myr[0],$type_id)==TRUE){
$event_tooltips = $oCalendar_Date->getToolTipsDate($myr[0],$year,$month,$day,$type_id);
$event_list.= "$event_tooltips ";
}
}mysql_free_result($rst);
$div_id=$month.$day;
echo "".$day++."
$event_list
| ";
}else{
echo "".$day++." | ";
}
}
}
echo " ";
if($end==1){ break; }
}
echo "
| ";
if ($month%3==0){ echo "
"; }
}
echo "
";
}
if($calview=="month"){
if ($month==1){
$prevyear=$year-1; $prevmonth=12;
$nextyear=$year; $nextmonth=2;
}else if($month==12){
$prevyear=$year; $prevmonth=11;
$nextyear=$year+1; $nextmonth=1;
}else{
$prevyear=$year; $prevmonth = $month-1;
$nextyear=$year; $nextmonth = $month+1;
}
echo "
";
echo "
" . $monthArr[$month-1] . " $year |
";
echo "";
for($i=0;$i$dayArr1[$i]"; }
echo " ";
$first = date("w", mktime(0,0,0,$month,1,$year));
$lastday = date("t", mktime(0,0,0,$month,1,$year));
$day=1; $end = 0;
for($w=1; $w<7; $w++){
echo "";
for($wd=0; $wd<7; $wd++){
if(($w==1 && $wd<$first) || $day > $lastday){
echo " | ";
}else{
if($day==$lastday){ $end=1; }
if($year==date("Y",$localtime) && $month==date("m",$localtime) && $day==date("d",$localtime)){ $cellstyle="cellnow"; }else{ $cellstyle="cell"; }
if($oCalendar_Date->chkDay_Year($year,$month,$day,$type_id)==TRUE){
$clickdate=$year."-".$month."-".$day;
$oCalendar_Date->data = array("calendar_date.event_id","calendar_date.status","calendar_date.time_from","calendar_date.time_to");
$result = $oCalendar_Date->getEvent_Month($year,$month,$day,$type_id);
$event = ""; $no=0;
while($myrow=mysql_fetch_row($result)){
$no++;
$event_title = stripslashes($oCalendar_Event->getTitle($myrow[0]));
if ($oSystem->getValue("calendar_showmtime")=="Yes"){
$evetime=$oCalendar_Date->getTime_Format($myrow[0],$year,$month,$day);
$evetime=" ".$evetime."";
}else {$evetime="";};
if($myrow[1]=="Cancel"){ $event_title = "$event_title"; }
if($oCalendar_Event->getHighlight($myrow[0])=="Yes"){ $event_highlight="*"; }else{ $event_highlight=""; }
if ($oSystem->getValue("calendar_detailsdisplay")=="Same"){
$event .= "$no. $event_title$event_highlight$evetime ";
} else {
$event .= "$no. $event_title$event_highlight$evetime ";
}
}mysql_free_result($result);
echo "
".$day++.".
".($event!=""?"":" ")." | ";
}else{
echo " ".$day++.".
| ";
}
}
}
echo " ";
if($end==1){ break; }
}
echo "
|
";
}
if($calview=="week"){
$d = $oCalendar->getFDayOfWeek($year,$month,$day);
$prevyear = date("Y",$d-$weekInterval);
$prevmonth = date("m",$d-$weekInterval);
$prevday = date("d",$d-$weekInterval);
$nextyear = date("Y",$d+$weekInterval);
$nextmonth = date("m",$d+$weekInterval);
$nextday = date("d",$d+$weekInterval);
echo "
";
echo "
";
echo "";
for($wd=0; $wd<7; $wd++){
$year = date("Y",$d); $month = date("m",$d); $day = date("d",$d);
$dayname = $lang['calendar'][strtolower(date("l",$d))];
$monthname = $lang['calendar'][strtolower(date("M",$d))]." ".date("j",$d);
echo "$dayname $monthname | ";
$d += $dayInterval;
}
echo " ";
$d = $oCalendar->getFDayOfWeek($year,$month,$day);
$c = mktime(0,0,0,date("m",$localtime),date("d",$localtime),date("Y",$localtime));
echo "";
for($wd=0; $wd<7; $wd++){
if($d==$c){ $cellstyle="cellnow"; }else{ $cellstyle="cell"; }
$year = date("Y",$d); $month = date("m",$d); $day = date("d",$d); $event = "";
$clickdate=$year."-".$month."-".$day;
$oCalendar_Date->data = array("calendar_date.event_id","calendar_date.status");
$result = $oCalendar_Date->getEvent_Month($year,$month,$day,$type_id);
while($myrow=mysql_fetch_row($result)){
$event_title = stripslashes($oCalendar_Event->getTitle($myrow[0]));
$event_time = $oCalendar_Date->getTime_Week($myrow[0],$year,$month,$day,$type_id);
$event_time = (!empty($event_time)?" ".$event_time:"");
if($myrow[1]=="Cancel"){ $event_title = "$event_title"; $event_time = "$event_time"; }
if($oCalendar_Event->getHighlight($myrow[0])=="Yes"){ $event_highlight="*"; }else{ $event_highlight=""; }
if ($oSystem->getValue("calendar_detailsdisplay")=="Same"){
$event .= "$event_title $event_highlight $event_time
";
} else {
$event .= "$event_title $event_highlight $event_time
";
}
}
mysql_free_result($result);
echo " | ";
$d += $dayInterval;
}
echo "
|
";
}
if($calview=="day"){
$d = mktime(0,0,0,$month,$day,$year);
$prevyear = date("Y",$d-$dayInterval);
$prevmonth = date("m",$d-$dayInterval);
$prevday = date("d",$d-$dayInterval);
$nextyear = date("Y",$d+$dayInterval);
$nextmonth = date("m",$d+$dayInterval);
$nextday = date("d",$d+$dayInterval);
echo "
";
$d = mktime(0,0,0,$month,$day,$year);
$dayname = $lang['calendar'][strtolower(date("l",$d))];
$monthname = $lang['calendar'][strtolower(date("F",$d))];
$thisdate = $dayname." - ".$monthname." ".date(" j, Y", $d);
echo "
$thisdate |
";
$clickdate=$year."-".$month."-".$day;
$beginhour = $oSystem->getValue("calendar_beginhour");
for($h=$beginhour; $h<24; $h++){
$d = mktime($h,0,0,$month,$day,$year);
$c = mktime(date("G",$localtime),0,0,date("m",$localtime),date("d",$localtime),date("Y",$localtime));
if($d==$c){ $cellstyle="cellnow"; }else{ $cellstyle="cell"; }
if($h<10){ $hour = "0".$h; }else{ $hour = $h; }
$event = "";
$oCalendar_Date->data = array("calendar_date.event_id","time_format(calendar_date.time_from,'%H')","time_format(calendar_date.time_to,'%H')","calendar_date.time_from","calendar_date.time_to","calendar_date.status");
$result = $oCalendar_Date->getEvent_Day($year,$month,$day,$hour,$type_id);
while($myrow=mysql_fetch_row($result)){
$event_title = stripslashes($oCalendar_Event->getTitle($myrow[0]));
$event_time = $oCalendar_Date->getTime_Day($myrow[0],$year,$month,$day,$hour);
if($oCalendar_Event->getHighlight($myrow[0])=="Yes"){ $event_highlight="*"; }else{ $event_highlight=""; }
if($event_time!="" || ($myrow[1]<=$hour && $myrow[2]>=$hour )) {
if($myrow[5]=="Cancel"){ $event_title = "$event_title"; $event_time = "$event_time"; }
if ($oSystem->getValue("calendar_detailsdisplay")=="Same"){
$event .= "- $event_title $event_highlight $event_time ";
} else {
$event .= "- $event_title $event_highlight $event_time ";
}
}
}
mysql_free_result($result);
$event = substr($event,0,strrpos($event," "));
if($oSystem->getValue("calendar_timeformat")=="12"){ $time = date("g:00 a",mktime($h,0,0,1,1,1)); }else{ $time = date("G:00",mktime($h,0,0,1,1,1)); }
echo "$time | $event | ";
}
echo "
|
";
}
if($calview=="event"){
$oCalendar_Event->data = array("type_id","title","venue","datefrom","dateuntil","time_format(timefrom,'%l')","time_format(timefrom,'%i')","time_format(timefrom,'%p')","time_format(timeuntil,'%l')","time_format(timeuntil,'%i')","time_format(timeuntil,'%p')","recur_event","recur_every","recur_day","highlight","description","contactname1","contactemail1","contactphone1","contactname2","contactemail2","contactphone2","whole_day");
$result=$oCalendar_Event->getDetail($event_id);
if($myrow=mysql_fetch_row($result)){
$title=stripslashes($myrow[1]);
$venue=stripslashes($myrow[2]);
$datefrom=$myrow[3];
$dateuntil=$myrow[4];
$timefrom_h=$myrow[5];
$timefrom_m=$myrow[6];
$timefrom_a=$myrow[7];
$timeuntil_h=$myrow[8];
$timeuntil_m=$myrow[9];
$timeuntil_a=$myrow[10];
$recur_event=$myrow[11];
$recur_every=$myrow[12];
$recur_day=$myrow[13];
$highlight=($myrow[14]=="Yes"?"
*":"");
$description=stripslashes($myrow[15]);
$contactname1=stripslashes($myrow[16]);
$contactemail1=stripslashes($myrow[17]);
$contactphone1=stripslashes($myrow[18]);
$contactname2=stripslashes($myrow[19]);
$contactemail2=stripslashes($myrow[20]);
$contactphone2=stripslashes($myrow[21]);
$dateevent = $oCalendar_Date->getDate_Event($event_id,$recur_event,$clickdate);
$timeevent = $oCalendar_Date->getTime_Event($event_id,$recur_event);
$type = stripslashes($oCalendar_Type->getName($myrow[0]));
}
mysql_free_result($result);
$label_eventdate=$oCalendar_Date->getViewDate($event_id,$clickdate);
$border = "border: ".$oSystem->getValue("calendar_borderwidth")."px ".$oSystem->getValue("calendar_bordercolor")." solid";
echo "
".$lang['calendar']['eventdetail']."
|
";
if($title!=""){ echo "".$lang['calendar']['event']." | : | $title $highlight | "; }
if($venue!=""){ echo "".$lang['calendar']['venue']." | : | $venue | "; }
if($clickdate!=""){ echo "".$lang['calendar']['eventdate']." | : | $label_eventdate | "; }
if($oSystem->getValue("calendar_shownextdate")=="Yes" && $dateevent!=""){ echo "".$lang['calendar']['nextdate']." | : | $dateevent | "; }
if($timeevent!=""){ echo "".$lang['calendar']['time']." | : | $timeevent | "; }
if($type!=""){ echo "".$lang['calendar']['type']." | : | $type | "; }
if($description!=""){ echo "".$lang['calendar']['description']." | : | | $description | "; }
$contact1 = "$contactname1".($contactemail1!=""?" , $contactemail1":"").($contactphone1!=""?" , $contactphone1":"");
$contact2 = "$contactname2".($contactemail2!=""?" , $contactemail2":"").($contactphone2!=""?" , $contactphone2":"");
if(($oSystem->getValue("calendar_showcontact")=="Yes") && ($contact1!="" || $contact2!="")){ echo " | ".$lang['calendar']['contactperson']." | : | $contact1 $contact2 | "; }
if($pageaction=="tellfriend"){
$oCalendar_Event->validate($lang['calendar']['yourname'],$tellyourname,"NotEmpty");
$oCalendar_Event->validate($lang['calendar']['youremail'],$tellyouremail,"NotEmpty");
$oCalendar_Event->validate($lang['calendar']['friendname'],$tellfriendname,"NotEmpty");
$oCalendar_Event->validate($lang['calendar']['friendemail'],$tellfriendemail,"NotEmpty");
if ($tellyouremail!=""){ $oCalendar_Event->validate($lang['calendar']['youremail'],$tellyouremail,"IsEmail"); }
if ($tellfriendemail!=""){ $oCalendar_Event->validate($lang['calendar']['friendemail'],$tellfriendemail,"IsEmail"); }
$emailadmin = $oUser->getAdminEmail();
if(empty($emailadmin)){ $status_message="".$lang['calendar']['emailfail']." "; }
if ($status_message==""){
$eventurl = $oSystem->getValue("calendar_pageurl")."?calview=event&event_id=$event_id&clickdate=$clickdate";
$subject = stripslashes($oSystem->getValue("calendar_tellsubject"));
$body = stripslashes($oSystem->getValue("calendar_tellmessage"));
$body = str_replace("[[name]]",$tellfriendname,$body);
$body = str_replace("[[yourname]]",$tellyourname,$body);
$body = str_replace("[[title]]",$title,$body);
$body = str_replace("[[date]]",$label_eventdate,$body);
$body = str_replace("[[time]]",$timeevent,$body);
$body = str_replace("[[venue]]",$venue,$body);
$body = str_replace("[[message]]",stripslashes($tellmessage),$body);
$body = str_replace("[[eventurl]]",$eventurl,$body);
$body = str_replace(" ","\r\n",$body);
$body = str_replace("","",$body);
$body = str_replace(""," (".$lang['calendar']['cancel'].")",$body);
$oSystem->mail($tellfriendemail,$subject,$body,$tellyouremail);
$tellyourname=""; $tellyouremail=""; $tellfriendname=""; $tellfriendemail=""; $tellmessage="";
$status_message = "".$lang['calendar']['status']." : ".$lang['calendar']['emailsent']." ";
}
} else { $status_message=""; }
if ($oSystem->getValue("calendar_showemail")=="Yes"){
echo "
".$lang['calendar']['tellafriend']." $status_message |
";
}
if($pageaction=="remind"){
$oCalendar_Event->validate($lang['calendar']['yourname'],$remindyourname,"NotEmpty");
$oCalendar_Event->validate($lang['calendar']['youremail'],$remindyouremail,"NotEmpty");
if ($remindyouremail!=""){ $oCalendar_Event->validate($lang['calendar']['youremail'],$remindyouremail,"IsEmail"); }
if ($remindday!=""){ $oCalendar_Event->validate($lang['calendar']['remindmein'],$remindday,"IsInteger"); }
if ($status_message==""){
$nearest = $oCalendar_Date->getNearestDate($event_id);
if($nearest!=""){
$nearstamp = mktime(0,0,0,substr($nearest, 5,2),substr($nearest,8,2),substr($nearest, 0,4));
$dateremind = date("Y-m-d", $nearstamp - $remindday * 24 * 60 * 60);
$oCalendar_Reminder->data = array("event_id", "name", "email", "dateremind", "dateevent");
$oCalendar_Reminder->value = array($event_id, $remindyourname, $remindyouremail, $dateremind, $nearest);
$oCalendar_Reminder->add();
$remindyourname=""; $remindyouremail=""; $dateremind="";
$status_message = "".$lang['calendar']['status']." : ".$lang['calendar']['benotified']." ";
$oSystem->setValue("calendar_lastreminder","");
}
}
} else { $status_message=""; }
if($oCalendar_Date->getNearestDate($event_id)!="" && $oSystem->getValue("calendar_showremind")=="Yes"){
echo "
".$lang['calendar']['remindevent']." $status_message |
";
}
echo "
|
";
}
if ($pageaction=="searchtitle" && $calview=="searchtitle"){
if ($searchby==""){$searchby="bytitle";}
$searchresultkey = array();
$searchkey = str_replace("+"," ",$searchkey);
$vsearchkey=addslashes($searchkey);
$vsearchkey=addslashes($vsearchkey);
$array_stopword = array("a","an","are","you","and","because","begin","bf","both","but","can","do");
$special = array("~","!","@","#","$","%","^","&","*","(",")",",","©","-","+","{","[","}","]",":",".","<",">","|","/","?","'");
if ($searchkey!=""){
if (!in_array($vsearchkey,$special)){
if (!in_array($vsearchkey,$array_stopword)){
$oCalendar_Event->data = array("event_id");
$oCalendar_Event->order = "";
if ($searchby=="bytitle"){
$oCalendar_Event->where="title like '%$vsearchkey%'";
} else {
$oCalendar_Event->where="venue like '%$vsearchkey%'";
}
$result=$oCalendar_Event->getList();
while($myrow=mysql_fetch_row($result)){ if(!in_array($myrow[0],$searchresultkey)){ array_push($searchresultkey,$myrow[0]); } }
mysql_free_result($result);
}
}
$searchkey = preg_replace('/\s+/',' ',$searchkey);
$searchkey=trim($searchkey);
$searchresultkeylist = explode(" ",$searchkey);
for($k=0;$k
where="title like '%$vsearchkey%'";
} else {
$oCalendar_Event->where="venue like '%$vsearchkey%'";
}
$result=$oCalendar_Event->getList();
while($myrow=mysql_fetch_row($result)){ if(!in_array($myrow[0],$searchresultkey)){ array_push($searchresultkey,$myrow[0]); }}
mysql_free_result($result);
}
}
}
}
echo"
";
$listno= $oSystem->getValue("calendar_listno");
$total= count($searchresultkey);
if($start=="" || $start==0){ $start=0; }
$prev=$start-$listno; $next=$start+$listno; $from=$start+1; $to=$listno+$from-1;
if($to>=$total){ $to=$total; }if($to<$from){ $from=0; }
$searchkey1 = stripslashes(htmlentities(str_replace(" ","+",$searchkey),ENT_NOQUOTES,'utf-8'));
if($prev>=0){ $prevlink="".$lang['calendar']['prev'].""; }else{ $prevlink=""; }
if($next<$total){ $nextlink="".$lang['calendar']['next'].""; }else{ $nextlink=""; }
if($prevlink!="" && $nextlink!=""){ $navline=" | "; }
$lblsearchkey=stripslashes(htmlentities($searchkey),ENT_NOQUOTES,'utf-8');
if ($searchby=="bytitle"){
$lblsearchby=$lang['newspublish']['searchbytitile'];
} else {
$lblsearchby=$lang['newspublish']['searchbyvenue'];
}
echo "
$lblsearchby : ".$lang['calendar']['searchfound']."'$lblsearchkey'
|
| ".$lang['calendar']['showing']." ".$from."-".$to." ".$lang['calendar']['of']." ".$total." | $prevlink $navline $nextlink |
";
if(count($searchresultkey)!=0){
echo "
".$lang['calendar']['eventtitle']." | ".$lang['calendar']['datestart']." | ".$lang['calendar']['time']." |
";
for($k=0;$kgetValue("calendar_timeformat")=="12"){ $timeformat="%l:%i %p"; }else{ $timeformat="%k:%i"; }
$dateformat=$oSystem->getValue("calendar_dateformat");
$oCalendar_Event->data = array("event_id","title","date_format(datefrom,'$dateformat')","datefrom","time_format(timefrom,'$timeformat')","time_format(timeuntil,'$timeformat')");
$result=$oCalendar_Event->getDetail($searchresultkey[$k]);
if($myrow=mysql_fetch_row($result)){
if($k >= $start && $k < $start+$listno){
$myrow[1]=stripslashes($myrow[1]);
if ($oSystem->getValue("calendar_detailsdisplay")=="Same"){
echo"$myrow[1] | $myrow[2] | ".$myrow[4]." - ".$myrow[5]." | ";
} else {
echo"$myrow[1] | $myrow[2] | ".$myrow[4]." - ".$myrow[5]." | ";
}
}
} mysql_free_result($result);
}
echo"
|
";
}else{
echo "
".$lang['calendar']['hnofound']." |
";
}
echo "
|
$prevlink $navline $nextlink |
";
}
if ($oSystem->getValue("calendar_showremind")=="Yes"){
/***** Auto Send Reminder *****/
$oCalendar_Reminder->autoSend();
}
?>