PHP get_cached_between Examples

Example #1

File: dbtree.php Project: pantofla/waterfan

function tree_to_array($root, $table, $showRoot = TRUE)
{
    // showRoot -- Do we want to include the "root" category named "all" in our results -- all subcats WILL appear regardless
    global $db;
    $row = get_cached_category_data('category__auto_id', $root);
    if (!$row) {
        $sqlfix = "UPDATE " . table_categories . " SET `category__auto_id` = '0' WHERE `category_name` = 'all' LIMIT 1;";
        $db->query($sqlfix);
        $row = $db->get_row($sql);
        if (!$row) {
            die('There is a problem with the categories table. Error CA:001.');
        }
    }
    $right = array();
    $result = get_cached_between($row->lft, $row->rgt);
    $i = 0;
    $lastspacer = 0;
    // added @ thanks to `parterburn` - http://www.pligg.com/forum/showthread.php?t=4888
    foreach ($result as $row) {
        if (count($right) > 0) {
            // check if we should remove a node from the stack
            while ($right[count($right) - 1] < $row->rgt) {
                if (array_pop($right) == NULL) {
                    break;
                    // We've reached the top of the category chain
                }
            }
        }
        $array[$i]['principlecat'] = $row->rgt - $row->lft - 1;
        $array[$i]['spacercount'] = count($right);
        $array[$i]['lastspacercount'] = $lastspacer;
        $array[$i]['spacerdiff'] = abs($lastspacer - count($right));
        $array[$i]['id'] = $row->category_id;
        $array[$i]['auto_id'] = $row->category__auto_id;
        $array[$i]['name'] = $row->category_name;
        $array[$i]['safename'] = $row->category_safe_name;
        $array[$i]['order'] = $row->category_order;
        $array[$i]['left'] = $row->lft;
        $array[$i]['right'] = $row->rgt;
        $array[$i]['leftrightdiff'] = $row->rgt - $row->lft;
        $array[$i]['authorlevel'] = $row->category_author_level;
        // DB 11/12/08
        $array[$i]['authorgroup'] = $row->category_author_group;
        /////
        if (isset($row->category_color)) {
            $array[$i]['color'] = $row->category_color;
        }
        if (isset($row->category_parent)) {
            $array[$i]['parent'] = $row->category_parent;
            $array[$i]['parent_name'] = GetCatName($row->category_parent);
            $array[$i]['parent_subcat_count'] = GetSubCatCount($row->category_parent);
        }
        $array[$i]['subcat_count'] = GetSubCatCount($row->category__auto_id);
        $lastspacer = count($right);
        $right[] = $row->rgt;
        if ($array[$i]['leftrightdiff'] != 1) {
            for ($j = 0; $j <= $array[$i]['leftrightdiff']; $j++) {
                $array[$i]['subcatalign'] = 1;
            }
        }
        $i++;
    }
    if ($showRoot == FALSE) {
        array_splice($array, 0, 1);
    }
    return $array;
}

Example #2

File: dbtree.php Project: bendroid/pligg-cms

function tree_to_array($root, $table, $showRoot = TRUE)
{
    // showRoot -- Do we want to include the "root" category named "all" in our results -- all subcats WILL appear regardless
    global $db, $cached_categories;
    $row = get_cached_category_data('category__auto_id', $root);
    if (!$row) {
        $sqlfix = "UPDATE " . table_categories . " SET `category__auto_id` = '0' WHERE `category_name` = 'all' LIMIT 1;";
        $db->query($sqlfix);
        $cached_categories = loadCategoriesForCache();
        $row = get_cached_category_data('category__auto_id', $root);
        if (!$row) {
            die('There is a problem with the categories table. Error CA:001.');
        }
    }
    $right = array();
    $left = array();
    $result = get_cached_between($row->lft, $row->rgt);
    $i = 0;
    $lastspacer = 0;
    foreach ($result as $row) {
        if (count($right) > 0) {
            // check if we should remove a node from the stack
            while ($right[count($right) - 1] < $row->rgt) {
                array_pop($left);
                if (array_pop($right) == NULL) {
                    break;
                    // We've reached the top of the category chain
                }
            }
        }
        $array[$i]['first'] = $row->lft - 1 == $left[sizeof($left) - 1];
        $array[$i]['last'] = $row->rgt + 1 == $right[sizeof($right) - 1];
        $array[$i]['principlecat'] = $row->rgt - $row->lft - 1;
        $array[$i]['spacercount'] = count($right);
        $array[$i]['lastspacercount'] = $lastspacer;
        $array[$i]['spacerdiff'] = abs($lastspacer - count($right));
        $array[$i]['id'] = $row->category_id;
        $array[$i]['auto_id'] = $row->category__auto_id;
        $array[$i]['name'] = $row->category_name;
        $array[$i]['safename'] = $row->category_safe_name;
        $array[$i]['order'] = $row->category_order;
        $array[$i]['left'] = $row->lft;
        $array[$i]['right'] = $row->rgt;
        $array[$i]['leftrightdiff'] = $row->rgt - $row->lft;
        $array[$i]['authorlevel'] = $row->category_author_level;
        $array[$i]['authorgroup'] = $row->category_author_group;
        $array[$i]['votes'] = $row->category_votes;
        $array[$i]['karma'] = $row->category_karma;
        $array[$i]['description'] = $row->category_desc;
        $array[$i]['keywords'] = $row->category_keywords;
        if (isset($row->category_color)) {
            $array[$i]['color'] = $row->category_color;
        }
        if (isset($row->category_parent)) {
            $array[$i]['parent'] = $row->category_parent;
            $array[$i]['parent_name'] = GetCatName($row->category_parent);
            $array[$i]['parent_subcat_count'] = GetSubCatCount($row->category_parent);
        }
        $array[$i]['subcat_count'] = GetSubCatCount($row->category__auto_id);
        $lastspacer = count($right);
        $right[] = $row->rgt;
        $left[] = $row->lft;
        if ($array[$i]['leftrightdiff'] != 1) {
            for ($j = 0; $j <= $array[$i]['leftrightdiff']; $j++) {
                $array[$i]['subcatalign'] = 1;
            }
        }
        $i++;
    }
    if ($showRoot == FALSE) {
        array_splice($array, 0, 1);
    }
    return $array;
}