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

[Cap'n Steve]

The database error should be fixed, as well as the Quick Language Chooser (I mean it this time). The Quote Filtering Options currently gets squeezed to the side in Firefox with some styles. If anyone good with CSS knows how to fix it, I'd appreciate the help because I can't seem to get it right without messing up the search box.

efil - What do you mean some options won't save? To arrange everything right to left, try editing the css files and switching left and right in those.

MaestroX - Do you have any quotes in the database? Make sure you download the latest version. If it still doesn't work then your server might have a problem with redirects.

Amiga Harrison - Thanks for catching that, it should be there now. It appears at the bottom of this list, though, and make sure you give yourself permission to approve quotes.

TwinsForMe - It uses the table width for whatever style you're using. You could adjust that or edit one of the css files.

everyone with problems editing quotes - Make absolutely sure you have the latest .js files on your server. If it still doesn't work, please post the exact error. In Firefox, it'll be under Tools -> Javascript Console; in Internet Explorer, there's probably an icon that you have to double-click on the bottom-left of the window.

Originally Posted by jluerken

I have the same error like efil is posting above

Which error is that?

[jluerken]

Originally Posted by Cap'n Steve

Which error is that?

The templates on quotes.php are not shown correctly. There is a column missing of the filter setting and I still have the problem that the product messes up my language chooser.

[MaestroX]

Thanks for your help so far Cap'n Steve. 'm still having trouble, I just installed your latest version and still the same problem. I've checked the DB and the field are there. There wasn't any quotes in there so I inserted one but still no luck. (also my server handles redirects fine)

Any ideas?

Also if possible, would it be possible to add quotes from the admincp? That would be great for my needs

Just thought of something nifty, you have the $showrandomquote function, how about showing a random quote from a certain category?

[Amiga Harrison]

Originally Posted by Cap'n Steve

everyone with problems editing quotes - Make absolutely sure you have the latest .js files on your server. If it still doesn't work, please post the exact error.

I have the latest QuoteIt files on my server including the .js files but am still getting an error for the editing quotes button. The javascript error it returns when clicked is:

Error: agent.handler.responseXML has no properties
Source File: http://url/clientscript/quoteit_moderation.js
Line: 282

I also still have a problem when selecting a category without any quotes in it. I am not getting the DB error any longer so thank you for fixing that problem, it does now show the correct"No quotes matched your search" message. But then after this the auto redirect gets the url wrong. Instead of redirecting to http://siteurl/quotes.php it is trying to go to http://siteurl/siteurl/quotes.php

And one final small error. When adding a new quote the context text box is very small and aligned to the left of the page.

[Cap'n Steve]

The bad redirect should be fixed and several things should look better in Firefox.

MaestroX - Have you approved the quote you added? Try going to quotes.php?do=view&quoteid=1 and tell me if the quote shows up. You can import a file full of quotes through the admincp if you'd like. Good idea about the categories, I'll put that in 3.1.

Amiga Harrison - What version of Firefox are you using? Have you changed any of the default settings regarding timeouts or something similar? Try holding shift and hitting refresh before editing a quote. I know that editing quotes works on Firefox 1.5 and 2, so I'm not sure what problem you're having. :/

[zetetic]

Hey Cap'n Steve.

I've been using this hack for a long time. Great work. I'm having trouble upgrading, though. I recently upgraded my forum from 3.0.6 -> 3.6.4 and upgraded to the 3.5.x version of QuoteIt 2.0 at the same time. However, when I just tried to upgrade to QuoteIt 3.0 (downloaded just now) I got this db error when attempting to import the product:

 Invalid SQL:

		DELETE ratings.* FROM quoteratings AS ratings
		LEFT JOIN quotes AS quotes ON quotes.quoteid = ratings.quoteid
			WHERE quotes.quote IS NULL;

MySQL Error  : Not unique table/alias: 'ratings'

That seemed to be just a clean-up operation, so I decided to remark it out. However when I tried the import again I got the same db error TwinsForMe mentions above:

Invalid SQL:

		INSERT INTO datastore
		(title, data) VALUES
		("quote_settings", "a:14:{s:13:\"enablecontext\";s:1:\"0\";s:14:\"moderatequotes\";s:1:\"0\";s:16:\"numbertomoderate\";s:1:\"5\";s:9:\"allowhtml\";i:0;s:11:\"allowbbcode\";i:1;s:12:\"allowsmilies\";i:1;s:11:\"allowimages\";i:0;s:15:\"allowlinebreaks\";i:1;s:13:\"continuousids\";i:1;s:12:\"saveascookie\";i:0;s:11:\"upgradedate\";i:1168175936;s:16:\"enablecategories\";i:1;s:14:\"showunapproved\";i:1;s:12:\"reportemails\";s:0:\"\";}");

MySQL Error  : Duplicate entry 'quote_settings' for key 1

[GrabAssGirl]

What the heck is going on with the quotation images? They don't line up with the quote. Is there anyway to fix it? It's doing it on your "demo site" forums.monkeycrap.com as well.

[Bubble #5]

Thank you for all of your hard work Steve, Looks like a very promising hack. A+

[Defkalion]

Hi,

I installed the module on my 3.6.4 version, and immediately after the import in the Plugins admin cp, I refreshed the page and now my whole portal does not display! Instead I get the following error when I type the URL for the admincp:

Warning: Invalid argument supplied for foreach() in /includes/functions.php on line 3553

And the main portal page is just blank.

Is there a way to disable the module now that I do not have access to the admin cp? Any help would be appreciated. Thanks.

[Calash]

Here is the Java Error I am getting