Subversion-Projekte lars-tiefland.content-management

<?php
    //$Id$
    require_once  "../connect2.php";
    require_once  "Weban_Smarty.class.php";
    $GLOBALS["ui"] = new Weban_Smarty();
    $GLOBALS["ui"]->compile_dir = $_SERVER["DOCUMENT_ROOT"] . "/templates_c/";
    $GLOBALS["ui"]->compile_id = "Online-Shop|acronyms";
    $GLOBALS["ui"]->use_sub_dirs = true;

    /* ---------------------------------------------------------------------------------------------------------------- */
    /* INIT                                                                                                                                                                                                                     */
    /* ---------------------------------------------------------------------------------------------------------------- */
    // Session einleiten
    session_start();

    $mode = ( isset( $_GET["mode"] ) ) ? $_GET["mode"] : "";
    $id = ( isset( $_GET["ID"] ) ) ? $_GET["ID"] : 0;
    $id = intval( $id );

    switch ( $mode )
    {
        case "del":
            $sql = "
                DELETE FROM 
                    akronyms 
                WHERE 
                    ID=$id
            ";
            $res = mysql_query( $sql );
            if ( !$res )
            {
                mail( "tiefland@weban.de", "Fehler beim Lesen der Akronyms",
                    mysql_error() . "\n$sql\n", "FROM: tiefland@weban.de",
                    "-F tiefland@weban.de" );
            }
            header( "Location: " . $_SERVER['PHP_SELF'] );
            break;
        case "del_desc":
            $sql = "
                DELETE FROM 
                    akronyms_desc 
                WHERE 
                    ID=$id
            ";
            $res = mysql_query( $sql );
            if ( !$res )
            {
                mail( "tiefland@weban.de", "Fehler beim Lesen der Akronyms",
                    mysql_error() . "\n$sql\n", "FROM: tiefland@weban.de",
                    "-F tiefland@weban.de" );
            }
            header( "Location: " . $_SERVER['PHP_SELF'] );
            break;
        default:
            $b_letter = ( isset( $_GET["b_letter"] ) ) ? $_GET["b_letter"]:
            "";
            $anz = 0;
            $letters = array( "0", "1", "2", "3", "4", "5", "6", "7", "8",
                "9", "A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K",
                "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W",
                "X", "Y", "Z" );
            foreach ( $letters as $letter )
            {
                $sql = "
                    SELECT 
                        count(*) AS Anzahl 
                    FROM
                        akronyms 
                    WHERE 
                        word LIKE '" . $letter . "%'
                ";
                $res = mysql_query( $sql );
                $row = mysql_fetch_assoc( $res );
                if ( $row["Anzahl"] )
                {
                    $anz += $row["Anzahl"];
                    $nav[] = "<a href=\"?b_letter=$letter\">$letter</a>";
                }
                else
                {
                    $nav[] = $letter;
                }
            }
            $auswahl = implode( " | ", $nav ) . " | <a href=\"" . $_SERVER['PHP_SELF'] .
                "\">Alle anzeigen</a>";

            if ( $b_letter )
            {
                $letters = array( $b_letter );
            }

            foreach ( $letters as $letter )
            {
                $sql = "
                    SELECT 
                        ID, 
                        word, 
                        acronyms_desc 
                    FROM 
                        akronyms 
                    WHERE 
                        word LIKE '" . $letter . "%'
                ";
                $res = mysql_query( $sql );
                if ( !$res )
                {
                    mail( "tiefland@weban.de",
                        "Fehler beim Lesen der Akronyms", mysql_error() . "\n$sql\n",
                        "FROM: tiefland@weban.de", "-F tiefland@weban.de" );
                }
                else
                {
                    if ( mysql_num_rows( $res ) )
                    {
                        $w_letter["letter"] = $letter;
                        while ( $row = mysql_fetch_assoc( $res ) )
                        {
                            $word = $row["word"];
                            $anfang = $word[0];
                            $desc = $row["acronyms_desc"];
                            $w_letter["words"][] = array( "word" => $word,
                                "ID" => $desc, "anfang" => $anfang, );
                        }
                        $words[] = $w_letter;
                        unset( $w_letter );
                    }
                }
            }
            break;
    }
    $GLOBALS["ui"]->assign( "webs", $webs );
    $GLOBALS["ui"]->assign( "auswahl", $auswahl );
    $GLOBALS["ui"]->assign( "letters", $words );
    $GLOBALS["ui"]->assign( "anz", $anz );
    $GLOBALS["ui"]->display( "acronyms.tpl" );
?>