Advertising Module and RavenNukeVersion 2.51.00

Posted: Fri Aug 29, 2014 7:49 pm

Hi all.
First and foremost, even though I have been a member here at RavenNuke for like years, I generally never have the need to post a question because generally, everything that I need to find answers for is always here, if you take the time to search; but I'm stuck with The Advertising Module and Raven's latest release.
I have noticed that in my Advertising Module, when I add a banner and I use the Ad Class of Javascript/HTML code, my clicks and % of clicks all say N/A but when I add a banner via the Ad Class Image, I automatically get data filling in the Clicks and % of Clicks tables.
I would like to be able to offer the option of selling Ad Space using the Flash/Html Ad Class option (everything seems to be either flash/html linking capabilities nowadays.)
Okay to all of you Raven wizards out here..what do I do, need to look for or change in order for me to see the number of clicks etc for my banners?
Thanx..Happy Labor Day Smile

Site Admin Joined: Aug 22, 2007 Posts: 1772

Ok thats not hard but please note, that you need to use a generated clickURL to count the clicks and you must add this ClickURL in your HTML ode JS code. And its needed to have the input-fields for the ClickURL also for HTML/JS and Falsh in the formulars for ADD and EDIT of your banner-eintries.

I have modified the functions add_banner and BannerEdit of the index.php in the admin-folder of the Advertising module. Please replace the both functions but create backup of this file before you start the replacement!

open modules/Advertising/admin/index.php and find:

php Code:

