Run these queries:
[sql]DELETE FROM phrasetype WHERE phrasetypeid='716';
DELETE FROM phrase WHERE varname LIKE '%shoutbox%';
DELETE FROM setting WHERE varname LIKE 'shoutbox%';
DELETE FROM settinggroup WHERE grouptitle='shoutbox';
ALTER TABLE language DROP phrasegroup_shoutbox;
ALTER TABLE usergroup DROP shoutboxpermissions, DROP shouthierarchy, DROP shoutmaxdaily;
ALTER TABLE user DROP shouts, DROP shoutbanned;
DROP TABLE shoutbox_posts;[/sql]
EDIT: Well, even if you use uninstall.sql, you'll need to run this since I haven't updated unsinstall.sql since Beta 5.
[sql]ALTER TABLE usergroup DROP shoutmaxdaily;[/sql]
Well, I ran the uninstaller query and this is what I got...
PHP Code:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax near ';
DELETE FROM setting WHERE varname LIKE 'shoutbox%';
DELETE FROM settinggroup' at line 1
Run these queries:
[sql]DELETE FROM phrasetype WHERE phrasetypeid='716';
DELETE FROM phrase WHERE varname LIKE '%shoutbox%';
DELETE FROM setting WHERE varname LIKE 'shoutbox%';
DELETE FROM settinggroup WHERE grouptitle='shoutbox';
ALTER TABLE language DROP phrasegroup_shoutbox;
ALTER TABLE usergroup DROP shoutboxpermissions, DROP shouthierarchy, DROP shoutmaxdaily;
ALTER TABLE user DROP shouts, DROP shoutbanned;
DROP TABLE shoutbox_posts;
I ran the query above and I got this...
Quote:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax near ';
DELETE FROM phrase WHERE varname LIKE '%shoutbox%';
DELETE FROM setting WHER' at line 1
Well, I ran the uninstaller query and this is what I got...
PHP Code:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax near ';
DELETE FROM setting WHERE varname LIKE 'shoutbox%';
DELETE FROM settinggroup' at line 1
You can't run multiple queries in the vB Admin CP. Use phpMyAdmin or split it up. (each line is a different query, for a total of 8)
If you had the Shoutbox hack by TWTCommish for vBulletin 2.x.x installed, or seen it somewhere, you might notice that this version has a different layout for showing the shouts than the vB2 version.
Well, the new layout is definately nice, however, I still feel more attracted to the vB2 style of displaying the shout, mainly because I am used to it.
So here it is, you just have to replace your "shoutbox_shoutbits" template and you are done!. It will make your shoutbox look more like the old vBulletin 2 version of the shoutbox.
Instructions: Replace your shoutbox_shoutbits template with the attatched text file.