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

[shane greer]

Any help appreciated guys. I cant even get into my admin now as it states..

Warning: Invalid argument supplied for foreach() in [path]includes\functions.php on line 3951

[Forgott3n]

Originally Posted by Cap'n Steve

Run this query and tell me what the output is (replace $TP with your table prefix):

[sql]SELECT * FROM $TPdatastore
WHERE title = "quote_settings"[/sql]

quote_settings  	a:26:{s:15:"showrandomquote";i:1;s:7:"ratings";i:2;s:16:"averagethreshold";s:0:"";s:14:"totalthreshold";s:0:"";s:14:"showquotecount";i:1;s:12:"enablebbcode";i:0;s:14:"showquotestats";i:1;s:7:"version";s:4:"3.12";s:12:"freshinstall";i:0;s:12:"usemegaquery";i:0;s:20:"randomquotefrequency";s:5:"every";s:11:"cachebbcode";i:0;s:14:"randomcategory";i:0;s:13:"enablecontext";i:0;s:13:"languagecount";s:1:"1";s:12:"reportquotes";i:0;s:14:"moderatequotes";i:1;s:16:"numbertomoderate";i:10;s:17:"enableguestvoting";i:0;s:13:"requireauthor";i:0;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:"";}  	0

[shane greer]

Upload everything in the upload directory to your forum directory.

Go to your administrator control panel and select "Plugin System", then "Manage Products", then "Add/Import Product". Follow the instructions to import product-quoteit.xml. If you have a previous version of QuoteIt! installed, be sure to set "Allow Overwrite" to yes.

It was at this point when everything crashed.

I will run a query like you asked.

[shane greer]

Im completely new to this. what exactly am I to type in.... what is the code below?

Do I type in SELECT * FROM $TPdatastore
WHERE title = "quote_settings"

And replace $TP with my database name?

Originally Posted by Forgott3n

quote_settings  	a:26:{s:15:"showrandomquote";i:1;s:7:"ratings";i:2;s:16:"averagethreshold";s:0:"";s:14:"totalthreshold";s:0:"";s:14:"showquotecount";i:1;s:12:"enablebbcode";i:0;s:14:"showquotestats";i:1;s:7:"version";s:4:"3.12";s:12:"freshinstall";i:0;s:12:"usemegaquery";i:0;s:20:"randomquotefrequency";s:5:"every";s:11:"cachebbcode";i:0;s:14:"randomcategory";i:0;s:13:"enablecontext";i:0;s:13:"languagecount";s:1:"1";s:12:"reportquotes";i:0;s:14:"moderatequotes";i:1;s:16:"numbertomoderate";i:10;s:17:"enableguestvoting";i:0;s:13:"requireauthor";i:0;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:"";}  	0

[shane greer]

Ok I deleted the files via FTP and reuploaded them.

Im getting this error...

Warning: Invalid argument supplied for foreach() in [path]includes\functions.php on line 3951

when I try to enter my admincp and also at the top of my forum.

[shane greer]

Any help appreciated guys.

I know some folk had similar problems... any of you able to help a fellow vB user out?

[Forgott3n]

Originally Posted by shane greer

Im completely new to this. what exactly am I to type in.... what is the code below?

Do I type in SELECT * FROM $TPdatastore
WHERE title = "quote_settings"

And replace $TP with my database name?

Sorry Shane, that support was directed at me.

I am unsure on how to proceed with your issue. Did you backup before installing QuoteIt? Your best bet is to contact vbulletin.com member support.

[shane greer]

Ok thanks. Do the guys over at vbulletin.com offer support for this mod?

Cap'n Steve already answered someone else with this problem... Im not sure where Im to put this.

Originally Posted by Defkalion
Is there a way to disable the module now that I do not have access to the admin cp? Any help would be appreciated. Thanks.

Add this to includes/config.php:
PHP Code:
define('DISABLE_HOOKS', 1);

[Forgott3n]

Originally Posted by shane greer

Ok thanks. Do the guys over at vbulletin.com offer support for this mod?

Cap'n Steve already answered someone else with this problem... Im not sure where Im to put this.

Ok, what you need to do is edit your config.php file which is located at yoursite.com/forumpath/includes/config.php

add

define('DISABLE_HOOKS', 1);

to the end of the file.

[Cap'n Steve]

shane greer - Sorry, I've been busy. Glad to see you found the solution. Once you're able to get back in the admincp, you can reinstall the product.

Forgott3n - It seems to be saved properly. Are you sure the quotes aren't going into the moderation queue? A link to your site would also be helpful.