WebSVN – lars-tiefland.content-management – /trunk/news/includes/editForm.php

  <?php
    if ( $ID )
    {
        $result = mysql_query( "SELECT * FROM $tab where ID = '$ID'" ) or
            die( mysql_errno() . ": " . mysql_error() );
        $zeile = mysql_fetch_array( $result );

        // Versuchen den Artikel in language nachzuladen
        $query_lang = "select * from $tab where language='$_SESSION[language]' and ID = $ID";

        if ( $result_lang = mysql_query( $query_lang ) )
        {
            if ( $zeile_lang = mysql_fetch_array( $result_lang ) )
            {
                $zeile = $zeile_lang;
            }
        }
    }
    $zeile[gueltig_von] = date2human( $zeile[gueltig_von] );
    $zeile[gueltig_bis] = date2human( $zeile[gueltig_bis] );
?>
  <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
    <tr>
      <td colspan="2" class="headline" bgcolor="#<?= $webs[bgcolor_links]
?>"><font color="#<?=
    $webs[font_color_links]
?>">News:
        <?php
    if ( $ID )
    {
?>
        Bearbeiten
        <?php
    }
    else
    {
?>
        Neueintrag
        <?php
    }
?>
        </font> </td>
    </tr>
    <?php
    $Feld = "ueberschrift";
    if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
    {
?>
    <tr>
      <td bgcolor="#<?= $webs[bgcolor_links]
?>" class="headline" width="20%"><font color="#<?=
        $webs[font_color_links]
?>"><b>
        <?php
        if ( $web_rechte[modul_name][tool_name][$Feld] )
        {
            echo $web_rechte[modul_name][tool_name][$Feld];
        }
        else
        {
?>
        &Uuml;berschrift:
        <?php
        }
?>
        </b></font></td>
      <td bgcolor="#<?= $webs[bgcolor_rechts]
?>"><input type="text" name="ueberschrift" size="40" value="<?=
        htmlentities( $zeile[ueberschrift] )
?>" maxlength="255">      </td>
    </tr>
    <?php
    }
?>
    <?php
    $Feld = "kurz";
    if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
    {
?>
    <tr>
      <td bgcolor="#<?= $webs[bgcolor_links]
?>" class="headline" width="20%"><font color="#<?=
        $webs[font_color_links]
?>"><b>
        <?php
        if ( $web_rechte[modul_name][tool_name][$Feld] )
        {
            echo $web_rechte[modul_name][tool_name][$Feld];
        }
        else
        {
?>
        Kurztext:
        <?php
        }
?>
        </b></font></td>
      <td bgcolor="#<?= $webs[bgcolor_rechts]
?>"><input type="text" name="kurz" size="40" value="<?=
        htmlentities( $zeile[kurz] )
?>" maxlength="255">      </td>
    </tr>
    <?php
    }
