Major Additions - QuoteIt! - Quote Database

QuoteIt! version 3.1

I'm no longer able to put very much time into this mod, so I've set up a Subversion repository at http://www.vbulletinprogramming.com/projects/quoteit/ to allow others to help out. You can use the login "vbuser" with the password "vbulletin" to edit files. If someone would like to completely take over the mod, please contact me.

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.

Older versions (no longer in development): QuoteIt! 3 for vBulletin 3.5.x | QuoteIt! 2.03 for vBulletin 3.0.x

[zetetic]

Originally Posted by Cap'n Steve

zetetic - Yes, I figured there were enough options to give it its own section.

That makes sense. I just think the option to turn the hack on/off should be at the top to be consistent with vBulletin. Anyway it's a minor point. Thanks for all your work on this great add-on!

[Mum]

Don't have permissionsl, followed the instructions 'NOTE: If you get errors stating that you don't have permission to view the page on either the "Moderate Quotes" page or the main quotes page, you should rebuild the bitfields by going to www.yourdomain.com/admincp/index.php?do=buildbitfields' but didn't change anything, still can't moderate comments. Have uninstalled. Running 3.6.4

[BaconDelight]

Originally Posted by Cap'n Steve

BaconDelight - If it helps, clientscript/vbulletin_css/quoteit_main.css is used by all browsers, quoteit_ie_all.css is used by all versions of Internet Explorer, and quoteit_ie_lt_7.css is used by Internet Explorer 6 and below.

Yeah, I've got it very nearly presentable. Good enough that I've gone live.

Another little issue - if you put in a search term that it can't find, the redirect is wrong. Instead of pointing to http://www.[domain].com/[forum]/quotes.php, it redirects to http://www.[domain].com/quotes.php

[zetetic]

I discovered that today too, BaconDelight. I spent an hour or two trying to track down the root of that problem with no success - even changing every

$vbulletin->url = 'quotes.php?'

to

$vbulletin->url = $vbulletin->options['bburl'] . '/quotes.php?'

in both the quotes.php and functions_quoteit.php files. That didn't break anything (that I noticed), but it didn't fix the problem either.

[Cap'n Steve]

Hmm. It used to be like that, until I discovered it was redirecting to domain.com/domain.com/forums/quotes.php. Maybe they changed something again, I'll take a look.

[yonglvnv]

Originally Posted by Cap'n Steve

yonglvnv - For some reason, all the external files aren't getting included. Does $headinclude show up in your adv_portal template? Anyway, this should work for a temporary fix; in adv_portal find this:

</head>

Above that, add:

	<if condition="$quoteitoptions['ratings'] OR $quoteitpermissions['canmoderatequotes'] OR $quoteitoptions['enablecategories'] OR $quoteitpermissions['canreportquotes']">
		<script type="text/javascript" src="clientscript/quoteit_common.js"></script>
	</if>
	<if condition="$quoteitoptions['ratings'] AND $quoteitpermissions['canratequotes']">
		<script type="text/javascript" src="clientscript/quoteit_voting.js"></script>
	</if>
	<if condition="$quoteitpermissions['canmoderatequotes']">
		<script type="text/javascript" src="clientscript/quoteit_moderation.js"></script>
	</if>

	<!--[if lt IE 7]>
		<link rel="stylesheet" type="text/css" href="clientscript/vbulletin_css/quoteit_ie_lt7.css" />
		<style type="text/css">
		.openquote {
			filter: progid:DXImageTransform.Microsoft.AlphaImageLoader (src="{$stylevar['imgdir_misc']}/quotation-open.png", sizingMethod="image");
		}

		.closequote {
			filter: progid:DXImageTransform.Microsoft.AlphaImageLoader (src="{$stylevar['imgdir_misc']}/quotation-close.png", sizingMethod="image");
		}
		</style>
	<![endif]-->
	<!--[if IE]>
		<link rel="stylesheet" type="text/css" href="clientscript/vbulletin_css/quoteit_ie_all.css" />
	<![endif]-->

Thanks Cap'n Steve, above code addition made it a look lot better. I did need to put the full url path to java scripts to make it work, but collapse and close quote graphics are still way off. See attachment. When this is corrected, $showrandomquote will work perfectly in vba block. Also, I checked and $headinclude was in the vba_portal template. Thanks again!

[jluerken]

Hi,

I wanted to upgrade from 3.0 to 3.07 and I am getting this error message:

Database error in vBulletin 3.6.4:

Invalid SQL:

ALTER TABLE vb3_quotes
MODIFY COLUMN date INT (10) UNSIGNED NOT NULL DEFAULT;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2
Error Number : 1064

[zetetic]

The 'delete' function seems to behave strangely. When I click delete on a quote an empty confirmation box pops up, and when I click "ok" the quote disappears, but the quote-box header remains. I have to refresh to get a new random quote.

[zetetic]

Sorry to keep piling them on, but I found another one Cap'n.

While I was working on the templates instead of disabling the hack I just made it non-viewable to the registered users usergroup, and that worked fine. However, when I went to make it non-viewable to unregistered/not logged in usergroup, I got this error upon saving the settings:

Invalid SQL:
	INSERT INTO cron
(weekday, day, hour, minute, filename, loglevel, title) VALUES
(-1, -1, -1, "a:1:{i:0;i:0;}", "./includes/cron/guestquotes.php", 1, "QuoteIt! Guest Voting Cleanup");

MySQL Error  : Unknown column 'title' in 'field list'

I went back in and selected 'no' for all the other options and it saved fine.

[dcsbclan]

Originally Posted by Mum

Don't have permissionsl, followed the instructions 'NOTE: If you get errors stating that you don't have permission to view the page on either the "Moderate Quotes" page or the main quotes page, you should rebuild the bitfields by going to www.yourdomain.com/admincp/index.php?do=buildbitfields' but didn't change anything, still can't moderate comments. Have uninstalled. Running 3.6.4

Getting this same problem. =\