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

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

Товары магазина Категории сервиса Страницы сервиса 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 " Сохранено"; } $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 '

'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '

Русский	Латышский

'.$descr.'	'.$translation_descr.'

'; echo '
'; echo ''; } else { ?> Exec('SELECT * FROM languages_texts WHERE type="goods" AND lang="lv"'); 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 goods '); while($row = $DB->Fetch($row_query)) { echo ''; echo ''; echo ''; //$goods[$product['title']]; } echo '

Название	Символов	Название	Описание
'.$row['title'].'	'.strlen(str_replace(" ","",$row['descr'])) .'	'.(isset($translation['title'][$row['id']]) ? "" : "" ).'	'.(isset($translation['descr'][$row['id']]) && strlen($row['descr'])>3 ? "" : "" ).'

'; }