Miscellaneous Hacks - Rotating Banner System

With the Rotating Banner System software, you may publish literally anywhere standard banners and advertising, with no restriction but your imagination. Unlike many other products, it allows to show an unlimited amount of banners and advertising, which are randomly shown at the places you choose, and you may refer generically to an Ad by using specific placeholders.

Also the management is straight-forward and simple to use. Forum administrators with maintenance rights may add, edit and delete records from the Administration Control Panel (ACP), one of each representing a banner. After saving the new banner settings, they are immediately visible at your board.

Compatibility: from vBulletin 3.6.5 onwards

By the way, I do also install the hack on your boards, but since I am very, very busy, it may take some time (weeks) until it gets done.


Tutorials:

• How-to create my first banner (Flash).

Updates:

• 2.0.1: Simple click tracker added, HTML help included.
• 2.0.3: Small bug fixes; additional banner list, navigation bar, E-Mail field for banner event notifications and automatic save on scroll setting; absolute URL to rbs_banner.php in order to allow click tracking on non-standard pages; supported languages: English, Italian; Help file clean-up.
• 2.0.5: Small bug fixes; additional details in banner list; email notification for epired banners.
• 2.0.6: vbCMS compatibility bug fix; additional banner lists.
• 2.0.7: Usergroups filter: now it is possible to define a list of usergroups which may show a banner; additional vbCMS compatibility bug fix.
• 2.0.8: Various fixes and most of all, inclusion of the right files: admin_rbs.php, cpnav_rbs.xml
• 2.0.9: Extra comma fix in new record creation.
• 2.1.0: Fix for an occasional banner type selection bug, when the sample banners have been deleted or disabled.
• 2.2.0 (Major upgrade): Up to 10 different banner locations. Requires changes to your existing placeholders in your templates, since a more generic format has been chosen. If you don't need more than 2 different locations, you don't need to upgrade. Changed files: rbs_banner.php, admin_rbs.php
• 2.2.1: Minor bug fix in files: admin_rbs_h_banner_list.php, admin_rbs_v_banner_list.php
• 2.2.1: Hotfix for Max Clicks saving bug.
• 2.2.2: More listings and less files. PDF Help. Separate Italian add-ons and help. Duplicate button.
• 2.2.3: Minor bug fixes. Changed files: product-rbs.xml
• 2.2.4: Flash Banner support (beta). Changed files: product-rbs.xml, rbs_wrapper.swf, admin_rbs.php, English Help.
• 2.2.5: Hotfix for vBulletin 4.0.2 compatibility bug.
• 2.2.6: Checking for installed Flash Wrapper rbs_wrapper.swf; A few English FAQ; Help files. Changed files: product-rbs.xml
• 2.3.0 (Major upgrade): New modules: Delete Expired Banners, Disable Expired Banners; Detail Banner Statistics with unique access key for your customers; Updated help; Changed files: all.
• 2.3.1: Hotfix for missing field in rbs_hist table. Changed files: none, just update product.
• 2.3.2: Added: Unsupported option for setting any number of available positions between 1 and big bang. Fixed: Small bug and speed issues. Removed: Italian translation. Italians may now request support at www.vbulletin.it. Changed files: admin_rbs.php.
• 2.3.3: Fix: Copy selected forum ID's during banner duplication. Changed: start and end hours for new banners are set to 0:00 and 23:59 respectively. Changed files: admin_rbs.php.
• 2.3.4: Option: Send Mail Before. This option allows to schedule expiring banners differently. New variables for emails: $rbs_enddate: This variable holds the formatted banner ending date and time based on the standard formats for date and time in vBulletin settings; $rbs_name: This variable holds the banner name. EMail Notifications option description: Added direct links to the email phrases for quick changes. Changed files: rbs_mail_cron.php.
• 2.4.0 (Major upgrade): Removed: Option to enable or disable mailing. Banners with email addresses to notify are handled. Setting to reset mailing in single banners. Now, if mailing should be repeated, you will have to edit the banner from phpMyAdmin. Added: Order links in lists. The initial state is ordered by ID, as before. By clicking the titles, the other voices can be ordered. Clicking twice inverts the order. This works in all lists. Options to prevent counting and reducing thus a tiny bit of load. A new bunch of demo banners for new installations. Demo banners are locked into database in order to avoid 30% of the questions because of the 'experts' deleting them before trying the product. They can be disabled and modified though. The true experts can delete them after all testing from the database by using phpMyAdmin without side effects. Changes: Phrase for emailing about expiring banners, now also with direct links to the phrases. Demo banners. Our old publisher ID is replaced with the new ones, and old demo banners are updated with the new ones, if found. The functions have been exported to includes/functions_rbs.php. This makes the product code smaller and easier to maintain, and runs faster on sites where caching/acceleration is enabled. Changed Files: all *.php
• 2.4.1: Option Likelihood. This new option adds a weight to banners and allows thus to show one banner more often than another. The default weight is 100%. We also make sure that the final date of the default banners falls into a valid range. Changed files: includes/functions_rbs.php and rbs_stats.php.
• 2.4.2: Workaround for update sequence problems.

