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

[Cap'n Steve]

I'm getting no permission errors on your quotes page, do you have guests or registered users allowed to view quotes? If you have phpMyAdmin on your server, could you post the contents of your quotes table?

[BrettMo]

Originally Posted by Cap'n Steve

I'm getting no permission errors on your quotes page, do you have guests or registered users allowed to view quotes? If you have phpMyAdmin on your server, could you post the contents of your quotes table?

Steve, I got it working. It seems that it was that the quotes table was corrupted but when reading the instructions I did not think to rebuild the table because the function was not giving me an permission error. I ran the table fix program and after that I found several messed up records, so dropped all the records and reloaded them. Now it looks great.

Thanks for the great function and the support.

[Cap'n Steve]

That's strange. Do you have any idea what went wrong? MySQL has been having a lot of strange errors lately.

[Chadi]

Can you please explain how to remove the author (who submitted the quote) name and date from the quote template? What code and which template?

Also, how do I remove the delete quote link and edit button?

Basically, I want only the quote/author to show up only.

[Chadi]

I edited the listbit template and got everything going except there is still a big blank gap on the bottom part which I cannot find the proper code to remove to correct that

<tr><td class="quoterow {$quoteclass}" align="left" id="quote{$quote['quoteid']}-{$globalcounter}">

<p class="quote"<if condition="($quote['userid'] == $vbulletin->userinfo['userid'] AND $quoteitpermissions['caneditownquotes']) OR ($quote['userid'] != $vbulletin->userinfo['userid'] AND $quoteitpermissions['caneditotherquotes'])"> ondblclick="editQuote(event, {$quote['quoteid']}, {$globalcounter});return false;"</if>>
<span class="quotetext" id="quotetext{$quote['quoteid']}-{$globalcounter}">{$quote['quote']}</span>
<if condition="!$sidebar">
</if>
</p>

<div class="authorcontainer">
    <if condition="!empty($quote['author'])">
        <div class="author" id="author{$quote['quoteid']}-{$globalcounter}">- {$quote['author']}</div>
    </if>
    <if condition="$quoteitoptions['enablecontext'] AND !empty($quote['context'])">
        <span class="context" id="context{$quote['quoteid']}-{$globalcounter}">({$quote['context']})</span>
    </if>
</div>

<if condition="$_REQUEST['do'] != 'preview' AND !$sidebar">
<div class="quotebottom">
    <if condition="$quoteitoptions['ratings']">
        <span class="stats" id="stats{$quote['quoteid']}-{$globalcounter}">{$vbphrase['total_rating']}: {$quote['rating']} - {$vbphrase['votes']}: {$quote['votes']} - {$vbphrase['average']}: {$quote['average']}</span>
        <span class="ratethis" id="rating{$quote['quoteid']}-{$globalcounter}">{$ratethis}</span>
    </if>

    <span class="inlineimg unapproved" id="unapproved{$quote['quoteid']}-{$globalcounter}">
    <img src="{$stylevar['imgdir_misc']}/moderated.gif" alt="{$vbphrase['unapproved_quote']}" <if condition="$quote['approved']">class="approved" </if>/>
    </span>

</div>
</if>

</td></tr>

[Cap'n Steve]

You'll have to edit clientscript/vbulletin_css/quoteit_main.css.

[Chadi]

Thanks.

Where can I edit quotes? I need to fix some categories.

Great hack

Feedback
- multiple quote addition ability
- more admin functions in backend (edit quotes)
- sort categories alphabetically, automatically
- choose by topic or by author (now, category shows category list only)
- modify category listing option / frame size

[Chadi]

Originally Posted by Cap'n Steve

You'll have to edit clientscript/vbulletin_css/quoteit_main.css.

Which line/code portion is it? Sorry, not a programmer or coder

[Cap'n Steve]

There's an "edit quote" link in the top right of each quote as long as you have given yourself permission to edit quotes. As far as the CSS file goes, I don't know what the specific problem is, but take a look at the .quote, .quotebottom, and .authorcontainer classes.

Originally Posted by chadi

- multiple quote addition ability

You can already import a text file containing quotes. Do you have another way that would work?

Originally Posted by chadi

- more admin functions in backend (edit quotes)
- sort categories alphabetically, automatically

Good idea, but how would editing quotes in the admincp work? I guess I could have a place to enter the quote ID to edit it.

Originally Posted by chadi

- choose by topic or by author (now, category shows category list only)
- modify category listing option / frame size

I'm not sure what you mean by these.

[Chadi]

Thanks for your reply. The ability to select from the category list would be two options, either by the quote topics (which I've done on my end at least) or a 2nd category option (frame), would be the author's name (hence this coincides with the author field that one inputs when adding a new quote)

In regards to editing a quote, that is only seen in the actual location (forum) where the quote is shown. Its not in the quotes.php (quotes manager area) anyway