diff -r 000000000000 -r 03b0d1493584 web/wp-content/plugins/calendar/calendar.php
--- /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&amp;action=edit&amp;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&amp;action=delete&amp;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;">&nbsp;</div>
+		</div>
+                <input type="submit" name="save" class="button bold" value="<?php _e('Save','calendar'); ?> &raquo;" />
+	</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;">&nbsp;</div>
+	        </div>
+                <input type="submit" name="save" class="button bold" value="<?php _e('Save','calendar'); ?> &raquo;" />
+  </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;">&nbsp;</div>
+                </div>
+                <input type="submit" name="save" class="button bold" value="<?php _e('Save','calendar'); ?> &raquo;" />
+    </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;">&nbsp;</div>
+                </div>
+                <input type="submit" name="save" class="button bold" value="<?php _e('Save','calendar'); ?> &raquo;" />
+    </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; ?>;">&nbsp;</td>
+	     <td><a href="<?php echo $_SERVER['PHP_SELF']  ?>?page=calendar-categories&amp;mode=edit&amp;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&amp;mode=delete&amp;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').' &raquo;</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').' &raquo;</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 .'">&laquo; '.__('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 . '">&laquo; '.__('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">&nbsp;</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;
+}
+
+?>