WebSVN – lars-tiefland.content-management – /trunk/Mail-Verteiler/Verteiler.php

<?

    $self = basename( $PHP_SELF );
    $DB = "Verteiler";
    require_once "../Online-Shop/connect2.php";
    if ( $action == "update" )
    {
        if ( !$ID )
        { // insert Dummy-Entry
            $query = "insert into $DB (erstellt_am,erstellt_von) VALUES (NOW(),'$PHP_AUTH_USER')";
            $result = mysql_query( $query ) or die( mysql_errno() . ": " .
                mysql_error() . "<hr>" . $query . "<hr>" );
            $ID = mysql_insert_id();
        }

        unset( $HTTP_POST_VARS[action] );
        unset( $HTTP_POST_VARS[ID] );

        foreach ( array_keys( $HTTP_POST_VARS ) as $elem )
        {
            if ( $elem[0] == "_" )
            {
                unset( $HTTP_POST_VARS[$elem] );
                $button = $$elem;
                $elem = substr( $elem, 1 );
                $Pfad = $HTTP_POST_VARS[$elem . "_Pfad"];
                unset( $HTTP_POST_VARS[$elem . "_Pfad"] );
                $image = $$elem;
                $image_name = $elem . "_name";
                $image_name = urlencode( $$image_name );
                switch ( $button )
                {
                    case 0:
                        break;
                    case 1:
                        $HTTP_POST_VARS[$elem] = '';
                        break;
                    case 2:
                        //$image_name=$ID."_".$image_name;
                        $image_name = $ID . strrchr( $image_name, "." );
                        $HTTP_POST_VARS[$elem] = $image_name;
                        copy( $image, $Pfad . $image_name );
                        break;
                    default:
                        break;
                }
            }
        }
        $names = array();
        foreach ( array_keys( $HTTP_POST_VARS ) as $elem )
        {
            array_push( $names, "$elem='$HTTP_POST_VARS[$elem]'" );
        }
        $query = "update $DB set " . join( $names, ', ' );
        $query = $query .
            ", letzte_Aenderung_am=NOW(), letzte_Aenderung_von='$PHP_AUTH_USER' where ID = '$ID'";
        echo "<br>" . $query;
        $result = mysql_query( $query ) or die( mysql_errno() . ": " .
            mysql_error() );
        header( "Location: " . $self );
    }

    if ( $action == "delete" )
    {
        if ( $ID )
        {
            $condition = array();
            foreach ( $ID as $elem )
            {
                array_push( $condition, " ID = '$elem'" );
            }
            $cond = join( " or ", $condition );
            $query = "DELETE FROM $DB WHERE $cond";
            $result = mysql_query( "$query" ) or die( mysql_errno() . ": " .
                mysql_error() );
            header( "Location: " . $self );
        }
    }
    if ( !$action )
    {
        $action = "select_edit";
    }
    if ( !$sort )
    {
        $sort = 'Name';
    }
?>
<html>
<head>
<title>Content-Management-System - Webagentur Niewerth</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel=stylesheet type="text/css" href="../buttons.css">
<style type="text/css">
<!--
a {  color: #<? echo $webs[font_color_rechts]
?>}
-->
</style>
<script language="JavaScript">
<!--

function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}

function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}

function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}
//-->
</script>
<meta name="description" content="Redaktionssystem">
<meta name="author" content="Webagentur Niewerth">
<meta name="robots" content="noindex">
</head>

<body bgcolor="#<? echo $webs[bgcolor_seite]
?>" 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
    $webs[font_color_rechts]
?>">
<form method="post" action="#" name="formname" enctype="multipart/form-data">
  <table width="662" border="0" cellspacing="0" cellpadding="0">
    <tr valign="top"> 
      <td width="585"> 
<!--  Auswahl Löschen START  -->
<?
    if ( $action == "delete" )
    {
        $query = "SELECT * FROM $DB ";
        $query = $query . "order by $sort";
        $result = mysql_query( $query ) or die( mysql_errno() . ": " .
            mysql_error() );
        if ( mysql_num_rows( $result ) == 0 )
        {
?>
        <p class="error"><font color="#000000">Es sind keine Daten eingetragen 
          !</font></p>
<p></p>
<?
        }
        else
        {
?>
        <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
          <tr> 
            <td colspan="2" class="headline" bgcolor="#<? echo $webs[bgcolor_links]
?>"><font color="#<?php echo $webs["font_color_links"]
?>">Verteiler:</font> 
              L&ouml;schen</td>
          </tr>
          <?
            while ( $zeile = mysql_fetch_array( $result ) )
            {
?>
          <tr> 
            <td bgcolor="#<? echo $webs[bgcolor_rechts]
?>"><a href="<? echo $self
?>?action=edit&ID=<? echo $zeile[ID];
?>"> 
              <? echo $zeile[Name]
?>
              </a>&nbsp;</td>
            <td width="5%" align="center"> 
              <input type="checkbox" name="ID[]" value="<? echo $zeile[ID]
?>">
            </td>
          </tr>
          <?
            }
?>
          <tr> 
            <td colspan="2" align="right" bgcolor="#<? echo $webs[bgcolor_links]
?>"> 
              <input type="hidden" name="action" value='delete'>
              <input type="submit" value="LÖSCHEN">
              <input type="reset" name="Button22" value="Zur&uuml;cksetzen">
            </td>
          </tr>
        </table>
        <?
        }
?>
        <?
    }
