vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Miscellaneous Hacks - Rotating Banner System (https://vborg.vbsupport.ru/showthread.php?t=188328)

emdee 12-14-2008 05:57 AM

the default/preloaded sample ads work ok, but when creating new ads and saving them im getting error:
any ideas why? please explain in detail (noob here)

PHP Code:

Database error in vBulletin 3.7.4:

Invalid SQL:
INSERT INTO rbs_banners (
            
id
            
name
            
url
            
image
            
text
            
startdate
            
enddate
            
notes
            
maximpressions
            
vertical
            
forumids,  
            
enabled,
            
forumhome,
            
clicktrack,
            
mails,
            
usergroups
            
VALUES (
            
NULL
            
'New banner'
            
'http://www.vbulletin.org'
            
''
            
'<a href=\"http://www.vbulletin.org\">vbulletin</a>'
            
'1229262600'
            
'1260798600'
            
''
            
'0'
            
'0'
            
''
            
'1'
            
'0'
            
'0',
            
'',  
            
'',
            );

MySQL Error   You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 35
Error Number  
1064
Request Date  
SundayDecember 14th 2008 01:51:52 AM
Error Date    
SundayDecember 14th 2008 01:51:52 AM
Script        
http://www.mydomain.com/forums/admincp/admin_rbs.php?do=edit
Referrer      http://www.mydomain.com/forums/admincp/admin_rbs.php?do=edit
IP Address    69.196.139.105
Username      
the_admin_username
Classname     
vB_Database
MySQL Version 
5.0.51a-community 


y2ksw 12-14-2008 06:36 PM

Quote:

Originally Posted by emdee (Post 1685043)
the default/preloaded sample ads work ok, but when creating new ads and saving them im getting error:
any ideas why? please explain in detail (noob here)

Thanks, bug is fixed in version 2.0.9 :)

Sunka 12-14-2008 06:45 PM

To update, just overwrite xml or also upload on forum folder all files?

y2ksw 12-14-2008 07:14 PM

Quote:

Originally Posted by Sunka (Post 1685386)
To update, just overwrite xml or also upload on forum folder all files?

admincp/admin_rbs.php, plus import new product for version update.

Sunka 12-14-2008 07:37 PM

OK.
I've overwrite admincp/admin_rbs.php, and overwrite product...
Everything look OK
Grazie form Croatia

Apolo. 12-15-2008 12:55 AM

Hi,

Just to report that the upgrade from 2.0.6 to 2.0.9 messed up the whole thing. The banners went like crazy, showing up at the top, even the vertical banners. It seems the upgrade is affecting the main template somehow.

I had to downgrade back to 2.0.6 to get this fixed.

Regards.

emdee 12-15-2008 05:42 AM

installed latest version 2.0.9
newly created ads are not showing. not getting an any errors, they are just not showing

im not sure if its the ad ID 4 and over ( ie ad id 4, 5, 6, 7, 8, etc.) that is the problme and are not showing , or if there is a differnet issue going on

later on:
i deleted all the preloaded ads
created new ones
and they are not showing

thanks

redlabour 12-18-2008 06:11 AM

Awesome Hack! Clicked Install! :)

y2ksw 12-18-2008 08:55 AM

Quote:

Originally Posted by emdee (Post 1685691)
installed latest version 2.0.9
newly created ads are not showing. not getting an any errors, they are just not showing

im not sure if its the ad ID 4 and over ( ie ad id 4, 5, 6, 7, 8, etc.) that is the problme and are not showing , or if there is a differnet issue going on

later on:
i deleted all the preloaded ads
created new ones
and they are not showing

thanks

Please restart :)

I believe you just installed the product and attend the ads to appear magically on your forums. Well, this isn't the way it works ;)

Install the product and keep the preinstalled ads. These are guaranteed to work everywhere. Then, write a message in a test area, and put @vbbanners@ inside the text. After saving, there should be a banner. If there isn't any, you are doing something wrong, e.g. check the spelling, verify you actually have active and enabled banners for the desired placeholder, refresh the page.

Once the ads start to show up, refine with user groups and forums selection, until you get what you want. Also you may add your own banners and copy some of the settings.

Then, add to your templates the @vbbanners@ placeholder, or the placeholder you have defined in the Rotating Banner System Options.

viper357 12-20-2008 07:11 PM

I have the vBIspy hack installed and the banners are not showing on this page, it just shows @vbbanners@, any idea on how to fix this? Not a major problem and I'm not too concerned about it, just if there's a quick fix to it then I would appreciate it, thanks :)

This is the link to the hack I am talking about
https://vborg.vbsupport.ru/showthread.php?t=125947

I'm running 3.6.12 and v2.0.6 of your hack.

y2ksw 12-20-2008 09:47 PM

Quote:

Originally Posted by viper357 (Post 1689707)
I have the vBIspy hack installed and the banners are not showing on this page, it just shows @vbbanners@, any idea on how to fix this? Not a major problem and I'm not too concerned about it, just if there's a quick fix to it then I would appreciate it, thanks :)

This is the link to the hack I am talking about
https://vborg.vbsupport.ru/showthread.php?t=125947

