Subversion-Projekte lars-tiefland.content-management

Revision

Blame | Letzte Änderung | Log anzeigen | RSS feed

<?
    $self = basename( $PHP_SELF );
    $DB = "Aktionen";
    define( "modul_name", "online_shop" );
    define( "tool_name", "aktion" );

    require_once  "connect2.php";
    require_once "language_pack.php";

    if ( $action == "update" )
    {
        if ( !$ID )
        { // insert Dummy-Entry
            $query = "insert into $DB (ID) VALUES (0)";
            $result = mysql_query( $query ) or die( mysql_errno() . ": " .
                mysql_error() . "<hr>" . $query . "<hr>" );
            $ID = mysql_insert_id();
        }

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

        $_POST[von] = human2date( $_POST[von] );
        $_POST[bis] = human2date( $_POST[bis] );

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

    if ( $action == "delete" )
    {
        if ( $ID )
        {
            $condition = array();
            $condition2 = array();
            foreach ( $ID as $elem )
            {
                array_push( $condition, " ID = '$elem'" );
                array_push( $condition2, " Aktionen = '$elem'" );
            }
            $cond = join( " or ", $condition );
            $cond2 = join( " or ", $condition2 );
            $query = "DELETE FROM $DB WHERE $cond";
            $query2 = "DELETE FROM artikel_2_Aktionen WHERE $cond2";
            $result = mysql_query( $query ) or die( mysql_errno() . ": " .
                mysql_error() );
            $result = mysql_query( $query2 ) or die( mysql_errno() . ": " .
                mysql_error() );
            header( "Location: " . $self );
        }
    }
    if ( !$action )
    {
        $action = "select_edit";
    }
    if ( !$sort )
    {
        if ( $web_rechte[modul_name][tool_name][Rang] != "" )
        {
            $sort = $web_rechte[modul_name][tool_name][Rang];
        }
        else
        {
            $sort = 'headline';
        }
    }
?>
<html>
<head>
<title><? echo $webs[kunde_bezeichnung]
?>: Redaktionssystem</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel=stylesheet type="text/css" href="redaktion.css">

<style type="text/css">
{
    font-family: Arial, Helvetica, sans-serif; font-size: 10pt;
<? if ( $webs[font_color_seite] )
    {
?>color:                #<? echo $webs[font_color_seite]
?>;<? }
?>
<? if ( $webs[bgcolor_seite] )
    {
?>background-color:    #<? echo $webs[bgcolor_seite]
?>;<? }
?>
<? if ( $webs[hintergrundbild] )
    {
?>background-image: url(../images/hintergrundbild/<? echo $webs[hintergrundbild]
?>);<? }
?>
}

.links
{
font-size: 10pt;
<? if ( $webs[font_color_links] )
    {
?>color:                #<? echo $webs[font_color_links]
?>;<? }
?>
<? if ( $webs[bgcolor_links] )
    {
?>background-color:    #<? echo $webs[bgcolor_links]
?>;<? }
?>
}

.rechts
{
font-size: 10pt;
<? if ( $webs[font_color_rechts] )
    {
?>color:                #<? echo $webs[font_color_rechts]
?>;<? }
?>
<? if ( $webs[bgcolor_rechts] )
    {
?>background-color:    #<? echo $webs[bgcolor_rechts]
?>;<? }
?>
}

A:link {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #<? echo
    $webs[font_color_rechts]
?>}
A:visited {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #<? echo
    $webs[font_color_rechts]
?>}
A:active {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #<? echo
    $webs[font_color_rechts]
?>}
A:hover {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #<? echo
    $webs[font_color_rechts]
?>}
</style>
</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" text="#000000" onLoad="MM_preloadImages('../images/navigation/bt_bearbeiten_f2.gif','../images/navigation/bt_delete_f2.gif','../images/navigation/bt_neu_f2.gif','../images/navigation/bt_sonderkasten_f2.gif')">
<form method="post" action="#" name="formname" enctype="multipart/form-data">
<table width="595" border="0" cellspacing="0" cellpadding="0">
    <tr valign="top"> 
      <td width="508"> 
<?
    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 )
        {
?>
            <font color="#<? echo $webs[font_color_seite]
?>"><b>Es sind keine Daten eingetragen !</b></font>
<?
        }
        else
        {
?>
            <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
                <tr bgcolor="#<? echo $webs[bgcolor_links]
?>"> 
                    
            <td colspan="2"><font color="#<? echo $webs[font_color_links]
?>"><b>Aktion: 
              L&ouml;schen</b></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[headline]
?></a>&nbsp;&nbsp;</td>
                    <td width="5%" align="center" bgcolor="#<? echo $webs[bgcolor_rechts]
?>"><input type="checkbox" name="ID[]" value="<? echo $zeile[ID]
?>"></td>
                </tr>
                <?
            }
