[kadafi_alive]

Originally Posted by kadafi_alive

Does anyone know how to do undo the database? I'm gettin' a error when I try to moderate threads and posts.

I want to do delete the SQL queries I ran, what queries do I've to type in to delete?

Anyone figured it out?

The queries are:

INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('modpmfrom', 'posting', '1', '1', '', 140, 0, 0);
INSERT INTO phrase (phraseid, languageid, varname, `text`, phrasetypeid) VALUES (NULL, '0', 'setting_modpmfrom_title', 'User Who Sends Automatic PM on Moderation', '5000');
INSERT INTO phrase (phraseid, languageid, varname, `text`, phrasetypeid) VALUES (NULL, '0', 'setting_modpmfrom_desc', 'Enter the user ID of the person whose account you\'d like to be used when sending Auto Moderation PMs.', '5000');


INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('modpmtext', 'posting', 'Hi $username,\r\n\r\nThis message is to advise that your $type titled "$threadinfo" has been $action.\r\n\r\nThe $type is located at this URL $url\r\n\r\nIf you have any questions, you can ask an administrator for assistance\r\n\r\nSincerely,\r\nThe $bbtitle staff.', 'Hi $username,\r\n\r\nThis message is to advise that your $type titled "$threadinfo" has been $action by $modby.\r\n\r\nThe $type is located at this URL $url\r\n\r\nIf you have any questions, you can ask an administrator for assistance\r\n\r\nSincerely,\r\nThe $bbtitle staff.', 'textarea', 150, 0, 0);
INSERT INTO phrase (phraseid, languageid, varname, `text`, phrasetypeid) VALUES (NULL, '0', 'setting_modpmtext_title', 'Auto PM on Moderation Text', '5000');
INSERT INTO phrase (phraseid, languageid, varname, `text`, phrasetypeid) VALUES (NULL, '0', 'setting_modpmtext_desc', 'Set the text of the PM sent to users on Moderation.<br />\r<br />\rNote: You can use the following variables to specify the <b>user\'s</b> information: $bbtitle, $username, $type, $action, $userid, $threadinfo, $modby.', '5000');


INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('modpmtitle', 'posting', 'Your $type "$threadinfo" has been $action', 'Your $type "$threadinfo" has been $action', '', 160, 0, 0);
INSERT INTO phrase (phraseid, languageid, varname, `text`, phrasetypeid) VALUES (NULL, '0', 'setting_modpmtitle_title', 'Title Of the PM That is Sent on Thread Moderation', '5000');
INSERT INTO phrase (phraseid, languageid, varname, `text`, phrasetypeid) VALUES (NULL, '0', 'setting_modpmtitle_desc', 'Set the title of the PM that is sent to users when threads are moderated. You can use the same variables as above.', '5000');