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.

[Torqued]

Originally Posted by Cap'n Steve

I actually thought about adding categories to this version but decided against it. Here's a list of what I hope to include in the next version (which will probably not be out for a while, though):

- quote categories
- dated quotes
- view only new quotes
- view only quotes you haven't rated

Any suggestions for other features would be appreciated!

I'd like the ability to pull categories via a url. I'd like to display relevant quotes in different sections such as specific forums, photo galleries, etc.

Something like: http://www.mysite.com/forum/quote.php?cat=motorcycles for my motorcycle quotes, etc.

[Megareus Rex]

Its still an incomplete installation. Some of the phrases that, by deduction, SHOULD be there aren't. Like Edit this Quote. It worked with Accept and Accept All, but thats it.

[deb0]

I upgraded board to 307. Could not get qoute 1.2 to show up on forum home, does in acp. Tried to upgrade. Still can't get it to show up in in Forum home. All templates and file edits are correct.

Is there a way to start over without losing quote tables in database? What are my options at this point?

thx in advance.

[Cap'n Steve]

deb0 - you need to run this query:

[sql] INSERT INTO $TPsetting
(varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES
("showquote", "forumhome", 1, 1, "yesno", 5, 0, 0)[/sql]

Don't forget to replace $TP with your table prefix. The option should show up after that.

Megareus - the error it gives you is the

mysql error: Duplicate entry '$phrasename-0-$number'

part. Your only real choice is to find the two lines in install_quoteit.php that are in the form of

			(0, "$phrasename", "$phrastext", $number),

and delete them. You'll just have to keep doing this and rerunning step 3 of the installer to make sure all the phrases are there. Sorry, but I don't know how it's possible to get a partial installation in the first place. :ermm:

[deb0]

Thanks, Im making progress.

Now when I give a rating and hit the vote button at the bottom, I get a blank page.

[Megareus Rex]

Originally Posted by Cap'n Steve

deb0 - you need to run this query:

[sql] INSERT INTO $TPsetting
(varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES
("showquote", "forumhome", 1, 1, "yesno", 5, 0, 0)[/sql]

Don't forget to replace $TP with your table prefix. The option should show up after that.

Megareus - the error it gives you is the

mysql error: Duplicate entry '$phrasename-0-$number'

part. Your only real choice is to find the two lines in install_quoteit.php that are in the form of

			(0, "$phrasename", "$phrastext", $number),

and delete them. You'll just have to keep doing this and rerunning step 3 of the installer to make sure all the phrases are there. Sorry, but I don't know how it's possible to get a partial installation in the first place. :ermm:

But why does it do that in the first place? Its like the script is trying to insert the same exact phrase TWICE. The phrases that it says are duplicates are NOT already in the database, so thast the only logical reason...:ermm:

[Megareus Rex]

I think I figured out why, I already had SOME of the phrases in the database, so it duplicated them ,and gave the error. Perhaps I had one of the phrases in there already? (from a previous hack, or of my own creation perhaps). I'm checking each one right now, and apparently I had the first few in there. I'll post again when I've discovered more.

[Cap'n Steve]

deb0 - What rating system are you using? Is it the random quote or the quotes list? Could you give me the link?

Megareus - Are you sure the phrase isn't already there? If you have access to phpMyAdmin, can you find it in there? Did you try editing and saving an existing phrase like I suggested earlier?

EDIT: You posted while I was typing. I don't think it's another hack, unless something you have uses a "number_of_quotes_to_moderate" phrase, which would be weird.

[deb0]

The rating in radom works fine. The rating is not working on the quotelist.

Suggestion: I noticed that non-members can use the quote system. Is there a way to restrict it to members only?

[Megareus Rex]

Originally Posted by Cap'n Steve

deb0 - What rating system are you using? Is it the random quote or the quotes list? Could you give me the link?

Megareus - Are you sure the phrase isn't already there? If you have access to phpMyAdmin, can you find it in there? Did you try editing and saving an existing phrase like I suggested earlier?

EDIT: You posted while I was typing. I don't think it's another hack, unless something you have uses a "number_of_quotes_to_moderate" phrase, which would be weird.

I dunno what happened, but they're all installed now. Except for one.

In QuoteIt options, the second line is missing the phrase. (Between Ratings and Show Random Quote). Do you happen to know what it is?