Über Hilfe wäre ich sehr dankbar.
Vielen Dank schonmal im Voraus
Hier die PHP.
- Code: Alles auswählen
<?
include("config.inc.php");
$result = mysql_query("SELECT * FROM $table2 where gbookid='".$_GET['id']."'");
if (mysql_num_rows($result)) {
while($row=mysql_fetch_array($result)) {
$bgcolor = $row['bgcolor'];
$sitetitel = $row['sitetitel'];
$titel = $row['titel'];
$border = $row['border'];
$bordercolor = $row['bordercolor'];
$tablebg = $row['tablebg'];
$font_color = $row['fontcolor'];
$hover = $row['hover'];
$link = $row['link'];
$background = $row['background'];
?>
<html>
<head>
<script>
function check() {
if (document.form1.text.value.indexOf('<',0)!=-1 || document.form1.text.value.indexOf('>',0)!=-1) {
alert( "Bitte kein Html benutzen!" );
document.form1.text.focus();
return false;
}
}
</script>
<script>
function smilie(name) {
document.form1.text.focus();
document.form1.text.value = document.form1.text.value + name;
document.form1.text.focus();
}
</script>
<title><? echo"$sitetitel"; ?></title>
<style>
a:link {
color: <? echo"$link"; ?>;
text-decoration: none;
}
a:visited {
color: <? echo"$link"; ?>;
text-decoration: none;
}
a:hover {
color: <? echo"$hover"; ?>;
text-decoration: underline;
}
body,table,p {
font-family: Tahoma;
font-size: 8pt;
color: <? echo"$font_color"; ?>;
font-weight: normal;
}
</style>
<link rel="stylesheet" type="text/css" href="style_gb.css">
</head>
<body bgcolor="<? echo"$bgcolor"; ?>" text="<? echo"$font_color"; ?>" background="<? echo"$background"; ?>">
<div align="center">
<b><font size="-1"><font color=<? echo"$font_color"; ?>><? echo"$titel"; ?></font></b><br>
<br>
<?
if($HTTP_GET_VARS['do'] == "add")
{
?>
<table width=500 cellspacing="0" cellpadding="3" style="border-color:<? echo"$bordercolor"; ?>; border-width:1px; border-style:<? echo"$border"; ?>;">
<tr>
<td width=500 bgcolor="<? echo"$tablebg"; ?>">
<div align="center"><?
if(strlen($_POST['name']) == 0 || strlen($_POST['text']) == 0)
echo"<b><font size=-1><font color=$font_color>Du hast nicht alle Felder ausgefüllt!</font></b>";
else {
$id = $_GET['id'];
echo"<meta http-equiv=\"refresh\" content=\"2; URL=gbook.php?id=$id\"><b><font size=-1><font color=$font_color>Vielen Dank für Deinen Eintrag!</font></b>";
mysql_query("insert into $table1 (gbookid, timestamp, name, email, web, ort, text) values ('".$_GET['id']."', '".time()."', '".$_POST['name']."', '".$_POST['email']."', '".$_POST['web']."', '".$_POST['ort']."', '".$_POST['text']."')");
}
?></div>
</td></tr>
</table><br>
<?
}
?>
<table width=500 cellspacing="0" cellpadding="3" style="border-color:<? echo"$bordercolor"; ?>; border-width:1px; border-style:<? echo"$border"; ?>;">
<tr>
<td width=500 bgcolor="<? echo"$tablebg"; ?>"><form action="gbook.php?do=add&id=<? $id = $_GET['id']; echo"$id"; ?>" method="POST" name=form1 onSubmit="return check()"><table>
<tr>
<td><b><font color="<? echo"$font_color"; ?>">Name:</font></b> </td>
<td><input type="Text" name="name" value="" size="" maxlength=""> </td>
</tr>
<tr>
<td><b><font color="<? echo"$font_color"; ?>">E-Mailadresse:</font></b> </td>
<td><input type="Text" name="email" value="" size="" maxlength=""> </td>
</tr>
<tr>
<td><b><font color="<? echo"$font_color"; ?>">Homepage:</font></b> </td>
<td><input type="Text" name="web" value="http://" size="" maxlength=""> </td>
</tr>
<tr>
<td><b><font color="<? echo"$font_color"; ?>">Herkunft:</font></b> </td>
<td><input type="Text" name="ort" value="" size="" maxlength=""> </td>
</tr>
<tr>
<td><b><font color="<? echo"$font_color"; ?>">Sicherheitscode:</font></b> </td>
<td><img src="captcha/captcha.php" border="0" title="Sicherheitscode"> <b><input type="text" name="sicherheitscode" size="5"></b> </td>
</tr>
<tr>
<td valign=top><b><font color="<? echo"$font_color"; ?>">Nachricht:</font></b> </td>
<td><textarea name="text" cols="28" rows="5"></textarea> </td>
</tr>
<tr>
<td><b><font color="<? echo"$font_color"; ?>">Smilies:</font></b> </td>
<td><a href="#" onClick="javascript:smilie(' :(')"><img src="img/1.gif" border="0"></a>
<a href="#" onClick="javascript:smilie(' 8)')"><img src="img/2.gif" border="0"></a>
<a href="#" onClick="javascript:smilie(' :D')"><img src="img/3.gif" border="0"></a>
<a href="#" onClick="javascript:smilie(' :)')"><img src="img/4.gif" border="0"></a>
<a href="#" onClick="javascript:smilie(' 8o')"><img src="img/5.gif" border="0"></a>
<a href="#" onClick="javascript:smilie(' ;)')"><img src="img/6.gif" border="0"></a> </td>
</tr>
<tr>
<td> </td>
<td><input type="Submit" name="" value="Eintragen"> </td>
</tr>
</table></form> </td>
</tr>
</table>
<br>
<?
$id = $_GET['id'];
$Zeilen_pro_Seite = 10;
if (!isset($_GET['position'])) {
$position = 0;
}
else {
$position = $_GET['position'];
}
$sql="SELECT * FROM $table1 where gbookid='".$_GET['id']."' order by id DESC ".
"limit $position,$Zeilen_pro_Seite";
$result=mysql_query($sql);
$result1=mysql_query("SELECT gbookid FROM $table1 where gbookid='".$_GET['id']."' order by id DESC ");
$Anzahl=mysql_num_rows($result1);
while ($row=mysql_fetch_array($result)) {
$datum = $row['timestamp'];
$name = $row['name'];
$email = $row['email'];
$web = $row['web'];
$ort = $row['ort'];
$text = $row['text'];
$comment = $row['comment'];
$datum2 = date("d.m.Y H:i",$datum);
if(strlen($email) > 0)
$setemail="<a href=mailto:$email><img src=\"img/email.gif\" alt=\"Email schreiben\" border=\"0\"></a>";
else {
$setemail="";
}
if(strlen($web) < 8)
$setweb="";
else {
$setweb="<a href=$web target=_new><img src=\"img/home.gif\" alt=\"Homepage besuchen\" border=\"0\"></a>";
}
str_replace("altes-zeichen","neues-zeichen","zeichenkette");
$text = str_replace(":(", "<img src=img/1.gif border=0>", $text);
$text = str_replace("8)", "<img src=img/2.gif border=0>", $text);
$text = str_replace(":D", "<img src=img/3.gif border=0>", $text);
$text = str_replace(":)", "<img src=img/4.gif border=0>", $text);
$text = str_replace("8o", "<img src=img/5.gif border=0>", $text);
$text = str_replace(";)", "<img src=img/6.gif border=0>", $text);
$text = nl2br($text);
$comment = nl2br($comment);
echo"<table width=500 cellspacing=0 cellpadding=3 style=\"border-color:$bordercolor; border-width:1px; border-style:$border;\">
<tr>
<td width=470 bgcolor=$tablebg>
<table>
<tr>
<td width=110><b><font size=-1><font color=$font_color>$name</font></b> </td>
<td width=360> <b><font color=$font_color>Datum:</b> <font color=$font_color>$datum2</font></td>
</tr>
<tr>
<td valign=top>
$setemail $setweb<br>
<br>
<b><font color=$font_color>Herkunft:</b> <br>
$ort
</td>
<td valign=top><font size=-1><font color=$font_color>$text ";
if(strlen($comment) > 0)
{
echo"<br>
<br>
<font size=-2><b>Kommentar:</b><br>
$comment</font>";
}
echo"
</font></font></td>
</tr>
</table>
</td>
</tr>
</table><br>";
}
echo"<div align=\"center\">";
if($Anzahl>$Zeilen_pro_Seite) {
$Seiten=intval($Anzahl/$Zeilen_pro_Seite);
if($Anzahl%$Zeilen_pro_Seite) {
$Seiten++;
}
}
for ($i=1;$i<=$Seiten;$i++) {
$fwd=($i-1)*$Zeilen_pro_Seite;
echo "<a href=\"gbook.php?id=$id&position=$fwd\"><b>[$i]</b></a> ";
}
?>
<br>
<br>
<table width=500 cellspacing=0 cellpadding=3 style="border-color:<? echo"$bordercolor"; ?>; border-width:1px; border-style:<? echo"$border"; ?>;">
<tr>
<td width=500 bgcolor=<? echo"$tablebg"; ?>><font color="<? echo"$font_color"; ?>"><b><div align=center></div></b></td>
</tr>
</table>
<table width=500>
<tr>
<td><div align="center"><font color="<? echo"$font_color"; ?>"><b><a href="http://www.gb-host.dl.am" target="_blank">Kostenlose Gästebücher von gb-host.dl.am</b><br>
Registrieren Sie sich noch heute Ihr eigenes Gästebuch!</a> </div> </td>
</tr>
</table>
</div>
</body>
</html>
<?
} }
else { header("Location: index_.php?seite=anmeldung"); } ?>
