QuoteIt! - Quote Database

QuoteIt! version 3.0

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.

Other versions (development will continue for the 3.6 version only): QuoteIt! 3 for vBulletin 3.6.x | QuoteIt! 2.03 for vBulletin 3.0.x

[lexx27]

I think there is a modification at vbadvanced page

[Warrior]

Originally Posted by Mr.Monkey

Can anyone suggest what I should add into the "adv_portal_moderation" to get the link to the quotes to moderate to show correctly on my quick moderate module in vbAdvanced?

I am also interested in this... did I miss it somewhere?

[Bubble #5]

Originally Posted by Cap'n Steve

The easy way to only allow administrators would be to edit quotes.php

Is there a way to only have admins add the quotes? The code above is only for editing the quotes. Maybe add a conditional before where it says "add a quote, show all quotes"? I'm not sure what the correct conditional would be though, or where to add it. Maybe in the templates? Thanks.

[Gio Takahashi]

Database error in vBulletin 3.5.1:

Invalid SQL:

					UPDATE quotes SET
					votes = votes + 1,
					rating = rating + 2,
					average = rating / votes
						WHERE quoteid = 385;

MySQL Error  : Unknown column 'votes' in 'field list'
Error Number : 1054
Date         : Sunday, December 4th 2005 @ 12:50:29 AM
Script       : [url]http://www.unitedempire.net/forum//quotes.php?do=rate&quoteid=385&vote=2[/url]
Referrer     : [url]http://www.unitedempire.net/forum/index.php[/url]
IP Address   : 71.3.5.169
Username     : Gio Takahashi
Classname    : vb_database

BTW, I did have QuoteIt for Vb 3.0. Anyway, anything I can do to fix it? Should I just manually add the collumn or not?

[Cap'n Steve]

I'm guessing you had QuoteIt! 1.2 but never upgraded to 2.0, right? I never even considered that situation when I released this version. :ermm: The next version should handle the upgrade better, but until then these queries should fix it:

UPDATE $TPquotes ADD COLUMN (votes SMALLINT(10) UNSIGNED NOT NULL DEFAULT 0, rating MEDIUMINT(10) NOT NULL DEFAULT 0, average FLOAT(3, 2) NOT NULL DEFAULT 0.00, context VARCHAR(250))

ALTER TABLE $TPquotes ADD INDEX rating

ALTER TABLE $TPquotes ADD INDEX average

Just replace $TP with your table prefix.

[Cap'n Steve]

For those interested, I've added instructions for adding quotes to the vBadvanced quick moderation in this post.

[Bubble #5]

Why doesn't this hack work in the header?

We added $showrandomquote (as mentioned in this thread) and made the changes to the plugin, but it still doesn't show up

What would block it from showing up?

[Cap'n Steve]

To only allow administrators to add quotes, in quotes.php, find

PHP Code:

require_once('./global.php'); 


below that, add

PHP Code:

    if ($_REQUEST['do'] == 'add' OR $_REQUEST['do'] == 'addquote' OR $_REQUEST['do'] == 'editquote' OR $_REQUEST['do'] == 'edit' OR $_REQUEST['do'] == 'submitpost' OR $_REQUEST['do'] == 'submit') {
    if (!$vbulletin->userinfo['permissions']['adminpermissions'])     {
        print_no_permission();
        exit;
    }
} 


I'm not sure about your other error, could you attach a saved html page where the quotes should be showing up in the header?

[Gio Takahashi]

Originally Posted by Cap'n Steve

I'm guessing you had QuoteIt! 1.2 but never upgraded to 2.0, right? I never even considered that situation when I released this version. :ermm: The next version should handle the upgrade better, but until then these queries should fix it:

UPDATE $TPquotes ADD COLUMN (votes SMALLINT(10) UNSIGNED NOT NULL DEFAULT 0, rating MEDIUMINT(10) NOT NULL DEFAULT 0, average FLOAT(3, 2) NOT NULL DEFAULT 0.00, context VARCHAR(250))

ALTER TABLE $TPquotes ADD INDEX rating

ALTER TABLE $TPquotes ADD INDEX average

Just replace $TP with your table prefix.

a bit of an issue: I had to manually add in the columns because the syntax you gave does not seem to work.

Yes I replaced $TP with the correct table prefixes..well I don't use prefixes at all anyway >>.

none of the queries work at all.

[Cap'n Steve]

That's weird, do you remember the error it showed?