= 0 && $limit <= 10) {
// allowed value of limit
} else {
$limit = 0;
}
} else {
$limit = 0;
}
if(isset($_REQUEST['allowwildcard'])){
$allowwildcard = $_REQUEST['allowwildcard'];
} else {
$allowwildcard = "yes";
}
if(isset($_REQUEST['nullcode'])){
$nullcode = $_REQUEST['nullcode'];
} else {
$nullcode = "";
}
$languagequery = sprintf("select * from language where deleted = false and isocode = '%s'", $iso);
$content_vars['getlanguage'] = query($languagequery);
/*
echo "";
echo var_dump($languagequery);
echo "
";
*/
?>
";
echo var_dump($_POST);
echo "";
*/
foreach ($_POST as $field => $value){
$field = str_replace("+", ".", $field);
if (($field == 'iso') || ($field == 'button') || ($field == 't') || ($field == 'q') || ($field == 'type') || ($field == 'nullcode') || ($field == 'limit')){
// field which should not be processed
} elseif ($value != "") {
// allowed post field
if($type == "region"){
// special saving for region
if ($field != "sort") {
$sql = sprintf("select save_data('name', '%s', ", pg_escape_string($value));
$sql .= sprintf("%u, ", $field);
$sql .= "'translation tool', ";
$sql .= sprintf("%u, ", $_SESSION['account_id']);
$sql .= sprintf("'%s'); ", $iso);
#$elasticresult = Elasticsearch::setBulkRegions(array("id" => intval($iso)));
}
} else {
// all other types
if($type == "category"){
$sql = "update category set ";
} elseif($type == "datatype"){
$sql = "update datatype set ";
} elseif($type == "webtext"){
$sql = "update webtext set ";
} elseif($type == "defabstract"){
$sql = "update definition set ";
} elseif($type == "regiontype"){
$sql = "update regiontype set ";
} elseif($type == "region"){
$sql = "update region set ";
}
if($value == "-" && $iso != "en"){
// copy english text to this language field
if ($type == "defabstract") {
if ($iso == "en") {
$sql .= "abstract = abstract ";
} else {
$sql .= sprintf("abstract_%s = abstract ", $iso);
}
} else {
$sql .= sprintf("name_%s = name_en ", $iso);
}
} elseif ($value == "!" && $iso != "en"){
// delete this language field
if ($type == "defabstract") {
if ($iso == "en") {
$sql .= "abstract = NULL ";
} else {
$sql .= sprintf("abstract_%s = NULL ", $iso);
}
} else {
$sql .= sprintf("name_%s = NULL ", $iso);
}
} else {
if ($type == "defabstract") {
if ($iso == "en") {
$sql .= "abstract = ";
$sql .= sprintf("'%s' ", pg_escape_string($value));
} else {
$sql .= sprintf("abstract_%s = ", $iso);
$sql .= sprintf("'%s' ", pg_escape_string($value));
}
} else {
$sql .= sprintf("name_%s = ", $iso);
$sql .= sprintf("'%s' ", pg_escape_string($value));
}
}
if($type == "category"){
$sql .= sprintf("where lower(categoryid) = '%s' ", strtolower($field));
} elseif($type == "datatype"){
$sql .= sprintf("where lower(datatypeid) = '%s' ", strtolower($field));
} elseif($type == "webtext"){
$sql .= sprintf("where id = %u ", $field);
} elseif($type == "defabstract"){
$sql .= sprintf("where id = %u ", $field);
} elseif($type == "regiontype"){
$sql .= sprintf("where id = %u ", $field);
} elseif($type == "region"){
$sql .= sprintf("where id = %u ", $field);
}
}
// run the query
query($sql);
/*
$result = query($sql);
echo $sql . '
';
echo $field . '
';
echo $value . '
';
*/
/*
echo "";
echo $row;
echo "";
*/
}
}
header("Location: /translations-list?q=".strip_tags($_POST['q'])."&type=".strip_tags($_POST['type'])."&iso=".strip_tags($_POST['iso']), true, 301);
die();
}
?>
= %u ", $limit);
$counttranslations .= "and deleted = false ";
$content_vars['counttranslations'] = queryRow($counttranslations);
$gettranslations = "select category.importance, categoryid as fieldid, COALESCE(name_".$translatelanguage.", name_en) as field, ";
$gettranslations .= sprintf("name_%s as value, definition.id from category ", $iso);
$gettranslations .= "LEFT JOIN definition ON category.definitionid = definition.id ";
if($q != ""){
$gettranslations .= "where ( ";
$gettranslations .= sprintf("lower(category.name_%s) ", $iso);
$gettranslations .= sprintf("ilike '%s' ", $sql_q);
$gettranslations .= sprintf("or categoryid like '%s' ", $sql_q);
$gettranslations .= ") ";
} else {
$gettranslations .= sprintf("where length(name_%s) ", $iso);
$gettranslations .= sprintf("IS %s NULL ", $nullcode);
}
$gettranslations .= sprintf("and category.importance >= %u ", $limit);
$gettranslations .= "and category.deleted = false ";
if ($sort == 2) {
$gettranslations .= "order by length(name_".$translatelanguage."), category.importance desc, name_".$translatelanguage." nulls last ";
} elseif ($sort == 3) {
$gettranslations .= "order by name_".$translatelanguage.", category.importance desc, name_".$translatelanguage." nulls last ";
} elseif ($sort == 4) {
$gettranslations .= "order by categoryid, category.importance desc, name_".$translatelanguage." nulls last ";
} else {
$gettranslations .= "order by category.importance desc, name_".$translatelanguage." nulls last ";
}
$gettranslations .= sprintf("OFFSET %u ", $offset);
$gettranslations .= sprintf("LIMIT %u ", $maxrows);
$content_vars['gettranslations'] = query($gettranslations);
} elseif ($type == "datatype"){
$showtitle = "Data Types";
$counttranslations = "select count(datatypeid) as number from datatype ";
if($q != ""){
$counttranslations .= "where ( ";
$counttranslations .= sprintf("lower(datatype.name_ar) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_bg) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_ca) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_zh) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_ct) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_hr) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_cs) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_da) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_nl) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_en) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_et) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_fi) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_fr) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_de) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_el) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_he) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_hi) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_hu) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_id) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_it) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_ja) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_ko) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_lv) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_lt) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_fa) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_pl) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_pt) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_ro) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_ru) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_sr) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_sl) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_es) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_sv) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_tl) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_ta) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_th) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_tr) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_uk) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_vi) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_ur) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_sw) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_sq) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_ka) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_hy) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_bn) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_gu) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_mr) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(datatype.name_te) like '%s' or ", $sql_q);
$counttranslations .= sprintf("datatypeid ilike '%s' ", $sql_q);
$counttranslations .= ") ";
} else {
$counttranslations .= sprintf("where length(name_%s) ", $iso);
$counttranslations .= sprintf("IS %s NULL ", $nullcode);
}
$counttranslations .= sprintf("and datatype.importance >= %u ", $limit);
$counttranslations .= "and datatype.deleted = false ";
$content_vars['counttranslations'] = queryRow($counttranslations);
$gettranslations = sprintf("select datatype.importance, datatypeid as fieldid, COALESCE(name_".$translatelanguage.", name_en) as field, name_%s as value, definition.id from datatype ", $iso);
$gettranslations .= "LEFT JOIN definition ON datatype.definitionid = definition.id ";
if($q != ""){
$gettranslations .= "where ( ";
$gettranslations .= sprintf("lower(datatype.name_ar) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_bg) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_ca) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_zh) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_ct) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_hr) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_cs) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_da) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_nl) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_en) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_et) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_fi) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_fr) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_de) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_el) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_he) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_hi) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_hu) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_id) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_it) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_ja) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_ko) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_lv) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_lt) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_fa) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_pl) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_pt) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_ro) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_ru) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_sr) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_sl) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_es) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_sv) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_tl) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_ta) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_th) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_tr) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_uk) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_vi) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_ur) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_sw) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_sq) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_ka) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_hy) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_bn) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_gu) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_mr) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(datatype.name_te) like '%s' or ", $sql_q);
$gettranslations .= sprintf("datatypeid ilike '%s' ", $sql_q);
$gettranslations .= ") ";
} else {
$gettranslations .= sprintf("where length(name_%s) ", $iso);
$gettranslations .= sprintf("IS %s NULL ", $nullcode);
}
$gettranslations .= sprintf("and datatype.importance >= %u ", $limit);
$gettranslations .= "and datatype.deleted = false ";
if ($sort == 2) {
$gettranslations .= "order by length(name_".$translatelanguage."), datatype.importance desc, name_".$translatelanguage." nulls last ";
} elseif ($sort == 3) {
$gettranslations .= "order by name_".$translatelanguage.", datatype.importance desc, name_".$translatelanguage." nulls last ";
} elseif ($sort == 4) {
$gettranslations .= "order by datatypeid, datatype.importance desc, name_".$translatelanguage." nulls last ";
} else {
$gettranslations .= "order by datatype.importance desc, name_".$translatelanguage." nulls last ";
}
$gettranslations .= sprintf("OFFSET %u ", $offset);
$gettranslations .= sprintf("LIMIT %u ", $maxrows);
#echo var_dump($gettranslations);
$content_vars['gettranslations'] = query($gettranslations);
} elseif ($type == "webtext"){
$showtitle = "Webtexts";
$counttranslations = "select count(id) as number from webtext ";
if($q != ""){
$counttranslations .= "where ( ";
$counttranslations .= sprintf("lower(webtext.name_ar) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_bg) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_ca) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_zh) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_ct) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_hr) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_cs) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_da) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_nl) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_en) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_et) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_fi) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_fr) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_de) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_el) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_he) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_hi) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_hu) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_id) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_it) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_ja) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_ko) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_lv) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_lt) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_fa) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_pl) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_pt) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_ro) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_ru) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_sr) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_sl) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_es) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_sv) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_tl) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_ta) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_th) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_tr) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_uk) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_ur) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_sw) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_sq) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_ka) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_hy) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_bn) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_gu) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_mr) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_te) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(webtext.name_vi) like '%s' ", $sql_q);
$counttranslations .= ") ";
} else {
$counttranslations .= sprintf("where length(name_%s) ", $iso);
$counttranslations .= sprintf("IS %s NULL ", $nullcode);
}
$counttranslations .= sprintf("and importance >= %u ", $limit);
if ($ids != "") {
$counttranslations .= sprintf("and webtext.id IN (%s) ", $ids);
}
$counttranslations .= "and webtext.deleted = false ";
$content_vars['counttranslations'] = queryRow($counttranslations);
$gettranslations = sprintf("select importance, id as fieldid, COALESCE(name_".$translatelanguage.", name_en) as field, name_%s as value, translationhint, inbetweencalledfromuri from webtext ", $iso);
if($q != ""){
$gettranslations .= "where ( ";
$gettranslations .= sprintf("lower(webtext.name_ar) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_bg) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_ca) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_zh) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_ct) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_hr) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_cs) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_da) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_nl) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_en) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_et) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_fi) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_fr) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_de) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_el) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_he) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_hi) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_hu) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_id) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_it) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_ja) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_ko) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_lv) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_lt) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_fa) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_pl) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_pt) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_ro) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_ru) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_sr) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_sl) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_es) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_sv) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_tl) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_ta) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_th) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_tr) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_uk) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_ur) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_sw) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_sq) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_ka) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_hy) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_bn) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_gu) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_mr) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_te) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(webtext.name_vi) like '%s' ", $sql_q);
$gettranslations .= ") ";
} else {
$gettranslations .= sprintf("where length(name_%s) ", $iso);
$gettranslations .= sprintf("IS %s NULL ", $nullcode);
}
$gettranslations .= sprintf("and importance >= %u ", $limit);
if ($ids != "") {
$gettranslations .= sprintf("and webtext.id IN (%s) ", $ids);
}
$gettranslations .= "and webtext.deleted = false ";
if ($sort == 2) {
$gettranslations .= "order by length(name_".$translatelanguage."), webtext.importance desc, name_".$translatelanguage." nulls last ";
} elseif ($sort == 3) {
$gettranslations .= "order by name_".$translatelanguage.", webtext.importance desc, name_".$translatelanguage." nulls last ";
} elseif ($sort == 4) {
$gettranslations .= "order by webtext.id, webtext.importance desc, name_".$translatelanguage." nulls last ";
} else {
$gettranslations .= "order by importance desc, webtext.name_".$translatelanguage." nulls last ";
}
$gettranslations .= sprintf("OFFSET %u ", $offset);
$gettranslations .= sprintf("LIMIT %u ", $maxrows);
#echo $gettranslations;
$content_vars['gettranslations'] = query($gettranslations);
} elseif ($type == "defabstract"){
$showtitle = "Abstracts";
$counttranslations = "select count(id) as number from definition ";
if($q != ""){
$counttranslations .= "where ( ";
$counttranslations .= sprintf("lower(definition.abstract_ar) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_bg) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_ca) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_zh) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_ct) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_hr) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_cs) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_da) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_nl) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_et) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_fi) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_fr) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_de) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_el) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_he) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_hi) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_hu) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_id) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_it) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_ja) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_ko) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_lv) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_lt) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_fa) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_pl) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_pt) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_ro) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_ru) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_sr) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_sl) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_es) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_sv) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_tl) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_ta) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_th) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_tr) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_uk) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_ur) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_sw) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_sq) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_ka) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_hy) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_bn) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_gu) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_mr) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_te) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(definition.abstract_vi) like '%s' ", $sql_q);
$counttranslations .= ") ";
} else {
if ($iso == "en") {
$counttranslations .= "where length(abstract) ";
} else {
$counttranslations .= sprintf("where length(abstract_%s) ", $iso);
}
$counttranslations .= sprintf("IS %s NULL ", $nullcode);
}
$counttranslations .= sprintf("and importance >= %u ", $limit);
if ($ids != "") {
$counttranslations .= sprintf("and definition.id IN (%s) ", $ids);
}
$counttranslations .= "and (definition.type = 'standard' or definition.type = 'compound') ";
$counttranslations .= "and definition.deleted = false ";
$content_vars['counttranslations'] = queryRow($counttranslations);
if ($translatelanguage == "en") {
$columnfield = "abstract";
} else {
$columnfield = "abstract_".$translatelanguage;
}
$gettranslations = sprintf("select importance, id as fieldid, COALESCE(".$columnfield.", abstract) as field, abstract_%s as value, title as definitiontitle from definition ", $iso);
if($q != ""){
$gettranslations .= "where ( ";
$gettranslations .= sprintf("lower(definition.abstract_ar) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_bg) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_ca) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_zh) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_ct) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_hr) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_cs) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_da) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_nl) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_et) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_fi) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_fr) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_de) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_el) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_he) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_hi) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_hu) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_id) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_it) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_ja) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_ko) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_lv) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_lt) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_fa) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_pl) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_pt) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_ro) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_ru) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_sr) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_sl) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_es) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_sv) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_tl) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_ta) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_th) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_tr) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_uk) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_ur) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_sw) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_sq) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_ka) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_hy) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_bn) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_gu) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_mr) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_te) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(definition.abstract_vi) like '%s' ", $sql_q);
$gettranslations .= ") ";
} else {
if ($iso == "en") {
$gettranslations .= "where length(abstract) ";
} else {
$gettranslations .= sprintf("where length(abstract_%s) ", $iso);
}
$gettranslations .= sprintf("IS %s NULL ", $nullcode);
}
$gettranslations .= sprintf("and importance >= %u ", $limit);
if ($ids != "") {
$gettranslations .= sprintf("and definition.id IN (%s) ", $ids);
}
$gettranslations .= "and definition.deleted = false ";
$gettranslations .= "and (definition.type = 'standard' or definition.type = 'compound') ";
if ($sort == 2) {
if ($translatelanguage == "en") {
$gettranslations .= "order by length(definition.abstract), webtext.importance desc ";
} else {
$gettranslations .= "order by length(definition.abstract_".$translatelanguage."), webtext.importance desc ";
}
} elseif ($sort == 3) {
if ($translatelanguage == "en") {
$gettranslations .= "order by definition.abstract, webtext.importance desc ";
} else {
$gettranslations .= "order by definition.abstract_".$translatelanguage.", webtext.importance desc ";
}
} elseif ($sort == 4) {
$gettranslations .= "order by definition.id, definition.importance desc ";
} else {
if ($translatelanguage == "en") {
$gettranslations .= "order by definition.importance desc, definition.abstract nulls last ";
} else {
$gettranslations .= "order by definition.importance desc, definition.abstract_".$translatelanguage." nulls last ";
}
}
$gettranslations .= sprintf("OFFSET %u ", $offset);
$gettranslations .= sprintf("LIMIT %u ", $maxrows);
$content_vars['gettranslations'] = query($gettranslations);
} elseif ($type == "regiontype"){
$showtitle = "Regiontypes";
$counttranslations = "select count(id) as number from regiontype ";
if($q != ""){
$counttranslations .= "where ( ";
$counttranslations .= sprintf("lower(regiontype.name_ar) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_bg) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_ca) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_zh) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_ct) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_hr) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_cs) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_da) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_nl) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_en) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_et) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_fi) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_fr) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_de) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_el) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_he) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_hi) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_hu) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_id) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_it) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_ja) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_ko) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_lv) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_lt) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_fa) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_pl) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_pt) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_ro) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_ru) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_sr) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_sl) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_es) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_sv) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_tl) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_ta) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_th) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_tr) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_uk) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_ur) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_sw) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_sq) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_ka) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_hy) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_bn) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_gu) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_mr) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_te) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(regiontype.name_vi) like '%s' ", $sql_q);
$counttranslations .= ") ";
} else {
$counttranslations .= sprintf("where length(name_%s) ", $iso);
$counttranslations .= sprintf("IS %s NULL ", $nullcode);
}
$counttranslations .= sprintf("and importance >= %u ", $limit);
if ($ids != "") {
$counttranslations .= sprintf("and regiontype.id IN (%s) ", $ids);
}
$counttranslations .= "and regiontype.deleted = false ";
$content_vars['counttranslations'] = queryRow($counttranslations);
$gettranslations = sprintf("select importance, id as fieldid, COALESCE(name_".$translatelanguage.", name_en) as field, name_%s as value, translationhint from regiontype ", $iso);
if($q != ""){
$gettranslations .= "where ( ";
$gettranslations .= sprintf("lower(regiontype.name_ar) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_bg) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_ca) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_zh) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_ct) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_hr) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_cs) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_da) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_nl) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_en) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_et) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_fi) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_fr) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_de) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_el) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_he) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_hi) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_hu) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_id) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_it) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_ja) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_ko) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_lv) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_lt) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_fa) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_pl) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_pt) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_ro) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_ru) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_sr) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_sl) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_es) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_sv) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_tl) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_ta) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_th) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_tr) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_uk) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_ur) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_sw) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_sq) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_ka) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_hy) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_bn) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_gu) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_mr) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_te) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(regiontype.name_vi) like '%s' ", $sql_q);
$gettranslations .= ") ";
} else {
$gettranslations .= sprintf("where length(name_%s) ", $iso);
$gettranslations .= sprintf("IS %s NULL ", $nullcode);
}
$gettranslations .= sprintf("and importance >= %u ", $limit);
if ($ids != "") {
$gettranslations .= sprintf("and regiontype.id IN (%s) ", $ids);
}
$gettranslations .= "and regiontype.deleted = false ";
if ($sort == 2) {
$gettranslations .= "order by length(name_".$translatelanguage."), regiontype.importance desc, name_".$translatelanguage." nulls last ";
} elseif ($sort == 3) {
$gettranslations .= "order by name_".$translatelanguage.", regiontype.importance desc, name_".$translatelanguage." nulls last ";
} elseif ($sort == 4) {
$gettranslations .= "order by regiontype.id, regiontype.importance desc, name_".$translatelanguage." nulls last ";
} else {
$gettranslations .= "order by importance desc, regiontype.name_".$translatelanguage." nulls last ";
}
$gettranslations .= sprintf("OFFSET %u ", $offset);
$gettranslations .= sprintf("LIMIT %u ", $maxrows);
$content_vars['gettranslations'] = query($gettranslations);
} elseif ($type == "region"){
$showtitle = "Regions";
$counttranslations = "select count(id) as number from region ";
if(is_numeric($q)){
$counttranslations .= sprintf("where parent_id = %u ", $q);
} elseif($q != ""){
$counttranslations .= "where ( ";
$counttranslations .= sprintf("lower(region.name_ar) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_bg) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_ca) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_zh) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_ct) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_hr) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_cs) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_da) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_nl) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_en) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_et) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_fi) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_fr) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_de) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_el) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_he) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_hi) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_hu) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_id) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_it) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_ja) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_ko) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_lv) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_lt) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_fa) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_pl) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_pt) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_ro) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_ru) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_sr) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_sl) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_es) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_sv) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_tl) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_ta) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_th) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_tr) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_uk) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_ur) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_sw) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_sq) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_ka) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_hy) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_bn) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_gu) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_mr) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_te) like '%s' or ", $sql_q);
$counttranslations .= sprintf("lower(region.name_vi) like '%s' ", $sql_q);
$counttranslations .= ") ";
} else {
$counttranslations .= sprintf("where length(region.name_%s) ", $iso);
$counttranslations .= sprintf("IS %s NULL ", $nullcode);
if($limit == "false" || $limit == ""){
$counttranslations .= sprintf("and population > %u ", $pop);
} else {
$counttranslations .= "and population > 25000 ";
}
}
$counttranslations .= sprintf("and region.importance >= %u ", $limit);
$counttranslations .= "and region.deleted = false ";
$content_vars['counttranslations'] = queryRow($counttranslations);
$gettranslations = sprintf("select region.importance, region.id as fieldid, COALESCE(region.name_".$translatelanguage.", region.name_en) as field, region.name_%s as value, region.population, region.parent_id, regiontype.name_".$translatelanguage." as regiontypename from region ", $iso);
$gettranslations .= "Inner Join regiontype ON region.regiontypeid = regiontype.id ";
if(is_numeric($q)){
$gettranslations .= sprintf("where parent_id = %u ", $q);
} elseif($q != ""){
$gettranslations .= "where ( ";
$gettranslations .= sprintf("lower(region.name_ar) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_bg) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_ca) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_zh) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_ct) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_hr) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_cs) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_da) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_nl) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_en) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_et) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_fi) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_fr) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_de) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_el) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_he) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_hi) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_hu) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_id) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_it) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_ja) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_ko) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_lv) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_lt) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_fa) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_pl) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_pt) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_ro) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_ru) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_sr) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_sl) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_es) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_sv) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_tl) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_ta) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_th) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_tr) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_uk) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_ur) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_sw) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_sq) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_ka) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_hy) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_bn) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_gu) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_mr) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_te) like '%s' or ", $sql_q);
$gettranslations .= sprintf("lower(region.name_vi) like '%s' ", $sql_q);
$gettranslations .= ") ";
} else {
$gettranslations .= sprintf("where length(region.name_%s) ", $iso);
$gettranslations .= sprintf("IS %s NULL ", $nullcode);
if($limit == "false" || $limit == ""){
$gettranslations .= sprintf("and population > %u ", $pop);
} else {
$gettranslations .= "and population > 25000 ";
}
}
$gettranslations .= sprintf("and region.importance >= %u ", $limit);
$gettranslations .= "and region.deleted = false ";
if ($sort == 2) {
$gettranslations .= "order by length(name_".$translatelanguage."), region.importance desc, name_".$translatelanguage." nulls last ";
} elseif ($sort == 3) {
$gettranslations .= "order by name_".$translatelanguage.", region.importance desc, name_".$translatelanguage." nulls last ";
} elseif ($sort == 4) {
$gettranslations .= "order by region.id, region.importance desc, name_".$translatelanguage." nulls last ";
} else {
$gettranslations .= "order by region.importance desc, population desc nulls last, region.name_".$translatelanguage." nulls last ";
}
$gettranslations .= sprintf("OFFSET %u ", $offset);
$gettranslations .= sprintf("LIMIT %u ", $maxrows);
$content_vars['gettranslations'] = query($gettranslations);
}
/*
echo "";
echo var_dump($content_vars['counttranslations']);
echo "
";
*/
$translations = t("Translations");
if ($translatelanguage == "de") {
$of = "von";
$into = "nach";
$currentlanguagetext = "deutsch";
$totalrecords = "Einträge gesamt";
$nextpage = "nächste Seite";
$previouspage = "vorherige Seite";
$importance = "Wichtigkeit";
$translationhint = "Übersetzungshinweis";
$occurrence = "Vorkommen";
$searchfortext = "Suche nach Text";
$andtranslateinto = "und übersetze nach ";
$search = "Suche";
$pleaseread = "Bitte lesen Sie in der verlinkten Seite zu Phorio Standards die englischen Details zu jeder Übersetzung.";
} else {
$of = "of";
$into = "into";
$currentlanguagetext = "english";
$totalrecords = "Total records";
$nextpage = "next page";
$previouspage = "previous page";
$importance = "Importance";
$translationhint = "Translation hint";
$occurrence = "Ocurrence";
$searchfortext = "Search for text";
$andtranslateinto = "and translate into";
$search = "Search";
$pleaseread = "Please read the linked Phorio Standards page in order to learn more about each definition.";
}
?>
()
Wenn ein Text einen Platzhalter beinhaltet (%s), bitte auch %s an der richtigen Stelle in Ihrer Übersetzung verwenden (die Website wird dann den richtigen Text in den Platzhalter eintragen wenn Sie %s in Ihrer Übersetzung verwenden).
When a text contains a placeholder (%s), please also list %s in your translation at the right position where it should be shown (the website will then insert the right placeholder text when you include %s in your translation).
Entering a dash '-' will use the english default text for the translation into ().