function add_banner() {


	global $prefix, $db, $banners, $admin_file, $ad_admin_menu, $AllowableHTML, $advanced_editor;


	include_once ('header.php');


	GraphicAdmin();


	OpenTable();


	echo $ad_admin_menu;


	CloseTable();


	echo '<br />';


	OpenTable();


	$imageurl = 'http://';


	$clickurl = 'http://';


	$alttext = '';


	$ad_width = '';


	$ad_height = '';


	$result = $db->sql_query('SELECT * FROM ' . $prefix . '_banner_clients');


	$numrows = $db->sql_numrows($result);


	if ($numrows > 0) {


		if (isset($_POST['ad_class'])) {


			$ad_class = $_POST['ad_class'];


			$addmsg = _ADDBANNER;


			$step2flag = TRUE;


			$opset = 'BannersAdd';


			if (isset($_POST['adname'])) {


				$adname = check_html($_POST['adname'], 'nohtml');


			}


			else {


				$adname = '';


			}


			if (isset($_POST['imptotal'])) {


				$imptotal = intval($_POST['imptotal']);


			}


			else {


				$imptotal = '0';


			}


			if (isset($_POST['imageurl'])) {


				$imageurl = check_html($_POST['imageurl'],'nohtml');


			}


			if (isset($_POST['clickurl'])) {


				$clickurl = check_html($_POST['clickurl'],'nohtml');


			}


			if (isset($_POST['ad_width'])) {


				$ad_width = intval($_POST['ad_width']);


			}


			if (isset($_POST['ad_height'])) {


				$ad_height = intval($_POST['ad_height']);


			}


			if (isset($_POST['alttext'])) {


				$alttext = check_html($_POST['alttext'],'nohtml');


			}


		}


			else {


				$addmsg = 'CONTINUE';


				$ad_class = '';


				$step2flag = FALSE;


				$imptotal = '0';


				$adname = '';


				$opset = 'add_banner';


			}


		echo '<div style="text-align:center;" class="title">' . _ADDNEWBANNER . '<br /><br />';


			if (isset($_POST['errormsg'])) {


				$errormsg = check_html($_POST['errormsg'], '');


				echo ' There were errors on your previous input:<br />  '. $errormsg . '<br /><br />';


			}


			echo '</div>';


			echo '<form action="' . $admin_file . '.php?op='.$opset. '" method="post">'


			. '<table border="0"><tr><td>'


			. _CLIENTNAME . ':</td>'


			. '<td><select name="cid">';


		$result = $db->sql_query('SELECT cid, name FROM ' . $prefix . '_banner_clients ORDER BY name');


		while ($row = $db->sql_fetchrow($result)) {


			$cid = intval($row['cid']);


			$name = $row['name'];


			echo '<option value="' . $cid . '">' . $name . '</option>';


		}


		echo '</select></td></tr>'


			. '<tr><td nowrap="nowrap">' . _BANNERNAME . ' : </td>'


			.'<td><input type="text" name="adname" size="12" maxlength="50" value = "'.$adname.'" />';


			echo '</td></tr><tr><td nowrap="nowrap">' . _PURCHASEDIMPRESSIONS . ':</td><td><input type="text" name="imptotal" size="12" maxlength="11" value= "'.$imptotal.'" /> 0=' . _UNLIMITED;


			echo '</td></tr>';


			if (!$step2flag) {


				echo


			'<tr><td>' . _ADCLASS . ':</td><td><select name="ad_class">'


			. '<option value="image">' . _ADIMAGE . '</option>'


			. '<option value="code">' . _ADCODE . '</option>'


			. '<option value="flash">' . _ADFLASH . '</option>'


			. '</select></td></tr>'


			. '<tr><td>&nbsp;</td><td><span class="italic">Select One of the Three Ad Classes, then proceed to fill out the appropriate information about each class.</span></td></tr>';


			}


			else {


				echo '<tr><td>' . _ADCLASS . ' : ' . $ad_class . '<input type="hidden" name="ad_class" value = "'.$ad_class.'" /></td></tr>';


			}


			if ($step2flag) {


				if ($ad_class == 'image' || $ad_class == 'flash') {





				echo  '<tr><td>' . _IMAGESWFURL . ':</td><td><input type="text" name="imageurl" size="50" maxlength="100" value="'.$imageurl.'" /></td></tr>'


			. '<tr><td>' . _IMAGESIZE . ':</td><td>' . _WIDTH . ': <input type="text" name="ad_width" size="4" maxlength="4" value="'.$ad_width.'"/> &nbsp; ' . _HEIGHT . ': <input type="text" name="ad_height" size="4" maxlength="4" value="'.$ad_height.'" /> &nbsp; ' . _INPIXELS . '<input type="hidden" name="ad_code" value = "" /></td></tr>';


				if ($ad_class == 'image') {


					echo '<tr><td>' . _CLICKURL . '</td><td><input type="text" name="clickurl" size="50" maxlength="200" value="'.$clickurl.'" /></td></tr>'


			. '<tr><td>' . _ALTTEXT . ':</td><td><input type="text" name="alttext" size="50" maxlength="255" value="'.$alttext.'" /></td></tr>';


				}


			}


			else {


				echo '<tr><td><input type="hidden" name="imageurl" value="" /><input type="hidden" name="clickurl" value="" /><input type="hidden" name="ad_width" value="" /><input type="hidden" name="ad_height" value="" /><input type="hidden" name="alttext" value="" />' . _ADCODE . ':</td><td><div>';


					wysiwyg_textarea('ad_code', '', 'PHPNukeAdmin', 70, 12);


					echo '</div></td></tr>';


					echo '<tr><td colspan="2">'._AREYOUSURE.'</td></tr>';


					//echo '<tr><td colspan="2"> . '_ALLOWEDHTML . '</td></tr><tr><td colspan="2">';


					//while (list($key) = each($AllowableHTML)) echo ' &lt;'.$key.'&gt;';


					//echo '</td></tr>';


			}


			echo '<tr><td>' . _TYPE . ':</td><td><select name="position">';


		$result = $db->sql_query('SELECT position_number, position_name FROM ' . $prefix . '_banner_positions ORDER BY position_number');


		while ($row = $db->sql_fetchrow($result)) {


			echo '<option value="' . $row['position_number'] . '">' . $row['position_number'] . ' - ' . $row['position_name'] . '</option>';


		}


		echo '</select></td></tr><tr><td>&nbsp;</td><td>' . _POSITIONNOTE . '</td></tr>'


			. '<tr><td>' . _ACTIVATE . ':</td><td><input type="radio" name="active" value="1" checked="checked" />' . _YES . '&nbsp;&nbsp;<input type="radio" name="active" value="0" />' . _NO . '</td></tr>';


		}


		echo '<tr><td>&nbsp;</td><td><input type="hidden" name="op" value="'.$opset.'" />'


			. '<input type="submit" value="' . $addmsg . '" />'


			. '</td></tr></table></form>';


	}


	else {


		echo '<div class="text-center"><span class="title thick">' . _ADDNEWBANNER . '</span><br /><br />'


			. _ADSNOCLIENT . '<br /><br />' . _GOBACK . '</div>';


	}


	CloseTable();


	include_once('footer.php');


}

replace it with:

php Code:

