Code:
Query Results:
SET @hoverboxold=0;
SELECT (@hoverboxold:=configuration_group_id) as hoverboxold FROM configuration_group WHERE configuration_group_title= 'HoverBox2';
DELETE FROM configuration WHERE configuration_group_id = @hoverboxold;
DELETE FROM configuration_group WHERE configuration_group_id = @hoverboxold;
SET @hoverbox=0;
SELECT (@hoverbox:=configuration_group_id) as hoverbox FROM configuration_group WHERE configuration_group_title= 'HoverBox 3';
DELETE FROM configuration WHERE configuration_group_id = @hoverbox;
DELETE FROM configuration_group WHERE configuration_group_id = @hoverbox;
INSERT INTO configuration_group VALUES (NULL, 'HoverBox 3', 'HoverBox 3 Configuration Options', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
SET @hoverbox=0;
SELECT (@hoverbox:=configuration_group_id) as hoverbox FROM configuration_group WHERE configuration_group_title= 'HoverBox 3';
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Enable HoverBox?', 'HOVERBOX_ENABLED', 'true', 'If set to true, all your product images will display using the HoverBox effect when viewing larger images.
If additional products exist, they will be presented in a slideshow fashion. Customers have the option to go through them manually or via the autoplay function.
Default: true
', @hoverbox, 10, NOW(), NOW(), NULL, 'zen_cfg_select_option( array(''true'', ''false''), '), (NULL, 'Include Product Title?', 'HOVERBOX_DISPLAY_TITLE', 'true', 'If set to true, the title of your product will be included below your product image.
Default: true
', @hoverbox, 20, NOW(), NOW(), NULL, 'zen_cfg_select_option( array(''true'', ''false''), '), (NULL, 'Include Product Price?', 'HOVERBOX_DISPLAY_PRICE', 'true', 'If set to true, the price of your product will be included below your product image.
Default: true
', @hoverbox, 30, NOW(), NOW(), NULL, 'zen_cfg_select_option( array(''true'', ''false''), '), (NULL, 'Include Product Description?', 'HOVERBOX_PRODUCT_DESC', 'false', 'If set to true, the products description will be included below your product image. You can limit the number of characters as well.
Default: false
', @hoverbox, 40, NOW(), NOW(), NULL, 'zen_cfg_select_option( array(''true'', ''false''), '), (NULL, 'Product Description Limitation', 'HOVERBOX_MAX_DESC_LENGTH', '200', 'Limit the number of characters for the product description displayed, if enabled.
Default: 200
', @hoverbox, 50, NOW(), NOW(), NULL, NULL), (NULL, 'Z-Index of HoverBox?', 'HOVERBOX_ZINDEX', '5000', 'This is the layer at which HoverBox resides on the page while viewing your product images. Change this to a higher value if your having problems with anything protruding into your effect.
Default: 5000
', @hoverbox, 60, NOW(), NOW(), NULL, NULL), (NULL, 'Use Smart Image Resizing?', 'HOVERBOX_SMART_RESIZE', 'true', 'If smart resizing is enabled, HoverBox will resize the image if it is to big to fit within the viewable browser area. Basically this keeps the entire image within view, even if it is too big for the screen.
Default: true
', @hoverbox, 70, NOW(), NOW(), NULL, 'zen_cfg_select_option( array(''true'', ''false''), '), (NULL, 'Background Color of HoverBox Contents?', 'HOVERBOX_BACKGROUND_COLOR', '#ffffff', 'This is the background color for the HoverBox itself. Where your product image resides when viewing a larger view.
Default: #ffffff
', @hoverbox, 80, NOW(), NOW(), NULL, NULL), (NULL, 'Enable Overlay?', 'HOVERBOX_OVERLAY_ENABLE', 'true', 'While viewing a product image, your store is overlayed with a background color (or image on the Mac, overlay.png). You can enable/disable this functionality if you so choose.
Default: true
', @hoverbox, 90, NOW(), NOW(), NULL, 'zen_cfg_select_option( array(''true'', ''false''), '), (NULL, 'Background Color of Page Overlay?', 'HOVERBOX_OVERLAY_BACKGROUND', '#000000', 'This is the background color for the overlay that covers your page while HoverBox is active, for compatibility purposes FireFox & Safari on the Mac use overlay.png located in your template images folder inside the hoverbox folder.
Default: #000000
', @hoverbox, 100, NOW(), NOW(), NULL, NULL), (NULL, 'Overlay Background Opacity?', 'HOVERBOX_OVERLAY_OPACITY', '0.85', 'The opacity of the overlay used while HoverBox is active. If the number is less than one, be sure to include the leading zeroes.
Default: 0.85
', @hoverbox, 110, NOW(), NOW(), NULL, NULL), (NULL, 'Padding for HoverBox Contents?', 'HOVERBOX_BORDER_SIZE', '10', 'The padding, or spacing of the inner-contents of HoverBox
Default: 10
', @hoverbox, 120, NOW(), NOW(), NULL, NULL), (NULL, 'Radius of Rounded Corners?', 'HOVERBOX_CORNER_RADIUS', '10', 'Without using images, HoverBox has the ability to have rounded corners. The higher the value, the more rounded the corners will render. Set to 0 for no rounded corners.
Default: 10
', @hoverbox, 130, NOW(), NOW(), NULL, NULL), (NULL, 'HoverBox Close Button Opacity - Normal?', 'HOVERBOX_CLOSE_NORMAL', '0.65', 'The initial opacity of the close button used by HoverBox.
Default: 0.65
', @hoverbox, 140, NOW(), NOW(), NULL, NULL), (NULL, 'HoverBox Close Button Opacity - Hover?', 'HOVERBOX_CLOSE_HOVER', '1', 'The opacity of the close button used by HoverBox during mouseover.
Default: 1
', @hoverbox, 150, NOW(), NOW(), NULL, NULL), (NULL, 'Additional Images - End-to-Beginning?', 'HOVERBOX_END_BEG', 'false', 'Allow customers to loop to the beginning of the images from the last image. This does not pertain to the autoplay function.
Default: false
', @hoverbox, 160, NOW(), NOW(), NULL, 'zen_cfg_select_option( array(''true'', ''false''), '), (NULL, 'Enable Slideshow Feature?', 'HOVERBOX_SHOW_SLIDE', 'true', 'If you have additional product images or other views of your product, this option enables/disables the slideshow functionality.
Default: true
', @hoverbox, 170, NOW(), NOW(), NULL, 'zen_cfg_select_option( array(''true'', ''false''), '), (NULL, 'Slideshow Interval (seconds)?', 'HOVERBOX_SLIDE_DELAY', '5', 'The time, in seconds, to display each image in the slideshow.
Default: 5
', @hoverbox, 180, NOW(), NOW(), NULL, NULL), (NULL, 'Additional Image Text - Image 1 of 10?', 'HOVERBOX_IMG_NUMBER', 'Image #{position} of #{total}', 'Sets the "Image 1 of 2" text when there is more than one image.
The text is replaced with a regular expression: #{position} is the number of the current image, #{total} is the total number of images.
Examples:
Image #{position} of #{total} - default English
Image #{position} (of #{total}) - English variation
Imagen #{position} de #{total} - Espanol
Immagine #{position} di #{total} - Italian
Bild #{position} von #{total} - German
Image #{position} de #{total} - French
イメージ #{position} の #{total} - Japanese
Default: Image #{position} of #{total}
', @hoverbox, 190, NOW(), NOW(), NULL, NULL);
Bookmarks