Complete Banner

The time now is Sat 27 Jul, 2024 09:41 • All times are UTC + 1 Hour [DST enabled]

Complete Banner

Page 1 of 1

xmenfile

Joined: September 2007
Posts: 482
Location:

Right in front of my computer

Complete Banner

This is one of them, Complete Banner mod. I installed it on a brand new Icy Phoenix and got this in ACP. Please help

Here is the install instruction:

Spoiler: [ Show ]

Code: [Download] [Hide] [Select]

## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 

############################################################## 

# 

#-----[ COPY ]------------------------------------------------ 

# 

copy complete_banner_db_update.php to complete_banner_db_update.php

copy root/redirect.php to redirect.php

copy root/admin/admin_banner.php to admin/admin_banner.php

copy root/language/lang_english/lang_banner.php to language/lang_english/lang_banner.php

copy root/templates/subSilver/redirect.tpl to templates/subSilver/redirect.tpl

copy root/templates/subSilver/admin/banner_edit_body.tpl to templates/subSilver/admin/banner_edit_body.tpl

copy root/templates/subSilver/admin/banner_list_body.tpl to templates/subSilver/admin/banner_list_body.tpl

#

# This MOD need a database update.

# Then, as you must have now copied the complete_banner_db_update.php file

# in your phpBB root directory, run it with your navigator...

# http://www.yourWebSite.xxx/phpbbRootDir/complete_banner_db_update.php

#

# ...and then delete it from the phpBB root directory!!!

#

# Please, do it NOW! Before editing phpBB files by EM or manually!!!

# Otherwise, you may have an error message during your next

# connection.

#

#

# Moreover, because EM 0.0.10a can not already manage files for not

# necessarily existing language, language provide with this MOD can

# not be automatically installed (if I add the above instruction it

# can cause an installation error). So, if you need this language

# copy this file manually.

#

# copy root/language/lang_french/lang_banner.php to language/lang_french/lang_banner.php

# copy root/language/lang_spanish/lang_banner.php to language/lang_spanish/lang_banner.php

#

# 

#-----[ OPEN ]------------------------------------------------

# 

viewonline.php

# 

#-----[ FIND ]------------------------------------------------ 

# 

default:

$location = $lang['Forum_index'];

# 

#-----[ BEFORE, ADD ]----------------------------------------- 

#

// Start add - Complete banner MOD

