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

[Cap'n Steve]

Somehow you kept the settings through the upgrade. It might still work, but if not, edit the product-quoteit.xml file and delete everything between <installcode> and </installcode>. Then reimport the file, making sure "allow overwrite" is checked.

[Snort_2005]

[sql]Database error in vBulletin 3.5.1:

Invalid SQL:

INSERT INTO vb3_setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'showquote',
'forumhome',
'1',
'0',
'boolean',
'yesno',
90,
0,
1,
'quoteit'
),
(
'ratequote',
'forumhome',
'0',
'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 'ratequote' for key 1
Error Number : 1062
Date : Friday, November 4th 2005 @ 12:38:57 PM
Script : http://www.zcworld.net/forums/admincp/plugin.php
Referrer : http://www.zcworld.net/forums/adminc...?do=productadd
IP Address : 216.76.169.217
Username : Sephiroth
Classname : vb_database[/sql]

That's after I edited the xml. o_O;

edit: However, http://www.zcworld.net/forums/quotes.php just gives me a white screen.

[Cap'n Steve]

Delete everything between <options> and </options> and try again.

[Gaffer]

how the heck do i make it so the quotes show on all pages threw the template navbar.

thats where i ran the last version of the quoteit but this one even though thats where i put it only loads on home

[Cap'n Steve]

Follow the instructions in this post to add it to every page.

[funinthesun]

Interesting mod, might install later, thanks

[Snort_2005]

Thank you.

*clicks install*

[Greebo]

I'm having what seems to be a different problem. I've got the quotes showing up in my portal homepage, but whenever anyone, myself included, attempts to add a quote, edit a quote, or view all quotes (in short any access to quotes.php) all we get is a blank page with just html and body tags in it.

Any ideas?

[OneShot]

Installed it - great Mod. One Question tho, is it possible to make the number of Quotes to moderate appear in the AdminCP Control Panel Home below Threats, Events and so on to moderate?

Cheers
OS

[TygerTyger]

Originally Posted by OneShot

Installed it - great Mod. One Question tho, is it possible to make the number of Quotes to moderate appear in the AdminCP Control Panel Home below Threats, Events and so on to moderate?

Cheers
OS

Yeah, I was gonna suggest that. There's also a missing phrase: quote_x_has_been_approved.

Couple of other suggestions from me, the Quote Number (#X) goes up one for every submitted qotm, regardless of whether or not it actually gets approved. So you end up with quote numbers scattered all over the place and people asking where the missing numbers are.

And would it be possible for number of ratings (Total Ratings to count the number of times a quote has been rated, as opposed to adding up the scores it has been given? A quote gets rated twice and already has a Total Rating of 10, which is rather confusing to say the least.

It's a great mod anyway, love it