Adsense code in viewlisting.php

[nachtwerkmir]

Hi, does anyone know how to correcty insert an google adsensecode in the viewlisting.php?

I would like to see the adsense code between the table with the ad and the table were the user can contact the seller.

[civ]

Add it wherever you want it in viewlisting.tpl.php

[nachtwerkmir]

It doesn't matter where i put it, i always get a error like:
Parse error: parse error, unexpected '}' in /var/www/html/test/viewlisting.php on line 154

or whatever line i insert the script. I've inserted the adsensecode with and without the {/literal} tags. I would really insert the code between the ad and the part where the user can contact the seller.
This is how i tried it last:

<?php
/*
* 68 Classifieds
*
* All source code & content (c) Copyright 2006, 68 Classifieds
* unless specifically noted otherwise.
*
* @Author $Author: Blair $ (68 Classifieds)
* @copyright 68 Classifieds
* @link http://www.68classifieds.com
* @version 3.1
* @$Revision: 1.7 $
* @Updated: $Date: 2007/05/10 16:31:30 $
* @package 68 Classifieds
*
*/
require_once('includes/init.php');
require_once('includes/classes/kernel/Listings.php');
$Listing = new Listings( $db, $class_tpl );

$go=TRUE;
if (!empty($_GET['view']))
{
$view = (int)$_GET['view'];
if(!$Listing->getListing($view))
{
$go=FALSE;
}
else
{
$rs=$Listing->getListing($view);
}
}
else
{
$go=FALSE;
}
if($go==FALSE)
{
//no rows where found. Must be either expired or deleted. Lets show the not available page
//header("Location: search.php");
$class_tpl->assign('available', FALSE);
$class_tpl->assign('body','viewlisting/notavailable.tpl.php');
}
else
{
if($rs['display']=="Y")
{
$price=FormatCurrency($rs['price']);
}
else
{
$price=LANG_LISTING_PRICE_SOLD;
}
//assign variables
$modules->call_hook('view_listing', $view); // Call any module functions
$path=breadcrumb($rs['section'],0);
$class_tpl->assign('breadcrumb', $path);
$title= safeStripSlashes($title ." : ". $rs['title']);
$class_tpl->assign('available', TRUE);
$class_tpl->assign('title', $title);

//owner
$class_tpl->assign('ownerid', safeStripSlashes($rs['owner']));
$class_tpl->assign('ownername', safeStripSlashes($rs['username']));
$class_tpl->assign('owneraddress', safeStripSlashes($rs['address']));
$class_tpl->assign('ownercity', safeStripSlashes($rs['city']));
$class_tpl->assign('ownerstate', safeStripSlashes($rs['state']));
$class_tpl->assign('ownercountry', safeStripSlashes($rs['country']));
$class_tpl->assign('ownerzip', safeStripSlashes($rs['zip']));
$class_tpl->assign('ownerphone', $rs['phone']);

//listing
$class_tpl->assign('listingid', $rs['id']);
$class_tpl->assign('url', $rs['url']);
$class_tpl->assign('listingtitle', safeStripSlashes($rs['title']));
$class_tpl->assign('listingsection', $rs['section']);
$class_tpl->assign('listingprice', $price);
$class_tpl->assign('dateadded', $rs['dateadded']);
$class_tpl->assign('listingexpiration', $rs['expiration']);
$class_tpl->assign('listingviews', $rs['hitcount']);
$class_tpl->assign('shortdescription', nl2br(safeStripSlashes($rs['shortDescription'])));
$class_tpl->assign('description', nl2br(safeStripSlashes($rs['description'])));
$class_tpl->assign('display', $rs['display']);

//extra fields
$extra=array();
$sSQL = "SELECT f.fID,sValue FROM ".PREFIX."products_fields AS p, `".PREFIX."fields` AS f WHERE p.pID='".$view."' AND f.fSeen='Y' AND p.fID=f.fID ORDER BY f.fOrder ASC";
$result=$db->query($sSQL);
$i=0;
while ($rs=$result->fetch())
{
$sql="SELECT fID,fName,fType FROM `".PREFIX."fields` WHERE fID='".$rs['fID']."' AND fSeen='Y' ORDER BY fOrder ASC";
$result2=$db->query($sql);
$rs2=$result2->fetch();
if(strpos($rs['sValue'], "|"))
{
$rs['sValue'] = explode("|", $rs['sValue']);
}
if($rs2['fType']=="F")
{
$ext = substr(strrchr($rs['sValue'], "."), 1);
if($ext=="pdf")
{
$icon='<img src="images/icon_pdf.png" />';
}
elseif($ext=="zip")
{
$icon='<img src="images/icon_zip.png" />';
}
else
{
$icon='<img src="images/icon_page.png" />';
}
$rs['sValue']=$icon." <a href=\"uploads/".$rs['sValue']."\" target=\"_blank\">".$rs['sValue']."</a>";
}
$tmp = array(
'fID' => $rs['fID'],
'title' => $rs2['fName'],
'value'=> nl2br($rs['sValue']),
);
$extra[$i++] = $tmp;
$i++;
}
$class_tpl->assign('extra', $extra);

//get the images
$image=$Listing->getImages($view);
$class_tpl->assign('data', $image);

//get the display fields
$sSQL="SELECT lDisplay,lCols FROM ".PREFIX."listing_settings WHERE lID=1";
$result=$db->query($sSQL);
$rs=$result->fetch();
$lDisplay=$rs['lDisplay'];

$class_tpl->assign('canSaveFavorites', $canSaveFavorites);
$class_tpl->assign('viewphotos', $canViewPhotos);
$class_tpl->assign('viewseller', $canViewSeller);
$class_tpl->assign('viewaddress', $canViewAddress);
$class_tpl->assign('viewcity', $canViewCity);
$class_tpl->assign('viewstate', $canViewState);
$class_tpl->assign('viewcountry', $canViewCountry);
$class_tpl->assign('viewprice', $canViewPrice);
$class_tpl->assign('viewdate', $canViewDateAdded);
$class_tpl->assign('viewexpiration', $canViewExpiration);
$class_tpl->assign('viewhits', $canViewHits);
$class_tpl->assign('viewphone', $canViewPhone);
$class_tpl->assign('cols', $rs['lCols']);

$class_tpl->assign('allowcontact', $canContact);
$class_tpl->assign('allowfriendmail', $canEmailFriend);
$result->freeResult($result);
{literal}
<script type="text/javascript"><!--
google_ad_client = "pub-122322323232";
google_ad_width = 336;
google_ad_height = 280;
google_ad_format = "336x280_as";
google_ad_type = "text_image";
google_ad_channel ="";
google_page_url = document.location;
google_color_border = "FFFFDD";
google_color_bg = "FFFFDD";
google_color_link = "000000";
google_color_url = "FF6600";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
{/literal}
//catpcha?
$sSQL="SELECT rCaptcha FROM ".PREFIX."registration WHERE rID=1";
$result=$db->query($sSQL);
$rs=$result->fetch();
$rCaptcha=$rs['rCaptcha'];
$class_tpl->assign('rCaptcha', $rCaptcha);

if($lDisplay==1)
{
$class_tpl->assign('body','viewlisting.tpl.php');
}
else
{
$class_tpl->assign('body','viewlisting2.tpl.php');
}

//finally update the hit counter
$sSQL = "UPDATE ".PREFIX."products SET hitcount=hitcount+1 WHERE id=".$view;
$db->query($sSQL);
}

