\n"; echo Get_Text("pub_sprache_text1") . "

\n"; echo "" . Get_Text("pub_sprache_ShowEntry") . ""; // ausgabe Tabellenueberschift $SQL_Sprachen = "SELECT `Sprache` FROM `Sprache` GROUP BY `Sprache`;"; $erg_Sprachen = mysql_query($SQL_Sprachen, $con); echo mysql_error($con); for ($i = 0; $i < mysql_num_rows($erg_Sprachen); $i++) $Sprachen[mysql_result($erg_Sprachen, $i, "Sprache")] = $i; echo "\t\n\t\t"; echo "\t\t"; foreach ($Sprachen as $Name => $Value) echo ""; echo "\t\t"; echo "\t\t"; if (isset ($_GET["ShowEntry"])) { // ausgabe eintraege $SQL = "SELECT * FROM `Sprache` ORDER BY `TextID`;"; $erg = mysql_query($SQL, $con); echo mysql_error($con); $TextID_Old = mysql_result($erg, 0, "TextID"); for ($i = 0; $i < mysql_num_rows($erg); $i++) { $TextID_New = mysql_result($erg, $i, "TextID"); if ($TextID_Old != $TextID_New) { echo ""; echo "\n"; echo "\t\t\n"; foreach ($Sprachen as $Name => $Value) { $Value = html_entity_decode($Value, ENT_QUOTES); echo "\t\t\n"; $Sprachen[$Name] = ""; } echo "\t\t\n"; echo ""; echo "\n"; $TextID_Old = $TextID_New; } $Sprachen[mysql_result($erg, $i, "Sprache")] = mysql_result($erg, $i, "Text"); } /*FOR*/ } //fuer neu eintraege echo ""; echo "\n"; echo "\t\t\n"; foreach ($Sprachen as $Name => $Value) echo "\t\t\n"; echo "\t\t\n"; echo ""; echo "\n"; echo "

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

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

"; foreach ($_GET as $k => $v) { if ($k != "TextID") { $sql_test = "SELECT * FROM `Sprache` " . "WHERE `TextID`='" . $_GET["TextID"] . "' AND `Sprache`='$k'"; $erg_test = mysql_query($sql_test, $con); if (mysql_num_rows($erg_test) == 0) { $sql_save = "INSERT INTO `Sprache` (`TextID`, `Sprache`, `Text`) " . "VALUES ('" . $_GET["TextID"] . "', '$k', '$v')"; echo $sql_save . "
"; $Erg = mysql_query($sql_save, $con); if ($Erg == 1) echo "\t $k Save: OK
\n"; else echo "\t $k Save: KO
\n"; } else if (mysql_result($erg_test, 0, "Text") != $v) { $sql_save = "UPDATE `Sprache` SET `Text`='$v' " . "WHERE `TextID`='" . $_GET["TextID"] . "' AND `Sprache`='$k' "; echo $sql_save . "
"; $Erg = mysql_query($sql_save, $con); if ($Erg == 1) echo "\t $k Update: OK
\n"; else echo "\t $k Update: KO
\n"; } else echo "\t $k no changes
\n"; } } } include ("includes/footer.php"); ?>