Subversion-Projekte lars-tiefland.content-management

Revision

Revision 1 | Blame | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed 

<?php
    $self = basename( $_SERVER["PHP_SELF"] );
    $tab = "news";
    define( "modul_name", "news" );
    define( "tool_name", "news" );
    require_once  "../Online-Shop/connect2.php";
    require_once "../Online-Shop/language_pack.php";

    session_start();
    if ( !$_SESSION["language"] )
    {
        $_SESSION["language"] = "DE";
    }
    if ( !$_SESSION[$self]["filter"] )
    {
        $_SESSION[$self]["filter"] = array();
    }

    // $charset laden um die jeweiligen ISO-Zeichensätzte zu laden.
    require_once  "../Online-Shop/charset.php";


    $_POST[gueltig_von] = human2date( $_POST[gueltig_von] );
    $_POST[gueltig_bis] = human2date( $_POST[gueltig_bis] );

    // $_POST['newsticker_ausgabe'] auf "off" setzten, wenn die Checkbox "newsticker_ausgabe" nicht             // gechecked ist.
    if ( empty( $_POST['newsticker_ausgabe'] ) )
    {
        $sql = "SHOW COLUMNS FROM news WHERE Field='newsticker_ausgabe'";
        $result = mysql_query( $sql ) or die( mysql_errno() . ': ' .
            mysql_error() . '<hr />' . $sql );
        $row = mysql_fetch_assoc( $result );

        if ( !empty( $row ) )
        {
            $_POST['newsticker_ausgabe'] = "off";
        }
    }

    if ( $action == "update" )
    {
        if ( !$ID )
        { // insert Dummy-Entry
            $felder[] = 'erstellt_am';
            $values[] = 'NOW()';
            $felder[] = 'erstellt_von';
            $values[] = "'$PHP_AUTH_USER'";
            if ( isset( $web_rechte[modul_name][tool_name]["language"] ) )
            {
                $felder[] = 'language';
                $values[] = "'" . $_SESSION['language'] . "'";
            }
            if ( isset( $web_rechte[modul_name][tool_name]["firma"] ) )
            {
                $felder[] = 'firma';
                $values[] = "'" . $_POST['firma'] . "'";
            }
            /*                  $query = "insert into $tab (erstellt_am,erstellt_von) VALUES (NOW(),'$PHP_AUTH_USER')";
            if (isset($web_rechte[modul_name][tool_name]["language"]))
            {
            $query = "insert into $tab (language,erstellt_am,erstellt_von) VALUES ('$_SESSION[language]',NOW(),'$PHP_AUTH_USER')";
            }*/
            $feld_sql = implode( ", ", $felder );
            $val_sql = implode( ", ", $values );
            $query = "
                INSERT INTO
                    $tab
                ($feld_sql)
                VALUES
                ($val_sql)
            ";
            $result = mysql_query( $query ) or die( mysql_errno() . ": " .
                mysql_error() . "<hr>" . $query . "<hr>" );
            $ID = mysql_insert_id();
        }

        // Übersetzungen sind eigentlich updates
        // Verfahren für Einträge die nicht "DE" sind
        if ( $_SESSION[language] != "DE" )
        {
            // überprüfe ob der Eintrag schon übersetzt wurde
            $query = "select * from $tab where ID = '$ID' and language = '" .
                $_SESSION['language'] . "'";
            $result = mysql_query( $query ) or die( mysql_errno() . ": " .
                mysql_error() . "<hr>" . $query . "<hr>" );
            if ( mysql_num_rows( $result ) == 0 )
            {
                // Eintrag wurde noch nicht übersetzt neuen Dummy in der entsprechenden Sprache erzeugen
                $query = "insert into $tab (ID,language,erstellt_am,erstellt_von) VALUES ($ID,'" .
                    $_SESSION['language'] . "',NOW(),'$PHP_AUTH_USER')";
                $result = mysql_query( $query ) or die( mysql_errno() . ": " .
                    mysql_error() . "<hr>" . $query . "<hr>" );
            }
            // Der Eintrag für die Sprache wurde erzeugt.
        }

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

        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;

                        /* ------------------------------------------------------------------------------------------ */
                        // $Imagenummer extrahieren
                        $Imagenummer = explode( "_", $elem );
                        $Imagenummer = $Imagenummer[1];
                        $DatenID = "bild" . $Imagenummer;
                        $Imagedaten = explode( ";", $web_rechte[modul_name][tool_name][$DatenID] );
                        /*
                        Imagedaten möglich Werte:
                        0: Titel des Feldes
                        1: max. Breite für Bild1
                        2: max. Höhe für Bild1
                        
                        3: Pfad für mittleres Bild1
                        4: max. Breite für mittleres Bild1
                        5: max. Höhe für mittleres Bild1
                        
                        6: Pfad für kleines Bild1
                        7: max. Breite für kleines Bild1
                        8: max. Höhe für kleines Bild1
                        */

                        // Höhe und Breite des Bildes bestimmen
                        $imgsize = GetImageSize( $image );
                        // $imgsize[0] $imgsize[1]

                        // ---- Hier wird abgefragt ob das grosse Bild angepasst werden soll ---- //
                        $resize = false;
                        if ( count( $Imagedaten ) > 1 )
                        {
                            $resize = true;
                        }
                        if ( ( $imgsize[0] < $Imagedaten[1] ) and ( $imgsize[1] <
                            $Imagedaten[2] ) )
                        {
                            $resize = false;
                        }
                        if ( $resize == true )
                        {
                            exec( "convert -scale " . $Imagedaten[1] . "x" .
                                $Imagedaten[2] . " " . $image . " " . $Pfad .
                                $image_name );
                        }
                        else
                        {
                            copy( $image, $Pfad . $image_name );
                        }
                        /* ------------------------------------------------------------------------------------------ */

                        // ---- falls mittleres Bild: erstellen---- //
                        if ( ( $Imagedaten[4] ) and ( $Imagedaten[5] ) )
                        {
                            exec( "convert -scale " . $Imagedaten[4] . "x" .
                                $Imagedaten[5] . " " . $image . " " . $Pfad .
                                $Imagedaten[3] . "/" . $image_name );
                        }

                        // ---- falls kleines Bild: erstellen---- //
                        if ( ( $Imagedaten[6] ) and ( $Imagedaten[7] ) )
                        {
                            exec( "convert -scale " . $Imagedaten[7] . "x" .
                                $Imagedaten[8] . " " . $image . " " . $Pfad .
                                $Imagedaten[6] . "/" . $image_name );
                        }

                        break;
                    default:
                        break;
                }
            }
        }
        $names = array();
        foreach ( array_keys( $_POST ) as $elem )
        {
            array_push( $names, "$elem='" . mysql_real_escape_string( $_POST[$elem] ) .
                "'" );
        }
        $query = "update $tab set " . join( $names, ', ' );
        $query .= ", letzte_Aenderung_am=NOW(), letzte_Aenderung_von='$PHP_AUTH_USER' where ID = '$ID'";

        if ( isset( $web_rechte[modul_name][tool_name]["language"] ) )
        {
            $query .= " and language='$_SESSION[language]'";
        }
        else
        {
        }
        $result = mysql_query( $query ) or die( mysql_errno() . ": " .
            mysql_error() . "<hr>" . $query . "<hr>" );
        header( "Location: " . $_SERVER["PHP_SELF"] . ( $_POST["firma"] ?
            "?firma=" . $_POST["firma"] : "" ) );
    }

    // News löschen
    if ( $action == "delete" )
    {
        if ( $ID )
        {
            $condition = array();
            foreach ( $ID as $elem )
            {
                array_push( $condition, " ID = '$elem'" );
            }
            $cond = join( " or ", $condition );
            if ( isset( $web_rechte[modul_name][tool_name]["language"] ) )
            {
                $cond .= " and language='" . $_SESSION['language'] . "'";
            }

            $query = "DELETE FROM $tab WHERE $cond";
            $result = mysql_query( $query ) or die( mysql_errno() . ": " .
                mysql_error() . "<hr>" . $query . "<hr>" );
            header( "Location: " . $self );
        }
    }
    if ( !$action )
    {
        $action = "select_edit";
    }
    if ( !$sort )
    {
        $sort = 'ueberschrift';
    }

    if ( $_POST["filter"] )
    {
        $_SESSION[$self]["filter"] = $_POST["filter"];
    }
    $range = 100;