?>
    <?php
    $Feld = "text_lang";
    if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
    {
?>
    <tr>
      <td bgcolor="#<?= $webs[bgcolor_links]
?>" class="headline" width="20%" valign="top"><font color="#<?=
        $webs[font_color_links]
?>"><b>
        <?php
        if ( $web_rechte[modul_name][tool_name][$Feld] )
        {
            echo $web_rechte[modul_name][tool_name][$Feld];
        }
        else
        {
?>
        Langtext:
        <?php
        }
?>
        </b></font></td>
      <td bgcolor="#<?= $webs[bgcolor_rechts]
?>"><textarea id="lang" name="lang" cols="70" rows="6"><?=
        $zeile[lang]
?></textarea>
<?php
        if ( isset( $user_rechte[modul_name][tool_name][text_lang_html] ) )
        {
?>
<script type="text/javascript">
tinyMCE.init({
        // General options
        mode : "exact",
    elements: "lang",
        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",
        theme_advanced_buttons2 : "cut,copy,paste,pastetext,pasteword,|,search,replace,|,bullist,numlist,|,outdent,indent,blockquote,|,undo,redo,|,link,unlink,anchor,image,cleanup,help,code,|,preview,|,forecolor,backcolor",
        theme_advanced_buttons3 : "tablecontrols,|,hr,removeformat,visualaid,|,sub,sup,|,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>
<?php }
?>
      </td>
    </tr>
    <?php
    }

    /* ############################################################################################################## */

    for ( $bild_nr = 1; $bild_nr < 3; $bild_nr++ )
    {
        $Feld = "bild$bild_nr";
        if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
        {
?>
    <tr>
      <td bgcolor="#<?= $webs[bgcolor_links]
?>" valign="top" width="21%"><font color="#<?=
            $webs[font_color_links]
?>"><b>
        <?php
            $Felddaten = explode( ";", $web_rechte[modul_name][tool_name][$Feld] );
            if ( !empty( $Felddaten[0] ) )
            {
                echo $Felddaten[0];
            }
            else
            {
?>
        Bild <?= $bild_nr;
?>
        <?php
            }
?>
        </b></font> </td>
      <td bgcolor="#<?= $webs[bgcolor_rechts]
?>" width="79%"><table border="0" width="100%" cellspacing="0" cellpadding="0">
          <tr>
            <td width="55%" nowrap colspan="2"><font color="#<?= $webs[font_color_rechts]
?>">
              <?php
            $image_name = "bild_" . $bild_nr . "_url";
            $image_Path = $webs[verzeichnis] . "/images/news/" . $bild_nr .
                "/";
?>
              <input type="hidden" name="<?= $image_name
?>_Pfad" value="<?=
            $image_Path
?>">
              <?php
            if ( $zeile[$image_name] != "" )
            {
?>
              <input type="radio" name="_<?= $image_name
?>" value="0" checked>
              <a href="http://www.<?= $site . "/images/news/" . $bild_nr .
                "/" . $zeile[$image_name]
?>" target="blank"> <?=
                $zeile[$image_name];
?> </a>
              <?php
                $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="_<?= $image_name
?>" value="1" <?php if ( $zeile[$image_name] ==
            "" )
            {
                echo "checked";
            }
?>>
              kein Bild<br>
              <input type="radio" name="_<?= $image_name
?>" value="2">
              <input type="File" name="<?= $image_name
?>" size="17" maxlength="255" onFocus="this.form._<?=
            $image_name
?>[<?php if ( $zeile[$image_name] != "" )
            {
                echo "2";
            }
            else
            {
                echo "1";
            }
?>].checked=true;">
              </font> </td>
            <td width="45%" nowrap align="center"><?php if ( $zeile[$image_name] !=
            "" )
            {
?>
              <a href="http://www.<?= $site . "/images/news/" . $bild_nr .
                "/" . $zeile[$image_name]
?>" target="blank"><img height="60" src="http://www.<?=
                $site . "/images/news/" . $bild_nr . "/" . $zeile[$image_name]
?>" border="0"></a>
              <?php }
?>            </td>
          </tr>
        </table></td>
    </tr>
    <?php
        }

        $Feld = "bild_text$bild_nr";
        if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
        {
?>
    <tr>
      <td bgcolor="#<?= $webs[bgcolor_links]
?>" class="headline" width="20%"><font color="#<?=
            $webs[font_color_links]
?>"><b>
        <?php
            if ( $web_rechte[modul_name][tool_name][$Feld] )
            {
                echo $web_rechte[modul_name][tool_name][$Feld];
            }
            else
            {
?>
        Bildtext:
        <?php
            }
?>
        </b></font></td>
      <td bgcolor="#<?= $webs[bgcolor_rechts]
?>"><input type="text" name="bildunterschrift<?= $bild_nr;
?>" size="40" value="<?=
            htmlentities( $zeile["bildunterschrift" . $bild_nr] )
?>" maxlength="255">      </td>
    </tr>
    <?php
        }
        $Feld = "bild_pos$bild_nr";
        if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
        {
?>
    <tr>
      <td bgcolor="#<?= $webs[bgcolor_links]
?>" class="headline" width="20%"><font color="#<?=
            $webs[font_color_links]
?>"><b> Position:</b></font></td>
      <td bgcolor="#<?= $webs[bgcolor_rechts]
?>"><?php $kats = explode( ";",
            $web_rechte[modul_name][tool_name][$Feld] )
?>
        <select name="<?= $Feld
?>">
          <?php
            foreach ( $kats as $elem )
            {
?>
          <option <?php if ( $zeile[$Feld] == $elem )
                {
?>selected<?php }
?>> <?=
                $elem
?> </option>
          <?php
            }
?>
        </select>      </td>
    </tr>
    <?php
        }
    }

    for ( $dokument_nr = 1; $dokument_nr < 2; $dokument_nr++ )
    {
        $Feld = "dokument$dokument_nr";
        if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
        {
?>
    <tr>
      <td bgcolor="#<?= $webs[bgcolor_links]
?>" valign="top" width="21%"><font color="#<?=
            $webs[font_color_links]
?>"><b>
        <?php
            $Felddaten = explode( ";", $web_rechte[modul_name][tool_name][$Feld] );
            if ( !empty( $Felddaten[0] ) )
            {
                echo $Felddaten[0];
            }
            else
            {
?>
        Dokument <?= $dokument_nr;
?>
        <?php
            }
?>
        </b></font> </td>
      <td bgcolor="#<?= $webs[bgcolor_rechts]
?>" width="79%"><font color="#<?= $webs[font_color_rechts]
?>">
        <?php
            $image_name = "dokument" . $dokument_nr;
            $image_Path = $webs[verzeichnis] . "/dokumente/news/" . $dokument_nr .
                "/";
?>
        <input type="hidden" name="<?= $image_name
?>_Pfad" value="<?=
            $image_Path
?>">
        <?php
            if ( $zeile[$image_name] != "" )
            {
?>
        <input type="radio" name="_<?= $image_name
?>" value="0" checked>
        <a href="http://www.<?= $site . "/dokumente/news/" . $dokument_nr .
                "/" . $zeile[$image_name]
?>" target="blank"> <?=
                $zeile[$image_name];
?> </a>
        <?php
                $size = filesize( $image_Path . $zeile[$image_name] ) >> 10;
            }
?>
        <br>
        <input type="radio" name="_<?= $image_name
?>" value="1" <?php if ( $zeile[$image_name] ==
            "" )
            {
                echo "checked";
            }
?>>
        kein Dokument<br>
        <input type="radio" name="_<?= $image_name
?>" value="2">
        <input type="File" name="<?= $image_name
?>" size="17" maxlength="255" onFocus="this.form._<?=
            $image_name
?>[<?php if ( $zeile[$image_name] != "" )
            {
                echo "2";
            }
            else
            {
                echo "1";
            }
?>].checked=true;">
        </font> </td>
    </tr>
    <?php
        }
        $Feld = "dokument" . $dokument_nr . "_text";
        if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
        {
?>
    <tr>
      <td bgcolor="#<?= $webs[bgcolor_links]
?>" class="headline" width="20%"><font color="#<?=
            $webs[font_color_links]
?>"><b>
        <?php
            if ( $web_rechte[modul_name][tool_name][$Feld] )
            {
                echo $web_rechte[modul_name][tool_name][$Feld];
            }
            else
            {
?>
        Dokumenttext:
        <?php
            }
?>
        </b></font></td>
      <td bgcolor="#<?= $webs[bgcolor_rechts]
?>"><input type="text" name="<?= $Feld
?>" size="40" value="<?=
            htmlentities( $zeile[$Feld] )
?>" maxlength="255">      </td>
    </tr>
    <?
        }
    }

    /* ############################################################################################################## */

    for ( $Eigenschaft_nr = 1; $Eigenschaft_nr <= 5; $Eigenschaft_nr++ )
    {
        $Feld = "Eigenschaft_" . $Eigenschaft_nr;
        if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
        {
?>
    <tr>
      <td bgcolor="#<?= $webs[bgcolor_links]
?>" width="21%"><font color="#<?=
            $webs[font_color_links]
?>"><b>
        <?php
            if ( $web_rechte[modul_name][tool_name][$Feld] )
            {
                echo $web_rechte[modul_name][tool_name][$Feld];
            }
            else
            {
?>
        Eigenschaft <?= $Eigenschaft_nr
?>
        <?php
            }
?>
        </b></font> </td>
      <td bgcolor="#<?= $webs[bgcolor_rechts]
?>" width="79%"><input type="hidden" name="Eigenschaft_<?=
            $Eigenschaft_nr
?>" value="0">
        <input type="checkbox" name="Eigenschaft_<?= $Eigenschaft_nr
?>" <?php if ( $zeile[$Feld] ==
            1 )
            {
                echo "checked";
            }
?> value="1">      </td>
    </tr>
    <?php
        }
    }
