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

[Alien]

Hey!

It's awesome to see this updated, and so much hard work going into answering all these questions..

I have a small one of my own. I'm running 2.1 of this on 2 different sites (and it's working on vBulletin 3.6.4).. Do I have to upgrade to the vB 3.50/QuoteIt 3.05 version BEFORE upgrading to this QuoteIt 3.07+ version? I attempted to upgrade directly from QuoteIt 2.1 to THIS LATEST version and I get this error message:

Database error in vBulletin 3.6.4:

Invalid SQL:

ALTER TABLE quotes
MODIFY COLUMN quoteid INT (10) UNSIGNED NOT NULL AUTO_INCREMENT;

MySQL Error : Duplicate column name 'quoteid'

[Cap'n Steve]

I finally gave in and renewed my license because my test server wasn't cutting it, but then my host chose that moment to go down. Never buy hosting from fuitadnet.com

yonglvnv - Don't worry, I haven't forgotten about vBadvanced, I'm still trying to sort out that weirdness.

jluerken - That'll be fixed in a little while.

zetetic - The database error should be fixed in the latest version. Make sure you upload all the 3.07 files. The delete problem means that the phrase must not be getting passed to the Javascript. Got a link?

everyone with no permission errors - If you're getting errors approving quotes, make sure you gave yourself permission in the usergroup manager. If you're getting errors viewing quotes, let me know what the QuoteIt! Permissions are for your usergroup. A link might help, too.

[Cap'n Steve]

Alien - Could you find out what version of mySQL you have? That's kind of a strange error, I don't see how modifying a column creates a duplicate.

[Alien]

Here you go: 4.1.21

[yonglvnv]

Thanks, this mod is worth the wait.

[Cap'n Steve]

I've uploaded 3.08, which should fix the database errors during installation.

Alien - Wonderful, the exact same version I have. I haven't found a workaround, but I've hidden the installer errors, so you should hopefully be able to install without a problem. Let me know if there are any further errors.

[jluerken]

Cap'n Steve,

v 3.08 still contains the language Chooser bug.
Enabling the random quote options now does not make wrong entries in the language chooser, it simply turns it off

Editing a language makes the language chooser visible again but turns off the random quote option. This can be reproduced at any time

Can you please take a look at this again?

[Alien]

Hay Cap'n!

v3.08 allowed the upgrade to go through without error.

Right after install I edited the QuoteIt options but left things as they were.

Then, I clicked on "Moderate Quotes" to take a look (I know we were up to date and there were no quotes to moderate), and I get this error:

Invalid SQL:

SELECT quotes.*, user.username, categories.title AS category FROM quotes AS quotes
LEFT JOIN user AS user ON user.userid = quotes.userid
LEFT JOIN quotecategories AS categories ON quotes.categoryid = categories.categoryid
WHERE quotes.approved = 0 LIMIT 5;

MySQL Error : Unknown column 'quotes.categoryid' in 'on clause'
Error Number : 1054

I also clicked on "Manage Categories" (i know we haven't made any categories yet, as 2.1 didn't have this correct?" and I get this error:

Invalid SQL:

SELECT category.*, COUNT(quotes.quoteid) AS count FROM quotecategories AS category
LEFT JOIN quotes AS quotes ON quotes.categoryid = category.categoryid
GROUP BY category.categoryid ORDER BY category.displayorder ASC;

MySQL Error : Unknown column 'quotes.categoryid' in 'on clause'
Error Number : 1054

Help!

[soulface]

Originally Posted by jluerken

Cap'n Steve,

v 3.08 still contains the language Chooser bug.
Enabling the random quote options now does not make wrong entries in the language chooser, it simply turns it off

Editing a language makes the language chooser visible again but turns off the random quote option. This can be reproduced at any time

Can you please take a look at this again?

Yes this bug still exists. also..

after many testing on my test forum, today i install this on my live forum. which had the old version from vb3.5. so after the update, all quotes add dates showing todays date (January 16th, 2007) screenshot attached bellow...

[yonglvnv]

Cap'n Steve,
had a weird situation. After upgrading to 3.8, QuoteIt disappeared from vba cmps page. Completely uninstalled the 3.8 and reinstalled QuoteIt and was locked out of my admincp. The error on blank admin page and top of all my website pages were "Warning: Invalid argument supplied for foreach() in /includes/functions.php on line 3553" which is "foreach ($_FIELDNAMES AS $field => $bitvalue)" in functions.php file. Ended up disabling all hooks through my config.php file so I can sign back in to admincp page to disable this mod. I'm also seeing some error messages when doing a fresh install of QuoteIt. Trying to install 3.7 gave me the same error. Do you think uninstall didn't clean up everything?