FlexCMS eNews
To subscribe to our enewsletter, please enter your email address in the box below and click the "Subscribe" button.
Note: You may easily remove yourself from the newsletter list at any time by following the instructions included with every mailing. |
|
| |
Home > FlexCMS Support Forum > User Help > Code Snippets > Upcoming Calendar Events in a Page
FlexCMS Support Forum
Upcoming Calendar Events in a Page
Started June 21, 2005 @ 7:53pm by jacmgr
|
Post Message |
|
|
| Upcoming Calendar Events in a Page | June 21, 2005 @ 7:53pm | This is a modified version of the code that the FLEX team posted for the TODAYS EVENTS in a BLOCK.
If you have a page that is set to process php, you can add this code to display a list of upcoming events in your page. I found it easier to save this snippet as its own file and then use a php include statement in the page where I want it to appear. But you can simpley copy and paste this directly into your page. All you have to do is set the variables near the top for the number of days you want to show and the title you want to appear in the table header.
See it in action at http://www.vacationrentalworkshop.com/poconos near the bottom of the page.
// ----------------------------------------------
// ----------------------------------------------
// Prints a table of upcoming calendar data
// Includes Events, Holidays (how to choose?)
// Defualts to 90 days
// ----------------------------------------------
// requires these variable set:
// $future = 120; //number of days to get
// $eventtype = '1,2'; // not implemented yet!!
// $mytitle = '<h1>Upcoming Events</h1>';
// The table can have a CSS class if you want to format it nicely.
// Just give the table a class and put formats on the TH and TD
// You will have to put that CSS in your template file in the HEAD section.
// ----------------------------------------------
$future = 120; //number of days to get
$eventtype = '1,2'; // not implemented yet!!
$mytitle = '<h1>Upcoming Events</h1>';
// ----------------------------------------------
print $mytitle;
$TZO = (($Settings['TimezoneOffset']+5)*3600);
//todays date
$DateSplit = getdate();
$DayTimestamp = mktime(0,0,0,$DateSplit['mon'],$DateSplit['mday'],$DateSplit['year']);
//THIS IS GENERALIZED FOR NEXT $future days
$DayTimestampEND = mktime(0,0,0,$DateSplit['mon'],$DateSplit['mday']+$future,$DateSplit['year']);
$query55 = "select * from `".$Settings['DBPrefix']."cl-EventDates` where DateCode>=".($DayTimestamp+$TZO)." and DateCode<".($DayTimestampEND)." order by DateCode asc";
$result55 = mysql_query($query55) or die (mysql_error());
// ----------------------------------------------
// END of Main Query to get events header for events in the date range
// ----------------------------------------------
//
//print the table header
//
print '<table class="j_style1">
<tr><th>Date and Description<br>click on date for more info</th>
</tr>';
// -----------------------------------
// For each event query the details and print the table rows
// ------------------------------------
if (mysql_num_rows($result55) > 0)
{
while ($row55 = mysql_fetch_array($result55))
{
$query5 = "select * from `".$Settings['DBPrefix']."cl-Events` where RecordNumber='".$row55['EventID']."' and MinLevel<='".$UserLevel."' limit 1";
$result5 = mysql_query($query5) or die (mysql_error());
if (mysql_num_rows($result5) > 0)
{
$row5 = mysql_fetch_array($result5);
$a = date("D M j", $row55['DateCode']);
$LinkString='<a href="'.$MainURL.'/calendar/details/'.$row5['RecordNumber'].'.html">'.$a.'</a>';
// print the table row
print '<tr><td align="center"> '.$LinkString.' : '.$row5['Title'].'</td></tr>';
$EventsPrinted++;
}
}
}
if ($EventsPrinted < 1)
{
print '<tr><td>?</td><td>No Events listed for next $future days</td></tr>';
}
// ----------------------------------------------
// end the table
// ----------------------------------------------
print '</table>';
// ----------------------------------------------
// END CALENDER SNIPPET
// ----------------------------------------------
|
|
|
|
Last Edit: June 21, 2005 @ 7:54pm by jacmgr | |
|
|
|
| |
DCSun
Administrator
Posts: 381 |
|
|
| November 21, 2007 @ 2:56pm | Admin Note:
Support request concerning the syntax for including scripts in a page has been moved here: http://www.flexcms.com/flex/forum/6/296.html.
Please open a new thread in the General Support Requests board for future support requests.
Thanks! |
|
|
|
|
|
|
|
|
|
|
