WebSVN – lars-tiefland.content-management – /trunk/dokumente/dokumente.php

<?
    $self = basename( $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";


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

    if ( $action == "update" )
    {
        if ( !$ID )
        { // insert Dummy-Entry
            $query = "insert into $tab (erstellt_am,erstellt_von) VALUES (NOW(),'$PHP_AUTH_USER')";
            if ( isset( $user_rechte[modul_name][tool_name]["language"] ) )
            {
                $query = "insert into $tab (language,erstellt_am,erstellt_von) VALUES ('$_SESSION[language]',NOW(),'$PHP_AUTH_USER')";
            }
            $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( $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;

                        /* ------------------------------------------------------------------------------------------ */
                        // $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( $HTTP_POST_VARS ) as $elem )
        {
            array_push( $names, "$elem='$HTTP_POST_VARS[$elem]'" );
        }
        $query = "update $tab set " . join( $names, ', ' );

        if ( isset( $user_rechte[modul_name][tool_name]["language"] ) )
        {
            $query = $query .
                ", letzte_Aenderung_am=NOW(), letzte_Aenderung_von='$PHP_AUTH_USER' where ID = '$ID' and language='$_SESSION[language]'";
        }
        else
        {
            $query = $query .
                ", letzte_Aenderung_am=NOW(), letzte_Aenderung_von='$PHP_AUTH_USER' where ID = '$ID'";
        }
        $result = mysql_query( $query ) or die( mysql_errno() . ": " .
            mysql_error() . "<hr>" . $query . "<hr>" );
        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 $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>
<meta name="description" content="Redaktionssystem">
<meta name="author" content="Webagentur Niewerth">
<meta name="robots" content="noindex">
<style type="text/css">
<!--
a {  color: #<? echo $webs[font_color_rechts]
?>}
fieldset { float:left; padding:2px; }
-->
</style>
</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_delete_f2.gif','../images/navigation/bt_bearbeiten_f2.gif')" text="#<? echo
$webs[font_color_seite];
?>">
<form method="post" action="news.php" name="formname" enctype="multipart/form-data">
  <table width="662" border="0" cellspacing="0" cellpadding="0">
    <tr valign="top">
      <td width="585">
<?
    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">
          <?
    if ( ( $_SESSION[language] != "DE" ) && ( isset( $user_rechte[modul_name][tool_name]["language"] ) ) )
    {
    }
    else
    {
?>
          <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('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>
          <?
    if ( ( $_SESSION[language] != "DE" ) && ( isset( $user_rechte[modul_name][tool_name]["language"] ) ) )
    {
    }
    else
    {
?>
          <tr>
            <td><a href="<? echo $self
?>?action=delete<? if ( ( $action ==
"edit" ) && ( $ID > 0 ) )
        {
?>&ID[]=<?= $ID
?>" onClick="return confirm('Diesen Eintrag wirklich löschen ?');"<? }
        else
        {
?>"<? }
?> 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>
          <? }
?>
        </table></td>
      <td width="77" align="right"><?
    if ( isset( $user_rechte[modul_name][tool_name]["language"] ) )
    {
?>
        <input type="hidden" name="language" value="<?= $_SESSION[language]
?>">
        <table border="0" cellspacing="5" cellpadding="2">
          <?
        $flaggen_pro_zeile = 1;
        if ( count( $language_pack ) < $flaggen_pro_zeile )
        {
            $flaggen_pro_zeile = count( $language_pack );
        }
        $zeilen = count( $language_pack ) / $flaggen_pro_zeile;
        for ( $j = 0; $j < $zeilen; $j++ )
        {
?>
          <tr>
            <?
            for ( $i = 0; $i < $flaggen_pro_zeile; $i++ )
            {
                $index = ( $j * $flaggen_pro_zeile ) + $i;
?>
            <td align="center" valign="middle"<? if ( $_SESSION[language] ==
$language_pack[$index][0] )
                {
?> bgcolor="#FF0000"<? }
?>><a href="../Online-Shop/select_language.php?language=<? echo
$language_pack[$index][0]
?>"><img src="../images/Online-Shop/language/<? echo
$language_pack[$index][1]
?>" alt="<? echo
$language_pack[$index][2]
?>" width="32" height="22" border="0"></a></td>
            <?
            }
?>
          </tr>
          <?
        }
?>
        </table>
        <? }
?>
      </td>
    </tr>
  </table>
</form>
</body>
Subversion-Projekte lars-tiefland.content-management

(root)/trunk/dokumente/dokumente.php – Revision 1
