'') $term_type = $_REQUEST['term_type'];
$sql = "SELECT * FROM ".TABLE_PREFIX."language_text
WHERE language_code='".DEFAULT_LANGUAGE_CODE."'";
if ($term_type <> '') $sql .= " AND variable = '".$term_type."'";
if (isset($_REQUEST['new_or_translated']) && ($_REQUEST['new_or_translated'] == 1 || $_REQUEST['new_or_translated'] == 2))
{
$subquery = "(SELECT term FROM ".TABLE_PREFIX."language_text
WHERE language_code='".$_REQUEST['lang_code']."'
AND text <> '')";
if ($_REQUEST['new_or_translated'] == 1) $sql .= " AND term NOT IN ".$subquery;
if ($_REQUEST['new_or_translated'] == 2) $sql .= " AND term IN ".$subquery;
}
if (isset($_REQUEST['new_or_translated']) && $_REQUEST['new_or_translated'] == 3)
{
$sql = "select * from ".TABLE_PREFIX."language_text a
where language_code='".DEFAULT_LANGUAGE_CODE."'
and exists (select 1 from ".TABLE_PREFIX."language_text b
where language_code = '".$_REQUEST['lang_code']."'
and a.term = b.term
and a.revised_date > b.revised_date)";
}
}
if (isset($_REQUEST['search']))
{
$sql = "SELECT * FROM ".TABLE_PREFIX."language_text
WHERE language_code='".DEFAULT_LANGUAGE_CODE."'
AND lower(term) like '%".$addslashes(strtolower(trim($_REQUEST['search_phase'])))."%'";
}
$rows = $dao->execute($sql);
if (is_array($rows)) $num_results = count($rows);
else $num_results = 0;
}
if (isset($_REQUEST["save"]))
{
$sql_save = "REPLACE INTO ".TABLE_PREFIX."language_text VALUES ('".$_POST["lang_code"]."', '".$_POST["variable"]."', '".$_POST["term"]."', '".$addslashes($_POST["translated_text"])."', NOW(), '')";
$trans = get_html_translation_table(HTML_ENTITIES);
$trans = array_flip($trans);
$sql_save = strtr($sql_save, $trans);
if (!$dao->execute($sql_save)) {
$success_error = 'Error: changes not saved!
';
}
else {
$success_error = 'Success: changes saved.
';
}
}
//$rows_lang = $languagesDAO->getAllExceptLangCode(DEFAULT_LANGUAGE_CODE);
$rows_lang = $languagesDAO->getAll();
include(TR_INCLUDE_PATH.'header.inc.php');
?>
"") $sql_english .= " AND variable='".$_REQUEST["term_type"]."' ";
$rows_english = $dao->execute($sql_english);
$row_english = $rows_english[0];
$rows_selected = $languageTextDAO->getByTermAndLang($_REQUEST["selected_term"], $_REQUEST["lang_code"]);
function trans_form() {
global $row_english, $rows_selected;
global $langs;
global $success_error;
global $db;
global $addslashes;
if (!is_array($rows_selected)) // add new term
$add_new = true;
else // update existing one
{
$row_selected = $rows_selected[0];
$add_new = false;
}
?>
0)
{
echo ''. _AT("result") .'
'."\n";
echo ''."\n";
}
include(TR_INCLUDE_PATH.'footer.inc.php');
?>