The Arcive of Official vBulletin Modifications Site.

QuoteIt! - Quote Database · **Released**: 10-04-2005

QuoteIt! version 3.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 or on your portal home page.

If you'd like to see a demo, go to forums.monkeycrap.com.

Features:

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
- a new random quote can be chosen at a specific interval of time, to reduce server load

Quote Database
- quotes can be searched, filtered, and sorted by many different criteria
- quotes have a "context" field that can be turned on or off to include more information about the quote
- quotes can be embedded in posts with bbcode
- 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 quote moderation que is like the que for posts, enabling the moderation of several quotes at once
- usergroup permissions are used for adding, editing, deleting, rating and viewing quotes
- most actions use AJAX to avoid page reloads

Don't forget to click install!

Currently known problems are listed here.

The files needed to edit the included images are attached to this post.

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

Other versions (development will continue for the 3.6 version only): QuoteIt! 3 for vBulletin 3.6.x | QuoteIt! 2.03 for vBulletin 3.0.x

Cap'n Steve · #**122** 11-19-2005, 01:29 AM

Here's the entire template. You're apparently missing the opening <style> tag on the first line which would cause problems. Taking out the closing </table> tag would also cause problems, but it still has nothing to do with the navbar. Did the two navbars appear before or after you changed the template? I can't duplicate either of your problems so it must have something to do with your style or the other modules.

HTML Code:

<style type="text/css">
.vote {
	color:$stylevar[smallfont_fgcolor];
	font-family:'trebuchet ms',helvetica,sans-serif;
	font-size:110%;
	font-weight:bold;
	background-color:$stylevar[button_bgcolor];
<if condition="$vboptions[ratequote]==1">
	width:25px;
	height:25px;
</if>
	border-top-color:$stylevar[alt2_bgcolor];
	border-left-color:$stylevar[alt2_bgcolor];
	border-right-color:$stylevar[alt1_bgcolor];
	border-bottom-color:$stylevar[alt1_bgcolor];
	filter:progid:DXImageTransform.Microsoft.Gradient
	(GradientType=0,StartColorStr='#aa$gradient1',EndColorStr='#aa$gradient2');}
}
</style>
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="0" border="0" width="$stylevar[tablewidth]" align="center">
<thead>
	<tr>
		<td class="tcat">
			$vbphrase[random_quote]
		</td><td class="tcat" align="right">
			<div align="right">

			(<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> | <a href="$vboptions[bburl]/quotes.php?do=editquote&quoteid=$randomquote[quoteid]">$vbphrase[edit_this_quote]</a>
			</if>

			 | <a href="$vboptions[bburl]/quotes.php?do=list">$vbphrase[view_all_quotes]</a>)
		</div>
	 	 	 </td><td class="tcat" style="width:15px;">
	 	 	<div style="float:right;" align="right">
			<a 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></div>

		</td>
	</tr>
</thead>
<tbody id="collapseobj_forumhome_randomquote" style="$vbcollapse[collapseobj_forumhome_randomquote]">
	<tr><td class="alt1" width="30%"></td>
		<td class="alt1"><div style="font-style:italic;margin-right:10%;">
		<p>&quot;$randomquote[quote]&quot;</p>
		<p style="font-weight:bold;margin-left:25%;">- $randomquote[author]<if condition="$randomquote[context]"> ($randomquote[context])</if></p>
		</div>
		</td><td class="alt1" valign="top">
			<a style="float:$stylevar[right];" href="$vboptions[bburl]/quotes.php?do=view&quoteid=$randomquote[quoteid]">#$randomquote[quoteid]</a>
		</td>

	</tr>
<if condition="$vboptions[ratequote]==3">
	<tr><td class="alt1" align="left" colspan="3">
	$vbphrase[total_rating]: $randomquote[rating] - $vbphrase[average]: $randomquote[average]
	</td>
</if>

<if condition="$vboptions[ratequote]==1">
	<tr><td class="alt1" align="left">
	$vbphrase[total_rating]: $randomquote[rating] - $vbphrase[average]: $randomquote[average]
	</td>
	<td class="alt1" align="right" colspan="2">$vbphrase[rate_this_quote]: 
	<form name="rateplus" action="$vboptions[bburl]/quotes.php">
	<input type="hidden" name="do" id="do" value="rate" />
	<input type="hidden" name="quoteid" id="quoteid" value="$randomquote[quoteid]" />
	<input type="hidden" name="vote" id="vote" value="plus" />
	<input type="submit" value="+" class="vote" />
	</form>
	&nbsp;
	<form name="rateminus" action="$vboptions[bburl]/quotes.php">
	<input type="hidden" name="do" id="do" value="rate" />
	<input type="hidden" name="quoteid" id="quoteid" value="$randomquote[quoteid]" />
	<input type="hidden" name="vote" id="vote" value="minus" />
	<input type="submit" value="-" class="vote" /></form>
	</td>
