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

[zetetic]

Yeah, the few options I've tried to change didn't save either.

QuoteIt! 3.0.3 and vb 3.6.4

[Cap'n Steve]

Random quote problems fixed. To change the style you'll need to edit the css files. It's pretty simple and there's lots of tutorials on the Internet. The deletion error might be fixed; if you're still getting this, please let me know what version of mySQL you have.

jluerken - Yes, that should have been fixed a few versions ago, is it still showing up on your forum?

thepub - Try a reupload and reinstall, then please give me a link to your forum.

everyone with editing problems - I've enabled editing quotes on my forum. Register on monkeycrap.com, add a quote and then try editing it. I've tested editing with all those browsers, so it must be either a server or browser setting that's causing problems.

everyone with problems saving options - Run this query (replacing $TP with your table prefix) and tell me what it says:

SELECT * FROM $TPdatastore where title = "quote_settings"

If nothing shows up after the first query, run this one (replacing $TP with the table prefix again):

INSERT INTO $TPdatastore (title, data) VALUES ("quote_settings", "")

[zetetic]

The query resulted in this data field:

a:11:{s:14:"moderatequotes";i:0;s:16:"numbertomoderate";i:0;s:13:"enablecontext";i:1;s:17:"enableguestvoting";i:0;s:13:"requireauthor";i:1;s:10:"softdelete";i:0;s:16:"enablecategories";i:0;s:13:"continuousids";i:0;s:14:"showunapproved";i:0;s:12:"saveascookie";i:0;s:12:"reportemails";s:0:"";}

...and "2" in the "unserialize" column.

[Calash]

The edit issue is definetly not a browser problem. I have run tests using Firefox, IE6 and 7 on 2 systems and a virtual PC, clearing cookies and cache to make sure it is fine.

Firefox does not throw an error, but it does not do anything, IE 6 and 7 throw the error listed above.

Here is a list of my mods. It may help if other people who have the same problem post a list of theres to see if we have a common element.

FlashChat Integration 3.08 Integration of Flashchat and vBulletin 3.6  
Members who are using flashchat 4.37 Display members who are currently chatting in Flashchat.  
Members who have visited the forum 4.39 Display members who have visited the forum.  
Mini Navbar 1.0.4 Places a breadcrumb from the navbar on the bottom of a thread    
My Smilies VB 1.02 Custom user-uploaded smilies  
Restrict URLS 0.1 Restricts users from posting URLs until they have an admin defined number of posts.   
Smilies in Quickreply 3.6.x Show Smilies in Quickreply.   
vB Spell 0.10.2b vB Spell allows you to provide a spell checking window through your editor interface.    
vbgooglemap Member Edition by StonyArc 2.5.2 Display user location based on Google Maps API  
Zoints Profile System 2.1.4 The Zoints client forum profile linking system.     
Zoints SEO 2.2.2 The Zoints Search Engine Optimization Package  
Zoints Thread Tags 1.2.1 The Zoints thread tagging system    
[Sniper] - Mood Manager 1.2.3 Allows users to manage there mood

I am also still having the language bar issue. It goes away when I rebuild, but eventually comes back after editing the settings.

[Calash]

Ok, I figured out something.

I can not edit a post when the account I am using has Delete Own, Delete Others or Approve permissions in the primary group (Did not test other groups). With these 3 disabled I can click the edit button and get to the edit page. I am still seeing a Javascript error, but it disappears before I can see what the error is about. I see this same quick error when I test on your site.

[thepub]

Originally Posted by Cap'n Steve

thepub - Try a reupload and reinstall, then please give me a link to your forum.

same problem after reupload. Here's link to my forum http://www.theneighborhoodpub.com/index.php if you need assistance you can pm Jenn

[apokphp]

Originally Posted by Cap'n Steve

everyone with problems saving options - Run this query (replacing $TP with your table prefix) and tell me what it says:

This is the result:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'onlin19_vb.$TPdatastore' doesn't exist

[thepub]

I just want to say that I can't imagine being a coder because when you make a hack, addin, etc...it seems that you get 300 posts of whats wrong with it and not very many posts about how wonderful it is (at least not right away). With that said I do want to say thank you for making this incredible product, I know that when it finally gets working on my forum my community will be ecstatic. Thank you for caring about your work enough to help people with the errors and your time in making this.

*butt kissing is officially over*

[zetetic]

apokphp: Replace $TP with your table prefix and try the query again.

[dcsbclan]

Originally Posted by thepub

I just want to say that I can't imagine being a coder because when you make a hack, addin, etc...it seems that you get 300 posts of whats wrong with it and not very many posts about how wonderful it is (at least not right away). With that said I do want to say thank you for making this incredible product, I know that when it finally gets working on my forum my community will be ecstatic. Thank you for caring about your work enough to help people with the errors and your time in making this.

I fully agree, people jump quicker on the bits that dont work.

a:24:{s:15:"averageoperator";s:0:"";s:13:"totaloperator";s:0:"";s:11:"ageoperator";s:0:"";s:13:"votesoperator";s:0:"";s:7:"average";s:0:"";s:5:"total";s:0:"";s:3:"age";s:0:"";s:4:"days";s:0:"";s:9:"allowhtml";i:0;s:11:"allowbbcode";i:1;s:12:"allowsmilies";i:1;s:11:"allowimages";i:1;s:15:"allowlinebreaks";i:1;s:14:"moderatequotes";i:0;s:16:"numbertomoderate";i:0;s:13:"enablecontext";i:0;s:17:"enableguestvoting";i:0;s:13:"requireauthor";i:1;s:10:"softdelete";i:0;s:16:"enablecategories";i:0;s:13:"continuousids";i:0;s:14:"showunapproved";i:0;s:12:"saveascookie";i:0;s:12:"reportemails";s:0:"";}