From b5bf04a3b95468d37a95df63e2c7823f03b0b39b Mon Sep 17 00:00:00 2001 From: niekt0 Date: Mon, 20 Jun 2011 16:38:11 +0200 Subject: [PATCH] getUserSubmission_children fix3 --- wwwroot/backend/mysql/backend.inc | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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 -- 2.30.2