Subversion-Projekte lars-tiefland.content-management

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1
<?
2
	$self=basename($PHP_SELF);
3
	$DB="Gaestebuch";
4
	require_once "connect.php";
5
	if ($action=="update")
6
	{
7
		if (!$ID)
8
		{	// insert Dummy-Entry
9
			$query = "insert into $DB (ID) VALUES (0)";
10
			$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query."<hr>");
11
			$ID=mysql_insert_id();
12
		}
13
 
14
		unset($HTTP_POST_VARS[action]);
15
		unset($HTTP_POST_VARS[ID]);
16
 
17
		foreach(array_keys($HTTP_POST_VARS) as $elem)
18
		{
19
			if ($elem[0] == "_")
20
			{
21
				unset($HTTP_POST_VARS[$elem]);
22
				$button=$$elem;
23
				$elem=substr($elem,1);
24
				$Pfad=$HTTP_POST_VARS[$elem."_Pfad"];
25
				unset($HTTP_POST_VARS[$elem."_Pfad"]);
26
				$image=$$elem;
27
				$image_name=$elem."_name";
28
				$image_name=urlencode($$image_name);
29
				switch ($button)
30
				{
31
					case 0:
32
						break;
33
					case 1:
34
						$HTTP_POST_VARS[$elem]='';
35
	   					break;
36
	   				case 2:
37
						//$image_name=$ID."_".$image_name;
38
						$image_name=$ID.strrchr($image_name,".");
39
						$HTTP_POST_VARS[$elem]=$image_name;
40
						copy($image,$Pfad.$image_name);
41
				        break;
42
				    default:
43
				        break;
44
			    }
45
			}
46
		}
47
		$names=array();
48
		foreach(array_keys($HTTP_POST_VARS) as $elem)
49
		{
50
			array_push($names,"$elem='$HTTP_POST_VARS[$elem]'");
51
		}
52
		$query="update $DB set ".join($names,', ');
53
		$query=$query." where ID = '$ID'";
54
		$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
55
		header("Location: ".$self);
56
		$query = "select * from Gaestebuch_design where GID='$site'";
57
		$result = mysql_query($query);
58
		$row = mysql_fetch_array($result);
59
$bgcolor=$row[bgcolor];
60
$background=$row[background];
61
$face=$row[textart];
62
$fcolor=$row[textcolor];
63
$fsize=$row[textgroesse];
64
$zeige=$row[max_Eintraege];
65
$trennlinie=$row[trennbild];
66
 
67
if ($trennlinie == "") {
68
$trennlinie="<hr color=$fcolor>";
69
}
70
else {
71
$trennlinie="<br><img src=$trennlinie border=0><br>";
72
}
73
 
74
 
75
		$filename="vorlagen/gb-hauptseite.htm";
76
		require_once "capture_file.php";
77
		$teil1 = $source;
78
		$anfrage="select * from Gaestebuch where GID='$site' order by id desc";
79
		$result=mysql_query($anfrage);
80
		$nummer=mysql_numrows($result);
81
		$i=0;
82
		$fp = fopen ("ansehen.html","w+");
83
		fwrite ($fp, $teil1);
84
		fclose($fp);
85
		while ($i < $nummer) {
86
		$row=mysql_fetch_array($result);
87
		$autor=$row[Name];
88
		$stadt=$row[Bundesland];
89
		$homepage=$row[homepage];
90
		$betreff=$row[headline];
91
		if ($homepage=="") {
92
		$homepage="";
93
		}
94
		else {
95
		$homepage="<a href=\"$homepage\">Homepage</a> | ";
96
		}
97
		$bund=$row[Staat];
98
		$email=$row[mail];
99
		$text=$row[text];
100
		$row[Zeit]=preg_split("/ /",$row[Zeit]);
101
		$datum=join(".",array_reverse(preg_split("/-/",$row[Zeit][0])));
102
		$zeit=$row[Zeit][1];
103
		$filename="vorlagen/gb-beitrag.htm";
104
		require_once "capture_file.php";
105
		$fp= fopen ("ansehen.html","a");
106
		fwrite ($fp, $source);
107
		fclose($fp);
108
		$i++;
109
		}
110
		$filename="vorlagen/gb-fusszeile.htm";
111
		require_once "capture_file.php";
112
		$fp= fopen ("ansehen.html","a");
