$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; }