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_eintraege";
4
	require_once "../connect2.php";
5
	require_once "../webs.php";
6
 
7
	session_start();
8
 
9
	if ($_GET[selectGB])			{$_SESSION[$self][selectGB]=$_GET[selectGB];}
10
	if ($_SESSION[$self][selectGB])	{$site=$_SESSION[$self][selectGB];}
11
 
12
	if ($action=="update")
13
	{
14
		if (!$ID)
15
		{	// insert Dummy-Entry
16
			$query = "insert into $DB (erstellt_am,erstellt_von,letzte_Aenderung_am,letzte_Aenderung_von) VALUES (NOW(),'$PHP_AUTH_USER',NOW(),'$PHP_AUTH_USER')";
17
			$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query."<hr>");
18
			$ID=mysql_insert_id();
19
		}
20
 
21
		unset($HTTP_POST_VARS[action]);
22
		unset($HTTP_POST_VARS[ID]);
23
 
24
		foreach(array_keys($HTTP_POST_VARS) as $elem)
25
		{
26
			if ($elem[0] == "_")
27
			{
28
				unset($HTTP_POST_VARS[$elem]);
29
				$button=$$elem;
30
				$elem=substr($elem,1);
31
				$Pfad=$HTTP_POST_VARS[$elem."_Pfad"];
32
				unset($HTTP_POST_VARS[$elem."_Pfad"]);
33
				$image=$$elem;
34
				$image_name=$elem."_name";
35
				$image_name=urlencode($$image_name);
36
				switch ($button)
37
				{
38
					case 0:
39
						break;
40
					case 1:
41
						$HTTP_POST_VARS[$elem]='';
42
	   					break;
43
	   				case 2:
44
						if ($image != "none")
45
						{
46
							$image_name=$ID."_".$image_name;
47
							//$image_name=$ID.strrchr($image_name,".");
48
							$HTTP_POST_VARS[$elem]=$image_name;
49
							copy($image,$Pfad.$image_name);
50
						}
51
				        break;
52
				    default:
53
				        break;
54
			    }
55
			}
56
		}
57
		$names=array();
58
		foreach(array_keys($HTTP_POST_VARS) as $elem)
59
		{
60
			array_push($names,"$elem='$HTTP_POST_VARS[$elem]'");
61
		}
62
		$query="update $DB set letzte_Aenderung_am=NOW(), letzte_Aenderung_von='$PHP_AUTH_USER', ".join($names,', ');
63
		$query=$query." where ID = '$ID'";
64
		$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
65
 
66
		if ($webs[FTP_server])
67
		{
68
			require_once "update_file.php";
69
		}
70
		header("Location: ".$self);
71
		exit;
72
	}
73
 
74
	if ($action=="delete")
75
	{
76
		if ($ID)
77
		{
78
			$condition=array();
79
			foreach ($ID as $elem)
80
			{
81
				array_push($condition," ID = '$elem'");
82
			}
83
			$cond=join(" or ",$condition);
84
			$query = "DELETE FROM $DB WHERE $cond";
85
			$result = mysql_query ("$query") or die (mysql_errno().": ".mysql_error());
86
 
87
			$request="http://forum.$site/gaestebuch/$site.php";
88
			$content=join("",file($request));
89
 
90
			if ($webs[FTP_server])
91
			{
92
				require_once "update_file.php";
93
			}
94
 
95
			header("Location: ".$self);
96
			exit;
97
		}
98
	}
99
	if (!$action)
100
	{
101
		$action="select_edit";
102
	}
103
	if (!$sort) {$sort='erstellt_am DESC';}
104
?>
105
 
