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

[Neutral Singh]

Originally Posted by Cap'n Steve

I've been running it on 3.7 for a while now. What problem are you having?

1. I am getting the following error at http://www.sikhism.us/quotes.php

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

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

2. The random quote shows like the attachement which is quite untidy.


Please advice how to get it right. Thanks

[L2V]

Is there a way to disable this in certain templates? I am using a mobile template under 3.7.3 and the javascript loads on every page. Quotes isn't visible from this mobile template and I'd love to reduce the overall page size by turning off the script includes for this... Any idea how?

[Cap'n Steve]

Neutral Singh - Try the instructions in this post.

L2V - I'm sure you could use a conditional to check the styleid, but I'm not sure off the top of my head what variable it's stored in.

[L2V]

Originally Posted by Cap'n Steve

L2V - I'm sure you could use a conditional to check the styleid, but I'm not sure off the top of my head what variable it's stored in.

Thanks. Do you know what part would have the conditional? Does that go in the plugin itself? Or a template?

[Neutral Singh]

Neutral Singh - Try the instructions in this post.

Alright that made the first problem vanish. What about the second. I have kept it live on my forum for your analysis.

Please advice. Thanks

[Cap'n Steve]

L2V - Actually, try adding it to the conditional on line 768 in includes/functions_quoteit.php. The updated code should look something like this. Replace $styleid with whatever variable holds the current styleid (just search around this site to find the right one) and $yourstyle with whatever the styleid of your mobile style is.

PHP Code:

    if (!defined('THIS_IS_A_QUOTE') AND $styleid != $yourstyle) { 


Neutral Singh - That is strange. Try removing this line from includes/functions_quoteit.php.

PHP Code:

        $tempinclude = str_replace('"', '\"', $tempinclude); 


[L2V]

Originally Posted by Cap'n Steve

L2V - Actually, try adding it to the conditional on line 768 in includes/functions_quoteit.php. The updated code should look something like this. Replace $styleid with whatever variable holds the current styleid (just search around this site to find the right one) and $yourstyle with whatever the styleid of your mobile style is.

PHP Code:

    if (!defined('THIS_IS_A_QUOTE') AND $styleid != $yourstyle) { 


Brilliant! That worked perfectly.
For anyone else who needs it... The following line number mentioned above can be

PHP Code:

if (!defined('THIS_IS_A_QUOTE') AND $vbulletin->userinfo['styleid'] != xx) { 


change the xx to the style id number that you don't want the info to show up in.

Thanks Cap'n Steve!

[Forgott3n]

Sorry to bother again Cap'n Steve, but do you have an idea what could be going on? We're running 3.7.3 PL1

Originally Posted by Forgott3n

Hi we're using vB 3.7.2 and it will not sort the top quotes:

http://www.avrilbandaids.com/forums/...ing&order=desc

What's going on?

[Cap'n Steve]

Try the advice from this post.

[Forgott3n]

Originally Posted by Cap'n Steve

Try the advice from this post.

That seems to have fixed it, thank you!

[EDIT] I've seem to be getting a lot of errors since I've made the fix:

Database error in vBulletin 3.7.3:

Invalid SQL:

INSERT INTO guestquoteratings
(ip, quoteid, date, rating) VALUES
("208.101.13.14", 21, 1223328061, 4);

MySQL Error : Duplicate entry '21-208.101.13.14' for key 1
Error Number : 1062
Request Date : Monday, October 6th 2008 @ 05:21:01 PM
Error Date : Monday, October 6th 2008 @ 05:21:09 PM
Script : http://www.avrilbandaids.com/forums/...teid=21&vote=4
Referrer : http://www.avrilbandaids.com/forums/...ing&order=desc
IP Address : 208.101.13.14
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :