ini_set('display_errors', 'On'); $lnk = mysql_connect('114.215.210.34', 'root', 'xujj10192917') or die('Not connected : ' . mysql_error()); // make foo the current db mysql_select_db('touzilicai', $lnk) or die('Can\'t use foo : ' . mysql_error()); mysql_query("set names utf8"); /* mysql_query('truncate tree_data'); mysql_query('truncate tree_struct'); mysql_query('insert into tree_struct select id,lpoint,rpoint,level,parent_id,position,"default" from categories'); mysql_query('insert into tree_data(id,title,title_en) select id,title,title_en from categories'); mysql_query('insert into tree_data(title,title_en,summary,content,cid,src,src_id,src_category,src_tag) select title,"",summary,content,cid,src,src_id,src_category,src_tag from articles'); */ //修复lft, rgt $trees = get_trees(); regenerate_tid($trees); updateTreeTids($trees); //repair_pos(); //createArticleList(); //importArticle(); function repair_pos() { $result = mysql_query('select * from tree_struct where id<=66 order by id limit 0,70'); if ($result) { while ($row = mysql_fetch_assoc($result)) { $selSql = 'select * from tree_struct where id>66 and pid=' . $row['id'] . ' order by lft'; $result2 = mysql_query($selSql); if ($result2) { $i = 0; while ($row2 = mysql_fetch_assoc($result2)) {
function get_tree_leaf_items($tree_id, $leaf_id, $device_group_type, $include_parent = false) { global $current_user, $config; require(CACTI_BASE_PATH . "/include/graph_tree/graph_tree_arrays.php"); // prototype // $items = array($tree_id, $leaf_id, $type, $id, $name); // $tree_id = 'Tree where item exists' // $leaf_id = 'Leaf where item exists' // $type = 'graph|device|site|leaf|dqn|dqi|gtn'; // $id = 'local_graph_id|device_id|site_id|leaf_id|dqn_id|dqi_id|gtn_id' // the following types are only valid if $device_group_data = true // dqn|dqi|gtn include(CACTI_BASE_PATH . "/include/global_arrays.php"); include_once(CACTI_BASE_PATH . "/lib/data_query.php"); include_once(CACTI_BASE_PATH . "/lib/tree.php"); include_once(CACTI_BASE_PATH . "/lib/html_utility.php"); /* get the trees that the user has access to */ $items = array(); if ($tree_id <= 0) { return get_trees($tree_id); }elseif (tree_authorized($tree_id)) { if ($include_parent) { return get_trees($tree_id); } $search_key = ""; if ($leaf_id > 0) { /* return leaf, site, device, graph template or data query items */ $leaf = db_fetch_row("SELECT * FROM graph_tree_items WHERE id=$leaf_id"); $leaf_type = get_tree_item_type($leaf_id); /* get the "starting leaf" if the user clicked on a specific branch */ if (!empty($leaf_id)) { $search_key = substr($leaf["order_key"], 0, (tree_tier($leaf["order_key"]) * CHARS_PER_TIER)); } }else{ $leaf_type = "header"; } $user = db_fetch_row("SELECT * FROM user_auth WHERE id=" . $_SESSION["sess_user_id"]); if ($leaf_type == "header") { if (read_config_option("auth_method") != 0) { $tree_items = db_fetch_assoc("SELECT * FROM graph_tree_items WHERE graph_tree_id=$tree_id AND id!=$leaf_id AND order_key like '$search_key" . str_repeat('_', CHARS_PER_TIER) . str_repeat('0', (MAX_TREE_DEPTH * CHARS_PER_TIER) - (strlen($search_key) + CHARS_PER_TIER)) . "'"); if (sizeof($tree_items)) { foreach($tree_items AS $item) { if ($item["local_graph_id"]) { if (graph_authorized($item["local_graph_id"], $user)) { $new_tree_items[] = $item; } }elseif ($item["device_id"]) { if (device_authorized($item["device_id"], $user)) { $new_tree_items[] = $item; } }else{ $new_tree_items[] = $item; } } $tree_items = $new_tree_items; } }else{ $tree_items = db_fetch_assoc("SELECT * FROM graph_tree_items WHERE graph_tree_id=$tree_id AND id!=$leaf_id AND order_key like '$search_key" . str_repeat('_', CHARS_PER_TIER) . str_repeat('0', (MAX_TREE_DEPTH * CHARS_PER_TIER) - (strlen($search_key) + CHARS_PER_TIER)) . "'"); } if (sizeof($tree_items)) { foreach($tree_items as $item) { if ($item["local_graph_id"] > 0) { $items[] = array( "tree_id" => $tree_id, "leaf_id" => $item["id"], "type" => 'graph', "id" => $item["local_graph_id"], "name" => get_graph_title($item["local_graph_id"]) ); }elseif ($item["device_id"] > 0) { $items[] = array( "tree_id" => $tree_id, "leaf_id" => $item["id"], "type" => 'device', "id" => $item["device_id"], "name" => get_device_description($item["device_id"]) ); }else{ $items[] = array( "tree_id" => $tree_id, "leaf_id" => $item["id"], "type" => 'header', "id" => $item["id"], "name" => $item["title"] ); } } } return $items; }elseif ($leaf_type == "device") { if (read_graph_config_option("expand_devices") == CHECKED) { if ($leaf["device_grouping_type"] == TREE_DEVICE_GROUPING_GRAPH_TEMPLATE) { if ((isset($device_group_type)) && ($device_group_type[0] != 'gt')) { $items = get_device_grouping_graph_templates($leaf, $user); } }else{ if (isset($device_group_type)) { if (($device_group_type[0] != 'dqi') && ($device_group_type[0] != 'dq')) { $items = get_device_grouping_data_queries($leaf); }elseif ($device_group_type[0] != 'dqi') { $items = get_device_grouping_data_query_items($leaf, $device_group_type); } } } } return $items; }else{ return $items; } }else{ return $items; } }