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

[samu2]

OK Finally I got it to work is there any way I can get it to show up on all pages? great mod Thank you

[dieselpowered]

After moderating, I am receiving this error:

"Could not find phrase 'quote_x_has_been_approved"

It is odd as looking within the phrase manager does have it existing? :ermm:

Also, is there a way to make a confirmation page so that people know that the quote will not display until approved?

[Cap'n Steve]

Originally Posted by xtremeoff-road

No my friend, I am looking for the code to add to my CMPS moderation module so that I do not have to go into the admincp every time to check if new quotes have ben submitted.

I know, it's in that post I linked along with instructions for adding the Random Quote block.

To add a message for after a quote is submitted, create a template called quote_message (just base it off of quote_addquote and delete the text boxes) then, in quotes.php find

PHP Code:

elseif ($_REQUEST['do'] == 'add') {

    if (!$vbulletin->userinfo['userid']) {
        print_no_permission();
        exit;
    }

    if (empty($_POST['author']) OR empty($_POST['quote'])) {
        eval(standard_error(fetch_error('requiredfields')));
    }
    $approved = 0;
    if ($settings[3] == 0) {
        $approved = 1;
    }
    if ($settings[5] == 1) {
        $context = $db->escape_string(htmlspecialchars_uni(trim($_POST['context'])));
    }
    $author = $db->escape_string(htmlspecialchars_uni(trim($_POST['author'])));
    $quote = $db->escape_string(nl2br(htmlspecialchars_uni(trim($_POST['quote']))));
    $db->query_write('
        INSERT INTO ' . TABLE_PREFIX . 'quotes
        (quote, author, userid, approved, context) VALUES
        ("' . $quote . '", "' . $author . '", ' . $vbulletin->userinfo['userid'] . ', ' . $approved . ', "' . $context . '")
    ');

    header('Location: ' . $vbulletin->options['forumhome'] . '.php?' . $vbulletin->session->vars['sessionurl']);

} 


and replace that with

PHP Code:

elseif ($_REQUEST['do'] == 'add') {

    if (!$vbulletin->userinfo['userid']) {
        print_no_permission();
        exit;
    }

    if (empty($_POST['author']) OR empty($_POST['quote'])) {
        eval(standard_error(fetch_error('requiredfields')));
    }
    $approved = 0;
    if ($settings[3] == 0) {
        $approved = 1;
    }
    if ($settings[5] == 1) {
        $context = $db->escape_string(htmlspecialchars_uni(trim($_POST['context'])));
    }
    $author = $db->escape_string(htmlspecialchars_uni(trim($_POST['author'])));
    $quote = $db->escape_string(nl2br(htmlspecialchars_uni(trim($_POST['quote']))));
    $db->query_write('
        INSERT INTO ' . TABLE_PREFIX . 'quotes
        (quote, author, userid, approved, context) VALUES
        ("' . $quote . '", "' . $author . '", ' . $vbulletin->userinfo['userid'] . ', ' . $approved . ', "' . $context . '")
    ');

    eval('print_output("' . fetch_template('quote_message') . '");');

} 


I know about the missing phrase, I've yet to figure out what group to put it in. :ermm:

Originally Posted by samu2

is there any way I can get it to show up on all pages?

Instructions are in this post.

[thisgeek]

Is there any way to get the quotes to parse vbcode and smilies?

[DefenceTalk]

FYI:

If you have Photopost installed, this mod's who is online process will cause issues with Photopost's Who is online not working correctly with vB.

[Cap'n Steve]

Originally Posted by thisgeek

Is there any way to get the quotes to parse vbcode and smilies?

Not yet.

Originally Posted by DefenceTalk

FYI:

If you have Photopost installed, this mod's who is online process will cause issues with Photopost's Who is online not working correctly with vB.

I'll take a look at that.

[CtrlAltDel]

nice work steve, thought i'd slap a post in here

[thisgeek]

How can I integrate QuoteIt with vbShout (v2)? - I want to add a 'Submit to Quotes' link on the archives page - any simple way of doing this?

[Robbed]

Originally Posted by xtremeoff-road

After moderating, I am receiving this error:

"Could not find phrase 'quote_x_has_been_approved"

It is odd as looking within the phrase manager does have it existing? :ermm:

Same problem, any fixes?

also the title of the page is Array[bbtitle]

[Cap'n Steve]

Originally Posted by Robbed

Same problem, any fixes?

also the title of the page is Array[bbtitle]

Just ignore the phrase for now, it's harmless.

To fix the title, change $vbulletin->options to $vboptions in the templates.

Originally Posted by thisgeek

How can I integrate QuoteIt with vbShout (v2)?

I'm not sure how the vbShout database is structured, but you could probably just copy the submit post code and adapt it to their table. They'd probably be able to give you more help than me.