X-Git-Url: http://git.harvie.cz/?a=blobdiff_plain;f=wwwroot%2Fbackend%2Fmysql%2Ftest.sql;fp=wwwroot%2Fbackend%2Fmysql%2Ftest.sql;h=338db8b583552ff0991e4f8f07bbe55da0c50cba;hb=9ed37a87c196a6199e7cb4bef32c8a58c5606127;hp=893b92d1824732e1f6d88b67f5d487649f176e68;hpb=0c936d6edb24eec08fecae02285a2ff99c17c5e2;p=mirrors%2FKyberia-bloodline.git

diff --git a/wwwroot/backend/mysql/test.sql b/wwwroot/backend/mysql/test.sql
index 893b92d..338db8b 100644
--- a/wwwroot/backend/mysql/test.sql
+++ b/wwwroot/backend/mysql/test.sql
@@ -3,7 +3,7 @@ drop function if exists k_get_node_weigth;
 delimiter //
 create function k_get_node_weigth (node INT, user INT) returns DOUBLE
 BEGIN
-	declare vector,node2,len,n_owner,offset int;
+	declare vector,node2,len,n_owner,offset int; /* vector type*/
 	declare final,n_weight,o_weight,s_weight double;
 
 	select node_vector into vector from nodes where node_id = node;
@@ -41,5 +41,28 @@ begin
                 and node_created>now()-interval 20 day;
 
 --	select * from tmp_table order by k_weight desc;
+end//
+
+create function get_fix_vector (node INT) returns varchar(80)
+BEGIN
+	declare np,mynode int;
+
+	set mynode=node;
+	REPEAT
+		select node_parent into np from nodes where node_id = mynode;
+		/* XXX padding */
+		vector=concat(node_parent,vector);
+		set mynode=node_parent;
+	UNTIL node_parent != NULL and node_parent > 0
+	END REPEAT;
+	
+	return vector;
+
+END//
+
+create procedure fix_all_vectors ()
+begin
+	
 end//
 delimiter ;
+