Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.5 > vBulletin 3.5 Add-ons
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
QuoteIt! - Quote Database Details »»
QuoteIt! - Quote Database
Version: 3.05, by Cap'n Steve Cap'n Steve is offline
Developer Last Online: May 2010 Show Printable Version Email this Page

Version: 3.5.0 Rating:
Released: 10-04-2005 Last Update: 01-11-2007 Installs: 113
DB Changes Uses Plugins Template Edits
Additional Files  
No support by the author.

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

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #122  
Old 11-19-2005, 01:29 AM
Cap'n Steve's Avatar
Cap'n Steve Cap'n Steve is offline
 
Join Date: Feb 2004
Location: Kalamazoo, MI, USA
Posts: 745
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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 />
Reply With Quote
  #123  
Old 11-19-2005, 01:43 PM
Mr.Monkey Mr.Monkey is offline
 
Join Date: Dec 2004
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
  #124  
Old 11-19-2005, 02:44 PM
funinthesun funinthesun is offline
 
Join Date: Oct 2005
Posts: 460
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #125  
Old 11-19-2005, 03:03 PM
OneShot OneShot is offline
 
Join Date: Apr 2002
Location: Germany
Posts: 66
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Did you check in your AdminCP under Moderation -> Moderate Quotes? Because depending on your settings you have to approve them first.
Reply With Quote
  #126  
Old 11-19-2005, 03:21 PM
funinthesun funinthesun is offline
 
Join Date: Oct 2005
Posts: 460
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi OneShot

No, I hadn't checked but I just looked now and there is no option in the moderation section to moderate posts?
Reply With Quote
  #127  
Old 11-19-2005, 05:37 PM
Mr.Monkey Mr.Monkey is offline
 
Join Date: Dec 2004
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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!
Reply With Quote
  #128  
Old 11-19-2005, 06:32 PM
funinthesun funinthesun is offline
 
Join Date: Oct 2005
Posts: 460
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
  #129  
Old 11-19-2005, 07:03 PM
TygerTyger TygerTyger is offline
 
Join Date: Aug 2005
Posts: 182
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #130  
Old 11-19-2005, 07:41 PM
Cap'n Steve's Avatar
Cap'n Steve Cap'n Steve is offline
 
Join Date: Feb 2004
Location: Kalamazoo, MI, USA
Posts: 745
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #131  
Old 11-20-2005, 12:08 AM
funinthesun funinthesun is offline
 
Join Date: Oct 2005
Posts: 460
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 07:47 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05431 seconds
  • Memory Usage 2,346KB
  • 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