| 1 |
<?php |
<?php |
| 2 |
// $Id: export.inc,v 1.1.2.15.2.16 2009/11/11 18:21:01 goba Exp $ |
// $Id: export.inc,v 1.1.2.15.2.17 2009/11/19 22:57:43 goba Exp $ |
| 3 |
|
|
| 4 |
/** |
/** |
| 5 |
* @file |
* @file |
| 388 |
$sql_args = array($project->pid); |
$sql_args = array($project->pid); |
| 389 |
} |
} |
| 390 |
else { |
else { |
| 391 |
|
// Join differently based on compact method, so we can skip strings without |
| 392 |
|
// translation for compact method export. |
| 393 |
|
$translation_join = ($compact) ? 'INNER JOIN' : 'LEFT JOIN'; |
| 394 |
// We only export active translations, not suggestions. |
// We only export active translations, not suggestions. |
| 395 |
$sql = "SELECT s.sid, s.value, s.context, f.location, f.revision, l.lineno, l.type, t.translation, t.uid_approved, t.time_approved FROM {l10n_community_file} f 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 AND t.language = '%s' AND is_active = 1 AND is_suggestion = 0 WHERE f.pid = %d"; |
$sql = "SELECT s.sid, s.value, s.context, f.location, f.revision, l.lineno, l.type, t.translation, t.uid_approved, t.time_approved FROM {l10n_community_file} f INNER JOIN {l10n_community_line} l ON f.fid = l.fid INNER JOIN {l10n_community_string} s ON l.sid = s.sid $translation_join {l10n_community_translation} t ON s.sid = t.sid AND t.language = '%s' AND is_active = 1 AND is_suggestion = 0 WHERE f.pid = %d"; |
| 396 |
$sql_args = array($language->language, $project->pid); |
$sql_args = array($language->language, $project->pid); |
| 397 |
} |
} |
| 398 |
|
|
Parent Directory
| 
Revision Log
| 
Revision Graph
| 
Patch