Subversion-Projekte lars-tiefland.content-management

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1
<?
2
	require_once "connect.php";
3
	$DB="Head";
4
	if (!$rechte[$Rubrik[content_management]] & $Buttons[Frameset])
5
	{
6
		header("Location: www.".$site);
7
		exit;
8
	}
9
	if ($action=="update")
10
	{
11
		if (!$ID)
12
		{	// insert Dummy-Entry
13
			$query = "insert into $DB (erstellt_am,erstellt_von,letzte_Aenderung_am,letzte_Aenderung_von) VALUES (NOW(),'$PHP_AUTH_USER',NOW(),'$PHP_AUTH_USER')";
14
			$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query."<hr>");
15
			$ID=mysql_insert_id();
16
		}
17
 
18
		unset($HTTP_POST_VARS[action]);
19
		unset($HTTP_POST_VARS[ID]);
20
 
21
		foreach(array_keys($HTTP_POST_VARS) as $elem)
22
		{
23
			if ($elem[0] == "_")
24
			{
25
				unset($HTTP_POST_VARS[$elem]);
26
				$button=$$elem;
27
				$elem=substr($elem,1);
28
				$Pfad=$HTTP_POST_VARS[$elem."_Pfad"];
29
				unset($HTTP_POST_VARS[$elem."_Pfad"]);
30
				$image=$$elem;
31
				$image_name=$elem."_name";
32
				$image_name=urlencode($$image_name);
33
				switch ($button)
34
				{
35
					case 0:
36
						$$elem=$button;
37
						break;
38
					case 1:
39
						$HTTP_POST_VARS[$elem]='';
40
						$$elem=$button;
41
	   					break;
42
	   				case 2:
43
						//$image_name=$ID."_".$image_name;  		// dateiname = ID_Dateiname
44
						//$image_name=$ID.strrchr($image_name,".");	// dateiname = ID.Endung
45
						if ($image_name == 'none')
46
						{
47
							unset($HTTP_POST_VARS[$elem]);
48
						}
49
						else
50
						{
51
							$HTTP_POST_VARS[$elem]=$image_name;
52
							copy($image,$Pfad.$image_name);
53
							$$elem=$image_name;
54
						}
55
				        break;
56
				    default:
57
						$$elem=$button;
58
				        break;
59
			    }
60
			}
61
		}
62
		$names=array();
63
		foreach(array_keys($HTTP_POST_VARS) as $elem)
64
		{
65
			array_push($names,"$elem='$HTTP_POST_VARS[$elem]'");
66
		}
67
		$query="update $DB set ".join($names,', ');
68
		$query=$query.", letzte_Aenderung_am=NOW(), letzte_Aenderung_von='$PHP_AUTH_USER' where ID = '$ID'";
69
		$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
70
// ****************************************************************************************************************** //
71
// **	Dateien erstellen START																					   ** //
72
// ****************************************************************************************************************** //
73
		$filename="vorlagen/index.htm";
74
		require_once "capture_file.php";
75
		$fp = fopen ("../$site/index.htm","w");
76
		fwrite ($fp, $source);
77
		fclose($fp);
78
 
79
 
80
		switch ($Banner1)
81
		{
82
			case 1:
83
					$Banner1="&nbsp;";
84
					break;
85
			default:
86
					$Banner1="<img src=\"images/$Banner1\">";
87
					break;
88
		}
89
 
90
		switch ($Banner2)
91
		{
92
			case 1:
93
					$Banner2="&nbsp;";
94
					break;
95
			default:
96
					$Banner2="<img src=\"images/$Banner2\">";
97
					break;
98
		}
99
 
100
		switch ($background)
101
		{
102
			case 0:
103
					$background="background=\"images/".$background."\"";
104
					break;
105
			case 1:
106
					unset($background);
107
					break;
108
			case 2:
109
					$background="background=\"images/".$background."\"";
110
					break;
111
		}
