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]

They'll still show up when browsing the list of quotes, just not in the random quote on your forum home page.

[Dolamite]

Originally Posted by Cap'n Steve

Run this query and tell me what it says:

SHOW CREATE TABLE $TPquotes

Replace the $TP with your table prefix.

quotes  	CREATE TABLE `quotes` ( `quoteid` int(10) unsigned NOT NULL auto_increment, `quote` mediumtext NOT NULL, `author` mediumtext NOT NULL, `userid` int(10) unsigned NOT NULL default '0', `approved` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`quoteid`), KEY `approved` (`approved`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1

[Cap'n Steve]

You somehow reverted to the old quotes table. Run these queries to fix it, replacing $TP with your table prefix:

ALTER TABLE $TPquotes ADD COLUMN votes int (5) unsigned not null default 0

ALTER TABLE $TPquotes ADD COLUMN rating int (10) not null default 0

ALTER TABLE $TPquotes ADD COLUMN average float (3, 2) not null default 0.00

ALTER TABLE $TPquotes ADD COLUMN context varchar (250)

[Dolamite]

sweet man... fixed it...appreciate your help

[HumourForum.com]

Great! However is there anyway I can make the random quote bit smaller? Thanks.

[Cap'n Steve]

You'd have to edit the quote_randomquote template and rearrange it to your liking.

[S@NL - BlackBik]

Thanks Cap'n Steve, installed and works fine

[S@NL - BlackBik]

I've made a little modification that shows the name and avatar of the user that posted a quote. This is only shown in the random quote at forumhome. Maybe someone else also likes this so I thought to share it with you people
Here goes:
Open the phrasemanager and add a new global phrase "added_by".
Open the plugin "Random Quote" and find:

        eval('$showrandomquote = "' . fetch_template('quote_randomquote') . '";');

(this is at the bottom of the code)
Above it, insert:

                require_once('./includes/functions_user.php');
                $userinfo[avatarurl] = fetch_avatar_url($randomquote[userid]);
                if (!$userinfo[avatarurl]) {
                     $userinfo[avatarurl] = "";
                } else {
                     $userinfo[avatarurl] = $vbulletin->options['bburl'] . '/' . $userinfo[avatarurl][0];
                }

Save the plugin and open the templates editor and the template: "quote_randomquote".
Find

<tr><td class="alt1" width="30%"></td>

and replace by:

<tr><td class="alt1" width="20%">$vbphrase[added_by]:<br>
                        <if condition="$userinfo[avatarurl]">
				<a href="member.php?u=$randomquote[userid]"><img src="$userinfo[avatarurl]" border="0" alt="$randomquote[username]" height="50" width="50"/>
			</if></a>
<a href="$vboptions[bburl]/member.php?userid=$randomquote[userid]">$randomquote[username]</a></td>

And you're done
Check http://forum.seti.nl/ for a demo.

Enjoy

Thanks go to amykhar, cause I used part of her code from her avatar on WOL hack

[HumourForum.com]

Awesome! Thanks for sharing!

[kizzmet]

I am running vb 3.5.4 and CMPS v2

Everything works fine in the forum, and it shows up in moderation sections, it also kept the old quotes from my previous version which is awesome. Over all I cannot thank you enough for posting this Captain.

The problem I am having is this:

When I create the module for the CMPS home page, I follow your directions but when I hit Save or whatever, I get this message:

You already have a Module with an identifier of ''. Please select a different identifier.

Any ideas? I checked the modules page and no I don't already have anything for quote it in there. And I reverted my old quote it templates before installing.

I appreciate any thoughts on it.