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.

[Lea Verou]

Originally Posted by Cap'n Steve

Does the rest of the quote appear? You shouldn't have to make any changes to index.php, but even if you did, the quote wouldn't show up on your forum home page unless you edited the FORUMHOME template.

Yes yes it appears correctly. The username is the only thing that doesn't appear!

[Cap'n Steve]

Sorry, I completely forgot that the random quote uses a different query.

What you need to do is open quote.php (the vbAdvanced module) and find this:

		SELECT quotes.* FROM ' . TABLE_PREFIX . 'quotes AS quotes
				WHERE approved = 1 ' . $threshold . ' LIMIT ' . $row . ', 1

replace that with this:

		SELECT quotes.*, user.username FROM ' . TABLE_PREFIX . 'quotes AS quotes
		LEFT JOIN ' . TABLE_PREFIX . 'user AS user ON quotes.userid = user.userid
				WHERE approved = 1 ' . $threshold . ' LIMIT ' . $row . ', 1

[Lea Verou]

Thanks so much!!!

Another question now... I would like to add the vba left column in the quotes module, like I did with forumhome. I made the appropriate changes but some thing in the template seem screwed up (the vote button in particular).
See what I mean here:

without vba: www.e-steki.com/forum/quotes.php
with vba: www.e-steki.com/forum/quotes2.php

[Lea Verou]

Help! I tried to vote on some quotes and got the following SQL error!

Invalid SQL:
UPDATE vb3_quotes SET
votes = votes + 1,
rating = rating + 1,
average = rating / votes
WHERE quoteid IN ()

What can I do??? :'(

[Cap'n Steve]

I don't get that error on your site. Did you select a quote rating before you clicked the vote button?

[Lea Verou]

Probably it was temporary cause I don't get it now either but I can't vote! I just get a blank page! And yes I selected some quote ratings before I vote.

Oh, do you have any idea about the vba left column problem I mentioned above?

[Cap'n Steve]

Well, the votes are actually getting recorded, but I'm not sure what's causing it to not redirect after you vote. My only advice would be to download the files again and replace your quotes.php. If that doesn't work, try changing any templates you might have changed back to their original version. Sorry, but it must be something you changed. :ermm:

[Lea Verou]

Thanks I'll see what I can do...

What about the vba left column? What can I do with the Vote button that is ugly?

[Cap'n Steve]

If you move it after the last </table> tag, it should be centered.

[Snort_2005]

Is there a possability on getting this ported to vB 3.5 RC2? I used to have it on my vB 3.0.7 and my members loved it.. Now that I upgraded, It's not there anymore and my members are complaining. Is there a possibility on an upgrade?