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

[gettingbetter]

I've enabled the moderation option in my QuoteIt settings, yet users have somehow been able to bypass it and their quotes show up right away on the page. What could be the problem here?

Moderate Quotes is set to YES.

[Cap'n Steve]

That is strange. Try saving the options again and try creating a new user and adding a quote with that account. Does it still get automatically approved? A link to your site might help, too.

[Dr. Bantham]

Is it feasible to be able to add additional fields to quote entries? I wish to add a URL reference field and a media file path field.

[Cap'n Steve]

I don't have time to do it right now, but it shouldn't be that hard. Just add the appropriate database columns, then add the fields in the quote_listbit and quote_manager templates and a little bit of code in quotes.php to insert the fields in the right columns.

[Dr. Bantham]

The quotes and randomquote BBCodes are not functional on my board, though they have been in the past. No content of any nature appears. I double checked the settings, and they are turned on. I saved all QuoteIt options, rebuilt bitfields, re-uploaded all files and re-imported the product. No dice. The BBCodes are there, but the Replacement fields are blank. Furthermore, the randomquote BBCode entries are stripped entirely from the post content after saving.

UPDATE #1
I deleted the BBCodes and repeated all procedures above. Now the quotes BBCode is functional, but the randomquote is still defunct.

UPDATE #2
Perhaps I spoke too soon. The quotes BBCode appears to be functional after first saving and displaying post content, however it reverts back to displaying plain text tags thereafter. When viewing the BBCodes within the BBCode manager of ACP, it displays {Q1201967627:42} in the HTML and Replacement columns for quotes and {R1201967627:0} for these respective fields for randomquote. When you edit both quotes and randomquote BBCodes, the Replacement box is empty.

UPDATE #3
I have discovered that the quotes BBCode is working only on quick replies and quick edits, and only when first displaying the post immediately thereafter. Refreshing the page or going back later to view the post reverts to plain text tags (ie "[quotes]246[/quotes]". Again, randomquote disappears regardless.

[Cap'n Steve]

Ooh, that random quote does look pretty broken, although I don't see what you mean about the [quotes] BBCode. I'm not sure what update caused that problem, but I'll take a look at it tomorrow. Ignore the BBCodes in the admincp, though. That was originally just an example and probably should have been taken out.

[Dr. Bantham]

Originally Posted by Cap'n Steve

Ooh, that random quote does look pretty broken, although I don't see what you mean about the [quotes] BBCode. I'm not sure what update caused that problem, but I'll take a look at it tomorrow. Ignore the BBCodes in the admincp, though. That was originally just an example and probably should have been taken out.

Thanks for taking a look, Steve. As for the [quotes] BBCode, it appears to work upon preview and the first display of a quick reply or quick edit. However, if you refresh the post or go back later, it reverts to text as if the BBCode is unrecognized.

[Cap'n Steve]

Ok, it appears that something changed with the removal of empty BBCodes. For the time being, just put anything between the randomquote tags, like this:

[randomquote]oug[/randomquote]

I still can't duplicate the [quotes] problem, though. I'd like to try it on your site, do you want to make a hidden forum or something so I can test it out?

[Dr. Bantham]

Originally Posted by Cap'n Steve

Ok, it appears that something changed with the removal of empty BBCodes. For the time being, just put anything between the randomquote tags, like this:

[randomquote]oug[/randomquote]

This resulted in a blank post, though it does now retain the BBCode instead of having it stripped.

Originally Posted by Cap'n Steve

I still can't duplicate the [quotes] problem, though. I'd like to try it on your site, do you want to make a hidden forum or something so I can test it out?

I'm OK with a public test. You can delete your post when finished, or I can clean it up later.
As for the forum, how about this one:
http://www.ligotti.net/forumdisplay.php?f=86

Thanks again!

[Cap'n Steve]

Try reuploading the latest files and reinstalling (without uninstalling) the product. If that doesn't work, edit the "Finalize BBCode" plugin that uses the "newpost_preview" hook and replace this:

PHP Code:

} 


with this:

PHP Code:

header('Content-type: text/plain');
die('quotes = ' . print_r($quotebbcodeids, true) . "\n random = " . print_r($randomquotes, true));
} 


Then try previewing a post with a few [quotes] and [randomquote] bbcodes in it and tell me what the output is. This will break the post preview, so undo the edit after you're done.