QuoteIt! 2.0 - Quote Management System

QuoteIt! version 2.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. This was developed on vBulletin 3.0.7, but should work on 3.0.0 and above.

You can see a demo on forums.monkeycrap.com.
Instructions for adding a random quote to vBadvanced and vBindex are in this post.


Features (features new to 2.0 are in yellow)

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
- the quote shown is much more random than in previous versions

Quote Database
- quotes can only be edited or deleted by an administrator
- quotes can be viewed individually or listed on several pages
- quotes can be sorted by total score, average score, author, submitter, or date added
- quotes now have a "context" field that can be turned on or off to include more information about the quote
- 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 administrator can now edit quotes
- the quote moderation que is now more like the que for posts, enabling the moderation of several quotes at once



Don't forget to click

This hack is based on QuoteIt! 1.2, originally by magnus. The "submit post" feature was inspired by an addon by CtrlAltDel. The location code is based on a post by Acido.

You may release translations of this hack as long as the original credits are included. Otherwise, you not redistribute this hack without permission from me.

[Cap'n Steve]

If you want to add the username to the random quote, in index.php find:

PHP Code:

        $randomquote = $DB_site->query_first('
            SELECT quotes.* FROM ' . TABLE_PREFIX . 'quotes AS quotes
             WHERE approved = 1 ' . $threshold . ' LIMIT ' . $row . ', 1
        '); 


Replace that with:

PHP Code:

        $randomquote = $DB_site->query_first('
            SELECT quotes.*, user.username FROM ' . TABLE_PREFIX . 'quotes AS quotes
            LEFT JOIN ' . TABLE_PREFIX . 'user AS user ON quotes.userid = user.userid
             WHERE approved = 1 ' . $threshold . ' LIMIT ' . $row . ', 1
        '); 


I don't see what you mean about the tables being messy. Could you post a screenshot? That's an interesting redesign of the random quote you've got going there.

[j_86]

Thanks Capn'

One question; when you do a vote on the randomquote display on forumhome, does it register the vote or are you just taken to the quote view page where you need to do it again?

[Cap'n Steve]

In my version, it registers the vote and redirects you back the forumhome. Are you asking how to add that to your redesign? Just have a form that calls quotes.php with quoteid=$randomquote[quoteid], do=rate and vote=whatever number's in the select box (or the word "plus" or "minus" if you're using that system).

[j_86]

Hi again;

Could you show me how to incorporate the above information to get this working (into my below form)? Thank you.

<form name="voting" id="voting" action="$vboptions[bburl]/quotes.php">
	<input type="hidden" name="quoteid" id="quoteid" value="$randomquote[quoteid]" />
	<select name="vote" id="vote" onchange="document.voting.submit();">
	<option value="">Average Rating: $randomquote[average]</option>
	<option value="1">1</option>
	<option value="2">2</option>
	<option value="3">3</option>
	<option value="4">4</option>
	<option value="5">5</option>
	</select>
	</form>

[Cap'n Steve]

Use this:

<form name="voting" id="voting" action="$vboptions[bburl]/quotes.php">
	<input type="hidden" name="quoteid" id="quoteid" value="$randomquote[quoteid]" />
 	<input type="hidden" name="do" id="do" value="rate" />
	<select name="vote" id="vote" onchange="document.voting.submit();">
	<option value="">Average Rating: $randomquote[average]</option>
	<option value="1">1</option>
	<option value="2">2</option>
	<option value="3">3</option>
	<option value="4">4</option>
	<option value="5">5</option>
	</select>
	</form>

[j_86]

Great! One last question I hope; any conditionals to use to see if the current user has voted yet (template conditionals)?

[Cap'n Steve]

Just surround it with:

<if condition="$vboptions[ratequote]==2">
</if>

[j_86]

Here is what i'm coming up with so far, in the re-drawing of the random quote template. It is complete for my needs, but if i'm allowed to release it (Cap'n), i'll make it compatiable with all other voting modes etc.

I'm also going to be releasing an addon, shortly, that adds a "X Quotes Pending Moderation" on the Quick Stats view on AdminCP Home (if enabled).

Thanks.

Please see the screenies so far - tell me if you like them.
One of them shows the quote view.
One of them shows the drop down menu after you have voted.
One of them shows the drop down menu with voting options.
(all whilst logged in with full admin perms)

[j_86]

Capn' - I think I found a bug, in that there is nothing displayed on the nav tree at the top of the page when editing a quote (it would normaly show: "Forum name" and then "Quotes" underneath it).

[Cap'n Steve]

Those templates look pretty cool. Go ahead and release them, you don't really need my permission to release an addon anyway.

Thanks for pointing out that bug. It's fixed in the installer now. If you want to fix it on your forum, go to the phrase manager in your administrator control panel, find the phrase called "quote_manager" and change the phrase type to global.