function add_banner() {


	global $prefix, $db, $banners, $admin_file, $ad_admin_menu, $AllowableHTML, $advanced_editor;


	include_once ('header.php');


	GraphicAdmin();


	OpenTable();


	echo $ad_admin_menu;


	CloseTable();


	echo '<br />';


	OpenTable();


	$imageurl = 'http://';


	$clickurl = 'http://';


	$alttext = '';


	$ad_width = '';


	$ad_height = '';


	$result = $db->sql_query('SELECT * FROM ' . $prefix . '_banner_clients');


	$numrows = $db->sql_numrows($result);


	if ($numrows > 0) {


		if (isset($_POST['ad_class'])) {


			$ad_class = $_POST['ad_class'];


			$addmsg = _ADDBANNER;


			$step2flag = TRUE;


			$opset = 'BannersAdd';


			if (isset($_POST['adname'])) {


				$adname = check_html($_POST['adname'], 'nohtml');


			}


			else {


				$adname = '';


			}


			if (isset($_POST['imptotal'])) {


				$imptotal = intval($_POST['imptotal']);


			}


			else {


				$imptotal = '0';


			}


			if (isset($_POST['imageurl'])) {


				$imageurl = check_html($_POST['imageurl'],'nohtml');


			}


			if (isset($_POST['clickurl'])) {


				$clickurl = check_html($_POST['clickurl'],'nohtml');


			}


			if (isset($_POST['ad_width'])) {


				$ad_width = intval($_POST['ad_width']);


			}


			if (isset($_POST['ad_height'])) {


				$ad_height = intval($_POST['ad_height']);


			}


			if (isset($_POST['alttext'])) {


				$alttext = check_html($_POST['alttext'],'nohtml');


			}


		}


			else {


				$addmsg = 'CONTINUE';


				$ad_class = '';


				$step2flag = FALSE;


				$imptotal = '0';


				$adname = '';


				$opset = 'add_banner';


			}


		echo '<div style="text-align:center;" class="title">' . _ADDNEWBANNER . '<br /><br />';


			if (isset($_POST['errormsg'])) {


				$errormsg = check_html($_POST['errormsg'], '');


				echo ' There were errors on your previous input:<br />  '. $errormsg . '<br /><br />';


			}


			echo '</div>';


			echo '<form action="' . $admin_file . '.php?op='.$opset. '" method="post">'


			. '<table border="0"><tr><td>'


			. _CLIENTNAME . ':</td>'


			. '<td><select name="cid">';


		$result = $db->sql_query('SELECT cid, name FROM ' . $prefix . '_banner_clients ORDER BY name');


		while ($row = $db->sql_fetchrow($result)) {


			$cid = intval($row['cid']);


			$name = $row['name'];


			echo '<option value="' . $cid . '">' . $name . '</option>';


		}


		echo '</select></td></tr>'


			. '<tr><td nowrap="nowrap">' . _BANNERNAME . ' : </td>'


			.'<td><input type="text" name="adname" size="12" maxlength="50" value = "'.$adname.'" />';


			echo '</td></tr><tr><td nowrap="nowrap">' . _PURCHASEDIMPRESSIONS . ':</td><td><input type="text" name="imptotal" size="12" maxlength="11" value= "'.$imptotal.'" /> 0=' . _UNLIMITED;


			echo '</td></tr>';


			if (!$step2flag) {


				echo


			'<tr><td>' . _ADCLASS . ':</td><td><select name="ad_class">'


			. '<option value="image">' . _ADIMAGE . '</option>'


			. '<option value="code">' . _ADCODE . '</option>'


			. '<option value="flash">' . _ADFLASH . '</option>'


			. '</select></td></tr>'


			. '<tr><td>&nbsp;</td><td><span class="italic">Select One of the Three Ad Classes, then proceed to fill out the appropriate information about each class.</span></td></tr>';


			} else {


				echo '<tr><td>' . _ADCLASS . ' : ' . $ad_class . '<input type="hidden" name="ad_class" value = "'.$ad_class.'" /></td></tr>';


			}


			if ($step2flag) {


				if ($ad_class == 'image' || $ad_class == 'flash') {





				echo  '<tr><td>' . _IMAGESWFURL . ':</td><td><input type="text" name="imageurl" size="50" maxlength="100" value="'.$imageurl.'" /></td></tr>'


			. '<tr><td>' . _IMAGESIZE . ':</td><td>' . _WIDTH . ': <input type="text" name="ad_width" size="4" maxlength="4" value="'.$ad_width.'"/> &nbsp; ' . _HEIGHT . ': <input type="text" name="ad_height" size="4" maxlength="4" value="'.$ad_height.'" /> &nbsp; ' . _INPIXELS . '<input type="hidden" name="ad_code" value = "" /></td></tr>';


				if ($ad_class == 'image') {


					echo '<tr><td>' . _ALTTEXT . ':</td><td><input type="text" name="alttext" size="50" maxlength="255" value="'.$alttext.'" /></td></tr>';


				}


			} else {


				echo '<tr><td>' . _CLICKURL . '</td><td><input type="text" name="clickurl" size="50" maxlength="200" value="'.$clickurl.'" /></td></tr>';


				echo '<tr><td><input type="hidden" name="imageurl" value="" /><input type="hidden" name="clickurl" value="" /><input type="hidden" name="ad_width" value="" /><input type="hidden" name="ad_height" value="" /><input type="hidden" name="alttext" value="" />' . _ADCODE . ':</td><td><div>';


					wysiwyg_textarea('ad_code', '', 'PHPNukeAdmin', 70, 12);


					echo '</div></td></tr>';


					echo '<tr><td colspan="2">'._AREYOUSURE.'</td></tr>';


					//echo '<tr><td colspan="2"> . '_ALLOWEDHTML . '</td></tr><tr><td colspan="2">';


					//while (list($key) = each($AllowableHTML)) echo ' &lt;'.$key.'&gt;';


					//echo '</td></tr>';


			}


			echo '<tr><td>' . _TYPE . ':</td><td><select name="position">';


		$result = $db->sql_query('SELECT position_number, position_name FROM ' . $prefix . '_banner_positions ORDER BY position_number');


		while ($row = $db->sql_fetchrow($result)) {


			echo '<option value="' . $row['position_number'] . '">' . $row['position_number'] . ' - ' . $row['position_name'] . '</option>';


		}


		echo '</select></td></tr><tr><td>&nbsp;</td><td>' . _POSITIONNOTE . '</td></tr>'


			. '<tr><td>' . _ACTIVATE . ':</td><td><input type="radio" name="active" value="1" checked="checked" />' . _YES . '&nbsp;&nbsp;<input type="radio" name="active" value="0" />' . _NO . '</td></tr>';


		}


		echo '<tr><td>&nbsp;</td><td><input type="hidden" name="op" value="'.$opset.'" />'


			. '<input type="submit" value="' . $addmsg . '" />'


			. '</td></tr></table></form>';


	}


	else {


		echo '<div class="text-center"><span class="title thick">' . _ADDNEWBANNER . '</span><br /><br />'


			. _ADSNOCLIENT . '<br /><br />' . _GOBACK . '</div>';


	}


	CloseTable();


	include_once('footer.php');


}

