PHP IM Login
Posted: Tue Dec 17, 2002 8:55 pm
The instant messenger I am setting up is in PHP and connects to a mysql database. It has scripts for login, messaging, and registration. It's supposed to log you out when you close the IM window. It keeps logging people out as soon as they register or login. I figure that the problem has to either be in the im window script or the logout script
window.php
logout.php
Anyone see something I'm missing?[/i]
window.php
Code: Select all
<?
include ("mysql.php");
mysql_select_db("swacfans_im");
$query="select * from users where username='$username' and status="yes"";
$result=mysql_query($query, $link);
if($result!=0)
{
print"<center><body bgcolor="000066"><span style=background-color:8080C0><font color=lightblue> $username you have logged out </span>";
exit;
}
else
{
$query="delete from chatdata where message ='<br>' or buddy='to <font color=blue></font>'";
mysql_query($query,$link);
$query="select sender, buddy, message from chatdata where sender = '<font color=red>$username</font>' or sender like '%$buddy%' and
buddy ='<font color=blue>$buddy</font>' or buddy like '%$username%' order by id desc";
echo mysql_error();Code: Select all
<?
include("mysql.php");
if($user=="$username")
{
$query="delete from chatdata where username like '%$username%'";
mysql_query($query, $link);
$query="update users set status='no' where username='$username'";
$result= mysql_query($query, $link);
header("location: index.php");
}
print$msg;
print$user;
?>