?>
        <!--  Auswahl Löschen ENDE  -->
        <!--  Auswahl SELECT_EDIT START  -->
        <?

    if ( $action == "select_edit" )
    {
        $query = "SELECT * FROM $DB ";
        $query = $query . "order by $sort";

        $result = mysql_query( $query ) or die( mysql_errno() . ": " .
            mysql_error() );
        if ( mysql_num_rows( $result ) == 0 )
        {
?>
        <p class="error"><font color="#000000">Es sind keine Daten eingetragen 
          !</font></p>
          <p></p>
        <?
        }
        else
        {
?>
        <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
          <tr bgcolor="#<? echo $webs[bgcolor_links]
?>"> 
            <td class="headline" colspan="2"><font color="#<?php echo $webs["font_color_links"]
?>">Verteiler: Bearbeiten</font></td>
          </tr>
          <?
            while ( $zeile = mysql_fetch_array( $result ) )
            {
?>
          <tr> 
            <td bgcolor="#<? echo $webs[bgcolor_rechts]
?>"><a href="<? echo $self
?>?action=edit&ID=<? echo $zeile[ID];
?>"> 
              <? echo $zeile[Name]
?>
              </a> &nbsp; </td>
          </tr>
          <?
            }
?>
          <tr bgcolor="#<? echo $webs[bgcolor_links]
?>"> 
            <td colspan="2"> 
              <div align="right">&nbsp; 
                <input type="hidden" name="action" value='edit'>
              </div>
            </td>
          </tr>
        </table>
 <?
        }
?> 
        <?
    }
?> 
<!--  Auswahl SELECT_EDIT ENDE  -->

