$isSubcats = getSqlNumber("SELECT id FROM probid_categories WHERE parent='".$_REQUEST['parent']."'");
if ($isSubcats>0) { ?>
## if store is active and listin!=auction only activate the store categories
$adCatQuery = "";
$selectedCats = getSqlField("SELECT store_categories FROM probid_users WHERE id='".$_GET['userid']."'","store_categories");
if ($selectedCats!=""&&($_REQUEST['parent']==0||trim($_REQUEST['parent'])=="")) {
$store_cats_array = substr($selectedCats,0,-1);
$adCatQuery = " AND id IN ($store_cats_array) ";
}
$getSubCategories=mysql_query("SELECT id,items_counter FROM probid_categories WHERE parent='".$_REQUEST['parent']."' ".$adCatQuery." ORDER BY theorder ASC, name ASC");
while ($subCategories=mysql_fetch_array($getSubCategories)) { ?>
» echo $c_lang[$subCategories['id']]?> |
} ?>
|
} ?>
if ($setts['buyout_process']==0) { ?>
} ?>
|
|
|
|
if ($setts['buyout_process']==0) { ?>
|
} ?>
|
|
// newest function
if ($_GET['start'] == "") $start = 0;
else $start = $_GET['start'];
$limit = 20;
$croot = $_REQUEST['parent'];
$cntr=0;
while ($croot>0) {
$crw = getSqlRow("SELECT * FROM probid_categories WHERE id='$croot'");
if($cntr == 0) {
$catname = $crw['name'];
} else {
if($crw['parent'] != $croot) {
$catname = "$crw[name] : $catname";
}
}
$cntr++;
$croot = $crw['parent'];
}
$catname = trim($catname);
## get all subcats
reset($cat_array);
if ($catname!="") {
while (list($cat_array_id, $cat_array_details)=each($cat_array)) {
list($cat_array_name, $userid) = $cat_array_details;
$strResult = strpos($cat_array_name,$catname);
if (trim($strResult)=="0") $cat_id[$catcnt++] = $cat_array_id;
}
$all_subcats = implode (",",$cat_id);
$subcatquery="(a.category IN (".$all_subcats.") OR a.addlcategory IN (".$all_subcats.")) AND ";
} else {
$subcatquery = "";
}
$mysqlVersion = substr(mysql_get_server_info(),0,1);
$additionalVars = "&userid=".$_REQUEST['userid']."&parent=".$_REQUEST['parent']."&basicsearch=".$_REQUEST['basicsearch'];
if (!empty($_REQUEST['basicsearch'])) $searchQuery = " AND keywords LIKE '%".$_REQUEST['basicsearch']."%' ";
if ($mysqlVersion>=4) {
$additionalQuery = "SQL_CALC_FOUND_ROWS ";
} else {
## this is only used if the mySql is older than v4. Slower version
$nbItems = getSqlNumber("SELECT DISTINCT a.id, a.itemname, a.picpath, a.maxbid, a.currency,
a.nrbids, a.enddate FROM probid_auctions a WHERE
".$subcatquery."
a.active=1 AND a.closed=0 AND a.deleted!=1 AND a.listin!='auction' AND ownerid='".$_GET['userid']."' ".$searchQuery."
ORDER BY a.".$orderField." ".$orderType);
}
$getAuctions = mysql_query("SELECT ".$additionalQuery." DISTINCT a.id, a.itemname, a.hpfeat, a.picpath, a.maxbid, a.currency, a.bn, a.bnvalue,
a.nrbids, a.enddate, a.bidstart, a.bn, a.bnvalue FROM probid_auctions a WHERE
".$subcatquery."
a.active=1 AND a.closed=0 AND a.deleted!=1 AND a.listin!='auction' AND ownerid='".$_GET['userid']."' ".$searchQuery."
ORDER BY a.".$orderField." ".$orderType." LIMIT $start,$limit");
if ($mysqlVersion>=4) $nbItems = mysql_result(mysql_query("Select FOUND_ROWS() AS nbr"),0,"nbr");
if ($nbItems==0) {
echo "".$lang[nostore]." | ";
} else {
if ($nbItems>($start+$limit)) $final = $start+$limit;
else $final = $nbItems;
while ($auction = mysql_fetch_array($getAuctions)) { ?>
">
echo " $auction['itemname'], 'id' => $auction['id']))."\">";
echo "";
echo ""; ?>
|
| |