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]

Thanks for sticking with me guys, I've had this on my live forum for about three months and only got a few bugs reported. And I swear the editing works in all those browsers when I do it.

thepub - Did you have the old version of QuoteIt! installed? It looks like you need to revert your quote_listbit and quote_randomquote templates.

apokphp - You need to replace $TP with your table prefix (or delete it if you don't have one) and try it again.

Calash - I don't see the quick language chooser on the forum in your signature, is it still happening there?

everyone with editing problems - Edit clientscript/quoteit_moderation.js. Find this:

				var author = agent.handler.responseXML.documentElement.getElementsByTagName('author')[0].firstChild.data;

Above that, add this:

alert(agent.handler.responseText);

Then let me know what the popup says when you try to edit a quote (you might want to post a screenshot of it).

everyone with option saving problems - Try running this query and see if that fixes it (replace $TP with your table prefix):

UPDATE $TPdatastore SET unserialize = 0 WHERE title = "quote_settings"

[Firen]

I just tried adding the extra code to get the editing to work. This is the error message I got:

Attachment 58873

[yonglvnv]

Originally Posted by Cap'n Steve

everyone with option saving problems - Try running this query and see if that fixes it (replace $TP with your table prefix):

UPDATE $TPdatastore SET unserialize = 0 WHERE title = "quote_settings"

Return code was "Affected Rows: 1 (0s)"
This worked for me, now able to save settings. thanks.

[Cap'n Steve]

A new version has been uploaded. The Quick Language Chooser should be fixed on all versions finally, and editing quotes is probably fixed (I hope).

[yonglvnv]

Great mod! Thanks and new version installed. I can confirm language selection issue is gone (for me), and no error message displayed when importing the xml file. I just have a problem with formating when displaying from a vba block. And that is, everything, including collapse icon, is aligned to the left and in the next line.(see attached). In addition, there seems to be no spacing between this block and one below it. Otherwise, everything looks great, including edit and delete function. Which template and where can I modify to change the alignment? Thanks, it's a great mod!

[zetetic]

It's looking great, Cap'n Steve. I ran the query to fix the problem saving options and that worked, then I installed the latest version and everything else seems to work too. I don't have time to test it thoroughly, but right now I'd say it looks great.

Thanks for all your hard work!

Oh, one thing. Did you mean to move "Random Quote Options" under "Quote Display Options" in the acp? I can change it on mine, but just wondering if it was an accident.

[dcsbclan]

All working now Steve! Thankyou for putting up with us and sticking with getting it working.

Edit: Is there a page to view all quotes without having to have them displayed on your forum? All I get when I go to quote.php is to add a quote.

[Calash]

The Language bar comes back whenever I edit the QuoteIT settings. It goes away by rebuilding the languages. I will leave it there for the moment.

Attached is the popup you asked for. It matches what was already posted.

[BaconDelight]

Originally Posted by dcsbclan

All working now Steve! Thankyou for putting up with us and sticking with getting it working.

Edit: Is there a page to view all quotes without having to have them displayed on your forum? All I get when I go to quote.php is to add a quote.

quotes.php?do=list

I'll update to the latest version in a minute here and let you know how it's working.

Thanks for the efforts, Cap'n

[BaconDelight]

Edit's working great. Delete is working-ish (it deletes, no database error, but the pop up confirmation box is still blank except for the OK and Cancel buttons).

Formatting is still ugly on IE, but I suppose I can mess with the template/css until it's right.

And one minor issue, not a big deal at all as it's a total edge-case, but if you are in the list view and there's only 1 quote in the database, after you delete it a message pops up that says "no quotes matched your search" and the quote remains displayed. I thought it meant the quote wasn't deleted, but a refresh showed that it was gone, it just was unable to refresh the view with an empty database. Like I said, not a big deal at all sicne it's unlikely any of us will be deleting ALL the quotes in a live install, but as a sometimes-programmer myself I know that those little edge-case bugs irritate me in my own code so I thought I'd let you know.

Once I get the IE formatting sorted out I'm going live with this. My users will be thrilled, thanks!