//now display the template
$class_tpl->display('layout.tpl.php', $view);
?>

[nachtwerkmir]

Well it doesn't seem to work. Is still get a parse error. I have tried it with and without the {/literal} tags. I would like to have the code just between the ad en the space where the user can contact the seller. This is the code with the parseerror.

<?php
/*
* 68 Classifieds
*
* All source code & content (c) Copyright 2006, 68 Classifieds
* unless specifically noted otherwise.
*
* @Author $Author: Blair $ (68 Classifieds)
* @copyright 68 Classifieds
* @link http://www.68classifieds.com
* @version 3.1
* @$Revision: 1.7 $
* @Updated: $Date: 2007/05/10 16:31:30 $
* @package 68 Classifieds
*
*/
require_once('includes/init.php');
require_once('includes/classes/kernel/Listings.php');
$Listing = new Listings( $db, $class_tpl );

$go=TRUE;
if (!empty($_GET['view']))
{
$view = (int)$_GET['view'];
if(!$Listing->getListing($view))
{
$go=FALSE;
}
else
{
$rs=$Listing->getListing($view);
}
}
else
{
$go=FALSE;
}
if($go==FALSE)
{
//no rows where found. Must be either expired or deleted. Lets show the not available page
//header("Location: search.php");
$class_tpl->assign('available', FALSE);
$class_tpl->assign('body','viewlisting/notavailable.tpl.php');
}
else
{
if($rs['display']=="Y")
{
$price=FormatCurrency($rs['price']);
}
else
{
$price=LANG_LISTING_PRICE_SOLD;
}
//assign variables
$modules->call_hook('view_listing', $view); // Call any module functions
$path=breadcrumb($rs['section'],0);
$class_tpl->assign('breadcrumb', $path);
$title= safeStripSlashes($title ." : ". $rs['title']);
$class_tpl->assign('available', TRUE);
$class_tpl->assign('title', $title);

//owner
$class_tpl->assign('ownerid', safeStripSlashes($rs['owner']));
$class_tpl->assign('ownername', safeStripSlashes($rs['username']));
$class_tpl->assign('owneraddress', safeStripSlashes($rs['address']));
$class_tpl->assign('ownercity', safeStripSlashes($rs['city']));
$class_tpl->assign('ownerstate', safeStripSlashes($rs['state']));
$class_tpl->assign('ownercountry', safeStripSlashes($rs['country']));
$class_tpl->assign('ownerzip', safeStripSlashes($rs['zip']));
$class_tpl->assign('ownerphone', $rs['phone']);

//listing
$class_tpl->assign('listingid', $rs['id']);
$class_tpl->assign('url', $rs['url']);
$class_tpl->assign('listingtitle', safeStripSlashes($rs['title']));
$class_tpl->assign('listingsection', $rs['section']);
$class_tpl->assign('listingprice', $price);
$class_tpl->assign('dateadded', $rs['dateadded']);
$class_tpl->assign('listingexpiration', $rs['expiration']);
$class_tpl->assign('listingviews', $rs['hitcount']);
$class_tpl->assign('shortdescription', nl2br(safeStripSlashes($rs['shortDescription'])));
$class_tpl->assign('description', nl2br(safeStripSlashes($rs['description'])));
$class_tpl->assign('display', $rs['display']);

//extra fields
$extra=array();
$sSQL = "SELECT f.fID,sValue FROM ".PREFIX."products_fields AS p, `".PREFIX."fields` AS f WHERE p.pID='".$view."' AND f.fSeen='Y' AND p.fID=f.fID ORDER BY f.fOrder ASC";
$result=$db->query($sSQL);
$i=0;
while ($rs=$result->fetch())
{
$sql="SELECT fID,fName,fType FROM `".PREFIX."fields` WHERE fID='".$rs['fID']."' AND fSeen='Y' ORDER BY fOrder ASC";
$result2=$db->query($sql);
$rs2=$result2->fetch();
if(strpos($rs['sValue'], "|"))
{
$rs['sValue'] = explode("|", $rs['sValue']);
}
if($rs2['fType']=="F")
{
$ext = substr(strrchr($rs['sValue'], "."), 1);
if($ext=="pdf")
{
$icon='<img src="images/icon_pdf.png" />';
}
elseif($ext=="zip")
{
$icon='<img src="images/icon_zip.png" />';
}
else
{
$icon='<img src="images/icon_page.png" />';
}
$rs['sValue']=$icon." <a href=\"uploads/".$rs['sValue']."\" target=\"_blank\">".$rs['sValue']."</a>";
}
$tmp = array(
'fID' => $rs['fID'],
'title' => $rs2['fName'],
'value'=> nl2br($rs['sValue']),
);
$extra[$i++] = $tmp;
$i++;
}
$class_tpl->assign('extra', $extra);

//get the images
$image=$Listing->getImages($view);
$class_tpl->assign('data', $image);

//get the display fields
$sSQL="SELECT lDisplay,lCols FROM ".PREFIX."listing_settings WHERE lID=1";
$result=$db->query($sSQL);
$rs=$result->fetch();
$lDisplay=$rs['lDisplay'];

$class_tpl->assign('canSaveFavorites', $canSaveFavorites);
$class_tpl->assign('viewphotos', $canViewPhotos);
$class_tpl->assign('viewseller', $canViewSeller);
$class_tpl->assign('viewaddress', $canViewAddress);
$class_tpl->assign('viewcity', $canViewCity);
$class_tpl->assign('viewstate', $canViewState);
$class_tpl->assign('viewcountry', $canViewCountry);
$class_tpl->assign('viewprice', $canViewPrice);
$class_tpl->assign('viewdate', $canViewDateAdded);
$class_tpl->assign('viewexpiration', $canViewExpiration);
$class_tpl->assign('viewhits', $canViewHits);
$class_tpl->assign('viewphone', $canViewPhone);
$class_tpl->assign('cols', $rs['lCols']);

$class_tpl->assign('allowcontact', $canContact);
$class_tpl->assign('allowfriendmail', $canEmailFriend);
$result->freeResult($result);
{literal}
<script type="text/javascript"><!--
google_ad_client = "pub-heredoiputmyid";
google_ad_width = 336;
google_ad_height = 280;
google_ad_format = "336x280_as";
google_ad_type = "text_image";
google_ad_channel ="";
google_page_url = document.location;
google_color_border = "FFFFDD";
google_color_bg = "FFFFDD";
google_color_link = "000000";
google_color_url = "FF6600";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
{/literal}
//catpcha?
$sSQL="SELECT rCaptcha FROM ".PREFIX."registration WHERE rID=1";
$result=$db->query($sSQL);
$rs=$result->fetch();
$rCaptcha=$rs['rCaptcha'];
$class_tpl->assign('rCaptcha', $rCaptcha);

if($lDisplay==1)
{
$class_tpl->assign('body','viewlisting.tpl.php');
}
else
{
$class_tpl->assign('body','viewlisting2.tpl.php');
}

//finally update the hit counter
$sSQL = "UPDATE ".PREFIX."products SET hitcount=hitcount+1 WHERE id=".$view;
$db->query($sSQL);
}

//now display the template
$class_tpl->display('layout.tpl.php', $view);
?>

[Lhotch]

You need to place it in the template, not the script itself. You also need to surround the code with proper smarty escape tags.

[civ]

Originally Posted by civ

Add it wherever you want it in viewlisting.tpl.php

Yep, take another look at the bolded portion of my previous reply

[nachtwerkmir]

Wrong file!! i see.
But what are the correct smarty escape tags? I am not familiar with the tags.

[Lhotch]

http://www.smarty.net/manual/en/language.escaping.php

[nachtwerkmir]

Thanks, solved!