echo "<td class=\"classadd2\">{$dbcat['name']}</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td class=\"classadd1\"><div class=\"maininputleft\">{$adadd_subcat}</div></td>\n";
echo "<td class=\"classadd2\"><select name=\"subcatid\">\n";
echo "{$optionsubcat}</select></td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td class=\"classadd2\"></td>\n";
echo "<td class=\"classadd2\"><br><input type=submit value={$adadd_submit}></td>\n";
echo "</tr>\n";
echo "</table>\n";
echo "</form>\n";
} elseif ($subcatid || $editadid) {
if ($sales_option) {
if (!sales_checkaccess(2, $_SESSION[suserid], $catid)) {
// check access for user and cat
open_sales_window();
echo "<script language=javascript>location.replace('classified.php');</script>";
}
}
if (strpos($client, "MSIE")) {
// Internet Explorer Detection
$field_size = "50";
$text_field_size = "30";
$input_field_size = "28";
} else {
$field_size = "28";
$text_field_size = "20";
$input_field_size = "14";
}
}
}
} else {
echo " ";
}
echo " </div>";
echo " </td>\n";
echo " </tr>\n";
}
//End while
# Sub Categories
#################################################################################################
} else {
// show the subcategories
if ($sales_option) {
if (!sales_checkaccess(1, $_SESSION['suserid'], $catid)) {
// check access for user and cat
open_sales_window();
#echo "<script language=javascript>location.replace('classified.php?textmessage=$sales_lang_noaccess');</script>";
echo "<script language=javascript>location.replace('classified.php');</script>";
}
}
$result = mysql_query("SELECT * FROM " . $prefix . "adcat WHERE id='{$catid}' AND disabled<>'1'") or died("Record NOT Found");
$db = mysql_fetch_array($result) or died("Category NOT Found");
echo "<table align=\"center\" cellspacing=\"0\" cellpadding=\"3\" width=\"100%\" border=\"0\">\n";
echo "<tr><td><div class=\"maincatnav\">";
echo "<a href=\"classified.php\" onmouseover=\"window.status='{$ad_home}'; return true;\"\n onmouseout=\"window.status=''; return true;\">{$ad_home}</a> / {$db['name']}\n";
echo "</td></tr></table>";
echo "<table align=\"center\" cellspacing=\"1\" cellpadding=\"3\" width=\"100%\" border=\"0\">\n";
$result = mysql_query("SELECT * FROM " . $prefix . "adsubcat where catid={$catid} ORDER by id") or died("Record NOT Found");
while ($db = mysql_fetch_array($result)) {
// check access for user and cat
ico_email("", "left");
} else {
ico_email("adid={$db['id']}", "left");
}
if ($dbu[icq]) {
if ($sales_option && !sales_checkaccess(3, $_SESSION[suserid], $db[catid])) {
// check access for user and cat
ico_icq("", "left");
} else {
ico_icq("{$dbu['icq']}", "left");
}
}
ico_friend("catid={$db['catid']}&subcatid={$db['subcatid']}&adid={$db['id']}", "left");
if ($show_url && $dbu[homepage]) {
if ($sales_option && !sales_checkaccess(3, $_SESSION[suserid], $catid)) {
// check access for user and cat
ico_url("", "left");
} else {
ico_url("{$dbu['homepage']}", "left");
}
}
ico_print("", "left");
if ($show_adrating && $_SESSION[suserid]) {
ico_adrating("adid={$db['id']}", "left");
}
if ($show_members_details && $_SESSION[suserid]) {
ico_info("choice=details&uid={$dbu['id']}&uname={$dbu['username']}", "left");
}
echo " <div class=\"smallright\">{$ad_nr}{$db['id']}</div>";
echo " <a href=\"favorits.php?deladid={$db['id']}\" onClick='enterWindow=window.open(\"favorits.php?" . sidstr() . "deladid={$db['id']}\",\"Delete\",\"width=400,height=200,top=100,left=100\"); return false'\n onmouseover=\"window.status='{$adfav_delete}'; return true;\"\n onmouseout=\"window.status=''; return true;\">\n <img src=\"{$image_dir}/icons/trash.gif\" border=\"0\" alt=\"{$adfav_delete}\" align=\"right\" vspace=\"6\"></a>\n";
if ($npoffset < 0) {
$npoffset = 0;
}
if ($npoffset > $maxpoffset) {
$npoffset = $maxpoffset;
}
echo "[<a href=\"classified.php?sqlquery={$nsqlquery}&sqlquery2={$nsqlquery2}&sqlquery3={$nsqlquery3}&offset={$noffset}&poffset={$npoffset}\" onmouseover=\"window.status='{$nav_next}'; return true;\" onmouseout=\"window.status=''; return true;\">></a>]\n";
}
}
echo "</div></td></tr>\n";
echo "</table>\n";
$sqlquery = "SELECT * FROM " . $prefix . "ads" . stripslashes($sqlquery . $sql2 . $sqlquery3) . " LIMIT {$offset}, {$perpage}";
$result = mysql_query("{$sqlquery}") or died("SQL Error: {$sqlquery}");
echo "<table align=\"center\" cellspacing=\"1\" cellpadding=\"3\" width=\"100%\" border=\"0\">\n";
while ($db = mysql_fetch_array($result)) {
$result2 = mysql_query("SELECT * FROM " . $prefix . "userdata WHERE id={$db['userid']}") or died("Record NOT Found");
$dbu = mysql_fetch_array($result2);
$result3 = mysql_query("SELECT * FROM " . $prefix . "adcat WHERE id={$db['catid']}") or died("Record NOT Found");
$dbc = mysql_fetch_array($result3);
if ($sales_option && $sqlquery && !sales_checkaccess(1, $_SESSION[suserid], $db[catid])) {
// check access for user and cat
// if no acces to cat, do nothing :-)
} else {
include "classified_ads.inc.php";
}
}
//End while
echo "</table>\n";
}
# End of Page reached
#################################################################################################
