QuoteIt! 2.0 - Quote Management System

QuoteIt! version 2.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. This was developed on vBulletin 3.0.7, but should work on 3.0.0 and above.

You can see a demo on forums.monkeycrap.com.
Instructions for adding a random quote to vBadvanced and vBindex are in this post.


Features (features new to 2.0 are in yellow)

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
- the quote shown is much more random than in previous versions

Quote Database
- quotes can only be edited or deleted by an administrator
- quotes can be viewed individually or listed on several pages
- quotes can be sorted by total score, average score, author, submitter, or date added
- quotes now have a "context" field that can be turned on or off to include more information about the quote
- 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 administrator can now edit quotes
- the quote moderation que is now more like the que for posts, enabling the moderation of several quotes at once



Don't forget to click

This hack is based on QuoteIt! 1.2, originally by magnus. The "submit post" feature was inspired by an addon by CtrlAltDel. The location code is based on a post by Acido.

You may release translations of this hack as long as the original credits are included. Otherwise, you not redistribute this hack without permission from me.

[YLP1]

I am getting an error as well:

Database error in vBulletin 3.0.7:

Invalid SQL: 
INSERT INTO vb3_template
(styleid, title, template, template_un, dateline, username, version) VALUES
(-1, "quote_rating1", "
$vbphrase[rate_this_quote]: 
<form name=\\\"quote$quote[quoteid]\\\">
<input type=\\\"button\\\" name=\\\"plus\\\" id=\\\"plus\\\" value=\\\"+\\\" class=\\\"vote\\\" onclick=\\\"rateQuote(\'plus\', $quote[quoteid], \'quote$quote[quoteid]\');\\\" />
&nbsp;
<input type=\\\"button\\\" name=\\\"minus\\\" id=\\\"minus\\\" value=\\\"-\\\" class=\\\"vote\\\" onclick=\\\"rateQuote(\'minus\', $quote[quoteid], \'quote$quote[quoteid]\');\\\" />
</form>", "
$vbphrase[rate_this_quote]: 
<form name=\"quote$quote[quoteid]\">
<input type=\"button\" name=\"plus\" id=\"plus\" value=\"+\" class=\"vote\" onclick=\"rateQuote(\'plus\', $quote[quoteid], \'quote$quote[quoteid]\');\" />
&nbsp;
<input type=\"button\" name=\"minus\" id=\"minus\" value=\"-\" class=\"vote\" onclick=\"rateQuote(\'minus\', $quote[quoteid], \'quote$quote[quoteid]\');\" />
</form>", "Robin", "3.0.7")

mysql error: Duplicate entry 'quote_rating1--1' for key 2

mysql error number: 1062

[Cap'n Steve]

TheComputerGuy - It looks fine to me. What exactly is the problem? What browser are you using? Maybe you should attach a screenshot.

YLP1 - You also somehow already have the quote_rating1 template. Go to yourdomain.com/admincp/install_quoteit.php?do=x&step=2 (replace x with either install or upgrade). If that doesn't work, just delete all templates that start with quote_ and run the installer again.

I'll take a look at vbportal later today.

[YLP1]

I didnt' get to the second step....I quit in case it caused damage. But I found another little issue....when I go to edit a quote.....the script is timing out.....all other queries for other things are working and no other timeouts are occuring....I think maybe this edit has something to do with the install db error? Just guessing here.

[zetetic]

This is a great upgrade, Cap'n Steve. Thanks.

I got a parse error on the "Who's Online" page though, because when I copied and pasted the includes/functions_online.php code from your instructions it put "&-#-0-3-9-;"* in the code instead of apostrophes (marked red below). And I had to remove the apostrophes from around bburl.

'<a href="' . $vboptions['bburl'] . '/quotes.php?do=list">'

*Minus the hyphens, of course. I tried every bbcode here and couldn't write out that damn code without it getting converted.

[Cap'n Steve]

Thanks for catching that typo, anyone who's already installed should replace ' with ' in includes/functions_online.php.

YLP1, you should download the installer again to be sure. I've updated it so it deletes every QuoteIt template before upgrading, just in case. I don't know what would cause the edit error, though.

EDIT: You're right about not being able to post ', the only way I could do it was by using empty bbcode tags in the middle of it. I think you found a bug in vBulletin.

[YLP1]

Originally Posted by Cap'n Steve

Thanks for catching that typo, anyone who's already installed should replace ' with ' in includes/functions_online.php.

YLP1, you should download the installer again to be sure. I've updated it so it deletes every QuoteIt template before upgrading, just in case. I don't know what would cause the edit error, though.

EDIT: You're right about not being able to post ', the only way I could do it was by using empty bbcode tags in the middle of it. I think you found a bug in vBulletin.

I downloaded the file again and installed it in the correct directories.

Ran the installer as an upgrade and this is the error I recieved after the templates were modified:

Database error in vBulletin 3.0.7:

Invalid SQL: 
			ALTER TABLE vb3_quotes
			ADD COLUMN votes SMALLINT(10) UNSIGNED NOT NULL DEFAULT 0,
			ADD COLUMN rating MEDIUMINT(10) NOT NULL DEFAULT 0,
			ADD COLUMN average FLOAT(3, 2) NOT NULL DEFAULT 0.00,
			ADD COLUMN context VARCHAR(250),
			ADD INDEX (rating),
			ADD INDEX (average)
		
mysql error: Duplicate column name 'votes'

mysql error number: 1060

Date: Tuesday 12th of April 2005 05:28:51 PM
Script: http://www.yourlincolnpark.com/lpsforum/admin/install_quoteit.php
Referer: http://www.yourlincolnpark.com/lpsforum/admin/install_quoteit.php?do=upgrade&step=1

Should I try the new install vs upgrade??

Also, how would I delete a style template? I looked everywhere and can't find how to manually delete the quoteit templates that were installed or any other template deletion for that matter.

[Cap'n Steve]

You already ran the second step then. Go to your admincp phrase manager and search for a phrase named quoteit. If that exists, your installation is complete, if not, skip to the third step of the installer.

[ehjay]

The page that offers views of all the quotes is giving (null) errors whenever my users attempt to vote "+" or "-" on any particular quote.

you can see it in action here:
http://www.warboards.org/quotes.php?do=list

if you need to login, you can use the account test/asd

[Cap'n Steve]

Did you modify the templates? Here's what the quote_rating1 template should look like:

$vbphrase[rate_this_quote]: 
<form name="quote$quote[quoteid]">
<input type="button" name="plus" id="plus" value="+" class="vote" onclick="rateQuote(\'plus\', $quote[quoteid], \'quote$quote[quoteid]\');" />
&nbsp;
<input type="button" name="minus" id="minus" value="-" class="vote" onclick="rateQuote(\'minus\', $quote[quoteid], \'quote$quote[quoteid]\');" />
</form>

Notice that it actually uses a javascript function to fill in a hidden form, which is submitted all at once by the vote button at the bottom of the page.

EDIT: I just noticed rating your random quote doesn't work either. It might have something to do the javascript, although the rating does actually get recorded, for some reason it's not redirecting you back to the forum home page. The only thing I can think of is that there's something wrong with your $vboptions['forumhome'] variable, because that's what it redirects to.

[Cap'n Steve]

Originally Posted by Ski-Whiz

I run vbportal, is it hard for that CMS?

Is there some sort of free version I could look at? I don't see anything about it at their site, and I'm not going to pay for something just to release an addon for it.