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

\n"; //show exist Messages $SQL = "SELECT * FROM `Messages` WHERE `SUID`='" . $_SESSION["UID"] . "' OR `RUID`='" . $_SESSION["UID"] . "'"; $erg = mysql_query($SQL, $con); echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; for ($i = 0; $i < mysql_num_rows($erg); $i++) { echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } // send Messeges echo ""; echo "\n"; echo "\n"; echo "\n"; // Listet alle Nicks auf echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo ""; echo "

" . Get_Text("pub_messages_Datum") . "	" . Get_Text("pub_messages_Von") . "	" . Get_Text("pub_messages_An") . "	" . Get_Text("pub_messages_Text") . "
" . mysql_result($erg, $i, "Datum") . "	" . UID2Nick(mysql_result($erg, $i, "SUID")) . "	" . UID2Nick(mysql_result($erg, $i, "RUID")) . "	" . mysql_result($erg, $i, "Text") . "	"; if (mysql_result($erg, $i, "RUID") == $_SESSION["UID"]) { echo "" . Get_Text("pub_messages_DelMsg") . ""; if (mysql_result($erg, $i, "isRead") == "N") echo "" . Get_Text("pub_messages_MarkRead") . ""; } else { if (mysql_result($erg, $i, "isRead") == "N") echo Get_Text("pub_messages_NotRead"); } echo "
		\n"; $usql = "SELECT * FROM `User` WHERE (`UID`!='" . $_SESSION["UID"] . "') ORDER BY `Nick`"; $uErg = mysql_query($usql, $con); $urowcount = mysql_num_rows($uErg); for ($k = 0; $k < $urowcount; $k++) { echo "" . mysql_result($uErg, $k, "Nick") . "\n"; } echo "

\n"; break; case "SendMsg" : echo Get_Text("pub_messages_Send1") . "...
\n"; $SQL = "INSERT INTO `Messages` ( `Datum` , `SUID` , `RUID` , `Text` ) VALUES (" . "'" . gmdate("Y-m-j H:i:s", time()) . "', " . "'" . $_SESSION["UID"] . "', " . "'" . $_POST["RUID"] . "', " . "'" . $_POST["Text"] . "');"; $Erg = mysql_query($SQL, $con); if ($Erg == 1) echo Get_Text("pub_messages_Send_OK") . "\n"; else echo Get_Text("pub_messages_Send_Error") . "...\n(" . mysql_error($con) . ")"; break; case "MarkRead" : $SQL = "UPDATE `Messages` SET `isRead` = 'Y' " . "WHERE `Datum` = '" . $_GET["Datum"] . "' AND `RUID`='" . $_SESSION["UID"] . "' " . "LIMIT 1 ;"; $Erg = mysql_query($SQL, $con); if ($Erg == 1) echo Get_Text("pub_messages_MarkRead_OK") . "\n"; else echo Get_Text("pub_messages_MarkRead_KO") . "...\n(" . mysql_error($con) . ")"; break; case "DelMsg" : $SQL = "DELETE FROM `Messages` " . "WHERE `Datum` = '" . $_GET["Datum"] . "' AND `RUID` ='" . $_SESSION["UID"] . "' " . "LIMIT 1;"; $Erg = mysql_query($SQL, $con); if ($Erg == 1) echo Get_Text("pub_messages_DelMsg_OK") . "\n"; else echo Get_Text("pub_messages_DelMsg_KO") . "...\n(" . mysql_error($con) . ")"; break; default : echo Get_Text("pub_messages_NoCommand"); } include "includes/footer.php"; ?>