112
 
113
 
114
		$filename="vorlagen/head.htm";
115
		require_once "capture_file.php";
116
		$fp = fopen ("../$site/head.htm","w");
117
		fwrite ($fp, $source);
118
		fclose($fp);
119
 
120
// ****************************************************************************************************************** //
121
// **	Dateien erstellen STOP																					   ** //
122
// ****************************************************************************************************************** //
123
		header("Location: ".$self);
124
	}
125
 
126
	if ($action=="delete")
127
	{
128
		if ($ID)
129
		{
130
			$condition=array();
131
			foreach ($ID as $elem)
132
			{
133
				array_push($condition," ID = '$elem'");
134
			}
135
			$cond=join(" or ",$condition);
136
			$query = "DELETE FROM $DB WHERE $cond";
137
			$result = mysql_query ("$query") or die (mysql_errno().": ".mysql_error());
138
			header("Location: ".$self);
139
		}
140
	}
141
	if (!$action)
142
	{
143
		$action="edit";
144
	}
145
	if (!$sort) {$sort='Name';}
146
?>
147
 
148
<html>
149
<head>
150
<title>Content-Management-System - Webagentur Niewerth</title>
151
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
152
<script language="JavaScript">
153
<!--
154
 
155
function MM_openBrWindow(theURL,winName,features) { //v2.0
156
  window.open(theURL,winName,features);
157
}
158
//-->
159
</script>
160
<script language="javascript" src="Farb_Assistent.js"></script>
161
<meta name="author" content="Webagentur Niewerth - www.weban.de">
162
<meta name="description" content="Redaktionssystem">
163
<meta name="robots" content="noindex">
164
<link rel="stylesheet" href="redaktion.css" type="text/css">
165
<style type="text/css"><? require_once "redaktion.css" ?></style>
166
</head>
167
 
168
<body bgcolor="#FFFFFF" leftmargin="20" topmargin="10" marginwidth="20" marginheight="10" >
169
<form method="post" action="<? echo $self ?>" name="formname" enctype="multipart/form-data">
170
  <table width="740" border="0" cellspacing="0" cellpadding="0">
171
    <tr valign="top">
172
 
173
      <td>
174
        <?  if ($action=="delete")
175
	{
176
	$result = mysql_query ("SELECT * FROM Objekte,$DB where $DB.Objekt=Objekte.Kennung order by $DB.von,$DB.bis") or die (mysql_errno().": ".mysql_error());
177
	if (mysql_num_rows($result) == 0)
178
	{
179
	?>
180
        <p class="error">Es sind keine Daten eingetragen !</p>
181
<p></p>
182
 
183
	<?
184
	}
185
	else
186
	{
187
	?>
188
	    <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
189
          <tr bgcolor="#000096">
190
            <td colspan="3" class="headline">Seite: L&ouml;schen</td>
191
          </tr>
192
          <tr>
193
            <td width="6%" bgcolor="#000096">&nbsp;</td>
194
            <td width="88%" ><a href="<? echo $self?>?action=select_edit&sort=Objekte.Titel">Titel</a>
195
              / <a href="<? echo $self?>?action=select_edit&sort=Objekte.Hersteller">Hersteller</a></td>
196
            <td align="center" valign="middle" width="6%" bgcolor="#000096">&nbsp;</td>
197
          </tr>
198
          <?
199
	while ($zeile=mysql_fetch_array($result))
200
	{
201
  	$zeile[von]=join(".",array_reverse(preg_split("/-/",$zeile[von])));
202
   	$zeile[bis]=join(".",array_reverse(preg_split("/-/",$zeile[bis])));
203
	$zeile[Eingangsdatum]=join(".",array_reverse(preg_split("/-/",$zeile[Eingangsdatum])));
204
	?>
205
          <tr>
206
            <td width="6%" bgcolor="#000096">&nbsp; </td>
207
            <td width="88%" > <span class="small"> </span>
208
              <? echo $zeile[Titel]?>
209
              /
210
              <? echo $zeile[Hersteller]?>
211
            </td>
212
            <td align="center" valign="middle" width="6%" bgcolor="#000096">
213
              <input type="checkbox" name="ID[]" value="<?  echo $zeile[ID] ?>">
214
            </td>
215
          </tr>
216
          <?
217
	}
218
	?>
219
          <tr align="right" bgcolor="#000096">
220
            <td colspan="3">
221
              <input type="hidden" name="action" value='delete'>
222
              <input type="submit" value="LÖSCHEN">
223
              <input type="reset" name="Button22" value="Zur&uuml;cksetzen">
224
            </td>
225
          </tr>
226
        </table>
227
        <?
228
	}
229
?>
230
        <?
231
 	}
