QuoteIt! - Quote Database

QuoteIt! version 3.0

QuoteIt! allows you to have a database of quotes integrated with your forum. Users submit quotes that can then be voted on by the other users, using your choice of two rating systems. The average installation will show a random quote on the forum home page, but you can include it on any vBulletin page or on your portal home page.

If you'd like to see a demo, go to forums.monkeycrap.com.

Features:

Random Quote
- a random quote can be shown on any vBulletin powered page
- the administrator can set a default rating threshold that quotes must meet before showing up as the random quote
- a new random quote can be chosen at a specific interval of time, to reduce server load

Quote Database
- quotes can be searched, filtered, and sorted by many different criteria
- quotes have a "context" field that can be turned on or off to include more information about the quote
- quotes can be embedded in posts with bbcode
- each post and private message now has a "Submit to Quotes" link that allows users to quote things said on your forum more easily

Quote Ratings System
- quotes can be rated either plus/minus or on a scale from 1 to 5
- quotes below a certain total score or average score can be filtered out

Quote Management
- quotes can either be automatically approved or moderated
- the quote moderation que is like the que for posts, enabling the moderation of several quotes at once
- usergroup permissions are used for adding, editing, deleting, rating and viewing quotes
- most actions use AJAX to avoid page reloads

Don't forget to click install!

Currently known problems are listed here.

The files needed to edit the included images are attached to this post.

This hack is based on QuoteIt! 1.2, originally by magnus. The "submit post" feature was inspired by an addon by CtrlAltDel.

Other versions (development will continue for the 3.6 version only): QuoteIt! 3 for vBulletin 3.6.x | QuoteIt! 2.03 for vBulletin 3.0.x

[docvader]

I've been using Quoteit in vb 3.07 for quite some time, without problems. I successfully upgraded to vb 3.52, and followed your instructions to install this new version. I had the same problem that Snort had, used the upgrade xml file recently suggested, and I still get database errors. Now my index page is gone

Database error in vBulletin 3.5.2:

Invalid SQL:

SELECT COUNT(*) AS count FROM quotes AS quotes
WHERE approved = 1;

MySQL Error : Table 'vbtest.quotes' doesn't exist
Error Number : 1146
Date : Sunday, December 18th 2005 @ 11:16:06 AM
Script : http://x.russbo.com/vbtest/index.php

any suggestions? This certainly did not "upgrade" smoothly at all.

[docvader]

I successfully uninstalled it and got my board back. But, it won't upgrade without database errors

Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'showquote',
'forumhome',
'1',
'0',
'boolean',
'yesno',
90,
0,
1,
'quoteit'
),
(
'ratequote',
'forumhome',
'2',
'0',
'number',
'<select name=\\\"setting[ratequote]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"0\\\" \" . iif($setting[\'value\']==0, \'selected=\"selected\"\') . \">\" . $vbphrase[\'disabled\'] . \"</option>\r\n<option value=\\\"1\\\" \" . iif($setting[\'value\']==1, \'selected=\"selected\"\') . \">\" . $vbphrase[\'plus_or_minus\'] . \"</option>\r\n<option value=\\\"2\\\" \" . iif($setting[\'value\']==2, \'selected=\"selected\"\') . \">\" . $vbphrase[\'1_to_5\'] . \"</option>\r\n</select>',
100,
0,
1,
'quoteit'
),
(
'averagethreshold',
'forumhome',
'',
'',
'number',
'',
110,
0,
1,
'quoteit'
),
(
'totalthreshold',
'forumhome',
'',
'',
'number',
'',
120,
0,
1,
'quoteit'
);

MySQL Error : Duplicate entry 'showquote' for key 1
Error Number : 1062
Date : Sunday, December 18th 2005 @ 11:29:41 AM
Script : http://x.russbo.com/vbtest/admincp/plugin.php
Referrer : http://x.russbo.com/vbtest/admincp/p...?do=productadd
IP Address : 67.77.47.30
Username : doc

Suggestions? Should I wipe out all of my Quoteit tables (I have backups), install this fresh, and then import the tables again??? I'm not sure how to do that, by the way

thanks
rich

[Warrior]

Originally Posted by Cap'n Steve

vonedaddy - try reimporting the product, be sure to check "allow overwrite". Let me know if that causes any errors.

sengerdw - the only thing changed was to allow 3.5 compatibility.

Nice work on those quotation mark images, by the way.

Nevermind my last post - I just checked my plugin manager and it shows I have 2.1... the folder says 2.0 so I got confused... :ermm:

[vonedaddy]

Originally Posted by vonedaddy

I assume to reimport you would need to uninstall... When I try to reinstall I get the following error:

Database error in vBulletin 3.5.2:

Invalid SQL:

DROP TABLE vbquotes;

MySQL Error : Unknown table 'vbquotes'
Error Number : 1051
Date : Saturday, December 17th 2005 @ 09:32:02 PM
Script : http://hereyah.com/forum/admincp/plugin.php
Referrer : http://hereyah.com/forum/admincp/plu...tid=quoteit&s=
IP Address : 68.46.5.248
Username : savone
Classname : vb_database


By the way I just re-imported and nothing still. Checked the database and no tables. But I do see the options in the control panel now, but if I enable it my forums dont work.

Capt, some help please

Anyone have any ideas for me?

[samu2]

OK Installed,it is up and running,I have it set ti show on forum home,however there are no options for it in Admin CP,I cant moderat quotes or anything as their are no options for it at all.

Ive uploaded the admin cp folder and re built my bitfields,nothing. thank you in advance

[Cap'n Steve]

samu2 - try editing a plugin in the Plugin Manager and then saving it without changing anything.

vonedaddy - do NOT uninstall. Just reimport the the product and check the "allow overwrite" box. If there are any errors during installation, post them.

docvader - run these queries to make sure the quote settings get reset:

DELETE FROM $TPsetting WHERE varname IN ("showquote", "ratequote", "averagethreshold", "totalthreshold")

DELETE FROM $TPdatastore WHERE title = "quote_settings"

Just replace the $TP with your table prefix first.

[samu2]

try editing a plugin in the Plugin Manager and then saving it without changing anything.

Did that,it saved fine,nothing happened

[Cap'n Steve]

That's really strange, are you sure cpnav_quoteit.xml is in your includes/xml folder? Try going to admincp/quoteadmin.php.

[docvader]

Cap'n
Running those queries "cleaned" out the database and allowed me to freshly install the system without problems, on my test board.

Now, before I do this on my real board, how would you suggest I protect the few hunded quotes we've accumulated? How do I get them out of the database and then, after instaling quoteit, get those quotes back into the database??

Thanks for you help man. As usual, you're incredible prompt and effective

rich
x.russbo.com

[Cap'n Steve]

Those queries will cause you to lose your old settings but not the quotes. It never hurts to make a backup, though.