Subversion-Projekte lars-tiefland.content-management

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1 
<?php
2 
    //$Id$
3 
    require_once  "../connect2.php";
4 
    require_once  "Weban_Smarty.class.php";
5 
    $GLOBALS["ui"] = new Weban_Smarty();
6 
    $GLOBALS["ui"]->compile_dir = $_SERVER["DOCUMENT_ROOT"] . "/templates_c/";
7 
    $GLOBALS["ui"]->compile_id = "Online-Shop|acronyms";
8 
    $GLOBALS["ui"]->use_sub_dirs = true;
9 
 
10 
    /* ---------------------------------------------------------------------------------------------------------------- */
11 
    /* INIT 																											*/
12 
    /* ---------------------------------------------------------------------------------------------------------------- */
13 
    // Session einleiten
14 
    session_start();
15 
 
16 
    $mode = ( isset( $_GET["mode"] ) ) ? $_GET["mode"] : "";
17 
    $id = ( isset( $_GET["ID"] ) ) ? $_GET["ID"] : 0;
18 
    $id = intval( $id );
19 
 
20 
    switch ( $mode )
21 
    {
22 
        case "del":
23 
            $sql = "
24 
                DELETE FROM
25 
                    akronyms
26 
                WHERE
27 
                    ID=$id
28 
            ";
29 
            $res = mysql_query( $sql );
30 
            if ( !$res )
31 
            {
32 
                mail( "tiefland@weban.de", "Fehler beim Lesen der Akronyms",
33 
                    mysql_error() . "\n$sql\n", "FROM: tiefland@weban.de",
34 
                    "-F tiefland@weban.de" );
35 
            }
36 
            header( "Location: " . $_SERVER['PHP_SELF'] );
37 
            break;
38 
        case "del_desc":
39 
            $sql = "
40 
                DELETE FROM
41 
                    akronyms_desc
42 
                WHERE
43 
                    ID=$id
44 
            ";
45 
            $res = mysql_query( $sql );
46 
            if ( !$res )
47 
            {
48 
                mail( "tiefland@weban.de", "Fehler beim Lesen der Akronyms",
49 
                    mysql_error() . "\n$sql\n", "FROM: tiefland@weban.de",
50 
                    "-F tiefland@weban.de" );
51 
            }
52 
            header( "Location: " . $_SERVER['PHP_SELF'] );
53 
            break;
54 
        default:
55 
            $b_letter = ( isset( $_GET["b_letter"] ) ) ? $_GET["b_letter"]:
56 
            "";
57 
            $anz = 0;
58 
            $letters = array( "0", "1", "2", "3", "4", "5", "6", "7", "8",
59 
                "9", "A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K",
60 
                "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W",
61 
                "X", "Y", "Z" );
62 
            foreach ( $letters as $letter )
63 
            {
64 
                $sql = "
65 
                    SELECT
66 
                        count(*) AS Anzahl
67 
                    FROM
68 
                        akronyms
69 
                    WHERE
70 
                        word LIKE '" . $letter . "%'
71 
                ";
72 
                $res = mysql_query( $sql );
73 
                $row = mysql_fetch_assoc( $res );
74 
                if ( $row["Anzahl"] )
75 
                {
76 
                    $anz += $row["Anzahl"];
77 
                    $nav[] = "<a href=\"?b_letter=$letter\">$letter</a>";
78 
                }
79 
                else
80 
                {
81 
                    $nav[] = $letter;
82 
                }
83 
            }
84 
            $auswahl = implode( " | ", $nav ) . " | <a href=\"" . $_SERVER['PHP_SELF'] .
85 
                "\">Alle anzeigen</a>";
86 
 
87 
            if ( $b_letter )
88 
            {
89 
                $letters = array( $b_letter );
90 
            }
91 
 
92 
            foreach ( $letters as $letter )
93 
            {
94 
                $sql = "
95 
                    SELECT
96 
                        ID,
97 
                        word,
98 
                        acronyms_desc
99 
                    FROM
100 
                        akronyms
101 
                    WHERE
102 
                        word LIKE '" . $letter . "%'
103 
                ";
104 
                $res = mysql_query( $sql );
105 
                if ( !$res )
106 
                {
107 
                    mail( "tiefland@weban.de",
108 
                        "Fehler beim Lesen der Akronyms", mysql_error() . "\n$sql\n",
109 
                        "FROM: tiefland@weban.de", "-F tiefland@weban.de" );
110 
                }
111 
                else
112 
                {
113 
                    if ( mysql_num_rows( $res ) )
114 
                    {
115 
                        $w_letter["letter"] = $letter;
116 
                        while ( $row = mysql_fetch_assoc( $res ) )
117 
                        {
118 
                            $word = $row["word"];
119 
                            $anfang = $word[0];
120 
                            $desc = $row["acronyms_desc"];
121 
                            $w_letter["words"][] = array( "word" => $word,
122 
                                "ID" => $desc, "anfang" => $anfang, );
123 
                        }
124 
                        $words[] = $w_letter;
125 
                        unset( $w_letter );
126 
                    }
127 
                }
128 
            }
129 
            break;
130 
    }
131 
    $GLOBALS["ui"]->assign( "webs", $webs );
132 
    $GLOBALS["ui"]->assign( "auswahl", $auswahl );
133 
    $GLOBALS["ui"]->assign( "letters", $words );
134 
    $GLOBALS["ui"]->assign( "anz", $anz );
135 
    $GLOBALS["ui"]->display( "acronyms.tpl" );
136 
?>