?>
                <tr bgcolor="#<? echo $webs[bgcolor_links]
?>"> 
                    <td colspan="2" align="right"> 
                        <input type="hidden" name="action" value='delete'>
                        <input type="submit" value="LÖSCHEN">
                        <input type="reset" 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 )
        {
?>
            <font color="#<? echo $webs[font_color_seite]
?>"><b>Es sind keine Daten eingetragen !</b></font>
<?
        }
        else
        {
?>
        <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
          <tr bgcolor="#<? echo $webs[bgcolor_links]
?>"> 
            <td colspan="2"><font color="#<? echo $webs[font_color_links]
?>"><b>Aktion: Bearbeiten</b></font></td>
          </tr>
          <?
            while ( $zeile = mysql_fetch_array( $result ) )
            {
?>
          <tr bgcolor="#<? echo $webs[bgcolor_rechts]
?>"> 
            <td><a href="<? echo $self
?>?action=edit&ID=<? echo $zeile[ID];
?>">[&gt;&gt;]</a> 
              <a href="<? echo $self
?>?action=edit&ID=<? echo $zeile[ID];
?>"> 
              <? echo $zeile[headline]
?>
              &nbsp;von&nbsp; 
              <? echo date2human( $zeile[von] )
?>
              &nbsp;bis&nbsp; 
              <? echo date2human( $zeile[bis] )
?>
              </a> 
              <?php
                if ( $zeile["shops_id"] )
                {
                    $query = "select Name from shops where ID = " . $zeile["shops_ID"];
                    $res = mysql_query( $query ) or die( mysql_errno() .
                        ": " . mysql_error() . "<hr>" . $query );
                    $r = mysql_fetch_assoc( $res );
                    echo " - " . $r["Name"];
                }
?>
              </td>
          </tr>
          <?
            }
?>
          <tr bgcolor="#<? echo $webs[bgcolor_links]
?>"> 
            <td colspan="2"> 
              &nbsp;<input type="hidden" name="action" value='edit'>
            </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 );
        }
?> 
<table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
    <tr bgcolor="#<? echo $webs[bgcolor_links]
?>"> 
            <td colspan="3"><font color="#<? echo $webs[font_color_links]
?>"><b>Aktion: 
              <?
        if ( $ID )
        {
?>
              Bearbeiten 
              <?
        }
        else
        {
?>
              Neueintrag 
              <?
        }
?>
              </b></font></td>
    </tr>
<?
        $Feld = "headline";
        if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
        {
?>
    <tr> 
            <td bgcolor="#<? echo $webs[bgcolor_links]
?>" valign="middle" width="13%"> 
              <font color="#<? echo $webs[font_color_links]
?>"><b> 
              <?
            if ( $web_rechte[modul_name][tool_name][$Feld] )
            {
                echo $web_rechte[modul_name][tool_name][$Feld];
            }
            else
            {
?>
              &Uuml;berschrift 
              <?
            }
?>
              </b></font> </td>
        <td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts]
?>"> 
            <?php
            // Markus
            $colSize = strlen( $zeile['headline'] ) > 0 ? 75 : 40;
?>
            <input name="headline" type="text" value="<? echo $zeile[headline]
?>" size="<?= $colSize
?>" >
        </td>
    </tr>
<?
        }
