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]

KevinL - What errors?

expatdirectory - Try experimenting with the module settings when you add it. vBadvanced may have added some new options since the last time it was updated.

[KevinL]

Originally Posted by Cap'n Steve

KevinL - What errors?

When I check 'show random quote' I get these errors:

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 31

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 32

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 33

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 34

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 35

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 36

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 37

Any ideas? I did do a search but came up with nothing...

Thank you

EDIT** now I'm also getting this

Warning: Cannot modify header information - headers already sent by (output started at [path]/includes/class_core.php:3243) in [path]/includes/functions_quoteit.php on line 1198

[Dr. Bantham]

I would love for this mod to have a feature to auto-create a thread as new quotes are entered. I have managed to create new fields for this mod and could create another for thread title. My site has quotations constantly appearing within the forums for discussion. I end up replicating quotations myself within QuoteIt! and editing their post to include the [quotes] reference. I would think that this feature would not be too complicated, but it is beyond my current ability. I would be satisfied if the forum was fixed as a option variable, but having forum selection within a dropdown list would be even better. The thread content would consist only of [quotes]quotenumber[/quotes]. If you do not have time to dedicate to this, Cap'n Steve, then any suggestions with the approach would be greatly appreciated. I think that tying QuoteIt! to the forums in such a manner would be the ideal feature for promoting additional installations and forum discussion of the quotes themselves.

[KevinL]

Originally Posted by KevinL

When I check 'show random quote' I get these errors:

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 31

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 32

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 33

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 34

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 35

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 36

Warning: Cannot use a scalar value as an array in [path]/includes/functions_quoteit.php on line 37

Any ideas? I did do a search but came up with nothing...

Thank you

EDIT** now I'm also getting this

Warning: Cannot modify header information - headers already sent by (output started at [path]/includes/class_core.php:3243) in [path]/includes/functions_quoteit.php on line 1198

Hmm I'm glad that this was bumped

Has anyone ever seen this?

[Cap'n Steve]

KevinL - Try removing this chunk of code from includes/functions_quoteit.php (also, post a list of the other mods you have installed):

PHP Code:

$settings[1] =& $quoteitoptions['ratings'];
$settings[3] =& $quoteitoptions['moderatequotes'];
$settings[0] =& $quoteitoptions['showrandomquote'];
$settings[4] =& $quoteitoptions['numbertomoderate'];
$settings[2] =& $quoteitoptions['averagethreshold'];
$settings[7] =& $quoteitoptions['totalthreshold'];
$settings[5] =& $quoteitoptions['enablecontext']; 


Dr. Bantham - I've never used the post datamanager, so I'm not sure how to do it off the top of my head, but you'll want to add it at the end of the add_quote function in includes/functions_quoteit.php.

[KevinL]

Originally Posted by Cap'n Steve

KevinL - Try removing this chunk of code from includes/functions_quoteit.php (also, post a list of the other mods you have installed):

PHP Code:

$settings[1] =& $quoteitoptions['ratings'];
$settings[3] =& $quoteitoptions['moderatequotes'];
$settings[0] =& $quoteitoptions['showrandomquote'];
$settings[4] =& $quoteitoptions['numbertomoderate'];
$settings[2] =& $quoteitoptions['averagethreshold'];
$settings[7] =& $quoteitoptions['totalthreshold'];
$settings[5] =& $quoteitoptions['enablecontext']; 


This works wonders!

Got it up and running. Now I had this on my site since the first version. I did a dump of the old database (before we had to close for a bit) and want to add them back in. Now when I tried to do that I started getting these errors:

Database error in vBulletin 3.7.2:

Invalid SQL:

			SELECT quotes.*, categories.title AS category, users.username FROM quotes AS quotes
			LEFT JOIN user AS users ON quotes.userid = users.userid
			LEFT JOIN quotecategories AS categories ON categories.categoryid = quotes.categoryid
			
				 LIMIT 17, 1;

MySQL Error   : Unknown column 'quotes.categoryid' in 'on clause'
Error Number  : 1054
Request Date  : Saturday, August 2nd 2008 @ 07:12:28 AM
Error Date    : Saturday, August 2nd 2008 @ 07:12:28 AM

I understand what it's saying but what I don't understand is why inserting them back into the database is giving me this error (since this is actually the 2nd time doing it like this). Also what is the table 'on clause'?

Thanks for your help!

[Cap'n Steve]

You don't have the categoryid column in your quotes table somehow. I'm guessing your database dump dropped the tables and then recreated them. Try re-importing the product (without uninstalling it). After that, you'll have to edit the dump file and remove all the DROP TABLE and CREATE TABLE statements before you can safely import it.

[KevinL]

Worked wonders!!

Thank you

[gpc10347]

Mod still working wonders and looks great!

I need something that is probably right under my nose but - here goes:

I have a style specifically for cell phones and disable as much as I can..

To date, I have the following:

PHP Code:

//Disables Cyb Chatbox
$vbulletin->options['cybchatbox_enable_product']=0;
//Disables MGC Chatbox
$vbulletin->options['mgc_cb_evo_active']=0;
//Disable Moods?
$vbulletin->options['vmoods_active']=0; 


What would the proper string be to disable QuoteIt for this situation only?

Thanks in advance!!

[Cap'n Steve]

Do you mean just the random quote? For that, try this (although it needs to execute after QuoteIt!'s "Initialize Global Options/Permissions" plugin):

PHP Code:

$quoteitoptions['showrandomquote'] = false;