Changes to the install SQL.. (the image resizing didn't reflect the correct changes as per my conversation with Rus this weekend..)
#
# INSTALL Events Calendar v4.0 for zencart v1_5_0
# $Id: install_events_calendar.sql 2013-03-19 dw08gm
# $Id: install_events_calendar.sql 2013-03-19 C Jones
# Remove pre-existing Events Calendar admin page entries
DELETE FROM admin_pages WHERE page_key='eventsCalendar';
DELETE FROM admin_pages WHERE page_key='configEventsCalendar';
# This will delete any existing events in their entirety! DO NOT uncomment and run this part of the SQL if you do not want to delete your existing calendar table.
#DROP TABLE IF EXISTS events_calendar;
# Create events calendar TABLE
CREATE TABLE events_calendar (event_id int(3) NOT NULL auto_increment, language_id int(11) NOT NULL default '1', start_date date NOT NULL default '0000-00-00', end_date varchar(20) default NULL, title varchar(255) default NULL, event_image varchar(64) default NULL, ZC_link varchar(255) default NULL, ADDL_link varchar(255) default NULL, description text, date_added datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (event_id,language_id));
SELECT @t4:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Events Calendar';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;
INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'Events Calendar', 'Set Event Calendar Options', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
SELECT @t4:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Events Calendar';
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES
(NULL, 'Re-size event images?', 'EVENTS_FILE_RESIZE', '1', 'If this option is set to true, the module will display the re-size event images options on the create/edit preview page. (based on maximum width and height settings below).<br /><br />Set to false to disable image resizing.<br /><br />Set as follows:<br />0=False<br />1=True<br /><br />Default is true.', @t4, 1, NOW(), NULL, 'zen_cfg_select_option(array(\'1\', \'0\'),'),
(NULL, 'Set the maximum file width', 'EVENTS_FILE_MAX_WIDTH', '800', 'Set the max image width in px. The module will check on uploads, & change on review<br /><br />Default is 800.', @t4, 2, NOW(), NULL, NULL),
(NULL, 'Set the maximum file height', 'EVENTS_FILE_MAX_HEIGHT', '600', 'Set the max image height in px. The module will check on uploads, & change on review<br /><br />Default is 600.', @t4, 3, NOW(), NULL, NULL),
(NULL, 'Events Manager description', 'DESCRIPTION_SIZE_LIMIT', '25', 'Limits the number of characters displayed in the Events Manager. (Most stores will NOT need to modify this setting)<br /><br />Default is 25.', @t4, 4, NOW(), NULL, NULL),
(NULL, 'Show Links in Information sidebox?', 'EVENTS_LINK_STATUS_INFO', 'false', 'Display the Event Calendar upcoming events links on the "Information" sidebox?<br /><br />Set to false to disable image resizing.<br /><br />Default is false.', @t4, 5, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Show Links in More Information sidebox?', 'EVENTS_LINK_STATUS_MORE_INFO', 'false', 'Display the Event Calendar upcoming events links on the "More Information" sidebox?<br /><br />Set to false to disable image resizing.<br /><br />Default is false.', @t4, 6, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Include the IMG tag height and width', 'EVENTS_DISPLAY_IMAGE_WIDTH_HEIGHT', 'true', 'If this option is set to true, the module will include the image\'s native height and width in the IMG tag. This is required to support other user agents \(e.g. a speech browser\) which should have this information in order to relate it to the user.<br /><br />If you do not wish to include the image\'s native height and width in the IMG tag, set this to false. \(Setting this to false may be required for image scaling support in Internet Explorer 7 and Internet Explorer 8\)<br /><br />Default is true.', @t4, 10, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Set first day of the week', 'FIRST_DAY_OF_WEEK', '0', 'First day of the week in the calendar display, eg 0=Sunday, 1=Monday, etc.<br /><br />Default is 0.', @t4, 30, NOW(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\'),'),
(NULL, 'Set number of years to display in the sidebox', 'NUMBER_OF_YEARS', '5', 'No of years to be shown in sidebox year drop-down.<br /><br />Default is 5.', @t4, 20, NOW(), NULL, NULL),
(NULL, 'Single event display', 'EVENTS_SINGLE_JUMP', 'true', 'If this option is set to true, then if the visitor clicks on a link to a date which only contains a single event, then Zen Cart will take them directly to that event-page, rather than present them with the event list with a link to click in order to see the event.<br /><br />Default is true.', @t4, 25, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Use short or long months in calendar titles', 'EVENTS_LONG_MONTHS_TITLES', 1, 'Set as follows:<br />0=Use short months display \(Jan, Feb, etc.\)<br />1=Use long months display \(January, February, etc.\).<br /><br />Default is 1.', @t4, 40, NOW(), NULL, 'zen_cfg_select_option(array(\'1\', \'0\'),'),
(NULL, 'Use short or long months in calendar dropdowns', 'EVENTS_LONG_MONTHS_DROPDOWNS', 1, 'Set as follows:<br />0=Use short months display \(Jan, Feb, etc.\)<br />1=Use long months display \(January, February, etc.\).<br /><br />Default is 1.', @t4, 45, NOW(), NULL, 'zen_cfg_select_option(array(\'1\', \'0\'),'),
(NULL, 'Other file types allowed', 'EVENTS_OTHER_EXTS', '.doc .docx .xls .xlsx .pdf .rtf .txt', 'What other filetypes are supported. Be sure to include a dot \(\'.\'\) and the filetype extension. Each filetype should be followed by a space. \(except the last one in the list\) You will need to add the supported file types to the <strong>images/.htaccess</strong> file.', @t4, 50, NOW(), NULL, NULL),
(NULL, 'Maximum number of recurring events', 'EVENTS_MAX_RECURS', '52', 'Set the maximum possible # of recurring events to add to the events database at one time.<br /><br />Default is 52.', @t4, 55, NOW(), NULL, NULL);
# Register admin menu Extras page
INSERT INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order)
VALUES ('eventsCalendar','BOX_EXTRAS_EVENTS_MANAGER','FILENAME_EVENTS_MANAGER','','extras','Y',10);
# Register the configuration page for Admin Configuration Settings
INSERT IGNORE INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES ('configEventsCalendar','BOX_CONFIGURATION_EVENTS_CALENDAR','FILENAME_CONFIGURATION',CONCAT('gID=',@t4),'configuration','Y',@t4);
