k_neurons another fix.

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

diff --git a/wwwroot/backend/mysql/functions.sql b/wwwroot/backend/mysql/functions.sql
index 14bb0f514ebcf1cde34490148d6533f64d332340..801dc83f2b11cc544ce046ffe3e7070babb7e56a 100644 (file)
--- a/wwwroot/backend/mysql/functions.sql
+++ b/wwwroot/backend/mysql/functions.sql
@@ -37,7 +37,7 @@ END//
 create procedure k_neurons ( IN user_id INT, IN day_int INT)
 BEGIN
        if day_int = NULL or day_int = 0 then set day_int=20; end if;
-       select *,(k_get_node_weigth(node_id,user_id)*k) as weight_k from nodes where k>0
+       select *,(k_get_node_weigth(node_id,user_id)*k) as weight_k,'test1' as creator,'test2' as parent from nodes where k>0
                 and node_created>now()-interval day_int day order by weight_k desc; 
 
 END//