blob: 44aa55d45b4347c3957df4f3d2b2a24d46e3ab4e [file] [log] [blame]
<?php
/*******************************************************************************
* Copyright (c) 2008 Eclipse Foundation and others.
* All rights reserved. This program and the accompanying materials
* are made available under the terms of the Eclipse Public License v1.0
* which accompanies this distribution, and is available at
* http://www.eclipse.org/legal/epl-v10.html
*
* Contributors:
* Intalio, Inc. - Initial API and implementation
* Antoine Toulme - Initial contribution.
*******************************************************************************/
ini_set("memory_limit", "64M");
error_reporting(E_ALL);
ini_set('display_errors', '1');
require(dirname(__FILE__) . "/../system/dbconnection.class.php");
$dbc = new DBConnection();
$dbh = $dbc->connect();
require_once(dirname(__FILE__) . "/../system/backend_functions.php");
if( !function_exists('json_encode') ){
require("/home/data/httpd/babel.eclipse.org/html/json_encode.php");
function json_encode($encode){
$jsons = new Services_JSON();
return $jsons->encode($encode);
}
}
$User = getSyncupUser();
$dbc = new DBConnection();
global $dbh;
$dbh = $dbc->connect();
echo "Connection established, ready to begin; The syncup user id is $User->userid \n";
$langs = mysql_query( "SELECT language_id FROM languages where languages.is_active" );
while( ($lang_row = mysql_fetch_assoc($langs)) != null ) {
$language_id = $lang_row['language_id'];
echo "Investigating language " . $language_id . "\n\n";
$untranslated_strings = mysql_query( "SELECT * from strings where is_active and value <> '' and string_id not in(select string_id from translations where language_id=". $language_id .")" );
$count = 0;
while ( ($string_row = mysql_fetch_assoc($untranslated_strings)) != null) {
$count++;
if($count % 100 == 0) {
echo "Processed " . $count . " strings...\n";
}
$untranslated_value = $string_row['value'];
$untranslated_id = $string_row['string_id'];
# This query split in two for added performance.
# See bug 270485
$string_ids = "";
$rs = mysql_query( "SELECT s.string_id FROM strings AS s WHERE BINARY s.value = '" . addslashes($untranslated_value) . "'");
while ( ($row = mysql_fetch_assoc($rs)) != null) {
if(strlen($string_ids) > 0) {
$string_ids .= ",";
}
$string_ids .= $row['string_id'];
}
$possible_translations = mysql_query( "SELECT t.value from strings As s inner join translations AS t on s.string_id = t.string_id where s.string_id IN ($string_ids) and t.language_id = '" . $language_id . "' and t.is_active ");
if ($possible_translations and (($translation_row = mysql_fetch_assoc($possible_translations)) != null)) {
$translation = $translation_row['value'];
$query = "INSERT INTO translations(string_id, language_id, value, userid, created_on, possibly_incorrect) values('". addslashes($untranslated_id) ."','". addslashes($language_id) ."','" . addslashes($translation) . "', '". addslashes($User->userid) ."', NOW(), 1)";
echo "\tTranslating ". addslashes($untranslated_id) ." with: " . addslashes($translation) . "\n";
mysql_query($query);
}
}
}
?>