Does anyone know how I can undo these queries?
(I'm trying to uninstall the canned text hack so that I can reinstall from scratch if the problem lies somewhere here.)
Code:
Creating Settings...
Getting current highest + 1 displayorder for settings...
query_first: SELECT MAX(settinggroupid) + 1 AS newdisplayorder FROM setting
Creating settings group...
query: INSERT INTO settinggroup (title, displayorder) VALUES ("Canned Text", 44)
Getting newly created settinggroupid...
Writing script to create individual settings...
Caching highest settingid + 1...
query_first: SELECT MAX(settingid) + 1 AS sidplusone FROM setting
Creating setting "Maximum allowed canned text items"...
query: INSERT INTO setting (settinggroupid, title, varname, value, description, optioncode, displayorder)
VALUES (45,
"Maximum allowed canned text items",
"ctmax",
"5",
"The maximum allowed number of unique canned text responses users can save. Set to 0 to disable the use of canned text.",
"",
0)