Subversion-Projekte lars-tiefland.content-management

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

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