Subversion-Projekte lars-tiefland.em_wm

<?php
    require ( "include/common.php" );
    $smarty->assign( "title", $common["user_activation"] );
    if ( isset( $_GET["key"] ) )
    {
        $key = $_GET["key"];
    } elseif ( isset( $_POST["key"] ) )
    {
        $key = $_POST["key"];
    }
    else
    {
        $key = "";
    }
    if ( $key != "" )
    {
        $key = addslashes( $key );
        $sql = "SELECT * FROM auth_user WHERE u_key='$key' AND u_active=0";
        $res = $db->query( $sql );
        if ( ! DB::isError( $res ) )
        {
            $data = $res->fetchRow();
            if ( ! count( $data ) )
            {
                $smarty->assign( "key", $key );
                $smarty->assign( "meld", "Key not found!" );
                $smarty->assign( "db_meld", "" );
                $smarty->assign( "error", true );
                $smarty->display( "activate.tpl" );
            }
            else
            {
                $u_id = $data["u_id"];
                $u_name = $data["u_name"];
                $sql_u = "UPDATE auth_user SET u_key='', u_active=1 WHERE u_id=$u_id";
                $res_u = $db->query( $sql_u );
                if ( DB::isError( $res_u ) )
                {
                    $smarty->assign( "meld", $common["an_error_occured"] );
                    $smarty->assign( "db_meld", $res_u->getUserInfo() );
                    $smarty->assign( "error", true );
                    $smarty->display( "meld.tpl" );
                }
                else
                {
                    $smarty->assign( "meld", sprintf( $common["user_activated"],
                        $u_name ) );
                    $smarty->assign( "db_meld", $common["can_login_now"] );
                    $smarty->assign( "error", false );
                    $smarty->display( "meld.tpl" );
                }
            }
        }
        else
        {
            $smarty->assign( "key", $key );
            $smarty->assign( "meld", $common["an_error_occured"] );
            $smarty->assign( "db_meld", $res->getUserInfo() );
            $smarty->assign( "error", true );
            $smarty->display( "activate.tpl" );
        }
    }
    else
    {
        $smarty->assign( "key", "" );
        $smarty->display( "activate.tpl" );
    }
?>