Uninstall HoverBox2 Admin Switch

[guoxiang]

I've installed HoverBox2 and I need to uninstall it before I can install Lightbox 1.4 and Image Handler 2.0.

I have problem to uninstall HoverBox2 Admin Switch from my SQL.
The SQL installation statements for the HoverBox2 Admin goes like this:

INSERT INTO `configuration_group` VALUES (50, 'HoverBox<sup>2</sup>', 'Settings for your HoverBox<sup>2</sup>', 4.50, 1);
INSERT INTO `configuration` VALUES (721, 'Should I display the title of your product?', 'HOVERBOX_DISPLAY_TITLE', 'Yes', 'This let''s me know whether or not I should display the title of your product. Either select yes or no. I''ll handle the rest.', 50, 2, NULL, '0001-01-01 00:00:00', NULL, 'zen_cfg_select_option(array(''Yes'',''No''), ');
INSERT INTO `configuration` VALUES (720, 'Would you like to put me to work for you?', 'HOVERBOX_ENABLED', 'Yes', 'This let''s me know if I should be taking control over the display of your product images.', 50, 1, '2007-07-15 02:14:06', '0001-01-01 00:00:00', NULL, 'zen_cfg_select_option(array(''Yes'', ''No''), ');
INSERT INTO `configuration` VALUES (722, 'And lastly, should I display your product''s price to your customers?', 'HOVERBOX_DISPLAY_PRICE', 'Yes', 'This one just lets me know if I should be displaying the price of your products to your customers.', 50, 3, NULL, '0001-01-01 00:00:00', NULL, 'zen_cfg_select_option(array(''Yes'', ''No''),');

So the question is how do I reverse/uninstall the SQL code?

Regards
Cheng King Xiang

[francocauter]

Hi Cheng
This is an Install SQL and and the Uninstall for the same SQL.
See if you can make out something out of it.
DO NOT FORGET TO BACK UP YOUR DB BEFORE YOU TRY ANYTHING

SET @configuration_group_id=0;
SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'CAPTCHA' LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'CAPTCHA', 'CAPTCHA Configuration', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;

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, 'Code Length', 'CAPTCHA_CODE_LENGTH', '6', 'Verification Code length', @configuration_group_id, 1, NOW(), NULL, NULL),
(NULL, 'Image Width', 'CAPTCHA_IMG_WIDTH', '240', 'CAPTCHA Image Width', @configuration_group_id, 2, NOW(), NULL, NULL),
(NULL, 'Image Height', 'CAPTCHA_IMG_HEIGHT', '50', 'CAPTCHA Image Height', @configuration_group_id, 3, NOW(), NULL, NULL),
(NULL, 'Chars minimum size', 'CAPTCHA_CHARS_MIN_SIZE', '0.6', 'Chars minimum size (1.0=Image Height)', @configuration_group_id, 4, NOW(), NULL, NULL),
(NULL, 'Chars maximum size', 'CAPTCHA_CHARS_MAX_SIZE', '0.8', 'Chars maximum size (1.0=Image Height)', @configuration_group_id, 5, NOW(), NULL, NULL),
(NULL, 'Corner of rotation', 'CAPTCHA_CHARS_ROTATION', '23', 'Chars Corner of rotation', @configuration_group_id, 6, NOW(), NULL, NULL),
(NULL, 'Shadow Chars', 'CAPTCHA_CHARS_SHADOW', 'true', 'Generate Shadows for Characters', @configuration_group_id, 7, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),

(NULL, 'Image Type', 'CAPTCHA_IMG_TYPE', 'png', 'CAPTCHA Image Type', @configuration_group_id, 10, NOW(), NULL, 'zen_cfg_select_option(array(\'png\', \'jpeg\', \'gif\'),'),
(NULL, 'Create Account page', 'CAPTCHA_CREATE_ACCOUNT', 'true', 'Activate Validation on Create Account page', @configuration_group_id, 21, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Contact Us page', 'CAPTCHA_CONTACT_US', 'true', 'Activate Validation on Contact Us page', @configuration_group_id, 22, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Tell A Friend page', 'CAPTCHA_TELL_A_FRIEND', 'true', 'Activate Validation on Tell A Friend page', @configuration_group_id, 23, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Links Submit page', 'CAPTCHA_LINKS_SUBMIT', 'true', 'Activate Validation on Links Submit page', @configuration_group_id, 24, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Write Review page', 'CAPTCHA_REVIEWS_WRITE', 'true', 'Activate Validation on Write Review page', @configuration_group_id, 25, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');

SET @configuration_group_id=0;
SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'CAPTCHA' LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;

[guoxiang]

Hi Cheng
This is an Install SQL and and the Uninstall for the same SQL.
See if you can make out something out of it.
DO NOT FORGET TO BACK UP YOUR DB BEFORE YOU TRY ANYTHING

Hi Franco, I manage to uninstall HoverBox2 manually from my SQL.
Thanks.
By the way I'm currently using Zen Lightbox 1.4. It's another mod similar to HoverBox2. Zen Lightbox 1.4 is currently compatible with Image-Handler 2.0.

Regards
Cheng King Xiang