'; echo ''; echo ''; echo ''; if(!isset($_GET['id'])) { ?>

Система переводов

Товары магазина Категории сервиса Страницы сервиса Exec('UPDATE service_pages SET title="'.mysql_real_escape_string($_POST['title_ru']).'", intro="'.mysql_real_escape_string($_POST['intro_ru']).'",content="'.mysql_real_escape_string($_POST['content_ru']).'" WHERE id='.$_GET['id'].' '); echo mysql_error(); $DB->Exec('INSERT INTO languages_texts (type,objectid,translation,lang,col) VALUES ("service","'.$_GET['id'].'","'.$_POST['title_lv'].'","lv","page") ON DUPLICATE KEY UPDATE translation="'.$_POST['title_lv'].'" '); $DB->Exec('INSERT INTO languages_texts (type,objectid,translation,lang,col) VALUES ("service","'.$_GET['id'].'","'.$_POST['intro_lv'].'","lv","intro") ON DUPLICATE KEY UPDATE translation="'.$_POST['intro_lv'].'" '); $DB->Exec('INSERT INTO languages_texts (type,objectid,translation,lang,col) VALUES ("service","'.$_GET['id'].'","'.$_POST['content_lv'].'","lv","content") ON DUPLICATE KEY UPDATE translation="'.$_POST['content_lv'].'" '); echo mysql_error(); echo " Сохранено"; } $row_query_2=$DB->Exec('SELECT translation FROM languages_texts WHERE type="service" AND objectid='.$_GET['id'].' AND lang="lv" AND col="page" '); list($title_lv) = mysql_fetch_row($row_query_2); $row_query_2=$DB->Exec('SELECT translation FROM languages_texts WHERE type="service" AND objectid='.$_GET['id'].' AND lang="lv" AND col="intro" '); list($intro_lv) = mysql_fetch_row($row_query_2); $row_query_2=$DB->Exec('SELECT translation FROM languages_texts WHERE type="service" AND objectid='.$_GET['id'].' AND lang="lv" AND col="content" '); list($content_lv) = mysql_fetch_row($row_query_2); $row_query=$DB->Exec('SELECT title,intro,content FROM service_pages WHERE id= '.$_GET['id']); list($title,$intro,$content) = mysql_fetch_row($row_query); $title = htmlspecialchars($title); $title_lv = htmlspecialchars($title_lv); echo '
'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '
Русский Латышский
Интро
Описание
'; echo '
'; echo ''; } else { ?> Exec('SELECT * FROM languages_texts WHERE type="service" AND lang="lv" AND col!="title"'); while($row = $DB->Fetch($row_query)) { if(strlen($row['translation'])>=4) $translation[$row['col']][$row['objectid']] = $row['translation']; } echo '

Страницы сервиса

'; echo ''; echo ''; echo ''; echo ''; $row_query=$DB->Exec('SELECT * FROM service_pages'); while($row = $DB->Fetch($row_query)) { echo ''; echo ''; echo ''; //$goods[$product['title']]; } echo '
Название Название Интро Описание
'.$row['title'].' '.(isset($translation['page'][$row['id']]) ? "" : "" ).' '.(isset($translation['intro'][$row['id']]) && strlen($row['intro'])>3 ? "" : "" ).' '.(isset($translation['content'][$row['id']]) && strlen($row['content'])>3 ? "" : "" ).'
'; }