<?
    if ( $action == "edit" )
    {
        if ( $ID )
        {
            $result = mysql_query( "SELECT * FROM $DB where ID = '$ID' " ) or
                die( mysql_errno() . ": " . mysql_error() );
            $zeile = mysql_fetch_array( $result );
        }
        $zeile[von] = join( ".", array_reverse( preg_split( "/-/", $zeile[von] ) ) );
        $zeile[bis] = join( ".", array_reverse( preg_split( "/-/", $zeile[bis] ) ) );
        $zeile[Abmeldedatum] = join( ".", array_reverse( preg_split( "/-/",
            $zeile[Abmeldedatum] ) ) );
?> 
            <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
          <tr> 
            <td colspan="2" class="headline" bgcolor="#<? echo $webs[bgcolor_links]
?>"><font color="#<?php echo $webs["font_color_links"]
?>">Verteiler: 
              <?
        if ( $ID )
        {
?>
              Bearbeiten 
              <?
        }
        else
        {
?>              Neueintrag 
              <?
        }
?>
          </font>  </td>
          </tr>
          <tr> 
            <td bgcolor="#<? echo $webs[bgcolor_links]
?>" class="headline" valign="middle" width="20%"><font color="#<?php echo $webs["font_color_links"]
?>">Verteilername:</font></td>
            <td bgcolor="#<? echo $webs[bgcolor_rechts]
?>"> 
              <input type="text" name="Name" value="<? echo $zeile[Name]
?>">
            </td>
          </tr>
          <tr> 
            <td bgcolor="#<? echo $webs[bgcolor_links]
?>" class="headline" valign="middle" width="20%"><font color="#<?php echo $webs["font_color_links"]
?>">Absender:</font></td>
            <td bgcolor="#<? echo $webs[bgcolor_rechts]
?>"> 
              <input type="text" name="Absender" value="<? echo $zeile[Absender]
?>">
            </td>
          </tr>
          <tr> 
            <td bgcolor="#<? echo $webs[bgcolor_links]
?>" class="headline" valign="middle" width="20%"><font color="#<?php echo $webs["font_color_links"]
?>">Betreff:</font></td>
            <td bgcolor="#<? echo $webs[bgcolor_rechts]
?>"> 
              <input type="text" name="Betreff" value="<? echo $zeile[Betreff]
?>">
            </td>
          </tr>
          <tr> 
            <td bgcolor="#<? echo $webs[bgcolor_links]
?>" class="headline" valign="top" width="20%"><font color="#<?php echo $webs["font_color_links"]
?>">Begr&uuml;ssung:</font></td>
            <td bgcolor="#<? echo $webs[bgcolor_rechts]
?>"> 
              <textarea name="Begruessung" cols="50" rows="5"><? echo $zeile[Begruessung]
?></textarea>
            </td>
          </tr>
          <tr> 
            <td bgcolor="#<? echo $webs[bgcolor_links]
?>" class="headline" valign="top" width="20%"><font color="#<?php echo $webs["font_color_links"]
?>">Schlusstext:</font></td>
            <td bgcolor="#<? echo $webs[bgcolor_rechts]
?>"> 
              <textarea name="Schlusstext" cols="50" rows="5"><? echo $zeile[Schlusstext]
?></textarea>
            </td>
          </tr>
          <?
?>
          <tr> 
            <td bgcolor="#<? echo $webs[bgcolor_links]
?>" class="headline" valign="top" width="20%"><font color="#<?php echo $webs["font_color_links"]
?>">Template URL:       </font>     </td>
            <td bgcolor="#<? echo $webs[bgcolor_links]
?>"><input name="Template_URL" type="text" value="<? echo $zeile[Template_URL]
?>"></td>
          </tr>
<?

        if ( isset( $web_rechte["mail_verteiler"]["verteiler"]["smtp_server"] ) )
        {
            if ( $web_rechte["mail_verteiler"]["verteiler"]["smtp_server"] )
            {
?>
          <tr> 
            <td bgcolor="#<? echo $webs[bgcolor_links]
?>" class="headline" valign="top" width="20%"><font color="#<?php echo $webs["font_color_links"]
?>">SMTP Server:    </font>        </td>
            <td bgcolor="#<? echo $webs[bgcolor_links]
?>"><input name="smtp_server" type="text" value="<? echo $zeile[smtp_server]
?>"></td>
          </tr>
<?

            }
        }
?>

<?

        if ( isset( $web_rechte["mail_verteiler"]["verteiler"]["smtp_user"] ) )
        {
            if ( $web_rechte["mail_verteiler"]["verteiler"]["smtp_user"] )
            {
?>
          <tr> 
            <td bgcolor="#<? echo $webs[bgcolor_links]
?>" class="headline" valign="top" width="20%"><font color="#<?php echo $webs["font_color_links"]
?>">SMTP User:      </font>      </td>
            <td bgcolor="#<? echo $webs[bgcolor_links]
?>"><input name="smtp_user" type="text" value="<? echo $zeile[smtp_user]
?>"></td>
          </tr>
<?

            }
        }
?>


<?

        if ( isset( $web_rechte["mail_verteiler"]["verteiler"]["smtp_pass"] ) )
        {
            if ( $web_rechte["mail_verteiler"]["verteiler"]["smtp_pass"] )
            {
?>
          <tr> 
            <td bgcolor="#<? echo $webs[bgcolor_links]
?>" class="headline" valign="top" width="20%"><font color="#<?php echo $webs["font_color_links"]
?>">SMTP Pass:     </font>       </td>
            <td bgcolor="#<? echo $webs[bgcolor_links]
?>"><input name="smtp_pass" type="password" value="<? echo $zeile[smtp_pass]
?>"></td>
          </tr>
<?

            }
        }
?>


<?

        if ( isset( $web_rechte["mail_verteiler"]["verteiler"]["smtp_authed"] ) )
        {
            if ( $web_rechte["mail_verteiler"]["verteiler"]["smtp_authed"] )
            {
?>
          <tr> 
            <td bgcolor="#<? echo $webs[bgcolor_links]
?>" class="headline" valign="top" width="20%"><font color="#<?php echo $webs["font_color_links"]
?>">SMTP Authentifizierung:    </font>        </td>
            <td bgcolor="#<? echo $webs[bgcolor_links]
?>">
                        <input type="hidden" name="smtp_authed" value="0">
                        <input name="smtp_authed" type="checkbox" value="1" <?= ( $zeile["smtp_authed"] ) ?
'checked="checked"' : "";
?>></td>
          </tr>
<?

            }
        }
?>

          <tr> 
            <td align="right" colspan="2" bgcolor="#<? echo $webs[bgcolor_links]
?>"> 
              <input type="hidden" name="ID" value="<? echo $ID
?>">
              <input type="hidden" name="action" value="update">
              <input type="submit" value="OK">
              <input type="reset" name="Button" value="Zur&uuml;cksetzen">
            </td>
          </tr>
        </table>
        <?
    }
?> </td>
      <td width="77" align="right"> 
        <table width="67" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#FFFFFF" bordercolordark="#999999">
                <tr> 
            <td class="frame"><a href="<? echo $self
?>?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>
                </tr>
                <tr> 
            <td class="frame"><a href="<? echo $self
?>?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>
                </tr>
                <tr> 
            <td class="frame"><a href="<? echo $self
?>?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>
                </tr>
                </table>
      </td>
</tr>
</table>
</form>
</body>
Subversion-Projekte lars-tiefland.content-management

(root)/trunk/Mail-Verteiler/Verteiler.php – Revision 1
