ExtCalendar May 22, 2005 Matthew Friedman This component is released under the GNU/GPL License mf@marjoram.net www.whatismoving.com 0.9.1 Events calendar with very nice CSS display. Created for MamboServer based on the excellent ExtCal 2 program by Mohamed Moujami (SimoAmi), at http://extcal.sourceforge.net/ based on its Beta 1 release and CVS files as of Feb. 23, 2005. admin_events.php cal_popup.php cal_search.php config.inc.php extcalendar.class.php extcalendar.php index.html install.extcalendar.php LICENSE uninstall.extcalendar.php images/index.html include/colorpicker.php include/dblib.php include/functions.inc.php include/index.html include/installed.dis include/sql_parse.php languages/brazilian_portuguese/index.php languages/danish/index.php languages/dutch/index.php languages/english/index.php languages/french/index.php languages/german/index.php languages/italian/index.php languages/spanish/index.php languages/swedish/index.php lib/class.phpmailer.php lib/class.smtp.php lib/event.inc.php lib/index.html lib/mail.inc.php lib/xmlrpc.inc themes/default/style.css themes/default/template.html themes/default/theme.php themes/default/images/addsign.gif themes/default/images/addsign_a.gif themes/default/images/arrowleft.gif themes/default/images/arrowright.gif themes/default/images/banner.png themes/default/images/bannerbg.gif themes/default/images/bg1.gif themes/default/images/box_left_icon.gif themes/default/images/btn_bg.gif themes/default/images/btn_bold.gif themes/default/images/btn_center.gif themes/default/images/btn_image.gif themes/default/images/btn_italic.gif themes/default/images/btn_left.gif themes/default/images/btn_link.gif themes/default/images/btn_right.gif themes/default/images/btn_underline.gif themes/default/images/days1.gif themes/default/images/days2.gif themes/default/images/def_pic.gif themes/default/images/errormessage.gif themes/default/images/icon-add.gif themes/default/images/icon-addevent.gif themes/default/images/icon-apprevent.gif themes/default/images/icon-archive.gif themes/default/images/icon-calendarview.gif themes/default/images/icon-cat-active.gif themes/default/images/icon-cat-inactive.gif themes/default/images/icon-cats.gif themes/default/images/icon-colorpicker.gif themes/default/images/icon-daily.gif themes/default/images/icon-del.gif themes/default/images/icon-delevent.gif themes/default/images/icon-edit.gif themes/default/images/icon-editevent.gif themes/default/images/icon-event-active.gif themes/default/images/icon-event-enddate.gif themes/default/images/icon-event-inactive.gif themes/default/images/icon-event-middate.gif themes/default/images/icon-event-onedate.gif themes/default/images/icon-event-startdate.gif themes/default/images/icon-flyer.gif themes/default/images/icon-group.gif themes/default/images/icon-info.gif themes/default/images/icon-loginpic.gif themes/default/images/icon-mini-week.gif themes/default/images/icon-minus.gif themes/default/images/icon-photo.gif themes/default/images/icon-plus.gif themes/default/images/icon-print.gif themes/default/images/icon-recur-event-active.gif themes/default/images/icon-recur-event-inactive.gif themes/default/images/icon-release-dev.gif themes/default/images/icon-release.gif themes/default/images/icon-search.gif themes/default/images/icon-tag-menu.gif themes/default/images/icon-update.gif themes/default/images/icon-user-active.gif themes/default/images/icon-user-inactive.gif themes/default/images/icon-user-profile.jpg themes/default/images/icon-user.gif themes/default/images/icon-visibility.gif themes/default/images/icon-weekly.gif themes/default/images/logo.gif themes/default/images/mini_arrowleft.gif themes/default/images/mini_arrowleft_inactive.gif themes/default/images/mini_arrowright.gif themes/default/images/minical.png themes/default/images/preview.gif themes/default/images/rect.gif themes/default/images/tile_back1.gif themes/default/images/tile_sub.gif themes/default/images/txtboxbg.gif upload/index.html index_image.gif images/minipics/def_pic.gif images/box_left_icon.gif images/colorpicker.gif images/errormessage.gif images/icon-colorpicker.gif images/icon-print.gif images/mini_arrowleft.gif images/mini_arrowright.gif images/selected.gif images/spacer.gif images/tile_back1.gif images/txtboxbg.gif CREATE TABLE IF NOT EXISTS #__extcal_categories ( cat_id int(11) NOT NULL auto_increment, cat_parent int(11) NOT NULL default '0', cat_name varchar(150) NOT NULL default '', description text NOT NULL, color varchar(10) default '#000000', bgcolor varchar(10) default '#EEF0F0', options tinyint(4) default '0', published tinyint(1) default '0', checked_out int(11) unsigned NOT NULL default '0', checked_out_time datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (cat_id), UNIQUE KEY cat_id (cat_id) ) TYPE=MyISAM COMMENT = 'Table for event categories'; CREATE TABLE IF NOT EXISTS #__extcal_events ( extid int(11) NOT NULL auto_increment, title varchar(255) NOT NULL default '', description text NOT NULL, contact text NOT NULL, url varchar(100) NOT NULL default '', email varchar(120) NOT NULL default '', picture varchar(100) NOT NULL default '', cat tinyint(2) NOT NULL default '0', day tinyint(2) NOT NULL default '0', month smallint(2) NOT NULL default '0', year smallint(4) NOT NULL default '0', approved tinyint(1) NOT NULL default '0', start_date datetime NOT NULL default '0000-00-00 00:00:00', end_date datetime default '0000-00-00 00:00:00', recur_type varchar(16) default NULL, recur_val tinyint(4) default '0', recur_end_type tinyint(1) unsigned NOT NULL default '0', recur_count tinyint unsigned NOT NULL default '0', recur_until date default '0000-00-00', PRIMARY KEY (extid), UNIQUE KEY extid (extid), KEY start_date (start_date) ) TYPE=MyISAM COMMENT = 'Table holding events and their attributes'; CREATE TABLE IF NOT EXISTS #__extcal_config ( name varchar(40) NOT NULL default '', value varchar(255) NOT NULL default '', checked_out int(11) unsigned NOT NULL default '0', checked_out_time datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (name) ) TYPE=MyISAM COMMENT = 'Table for configurable parameters'; CREATE TABLE IF NOT EXISTS #__extcal_plugins ( plugin_id int(11) NOT NULL auto_increment, plugin_name varchar(64) NOT NULL, plugin_priority tinyint(2) unsigned NOT NULL default '50', plugin_path varchar(255) default null, PRIMARY KEY(plugin_id) ) TYPE = MYISAM COMMENT = 'Table holding installed plugins'; INSERT INTO #__extcal_categories VALUES (1,0,'General', 'This is the default category', '#000000','#EEF0F0', 2, 1, 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('allowed_file_extensions', 'GIF/PNG/JPG/JPEG', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('max_upl_size', '20000', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('cookie_name', 'ext20', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('cookie_path', '/', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('debug_mode', '0', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('events_per_page', '10', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('calendar_name', 'Mambo ExtCalendar', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('calendar_admin_email', '', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('calendar_description', 'Your online events calendar', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('lang', 'english', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('charset', 'language file', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('main_table_width', '100%', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('max_tabs', '12', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('theme', 'default', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('timezone', '-5', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('time_format_24hours', '0', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('auto_daylight_saving', '1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('default_view', '2', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('popup_event_mode', '0', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('popup_event_width', '550', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('popup_event_height', '300', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('add_event_view', '1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('cats_view', '1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('daily_view', '1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('weekly_view', '1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('monthly_view', '1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('flyer_view', '1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('search_view', '1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('day_start', '0', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('archive', '0', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('flyer_show_picture', '1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('addevent_allow_html', '1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('addevent_allow_contact', '1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('addevent_allow_email', '1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('addevent_allow_url', '1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('addevent_allow_picture', '1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('new_post_notification', '1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('cal_view_max_chars', '100', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('flyer_view_max_chars', '100', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('weekly_view_max_chars', '100', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('daily_view_max_chars', '100', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('cats_view_max_chars', '100', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('mini_cal_def_picture', 'def_pic.gif', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('mini_cal_diplay_options', '1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('release_name', 'Mambo Version of 2.0 Beta 1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('release_version', 'Mambo Version of 2.00.25', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('release_type', 'Unique MamboServer Version', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('sort_order', 'ta', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('picture_chmod', '0644', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('max_upl_dim', '450', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('allow_user_registration', '1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('reg_email_verify', '1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('reg_duplicate_emails', '0', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('calendar_status', '1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('show_recurrent_events', '1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('multi_day_events', 'all', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('cal_view_show_week', '1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('mail_method', 'mail', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('mail_smtp_host', 'smtp.myhost.com', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('mail_smtp_auth', '0', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('mail_smtp_username', '', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('mail_smtp_password', '', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('url_target_for_events', '_blank', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('capitalize_event_titles', '1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('show_top_navigation_bar', '1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('who_can_add_events', 'Anyone', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('who_can_edit_events', 'Registered', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('who_can_delete_events', 'Administrator', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('show_recurrence_info_event_view', '1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('show_recurrence_info_category_view', '1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('sort_category_view_by', 'date_asc', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('show_only_start_times', '0', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('show_event_times_in_monthly_view', '0', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('show_event_times_in_flat_view', '1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('show_event_times_in_weekly_view', '1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('show_event_times_in_daily_view', '1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('show_overlapping_recurrences_monthlyview', '1', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('show_overlapping_recurrences_flatview', '0', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('show_overlapping_recurrences_weeklyview', '0', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('show_overlapping_recurrences_dailyview', '0', 0, '0000-00-00 00:00:00'); INSERT INTO #__extcal_config VALUES ('allow_javascript_in_event_urls', '0', 0, '0000-00-00 00:00:00'); DELETE FROM `#__extcal_categories` DROP TABLE `#__extcal_categories` DELETE FROM `#__extcal_events` DROP TABLE `#__extcal_events` DELETE FROM `#__extcal_config` DROP TABLE `#__extcal_config` DELETE FROM `#__extcal_plugins` DROP TABLE `#__extcal_plugins` install.extcalendar.php uninstall.extcalendar.php ExtCal Calendar Manage Event Categories ExtCal Settings admin.config.inc.php admin.extcalendar.html.php admin.extcalendar.php admin_settings.php toolbar.extcalendar.html.php toolbar.extcalendar.php