diff options
author | morkt <> | 2015-03-08 09:01:59 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2015-03-08 09:01:59 +0100 |
commit | e20b19ce400ccf382a969a51777e0678ff8d44db (patch) | |
tree | 5548e9fb7e0a28ea92e97a1ee1406042566fa68b /lib | |
parent | 66c072697477526b25c4b4b87e87c1a4f8e5be33 (diff) |
Multi::Feed: Fix IDs of staff edits
Diffstat (limited to 'lib')
-rw-r--r-- | lib/Multi/Feed.pm | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/lib/Multi/Feed.pm b/lib/Multi/Feed.pm index ea9cbcac..443d1ac2 100644 --- a/lib/Multi/Feed.pm +++ b/lib/Multi/Feed.pm @@ -64,14 +64,16 @@ sub generate { # changes $_[KERNEL]->post(pg => query => q{ - SELECT '/'||c.type||COALESCE(vr.vid, rr.rid, pr.pid, cr.cid)||'.'||c.rev AS id, - COALESCE(vr.title, rr.title, pr.name, cr.name) AS title, extract('epoch' from c.added) AS updated, + SELECT '/'||c.type||COALESCE(vr.vid, rr.rid, pr.pid, cr.cid, sr.sid)||'.'||c.rev AS id, + COALESCE(vr.title, rr.title, pr.name, cr.name, sa.name) AS title, extract('epoch' from c.added) AS updated, u.username, u.id AS uid, c.comments AS summary FROM changes c LEFT JOIN vn_rev vr ON c.type = 'v' AND c.id = vr.id LEFT JOIN releases_rev rr ON c.type = 'r' AND c.id = rr.id LEFT JOIN producers_rev pr ON c.type = 'p' AND c.id = pr.id LEFT JOIN chars_rev cr ON c.type = 'c' AND c.id = cr.id + LEFT JOIN staff_rev sr ON c.type = 's' AND c.id = sr.id + LEFT JOIN staff_alias sa ON sa.rid = sr.id AND sa.id = sr.aid JOIN users u ON u.id = c.requester WHERE c.requester <> 1 ORDER BY c.id DESC |