+ if found_rows() = 0 then set o_weight=1; end if;
+
+/* if o_weight = NULL or o_weight=0 then set o_weight=1; end if;
+ if s_weight = NULL or s_weight=0 then set s_weight=1; end if;*/
+ /*if n_weight = NULL or n_weight=0 then set n_weight=1; end if;*/
- if o_weight = NULL or o_weight=0 then set o_weight=1; end if;
- if s_weight = NULL or s_weight=0 then set s_weight=1; end if;
- if n_weight = NULL or n_weight=0 then set n_weight=1; end if;
-
- set final = final * s_weight * o_weight * n_weight;
+ set final = final * s_weight * o_weight;/* * n_weight;*/
nodes.node_parent,(k_get_node_weigth(nodes.node_id,user_id)*nodes.k) as weight_k,
users.login as creator_name,
parent.node_name as parent_name
nodes.node_parent,(k_get_node_weigth(nodes.node_id,user_id)*nodes.k) as weight_k,
users.login as creator_name,
parent.node_name as parent_name