find:

php Code:

function BannerEdit($bid) {


	global $prefix, $db, $admin_file, $ad_admin_menu, $AllowableHTML, $advanced_editor;


	include_once('header.php');


	GraphicAdmin();


	OpenTable();


	echo $ad_admin_menu;


	CloseTable();


	echo '<br />';


	$bid = intval($bid);


	$row = $db->sql_fetchrow($db->sql_query('SELECT cid, name, imptotal, impmade, clicks, imageurl, clickurl, alttext, date, position, active, ad_class, ad_code, ad_width, ad_height FROM ' . $prefix . '_banner WHERE bid=\'' . $bid . '\''));


	$cid = $row['cid'];


	$imptotal = $row['imptotal'];


	$impmade = $row['impmade'];


	$clicks = $row['clicks'];


	$imageurl = $row['imageurl'];


	$clickurl = $row['clickurl'];


	$alttext = $row['alttext'];


	$date = $row['date'];


	$date = explode(' ', $date);


	$date = $date[0] . ' @ ' . $date[1];


	$position = $row['position'];


	$active = $row['active'];


	$ad_class = $row['ad_class'];


	$ad_code = $row['ad_code'];


	$ad_width = $row['ad_width'];


	$ad_height = $row['ad_height'];


	$bannername = $row['name'];


	OpenTable();


	echo '<div style="text-align: center;" class="title">' . _EDITBANNER . '</div><br /><br />';


	if ($ad_class == 'code') {


		echo '<table border="0" align="center"><tr><td>' . $ad_code . '</td></tr></table><br /><br />';


	} elseif ($ad_class == 'flash') {


		echo '<div style="text-align: center;">


			<OBJECT classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"


			codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0"


			WIDTH="' . $ad_width . '" HEIGHT="' . $ad_height . '" id="' . $bid . '">


			<PARAM NAME=movie VALUE="' . $imageurl . '">


			<PARAM NAME=quality VALUE=high>


			<EMBED src="' . $imageurl . '" quality=high WIDTH="' . $ad_width . '" HEIGHT="' . $ad_height . '"


			NAME="' . $did . '" ALIGN="" TYPE="application/x-shockwave-flash"


			PLUGINSPAGE="http://www.macromedia.com/go/getflashplayer">


			</EMBED>


			</OBJECT>


			</div><br /><br />';


	} else {


		echo '<div style="text-align: center;"><img src="' . $imageurl . '" border="1" alt="' . $alttext . '" title="' . $alttext . '" width="' . $ad_width . '" height="' . $ad_height . '" /></div><br /><br />';


	}


	echo '<form action="' . $admin_file . '.php?op=BannerChange" method="post">';


	echo '<table width="100%">';


	 echo '<tr><td width="20%">'._CLIENTNAME . ':</td><td>'


		. '<select name="cid">';


	$row2 = $db->sql_fetchrow($db->sql_query('SELECT cid, name FROM ' . $prefix . '_banner_clients WHERE cid=\'' . $cid . '\''));


	$cid = $row2['cid'];


	$clientname = $row2['name'];


	echo '<option value="' . $cid . '" selected="selected">' . $clientname . '</option>';


	$result3 = $db->sql_query('SELECT cid, name FROM ' . $prefix . '_banner_clients');


	while ($row3 = $db->sql_fetchrow($result3)) {


		$ccid = $row3['cid'];


		$clientname = $row3['name'];


		if ($cid != $ccid) {


			echo '<option value="' . $ccid . '">' . $clientname . '</option>';


		}


	}


	echo '</select></td></tr>';


	if ($imptotal == 0) {


		$impressions = _UNLIMITED;


	} else {


		$impressions = $imptotal;


	}


	if ($active == 1) {


		$check1 = ' checked="checked"';


		$check2 = '';


	} else {


		$check1 = '';


		$check2 = ' checked="checked"';


	}


	if ($imptotal != 0) {


		$unl = '<span class="italic">(' . _XFORUNLIMITED . ')</span>';


	} else {


		$unl = '';


	}


	echo '<tr><td>' . _BANNERNAME . ':</td><td><input type="text" name="adname" size="20" maxlength="50" value="' . $row['name'] . '" /></td></tr>';


	echo '<tr><td>' . _ADDEDDATE . ':</td><td>' . $date . '</td></tr>';


	echo '<tr><td>' . _IMPPURCHASED . ':</td><td class="thick">' . $impressions . '</td></tr>';


	echo '<tr><td>' . _IMPMADE . ':</td><td class="thick">' . $impmade . '</td></tr>';


	echo '<tr><td>' . _ADDIMPRESSIONS . ':</td><td><input type="text" name="impadded" size="12" maxlength="11" value="0" /> ' . $unl . '</td></tr>';


	echo '<tr><td>' . _ADCLASS . ':</td><td class="thick">' . ucFirst($ad_class) . '</td></tr>';


	if ($ad_class == 'code') {





			echo '<tr><td colspan="2" style="text-align:center;">' . _ADCODE . ':</td></tr><tr><td colspan="2"><div>';


			if (!isset($advanced_editor) || $advanced_editor == 0) {


					$ad_code = htmlentities($ad_code, ENT_QUOTES);


			}


		 wysiwyg_textarea('ad_code', $ad_code, 'PHPNukeAdmin', 70, 15);


		 echo '</div></td></tr>';


			echo '<tr><td colspan="2">'._AREYOUSURE.'</td></tr>';


		//echo <tr><td colspan="2"> . _ALLOWEDHTML . '</td></tr><tr><td colspan="2">';


		//while (list($key) = each($AllowableHTML)) echo ' &lt;'.$key.'&gt;';


		//echo '</td></tr>';


		 echo '<tr><td>'


			. '<input type="hidden" name="imageurl" value="' . $imageurl . '" />'


			. '<input type="hidden" name="ad_width" value="' . $ad_width . '" />'


			. '<input type="hidden" name="ad_height" value="' . $ad_height . '" />'


			. '<input type="hidden" name="clickurl" value="' . $clickurl . '" />'


			. '<input type="hidden" name="alttext" value="' . $alttext . '" /></td><td>&nbsp;</td></tr>';


	} elseif ($ad_class == 'flash') {


		echo '<tr><td>' . _FLASHFILEURL . ':</td><td><input type="text" name="imageurl" size="50" maxlength="255" value="' . $imageurl . '" /> &nbsp; <a href="' . $imageurl . '" target="_blank"><img src="images/view.gif" border="0" alt="' . _SHOW . '" title="' . _SHOW . '" /></a></td></tr>'


			. '<tr><td>' . _FLASHSIZE . ':</td><td>' . _WIDTH . ': <input type="text" name="ad_width" size="4" maxlength="4" value="' . $ad_width . '" /> &nbsp; ' . _HEIGHT . ': <input type="text" name="ad_height" size="4" maxlength="4" value="' . $ad_height . '" /> &nbsp; ' . _INPIXELS


			. '<input type="hidden" name="clickurl" value="' . $clickurl . '" />'


			. '<input type="hidden" name="alttext" value="' . $alttext . '" />'


			. '<input type="hidden" name="ad_code" value="' . $ad_code . '" /></td></tr>';


	} else {


		echo '<tr><td>' . _IMAGEURL . ':</td><td><input type="text" name="imageurl" size="50" maxlength="255" value="' . $imageurl . '" /></td></tr>'


			. '<tr><td>' . _IMAGESIZE . ':</td><td>' . _WIDTH . ': <input type="text" name="ad_width" size="4" maxlength="4" value="' . $ad_width . '" /> &nbsp; ' . _HEIGHT . ': <input type="text" name="ad_height" size="4" maxlength="4" value="' . $ad_height . '" /> &nbsp; ' . _INPIXELS . '</td></tr>'


			. '<tr><td>' . _CLICKURL . ':</td><td><input type="text" name="clickurl" size="50" maxlength="200" value="' . $clickurl . '" /></td></tr>'


			. '<tr><td>' . _ALTTEXT . ':</td><td><input type="text" name="alttext" size="50" maxlength="255" value="' . $alttext . '" />'


			. '<input type="hidden" name="ad_code" value="' . $ad_code . '" /></td></tr>';


	}


	echo '<tr><td>' . _TYPE . ':</td><td><select name="position">';


	$result4 = $db->sql_query('SELECT position_number, position_name FROM ' . $prefix . '_banner_positions ORDER BY position_number');


	while ($row4 = $db->sql_fetchrow($result4)) {


		if ($position == $row4['position_number']) {


			$sel = ' selected="selected"';


		} else {


			$sel = '';


		}


		echo '<option value="' . $row4['position_number'] . '"' . $sel . '>' . $row4['position_number'] . ' - ' . $row4['position_name'] . '</option>';


	}


	echo '</select></td></tr>'


		. '<tr><td>' . _ACTIVATE . ':</td><td><input type="radio" name="active" value="1"' . $check1 . ' />' . _YES . '&nbsp;&nbsp;<input type="radio" name="active" value="0"' . $check2 . ' />' . _NO . '</td></tr>'


		. '<tr><td>&nbsp;</td><td><input type="hidden" name="bid" value="' . $bid . '" />'


		. '<input type="hidden" name="imptotal" value="' . $imptotal . '" />'


		. '<input type="hidden" name="impmade" value="' . $impmade . '" />'


		. '<input type="hidden" name="op" value="BannerChange" />'


		. '<input type="submit" value="' . _SAVECHANGES . '" />'


		. '</td></tr></table></form>';


	CloseTable();


	include_once('footer.php');


}

