<?php $query = sprintf("\r\n SELECT\r\n category_id, \r\n category_parent_id, \r\n category_name\r\n FROM \r\n %1\$s \r\n WHERE \r\n category_parent_id = '0' \r\n ORDER BY \r\n category_order \r\n ASC", TABLE_CATEGORY); $db->query($query); while ($db->next_record()) { $cat_id = $db->f("category_id"); $cat_parent_id = $db->f("category_parent_id"); $cat_name = $db->f("category_name"); if ((bool) $rewrite) { $cat_link = '1,' . $cat_id . ',4,item.html'; } else { $cat_link = 'index.php?p=4&id=' . $cat_id . ''; } $ft->assign(array('CAT_NAME' => replace_amp($cat_name), 'CAT_LINK' => $cat_link, 'CLASS' => "cat_parent", 'PARENT' => '')); $ft->define_dynamic("category_row", $assigned_tpl); $ft->parse('CATEGORY_ROW', ".category_row"); // funkcja pobieraj±ca rekurencyjnie strony dziedzicz±ce::child get_category_cat($cat_id, 2); }
function get_category_cat($cat_id, $level) { global $ft, $rewrite; $query = sprintf("\r\n SELECT \r\n category_id, \r\n category_parent_id, \r\n category_name \r\n FROM \r\n %1\$s \r\n WHERE \r\n category_parent_id = '%2\$d' \r\n ORDER BY \r\n category_id \r\n ASC", TABLE_CATEGORY, $cat_id); $db = new DB_SQL(); $db->query($query); while ($db->next_record()) { $cat_id = $db->f("category_id"); $cat_parent_id = $db->f("category_parent_id"); $cat_name = $db->f("category_name"); $cat_link = (bool) $rewrite ? '1,' . $cat_id . ',4,item.html' : 'index.php?p=4&id=' . $cat_id . ''; $ft->assign(array('CAT_NAME' => $cat_name, 'NEWS_CAT' => $cat_id, 'CLASS' => "cat_child", 'PARENT' => str_repeat(' ', $level), 'CAT_LINK' => $cat_link)); $ft->parse('CATEGORY_ROW', ".category_row"); get_category_cat($cat_id, $level + 2); } }