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

[Sadie Frost]

Originally Posted by Alien

Hey!

I went over the table structure carefully, and I have everything you showed above in your table structure EXCEPT for this in the quotes table:

date => INT (10) UNSIGNED NOT NULL DEFAULT 0
views => INT (10) UNSIGNED NOT NULL DEFAULT 0
categoryid => INT (10) UNSIGNED DEFAULT NULL
postid => INT (10) UNSIGNED DEFAULT NULL

I upgraded from the 3.5 version (version 2.1 it says in the Product Manager?) on 5 boards (lol), and it worked fine on 4 of them. The fifth though I seem to be having the same problem as Alien did above (page 9/10 of this thread).

I tried to add the missing fields to the tables but I get this error in phpmyadmin:

ALTER TABLE `quotes` ADD `date` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
ADD `views` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
ADD `categoryid` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
ADD `postid` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0'

MySQL said:

#1060 - Duplicate column name 'quoteid'

I am using MySql version 4.1.21 there. I also get the same errors if I try to use the latest version from the 3.5 version thread. I also did choose the allow overwrite.

Does anyone have any ideas for me? Is it jsut a MySQL version problem?

Also I know that I read this somewhere but I just read through the thread again and couldn't find it, so I'm sorry. But all my dates on my quotes are "12-31-1969"? Is that just because I've just installed the new version?

Thanks

[Cap'n Steve]

ubblite - I'm not sure if you saw the post in the other thread, but could you tell me how many languages you normally have, or even better, give me a link? I can't really test the Photopost problem, but I'll take another look.

Sadie Frost - Try adding each column individually. Try using the phpMyAdmin interface instead of typing it in manually ("add new field" at the bottom of the page when viewing table structure). The date problem is because of the incomplete install, but it will default to the date you installed it when the quote doesn't have a date stored (which is all of the ones added before this version).

I'd love to know what's causing that problem, but I have no clues so far.

[Sadie Frost]

Hi Cap'n Thanks for the response I really do love this hack, and have been using it for a while. It's so odd that out of five upgrades done exactly the same at the same time that only one would have a problem when the rest were fine.

The one with the problems is on a different server than the other four, but both are using MySql 4.1.21.

The way I tried to add the new fields before was through the phpmyadmin interface. I tried doing them one by one and trying to do it by just running a query for it, but I still get that duplicate quoteid column message.

Weird! lol

[Cap'n Steve]

Well, the only thing I can think of is to make a backup of your quotes and quoteratings tables, delete them, reimport the product, and then restore the backup (making sure you don't have it add any drop table statements when you export).

[Cap'n Steve]

I just uploaded a new version with a few small improvements, including improving the style, especially on vBadvanced pages and especially in Internet Explorer.

[turiel]

There seems to be a problem with installing it - the Importing Product progress bar seems to go on 'forever' (by forever I mean 15 minutes before I stopped it). Maybe it normally takes that long, I just haven't seen a mod do that before. I'm using the latest vBB and mod.

[BaconDelight]

Originally Posted by Cap'n Steve

I just uploaded a new version with a few small improvements, including improving the style, especially on vBadvanced pages and especially in Internet Explorer.

It's certainly an improvement. Thanks!

BTW, I'm working on adding a feature to this, if I get it working I'll pass my code on to you if you want to include it in a future release. I'm trying to add a redirect link back to the thread after you've submitted a post to quotes. A couple users have said they're annoyed that it kinda dead-ends at the page displaying the submitted quote.

[jw00dy]

Thanks, upgrade worked flawless.

Looks a lot better now too.

[Cap'n Steve]

turiel - Just try importing it again. Do you have a lot of styles? Updating those seems to take the longest.

BaconDelight - Good idea.

[confus]

eep installed it without testing thinking its just a small quick simple hack and it killed stuff
trying to access admincp or the vbadvanced index page gave php errors (attached)

its possible it was the same problem as mamashid had heh

I had to go to /admincp/plugin.php and untick all the boxes for this hack, then everything ran again and I uninstalled the hack

While it was my fault it was bad consequences for a minor error, in my rush of getting it done so I could do something else I uploaded the files to the main dir, not the forums dir, then installed the xml file
xml files couldn't find the files and gave me those errors