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

[jluerken]

Originally Posted by Cap'n Steve

jluerken - What did you do to correct the problem that uninstalled the hack? When I select "Rebuild All Languages", just the problem goes away.

No the problem is not gone then. Enabling, Disabling the hack brings the problem with the language choose also up again.
Please check this again, there is something wrong with the hack..

[Cap'n Steve]

You need to install the latest version.

[efil]

Hi,
I have some problems with this mod,

1.My forum is in hebrew (rtl) and i don't get the Quote in the frame (see pic 1). also the I need the table above the Quote to locate to the right side. (see pic 2).
2. Some options In admincp can not be save.

[Calash]

I am still getting the Javascript error. I may have misspelled it when I copied the error code to the forum.

I am also getting the language bar error listed above. Rebuilding the languages did fix it for me for the moment.

The 500 error is gone, it takes me to a screen to enter a new quote.

[jluerken]

Originally Posted by Calash

I am also getting the language bar error listed above. Rebuilding the languages did fix it for me for the moment.

I have the same error like efil is posting above. The template is not correct.

Calash can you please turn on the random quote and turn off the random quote in the hack a few times? Afterwards please take a look at the language chooser. The error must be there again

[MaestroX]

I'm having a problem, anytime I go to quotes.php the page is blank. Any ideas?

[soulplayer]

Hy,

I'm having this problem:

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT * FROM vb3quoteratings
WHERE quoteid IN () AND userid = 5;

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 ') AND userid = 5' at line 2 Error Number : 1064
Date : Friday, January 5th 2007 @ 05:26:54 PM
Script : http://www.xeonix.be/forum/quotes.php
Referrer : http://www.xeonix.be/forum/quotes.php?do=list
IP Address :XXXXXXXX
Username : bulbaz0r
Classname : vb_database

The plugin works, but I'm still getting this error in my mail...

[TwinsForMe]

I'm getting the following error when Importing product-quoteit.xml via the Add/Import Product". And yes, I have allowed overwrite.

Database error in vBulletin 3.6.4:

Invalid SQL:

INSERT INTO vb3_datastore
(title, data) VALUES
("quote_settings", "a:14:{s:13:\"enablecontext\";s:1:\"1\";s:14:\"mod eratequotes\";s:1:\"1\";s:16:\"numbertomoderate\"; s:2:\"25\";s:9:\"allowhtml\";i:0;s:11:\"allowbbcod e\";i:1;s:12:\"allowsmilies\";i:1;s:11:\"allowimag es\";i:0;s:15:\"allowlinebreaks\";i:1;s:13:\"conti nuousids\";i:1;s:12:\"saveascookie\";i:0;s:11:\"up gradedate\";i:1168027704;s:16:\"enablecategories\" ;i:1;s:14:\"showunapproved\";i:1;s:12:\"reportemai ls\";s:0:\"\";}");

MySQL Error : Duplicate entry 'quote_settings' for key 1
Error Number : 1062
Date : Friday, January 5th 2007 @ 01:08:28 PM
Script : http://www.newtestboard.twinshock.ne...=productimport
Referrer : http://www.newtestboard.twinshock.ne...?do=productadd
IP Address : XXXXXXXXX
Username : XXXXXXXXXXXXXX
Classname : vb_database

[TwinsForMe]

So I manually inserted the new fields into the tables and it seems to work fine.

How do I reduce the size of the quote area? It is takes up most of my screen.

[Amiga Harrison]

When uploading the files for QuoteIt! I noticed a file called quotemod.php was included that went into the modcp directory.

But on going into the modcp control panel there is no entry listed for quote moderation. How come?

If I directly link to the quotemod.php file it does load the moderators quote moderation screen. Should this therefore be linked from the modcp?

Also I have two other errors.

1, In firefox I can still not click the edit quote buttons directly. I need to middle click them to load the edit screen in a new tab. (I mentioned this problem before).

2, The other problem is a database error. If I select a quote category that currently doesn't have any quotes in it, I receive the following database error message:

Database error in vBulletin 3.6.4:

Invalid SQL:

					SELECT * FROM quoteratings
						WHERE quoteid IN () AND userid = 1;

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 ') AND userid = 1' at line 2
Error Number : 1064
Date         : Friday, January 5th 2007 @ 07:21:00 PM
Script       : forumurl/quotes.php?s=&all=&perpage=25&category%5B%5D=1&totaloperator=&total=&averageoperator=&average=&votesoperator=&votes=&do=list
Referrer     : forumurl/quotes.php