Slettet bruger
26. maj 2002 - 15:06
#1
<?php
$connection=mysql_connect("localhost", "jknutz", "jknutz");
mysql_select_db("jknutz", $connection);
$date = date("Y-m-d H:i:s", time());
$check = mysql_query("SELECT * FROM chat_users WHERE username = '$username'");
while($data1 = mysql_fetch_row($check))
{
$status = $data1[7];
}
if ($msg=="")
{
header("Location: send.php?username=$username&room=$room&sendcolor=$sendcolor");
}
else {
$msg = explode("_", $msg);
//finder status
if ($status == "0")
{
//her starter handlinger
if ($msg[0] == "/hej"){
if ($msg[1] == "")
{
mysql_query("INSERT INTO chatlog (username, date, msg, room)
VALUES ('$username', '$date', '<i>$username davser alle i $room</i>', '$room')");
header("Location: send.php?username=$username&room=$room&sendcolor=$sendcolor");
}
else if ($msg[1] == "$username")
{
mysql_query("INSERT INTO chatlog (username, date, msg, room)
VALUES ('$username', '$date', '<i>$username davser sig selv</i>', '$room')");
header("Location: send.php?username=$username&room=$room&sendcolor=$sendcolor");
}
else
{
$checkuser = "SELECT COUNT(*) FROM chat_users where username ='$msg[1]' AND room ='$room' AND online = '1'";
$checkuser = mysql_query($checkuser);
$checkuser = mysql_fetch_array($checkuser);
if($checkuser[0]!=0)
{
mysql_query("INSERT INTO chatlog (username, date, msg, room)
VALUES ('$username', '$date', '<i>$username davser $msg[1]</i>', '$room')");
header("Location: send.php?username=$username&room=$room&sendcolor=$sendcolor");
}
else
{
mysql_query("INSERT INTO chatlog (username, date, msg, room, touser)
VALUES ('Robot', '$date', '<i>Robot: $username brugeren $msg[1] er ikke online</i>', '$room', '$username')");
header("Location: send.php?username=$username&room=$room&sendcolor=$sendcolor");
}
}
//starter vink handling
} else if ($msg[0] == "/vink"){
if ($msg[1] == "")
{
mysql_query("INSERT INTO chatlog (username, date, msg, room)
VALUES ('$username', '$date', '<i>$username vinker til alle i $room</i>', '$room')");
header("Location: send.php?username=$username&room=$room&sendcolor=$sendcolor");
}
else if ($msg[1] == "$username")
{
mysql_query("INSERT INTO chatlog (username, date, msg, room)
VALUES ('$username', '$date', '<i>$username vinker</i>', '$room')");
header("Location: send.php?username=$username&room=$room&sendcolor=$sendcolor");
}
else
{
$checkuser = "SELECT COUNT(*) FROM chat_users where username ='$msg[1]' AND room ='$room' AND online = '1'";
$checkuser = mysql_query($checkuser);
$checkuser = mysql_fetch_array($checkuser);
if($checkuser[0]!=0)
{
mysql_query("INSERT INTO chatlog (username, date, msg, room)
VALUES ('$username', '$date', '<i>$username vinker til $msg[1]</i>', '$room')");
header("Location: send.php?username=$username&room=$room&sendcolor=$sendcolor");
}
else
{
mysql_query("INSERT INTO chatlog (username, date, msg, room, touser)
VALUES ('Robot', '$date', '<i>Robot: $username brugeren $msg[1] er ikke online</i>', '$room', '$username')");
header("Location: send.php?username=$username&room=$room&sendcolor=$sendcolor");
}
}
}
//handlingen fortæl
else if ($msg[0] == "/fortæl"){
if ($msg[1] == "")
{
mysql_query("INSERT INTO chatlog (username, date, msg, room, touser)
VALUES ('Robot', '$date', '<font color=red>Robot: Du skal vælge hvem du vil skrive til</font>', '$room', '$username')");
header("Location: send.php?username=$username&room=$room&sendcolor=$sendcolor");
}
else if ($msg[1] == "$username")
{
mysql_query("INSERT INTO chatlog (username, date, msg, room, touser)
VALUES ('Robot', '$date', '<font color=red>Robot: Du kan da ikke skrive til dig selv :o)</font>', '$room', '$username')");
header("Location: send.php?username=$username&room=$room&sendcolor=$sendcolor");
}
else
{
$checkuser2 = "SELECT COUNT(*) FROM chat_users where username ='$msg[1]' AND room ='$room' AND online = '1'";
$checkuser2 = mysql_query($checkuser2);
$checkuser2 = mysql_fetch_array($checkuser2);
if($checkuser2[0]!=0)
{
mysql_query("INSERT INTO chatlog (username, date, msg, room, touser)
VALUES ('Robot', '$date', 'Privat fra $username: $msg[2]', '$room', '$msg[1]')");
header("Location: send.php?username=$username&room=$room&sendcolor=$sendcolor");
mysql_query("INSERT INTO chatlog (username, date, msg, room, touser)
VALUES ('Robot', '$date', 'Privat til $msg[1]: $msg[2]', '$room', '$username')");
header("Location: send.php?username=$username&room=$room&sendcolor=$sendcolor");
}
else
{
mysql_query("INSERT INTO chatlog (username, date, msg, room, touser)
VALUES ('Robot', '$date', '<i>Robot: $username brugeren $msg[1] er ikke online</i>', '$room', '$username')");
header("Location: send.php?username=$username&room=$room&sendcolor=$sendcolor");
}
}
}
else
{
//her sender den bare beskeden normal
$msg = implode(" ", $msg);
$date = date("Y-m-d H:i:s", time());
$msg = strip_tags($msg, "");
mysql_query("INSERT INTO chatlog (username, date, msg, room)
VALUES ('$username', '$date', '$username: $msg', '$room')");
mysql_query("UPDATE chat_users SET date='$date' WHERE username='$username'");
header("Location: send.php?username=$username&room=$room&sendcolor=$sendcolor");
}
} else if ($status == "10")
//status 10 handlinger
{
//kick handling
if ($msg[0] == "/kick"){
if ($msg[1] == "")
{
mysql_query("INSERT INTO chatlog (username, date, msg, room)
VALUES ('$username', '$date', '<i>$username overvejer at kicke alle i $room</i>', '$room')");
header("Location: send.php?username=$username&room=$room&sendcolor=$sendcolor");
}
else if ($msg[1] == "$username")
{
mysql_query("INSERT INTO chatlog (username, date, msg, room)
VALUES ('$username', '$date', '<i>$username kicker snart sig selv :o)</i>', '$room')");
header("Location: send.php?username=$username&room=$room&sendcolor=$sendcolor");
}
else
{
$checkuser = "SELECT COUNT(*) FROM chat_users where username ='$msg[1]' AND room ='$room' AND online = '1'";
$checkuser = mysql_query($checkuser);
$checkuser = mysql_fetch_array($checkuser);
if($checkuser[0]!=0)
{
mysql_query("INSERT INTO chatlog (username, date, msg, room)
VALUES ('$username', '$date', '<i>$username overvejer at kicke $msg[1]</i>', '$room')");
header("Location: send.php?username=$username&room=$room&sendcolor=$sendcolor");
}
else
{
mysql_query("INSERT INTO chatlog (username, date, msg, room, touser)
VALUES ('Robot', '$date', '<i>Robot: $username brugeren $msg[1] er ikke online</i>', '$room', '$username')");
header("Location: send.php?username=$username&room=$room&sendcolor=$sendcolor");
}
}
//slut kick handling
}
else
{
mysql_query("INSERT INTO chatlog (username, date, msg, room, touser)
VALUES ('Robot', '$date', 'Desværre du kan ikke bruge denne kommando', '$room', '$username')");
header("Location: send.php?username=$username&room=$room&sendcolor=$sendcolor");
}
}
}
?>