inc/calendars.php

   1 <?php
   2 /*
   3     This program is free software; you can redistribute it and/or modify
   4     it under the terms of the Revised BSD License.
   5
   6     This program is distributed in the hope that it will be useful,
   7     but WITHOUT ANY WARRANTY; without even the implied warranty of
   8     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   9     Revised BSD License for more details.
  10
  11     Copyright 2004-2010 iDB Support - http://idb.berlios.de/
  12     Copyright 2004-2010 Game Maker 2k - http://gamemaker2k.org/
  13
  14     $FileInfo: calendars.php - Last Update: 10/12/2010 SVN 587 - Author: cooldude2k $
  15 */
  16 $File3Name = basename($_SERVER['SCRIPT_NAME']);
  17 if ($File3Name=="calendars.php"||$File3Name=="/calendars.php") {
  18         require('index.php');
  19         exit(); }
  20 $_SESSION['ViewingPage'] = url_maker(null,"no+ext","act=view","&","=",null,null);
  21 if($Settings['file_ext']!="no+ext"&&$Settings['file_ext']!="no ext") {
  22 $_SESSION['ViewingFile'] = $exfile['calendar'].$Settings['file_ext']; }
  23 if($Settings['file_ext']=="no+ext"||$Settings['file_ext']=="no ext") {
  24 $_SESSION['ViewingFile'] = $exfile['calendar']; }
  25 $_SESSION['PreViewingTitle'] = "Viewing";
  26 $_SESSION['ViewingTitle'] = "Calendar";
  27 if(!isset($_GET['HighligtDay'])) { $_GET['HighligtDay'] = null; }
  28 // Count the Days in this month
  29 $MyTimeStamp = GMTimeStamp();
  30 $CountDays = GMTimeGet("t",$_SESSION['UserTimeZone'],0,$_SESSION['UserDST']);
  31 $MyDay = GMTimeGet("j",$_SESSION['UserTimeZone'],0,$_SESSION['UserDST']);
  32 $MyDay2 = GMTimeGet("jS",$_SESSION['UserTimeZone'],0,$_SESSION['UserDST']);
  33 $MyDayNum = GMTimeGet("d",$_SESSION['UserTimeZone'],0,$_SESSION['UserDST']);
  34 $MyDayName = GMTimeGet("l",$_SESSION['UserTimeZone'],0,$_SESSION['UserDST']);
  35 $MyYear = GMTimeGet("Y",$_SESSION['UserTimeZone'],0,$_SESSION['UserDST']);
  36 $MyYear2 = GMTimeGet("y",$_SESSION['UserTimeZone'],0,$_SESSION['UserDST']);
  37 $MyMonth = GMTimeGet("m",$_SESSION['UserTimeZone'],0,$_SESSION['UserDST']);
  38 $MyTimeStamp1 = mktime(0,0,0,$MyMonth,1,$MyYear);
  39 $MyTimeStamp2 = mktime(23,59,59,$MyMonth,$CountDays,$MyYear);
  40 $MyMonthName = GMTimeGet("F",$_SESSION['UserTimeZone'],0,$_SESSION['UserDST']);
  41 $FirstDayThisMonth = date("w", mktime(0, 0, 0, $MyMonth, 1, $MyYear));
  42 $EventsName = array();
  43 $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));
  44 $result=sql_query($query,$SQLStat);
  45 $num=sql_num_rows($result);
  46 $is=0;
  47 while ($is < $num) {
  48 $EventID=sql_result($result,$is,"id");
  49 $EventUser=sql_result($result,$is,"UserID");
  50 $EventGuest=sql_result($result,$is,"GuestName");
  51 $EventName=sql_result($result,$is,"EventName");
  52 $EventText=sql_result($result,$is,"EventText");
  53 $EventStart=sql_result($result,$is,"TimeStamp");
  54 $EventEnd=sql_result($result,$is,"TimeStampEnd");
  55 $EventMonth=sql_result($result,$is,"EventMonth");
  56 $EventMonthEnd=sql_result($result,$is,"EventMonthEnd");
  57 $EventDay=sql_result($result,$is,"EventDay");
  58 $EventDayEnd=sql_result($result,$is,"EventDayEnd");
  59 $EventYear=sql_result($result,$is,"EventYear");
  60 $EventYearEnd=sql_result($result,$is,"EventYearEnd");
  61 if($EventMonthEnd!=$MyMonth) { $EventDayEnd = $CountDays; }
  62 if($EventMonth<$MyMonth) { $EventDay = 1; }
  63 $oldeventname=$EventName;
  64 $EventName1 = pre_substr($EventName,0,20);
  65 if (pre_strlen($EventName)>20) { $EventName1 = $EventName1."..."; }
  66 $EventName=$EventName1;
  67 if(!isset($EventsName[$EventDay])) { $EventsName[$EventDay] = null; }
  68 if ($EventsName[$EventDay] != null) {
  69         $EventsName[$EventDay] .= ", <a href=\"".url_maker($exfile['event'],$Settings['file_ext'],"act=event&id=".$EventID,$Settings['qstr'],$Settings['qsep'],$prexqstr['event'],$exqstr['event'])."\" style=\"font-size: 9px;\" title=\"View Event ".$oldeventname.".\">".$EventName."</a>";   }
  70 if ($EventsName[$EventDay] == null) {
  71         $EventsName[$EventDay] = "<a href=\"".url_maker($exfile['event'],$Settings['file_ext'],"act=event&id=".$EventID,$Settings['qstr'],$Settings['qsep'],$prexqstr['event'],$exqstr['event'])."\" style=\"font-size: 9px;\" title=\"View Event ".$oldeventname.".\">".$EventName."</a>"; }
  72 if ($EventDay<$EventDayEnd) {
  73 $NextDay = $EventDay+1;
  74 $EventDayEnd = $EventDayEnd+1;
  75 while ($NextDay < $EventDayEnd) {
  76 if(!isset($EventsName[$NextDay])) { $EventsName[$NextDay] = null; }
  77 if ($EventsName[$NextDay] != null) {
  78         $EventsName[$NextDay] .= ", <a href=\"".url_maker($exfile['event'],$Settings['file_ext'],"act=event&id=".$EventID,$Settings['qstr'],$Settings['qsep'],$prexqstr['event'],$exqstr['event'])."\" style=\"font-size: 9px;\" title=\"View Event ".$oldeventname.".\">".$EventName."</a>";    }
  79 if ($EventsName[$NextDay] == null) {
  80         $EventsName[$NextDay] = "<a href=\"".url_maker($exfile['event'],$Settings['file_ext'],"act=event&id=".$EventID,$Settings['qstr'],$Settings['qsep'],$prexqstr['event'],$exqstr['event'])."\" style=\"font-size: 9px;\" title=\"View Event ".$oldeventname.".\">".$EventName."</a>"; }
  81 $NextDay++; } }
  82 $EventsID[$EventDay] = $EventID;
  83 ++$is; }
  84 sql_free_result($result);
  85 $bdquery = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."members\" WHERE \"BirthMonth\"=%i", array($MyMonth));
  86 $bdresult=sql_query($bdquery,$SQLStat);
  87 $bdnum=sql_num_rows($bdresult);
  88 $bdi=0;
  89 while ($bdi < $bdnum) {
  90 $UserNamebd=sql_result($bdresult,$bdi,"Name");
  91 $BirthDay=sql_result($bdresult,$bdi,"BirthDay");
  92 $BirthMonth=sql_result($bdresult,$bdi,"BirthMonth");
  93 $BirthYear=sql_result($bdresult,$bdi,"BirthYear");
  94 $oldusername=$UserNamebd;
  95 $UserNamebd1 = pre_substr($UserNamebd,0,20);
  96 if (pre_strlen($UserNamebd)>20) { $UserNamebd1 = $UserNamebd1."..."; }
  97 $UserNamebd=$UserNamebd1;
  98 if(!isset($EventsName[$BirthDay])) { $EventsName[$BirthDay] = null; }
  99 if ($EventsName[$BirthDay] != null) {
 100         $EventsName[$BirthDay] .= ", <span title=\"".$oldusername."'s birthday.\">".$UserNamebd1."</span>";      }
 101 if ($EventsName[$BirthDay] == null) {
 102         $EventsName[$BirthDay] = "<span title=\"".$oldusername."'s birthday.\">".$UserNamebd1."</span>"; }
 103 ++$bdi; }
 104 sql_free_result($bdresult);
 105 $MyDays = array("Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday");
 106 $DayNames = "";
 107 foreach ($MyDays as $x => $y) {
 108     $DayNames .= '<th class="CalTableColumn2" style="width: 12%;">' . $y . '</th>'."\r\n";
 109 }
 110 $WeekDays = "";
 111 $i = $FirstDayThisMonth + 1;
 112 if ($FirstDayThisMonth != "0") {
 113     $WeekDays .= '<td class="CalTableColumn3Blank" style="text-align: center;" colspan="' . $FirstDayThisMonth . '">&nbsp;</td>'."\r\n";
 114 }
 115 $Day_i = "1";
 116 $ii = $i;
 117 for ($i; $i <= ($CountDays + $FirstDayThisMonth) ;$i++) {
 118 if ($ii == 8) {
 119 $WeekDays .= "</tr><tr class=\"CalTableRow3\">"."\r\n";
 120 $ii = 1; }
 121  if ($MyDay == $Day_i) {
 122 $Extra = 'CalTableColumn3Current'; }
 123 else {
 124 $Extra = 'CalTableColumn3'; }
 125 if ($Day_i != $_GET['HighligtDay']) {
 126 if(!isset($EventsName[$Day_i])) { $EventsName[$Day_i] = null; }
 127 if($EventsName[$Day_i]!=null) { $EventsName[$Day_i] = "&nbsp;( ".$EventsName[$Day_i]." )"; }
 128 if ($Day_i != $MyDay) {
 129 $WeekDays .= '<td class="'.$Extra.'" style="vertical-align: top;"><div class="CalDate">' . $Day_i . '</div>' . $EventsName[$Day_i] . '</td>'."\r\n";     }      }
 130 if ($Day_i == $MyDay) {
 131 $WeekDays .= '<td class="'.$Extra.'" style="vertical-align: top;"><div class="CalDateCurrent">' . $Day_i  . '</div>' . $EventsName[$Day_i] . '</td>'."\r\n";     }
 132 $Day_i++;
 133 $ii++;
 134 }
 135 if ((8 - $ii) >= "1") {
 136 $WeekDays .= '<td class="CalTableColumn3Blank" style="text-align: center;" colspan="' . (8 - $ii) . '">&nbsp;</td>'."\r\n"; } ?>
 137 <div class="NavLinks"><?php echo $ThemeSet['NavLinkIcon']; ?><a href="<?php echo url_maker($exfile['index'],$Settings['file_ext'],"act=view",$Settings['qstr'],$Settings['qsep'],$prexqstr['index'],$exqstr['index']); ?>">Board index</a><?php echo $ThemeSet['NavLinkDivider']; ?><a href="<?php echo url_maker($exfile['calendar'],$Settings['file_ext'],"act=view",$Settings['qstr'],$Settings['qsep'],$prexqstr['calendar'],$exqstr['calendar']); ?>">Calendar</a></div>
 138 <div class="DivNavLinks">&nbsp;</div>
 139 <div class="CalTable1Border">
 140 <?php if($ThemeSet['TableStyle']=="div") { ?>
 141 <div class="CalTableRow1" style="font-weight: bold;">
 142 <span style="float: left;"><?php echo $ThemeSet['TitleIcon']; ?><?php echo "Today is ".$MyDayName." the ".$MyDay2." of ".$MyMonthName.", ".$MyYear; ?></span>
 143 <span style="float: right;"><?php echo "The time is ".GMTimeGet('g:i a',$_SESSION['UserTimeZone'],0,$_SESSION['UserDST']); ?>&nbsp;</span>&nbsp;</div>
 144 <?php } ?>
 145 <table class="CalTable1">
 146 <?php if($ThemeSet['TableStyle']=="table") { ?>
 147 <tr class="CalTableRow1">
 148 <th class="CalTableColumn1" colspan="7">
 149 <span style="float: left;"><?php echo $ThemeSet['TitleIcon']; ?><?php echo "Today is ".$MyDayName." the ".$MyDay2." of ".$MyMonthName.", ".$MyYear; ?></span>
 150 <span style="float: right;"><?php echo "The time is ".GMTimeGet('g:i a',$_SESSION['UserTimeZone'],0,$_SESSION['UserDST']); ?>&nbsp;</span>
 151 &nbsp;</th>
 152 </tr><?php } ?>
 153 <tr class="CalTableRow2">
 154 <?php echo $DayNames; ?>
 155 </tr><tr class="CalTableRow3">
 156 <?php echo $WeekDays; ?>
 157 </tr>
 158 <tr class="CalTableRow4">
 159 <td class="CalTableColumn4" colspan="7">&nbsp;</td>
 160 </tr>
 161 </table></div>
 162 <div class="DivCalendar">&nbsp;</div>