alebo by mi stacilo ak by sa tento skript dal upravit aby
zobrazovalo stale iba 15 prispevkov a posledne mazalo.........
ten shoutboard vyzera v originale takto....
http://www.testwebu.wz.cz/retro/base
potrebujem aby toto fungovalo ako shoutboard od BLUEBOARDU....
cele je to len tento jeden script.....
dik za pomoc
<?php
$db_host = "";
$db_user = "";
$db_password = "";
$db_name = "";
if($_POST['submit']) {
if(!$_POST['author']) {
echo 'Chyba! Nevložili ste meno!';
die;
}
if(!$_POST['email']) {
echo 'Chyba! Nevložili ste email!';
die;
}
if(!$_POST['message']) {
echo 'Chyba! Nevložili ste správu!';
die;
}
$message = strip_tags($_POST['message'], '');
$email = strip_tags($_POST['email'], '');
$author = strip_tags($_POST['author'], '');
$message_length = strlen($message);
$author_length = strlen($author);
if($message_length > 150) {
echo "Chyba! Vašs správa nesmie byt dlhšia ako 150
znakov!";
die;
}
if($author_length > 150) {
echo " Chyba! Vaše meno nesmie byt dlhšie ako 150
znakov!";
die;
}
mysql_connect($db_host,$db_user,$db_password) or
die(mysql_error());
mysql_select_db($db_name) or die(mysql_error());
$date = date("h:i");
$query = "INSERT INTO shoutbox (message, author, email, date,
ip) VALUES
('$message','$author','$email','$date','$_SERVER[REMOTE_ADD
R]')";
mysql_query($query);
mysql_close();
echo "Vaše zpráva byla pøidána!<br>";
echo "<a href=\"../base/index.php\">Návrat na hlavnú
stránku</a>";
} else {
mysql_connect($db_host,$db_user,$db_password) or
die(mysql_error());
mysql_select_db($db_name) or die(mysql_error());
$query = "SELECT message, author, email, date FROM shoutbox
order by id DESC LIMIT 10";
$result = mysql_query($query);
echo "<table>";
while($r=mysql_fetch_array($result))
{
echo "<tr>
<td><h4>Vložené:$r[date] <br /> Autor: <a
href=\"mailto:$r\">$r[author]</a></h4></td>
<td><br /><br />$r[message]<hr /></td>
</tr>";
}
echo "</table>";
?>
<?php
}
?>