';
include("gb_entry_tpl.php");
}else{
$query = 'select count(*) as count from chat_gb where user = "'.mysql_real_escape_string($user).'" and nick = "'.$_SESSION['nick'].'" and unix_timestamp(date) > (unix_timestamp(now()) - (60*60)) ';
$count = mysql_result(mysql_query($query,$db_handle),0,'count');
if(!$count){
$text = substr($text,0,10000);
$text=preg_replace("(\n|\n\015|\015\n)"," ",strmaxwordlen(htmlentities(stripslashes($text),ENT_QUOTES, 'ISO-8859-1'),50));
include ('filter_inc.php');
$text = filter($text,false,false,10);
$update = mysql_query("INSERT INTO chat_gb (USER,NICK,DATE,COMMENT)VALUES('$user','$nick',CURRENT_TIMESTAMP(),'".$text."')",$db_handle);
echo ' '.$_SESSION['nick'].' - Dein Eintrag wurde im Gästebuch gespeichert...
';
$sql = "select count(*) as c from chat_gb where User = '".mysql_real_escape_string($_SESSION['nick'], $db_handle)."' and nick = 'Pausenaufsicht' and date > now() - interval 4 week";
$lock = mysql_result(mysql_query($sql, $db_handle),0,'c');
if(strtolower($user) == 'pausenaufsicht' AND $nick and 1 > $lock){
$zufallstext = array('Ich freu mich immer, wenn jemand an mich denkt.',
'Du bist ein toller Chatter.',
'Ich hoffe, du magst mich ...',
'Wollen wir Freunde sein?',
'Jetzt hab ich direkt gute Laune.',
'Der Schulhofchat ist toll, oder?',
'Endlich redet mal jemand mit mir.',
'Ich hoffe du freust dich über meinen Eintrag.');
$zufallstextindex = array_rand($zufallstext);
$text = "Danke für Deinen Eintrag in mein Gästebuch! ".$zufallstext[$zufallstextindex].'
Deine Pausenaufsicht ';
mysql_query("INSERT INTO chat_gb (USER,NICK,DATE,COMMENT)VALUES('$nick','Pausenaufsicht',CURRENT_TIMESTAMP(),'".$text."')",$db_handle);
}
}else{
echo "Du hast diesem Chatter in dieser Stunde schon einen Eintrag gemacht. Eintrag wird nicht ins Gästebuch eingetragen.";
}
echo '';
}
break;
default:
$count = mysql_query("SELECT count(*) as count FROM chat_gb WHERE USER = '".mysql_real_escape_string($user)."'",$db_handle);
$msg_count = mysql_result($count,0,'count');
$limit = 10;
if(isset($nav)){
switch ($nav) {
case 'first':
$msg_start = 1;
break;
case 'prev':
if ($msg_start - $limit > 1) { $msg_start = $msg_start - $limit; }
break;
case 'next':
$msg_start = $msg_start + $limit +1;
if ($msg_start > $msg_count) { $msg_start = 1; }
break;
case 'last':
$msg_start = $msg_count - $limit +1;
if ($msg_start < 0) {$msg_start=1; }
break;
}
}
// number of pages
$num_pages = ceil($msg_count / $limit);
if ( ! isset ($page)) { $page = 1; }
if ($page > $num_pages) { $page=1; }
$msg_start = $page * $limit - $limit +1 ;
// set start-message if not set
if ( ! isset ($msg_start)) { $msg_start = 1; }
// set stop-message
$msg_stop = $msg_start + $limit -1 ;
// if $msg_start is invalid set it to 1
if ($msg_start > $msg_count OR $msg_start < 0) { $msg_start = 1; }
// if $msg_start is invalid set it to 1
if ($msg_stop > $msg_count) { $msg_stop = $msg_count; }
// set start-message for the database
$sql_start = $msg_start -1;
// select a number of messages in range of $msg_start to $msg_stop
//delete if it was wished
if($delete AND $_SESSION['nick'])
{
$result = mysql_query("delete from chat_gb where ID = '$delete' && USER = '".$_SESSION['nick']."'",$db_handle);
}
$result = mysql_query("SELECT DATE, NICK, COMMENT, ID, unix_timestamp(date) as unix_date FROM chat_gb WHERE USER = '".mysql_real_escape_string($user)."' ORDER BY ID DESC LIMIT $sql_start, $limit",$db_handle);
echo '';
echo '
';
echo ''.$data['NICK'].' schrieb am ';
echo $showdate.' ';
echo $data['COMMENT'];
if(strtolower($user) == strtolower($_SESSION['nick'])){ // it is tha page from user self
echo ' löschen';
}
echo '
';
}
}
mysql_close($db_handle);
?>
Diese Seite wurde von einem Chatter erstellt und gibt nur die Meinung des Chatters wieder, nicht die des Schulhofchats. Entspricht diese Userpage nicht unseren Regeln oder den Gesetzen, wende Dich bitte an
- Stammtischplatz: 
';
}
if($no_user){
echo "Diesen Namen kenn ich nicht";
exit;
}
?>
';
mysql_query("INSERT INTO chat_gb (USER,NICK,DATE,COMMENT)VALUES('$nick','Pausenaufsicht',CURRENT_TIMESTAMP(),'".$text."')",$db_handle);
}
}else{
echo "Du hast diesem Chatter in dieser Stunde schon einen Eintrag gemacht. Eintrag wird nicht ins Gästebuch eingetragen.";
}
echo '';
}
break;
default:
$count = mysql_query("SELECT count(*) as count FROM chat_gb WHERE USER = '".mysql_real_escape_string($user)."'",$db_handle);
$msg_count = mysql_result($count,0,'count');
$limit = 10;
if(isset($nav)){
switch ($nav) {
case 'first':
$msg_start = 1;
break;
case 'prev':
if ($msg_start - $limit > 1) { $msg_start = $msg_start - $limit; }
break;
case 'next':
$msg_start = $msg_start + $limit +1;
if ($msg_start > $msg_count) { $msg_start = 1; }
break;
case 'last':
$msg_start = $msg_count - $limit +1;
if ($msg_start < 0) {$msg_start=1; }
break;
}
}
// number of pages
$num_pages = ceil($msg_count / $limit);
if ( ! isset ($page)) { $page = 1; }
if ($page > $num_pages) { $page=1; }
$msg_start = $page * $limit - $limit +1 ;
// set start-message if not set
if ( ! isset ($msg_start)) { $msg_start = 1; }
// set stop-message
$msg_stop = $msg_start + $limit -1 ;
// if $msg_start is invalid set it to 1
if ($msg_start > $msg_count OR $msg_start < 0) { $msg_start = 1; }
// if $msg_start is invalid set it to 1
if ($msg_stop > $msg_count) { $msg_stop = $msg_count; }
// set start-message for the database
$sql_start = $msg_start -1;
// select a number of messages in range of $msg_start to $msg_stop
//delete if it was wished
if($delete AND $_SESSION['nick'])
{
$result = mysql_query("delete from chat_gb where ID = '$delete' && USER = '".$_SESSION['nick']."'",$db_handle);
}
$result = mysql_query("SELECT DATE, NICK, COMMENT, ID, unix_timestamp(date) as unix_date FROM chat_gb WHERE USER = '".mysql_real_escape_string($user)."' ORDER BY ID DESC LIMIT $sql_start, $limit",$db_handle);
echo '';
echo '