| 1 |
lars |
1 |
<?
|
|
|
2 |
require_once "connect.php";
|
|
|
3 |
global $site;
|
|
|
4 |
|
|
|
5 |
// Daten in die Datenbank schreiben!
|
|
|
6 |
|
|
|
7 |
if ( $name == "" or $mail == "" or $headline == "" or $text == "" or $staat ==
|
|
|
8 |
"" or $bundesland == "" )
|
|
|
9 |
{
|
|
|
10 |
?>
|
|
|
11 |
Sie haben nicht alle Pflichtfelder ausgefüllt!<p>
|
|
|
12 |
<?
|
|
|
13 |
}
|
|
|
14 |
else
|
|
|
15 |
{
|
|
|
16 |
$text = nl2br( $text );
|
|
|
17 |
$anfrage =
|
|
|
18 |
"Insert into Gaestebuch (id, zeit, name, mail, headline, text, GID, Staat, Bundesland, homepage)
|
|
|
19 |
values ('', now(), '$name', '$mail', '$headline', '$text', '$site', '$staat', '$bundesland', '$homepage')";
|
|
|
20 |
mysql_query( $anfrage );
|
|
|
21 |
|
|
|
22 |
$query = "select * from Gaestebuch_design where GID='$site'";
|
|
|
23 |
$result = mysql_query( $query );
|
|
|
24 |
$row = mysql_fetch_array( $result );
|
|
|
25 |
$bgcolor = $row[bgcolor];
|
|
|
26 |
$background = $row[background];
|
|
|
27 |
$face = $row[textart];
|
|
|
28 |
$fcolor = $row[textcolor];
|
|
|
29 |
$fsize = $row[textgroesse];
|
|
|
30 |
$zeige = $row[max_Eintraege];
|
|
|
31 |
$trennlinie = $row[trennbild];
|
|
|
32 |
|
|
|
33 |
if ( $trennlinie == "" )
|
|
|
34 |
{
|
|
|
35 |
$trennlinie = "<hr color=$fcolor>";
|
|
|
36 |
}
|
|
|
37 |
else
|
|
|
38 |
{
|
|
|
39 |
$trennlinie = "<br><img src=$trennlinie border=0><br>";
|
|
|
40 |
}
|
|
|
41 |
|
|
|
42 |
|
|
|
43 |
$filename = "vorlagen/gb-hauptseite.htm";
|
|
|
44 |
require_once "capture_file.php";
|
|
|
45 |
$teil1 = $source;
|
|
|
46 |
$anfrage = "select * from Gaestebuch where GID='$site' order by id desc";
|
|
|
47 |
$result = mysql_query( $anfrage );
|
|
|
48 |
$nummer = mysql_numrows( $result );
|
|
|
49 |
$i = 0;
|
|
|
50 |
$fp = fopen( "ansehen.html", "w+" );
|
|
|
51 |
fwrite( $fp, $teil1 );
|
|
|
52 |
fclose( $fp );
|
|
|
53 |
while ( $i < $nummer )
|
|
|
54 |
{
|
|
|
55 |
$row = mysql_fetch_array( $result );
|
|
|
56 |
$autor = $row[Name];
|
|
|
57 |
$stadt = $row[Bundesland];
|
|
|
58 |
$betreff = $row[headline];
|
|
|
59 |
$homepage = $row[homepage];
|
|
|
60 |
if ( $homepage == "" )
|
|
|
61 |
{
|
|
|
62 |
$homepage = "";
|
|
|
63 |
}
|
|
|
64 |
else
|
|
|
65 |
{
|
|
|
66 |
$homepage = "<a href=\"$homepage\">Homepage</a> | ";
|
|
|
67 |
}
|
|
|
68 |
$bund = $row[Staat];
|
|
|
69 |
$email = $row[mail];
|
|
|
70 |
$text = $row[text];
|
|
|
71 |
$row[Zeit] = preg_split( "/ /", $row[Zeit] );
|
|
|
72 |
$datum = join( ".", array_reverse( preg_split( "/-/", $row[Zeit][0] ) ) );
|
|
|
73 |
$zeit = $row[Zeit][1];
|
|
|
74 |
$filename = "vorlagen/gb-beitrag.htm";
|
|
|
75 |
require_once "capture_file.php";
|
|
|
76 |
$fp = fopen( "ansehen.html", "a" );
|
|
|
77 |
fwrite( $fp, $source );
|
|
|
78 |
fclose( $fp );
|
|
|
79 |
$i++;
|
|
|
80 |
}
|
|
|
81 |
$filename = "vorlagen/gb-fusszeile.htm";
|
|
|
82 |
require_once "capture_file.php";
|
|
|
83 |
$fp = fopen( "ansehen.html", "a" );
|
|
|
84 |
fwrite( $fp, $source );
|
|
|
85 |
fclose( $fp );
|
|
|
86 |
|
|
|
87 |
// Jetzt geben wie eine Nachricht aus, das der Beitrag erfolgreich eingetragen worden ist und verweisen auf
|
|
|
88 |
// die neue erstellte/modifizierte ANSEHEN.HTML
|
|
|
89 |
|
|
|
90 |
?>
|
|
|
91 |
Vielen Dank für Ihren Eintrag.<p>
|
|
|
92 |
<a href="ansehen.html">Zum Gästebuch</a>
|
|
|
93 |
<? }
|
|
|
94 |
?>
|