replace it with:

php Code:

function BannerEdit($bid) {


	global $prefix, $db, $admin_file, $ad_admin_menu, $AllowableHTML, $advanced_editor;


	include_once('header.php');


	GraphicAdmin();


	OpenTable();


	echo $ad_admin_menu;


	CloseTable();


	echo '<br />';


	$bid = intval($bid);


	$row = $db->sql_fetchrow($db->sql_query('SELECT cid, name, imptotal, impmade, clicks, imageurl, clickurl, alttext, date, position, active, ad_class, ad_code, ad_width, ad_height FROM ' . $prefix . '_banner WHERE bid=\'' . $bid . '\''));


	$cid = $row['cid'];


	$imptotal = $row['imptotal'];


	$impmade = $row['impmade'];


	$clicks = $row['clicks'];


	$imageurl = $row['imageurl'];


	$clickurl = $row['clickurl'];


	$alttext = $row['alttext'];


	$date = $row['date'];


	$date = explode(' ', $date);


	$date = $date[0] . ' @ ' . $date[1];


	$position = $row['position'];


	$active = $row['active'];


	$ad_class = $row['ad_class'];


	$ad_code = $row['ad_code'];


	$ad_width = $row['ad_width'];


	$ad_height = $row['ad_height'];


	$bannername = $row['name'];


	OpenTable();


	echo '<div style="text-align: center;" class="title">' . _EDITBANNER . '</div><br /><br />';


	if ($ad_class == 'code') {


		echo '<table border="0" align="center"><tr><td>' . $ad_code . '</td></tr></table><br /><br />';


	} elseif ($ad_class == 'flash') {


		echo '<div style="text-align: center;">


			<OBJECT classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"


			codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0"


			WIDTH="' . $ad_width . '" HEIGHT="' . $ad_height . '" id="' . $bid . '">


			<PARAM NAME=movie VALUE="' . $imageurl . '">


			<PARAM NAME=quality VALUE=high>


			<EMBED src="' . $imageurl . '" quality=high WIDTH="' . $ad_width . '" HEIGHT="' . $ad_height . '"


			NAME="' . $did . '" ALIGN="" TYPE="application/x-shockwave-flash"


			PLUGINSPAGE="http://www.macromedia.com/go/getflashplayer">


			</EMBED>


			</OBJECT>


			</div><br /><br />';


	} else {


		echo '<div style="text-align: center;"><img src="' . $imageurl . '" border="1" alt="' . $alttext . '" title="' . $alttext . '" width="' . $ad_width . '" height="' . $ad_height . '" /></div><br /><br />';


	}


	echo '<form action="' . $admin_file . '.php?op=BannerChange" method="post">';


	echo '<table width="100%">';


	 echo '<tr><td width="20%">'._CLIENTNAME . ':</td><td>'


		. '<select name="cid">';


	$row2 = $db->sql_fetchrow($db->sql_query('SELECT cid, name FROM ' . $prefix . '_banner_clients WHERE cid=\'' . $cid . '\''));


	$cid = $row2['cid'];


	$clientname = $row2['name'];


	echo '<option value="' . $cid . '" selected="selected">' . $clientname . '</option>';


	$result3 = $db->sql_query('SELECT cid, name FROM ' . $prefix . '_banner_clients');


	while ($row3 = $db->sql_fetchrow($result3)) {


		$ccid = $row3['cid'];


		$clientname = $row3['name'];


		if ($cid != $ccid) {


			echo '<option value="' . $ccid . '">' . $clientname . '</option>';


		}


	}


	echo '</select></td></tr>';


	if ($imptotal == 0) {


		$impressions = _UNLIMITED;


	} else {


		$impressions = $imptotal;


	}


	if ($active == 1) {


		$check1 = ' checked="checked"';


		$check2 = '';


	} else {


		$check1 = '';


		$check2 = ' checked="checked"';


	}


	if ($imptotal != 0) {


		$unl = '<span class="italic">(' . _XFORUNLIMITED . ')</span>';


	} else {


		$unl = '';


	}


	echo '<tr><td>' . _BANNERNAME . ':</td><td><input type="text" name="adname" size="20" maxlength="50" value="' . $row['name'] . '" /></td></tr>';


	echo '<tr><td>' . _ADDEDDATE . ':</td><td>' . $date . '</td></tr>';


	echo '<tr><td>' . _IMPPURCHASED . ':</td><td class="thick">' . $impressions . '</td></tr>';


	echo '<tr><td>' . _IMPMADE . ':</td><td class="thick">' . $impmade . '</td></tr>';


	echo '<tr><td>' . _ADDIMPRESSIONS . ':</td><td><input type="text" name="impadded" size="12" maxlength="11" value="0" /> ' . $unl . '</td></tr>';


	echo '<tr><td>' . _ADCLASS . ':</td><td class="thick">' . ucFirst($ad_class) . '</td></tr>';


	if ($ad_class == 'code' || $ad_class == 'flash') {


		$inlinejs = '<script type="text/javascript">' . PHP_EOL


				  . '$(".selectall").click(function () {' . PHP_EOL


				  . '	$(this).select();' . PHP_EOL


				  . '});' . PHP_EOL


				  . '</script>' . PHP_EOL;


		addJSToBody($inlinejs, 'inline');


	}


	if ($ad_class == 'code') {


			echo '<tr>'


			   . '<td style="vertical-align:top;">' . _CLICKURL . ':</td>'


			   . '<td>'


			   . '<input type="text" name="clickurl" size="50" maxlength="200" value="' . $clickurl . '" /><br /><br />'


			   . '<input type="text" readonly="readonly" size="50" maxlength="200" value="' . htmlspecialchars('index.php?op=ad_click&amp;bid=' . $bid, ENT_QUOTES, _CHARSET) . '" class="selectall" /><br /><br />'


			   . '</td>'


			   . '</tr>'


			   . '<tr><td colspan="2" style="text-align:center;">' . _ADCODE . ':</td></tr><tr><td colspan="2"><div>';


			if (!isset($advanced_editor) || $advanced_editor == 0) {


					$ad_code = htmlentities($ad_code, ENT_QUOTES);


			}


		 wysiwyg_textarea('ad_code', $ad_code, 'PHPNukeAdmin', 70, 15);


		 echo '</div></td></tr>';


			echo '<tr><td colspan="2">'._AREYOUSURE.'</td></tr>';


		//echo <tr><td colspan="2"> . _ALLOWEDHTML . '</td></tr><tr><td colspan="2">';


		//while (list($key) = each($AllowableHTML)) echo ' &lt;'.$key.'&gt;';


		//echo '</td></tr>';


		 echo '<tr><td>'


			. '<input type="hidden" name="imageurl" value="' . $imageurl . '" />'


			. '<input type="hidden" name="ad_width" value="' . $ad_width . '" />'


			. '<input type="hidden" name="ad_height" value="' . $ad_height . '" />'


			#. '<input type="hidden" name="clickurl" value="' . $clickurl . '" />'


			. '<input type="hidden" name="alttext" value="' . $alttext . '" /></td><td>&nbsp;</td></tr>';


	} elseif ($ad_class == 'flash') {


		echo '<tr><td>' . _FLASHFILEURL . ':</td><td><input type="text" name="imageurl" size="50" maxlength="255" value="' . $imageurl . '" /> &nbsp; <a href="' . $imageurl . '" target="_blank"><img src="images/view.gif" border="0" alt="' . _SHOW . '" title="' . _SHOW . '" /></a></td></tr>'


			. '<tr><td>' . _FLASHSIZE . ':</td><td>' . _WIDTH . ': <input type="text" name="ad_width" size="4" maxlength="4" value="' . $ad_width . '" /> &nbsp; ' . _HEIGHT . ': <input type="text" name="ad_height" size="4" maxlength="4" value="' . $ad_height . '" /> &nbsp; ' . _INPIXELS


			. '<tr>'


			. '<td style="vertical-align:top;">' . _CLICKURL . ':</td>'


			. '<td>'


			. '<input type="text" name="clickurl" size="50" maxlength="200" value="' . $clickurl . '" /><br /><br />'


			. '<input type="text" readonly="readonly" size="50" maxlength="200" value="' . htmlspecialchars('index.php?op=ad_click&amp;bid=' . $bid, ENT_QUOTES, _CHARSET) . '" class="selectall" /><br /><br />'


			. '</td>'


			. '</tr>'


			#. '<input type="hidden" name="clickurl" value="' . $clickurl . '" />'


			. '<input type="hidden" name="alttext" value="' . $alttext . '" />'


			. '<input type="hidden" name="ad_code" value="' . $ad_code . '" /></td></tr>';


	} else {


		echo '<tr><td>' . _IMAGEURL . ':</td><td><input type="text" name="imageurl" size="50" maxlength="255" value="' . $imageurl . '" /></td></tr>'


			. '<tr><td>' . _IMAGESIZE . ':</td><td>' . _WIDTH . ': <input type="text" name="ad_width" size="4" maxlength="4" value="' . $ad_width . '" /> &nbsp; ' . _HEIGHT . ': <input type="text" name="ad_height" size="4" maxlength="4" value="' . $ad_height . '" /> &nbsp; ' . _INPIXELS . '</td></tr>'


			. '<tr><td>' . _CLICKURL . ':</td><td><input type="text" name="clickurl" size="50" maxlength="200" value="' . $clickurl . '" /></td></tr>'


			. '<tr><td>' . _ALTTEXT . ':</td><td><input type="text" name="alttext" size="50" maxlength="255" value="' . $alttext . '" />'


			. '<input type="hidden" name="ad_code" value="' . $ad_code . '" /></td></tr>';


	}


	echo '<tr><td>' . _TYPE . ':</td><td><select name="position">';


	$result4 = $db->sql_query('SELECT position_number, position_name FROM ' . $prefix . '_banner_positions ORDER BY position_number');


	while ($row4 = $db->sql_fetchrow($result4)) {


		if ($position == $row4['position_number']) {


			$sel = ' selected="selected"';


		} else {


			$sel = '';


		}


		echo '<option value="' . $row4['position_number'] . '"' . $sel . '>' . $row4['position_number'] . ' - ' . $row4['position_name'] . '</option>';


	}


	echo '</select></td></tr>'


		. '<tr><td>' . _ACTIVATE . ':</td><td><input type="radio" name="active" value="1"' . $check1 . ' />' . _YES . '&nbsp;&nbsp;<input type="radio" name="active" value="0"' . $check2 . ' />' . _NO . '</td></tr>'


		. '<tr><td>&nbsp;</td><td><input type="hidden" name="bid" value="' . $bid . '" />'


		. '<input type="hidden" name="imptotal" value="' . $imptotal . '" />'


		. '<input type="hidden" name="impmade" value="' . $impmade . '" />'


		. '<input type="hidden" name="op" value="BannerChange" />'


		. '<input type="submit" value="' . _SAVECHANGES . '" />'


		. '</td></tr></table></form>';


	CloseTable();


	include_once('footer.php');


}

Now you have the inpult-field for the Click-URL also in the ADD and EDIT formulars for HTML/JS and flash to store your wanted URL.

Example:

If you would have now a simple hyperlink in your html-code like this:

html Code:

<a href ="http://www.ravenphpscripts.com">Raven Forums</a>

... and you would have stored a ClickURL like this:

Code:

http://www.ravenphpscripts.com

... then you have to replace the URL of your hyperlink with the generated ClickURL, that you will find in the EDIT formular below the input-field of your stored ClickURL.

That should be look like this:

html Code:

<a href ="index.php?op=ad_click&bid=1">Raven Forums</a>

I hope this is what you were looking for. Don't forget to make a Backup before you are trying this and let me know if you will get some errors.

Please note: If you are using flash-objects, then you must have a chance to edit the flash-objects to use the genereated click-urls otherwise you can't use it in this way.

Wink