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

[AfterWorldForum]

That did not seem to do anything for me. I must admit though that I've been working on an attempt of my own to implement a new module, but so far have not been succesful. I might have accidently messed up the template in the process.

Once again, though, thanks for all your help and effort. By far the best support I've seen on any mod.

[Cap'n Steve]

I edited the plugin in the previous post, try uploading it again. I included some code that might give me a little more information, but if this doesn't help, I'm running out of ideas.

[AfterWorldForum]

Man, you're going to hit me or something, but I figured it out.

When looking at the main options, I noticed it stated something in the field for the Portal Output Global Variables, that one page (which would be my portal) was not configured to use the default.

After I added the showrandomquotes to the variables list there, it worked. I need to figure out the proper layout to use, but at least things seem to finally work

I'm feeling all embarrassed now for it bieng so obvious, and having wasted your time like that

[Cap'n Steve]

Yeah, I knew it had to be something simple I wasn't seeing. Glad you got it working!

[Sadie Frost]

I still have a problem with unapproved quotes being viewable to all members - has anyone had this problem and found a fix?

[Cap'n Steve]

I don't know what would cause that problem. Try re-saving your QuoteIt! options, and your usergroup permissions. If that doesn't work, enable debug mode and then view the quotes page on a non-moderator account, show the queries being run and post any quotes related queries that you see.

[Sadie Frost]

It's only with the random quote on the index page where the unapproved quotes show. I have three boards that have used quote it for years with the same problem. I did a clean install of vb and QuoteIt and got the same thing happening.

Here are the quote-related queries on the index page:


SELECT COUNT(*) AS count FROM quotes AS quotes WHERE quotes.average >= 0 AND quotes.rating >= 0

SELECT quotes.*, categories.title AS category, users.username FROM quotes AS quotes
LEFT JOIN user AS users ON quotes.userid = users.userid
LEFT JOIN quotecategories AS categories ON categories.categoryid = quotes.categoryid WHERE quotes.average >= 0 AND quotes.rating >= 0 LIMIT 281, 1

SELECT rating AS yourvote FROM quoteratings WHERE quoteid = 575 AND userid = 6370

Thanks Steve I love QuoteIt, whether regular members see the spam or not

[Cap'n Steve]

Ok, try this. In includes/functions_quoteit.php find this

PHP Code:

    $threshold = is_array($threshold) ? 'WHERE ' . implode(' AND ', $threshold) : ''; 


and above that, add this

PHP Code:

    $threshold[] = 'quotes.approved = 1'; 


[Dr. Bantham]

Has anyone tried this mod out with VB4.0?

[Sadie Frost]

Originally Posted by Cap'n Steve

Ok, try this. In includes/functions_quoteit.php find this

PHP Code:

    $threshold = is_array($threshold) ? 'WHERE ' . implode(' AND ', $threshold) : ''; 


and above that, add this

PHP Code:

    $threshold[] = 'quotes.approved = 1'; 


That seems to be working now - at least on my test board. Thank you so much Steve! You're awesome - much appreciated!