?>
          <?
        $bild_nr = 1;
        $Feld = "bild$bild_nr";
        if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
        {
?>
          <tr> 
            <td bgcolor="#<? echo $webs[bgcolor_links]
?>" valign="top" width="21%"> 
              <font color="#<? echo $webs[font_color_links]
?>"><b> 
              <?
            if ( $web_rechte[modul_name][tool_name][$Feld] )
            {
                echo $web_rechte[modul_name][tool_name][$Feld];
            }
            else
            {
?>
              Bild 
              <? echo $bild_nr;
?>
              <?
            }
?>
              </b></font> </td>
            <td bgcolor="#<? echo $webs[bgcolor_rechts]
?>" width="79%"> 
              <table border="0" width="100%" cellspacing="0" cellpadding="0">
                <tr> 
                  <td width="55%" nowrap colspan="2"> <font color="#<? echo
            $webs[font_color_rechts]
?>"> 
                    <?
            $image_name = "bild_" . $bild_nr . "_url";
            $image_Path = "/images/aktionen/" . $bild_nr . "/";
            $image_Path = $webs[verzeichnis] . $image_Path;
?>
                    <input type="hidden" name="<? echo $image_name
?>_Pfad" value="<? echo $image_Path
?>">
                    <?
            if ( $zeile[$image_name] != "" )
            {
?>
                    <input type="radio" name="_<? echo $image_name
?>" value="0" checked>
                    <a href="http://www.<? echo $site . "/images/aktionen/" .
                $bild_nr . "/" . $zeile[$image_name]
?>" target="blank"> 
                    <? echo $zeile[$image_name];
?>
                    </a> 
                    <?
                $size = filesize( $image_Path . $zeile[$image_name] ) >> 10;
                $imgsize = GetImageSize( $image_Path . $zeile[$image_name] );
                echo "&nbsp;( $size KB $imgsize[0]x$imgsize[1])<BR>";
            }
?>
                    <input type="radio" name="_<? echo $image_name
?>" value="1" <? if ( $zeile[$image_name] == "" )
            {
                echo "checked";
            }
?>>
                    kein Bild<br>
                    <input type="radio" name="_<? echo $image_name
?>" value="2">
                    <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;">
                    </font> </td>
                  <td width="45%" nowrap align="center">  
                    <? if ( $zeile[$image_name] != "" )
            {
?>
                    <a href="http://www.<? echo $site . "/images/aktionen/" .
                $bild_nr . "/" . $zeile[$image_name]
?>" target="blank"><img height="60" src="http://www.<? echo $site .
                "/images/aktionen/" . $bild_nr . "/" . $zeile[$image_name]
?>" border="0"></a> 
                    <? }
?>
                  </td>
                </tr>
              </table>
            </td>
          </tr>
          <?
        }
?>
          <?
        $Feld = "bild1_text";
        if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
        {
?>
          <tr> 
            <td bgcolor="#<? echo $webs[bgcolor_links]
?>" class="headline" width="20%"><font color="#<? echo $webs[font_color_links]
?>"><b> 
              <?
            if ( $web_rechte[modul_name][tool_name][$Feld] )
            {
                echo $web_rechte[modul_name][tool_name][$Feld];
            }
            else
            {
?>
              Bildtext:
              <?
            }
?>
              </b></font></td>
            <td bgcolor="#<? echo $webs[bgcolor_rechts]
?>"> 
              <input type="text" name="bildunterschrift1" size="40" value="<? echo
            htmlentities( $zeile[bildunterschrift1] )
?>" maxlength="255">
            </td>
          </tr>
          <?
        }
?>

<?php
        $Feld = "bild_link_1";
        if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
        {
?>
<tr> 
            <td bgcolor="#<? echo $webs[bgcolor_links]
?>" width="15%">
            <font color="#<? echo $webs[font_color_links]
?>"><b>
<?
            if ( $web_rechte[modul_name][tool_name][$Feld] )
            {
                echo $web_rechte[modul_name][tool_name][$Feld];
            }
            else
            {
?>
            Bildunterschrift:
<?php
            }
?>
            </b></font>
            </td>
            <td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts]
?>">
              <input type="text" name="bild_link_1" value="<?= $zeile['bild_link_1']
?>" size="40" />
            </td>
          </tr>
<?
        }