106
<html>
107
<head>
108
<title>Redaktionssystem: Gästebuch</title>
109
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
110
<link rel=stylesheet type="text/css" href="../buttons.css">
111
<style type="text/css" link="redaktion.css"><MM:BeginLock translatorClass="MM_SSI" type="ssi" orig="%3C? require_once %22../buttons.css%22; ?%3E" fileRef="../buttons.css" depFiles="file:///L|/content-management/buttons.css">span {text-decoration:underline; color:#000000}
112
p {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #000000}
113
p.error {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; font-weight: bold}
114
span {font-family: Arial, Helvetica, sans-serif; font-size: 10pt}
115
span.blue {font-family: Arial, Helvetica, sans-serif; color: #FFFFFF; background-color:#0000A0; font-size: 10pt}
116
span.small {font-family: Arial, Helvetica, sans-serif; font-size: 8pt; text-decoration: none}
117
td {font-family: Arial, Helvetica, sans-serif; font-size: 10pt}
118
td.timeout {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #FF0000;}
119
td.small {font-family: Arial, Helvetica, sans-serif; font-size: 8pt}
120
td.headline {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #FFFFFF; font-weight: bold}
121
td.haupt {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; font-weight: bold}
122
input {font-family: Arial, Helvetica, sans-serif; font-size: 8pt}
123
select {font-family: Arial, Helvetica, sans-serif; font-size: 8pt}
124
textarea {font-family: Arial, Helvetica, sans-serif; font-size: 8pt}a {  text-decoration: none}
125
<MM:EndLock></style>
126
<script language="JavaScript">
127
<!--
128
function MM_swapImgRestore() { //v3.0
129
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
130
}
131
 
132
function MM_preloadImages() { //v3.0
133
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
134
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
135
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
136
}
137
 
138
function MM_swapImage() { //v3.0
139
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
140
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
141
}
142
 
143
function MM_findObj(n, d) { //v4.0
144
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
145
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
146
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
147
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
148
  if(!x && document.getElementById) x=document.getElementById(n); return x;
149
}
150
 
151
//-->
152
</script>
153
<meta name="description" content="Redaktionssystem">
154
<meta name="author" content="Webagentur Niewerth">
155
<meta name="robots" content="noindex">
156
</head>
157
 
158
<body leftmargin="20" topmargin="10" marginwidth="20" marginheight="10" onLoad="MM_preloadImages('images/navigation/bt_bearbeiten_f2.gif','images/navigation/bt_delete_f2.gif')" bgcolor="#<? echo $webs[bgcolor_seite] ?>" text="#<? echo $webs[font_color_seite] ?>" alink="#<? echo $webs[font_color_seite] ?>" vlink="#<? echo $webs[font_color_seite] ?>">
159
<form method="post" action="#" name="formname" enctype="multipart/form-data">
160
  <table border="0" cellspacing="0" cellpadding="2">
161
    <tr valign="top">
162
      <td width="485">
163
        <!--  Auswahl Löschen START  -->
164
        <?
165
	if ($action=="delete")
166
	{
167
		$query="SELECT * FROM $DB where site='$site' ";
168
		$query=$query."order by $sort";
169
		$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
170
		if (mysql_num_rows($result) == 0)
171
		{
172
?>
173
<p><b><font color="#<? echo $webs[font_color_seite] ?>">Es sind keine Daten eingetragen !</font></b></p>
174
<p></p>
175
<?
176
		}
177
		else
178
		{
179
?>
180
        <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
181
          <tr bgcolor="#<? echo $webs[bgcolor_links] ?>">
182
            <td colspan="3" class="headline"><font color="#<? echo $webs[font_color_links] ?>">Eintrag: L&ouml;schen</font></td>
183
          </tr>
184
          <tr bgcolor="#<? echo $webs[bgcolor_rechts] ?>">
185
            <td width="50%" class="haupt"><a href="<? echo $self?>?action=delete&sort=Name">Name</a></td>
186
            <td class="haupt" colspan="2"><a href="<? echo $self?>?action=delete&sort=erstellt_am">erstellt</a></td>
187
          </tr>
188
          <?
189
	while ($zeile=mysql_fetch_array($result))
190
	{
191
?>
192
          <tr bgcolor="#<? echo $webs[bgcolor_rechts] ?>">
193
            <td width="50%"><a href="<? echo $self?>?action=edit&ID=<? echo $zeile[ID]; ?>">
194
              <? echo $zeile[Name]?>
195
              </a></td>
196
            <td>
197
             <? $Zeit=datetime2human($zeile[erstellt_am]); ?>
198
              <? echo $Zeit[Datum] ?>
199
              &nbsp; </td>
200
            <td width="5%" align="center">
201
              <input type="checkbox" name="ID[]" value="<?  echo $zeile[ID] ?>">
202
            </td>
203
          </tr>
204
          <?
205
	}
206
?>
207
          <tr bgcolor="#<? echo $webs[bgcolor_links] ?>">
208
            <td colspan="3" align="right">
209
              <input type="hidden" name="action" value='delete'>
210
              <input type="submit" value="LÖSCHEN">
211
              <input type="reset" name="Button22" value="Zur&uuml;cksetzen">
212
            </td>
213
          </tr>
214
        </table>
215
        <?
216
		}
217
?>
218
        <?
219
 	}
220
?>
221
        <!--  Auswahl Löschen ENDE  -->
222
        <!--  Auswahl SELECT_EDIT START  -->
223
        <?
224
 
225
  if ($action=="select_edit")
226
	{
227
	$query="SELECT * FROM $DB where site='$site' ";
228
	$query=$query."order by $sort";
229
 
230
	$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
231
	if (mysql_num_rows($result) == 0)
232
	{
233
	?>
234
<p><b><font color="#<? echo $webs[font_color_seite] ?>">Es sind keine Daten eingetragen !</font></b></p>
235
<p></p>
236
	<?
237
	}
238
	else
239
	{
240
	?>
241
        <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
242
          <tr bgcolor="#<? echo $webs[bgcolor_links] ?>">
243
            <td class="headline" colspan="3"><font color="#<? echo $webs[font_color_links] ?>">Eintrag: Bearbeiten</font></td>
244
          </tr>
245
          <tr bgcolor="#<? echo $webs[bgcolor_links] ?>">
246
            <td width="50%" class="haupt"><a href="<? echo $self?>?action=select_edit&sort=Name"><font color="#<? echo $webs[font_color_links] ?>">Name</font></a></td>
247
            <td width="50%" class="haupt"><a href="<? echo $self?>?action=select_edit&sort=erstellt_am"><font color="#<? echo $webs[font_color_links] ?>">erstellt</font></a></td>
248
          </tr>
249
          <?
250
	while ($zeile=mysql_fetch_array($result))
251
	{
252
?>
253
          <tr bgcolor="#<? echo $webs[bgcolor_rechts] ?>">
254
            <td width="50%"><a href="<? echo $self?>?action=edit&ID=<? echo $zeile[ID]; ?>">
255
              <font color="#<? echo $webs[font_color_rechts] ?>"><? echo $zeile[Name]?></font></a></td>
256
            <td width="50%">
257
<? $Zeit=datetime2human($zeile[erstellt_am]); ?>
258
<font color="#<? echo $webs[font_color_rechts] ?>">
259
              <? echo $Zeit[Datum] ?></font>
260
              &nbsp; </td>
261
          </tr>
262
          <?
263
	}
264
?>
265
          <tr bgcolor="#<? echo $webs[bgcolor_links] ?>">
266
            <td colspan="3">
267
              <div align="right">&nbsp;
268
                <input type="hidden" name="action" value='edit'>
269
              </div>
270
            </td>
271
          </tr>
272
        </table>
273
 <?
274
	}
275
?>
276
        <?
277
 	}
278
?>
279
<!--  Auswahl SELECT_EDIT ENDE  -->
280
 
281
<?
282
	if ($action=="edit")
283
	{
284
		if ($ID)
285
		{
286
			$result = mysql_query ("SELECT * FROM $DB where ID = '$ID'") or die (mysql_errno().": ".mysql_error());
287
			$zeile=mysql_fetch_array($result);
288
		}
289
	?>
290
	    <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
291
          <tr bgcolor="#<? echo $webs[bgcolor_links] ?>">
292
            <td colspan="3" class="headline"><font color="#<? echo $webs[font_color_links] ?>">Eintrag:
293
              <?
294
					if ($ID)
295
					{
296
					 ?>
297
              Bearbeiten
298
              <?
299
					}
300
					else
301
					{
302
					 ?>
303
              Neueintrag
304
              <?
305
					}
306
				?>
307
              </font> </td>
308
          </tr>
309
          <tr>
310
            <td bgcolor="#<? echo $webs[bgcolor_links] ?>" class="headline" valign="middle" width="14%"><font color="#<? echo $webs[font_color_links] ?>">&Uuml;berschrift:</font></td>
311
            <td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts] ?>">
312
              <input type="text" name="headline" value="<? echo $zeile[headline] ?>" >
313
            </td></tr>
314
          <tr>
315
            <td bgcolor="#<? echo $webs[bgcolor_links] ?>" class="headline" valign="top" width="14%"><font color="#<? echo $webs[font_color_links] ?>">Text:</font></td>
316
            <td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts] ?>">
317
              <textarea name="text" cols="60" rows="10"><? echo $zeile[text] ?></textarea>
318
            </td>
319
          </tr>
320
          <tr>
321
            <td bgcolor="#<? echo $webs[bgcolor_links] ?>" class="headline" valign="middle" colspan="3"><font color="#<? echo $webs[font_color_links] ?>">Personendaten:</font></td>
322
          </tr>
323
          <tr>
324
            <td bgcolor="#<? echo $webs[bgcolor_links] ?>" class="headline" valign="middle" width="14%"><font color="#<? echo $webs[font_color_links] ?>">Name:</font></td>
325
            <td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts] ?>"> <input type="text" name="Name" value="<? echo $zeile[Name] ?>" ></td>
326
          </tr>
327
          <tr>
328
            <td bgcolor="#<? echo $webs[bgcolor_links] ?>" class="headline" valign="middle" width="14%"><font color="#<? echo $webs[font_color_links] ?>">E-Mail:</font></td>
329
            <td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts] ?>">
330
              <input type="text" name="mail" value="<? echo $zeile[mail] ?>" >
331
            </td>
332
          </tr>
333
          <tr>
334
            <td bgcolor="#<? echo $webs[bgcolor_links] ?>" class="headline" valign="middle" width="14%"><font color="#<? echo $webs[font_color_links] ?>">Homepage:</font></td>
335
            <td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts] ?>">
336
              <input type="text" name="homepage" value="<? echo $zeile[homepage] ?>" >
337
            </td>
338
          </tr>
339
          <tr>
340
            <td bgcolor="#<? echo $webs[bgcolor_links] ?>" class="headline" valign="middle" width="14%"><font color="#<? echo $webs[font_color_links] ?>">Stadt:</font></td>
341
            <td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts] ?>">