?>
<?php
    $Feld = "gueltig";
    if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
    {
?>
    <tr>
      <td bgcolor="#<?= $webs[bgcolor_links]
?>" class="headline" width="20%"><font color="#<?=
        $webs[font_color_links]
?>"><b>
        <?php
        if ( $web_rechte[modul_name][tool_name][$Feld] )
        {
            echo $web_rechte[modul_name][tool_name][$Feld];
        }
        else
        {
?>
        G&uuml;ltigkeit:
        <?php
        }
?>
        </b></font></td>
      <td bgcolor="#<?= $webs[bgcolor_rechts]
?>"> von
        <input type="text" name="gueltig_von" size="10" value="<?= $zeile[gueltig_von]
?>" onFocus="current_value=this.value;if (this.value=='') {this.value=today()};this.select();" onChange="this.value=check_Date(this.value)">
        bis
        <input type="text" name="gueltig_bis" size="10" value="<?= $zeile[gueltig_bis]
?>" onFocus="current_value=this.value;if (this.value=='') {this.value=today()};this.select();" onChange="this.value=check_Date(this.value)">      </td>
    </tr>
    <?php
    }
?>
    <?php
    $Feld = "kategorie";
    if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
    {
?>
    <tr>
      <td bgcolor="#<?= $webs[bgcolor_links]
?>" class="headline" width="20%"><font color="#<?=
        $webs[font_color_links]
?>"><b>
        <?php
        if ( $web_rechte[modul_name][tool_name][$Feld] )
        {
            echo $web_rechte[modul_name][tool_name][$Feld];
        }
        else
        {
?>
        Kategorie:
        <?php
        }
?>
        </b></font></td>
      <td bgcolor="#<?= $webs[bgcolor_rechts]
?>"><? $kats = explode( ";", $web_rechte[modul_name][tool_name][zuordnung] )
?>
        <select name="kategorie">
          <?php
        foreach ( $kats as $elem )
        {
?>
          <option <?php if ( $zeile[kategorie] == $elem )
            {
?>selected<?php }
?>> <?=
            $elem
?> </option>
          <?php
        }
?>
        </select>      </td>
    </tr>
    <?php
    }
