X-Git-Url: http://git.harvie.cz/?a=blobdiff_plain;f=wwwroot%2Fbackend%2Fmysql%2Fbackend.inc;h=55eafab5e5633d8deb557d674497aa883ec2d096;hb=2341aefae4213c68c6d7f925680002382ae94a45;hp=8b21936a6d4e737e3b84f099d9cffa8cc7dc19fb;hpb=ad7b5117657235e1fcb080389ab52a1b126736d0;p=mirrors%2FKyberia-bloodline.git

diff --git a/wwwroot/backend/mysql/backend.inc b/wwwroot/backend/mysql/backend.inc
index 8b21936..55eafab 100644
--- a/wwwroot/backend/mysql/backend.inc
+++ b/wwwroot/backend/mysql/backend.inc
@@ -288,10 +288,10 @@ public static function GetUserSubmissionsChildren($user_id,$limit=23,$offset=0,$
 
 	// XXX orderby mysql escape
 
-	$q = "select n1.* from nodes as n1 join 
+	$q = "select child.*, from nodes as child join 
 		(select node_id,node_creator from nodes where node_creator='$user_id')
-		as j2 on n1.node_parent=j2.node_id 
-		join users as j3 on j3.user_id=n1.node_creator order by node_created 
+		as j2 on child.node_parent=j2.node_id and child.node_creator <> '$user_id'
+		join users as j3 on j3.user_id=child.node_creator order by node_created desc
 		$orderby LIMIT $offset,$limit";
 
 //	  $q="select users.*,nodes.* from nodes