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]

AAN - This post has instructions for adding it to other pages.

ambrosious - Not right now, but I'm working on one.

MortysTW -
In modules/quote.php find this

PHP Code:

    eval('$home[$mods[\'modid\']][\'content\'] .= "' . fetch_template('quote_randomquote') . '";'); 


and replace that with this

PHP Code:

    eval('print_output("' . fetch_template('quote_randomquote') . '");'); 


Then turn Clean File Output on again. If that doesn't work, then I really don't have any idea why. You might want to ask the vBadvanced guys.

[TPOCJames]

Getting this error:

Database error in vBulletin 3.5.4:

Invalid SQL:

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

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND quotes.average >= 0 AND quotes.rating >= 0  approved = 1' at line 2
Error Number : 1064
Date         : Tuesday, August 29th 2006 @ 12:20:41 AM
Script       : http://www.into-thin-air.com/quotes.php
Referrer     : 
IP Address   : removed
Username     : removed
Classname    : vb_database

A moron admin deleted my entire forum and this was after a backup soo... yeah.

[Cap'n Steve]

Do you have the Random Quote set to use the golbal_start hook? If that's the case, you need to edit that plugin and add this at the end:

PHP Code:

unset($threshold); 


[TPOCJames]

Thanks, I'll try that and tell you how it goes.

Working fine. Thanks.

[Antwerp]

Originally Posted by ambrosious

Is there a graphic for the "Submit to Quotes" line that comes up in each thread? If so, where and how do I use it?!

GREAT HACK!

I made this button, but I'm using the old school buttons, I don't like the new ones.


To get it to work, I used this in the postbit

<!-- BEGIN QuoteIt! -->
<a href="$vboptions[bburl]/quotes.php?$session[sessionurl]do=submitpost&amp;postid=$post[postid]">
<img src="$stylevar[imgdir_button]/submitquote.gif" alt="$vbphrase[submit_to_quotes]" border="0" /></a> 
<!-- END QuoteIt! -->

Also, I changed the Phrase "Submit_to_Quote" in the phrase manager to say:
"Submit Quote to Hall of Fame"

Works Great! Love the Hack!
Thanks

[opteek]

Does this work with 3.6 and if not, what changes would need to be made? This is an awesome mod!

[Cap'n Steve]

It may or may not work on 3.6. If you're worried about it, you can just wait until the official 3.6 version is released, which shouldn't be too long.

[Lionel]

This does not work for me on 3.60. This is really too bad.

[Bubble #5]

Originally Posted by Cap'n Steve

you can just wait until the official 3.6 version is released, which shouldn't be too long.

Any update on this please?

[Alien]

While I can't verify if it works installing it fresh, I do know that it works fine on 3.6.1 here already installed..

Can't wait for an update on this, Capt! Been a year since last, man time flies..