Summary: | Recent translations / RSS feed | ||
---|---|---|---|
Product: | [Technology] Babel | Reporter: | Denis Roy <denis.roy> |
Component: | Server | Assignee: | Babel server inbox <babel.server-inbox> |
Status: | NEW --- | QA Contact: | |
Severity: | enhancement | ||
Priority: | P3 | CC: | antoine, kitlo |
Version: | unspecified | Keywords: | bugday |
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | Linux | ||
Whiteboard: | |||
Bug Depends on: | 221420 | ||
Bug Blocks: |
Description
Denis Roy
2008-05-20 11:32:24 EDT
Here's the optimized SQL to pull out everything needed to do this. SELECT f.name, f.project_id, f.version, s.name, s.value, t.value, CONCAT(CONCAT(first_name, " "), u.last_name) AS who, t.created_on FROM translations as t LEFT JOIN strings as s on s.string_id = t.string_id LEFT JOIN files as f on s.file_id = f.file_id LEFT JOIN users as u on u.userid = t.userid WHERE t.is_active ORDER BY t.created_on desc LIMIT 200; Actually, one would need to add AND t.language_id = to not get all the languages, just the one in your session. I've done the HTML version of this. All that's missing is the RSS output. http://babel.eclipse.org/staging/recent.php This looks good. But, when a locale is available, we have to insert that in front of the language name. (For example, Brazilian Portuguese) You're right, Kit, I fixed that. I also added a 'list' view, and modified the layout to waste less space. I won't tweak this any further for now. I just wanted to put something there so that folks can follow along with recent changes. Putting this on my plate for Q3. *** Bug 281714 has been marked as a duplicate of this bug. *** |