?>

          <?
        $Feld = "bild_pos1";
        if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
        {
?>
          <tr> 
            <td bgcolor="#<? echo $webs[bgcolor_links]
?>" class="headline" width="20%"><font color="#<? echo $webs[font_color_links]
?>"><b> 
              Position:</b></font></td>
            <td bgcolor="#<? echo $webs[bgcolor_rechts]
?>"> 
              <? $kats = explode( ";", $web_rechte[modul_name][tool_name][bild_pos1] )
?>
              <select name="bild_pos1">
                <?
            foreach ( $kats as $elem )
            {
?>
                <option <? if ( $zeile[bild_pos1] == $elem )
                {
?>selected<? }
?>> 
                <? echo $elem
?>
                </option>
                <?
            }
?>
              </select>
            </td>
          </tr>
          <?
        }
?>
<?
        $bild_nr = 2;
        $Feld = "bild$bild_nr";
        if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
        {
?>
          <tr> 
            <td bgcolor="#<? echo $webs[bgcolor_links]
?>" valign="top" width="21%"> 
              <font color="#<? echo $webs[font_color_links]
?>"><b> 
              <?
            if ( $web_rechte[modul_name][tool_name][$Feld] )
            {
                echo $web_rechte[modul_name][tool_name][$Feld];
            }
            else
            {
?>
              Bild 
              <? echo $bild_nr;
?>
              <?
            }
?>
              </b></font> </td>
            <td bgcolor="#<? echo $webs[bgcolor_rechts]
?>" width="79%"> 
              <table border="0" width="100%" cellspacing="0" cellpadding="0">
                <tr> 
                  <td width="55%" nowrap colspan="2"> <font color="#<? echo
            $webs[font_color_rechts]
?>"> 
                    <?
            $image_name = "bild_" . $bild_nr . "_url";
            $image_Path = "/images/aktionen/" . $bild_nr . "/";
            $image_Path = $webs[verzeichnis] . $image_Path;
?>
                    <input type="hidden" name="<? echo $image_name
?>_Pfad" value="<? echo $image_Path
?>">
                    <?
            if ( $zeile[$image_name] != "" )
            {
?>
                    <input type="radio" name="_<? echo $image_name
?>" value="0" checked>
                    <a href="http://www.<? echo $site . "/images/aktionen/" .
                $bild_nr . "/" . $zeile[$image_name]
?>" target="blank"> 
                    <? echo $zeile[$image_name];
?>
                    </a> 
                    <?
                $size = filesize( $image_Path . $zeile[$image_name] ) >> 10;
                $imgsize = GetImageSize( $image_Path . $zeile[$image_name] );
                echo "&nbsp;( $size KB $imgsize[0]x$imgsize[1])<BR>";
            }
?>
                    <input type="radio" name="_<? echo $image_name
?>" value="1" <? if ( $zeile[$image_name] == "" )
            {
                echo "checked";
            }
?>>
                    kein Bild<br>
                    <input type="radio" name="_<? echo $image_name
?>" value="2">
                    <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;">
                    </font> </td>
                  <td width="45%" nowrap align="center">  
                    <? if ( $zeile[$image_name] != "" )
            {
?>
                    <a href="http://www.<? echo $site . "/images/aktionen/" .
                $bild_nr . "/" . $zeile[$image_name]
?>" target="blank"><img height="60" src="http://www.<? echo $site .
                "/images/aktionen/" . $bild_nr . "/" . $zeile[$image_name]
?>" border="0"></a> 
                    <? }
?>
                  </td>
                </tr>
              </table>
            </td>
          </tr>
          <?
        }
?>
          <?
        $Feld = "shops_ID";
        if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
        {

            // WICHTIG - aber nur, wenn das Recht gegeben ist
            if ( $ID )
            {
                $query = "select shops_ID from Aktionen where ID = " . $ID;
                $result = mysql_query( $query ) or die( mysql_errno() . ": " .
                    mysql_error() . "<hr>" . $query );
                $r = mysql_fetch_array( $result );
                $shops_ID = $r['shops_ID'];
            }
?>
          <tr> 
            <td bgcolor="#<? echo $webs[bgcolor_links]
?>" class="headline" width="20%"><font color="#<? echo $webs[font_color_links]
?>"><b> 
            <?
            if ( $web_rechte[modul_name][tool_name][$Feld] )
            {
                echo $web_rechte[modul_name][tool_name][$Feld];
            }
            else
            {
?>
Shop:
<?
            }
?>
              </b></font></td>
            <td bgcolor="#<? echo $webs[bgcolor_rechts]
?>"> 
            <?
            // SHOPS_ID

            if ( isset( $ID ) )
            {
                //Bearbeiten
                $query = "select Name from shops where ID = " . $shops_ID;
                $result = mysql_query( $query ) or die( mysql_errno() . ": " .
                    mysql_error() . "<hr>" . $query );
                $r = mysql_fetch_array( $result );
                echo $shops_ID . ' - ' . $r['Name'];
            }
            else
            {
                //Neueintrag:
                $query = "select * from shops";
                $result = mysql_query( $query ) or die( mysql_errno() . ": " .
                    mysql_error() . "<hr>" . $query );
                echo '<select name="shops_ID"><option></option>';
                while ( $r = mysql_fetch_array( $result ) )
                {
                    echo '<option value="' . $r['ID'] . '">' . $r['Name'] .
                        '</option>';
                }
                echo '</select>';
            }


            // SHOPS_ID

?>    
            </td>
          </tr>
          <?
        }