case PAGE_REDIRECT: 

    require_once($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_banner.' . $phpEx);

    if ($row['session_topic'])

    {

        $sql = "SELECT banner_description FROM " . BANNERS_TABLE . " WHERE banner_id=" . $row['session_topic'];

        if ( $result2 = $db->sql_query($sql) )

        {

            $banner_data = $db->sql_fetchrow($result2);

        }

        else

        {    

            message_die(GENERAL_ERROR, 'Could not obtain redirect online information', '', __LINE__, __FILE__, $sql);

        }

        $location_url = append_sid("redirect.$phpEx?banner_id=" . $row['session_topic']);

        $location = $lang['Left_via_banner'] .' --> '.$banner_data['banner_description'];

    } else

    {

        $location_url = "";

        $location = $lang['Left_via_banner'];

    }

    break;

// End add - Complete banner MOD

# 

#-----[ OPEN ]------------------------------------------------ 

# 

admin/admin_db_utilities.php

# 

#-----[ FIND ]------------------------------------------------ 

#

$tables = array(

# 

#-----[ AFTER, ADD ]------------------------------------------ 

#

// Start add - Complete banner MOD

$tables[] = 'banner';

$tables[] = 'banner_stats';

// End add - Complete banner MOD

# 

#-----[ OPEN ]------------------------------------------------

# 

includes/constants.php

# 

#-----[ FIND ]------------------------------------------------ 

# 

define('PAGE_GROUPCP', -11);

# 

#-----[ AFTER, ADD ]------------------------------------------ 

#

// Start add - Complete banner MOD

define('PAGE_REDIRECT', -1031);

// End add - Complete banner MOD

# 

#-----[ FIND ]------------------------------------------------ 

# 

define('USERS_TABLE', $table_prefix.'users');

# 

#-----[ AFTER, ADD ]------------------------------------------ 

#

// Start add - Complete banner MOD

define('BANNER_STATS_TABLE', $table_prefix.'banner_stats');

define('BANNERS_TABLE', $table_prefix.'banner');

// End add - Complete banner MOD

# 

#-----[ OPEN ]------------------------------------------------

# 

includes/page_header.php

# 

#-----[ FIND ]------------------------------------------------ 

# 

//

// The following assigns all _common_ variables that may be used at any point

# 

#-----[ BEFORE, ADD ]----------------------------------------- 

#

// Start add - Complete banner MOD

$time_now=time();

$hour_now=create_date('Hi',$time_now,$board_config['board_timezone']);

$date_now=create_date('Ymd',$time_now,$board_config['board_timezone']);

$week_now=create_date('w',$time_now,$board_config['board_timezone']);

$sql_level= ($userdata['user_id']==ANONYMOUS) ? ANONYMOUS : (($userdata['user_level']==ADMIN) ? MOD : (($userdata['user_level']==MOD) ? ADMIN : $userdata['user_level'])); 

$sql = "SELECT DISTINCT banner_id, banner_name, banner_spot, banner_description, banner_forum, banner_type, banner_width, banner_height, banner_filter FROM ".BANNERS_TABLE ."

        WHERE banner_active

        AND IF(banner_level_type,IF(banner_level_type=1,".intval($sql_level)."<=banner_level,IF(banner_level_type=2,".intval($sql_level).">=banner_level,".intval($sql_level)."<>banner_level)),banner_level=".intval($sql_level).")

        AND (banner_timetype=0 

        OR (( $hour_now BETWEEN time_begin AND time_end) AND ((banner_timetype=2

        OR (( $week_now BETWEEN date_begin AND date_end) AND banner_timetype=4)

        OR (( $date_now BETWEEN date_begin AND date_end) AND banner_timetype=6)

        )))) ORDER BY banner_spot,banner_weigth*SUBSTRING(RAND(),6,2) DESC";

if ( !($result = $db->sql_query($sql)) )

{

    message_die(GENERAL_ERROR, "Couldn't get banners data", "", __LINE__, __FILE__, $sql);

} 

$banners = array();

$i=0;

while ($banners[$i] = $db->sql_fetchrow($result))

{

    $cookie_name = $board_config['cookie_name'] . '_b_' . $banners[$i]['banner_id'];

    if ( !($HTTP_COOKIE_VARS[$cookie_name] && $banners[$i]['banner_filter']) )

    {

        $banner_spot=$banners[$i]['banner_spot'];

        if ($banner_spot<>$last_spot  AND ($banners[$i]['banner_forum']==$forum_id || empty($banners[$i]['banner_forum'])))

        {

            $banner_size = '';

            $banner_size = ($banners[$i]['banner_width']<>'') ? ' width="'.$banners[$i]['banner_width'].'"' : '';

            $banner_size .= ($banners[$i]['banner_height']<>'') ? ' height="'.$banners[$i]['banner_height'].'"' : '';            switch ($banners[$i]['banner_type'])

            {

                case 6 :

                    // swf file

                    $template->assign_vars(array('BANNER_'.$banner_spot.'_IMG' => '<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" id="macromedia'.$i.'" '.$banner_size.' align="abscenter"><param name="allowScriptAccess" value="sameDomain" /><param name=movie value="'.$banners[$i]['banner_name'].'?clickTAG='.append_sid('redirect.'.$phpEx.'?banner_id='.$banners[$i]['banner_id']).'"><param name=quality value=high><embed src="'.$banners[$i]['banner_name'].'?clickTAG='.append_sid('redirect.'.$phpEx.'?banner_id='.$banners[$i]['banner_id']).'" quality=high name="macromedia'.$i.'"  align="middle" allowScriptAccess="sameDomain" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" autostart="true" /><noembed><a href="'.append_sid('redirect.'.$phpEx.'?banner_id='.$banners[$i]['banner_id']).'" target="_blank">'.$banners[$i]['banner_description'].'</a></noembed></object>')); 

                    break;

                case 4 :

                    // custom code

                    $template->assign_var('BANNER_'.$banner_spot.'_IMG', $banners[$i]['banner_name'] );

                    $template->assign_var('BANNER_'.$banner_spot.'_IMG', '<br />'.$banners[$i]['banner_name'].'<br />' );

                    break;

                case 2 :

                    // Text link

                    $template->assign_var('BANNER_'.$banner_spot.'_IMG', '<a href="'.append_sid('redirect.'.$phpEx.'?banner_id='.$banners[$i]['banner_id']).'" target="_blank" alt="'.$banners[$i]['banner_description'].'" title="'.$banners[$i]['banner_description'].'">'.$banners[$i]['banner_name'].'</a>');

                    break;

                case 0 :

                default: 

                    $template->assign_var('BANNER_'.$banner_spot.'_IMG', '<a href="'.append_sid('redirect.'.$phpEx.'?banner_id='.$banners[$i]['banner_id']).'" target="_blank"><img src="'.$banners[$i]['banner_name'].'" '.$banner_size.' border="0" alt="'.$banners[$i]['banner_description'].'" title="'.$banners[$i]['banner_description'].'" /></a>');

            }

            $banner_show_list.= ', '.$banners[$i]['banner_id'];

        }

        $last_spot = ($banners[$i]['banner_forum']==$forum_id || empty($banners[$i]['banner_forum'])) ? $banner_spot : $last_spot;

    }

    $i++;

}

// End add - Complete banner MOD

# 

#-----[ OPEN ]------------------------------------------------

# 

includes/page_tail.php

# 

#-----[ FIND ]------------------------------------------------ 

# 

    die('Hacking attempt');

}

# 

#-----[ AFTER, ADD ]------------------------------------------ 

#

// Start add - Complete banner MOD

if ($banner_show_list)

{

    $banner_show_list['0'] = ($banner_show_list) ? ' ':'';

    $sql = "UPDATE ".BANNERS_TABLE." SET banner_view=banner_view+1 where banner_id IN ($banner_show_list)"; 

    if ( !($result = $db->sql_query($sql)) )

    {

        message_die(GENERAL_ERROR, "Couldn't update banners data", "", __LINE__, __FILE__, $sql);

    } 

}

// End add - Complete banner MOD

# 

#-----[ OPEN ]------------------------------------------------

# 

includes/functions.php

# 

#-----[ FIND ]------------------------------------------------ 

# 

global $starttime;

# 

#-----[ AFTER, ADD ]------------------------------------------------ 

# 

global $HTTP_COOKIE_VARS;

# 

#-----[ OPEN ]------------------------------------------------ 

# 

templates/subSilver/overall_footer.tpl

# 

#-----[ FIND ]------------------------------------------------ 

# 

    </tr>

</table>

# 

#-----[ BEFORE, ADD ]----------------------------------------- 

#

<!-- Start add - Complete banner MOD -->

<!-- Banners -->

<table width="100%" border="0" cellspacing="0" cellpadding="0">

  <tr>

    <td width="20%">

     <table width="100%" border="0" cellspacing="2" cellpadding="2">

        <tr><td><div align="center">{BANNER_7_IMG}</div></td></tr>

        <tr><td><div align="center">{BANNER_8_IMG}</div></td></tr>

    </table>

    </td>

    <td width="60%">

     <table width="100%" border="0" cellspacing="2" cellpadding="2">

        <tr><td><div align="center">{BANNER_9_IMG}</div></td></tr>

        <tr><td><div align="center">{BANNER_10_IMG}</div></td></tr>

    </table>

    </td>

    <td width="20%">

     <table width="100%" border="0" cellspacing="2" cellpadding="2">

        <tr><td><div align="center">{BANNER_11_IMG}</div></td></tr>

        <tr><td><div align="center">{BANNER_12_IMG}</div></td></tr>

    </table>

    </td>

  </tr>

</table>

<!-- End Banners -->

<!-- End add - Complete banner MOD -->

# 

#-----[ OPEN ]------------------------------------------------ 

# 

templates/subSilver/overall_header.tpl

# 

#-----[ FIND ]------------------------------------------------ 

# 

<a name="top"></a>

# 

#-----[ BEFORE, ADD ]----------------------------------------- 

#

<!-- Start add - Complete banner MOD -->

<!-- Banners -->

<table width="100%" border="0" cellspacing="0" cellpadding="0">

  <tr>

    <td width="100%" colspan="3"><div align="center">{BANNER_0_IMG}</div></td>

  </tr>

  <tr>

    <td width="20%">

     <table width="100%" border="0" cellspacing="2" cellpadding="2">

        <tr><td><div align="center">{BANNER_1_IMG}</div></td></tr>

        <tr><td><div align="center">{BANNER_2_IMG}</div></td></tr>

    </table>

    </td>

    <td width="60%">

     <table width="100%" border="0" cellspacing="2" cellpadding="2">

        <tr><td><div align="center">{BANNER_3_IMG}</div></td></tr>

        <tr><td><div align="center">{BANNER_4_IMG}</div></td></tr>

    </table>

    </td>

    <td width="20%">

     <table width="100%" border="0" cellspacing="2" cellpadding="2">

        <tr><td><div align="center">{BANNER_5_IMG}</div></td></tr>

        <tr><td><div align="center">{BANNER_6_IMG}</div></td></tr>

    </table>

    </td>

  </tr>

</table>

<!-- End Banners -->

<!-- End add - Complete banner MOD -->

# 

#-----[ OPEN ]------------------------------------------------ 

# 

templates/subSilver/viewforum_body.tpl

# 

#-----[ FIND ]------------------------------------------------ 

# 

<b>{PAGINATION}</b>

# 

#-----[ BEFORE, ADD ]----------------------------------------- 

#

<!-- Start add - Complete banner MOD -->

{BANNER_13_IMG}<br/>

<!-- End add - Complete banner MOD -->

# 

#-----[ OPEN ]------------------------------------------------ 

# 

templates/subSilver/viewtopic_body.tpl

# 

#-----[ FIND ]------------------------------------------------ 

# 

<b>{PAGINATION}</b>

# 

#-----[ BEFORE, ADD ]----------------------------------------- 

#

<!-- Start add - Complete banner MOD -->

{BANNER_14_IMG}<br/>

<!-- End add - Complete banner MOD -->

# 

#-----[ FIND ]------------------------------------------------ 

# 

<td width="40%" valign="top" nowrap="nowrap" align="left"><span class="gensmall">{S_WATCH_TOPIC}

# 

#-----[ BEFORE, ADD ]----------------------------------------- 

#

<!-- Start add - Complete banner MOD -->

<td align="left" valign="bottom" colspan="2">{BANNER_15_IMG}</td>

<!-- End add - Complete banner MOD -->

# 

#-----[ SAVE/CLOSE ALL FILES ]-------------------------------- 

# 

# EoM

Thank you

Edited by Mighty Gorgon, Thu 01 Nov, 2007 21:20: Added spoiler and code

#1 Sat 27 Oct, 2007 20:00

Sponsors	Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

KugeLSichA Joined: August 2006 Posts: 803 Location: Dresden	Re: Complete Banner Hello xmenfile, i have adapted this mod successfull to my site and its running for some month correctly... if i found some time in these days i can provide my pack. please be patient. thanks ____________ Play Games at GamesCampus!
#2 Sun 28 Oct, 2007 16:43

Mighty Gorgon

Luca Libralato

Joined: August 2006
Posts: 7191
Location:

Borgo San Michele

Re: Complete Banner

Please do not open several topics with the same questions.

Use spoiler when posting long CODE.

Use CODE not QUOTE when posting code.

Try to post in the appropriate forum, since these queries have to go into Icy Phoenix Customizations.

I'm fixing all and moving the topics.

Please pay attention next time.

____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON

#3 Thu 01 Nov, 2007 21:22

Page 1 of 1

Was this topic useful?

Link this topic
URL
BBCode
HTML

The time now is Sat 27 Jul, 2024 09:41 • All times are UTC + 1 Hour [DST enabled]

Permissions List

You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events