if (!defined('WEBPATH')) include $_SERVER['DOCUMENT_ROOT'].'/system/default.php'; header("Content-Type:text/html;charset=utf-8"); echo ''; echo ''; echo ''; echo ''; ?> if(isset($_GET['id'])) { if(isset($_POST['descr_ru'])) { if(isset($_GET['type']) && $_GET['type']=='service' ) { $DB->Exec('UPDATE goods SET descr="'.mysql_real_escape_string($_POST['descr_ru']).'" WHERE id='.$_GET['id'].' '); echo mysql_error(); $DB->Exec('INSERT INTO languages_texts (type,objectid,translation,lang,col) VALUES ("goods","'.$_GET['id'].'","'.$_POST['descr_lv'].'","lv","descr") ON DUPLICATE KEY UPDATE translation="'.$_POST['descr_lv'].'" '); $DB->Exec('INSERT INTO languages_texts (type,objectid,translation,lang,col) VALUES ("goods","'.$_GET['id'].'","'.$_POST['title_lv'].'","lv","title") ON DUPLICATE KEY UPDATE translation="'.$_POST['title_lv'].'" '); echo mysql_error(); echo "Saved"; } else { //$DB->Exec('UPDATE goods SET descr="'.mysql_real_escape_string($_POST['descr_ru']).'" WHERE id='.$_GET['id'].' '); echo mysql_error(); $DB->Exec('INSERT INTO languages_texts (type,objectid,translation,lang,col) VALUES ("service","'.$_GET['id'].'","'.$_POST['descr_lv'].'","lv","page") ON DUPLICATE KEY UPDATE translation="'.$_POST['descr_lv'].'" '); $DB->Exec('INSERT INTO languages_texts (type,objectid,translation,lang,col) VALUES ("service","'.$_GET['id'].'","'.$_POST['title_lv'].'","lv","title") ON DUPLICATE KEY UPDATE translation="'.$_POST['title_lv'].'" '); echo mysql_error(); echo "Saved"; } } } if(isset($_GET['type']) && $_GET['type']=='service' ) { } else { $row_query_2=$DB->Exec('SELECT translation FROM languages_texts WHERE type="goods" AND objectid='.$_GET['id'].' AND lang="lv" AND col="descr" '); list($translation_descr) = mysql_fetch_row($row_query_2); $row_query_2=$DB->Exec('SELECT translation FROM languages_texts WHERE type="goods" AND objectid='.$_GET['id'].' AND lang="lv" AND col="title" '); list($translation_title) = mysql_fetch_row($row_query_2); $row_query=$DB->Exec('SELECT title,descr FROM goods WHERE id= '.$_GET['id']); list($title,$descr) = mysql_fetch_row($row_query); } echo '