hello
My files detail.php
<?
session_start();
$counter = 0;
$wsize=100;
$hsize=100;
$cur_grade = 0;
$cur_user_grade = 0;
$cur_grade=0;
$pre = "";
include_once("admin/inc.php");
$catname = " :: $ad_details_text";
if (isset($_REQUEST["print"]))
$print = 1;
if (isset($_REQUEST["siteid"]))
$siteid = round($_REQUEST["siteid"]);
if (isset($_REQUEST["pre"]))
$pre = round($_REQUEST["pre"]);
if (!isset($print))
include_once("header_inc.php");
if (!$special_mode)
{
if (!isset($print))
include("navigation.php");
else {
print "<script language='javascript'>window.print()</script>";
print "<p><a href='detail.php?siteid=$siteid'><h2>$la_p</h2></a></p>";
}
}
// Print out linked title
writeLinkedTitle(getCategoryId($siteid));
if ($set_detail_login_need==1)
check_valid_user("");
// 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)) { $siteid = $preview; $validation = 0; }
if ($validation == 1 AND empty($pre)) { $val_string = " AND valid = 1"; } else { $val_string = ""; }
$sql_links = "select * from $ads_tbl, $cat_tbl, $usr_tbl where catid=sitecatid AND ad_username = $usr_tbl.email AND siteid=$siteid $val_string";
$sql_result = q ($sql_links);
$num_links = mysql_num_rows($sql_result);
for ($i=0; $i<$num_links; $i++)
{
$row = mysql_fetch_array($sql_result);
$row2 = $row;
$siteid = $row["siteid"];
$sitetitle = $row["sitetitle"];
$sitedescription = $row["sitedescription"];
$userid = $row["userid"];
$sitedate = $row["sitedate"];
$sitehits = $row["sitehits"];
if (!$sitehits)
$sitehits = 1;
$sitevotes = $row["sitevotes"];
$sitevoters = $row["sitevoters"];
$votes = $row["votes"];
$voters = $row["voters"];
$name = $row["name"];
$phone = $row["phone"];
$email = $row["email"];
$adressfield1 = $row["adressfield1"];
$adressfield2 = $row["adressfield2"];
$catname = $row["catname"];
$catid = $row["catid"];
$catid = $row["catid"];
$vendor_url = $row["vendor_url"];
$vendor_homepage = $row["vendor_homepage"];
$usr_1 = $row["usr_1"];
$usr_2 = $row["usr_2"];
$usr_3 = $row["usr_3"];
$usr_4 = $row["usr_4"];
$usr_5 = $row["usr_5"];
$sold = $row["sold"];
$cattpl = $row["cattpl"];
$datestamp = $row["datestamp"];
$picture = $row["picture"];
$is_vendor = $row["is_vendor"];
$hide_email = $row["hide_email"];
$img_stored = $row["img_stored"];
$expire_days = $row["expire_days"];
//$expire_ad = $row["expiredate"];
$year=substr($row["datestamp"],0,4);
$month=substr($row["datestamp"],4,2);
$day=substr($row["datestamp"],6,2);
if ($voters > 0)
{
$sum = $votes/$voters;
$cur_user_grade = round($sum, 1);
}
$sitedescription = preg_replace( "/(?<!<a href=\")((http|ftp)+(s)?:\/\/[^<>\s]+)/i", "<a href=\"\\0\" target='new'>\\0</a>", $sitedescription );
// Date_format grabbed from settings...
$date_added_1 = $date_format;
$date_added_1 = ereg_replace("d", "$day", $date_added_1);
$date_added_1 = ereg_replace("m", "$month", $date_added_1);
$date_added_1 = ereg_replace("y", "$year", $date_added_1);
$sitedate1 = $date_added_1;
// If vote enabled, use this
if ($sitevoters and $sitevotes)
{
$cur_grade = round($sitevotes / $sitevoters, 1);
}
if ($expire_days_option)
{
//find ($year, $month, $day, $expire_days);
$num_days = getNumDaysRemain($row["datestamp"],$expire_days); # If user-supplied expire date
$delete_ad = getExpireDate($row["datestamp"],$expire_days); # If system expire date
}
else
{
//find ($year, $month, $day, $delete_after_x_days);
$num_days = getNumDaysRemain($row["datestamp"],$delete_after_x_days); # If system expire date
$delete_ad = getExpireDate($row["datestamp"],$delete_after_x_days); # If system expire date
}
if ($num_days<0 AND $auto)
{
updateExpireAds("");
}
?>
<!-- 1 -->
<table border="0" width="100%" bgcolor="<? echo $set_outer_color ?>" cellspacing="0" cellpadding="0">
<tr>
<td width="100%" height="1"><img border="0" src="layout_images/spacerbig.gif" width="1" height="1" /></td>
</tr>
</table>
<!-- // 1 -->
<script language="JavaScript">
<?
if (!empty($magic_xlarge_size))
{
$split = split("x",$magic_xlarge_size);
$size_1 = $split[1]+70;
$size_2 = $split[0]+70;
}
if (empty($size_1) OR empty($size_2))
{
$size_1 = 300;
$size_2 = 300;
}
?>
function openWin(URL) { aWindow=window.open(URL,_new,"toolbar=no,width=<? echo $wsize ?>,height=<? echo $hsize ?>,status=no,scrollbars=no,resize=no,menubars=no",true);
aWindow.resizeTo(<? echo $wsize ?>, <? echo $hsize ?>)
}
function openWin2(URL) {
aWindow=window.open(URL,"Large","toolbar=no,width=400,height=350,status=no,scrollbars=no,resize=no,menubars=no");
}
</script>
<!-- 1 -->
<table border="0" width="100%" cellspacing="0" cellpadding="10">
<tr>
<td>
<!-- 2 -->
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td>
<span class="title"><? echo $sitetitle ?></span>
<br /><br />
<?
// Code for prev next result
if ($sold == 1)
{
print "<p> <b>$la_sold</b> </p>";
}
if ($vendor_url AND $set_vendor AND $is_vendor)
{
print "<a href='$vendor_homepage' target='new'><img src='$vendor_url' border='0'></a>";
}
print "<center>";
$sql_prevsiteid = "select siteid from $ads_tbl, $cat_tbl, $usr_tbl where catid=sitecatid AND ad_username = $usr_tbl.email AND siteid < $siteid AND catid = $catid $val_string order by siteid desc limit 1";
$result_prevsiteid = q($sql_prevsiteid);
$row_prev = mysql_fetch_array($result_prevsiteid);
$prevsiteid = $row_prev["siteid"];
$sql_nextsiteid = "select siteid from $ads_tbl, $cat_tbl, $usr_tbl where catid=sitecatid AND ad_username = $usr_tbl.email AND siteid > $siteid AND catid = $catid $val_string order by siteid asc limit 1";
$result_nextsiteid = q($sql_nextsiteid);
$row_next = mysql_fetch_array($result_nextsiteid);
$nextsiteid = $row_next["siteid"];
if ($prevsiteid)
{
print "<a href='detail.php?siteid=$prevsiteid&catid=$catid'><img src='layout_images/arrow-back.gif' border='0' /> $la_p</a>";
}
print " ";
if ($nextsiteid)
{
print "<a href='detail.php?siteid=$nextsiteid&catid=$catid'>$la_n <img src='layout_images/arrow-forw.gif' border='0' /></a>";
}
print "</center>";
// End of Code for prev next result
?>
<p />
<!-- 3 -->
<table border="0" width="100%" cellspacing="0" cellpadding="0"><tr><td width="100%">
<!-- 4 -->
<table border="0" width="100%" cellspacing="0" cellpadding="0"><tr><td width="100%" valign="top" align="left">
<!-- 5 -->
<table border="0" width="100%" cellspacing="0" cellpadding="0"><tr><td valign="top" align="left">
<?
if ($nl2br == 1)
{
$sitedescription = nl2br($sitedescription);
}
?>
<?
if (isset($_REQUEST["contact"]))
{
include "contact.php";
}
if (isset($_REQUEST["tellafriend"]))
{
include "tellafriend.php";
}
?><p>
<!-- 6 -->
<table border="0" bgcolor="<? echo $set_outer_color ?>" cellspacing="0" cellpadding="1" width="100%"><tr><td>
<!-- 7 -->
<table border="0" bgcolor="<? echo $set_descr_color ?>" cellspacing="0" cellpadding="<? echo $set_descr_cell ?>" width="100%"><tr><td valign="top" align="left">
<b><? print(" $description ");?></b><br /><? print(" $sitedescription "); ?>
</td></tr>
</table>
<!-- // 7 -->
</td></tr>
</table>
<!-- // 6 -->
<!-- 6 -->
<table border="0" cellpadding="1" cellspacing="1" width="90%">
<tr><td>
<br />
</td>
<td></td>
</tr>
<tr>
<td colspan="2"><b> <? echo $general_details ?></b> </td>
</tr>
<tr>
<td> <? echo $sold_by_text?></td>
<td> <? echo $name ?>
<?
if ($set_vote_on_member)
{
if ($set_ratemem_login_need)
{
if (isset($_SESSION["valid_user"]))
{
echo " ($votes/# $voters) <small> <a href='javascript:openWin2(\"rate_user.php?id=$siteid\")'><u>$la_grade $name</u></a> </small>";
}
}
else
{
echo " ($votes/# $voters) <small> <a href='javascript:openWin2(\"rate_user.php?id=$siteid\")'><u>$la_grade $name</u></a> </small>";
}
}
?>
</td>
</tr>
<tr>
<td> <? echo $add_user_email ?></td>
<td>
<?
if ($email)
{
if ($hide_email == 1)
{
print "<a href=\"detail.php?siteid=$siteid&contact=1\">$la_contact_sale</a>";
}
else
{
print "<a href='mailto:$email'>$email</a>";
}
}
else
{
print $la_call;
}
?>
</td>
</tr>
<?
if ($adressfield1 OR $adressfield2)
{
print("<tr>");
print("<td> $location_text</td>");
print("<td> $adressfield1, $adressfield2</td>");
print("</tr>");
}
if ($phone)
{
print("<tr>");
print("<td> $add_user_phone</td>");
print("<td> $phone</td>");
print("</tr>");
}
if (isset($usr_1_text) AND isset($usr_1))
{
print("<tr>");
print("<td> $usr_1_text</td>");
if ($usr_1_link)
{
$usr_1=eregi_replace("http://","",$usr_1);
echo "<td>";
if (!empty($usr_1))
print "<a href='http://$usr_1' target='_blank'>$la_link</a>";
echo "</td>";
}
else {
print("<td> $usr_1</td>");
}
print("</tr>");
}
if (isset($usr_2_text) AND isset($usr_2))
{
print("<tr>");
print("<td> $usr_2_text</td>");
if ($usr_2_link)
{
$usr_2=eregi_replace("http://","",$usr_2);
echo "<td>";
if (!empty($usr_2))
print "<a href='http://$usr_2' target='_blank'>$la_link</a>";
echo "</td>";
}
else {
print("<td> $usr_2</td>");
}
print("</tr>");
}
if (isset($usr_3_text) AND isset($usr_3))
{
print("<tr>");
print("<td> $usr_3_text</td>");
if ($usr_3_link)
{
$usr_3=eregi_replace("http://","",$usr_3);
echo "<td>";
if (!empty($usr_3))
print "<a href='http://$usr_3' target='_blank'>$la_link</a>";
echo "</td>";
}
else {
print("<td> $usr_3</td>");
}
print("</tr>");
}
if (isset($usr_4_text) AND isset($usr_4))
{
print("<tr>");
print("<td> $usr_4_text</td>");
if ($usr_4_link)
{
$usr_4=eregi_replace("http://","",$usr_4);
echo "<td>";
if (!empty($usr_4))
print "<a href='http://$usr_4' target='_blank'>$la_link</a>";
echo "</td>";
}
else {
print("<td> $usr_4</td>");
}
print("</tr>");
}
if (isset($usr_5_text) AND isset($usr_5))
{
print("<tr>");
print("<td> $usr_5_text</td>");
if ($usr_5_link)
{
$usr_5=eregi_replace("http://","",$usr_5);
echo "<td>";
if (!empty($usr_5))
print "<a href='http://$usr_5' target='_blank'>$la_link</a>";
echo "</td>";
}
else {
print("<td> $usr_5</td>");
}
print("</tr>");
}
$sql = "select cattpl from $cat_tbl where catid = ".getCategoryId($siteid);
$result_1 = q($sql);
$row_cat = mysql_fetch_array($result_1);
$cattpl = $row_cat["cattpl"];
$string = "select * from $q_tbl where q_tpl = '$cattpl' OR q_tpl = 1 order by q_seq";
$result = mysql_query ($string);
$fieldid = 0;
while ($tpl=mysql_fetch_array($result))
{
$q_field = $tpl["q_field"];
$q_question = $tpl["q_question"];
$q_size = $tpl["q_size"];
$q_type = $tpl["q_type"];
$q_catdescr = $tpl["q_catdescr"];
$q_seq = $tpl["q_seq"];
$q_page = $tpl["q_page"];
$q_mand = $tpl["q_mand"];
$q_tpl = $tpl["q_tpl"];
$q_isurl = $tpl["q_isurl"];
$q_between = $tpl["q_between"];
$q_include_search = $tpl["q_include_search"];
$fieldname = "e_" . $q_field;
if ($q_catdescr)
echo "<tr><td colspan='2'><br><b>$q_catdescr</b></td></tr>";
echo "<tr><td>$q_question";
echo "</td><td>";
$val = "";
$array = array();
if (isset($row["$fieldname"]))
{
$val = $row["$fieldname"];
if ($q_type<>"t" AND $q_type<>"d")
{
$array = split(",",$val);
echo showItems($q_type,"e_".$q_field,$q_field,$q_size,$q_mand,$array,$q_isurl);
}
else
{
echo showItems($q_type,"e_".$q_field,$q_field,$q_size,$q_mand,"$val",$q_isurl);
}
}
echo "</td></tr>";
}
?>
<tr>
<td><br />
</td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
</tr>
<tr>
<td colspan="2"><b> <? echo $ad_details_text ?> </b> </td>
</tr>
<tr>
<td> <? echo $la_adid ?></td>
<td> <? echo $siteid ?></td>
</tr>
<tr>
<td> <? echo $ad_views ?> </td>
<td> <? echo $sitehits ?></td>
</tr>
<?
if ($advanced_delete_activated)
{
?>
<tr>
<td> <? echo $ad_expire ?></td>
<td>
<?
print "<b>$delete_ad </b> ($la_in $num_days $days)";
?>
</td>
</tr>
<?
}
?>
<tr>
<td> <? echo $date_added ?></td>
<td> <? echo $sitedate1 ?></td>
</tr>
<? if ($cur_grade) {?>
<tr>
<td> <? echo $la_curr_grade ?></td>
<td> <? echo $cur_grade ?> (# <? echo $sitevoters ?>)</td>
</tr>
<? } ?>
<tr><td colspan="2"> <p />
<?
if ($set_favourites AND isset($_SESSION["valid_user"]))
{
$sql = "select fid from $fav_tbl where f_adid=$siteid AND femail = '".$_SESSION["valid_user"]."'";
$r = mysql_query($sql);
$number = mysql_num_rows($r);
if ($number)
{
print "<a href=\"javascript:openWin2('fav_popup.php?remove_fav=$siteid')\"><img src='layout_images/garb.gif' border='0' align='left'> <b>$la_remove_fav</b></a>";
}
else
{
print "<a href=\"javascript:openWin2('fav_popup.php?add_fav=$siteid')\"><img src='layout_images/bookmark.gif' border='0' align='left'> <b>$la_add_fav</b></a>";
}
}
?>
</td></tr>
</table>
<!-- // 6 -->
</td><td width="20"><img src="layout_images/spacerbig.gif" width="10" height="5" alt="" /></td>
</tr>
</table>
<!-- // 5 -->
</td><td valign="top" align="right">
<?
$query = "select id,imageh,imagew,filename from $pic_tbl where pictures_siteid=$siteid";
$sql_result = mysql_query ($query);
$num_pictures = mysql_num_rows($sql_result);
for ($i=0; $i<$num_pictures; $i++)
{
?>
<!-- 5 -->
<table cellspacing="0" cellpadding="1" bgcolor="<? echo $set_outer_color ?>" border="0" width="100%"><tr><td>
<!-- 6 -->
<table border="0" width="100%" bgcolor="<? echo $set_inner_color ?>" cellspacing="0" cellpadding="5"><tr><td width="100%" align="center">
<?
if (!isset($_REQUEST["show_still"]) AND $set_slideShow AND $num_pictures>1)
{
print "<a href='detail.php?siteid=$siteid&show_still=1'><b>$la_show_still</b></a><p />";
include "pg_include.php";
}
if (isset($_REQUEST["show_still"]) OR !$set_slideShow OR (!isset($_REQUEST["show_still"]) AND $set_slideShow AND $num_pictures<2))
{
if ($set_slideShow AND $num_pictures>1)
print "<a href='detail.php?siteid=$siteid'><b>$la_show_show</b></a><p />";
$row = mysql_fetch_array($sql_result);
$w = $row["imagew"];
$h = $row["imageh"];
$id = $row["id"];
$filename_stored = $row["filename"];
$imgSizeArray = setImageSize($maxSize_large,$w,$h);
$imagehw = GetImageSize("images/$filename_stored");
$w = $imagehw[0]+30;
$h = $imagehw[1]+90;
if (!empty($set_gd) OR !empty($magic))
{
print "<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\"><tr><td width=\"100%\" align=\"center\">";
echo "<a href=\"large_picture.php?id=$id\" onclick=\"popWin = open('large_picture.php?id=$id','my','width=$w,height=$h');popWin.focus();popWin.resizeTo($w, $h);return false\">";
echo getOneImage($siteid,"$la_large_pic",$maxSize_large,$id)."<img border=\"0\" src=\"layout_images/zoom.gif\" width=\"19\" height=\"24\" alt='' /></a></td></tr></table>";
}
else
{
print "<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\"><tr><td width=\"100%\" align=\"center\">";
echo "<a href=\"large_picture.php?id=$id\" onclick=\"popWin = open('large_picture.php?id=$id','my','width=$w,height=$h');popWin.focus();popWin.resizeTo($w, $h);return false\">";
echo getOneImage($siteid,"$la_large_pic",$maxSize,$id)."<img border=\"0\" src=\"layout_images/zoom.gif\" width=\"19\" height=\"24\" alt='' /></a></td></tr></table>";
}
}
?>
</td></tr>
</table>
<!-- // 6 -->
</td></tr></table>
<!-- // 5 -->
<table border="0" width="100%" height="10" cellspacing="0" cellpadding="0">
<tr>
<td width="100%"></td>
</tr>
</table>
<?
}
?>
</td></tr></table>
<!-- // 4 -->
</td></tr><tr><td width="100%">
</td></tr>
</table>
<!-- // 3 -->
</td>
</tr>
</table>
<!-- // 2 -->
</td>
</tr>
</table>
<!-- // 1 -->
<table border="0" width="100%" bgcolor="#A9B8D1" cellspacing="0" cellpadding="0">
<tr>
<td width="100%" height="1"><img border="0" src="layout_images/spacerbig.gif" width="1" height="1" alt='' /></td>
</tr>
</table>
<table border="0" width="100%" cellspacing="0" cellpadding="10">
<tr>
<td width="100%">
<?
print("<table border='0' cellspacing='0' cellpadding='0'><tr><td><a href='index.php?catid=$catid'><img border='0' src='layout_images/icon_moreadsincat.gif' width='28' height='20'></a></td><td><a href='index.php?catid=$catid'>$la_similar</a>");
print("</td><td width='15'></td><td><a href='useritems.php?user_siteid=$siteid'><img border='0' src='layout_images/icon_adsfromseller.gif' width='28' height='20'></a></td><td><a href='useritems.php?user_siteid=$siteid'>$la_similar_ads</a>");
print("</td><td width='15'></td><td><a href=\"detail.php?siteid=$siteid&contact=1\"><img border='0' src='layout_images/icon_contactsalesperson.gif' width='28' height='20'></a></td><td><a href=\"detail.php?siteid=$siteid&contact=1\">$la_contact_sale</a>");
print("</td><td width='15'></td><td><a href=\"detail.php?siteid=$siteid&tellafriend=1\"><img border='0' src='layout_images/icon_tellafriend.gif' width='28' height='20'></a></td><td><a href=\"detail.php?siteid=$siteid&tellafriend=1\">$la_tell_a_friend</a>");
if ($set_rate)
{
print("</td><td width='15'></td><td><a href=\"javascript:openWin2('rate.php?id=$siteid&adtitle=$sitetitle')\"><img border='0' src='layout_images/icon_tellafriend.gif' width='28' height='20'></a></td><td><a href=\"javascript:openWin2('rate.php?id=$siteid')\">$la_rate</a>");
}
?>
</td><td width="15"></td><td><a href="detail.php?siteid=<? echo $siteid ?>&print=1"><img border="0" src="layout_images/icon_print.gif" width="28" height="20"></a></td><td><a href="detail.php?siteid=<? echo $siteid ?>&print=1"><? echo $la_print ?></a>
</td></tr></table>
<?
}
if ($num_links == 0)
{
include_once("header_inc.php");
include_once("admin/inc.php");
include_once("navigation.php");
print "<p><img border='0' src='images/blank.gif' height='20' align='left'>";
print "<b>$la_ad_removed_caption</b><br>";
echo formatString($la_ad_removed_content,array("http://$url"));
print "</p></td></tr></table>";
include_once("footer_inc.php");
exit;
}
$tell=$sitehits+1;
$s = "UPDATE $ads_tbl set sitehits=$tell,datestamp='$datestamp' where siteid=$siteid";
$result1=q($s);
?>
</td>
</tr>
</table>
<?
if (!isset($print))
include_once("footer_inc.php");
else
echo formatString("<center>$la_print_clean</center>", array(formatDate(date("Ymd")),date("H:m"),"http://$url/detail.php?siteid=$siteid"));
?>