vb.org Archive - Miscellaneous Hacks - Rotating Banner System

Page 21 of 289

« First

121

Last »

Show 40 post(s) from this thread on one page

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 syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 35

Error Number  : 1064

Request Date  : Sunday, December 14th 2008 @ 01:51:52 AM

Error Date    : Sunday, December 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)

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.

All times are GMT. The time now is 05:25 AM.

Page 21 of 289

« First

121

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02747 seconds Memory Usage 1,763KB 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 (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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
Messages: