(大概33行起替换)
/**
* 获得指定分类同级的所有分类以及该分类下的子分类
*
* @access public
* @param integer $cat_id 分类编号
* @return array
*/
function get_categories_tree($cat_id = 0)
{
if ($cat_id > 0)
{
$sql = ‘SELECT parent_id FROM ‘ . $GLOBALS['ecs']->table(‘category’) . ” WHERE cat_id = ‘$cat_id’”;
$parent_id = $GLOBALS['db']->getOne($sql);
$row = $GLOBALS['db']->getRow(‘SELECT parent_id ,(SELECT COUNT(*) FROM ecs_category b WHERE b.parent_id = a.cat_id ) AS has_children FROM ‘ . $GLOBALS['ecs']->table(‘category’) .” AS a WHERE cat_id = ‘$cat_id’”);
if($row['has_children']==”0″)
{
$parent_id = $row['parent_id'];
}
else
{
$parent_id = $cat_id;
}
}
else
{
$parent_id = 0;
}
› 最近评论