Hacks and unsupported add-ons:

• Banner Rotator Widget To CMS
• Rotate banners in-place
• Italian Translation

[drdoc]

@ coder y2ksw and others

Hi to everyone...anyone can answer my question if they know.

I have a flash banner with swf file script. How to insert swf in to Rotation banner system software which i have in my admin cp of 4.2.2. Or guide me how to run flash banners in rotation banner system

I was using static banners in rotation banner so far but how to insert swf file(flash banner). Please help...thanks to all

[drdoc]

Originally Posted by y2ksw

It can handle anything you can express in HTML, e.g.

<OBJECT CLASSID="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" WIDTH="1024" HEIGHT="788" CODEBASE="http://active.macromedia.com/flash5/cabs/swflash.cab#version=5,0,0,0">
<PARAM NAME=movie VALUE="cvs01.swf">
<PARAM NAME=play VALUE=true>
<PARAM NAME=loop VALUE=false>
<PARAM NAME=quality VALUE=low>
<EMBED SRC="cvs01.swf" WIDTH=1024 HEIGHT=788 quality=low loop=false TYPE="application/x-shockwave-flash" PLUGINSPAGE="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash">
</EMBED>
</OBJECT>

will load the cvs01.swf file at the banner placeholder when inserted in the Text field.

The above quote belongs to old post and I just followed like above example in order to insert my swf flash banner in Text Box but NOT successful.....it just shows empty white space in the place of banner.

what else i should do to be successful for inserting flash banner...my other banners are static in rotation...location is below navbar and it is (0-Horizontal) . Please help me. thx in advance

[yaku]

Not sure if anyone has had this problem come up, but some of my banners weren't showing up in Chrome. No problem with other browsers. Finally fixed it by changing the names of the files and getting rid of the underscore "_".

So a file named "banner_468" became "banner468". All works well, I believe.

[dariyos]

Hello,

got a DB Eorror:

Datenbankfehler in vBulletin 4.2.2:

Invalid SQL:
SELECT *
            FROM rbs_banners 
            WHERE enabled=1
                AND likelihood>0
                AND startdate<=1411460197
                AND enddate>=1411460197
                AND IF(forumhome, 10=0, IF(forumids='', 1, FIND_IN_SET('10', forumids)))
                AND IF(maximpressions>0, impressions<maximpressions, 1)
                AND IF(clicktrack, maxclicks=0 OR (maxclicks>0 AND clicks<maxclicks), 1)
            ORDER BY -LOG(1-RAND()) / likelihood;

