Subversion-Projekte lars-tiefland.em_wm

<?
        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");
        }
?>