[QUOTE=francocauter;461575]Hi There Clyde
its me again, I'd like to reinstall Links Manager fresh again and I want to clear the db of the Links manager SQL Patches. Is there an unintall SQL? Would you say that all the SQL entries have links in their description?
How ca I do it?
Can you help?
Thanks
Franco[/QUOTE
Yep,
Just copy and paste the following in admin -> tools -> install sql patches and click the send button
Code:
SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Links Manager'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration WHERE configuration_key = 'DEFINE_LINKS_STATUS';
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;
INSERT INTO `configuration` VALUES ('', 'Product option type Select', 'PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', 0, NULL, '2006-09-04 09:22:39', '2006-09-04 09:22:39', NULL, NULL);
INSERT INTO `configuration` VALUES ('', 'Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, '2006-09-04 09:22:39', '2006-09-04 09:22:39', NULL, NULL);
INSERT INTO `configuration` VALUES ('', 'Text prefix', 'TEXT_PREFIX', 'txt_', 'Prefix used to differentiate between text option values and other option values', 0, NULL, '2006-09-04 09:22:39', '2006-09-04 09:22:39', NULL, NULL);
INSERT INTO `configuration` VALUES ('', 'Image Handler Version', 'IH_VERSION', '2.0', 'This is used by image handler to check if the database is up to date with uploaded image handler files.', 0, 100, NULL, '2007-09-03 12:30:43', NULL, 'zen_cfg_textarea_small(');
NOTE: a fresh install will delete the links you already have entered in the database because the install sql will delete your current links manager tables and then install new empty tables.
Bookmarks