Fik set chat.php:
<?
include ( "config.php" );
if ( !isset($s) || $s=="" ) $s = 0;
$sql = "select * from messages where stamp>'$s' order by stamp";
$res = mysql_query( $sql ) or die (mysql_error());
$num_rows = mysql_num_rows( $res );
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"
http://www.w3.org/TR/html4/loose.dtd"><html>
<script type="text/JavaScript">
var a = new Array();
<?
if ($num_rows>0) {
while ( $row=mysql_fetch_array($res) ) {
$arr_str .= "a[a.length] = \"".stripslashes($row["user"])."\";\n";
$arr_str .= "a[a.length] = \"".date( "H:i:s", $row["stamp"] )."\";\n";
$arr_str .= "a[a.length] = \"".stripslashes($row["msg"])."\";\n";
$s = $row["stamp"];
}
print $arr_str;
}
?>
parent.writeChat( a );
setTimeout( "location.href='chat.php?s=<?=$s?>'", 5000 );
</script>
</html>
Men skal jeg være helt ærlig forstår jeg ikke så meget af den...
min nuværende opdatering:
Mysql
CREATE TABLE chatbeskeder (
id bigint(11) NOT NULL auto_increment,
fra varchar(50) NOT NULL default '',
til varchar(50) NOT NULL default '',
besked mediumtext NOT NULL,
rum tinyint(4) NOT NULL default '0',
smil varchar(25) NOT NULL default 'tomt',
PRIMARY KEY (id)
) TYPE=MyISAM;
og kode som så er sat sammen med en session_start(); og en setTimeout("self.location.reload(true)",3500);
Hele:
<?php
include("config.php");
mysql_connect($host,$user,$pass);
mysql_select_db($db);
$hent_dem = mysql_query("SELECT * FROM chatusers WHERE navn = '$s_navn'");
while ($rowz = mysql_fetch_array ($hent_dem)) {
$rum123 = "$rowz[online_rum]";
$hent = mysql_query ("SELECT * FROM chatbeskeder WHERE rum='$rum123' AND (til='alle' OR til='$s_navn' OR fra='$s_navn') ORDER BY id DESC LIMIT 0,17");
while ($row = mysql_fetch_array ($hent)) {
if ($row[fra] == "<font color=\"#0099FF\">Chatten</font>") {
echo "<font color=\"$color\" face=\"Verdana\" size=\"2\"><img src=\"gfx/smil/$row[smil].gif\"><b>$row[fra]</b> $row[besked]</font><br>";
}
elseif ($row[til] == "alle") {
$color = "#000000";
echo "<font color=\"$color\" face=\"Verdana\" size=\"2\"><img src=\"gfx/smil/$row[smil].gif\"><b><a href=\"menu.php?link=showinfo&&navn=$row[fra]\" target=\"menu\">$row[fra]</a>:</b> $row[besked]</font><br>";
}
elseif($row[til] == "$s_navn") {
$color = "#ff0000";
echo"<font color=\"$color\" face=\"Verdana\" size=\"2\"><b>Privat fra $row[fra]:</b> $row[besked]</font><br>";
}
elseif($row[fra] == "$s_navn") {
$color = "#ff0000";
echo "<font color=\"$color\" face=\"Verdana\" size=\"2\"><b>Privat til $row[til]:</b> $row[besked]</font><br>";
}
}
}
?>
kan man ombygge det mindst 'smertefrit' ?