I'm running 3.6.12 and v2.0.6 of your hack.

You may define a different placeholder in the options, such as a HTML comment, e.g. <!--banner-->, which is then hidden to browsers, if the banner plugin isn't called for some reason. You will have to change the placeholder in the options and in the templates to make this work ;)

mexicanpizza 12-24-2008 04:53 AM

Great looking hack. I'm just starting to play with it. Is there a way to rotate different subsets of banners in different locations?

ie. @vbbanners_set1@ in location 1 and @vbbanners_set2@ in a different location?

y2ksw 12-27-2008 12:07 PM

Quote:

Originally Posted by mexicanpizza (Post 1692620)
Great looking hack. I'm just starting to play with it. Is there a way to rotate different subsets of banners in different locations?

ie. @vbbanners_set1@ in location 1 and @vbbanners_set2@ in a different location?

There are currently only two subsets supported, horizontal and vertical banners.

However, you may choose forums and usergroups, and thus refine your banner locations up to a high degree.

gbox master 12-28-2008 07:59 PM

just to let members know it works perfect just installed it and bingo
where to put the gif banner was not so clear but after inserting the @vbbanners@ @vbbanners@ code it was easy to find where the banner should be uploaded

perfect job guys thnx

MartynK 12-29-2008 11:16 PM

I have a number of normal banners and google setup as my vertical banner, the only issue I have is that when I enable the vertical banner, both sets swap locations.

Any idea what I am doing wrong ?

TimberFloorAu 12-29-2008 11:17 PM

will look into this, can the banners within the entire product be renamed so that it bypasses adblock etc ?

jlew24asu 12-30-2008 11:41 AM

I'd like to use this to rotate some images in my header. can I center this?

y2ksw 12-30-2008 08:42 PM

Quote:

Originally Posted by MartynK (Post 1696835)
I have a number of normal banners and google setup as my vertical banner, the only issue I have is that when I enable the vertical banner, both sets swap locations.

Any idea what I am doing wrong ?

Could you please ensure you have in the banner options (bottom of vbulletin option list) 2 different placeholders? If both are the same, the replacement may swap. I could not imagine other conflicts.

y2ksw 12-30-2008 08:46 PM

Quote:

Originally Posted by TimberFloorAu (Post 1696837)
will look into this, can the banners within the entire product be renamed so that it bypasses adblock etc ?

I'm not sure what you mean. If you intend to hide ads from ad blockers, this may be done only by intelligent scripts. I doubt however simple image ads would be rejected by any software I am aware of. Image banners are simply inserted into the templates, as if they were any kind of picture.

y2ksw 12-30-2008 08:47 PM

Quote:

Originally Posted by jlew24asu (Post 1697120)
I'd like to use this to rotate some images in my header. can I center this?

Sure. Use image banners and insert as the URL a # sign.

MartynK 12-30-2008 11:17 PM

Quote:

Originally Posted by y2ksw (Post 1697424)
Could you please ensure you have in the banner options (bottom of vbulletin option list) 2 different placeholders? If both are the same, the replacement may swap. I could not imagine other conflicts.

Yes, I have to seperate setting, the default ones. I want to put Google ads at in one place and my ads in another, but as soon as I enable the Google ads, they switch places.

Also, is there a way to stop someone getting the same advert displayed multiple times, one after the other ?

y2ksw 12-31-2008 07:55 PM

Quote:

Originally Posted by MartynK (Post 1697503)
Yes, I have to seperate setting, the default ones. I want to put Google ads at in one place and my ads in another, but as soon as I enable the Google ads, they switch places.

Also, is there a way to stop someone getting the same advert displayed multiple times, one after the other ?

Could you please attach a snapshot of each kind of ad (horizontal, vertical) you have been setting up and which creates the problem? I'm unable to reproduce the problem.

There is already a filter against showing one ad more than once on any page. If you have the same ad inserted multiple times in the database though, you will have to disable the ones you wish not to show, or apply different rules.

wmlvb 12-31-2008 10:30 PM

Hi

I tried to do a search but nothing showed up! Can someone tell me why I am not allowed to upload .gif with this banner rotator?

y2ksw 12-31-2008 11:52 PM

Quote:

Originally Posted by wmlvb (Post 1698199)
Hi

I tried to do a search but nothing showed up! Can someone tell me why I am not allowed to upload .gif with this banner rotator?

Can you please attach a snapshot of the banner settings?

meissenation 01-01-2009 06:50 PM

Great mod - thank you thank you thank you! I love the differentiation between horizontal and vertical!

meissenation 01-01-2009 07:28 PM

There's definitely a bug that MartynK is talking about.

I have not changed the Options - it still has @vbbanners@ and @vbbanners_vertical@ yet everwhere that I have @vbbanners@ it's pulling my Vertical images and everwhere that I have @vbbanners_vertical@ it's pulling my horizontal images. This ONLY started after I added @vbbanners_vertical@ - when I was only using @vbbanners@ it was showing the correct horizontal images.

Edit: Easiest fix is to switch the variables in the Banner Options:
Change Horizontal Placeholder to @vbbanners_vertical@
Change Vertical Placeholder to @vbbanners@

