Forum Home Enhancements - Rotating Quotes Database

Rotating Quotes Database

Info
An easy to use quote cycling system that displays on your FORUMHOME. Put in a bunch of Windows jokes to beat around Bill Gates or throw a few of those old inspirational up-lifters to help brighten your user's day!

Features
- Completely lightweight, installs in under 5 seconds.
- Insanely customizable, you can add any quote or joke in under a minute!
- Uses MySQL to cycle through quotes, no extra dependencies or CSS to install.
- Options to display just the quote, the author and the quote, or the quote number, author, and the quote.

Installation

1. Download product-rand_quote.zip.
2. Upload admincp/quotes.php and includes/xml/cpnav-rand_quote.xml.
3. Import product-rand_quote.xml.
4. You can configure it by going to AdminCP > vBOptions > Quote Database
5. The management page can be found in the Quote Database dropdown above "Styles & Templates."
6. All done!

If you have customized your FORUMHOME template, look for:

<!-- main -->

and add right above it: $quote_manual_template

Changelog

v1.0
- Initial Release
v1.1
- Bugfix for "T_LNUMBER" or your forumhome page has "an unsupported forum of compression."

Like this mod? Click INSTALL for me! :up:

[Zoomantics]

Originally Posted by Zoomantics

Hi folks,

Any idea as to why this is displaying?



It is showing just above the QOTD.

Cheers

Never mind that, I fixed it.

Can someone point me to the right place to add the QOTD to the search results as well.
It only appears on the homepage currently

[tyteen4a03]

Anyway it could work with QdbS(www.qdbs.org)? Thanks Zach ;D

[klaush]

Invalid SQL:
SELECT * FROM quote ORDER BY id ASC;

MySQL-Fehler : Table 'blabla_bla.quote' doesn't exist

In deed, the prefix "vb_" before the "qoute" is missing.

Any idea how to fix this?

[imedic]

Same error to me too. Hope someone correct it.

I was planning to use this in a more creative way:
Not to display the quotes in forum home but in all errors the forum gives, in redirect page , or other forum notification to users making boring errors & redirect pages much more interesting hence forum experience more interesting.

Probably a nice expansion of this mode if u can add from admin cp the insertion of quotes in all errors and redirect pages.

[tyteen4a03]

Originally Posted by klaush

Invalid SQL:
SELECT * FROM quote ORDER BY id ASC;

MySQL-Fehler : Table 'blabla_bla.quote' doesn't exist

In deed, the prefix "vb_" before the "qoute" is missing.

Any idea how to fix this?

Find:

$quote_list_sql = $db->query_read("SELECT * FROM quote ORDER BY id ASC");

Replace EVERY MATCH with:

$quote_list_sql = $db->query_read("SELECT * FROM ". TABLE_PREFIX . "quote ORDER BY id ASC");

Originally Posted by imedic

Same error to me too. Hope someone correct it.

I was planning to use this in a more creative way:
Not to display the quotes in forum home but in all errors the forum gives, in redirect page , or other forum notification to users making boring errors & redirect pages much more interesting hence forum experience more interesting.

Probably a nice expansion of this mode if u can add from admin cp the insertion of quotes in all errors and redirect pages.

I think it can be done by changing phrases.

Or you mean different error message for same error?

[vivamexico55]

Is this available for VB 4.06? I can't find any quotes widget =(

[mgurain]

looking for 4.x version of this useful hack ?

[sheppardzwc]

Originally Posted by imedic

Same error to me too. Hope someone correct it.

I was planning to use this in a more creative way:
Not to display the quotes in forum home but in all errors the forum gives, in redirect page , or other forum notification to users making boring errors & redirect pages much more interesting hence forum experience more interesting.

Probably a nice expansion of this mode if u can add from admin cp the insertion of quotes in all errors and redirect pages.

Originally Posted by vivamexico55

Is this available for VB 4.06? I can't find any quotes widget =(

Originally Posted by mgurain

looking for 4.x version of this useful hack ?

I'll be working on an update to vB4 and a better vB3 version in the future, keep checking around!

[FreshFroot]

Looks good. Will keep an eye on this, as I may want to use it soon.

Thanks and hope to see a new update for vB3

[killa seven]

I installed this but for some reason the database drop down menu is not showing up on the left side above styles and templates, do you know why? it is displaying on the forums homes but i cant see how to change the quotes.