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.

[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!

[Megareus Rex]

Ok, a problem:

The phrase mod part gives this error;

			INSERT INTO vb3_phrase
			(languageid, varname, text, phrasetypeid) VALUES
			(0, "submitted_by", "Submitted by", 2),
			(0, "number_of_quotes_to_moderate", "Number of quotes to moderate at one time", 2),
			(0, "default_threshold", "Default Threshold", 2),
			(0, "enable_context", "Enable Context", 2),
			(0, "ratings", "Ratings", 2),
			(0, "approve", "Approve", 2),
			(0, "author", "Author", 1),
			(0, "submit_to_quotes", "Submit to Quotes", 1),
			(0, "moderate_quotes", "Moderate Quotes", 2),
			(0, "disabled", "Disabled", 2),
			(0, "plus_or_minus", "Plus or Minus", 2),
			(0, "quoteit_options", "QuoteIt! Options", 2),
			(0, "1_to_5", "1 to 5", 2),
			(0, "show_random_quote", "Show random quote", 2),
			(0, "average_threshold", "Average Threshold", 2),
			(0, "total_threshold", "Total Threshold", 2),
			(0, "quoteit", "QuoteIt!", 2),
			(0, "context", "Context", 1),
			(0, "edit_this_quote", "Edit this Quote", 1),
			(0, "adding_a_quote", "Adding a quote.", 1),
			(0, "editing_a_quote", "Editing or deleting a quote.", 1),
			(0, "sort_by", "Sort by", 1),
			(0, "quote_id", "Quote ID", 1),
			(0, "user_id", "User ID", 1),
			(0, "show", "Show", 1),
			(0, "greater_than_or_equal_to", "greater than or equal to", 1),
			(0, "total_rating", "Total rating", 1),
			(0, "average", "Average", 1),
			(0, "quotes", "Quotes", 1),
			(0, "show_only_quotes_with", "Show only quotes with", 1),
			(0, "vote", "Vote", 1),
			(0, "added_by", "Added by", 1),
			(0, "rate_this_quote", "Rate this quote", 1),
			(0, "posted_in_thread", "Posted in thread", 1),
			(0, "setting_ratequote_title", "Quote Ratings System", 5000),
			(0, "setting_ratequote_desc", "This allows you to choose what ratings scale the quotes will use or disable the ratings completely.", 5000),
			(0, "setting_averagethreshold_title", "Random Quote Average Threshold", 5000),
			(0, "setting_averagethreshold_desc", "The minimum average rating necessary for a quote to show up as the random quote (leave blank to allow all quotes).", 5000),
			(0, "setting_totalthreshold_title", "Random Quote Total Threshold", 5000),
			(0, "setting_totalthreshold_desc", "The minimum total rating necessary for a quote to show up as the random quote (leave blank to allow all quotes).", 5000)
		
mysql error: Duplicate entry 'submitted_by-0-2' for key 2

Any ideas? (I'm looking through the thread right now, but I wanted to get this posted just in case.)

Also.....

I was wondering if there's a way to get it to look more like v1.2. I don't like how the Add Quote/View all part is on the category strip, and how the quote is centered. If so, what do I do? (It looks really really ugly right now, IMO :ermm: )

[Megareus Rex]

Also, one more question. Is there any way to edit quotes after they've been accepted? (Other than going into the database and editing them directly).

[Torqued]

Originally Posted by Megareus Rex

Also, one more question. Is there any way to edit quotes after they've been accepted? (Other than going into the database and editing them directly).

Um. Go to view all quotes in the Random Quote box and then click on "edit" next to the quote you want to edit.

[Megareus Rex]

Originally Posted by Torqued

Um. Go to view all quotes in the Random Quote box and then click on "edit" next to the quote you want to edit.

Oh, ok. Sorry, like I also said, the phrase mechanism of the installer won't work, so I didn't see the edit box :ermm:

[Cap'n Steve]

You already had version 1.2 installed, right? It looks like you clicked on "install" when you ran the installer, you should click "upgrade" instead. As for the style, here's the quote_randomquote template from 1.2:

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="0" border="0" width="$stylevar[tablewidth]" align="center">
<thead>
	<tr>
		<td class="tcat" colspan="2">
			<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_randomquote')"><img id="collapseimg_forumhome_randomquote" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_forumhome_randomquote].gif" alt="" border="0" /></a>
			$vbphrase[random_quote]
		</td>
	</tr>
</thead>
<tbody id="collapseobj_forumhome_randomquote" style="$vbcollapse[collapseobj_forumhome_randomquote]">
	<tr>
		<td class="alt1" align="center" colspan="2">
		<i>"$randomquote[quote]"</i>
		</td>
	</tr>
	<tr>
		<td class="alt1 smallfont" align="left">
		<if condition="$bbuserinfo['userid']">(<a href=$vboptions[bburl]/quotes.php?do=addquote>$vbphrase[add_a_quote]</a><if condition="$bbuserinfo['permissions']['adminpermissions']"> | <a href="$vboptions[bburl]/quotes.php?do=delquote&quoteid=$randomquote[quoteid]">$vbphrase[delete_this_quote]</a></if> | <a href="$vboptions[bburl]/quotes.php?do=list">$vbphrase[view_all_quotes]</a>)</if>
		</td>
		<td class="alt1" align="right">
		- <b>$randomquote[author]</b>
		</td>
	</tr>
</tbody>
</table><br />

and here's the quote_listbit template from 1.2:

<table class="tborder" cellpadding="3" cellspacing="0" border="0" width="$stylevar[tablewidth]" align="center">
	<tr>
		<td class="alt1 smallfont" align="left">
		Added by: <a href="$vboptions[bburl]/member.php?userid=$randomquote[userid]">$randomquote[username]
		</td>
		<td class="alt1" align="right">
		<a href="$vboptions[bburl]/quotes.php?do=view&quoteid=$randomquote[quoteid]">#$randomquote[quoteid]</a>
		</td>
	</tr>
	<tr>
		<td class="alt1" align="center" colspan="2">
		<i>"$randomquote[quote]"</i>
		</td>
	</tr>
	<tr>
		<td class="alt1 smallfont" align="left">
		<if condition="$bbuserinfo['permissions']['adminpermissions']">(<a href="$vboptions[bburl]/quotes.php?do=delquote&quoteid=$randomquote[quoteid]">$vbphrase[delete_this_quote]</a>)</if>
		</td>
		<td class="alt1" align="right">
		- <b>$randomquote[author]</b>
		</td>
	</tr>
</table>

Keep in mind that you need to add $randomquote[average] or $randomquote[rating] to display the quotes rating and $ratethis to display the form for rating the quote. You should also add this:

<a href="$vboptions[bburl]/quotes.php?$session[sessionurl]&do=edit&quoteid=$randomquote[quoteid]">$vbphrase[edit_this_quote]</a>

to be able to edit the quotes. Also, the quotes in the old version are centered, while the new ones just have margins.

[Megareus Rex]

No, I clicked on Upgrade, not Install. It keeps giving me that error, and its driving me crazy, since half the hack is without phrases.

Here's the last part of the link to the error:

install_quoteit.php?do=upgrade&step=3

If that IS the right link for upgrading the phrases, it doesnt work.

EDIT: I just applied the template chages. THANK YOU I love the look of the v1.2 randomquote :P

[Cap'n Steve]

Hmm, it must have gotten run twice since you somehow have that phrase already. In install_quoteit.php, find:

			(0, "submitted_by", "Submitted by", 2),

and delete it (it should be there twice, delete both), then run the installer again, skipping to step 3.

[Megareus Rex]

Now I get this error:

Invalid SQL: 
			INSERT INTO vb3_phrase
			(languageid, varname, text, phrasetypeid) VALUES
			(0, "number_of_quotes_to_moderate", "Number of quotes to moderate at one time", 2),
			(0, "default_threshold", "Default Threshold", 2),
			(0, "enable_context", "Enable Context", 2),
			(0, "ratings", "Ratings", 2),
			(0, "approve", "Approve", 2),
			(0, "author", "Author", 1),
			(0, "submit_to_quotes", "Submit to Quotes", 1),
			(0, "moderate_quotes", "Moderate Quotes", 2),
			(0, "disabled", "Disabled", 2),
			(0, "plus_or_minus", "Plus or Minus", 2),
			(0, "quoteit_options", "QuoteIt! Options", 2),
			(0, "1_to_5", "1 to 5", 2),
			(0, "show_random_quote", "Show random quote", 2),
			(0, "average_threshold", "Average Threshold", 2),
			(0, "total_threshold", "Total Threshold", 2),
			(0, "quoteit", "QuoteIt!", 2),
			(0, "context", "Context", 1),
			(0, "edit_this_quote", "Edit this Quote", 1),
			(0, "adding_a_quote", "Adding a quote.", 1),
			(0, "editing_a_quote", "Editing or deleting a quote.", 1),
			(0, "sort_by", "Sort by", 1),
			(0, "quote_id", "Quote ID", 1),
			(0, "user_id", "User ID", 1),
			(0, "show", "Show", 1),
			(0, "greater_than_or_equal_to", "greater than or equal to", 1),
			(0, "total_rating", "Total rating", 1),
			(0, "average", "Average", 1),
			(0, "quotes", "Quotes", 1),
			(0, "show_only_quotes_with", "Show only quotes with", 1),
			(0, "vote", "Vote", 1),
			(0, "added_by", "Added by", 1),
			(0, "rate_this_quote", "Rate this quote", 1),
			(0, "posted_in_thread", "Posted in thread", 1),
			(0, "setting_ratequote_title", "Quote Ratings System", 5000),
			(0, "setting_ratequote_desc", "This allows you to choose what ratings scale the quotes will use or disable the ratings completely.", 5000),
			(0, "setting_averagethreshold_title", "Random Quote Average Threshold", 5000),
			(0, "setting_averagethreshold_desc", "The minimum average rating necessary for a quote to show up as the random quote (leave blank to allow all quotes).", 5000),
			(0, "setting_totalthreshold_title", "Random Quote Total Threshold", 5000),
			(0, "setting_totalthreshold_desc", "The minimum total rating necessary for a quote to show up as the random quote (leave blank to allow all quotes).", 5000)
		
mysql error: Duplicate entry 'number_of_quotes_to_moderate-0-2' for key 2

mysql error number: 1062

Date: Friday 13th of May 2005 01:46:58 AM
Script: http://www.evermoreforums.com/forums/admincp/install_quoteit.php?do=upgrade&step=3

However, I did notice that more phrases were added, so it achieved some success, at least.

[Cap'n Steve]

You already installed it, then. You should have all of those phrases. If they're not showing up, try going into your phrase manager, edit a phrase and then save it without changing anything.