function SpiderCalendar_activate()
{
global $wpdb;
$spider_event_table = "CREATE TABLE IF NOT EXISTS `" . $wpdb->prefix . "spidercalendar_event` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `calendar` int(11) NOT NULL,\n `date` date NOT NULL,\n `date_end` date NOT NULL,\n `title` text NOT NULL,\n `time` varchar(20) NOT NULL,\n `text_for_date` longtext NOT NULL,\n `userID` varchar(255) NOT NULL,\n `repeat_method` varchar(255) NOT NULL,\n `repeat` varchar(255) NOT NULL,\n `week` varchar(255) NOT NULL,\n `month` varchar(255) NOT NULL,\n `month_type` varchar(255) NOT NULL,\n `monthly_list` varchar(255) NOT NULL,\n `month_week` varchar(255) NOT NULL,\n `year_month` varchar(255) NOT NULL,\n `published` int(11) NOT NULL,\n PRIMARY KEY (`id`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
$spider_calendar_table = "CREATE TABLE IF NOT EXISTS `" . $wpdb->prefix . "spidercalendar_calendar` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `title` varchar(255) NOT NULL,\n `gid` varchar(255) NOT NULL,\n `def_zone` varchar(255) NOT NULL,\n `time_format` tinyint(1) NOT NULL,\n `allow_publish` varchar(255) NOT NULL,\n `start_month` varchar(255) NOT NULL,\n `published` tinyint(1) NOT NULL,\n PRIMARY KEY (`id`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
$spider_category_event_table = "CREATE TABLE IF NOT EXISTS `" . $wpdb->prefix . "spidercalendar_event_category` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `title` varchar(255) NOT NULL,\n `published` tinyint(1) NOT NULL,\n `color` varchar(255) NOT NULL,\n `description` longtext NOT NULL,\n PRIMARY KEY (`id`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
$wpdb->query($spider_event_table);
$wpdb->query($spider_calendar_table);
$wpdb->query($spider_category_event_table);
require_once "spider_calendar_update.php";
spider_calendar_chech_update();
}
$spider_widget_theme_rows = "INSERT INTO `" . $wpdb->prefix . "spidercalendar_widget_theme` (`id`, `title`, `width`, `cell_height`, `bg_top`, `bg_bottom`, `border_color`, `text_color_year`, `text_color_month`, `text_color_week_days`, `text_color_other_months`, `text_color_this_month_unevented`, `text_color_this_month_evented`, `event_title_color`, `current_day_border_color`, `bg_color_this_month_evented`, `next_prev_event_arrowcolor`, `show_event_bgcolor`, `cell_border_color`, `arrow_color_year`, `week_days_cell_height`, `arrow_color_month`, `text_color_sun_days`, `title_color`, `next_prev_event_bgcolor`, `title_font_size`, `title_font`, `title_style`, `date_color`, `date_size`, `date_font`, `date_style`, `popup_width`, `popup_height`, `number_of_shown_evetns`, `sundays_font_size`, `other_days_font_size`, `weekdays_font_size`, `border_width`, `top_height`, `bg_color_other_months`, `sundays_bg_color`, `weekdays_bg_color`, `week_start_day`, `weekday_sunday_bg_color`, `border_radius`, `year_font_size`, `month_font_size`, `arrow_size`, `next_month_text_color`, `prev_month_text_color`, `next_month_arrow_color`, `prev_month_arrow_color`, `next_month_font_size`, `prev_month_font_size`, `month_type`, `date_format`, `show_time`, `show_repeat`, `all_days_border_width`) VALUES\n(1, 'Blue Dark', '230', '30', '00004F', '5BCAFF', '00004F', 'D1D4F5', 'D1D4F5', 'FFFFFF', 'E6E6E6', '000000', 'FFFFFF', 'FFFFFF', 'FFFFFF', '00004F', 'FFFFFF', '009EEB', '000000', 'FFFFFF', '30', 'FFFFFF', '000000', 'FFFFFF', '00004F', '', '', 'normal', 'FFFFFF', '', '', 'normal', '600', '500', '1', '14', '12', '14', '2', '40', '5BCAFF', '5BCAFF', '00004F', 'su', '00004F', '', '18', '14', '14', 'FFFFFF', 'FFFFFF', 'FFFFFF', 'FFFFFF', '9', '9', '2', 'w/d/m/y', 0, 1, 0),\n(2, 'Green Light', '230', '25', 'A6BA7D', 'FDFCDE', '000000', '000000', '080808', '000000', '6E5959', '060D12', '000000', '000000', '4AFF9E', 'FF6933', 'E0E0C5', 'FDFCDE', '000000', '000000', '25', '000000', 'FF0000', '000000', 'CCCCCC', '18', 'Courier New', 'normal', '000000', '16', 'Courier New', 'bold', '800', '600', '1', '14', '12', '14', '2', '70', 'FFFFFF', 'FDFCDE', 'E6E6DE', 'su', 'BD848A', '0', '16', '14', '14', 'FFFFFF', 'FFFFFF', 'FFFFFF', 'FFFFFF', '9', '9', '2', 'w/d/m/y', 0, 1, 0),\n(3, 'Blue Light', '220', '25', '36A7E9', 'FFFFFF', '000000', '000000', '000000', '000000', '525252', '000000', 'FFFFFF', 'FFFFFF', '36A7E9', 'FFA142', 'FFFFFF', '36A7E9', '000000', '000000', '30', '000000', '36A7E9', 'FFFFFF', 'FFA142', '12', 'Courier New', 'normal', 'FFFFFF', '16', 'Courier New', 'bold', '800', '600', '1', '14', '12', '14', '2', '70', 'FFFFFF', 'FFFFFF', 'FFFFFF', 'su', 'FFFFFF', '0', '18', '14', '10', 'FFFFFF', 'FFFFFF', 'FFFFFF', 'FFFFFF', '9', '9', '2', 'w/d/m/y', 0, 1, 0),\n(4, 'Black light', '230', '30', '2A2829', '363636', '000000', 'FFFFFF', 'FFFFFF', 'FFFFFF', 'BDBDBD', 'FFFFFF', '000000', '000000', 'FFFFFF', 'F0F0F0', 'C7C7C7', '969696', '000000', 'FFFFFF', '25', 'FFFFFF', 'FFFFFF', 'FFFFFF', '323232', '', '', 'normal', 'FFFFFF', '', '', 'normal', '600', '500', '1', '14', '12', '14', '2', '30', '363636', '363636', '2A2829', 'su', '2A2829', '4', '18', '14', '12', 'FFFFFF', 'FFFFFF', 'FFFFFF', 'FFFFFF', '9', '9', '1', 'w/d/m/y', 0, 1, 0),\n(5, 'Red Elegant', '220', '27', '9A0000', 'CDCC96', 'D9D9D7', 'FFFFFF', 'FFFFFF', '000000', '525252', '000000', 'FFFFFF', 'FFFFFF', '9A0000', '9A0000', 'DEDDB5', 'FFFED0', 'FFFFFF', 'FFFFFF', '25', 'FFFFFF', '9A0000', '000000', '9A0000', '', '', 'normal', '000000', '', '', 'normal', '600', '500', '1', '14', '', '14', '6', '70', 'E4E7CC', 'CDCC96', 'FFFED0', 'mo', 'FFFED0', '3', '18', '14', '9', 'FFFFFF', 'FFFFFF', 'FFFFFF', 'FFFFFF', '9', '9', '2', 'w/d/m/y', 0, 1, 1),\n(6, 'Blue Simple', '220', '25', 'FCF7D9', 'FFFFFF', '3DBCEB', '9A0000', '9A0000', 'FFFFFF', 'C7C7C7', '1374C3', '000000', '000000', '9A0000', 'FCF7D9', 'E0E0E0', 'FCF7D9', '1374C3', '9A0000', '20', '9A0000', '013A7D', '000000', '21B5FF', '', '', 'normal', '000000', '', '', 'bold', '600', '500', '1', '14', '12', '14', '5', '70', 'FFFFFF', 'FFFFFF', '013A7D', 'su', '1374C3', '3', '18', '14', '9', 'FFFFFF', 'FFFFFF', 'FFFFFF', 'FFFFFF', '9', '9', '2', 'w/d/m/y', 0, 1, 0),\n(7, 'Green Dark', '210', '27', '598923', 'F0F0E6', 'D78B29', 'FFFFFF', 'FFFFFF', '000000', 'A6A6A6', '5C5C5C', 'FFFFFF', 'FFFFFF', '000000', 'D78B29', 'D78B29', 'FFB061', '363636', 'FFFFFF', '25', 'FFFFFF', '000000', 'FFFFFF', 'DDDCC8', '', 'Courier New', 'bold', '000000', '', '', 'normal', '600', '500', '1', '14', '12', '12', '6', '70', 'DDDCC8', 'F0F0E6', 'D78B29', 'su', 'D78B29', '2', '18', '14', '8', 'FFFFFF', 'FFFFFF', 'FFFFFF', 'FFFFFF', '9', '9', '1', 'w/d/m/y', 0, 1, 1),\n(8, 'Green Elegant', '195', '20', '009898', 'FDFDCC', 'FDFDCC', 'FFFFFF', 'FFFFFF', '000000', '8C8C8C', '383838', '383838', 'FFFFFF', '000000', 'FE7C00', 'FEAC30', 'FE7C00', '4D4D4D', 'FFFFFF', '25', 'FFFFFF', '000000', 'FFFFFF', 'FDFDE8', '', '', 'normal', 'FFFFFF', '', '', 'normal', '600', '500', '1', '14', '12', '14', '7', '40', 'FDFDE8', 'BACBDC', '9865FE', 'su', '9865FE', '2', '18', '14', '8', 'FFFFFF', 'FFFFFF', 'FFFFFF', 'FFFFFF', '9', '9', '1', 'w/d/m/y', 0, 1, 0),\n(9, 'Blue Elegant', '240', '30', '346699', 'E3F9F9', '346699', 'FFFFFF', 'FFFFFF', 'FFFFFF', 'CCCCCC', '2410EE', '000000', '000000', '346699', 'FFCC33', 'E3B62D', 'FFCC33', '6B6B6B', 'FFFFFF', '25', 'FFFFFF', '2410EE', 'FFFFFF', '346699', '', '', 'normal', '000000', '', '', 'normal', '600', '500', '1', '14', '12', '12', '4', '60', 'E3F9F9', 'E3F9F9', '68676D', 'su', '68676D', '3', '18', '12', '8', 'FFFFFF', 'FFFFFF', 'FFFFFF', 'FFFFFF', '10', '10', '2', 'w/d/m/y', 0, 1, 0),\n(10, 'Blue Green Mix', '220', '25', 'C0EFC0', 'E3F9F9', 'ABCEA8', '58A42B', '58A42B', '000000', 'B0B0B0', '383838', '383838', '383838', '58A42B', 'C0EFC0', 'AED9AE', 'C0EFC0', 'B1B1B0', '58A42B', '20', '58A42B', 'FF7C5C', 'FFFFFF', '58A42B', '12', '', 'normal', '262626', '12', '', 'normal', '600', '500', '1', '12', '14', '12', '6', '70', 'E1DDE9', 'FFFFFF', 'FFFFFF', 'su', 'FFFFFF', '2', '18', '12', '10', '58A42B', '58A42B', '58A42B', '58A42B', '10', '10', '2', 'w/d/m/y', 0, 1, 0),\n(11, 'Brown Elegant', '210', '25', 'E7C892', '7E5F43', 'FFC219', '404040', '404040', '404040', 'FFFFFF', 'FFFFFF', '404040', '404040', 'FFFFFF', 'FFC219', 'B3875F', '7E5F43', '000000', '404040', '20', '404040', 'FFFFFF', 'FFFFFF', 'FFC219', '', '', 'normal', 'FFFFFF', '', '', 'normal', '800', '500', '2', '14', '12', '12', '4', '60', '523F30', '7E5F43', 'FFC219', 'su', 'FFC219', '2', '16', '11', '10', '404040', '404040', '404040', '404040', '9', '9', '1', 'w/d/m/y', 1, 1, 0);";
$spider_theme_rows = "INSERT INTO `" . $wpdb->prefix . "spidercalendar_theme` (`id`, `title`, `width`, `cell_height`, `bg_top`, `bg_bottom`, `border_color`, `text_color_year`, `text_color_month`, `text_color_week_days`, `text_color_other_months`, `text_color_this_month_unevented`, `text_color_this_month_evented`, `event_title_color`, `current_day_border_color`, `bg_color_this_month_evented`, `next_prev_event_arrowcolor`, `show_event_bgcolor`, `cell_border_color`, `arrow_color_year`, `week_days_cell_height`, `arrow_color_month`, `text_color_sun_days`, `title_color`, `next_prev_event_bgcolor`, `title_font_size`, `title_font`, `title_style`, `date_color`, `date_size`, `date_font`, `date_style`, `popup_width`, `popup_height`, `number_of_shown_evetns`, `sundays_font_size`, `other_days_font_size`, `weekdays_font_size`, `border_width`, `top_height`, `bg_color_other_months`, `sundays_bg_color`, `weekdays_bg_color`, `week_start_day`, `weekday_sunday_bg_color`, `border_radius`, `year_font_size`, `month_font_size`, `arrow_size`, `next_month_text_color`, `prev_month_text_color`, `next_month_arrow_color`, `prev_month_arrow_color`, `next_month_font_size`, `prev_month_font_size`, `month_type`, `date_format`, `show_time`, `show_repeat`) VALUES\n(1, 'Blue Light', '650', '80', '36A7E9', 'FFFFFF', '000000', '000000', '000000', '000000', '525252', '000000', 'FFFFFF', 'FFFFFF', '36A7E9', 'FFA142', 'FFFFFF', '36A7E9', '000000', '000000', '40', '000000', '36A7E9', 'FFFFFF', 'FFA142', '', '', 'normal', 'FFFFFF', '16', '', 'bold', '800', '600', '1', '14', '12', '14', '4', '80', 'FFFFFF', 'FFFFFF', 'FFFFFF', 'su', 'FFFFFF', '0', '22', '14', '10', 'FFFFFF', 'FFFFFF', 'FFFFFF', 'FFFFFF', '', '', '2', 'w/d/m/y', 1, 1),\n(2, 'Blue Dark', '650', '70', '00004F', '5BCAFF', '000000', 'D1D4F5', 'D1D4F5', 'FFFFFF', 'E6E6E6', '000000', 'FFFFFF', 'FFFFFF', 'FFFFFF', '00004F', 'FFFFFF', '009EEB', '000000', 'FFFFFF', '30', 'FFFFFF', '000000', 'FFFFFF', '00004F', '', '', 'normal', 'FFFFFF', '', '', 'normal', '600', '500', '1', '18', '14', '14', '2', '120', 'C0C0C0', '8ADAFF', '000000', 'su', '000000', '', '40', '20', '14', 'FFFFFF', 'FFFFFF', 'FFFFFF', 'FFFFFF', '', '', '1', 'w/d/m/y', 1, 1),\n(3, 'Green Light', '650', '70', 'A6BA7D', 'FDFCDE', '000000', '000000', '080808', '000000', '6E5959', '060D12', '000000', '000000', '4AFF9E', 'FF6933', 'E0E0C5', 'FDFCDE', '000000', '000000', '50', '000000', 'FF0000', '000000', 'CCCCCC', '18', 'Courier New', 'normal', '000000', '16', 'Courier New', 'bold', '800', '600', '1', '18', '12', '14', '2', '90', 'FFFFFF', 'FDFCDE', 'E6E6DE', 'su', 'BD848A', '0', '28', '18', '18', 'FFFFFF', 'FFFFFF', 'FFFFFF', 'FFFFFF', '', '', '1', 'w/d/m/y', 1, 1),\n(4, 'Black light', '650', '70', '2A2829', '323232', '000000', 'FFFFFF', 'FFFFFF', 'FFFFFF', 'FFFFFF', 'FFFFFF', '000000', '000000', 'FFFFFF', 'F0F0F0', 'C7C7C7', '969696', '000000', 'FFFFFF', '35', 'FFFFFF', 'FFFFFF', 'FFFFFF', '323232', '', '', 'normal', 'FFFFFF', '', '', 'normal', '600', '500', '1', '16', '12', '14', '2', '90', '282828', '323232', '969696', 'su', '969696', '8', '33', '16', '12', 'FFFFFF', 'FFFFFF', 'FFFFFF', 'FFFFFF', '', '', '1', 'w/d/m/y', 1, 1),\n(5, 'Red Elegant', '650', '70', '9A0000', 'CDCC96', 'E6E6E4', 'FFFFFF', 'FFFFFF', '000000', '525252', '000000', 'FFFFFF', 'FFFFFF', '9A0000', '9A0000', 'DEDDB5', 'FFFED0', 'FFFFFF', 'FFFFFF', '60', 'FFFFFF', '000000', '000000', '9A0000', '', '', 'normal', '000000', '', '', 'normal', '600', '500', '1', '18', '', '14', '18', '100', 'E4E7CC', 'CDCC96', 'FFFED0', 'mo', 'FFFED0', '6', '33', '16', '10', 'FFFFFF', 'FFFFFF', 'FFFFFF', 'FFFFFF', '', '', '1', 'w/d/m/y', 1, 1),\n(6, 'Blue Simple', '650', '70', 'FCF7D9', 'FFFFFF', '3DBCEB', '9A0000', '9A0000', 'FFFFFF', 'C7C7C7', '1374C3', '000000', '000000', '9A0000', 'FCF7D9', 'E0E0E0', 'FCF7D9', '1374C3', '9A0000', '20', '9A0000', '013A7D', '000000', '21B5FF', '', '', 'normal', '000000', '', '', 'bold', '600', '500', '1', '16', '12', '14', '12', '93', 'FFFFFF', 'FFFFFF', '013A7D', 'su', '1374C3', '6', '33', '16', '10', 'FFFFFF', 'FFFFFF', 'FFFFFF', 'FFFFFF', '', '', '1', 'w/d/m/y', 1, 1),\n(7, 'Green Dark', '650', '70', '598923', 'F0F0E6', 'D78B29', 'FFFFFF', 'FFFFFF', '000000', 'A6A6A6', '5C5C5C', 'FFFFFF', 'FFFFFF', '000000', 'D78B29', 'D78B29', 'FFB061', '363636', 'FFFFFF', '30', 'FFFFFF', '000000', 'FFFFFF', 'DDDCC8', '', 'Courier New', 'bold', '000000', '', '', 'normal', '600', '500', '1', '16', '12', '14', '12', '100', 'DDDCC8', 'F0F0E6', 'D78B29', 'su', 'D78B29', '6', '33', '16', '12', 'FFFFFF', 'FFFFFF', 'FFFFFF', 'FFFFFF', '', '', '1', 'w/d/m/y', 1, 1),\n(8, 'Green Elegant', '650', '70', '009898', 'FDFDCC', 'FDFDCC', 'FFFFFF', 'FFFFFF', '000000', '8C8C8C', '383838', '383838', 'FFFFFF', '000000', 'FE7C00', 'FEAC30', 'FE7C00', '4D4D4D', 'FFFFFF', '30', 'FFFFFF', '000000', 'FFFFFF', 'FDFDE8', '', '', 'normal', 'FFFFFF', '', '', 'normal', '600', '500', '1', '16', '12', '14', '14', '90', 'FDFDE8', 'BACBDC', '9865FE', 'su', '9865FE', '2', '30', '16', '12', 'FFFFFF', 'FFFFFF', 'FFFFFF', 'FFFFFF', '', '', '1', 'w/d/m/y', 1, 1),\n(9, 'Blue Elegant', '650', '70', '346699', 'E3F9F9', '346699', 'FFFFFF', 'FFFFFF', 'FFFFFF', 'FFFFFF', '2410EE', '000000', '000000', '346699', 'FFCC33', 'E3B62D', 'FFCC33', '6B6B6B', 'FFFFFF', '25', 'FFFFFF', '2410EE', 'FFFFFF', '346699', '', '', 'normal', '000000', '', '', 'normal', '600', '500', '1', '18', '14', '14', '10', '100', 'CCCCCC', 'CDDDFF', '68676D', 'su', '68676D', '4', '33', '16', '12', 'FFFFFF', 'FFFFFF', 'FFFFFF', 'FFFFFF', '', '', '1', 'w/d/m/y', 1, 1),\n(10, 'Blue Green Mix', '650', '70', 'C0EFC0', 'E3F9F9', 'ABCEA8', '58A42B', '58A42B', '000000', 'B0B0B0', '383838', '383838', '383838', '58A42B', 'C0EFC0', 'AED9AE', 'C0EFC0', 'B1B1B0', '58A42B', '25', '58A42B', 'FF7C5C', 'FFFFFF', '58A42B', '', '', 'normal', '262626', '', '', 'normal', '600', '500', '1', '16', '12', '12', '8', '40', 'E1DDE9', 'FFFFFF', 'FFFFFF', 'su', 'FFFFFF', '2', '18', '18', '10', '58A42B', '58A42B', '58A42B', '58A42B', '16', '16', '2', 'w/d/m/y', 1, 1),\n(11, 'Brown Elegant', '650', '70', 'E7C892', '7E5F43', 'FFC219', '404040', '404040', '404040', 'FFFFFF', 'FFFFFF', '404040', '404040', 'FFFFFF', 'FFC219', 'B3875F', '7E5F43', '000000', '404040', '30', '404040', 'FFFFFF', 'FFFFFF', 'FFC219', '', '', 'normal', 'FFFFFF', '', '', 'normal', '800', '500', '2', '18', '12', '14', '10', '100', '523F30', '7E5F43', 'FFC219', 'su', 'FFC219', '6', '30', '20', '12', '404040', '404040', '404040', '404040', '16', '16', '1', 'w/d/m/y', 1, 1);";
//create tables
$wpdb->query($spider_event_table);
$wpdb->query($spider_calendar_table);
$wpdb->query($spider_theme_table);
$wpdb->query($spider_widhet_theme_table);
$wpdb->query($spider_theme_rows);
$wpdb->query($spider_widget_theme_rows);
}
register_activation_hook(__FILE__, 'SpiderCalendar_activate');
///////////////////// update plugin
if (get_bloginfo('version') >= 3.1) {
add_action('plugins_loaded', 'spider_calendar_chech_update');
} else {
spider_calendar_chech_update();
}
function spider_calendar_chech_update()
{
global $wpdb;
if (get_site_option('spider_calendar_cureent_version') != '1.1') {
$sql = "ALTER TABLE " . $wpdb->prefix . "spidercalendar_calendar ADD start_month varchar(255);";
$wpdb->query($sql);
if (!get_site_option('spider_calendar_cureent_version', false)) {
if ($wpdb->get_var("SHOW TABLES LIKE '" . $wpdb->prefix . "spidercalendar_widget_theme'") == $wpdb->prefix . "spidercalendar_widget_theme") {
add_option('spider_calendar_cureent_version', '1.1');
}
} else {
if ($wpdb->get_var("SHOW TABLES LIKE '" . $wpdb->prefix . "spidercalendar_widget_theme'") == $wpdb->prefix . "spidercalendar_widget_theme") {
update_option('spider_calendar_cureent_version', '1.1');
}
