Simpel chatbox script

[hackie900]

Hallo,
Ik zoek een eigenlijk simpel chatbox script.
het hoeft eigenlijk alleen maar:
-je naam invoeren voordat je bij de chatbox bent.
-een box waar de berichten in komen(wel met naam van de afzender en als mogenlijk met tijd).
-een textbox waar je iets in kan typen.
-een button om je bericht te verzenden.

Dit mag over MySql gaan.
Bij voorbaat dank.

Hackie900

P.S. het maakt niet uit in welke programmeertaal.

 

[ecross]

ik heb het volgende script, het ververst telkens om te zien of er nieuwe berichten zijn.
tabellen:

chatmessages:
ID bigint(200) Primary auto_increment
name varchar(255)
IP varchar(255) postime bigint(200)
message varchar(400)

chatnames:
id int(3) Primary auto_increment
ip varchar(20)
name varchar(30)

ipbans:
IPID bigint(200) Primary auto_increment
IP varchar(255)

chatframe.php:

<?php
echo "<iframe src='chatlog.php'  name='chatlogframe' width='450' height='400'></iframe>";
echo "<br><br>";
include('submit.php');
?>

chatlog.php

<?php
include "connect.php";
$getmsg="SELECT name, message from chatmessages order by postime desc limit 20";
$getmsg2=mysql_query($getmsg) or die(mysql_error());
while($getmsg3=mysql_fetch_array($getmsg2))
{
  $getmsg3=Smiley($getmsg3); //Smiley faces
   echo "<font color='red'><b>$getmsg3[name]:</b></font> $getmsg3[message]<br>";

}

function Smiley($texttoreplace)
{
    $smilies=array(
    ':)'=>"<img src='images/smile.png'>",
    ':('=>"<img src='images/sad.png'>",
    ':angry'=>"<img src='images/angry.png'>",
    ':o'=>"<img src='images/shocked.png'>",  
    '****'=>"$#$%",
    '****'=>"&$#@"
	);
    $texttoreplace = str_replace(array_keys($smilies), array_values($smilies), $texttoreplace);
    return $texttoreplace;
}
?>
<script>
  setTimeout("window.location.replace('chatlog.php')",2000);

</script>

submit.php

<?php
include "connect.php";
$getname = mysql_query("select name from chatnames where ip='{$_SERVER['REMOTE_ADDR']}'");
$getname_num = mysql_num_rows($getname);
if ($getname_num > 0){
mysql_data_seek($getname, 0);
$getname_row = mysql_fetch_array($getname);}
else {$new_name = 'new';}
if(isset($_POST['submit'])) //if submit button push has been detected
{
   $message=$_POST['message'];
   $name=$_POST['name'];
   if(strlen($message)<1)
   {
      echo "You did not input a message";
   }
   elseif(strlen($name)<1 and $new_name == 'new')
   {
      echo "You did not enter a name, please try again.";
   }
   else
   {
      $IP=$_SERVER["REMOTE_ADDR"]; //grabs poster's IP
	  if(strlen($name)>1 and $new_name == 'new'){
	  $insert_name_query="insert into chatnames (name, ip) values ('{$_POST['name']}', '{$IP}')";
	  $insert_name_result = mysql_query($insert_name_query);
	  @$insert_name_row = mysql_fetch_array($insert_name_result);
	  $name = $_POST['name'];
	  }
	  else {
	  $name = $getname_row['name'];}
      $message=strip_tags($message);
      
      $checkforbanned="SELECT IP from ipbans where IP='$IP'";
      $checkforbanned2=mysql_query($checkforbanned) or die("Could not check for banned IPS");
      if(mysql_num_rows($checkforbanned2)>0) //IP is in the banned list
      {
         echo "You IP is banned from posting.";
      }
      else
      {
         $thedate = date("U"); //grab date and time of the post
         $insertmessage="INSERT into chatmessages (name,IP,postime,message) values('$name','$IP','$thedate','$message')";
         mysql_query($insertmessage) or die("Could not insert message");
      }
   }
 
      
}
echo "<form action='chatframe.php' method='post' name='form'>";
echo "Your name: ";
if($new_name != 'new' and !isset($_POST['name'])){echo $getname_row['name']."<br>";}
elseif(isset($_POST['name'])){echo $_POST['name']."<br>";}
else{
echo "<input type='text' name='name' size='20'><br>";}
echo "Your message:<br>";
echo "<textarea name='message' cols='40' rows='2'></textarea><br>";
echo "<a onClick=\"addSmiley(':)')\"><img src='images/smile.png'></a> "; //replace images/smile.gif with the relative path of your smiley
echo "<a onClick=\"addSmiley(':(')\"><img src='images/sad.png'></a> ";
//echo "<a onClick=\"addSmiley(';)')\"><img src='images/wink.png'></a> ";
echo "<input type='submit' name='submit' value='submit'></form>";
echo "<script language=\"Java Script\" type=\"text/javascript\">\n";
echo "function addSmiley(textToAdd)\n";
echo "{\n";
echo "document.form.message.value += textToAdd;";
echo "document.form.message.focus();\n";
echo "}\n";
echo "</script>\n";
echo "<br><br>";

?>

 

[hackie900]

bedankt voor je antwoord!
Ik heb het zelf geprobeerd te maken maar het is niet gelukt.