hm je, the alias of the moment when it was said is important.
sure a link to the alias list of that player id could make it perfect then...
playernames get changed afterwards in clients table, if u reconnect with another username and same ip.
i found that out yesterday...
btw, i have the script now with fancy date, a player helped me out after i tryed for hours to change some in the query wit unix date...
here it is:
<?php
//wursti shitty klickery
//enter tekst:
$dbhost='host';
$dbusername='user';
$dbuserpass='pw';
$dbname='dbname';
$header='this is the realtime playerchat table';
//connectomatrix.
$db = mysql_connect ($dbhost, $dbusername, $dbuserpass) or die(mysql_error());
//selectomatrix.
mysql_select_db($dbname, $db) or die('Cannot select database');
$query = 'SELECT ch.`msg_time`, ch.`msg_type`, c.`name`, ch.`msg` FROM `chatlog` as ch INNER JOIN `clients` as c ON ch.`client_id` = c.`id` ORDER BY `msg_time` DESC LIMIT 0, 500';
$result = mysql_query($query, $db);
if (mysql_errno($db) == 0)
echo "$header <br><br>";
else
echo mysql_error();
//Call table
?><table><tr><?
if(! $result) { ?><th>result not valid</th><? }
else {
$i = 0;
while ($i < mysql_num_fields($result)) {
$meta = mysql_fetch_field($result, $i);
?><th style="white-space:nowrap"><?=$meta->name?></th><?
$i++;
}
?></tr><?
if(mysql_num_rows($result) == 0) {
?><tr><td colspan="<?=mysql_num_fields($result)?>">
<strong><center>no result</center></strong>
</td></tr><?
} else
// while($row=mysql_fetch_assoc($result)) {
// ?><tr style="white-space:nowrap"><?
// foreach($row as $key=>$value) { ?><td><?=$value?></td><? }
// ?></tr><?
//// }
// }
while($row = mysql_fetch_assoc($result)) {
?><tr style="white-space:nowrap"><?
foreach($row as $key => $value) {
if('msg_time' == $key) {
$value = date("d.m.Y H:i:s", $value);
}
echo "\t<td>$value</td> ";
}
}
?></table><?
?>
i hope i become faster soon, im expirienced network admin but i never wrote my own php...
what to say? lol wurst n00b.
im planning to bring a link on every chat event that query content around this chat line, so theres possibility to say:
"he admin, heres link to the conversation i mean"
oki gg
