I am creating an online game. I have attempted to create an ingame message system but am having problems with the text box posting to the database. When a message is sent all the recipient gets is who its from and a date.. empty message. Please find below the code as well as the table structure. I have been going over this code for a while now and tried different things.. any help would be appreciated.
<?php
session_start();
include "includes/db_connect.php";
include "includes/functions.php";
logincheck();
$username=$_SESSION['username'];
echo "<html>
$style
<center>";
$goody = mysql_query("SELECT `message`, `date`, `from` FROM `inbox` WHERE `id`='$rep'");
while($success = mysql_fetch_row($goody)){
$ini = $success[0];
$dateon = $success[1];
$fromper = $success[2];
}
if(strip_tags($_POST['Send'])){
$text= strip_tags(addslashes($_POST['text']));
$to = strip_tags(addslashes($_POST['to']));
$rep = $_GET['rep'];
$sql_username_check = mysql_query("SELECT username FROM users WHERE username='$to'");
$username_check = mysql_num_rows($sql_username_check);
if ($username_check == 0){
echo '<font color=red>There is no user with that name! </font>';
}else{
$blocked=mysql_num_rows(mysql_query("SELECT * FROM friends WHERE person='$username' AND type='Blocked' AND username='$to'"));
if ($blocked != "0"){
echo "This user has blocked you.";
}elseif ($blocked == "0"){
$date = gmdate('Y-m-d h:i:s');
$sql = mysql_query("INSERT INTO `inbox` (`id`, `to`, `from`, `message`, `date`, `read`) VALUES ('', '$to', '$username', '$ini', '$date', '0');") or die (mysql_error());
if(!$sql){
echo 'Error please contact an admin.';
}else{
echo "Message sent to <a href=profile.php?viewuser=$to><b>$to</b></a>";
}}}}
?>
<html>
<link href="includes/in.css" rel="stylesheet" type="text/css">
<center>
<form action="" method="post">
<table width="66%" border="0" align="center" cellpadding="0" cellspacing="3">
<tr>
<td><table width="100%" height="21" border="1" align="center" cellpadding="0" cellspacing="0" class=thinline rules=none>
<tr>
<td><table width="100%" border="0" cellspacing="3" cellpadding="0">
<tr>
<td width="53%"><div align="center"><a href="baf.php">User management</a></div></td>
<td width="47%"><div align="center"><a href="inbox.php">Inbox</a></div></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" border="1" align="center" cellpadding="0" cellspacing="0" class=thinline rules=none>
<tr>
<td class=header><div align="center">Compose a message</div></td>
</tr>
<tr bgcolor=white>
<td class=tip><div align="center">Compose a message.</div></td>
</tr>
<tr bgcolor=black>
<td height=1></td>
</tr>
<tr>
<td><table width=300 cellspacing=1 cellpadding=1 border=0 bordercolor=black class=black2 align=center>
<tr class=title>
<td width=248>Send To: </td>
<td width=357><input type=text name=to class=submit style=width: 60%; value='<?php echo $fromper; ?>'></td>
</tr>
<tr class=text>
<td colspan=2>Message:</td>
</tr>
<tr class=sub>
<td colspan=2><textarea name='text' style='width: 98%; height: 175px' class=submit><?php if ($m > 0){ echo "[b]On:[/b] $dateon. $fromper [b] Wrote:[/b] $ini"; }else{ } ?></textarea></td>
</tr>
<tr class=title>
<td colspan=2><input type=submit name=Send value=Send class=submit></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<br>
</form>
<?php include_once"includes/footer.php"; ?>
here is the table structure
TABLE inbox (
id int(11) NOT NULL auto_increment,
to varchar(40) NOT NULL default '',
from varchar(40) NOT NULL default '',
message text NOT NULL,
date datetime NOT NULL default '0000-00-00 00:00:00',
read enum('0','1') NOT NULL default '0',
saved int(2) NOT NULL default '0',
event_id int(11) NOT NULL default '0',
witness enum('0','1') NOT NULL default '0',
witness_per varchar(40) NOT NULL default '',
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=175
