chat room private messaging help

[acey]

ok , well im a php beginer and i have been working on a php chatroom and now asking for a little help from someone that knows more than me , what i would like to have is private messaging i have had a few ideas but they dont seem to work all that well

here is some of my code

<?
session_register("uid");
session_register("pwd");
require_once("db.php");
require_once("common.php");

dbconnect('sessions');
$sql="SELECT * FROM oc";
$result = mysql_query($sql);

if (!$result) {
error("A database error occurred in processing your ".
"submission.\nIf this error persists, please ".
"contact .");
}

$numb=mysql_numrows($result);

$useron=mysql_result($result,$i,"online");

dbconnect('sessions');
$sql="SELECT * FROM chatuser where userid
='$uid'";
$result = mysql_query($sql);

if (!$result) {
error("A database error occurred in processing your ".
"submission.\nIf this error persists, please ".
"contact .");
}
$numb=mysql_numrows($result);

$private=mysql_result($result,0,"private");

echo "<br>$private";

echo "<form method=\"post\" action=\"sndprivate.php\">
<input type=\"text\" name=\"pm\">
<select name=\"who\">";

echo "<option value=\"$useron\">$useron";
$i++;
echo "</select>";

echo "</form>";

?>

and sndprivate.php

<?
session_register("uid");
session_register("pwd");
include('accesskill.php');
require_once('common.php');
require_once('db.php');
dbconnect('sessions');
$sql="SELECT * FROM chatuser";
$result = mysql_query($sql);

if (!$result) {
error("A database error occurred in processing your ".
"submission.\nIf this error persists, please ".
"contact .");
}

dbconnect('sessions');
$sql="SELECT * FROM chatuser where userid
='$uid'";
$result = mysql_query($sql);

if (!$result) {
error("A database error occurred in processing your ".
"submission.\nIf this error persists, please ".
"contact .");
}
$numb=mysql_numrows($result);

$private=mysql_result($result,0,"private");

dbconnect('sessions');
$sql ="UPDATE chatuser SET private='$who $pm<br>$private'";
$result = mysql_query($sql);
if (!$result) {
error("A database error occurred in processing your ".
"submission.\nIf this error persists, please ".
"contact .");
}
include'private.php';

?>

this does work , but i would like to limit it to lines also delete old lines ! im not sure ne help will be appreciated and or a betta idea thank you

[scoppc]

I have done that and I cant really show u all the code here.
What I have done is basically having a field called "logintime" in "chatuser" table.
This will be used to display all messages which have bigger timestamp than the "logintime".

For Private Message, u need to have a field called "privateTo" or some other name u like that stores the username of the recipient and "private" that holds a value to determine whether the message is a private one.

In the PHP File that outputs the messages to the users' screen, do something like the following:

if ($private=="y"){
						if ($privateto==$username OR $by==$username){
			 ?>
	 			<table width="100%" border="0" cellspacing="1" cellpadding="3" class="dotted">
				<tr> 
				  <td width="25%" valign="top"><?php print "<strong>" . $by . "</strong>";  ?>
				  <font color="#999999">(<?php print date("H:i",$postedTime); ?>):</font>
				  </td>
				  <td width="75%" valign="top">
				  <?php
					$text=stripspec($data['ctText']);
					$style=$data['ctStyle'];
				  ?>
				  <font <?php print $style; ?>>
				  <?php print $text; ?>
				  </td>
				</tr>
			  </table>		
	  <?php
	 			}
			}
?>

I use the concept above and everything is fine.

[acey]

if someone could , can you continue to explain this method 🙂 or your own

[acey]

.

[acey]

bump

[acey]

bump , someone help please