?>
<html>
<head>
<title>Vorlage: Redaktionssystem</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" type="text/css" href="../buttons.css">
<script language="javascript" src="../checkDate.js"></script>
<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_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;
}

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];}
}
//-->
</script>
<script language="JavaScript" src="../checkDate.js"></script>
<!--<script type="text/javascript">
   _editor_url = "../htmlarea/";
   _editor_lang = "de";
</script>
<script type="text/javascript" src="../htmlarea/htmlarea.js"></script>-->
<!-- Einbindung TinyMCE -->
<script type="text/javascript" language="javascript" src="/js/jquery-1.6.4.min.js"></script>
<script type="text/javascript" src="../tiny_mce/tiny_mce.js"></script>

<meta name="description" content="Redaktionssystem">
<meta name="author" content="Webagentur Niewerth">
<meta name="robots" content="noindex">
<style type="text/css">
<!--
a {  color: #<?= $webs[font_color_rechts]
?>}
fieldset { float:left; padding:2px; }
-->
</style>
</head>
<body bgcolor="#<?= $webs[bgcolor_seite];
?>" leftmargin="20" topmargin="10" marginwidth="20" marginheight="10" onLoad="MM_preloadImages('../images/navigation/bt_neu_f2.gif','../images/navigation/bt_delete_f2.gif','../images/navigation/bt_bearbeiten_f2.gif')" text="#<?=
    $webs[font_color_seite];