?>


    <?php
    $Feld = "newsticker_ausgabe";

    if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
    {
?>
    <tr>
      <td bgcolor="#<?= $webs[bgcolor_links]
?>" class="headline" width="20%"><font color="#<?=
        $webs[font_color_links]
?>"><b>
        <?php
        if ( $web_rechte[modul_name][tool_name][$Feld] )
        {
            echo $web_rechte[modul_name][tool_name][$Feld];
        }
        else
        {
?>
        Newsticker Ausgabe:
        <?php
        }
?>
        </b></font></td>
      <td bgcolor="#<?= $webs[bgcolor_rechts]
?>">
        <input type="checkbox" name="newsticker_ausgabe" <?= ( $zeile['newsticker_ausgabe'] ==
"on" ) ? "checked=\"checked\"" : ""
?>  />
      </td>
    </tr>
<?php
    }
?>

<?php
    $Feld = "shops_ID";
    if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
    {
?>
    <tr>
      <td bgcolor="#<?= $webs[bgcolor_links]
?>" class="headline" width="20%"><font color="#<?=
        $webs[font_color_links]
?>"><b>
        <?php
        if ( $web_rechte[modul_name][tool_name][$Feld] )
        {
            echo $web_rechte[modul_name][tool_name][$Feld];
        }
        else
        {
?>
        Shop:
        <?php
        }
?>
        </b></font></td>
      <td bgcolor="#<?= $webs[bgcolor_rechts]
?>"><?php
        $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'] . '"';
            if ( $r['ID'] == $zeile[shops_ID] )
            {
                echo ' selected';
            }
            echo '>' . $r['Name'] . '</option>';
        }
        echo '</select>';
