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

[glowinggal]

only thing stoppping me from installing this in particular is not being able to put quotes into categories

[BaconDelight]

Here's what I mean when I say the formatting on IE is ugly. I've uploaded 2 screen shots, one from Firefox one from IE. Notice how the IE one is about 50% taller, the quote extends all the way to the right margin, and the author is shifted well to the right. It just looks sloppier than the Firefox equivalent.

I figure I can create separate classes and modify the template to detect the browser and use the appropriate class, but I'm a little fuzzy on the workings of css for manipulating formatting, so any help in that area would be greatly appreciated.

[dcsbclan]

Originally Posted by glowinggal

only thing stoppping me from installing this in particular is not being able to put quotes into categories

You can.

When i try to go to quotes.php?do=list I just get redirected to quotes.php?do=addquote. Also when I do add a quote I just get redirected to the forum homepage.

[BaconDelight]

Originally Posted by BaconDelight

but I'm a little fuzzy on the workings of css for manipulating formatting, so any help in that area would be greatly appreciated.

Nevermind, I think I've got it.

[soulface]

the language problem still exists. also getting this db error when changing the option 'Random Quote Frequency' from Every time to hourly, daily, weekly, monthly

Database error in vBulletin 3.6.4:

Invalid SQL:

			INSERT INTO cron
			(weekday, day, hour, minute, filename, loglevel, title) VALUES
			(-1, -1, -1, "a:1:{i:0;i:0;}", "./includes/cron/randomquote.php", 0, "QuoteIt! Quote Randomizer");

MySQL Error  : Unknown column 'title' in 'field list'
Error Number : 1054
Date         : Saturday, January 13th 2007 @ 02:05:21 AM
Script       : http://***********/forum/admincp/quoteadmin.php?do=saveoptions
Referrer     : http://***********/forum/admincp/quoteadmin.php?do=options
IP Address   : *********
Username     : Eros
Classname    : vb_database

[Firen]

I'm back to square one. I still can't get the edit button to work. I've installed the updated Quote It! and the Edit button won't do anything. Everything else works fine though.

[Cap'n Steve]

yonglvnv - That's strange, could you post a link to the page?

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

dcsbclan - You have some quotes already added and approved? They show up as a random quote?

Calash - How many languages do you normally have? Did you upload the newest files?

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. It was a nightmare trying to get it to look decent on all browsers, depending on what kind of people use your forum, you might only have to worry about Internet Explorer.

Firen - Do you still get that error you posted when you add that line to quoteit_moderation.js? Make sure you've uploaded all the latest files.

soulface - I'll have a new version up later tonight.

[yonglvnv]

Thanks, sent you a pm.

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

[soulface]

ok the db error is fixed now. working fine. but what abt the language problem ? its still exists. when i rebuild the language. then language bar disappeared. but then QuoteIt options get disabled. when i enable them. the language bar again shows up....