</if>
<if condition="$vboptions[ratequote]==2">
	<tr><td class="alt1" align="left">
	$vbphrase[total_rating]: $randomquote[rating] - $vbphrase[average]: $randomquote[average]
	</td>
	<td class="alt1" align="right" colspan="2">$vbphrase[rate_this_quote]:
	<form name="voting" id="voting" action="$vboptions[bburl]/quotes.php">
	<input type="hidden" name="do" id="do" value="rate" />
	<input type="hidden" name="quoteid" id="quoteid" value="$randomquote[quoteid]" />
	<select name="vote" id="vote" onchange="document.voting.submit();">
	<option value=""></option>
	<option value="1">&nbsp;&nbsp;1&nbsp;&nbsp;</option>
	<option value="2">&nbsp;&nbsp;2&nbsp;&nbsp;</option>
	<option value="3">&nbsp;&nbsp;3&nbsp;&nbsp;</option>
	<option value="4">&nbsp;&nbsp;4&nbsp;&nbsp;</option>
	<option value="5">&nbsp;&nbsp;5&nbsp;&nbsp;</option>
	</select>
	</form>
	</td>
</if>

</tr>
</tbody>
</table><br />

Mr.Monkey · #**123** 11-19-2005, 01:43 PM

Hey Cap'n, good job on quoteit, but I've managed to break something. I had an old version of quoteit installed, but I reverted all the templates necessary afterwards.
When I try to submit a quote, I get the following error:

Code:

 
Database error in vBulletin 3.5.1:

Invalid SQL:

		INSERT INTO 1vb3_quotes
		(quote, author, userid, approved, context) VALUES
		("Test", "Test", 1, 0, "");

MySQL Error  : Unknown column 'context' in 'field list'
Error Number : 1054
Date         : Saturday, November 19th 2005 @ 04:38:35 PM
Script       : http://www.tribeclown.com/vforum/quotes.php
Referrer     : http://www.tribeclown.com/vforum/quotes.php?&do=addquote
IP Address   : 146.115.44.37
Username     : Test
Classname    : vb_database

Any suggestions?

funinthesun · #**124** 11-19-2005, 02:44 PM

I've just installed this and it seemed easy enough to do, however nothing is showing up when I add a quote? When I click to view all quotes it just takes me to the submit quote form. I didn't add the submit posts code, should I of added that as well? The options for showing quotes is in my forum home page options in my admincp which turns it on and off fine but no quotes, what have I done wrong? Also, where can I view all quotes that have been entered in my admincp? Thanks

OneShot · #**125** 11-19-2005, 03:03 PM

Did you check in your AdminCP under Moderation -> Moderate Quotes? Because depending on your settings you have to approve them first.

funinthesun · #**126** 11-19-2005, 03:21 PM

Hi OneShot

No, I hadn't checked but I just looked now and there is no option in the moderation section to moderate posts?

Mr.Monkey · #**127** 11-19-2005, 05:37 PM

Quote:

Originally Posted by Mr.Monkey

Hey Cap'n, good job on quoteit, but I've managed to break something. I had an old version of quoteit installed, but I reverted all the templates necessary afterwards.
When I try to submit a quote, I get the following error:

Code:

 
Database error in vBulletin 3.5.1:

Invalid SQL:

		INSERT INTO 1vb3_quotes
		(quote, author, userid, approved, context) VALUES
		("Test", "Test", 1, 0, "");

MySQL Error  : Unknown column 'context' in 'field list'
Error Number : 1054
Date         : Saturday, November 19th 2005 @ 04:38:35 PM
Script       : http://www.tribeclown.com/vforum/quotes.php
Referrer     : http://www.tribeclown.com/vforum/quotes.php?&do=addquote
IP Address   : 
Username     : Test
Classname    : vb_database

Any suggestions?

Just in case anyone gets the same message, deleting it from the Plugins section, then reinstalling the .xml seems to have cleared the problem!

funinthesun · #**128** 11-19-2005, 06:32 PM

I'm stumped on this one, I don't know why the quotes aren't showing up. Could it be something to do with my version of mySQL?

TygerTyger · #**129** 11-19-2005, 07:03 PM

Quote:

Originally Posted by funinthesun

I'm stumped on this one, I don't know why the quotes aren't showing up. Could it be something to do with my version of mySQL?

Hard for anyone to say if you don't tell us what version it is

Cap'n Steve · #**130** 11-19-2005, 07:41 PM

Quote:

Originally Posted by Mr.Monkey

Just in case anyone gets the same message, deleting it from the Plugins section, then reinstalling the .xml seems to have cleared the problem!

Be careful with that, as uninstalling the product will delete all your quotes. I think your original problem was that you had version 1.x installed and never upgraded to 2.0. As long as it works now it's ok, but I'll remember to take that into consideration for the install code.

funinthesun - If there's no "Moderate Quotes" link under Moderation, did you upload includes/xml/cpnav_quoteit.xml? To see quotes in the moderation que without the link, point your browser to admincp/quoteadmin.php?do=moderate

funinthesun · #**131** 11-20-2005, 12:08 AM

Hi Cap'n Steve

Yes, I uploaded the cpnav_quoteit.xml file to includes/xml. I thought it was a simple install to be honest. I've pointed my browser to http://www.mysite.com/quotes.php?do=moderate and it's just a blank white page?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05353 seconds Memory Usage 2,341KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_code (1)bbcode_html (3)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!