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

[vonedaddy]

Originally Posted by Cap'n Steve

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

Did what you asked. Everything seemed fine, no errors during re-import. But it still gives me the same error when calling the quotes.php file.

Database error in vBulletin 3.5.2:

Invalid SQL:

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

MySQL Error : Table 'vonaone.vbquotes' doesn't exist
Error Number : 1146
Date : Sunday, December 18th 2005 @ 06:34:20 PM
Script : http://hereyah.com/forum/quotes.php
Referrer :
IP Address : 68.46.5.248
Username : savone
Classname : vb_database

[Cap'n Steve]

That's really weird. Somehow it thinks you already have the quotes table when apparently you don't. Run these two queries to add the tables:

CREATE TABLE $TPquotes (
	quoteid INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	quote MEDIUMTEXT NOT NULL,
	author VARCHAR(75) NOT NULL,
	userid INT(10) UNSIGNED NOT NULL DEFAULT 0,
	approved TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
	votes SMALLINT(10) UNSIGNED NOT NULL DEFAULT 0,
	rating MEDIUMINT(10) NOT NULL DEFAULT 0,
	average FLOAT(3, 2) NOT NULL DEFAULT 0.00,
	context VARCHAR(250),
	PRIMARY KEY (quoteid),
	INDEX (rating),
	INDEX (average),
	KEY approved (approved))

CREATE TABLE $TPquoteratings (
	quoteid INT(10) UNSIGNED NOT NULL,
	userid INT(10) UNSIGNED NOT NULL,
	rating TINYINT(1) NOT NULL,
	PRIMARY KEY (quoteid, userid))

As always, replace $TP with your table prefix.

[vonedaddy]

Got it, it didnt work at first but I noticed it created two tables.. One called $TBquotes and another called $TBquoteratings. So I ran the queries again and changed the names accordingly. It works now, thanks a million.

Also this is an awesome hack. Right now I am having some display problems but if I cant figure them out you will hear from me again. Thanks for this hack, and the support, two thumbs up.

[vonedaddy]

Originally Posted by Cap'n Steve

As always, replace $TP with your table prefix.

DUH, Sorry. I just noticed that as I hit submit. I'm a moron, again thanks.

[dieselpowered]

Well I am not sure what happened, however, it refuses to save quotes now??? It was working, however, now when I attempt to add a quote it does not save it??

Any help would be appreciated!

[Cap'n Steve]

Does it give you an error? You may have to moderate the quotes before they show up if that option is on.

[dieselpowered]

Darnit, that is right, I turned on moderation. Sorry, I will have another drink...

[dieselpowered]

I would like to add the code to moderate the quotes within the moderation module in CMPS. I know the url to the moderation page, however, was curious if there was a way to place the number of quotes awaiting moderation next to the link.

Any thoughts? Thanks

Also, I had to delete a bunch of posts, now I have quotes 1-4 and then the next is quote #8. Is there any way to get the those numbers in sequence?

[Cap'n Steve]

Originally Posted by xtremeoff-road

I would like to add the code to moderate the quotes within the moderation module in CMPS. I know the url to the moderation page, however, was curious if there was a way to place the number of quotes awaiting moderation next to the link.

Check out this post.

Originally Posted by xtremeoff-road

Also, I had to delete a bunch of posts, now I have quotes 1-4 and then the next is quote #8. Is there any way to get the those numbers in sequence?

Not right now. It's already been requested for the next version, though.

[dieselpowered]

Originally Posted by Cap'n Steve

Check out this post.

No my friend, I am looking for the code to add to my CMPS moderation module so that I do not have to go into the admincp every time to check if new quotes have ben submitted.

Originally Posted by Cap'n Steve

Not right now. It's already been requested for the next version, though.

I went into the db and manually changed it, thanks