113
		fwrite ($fp, $source);
114
		fclose($fp);
115
	}
116
 
117
	if ($action=="delete")
118
	{
119
		if ($ID)
120
		{
121
			$condition=array();
122
			foreach ($ID as $elem)
123
			{
124
				array_push($condition," ID = '$elem'");
125
			}
126
			$cond=join(" or ",$condition);
127
			$query = "DELETE FROM $DB WHERE $cond";
128
			$result = mysql_query ("$query") or die (mysql_errno().": ".mysql_error());
129
			$query = "select * from Gaestebuch_design where GID='$site'";
130
$result = mysql_query($query);
131
$row = mysql_fetch_array($result);
132
$bgcolor=$row[bgcolor];
133
$background=$row[background];
134
$face=$row[textart];
135
$fcolor=$row[textcolor];
136
$fsize=$row[textgroesse];
137
$zeige=$row[max_Eintraege];
138
$trennlinie=$row[trennbild];
139
 
140
if ($trennlinie == "") {
141
$trennlinie="<hr color=$fcolor>";
142
}
143
else {
144
$trennlinie="<br><img src=$trennlinie border=0><br>";
145
}
146
 
147
 
148
		$filename="vorlagen/gb-hauptseite.htm";
149
		require_once "capture_file.php";
150
		$teil1 = $source;
151
		$anfrage="select * from Gaestebuch where GID='$site' order by id desc";
152
		$result=mysql_query($anfrage);
153
		$nummer=mysql_numrows($result);
154
		$i=0;
155
		$fp = fopen ("ansehen.html","w+");
156
		fwrite ($fp, $teil1);
157
		fclose($fp);
158
		while ($i < $nummer) {
159
		$row=mysql_fetch_array($result);
160
		$autor=$row[Name];
161
		$stadt=$row[Bundesland];
162
		$homepage=$row[homepage];
163
		if ($homepage=="") {
164
		$homepage="";
165
		}
166
		else {
167
		$homepage="<a href=\"$homepage\">Homepage</a> | ";
168
		}
169
		$bund=$row[Staat];
170
		$email=$row[mail];
171
		$betreff=$row[headline];
172
		$text=$row[text];
173
		$row[Zeit]=preg_split("/ /",$row[Zeit]);
174
		$datum=join(".",array_reverse(preg_split("/-/",$row[Zeit][0])));
175
		$zeit=$row[Zeit][1];
176
		$filename="vorlagen/gb-beitrag.htm";
177
		require_once "capture_file.php";
178
		$fp= fopen ("ansehen.html","a");
179
		fwrite ($fp, $source);
180
		fclose($fp);
181
		$i++;
182
		}
183
		$filename="vorlagen/gb-fusszeile.htm";
184
		require_once "capture_file.php";
185
		$fp= fopen ("ansehen.html","a");
186
		fwrite ($fp, $source);
187
		fclose($fp);
188
			header("Location: ".$self);
189
		}
190
	}
191
	if (!$action)
192
	{
193
		$action="select_edit";
194
	}
195
	if (!$sort) {$sort='Name';}
196
?>
197
 
198
<html>
199
<head>
200
<title>Gästebuch: Administration</title>
201
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
202
<link rel=stylesheet type="text/css" href="redaktion.css">
203
<!--
204
<style type="text/css" link="redaktion.css"><? //require_once "redaktion.css"; ?></style>
205
-->
206
<script language="JavaScript">
207
<!--
208
function MM_swapImgRestore() { //v3.0
209
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
210
}
211
 
212
function MM_preloadImages() { //v3.0
213
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
214
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
215
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
216
}
217
 
218
function MM_swapImage() { //v3.0
219
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
220
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
221
}
222
 
223
function MM_findObj(n, d) { //v4.01
224
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
225
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
226
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
227
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
228
  if(!x && d.getElementById) x=d.getElementById(n); return x;
229
}
230
//-->
231
</script>
232
<meta name="description" content="Redaktionssystem">
233
<meta name="author" content="Webagentur Niewerth">
234
<meta name="robots" content="noindex">
235
</head>
236
 
237
<body bgcolor="#FFFFFF" leftmargin="20" topmargin="10" marginwidth="20" marginheight="10" onLoad="MM_preloadImages('../images/redaktion/bt_neu_f2.gif','images/navigation/bt_bearbeiten_f2.gif','images/navigation/bt_delete_f2.gif')" text="#000096">
238
<form method="post" action="#" name="formname" enctype="multipart/form-data">
239
  <table width="662" border="0" cellspacing="0" cellpadding="0">
