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

[Soliloquy]

I'm having the same problem with random quotes not displaying that BrettMo did, except I checked my tables in phpMyAdmin and found nothing wrong. Repaired them anyway and still nothing. The BEGIN and END comments are in the source, random quotes are enabled in the options, quotes.php is working just fine, and I have no quotes in the moderation queue. I even installed the global quotes plugin and tried it on a couple other pages just in case, but that had no effect. Any ideas for me?

Thanks for all your hard work, Cap'n Steve.

[Cap'n Steve]

Could you post a link?

[Stop]

I can't figure out the right way to import quotes from a file. Can somebody please attach a file with some quotes so I can see how they are arranged?

Thanks in advanced..

[Cap'n Steve]

Soliloquy - What do you have for Total Threshold and Average Threshold in your QuoteIt! Settings? Better yet, just post a screenshot of those options.

Stop - It just splits them up based on what you put in the Separator box. So if the Separator was set to | and the Field Order was set to quote, author, userid, context (the default) then the file you upload would look like this:

quote text|me|1|none
another quote|you|32|none
last quote|last author|0|from a tv show

[Stop]

Thanks a lot Steve. It did work fine with me.
But I noticed that the quotes I imported, go the no where. I mean there were not classified under any category, though I can browse them through the Quotes main page.
Can you please add a field so we can choose to which category the quotes will sent to when we import some from a file ?

[Soliloquy]

Originally Posted by Cap'n Steve

Soliloquy - What do you have for Total Threshold and Average Threshold in your QuoteIt! Settings? Better yet, just post a screenshot of those options.

I've experimented with different settings for those options, but don't really understand what they refer to. Right now they're at 10 and 10.

[Cap'n Steve]

Stop - Just add categoryid to the Field Order and then include the ID in the file.

Soliloquy - That's the problem then. It's looking for only quotes with a total rating and average rating greater than or equal to 10. Just set those to blank.

[Soliloquy]

I set them to blank and still no luck. Anything else it could be?

[Cap'n Steve]

It was a bug in the cron job that picks a new quote. Install the latest version and save the QuoteIt! Options again and it should work.

[Talisman]

Cap'n,

For some reason, I'm getting a weird error displayed in the ACP when I change options. But, the changes seem to work okay... so I don't know what to think of it.

Fatal error: Call to a member function on a non-object in /{deleted path}/forum/includes/functions_quoteit.php on line 1678

I checked that php script and this is what appears on lines 1678-1681:

 $cronexists = $db->query_first('
  SELECT * FROM ' . TABLE_PREFIX . 'cron
   WHERE filename = "./includes/cron/guestquotes.php"
 ');