An all Drupal (version >4.7):
===========================
~ 1350 module
~ 57000 english strings (Russian ~20% translation)
===========================
data base ~50Mb
table(record)
10n_community_error 3,187
10n_community_file 10,879
10n_community_line 741,431
10n_community_project 1,348
10n_community_release 1,644
10n_community_string 57,144
10n_community_translation 27,815
10n_groups_group 6 (Other languages - WELCOM [http://drupaler.ru/translate] :-) )

Gábor Hojtsy, many thanks for your work and the remarkable project!

Comments

gábor hojtsy’s picture

Status: Closed (works as designed) » Active
pvasili’s picture

I Delete all the abandoned projects and has cleared 3 tables(http://drupal.org/node/203658). I see the new statistic:

l10n_community_error 7,623 (1.8 МБ)
l10n_community_file 9,710 (1.0 МБ)
l10n_community_line 131,253 (4.5 МБ)
l10n_community_project 1,453 (109.9 КБ)
l10n_community_release 1,626 (137.1 КБ)
l10n_community_string 61,984 (4.6 МБ)
l10n_community_translation 30,784 (4.7 МБ)

pvasili’s picture

An online statistics in a block:

if ((arg(0) == 'translate' ) AND (arg(1) == 'languages') AND (arg(3) !='') AND (arg(2) !='')) {
$cur_lang  = arg(2);
$cur_modul = arg(3);

$l10n_projects = db_fetch_object(db_query("SELECT tit, SUM(translation_count) count_translation, SUM(suggestion_count) count_suggestion, SUM(string_count) count_string 
FROM (

SELECT p.title tit, r.title rel, COUNT(DISTINCT(t.sid)) translation_count, SUM(0) suggestion_count, SUM(0) string_count, r.pid, t.is_suggestion 
FROM {l10n_community_release} r
INNER JOIN {l10n_community_project} p ON p.pid = r.pid 
INNER JOIN {l10n_community_file} f ON r.rid = f.rid 
INNER JOIN {l10n_community_line} l ON f.fid = l.fid 
INNER JOIN {l10n_community_string} s ON l.sid = s.sid 
LEFT JOIN {l10n_community_translation} t ON s.sid = t.sid 
WHERE t.is_active = 1 AND t.translation != ''  AND t.language ='$cur_lang' AND t.is_suggestion = 0 AND p.title = '$cur_modul'
GROUP BY r.pid, t.is_suggestion

UNION

SELECT p.title tit, r.title rel, SUM(0) translation_count, COUNT(DISTINCT(t.sid)) suggestion_count, SUM(0) string_count, r.pid, t.is_suggestion 
FROM `drupaler_ru_l10n_community_release` r 
INNER JOIN {l10n_community_project} p ON p.pid = r.pid 
INNER JOIN {l10n_community_file} f ON r.rid = f.rid 
INNER JOIN {l10n_community_line} l ON f.fid = l.fid 
INNER JOIN {l10n_community_string} s ON l.sid = s.sid 
LEFT JOIN  {l10n_community_translation} t ON s.sid = t.sid 
WHERE t.is_active = 1 AND t.translation != ''  AND t.language = '$cur_lang' AND t.is_suggestion = 1 AND p.title = '$cur_modul'
GROUP BY r.pid, t.is_suggestion

UNION

SELECT p.title tit, r.title rel, SUM(0) translation_count, SUM(0) suggestion_count, COUNT(DISTINCT(l.sid)) string_count, SUM(0) pid, SUM(0) is_suggestion
FROM {l10n_community_release} r 
INNER JOIN {l10n_community_project} p ON p.pid = r.pid 
INNER JOIN {l10n_community_file} f ON r.rid = f.rid 
INNER JOIN {l10n_community_line} l ON f.fid = l.fid 
WHERE p.title = '$cur_modul'
GROUP BY p.title
) AS translated

GROUP BY tit"));

echo 'Module = ' . arg(3) . ' Lang = ' . arg(2) . ' String (translation/suggestion/count) = ' . $l10n_projects->count_translation . '/' . $l10n_projects->count_suggestion . '/' .  $l10n_projects->count_string;
}
pvasili’s picture

Component: Miscellaneous » User interface
Priority: Minor » Normal

This code does not work for version > 5.x-1.0-alpha1....
I think, the % of translation it is necessary to add in interface of translation

gábor hojtsy’s picture

Version: 5.x-1.0-alpha1 » 6.x-1.x-dev
Status: Active » Closed (fixed)

l10n_server has such statistics currently already.