342
              <input type="text" name="Stadt" value="<? echo $zeile[Stadt] ?>" >
343
            </td>
344
          </tr>
345
          <tr>
346
            <td bgcolor="#<? echo $webs[bgcolor_links] ?>" class="headline" valign="middle" width="14%"><font color="#<? echo $webs[font_color_links] ?>">Bundesland:</font></td>
347
            <td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts] ?>">
348
              <input type="text" name="Bundesland" value="<? echo $zeile[Bundesland] ?>" >
349
            </td>
350
          </tr>
351
          <tr>
352
            <td bgcolor="#<? echo $webs[bgcolor_links] ?>" class="headline" valign="middle" width="14%"><font color="#<? echo $webs[font_color_links] ?>">Staat:</font></td>
353
            <td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts] ?>">
354
              <input type="text" name="Staat" value="<? echo $zeile[Staat] ?>" >
355
            </td>
356
          </tr>
357
          <? if ($ID) {?>
358
          <tr bgcolor="#<? echo $webs[bgcolor_links] ?>">
359
            <td class="headline" colspan="4"><font color="#<? echo $webs[font_color_links] ?>">Datensatz:</font></td>
360
          </tr>
361
          <tr>
362
            <td bgcolor="#<? echo $webs[bgcolor_links] ?>" class="headline" width="20%"><font color="#<? echo $webs[font_color_links] ?>">erstellt:</font></td>
363
            <td colspan="3" bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><font color="#<? echo $webs[font_color_rechts] ?>">am:
364
              <? $erstellt_am=datetime2human($zeile[erstellt_am]); ?>
365
              <? echo $erstellt_am[Datum] ?>
366
              &nbsp;&nbsp;um:
367
              <? echo $erstellt_am[Zeit] ?>
368
              &nbsp;&nbsp;von:
369
              <? echo $zeile[erstellt_von] ?></font>
370
            </td>
371
          </tr>
372
          <tr>
373
            <td bgcolor="#<? echo $webs[bgcolor_links] ?>" class="headline" width="20%" nowrap><font color="#<? echo $webs[font_color_links] ?>">letzte
374
              &Auml;nderung:</font></td>
375
            <td colspan="3" bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><font color="#<? echo $webs[font_color_rechts] ?>">am:
376
              <? $letzte_Aenderung_am=datetime2human($zeile[letzte_Aenderung_am]); ?>
377
              <? echo $letzte_Aenderung_am[Datum] ?>
378
              &nbsp;&nbsp;um:
379
              <? echo $letzte_Aenderung_am[Zeit] ?>
380
              &nbsp;&nbsp;von:
381
              <? echo $zeile[letzte_Aenderung_von] ?></font>
382
            </td>
383
          </tr>
384
          <? } ?>
