Hallo und guten morgen allerseits ..
ich habe ein kleines problem bei einer shoutbox die ich hier auf Tutorials gefunden habe.
Undzwar würde ich gerne wissen, wie ich die Einträge innerhalb der Datenbank löschen kann.
Wer kann mir kurz weiterhelfen ?
Hier der Code
ich habe ein kleines problem bei einer shoutbox die ich hier auf Tutorials gefunden habe.
Undzwar würde ich gerne wissen, wie ich die Einträge innerhalb der Datenbank löschen kann.
Wer kann mir kurz weiterhelfen ?
Hier der Code
PHP:
<?php
ob_start(); //für den Keks
?>
<html>
<head> <link href=hp.css type=text/css rel=stylesheet>
<?
$host = "localhost";
$user = "xxx";
$pass = "xxx";
$db = "xxx";
$smilies_ort = "images/";
//Smileys kann mann hinzufügen zb. ":das-zeichen-für-die-darstellung:","das-bildgif",
$smilies_ubb_array = array(
":grr:","angryfire.gif",
":prost:","beer.gif",
":confused:","confused.gif",
":cool:","cool.gif",
":dj:","dj.gif",
":mhh:","duarmer.gif",
":crazy:","durchgedreht.gif",
":king:","king.gif",
":kippe:","kippe.gif",
":hehe:","lach.gif",
":lol:","lol.gif",
":mad:","mad.gif",
":talk:","talk.gif",
";)","zwinker.gif",
);
function format_message($post) {
global $smilies_ubb_array, $smilies_ort;
$post= addslashes($post);
$post= stripslashes($post);
$post= htmlspecialchars($post);
$post= trim($post);
//Smileys:
//str_replace("altes-zeichen","neues-zeichen","zeichenkette");
$smilie_rep_count = 0;
while($smilies_ubb_array[$smilie_rep_count]!="")
{
$smilie_rep_count2 = $smilie_rep_count + 1;
$post = str_replace("$smilies_ubb_array[$smilie_rep_count]","<image src=\"$smilies_ort/$smilies_ubb_array[$smilie_rep_count2]\">",$post);
$smilie_rep_count+=2;
}
// URLS in HRC umwandeln:
$post=eregi_replace("([ \r\n])[ url]http://[ /url]([^ ,\r\n]*)","\\1http://\\2",$post);
$post=eregi_replace("([ \r\n])[ url]https://[ /url]([^ ,\r\n]*)","\\1https://\\2",$post);
$post=eregi_replace("([ \r\n])[ url]ftp://[ /url]([^ ,\r\n]*)","\\1ftp://\\2",$post);
$post=eregi_replace("([ \r\n])www\\.([^ ,\r\n]*)","\\1http://www.\\2",$post);
$post=eregi_replace("^[ url]http://[ /url]([^ ,\r\n]*)","http://\\1",$post);
$post=eregi_replace("^[ url]https://[ /url]([^ ,\r\n]*)","https://\\1",$post);
$post=eregi_replace("^[ url]ftp://[ /url]([^ ,\r\n]*)","ftp://\\1",$post);
$post=eregi_replace("^www\\.([^ ,\r\n]*)","http://www.\\1",$post);
// ######### HRC Codes:
$post = str_replace("[hr]","<hr>",$post);
$post=preg_replace("/\[b\](.*)\[\/b\]/iUms","<b>\\1</b>",$post);
$post=preg_replace("/\[i\](.*)\[\/i\]/iUms","<i>\\1</i>",$post);
$post=preg_replace("/\[s\](.*)\[\/s\]/iUms","<strike>\\1</strike>",$post);
$post=preg_replace("/\[u \](.*)\[\/u\]/iUms","<u>\\1</u>",$post);
//email link
$post=preg_replace("/\[e mail\](.*)\[\/email\]/msiU", "<a href=\"mailto:\\1\">\\1</a>", $post);
// [url]
$post=preg_replace("/\[url\]www.(.*)\[\/url\]/iUms","<a href=\"http://www.\\1\" target=_blank>[ url]http://www.\\1[ /url]</a>",$post);
$post=preg_replace("/\[url\](.*)\[\/url\]/iUms","<a href=\"\\1\" target=_blank>\\1</a>",$post);
// [url]
$post=preg_replace("/\[ url](.*)\](.*)\[\/url\]/iUms","<a href=\"\\1\" target=_blank>\\2</a>",$post);
//code ausrichtung
$post=preg_replace("/\[code\](.*)\[\/code\]/msiU", "<blockquote><pre><smallfont>code:<hr>\\1<hr></blockquote></pre></smallfont>", $post);
//quote ausrichtung
$post=preg_replace("/\[q uote\](.*)\[\/quote\]/msiU", "<blockquote><smallfont>quote:<hr>\\1<hr></blockquote></smallfont>", $post);
//pic anzeigen
$post=preg_replace("/\[i mg\](.*)\[\/img\]/iUms","<center><img src=\"\\1\" alt=\"bild\"></center>",$post);
// Farbiger Text
$post=preg_replace("/\[green\](.*)\[\/green\]/iUms","<span style=\"color:green\">\\1</span>",$post);
$post=preg_replace("/\[red\](.*)\[\/red\]/iUms","<span style=\"color:red\">\\1</span>",$post);
$post=preg_replace("/\[blue\](.*)\[\/blue\]/iUms","<span style=\"color:blue\">\\1</span>",$post);
$post=preg_replace("/\[white\](.*)\[\/white\]/iUms","<span style=\"color:white\">\\1</span>",$post);
// sub, sup
$post=preg_replace("/\[sub\](.*)\[\/sub\]/iUms","<sub>\\1</sub>",$post);
$post=preg_replace("/\[sup\](.*)\[\/sup\]/iUms","<sup>\\1</sup>",$post);
// ########## Ende HRC Codes
$post= nl2br($post);
return $post;
}
function format_title($post) {
$post= addslashes($post);
$post= stripslashes($post);
$post= htmlspecialchars($post);
return $post;
}
$link = mysql_connect($host, $user, $pass);
mysql_select_db($db, $link);
if($txtMessage!="" && $txtNickname!=""){
$txtMessage=format_message($txtMessage);
$txtNickname=format_title($txtNickname);
mysql_query("INSERT INTO shoutbox (time, nick, txt) VALUES('".time()."', '$txtNickname', '$txtMessage')");
}
$ausgabe = mysql_query("SELECT * FROM shoutbox ORDER BY time DESC LIMIT 5");
?>
<html>
<head>
<title>$title</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FF9900" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" scroll="auto" link="#000000" vlink="#000000" alink="#000000">
<table cellPadding="0" width="118" border="0" cellSpacing="0" height="75%">
<tr>
<td valign="top" align="left"><b>buch</b></td>
</tr>
<tr vAlign="top">
<td colSpan="3" valign="top" align="center">
<table cellSpacing="0" cellPadding="0" width="100%" border="0" valign="top" height="247">
<tr>
<td><br>
<form name="frmMsgBox" method="POST" action="<?=$PHP_SELF?>">
<input type="text" name="txtNickname" maxlength="16" value="<?=$txtNickname?>" size="10">
<br>
<input type="text" name="txtMessage" size="10" value="">
<!---<input type="text" name="txtMessage" maxlength="100" size="50">-->
<br>
<input type="submit" name="senden" value="send">
<font face="Arial, Helvetica, sans-serif"><a href="javascript:opentip()"><font face="Verdana, Arial, Helvetica, sans-serif" size="1">smiles</font></a></font>
</form>
</td>
</tr>
<tr>
<td valign="top" align="top" height="111">
<?
while($print = mysql_fetch_array($ausgabe)){
?>
<table width="100%" border="0" cellspacing="1" cellpadding="1">
<tr>
<td><i><?=$print[nick]?></i><br>schrieb am
<b><? print date("d/m/Y", $print[time]); ?>::</b> | <? print date("H:i:s", $print[time]); ?> |<br>
<span style="word-break:break-all;word-wrap:break-word">
<?=$print[txt]?></span><br>
</td>
</tr>
</table>
<br>
<?
}
?>
<br>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
<?
mysql_close($link);
?>