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

[scville]

The first step says to upload the upload folder into your forum directory. How do you go about doing this step? I have only done simple mods and not sure how to start this one. Thanks!

[Cap'n Steve]

The same way you got the vBulletin files uploaded to your site. Usually this means an FTP client, but some people have a way to upload through a web-based control panel that their host gives them. Oh, and don't upload the upload folder itself, just everything inside of it.

[Chadi]

This mod does not work with this one:
https://vborg.vbsupport.ru/showthread.php?t=132716

The code that must be used is outputting as text only:

$showrandomquote

It won't pull when placed in the code box for the mentioned mod. However, it works fine in forumdisplay template.

Do you know of any workaround to this?

Thanks.

[Cap'n Steve]

Are you saying you're putting $showrandomquote in the "Custom HTML Code" box on that mod's admincp page? That's probably not possible, but you can try following the instructions to enable a global random quote and see if that helps. If not, you'll just have to place it in a template.

[DBs]

Originally Posted by Cap'n Steve

DBs - I'm not sure why that would cause problems. I don't know anything about how vBulletin handles caching systems, but I'll put it on the list of things to look at. In the meantime, I guess you'll just have to disable it, which hopefully won't slow things down too much.

thepub - Try approving some of the quotes on your site.

Hi Cap'n Steve,

Any news on the above issue?

[Cap'n Steve]

Sorry, I really haven't been able to work on this at all. Do you have any other mods installed that add to the datastore and do they work ok?

[Neutral Singh]

Unable to delete quotes, states:

Warning: Invalid argument supplied for foreach() in /home/xxxxxx/public_html/xxxxxx/quotes.php on line 726

Database error in vBulletin 3.8.0:

Invalid SQL:

SELECT * FROM quotes
WHERE quoteid IN ();

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2
Error Number : 1064
Request Date : Saturday, January 31st 2009 @ 04:41:49 AM
Error Date : Saturday, January 31st 2009 @ 04:41:49 AM

[Cap'n Steve]

Were you trying to delete multiple quotes? Have you been able to delete multiple quotes before?

[Chadi]

Strange problem in 3.8.1

It seems the Show Random Quote option gets turned off automatically by itself for some reason. Not sure what is causing it.

[Chadi]

Another bug:

Messes up forum display columns when enabled.

Disabled:


Enabled: