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

[Cap'n Steve]

Still looking at the language chooser and vBadvanced bugs.

yonglvnv - It's not reading the permissions for some reason. Did you still have includes/xml/bitfield_quoteit.xml on the server?

soulface - That's right. The date wasn't stored in earlier versions so it uses the date you installed it as the default date.

Alien - I was afraid of that. I have no idea what your problem is, but it's not modifying or adding columns. I'll keep searching for the reason behind that, but until then you have two options: Try and get your host to upgrade MySQL (I'm not sure if that will help) or modify the tables yourself through phpMyAdmin. Here's the structure for each table (column name is on the left, definition after the =>):

quotes

quoteid => INT (10) UNSIGNED NOT NULL AUTO_INCREMENT
quote => MEDIUMTEXT NOT NULL
author => VARCHAR (100) DEFAULT NULL
userid => INT (10) UNSIGNED NOT NULL DEFAULT 0
approved => TINYINT (1) UNSIGNED NOT NULL DEFAULT 0
votes => INT (10) UNSIGNED NOT NULL DEFAULT 0
rating => INT (10) NOT NULL DEFAULT 0
average => FLOAT (3, 2) NOT NULL DEFAULT 0.00
context => VARCHAR (250) DEFAULT NULL
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

quoteratings

userid => INT (10) UNSIGNED NOT NULL
quoteid => INT (10) UNSIGNED NOT NULL
rating => TINYINT (1) NOT NULL

guestquoteratings

ip => VARCHAR (15) NOT NULL
quoteid => INT (10) UNSIGNED NOT NULL
date => INT (10) UNSIGNED NOT NULL
rating => TINYINT (1) NOT NULL

quotecategories

categoryid => INT (10) UNSIGNED NOT NULL AUTO_INCREMENT
title => VARCHAR (64) NOT NULL
description => VARCHAR (250) DEFAULT NULL
public => TINYINT (1) NOT NULL DEFAULT 1
displayorder => SMALLINT (5) SIGNED NOT NULL DEFAULT 0

Here are the keys (table name on the left, keys after the =>):

quotes => PRIMARY KEY (quoteid), KEY (approved), KEY (rating), KEY (average)
quoteratings => PRIMARY KEY (quoteid, userid)
guestquoteratings => PRIMARY KEY (quoteid, ip)
quotecategories => PRIMARY KEY (categoryid)

And finally, these columns need to be added to other tables:

user

quoteitoptions => INT(10) UNSIGNED NOT NULL DEFAULT 0
lastquotesvisit => INT(10) UNSIGNED NOT NULL DEFAULT 0
quotecount => INT(10) UNSIGNED NOT NULL DEFAULT 0

usergroup

quoteitpermissions => INT(10) UNSIGNED NOT NULL DEFAULT 2567

[Calash]

The latest download has resolved the issue with the edit button, it now does an AJAX edit.

I still have the language bar issue. Normally I only have 1 language (English) and the drop down selection is not visible. When I install QuoteIT the drop-down shows up and has a random selection (I have seen A, E, and blank). I will leave it up so you can take a look.

I am also having issues with the vBadvanced module. I set it up per the instructions but it does not show up. I have not had time to trouble shoot yet, but if you can give me some common problem areas to look at it would help

Thank you for making the mod...it is something I thought I was going to lose when I moved to vB.

[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

[Calash]

The vBadvamced module problem seems to be related to permisisions. If I edit the get_random_quote() function and remove the "canviewquote" check it works fine. I need to fix the layout but that is a skin issue and not a QuoteIT issue.

May be off on the names, I am at work ATM.

[Alien]

Okay, added the entries above and so far so good without mysql errors in the admincp..

I'll also upgrade to the latest version you posted shortly.

[zetetic]

Sorry Cap'n, I haven't had a chance to work on this for the last couple days so I can't give any feedback about the current revision. However, would you mind updating the filename or OP with the current rev number when you release new revisions? I'd like to make sure I grab the latest.

Thanks again for all your work on this.

[thepub]

so I have to reinstall in order to get the edit button to look normal? I finally got it installed and showing, but it's very large on the forum index and the edit button looks like an edit button on the board.

[thepub]

this may be the dumbest question ever but where exactly is the modules/moderate.php at so I can edit the file according to the vbadvanced installation instructions?

[zetetic]

The modules directory should be in your forum root. So like yoursite.com/forum/modules/

[Cap'n Steve]

zetetic - It's at the top, right under the title, but the easiest way to check is to go to "Manage Products" in your admincp and then there'll be a "Check Version" option in the list next to QuoteIt!

thepub - That module and the directory itself come with vBadvanced. I'm not sure what you mean about the edit button. The actual image is too large? You'll have to edit the quote_listbit template to change the size.