Now it's working correctly.

y2ksw 01-01-2009 09:34 PM

Quote:

Originally Posted by meissenation (Post 1698727)
There's definitely a bug that MartynK is talking about.

I have not changed the Options - it still has @vbbanners@ and @vbbanners_vertical@ yet everwhere that I have @vbbanners@ it's pulling my Vertical images and everwhere that I have @vbbanners_vertical@ it's pulling my horizontal images. This ONLY started after I added @vbbanners_vertical@ - when I was only using @vbbanners@ it was showing the correct horizontal images.

Edit: Easiest fix is to switch the variables in the Banner Options:
Change Horizontal Placeholder to @vbbanners_vertical@
Change Vertical Placeholder to @vbbanners@

Now it's working correctly.

I've tried yesterday to simulate and I didn't succeed in reproducing the problem. @vbbanners@ shows to me horizontal banners and @vbbanners_vertical@ vertical banners with no exception.

How many banners do you have of each kind?

y2ksw 01-01-2009 09:55 PM

I think I found the problem. From the moment you disable or delete the samples and add first vertical, then horizontal banners, you run into this problem.

Update on the way for the weekend.

meissenation 01-01-2009 10:31 PM

Ah - yeah that would probably be it. I actually deleted all the samples.

Here's my site with a demo of it. The horizontal banners under the MiFbody.com logo and the banners down the right side of the page are all done through this product. Works great - I really like the impressions and clicks logging!

http://www.mifbody.com/vbulletin/

wmlvb 01-01-2009 11:31 PM

1 Attachment(s)
Quote:

Originally Posted by y2ksw (Post 1698234)
Can you please attach a snapshot of the banner settings?


Image attached

TimberFloorAu 01-02-2009 12:01 AM

Quote:

Originally Posted by y2ksw (Post 1697428)
I'm not sure what you mean. If you intend to hide ads from ad blockers, this may be done only by intelligent scripts. I doubt however simple image ads would be rejected by any software I am aware of. Image banners are simply inserted into the templates, as if they were any kind of picture.

with Firefox AdBlockPlus which many users use, the generic code that prevents advertisements being displayed, is by reading the text of the source code, and blocking stuff like:

Advert
Advertisement
Ad
Banner

etc etc etc

The Realist 01-03-2009 08:53 PM

How do you change the name within the admincp for this hack. Mine is showing up at the bottom as follows:

*
[rbs_rotating_banner_system]
*

Exactly like the above and its throwing my page out.

I want it to read "RBS Banner System not the above.

Regards

y2ksw 01-03-2009 11:15 PM

Quote:

Originally Posted by wmlvb (Post 1698883)
Image attached

It appears to me you are using a different banner product ;)

y2ksw 01-03-2009 11:20 PM

Quote:

Originally Posted by TimberFloorAu (Post 1698894)
with Firefox AdBlockPlus which many users use, the generic code that prevents advertisements being displayed, is by reading the text of the source code, and blocking stuff like:

Advert
Advertisement
Ad
Banner

etc etc etc

Well, you may use a GIF image called pincopallino.gif and avoid names and labels which are automatically banned from AdBlockPlus. The replaced HTML is absolutely neutral and can't be identified. Unless of course you are using scripts which are recognized. In that case you may try to encode the contents, but a clever blocking script gets around that, too. ;)

y2ksw 01-03-2009 11:31 PM

Quote:

Originally Posted by The Realist (Post 1700684)
How do you change the name within the admincp for this hack. Mine is showing up at the bottom as follows:

*
[rbs_rotating_banner_system]
*

Exactly like the above and its throwing my page out.

I want it to read "RBS Banner System not the above.

Regards

If you search in the phrases for the rbs_rotating_banner_system variable and it's there, you may try to use the US translation with the appropriate text. If it isn't there, create the phrase in the GLOBAL space.

Generally, this problem has appeared relatively often and after long research it seems to depend on the language system which has a modified master language table, such as direct modifications or incorrect date/time assignment. It is particularily true on systems which host also translated boards and which language tables contain assignment errors or foreign phrases (e.g. vBulletin product phrases).

On some systems the problem has disappeared after reinstalling the Rotating Banner System product from scratch. If you have already banners inserted, make a backup of the rbs_banners table and restore after installation.

mongothetrucker 01-04-2009 05:11 PM

any code to change, or just FTP the new files in?

y2ksw 01-04-2009 08:45 PM

Quote:

Originally Posted by mongothetrucker (Post 1701507)
any code to change, or just FTP the new files in?

Just update the plugin - all code changes are there ;)

Sonyuserforum 01-09-2009 08:32 AM

Any known problems with vB 3.8.0 Gold?

y2ksw 01-09-2009 09:16 AM

Quote:

Originally Posted by Sonyuserforum (Post 1706064)
Any known problems with vB 3.8.0 Gold?

None yet ;)

Markos 01-09-2009 10:10 PM

thanks for this nice banner rotator


All times are GMT. The time now is 07:46 PM.

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.02773 seconds
  • Memory Usage 1,858KB
  • 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
  • (1)bbcode_php_printable
  • (19)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (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