232
?>
233
        <?
234
 
235
  if ($action=="select_edit")
236
	{
237
	$result = mysql_query ("SELECT * FROM Objekte,$DB where $DB.Objekt=Objekte.Kennung order by $sort") or die (mysql_errno().": ".mysql_error());
238
	if (mysql_num_rows($result) == 0)
239
	{
240
	?>
241
 
242
<p class="error">Es sind keine Daten eingetragen !</p>
243
<p></p>
244
 
245
	<?
246
	}
247
	else
248
	{
249
	?>
250
	    <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
251
          <tr bgcolor="#000099">
252
            <td colspan="2" class="headline">Seite: Bearbeiten</td>
253
          </tr>
254
          <tr>
255
            <td width="6%" bgcolor="#000096">&nbsp;</td>
256
            <td width="94%" >&nbsp;&nbsp;&nbsp; <a href="file:///L|/asset-trading.de/redaktion/<? echo $self?>?action=select_edit&sort=<? echo $DB ?>.von">von</a>
257
              &nbsp;&nbsp;&nbsp;&nbsp;- &nbsp;&nbsp;&nbsp;&nbsp; <a href="file:///L|/asset-trading.de/redaktion/<? echo $self?>?action=select_edit&sort=<? echo $DB ?>.bis">bis</a>
258
              &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="file:///L|/asset-trading.de/redaktion/<? echo $self?>?action=select_edit&sort=<? echo $DB ?>.Objekt">Kennung</a>
259
              / <a href="<? echo $self?>?action=select_edit&sort=Objekte.Titel">Titel</a>
260
              / <a href="<? echo $self?>?action=select_edit&sort=Objekte.Hersteller">Hersteller</a></td>
261
          </tr>
262
          <?
263
	while ($zeile=mysql_fetch_array($result))
264
	{
265
  	$zeile[von]=join(".",array_reverse(preg_split("/-/",$zeile[von])));
266
   	$zeile[bis]=join(".",array_reverse(preg_split("/-/",$zeile[bis])));
267
   	$zeile[Eingangsdatum]=join(".",array_reverse(preg_split("/-/",$zeile[Eingangsdatum])));
268
	?>
269
          <tr>
270
            <td width="6%" bgcolor="#000096">&nbsp;</td>
271
            <td width="94%" ><a href="file:///L|/asset-trading.de/redaktion/<? echo $self?>?action=edit&ID=<? echo $zeile[ID]; ?>">
272
              <span class="small">
273
              <? echo $zeile[von]?>
274
              -
275
              <? echo $zeile[bis]?>
276
              </span>&nbsp;&nbsp;&nbsp;&nbsp;
277
              <? echo $zeile[Objekt]?>
278
              /
279
              <? echo $zeile[Titel]?>
280
              /
281
              <? echo $zeile[Hersteller]?>
282
              </a> </td>
283
          </tr>
284
          <?
285
	}
286
	?>
287
          <tr bgcolor="#000096">
288
            <td colspan="2"> &nbsp;
289
              <input type="hidden" name="action" value='edit'>
290
            </td>
291
          </tr>
292
        </table>
293
 <?
294
	}
295
?>
296
        <?
297
 	}
