<?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 )

		{