Subversion-Projekte lars-tiefland.content-management

<?php
    session_start();
    require_once  "connect2.php";
    $dirs = explode( ",", $_GET["id"] );
    $out = array();
    foreach ( $dirs as $d_id )
    {
        $buff = "";
        $sql = "
            SELECT 
                * 
            FROM 
                directory 
            WHERE 
                Father=" . ( int )$d_id . " 
            AND 
                Language='".DEFAULT_LANG."' 
            ORDER BY 
                kennung
        ";
        $res = mysql_query( $sql );
        if ( !$res )
        {
            die( mysql_error() );
        }
        //        $buff = array();
        while ( $row = mysql_fetch_assoc($res) )
        {
            if ( $_SESSION["language"] != DEFAULT_LANG )
            {
                $query_language = "select distinct * FROM directory where ID = " . $row["ID"] .
                    " and Language = '" . $_SESSION["language"] . "'";
                $result_language = mysql_query( $query_language ) or die( mysql_errno() .
                    ": " . mysql_error() . "<hr>$query_language<hr>" );
                if ( mysql_num_rows($result_language) > 0 )
                {
                    $row = mysql_fetch_array( $result_language );
                }
            }

            $sql2 = "SELECT COUNT(*) AS anz FROM directory WHERE Father=" . $row["ID"] .
                " AND Language='".DEFAULT_LANG."'";
            $res2 = mysql_query( $sql2 );
            $row2 = mysql_fetch_assoc( $res2 );
            if ( $row2["anz"] )
            {
                $row["Name"] .= " (" . $row2["anz"] . ")";
            }
            $_SESSION["dir_open"][$row["ID"]] = ( !isset($_SESSION["dir_open"][$row["ID"]]) ) ? false :
                $_SESSION["dir_open"][$row["ID"]];
            $status = ( $_SESSION["dir_open"][$row["ID"]] ) ? "open" : "closed";
            if ( $_SESSION["language"] != $row["Language"] )
            {
                $dirstatus = "1";
            }
            else
            {
                $dirstatus = "0";
            }
            if ( $row["status"] == 1 )
            {
                $dirstatus .= "1";
            }
            else
            {
                $dirstatus .= "0";
            }
            if ( $row["Father"] != $d_id )
            {
                $dirstatus .= "1";
            }
            else
            {
                $dirstatus .= "0";
            }
            if ( $row["Artikelstamm"] == "1" )
            {
                $dirstatus .= "_artikelstamm";
            }
            $dirstatus = '<img src="../images/Online-Shop/directory/ordner_' . $dirstatus .
                '.gif" border="0">';

            if ( $_GET["link"] )
            {
                $link = '<a href="directory.php?action=edit&ID=' . $row["ID"] .
                    '" target="tool2">%s</a>';
                $row["Name"] = sprintf( $link, $row["Name"] );
                $dirstatus = sprintf( $link, $dirstatus );
            }
            $buff .= '<span id="status_' . $row["ID"] .
                '" style="cursor:pointer;margin-left:20px;"  onClick="toggle_dir(' . $row["ID"] .
                ');"><img src="../images/Online-Shop/directory/subdir_' . $status .
                '.gif"></span><span>' . $dirstatus . '</span>' . $row["Name"] .
                '<div id="sub_dirs_' . $row["ID"] .
                '" style="margin-left:20px;"></div><div id="sub_dirs_' . $row["ID"] .
                '_artikel" style="margin-left:20px;"></div>';
            /*$buff[] = array( "status" => $status, "id" => $row["ID"], "Text" => $row["Name"],
            "Father" => $row["Father"], "dirstatus" => $dirstatus );*/
        }
        /*foreach ( $buff as $dir )
        {
        $out[] = implode( "#", $dir );
        }
        //echo $_GET["id"] . "#" . $buff;
        echo implode( "|", $out );*/
        $out[] = $d_id . "#" . $buff;
    }
    echo implode( "|", $out );

?>