Subversion-Projekte lars-tiefland.content-management

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1 
<?php
2 
    session_start();
3 
    require_once  "connect2.php";
4 
    $dirs = explode( ",", $_GET["id"] );
5 
    $out = array();
6 
    foreach ( $dirs as $d_id )
7 
    {
8 
        $buff = "";
9 
        $sql = "
10 
            SELECT
11 
                *
12 
            FROM
13 
                directory
14 
            WHERE
15 
                Father=" . ( int )$d_id . "
16 
            AND
17 
                Language='".DEFAULT_LANG."'
18 
            ORDER BY
19 
                kennung
20 
        ";
21 
        $res = mysql_query( $sql );
22 
        if ( !$res )
23 
        {
24 
            die( mysql_error() );
25 
        }
26 
        //        $buff = array();
27 
        while ( $row = mysql_fetch_assoc($res) )
28 
        {
29 
            if ( $_SESSION["language"] != DEFAULT_LANG )
30 
            {
31 
                $query_language = "select distinct * FROM directory where ID = " . $row["ID"] .
32 
                    " and Language = '" . $_SESSION["language"] . "'";
33 
                $result_language = mysql_query( $query_language ) or die( mysql_errno() .
34 
                    ": " . mysql_error() . "<hr>$query_language<hr>" );
35 
                if ( mysql_num_rows($result_language) > 0 )
36 
                {
37 
                    $row = mysql_fetch_array( $result_language );
38 
                }
39 
            }
40 
 
41 
            $sql2 = "SELECT COUNT(*) AS anz FROM directory WHERE Father=" . $row["ID"] .
42 
                " AND Language='".DEFAULT_LANG."'";
43 
            $res2 = mysql_query( $sql2 );
44 
            $row2 = mysql_fetch_assoc( $res2 );
45 
            if ( $row2["anz"] )
46 
            {
47 
                $row["Name"] .= " (" . $row2["anz"] . ")";
48 
            }
49 
            $_SESSION["dir_open"][$row["ID"]] = ( !isset($_SESSION["dir_open"][$row["ID"]]) ) ? false :
50 
                $_SESSION["dir_open"][$row["ID"]];
51 
            $status = ( $_SESSION["dir_open"][$row["ID"]] ) ? "open" : "closed";
52 
            if ( $_SESSION["language"] != $row["Language"] )
53 
            {
54 
                $dirstatus = "1";
55 
            }
56 
            else
57 
            {
58 
                $dirstatus = "0";
59 
            }
60 
            if ( $row["status"] == 1 )
61 
            {
62 
                $dirstatus .= "1";
63 
            }
64 
            else
65 
            {
66 
                $dirstatus .= "0";
67 
            }
68 
            if ( $row["Father"] != $d_id )
69 
            {
70 
                $dirstatus .= "1";
71 
            }
72 
            else
73 
            {
74 
                $dirstatus .= "0";
75 
            }
76 
            if ( $row["Artikelstamm"] == "1" )
77 
            {
78 
                $dirstatus .= "_artikelstamm";
79 
            }
80 
            $dirstatus = '<img src="../images/Online-Shop/directory/ordner_' . $dirstatus .
81 
                '.gif" border="0">';
82 
 
83 
            if ( $_GET["link"] )
84 
            {
85 
                $link = '<a href="directory.php?action=edit&ID=' . $row["ID"] .
86 
                    '" target="tool2">%s</a>';
87 
                $row["Name"] = sprintf( $link, $row["Name"] );
88 
                $dirstatus = sprintf( $link, $dirstatus );
89 
            }
90 
            $buff .= '<span id="status_' . $row["ID"] .
91 
                '" style="cursor:pointer;margin-left:20px;"  onClick="toggle_dir(' . $row["ID"] .
92 
                ');"><img src="../images/Online-Shop/directory/subdir_' . $status .
93 
                '.gif"></span><span>' . $dirstatus . '</span>' . $row["Name"] .
94 
                '<div id="sub_dirs_' . $row["ID"] .
95 
                '" style="margin-left:20px;"></div><div id="sub_dirs_' . $row["ID"] .
96 
                '_artikel" style="margin-left:20px;"></div>';
97 
            /*$buff[] = array( "status" => $status, "id" => $row["ID"], "Text" => $row["Name"],
98 
            "Father" => $row["Father"], "dirstatus" => $dirstatus );*/
99 
        }
100 
        /*foreach ( $buff as $dir )
101 
        {
102 
        $out[] = implode( "#", $dir );
103 
        }
104 
        //echo $_GET["id"] . "#" . $buff;
105 
        echo implode( "|", $out );*/
106 
        $out[] = $d_id . "#" . $buff;
107 
    }
108 
    echo implode( "|", $out );
109 
 
110 
?>