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:

[Shazan]

I'm using vb 3.8.1 patch lvl 1 , I've done the first 3 steps correcly but I can't find the options inside the admin CP (step 4) and the quotes aren't showing in my home even though I tried adding "$quote_manual_template" above "<!-- main -->" in every template.

I'm not very good with Php so I don't understand why it's not working since I did everything right (uploads via ftp in the right folders and importing the other xml). I can even see "Random Quotes" in the list of pluging in Admin CP.

Is there some way to help me? Thx in advance.

[Warlord]

For anyone wondering how to figure out why quotes with apostrophes give you a SQL error...

Change a quote like this....

It's clobberin' time!

to

It\'s clobberin\' time!

and it will work just fine.

[imedic]

Originally Posted by tyteen4a03

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");

I think it can be done by changing phrases.

Or you mean different error message for same error?

Thanks for the edit, it worked, I get rid of the error but quotes are not showing (it shows only Q#: "" - )

I am reffering to put quotes above all errors forum gives and not on index page as this is too boring. And the benefit to this is it will put a smile on ppl face when they should be not happy of receiving an error or a warning from forum.

[mgurain]

Originally Posted by mgurain

looking for 4.x version of this useful hack ?

Any time ?

[ravenscape]

Originally Posted by 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.

I have the same problem. I'm getting around it temporarily with a direct link <www.myforum.com>/quotes.php

I would like for the quotes to show up on every page, not just the index page. Any idea how to make that work?

[blackberry]

supports images or just the txt?

[ravenscape]

Anyone know if this works with VB4? Of if there's a similar hack for VB4?

[ravenscape]

Originally Posted by blackberry

supports images or just the txt?

If you change the Quotes table element type from "text" to "medium text" then you can use html tags in your quotes to include images.

[ravenscape]

Also, anyone know how to include the random quotes on a vbadvanced portal?

[egexperiment626]

I love this mod so much! Just one little question... While editing the quotes, I ended up with to blank lines. Since there is no information I can't click to delete or edit and they are showing up in the mod as " " . How can I either remove those lines or edit them so I can enter a quote?