Subversion-Projekte lars-tiefland.content-management

<?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" 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>