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

[thisgeek]

Ok ta

[docvader]

Originally Posted by Cap'n Steve

docvader - run these queries to make sure the quote settings get reset:

DELETE FROM $TPsetting WHERE varname IN ("showquote", "ratequote", "averagethreshold", "totalthreshold")

DELETE FROM $TPdatastore WHERE title = "quote_settings"

Just replace the $TP with your table prefix first.

Hi Capn
Running these queries allowed me to install the Quoteit on my 3.52 board, but, the hack is not "finding" all the the quotes that were previously in the database (from my 3.07 board running the older Quoteit). Is there another step or query that I have to run to enable the new hack to show the old quotes in the database?

Thanks!
rich

[Cap'n Steve]

So it shows some but not all of your quotes? You must either have some quotes still awaiting moderation or have a minimum rating threshold set.

[docvader]

Well, according to my database in my test board now, it lost all of my quotes. It's accepting new ones, and appears to be functioning correctly, but, my "quotes" and "quoterating" databases are empty (except for the new test quotes I put in.

At this point, is it as simple as exporting those two databases from my original board, and importing them back into the test board? Got any suggestions for upgrading the original board so that I don't lose the two "quote" databases?

Exporting the quotes and quotesratings sql files from my original board is no problem using phpmyadmin, but, I'm uncertain as to how to succesfully reimport them back into my test board, to get the original quotes to show up. "Uploading" the files didn't work.... (I'm not exactly a whiz when it comes to mysql).

Thanks!
rich

[docvader]

Originally Posted by docvader

Well, according to my database in my test board now, it lost all of my quotes. It's accepting new ones, and appears to be functioning correctly, but, my "quotes" and "quoterating" databases are empty (except for the new test quotes I put in.

At this point, is it as simple as exporting those two databases from my original board, and importing them back into the test board? Got any suggestions for upgrading the original board so that I don't lose the two "quote" databases?

Exporting the quotes and quotesratings sql files from my original board is no problem using phpmyadmin, but, I'm uncertain as to how to succesfully reimport them back into my test board, to get the original quotes to show up. "Uploading" the files didn't work.... (I'm not exactly a whiz when it comes to mysql).

Thanks!
rich

OK, that was easy, lol.

You have to drop the old database before you can install the new one. Just figured that out. Got it all working on my test board.

I guess dropping the old tables first, installing the hack fresh, and reuploading the backup sql databases is the easiest way to do this.

Thanks Capn, I'm learning all the time. Appreciate the help.

rich

[Cap'n Steve]

It shouldn't mess with your quotes or ratings unless you uninstall it, in which case it will drop both tables. But as long as you've got it working, I guess everything's peachy. :nervous:

[docvader]

My mistake. I did uninstall it, because I had lost my index page. I'll try those queries on my main board and install the hack fresh.

[Robbed]

-quote_addquote is uncached
-Would it be possible to have another sort item, have it sort by random.
-Is there a way to make it parse smilies, bold, quotes etc.

[Cap'n Steve]

Originally Posted by Robbed

-quote_addquote is uncached
-Would it be possible to have another sort item, have it sort by random.
-Is there a way to make it parse smilies, bold, quotes etc.

Good ideas, they're on the list to be included in the next version.

[loonytune15]

Great hack installed easily.

Just wondering how I can make it so this hack fits in with the rest of my forumhome? Currently it sticks out like a sore thumb

http://www.monster-designs.com/forums

Thanks for any help you can provide..