Zen Follower
- Join Date:
- May 2007
- Location:
- Italy
- Posts:
- 438
- Plugin Contributions:
- 0
how to delete a sql patch of a mod?
hello, many times I download mods that don't have sql uninstall, for example I have this sql install
SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Linkconnector Configuration';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;
INSERT INTO configuration_group VALUES ('', 'Linkconnector Configuration', 'Set Linkconnector Options', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Linkconnector Configuration';
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
('', 'Linkconnector Account', 'LINKCONNECTOR_ID', '00001', 'Enter your Linkconnector account number', @t4, 1, NOW(), NOW(), NULL, NULL),
('', 'Merchant ID', 'MERCHANT_ID', '1', 'Enter your Linkconnector Merchant ID account number', @t4, 1, NOW(), NOW(), NULL, NULL),
('', 'Campaign ID', 'CAMPAIGN_ID', '1', 'Enter your Linkconnector Campaign ID account number', @t4, 1, NOW(), NOW(), NULL, NULL);
how can I delete it?
And when I will have another mod with only sql install?
Can you give me a guide to how create a sql uninstall file?
Please
:frusty:
