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

[CtrlAltDel]

nice upgrade steve

[thepub]

not working and I just typed a long post explaining what the heck was going on and somehow lost it *grrr* I am having trouble installing this and there is no Quote it maintenance thing in my admin cp. Also, if I revert my templates (as suggested) to upgrade the quoter then I lose all of my other hacks and addins, is this the only way to do it?

[thepub]

I tried to import the product and got an error message saying:

Database error in vBulletin 3.6.2:

Invalid SQL:

INSERT INTO datastore
(title, data) VALUES
("quote_settings", "a:14:{s:13:\"enablecontext\";s:1:\"0\";s:14:\"mod eratequotes\";s:1:\"1\";s:16:\"numbertomoderate\"; s:1:\"0\";s:9:\"allowhtml\";i:0;s:11:\"allowbbcode \";i:1;s:12:\"allowsmilies\";i:1;s:11:\"allowimage s\";i:0;s:15:\"allowlinebreaks\";i:1;s:13:\"contin uousids\";i:1;s:12:\"saveascookie\";i:0;s:11:\"upg radedate\";i:1168224147;s:16:\"enablecategories\"; i:1;s:14:\"showunapproved\";i:1;s:12:\"reportemail s\";s:0:\"\";}");

MySQL Error : Duplicate entry 'quote_settings' for key 1
Error Number : 1062
Date : Sunday, January 7th 2007 @ 09:42:28 PM
Script : http://www.theneighborhoodpub.com/ad...=productimport
Referrer : http://www.theneighborhoodpub.com/ad...?do=productadd
IP Address : (deleted by thepub)
Username : (deleted by thepub)
Classname : vb_database

can you tell me what this means and why it's happening?

[Cap'n Steve]

Originally Posted by Defkalion

Is there a way to disable the module now that I do not have access to the admin cp? Any help would be appreciated. Thanks.

Add this to includes/config.php:

PHP Code:

define('DISABLE_HOOKS', 1); 


[Cap'n Steve]

All installation database errors should be fixed. The closing quotation mark is hidden in Internet Explorer on the random quote and the quote bbcodes until it learns to stop wandering off.

thepub - You should only revert the QuoteIt! templates, and you only need to do that if you customized them in an earlier version.

Calash - What version of IE is that? Check under Help -> About. Also, try shift + refresh and see if that changes anything.

Defkalion - Do you have any other mods installed? If you could post the code on and around that line number, that might help, since it seems to be different in older versions.

The latest version I can download is 3.6.1, can anyone confirm that this works on newer versions?

[Defkalion]

Ok I did a rebuild of the bitfields and now everything seems to be ok.

Many thanks for your quick reply Steve.

[GrabAssGirl]

Can you tell me why the quotations are located so far apart. The image on the right is located almost outside the quoteIt box. It's even doing this on your "live demo" site. Is there any way for me fix this? (don't know if this will work, but here's an image of what I am talking about...

[GrabAssGirl]

or, is there anyway to just do away with the images and have nothing but the quote there?

[Calash]

Both IE6 and IE7. Firefox does not throw a visible error but the edit button does not work.

I am also having the issue with the quotes being spaced way too much, but that appears to be a skin issue so I am going to work to resolve that via editing the templates.

I am also having a problem getting the vBadvanced module to work. The block just will not show up no matter what I do and I am not sure how to get any error messages to help diagnose the problem.

[zetetic]

Originally Posted by Cap'n Steve

All installation database errors should be fixed.

Doh! I got impatient yesterday so I dumped the quotes table to a flat file, then uninstalled and reinstalled QuoteIt. Unfortunately I can't seem to get the QuoteIt file import to work. I keep getting this error: "Invalid Query: Column Count Doesn't Match Value Count At Row 1".

Exactly what format does a file have to be in? I'm trying just quote, author, userid, context separated by semicolons. Sorry, I know just enough to be dangerous!

The latest version I can download is 3.6.1, can anyone confirm that this works on newer versions?

The clean install went fine on 3.6.4, but I can't be sure it worked until I get the import done.