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

[nnjj.net]

how rebuilding bitfields?

[Cap'n Steve]

It's under vBulletin Options, you might have to turn debug mode on.

[welovehiphop]

Originally Posted by Cap'n Steve

Make sure the random quote is enabled in the options, save the options just to be sure. Try going to quotes.php and see what happens. If all else fails, reinstall the mod.

that did it!

[welovehiphop]

actually it worked but its not allowing me to approve the quotes..saying

Sorry, you don't have permission to access the administrative controls on this page.

If you need to access this page, ask your lead administrator to enable your permissions for this page using the Administrator Permissions section of the control panel.

[Cap'n Steve]

Try rebuilding the bitfields or saving the usergroup permissions like I mentioned in the post above. If that doesn't work, what vBulletin version are you using?

[Gray Matter]

This may be a stupid question, but where can I edit the URL for the pagenav links? There are unencoded ampersands in it and I'm getting a bunch of errors in the W3C Validator.

[Cap'n Steve]

I believe the pagnav is in the pagenav template. I never noticed that before, so I'm not sure exactly why they aren't getting escaped. It looks like they might need to be escaped in includes/functions_quoteit.php (just search for $querystring), but that might break something else. I'll have to take a deeper look sometime.

[Megareus Rex]

For anyone who can help, I get this mysql error when trying to upload the product:

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 'ENGINE=MyISAM' at line 15
Error Number : 1064

Does anyone have any idea what causes it, and/or how to fix it?

[Cap'n Steve]

Try redownloading and reinstalling it. What MySQL version do you have?

[zmuda]

Problem Solved...