?>
          <?
        $Feld = "Template";
        if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) and isset( $ID ) )
        {
?>
          <tr> 
            <td bgcolor="#<? echo $webs[bgcolor_links]
?>" class="headline" width="20%"><font color="#<? echo $webs[font_color_links]
?>"><b> 
              <?
            if ( $web_rechte[modul_name][tool_name][$Feld] )
            {
                echo $web_rechte[modul_name][tool_name][$Feld];
            }
            else
            {
?>
              Template: 
              <?
            }
?>
              </b></font></td>
            <td bgcolor="#<? echo $webs[bgcolor_rechts]
?>"> 
              <select name="templates_ID">
                <option value=""></option>
                <?
            // TEMPLATES
            $query = "select templates_ID from Aktionen where ID = " . $ID;
            $result = mysql_query( $query ) or die( mysql_errno() . ": " .
                mysql_error() . "<hr>" . $query );
            $r = mysql_fetch_array( $result );
            $aktuelles_template = $r['templates_ID'];
            $query = "select * from templates where shops_ID = " . $shops_ID .
                " and Typ = 'Aktionen'";
            $result = mysql_query( $query ) or die( mysql_errno() . ": " .
                mysql_error() . "<hr>" . $query );
            while ( $r = mysql_fetch_array( $result ) )
            {
                echo '<option value="' . $r['ID'] . '" ';
                if ( $aktuelles_template == $r['ID'] )
                {
                    echo "selected";
                }
                echo '>' . $r['Name'] . '</option>';
            }

            // TEMPLATES

?>
              </select>
            </td>
          </tr>
          <?
        }
?>
<?
        if ( $language_pack )
        {
?>
    <tr> 
            <td bgcolor="#<? echo $webs[bgcolor_links]
?>" valign="middle" width="16%"> 
              <font color="#<? echo $webs[font_color_links]
?>"><b> 
              <?
            if ( $web_rechte[modul_name][tool_name][$Feld] )
            {
                echo $web_rechte[modul_name][tool_name][$Feld];
            }
            else
            {
?>
              Sprache: 
              <?
            }
?>
              </b></font> </td>
            <td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts]
?>"> 
              <?
            // LANGUAGE

            if ( isset( $ID ) )
            {
                /*                $query = "select Language from shops where ID = ".$shops_ID;
                $result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query);
                $r = mysql_fetch_array($result);
                */
                echo $zeile['Language'];
            }
            else
            {
                echo '<select name="Language"><option value=""></option>';
                for ( $i = 0; $i < count( $language_pack ); $i++ )
                {
                    echo '<option value="' . $language_pack[$i][0] . '">' .
                        $language_pack[$i][2] . '</option>';
                }
            }

            // LANGUAGE

?>


            </td>
    </tr>
<?
        }
?>
<?
        $Feld = "text";
        if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
        {
?>
    <tr> 
        <td bgcolor="#<? echo $webs[bgcolor_links]
?>" valign="top" width="13%"> 
            <font color="#<? echo $webs[font_color_links]
?>"><b> 
<?
            if ( $web_rechte[modul_name][tool_name][$Feld] )
            {
                echo $web_rechte[modul_name][tool_name][$Feld];
            }
            else
            {
?>
Text 
<?
            }
?>
            </b></font>
        </td>
        <td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts]
