1 files changed, 116 insertions, 0 deletions
diff --git a/admin/sprache.php b/admin/sprache.php
new file mode 100755
index 00000000..c3071f7d
--- /dev/null
+++ b/admin/sprache.php
@@ -0,0 +1,116 @@
+<?PHP
+
+$title = "Sprache";
+$header = "Liste der existierenden Sprcheintr&auml;ge";
+include ("./inc/header.php");
+
+
+if( !isset( $TextID )  )
+{
+	echo Get_Text("Hello").$_SESSION['Nick'].", <br>\n";
+	echo Get_Text("pub_sprache_text1")."<br><br>\n";
+	
+	// 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<table border=\"0\" class=\"border\" cellpadding=\"2\" cellspacing=\"1\">\n\t\t<tr>";
+	echo "\t\t<td class=\"contenttopic\"><b>". Get_Text("pub_sprache_TextID"). "</b></td>";
+	foreach( $Sprachen as $Name => $Value )
+		echo "<td class=\"contenttopic\"><b>". 
+			Get_Text("pub_sprache_Sprache"). " ". $Name.
+			"</b></td>";
+	echo "\t\t<td class=\"contenttopic\"><b>". Get_Text("pub_sprache_Edit"). "</b></td>";
+	echo "\t\t</tr>";
+
+
+	// 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 "<form action=\"sprache.php\">";
+			echo "<tr class=\"content\">\n";
+			echo "\t\t<td>$TextID_Old ".
+			     "<input name=\"TextID\" type=\"hidden\" value=\"$TextID_Old\"> </td>\n";
+		
+			foreach( $Sprachen as $Name => $Value )
+			{
+				echo "\t\t<td><textarea name=\"$Name\" cols=\"22\" rows=\"8\">$Value</textarea></td>\n";
+				$Sprachen[ $Name ] = "";
+			}
+			
+			echo "\t\t<td><input type=\"submit\" value=\"Save\"></td>\n";
+			echo "</tr>";
+			echo "</form>\n";
+			$TextID_Old = $TextID_New;
+		}
+		$Sprachen[ mysql_result( $erg, $i, "Sprache" ) ] = mysql_result( $erg, $i, "Text" );
+	} /*FOR*/
+	
+	//fuer neu eintraege
+	echo "<form action=\"sprache.php\">";
+	echo "<tr class=\"content\">\n";
+	echo "\t\t<td><input name=\"TextID\" type=\"text\" value=\"new\"> </td>\n";
+		
+	foreach( $Sprachen as $Name => $Value )
+		echo "\t\t<td><textarea name=\"$Name\" cols=\"22\" rows=\"8\">$Name Text</textarea></td>\n";
+
+	echo "\t\t<td><input type=\"submit\" value=\"Save\"></td>\n";
+	echo "</tr>";
+	echo "</form>\n";
+	
+	
+	echo "</table>\n";
+} /*if( !isset( $TextID )  )*/
+else
+{
+	echo "edit: ". $TextID. "<br><br>";
+	foreach ($_GET as $k => $v) {
+		if( $k != "TextID" ) 
+		{
+			$sql_test = "SELECT * FROM `Sprache` ".
+				"WHERE `TextID`='$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 ('$TextID', '$k', '$v')";
+		        	$Erg = mysql_query($sql_save, $con);
+			        if ($Erg == 1)
+			                echo "\t $k Save: OK<br>\n";
+			        else
+		        	        echo "\t $k Save: KO<br>\n";
+			}
+			else if( mysql_result($erg_test, 0, "Text")!=$v )
+			{
+				$sql_save = "UPDATE `Sprache` SET `Text`='$v' ".
+					"WHERE `TextID`='$TextID' AND `Sprache`='$k' ";
+				  echo $sql_save."<br>";
+		        	$Erg = mysql_query($sql_save, $con);
+			        if ($Erg == 1)
+			                echo "\t $k Update: OK<br>\n";
+			        else
+		        	        echo "\t $k Update: KO<br>\n";
+			}
+			else
+				echo "\t $k no changes<br>\n";
+		}
+	}
+	   
+}
+
+include ("./inc/footer.php");
+?>
+