240
    <tr valign="top">
241
      <td width="585">
242
<!--  Auswahl Löschen START  -->
243
<?
244
	if ($action=="delete")
245
	{
246
		$query="SELECT * FROM $DB ";
247
		$query=$query."order by $sort";
248
		$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
249
		if (mysql_num_rows($result) == 0)
250
		{
251
?>
252
<p class="error">Es sind keine Daten eingetragen !</p>
253
<p></p>
254
<?
255
		}
256
		else
257
		{
258
?>
259
        <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
260
          <tr bgcolor="#000099">
261
            <td colspan="3" class="headline">Gästebuch: Löschen</td>
262
          </tr>
263
          <tr>
264
            <td width="50%" class="haupt"><a href="<? echo $self?>?action=select_edit&sort=Name,Vorname">Autor, Überschrift</a></td>
265
            <td class="haupt" colspan="2"><a href="<? echo $self?>?action=select_edit&sort=ID">ID</a></td>
266
          </tr>
267
          <?
268
	while ($zeile=mysql_fetch_array($result))
269
	{
270
?>
271
          <tr>
272
            <td width="50%"><a href="<? echo $self?>?action=edit&ID=<? echo $zeile[ID]; ?>">
273
              <? echo $zeile[Name]?>, <? echo $zeile[headline]?>
274
              </a></td>
275
            <td>
276
              <? echo $zeile[ID]; ?>
277
              &nbsp; </td>
278
            <td width="5%" align="center">
279
              <input type="checkbox" name="ID[]" value="<?  echo $zeile[ID] ?>">
280
            </td>
281
          </tr>
282
          <?
283
	}
284
?>
285
          <tr bgcolor="#000099">
286
            <td colspan="3" align="right">
287
              <input type="hidden" name="action" value='delete'>
288
              <input type="submit" value="LÖSCHEN">
289
              <input type="reset" name="Button22" value="Zur&uuml;cksetzen">
290
            </td>
291
          </tr>
292
        </table>
293
        <?
294
		}
295
?>
296
        <?
297
 	}
298
?>
299
        <!--  Auswahl Löschen ENDE  -->
300
        <!--  Auswahl SELECT_EDIT START  -->
301
        <?
302
 
303
  if ($action=="select_edit")
304
	{
305
	$query="SELECT * FROM $DB ";
306
	$query=$query."order by $sort";
307
 
308
	$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
309
	if (mysql_num_rows($result) == 0)
310
	{
311
	?>
312
        <p class="error">Es sind keine
313
            Daten eingetragen !</p>
314
          <p></p>
315
	<?
316
	}
317
	else
318
	{
319
	?>
320
        <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
321
          <tr bgcolor="#000099">
322
            <td class="headline" colspan="3">Gästebuch: Bearbeiten</td>
323
          </tr>
324
          <tr>
325
            <td width="50%" class="haupt"><a href="<? echo $self?>?action=select_edit&sort=name, headline">Autor, Überschrift</a></td>
326
            <td width="50%" class="haupt"><a href="<? echo $self?>?action=select_edit&sort=ID">ID</a></td>
327
          </tr>
328
          <?
329
	while ($zeile=mysql_fetch_array($result))
330
	{
331
?>
332
          <tr>
333
            <td width="50%"><a href="<? echo $self?>?action=edit&ID=<? echo $zeile[ID]; ?>">
334
              <? echo $zeile[Name]?>
335
              ,
336
              <? echo $zeile[headline]?>
337
              </a></td>
338
            <td width="50%">
339
              <? echo $zeile[ID]; ?>
340
              &nbsp; </td>
341
          </tr>
342
          <?
343
	}
344
?>
345
          <tr bgcolor="#000099">
346
            <td colspan="3">
347
              <div align="right">&nbsp;
348
                <input type="hidden" name="action" value='edit'>
349
              </div>
350
            </td>
351
          </tr>
352
        </table>
353
 <?
354
	}
355
?>
356
        <?
357
 	}
358
?>
359
<!--  Auswahl SELECT_EDIT ENDE  -->
360
 
361
<?
362
	if ($action=="edit")