?>">
<form method="post" action="<?= $_SERVER["PHP_SELF"];
?>" name="formname" enctype="multipart/form-data">
  <table width="662" border="0" cellspacing="0" cellpadding="0">
    <tr valign="top">
      <td width="585">
<?php
    switch ( $action )
    {
        case "delete":
            require_once  "includes/selectDelete.php";
            break;
        case "edit":
            require_once  "includes/editForm.php";
            break;
        default:
        case "select_edit":
            require_once  "includes/selectEdit.php";
            break;
    }
?>
          </td>
      <td width="77" align="right"><table width="67" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#FFFFFF" bordercolordark="#999999">
          <?php
    if ( isset( $web_rechte[modul_name][tool_name]["language"] ) )
    {
        if ( $_SESSION['language'] == 'DE' )
        {
?>
          <tr>
            <td><a href="<?= $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>
                                <?php }
?>
          <tr>
            <td><a href="<?= $self
?>?action=select_edit" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('edit','','../images/navigation/bt_bearbeiten_f2.gif',1)"><img name="edit" border="0" src="../images/navigation/bt_bearbeiten.gif" width="67" height="40" alt="Eintrag bearbeiten"></a></td>
          </tr>

          <tr>
            <td><a href="<?= $self
?>?action=delete<?php if ( ( $action == "edit" ) && ( $ID > 0 ) )
        {
?>&ID[]=<?= $ID
?>" onClick="return confirm('Diesen Eintrag wirklich löschen ?');"<?php }
        else
        {
?>"<?php }
?> 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 }
    else
    {
?>
          <tr>
            <td><a href="<?= $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="<?= $self
?>?action=select_edit" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('edit','','../images/navigation/bt_bearbeiten_f2.gif',1)"><img name="edit" border="0" src="../images/navigation/bt_bearbeiten.gif" width="67" height="40" alt="Eintrag bearbeiten"></a></td>
          </tr>

          <tr>
            <td><a href="<?= $self
?>?action=delete<?php if ( ( $action == "edit" ) && ( $ID > 0 ) )
        {
?>&ID[]=<?= $ID
?>" onClick="return confirm('Diesen Eintrag wirklich löschen ?');"<?php }
        else
        {
?>"<?php }
?> 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 }
?>
        </table></td>
      <td width="77" align="right"><?php
    if ( isset( $web_rechte[modul_name][tool_name]["language"] ) )
    {
?>
        <input type="hidden" name="language" value="<?= $_SESSION[language]
?>">
        <table border="0" cellspacing="5" cellpadding="2">
          <?php
        $flaggen_pro_zeile = 1;
        if ( count( $language_pack ) < $flaggen_pro_zeile )
        {
            $flaggen_pro_zeile = count( $language_pack );
        }
        if ( $flaggen_pro_zeile < 1 )
        {
            $zeilen = 1;
        }
        else
        {
            $zeilen = count( $language_pack ) / $flaggen_pro_zeile;
        }
        for ( $j = 0; $j < $zeilen; $j++ )
        {
?>
          <tr>
            <?php
            for ( $i = 0; $i < $flaggen_pro_zeile; $i++ )
            {
                $index = ( $j * $flaggen_pro_zeile ) + $i;
?>
            <td align="center" valign="middle"<?php if ( $_SESSION[language] ==
                $language_pack[$index][0] )
                {
?> bgcolor="#FF0000"<?php }
?>><a href="../Online-Shop/select_language.php?language=<?=
                $language_pack[$index][0]
?>"><img src="../images/Online-Shop/language/<?=
                $language_pack[$index][1]
?>" alt="<?= $language_pack[$index][2]
?>" width="32" height="22" border="0"></a></td>
            <?php
            }
?>
          </tr>
          <?php
        }
?>
        </table>
        <?php }
?>
      </td>
    </tr>
  </table>
</form>
</body>