k_neurons fix & small warnings removed

[mirrors/Kyberia-bloodline.git] / wwwroot / backend / mysql / functions.sql

diff --git a/wwwroot/backend/mysql/functions.sql b/wwwroot/backend/mysql/functions.sql
index b5c81a13ec4ae4c08238323f28a52edbe383b3ef..c50f19dffa333ca44b2d0ce03dc3f5933c914e2f 100644 (file)
--- a/wwwroot/backend/mysql/functions.sql
+++ b/wwwroot/backend/mysql/functions.sql
@@ -20,17 +20,19 @@ BEGIN
                /* weigths from user to: 
                        - all nodes from node to root node
                        - all node owners from node to root node
-                       - all nodes between themselves (safe?)
+                       - all nodes between themselves (safe?) XXX removed
                */
-               select node_weight,node_creator into n_weight,n_owner from nodes where node_id=node2;
+               select /*node_weight,*/node_creator into /*n_weight,*/n_owner from nodes where node_id=node2;
                select synapse_weight into s_weight from neurons where src=user and dst=node2;
+               if found_rows() = 0  then set s_weight=1; end if;
                select synapse_weight into o_weight from neurons where src=user and dst=n_owner;
+               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;*/
        END WHILE;
        RETURN final;
 END//
@@ -43,6 +45,7 @@ BEGIN
                nodes.node_name,
                nodes.node_creator,
                nodes.node_content,
+               nodes.k,
                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