AJAX IMAGE Swapper support thread

[jaycode]

Thanks dbltoe,

Or if you install through admin install sql patches, for example if you have xyz_ as your prefix, use this:

			 				DROP TABLE products_attributes_images;

CREATE TABLE products_attributes_images (
	image_id INT NOT NULL AUTO_INCREMENT,
	products_attributes_id INT NOT NULL,
	image_path VARCHAR(255),
	image_title VARCHAR(255),
	image_sort_order INT,
	PRIMARY KEY(`image_id`)
);

INSERT INTO configuration_group
(configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible)
VALUES (NULL, 'AJAX Image Swapper', 'Config options for AJAX Image Swapper', '1', '1');

UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

SELECT @last_id :=last_insert_id() FROM xyz_configuration_group;

INSERT INTO configuration 
(configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added)
VALUES 
('', 'Small Image Height', 'IMAGE_VIEWER_SMALL_IMAGE_HEIGHT','75','The height of small images in AJAX Image Swapper, shown as thumbnails. Default 75.', @last_id, 1, now()),
('', 'Small Image Width', 'IMAGE_VIEWER_SMALL_IMAGE_WIDTH','75','The height of small images in AJAX Image Swapper, shown as thumbnails. Default 75.', @last_id, 5, now()),
('', 'Medium Image Height', 'IMAGE_VIEWER_MEDIUM_IMAGE_HEIGHT','300','The height of medium images in AJAX Image Swapper. Default 300.', @last_id, 10, now()),
('', 'Medium Image Width', 'IMAGE_VIEWER_MEDIUM_IMAGE_WIDTH','300','The width of medium images in AJAX Image Swapper. Default 300.', @last_id, 15, now()),
('', 'Number of Images Shown', 'IMAGE_VIEWER_IMAGES_NUM','3','Number of images shown in AJAX Image Swapper', @last_id, 20, now());

Note that I only added xyz_ to this line:

 SELECT @last_id :=last_insert_id() FROM xyz_configuration_group;

You can omit the first DROP query since it doesn't do nothing for fresh installation.

Good luck