Rotating Quotes Database

[sheppardzwc]

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! :cool::up:

[marshal_ramdev]

thanks will use it !!

[sheppardzwc]

thanks will use it !!
Sure thing, glad you like it! :)

[Datok]

Thank you...

[Forum Lover]

Is it vb 4 friendly?

[sheppardzwc]

Thank you...

You're welcome. :)

Is it vb 4 friendly?

In v2 it will be, which should be released in a week or two.

[apiasto]

is it possible to add forum id manually,thnx

[glen290]

Getting a database error on installing this and on front page of my forums get error saying

"Parse error: syntax error, unexpected T_LNUMBER in /home/tenpinfo/public_html/indexold.php(594) : eval()'d code on line 33"

[sheppardzwc]

is it possible to add forum id manually,thnx

froumid manually? Can you elaborate? You want it to display in a specific forum only, is that what you're saying? Interesting.. might be an expansion for the future..

Getting a database error on installing this and on front page of my forums get error saying

"Parse error: syntax error, unexpected T_LNUMBER in /home/tenpinfo/public_html/indexold.php(594) : eval()'d code on line 33"

I've updated to v1.1 for the bugfix release for this bug above. There was a malformed conditional statement in the automatic template editor. Please upgrade. :)

[saadessa]

thank you ..installed

[sheppardzwc]

thank you ..installed
You're welcome. Hope you like it. :)

[mbc100]

i ike it
thank u

[yaku]

froumid manually? Can you elaborate? You want it to display in a specific forum only, is that what you're saying? Interesting.. might be an expansion for the future..



I've updated to v1.1 for the bugfix release for this bug above. There was a malformed conditional statement in the automatic template editor. Please upgrade. :)

I'd like that option as well.

Great add-on either way!

[glen290]

Getting this error on my admincp panel..


Database error in vBulletin 3.8.1:

Invalid SQL:
INSERT INTO quote (author, text) VALUES ('Me ', 'Blah Blah Blah');

MySQL Error : Table 'tenpinfo_forum.quote' doesn't exist
Error Number : 1146
Request Date : Monday, December 7th 2009 @ 09:02:36 AM
Error Date : Monday, December 7th 2009 @ 09:02:37 AM
Script : http://www.tenpinforums.co.uk/admincp/quotes.php?do=addnew
Referrer : http://www.tenpinforums.co.uk/admincp/quotes.php?do=add
IP Address : 213.31.11.80
Username : hitman
Classname : vB_Database
MySQL Version : 5.0.81-community


Can you help (by the way, the other fix worked, just this now.)

:o

[AndrewJZhao]

database error

EDIT: the error occurs when there is an apostrophe ' in the quote

[aaa007]

are we able to add our own quotes? why there is an error with the apostrope in the quote? any fixes?

[glen290]

i get the database error without any quotes...

[mgurain]

Hi sheppardzwc,

This is a very good mod, I installed it and it's useful.

I have one suggestion :
- to add a new feature that can import from xls or txt file a list, instead of entering one by one.
since I have a big list and I can copy it to excel for example or text file.

Can you do it please ?

Thanks,,

[mgurain]

Hi,

1. Can you please upgrade it to vb4.0 ?
2. Can you make (Adding Quotes) available to users (based on usergroup permissions) (not only adding quote using ACP)
And we can choose for usergroups if their additions will be under moderation ?

It's very needed.

Thanks,,

[aaa007]

would i be able to place the quote any where i want? or does it have to be at the top?

[chick]

would i be able to place the quote any where i want? or does it have to be at the top?


Yes just add the code tag he provides anywhere you like. I added mine at the bottom. This really is a nice script and works well... I just wish it would separate approve tags and unapproved... or there was a feature not to approve certain usergroups. All quotes, including mods and admin must be approved after submittal via the adminCP.

[mgurain]

Yes just add the code tag he provides anywhere you like. I added mine at the bottom. This really is a nice script and works well... I just wish it would separate approve tags and unapproved... or there was a feature not to approve certain usergroups. All quotes, including mods and admin must be approved after submittal via the adminCP.

Hi,
I searched my templates (styles) for the term ($quote_manual_template) but nothing found ?
Should I look for it somewhere else ?
Thanks,,

[mgurain]

Where is developer sheppardzwc ?
I add a suggestion:
- a refresh button beside the title using Ajax to reload another quote without refreshing the index.php

Thanks,,

[mgurain]

Also:
- allow usergroups to add quotes, and in ACP can put in moderation.
Thanks,,

[chick]

Works great I just wish there was a separate page all the quotes so if someone wanted to look at them all.

[talkncaasports]

nvm got it to work.

[sheppardzwc]

Hello all. Sorry about my non-responsiveness.. haven't been around lately and almost forgot about this mod.

Hi,

1. Can you please upgrade it to vb4.0 ?

I will update this to vB4.x when I get a stable version of it for 3.8.x.

2. Can you make (Adding Quotes) available to users (based on usergroup permissions) (not only adding quote using ACP)
And we can choose for usergroups if their additions will be under moderation ?

This is a very good idea! I'll see what I can do about adding quotes via public users and putting them into a custom queue.

Where is developer sheppardzwc ?
I add a suggestion:
- a refresh button beside the title using Ajax to reload another quote without refreshing the index.php

Thanks,,

Another great idea. I'll see what I can do here as well.

Works great I just wish there was a separate page all the quotes so if someone wanted to look at them all.

Once again, a great suggestion, and this will be definitely featured in the next update. :)

[Alien]

Terrific news that you're continuing to support this mod...

I'm looking forward to the vB4 version for a new site project I'm about done with!

I'm also looking forward to seeing them all on a page (with pagination preferred) and the ability for special usergroups (like premium members) to have quotes they enter randomly display on the forumhome. If I see those arrive, I'll happily donate your way too!

[mgurain]

Thank you very much sheppardzwc for your response to my PM, happy to see you are back to update this great mod.

[Zoomantics]

Hi folks,

Any idea as to why this is displaying?

$vbphrase[quote_forumhome_cat]
$quote_id \"$quote_text\" $quote_author

It is showing just above the QOTD.

Cheers

[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]

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


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]

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.

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

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 :D

[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.

[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]

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]

looking for 4.x version of this useful hack ?

Any time ?

[ravenscape]

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]

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?

[solarboy]

I can't uninstall this thing now. it gives me database error.

EDIT

I finally made it.. UNinstaled the thing by deleting the entry in the database table vb_product.

[Lewenhaupt]

is this compatible with vb 4?

[ozzy47]

Nope it won't.