MySQL-Fehler  : MySQL server has gone away
Fehler-Nr.    : 2006
Fehler-Zeit   : Tuesday, 23.09.2014 @ 10:16:37
Datum         : Tuesday, 23.09.2014 @ 10:25:28
Skript        : http://www.sps-forum.de/simatic/72764-welche-eigenschaften-angeben-3.html
Referrer      : http://www.sps-forum.de/search.php?searchid=3658860

[y2ksw]

Originally Posted by dariyos

Hello,

got a DB Eorror:

Datenbankfehler in vBulletin 4.2.2:

Invalid SQL:
SELECT *
            FROM rbs_banners 
            WHERE enabled=1
                AND likelihood>0
                AND startdate<=1411460197
                AND enddate>=1411460197
                AND IF(forumhome, 10=0, IF(forumids='', 1, FIND_IN_SET('10', forumids)))
                AND IF(maximpressions>0, impressions<maximpressions, 1)
                AND IF(clicktrack, maxclicks=0 OR (maxclicks>0 AND clicks<maxclicks), 1)
            ORDER BY -LOG(1-RAND()) / likelihood;

MySQL-Fehler  : MySQL server has gone away
Fehler-Nr.    : 2006
Fehler-Zeit   : Tuesday, 23.09.2014 @ 10:16:37
Datum         : Tuesday, 23.09.2014 @ 10:25:28
Skript        : http://www.sps-forum.de/simatic/72764-welche-eigenschaften-angeben-3.html
Referrer      : http://www.sps-forum.de/search.php?searchid=3658860

Your database server has timed out before it returned the recordset to the calling process. This is a typical error for overloaded servers.

[nicklfire]

it would be absolutely amazing and save me so much time if there was a expiring date, or end date field on the banner list section. I have no idea when the banners expire unless i go in 1 by 1.. and with 25 banners that takes a while. Great product, really love it.ried

I tried to read the help file but it has no instructions for proper way to upgrade the version, i dont want to lose all the banners in there already.

Also the help file included revisions only goes up to like 2.3 or something, might need to update to 2.4.2

[y2ksw]

Originally Posted by nicklfire

it would be absolutely amazing and save me so much time if there was a expiring date, or end date field on the banner list section. I have no idea when the banners expire unless i go in 1 by 1.. and with 25 banners that takes a while. Great product, really love it.ried

I tried to read the help file but it has no instructions for proper way to upgrade the version, i dont want to lose all the banners in there already.

Also the help file included revisions only goes up to like 2.3 or something, might need to update to 2.4.2

I've put this in the Todo list, but I'm not sure there is enough space for the whole date. Eventually I could add a column with days to go.

[rhody401]

I would like to thank you for making such a great plugin. It is rock solid reliable and serves a great purpose on my forum.

Thank you thank you thank you!

[y2ksw]

You are welcome

[webmaster74]

Originally Posted by MaR?

Well... I did it!... here you are this mod xhtml validated!... I only change the xml file.

Grazzie Mille Giovanni for the great help you provide.

As placing a no follow before the banners is not an option within the vbulletin mod, I tried to follow up the example given by Maru up here and place the nofollow tag manually to the XML file and reupload it and, allow overwrite on import product.

YET, when I check the file provided by Maru, it only has two occurences of nofollow, on lines 279 and 284, as here below

                $output = substr($output, 0, $npos) . "<a href=\"$bburl/rbs_banner.php?id=$rs[id]\" rel=\"nofollow\" target=\"$rbs_target\"><img src=\"$image\" border=\"0\" alt=\"$name\" /></a>" . substr($output, $npos + $len);
            }
            else
            {
                $url = rbs_url_sanity($rs['url']);
                $output = substr($output, 0, $npos) . "<a href=\"$url\" rel=\"nofollow\" target=\"$rbs_target\"><img src=\"$image\" border=\"0\" alt=\"$name\" /></a>" . substr($output, $npos + $len);

I searched the most up to date version of rbs for any nofollow, and could not find them. This means you did not adopt the nofollow hardcoded

While this is good, the option is still not there.

I would like to place nofollow before links, where should I do that in the last rbs?