function sendChat($to_enroll, $to_user, $msg, $enroll, $username) { $t = time() - 180; // time to be used to check if the message can be concatinated. $i = 0; $msg = htmlentities($msg); $msg = mysql_real_escape_string($msg); $sql = "SELECT null FROM stud_data WHERE usr_roll=" . $enroll . " AND online='yes' LIMIT 1"; $result = mysql_query($sql); $count = mysql_num_rows($result); if ($count == 0) { return; } $sql = "SELECT from_enroll,msg_id FROM chat_messages WHERE ((to_enroll='" . $to_enroll . "' AND from_enroll='" . $enroll . "') OR (to_enroll='" . $enroll . "' AND from_enroll='" . $to_enroll . "')) AND time>=" . $t . " ORDER BY msg_id DESC LIMIT 1"; $result = mysql_query($sql); $count = 1; while ($row = mysql_fetch_assoc($result)) { if ($row['from_enroll'] == $enroll) { $msg_id = $row['msg_id']; $newmsg = "<br>" . $msg; $sql = "UPDATE chat_messages SET msg=concat(msg,'" . $newmsg . "') ,time=" . time() . " WHERE msg_id=" . $msg_id . ""; mysql_query($sql); } else { $chat_id = getLastChatId($to_enroll); $newsql = "INSERT INTO chat_messages (chat_id,to_enroll,to_user,from_enroll,from_user,msg,time) VALUES (" . $chat_id . ", " . $to_enroll . ", '" . $to_user . "', " . $enroll . ", '" . $username . "', '" . $msg . "', " . time() . ")"; mysql_query($newsql); } $count = 0; } if ($count) { $chat_id = getLastChatId($to_enroll); $newsql = "INSERT INTO chat_messages (chat_id,to_enroll,to_user,from_enroll,from_user,msg,time) VALUES (" . $chat_id . ", " . $to_enroll . ", '" . $to_user . "', " . $enroll . ", '" . $username . "', '" . $msg . "', " . time() . ")"; mysql_query($newsql); } setWritingStatus($enroll, "no"); echo "<root success='yes'><user>" . $to_user . "</user></root>"; }
$to_user = mysql_real_escape_string($_POST['name']); $t = time() - 3; $sql = "SELECT NULL FROM stud_data WHERE usr_roll=" . $to_roll . " AND time>=" . $t; $result = mysql_query($sql); $count = mysql_num_rows($result); if ($count == 1) { sendChat($to_roll, $to_user, $msg, $enroll, $username); } else { echo "<root success='no'><user>" . $to_user . "</user></root>"; } } else { if ($action == "getChat") { getChat($to_roll, $enroll); } else { if ($action == "setWritingStatus") { setWritingStatus($enroll, "yes"); } else { if ($action == "checkMyOnlineStatus") { checkMyOnlineStatus($enroll); } else { if ($action == "setOnlineStatus") { $status = mysql_real_escape_string($_POST['status']); setOnlineStatus($enroll, $status); } else { if ($action == "popUpChat") { popUpChat($enroll); } } } } }