vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Miscellaneous Hacks - Banner Rotator (Definitive Mod) **UPDATED** (https://vborg.vbsupport.ru/showthread.php?t=133954)

brvheart 03-07-2007 06:38 PM

thank you much :) will do this in a bit for sure :) I almost say integrate it to the mod or maybe have both in the mod so that people can choose...since I have seen quite a few mention it ;)

thank you again, great mod!!

gsmlover4u 03-08-2007 04:56 AM

what is this error
Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to access ./images/banners/iklkiu_468x60_01_01.gif/iklkiu_468x60_01_01.gif in /admincp/brotator.php on line 62

KHALIK 03-14-2007 11:02 PM

working nicely.

But

can you select different banners for "Specific" forums.

accessdeniedzzz 03-17-2007 05:37 AM

Nice work ;) i luv it

Spika 03-21-2007 09:17 AM

Quote:

Originally Posted by WarLion (Post 1195101)
actually i need that and i made it

find in product-rotator.xml

PHP Code:

CREATE TABLE `". TABLE_PREFIX ."banners` (
                      `
bidsmallint(20UNSIGNED NOT NULL auto_increment,
                      `
namevarchar(255NOT NULL default '',
                      `
widthvarchar(255NOT NULL default '',
                      `
heightvarchar(255NOT NULL default '',
                      `
altvarchar(255NOT NULL default '',
                      `
urlvarchar(255NOT NULL default '',
                      `
flashINT(1UNSIGNED NOT NULL default '0',
                      `
activeINT(1UNSIGNED NOT NULL default '0',
                      
PRIMARY KEY  (`bid`)
                    )
                
"); 

and remplace with this
PHP Code:

CREATE TABLE `". TABLE_PREFIX ."banners` (
                      `
bidsmallint(20UNSIGNED NOT NULL auto_increment,
                      `
namevarchar(255NOT NULL default '',
                      `
widthvarchar(255NOT NULL default '',
                      `
heightvarchar(255NOT NULL default '',
                      `
altvarchar(255NOT NULL default '',
                      `
urlvarchar(255NOT NULL default '',
                      `
linkvarchar(255NOT NULL default '',
                      `
flashINT(1UNSIGNED NOT NULL default '0',
                      `
activeINT(1UNSIGNED NOT NULL default '0',
                      
PRIMARY KEY  (`bid`)
                    )
                
"); 

then find
PHP Code:

} else {
        
$banner =     "<center><img src='" $vbulletin->options[bburl] . $defaultdir "/" $ban['name'] . "' alt='" $ban['alt'] . "' width='".$ban['width']."' height='".$ban['height']."' border='0'></center>";            
    } 

and remplace with
PHP Code:

} else {
        
$banner =     "<a href='".$ban['link']."'><img src='" $vbulletin->options[bburl] . $defaultdir "/" $ban['name'] . "' alt='" $ban['alt'] . "' width='".$ban['width']."' height='".$ban['height']."' border='0'></a>";            
    } 

now you need to add this about line 89
PHP Code:

<phrase name="setting_brotator_default_link_desc" date="1166036111" username="FileWarez" version="1.0b"><![CDATA[Defalt link]]></phrase

and
PHP Code:

<phrase name="setting_brotator_default_link_title" date="1166036111" username="FileWarez" version="1.0b"><![CDATA[Default link]]></phrase

save and import

now you need to edit the admincp/brotator.xml

on line 30 add this
PHP Code:

print_input_row('Link''link'$vbulletin->options['brotator_default_link']); 

find this
PHP Code:

if ($movefile) {
            
$db->query_write("INSERT INTO " TABLE_PREFIX "banners (bid, name, width, height, alt, flash, active) VALUES ('', '$fname', '$_POST[width]', '$_POST[height]', '$_POST[alt]', '$_POST[flash]', '$_POST[active]')");
            
print_cp_message($vbphrase['brotator_add_success'], "brotator.php?do=add""1");
        } else {
            
print_cp_message("There was an error while moving your file. Please retry.");
        } 

and remplace with this
PHP Code:

if ($movefile) {
            
$db->query_write("INSERT INTO " TABLE_PREFIX "banners (bid, name, width, height, link, alt, flash, active) VALUES ('', '$fname', '$_POST[width]', '$_POST[height]', '$_POST[link]', '$_POST[alt]', '$_POST[flash]', '$_POST[active]')");
            
print_cp_message($vbphrase['brotator_add_success'], "brotator.php?do=add""1");
        } else {
            
print_cp_message("There was an error while moving your file. Please retry.");
        } 

find this
PHP Code:

if (!empty($_POST['bid'])) {
            
$db->query("UPDATE " TABLE_PREFIX "banners SET 
                alt = '
$_POST[alt]',
                width = '
$_POST[width]',
                height = '
$_POST[height]',
                flash = '
$_POST[flash]'  
            WHERE bid = '
$_POST[bid]'");
            
print_cp_message($vbphrase['brotator_edit_desc_success'], "brotator.php?do=edit""1");
        } 

remplace with this
PHP Code:

if (!empty($_POST['bid'])) {
            
$db->query("UPDATE " TABLE_PREFIX "banners SET 
                alt = '
$_POST[alt]',
                width = '
$_POST[width]',
                height = '
$_POST[height]',
                link = '
$_POST[link]',
                flash = '
$_POST[flash]'  
            WHERE bid = '
$_POST[bid]'");
            
print_cp_message($vbphrase['brotator_edit_desc_success'], "brotator.php?do=edit""1");
        } 

find this
PHP Code:

                print_cells_row(array(
                    
"<center>".$img."</center>",
                    
"<form name='form1' method='post' action='brotator.php?do=edit'>
                    <input type='text' class='bginput' name='alt' value='
$banner[alt]' class='bginput' size='35'><br><br>
                    Width: <input type='text' class='bginput' name='width' value='
$banner[width]' class='bginput' size='5'> 
                    Height: <input type='text' class='bginput' name='height' value='
$banner[height]' class='bginput' size='5'><br><br>
                    Flash? <label for='flash"
.$banner[bid]."' class='smallfont'><input name='flash' id='flash".$banner[bid]."' type='checkbox' value='1' ".$checked."><strong>Yes</strong></label>
                    <input type='hidden' name='bid' value='
$banner[bid]'>
                    <input type='hidden' name='update' value='1'>
                    <input type='submit' name='Submit' value='  "
.$vbphrase['brotator_edit_update']."  ' class='button'>
                    </form>"
,
                    
$active 

and remplaze with this
PHP Code:

                print_cells_row(array(
                    
"<center>".$img."</center>",
                    
"<form name='form1' method='post' action='brotator.php?do=edit'>
                    <input type='text' class='bginput' name='alt' value='
$banner[alt]' class='bginput' size='35'><br>
                    Link : <input type='text' class='bginput' name='link' value='
$banner[link]' class='bginput' size='28'><br>
                    Width: <input type='text' class='bginput' name='width' value='
$banner[width]' class='bginput' size='5'> 
                    Height: <input type='text' class='bginput' name='height' value='
$banner[height]' class='bginput' size='5'><br><br>
                    Flash? <label for='flash"
.$banner[bid]."' class='smallfont'><input name='flash' id='flash".$banner[bid]."' type='checkbox' value='1' ".$checked."><strong>Yes</strong></label>
                    <input type='hidden' name='bid' value='
$banner[bid]'>
                    <input type='hidden' name='update' value='1'>
                    <input type='submit' name='Submit' value='  "
.$vbphrase['brotator_edit_update']."  ' class='button'>
                    </form>"
,
                    
$active 

save and overwrite

with this you can edit the link too
and thats all works for me on vb 3.6.4

Great work!
Works fine in 3.6.5!
My banners are now clickable, and I Have put I forumhome template below $navbar
but I have another question: How I can open the link in a new Window? Where I have put the code?

Thanks in advanced.

php4ever 03-21-2007 06:13 PM

I honestly dont see where you add banners. I've searched every single area of the admin cp and cant find a single place to upload images for the banners.

brvheart 03-21-2007 06:43 PM

Quote:

Originally Posted by WarLion (Post 1195101)
actually i need that and i made it

find in product-rotator.xml

PHP Code:

CREATE TABLE `". TABLE_PREFIX ."banners` (
                      `
bidsmallint(20UNSIGNED NOT NULL auto_increment,
                      `
namevarchar(255NOT NULL default '',
                      `
widthvarchar(255NOT NULL default '',
                      `
heightvarchar(255NOT NULL default '',
                      `
altvarchar(255NOT NULL default '',
                      `
urlvarchar(255NOT NULL default '',
                      `
flashINT(1UNSIGNED NOT NULL default '0',
                      `
activeINT(1UNSIGNED NOT NULL default '0',
                      
PRIMARY KEY  (`bid`)
                    )
                
"); 

and remplace with this
PHP Code:

CREATE TABLE `". TABLE_PREFIX ."banners` (
                      `
bidsmallint(20UNSIGNED NOT NULL auto_increment,
                      `
namevarchar(255NOT NULL default '',
                      `
widthvarchar(255NOT NULL default '',
                      `
heightvarchar(255NOT NULL default '',
                      `
altvarchar(255NOT NULL default '',
                      `
urlvarchar(255NOT NULL default '',
                      `
linkvarchar(255NOT NULL default '',
                      `
flashINT(1UNSIGNED NOT NULL default '0',
                      `
activeINT(1UNSIGNED NOT NULL default '0',
                      
PRIMARY KEY  (`bid`)
                    )
                
"); 

then find
PHP Code:

} else {
        
$banner =     "<center><img src='" $vbulletin->options[bburl] . $defaultdir "/" $ban['name'] . "' alt='" $ban['alt'] . "' width='".$ban['width']."' height='".$ban['height']."' border='0'></center>";            
    } 

and remplace with
PHP Code:

} else {
        
$banner =     "<a href='".$ban['link']."'><img src='" $vbulletin->options[bburl] . $defaultdir "/" $ban['name'] . "' alt='" $ban['alt'] . "' width='".$ban['width']."' height='".$ban['height']."' border='0'></a>";            
    } 

now you need to add this about line 89
PHP Code:

<phrase name="setting_brotator_default_link_desc" date="1166036111" username="FileWarez" version="1.0b"><![CDATA[Defalt link]]></phrase

and
PHP Code:

<phrase name="setting_brotator_default_link_title" date="1166036111" username="FileWarez" version="1.0b"><![CDATA[Default link]]></phrase

save and import

now you need to edit the admincp/brotator.xml

on line 30 add this
PHP Code:

print_input_row('Link''link'$vbulletin->options['brotator_default_link']); 

find this
PHP Code:

if ($movefile) {
            
$db->query_write("INSERT INTO " TABLE_PREFIX "banners (bid, name, width, height, alt, flash, active) VALUES ('', '$fname', '$_POST[width]', '$_POST[height]', '$_POST[alt]', '$_POST[flash]', '$_POST[active]')");
            
print_cp_message($vbphrase['brotator_add_success'], "brotator.php?do=add""1");
        } else {
            
print_cp_message("There was an error while moving your file. Please retry.");
        } 

and remplace with this
PHP Code:

if ($movefile) {
            
$db->query_write("INSERT INTO " TABLE_PREFIX "banners (bid, name, width, height, link, alt, flash, active) VALUES ('', '$fname', '$_POST[width]', '$_POST[height]', '$_POST[link]', '$_POST[alt]', '$_POST[flash]', '$_POST[active]')");
            
print_cp_message($vbphrase['brotator_add_success'], "brotator.php?do=add""1");
        } else {
            
print_cp_message("There was an error while moving your file. Please retry.");
        } 

find this
PHP Code:

if (!empty($_POST['bid'])) {
            
$db->query("UPDATE " TABLE_PREFIX "banners SET 
                alt = '
$_POST[alt]',
                width = '
$_POST[width]',
                height = '
$_POST[height]',
                flash = '
$_POST[flash]'  
            WHERE bid = '
$_POST[bid]'");
            
print_cp_message($vbphrase['brotator_edit_desc_success'], "brotator.php?do=edit""1");
        } 

remplace with this
PHP Code:

if (!empty($_POST['bid'])) {
            
$db->query("UPDATE " TABLE_PREFIX "banners SET 
                alt = '
$_POST[alt]',
                width = '
$_POST[width]',
                height = '
$_POST[height]',
                link = '
$_POST[link]',
                flash = '
$_POST[flash]'  
            WHERE bid = '
$_POST[bid]'");
            
print_cp_message($vbphrase['brotator_edit_desc_success'], "brotator.php?do=edit""1");
        } 

find this
PHP Code:

                print_cells_row(array(
                    
"<center>".$img."</center>",
                    
"<form name='form1' method='post' action='brotator.php?do=edit'>
                    <input type='text' class='bginput' name='alt' value='
$banner[alt]' class='bginput' size='35'><br><br>
                    Width: <input type='text' class='bginput' name='width' value='
$banner[width]' class='bginput' size='5'> 
                    Height: <input type='text' class='bginput' name='height' value='
$banner[height]' class='bginput' size='5'><br><br>
                    Flash? <label for='flash"
.$banner[bid]."' class='smallfont'><input name='flash' id='flash".$banner[bid]."' type='checkbox' value='1' ".$checked."><strong>Yes</strong></label>
                    <input type='hidden' name='bid' value='
$banner[bid]'>
                    <input type='hidden' name='update' value='1'>
                    <input type='submit' name='Submit' value='  "
.$vbphrase['brotator_edit_update']."  ' class='button'>
                    </form>"
,
                    
$active 

and remplaze with this
PHP Code:

                print_cells_row(array(
                    
"<center>".$img."</center>",
                    
"<form name='form1' method='post' action='brotator.php?do=edit'>
                    <input type='text' class='bginput' name='alt' value='
$banner[alt]' class='bginput' size='35'><br>
                    Link : <input type='text' class='bginput' name='link' value='
$banner[link]' class='bginput' size='28'><br>
                    Width: <input type='text' class='bginput' name='width' value='
$banner[width]' class='bginput' size='5'> 
                    Height: <input type='text' class='bginput' name='height' value='
$banner[height]' class='bginput' size='5'><br><br>
                    Flash? <label for='flash"
.$banner[bid]."' class='smallfont'><input name='flash' id='flash".$banner[bid]."' type='checkbox' value='1' ".$checked."><strong>Yes</strong></label>
                    <input type='hidden' name='bid' value='
$banner[bid]'>
                    <input type='hidden' name='update' value='1'>
                    <input type='submit' name='Submit' value='  "
.$vbphrase['brotator_edit_update']."  ' class='button'>
                    </form>"
,
                    
$active 

save and overwrite

with this you can edit the link too
and thats all works for me on vb 3.6.4

I did that and now I get a DB error :(

MySQL Error : Unknown column 'link' in 'field list'
Error Number : 1054

Spika 03-22-2007 11:17 AM

Quote:

Originally Posted by php4ever (Post 1208967)
I honestly dont see where you add banners. I've searched every single area of the admin cp and cant find a single place to upload images for the banners.

In AdminCP you should see in the left column "Banner Rotator" where you can add, edit or delete banners, If not refresh your browser.

mescalin 03-23-2007 03:15 PM

Its a perfect mod thank you..!

I would liketo see code rotating options (for bannerexchanges etc.) in the future releases..

andrefedalto 03-24-2007 01:22 PM

Quote:

Originally Posted by Spika (Post 1208651)
Great work!
Works fine in 3.6.5!
My banners are now clickable, and I Have put I forumhome template below $navbar
but I have another question: How I can open the link in a new Window? Where I have put the code?
Thanks in advanced.

If you did the changes WarLion pointed, find:
Code:

} else {
        $banner =    "<a href='".$ban['link']."'><img src='" . $vbulletin->options[bburl] . $defaultdir . "/" . $ban['name'] . "' alt='" . $ban['alt'] . "' width='".$ban['width']."' height='".$ban['height']."' border='0'></a>";           
    }

and replace to
Code:

} else {
        $banner =    "<a href='".$ban['link']."' target='_blank'><img src='" . $vbulletin->options[bburl] . $defaultdir . "/" . $ban['name'] . "' alt='" . $ban['alt'] . "' width='".$ban['width']."' height='".$ban['height']."' border='0'></a>";           
    }

Quote:

Originally Posted by php4ever (Post 1208967)
I honestly dont see where you add banners. I've searched every single area of the admin cp and cant find a single place to upload images for the banners.

Check attached image.

Quote:

Originally Posted by brvheart (Post 1208986)
I did that and now I get a DB error :(

MySQL Error : Unknown column 'link' in 'field list'
Error Number : 1054

After making the changes pointed by WarLion you have to reinstall the modification with the changed xml.

Quote:

Originally Posted by mescalin (Post 1210426)
Its a perfect mod thank you..!

I would liketo see code rotating options (for bannerexchanges etc.) in the future releases..

Can you explain more please?



And to WarLion: Thanks for helping out :)
Just one thing: there were no need to create a new field in database (link), since i already had set the 'url' field for future releases. But if it works fine, leave as it is. Thanks a lot for adding the feature :)


All times are GMT. The time now is 06:34 AM.

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.01617 seconds
  • Memory Usage 1,957KB
  • 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
  • (2)bbcode_code_printable
  • (26)bbcode_php_printable
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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