--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/web/wp-content/plugins/calendar/calendar.php Wed Dec 23 17:55:33 2009 +0000
@@ -0,0 +1,2712 @@
+<?php
+/*
+Plugin Name: Calendar
+Plugin URI: http://www.kieranoshea.com
+Description: This plugin allows you to display a calendar of all your events and appointments as a page on your site.
+Author: Kieran O'Shea
+Author URI: http://www.kieranoshea.com
+Version: 1.2.2
+*/
+
+/* Copyright 2008 Kieran O'Shea (email : kieran@kieranoshea.com)
+
+ This program is free software; you can redistribute it and/or modify
+ it under the terms of the GNU General Public License as published by
+ the Free Software Foundation; either version 2 of the License, or
+ (at your option) any later version.
+
+ This program is distributed in the hope that it will be useful,
+ but WITHOUT ANY WARRANTY; without even the implied warranty of
+ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ GNU General Public License for more details.
+
+ You should have received a copy of the GNU General Public License
+ along with this program; if not, write to the Free Software
+ Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
+*/
+
+// Enable internationalisation
+$plugin_dir = basename(dirname(__FILE__));
+load_plugin_textdomain( 'calendar','wp-content/plugins/'.$plugin_dir, $plugin_dir);
+
+// Define the tables used in Calendar
+define('WP_CALENDAR_TABLE', $table_prefix . 'calendar');
+define('WP_CALENDAR_CONFIG_TABLE', $table_prefix . 'calendar_config');
+define('WP_CALENDAR_CATEGORIES_TABLE', $table_prefix . 'calendar_categories');
+
+// Create a master category for Calendar and its sub-pages
+add_action('admin_menu', 'calendar_menu');
+
+// Enable the ability for the calendar to be loaded from pages
+add_filter('the_content','calendar_insert');
+
+// Add the function that puts style information in the header
+add_action('wp_head', 'calendar_wp_head');
+
+// Add the function that deals with deleted users
+add_action('delete_user', 'deal_with_deleted_user');
+
+// Add the widgets if we are using version 2.8
+add_action('widgets_init', 'widget_init_calendar_today');
+add_action('widgets_init', 'widget_init_calendar_upcoming');
+
+// Before we get on with the functions, we need to define the initial style used for Calendar
+
+// Function to deal with events posted by a user when that user is deleted
+function deal_with_deleted_user($id)
+{
+ global $wpdb;
+
+ // This wouldn't work unless the database was up to date. Lets check.
+ check_calendar();
+
+ // Do the query
+ $wpdb->get_results("UPDATE ".WP_CALENDAR_TABLE." SET event_author=".$wpdb->get_var("SELECT MIN(ID) FROM ".$wpdb->prefix."users",0,0)." WHERE event_author=".$id);
+}
+
+// Function to add the calendar style into the header
+function calendar_wp_head()
+{
+ global $wpdb;
+
+ // If the calendar isn't installed or upgraded this won't work
+ check_calendar();
+
+ $styles = $wpdb->get_results("SELECT config_value FROM " . WP_CALENDAR_CONFIG_TABLE . " WHERE config_item='calendar_style'");
+ if (!empty($styles))
+ {
+ foreach ($styles as $style)
+ {
+ echo '<style type="text/css">
+<!--
+';
+ echo $style->config_value.'
+';
+ echo '//-->
+</style>
+';
+ }
+ }
+}
+
+// Function to deal with adding the calendar menus
+function calendar_menu()
+{
+ global $wpdb;
+
+ // We make use of the Calendar tables so we must have installed Calendar
+ check_calendar();
+
+ // Set admin as the only one who can use Calendar for security
+ $allowed_group = 'manage_options';
+
+ // Use the database to *potentially* override the above if allowed
+ $configs = $wpdb->get_results("SELECT config_value FROM " . WP_CALENDAR_CONFIG_TABLE . " WHERE config_item='can_manage_events'");
+ if (!empty($configs))
+ {
+ foreach ($configs as $config)
+ {
+ $allowed_group = $config->config_value;
+ }
+ }
+
+ // Add the admin panel pages for Calendar. Use permissions pulled from above
+ if (function_exists('add_menu_page'))
+ {
+ add_menu_page(__('Calendar','calendar'), __('Calendar','calendar'), $allowed_group, 'calendar', 'edit_calendar');
+ }
+ if (function_exists('add_submenu_page'))
+ {
+ add_submenu_page('calendar', __('Manage Calendar','calendar'), __('Manage Calendar','calendar'), $allowed_group, 'calendar', 'edit_calendar');
+ add_action( "admin_head", 'calendar_add_javascript' );
+ // Note only admin can change calendar options
+ add_submenu_page('calendar', __('Manage Categories','calendar'), __('Manage Categories','calendar'), 'manage_options', 'calendar-categories', 'manage_categories');
+ add_submenu_page('calendar', __('Calendar Config','calendar'), __('Calendar Options','calendar'), 'manage_options', 'calendar-config', 'edit_calendar_config');
+ }
+}
+
+// Function to add the javascript to the admin header
+function calendar_add_javascript()
+{
+ echo '<script type="text/javascript" src="';
+ bloginfo('wpurl');
+ echo '/wp-content/plugins/calendar/javascript.js"></script>
+<script type="text/javascript">document.write(getCalendarStyles());</script>
+';
+}
+
+// Function to deal with loading the calendar into pages
+function calendar_insert($content)
+{
+ if (preg_match('{CALENDAR}',$content))
+ {
+ $cal_output = calendar();
+ $content = str_replace('{CALENDAR}',$cal_output,$content);
+ }
+ return $content;
+}
+
+// Function to check what version of Calendar is installed and install if needed
+function check_calendar()
+{
+ // Checks to make sure Calendar is installed, if not it adds the default
+ // database tables and populates them with test data. If it is, then the
+ // version is checked through various means and if it is not up to date
+ // then it is upgraded.
+
+ // Lets see if this is first run and create us a table if it is!
+ global $wpdb, $initial_style;
+
+ // All this style info will go into the database on a new install
+ // This looks nice in the Kubrick theme
+ $initial_style = " .calnk a:hover {
+ background-position:0 0;
+ text-decoration:none;
+ color:#000000;
+ border-bottom:1px dotted #000000;
+ }
+ .calnk a:visited {
+ text-decoration:none;
+ color:#000000;
+ border-bottom:1px dotted #000000;
+ }
+ .calnk a {
+ text-decoration:none;
+ color:#000000;
+ border-bottom:1px dotted #000000;
+ }
+ .calnk a span {
+ display:none;
+ }
+ .calnk a:hover span {
+ color:#333333;
+ background:#F6F79B;
+ display:block;
+ position:absolute;
+ margin-top:1px;
+ padding:5px;
+ width:150px;
+ z-index:100;
+ }
+ .calendar-table {
+ border:none;
+ width:100%;
+ }
+ .calendar-heading {
+ height:25px;
+ text-align:center;
+ border:1px solid #D6DED5;
+ background-color:#E4EBE3;
+ }
+ .calendar-next {
+ width:25%;
+ text-align:center;
+ }
+ .calendar-prev {
+ width:25%;
+ text-align:center;
+ }
+ .calendar-month {
+ width:50%;
+ text-align:center;
+ font-weight:bold;
+ }
+ .normal-day-heading {
+ text-align:center;
+ width:25px;
+ height:25px;
+ font-size:0.8em;
+ border:1px solid #DFE6DE;
+ background-color:#EBF2EA;
+ }
+ .weekend-heading {
+ text-align:center;
+ width:25px;
+ height:25px;
+ font-size:0.8em;
+ border:1px solid #DFE6DE;
+ background-color:#EBF2EA;
+ color:#FF0000;
+ }
+ .day-with-date {
+ vertical-align:text-top;
+ text-align:left;
+ width:60px;
+ height:60px;
+ border:1px solid #DFE6DE;
+ }
+ .no-events {
+
+ }
+ .day-without-date {
+ width:60px;
+ height:60px;
+ border:1px solid #E9F0E8;
+ }
+ span.weekend {
+ color:#FF0000;
+ }
+ .current-day {
+ vertical-align:text-top;
+ text-align:left;
+ width:60px;
+ height:60px;
+ border:1px solid #BFBFBF;
+ background-color:#E4EBE3;
+ }
+ span.event {
+ font-size:0.75em;
+ }
+ .kjo-link {
+ font-size:0.75em;
+ text-align:center;
+ }
+ .event-title {
+ text-align:center;
+ font-weight:bold;
+ font-size:1.2em;
+ }
+ .event-title-break {
+ width:96%;
+ margin-left:2%;
+ margin-right:2%;
+ margin-top:5px;
+ margin-bottom:5px;
+ text-align:center;
+ height:1px;
+ background-color:#000000;
+ }
+ .event-content-break {
+ width:96%;
+ margin-left:2%;
+ margin-right:2%;
+ margin-top:5px;
+ margin-bottom:5px;
+ text-align:center;
+ height:1px;
+ background-color:#000000;
+ }
+ .calendar-date-switcher {
+ height:25px;
+ text-align:center;
+ border:1px solid #D6DED5;
+ background-color:#E4EBE3;
+ }
+ .calendar-date-switcher form {
+ margin:0;
+ padding:0;
+ }
+ .calendar-date-switcher input {
+ border:1px #D6DED5 solid;
+ }
+ .calendar-date-switcher select {
+ border:1px #D6DED5 solid;
+ }
+ .cat-key {
+ width:100%;
+ margin-top:10px;
+ padding:5px;
+ border:1px solid #D6DED5;
+ }";
+
+
+ // Assume this is not a new install until we prove otherwise
+ $new_install = false;
+ $vone_point_one_upgrade = false;
+ $vone_point_two_beta_upgrade = false;
+
+ $wp_calendar_exists = false;
+ $wp_calendar_config_exists = false;
+ $wp_calendar_config_version_number_exists = false;
+
+ // Determine the calendar version
+ $tables = $wpdb->get_results("show tables;");
+ foreach ( $tables as $table )
+ {
+ foreach ( $table as $value )
+ {
+ if ( $value == WP_CALENDAR_TABLE )
+ {
+ $wp_calendar_exists = true;
+ }
+ if ( $value == WP_CALENDAR_CONFIG_TABLE )
+ {
+ $wp_calendar_config_exists = true;
+
+ // We now try and find the calendar version number
+ // This will be a lot easier than finding other stuff
+ // in the future.
+ $version_number = $wpdb->get_var("SELECT config_value FROM " . WP_CALENDAR_CONFIG_TABLE . " WHERE config_item='calendar_version'");
+ if ($version_number == "1.2")
+ {
+ $wp_calendar_config_version_number_exists = true;
+ }
+ }
+ }
+ }
+
+ if ($wp_calendar_exists == false && $wp_calendar_config_exists == false)
+ {
+ $new_install = true;
+ }
+ else if ($wp_calendar_exists == true && $wp_calendar_config_exists == false)
+ {
+ $vone_point_one_upgrade = true;
+ }
+ else if ($wp_calendar_exists == true && $wp_calendar_config_exists == true && $wp_calendar_config_version_number_exists == false)
+ {
+ $vone_point_two_beta_upgrade = true;
+ }
+
+ // Now we've determined what the current install is or isn't
+ // we perform operations according to the findings
+ if ( $new_install == true )
+ {
+ $sql = "CREATE TABLE " . WP_CALENDAR_TABLE . " (
+ event_id INT(11) NOT NULL AUTO_INCREMENT ,
+ event_begin DATE NOT NULL ,
+ event_end DATE NOT NULL ,
+ event_title VARCHAR(30) NOT NULL ,
+ event_desc TEXT NOT NULL ,
+ event_time TIME ,
+ event_recur CHAR(1) ,
+ event_repeats INT(3) ,
+ event_author BIGINT(20) UNSIGNED,
+ PRIMARY KEY (event_id)
+ )";
+ $wpdb->get_results($sql);
+ $sql = "CREATE TABLE " . WP_CALENDAR_CONFIG_TABLE . " (
+ config_item VARCHAR(30) NOT NULL ,
+ config_value TEXT NOT NULL ,
+ PRIMARY KEY (config_item)
+ )";
+ $wpdb->get_results($sql);
+ $sql = "INSERT INTO ".WP_CALENDAR_CONFIG_TABLE." SET config_item='can_manage_events', config_value='edit_posts'";
+ $wpdb->get_results($sql);
+ $sql = "INSERT INTO ".WP_CALENDAR_CONFIG_TABLE." SET config_item='calendar_style', config_value='".$initial_style."'";
+ $wpdb->get_results($sql);
+ $sql = "INSERT INTO ".WP_CALENDAR_CONFIG_TABLE." SET config_item='display_author', config_value='false'";
+ $wpdb->get_results($sql);
+ $sql = "INSERT INTO ".WP_CALENDAR_CONFIG_TABLE." SET config_item='display_jump', config_value='false'";
+ $wpdb->get_results($sql);
+ $sql = "INSERT INTO ".WP_CALENDAR_CONFIG_TABLE." SET config_item='display_todays', config_value='true'";
+ $wpdb->get_results($sql);
+ $sql = "INSERT INTO ".WP_CALENDAR_CONFIG_TABLE." SET config_item='display_upcoming', config_value='true'";
+ $wpdb->get_results($sql);
+ $sql = "INSERT INTO ".WP_CALENDAR_CONFIG_TABLE." SET config_item='display_upcoming_days', config_value=7";
+ $wpdb->get_results($sql);
+
+ $sql = "INSERT INTO ".WP_CALENDAR_CONFIG_TABLE." SET config_item='calendar_version', config_value='1.2'";
+ $wpdb->get_results($sql);
+ $sql = "INSERT INTO ".WP_CALENDAR_CONFIG_TABLE." SET config_item='enable_categories', config_value='false'";
+ $wpdb->get_results($sql);
+ $sql = "ALTER TABLE ".WP_CALENDAR_TABLE." ADD COLUMN event_category BIGINT(20) UNSIGNED";
+ $wpdb->get_results($sql);
+ $sql = "UPDATE " . WP_CALENDAR_TABLE . " SET event_category=1";
+ $wpdb->get_results($sql);
+ $sql = "ALTER TABLE ".WP_CALENDAR_TABLE." ADD COLUMN event_link TEXT";
+ $wpdb->get_results($sql);
+ $sql = "UPDATE " . WP_CALENDAR_TABLE . " SET event_link=''";
+ $wpdb->get_results($sql);
+ $sql = "CREATE TABLE " . WP_CALENDAR_CATEGORIES_TABLE . " (
+ category_id INT(11) NOT NULL AUTO_INCREMENT,
+ category_name VARCHAR(30) NOT NULL ,
+ category_colour VARCHAR(30) NOT NULL ,
+ PRIMARY KEY (category_id)
+ )";
+ $wpdb->get_results($sql);
+ $sql = "INSERT INTO " . WP_CALENDAR_CATEGORIES_TABLE . " SET category_id=1, category_name='General', category_colour='#F6F79B'";
+ $wpdb->get_results($sql);
+ }
+ else if ($vone_point_one_upgrade == true)
+ {
+ $sql = "ALTER TABLE ".WP_CALENDAR_TABLE." ADD COLUMN event_author BIGINT(20) UNSIGNED";
+ $wpdb->get_results($sql);
+ $sql = "UPDATE ".WP_CALENDAR_TABLE." SET event_author=".$wpdb->get_var("SELECT MIN(ID) FROM ".$wpdb->prefix."users",0,0);
+ $wpdb->get_results($sql);
+ $sql = "ALTER TABLE ".WP_CALENDAR_TABLE." MODIFY event_desc TEXT NOT NULL";
+ $wpdb->get_results($sql);
+ $sql = "CREATE TABLE " . WP_CALENDAR_CONFIG_TABLE . " (
+ config_item VARCHAR(30) NOT NULL ,
+ config_value TEXT NOT NULL ,
+ PRIMARY KEY (config_item)
+ )";
+ $wpdb->get_results($sql);
+ $sql = "INSERT INTO ".WP_CALENDAR_CONFIG_TABLE." SET config_item='can_manage_events', config_value='edit_posts'";
+ $wpdb->get_results($sql);
+ $sql = "INSERT INTO ".WP_CALENDAR_CONFIG_TABLE." SET config_item='calendar_style', config_value='".$initial_style."'";
+ $wpdb->get_results($sql);
+ $sql = "INSERT INTO ".WP_CALENDAR_CONFIG_TABLE." SET config_item='display_author', config_value='false'";
+ $wpdb->get_results($sql);
+ $sql = "INSERT INTO ".WP_CALENDAR_CONFIG_TABLE." SET config_item='display_jump', config_value='false'";
+ $wpdb->get_results($sql);
+ $sql = "INSERT INTO ".WP_CALENDAR_CONFIG_TABLE." SET config_item='display_todays', config_value='true'";
+ $wpdb->get_results($sql);
+ $sql = "INSERT INTO ".WP_CALENDAR_CONFIG_TABLE." SET config_item='display_upcoming', config_value='true'";
+ $wpdb->get_results($sql);
+ $sql = "INSERT INTO ".WP_CALENDAR_CONFIG_TABLE." SET config_item='display_upcoming_days', config_value=7";
+ $wpdb->get_results($sql);
+
+ $sql = "INSERT INTO ".WP_CALENDAR_CONFIG_TABLE." SET config_item='calendar_version', config_value='1.2'";
+ $wpdb->get_results($sql);
+ $sql = "INSERT INTO ".WP_CALENDAR_CONFIG_TABLE." SET config_item='enable_categories', config_value='false'";
+ $wpdb->get_results($sql);
+ $sql = "ALTER TABLE ".WP_CALENDAR_TABLE." ADD COLUMN event_category BIGINT(20) UNSIGNED";
+ $wpdb->get_results($sql);
+ $sql = "UPDATE " . WP_CALENDAR_TABLE . " SET event_category=1";
+ $wpdb->get_results($sql);
+ $sql = "ALTER TABLE ".WP_CALENDAR_TABLE." ADD COLUMN event_link TEXT";
+ $wpdb->get_results($sql);
+ $sql = "UPDATE " . WP_CALENDAR_TABLE . " SET event_link=''";
+ $wpdb->get_results($sql);
+ $sql = "CREATE TABLE " . WP_CALENDAR_CATEGORIES_TABLE . " (
+ category_id INT(11) NOT NULL AUTO_INCREMENT,
+ category_name VARCHAR(30) NOT NULL ,
+ category_colour VARCHAR(30) NOT NULL ,
+ PRIMARY KEY (category_id)
+ )";
+ $wpdb->get_results($sql);
+ $sql = "INSERT INTO " . WP_CALENDAR_CATEGORIES_TABLE . " SET category_id=1, category_name='General', category_colour='#F6F79B'";
+ $wpdb->get_results($sql);
+ }
+ else if ($vone_point_two_beta_upgrade == true)
+ {
+ $sql = "INSERT INTO ".WP_CALENDAR_CONFIG_TABLE." SET config_item='calendar_version', config_value='1.2'";
+ $wpdb->get_results($sql);
+ $sql = "INSERT INTO ".WP_CALENDAR_CONFIG_TABLE." SET config_item='enable_categories', config_value='false'";
+ $wpdb->get_results($sql);
+ $sql = "ALTER TABLE ".WP_CALENDAR_TABLE." ADD COLUMN event_category BIGINT(20) UNSIGNED";
+ $wpdb->get_results($sql);
+ $sql = "UPDATE " . WP_CALENDAR_TABLE . " SET event_category=1";
+ $wpdb->get_results($sql);
+ $sql = "ALTER TABLE ".WP_CALENDAR_TABLE." ADD COLUMN event_link TEXT";
+ $wpdb->get_results($sql);
+ $sql = "UPDATE " . WP_CALENDAR_TABLE . " SET event_link=''";
+ $wpdb->get_results($sql);
+ $sql = "CREATE TABLE " . WP_CALENDAR_CATEGORIES_TABLE . " (
+ category_id INT(11) NOT NULL AUTO_INCREMENT,
+ category_name VARCHAR(30) NOT NULL ,
+ category_colour VARCHAR(30) NOT NULL ,
+ PRIMARY KEY (category_id)
+ )";
+ $wpdb->get_results($sql);
+ $sql = "INSERT INTO " . WP_CALENDAR_CATEGORIES_TABLE . " SET category_id=1, category_name='General', category_colour='#F6F79B'";
+ $wpdb->get_results($sql);
+ $sql = "UPDATE " . WP_CALENDAR_CONFIG_TABLE . " SET config_value='".$initial_style."' WHERE config_item='calendar_style'";
+ $wpdb->get_results($sql);
+ }
+}
+
+// Used on the manage events admin page to display a list of events
+function wp_events_display_list()
+{
+ global $wpdb;
+
+ $events = $wpdb->get_results("SELECT * FROM " . WP_CALENDAR_TABLE . " ORDER BY event_begin DESC");
+
+ if ( !empty($events) )
+ {
+ ?>
+ <table class="widefat page fixed" width="100%" cellpadding="3" cellspacing="3">
+ <thead>
+ <tr>
+ <th class="manage-column" scope="col"><?php _e('ID','calendar') ?></th>
+ <th class="manage-column" scope="col"><?php _e('Title','calendar') ?></th>
+ <th class="manage-column" scope="col"><?php _e('Description','calendar') ?></th>
+ <th class="manage-column" scope="col"><?php _e('Start Date','calendar') ?></th>
+ <th class="manage-column" scope="col"><?php _e('End Date','calendar') ?></th>
+ <th class="manage-column" scope="col"><?php _e('Recurs','calendar') ?></th>
+ <th class="manage-column" scope="col"><?php _e('Repeats','calendar') ?></th>
+ <th class="manage-column" scope="col"><?php _e('Author','calendar') ?></th>
+ <th class="manage-column" scope="col"><?php _e('Category','calendar') ?></th>
+ <th class="manage-column" scope="col"><?php _e('Edit','calendar') ?></th>
+ <th class="manage-column" scope="col"><?php _e('Delete','calendar') ?></th>
+ </tr>
+ </thead>
+ <?php
+ $class = '';
+ foreach ( $events as $event )
+ {
+ $class = ($class == 'alternate') ? '' : 'alternate';
+ ?>
+ <tr class="<?php echo $class; ?>">
+ <th scope="row"><?php echo $event->event_id; ?></th>
+ <td><?php echo $event->event_title; ?></td>
+ <td><?php echo $event->event_desc; ?></td>
+ <td><?php echo $event->event_begin; ?></td>
+ <td><?php echo $event->event_end; ?></td>
+ <td>
+ <?php
+ // Interpret the DB values into something human readable
+ if ($event->event_recur == 'S') { echo __('Never','calendar'); }
+ else if ($event->event_recur == 'W') { echo __('Weekly','calendar'); }
+ else if ($event->event_recur == 'M') { echo __('Monthly','calendar'); }
+ else if ($event->event_recur == 'Y') { echo __('Yearly','calendar'); }
+ ?>
+ </td>
+ <td>
+ <?php
+ // Interpret the DB values into something human readable
+ if ($event->event_recur == 'S') { echo __('N/A','calendar'); }
+ else if ($event->event_repeats == 0) { echo __('Forever','calendar'); }
+ else if ($event->event_repeats > 0) { echo $event->event_repeats.' '.__('Times','calendar'); }
+ ?>
+ </td>
+ <td><?php $e = get_userdata($event->event_author); echo $e->display_name; ?></td>
+ <?php
+ $sql = "SELECT * FROM " . WP_CALENDAR_CATEGORIES_TABLE . " WHERE category_id=".$event->event_category;
+ $this_cat = $wpdb->get_row($sql);
+ ?>
+ <td style="background-color:<?php echo $this_cat->category_colour;?>;"><?php echo $this_cat->category_name; ?></td>
+ <?php unset($this_cat); ?>
+ <td><a href="<?php echo $_SERVER['PHP_SELF'] ?>?page=calendar&action=edit&event_id=<?php echo $event->event_id;?>" class='edit'><?php echo __('Edit','calendar'); ?></a></td>
+ <td><a href="<?php echo $_SERVER['PHP_SELF'] ?>?page=calendar&action=delete&event_id=<?php echo $event->event_id;?>" class="delete" onclick="return confirm('<?php _e('Are you sure you want to delete this event?','calendar'); ?>')"><?php echo __('Delete','calendar'); ?></a></td>
+ </tr>
+ <?php
+ }
+ ?>
+ </table>
+ <?php
+ }
+ else
+ {
+ ?>
+ <p><?php _e("There are no events in the database!",'calendar') ?></p>
+ <?php
+ }
+}
+
+
+// The event edit form for the manage events admin page
+function wp_events_edit_form($mode='add', $event_id=false)
+{
+ global $wpdb,$users_entries;
+ $data = false;
+
+ if ( $event_id !== false )
+ {
+ if ( intval($event_id) != $event_id )
+ {
+ echo "<div class=\"error\"><p>".__('Bad Monkey! No banana!','calendar')."</p></div>";
+ return;
+ }
+ else
+ {
+ $data = $wpdb->get_results("SELECT * FROM " . WP_CALENDAR_TABLE . " WHERE event_id='" . mysql_escape_string($event_id) . "' LIMIT 1");
+ if ( empty($data) )
+ {
+ echo "<div class=\"error\"><p>".__("An event with that ID couldn't be found",'calendar')."</p></div>";
+ return;
+ }
+ $data = $data[0];
+ }
+ // Recover users entries if they exist; in other words if editing an event went wrong
+ if (!empty($users_entries))
+ {
+ $data = $users_entries;
+ }
+ }
+ // Deal with possibility that form was submitted but not saved due to error - recover user's entries here
+ else
+ {
+ $data = $users_entries;
+ }
+
+ ?>
+ <div id="pop_up_cal" style="position:absolute;margin-left:150px;visibility:hidden;background-color:white;layer-background-color:white;z-index:1;"></div>
+ <form name="quoteform" id="quoteform" class="wrap" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>?page=calendar">
+ <input type="hidden" name="action" value="<?php echo $mode; ?>">
+ <input type="hidden" name="event_id" value="<?php echo $event_id; ?>">
+
+ <div id="linkadvanceddiv" class="postbox">
+ <div style="float: left; width: 98%; clear: both;" class="inside">
+ <table cellpadding="5" cellspacing="5">
+ <tr>
+ <td><legend><?php _e('Event Title','calendar'); ?></legend></td>
+ <td><input type="text" name="event_title" class="input" size="40" maxlength="30"
+ value="<?php if ( !empty($data) ) echo htmlspecialchars($data->event_title); ?>" /></td>
+ </tr>
+ <tr>
+ <td style="vertical-align:top;"><legend><?php _e('Event Description','calendar'); ?></legend></td>
+ <td><textarea name="event_desc" class="input" rows="5" cols="50"><?php if ( !empty($data) ) echo htmlspecialchars($data->event_desc); ?></textarea></td>
+ </tr>
+ <tr>
+ <td><legend><?php _e('Event Category','calendar'); ?></legend></td>
+ <td> <select name="event_category">
+ <?php
+ // Grab all the categories and list them
+ $sql = "SELECT * FROM " . WP_CALENDAR_CATEGORIES_TABLE;
+ $cats = $wpdb->get_results($sql);
+ foreach($cats as $cat)
+ {
+ echo '<option value="'.$cat->category_id.'"';
+ if (!empty($data))
+ {
+ if ($data->event_category == $cat->category_id)
+ {
+ echo 'selected="selected"';
+ }
+ }
+ echo '>'.$cat->category_name.'</option>
+';
+ }
+ ?>
+ </select>
+ </td>
+ </tr>
+ <tr>
+ <td><legend><?php _e('Event Link (Optional)','calendar'); ?></legend></td>
+ <td><input type="text" name="event_link" class="input" size="40" value="<?php if ( !empty($data) ) echo htmlspecialchars($data->event_link); ?>" /></td>
+ </tr>
+ <tr>
+ <td><legend><?php _e('Start Date','calendar'); ?></legend></td>
+ <td> <script type="text/javascript">
+ var cal_begin = new CalendarPopup('pop_up_cal');
+ function unifydates() {
+ document.forms['quoteform'].event_end.value = document.forms['quoteform'].event_begin.value;
+ }
+ </script>
+ <input type="text" name="event_begin" class="input" size="12"
+ value="<?php
+ if ( !empty($data) )
+ {
+ echo htmlspecialchars($data->event_begin);
+ }
+ else
+ {
+ echo date("Y-m-d");
+ }
+ ?>" /> <a href="#" onClick="cal_begin.select(document.forms['quoteform'].event_begin,'event_begin_anchor','yyyy-MM-dd'); return false;" name="event_begin_anchor" id="event_begin_anchor"><?php _e('Select Date','calendar'); ?></a>
+ </td>
+ </tr>
+ <tr>
+ <td><legend><?php _e('End Date','calendar'); ?></legend></td>
+ <td> <script type="text/javascript">
+ function check_and_print() {
+ unifydates();
+ var cal_end = new CalendarPopup('pop_up_cal');
+ var newDate = new Date();
+ newDate.setFullYear(document.forms['quoteform'].event_begin.value.split('-')[0],document.forms['quoteform'].event_begin.value.split('-')[1]-1,document.forms['quoteform'].event_begin.value.split('-')[2]);
+ newDate.setDate(newDate.getDate()-1);
+ cal_end.addDisabledDates(null, formatDate(newDate, "yyyy-MM-dd"));
+ cal_end.select(document.forms['quoteform'].event_end,'event_end_anchor','yyyy-MM-dd');
+ }
+ </script>
+ <input type="text" name="event_end" class="input" size="12"
+ value="<?php
+ if ( !empty($data) )
+ {
+ echo htmlspecialchars($data->event_end);
+ }
+ else
+ {
+ echo date("Y-m-d");
+ }
+ ?>" /> <a href="#" onClick="check_and_print(); return false;" name="event_end_anchor" id="event_end_anchor"><?php _e('Select Date','calendar'); ?></a>
+ </td>
+ </tr>
+ <tr>
+ <td><legend><?php _e('Time (hh:mm)','calendar'); ?></legend></td>
+ <td> <input type="text" name="event_time" class="input" size=12
+ value="<?php
+ if ( !empty($data) )
+ {
+ if ($data->event_time == "00:00:00")
+ {
+ echo '';
+ }
+ else
+ {
+ echo date("H:i",strtotime(htmlspecialchars($data->event_time)));
+ }
+ }
+ else
+ {
+ echo date("H:i");
+ }
+ ?>" /> <?php _e('Optional, set blank if not required.','calendar'); ?> <?php _e('Current time difference from GMT is ','calendar'); echo get_option('gmt_offset'); _e(' hour(s)'); ?>
+ </td>
+ </tr>
+ <tr>
+ <td><legend><?php _e('Recurring Events','calendar'); ?></legend></td>
+ <td> <?php
+ if ($data->event_repeats != NULL)
+ {
+ $repeats = $data->event_repeats;
+ }
+ else
+ {
+ $repeats = 0;
+ }
+
+ if ($data->event_recur == "S")
+ {
+ $selected_s = 'selected="selected"';
+ }
+ else if ($data->event_recur == "W")
+ {
+ $selected_w = 'selected="selected"';
+ }
+ else if ($data->event_recur == "M")
+ {
+ $selected_m = 'selected="selected"';
+ }
+ else if ($data->event_recur == "Y")
+ {
+ $selected_y = 'selected="selected"';
+ }
+ ?>
+ <?php _e('Repeats for','calendar'); ?>
+ <input type="text" name="event_repeats" class="input" size="1" value="<?php echo $repeats; ?>" />
+ <select name="event_recur" class="input">
+ <option class="input" <?php echo $selected_s; ?> value="S">None</option>
+ <option class="input" <?php echo $selected_w; ?> value="W">Weeks</option>
+ <option class="input" <?php echo $selected_m; ?> value="M">Months</option>
+ <option class="input" <?php echo $selected_y; ?> value="Y">Years</option>
+ </select><br />
+ <?php _e('Entering 0 means forever. Where the recurrance interval is left at none, the event will not reoccur.','calendar'); ?>
+ </td>
+ </tr>
+ </table>
+ </div>
+ <div style="clear:both; height:1px;"> </div>
+ </div>
+ <input type="submit" name="save" class="button bold" value="<?php _e('Save','calendar'); ?> »" />
+ </form>
+ <?php
+}
+
+// The actual function called to render the manage events page and
+// to deal with posts
+function edit_calendar()
+{
+ global $current_user, $wpdb, $users_entries;
+ ?>
+ <style type="text/css">
+<!--
+ .error {
+ background: lightcoral;
+ border: 1px solid #e64f69;
+ margin: 1em 5% 10px;
+ padding: 0 1em 0 1em;
+ }
+
+ .center {
+ text-align: center;
+ }
+ .right { text-align: right;
+ }
+ .left {
+ text-align: left;
+ }
+ .top {
+ vertical-align: top;
+ }
+ .bold {
+ font-weight: bold;
+ }
+ .private {
+ color: #e64f69;
+ }
+//-->
+</style>
+
+<?php
+
+// First some quick cleaning up
+$edit = $create = $save = $delete = false;
+
+// Make sure we are collecting the variables we need to select years and months
+$action = !empty($_REQUEST['action']) ? $_REQUEST['action'] : '';
+$event_id = !empty($_REQUEST['event_id']) ? $_REQUEST['event_id'] : '';
+
+
+// Lets see if this is first run and create us a table if it is!
+check_calendar();
+
+// Deal with adding an event to the database
+if ( $action == 'add' )
+{
+ $title = !empty($_REQUEST['event_title']) ? $_REQUEST['event_title'] : '';
+ $desc = !empty($_REQUEST['event_desc']) ? $_REQUEST['event_desc'] : '';
+ $begin = !empty($_REQUEST['event_begin']) ? $_REQUEST['event_begin'] : '';
+ $end = !empty($_REQUEST['event_end']) ? $_REQUEST['event_end'] : '';
+ $time = !empty($_REQUEST['event_time']) ? $_REQUEST['event_time'] : '';
+ $recur = !empty($_REQUEST['event_recur']) ? $_REQUEST['event_recur'] : '';
+ $repeats = !empty($_REQUEST['event_repeats']) ? $_REQUEST['event_repeats'] : '';
+ $category = !empty($_REQUEST['event_category']) ? $_REQUEST['event_category'] : '';
+ $linky = !empty($_REQUEST['event_link']) ? $_REQUEST['event_link'] : '';
+
+ // Deal with the fools who have left magic quotes turned on
+ if ( ini_get('magic_quotes_gpc') )
+ {
+ $title = stripslashes($title);
+ $desc = stripslashes($desc);
+ $begin = stripslashes($begin);
+ $end = stripslashes($end);
+ $time = stripslashes($time);
+ $recur = stripslashes($recur);
+ $repeats = stripslashes($repeats);
+ $category = stripslashes($category);
+ $linky = stripslashes($linky);
+ }
+
+ // Perform some validation on the submitted dates - this checks for valid years and months
+ $date_format_one = '/^([0-9]{4})-([0][1-9])-([0-3][0-9])$/';
+ $date_format_two = '/^([0-9]{4})-([1][0-2])-([0-3][0-9])$/';
+ if ((preg_match($date_format_one,$begin) || preg_match($date_format_two,$begin)) && (preg_match($date_format_one,$end) || preg_match($date_format_two,$end)))
+ {
+ // We know we have a valid year and month and valid integers for days so now we do a final check on the date
+ $begin_split = split('-',$begin);
+ $begin_y = $begin_split[0];
+ $begin_m = $begin_split[1];
+ $begin_d = $begin_split[2];
+ $end_split = split('-',$end);
+ $end_y = $end_split[0];
+ $end_m = $end_split[1];
+ $end_d = $end_split[2];
+ if (checkdate($begin_m,$begin_d,$begin_y) && checkdate($end_m,$end_d,$end_y))
+ {
+ // Ok, now we know we have valid dates, we want to make sure that they are either equal or that the end date is later than the start date
+ if (strtotime($end) >= strtotime($begin))
+ {
+ $start_date_ok = 1;
+ $end_date_ok = 1;
+ }
+ else
+ {
+ ?>
+ <div class="error"><p><strong><?php _e('Error','calendar'); ?>:</strong> <?php _e('Your event end date must be either after or the same as your event begin date','calendar'); ?></p></div>
+ <?php
+ }
+ }
+ else
+ {
+ ?>
+ <div class="error"><p><strong><?php _e('Error','calendar'); ?>:</strong> <?php _e('Your date formatting is correct but one or more of your dates is invalid. Check for number of days in month and leap year related errors.','calendar'); ?></p></div>
+ <?php
+ }
+ }
+ else
+ {
+ ?>
+ <div class="error"><p><strong><?php _e('Error','calendar'); ?>:</strong> <?php _e('Both start and end dates must be entered and be in the format YYYY-MM-DD','calendar'); ?></p></div>
+ <?php
+ }
+ // We check for a valid time, or an empty one
+ $time_format_one = '/^([0-1][0-9]):([0-5][0-9])$/';
+ $time_format_two = '/^([2][0-3]):([0-5][0-9])$/';
+ if (preg_match($time_format_one,$time) || preg_match($time_format_two,$time) || $time == '')
+ {
+ $time_ok = 1;
+ }
+ else
+ {
+ ?>
+ <div class="error"><p><strong><?php _e('Error','calendar'); ?>:</strong> <?php _e('The time field must either be blank or be entered in the format hh:mm','calendar'); ?></p></div>
+ <?php
+ }
+ // We check to make sure the URL is alright
+ if (preg_match('/^(http)(s?)(:)\/\//',$linky) || $linky == '')
+ {
+ $url_ok = 1;
+ }
+ else
+ {
+ ?>
+ <div class="error"><p><strong><?php _e('Error','calendar'); ?>:</strong> <?php _e('The URL entered must either be prefixed with http:// or be completely blank','calendar'); ?></p></div>
+ <?php
+ }
+ // The title must be at least one character in length and no more than 30 - no non-standard characters allowed
+ if (preg_match('/^[a-zA-Z0-9]{1}[a-zA-Z0-9[:space:]]{0,29}$/',$title))
+ {
+ $title_ok =1;
+ }
+ else
+ {
+ ?>
+ <div class="error"><p><strong><?php _e('Error','calendar'); ?>:</strong> <?php _e('The event title must be between 1 and 30 characters in length and contain no punctuation. Spaces are allowed but the title must not start with one.','calendar'); ?></p></div>
+ <?php
+ }
+ // We run some checks on recurrance
+ if (($repeats == 0 && $recur == 'S') || (($repeats >= 0) && ($recur == 'W' || $recur == 'M' || $recur == 'Y')))
+ {
+ $recurring_ok = 1;
+ }
+ else
+ {
+ ?>
+ <div class="error"><p><strong><?php _e('Error','calendar'); ?>:</strong> <?php _e('The repetition value must be 0 unless a type of recurrance is selected in which case the repetition value must be 0 or higher','calendar'); ?></p></div>
+ <?php
+ }
+ if ($start_date_ok == 1 && $end_date_ok == 1 && $time_ok == 1 && $url_ok == 1 && $title_ok == 1 && $recurring_ok == 1)
+ {
+ $sql = "INSERT INTO " . WP_CALENDAR_TABLE . " SET event_title='" . mysql_escape_string($title)
+ . "', event_desc='" . mysql_escape_string($desc) . "', event_begin='" . mysql_escape_string($begin)
+ . "', event_end='" . mysql_escape_string($end) . "', event_time='" . mysql_escape_string($time) . "', event_recur='" . mysql_escape_string($recur) . "', event_repeats='" . mysql_escape_string($repeats) . "', event_author=".$current_user->ID.", event_category=".mysql_escape_string($category).", event_link='".mysql_escape_string($linky)."'";
+
+ $wpdb->get_results($sql);
+
+ $sql = "SELECT event_id FROM " . WP_CALENDAR_TABLE . " WHERE event_title='" . mysql_escape_string($title) . "'"
+ . " AND event_desc='" . mysql_escape_string($desc) . "' AND event_begin='" . mysql_escape_string($begin) . "' AND event_end='" . mysql_escape_string($end) . "' AND event_recur='" . mysql_escape_string($recur) . "' AND event_repeats='" . mysql_escape_string($repeats) . "' LIMIT 1";
+ $result = $wpdb->get_results($sql);
+
+ if ( empty($result) || empty($result[0]->event_id) )
+ {
+ ?>
+ <div class="error"><p><strong><?php _e('Error','calendar'); ?>:</strong> <?php _e('An event with the details you submitted could not be found in the database. This may indicate a problem with your database or the way in which it is configured.','calendar'); ?></p></div>
+ <?php
+ }
+ else
+ {
+ ?>
+ <div class="updated"><p><?php _e('Event added. It will now show in your calendar.','calendar'); ?></p></div>
+ <?php
+ }
+ }
+ else
+ {
+ // The form is going to be rejected due to field validation issues, so we preserve the users entries here
+ $users_entries->event_title = $title;
+ $users_entries->event_desc = $desc;
+ $users_entries->event_begin = $begin;
+ $users_entries->event_end = $end;
+ $users_entries->event_time = $time;
+ $users_entries->event_recur = $recur;
+ $users_entries->event_repeats = $repeats;
+ $users_entries->event_category = $category;
+ $users_entries->event_link = $linky;
+ }
+}
+// Permit saving of events that have been edited
+elseif ( $action == 'edit_save' )
+{
+ $title = !empty($_REQUEST['event_title']) ? $_REQUEST['event_title'] : '';
+ $desc = !empty($_REQUEST['event_desc']) ? $_REQUEST['event_desc'] : '';
+ $begin = !empty($_REQUEST['event_begin']) ? $_REQUEST['event_begin'] : '';
+ $end = !empty($_REQUEST['event_end']) ? $_REQUEST['event_end'] : '';
+ $time = !empty($_REQUEST['event_time']) ? $_REQUEST['event_time'] : '';
+ $recur = !empty($_REQUEST['event_recur']) ? $_REQUEST['event_recur'] : '';
+ $repeats = !empty($_REQUEST['event_repeats']) ? $_REQUEST['event_repeats'] : '';
+ $category = !empty($_REQUEST['event_category']) ? $_REQUEST['event_category'] : '';
+ $linky = !empty($_REQUEST['event_link']) ? $_REQUEST['event_link'] : '';
+
+ // Deal with the fools who have left magic quotes turned on
+ if ( ini_get('magic_quotes_gpc') )
+ {
+ $title = stripslashes($title);
+ $desc = stripslashes($desc);
+ $begin = stripslashes($begin);
+ $end = stripslashes($end);
+ $time = stripslashes($time);
+ $recur = stripslashes($recur);
+ $repeats = stripslashes($repeats);
+ $category = stripslashes($category);
+ $linky = stripslashes($linky);
+ }
+
+ if ( empty($event_id) )
+ {
+ ?>
+ <div class="error"><p><strong><?php _e('Failure','calendar'); ?>:</strong> <?php _e("You can't update an event if you haven't submitted an event id",'calendar'); ?></p></div>
+ <?php
+ }
+ else
+ {
+ // Perform some validation on the submitted dates - this checks for valid years and months
+ $date_format_one = '/^([0-9]{4})-([0][1-9])-([0-3][0-9])$/';
+ $date_format_two = '/^([0-9]{4})-([1][0-2])-([0-3][0-9])$/';
+ if ((preg_match($date_format_one,$begin) || preg_match($date_format_two,$begin)) && (preg_match($date_format_one,$end) || preg_match($date_format_two,$end)))
+ {
+ // We know we have a valid year and month and valid integers for days so now we do a final check on the date
+ $begin_split = split('-',$begin);
+ $begin_y = $begin_split[0];
+ $begin_m = $begin_split[1];
+ $begin_d = $begin_split[2];
+ $end_split = split('-',$end);
+ $end_y = $end_split[0];
+ $end_m = $end_split[1];
+ $end_d = $end_split[2];
+ if (checkdate($begin_m,$begin_d,$begin_y) && checkdate($end_m,$end_d,$end_y))
+ {
+ // Ok, now we know we have valid dates, we want to make sure that they are either equal or that the end date is later than the start date
+ if (strtotime($end) >= strtotime($begin))
+ {
+ $start_date_ok = 1;
+ $end_date_ok = 1;
+ }
+ else
+ {
+ ?>
+ <div class="error"><p><strong><?php _e('Error','calendar'); ?>:</strong> <?php _e('Your event end date must be either after or the same as your event begin date','calendar'); ?></p></div>
+ <?php
+ }
+ }
+ else
+ {
+ ?>
+ <div class="error"><p><strong><?php _e('Error','calendar'); ?>:</strong> <?php _e('Your date formatting is correct but one or more of your dates is invalid. Check for number of days in month and leap year related errors.','calendar'); ?></p></div>
+ <?php
+ }
+ }
+ else
+ {
+ ?>
+ <div class="error"><p><strong><?php _e('Error','calendar'); ?>:</strong> <?php _e('Both start and end dates must be entered and be in the format YYYY-MM-DD','calendar'); ?></p></div>
+ <?php
+ }
+ // We check for a valid time, or an empty one
+ $time_format_one = '/^([0-1][0-9]):([0-5][0-9])$/';
+ $time_format_two = '/^([2][0-3]):([0-5][0-9])$/';
+ if (preg_match($time_format_one,$time) || preg_match($time_format_two,$time) || $time == '')
+ {
+ $time_ok = 1;
+ }
+ else
+ {
+ ?>
+ <div class="error"><p><strong><?php _e('Error','calendar'); ?>:</strong> <?php _e('The time field must either be blank or be entered in the format hh:mm','calendar'); ?></p></div>
+ <?php
+ }
+ // We check to make sure the URL is alright
+ if (preg_match('/^(http)(s?)(:)\/\//',$linky) || $linky == '')
+ {
+ $url_ok = 1;
+ }
+ else
+ {
+ ?>
+ <div class="error"><p><strong><?php _e('Error','calendar'); ?>:</strong> <?php _e('The URL entered must either be prefixed with http:// or be completely blank','calendar'); ?></p></div>
+ <?php
+ }
+ // The title must be at least one character in length and no more than 30 - no non-standard characters allowed
+ if (preg_match('/^[a-zA-Z0-9]{1}[a-zA-Z0-9[:space:]]{0,29}$/',$title))
+ {
+ $title_ok =1;
+ }
+ else
+ {
+ ?>
+ <div class="error"><p><strong><?php _e('Error','calendar'); ?>:</strong> <?php _e('The event title must be between 1 and 30 characters in length and contain no punctuation. Spaces are allowed but the title must not start with one.','calendar'); ?></p></div>
+ <?php
+ }
+ // We run some checks on recurrance
+ if (($repeats == 0 && $recur == 'S') || (($repeats >= 0) && ($recur == 'W' || $recur == 'M' || $recur == 'Y')))
+ {
+ $recurring_ok = 1;
+ }
+ else
+ {
+ ?>
+ <div class="error"><p><strong><?php _e('Error','calendar'); ?>:</strong> <?php _e('The repetition value must be 0 unless a type of recurrance is selected in which case the repetition value must be 0 or higher','calendar'); ?></p></div>
+ <?php
+ }
+ if ($start_date_ok == 1 && $end_date_ok == 1 && $time_ok == 1 && $url_ok == 1 && $title_ok && $recurring_ok == 1)
+ {
+ $sql = "UPDATE " . WP_CALENDAR_TABLE . " SET event_title='" . mysql_escape_string($title)
+ . "', event_desc='" . mysql_escape_string($desc) . "', event_begin='" . mysql_escape_string($begin)
+ . "', event_end='" . mysql_escape_string($end) . "', event_time='" . mysql_escape_string($time) . "', event_recur='" . mysql_escape_string($recur) . "', event_repeats='" . mysql_escape_string($repeats) . "', event_author=".$current_user->ID . ", event_category=".mysql_escape_string($category).", event_link='".mysql_escape_string($linky)."' WHERE event_id='" . mysql_escape_string($event_id) . "'";
+
+ $wpdb->get_results($sql);
+
+ $sql = "SELECT event_id FROM " . WP_CALENDAR_TABLE . " WHERE event_title='" . mysql_escape_string($title) . "'"
+ . " AND event_desc='" . mysql_escape_string($desc) . "' AND event_begin='" . mysql_escape_string($begin) . "' AND event_end='" . mysql_escape_string($end) . "' AND event_recur='" . mysql_escape_string($recur) . "' AND event_repeats='" . mysql_escape_string($repeats) . "' LIMIT 1";
+ $result = $wpdb->get_results($sql);
+
+ if ( empty($result) || empty($result[0]->event_id) )
+ {
+ ?>
+ <div class="error"><p><strong><?php _e('Failure','calendar'); ?>:</strong> <?php _e('The database failed to return data to indicate the event has been updated sucessfully. This may indicate a problem with your database or the way in which it is configured.','calendar'); ?></p></div>
+ <?php
+ }
+ else
+ {
+ ?>
+ <div class="updated"><p><?php _e('Event updated successfully','calendar'); ?></p></div>
+ <?php
+ }
+ }
+ else
+ {
+ // The form is going to be rejected due to field validation issues, so we preserve the users entries here
+ $users_entries->event_title = $title;
+ $users_entries->event_desc = $desc;
+ $users_entries->event_begin = $begin;
+ $users_entries->event_end = $end;
+ $users_entries->event_time = $time;
+ $users_entries->event_recur = $recur;
+ $users_entries->event_repeats = $repeats;
+ $users_entries->event_category = $category;
+ $users_entries->event_link = $linky;
+ $error_with_saving = 1;
+ }
+ }
+}
+// Deal with deleting an event from the database
+elseif ( $action == 'delete' )
+{
+ if ( empty($event_id) )
+ {
+ ?>
+ <div class="error"><p><strong><?php _e('Error','calendar'); ?>:</strong> <?php _e("You can't delete an event if you haven't submitted an event id",'calendar'); ?></p></div>
+ <?php
+ }
+ else
+ {
+ $sql = "DELETE FROM " . WP_CALENDAR_TABLE . " WHERE event_id='" . mysql_escape_string($event_id) . "'";
+ $wpdb->get_results($sql);
+
+ $sql = "SELECT event_id FROM " . WP_CALENDAR_TABLE . " WHERE event_id='" . mysql_escape_string($event_id) . "'";
+ $result = $wpdb->get_results($sql);
+
+ if ( empty($result) || empty($result[0]->event_id) )
+ {
+ ?>
+ <div class="updated"><p><?php _e('Event deleted successfully','calendar'); ?></p></div>
+ <?php
+ }
+ else
+ {
+ ?>
+ <div class="error"><p><strong><?php _e('Error','calendar'); ?>:</strong> <?php _e('Despite issuing a request to delete, the event still remains in the database. Please investigate.','calendar'); ?></p></div>
+ <?php
+
+ }
+ }
+}
+
+// Now follows a little bit of code that pulls in the main
+// components of this page; the edit form and the list of events
+?>
+
+<div class="wrap">
+ <?php
+ if ( $action == 'edit' || ($action == 'edit_save' && $error_with_saving == 1))
+ {
+ ?>
+ <h2><?php _e('Edit Event','calendar'); ?></h2>
+ <?php
+ if ( empty($event_id) )
+ {
+ echo "<div class=\"error\"><p>".__("You must provide an event id in order to edit it",'calendar')."</p></div>";
+ }
+ else
+ {
+ wp_events_edit_form('edit_save', $event_id);
+ }
+ }
+ else
+ {
+ ?>
+ <h2><?php _e('Add Event','calendar'); ?></h2>
+ <?php wp_events_edit_form(); ?>
+
+ <h2><?php _e('Manage Events','calendar'); ?></h2>
+ <?php
+ wp_events_display_list();
+ }
+ ?>
+</div>
+
+<?php
+
+}
+
+// Display the admin configuration page
+function edit_calendar_config()
+{
+ global $wpdb, $initial_style;
+
+ // We can't use this page unless Calendar is installed/upgraded
+ check_calendar();
+
+ if (isset($_POST['permissions']) && isset($_POST['style']))
+ {
+ if ($_POST['permissions'] == 'subscriber') { $new_perms = 'read'; }
+ else if ($_POST['permissions'] == 'contributor') { $new_perms = 'edit_posts'; }
+ else if ($_POST['permissions'] == 'author') { $new_perms = 'publish_posts'; }
+ else if ($_POST['permissions'] == 'editor') { $new_perms = 'moderate_comments'; }
+ else if ($_POST['permissions'] == 'admin') { $new_perms = 'manage_options'; }
+ else { $new_perms = 'manage_options'; }
+
+ $calendar_style = mysql_escape_string($_POST['style']);
+ $display_upcoming_days = mysql_escape_string($_POST['display_upcoming_days']);
+
+ if (mysql_escape_string($_POST['display_author']) == 'on')
+ {
+ $disp_author = 'true';
+ }
+ else
+ {
+ $disp_author = 'false';
+ }
+
+ if (mysql_escape_string($_POST['display_jump']) == 'on')
+ {
+ $disp_jump = 'true';
+ }
+ else
+ {
+ $disp_jump = 'false';
+ }
+
+ if (mysql_escape_string($_POST['display_todays']) == 'on')
+ {
+ $disp_todays = 'true';
+ }
+ else
+ {
+ $disp_todays = 'false';
+ }
+
+ if (mysql_escape_string($_POST['display_upcoming']) == 'on')
+ {
+ $disp_upcoming = 'true';
+ }
+ else
+ {
+ $disp_upcoming = 'false';
+ }
+
+ if (mysql_escape_string($_POST['enable_categories']) == 'on')
+ {
+ $enable_categories = 'true';
+ }
+ else
+ {
+ $enable_categories = 'false';
+ }
+
+ $wpdb->get_results("UPDATE " . WP_CALENDAR_CONFIG_TABLE . " SET config_value = '".$new_perms."' WHERE config_item='can_manage_events'");
+ $wpdb->get_results("UPDATE " . WP_CALENDAR_CONFIG_TABLE . " SET config_value = '".$calendar_style."' WHERE config_item='calendar_style'");
+ $wpdb->get_results("UPDATE " . WP_CALENDAR_CONFIG_TABLE . " SET config_value = '".$disp_author."' WHERE config_item='display_author'");
+ $wpdb->get_results("UPDATE " . WP_CALENDAR_CONFIG_TABLE . " SET config_value = '".$disp_jump."' WHERE config_item='display_jump'");
+ $wpdb->get_results("UPDATE " . WP_CALENDAR_CONFIG_TABLE . " SET config_value = '".$disp_todays."' WHERE config_item='display_todays'");
+ $wpdb->get_results("UPDATE " . WP_CALENDAR_CONFIG_TABLE . " SET config_value = '".$disp_upcoming."' WHERE config_item='display_upcoming'");
+ $wpdb->get_results("UPDATE " . WP_CALENDAR_CONFIG_TABLE . " SET config_value = '".$display_upcoming_days."' WHERE config_item='display_upcoming_days'");
+ $wpdb->get_results("UPDATE " . WP_CALENDAR_CONFIG_TABLE . " SET config_value = '".$enable_categories."' WHERE config_item='enable_categories'");
+
+ // Check to see if we are replacing the original style
+ if (mysql_escape_string($_POST['reset_styles']) == 'on')
+ {
+ $wpdb->get_results("UPDATE " . WP_CALENDAR_CONFIG_TABLE . " SET config_value = '".$initial_style."' WHERE config_item='calendar_style'");
+ }
+
+ echo "<div class=\"updated\"><p><strong>".__('Settings saved','calendar').".</strong></p></div>";
+ }
+
+ // Pull the values out of the database that we need for the form
+ $configs = $wpdb->get_results("SELECT config_value FROM " . WP_CALENDAR_CONFIG_TABLE . " WHERE config_item='can_manage_events'");
+ if (!empty($configs))
+ {
+ foreach ($configs as $config)
+ {
+ $allowed_group = $config->config_value;
+ }
+ }
+
+ $configs = $wpdb->get_results("SELECT config_value FROM " . WP_CALENDAR_CONFIG_TABLE . " WHERE config_item='calendar_style'");
+ if (!empty($configs))
+ {
+ foreach ($configs as $config)
+ {
+ $calendar_style = $config->config_value;
+ }
+ }
+ $configs = $wpdb->get_results("SELECT config_value FROM " . WP_CALENDAR_CONFIG_TABLE . " WHERE config_item='display_author'");
+ if (!empty($configs))
+ {
+ foreach ($configs as $config)
+ {
+ if ($config->config_value == 'true')
+ {
+ $yes_disp_author = 'selected="selected"';
+ }
+ else
+ {
+ $no_disp_author = 'selected="selected"';
+ }
+ }
+ }
+ $configs = $wpdb->get_results("SELECT config_value FROM " . WP_CALENDAR_CONFIG_TABLE . " WHERE config_item='display_jump'");
+ if (!empty($configs))
+ {
+ foreach ($configs as $config)
+ {
+ if ($config->config_value == 'true')
+ {
+ $yes_disp_jump = 'selected="selected"';
+ }
+ else
+ {
+ $no_disp_jump = 'selected="selected"';
+ }
+ }
+ }
+ $configs = $wpdb->get_results("SELECT config_value FROM " . WP_CALENDAR_CONFIG_TABLE . " WHERE config_item='display_todays'");
+ if (!empty($configs))
+ {
+ foreach ($configs as $config)
+ {
+ if ($config->config_value == 'true')
+ {
+ $yes_disp_todays = 'selected="selected"';
+ }
+ else
+ {
+ $no_disp_todays = 'selected="selected"';
+ }
+ }
+ }
+ $configs = $wpdb->get_results("SELECT config_value FROM " . WP_CALENDAR_CONFIG_TABLE . " WHERE config_item='display_upcoming'");
+ if (!empty($configs))
+ {
+ foreach ($configs as $config)
+ {
+ if ($config->config_value == 'true')
+ {
+ $yes_disp_upcoming = 'selected="selected"';
+ }
+ else
+ {
+ $no_disp_upcoming = 'selected="selected"';
+ }
+ }
+ }
+ $configs = $wpdb->get_results("SELECT config_value FROM " . WP_CALENDAR_CONFIG_TABLE . " WHERE config_item='display_upcoming_days'");
+ if (!empty($configs))
+ {
+ foreach ($configs as $config)
+ {
+ $upcoming_days = $config->config_value;
+ }
+ }
+ $configs = $wpdb->get_results("SELECT config_value FROM " . WP_CALENDAR_CONFIG_TABLE . " WHERE config_item='enable_categories'");
+ if (!empty($configs))
+ {
+ foreach ($configs as $config)
+ {
+ if ($config->config_value == 'true')
+ {
+ $yes_enable_categories = 'selected="selected"';
+ }
+ else
+ {
+ $no_enable_categories = 'selected="selected"';
+ }
+ }
+ }
+ if ($allowed_group == 'read') { $subscriber_selected='selected="selected"';}
+ else if ($allowed_group == 'edit_posts') { $contributor_selected='selected="selected"';}
+ else if ($allowed_group == 'publish_posts') { $author_selected='selected="selected"';}
+ else if ($allowed_group == 'moderate_comments') { $editor_selected='selected="selected"';}
+ else if ($allowed_group == 'manage_options') { $admin_selected='selected="selected"';}
+
+ // Now we render the form
+ ?>
+ <style type="text/css">
+ <!--
+ .error {
+ background: lightcoral;
+ border: 1px solid #e64f69;
+ margin: 1em 5% 10px;
+ padding: 0 1em 0 1em;
+ }
+
+ .center {
+ text-align: center;
+ }
+ .right {
+ text-align: right;
+ }
+ .left {
+ text-align: left;
+ }
+ .top {
+ vertical-align: top;
+ }
+ .bold {
+ font-weight: bold;
+ }
+ .private {
+ color: #e64f69;
+ }
+ //-->
+ </style>
+
+ <div class="wrap">
+ <h2><?php _e('Calendar Options','calendar'); ?></h2>
+ <form name="quoteform" id="quoteform" class="wrap" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>?page=calendar-config">
+ <div id="linkadvanceddiv" class="postbox">
+ <div style="float: left; width: 98%; clear: both;" class="inside">
+ <table cellpadding="5" cellspacing="5">
+ <tr>
+ <td><legend><?php _e('Choose the lowest user group that may manage events','calendar'); ?></legend></td>
+ <td> <select name="permissions">
+ <option value="subscriber"<?php echo $subscriber_selected ?>><?php _e('Subscriber','calendar')?></option>
+ <option value="contributor" <?php echo $contributor_selected ?>><?php _e('Contributor','calendar')?></option>
+ <option value="author" <?php echo $author_selected ?>><?php _e('Author','calendar')?></option>
+ <option value="editor" <?php echo $editor_selected ?>><?php _e('Editor','calendar')?></option>
+ <option value="admin" <?php echo $admin_selected ?>><?php _e('Administrator','calendar')?></option>
+ </select>
+ </td>
+ </tr>
+ <tr>
+ <td><legend><?php _e('Do you want to display the author name on events?','calendar'); ?></legend></td>
+ <td> <select name="display_author">
+ <option value="on" <?php echo $yes_disp_author ?>><?php _e('Yes','calendar') ?></option>
+ <option value="off" <?php echo $no_disp_author ?>><?php _e('No','calendar') ?></option>
+ </select>
+ </td>
+ </tr>
+ <tr>
+ <td><legend><?php _e('Display a jumpbox for changing month and year quickly?','calendar'); ?></legend></td>
+ <td> <select name="display_jump">
+ <option value="on" <?php echo $yes_disp_jump ?>><?php _e('Yes','calendar') ?></option>
+ <option value="off" <?php echo $no_disp_jump ?>><?php _e('No','calendar') ?></option>
+ </select>
+ </td>
+ </tr>
+ <tr>
+ <td><legend><?php _e('Display todays events?','calendar'); ?></legend></td>
+ <td> <select name="display_todays">
+ <option value="on" <?php echo $yes_disp_todays ?>><?php _e('Yes','calendar') ?></option>
+ <option value="off" <?php echo $no_disp_todays ?>><?php _e('No','calendar') ?></option>
+ </select>
+ </td>
+ </tr>
+ <tr>
+ <td><legend><?php _e('Display upcoming events?','calendar'); ?></legend></td>
+ <td> <select name="display_upcoming">
+ <option value="on" <?php echo $yes_disp_upcoming ?>><?php _e('Yes','calendar') ?></option>
+ <option value="off" <?php echo $no_disp_upcoming ?>><?php _e('No','calendar') ?></option>
+ </select>
+ <?php _e('for','calendar'); ?> <input type="text" name="display_upcoming_days" value="<?php echo $upcoming_days ?>" size="1" maxlength="2" /> <?php _e('days into the future','calendar'); ?>
+ </td>
+ </tr>
+ <tr>
+ <td><legend><?php _e('Enable event categories?','calendar'); ?></legend></td>
+ <td> <select name="enable_categories">
+ <option value="on" <?php echo $yes_enable_categories ?>><?php _e('Yes','calendar') ?></option>
+ <option value="off" <?php echo $no_enable_categories ?>><?php _e('No','calendar') ?></option>
+ </select>
+ </td>
+ </tr>
+ <tr>
+ <td style="vertical-align:top;"><legend><?php _e('Configure the stylesheet for Calendar','calendar'); ?></legend></td>
+ <td><textarea name="style" rows="10" cols="60" tabindex="2"><?php echo $calendar_style; ?></textarea><br />
+ <input type="checkbox" name="reset_styles" /> <?php _e('Tick this box if you wish to reset the Calendar style to default','calendar'); ?></td>
+ </tr>
+ </table>
+ </div>
+ <div style="clear:both; height:1px;"> </div>
+ </div>
+ <input type="submit" name="save" class="button bold" value="<?php _e('Save','calendar'); ?> »" />
+ </form>
+ </div>
+ <?php
+
+
+}
+
+// Function to handle the management of categories
+function manage_categories()
+{
+ global $wpdb;
+
+ // Calendar must be installed and upgraded before this will work
+ check_calendar();
+
+?>
+<style type="text/css">
+ <!--
+ .error {
+ background: lightcoral;
+ border: 1px solid #e64f69;
+ margin: 1em 5% 10px;
+ padding: 0 1em 0 1em;
+ }
+
+ .center {
+ text-align: center;
+ }
+ .right {
+ text-align: right;
+ }
+ .left {
+ text-align: left;
+ }
+ .top {
+ vertical-align: top;
+ }
+ .bold {
+ font-weight: bold;
+ }
+ .private {
+ color: #e64f69;
+ }
+ //-->
+</style>
+<?php
+ // We do some checking to see what we're doing
+ if (isset($_POST['mode']) && $_POST['mode'] == 'add')
+ {
+ $sql = "INSERT INTO " . WP_CALENDAR_CATEGORIES_TABLE . " SET category_name='".mysql_escape_string($_POST['category_name'])."', category_colour='".mysql_escape_string($_POST['category_colour'])."'";
+ $wpdb->get_results($sql);
+ echo "<div class=\"updated\"><p><strong>".__('Category added successfully','calendar')."</strong></p></div>";
+ }
+ else if (isset($_GET['mode']) && isset($_GET['category_id']) && $_GET['mode'] == 'delete')
+ {
+ $sql = "DELETE FROM " . WP_CALENDAR_CATEGORIES_TABLE . " WHERE category_id=".mysql_escape_string($_GET['category_id']);
+ $wpdb->get_results($sql);
+ $sql = "UPDATE " . WP_CALENDAR_TABLE . " SET event_category=1 WHERE event_category=".mysql_escape_string($_GET['category_id']);
+ $wpdb->get_results($sql);
+ echo "<div class=\"updated\"><p><strong>".__('Category deleted successfully','calendar')."</strong></p></div>";
+ }
+ else if (isset($_GET['mode']) && isset($_GET['category_id']) && $_GET['mode'] == 'edit' && !isset($_POST['mode']))
+ {
+ $sql = "SELECT * FROM " . WP_CALENDAR_CATEGORIES_TABLE . " WHERE category_id=".mysql_escape_string($_GET['category_id']);
+ $cur_cat = $wpdb->get_row($sql);
+ ?>
+<div class="wrap">
+ <h2><?php _e('Edit Category','calendar'); ?></h2>
+ <form name="catform" id="catform" class="wrap" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>?page=calendar-categories">
+ <input type="hidden" name="mode" value="edit" />
+ <input type="hidden" name="category_id" value="<?php echo $cur_cat->category_id ?>" />
+ <div id="linkadvanceddiv" class="postbox">
+ <div style="float: left; width: 98%; clear: both;" class="inside">
+ <table cellpadding="5" cellspacing="5">
+ <tr>
+ <td><legend><?php _e('Category Name','calendar'); ?>:</legend></td>
+ <td><input type="text" name="category_name" class="input" size="30" maxlength="30" value="<?php echo $cur_cat->category_name ?>" /></td>
+ </tr>
+ <tr>
+ <td><legend><?php _e('Category Colour (Hex format)','calendar'); ?>:</legend></td>
+ <td><input type="text" name="category_colour" class="input" size="10" maxlength="7" value="<?php echo $cur_cat->category_colour ?>" /></td>
+ </tr>
+ </table>
+ </div>
+ <div style="clear:both; height:1px;"> </div>
+ </div>
+ <input type="submit" name="save" class="button bold" value="<?php _e('Save','calendar'); ?> »" />
+ </form>
+</div>
+ <?php
+ }
+ else if (isset($_POST['mode']) && isset($_POST['category_id']) && isset($_POST['category_name']) && isset($_POST['category_colour']) && $_POST['mode'] == 'edit')
+ {
+ $sql = "UPDATE " . WP_CALENDAR_CATEGORIES_TABLE . " SET category_name='".mysql_escape_string($_POST['category_name'])."', category_colour='".mysql_escape_string($_POST['category_colour'])."' WHERE category_id=".mysql_escape_string($_POST['category_id']);
+ $wpdb->get_results($sql);
+ echo "<div class=\"updated\"><p><strong>".__('Category edited successfully','calendar')."</strong></p></div>";
+ }
+
+ if ($_GET['mode'] != 'edit' || $_POST['mode'] == 'edit')
+ {
+?>
+
+ <div class="wrap">
+ <h2><?php _e('Add Category','calendar'); ?></h2>
+ <form name="catform" id="catform" class="wrap" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>?page=calendar-categories">
+ <input type="hidden" name="mode" value="add" />
+ <input type="hidden" name="category_id" value="">
+ <div id="linkadvanceddiv" class="postbox">
+ <div style="float: left; width: 98%; clear: both;" class="inside">
+ <table cellspacing="5" cellpadding="5">
+ <tr>
+ <td><legend><?php _e('Category Name','calendar'); ?>:</legend></td>
+ <td><input type="text" name="category_name" class="input" size="30" maxlength="30" value="" /></td>
+ </tr>
+ <tr>
+ <td><legend><?php _e('Category Colour (Hex format)','calendar'); ?>:</legend></td>
+ <td><input type="text" name="category_colour" class="input" size="10" maxlength="7" value="" /></td>
+ </tr>
+ </table>
+ </div>
+ <div style="clear:both; height:1px;"> </div>
+ </div>
+ <input type="submit" name="save" class="button bold" value="<?php _e('Save','calendar'); ?> »" />
+ </form>
+ <h2><?php _e('Manage Categories','calendar'); ?></h2>
+<?php
+
+ // We pull the categories from the database
+ $categories = $wpdb->get_results("SELECT * FROM " . WP_CALENDAR_CATEGORIES_TABLE . " ORDER BY category_id ASC");
+
+ if ( !empty($categories) )
+ {
+ ?>
+ <table class="widefat page fixed" width="50%" cellpadding="3" cellspacing="3">
+ <thead>
+ <tr>
+ <th class="manage-column" scope="col"><?php _e('ID','calendar') ?></th>
+ <th class="manage-column" scope="col"><?php _e('Category Name','calendar') ?></th>
+ <th class="manage-column" scope="col"><?php _e('Category Colour','calendar') ?></th>
+ <th class="manage-column" scope="col"><?php _e('Edit','calendar') ?></th>
+ <th class="manage-column" scope="col"><?php _e('Delete','calendar') ?></th>
+ </tr>
+ </thead>
+ <?php
+ $class = '';
+ foreach ( $categories as $category )
+ {
+ $class = ($class == 'alternate') ? '' : 'alternate';
+ ?>
+ <tr class="<?php echo $class; ?>">
+ <th scope="row"><?php echo $category->category_id; ?></th>
+ <td><?php echo $category->category_name; ?></td>
+ <td style="background-color:<?php echo $category->category_colour; ?>;"> </td>
+ <td><a href="<?php echo $_SERVER['PHP_SELF'] ?>?page=calendar-categories&mode=edit&category_id=<?php echo $category->category_id;?>" class='edit'><?php echo __('Edit','calendar'); ?></a></td>
+ <?php
+ if ($category->category_id == 1)
+ {
+ echo '<td>'.__('N/A','calendar').'</td>';
+ }
+ else
+ {
+ ?>
+ <td><a href="<?php echo $_SERVER['PHP_SELF'] ?>?page=calendar-categories&mode=delete&category_id=<?php echo $category->category_id;?>" class="delete" onclick="return confirm('<?php echo __('Are you sure you want to delete this category?','calendar'); ?>')"><?php echo __('Delete','calendar'); ?></a></td>
+ <?php
+ }
+ ?>
+ </tr>
+ <?php
+ }
+ ?>
+ </table>
+ <?php
+ }
+ else
+ {
+ echo '<p>'.__('There are no categories in the database - something has gone wrong!','calendar').'</p>';
+ }
+
+?>
+ </div>
+
+<?php
+ }
+}
+
+// Function to return a prefix which will allow the correct
+// placement of arguments into the query string.
+function permalink_prefix()
+{
+ // Get the permalink structure from WordPress
+ $p_link = get_permalink();
+
+ // Work out what the real URL we are viewing is
+ $s = empty($_SERVER["HTTPS"]) ? '' : ($_SERVER["HTTPS"] == "on") ? "s" : "";
+ $protocol = substr(strtolower($_SERVER["SERVER_PROTOCOL"]), 0, strpos(strtolower($_SERVER["SERVER_PROTOCOL"]), "/")).$s;
+ $port = ($_SERVER["SERVER_PORT"] == "80") ? "" : (":".$_SERVER["SERVER_PORT"]);
+ $real_link = $protocol.'://'.$_SERVER['SERVER_NAME'].$port.$_SERVER['REQUEST_URI'];
+
+ // Now use all of that to get the correctly craft the Calendar link prefix
+ if (strstr($p_link, '?') && $p_link == $real_link)
+ {
+ $link_part = $p_link.'&';
+ }
+ else if ($p_link == $real_link)
+ {
+ $link_part = $p_link.'?';
+ }
+ else if (strstr($real_link, '?'))
+ {
+ if (isset($_GET['month']) && isset($_GET['yr']))
+ {
+ $new_tail = split("&", $real_link);
+ foreach ($new_tail as $item)
+ {
+ if (!strstr($item, 'month') && !strstr($item, 'yr'))
+ {
+ $link_part .= $item.'&';
+ }
+ }
+ if (!strstr($link_part, '?'))
+ {
+ $new_tail = split("month", $link_part);
+ $link_part = $new_tail[0].'?'.$new_tail[1];
+ }
+ }
+ else
+ {
+ $link_part = $real_link.'&';
+ }
+ }
+ else
+ {
+ $link_part = $real_link.'?';
+ }
+
+ return $link_part;
+}
+
+// Configure the "Next" link in the calendar
+function next_link($cur_year,$cur_month)
+{
+ $mod_rewrite_months = array(1=>'jan','feb','mar','apr','may','jun','jul','aug','sept','oct','nov','dec');
+ $next_year = $cur_year + 1;
+
+ if ($cur_month == 12)
+ {
+ return '<a href="' . permalink_prefix() . 'month=jan&yr=' . $next_year . '">'.__('Next','calendar').' »</a>';
+ }
+ else
+ {
+ $next_month = $cur_month + 1;
+ $month = $mod_rewrite_months[$next_month];
+ return '<a href="' . permalink_prefix() . 'month='.$month.'&yr=' . $cur_year . '">'.__('Next','calendar').' »</a>';
+ }
+}
+
+// Configure the "Previous" link in the calendar
+function prev_link($cur_year,$cur_month)
+{
+ $mod_rewrite_months = array(1=>'jan','feb','mar','apr','may','jun','jul','aug','sept','oct','nov','dec');
+ $last_year = $cur_year - 1;
+
+ if ($cur_month == 1)
+ {
+ return '<a href="' . permalink_prefix() . 'month=dec&yr='. $last_year .'">« '.__('Prev','calendar').'</a>';
+ }
+ else
+ {
+ $next_month = $cur_month - 1;
+ $month = $mod_rewrite_months[$next_month];
+ return '<a href="' . permalink_prefix() . 'month='.$month.'&yr=' . $cur_year . '">« '.__('Prev','calendar').'</a>';
+ }
+}
+
+// Print upcoming events
+function upcoming_events()
+{
+ global $wpdb;
+
+ // This function cannot be called unless calendar is up to date
+ check_calendar();
+
+ // Find out if we should be displaying upcoming events
+ $display = $wpdb->get_var("SELECT config_value FROM ".WP_CALENDAR_CONFIG_TABLE." WHERE config_item='display_upcoming'",0,0);
+
+ if ($display == 'true')
+ {
+ // Get number of days we should go into the future
+ $future_days = $wpdb->get_var("SELECT config_value FROM ".WP_CALENDAR_CONFIG_TABLE." WHERE config_item='display_upcoming_days'",0,0);
+ $day_count = 1;
+
+ while ($day_count < $future_days+1)
+ {
+ list($y,$m,$d) = split("-",date("Y-m-d",mktime($day_count*24,0,0,date("m"),date("d"),date("Y"))));
+ $events = grab_events($y,$m,$d);
+ usort($events, "time_cmp");
+ if (count($events) != 0) {
+ $output .= '<li>'.date(get_option('date_format'),mktime($day_count*24,0,0,date("m"),date("d"),date("Y"))).'<ul>';
+ }
+ foreach($events as $event)
+ {
+ if ($event->event_time == '00:00:00') {
+ $time_string = ' '.__('all day','calendar');
+ }
+ else {
+ $time_string = ' '.__('at','calendar').' '.date(get_option('time_format'), strtotime($event->event_time));
+ }
+ $output .= '<li>'.draw_widget_event($event).$time_string.'</li>';
+ }
+ if (count($events) != 0) {
+ $output .= '</ul></li>';
+ }
+ $day_count = $day_count+1;
+ }
+
+ if ($output != '')
+ {
+ $visual = '<li class="upcoming-events"><h2>'.__('Upcoming Events','calendar').'</h2><ul>';
+ $visual .= $output;
+ $visual .= '</ul></li>';
+ return $visual;
+ }
+ }
+}
+
+// Print todays events
+function todays_events()
+{
+ global $wpdb;
+
+ // This function cannot be called unless calendar is up to date
+ check_calendar();
+
+ // Find out if we should be displaying todays events
+ $display = $wpdb->get_var("SELECT config_value FROM ".WP_CALENDAR_CONFIG_TABLE." WHERE config_item='display_todays'",0,0);
+
+ if ($display == 'true')
+ {
+ $output = '<li class="todays-events"><h2>'.__('Today\'s Events','calendar').'</h2><ul>';
+ $events = grab_events(date("Y"),date("m"),date("d"));
+ usort($events, "time_cmp");
+ foreach($events as $event)
+ {
+ if ($event->event_time == '00:00:00') {
+ $time_string = ' '.__('all day','calendar');
+ }
+ else {
+ $time_string = ' '.__('at','calendar').' '.date(get_option('time_format'), strtotime($event->event_time));
+ }
+ $output .= '<li>'.draw_widget_event($event).$time_string.'</li>';
+ }
+ $output .= '</ul></li>';
+ if (count($events) != 0)
+ {
+ return $output;
+ }
+ }
+}
+
+// Function to compare time in event objects
+function time_cmp($a, $b)
+{
+ if ($a->event_time == $b->event_time) {
+ return 0;
+ }
+ return ($a->event_time < $b->event_time) ? -1 : 1;
+}
+
+// Used to draw multiple events
+function draw_events($events)
+{
+ // We need to sort arrays of objects by time
+ usort($events, "time_cmp");
+
+ // Now process the events
+ foreach($events as $event)
+ {
+ $output .= draw_event($event);
+ }
+ return $output;
+}
+
+// Widget todays events
+function todays_events_widget() {
+ global $wpdb;
+
+ // This function cannot be called unless calendar is up to date
+ check_calendar();
+
+ // Find out if we should be displaying todays events
+ $display = $wpdb->get_var("SELECT config_value FROM ".WP_CALENDAR_CONFIG_TABLE." WHERE config_item='display_todays'",0,0);
+
+ if ($display == 'true')
+ {
+ $output = '<ul>';
+ $events = grab_events(date("Y"),date("m"),date("d"));
+ usort($events, "time_cmp");
+ foreach($events as $event)
+ {
+ if ($event->event_time == '00:00:00') {
+ $time_string = ' '.__('all day','calendar');
+ }
+ else {
+ $time_string = ' '.__('at','calendar').' '.date(get_option('time_format'), strtotime($event->event_time));
+ }
+ $output .= '<li>'.draw_widget_event($event).$time_string.'</li>';
+ }
+ $output .= '</ul>';
+ if (count($events) != 0)
+ {
+ return $output;
+ }
+ }
+}
+
+// Widget upcoming events
+function upcoming_events_widget() {
+ global $wpdb;
+
+ // This function cannot be called unless calendar is up to date
+ check_calendar();
+
+ // Find out if we should be displaying upcoming events
+ $display = $wpdb->get_var("SELECT config_value FROM ".WP_CALENDAR_CONFIG_TABLE." WHERE config_item='display_upcoming'",0,0);
+
+ if ($display == 'true')
+ {
+ // Get number of days we should go into the future
+ $future_days = $wpdb->get_var("SELECT config_value FROM ".WP_CALENDAR_CONFIG_TABLE." WHERE config_item='display_upcoming_days'",0,0);
+ $day_count = 1;
+
+ while ($day_count < $future_days+1)
+ {
+ list($y,$m,$d) = split("-",date("Y-m-d",mktime($day_count*24,0,0,date("m"),date("d"),date("Y"))));
+ $events = grab_events($y,$m,$d);
+ usort($events, "time_cmp");
+ if (count($events) != 0) {
+ $output .= '<li>'.date(get_option('date_format'),mktime($day_count*24,0,0,date("m"),date("d"),date("Y"))).'<ul>';
+ }
+ foreach($events as $event)
+ {
+ if ($event->event_time == '00:00:00') {
+ $time_string = ' '.__('all day','calendar');
+ }
+ else {
+ $time_string = ' '.__('at','calendar').' '.date(get_option('time_format'), strtotime($event->event_time));
+ }
+ $output .= '<li>'.draw_widget_event($event).$time_string.'</li>';
+ }
+ if (count($events) != 0) {
+ $output .= '</ul></li>';
+ }
+ $day_count = $day_count+1;
+ }
+
+ if ($output != '')
+ {
+ $visual = '<ul>';
+ $visual .= $output;
+ $visual .= '</ul>';
+ return $visual;
+ }
+ }
+}
+
+// The widget to show todays events in the sidebar
+function widget_init_calendar_today() {
+ // Check for required functions
+ if (!function_exists('register_sidebar_widget'))
+ return;
+
+ function widget_calendar_today($args) {
+ extract($args);
+ $the_title = get_option('calendar_today_widget_title');
+ $widget_title = empty($the_title) ? __('Today\'s Events','calendar') : $the_title;
+ $the_events = todays_events_widget();
+ if ($the_events != '') {
+ echo $before_widget;
+ echo $before_title . $widget_title . $after_title;
+ echo $the_events;
+ echo $after_widget;
+ }
+ }
+
+ function widget_calendar_today_control() {
+ $widget_title = get_option('calendar_today_widget_title');
+ if (isset($_POST['calendar_today_widget_title'])) {
+ update_option('calendar_today_widget_title',strip_tags($_POST['calendar_today_widget_title']));
+ }
+ ?>
+ <p>
+ <label for="calendar_today_widget_title"><?php _e('Title','calendar'); ?>:<br />
+ <input class="widefat" type="text" id="calendar_today_widget_title" name="calendar_today_widget_title" value="<?php echo $widget_title; ?>"/></label>
+ </p>
+ <?php
+ }
+
+ register_sidebar_widget(__('Today\'s Events','calendar'),'widget_calendar_today');
+ register_widget_control(__('Today\'s Events','calendar'),'widget_calendar_today_control');
+ }
+
+// The widget to show todays events in the sidebar
+function widget_init_calendar_upcoming() {
+ // Check for required functions
+ if (!function_exists('register_sidebar_widget'))
+ return;
+
+ function widget_calendar_upcoming($args) {
+ extract($args);
+ $the_title = get_option('calendar_upcoming_widget_title');
+ $widget_title = empty($the_title) ? __('Upcoming Events','calendar') : $the_title;
+ $the_events = upcoming_events_widget();
+ if ($the_events != '') {
+ echo $before_widget;
+ echo $before_title . $widget_title . $after_title;
+ echo $the_events;
+ echo $after_widget;
+ }
+ }
+
+ function widget_calendar_upcoming_control() {
+ $widget_title = get_option('calendar_upcoming_widget_title');
+ if (isset($_POST['calendar_upcoming_widget_title'])) {
+ update_option('calendar_upcoming_widget_title',strip_tags($_POST['calendar_upcoming_widget_title']));
+ }
+ ?>
+ <p>
+ <label for="calendar_upcoming_widget_title"><?php _e('Title','calendar'); ?>:<br />
+ <input class="widefat" type="text" id="calendar_upcoming_widget_title" name="calendar_upcoming_widget_title" value="<?php echo $widget_title; ?>"/></label>
+ </p>
+ <?php
+ }
+
+ register_sidebar_widget(__('Upcoming Events','calendar'),'widget_calendar_upcoming');
+ register_widget_control(__('Upcoming Events','calendar'),'widget_calendar_upcoming_control');
+}
+
+
+// Used to draw an event to the screen
+function draw_event($event)
+{
+ global $wpdb;
+
+ // Calendar must be updated to run this function
+ check_calendar();
+
+ // Before we do anything we want to know if we
+ // should display the author and/or show categories.
+ // We check for this later
+ $display_author = $wpdb->get_var("SELECT config_value FROM ".WP_CALENDAR_CONFIG_TABLE." WHERE config_item='display_author'",0,0);
+ $show_cat = $wpdb->get_var("SELECT config_value FROM ".WP_CALENDAR_CONFIG_TABLE." WHERE config_item='enable_categories'",0,0);
+
+ if ($show_cat == 'true')
+ {
+ $sql = "SELECT * FROM " . WP_CALENDAR_CATEGORIES_TABLE . " WHERE category_id=".$event->event_category;
+ $cat_details = $wpdb->get_row($sql);
+ $style = "background-color:".$cat_details->category_colour.";";
+ }
+
+ $header_details .= '<div class="event-title">'.$event->event_title.'</div><div class="event-title-break"></div>';
+ if ($event->event_time != "00:00:00")
+ {
+ $header_details .= '<strong>'.__('Time','calendar').':</strong> ' . date(get_option('time_format'), strtotime($event->event_time)) . '<br />';
+ }
+ if ($display_author == 'true')
+ {
+ $e = get_userdata($event->event_author);
+ $header_details .= '<strong>'.__('Posted by', 'calendar').':</strong> '.$e->display_name.'<br />';
+ }
+ if ($display_author == 'true' || $event->event_time != "00:00:00")
+ {
+ $header_details .= '<div class="event-content-break"></div>';
+ }
+ if ($event->event_link != '') { $linky = $event->event_link; }
+ else { $linky = '#'; }
+
+ $details = '<br />
+* <span class="calnk" nowrap="nowrap"><a href="'.$linky.'" style="'.$style.'">' . $event->event_title . '<span style="'.$style.'">' . $header_details . '' . $event->event_desc . '</span></a></span>';
+
+ return $details;
+}
+
+// Draw an event but customise the HTML for use in the widget
+function draw_widget_event($event)
+{
+ global $wpdb;
+
+ // Calendar must be updated to run this function
+ check_calendar();
+
+ // Before we do anything we want to know if we
+ // should display the author and/or show categories.
+ // We check for this later
+ $display_author = $wpdb->get_var("SELECT config_value FROM ".WP_CALENDAR_CONFIG_TABLE." WHERE config_item='display_author'",0,0);
+ $show_cat = $wpdb->get_var("SELECT config_value FROM ".WP_CALENDAR_CONFIG_TABLE." WHERE config_item='enable_categories'",0,0);
+
+ if ($show_cat == 'true')
+ {
+ $sql = "SELECT * FROM " . WP_CALENDAR_CATEGORIES_TABLE . " WHERE category_id=".$event->event_category;
+ $cat_details = $wpdb->get_row($sql);
+ $style = "background-color:".$cat_details->category_colour.";";
+ }
+
+ $header_details .= '<div class="event-title">'.$event->event_title.'</div><div class="event-title-break"></div>';
+ if ($event->event_time != "00:00:00")
+ {
+ $header_details .= '<strong>'.__('Time','calendar').':</strong> ' . date(get_option('time_format'), strtotime($event->event_time)) . '<br />';
+ }
+ if ($display_author == 'true')
+ {
+ $e = get_userdata($event->event_author);
+ $header_details .= '<strong>'.__('Posted by','calendar').':</strong> '.$e->display_name.'<br />';
+ }
+ if ($display_author == 'true' || $event->event_time != "00:00:00")
+ {
+ $header_details .= '<div class="event-content-break"></div>';
+ }
+ if ($event->event_link != '') { $linky = $event->event_link; }
+ else { $linky = '#'; }
+
+ $details = '<span class="calnk" nowrap="nowrap"><a href="'.$linky.'">' . $event->event_title . '<span style="'.$style.'">' . $header_details . '' . $event->event_desc . '</span></a></span>';
+
+ return $details;
+}
+
+// Grab all events for the requested date from calendar
+function grab_events($y,$m,$d)
+{
+ global $wpdb;
+
+ $arr_events = array();
+
+ // Get the date format right
+ $date = $y . '-' . $m . '-' . $d;
+
+ // Firstly we check for conventional events. These will form the first instance of a recurring event
+ // or the only instance of a one-off event
+ $events = $wpdb->get_results("SELECT * FROM " . WP_CALENDAR_TABLE . " WHERE event_begin <= '$date' AND event_end >= '$date' AND event_recur = 'S' ORDER BY event_id");
+ if (!empty($events))
+ {
+ foreach($events as $event)
+ {
+ array_push($arr_events, $event);
+ }
+ }
+
+ // Even if there were results for that query, we may still have events recurring
+ // from the past on this day. We now methodically check the for these events
+
+ /*
+ The yearly code - easy because the day and month will be the same, so we return all yearly
+ events that match the date part. Out of these we show those with a repeat of 0, and fast-foward
+ a number of years for those with a value more than 0. Those that land in the future are displayed.
+ */
+
+
+ // Deal with forever recurring year events
+ $events = $wpdb->get_results("SELECT * FROM " . WP_CALENDAR_TABLE . " WHERE event_recur = 'Y' AND EXTRACT(YEAR FROM '$date') >= EXTRACT(YEAR FROM event_begin) AND event_repeats = 0 ORDER BY event_id");
+
+ if (!empty($events))
+ {
+ foreach($events as $event)
+ {
+ // This is going to get complex so lets setup what we would place in for
+ // an event so we can drop it in with ease
+
+ // Technically we don't care about the years, but we need to find out if the
+ // event spans the turn of a year so we can deal with it appropriately.
+ $year_begin = date('Y',strtotime($event->event_begin));
+ $year_end = date('Y',strtotime($event->event_end));
+
+ if ($year_begin == $year_end)
+ {
+ if (date('m-d',strtotime($event->event_begin)) <= date('m-d',strtotime($date)) &&
+ date('m-d',strtotime($event->event_end)) >= date('m-d',strtotime($date)))
+ {
+ array_push($arr_events, $event);
+ }
+ }
+ else if ($year_begin < $year_end)
+ {
+ if (date('m-d',strtotime($event->event_begin)) <= date('m-d',strtotime($date)) ||
+ date('m-d',strtotime($event->event_end)) >= date('m-d',strtotime($date)))
+ {
+ array_push($arr_events, $event);
+ }
+ }
+ }
+ }
+
+ // Now the ones that happen a finite number of times
+ $events = $wpdb->get_results("SELECT * FROM " . WP_CALENDAR_TABLE . " WHERE event_recur = 'Y' AND EXTRACT(YEAR FROM '$date') >= EXTRACT(YEAR FROM event_begin) AND event_repeats != 0 AND (EXTRACT(YEAR FROM '$date')-EXTRACT(YEAR FROM event_begin)) <= event_repeats ORDER BY event_id");
+ if (!empty($events))
+ {
+ foreach($events as $event)
+ {
+ // This is going to get complex so lets setup what we would place in for
+ // an event so we can drop it in with ease
+
+ // Technically we don't care about the years, but we need to find out if the
+ // event spans the turn of a year so we can deal with it appropriately.
+ $year_begin = date('Y',strtotime($event->event_begin));
+ $year_end = date('Y',strtotime($event->event_end));
+
+ if ($year_begin == $year_end)
+ {
+ if (date('m-d',strtotime($event->event_begin)) <= date('m-d',strtotime($date)) &&
+ date('m-d',strtotime($event->event_end)) >= date('m-d',strtotime($date)))
+ {
+ array_push($arr_events, $event);
+ }
+ }
+ else if ($year_begin < $year_end)
+ {
+ if (date('m-d',strtotime($event->event_begin)) <= date('m-d',strtotime($date)) ||
+ date('m-d',strtotime($event->event_end)) >= date('m-d',strtotime($date)))
+ {
+ array_push($arr_events, $event);
+ }
+ }
+ }
+ }
+
+ /*
+ The monthly code - just as easy because as long as the day of the month is correct, then we
+ show the event
+ */
+
+ // The monthly events that never stop recurring
+ $events = $wpdb->get_results("SELECT * FROM " . WP_CALENDAR_TABLE . " WHERE event_recur = 'M' AND EXTRACT(YEAR FROM '$date') >= EXTRACT(YEAR FROM event_begin) AND event_repeats = 0 ORDER BY event_id");
+ if (!empty($events))
+ {
+ foreach($events as $event)
+ {
+ // This is going to get complex so lets setup what we would place in for
+ // an event so we can drop it in with ease
+
+ // Technically we don't care about the years or months, but we need to find out if the
+ // event spans the turn of a year or month so we can deal with it appropriately.
+ $month_begin = date('m',strtotime($event->event_begin));
+ $month_end = date('m',strtotime($event->event_end));
+
+ if ($month_begin == $month_end)
+ {
+ if (date('d',strtotime($event->event_begin)) <= date('d',strtotime($date)) &&
+ date('d',strtotime($event->event_end)) >= date('d',strtotime($date)))
+ {
+ array_push($arr_events, $event);
+ }
+ }
+ else if ($month_begin < $month_end)
+ {
+ if ( ($event->event_begin <= date('Y-m-d',strtotime($date))) && (date('d',strtotime($event->event_begin)) <= date('d',strtotime($date)) ||
+ date('d',strtotime($event->event_end)) >= date('d',strtotime($date))) )
+ {
+ array_push($arr_events, $event);
+ }
+ }
+ }
+ }
+
+
+ // Now the ones that happen a finite number of times
+ $events = $wpdb->get_results("SELECT * FROM " . WP_CALENDAR_TABLE . " WHERE event_recur = 'M' AND EXTRACT(YEAR FROM '$date') >= EXTRACT(YEAR FROM event_begin) AND event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '$date'),EXTRACT(YEAR_MONTH FROM event_begin))) <= event_repeats ORDER BY event_id");
+ if (!empty($events))
+ {
+ foreach($events as $event)
+ {
+ // This is going to get complex so lets setup what we would place in for
+ // an event so we can drop it in with ease
+
+ // Technically we don't care about the years or months, but we need to find out if the
+ // event spans the turn of a year or month so we can deal with it appropriately.
+ $month_begin = date('m',strtotime($event->event_begin));
+ $month_end = date('m',strtotime($event->event_end));
+
+ if ($month_begin == $month_end)
+ {
+ if (date('d',strtotime($event->event_begin)) <= date('d',strtotime($date)) &&
+ date('d',strtotime($event->event_end)) >= date('d',strtotime($date)))
+ {
+ array_push($arr_events, $event);
+ }
+ }
+ else if ($month_begin < $month_end)
+ {
+ if ( ($event->event_begin <= date('Y-m-d',strtotime($date))) && (date('d',strtotime($event->event_begin)) <= date('d',strtotime($date)) ||
+ date('d',strtotime($event->event_end)) >= date('d',strtotime($date))) )
+ {
+ array_push($arr_events, $event);
+ }
+ }
+ }
+ }
+
+
+ /*
+ Weekly - well isn't this fun! We need to scan all weekly events, find what day they fell on
+ and see if that matches the current day. If it does, we check to see if the repeats are 0.
+ If they are, display the event, if not, we fast forward from the original day in week blocks
+ until the number is exhausted. If the date we arrive at is in the future, display the event.
+ */
+
+ // The weekly events that never stop recurring
+ $events = $wpdb->get_results("SELECT * FROM " . WP_CALENDAR_TABLE . " WHERE event_recur = 'W' AND '$date' >= event_begin AND event_repeats = 0 ORDER BY event_id");
+ if (!empty($events))
+ {
+ foreach($events as $event)
+ {
+ // This is going to get complex so lets setup what we would place in for
+ // an event so we can drop it in with ease
+
+ // Now we are going to check to see what day the original event
+ // fell on and see if the current date is both after it and on
+ // the correct day. If it is, display the event!
+ $day_start_event = date('D',strtotime($event->event_begin));
+ $day_end_event = date('D',strtotime($event->event_end));
+ $current_day = date('D',strtotime($date));
+
+ $plan = array();
+ $plan['Mon'] = 1;
+ $plan['Tue'] = 2;
+ $plan['Wed'] = 3;
+ $plan['Thu'] = 4;
+ $plan['Fri'] = 5;
+ $plan['Sat'] = 6;
+ $plan['Sun'] = 7;
+
+ if ($plan[$day_start_event] > $plan[$day_end_event])
+ {
+ if (($plan[$day_start_event] <= $plan[$current_day]) || ($plan[$current_day] <= $plan[$day_end_event]))
+ {
+ array_push($arr_events, $event);
+ }
+ }
+ else if (($plan[$day_start_event] < $plan[$day_end_event]) || ($plan[$day_start_event]== $plan[$day_end_event]))
+ {
+ if (($plan[$day_start_event] <= $plan[$current_day]) && ($plan[$current_day] <= $plan[$day_end_event]))
+ {
+ array_push($arr_events, $event);
+ }
+ }
+
+ }
+ }
+
+ // The weekly events that have a limit on how many times they occur
+ $events = $wpdb->get_results("SELECT * FROM " . WP_CALENDAR_TABLE . " WHERE event_recur = 'W' AND '$date' >= event_begin AND event_repeats != 0 AND (event_repeats*7) >= (TO_DAYS('$date') - TO_DAYS(event_end)) ORDER BY event_id");
+ if (!empty($events))
+ {
+ foreach($events as $event)
+ {
+ // This is going to get complex so lets setup what we would place in for
+ // an event so we can drop it in with ease
+
+ // Now we are going to check to see what day the original event
+ // fell on and see if the current date is both after it and on
+ // the correct day. If it is, display the event!
+ $day_start_event = date('D',strtotime($event->event_begin));
+ $day_end_event = date('D',strtotime($event->event_end));
+ $current_day = date('D',strtotime($date));
+
+ $plan = array();
+ $plan['Mon'] = 1;
+ $plan['Tue'] = 2;
+ $plan['Wed'] = 3;
+ $plan['Thu'] = 4;
+ $plan['Fri'] = 5;
+ $plan['Sat'] = 6;
+ $plan['Sun'] = 7;
+
+ if ($plan[$day_start_event] > $plan[$day_end_event])
+ {
+ if (($plan[$day_start_event] <= $plan[$current_day]) || ($plan[$current_day] <= $plan[$day_end_event]))
+ {
+ array_push($arr_events, $event);
+ }
+ }
+ else if (($plan[$day_start_event] < $plan[$day_end_event]) || ($plan[$day_start_event]== $plan[$day_end_event]))
+ {
+ if (($plan[$day_start_event] <= $plan[$current_day]) && ($plan[$current_day] <= $plan[$day_end_event]))
+ {
+ array_push($arr_events, $event);
+ }
+ }
+
+ }
+ }
+
+ return $arr_events;
+}
+
+
+// Actually do the printing of the calendar
+// Compared to searching for and displaying events
+// this bit is really rather easy!
+function calendar()
+{
+ global $wpdb;
+
+ // First things first, make sure calendar is up to date
+ check_calendar();
+
+ // Deal with the week not starting on a monday
+ if (get_option('start_of_week') == 0)
+ {
+ $name_days = array(1=>__('Sunday','calendar'),__('Monday','calendar'),__('Tuesday','calendar'),__('Wednesday','calendar'),__('Thursday','calendar'),__('Friday','calendar'),__('Saturday','calendar'));
+ }
+ // Choose Monday if anything other than Sunday is set
+ else
+ {
+ $name_days = array(1=>__('Monday','calendar'),__('Tuesday','calendar'),__('Wednesday','calendar'),__('Thursday','calendar'),__('Friday','calendar'),__('Saturday','calendar'),__('Sunday','calendar'));
+ }
+
+ // Carry on with the script
+ $name_months = array(1=>__('January','calendar'),__('February','calendar'),__('March','calendar'),__('April','calendar'),__('May','calendar'),__('June','calendar'),__('July','calendar'),__('August','calendar'),__('September','calendar'),__('October','calendar'),__('November','calendar'),__('December','calendar'));
+
+ // If we don't pass arguments we want a calendar that is relevant to today
+ if (empty($_GET['month']) || empty($_GET['yr']))
+ {
+ $c_year = date("Y");
+ $c_month = date("m");
+ $c_day = date("d");
+ }
+
+ // Years get funny if we exceed 3000, so we use this check
+ if ($_GET['yr'] <= 3000 && $_GET['yr'] >= 0)
+ {
+ // This is just plain nasty and all because of permalinks
+ // which are no longer used, this will be cleaned up soon
+ if ($_GET['month'] == 'jan' || $_GET['month'] == 'feb' || $_GET['month'] == 'mar' || $_GET['month'] == 'apr' || $_GET['month'] == 'may' || $_GET['month'] == 'jun' || $_GET['month'] == 'jul' || $_GET['month'] == 'aug' || $_GET['month'] == 'sept' || $_GET['month'] == 'oct' || $_GET['month'] == 'nov' || $_GET['month'] == 'dec')
+ {
+
+ // Again nasty code to map permalinks into something
+ // databases can understand. This will be cleaned up
+ $c_year = mysql_escape_string($_GET['yr']);
+ if ($_GET['month'] == 'jan') { $t_month = 1; }
+ else if ($_GET['month'] == 'feb') { $t_month = 2; }
+ else if ($_GET['month'] == 'mar') { $t_month = 3; }
+ else if ($_GET['month'] == 'apr') { $t_month = 4; }
+ else if ($_GET['month'] == 'may') { $t_month = 5; }
+ else if ($_GET['month'] == 'jun') { $t_month = 6; }
+ else if ($_GET['month'] == 'jul') { $t_month = 7; }
+ else if ($_GET['month'] == 'aug') { $t_month = 8; }
+ else if ($_GET['month'] == 'sept') { $t_month = 9; }
+ else if ($_GET['month'] == 'oct') { $t_month = 10; }
+ else if ($_GET['month'] == 'nov') { $t_month = 11; }
+ else if ($_GET['month'] == 'dec') { $t_month = 12; }
+ $c_month = $t_month;
+ $c_day = date("d");
+ }
+ // No valid month causes the calendar to default to today
+ else
+ {
+ $c_year = date("Y");
+ $c_month = date("m");
+ $c_day = date("d");
+ }
+ }
+ // No valid year causes the calendar to default to today
+ else
+ {
+ $c_year = date("Y");
+ $c_month = date("m");
+ $c_day = date("d");
+ }
+
+ // Fix the days of the week if week start is not on a monday
+ if (get_option('start_of_week') == 0)
+ {
+ $first_weekday = date("w",mktime(0,0,0,$c_month,1,$c_year));
+ $first_weekday = ($first_weekday==0?1:$first_weekday+1);
+ }
+ // Otherwise assume the week starts on a Monday. Anything other
+ // than Sunday or Monday is just plain odd
+ else
+ {
+ $first_weekday = date("w",mktime(0,0,0,$c_month,1,$c_year));
+ $first_weekday = ($first_weekday==0?7:$first_weekday);
+ }
+
+ $days_in_month = date("t", mktime (0,0,0,$c_month,1,$c_year));
+
+ // Start the table and add the header and naviagtion
+ $calendar_body .= '
+<table cellspacing="1" cellpadding="0" class="calendar-table">
+';
+
+ // We want to know if we should display the date switcher
+ $date_switcher = $wpdb->get_var("SELECT config_value FROM ".WP_CALENDAR_CONFIG_TABLE." WHERE config_item='display_jump'",0,0);
+
+ if ($date_switcher == 'true')
+ {
+ $calendar_body .= '<tr>
+ <td colspan="7" class="calendar-date-switcher">
+ <form method="GET" action="'.$_SERVER['REQUEST_URI'].'">
+';
+ $qsa = array();
+ parse_str($_SERVER['QUERY_STRING'],$qsa);
+ foreach ($qsa as $name => $argument)
+ {
+ if ($name != 'month' && $name != 'yr')
+ {
+ $calendar_body .= '<input type="hidden" name="'.$name.'" value="'.$argument.'" />
+';
+ }
+ }
+ function month_comparison($month)
+ {
+ $current_month = strtolower(date("M", time()));
+ if (isset($_GET['yr']) && isset($_GET['month']))
+ {
+ if ($month == $_GET['month'])
+ {
+ return ' selected="selected"';
+ }
+ }
+ elseif ($month == $current_month)
+ {
+ return ' selected="selected"';
+ }
+ }
+ // We build the months in the switcher
+ $calendar_body .= '
+ '.__('Month','calendar').': <select name="month" style="width:100px;">
+ <option value="jan"'.month_comparison('jan').'>'.__('January','calendar').'</option>
+ <option value="feb"'.month_comparison('feb').'>'.__('February','calendar').'</option>
+ <option value="mar"'.month_comparison('mar').'>'.__('March','calendar').'</option>
+ <option value="apr"'.month_comparison('apr').'>'.__('April','calendar').'</option>
+ <option value="may"'.month_comparison('may').'>'.__('May','calendar').'</option>
+ <option value="jun"'.month_comparison('jun').'>'.__('June','calendar').'</option>
+ <option value="jul"'.month_comparison('jul').'>'.__('July','calendar').'</option>
+ <option value="aug"'.month_comparison('aug').'>'.__('August','calendar').'</option>
+ <option value="sept"'.month_comparison('sept').'>'.__('September','calendar').'</option>
+ <option value="oct"'.month_comparison('oct').'>'.__('October','calendar').'</option>
+ <option value="nov"'.month_comparison('nov').'>'.__('November','calendar').'</option>
+ <option value="dec"'.month_comparison('dec').'>'.__('December','calendar').'</option>
+ </select>
+ '.__('Year','calendar').': <select name="yr" style="width:60px;">
+';
+
+ // The year builder is string mania. If you can make sense of this,
+ // you know your PHP!
+ function year_comparison($year)
+ {
+ $current_year = strtolower(date("Y", time()));
+ if (isset($_GET['yr']) && isset($_GET['month']))
+ {
+ if ($year == $_GET['yr'])
+ {
+ return ' selected="selected"';
+ }
+ }
+ else if ($year == $current_year)
+ {
+ return ' selected="selected"';
+ }
+ }
+
+ $past = 30;
+ $future = 30;
+ $fut = 1;
+ while ($past > 0)
+ {
+ $p .= ' <option value="';
+ $p .= date("Y",time())-$past;
+ $p .= '"'.year_comparison(date("Y",time())-$past).'>';
+ $p .= date("Y",time())-$past.'</option>
+';
+ $past = $past - 1;
+ }
+ while ($fut < $future)
+ {
+ $f .= ' <option value="';
+ $f .= date("Y",time())+$fut;
+ $f .= '"'.year_comparison(date("Y",time())+$fut).'>';
+ $f .= date("Y",time())+$fut.'</option>
+';
+ $fut = $fut + 1;
+ }
+ $calendar_body .= $p;
+ $calendar_body .= ' <option value="'.date("Y",time()).'"'.year_comparison(date("Y",time())).'>'.date("Y",time()).'</option>
+';
+ $calendar_body .= $f;
+ $calendar_body .= '</select>
+ <input type="submit" value="Go" />
+ </form>
+ </td>
+</tr>
+';
+ }
+
+ // The header of the calendar table and the links. Note calls to link functions
+ $calendar_body .= '<tr>
+ <td colspan="7" class="calendar-heading">
+ <table border="0" cellpadding="0" cellspacing="0" width="100%">
+ <tr>
+ <td class="calendar-prev">' . prev_link($c_year,$c_month) . '</td>
+ <td class="calendar-month">'.$name_months[(int)$c_month].' '.$c_year.'</td>
+ <td class="calendar-next">' . next_link($c_year,$c_month) . '</td>
+ </tr>
+ </table>
+ </td>
+</tr>
+';
+
+ // Print the headings of the days of the week
+ $calendar_body .= '<tr>
+';
+ for ($i=1; $i<=7; $i++)
+ {
+ // Colours need to be different if the starting day of the week is different
+ if (get_option('start_of_week') == 0)
+ {
+ $calendar_body .= ' <td class="'.($i<7&&$i>1?'normal-day-heading':'weekend-heading').'">'.$name_days[$i].'</td>
+';
+ }
+ else
+ {
+ $calendar_body .= ' <td class="'.($i<6?'normal-day-heading':'weekend-heading').'">'.$name_days[$i].'</td>
+';
+ }
+ }
+ $calendar_body .= '</tr>
+';
+
+ for ($i=1; $i<=$days_in_month;)
+ {
+ $calendar_body .= '<tr>
+';
+ for ($ii=1; $ii<=7; $ii++)
+ {
+ if ($ii==$first_weekday && $i==1)
+ {
+ $go = TRUE;
+ }
+ elseif ($i > $days_in_month )
+ {
+ $go = FALSE;
+ }
+
+ if ($go)
+ {
+ // Colours again, this time for the day numbers
+ if (get_option('start_of_week') == 0)
+ {
+ // This bit of code is for styles believe it or not.
+ $grabbed_events = grab_events($c_year,$c_month,$i);
+ $no_events_class = '';
+ if (!count($grabbed_events))
+ {
+ $no_events_class = ' no-events';
+ }
+ $calendar_body .= ' <td class="'.(date("Ymd", mktime (0,0,0,$c_month,$i,$c_year))==date("Ymd")?'current-day':'day-with-date').$no_events_class.'"><span '.($ii<7&&$ii>1?'':'class="weekend"').'>'.$i++.'</span><span class="event">' . draw_events($grabbed_events) . '</span></td>
+';
+ }
+ else
+ {
+ $grabbed_events = grab_events($c_year,$c_month,$i);
+ $no_events_class = '';
+ if (!count($grabbed_events))
+ {
+ $no_events_class = ' no-events';
+ }
+ $calendar_body .= ' <td class="'.(date("Ymd", mktime (0,0,0,$c_month,$i,$c_year))==date("Ymd")?'current-day':'day-with-date').$no_events_class.'"><span '.($ii<6?'':'class="weekend"').'>'.$i++.'</span><span class="event">' . draw_events($grabbed_events) . '</span></td>
+';
+ }
+ }
+ else
+ {
+ $calendar_body .= ' <td class="day-without-date"> </td>
+';
+ }
+ }
+ $calendar_body .= '</tr>
+';
+ }
+ $show_cat = $wpdb->get_var("SELECT config_value FROM ".WP_CALENDAR_CONFIG_TABLE." WHERE config_item='enable_categories'",0,0);
+
+ if ($show_cat == 'true')
+ {
+ $sql = "SELECT * FROM " . WP_CALENDAR_CATEGORIES_TABLE . " ORDER BY category_name ASC";
+ $cat_details = $wpdb->get_results($sql);
+ $calendar_body .= '<tr><td colspan="7">
+<table class="cat-key">
+<tr><td colspan="2"><strong>'.__('Category Key','calendar').'</strong></td></tr>
+';
+ foreach($cat_details as $cat_detail)
+ {
+ $calendar_body .= '<tr><td style="background-color:'.$cat_detail->category_colour.'; width:20px; height:20px;"></td><td>'.$cat_detail->category_name.'</td></tr>';
+ }
+ $calendar_body .= '</table>
+</td></tr>
+';
+ }
+ $calendar_body .= '</table>
+';
+
+ // A little link to yours truely. See the README if you wish to remove this
+ $calendar_body .= '<div class="kjo-link" style="visibility:visible;display:block;"><p>'.__('Calendar developed and supported by ', 'calendar').'<a href="http://www.kieranoshea.com">Kieran O\'Shea</a></p></div>
+';
+
+ // Phew! After that bit of string building, spit it all out.
+ // The actual printing is done by the calling function.
+ return $calendar_body;
+}
+
+?>