vb.org Archive
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Forum Home Enhancements - Rotating Quotes Database (https://vborg.vbsupport.ru/showthread.php?t=229467)

sheppardzwc 12-03-2009 10:00 PM
Rotating Quotes Database
 
1 Attachment(s)
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:

Code:
<!-- 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 12-04-2009 02:22 AM
thanks will use it !!

sheppardzwc 12-04-2009 02:29 AM
Quote:
Originally Posted by marshal_ramdev (Post 1925027)
thanks will use it !!
Sure thing, glad you like it! :)

Datok 12-04-2009 05:26 AM
Thank you...

Forum Lover 12-04-2009 05:33 AM
Is it vb 4 friendly?

sheppardzwc 12-04-2009 07:50 AM
Quote:
Originally Posted by Datok (Post 1925072)
Thank you...
You're welcome. :)

Quote:
Originally Posted by Forum Lover (Post 1925074)
Is it vb 4 friendly?
In v2 it will be, which should be released in a week or two.

apiasto 12-04-2009 11:21 AM
is it possible to add forum id manually,thnx

glen290 12-04-2009 01:46 PM
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 12-04-2009 02:14 PM
Quote:
Originally Posted by apiasto (Post 1925179)
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..

Quote:
Originally Posted by glen290 (Post 1925240)
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 12-04-2009 05:07 PM
thank you ..installed

sheppardzwc 12-05-2009 03:59 AM
Quote:
Originally Posted by saadessa (Post 1925322)
thank you ..installed
You're welcome. Hope you like it. :)

mbc100 12-06-2009 10:20 AM
i ike it
thank u

yaku 12-07-2009 04:48 AM
Quote:
Originally Posted by sheppardzwc (Post 1925248)
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 12-07-2009 01:05 PM
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/adminc....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 12-16-2009 07:06 AM
database error

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

aaa007 12-16-2009 07:50 AM
are we able to add our own quotes? why there is an error with the apostrope in the quote? any fixes?

glen290 12-16-2009 01:28 PM
i get the database error without any quotes...

mgurain 12-16-2009 01:35 PM
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 12-24-2009 09:39 AM
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 12-27-2009 03:22 PM
would i be able to place the quote any where i want? or does it have to be at the top?

chick 12-27-2009 03:42 PM
Quote:
Originally Posted by aaa007 (Post 1939485)
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 12-28-2009 06:44 AM
Quote:
Originally Posted by chick (Post 1939503)
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 01-04-2010 05:51 AM
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 01-21-2010 04:17 AM
Also:
- allow usergroups to add quotes, and in ACP can put in moderation.
Thanks,,

chick 01-21-2010 08:11 PM
Works great I just wish there was a separate page all the quotes so if someone wanted to look at them all.

talkncaasports 01-22-2010 04:27 AM
nvm got it to work.

sheppardzwc 01-27-2010 08:39 PM
Hello all. Sorry about my non-responsiveness.. haven't been around lately and almost forgot about this mod.

Quote:
Originally Posted by mgurain (Post 1937142)
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.

Quote:
Originally Posted by mgurain (Post 1937142)
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.

Quote:
Originally Posted by mgurain (Post 1946654)
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.

Quote:
Originally Posted by chick (Post 1962741)
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 01-27-2010 09:33 PM
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 01-28-2010 11:14 AM
Thank you very much sheppardzwc for your response to my PM, happy to see you are back to update this great mod.

Zoomantics 01-28-2010 09:40 PM
Hi folks,

Any idea as to why this is displaying?

Quote:
$vbphrase[quote_forumhome_cat]
$quote_id \"$quote_text\" $quote_author
It is showing just above the QOTD.

Cheers

Zoomantics 01-28-2010 10:01 PM
Quote:
Originally Posted by Zoomantics (Post 1969327)
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 07-05-2010 03:29 PM
Anyway it could work with QdbS(www.qdbs.org)? Thanks Zach ;D

klaush 07-05-2010 05:39 PM
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 07-27-2010 07:44 PM
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 09-04-2010 12:20 AM
Quote:
Originally Posted by klaush (Post 2064904)
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:
Code:
$quote_list_sql = $db->query_read("SELECT * FROM quote ORDER BY id ASC");
Replace EVERY MATCH with:
Code:
$quote_list_sql = $db->query_read("SELECT * FROM ". TABLE_PREFIX . "quote ORDER BY id ASC");
Quote:
Originally Posted by imedic (Post 2075470)
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 10-14-2010 06:32 AM
Is this available for VB 4.06? I can't find any quotes widget =(

mgurain 11-11-2010 03:03 AM
looking for 4.x version of this useful hack ?

sheppardzwc 11-13-2010 01:14 PM
Quote:
Originally Posted by imedic (Post 2075470)
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.
Quote:
Originally Posted by vivamexico55 (Post 2110004)
Is this available for VB 4.06? I can't find any quotes widget =(
Quote:
Originally Posted by mgurain (Post 2120423)
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 11-23-2010 05:50 AM
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 11-24-2010 02:16 PM
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.


All times are GMT. The time now is 06:15 PM.
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02857 seconds
  • Memory Usage 1,836KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (20)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete