\n"; $html .= Get_Text("pub_sprache_text1") . "

\n"; $html .= "" . Get_Text("pub_sprache_ShowEntry") . ""; // ausgabe Tabellenueberschift $html .= "\t\n\t\t"; $html .= "\t\t"; foreach($languages as $language => $language_name) { $html .= ""; $Sprachen[$language] = $language_name; } $html .= "\t\t"; $html .= "\t\t"; if (isset ($_GET["ShowEntry"])) { // ausgabe eintraege $sprache_source = sql_select("SELECT * FROM `Sprache` ORDER BY `TextID`, `Sprache`"); $TextID_Old = $sprache_source[0]['TextID']; foreach($sprache_source as $sprache_entry) { $TextID_New = $sprache_entry['TextID']; if ($TextID_Old != $TextID_New) { $html .= ""; $html .= "\n"; $html .= "\t\t\n"; foreach ($Sprachen as $Name => $Value) { $Value = html_entity_decode($Value, ENT_QUOTES); $html .= "\t\t\n"; $Sprachen[$Name] = ""; } $html .= "\t\t\n"; $html .= ""; $html .= "\n"; $TextID_Old = $TextID_New; } $Sprachen[$sprache_entry['Sprache']] = $sprache_entry['Text']; } /*FOR*/ } //fuer neu eintraege $html .= ""; $html .= "\n"; $html .= "\t\t\n"; foreach ($Sprachen as $Name => $Value) $html .= "\t\t\n"; $html .= "\t\t\n"; $html .= ""; $html .= "\n"; $html .= "

" . Get_Text("pub_sprache_TextID") . "	" . Get_Text("pub_sprache_Sprache") . " " . $language . "	" . Get_Text("pub_sprache_Edit") . "
$TextID_Old " . "	$Value
	$Name Text

\n"; } /*if( !isset( $TextID ) )*/ else { $html .= "edit: " . $_POST["TextID"] . "

"; foreach ($_POST as $k => $v) { if ($k != "TextID") { $sql_test = "SELECT * FROM `Sprache` " . "WHERE `TextID`='" . sql_escape($_POST["TextID"]) . "' AND `Sprache`='" . sql_escape($k) . "'"; $erg_test = sql_select("SELECT * FROM `Sprache` WHERE `TextID`='" . sql_escape($_POST["TextID"]) . "' AND `Sprache`='" . sql_escape($k) . "'"); if (count($erg_test) == 0) { $sql_save = "INSERT INTO `Sprache` (`TextID`, `Sprache`, `Text`) " . "VALUES ('" . sql_escape($_POST["TextID"]) . "', '" . sql_escape($k) . "', '" . sql_escape($v) . "')"; $html .= $sql_save . "
"; $Erg = sql_query($sql_save); $html .= success("$k Save: OK
\n", true); } else if ($erg_test[0]['Text'] != $v) { $sql_save = "UPDATE `Sprache` SET `Text`='" . sql_escape($v) . "' " . "WHERE `TextID`='" . sql_escape($_POST["TextID"]) . "' AND `Sprache`='" . sql_escape($k) . "' "; $html .= $sql_save . "
"; $Erg = sql_query($sql_save); $html .= success(" $k Update: OK
\n", true); } else $html .= "\t $k no changes
\n"; } } } return $html; } ?>