?>"> 
        <?php
            // Markus
            $rows = explode( "<br />", nl2br( $zeile['text'] ) );
            $colSize = strlen( $zeile['text'] ) > 0 ? 80 : 40;
            $rowSize = sizeof( $rows ) > 4 ? sizeof( $rows ) : 4;
?>
            <textarea name="text" cols="<?= $colSize
?>" rows="<?= $rowSize
?>"><? echo $zeile[text]
?></textarea>
<!-- Einbindung TinyMCE -->
<script type="text/javascript" src="/js/jquery-1.6.4.min.js"></script>
<script type="text/javascript" src="../tiny_mce/tiny_mce.js"></script>
<script type="text/javascript">
tinyMCE.init({
    // General options
    mode : "exact",
    elements: "messageHTML",
    theme : "advanced",
    language: "de",
    plugins : "safari,spellchecker,pagebreak,style,layer,table,save,advhr,advimage,advlink,emotions,iespell,inlinepopups,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template",

    // Theme options
    theme_advanced_buttons1 : "bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,justifyfull,|,styleselect,formatselect,fontselect,fontsizeselect",
    theme_advanced_buttons2 : "cut,copy,paste,pastetext,pasteword,|,search,replace,|,bullist,numlist,|,outdent,indent,blockquote,|,undo,redo,|,link,unlink,anchor,image,cleanup,help,code,|,insertdate,inserttime,preview,|,forecolor,backcolor",
    theme_advanced_buttons3 : "tablecontrols,|,hr,removeformat,visualaid,|,sub,sup,|,charmap,emotions,iespell,media,advhr,|,print,|,ltr,rtl,|,fullscreen",
    theme_advanced_buttons4 : "insertlayer,moveforward,movebackward,absolute,|,styleprops,spellchecker,|,cite,abbr,acronym,del,ins,attribs,|,visualchars,nonbreaking,template,blockquote,pagebreak,|,insertfile,insertimage",
    theme_advanced_toolbar_location : "top",
    theme_advanced_toolbar_align : "left",
    theme_advanced_statusbar_location : "bottom",
    theme_advanced_resizing : true,

    // Example content CSS (should be your site CSS)
    content_css : "css/example.css",

    // Drop lists for link/image/media/template dialogs
    template_external_list_url : "js/template_list.js",
    external_link_list_url : "js/link_list.js",
    external_image_list_url : "js/image_list.js",
    media_external_list_url : "js/media_list.js",

    // Replace values for the template plugin
    template_replace_values : {
        username : "Some User",
        staffid : "991234"
    }
});
</script>
        </td>
    </tr>
<?
        }
?>
          <?
        $Feld = "Kategorie";
        if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
        {
?>
          <tr> 
            <td bgcolor="#<? echo $webs[bgcolor_links]
?>" class="headline" width="20%"><font color="#<? echo $webs[font_color_links]
?>"><b> 
<?
            $kats = explode( ";", $web_rechte[modul_name][tool_name][$Feld] );
            $web_rechte[modul_name][tool_name][$Feld] = array_shift( $kats );
?>
              <?
            if ( $web_rechte[modul_name][tool_name][$Feld] )
            {
                echo $web_rechte[modul_name][tool_name][$Feld];
            }
            else
            {
?>
              Kategorie: 
              <?
            }
?>
              </b></font></td>
            <td bgcolor="#<? echo $webs[bgcolor_rechts]
?>"> 
              <select name="Kategorie">
                <?
            foreach ( $kats as $elem )
            {
?>
                <option <? if ( $zeile[Kategorie] == $elem )
                {
?>selected<? }
?>> 
                <? echo $elem
?>
                </option>
                <?
            }
?>
              </select>
            </td>
          </tr>
          <?
        }
