GIT.Harvie.CZ
/
mirrors
/
Kyberia-bloodline.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
ad7b511
)
getUserSubmission_children fix2
author
niekt0
<niekt0@kyberia.cz>
Mon, 20 Jun 2011 14:11:06 +0000
(16:11 +0200)
committer
niekt0
<niekt0@kyberia.cz>
Mon, 20 Jun 2011 14:11:06 +0000
(16:11 +0200)
wwwroot/backend/mysql/backend.inc
patch
|
blob
|
blame
|
history
diff --git
a/wwwroot/backend/mysql/backend.inc
b/wwwroot/backend/mysql/backend.inc
index 8b21936a6d4e737e3b84f099d9cffa8cc7dc19fb..55eafab5e5633d8deb557d674497aa883ec2d096 100644
(file)
--- 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
// 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')
(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
$orderby LIMIT $offset,$limit";
// $q="select users.*,nodes.* from nodes
This page took
0.133715 seconds
and
4
git commands to generate.