Complete Banner

Posts: 482 Location: Right in front of my computer

Sat 27 Oct, 2007 20:00

Subject: 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

Profile PM

KugeLSichA

Quote

Posts: 803 Location: Dresden

Sun 28 Oct, 2007 16:43

Subject: 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

Profile PM Website ICQ

Mighty Gorgon

Quote

Posts: 7192 Location: Borgo San Michele

Thu 01 Nov, 2007 21:22

Subject: 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. :wink:

Profile PM Website

Reply to topic

Page 1 of 1

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

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.0944s (PHP: 20% SQL: 80%)
SQL queries: 11 - Debug Off - GZIP Enabled

Icy Phoenix

Icy Phoenix - Powering Communities

Complete Banner