X-Git-Url: http://git.harvie.cz/?a=blobdiff_plain;f=wwwroot%2Fbackend%2Fmysql%2Fbackend.inc;h=f7bba661bf9b7cb476f1a6e4670fad03480e67ba;hb=1b6374e50023ef764f9912c959d031d6bd5d41f8;hp=55eafab5e5633d8deb557d674497aa883ec2d096;hpb=2341aefae4213c68c6d7f925680002382ae94a45;p=mirrors%2FKyberia-bloodline.git diff --git a/wwwroot/backend/mysql/backend.inc b/wwwroot/backend/mysql/backend.inc index 55eafab..f7bba66 100644 --- a/wwwroot/backend/mysql/backend.inc +++ b/wwwroot/backend/mysql/backend.inc @@ -288,7 +288,7 @@ public static function GetUserSubmissionsChildren($user_id,$limit=23,$offset=0,$ // XXX orderby mysql escape - $q = "select child.*, from nodes as child join + $q = "select child.* from nodes as child join (select node_id,node_creator from nodes where node_creator='$user_id') 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