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

[user02934123123]

Originally Posted by monForum

*2: (more urgent): When 'context' is enabled, and the postbit template is modified to include a 'submit quote' button on each post, the automatic convert-thread-to-context feature does not work properly. The hack properly inserts its text ("Posted in thread x..."), with appropriate link, into the 'context' field on the submission form, and it is likewise visible in the preview screen; but once the 'submit' button is pressed, the context field is truncated, so that when one views the pending quote in the moderation queue, the context field reads simply 'Posted in', with no further information (i.e. the link to the thread has been entirely lost). This is a series bug, as the end-result is bizarrely truncated quote submissions -- for the time being I've had to disable the 'context' feature altogether to prevent this. An urgent fix would be most appreciated.

Originally Posted by Cap'n Steve

2. That's strange. Do you have bbcode enabled for quotes?

Yes, indeed. BBCode for quotes is enabled (while HTML is turned off). It seems that there is some error in passing the code through the submission form to the actualy dB; as I say, the link appears in the 'preview' screen, if used; but once you click 'submit', the link is lost (removed) on submission, and the submitted quote appears without it in the moderation queue.

I've tested this on IE6 and IE7, as well as the newest release of Firefox, and the same issue occurs - so that would seem to rule out it being a browser problem.

For information, this is on vB 3.6.5.

With thanks in advance for further assistance.

[deb0]

Getting the following error attempting to install this latest version of Quoteit:

Database error in vBulletin 3.6.4:

Invalid SQL:

ALTER TABLE quotes
MODIFY COLUMN quoteid INT (10) UNSIGNED NOT NULL AUTO_INCREMENT;

MySQL Error : Duplicate column name 'quoteid'
Error Number : 1060

Background information:

I was previously running quoteit version 1.2 for VB 3.07. I upgraded board to 3.64. I am trying to upgrade the Quoteit system now to the latest version and I keep getting this error.

HELP!

[Cap'n Steve]

monForum - Does the link problem happen on every thread? It's possible the title is too long to fit in the database. I still don't get the quick language chooser problem. Could you export your language and post it so I can see what's different about it?

deb0 - Try following these instructions to add each column by hand. If that doesn't work, do this instead. Any information about your database would be helpful, I'm still trying to figure out why that happens sometimes.

[ZippySLC]

Tried to install this but was unable to import the plugin. Apache error log says:

[Wed Apr 04 08:44:52 2007] [error] [client 141.153.160.232] PHP Fatal error: Cannot redeclare class fPluginServices in /home/bruset/websites/forums.njpinebarrens.com/public_html/jvb_fservices.php on line 12, referer: http://forums.njpinebarrens.com/admi...?do=productadd

[rburns]

Originally Posted by Cap'n Steve

digital3 - Well, judging by the symptoms, either something went wrong during the upload or your server is misconfigured somehow.

ChiliVB - quoteit_ie_lt_7.css is used by Internet Explorer versions 6 and lower, quoteit_ie_all.css is used by all versions of Internet Explorer, and quoteit_main.css is used by all browsers. If you want to add a class to the submitter section, you'll have to edit the quote_listbit template.

rburns - The BBCode is kind of complicated to prevent too many queries on a page. You'll have to edit includes/functions_quoteit.php. In that file, find

PHP Code:

        $tag_list['no_option']['quotes'] = array( 


and replace that with

PHP Code:

        $tag_list['no_option']['law'] = array( 


In the same file, find

PHP Code:

        return '[quotes]' . $quoteid . '[/quotes]'; 


and replace that with

PHP Code:

        return '[law]' . $quoteid . '[/law]'; 


To change the categoryid, you currently need to do it directly in the database through phpMyAdmin or something similar. If you want it to be a decimal, you'll have to add some code to convert it like you demonstrated. That might end up being a little difficult, so I'd suggest just including the number in the title. Users aren't really supposed to be paying attention to the id anyway.

I'm not sure what you mean about the reply dropdown. Are you talking about choosing a category when replying to a post?

Cap'n,

Thanks for that, yes a drop down box with the categories on post reply (both quick and advanced) is what I was wanting.

I agree about the catids, that's a better idea.

[Cap'n Steve]

ZippySLC - It looks like that's an error with some Joomla plugin. You'll have to ask wherever you got that addon.

rburns - So what do want to happen when they post? Do you want the quote from that category added to the post?

[thepub]

I am having some trouble, my quoter is not visible at all but I have the ability to submit, approve, moderate quotes through my admin cp and people can submit quotes but the actual quoter itself is not showing up anywhere. This is a recent problem and I'm not sure what to do to fix it.

[Cap'n Steve]

What did you change when this started happening? First, it doesn't look like you have all the latest files. Make sure you do and then try re-saving your QuoteIt! Options.

[thepub]

Originally Posted by Cap'n Steve

What did you change when this started happening? First, it doesn't look like you have all the latest files. Make sure you do and then try re-saving your QuoteIt! Options.

ok I reinstalled it and so far it looks good except the bb codes do not show up and I have them enabled. What can I do to fix that?

[Cap'n Steve]

Try saving the Quote Parsing Options again.