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