?>      </td>
    </tr>
    <?php
    }
?>
    <?php
    $Feld = "firma";
    if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
    {
?>
    <tr>
      <td bgcolor="#<?= $webs[bgcolor_links]
?>" class="headline" width="20%"><font color="#<?=
        $webs[font_color_links]
?>"><b>
        <?php
        if ( $web_rechte[modul_name][tool_name][$Feld] )
        {
            echo $web_rechte[modul_name][tool_name][$Feld];
        }
        else
        {
?>
        Firma:
        <?php
        }
?>
        </b></font></td>
      <td bgcolor="#<?= $webs[bgcolor_rechts]
?>"><?php
        $query = "select * from Firma";
        $result = mysql_query( $query ) or die( mysql_errno() . ": " .
            mysql_error() . "<hr>" . $query );
        echo '<select name="firma"><option></option>';
        while ( $r = mysql_fetch_array( $result ) )
        {
            echo '<option value="' . $r['ID'] . '"';
            if ( $r['ID'] == $zeile["firma"] )
            {
                echo ' selected';
            }
            echo '>' . $r['Name'] . '</option>';
        }
        echo '</select>';
?>      </td>
    </tr>
    <?php
    }
    if ( $ID )
    {
        $Feld = "erstellt";
        if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
        {
?>
    <tr>
      <td class="headline" width="20%" bgcolor="#<?= $webs[bgcolor_links]
?>"><font color="#<?=
            $webs[font_color_links]
?>"><b>
        <?php
            if ( $web_rechte[modul_name][tool_name][$Feld] )
            {
                echo $web_rechte[modul_name][tool_name][$Feld];
            }
            else
            {
?>
        erstellt am:
        <?php
            }
?>
        </b></font></td>
      <?php $erstellt_am = datetime2human( $zeile[erstellt_am] );
?>
      <td class="headline" bgcolor="#<?= $webs[bgcolor_rechts]
?>"><font color="#<?=
            $webs[font_color_rechts]
?>">am: <?=
            $erstellt_am[Datum]
?> um: <?=
            $erstellt_am[Zeit]
?> von: <?=
            $zeile[erstellt_von]
?> </font> </td>
    </tr>
    <?php
        }

        $Feld = "letzte_aenderung";
        if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
        {
?>
    <tr>
      <td class="headline" width="20%" bgcolor="#<?= $webs[bgcolor_links]
?>"><font color="#<?=
            $webs[font_color_links]
?>"><b>
        <?php
            if ( $web_rechte[modul_name][tool_name][$Feld] )
            {
                echo $web_rechte[modul_name][tool_name][$Feld];
            }
            else
            {
?>
        letzte &Auml;nderung:
        <?php
            }
?>
        </b></font></td>
      <?php $letzte_Aenderung_am = datetime2human( $zeile[letzte_Aenderung_am] );
?>
      <td class="headline" bgcolor="#<?= $webs[bgcolor_rechts]
?>"><font color="#<?=
            $webs[font_color_rechts]
?>">am: <?=
            $letzte_Aenderung_am[Datum]
?> um: <?=
            $letzte_Aenderung_am[Zeit]
?> von: <?=
            $zeile[letzte_Aenderung_von]
?> </font> </td>
    </tr>
    <?php
        }
    }
?>
    <tr>
      <td align="right" colspan="2" bgcolor="#<?= $webs[bgcolor_links]
?>"><input type="hidden" name="ID" value="<?=
    $ID
?>">
        <input type="hidden" name="action" value="update">
        <input type="submit" value="   OK   ">
        <input type="reset" name="Button" value="Abbrechen">      </td>
    </tr>
  </table>
Subversion-Projekte lars-tiefland.content-management

(root)/trunk/news/includes/editForm.php – Revision 1
