$row_count = $result_count->fetchRow();
$class_category[$i]['count'] = $row_count['aid'];
}
$i++;
}
$tpl->assign('class_category', $class_category);
}
//hirdetesek listaja
if (isset($cid)) {
//lekerdezzuk, hogy lathatja-e ezt a kategoriat
$query = "\n\t\t\tSELECT c.category_id AS cid, c.category_name AS cname, c.category_desc AS cdesc, c.picture AS cpic \n \t\tFROM iShark_Classifieds_Category c \n \t\tLEFT JOIN iShark_Classifieds_Groups ag ON ag.category_id = c.category_id\n \t\tWHERE (ag.category_id IS NULL {$grp_where}) AND c.is_active = '1' AND c.category_id = {$cid} AND \n \t\t\t(c.timer_start = '0000-00-00 00:00:00' OR (c.timer_start < NOW() AND c.timer_end > NOW()))\n\t\t";
$result =& $mdb2->query($query);
if ($result->numRows() > 0) {
//breadcrumb
include_once $include_dir . '/function.classifieds.php';
$category = get_classifieds_breadcrumb_category($cid, $ugroups);
$cat1 = explode(";", $category);
$cat2 = array();
foreach ($cat1 as $key => $value) {
if (!empty($value)) {
$robbant = explode("#@#", $value);
$cat2[$robbant[0]] = $robbant[1];
}
}
$cat_array = array_reverse($cat2, true);
foreach ($cat_array as $key => $value) {
if (!empty($_SESSION['site_class_is_breadcrumb'])) {
$class_breadcrumb->add($value, 'index.php?' . $self_class . '&act=lst&cid=' . $key);
}
}
$category_name = $value;
/**
* get_classifieds_breadcrumb_category - Rekurz�v men�k�r�s - visszafele
*
* @param int $parent
* @access public
* @return void
*/
function get_classifieds_breadcrumb_category($parent)
{
global $mdb2;
$ret = "";
$query = "\n\t\tSELECT category_id, parent, category_name \n\t\tFROM iShark_Classifieds_Category \n\t\tWHERE category_id = {$parent} AND category_id != 0\n\t";
$result =& $mdb2->query($query);
while ($row = $result->fetchRow()) {
$ret .= '' . $row['category_id'] . '#@#' . htmlspecialchars($row['category_name']) . ';';
$ret .= get_classifieds_breadcrumb_category($row['parent']);
}
return $ret;
}
