Subversion-Projekte lars-tiefland.content-management

<?php
    $web_rechte = array();
    $query = "SELECT
            modules.interner_name AS m_name,
            tools.button_name AS t_name,
            properties.interner_name AS p_name,
            webs_properties.Bezeichnung
        FROM
            content_management.webs,
            content_management.webs_properties,
            content_management.properties,
            content_management.tools,
            content_management.modules
        WHERE
            webs.domain='$site'
        AND
            webs_properties.webs=webs.ID
        AND
            webs_properties.properties=properties.ID
        AND
            properties.tools = tools.ID
        AND
            tools.modules = modules.ID
        ORDER BY
            properties.Rang
    ";

    $result = mysql_query( $query ) or die( mysql_errno() . ": " .
        mysql_error() . "<hr>$query<hr>" );
    while ( $zeile = mysql_fetch_assoc( $result ) )
    {
        //var_dump($zeile);
        //exit;
        if ( !$zeile["Bezeichnung"] )
        {
            $zeile["Bezeichnung"] = "";
        }
        $zeile["Bezeichnung"] = explode( "|", $zeile["Bezeichnung"] );

        if ( count( $zeile["Bezeichnung"] ) == 1 )
        {
            $zeile["Bezeichnung"] = $zeile["Bezeichnung"][0];
        }

        $web_rechte[$zeile["m_name"]][$zeile["t_name"]][$zeile["p_name"]] = $zeile["Bezeichnung"];
    }

    foreach ( array_keys( $web_rechte ) as $a )
    {
        foreach ( array_keys( $web_rechte[$a] ) as $b )
        {
            foreach ( array_keys( $web_rechte[$a][$b] ) as $c )
            {
                if ( is_array( $web_rechte[$a][$b][$c] ) )
                {
                    //if (in_array($_SESSION[language], $web_rechte[$a][$b][$c]))

                    {
                        $web_rechte[$a][$b][$c] = $web_rechte[$a][$b][$c][array_search( $_SESSION["language"],
                            array_keys( $web_rechte["online_shop"]["language"] ) )];
                    }
                    if ( $web_rechte[$a][$b][$c] == "./." )
                    {
                        unset( $web_rechte[$a][$b][$c] );
                    }
                }
            }
        }
    }

    unset( $query );
    unset( $result );
    unset( $zeile );
?>