\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 "../../../camp2011/includes/footer.php"; ?>