[Swedie]

Originally Posted by oldfan

I'm tying to reverse the install of these "INSERT INTO"
Could someone please show me how to do it with the I pasted below.
I'm getting mixed up with the commands

INSERT INTO `vB3phrase`WHERE (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_allowguestbook_desc', 'Allow guestbook in your users guestbooks?', 5000);

thanks

oldfan! STOP!! right now! dude. what you doing. If you don't know how to do it, then please don't make your own attempts of "reversing" it with your guessing.

Run this .SQL and all YOU installed (using vB3 prefix on everything by mistake) will be erased. Then after that, you run the proper .SQL file coming with the .ZIP file in my first post.

PHP Code:

DROP TABLE `user_guestbook`; 
DROP TABLE `user_webpage`; 

ALTER TABLE vb3usergroup DROP canuseguestbook;
ALTER TABLE vb3usergroup DROP canusewebpage;

DELETE FROM vb3phrase WHERE varname = 'setting_allowguestbook_desc' OR varname = 'setting_allowguestbook_title' OR varname = 'setting_allowwebpage_title' OR varname = 'setting_allowwebpage_desc' AND varname = 'settinggroup_guestbookwebpage' OR varname = 'setting_webpagevbcode_desc' OR varname = 'setting_guestbooksmilies_desc' OR varname = 'setting_webpagevbcode_title' OR varname = 'setting_webpagesmilies_title' OR varname = 'setting_guestbooksmilies_title' OR varname = 'setting_webpagesmilies_desc' OR varname = 'setting_webpagehtml_title' OR varname = 'setting_webpagehtml_desc' OR varname = 'can_use_guestbook' OR varname = 'can_use_webpage' OR varname = 'setting_allowedhtmltags_title' OR varname = 'setting_allowedhtmltags_desc' OR varname = 'edit_webpage_content' OR varname = 'edit_guestbook_settings';

DELETE FROM vb3settinggroup WHERE grouptitle = 'guestbookwebpage';

DELETE FROM vb3setting WHERE grouptitle = 'guestbookwebpage';