früher';
if($_GET['start'] >= 100){
$zurueck = 'später';
}
if(!$_GET['start'])
{
$_GET['start'] = 0;
}
$start = $_GET['start'];
$chatter = str_replace('%','',urldecode($_GET['chatter']));
/*$query = "(select id, from_chatter, line, date_format(time_stamp, '%e.%c.') as time_stamp
from chat_lines_save
where from_chatter like '".$chatter."' AND to_chatter = '".$_SESSION['nick']."' order by id desc limit 0, ".($start + 100).")
UNION ALL
(select id, from_chatter, line, date_format(time_stamp, '%e.%c.') as time_stamp
from chat_lines_save
where to_chatter like '".$chatter."' AND from_chatter = '".$_SESSION['nick']."' order by id desc limit 0, ".($start + 100).")
order by id desc limit $start, 100 ";*/
$query = "(select id
from chat_lines
where
(from_chatter = '".$chatter."' AND to_chatter = '".$_SESSION['nick']."')
OR
(from_chatter = '".$_SESSION['nick']."' AND to_chatter = '".$chatter."') order by id desc LIMIT 0, ".($start+100)." )
UNION ALL
(select id
from chat_lines_save
where
(from_chatter = '".$chatter."' AND to_chatter = '".$_SESSION['nick']."')
OR
(from_chatter = '".$_SESSION['nick']."' AND to_chatter = '".$chatter."') order by id desc LIMIT 0, ".($start+100)."
) order by id desc limit $start, 100";
$result = mysql_query($query,$db_handle);
if(mysql_num_rows($result) < 99){
$vor = '';
}
$ids = array();
while($row = mysql_fetch_assoc($result)){
$ids[] = $row['id'];
}
if(count($ids)>0){
$query = "(select id, from_chatter, line, date_format(time_stamp, '%e.%c.') as time_stamp
from chat_lines
where id IN(".implode(', ',$ids)."))
UNION ALL
(select id, from_chatter, line, date_format(time_stamp, '%e.%c.') as time_stamp
from chat_lines_save where id IN(".implode(', ',$ids).")) order by id desc";
$result = mysql_query($query,$db_handle);
}
?>
Protokoll f�r <?echo strip_tags($_GET['chatter']); ?>
0){
while($a = mysql_fetch_array($result))
{
echo ''.$a['time_stamp'].' '.$a['from_chatter'].' '.$a['line'].'
';
}
}else{
echo 'Für diesen Chatter sind keine bisherigen Gespräche gespeichert
';
}
?>