$val)
if(strstr($_SERVER['HTTP_USER_AGENT'], $val))
$lIsSearchE++;
if($lIsSearchE==0)
session_start();
include_once("admin/inc.php");
$ad_id=round(getParam("id",""));
$lPrint=getParam("print","");
// If setting is not set, use these defaults...
if (!$set_outer_color) { $set_outer_color = "#A9B8D1"; }
if (!$set_inner_color) { $set_inner_color = "#FFFFFF"; }
if (!$set_descr_color) { $set_descr_color = "#FFFFFF"; }
if (!isset($set_descr_cell)) { $set_descr_cell = 10; }
if (isset($preview)) { $ad_id = $preview; $validation = 0; }
if (!$ad_id)
criticalError(LA_ERROR,LA_ERROR_NO_ID);
if ($validation == 1 && getParam("preview","")=="") { $val_string = " AND ad_is_validated = 1"; } else { $val_string = ""; }
$sql_links = "select * from $ads_tbl, $cat_tbl, $usr_tbl where cat_id=ad_cat_id AND user_id=ad_owner AND ad_id=$ad_id $val_string";
$result_from_ad = q($sql_links);
$row_from_ad=mysql_fetch_array($result_from_ad);
if (mysql_num_rows($result_from_ad) == 0)
criticalError(LA_AD_REMOVED_CAPTION,formatString(LA_AD_REMOVED_CONTENT,array("http://$url")));
$sitetitle = $row_from_ad["ad_title"];
$ad_description = $row_from_ad["ad_description"];
$userid = $row_from_ad["user_id"];
$ad_date = $row_from_ad["ad_date"];
$ad_views = $row_from_ad["ad_views"];
$ad_votes = $row_from_ad["ad_votes"];
$ad_voters = $row_from_ad["ad_voters"];
$ad_totalscore = $row_from_ad["ad_totalscore"];
$votes = $row_from_ad["user_votes"];
$voters = $row_from_ad["user_voters"];
$name = $row_from_ad["user_name"];
$email = $row_from_ad["user_email"];
$catname = $row_from_ad["cat_name"];
$catid = $row_from_ad["cat_id"];
$vendor_url = $row_from_ad["user_vendor_url"];
$vendor_homepage = $row_from_ad["user_vendor_homepage"];
$sold = $row_from_ad["ad_is_sold"];
$cattpl = $row_from_ad["cat_tpl"];
$datestamp = $row_from_ad["ad_date"];
$ad_has_picture = $row_from_ad["ad_has_picture"];
$is_vendor = $row_from_ad["user_is_vendor"];
$hide_email = $row_from_ad["user_hide_email"];
$img_stored = $row_from_ad["img_stored"];
$user_id = $row_from_ad["user_id"];
$expire_days = $row_from_ad["ad_expires_after_days"];
$ad_expires=formatDateShort($row_from_ad["ad_date_expire"]);
$timestamp_expire_date=$row_from_ad["ad_date_expire"];
$ad_added=formatDateShort($row_from_ad["ad_date"]);
$pagename= $sitename . " - " . cleanInput($sitetitle);
$meta_desc=cleanInput(dotString($ad_description,150));
if (empty($lPrint))
include_once("singleheader_inc.php");
else
{
include ($full_path_to_public_program . "/admin/classes/TplLoad.php");
echo "";
echo "$la_p
";
}
// Start template system
$tplDetail=new TplLoad;
// Comment system
if (($_SESSION["valid_user"] !="") && (getParam("submit","") !="") && (getParam("comment_body","") !=""))
{
$lfBody=strToDb(getParam("comment_body",""));
$lfAdId=$ad_id;
$lfUser=$_SESSION["valid_user"];
//if ($lfUser==$user_id)
//$lSql="insert into $com_tbl (comment_body,comment_date,comment_userid,comment_ad) values ('$lfBody',".time().",$lfUser,$lfAdId)";
//else
$lSql="insert into $com_tbl (comment_body,comment_date,comment_userid,comment_ad,comment_ip) values ('$lfBody',".time().",$lfUser,$lfAdId,'".getRemoteIp()."')";
$lCommentRes=q($lSql);
$lCommentDone=1;
}
if (getParam("del","") && $set_comment_admin_del)
{
if ($_SESSION["valid_user"]==$user_id)
{
q("delete from $com_tbl where comment_id=" . getParamInt("del","") . " AND comment_ad=$ad_id");
}
}
$lSql="select * from $com_tbl where comment_ad=" . $ad_id . " order by comment_id desc";
$lComment=q($lSql);
$i=0;
while ($lRow=mysql_fetch_array($lComment))
{
$lComments[$i]["comment_body"]=strEnc($lRow["comment_body"]);
$lComments[$i]["comment_id"]=$lRow["comment_id"];
$lComments[$i]["comment_userid"]=$lRow["comment_userid"];
$lComments[$i]["comment_date"]=formatDateShort($lRow["comment_date"]);
$lSq="select user_name from $usr_tbl where user_id=" . $lRow["comment_userid"];
$lResult=q($lSq);
$lRow2=mysql_fetch_array($lResult);
$lComments[$i]["comment_by"]=strEnc($lRow2["user_name"]);
$i++;
}
$tplDetail->assign("comment_list",$lComments);
// END comment system
$tplDetail->assign("isLoggedIn",$_SESSION["valid_user"]);
$tplDetail->assign("set_outer_color",$set_outer_color);
$tplDetail->assign("set_inner_color",$set_inner_color);
$tplDetail->assign("set_descr_color",$set_descr_color);
$tplDetail->assign("set_descr_cell",$set_descr_cell);
$tplDetail->assign("set_comment_system",$set_comment_system);
$tplDetail->assign("set_comment_admin_del",$set_comment_admin_del);
$tplDetail->assign("id_ad","$ad_id");
$tplDetail->assign("ad_id","$ad_id");
$tplDetail->assign("ad_link",linkDetail($ad_id));
$tplDetail->assign("ad_title",strEnc("$sitetitle"));
$tplDetail->assign("ad_added","$ad_added");
$tplDetail->assign("ad_hits","$ad_views");
$tplDetail->assign("ad_expire","$ad_expires");
$tplDetail->assign("ad_catid","$catid");
$tplDetail->assign("ad_username",strEnc("$name"));
$tplDetail->assign("ad_email","$email");
$tplDetail->assign("ad_catname",strEnc($row_from_ad["cat_name"]));
//////GET TRANSLATION - NEW/////////////////////////
/* If not catid given, pretend in order to not break down*/
if ($catid=="")
$catid=0;
if ($num_ads==0){
$sql="select cat_allow_ads,cat_name";
if (!empty($_SESSION["la"]) AND $set_multilang_cat)
{
$lang_cat = "lang_" . $_SESSION["la"];
$sql.=",$lang_cat";
}
$sql.=" from $cat_tbl where cat_id=$catid";
$r_q=q($sql);
$allow_row=mysql_fetch_array($r_q);
$catname=$allow_row["cat_name"];
if (!empty($allow_row["$lang_cat"]))
$catname=$allow_row["$lang_cat"];
$tplDetail->assign("CATNAME",$catname);
}
//////GET TRANSLATION - NEW/////////////////////////
$tplDetail->assign("banner","$lBanner");
if ($set_nl2br)
$ad_description=nl2br($ad_description);
if ($lCommentDone)
$tplDetail->assign("set_comment_done",1);
$tplDetail->assign("ad_description","$ad_description");
$tplDetail->assign("user_id","$user_id");
$tplDetail->assign("num_days",getHowManyDaysRemains($timestamp_expire_date,time()));
$tplDetail->assign("LA_REMOVE_FAV",urldecode(LA_REMOVE_FAV));
$tplDetail->assign("LA_ADD_FAV",urldecode(LA_ADD_FAV));
$tplDetail->assign("set_image_program",$set_image_program);
// mod_rewrite tags
$tplDetail->assign("link_adcat",linkCat($catid));
$tplDetail->assign("link_aduser",linkUser($user_id));
// Print out linked title
writeLinkedTitle(getCategoryId($ad_id));
if ($set_detail_login_need==1)
check_valid_user("");
if ($hide_email==1)
$tplDetail->assign("hide_email",1);
else
$tplDetail->assign("email","$email");
// Member Rating
if ($set_vote_on_member)
$tplDetail->assign("rate_member",$set_vote_on_member);
if ($set_ratemem_login_need)
$tplDetail->assign("rate_member_requires_login","$set_ratemem_login_need");
if ($voters > 0)
$votes = round($votes/$voters, 1);
else {
$votes=0;
$voters=0;
}
$tplDetail->assign("sold","$sold");
$tplDetail->assign("ad_member_votes","$votes");
$tplDetail->assign("ad_member_voters","$voters");
// Ad Rating
if ($set_rate)
$tplDetail->assign("rate_ad","$set_rate");
if ($set_rate_ad_require_member)
$tplDetail->assign("rate_ad_requires_login","$set_rate_ad_require_member");
// Get image rating
$lStr=getStarRating($ad_totalscore);
$tplDetail->assign("ad_vote_img_result","$lStr");
$tplDetail->assign("ad_ad_votes","$ad_votes");
$tplDetail->assign("ad_ad_voters","$ad_voters");
$tplDetail->assign("ad_totalscore","$ad_totalscore");
// Code for prev next result
if ($sold == 1)
$tplDetail->assign("isSold",1);
$tplDetail->assign("IS_VENDOR","$is_vendor");
$tplDetail->assign("VENDOR_URL",strEnc($vendor_url));
$tplDetail->assign("VENDOR_HOMEPAGE",strEnc($vendor_homepage));
$sql_prevad_id = "select ad_id from $ads_tbl, $cat_tbl, $usr_tbl where cat_id=ad_cat_id AND ad_owner=user_id AND ad_id < $ad_id AND cat_id = $catid $val_string order by ad_id desc limit 1";
$result_prevad_id = q($sql_prevad_id);
$row_prev = mysql_fetch_array($result_prevad_id);
$prevad_id = $row_prev["ad_id"];
$sql_nextad_id = "select ad_id from $ads_tbl, $cat_tbl, $usr_tbl where cat_id=ad_cat_id AND ad_owner=user_id AND ad_id > $ad_id AND cat_id = $catid $val_string order by ad_id asc limit 1";
$result_nextad_id = q($sql_nextad_id);
$row_next = mysql_fetch_array($result_nextad_id);
$nextad_id = $row_next["ad_id"];
// PREV NEXT AD
if ($prevad_id)
{
$lLinkPrev=linkDetail($prevad_id);
if (ereg("\?",$lLinkPrev))
$lLinkPrev.="&catid=" . $catid;
else
$lLinkPrev.="?catid=" . $catid;
$str_nav.="";
$str_nav.="
".LA_P."";
$tplDetail->assign("prev_link",$lLinkPrev);
}
$str_nav.=" ";
if ($nextad_id)
{
$lLinkNext=linkDetail($nextad_id);
if (ereg("\?",$lLinkNext))
$lLinkNext.="&catid=" . $catid;
else
$lLinkNext.="?catid=" . $catid;
$str_nav.="";
$str_nav.=LA_N . " 
";
$tplDetail->assign("next_link",$lLinkNext);
}
$tplDetail->assign("navigation","$str_nav");
////////if (getParam("contact","")!="") include "contact.php";
if (getParam("tellafriend",""))
include "tellafriend.php";
$fExtraArray=getFieldArray($ad_id,$user_id,",");
$tplDetail->assign("ads",$fExtraArray["ad"][$ad_id]);
$tplDetail->assign("users",$fExtraArray["user"][$user_id]);
if ($set_favourites AND isset($_SESSION["valid_user"]))
{
$sql = "select fid from $fav_tbl where f_adid=$ad_id AND f_user_id = ".$_SESSION["valid_user"];
$r = mysql_query($sql);
$number = mysql_num_rows($r);
if ($number)
$tplDetail->assign("fav_remove_link",1);
else
$tplDetail->assign("fav_add_link",1);
}
$query = "select * from $vid_tbl where video_adid=$ad_id";
$sql_result = q($query);
while ($row=mysql_fetch_array($sql_result))
{
$id = $row["video_id"];
$filename_stored = $row["video_file"];
$array = split("\.",$filename_stored);
$last=count($array)-1;
$ext=$array[$last];
$videoArray[$i]["file"]=$filename_stored;
$videoArray[$i]["id"]=$id;
$videoArray[$i]["ext"]=strtolower($ext);
$i++;
}
$tplDetail->assign("video_list",$videoArray);
$query = "select * from $doc_tbl where f_adid=$ad_id order by f_id desc";
$sql_result_doc = q ($query);
$i=0;
while ($row=mysql_fetch_array($sql_result_doc))
{
$id = $row["f_id"];
$filetype = $row["filetype"];
$filename = $row["f_file"];
$fArray[$i]["id"] = $id;
$fArray[$i]["name"] = $filename;
$lSize=filesize("images/docs/" . $filename);
$fArray[$i]["size"] = round($lSize/1024);
$lDisplay=ereg_replace($ad_id . "_","",$filename);
$fArray[$i]["display_name"] = $lDisplay;
$lExtArray=split("\.",$filename);
$lExt=end($lExtArray);
$fArray[$i]["ext"] = strtolower($lExt);
$i++;
}
$tplDetail->assign("doc_list", $fArray);
$query = "select id,filename from $pic_tbl where pic_ad_id=$ad_id";
$sql_result = q($query);
$num_ad_has_pictures = mysql_num_rows($sql_result);
for ($i=0; $i<$num_ad_has_pictures; $i++)
{
$row = mysql_fetch_array($sql_result);
$id = $row["id"];
$filename_stored = $row["filename"];
if ($set_image_program==0)
{
$lSizeArray=setImageSize($filename_stored,getManualSize("small"),0);
$imgArray[$i]["w"]=$lSizeArray[0];
$imgArray[$i]["h"]=$lSizeArray[1];
}
else
$filename_stored=ereg_replace("tmb2","tmb1",$filename_stored);
$lFileOrig=ereg_replace("_tmb1","",$filename_stored);
$lFileOrig=ereg_replace("_tmb2","",$lFileOrig);
$imgArray[$i]["file"]=$filename_stored;
$imgArray[$i]["file_large"]=$lFileOrig;
$imgArray[$i]["id"]=$id;
$imgArray[$i]["nr"]=$i;
}
if ($set_image_program==0)
$tplDetail->assign("image_max",getManualSize("small"));
$tplDetail->assign("image_list",$imgArray);
$tplDetail->assign("set_slideshow",$set_slideShow);
$tplDetail->assign("set_slideShow_sec",$set_slideShow_sec*1000);
$tplDetail->assign("set_slideShow_count_from",$set_slideShow_sec);
$tplDetail->assign("num_pictures",$num_ad_has_pictures);
$tplDetail->assign("show_still",getParam("show_still",""));
$s = "UPDATE $ads_tbl set ad_views=ad_views+1 where ad_id=$ad_id";
$result1=q($s);
$tplDetail->display("single_detail.tpl");
include "single_contact.php";
if (empty($lPrint))
include_once("singlefooter_inc.php");
else
echo formatString("".LA_PRINT_CLEAN."", array(formatDate(date("Ymd")),date("H:m"),"http://$url/detail.php?id=$ad_id"));
?>