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

[tarot]

Originally Posted by Cap'n Steve

tarot - I think it is the Forumdisplay template. As for the second step, go to your Plugin Manager, edit the plugin called "Random Quote", change the hook to "global_start" and add that piece of code at the end.

jaks - Parsing bbcode would require you to modify the code, and I can't really help you since I haven't gotten around to learning how to do it myself.

Thank you Cap'n Steve, that did it, one more silly question how would I do multiple forums. I repeated the if line and changed the variable it worked but I'm sure it is really dirty. I tried commas and spaces neither worked, I bet it is a semicolon am I right? Thanks again.

[Cap'n Steve]

Try something like this:

<if condition="in_array($_REQUEST['f'], array(forumid1, forumid2, forumid3))">$showrandomquote</if>

[NoPonies]

Originally Posted by Cap'n Steve

Try something like this:

<if condition="in_array($_REQUEST['f'], array(forumid1, forumid2, forumid3))">$showrandomquote</if>

Thank you very much I will put that in.

[Dolamite]

i installed it.... and it worked.... then for reasons i cannot explain.... it now says this

Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT COUNT(*) AS count FROM quotes AS quotes
WHERE approved = 1 AND quotes.average >= 0 AND quotes.rating >= 0;

MySQL Error : Unknown column 'quotes.average' in 'where clause'
Error Number : 1054

[Cap'n Steve]

Run this query and tell me what it says:

SHOW CREATE TABLE $TPquotes

Replace the $TP with your table prefix.

[Dolamite]

i don't use a table prefix so i ran it as $quotes.... got some error...

anyways i uninstalled, and reinstalled... and it works again.... but... now i'm wondering if that reinstall.... wiped all my old quotes? And if so... I have the old database.... so it must be possible to import them somehow....

[Cap'n Steve]

You should also have removed the dollar sign. Uninstalling will delete all your quotes, but if you have the backup you can restore your quotes table through phpMyAdmin or just run all the queries.

[majoreyeswater]

Originally Posted by Alien

In moderation, when I attempt to moderate one (happens in delete, or approve) I get this:

Could not find phrase 'quote_x_has_been_approved'.

Aside from the missing phrase, it approves or deletes properly.

I also get this, can anyone advise where I can amend it.

Also, and atthe risk of looking extremely dim, what are the following for:

Average Threshold and Total Threshhold. Also, what does 'enable context' do? Is that for BB code?

Any help appreciated.

[Cap'n Steve]

Don't worry about the phrase, it's harmless.

An explanation of those options is in this post.

[majoreyeswater]

Originally Posted by Cap'n Steve

Bubble #5 - Sorry, it explains it under the Forum Home Options, but not under the QuoteIt! Options, here's an explanation:

Total Threshold - Quotes won't show up as the Random Quote unless their total rating is at least this number.

Average Threshold - Quotes won't show up as the Random Quote unless their average rating is at least this number.

Context - This is just an extra text box where users can include extra information, like where the quote came from.

Thanks for that, and sorry if I am going over old ground, but my questions is:

If they aren't allowed to show up in random posts until a certain rating is received, how do they appear at all to get their rating? I suppose I had just better try the threshold options and see what happens.

Thanks for this feature, really adds to the site.