Community
Participate
Working Groups
It would be great to have an html/rss view of recent translations, which one could filter against a specific project and/or a specific language. The functionality would be similar to MediaWiki's Recent Changes feature. It would allow people to become a language and/or a project champion by monitoring and reviewing its incoming changes. Making this depend on bug 221420 - being able to link to a specific file/string; however, implementing this feature w/o any kind of linking would still be beneficial.
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. ***
