l10n_server 6.x-1.0-alpha3

The happy new year 2009 release! Includes performance improvements (caching, better database indexes, streamlined queries); new permissions to better fence who can do what; fixes to the translation interface; GET based filtering instead of using SESSION data; improved PostgreSQL compatibility.

The following detailed changes have been made since the 6.x-1.0-alpha2 release:

• #321484 reported by hass: the l10n_server uses constructs only available with PHP 5, so better specify that
• #321525 requested by brmassa: add separate permission to export translations and templates
• #306641 reported by Razorraser: one extra double quote
• #251324 suggestion by dami: permission to import translations (still dependent on further permissions to suggest or submit translations directly. Also refining permission naming and application (#321525).
• #325383 by aries: missing form_state parameter
• #203659 suggested by hass: We should first check whether the local packages directory was configured.
• #325721 by meba: Cache overall and per language stats for better performance.
• #219807 by meba and myself: block duplicate suggestions or translation detected on form submission
• #209980 follow up by meba and myself: fix whitespace matching so that multiline strings get the proper treatment when their translations are saved
• #326423 by meba: add indexes to the translations table for better performance
• #321528 suggested by several users, also wished for by meba at http://drupal.org/node/196865#comment-763276: move away from sessions for permanent filters and implement GET param based filtering properly

  - Redirect on form submission with the right filter values kept intact in the URL
  - GET values are kept in pager links by Drupal automatically
  - We should keep GET values on form submission (done)
  - Reset button now redirect without keeping the filtering params

  This achieves URL based navigation without hidden session based magic. There is no need for the special permalinking feature, since all links are permalinks as much as possible (the list of untranslated stuff would change of course for example).

• #327357 by meba: fix badly ported caching code
• #327357 follow up by meba: fix badly ported caching code
• #327680 reported by panas, patch by myself: overall summary always said there is 1 contributor helping with the server
• #328655 report by Razorraser, patch by myself: eliminate old SESSION based project selection from here as well, going to URL parameters
  Also fixed several notices identified when testing export.
• #339344 suggested by pvasili: remove superfluous JOIN from count query
• #337687 by jmpoure and myself: Improve PostgreSQL compatibility by adding the missing AS keyword for aliased columns in SELECTs
• #331987 by Pasqualle: refactor export code so that the last string to export is not lost
• Minor code style fix.
• #346761 by andypost: l10n_drupalorg_cron() invoked a function which was in an include file not included yet
• This AJAX remote callback code was removed earlier. Remove leftover menu item.
• #344022 report by Psicomante, patch by myself: if plural forms are not initialized for a language, we will have issues editing the translations, so block functionality until plurals are properly set
• Break JOIN out to two very simple queries on string insert. The JOIN was invalid when inactive suggestions or translations from other languages resulted in the database not return rows, so it caused problems with the whitespace ensuring code. Now the source string is always found and the translation is queried in a second query.
• #306373 and #332361 as well as other issues I found while fixing:

  - Second click on the suggestions icon now also brings back the editing field, just as with the lookup button introduced earlier.
  - Fixed the string IDs for plural strings to contain the right delimiter with a hyphen.
  - Fixed string copying code to look for the hyphen to identify plural strings and copy over all source strings to the editor.
  - Thanks to the previous point, we could eliminate all but the first copy button on plural strings, resulting in (#306373 being fixed).
  - Keep and document plural suggestion copying solution.
  - Solve case when parent is not the translation column but the source column, and switch to translation column for the pane display. This solves #332361.
  - Add number of plurals to page JS settings. Now used for string copying, but can be used for other things later.

• Remove excessive line indent introduced with a previous patch against the export code.
• #331043 reported by Pasqualle, patch by myself: notice on use of 'changed' key without initialization; initialize better and get rid of some unneeded code
• #352167 reported by Psicomante, patch by myself: page numbers and filter values were preserved in two different, incompatible ways; now preserve both at the same time for form submission