?>
          <?
        $Feld = "html_alternative";
        if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
        {
?>
          <tr> 
            <td width="20%" valign="top" bgcolor="#<? echo $webs[bgcolor_links]
?>" class="headline"><font color="#<? echo $webs[font_color_links]
?>"><b> 
<?
            $kats = explode( ";", $web_rechte[modul_name][tool_name][$Feld] );
            $web_rechte[modul_name][tool_name][$Feld] = array_shift( $kats );
?>
<?
            if ( $web_rechte[modul_name][tool_name][$Feld] )
            {
                echo $web_rechte[modul_name][tool_name][$Feld];
            }
            else
            {
?>              
Freie html-Seite: 
              <?
            }
?>
              <br>
              <input name="html_seite_schalter" type="radio" value="1"<? if ( $zeile[html_seite_schalter] ==
            '1' )
            {
?> checked<? }
?>>
              Ein<br>
              <input name="html_seite_schalter" type="radio" value="0"<? if ( $zeile[html_seite_schalter] ==
            '0' )
            {
?> checked<? }
?>>
Aus</b></font></td>
            <td bgcolor="#<? echo $webs[bgcolor_rechts]
?>"> 
        <textarea id=messageHTML name="html_seite" cols="100" rows="10" wrap="OFF">
        <p><?= nl2br( $zeile[html_seite] )
?></p>
        </textarea>
      </td>
          </tr>
          <?
        }
?>
<?
        $Feld = "zeitraum";
        if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
        {
?>
<tr> 
            <td bgcolor="#<? echo $webs[bgcolor_links]
?>" width="15%">
            <font color="#<? echo $webs[font_color_links]
?>"><b>
<?
            if ( $web_rechte[modul_name][tool_name][$Feld] )
            {
                echo $web_rechte[modul_name][tool_name][$Feld];
            }
            else
            {
?>
            G&uuml;ltigkeit
<?
            }
?>
            </b></font>
            </td>
            <script language="JavaScript" src="../checkDate.js"></script>
            <td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts]
?>">von: 
              <input type="text" name="von" size="10" maxlength="12" onFocus="current_value=this.value;if (this.value=='') {this.value=today()};this.select();" onChange="this.value=check_Date(this.value)" value="<? echo
            date2human( $zeile[von] )
?>">
              &nbsp;bis:
<input type="text" name="bis" size="10" maxlength="12" onFocus="current_value=this.value;if (this.value=='') {this.value=today()};this.select();" onChange="this.value=check_Date(this.value)" value="<? echo
            date2human( $zeile[bis] )
?>">
            </td>
          </tr>
<?
        }
?>

    <tr bgcolor="#<? echo $webs[bgcolor_links]
?>"> 
        <td align="right" colspan="3"> 
            <input type="hidden" name="ID" value="<? echo $ID
?>">
            <input type="hidden" name="action" value="update">
<?
        $Feld = "artikel";
        if ( ( $ID ) and ( isset( $user_rechte[modul_name][tool_name][$Feld] ) ) )
        {
?>
<input type="button" value="<? if ( $web_rechte[modul_name][tool_name][$Feld] )
            {
                echo $web_rechte[modul_name][tool_name][$Feld];
            }
            else
            {
?>Werte bearbeiten<? }
?>" onClick="location.href='aktions_tool.php?Aktion=<? echo $ID
?><? if ( $language_pack )
            {
?>&language=<? echo $zeile[Language];
            }
?>'">
<?
        }
?>
              <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><a href="<? echo $self
?>?action=edit" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('new','','../images/navigation/bt_neu_f2.gif',1)"><img name="new" border="0" src="../images/navigation/bt_neu.gif" width="67" height="40" alt="Neueintrag"></a></td>
          </tr>
          <tr> 
            <td><a href="<? echo $self
?>?action=select_edit" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image4','','../images/navigation/bt_bearbeiten_f2.gif',1)"><img name="Image4" border="0" src="../images/navigation/bt_bearbeiten.gif" width="67" height="40"></a></td>
          </tr>
          <tr> 
            <td><a href="<? echo $self
?>?action=delete" 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>
          </tr>
        <?php

    if ( isset( $shops_ID ) )
    {
        //echo '<a href="sonderkasten.php?shop='.$shops_ID.'">Sonderkasten</a>';

?>
          <tr> 
            <td><a href="sonderkasten.php?shop=<?= $shops_ID
?><? if ( $language_pack )
        {
?>&language=<?= $zeile["Language"];
        }
?>" target="tool" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image145','','../images/navigation/bt_sonderkasten_f2.gif',0)"><img name="Image145" border="0" width="67" height="40" src="../images/navigation/bt_sonderkasten.gif"  alt="Sonderkasten"></a></td>
          </tr>
        <?php
    }
?>
        </table>
      </td>
</tr>
</table>
</form>
</body>
</html>