setTimestamp($defcurtime->getTimestamp()); $calcurtime->setTimezone($usertz); if(!isset($_GET['HighligtDay'])) { $_GET['HighligtDay'] = null; } if(!isset($_GET['calmadd'])) { $_GET['calmadd'] = 0; } if(!is_numeric($_GET['calmadd'])) { $_GET['calmadd'] = 0; } if((!isset($_GET['calmonth']) && !isset($_GET['calyear'])) && isset($_GET['caldate']) && strlen($_GET['caldate'])==2) { $_GET['caldate'] = $_GET['caldate'].$calcurtime->format("Y"); } if((!isset($_GET['calmonth']) && !isset($_GET['calyear'])) && isset($_GET['caldate']) && strlen($_GET['caldate'])==6) { preg_match_all("/([0-9]{2})([0-9]{4})/is", $_GET['caldate'], $datecheck); $_GET['calmonth'] = $datecheck[1][0]; $_GET['calyear'] = $datecheck[2][0]; } if((isset($_GET['calmonth']) && isset($_GET['calyear'])) && (strlen($_GET['calmonth'])==2&&strlen($_GET['calyear'])==4) ) { $year1 = date("Y", strtotime($_GET['calyear']."-".$_GET['calmonth']."-01")); $year2 = date("Y", $utccurtime->getTimestamp()); $month1 = date("m", strtotime($_GET['calyear']."-".$_GET['calmonth']."-01")); $month2 = date("m", $utccurtime->getTimestamp()); $redirdate = ((($year2 - $year1) * 12) + ($month2 - $month1)) * -1; $_GET['calmadd'] = $redirdate; } $nextcalm = $_GET['calmadd'] + 1; $backcalm = $_GET['calmadd'] - 1; $calmcount = abs($_GET['calmadd']); $getcurmonth = $usercurtime->format("m"); $getcuryear = $usercurtime->format("y"); $getcurtmsp = mktime(0, 0, 0, $getcurmonth, 1, $getcuryear); $getnextmsp = mktime(0, 0, 0, ($getcurmonth + $nextcalm), 1, $getcuryear); $nexmonthnum = date("m", $getnextmsp); $nexyearnum = date("Y", $getnextmsp); $nexcaldate = $nexmonthnum.$nexyearnum; $getbactmsp = mktime(0, 0, 0, ($getcurmonth + $backcalm), 1, $getcuryear); $bacmonthnum = date("m", $getbactmsp); $bacyearnum = date("Y", $getbactmsp); $baccaldate = $bacmonthnum.$bacyearnum; $tmpcalmnum = 0; $tmpcalmadd = 0; $tmpcalcount = 1; if($_GET['calmadd']>0) { while($tmpcalcount <= $calmcount) { $calcurtime->setTimestamp($defcurtime->getTimestamp()+$tmpcalmadd); $tmpdaystart = $calcurtime->format("d"); $tmpdaycount = $calcurtime->format("t"); if($tmpdaystart>=1) { $tmpcalmnum += ($tmpdaycount - $tmpdaystart) + 1; } if($tmpdaystart<1) { $tmpcalmnum += $tmpdaycount; } $tmpcalmadd = $tmpcalmnum * $dayconv['day']; ++$tmpcalcount; } $calmounthaddd = $tmpcalmadd; } if($_GET['calmadd']<0) { while($tmpcalcount <= $calmcount) { $calcurtime->setTimestamp($defcurtime->getTimestamp()+$tmpcalmadd); $tmpdaystart = $calcurtime->format("d"); $tmpdaycount = $calcurtime->format("t"); if($tmpdaystart>=1) { $tmpcalmnum -= $tmpdaystart + 1; } if($tmpdaystart<1) { $tmpcalmnum -= $tmpdaycount; } $tmpcalmadd = $tmpcalmnum * $dayconv['day']; ++$tmpcalcount; } $calmounthaddd = $tmpcalmadd; } // Extra month stuff $MyRealMonthNum1 = $usercurtime->format("m"); $MyRealYear = $usercurtime->format("Y"); // Count the Days in this month if(!isset($calmounthaddd)) { $calmounthaddd = 0; } $MyTimeStamp = $utccurtime->getTimestamp() + $calmounthaddd; //$calcurtime->setTimestamp($defcurtime->getTimestamp()+$calmounthaddd); $calcurtime->setDate($_GET['calyear'], $_GET['calmonth'], 1); $CountDays = $calcurtime->format("t"); $MyDay = $calcurtime->format("j"); $MyDay2 = $calcurtime->format("jS"); $MyDayNum = $calcurtime->format("d"); $MyDayName = $calcurtime->format("l"); $MyYear = $calcurtime->format("Y"); $MyYear2 = $calcurtime->format("y"); $MyMonth = $calcurtime->format("m"); $MyTimeStamp1 = mktime(0,0,0,$MyMonth,1,$MyYear); $MyTimeStamp2 = mktime(23,59,59,$MyMonth,$CountDays,$MyYear); $MyMonthName = $calcurtime->format("F"); $MyMonthNum1 = $calcurtime->format("m"); $MyMonthNum2 = $calcurtime->format("n"); $FirstDayThisMonth = date("w", mktime(0, 0, 0, $MyMonth, 1, $MyYear)); $MyCurDay = $usercurtime->format("j"); $MyCurYear = $usercurtime->format("Y"); $MyCurMonth = $usercurtime->format("m"); $EventsName = array(); $query = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."events\" WHERE (\"EventMonth\">=%i AND \"EventYear\"<%i AND \"EventYearEnd\">=%i) OR (\"EventMonth\"<=%i AND \"EventMonthEnd\">=%i AND \"EventYearEnd\">=%i) OR (\"EventMonth\"<=%i AND \"EventMonthEnd\"<=%i AND \"EventYear\"<=%i AND \"EventYearEnd\">%i)", array($MyMonth,$MyYear,$MyYear,$MyMonth,$MyMonth,$MyYear,$MyMonth,$MyMonth,$MyYear,$MyYear)); $result=sql_query($query,$SQLStat); $num=sql_num_rows($result); $is=0; while ($is < $num) { $EventID=sql_result($result,$is,"id"); $EventUser=sql_result($result,$is,"UserID"); $EventGuest=sql_result($result,$is,"GuestName"); $EventName=sql_result($result,$is,"EventName"); $EventText=sql_result($result,$is,"EventText"); $EventStart=sql_result($result,$is,"TimeStamp"); $EventEnd=sql_result($result,$is,"TimeStampEnd"); $eventstartcurtime = new DateTime(); $eventstartcurtime->setTimestamp($EventStart); $eventstartcurtime->setTimezone($usertz); $eventendcurtime = new DateTime(); $eventendcurtime->setTimestamp($EventEnd); $eventendcurtime->setTimezone($usertz); //$EventMonth=sql_result($result,$is,"EventMonth"); $EventMonth=$eventstartcurtime->format("m"); //$EventMonthEnd=sql_result($result,$is,"EventMonthEnd"); $EventMonthEnd=$eventendcurtime->format("m"); //$EventDay=sql_result($result,$is,"EventDay"); $EventDay=$eventstartcurtime->format("j"); //$EventDayEnd=sql_result($result,$is,"EventDayEnd"); $EventDayEnd=$eventendcurtime->format("j"); //$EventYear=sql_result($result,$is,"EventYear"); $EventYear=$eventstartcurtime->format("Y"); //$EventYearEnd=sql_result($result,$is,"EventYearEnd"); $EventYearEnd=$eventendcurtime->format("Y"); if($EventMonthEnd!=$MyMonth) { $EventDayEnd = $CountDays; } if($EventMonth<$MyMonth) { $EventDay = 1; } $oldeventname=$EventName; $EventName1 = pre_substr($EventName,0,20); if (pre_strlen($EventName)>20) { $EventName1 = $EventName1."..."; } $EventName=$EventName1; if(!isset($EventsName[$EventDay])) { $EventsName[$EventDay] = null; } if ($EventsName[$EventDay] != null) { $EventsName[$EventDay] .= ", ".$EventName.""; } if ($EventsName[$EventDay] == null) { $EventsName[$EventDay] = "".$EventName.""; } if ($EventDay<$EventDayEnd) { $NextDay = $EventDay+1; $EventDayEnd = $EventDayEnd+1; while ($NextDay < $EventDayEnd) { if(!isset($EventsName[$NextDay])) { $EventsName[$NextDay] = null; } if ($EventsName[$NextDay] != null) { $EventsName[$NextDay] .= ", ".$EventName.""; } if ($EventsName[$NextDay] == null) { $EventsName[$NextDay] = "".$EventName.""; } $NextDay++; } } $EventsID[$EventDay] = $EventID; ++$is; } sql_free_result($result); $bdquery = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."members\" WHERE \"BirthMonth\"=%i AND \"BirthYear\"<=%i", array($MyMonth, $MyYear)); $bdresult=sql_query($bdquery,$SQLStat); $bdnum=sql_num_rows($bdresult); $bdi=0; while ($bdi < $bdnum) { $UserNamebd=sql_result($bdresult,$bdi,"Name"); $BirthDay=sql_result($bdresult,$bdi,"BirthDay"); $BirthMonth=sql_result($bdresult,$bdi,"BirthMonth"); $BirthYear=sql_result($bdresult,$bdi,"BirthYear"); $UserCurAge=$MyYear-$BirthYear; $oldusername=$UserNamebd; $UserNamebd1 = pre_substr($UserNamebd,0,20); if (pre_strlen($UserNamebd)>20) { $UserNamebd1 = $UserNamebd1."..."; } $UserNamebd=$UserNamebd1; if(!isset($EventsName[$BirthDay])) { $EventsName[$BirthDay] = null; } if ($EventsName[$BirthDay] != null) { $EventsName[$BirthDay] .= ", ".$UserNamebd1.""; } if ($EventsName[$BirthDay] == null) { $EventsName[$BirthDay] = "".$UserNamebd1.""; } ++$bdi; } sql_free_result($bdresult); $MyDays = array("Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday"); $DayNames = ""; foreach ($MyDays as $x => $y) { $DayNames .= '' . $y . ''."\r\n"; } $WeekDays = ""; $i = $FirstDayThisMonth + 1; if ($FirstDayThisMonth != "0") { $WeekDays .= ' '."\r\n"; } $Day_i = "1"; $ii = $i; for ($i; $i <= ($CountDays + $FirstDayThisMonth) ;$i++) { if ($ii == 8) { $WeekDays .= ""."\r\n"; $ii = 1; } if ($MyCurDay == $Day_i && $MyCurMonth == $MyRealMonthNum1 && $MyCurYear == $MyRealYear) { $Extra = 'CalTableColumn3Current'; } else { $Extra = 'CalTableColumn3'; } if ($Day_i != $_GET['HighligtDay']) { if(!isset($EventsName[$Day_i])) { $EventsName[$Day_i] = null; } if($EventsName[$Day_i]!=null) { $EventsName[$Day_i] = " ( ".$EventsName[$Day_i]." )"; } if ($Day_i != $MyCurDay) { $WeekDays .= '
' . $Day_i . '
' . $EventsName[$Day_i] . ''."\r\n"; } } if ($Day_i == $MyCurDay) { $WeekDays .= '
' . $Day_i . '
' . $EventsName[$Day_i] . ''."\r\n"; } $Day_i++; $ii++; } if ((8 - $ii) >= "1") { $WeekDays .= ' '."\r\n"; } ?>
" title="">    "><">>  
    "><">>