363
	{
364
		if ($ID)
365
		{
366
			$result = mysql_query ("SELECT * FROM $DB where ID = '$ID'") or die (mysql_errno().": ".mysql_error());
367
			$zeile=mysql_fetch_array($result);
368
		}
369
  	$zeile[von]=join(".",array_reverse(preg_split("/-/",$zeile[von])));
370
   	$zeile[bis]=join(".",array_reverse(preg_split("/-/",$zeile[bis])));
371
   	$zeile[Abmeldedatum]=join(".",array_reverse(preg_split("/-/",$zeile[Abmeldedatum])));
372
	?>
373
	    <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
374
          <tr bgcolor="#000099">
375
            <td colspan="3" class="headline">Gästebuch:
376
              <?
377
					if ($ID)
378
					{
379
					 ?>
380
              Bearbeiten
381
              <?
382
					}
383
					else
384
					{
385
					 ?>
386
              Neueintrag
387
              <?
388
					}
389
				?>
390
            </td>
391
          </tr>
392
          <tr>
393
            <td bgcolor="#000099" class="headline" valign="middle" width="13%">Name:</td>
394
            <td colspan="2">
395
              <input type="text" name="Name" value="<? echo $zeile[Name] ?>" >
396
            </td>
397
          </tr>
398
          <tr>
399
            <td bgcolor="#000099" class="headline" valign="middle" width="13%">e-Mail:</td>
400
            <td colspan="2">
401
              <input type="text" name="mail" value="<? echo $zeile[mail] ?>">
402
            </td>
403
          </tr>
404
          <tr>
405
            <td bgcolor="#000099" class="headline" valign="middle" width="13%">Titel:</td>
406
            <td colspan="2">
407
              <input type="text" name="headline" value="<? echo $zeile[headline] ?>">
408
            </td>
409
          </tr>
410
		  <tr>
411
            <td bgcolor="#000099" class="headline" valign="middle" width="13%">Homepage:</td>
412
            <td colspan="2">
413
              <input type="text" name="homepage" value="<? echo $zeile[homepage] ?>">
414
            </td>
415
          </tr>
416
		  <tr>
417
            <td bgcolor="#000099" class="headline" valign="middle" width="13%">Staat:</td>
418
            <td colspan="2">
419
              <input type="text" name="Staat" value="<? echo $zeile[Staat] ?>">
420
            </td>
421
          </tr>
422
		  <tr>
423
            <td bgcolor="#000099" class="headline" valign="middle" width="13%">Bundesland:</td>
424
            <td colspan="2">
425
              <input type="text" name="Bundesland" value="<? echo $zeile[Bundesland] ?>">
426
            </td>
427
          </tr>
428
		  <tr>
429
		  <tr>
430
		  <tr>
431
		  <tr>
432
            <td bgcolor="#000099" class="headline" valign="middle" width="13%">Text:</td>
433
            <td colspan="2">
434
              <textarea name="text"><? echo $zeile[text] ?></textarea>
435
            </td>
436
          </tr>
437
 
438
          <tr bgcolor="#000099">
439
            <td align="right" colspan="3">
440
              <input type="hidden" name="ID" value="<? echo $ID ?>">
441
              <input type="hidden" name="action" value="update">
442
              <input type="submit" value="OK">
443
              <input type="reset" name="Button" value="Zur&uuml;cksetzen">
444
            </td>
445
          </tr>
446
        </table>
447
        <?
448
	}
449
?> </td>
450
      <td width="77" align="right">
451
        <table width="67" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#FFFFFF" bordercolordark="#999999">
452
  		<tr>
453
            <td><a href="<? echo $self ?>?action=select_edit" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('edit','','images/navigation/bt_bearbeiten_f2.gif',1)"><img name="edit" border="0" src="images/navigation/bt_bearbeiten.gif" width="67" height="40" alt="Eintrag bearbeiten"></a></td>
454
  		</tr>
455
  		<tr>
456
            <td><a href="<? echo $self ?>?action=delete" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('delete','','images/navigation/bt_delete_f2.gif',1)"><img name="delete" border="0" src="images/navigation/bt_delete.gif" width="67" height="40" alt="Eintrag l&ouml;schen"></a></td>
457
  		</tr>
458
		</table>
459
      </td>
460
</tr>
461
</table>
462
</form>
463
</body>