Zen Lightbox addon [Support Thread]

[canihave]

As promised, I've looked into the installation issues with the SQL code where database tables contained prefixes.

This issue has now been resolved and the new installation SQL code can be found below.

Please note, this code is to be used with Zen Lightbox v1.5 only.

/**
 * Zen Lightbox
 *
 * @author Alex Clarke (aclarke AT ansellandclarke DOT co DOT uk)
 * @copyright Copyright 2003-2005 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: install.sql 2009-01-13 aclarke $
 */
INSERT INTO `configuration_group` VALUES (NULL, 'Zen Lightbox', 'Configure Zen Lightbox settings', '0', '1');
UPDATE `configuration_group` SET `sort_order` = LAST_INSERT_ID() WHERE `configuration_group_id` = LAST_INSERT_ID();
SELECT (@cgi := `configuration_group_id`) FROM `configuration_group` WHERE `configuration_group_title` = 'Zen 
Lightbox';
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, '<b>Zen Lightbox</b>', 'ZEN_LIGHTBOX_STATUS', 'true', '<br />If true, all product images on the following 
pages will be displayed within a lightbox:<br /><br />- document_general_info<br />- document_product_info<br />- 
page (EZ-Pages)<br />- product_free_shipping_info<br />- product_info<br />- product_music_info<br />- 
product_reviews<br />- product_reviews_info<br />- product_reviews_write<br /><br /><b>Default: true</b>', @cgi, 
100, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '),
(NULL, 'Overlay Opacity', 'ZEN_LIGHTBOX_OVERLAY_OPACITY', '0.8', '<br />Controls the transparency of the overlay.<br 
/><br /><b>Default: 0.8</b>', @cgi, 101, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''0'', ''0.1'', ''0.2'', 
''0.3'', ''0.4'', ''0.5'', ''0.6'', ''0.7'', ''0.8'', ''0.9'', ''1''), '),
(NULL, 'Overlay Fade Duration', 'ZEN_LIGHTBOX_OVERLAY_FADE_DURATION', '400', '<br />Controls the fade duration of 
the overlay.<br /><br />Note: This value is measured in milliseconds.<br /><br /><b>Default: 400</b><br />', @cgi, 
102, NOW(), NOW(), NULL, NULL),
(NULL, 'Resize Duration', 'ZEN_LIGHTBOX_RESIZE_DURATION', '400', '<br />Controls the speed of the image resizing.<br 
/><br />Note: This value is measured in milliseconds.<br /><br /><b>Default: 400</b><br />', @cgi, 103, NOW(), 
NOW(), NULL, NULL),
(NULL, 'Resize Transition', 'ZEN_LIGHTBOX_RESIZE_TRANSITION', 'false', '<br />Allows for custom control over the 
transition effect used to animate the lightbox.<br /><br /><b>Default: false</b><br />', @cgi, 104, NOW(), NOW(), 
NULL, NULL),
(NULL, 'Initial Width', 'ZEN_LIGHTBOX_INITIAL_WIDTH', '250', '<br />If Enable Resize Animations is set to true, the 
lightbox will resize its width from this value to the current image width, when first displayed.<br /><br />Note: 
This value is measured in pixels.<br /><br /><b>Default: 250</b><br />', @cgi, 105, NOW(), NOW(), NULL, NULL),
(NULL, 'Initial Height', 'ZEN_LIGHTBOX_INITIAL_HEIGHT', '250', '<br />If Enable Resize Animations is set to true, 
the lightbox will resize its height from this value to the current image height, when first displayed.<br /><br 
/>Note: This value is measured in pixels.<br /><br /><b>Default: 250</b><br />', @cgi, 106, NOW(), NOW(), NULL, 
NULL),
(NULL, 'Image Fade Duration', 'ZEN_LIGHTBOX_IMAGE_FADE_DURATION', '400', '<br />Controls the fade duration of 
images.<br /><br />Note: This value is measured in milliseconds.<br /><br /><b>Default: 400</b><br />', @cgi, 107, 
NOW(), NOW(), NULL, NULL),
(NULL, 'Caption Animation Duration', 'ZEN_LIGHTBOX_CAPTION_ANIMATION_DURATION', '400', '<br />Controls the animation 
duration of the caption.<br /><br />Note: This value is measured in milliseconds.<br /><br /><b>Default: 400</b><br 
/>', @cgi, 108, NOW(), NOW(), NULL, NULL),
(NULL, 'Display Image Counter', 'ZEN_LIGHTBOX_COUNTER', 'true', '<br />If true, the image counter will be displayed 
(below the caption of each image) within the lightbox.<br /><br /><b>Default: true</b>', @cgi, 109, NOW(), NOW(), 
NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
(NULL, 'Close on Image Click', 'ZEN_LIGHTBOX_CLOSE_IMAGE', 'false', '<br />If true, the lightbox will close when the 
image being displaying is clicked.<br /><br /><b>Default: false</b>', @cgi, 110, NOW(), NOW(), NULL, 
'zen_cfg_select_option(array(''true'', ''false''), '),
(NULL, 'Close on Overlay Click', 'ZEN_LIGHTBOX_CLOSE_OVERLAY', 'false', '<br />If true, the lightbox will close when 
the overlay is clicked.<br /><br /><b>Default: false</b>', @cgi, 111, NOW(), NOW(), NULL, 
'zen_cfg_select_option(array(''true'', ''false''), '),
(NULL, '<b>Keyboard Navigation</b>', 'ZEN_LIGHTBOX_KEYBOARD_NAVIGATION', 'true', '<br />If true, keyboard inputs 
will also be used to control the lightbox.<br /><br /><b>Default: true</b>', @cgi, 200, NOW(), NOW(), NULL, 
'zen_cfg_select_option(array(''true'', ''false''), '),
(NULL, 'Close Lightbox', 'ZEN_LIGHTBOX_ESCAPE_KEYS', '27,88,67', '<br />The lightbox will close when any of these 
keys are pressed.<br /><br />Note: Only <a href="http://en.wikipedia.org/wiki/ASCII" target="_blank">ASCII</a> 
decimal values should be entered and separated with a comma (if listing multiple values).<br /><br /><b>Default: 
27,88,67</b><br />', @cgi, 201, NOW(), NOW(), NULL, NULL),
(NULL, 'Previous Image', 'ZEN_LIGHTBOX_PREVIOUS_KEYS', '37,80', '<br />The lightbox will display the previous image 
(if available) when any of these keys are pressed.<br /><br />Note: Only <a 
href="http://en.wikipedia.org/wiki/ASCII" target="_blank">ASCII</a> decimal values should be entered and separated 
with a comma (if listing multiple values).<br /><br /><b>Default: 37,80</b><br />', @cgi, 202, NOW(), NOW(), NULL, 
NULL),
(NULL, 'Next Image', 'ZEN_LIGHTBOX_NEXT_KEYS', '39,78', '<br />The lightbox will display the next image (if 
available) when any of these keys are pressed.<br /><br />Note: Only <a href="http://en.wikipedia.org/wiki/ASCII" 
target="_blank">ASCII</a> decimal values should be entered and separated with a comma (if listing multiple 
values).<br /><br /><b>Default: 39,78</b><br />', @cgi, 203, NOW(), NOW(), NULL, NULL),
(NULL, '<b>Gallery Mode</b>', 'ZEN_LIGHTBOX_GALLERY_MODE', 'true', '<br />If true, the lightbox will allow 
additional images to quickly be displayed using previous and next buttons.<br /><br /><b>Default: true</b>', @cgi, 
300, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
(NULL, 'Include Main Image in Gallery', 'ZEN_LIGHTBOX_GALLERY_MAIN_IMAGE', 'true', '<br />If true, the main product 
image will be included in the lightbox gallery.<br /><br /><b>Default: true</b>', @cgi, 301, NOW(), NOW(), NULL, 
'zen_cfg_select_option(array(''true'', ''false''),'),
(NULL, '<b>EZ-Pages Support</b>', 'ZEN_LIGHTBOX_EZPAGES', 'true', '<br />If true, the lightbox effect will be used 
for linked images on all EZ-Pages.<br /><br /><b>Default: true</b>', @cgi, 400, NOW(), NOW(), NULL, 
'zen_cfg_select_option(array(''true'', ''false''),'),
(NULL, 'File Types', 'ZEN_LIGHTBOX_FILE_TYPES', 'jpg,png,gif', '<br />On EZ-Pages, the lightbox effect will be 
applied to all images with one of the following file types.<br /><br /><b>Default: jpg,png,gif</b><br />', @cgi, 
401, NOW(), NOW(), NULL, NULL);

I would be grateful if everyone could report errors (or success stories) here.

Many thanks,

Alex

Hi
I used this code
It got lightbox working for me but my site shifted to the left side and had an error at the top saying

Slimbox.scanPage = function() { $$(document.links).filter(function(el) { return el.rel && el.rel.test(/^lightbox/i); }).slimbox({]}, null, function(el) { return (this == el) || ((this.rel.length > 8) && (this.rel == el.rel)); }); }; window.addEvent("domready", Slimbox.scanPage); //-->

I have uninstalled the sql for now but would really like lightbox to work.

Thanks

[selcyis]

How do I uninstall it from my sql and take the tap off the categories?
I have like 6 of them on there. please help.
Thanks

[Jazzyp]

I've just installed zen lightbox v1.5. I had to add the prefix "zen_" into the sql install like others have before...

Now, I can't insert images into my ez-pages. Anyone else come across this or know how to fix it?

Thanks.

[rufusclc]

Did something incredibly stupid twice the other day - somehow added in lightbox twice in the config file the first entry gives alll teh details the second is blank with simply the headings
the second stupid thing I did was not doing a backup before starting. How /where can I delete 1 or both of the entries so I can re0install correctly
site is clonecopies.net
thx in advance

[countrycharm]

Did something incredibly stupid twice the other day - somehow added in lightbox twice in the config file the first entry gives alll teh details the second is blank with simply the headings
the second stupid thing I did was not doing a backup before starting. How /where can I delete 1 or both of the entries so I can re0install correctly
site is clonecopies.net
thx in advance

Log on to your sever database phpMyAdmin after that click on the link to the right configuration_group. Check the box configuration_group_title click browse and find Zen Lightbox and delete it. If you want to delete everything under your store admin go to your phpMyAdmin configuration then Check the box on configuration_title click browse and look for everything that deals with Zen Lightbox and delete it. Hope this helps. As always backup, backup, backup.

[rufusclc]

Hi countrycharm thanx -
yup the funny thing sis I tell every=one I speak to back up backup
so they should do as I, say not as I do?

[rufusclc]

Hi Countrycharm -
I am using BlueHost, log onto phpMyAdmin
you say click on the link to the right configuration_group.
I just dont see this.Am I missing a step?
Rufus

[rufusclc]

Hi Countrycharm
Further comment when I sign onto phpMyAdmin the screen with the tabs flashes on/off and goes to the next screen local host on left hand side; phpMyAdmin - 2.11.9.4 on right hand side
something missing?
help
Rufus

[countrycharm]

Hi Countrycharm -
I am using BlueHost, log onto phpMyAdmin
you say click on the link to the right configuration_group.
I just dont see this.Am I missing a step?
Rufus

When you log on you have to choose your database name on the left. Sorry I did tell you that. Next configuration_group will be on your left under your database name a long with all your tables.

[countrycharm]

Hi Countrycharm
Further comment when I sign onto phpMyAdmin the screen with the tabs flashes on/off and goes to the next screen local host on left hand side; phpMyAdmin - 2.11.9.4 on right hand side
something missing?
help
Rufus

I don't know whats going on with your database flashing on and off. Sorry