298
?> <?
299
	if ($action=="edit")
300
	{
301
		$result = mysql_query ("SELECT * FROM $DB where domain = '$site'") or die (mysql_errno().": ".mysql_error());
302
		$zeile=mysql_fetch_array($result);
303
		$ID=$zeile[ID];
304
		if ($ID)
305
		{
306
			$result = mysql_query ("SELECT * FROM $DB where ID = $ID") or die (mysql_errno().": ".mysql_error());
307
			$zeile=mysql_fetch_array($result);
308
		}
309
  	$zeile[von]=join(".",array_reverse(preg_split("/-/",$zeile[von])));
310
   	$zeile[bis]=join(".",array_reverse(preg_split("/-/",$zeile[bis])));
311
   	$zeile[Eingangsdatum]=join(".",array_reverse(preg_split("/-/",$zeile[Eingangsdatum])));
312
	?>
313
	    <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
314
          <tr bgcolor="#000096">
315
            <td colspan="4" class="headline" height="27">
316
Head:
317
	<?
318
					if ($ID)
319
					{
320
					 ?>
321
              Bearbeiten
322
              <?
323
					}
324
					else
325
					{
326
					 ?>
327
              Neueintrag
328
              <?
329
					}
330
				?>
331
            </td>
332
          </tr>
333
          <tr>
334
            <td width="17%" bgcolor="#000096" class="headline">Titel: </td>
335
            <td colspan="3" class="small">
336
              <input type="text" name="Titel" size="30" maxlength="50" value="<? echo $zeile[Titel] ?>">
337
              Titel der Homepage</td>
338
          </tr>
339
          <tr>
340
            <td bgcolor="#000096" class="headline" rowspan="2" valign="top" width="17%">&Uuml;berschrift:</td>
341
            <td colspan="3"><b>
342
              <input type="text" name="Ueberschrift" size="20" maxlength="50" value="<? echo $zeile[Ueberschrift] ?>">
343
              </b></td>
344
          </tr>
345
          <tr>
346
            <td width="34%"><b><font face="Arial, Helvetica, sans-serif" size="2">Farbe:
347
              #
348
              <input type="text" name="Ueberschrift_color" size="6" maxlength="6" value="<? echo $zeile[Ueberschrift_color] ?>">
349
              <input type="button" value="Farb Assistent" onClick="Farb_Assistent(this.form.Ueberschrift_color.value,'document.formname.Ueberschrift_color.value');">
350
              </font></b></td>
351
            <td width="21%" bgcolor="#FFFFFF"><b>Art:
352
              <select name="Ueberschrift_art" size="1">
353
                <option value="Arial, Helvetica, sans-serif"<? if ($zeile[Ueberschrift_art] == "Arial, Helvetica, sans-serif") {echo " selected";} ?>>Arial</option>
354
                <option value="Times New Roman, Times, serif"<? if ($zeile[Ueberschrift_art] == "Times New Roman, Times, serif") {echo " selected";} ?>>Times New Roman</option>
355
                <option value="Courier New, Courier, mono"<? if ($zeile[Ueberschrift_art] == "Courier New, Courier, mono") {echo " selected";} ?>>Courier</option>
356
                <option value="Verdana, Arial, Helvetica, sans-serif"<? if ($zeile[Ueberschrift_art] == "Verdana, Arial, Helvetica, sans-serif") {echo " selected";} ?>>Verdana</option>
357
              </select>
358
              </b></td>
359
            <td width="28%" bgcolor="#FFFFFF"><b>Gr&ouml;&szlig;e:
360
              <select name="Ueberschrift_groesse" size="1">
361
                <option<? if ($zeile[Ueberschrift_groesse] == "1") {echo " selected";} ?>>1</option>
362
                <option<? if ($zeile[Ueberschrift_groesse] == "2") {echo " selected";} ?>>2</option>
363
                <option<? if ($zeile[Ueberschrift_groesse] == "3") {echo " selected";} ?>>3</option>
364
                <option<? if ($zeile[Ueberschrift_groesse] == "4") {echo " selected";} ?>>4</option>
365
                <option<? if ($zeile[Ueberschrift_groesse] == "5") {echo " selected";} ?>>5</option>
366
                <option<? if ($zeile[Ueberschrift_groesse] == "6") {echo " selected";} ?>>6</option>
367
              </select>
368
              </b></td>
369
          </tr>
370
          <tr>
371
            <td bgcolor="#000096" class="headline" width="17%"><b><font face="Arial, Helvetica, sans-serif" size="2" color="#FFFFFF">Hintergrund:</font></b></td>
372
            <td width="34%"><b><font face="Arial, Helvetica, sans-serif" size="2">Farbe:
373
              #
374
              <input type="text" name="bgcolor" size="6" maxlength="6" value="<? echo $zeile[bgcolor] ?>">
375
              <input type="button" value="Farb Assistent" onClick="Farb_Assistent(this.form.bgcolor.value,'document.formname.bgcolor.value');">
376
              </font></b></td>
377
            <td valign="top" colspan="2" bgcolor="#FFFFFF">
378
<?
379
	$image_name="background";
380
	$image_Path="../$site/images/";
381
	if ($zeile[$image_name] != "")
382
	{
383
?>
384
	<input type="radio" name="_<? echo $image_name ?>" value="<? echo $zeile[$image_name]; ?>" <? if ($zeile[$image_name] != "") {echo "checked";}?>>
385
<?
386
	echo "$zeile[$image_name]";
387
	$size= filesize ($image_Path.$zeile[$image_name]) >> 10;
388
	$imgsize = GetImageSize ($image_Path.$zeile[$image_name]);
389
	echo "&nbsp;( $size KB $imgsize[0]x$imgsize[1])<BR>";
390
	}
391
?>
392
              <input type="radio" name="_<? echo $image_name ?>" value="1" <? if ($zeile[$image_name] == "") {echo "checked";}?>>
393
              kein Bild<br>
394
              <input type="radio" name="_<? echo $image_name ?>" value="2">
395
              <input type="File" name="<? echo $image_name ?>" size="17" maxlength="255" onFocus="this.form._<? echo $image_name ?>[<? if ($zeile[$image_name] != "") {echo "2";} else {echo "1";} ?>].checked=true;">
396
              <input type="hidden" name="<? echo $image_name ?>_Pfad" value="<? echo $image_Path ?>">
397
            </td>
398
          </tr>
399
          <tr>
400
            <td bgcolor="#000096" class="headline" width="17%" nowrap>Logo/Banner1:<br>
401
              links </td>
402
            <td colspan="3">
403
              <?
404
	$image_name="Banner1";
405
	$image_Path="../$site/images/";
406
	if ($zeile[$image_name] != "")
407
	{
408
?>
409
              <input type="radio" name="_<? echo $image_name ?>" value="<? echo $zeile[$image_name]; ?>" <? if ($zeile[$image_name] != "") {echo "checked";}?>>
410
              <?
411
	echo "$zeile[$image_name]";
412
	$size= filesize ($image_Path.$zeile[$image_name]) >> 10;
413
	$imgsize = GetImageSize ($image_Path.$zeile[$image_name]);
414
	echo "&nbsp;( $size KB $imgsize[0]x$imgsize[1])<BR>";
415
	}
416
?>
417
              <input type="radio" name="_<? echo $image_name ?>" value="1" <? if ($zeile[$image_name] == "") {echo "checked";}?>>
418
              kein Bild<br>
419
              <input type="radio" name="_<? echo $image_name ?>" value="2">
420
              <input type="File" name="<? echo $image_name ?>" size="17" maxlength="255" onFocus="this.form._<? echo $image_name ?>[<? if ($zeile[$image_name] != "") {echo "2";} else {echo "1";} ?>].checked=true;">
421
              <input type="hidden" name="<? echo $image_name ?>_Pfad" value="<? echo $image_Path ?>">
422
            </td>
423
          </tr>
424
          <tr>
425
            <td bgcolor="#000096" class="headline" width="17%" nowrap>Logo/Banner2:<br>
426
              rechts </td>
427
            <td colspan="3">
428
              <?
429
	$image_name="Banner2";
430
	$image_Path="../$site/images/";
431
	if ($zeile[$image_name] != "")
432
	{
433
?>
434
              <input type="radio" name="_<? echo $image_name ?>" value="<? echo $zeile[$image_name]; ?>" <? if ($zeile[$image_name] != "") {echo "checked";}?>>
435
              <?
436
	echo "$zeile[$image_name]";
437
	$size= filesize ($image_Path.$zeile[$image_name]) >> 10;
438
	$imgsize = GetImageSize ($image_Path.$zeile[$image_name]);
439
	echo "&nbsp;( $size KB $imgsize[0]x$imgsize[1])<BR>";
440
	}
441
?>
442
              <input type="radio" name="_<? echo $image_name ?>" value="1" <? if ($zeile[$image_name] == "") {echo "checked";}?>>
443
              kein Bild<br>
444
              <input type="radio" name="_<? echo $image_name ?>" value="2">
445
              <input type="File" name="<? echo $image_name ?>" size="17" maxlength="255" onFocus="this.form._<? echo $image_name ?>[<? if ($zeile[$image_name] != "") {echo "2";} else {echo "1";} ?>].checked=true;">
446
              <input type="hidden" name="<? echo $image_name ?>_Pfad" value="<? echo $image_Path ?>">
447
            </td>
448
          </tr>
449
          <tr>
450
            <td bgcolor="#000096" class="headline" width="17%" nowrap>erstellt:</td>
451
            <td colspan="3">am:
452
              <?
453
				$zeile[erstellt_am]=preg_split("/ /",$zeile[erstellt_am]);
454
				$datum=join(".",array_reverse(preg_split("/-/",$zeile[erstellt_am][0])));
455
				$zeit=$zeile[erstellt_am][1];
456
			?>
457
              <?
458
				echo $datum;
459
			?>
460
              um:
461
              <?
462
				echo $zeit;
463
			?>
464
              Uhr von:
465
              <? echo $zeile[erstellt_von] ?>
466
            </td>
467
          </tr>
468
          <tr>
469
            <td bgcolor="#000096" class="headline" width="17%" nowrap>letzte &Auml;nderung:</td>
470
            <td colspan="3">am:
471
              <?
472
				$zeile[letzte_Aenderung_am]=preg_split("/ /",$zeile[letzte_Aenderung_am]);
473
				$datum=join(".",array_reverse(preg_split("/-/",$zeile[letzte_Aenderung_am][0])));
474
				$zeit=$zeile[letzte_Aenderung_am][1];
475
			?>
476
              <?
477
				echo $datum;
478
			?>
479
              um:
480
              <?
481
				echo $zeit;
482
			?>
483
              Uhr von:
484
              <? echo $zeile[letzte_Aenderung_von] ?>
485
            </td>
486
          </tr>
487
          <tr bgcolor="#000099">
488
            <td colspan=4 align="right">
489
              <input type="hidden" name="domain" value="<? echo $site ?>">
490
              <input type="hidden" name="ID" value="<? echo $ID ?>">
491
              <input type="hidden" name="action" value="update">
492
              <input type="submit" value="OK">
493
              <input type="reset" name="Button" value="Zur&uuml;cksetzen">
494
            </td>
495
          </tr>
496
        </table>
497
        <?
498
	}
499
?> </td>
500
 
501
</tr>
502
</table>
503
</form>
504
</body>
505
</html>