Subversion-Projekte lars-tiefland.content-management

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1 
<?php
2 
    $web_rechte = array();
3 
    $query = "SELECT
4 
            modules.interner_name AS m_name,
5 
            tools.button_name AS t_name,
6 
            properties.interner_name AS p_name,
7 
            webs_properties.Bezeichnung
8 
        FROM
9 
            content_management.webs,
10 
            content_management.webs_properties,
11 
            content_management.properties,
12 
            content_management.tools,
13 
            content_management.modules
14 
        WHERE
15 
            webs.domain='$site'
16 
        AND
17 
            webs_properties.webs=webs.ID
18 
        AND
19 
            webs_properties.properties=properties.ID
20 
        AND
21 
            properties.tools = tools.ID
22 
        AND
23 
            tools.modules = modules.ID
24 
        ORDER BY
25 
            properties.Rang
26 
    ";
27 
 
28 
    $result = mysql_query( $query ) or die( mysql_errno() . ": " .
29 
        mysql_error() . "<hr>$query<hr>" );
30 
    while ( $zeile = mysql_fetch_assoc( $result ) )
31 
    {
32 
        //var_dump($zeile);
33 
        //exit;
34 
        if ( !$zeile["Bezeichnung"] )
35 
        {
36 
            $zeile["Bezeichnung"] = "";
37 
        }
38 
        $zeile["Bezeichnung"] = explode( "|", $zeile["Bezeichnung"] );
39 
 
40 
        if ( count( $zeile["Bezeichnung"] ) == 1 )
41 
        {
42 
            $zeile["Bezeichnung"] = $zeile["Bezeichnung"][0];
43 
        }
44 
 
45 
        $web_rechte[$zeile["m_name"]][$zeile["t_name"]][$zeile["p_name"]] = $zeile["Bezeichnung"];
46 
    }
47 
 
48 
    foreach ( array_keys( $web_rechte ) as $a )
49 
    {
50 
        foreach ( array_keys( $web_rechte[$a] ) as $b )
51 
        {
52 
            foreach ( array_keys( $web_rechte[$a][$b] ) as $c )
53 
            {
54 
                if ( is_array( $web_rechte[$a][$b][$c] ) )
55 
                {
56 
                    //if (in_array($_SESSION[language], $web_rechte[$a][$b][$c]))
57 
 
58 
                    {
59 
                        $web_rechte[$a][$b][$c] = $web_rechte[$a][$b][$c][array_search( $_SESSION["language"],
60 
                            array_keys( $web_rechte["online_shop"]["language"] ) )];
61 
                    }
62 
                    if ( $web_rechte[$a][$b][$c] == "./." )
63 
                    {
64 
                        unset( $web_rechte[$a][$b][$c] );
65 
                    }
66 
                }
67 
            }
68 
        }
69 
    }
70 
 
71 
    unset( $query );
72 
    unset( $result );
73 
    unset( $zeile );
74 
?>