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]

Whoops, that's right. I should have known that an update query wouldn't cause an error if the row didn't exist. I still have no idea why that setting disappeared in the first place, but as long as it works now I guess it doesn't matter.

[mtha]

not running really smooth. you should add a Uninstall link in install_quoteit.php too.

it takes 3 queries when running , that's too much

[Cap'n Steve]

Do you mean the random quote? You can skip one query by disabling the ratings system and one of the others is just a count query, so it should still be quite fast.

[anarchystar]

Hey Cap'n'Steve ... I hate to bug you again, but I was wondering if you could give me a hand with a template question.
If you look at the block on my portal at www.anarchystar.com you can see how it is kinda divided into 3 table rows. How can I make the random quotes span across all 3 rows so it does'nt get sqeezed in the middle row?
I have been playing around with the html all night and can't seem to get it quite right.

[Cap'n Steve]

In your quote_randomquote template, it looks like you have this right now:

<tr><td class="alt2"></td>
		<td class="alt2" width="70%"><div margin-right:20%;>
		<i><p>$randomquote[quote]</p></i>

		<p style="font-weight:bold;margin-left:50%;">- $randomquote[author]</p>
		</div>
		</td><td class="alt2" valign="top">
<!-- no quoteid
		
	<a style="float:right;" href="http://forums.anarchystar.com/quotes.php?do=view&quoteid=35">#35</a>

end no quoteid-->
		
</td>



	</tr>

Replace that with this:

<tr>
		<td class="alt2" colspan="3" width="70%"><div margin-right:20%;>
		<i><p>$randomquote[quote]</p></i>

		<p style="font-weight:bold;margin-left:50%;">- $randomquote[author]</p>
		</div>
		</td>
	</tr>

I haven't tested it, but it should work.

[anarchystar]

Sweet, that did the trick, thanks once again for the excellent support.

[zetetic]

I just added this conditional (colored text below) to the quote_listquote template so the "show only quotes with ____ rating" stuff doesn't show up at the top of the page if you have ratings disabled.

<if condition="$settings[1] != 0">
<div align="center" style="color:$stylevar[smallfont_fgcolor];">
	$vbphrase[show_only_quotes_with]
	<form name="threshold" action="quotes.php">
	<select class="form" name="type" id="type" onchange="document.threshold.elements[1].name=this.value;">
	<option value="total">$vbphrase[total_rating]</option>
	<option value="average">$vbphrase[average]</option>
	</select>
	$vbphrase[greater_than_or_equal_to]
	<input type="text" class="form" name="total" size="5" />
	<input type="submit" class="form" value="$vbphrase[show]" />
	</form>
</div><br />
</if>

[Cap'n Steve]

Wow, I can't believe I didn't put that in there. Thanks for pointing it out, it'll be included in the next version.

[zetetic]

Originally Posted by Cap'n Steve

Wow, I can't believe I didn't put that in there. Thanks for pointing it out, it'll be included in the next version.

Glad to help. You've done a great job updating this.

[angelicGrace]

Great hack. I just love it. I love the amount of countrol my admin staff have over it. I have a few members on my site that are less than scrupless, so this lets me make sure they aren't adding dubious quotes to the system.