385
          <tr bgcolor="#<? echo $webs[bgcolor_links] ?>">
386
            <td align="right" colspan="3">
387
              <input type="hidden" name="ID" value="<? echo $ID ?>">
388
              <input type="hidden" name="action" value="update">
389
              <input type="submit" value="OK">
390
              <input type="reset" name="Button" value="Zur&uuml;cksetzen">
391
            </td>
392
          </tr>
393
        </table>
394
        <?
395
	}
396
?> </td>
397
      <td width="70" align="right">
398
        <table width="67" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#FFFFFF" bordercolordark="#999999">
399
          <tr>
400
            <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>
401
          </tr>
402
          <tr>
403
            <td><a href="<? echo $self ?>?action=delete<? if (($action=="edit") && ($ID > 0)) { ?>&ID[]=<?=$ID?>" onClick="return confirm('Diesen Eintrag wirklich löschen ?');"<? } else { ?>"<? } ?> 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>
404
          </tr>
405
        </table>
406
<?
407
	//if ($PHP_AUTH_USER == "admin")
408
	//{
409
	if ($web_rechte[gaestebuch][basisdaten][databases])
410
	{
411
		?>
412
        <br>
413
        Gästebücher:<ul>
414
<?
415
	  	foreach(explode(";",$web_rechte[gaestebuch][basisdaten][databases]) as $GaestebuchSite)
416
		{
417
			?><li><a href="<?=$self?>?selectGB=<?=$GaestebuchSite;?>"><?=$GaestebuchSite;?></a></li><?
418
		}
419
	}
420
	//}
421
?>
422
        </ul>
423
      </td>
424
</tr>
425
</table>
426
</form>
427
</body>