Subversion-Projekte lars-tiefland.em_wm

	require("include/common.php");

    require ( "include/common.php" );

	$smarty->assign("title",$common["user_activation"]);

    $smarty->assign( "title", $common["user_activation"] );

	if (isset($_GET["key"]))

    if ( isset($_GET["key"]) )

	{

    {

		$key=$_GET["key"];

        $key = $_GET["key"];

	elseif (isset($_POST["key"]))

    } elseif ( isset($_POST["key"]) )

	{

    {

		$key=$_POST["key"];

        $key = $_POST["key"];

	}

    }

	else

    else

	{

    {

		$key="";

        $key = "";

	}

    }

	if ($key!="")

    if ( $key != "" )

	{

    {

		$key=addslashes($key);

        $key = addslashes( $key );

		$sql="SELECT * FROM auth_user WHERE u_key='$key' AND u_active=0";

        $sql = "SELECT * FROM auth_user WHERE u_key='$key' AND u_active=0";

		$res=$db->query($sql);

        $res = $db->query( $sql );

		if (!DB::isError($res))

        if ( !DB::isError($res) )

		{

        {

			$data=$res->fetchRow();

            $data = $res->fetchRow();

			if (!count($data))

            if ( !count($data) )

			{

            {

				$smarty->assign("key",$key);

                $smarty->assign( "key", $key );

				$smarty->assign("meld","Key not found!");

                $smarty->assign( "meld", "Key not found!" );

				$smarty->assign("db_meld","");

                $smarty->assign( "db_meld", "" );

				$smarty->assign("error",true);

                $smarty->assign( "error", true );

				$smarty->display("activate.tpl");

                $smarty->display( "activate.tpl" );

			}

            }

			else

            else

			{

            {

				$u_id=$data["u_id"];

                $u_id = $data["u_id"];

				$u_name=$data["u_name"];

                $u_name = $data["u_name"];

				$sql_u="UPDATE auth_user SET u_key='', u_active=1 WHERE u_id=$u_id";

                    "UPDATE auth_user SET u_key='', u_active=1 WHERE u_id=$u_id";

				$res_u=$db->query($sql_u);

                $res_u = $db->query( $sql_u );

				if (DB::isError($res_u))

                if ( DB::isError($res_u) )

				{

                {

					$smarty->assign("meld",$common["an_error_occured"]);

                    $smarty->assign( "meld", $common["an_error_occured"] );

					$smarty->assign("db_meld",$res_u->getUserInfo());

                    $smarty->assign( "db_meld", $res_u->getUserInfo() );

					$smarty->assign("error",true);

                    $smarty->assign( "error", true );

					$smarty->display("meld.tpl");

                    $smarty->display( "meld.tpl" );

				}

                }

				else

                else

				{

                {

					$smarty->assign("meld",sprintf($common["user_activated"],$u_name));

                    $smarty->assign( "meld", sprintf($common["user_activated"],

					$smarty->assign("db_meld",$common["can_login_now"]);

                    $smarty->assign( "db_meld", $common["can_login_now"] );

					$smarty->assign("error",false);

                    $smarty->assign( "error", false );

					$smarty->display("meld.tpl");

                    $smarty->display( "meld.tpl" );

				}

                }

			}

            }

		}

        }

		else

        else

		{

        {

				$smarty->assign("key",$key);

            $smarty->assign( "key", $key );

				$smarty->assign("meld",$common["an_error_occured"]);

            $smarty->assign( "meld", $common["an_error_occured"] );

				$smarty->assign("db_meld",$res->getUserInfo());

            $smarty->assign( "db_meld", $res->getUserInfo() );

				$smarty->assign("error",true);

            $smarty->assign( "error", true );

				$smarty->display("activate.tpl");

            $smarty->display( "activate.tpl" );

		}

        }

	}

    }

	else

    else

	{

    {

		$smarty->assign("key","");

        $smarty->assign( "key", "" );

		$smarty->display("activate.tpl");

        $smarty->display( "activate.tpl" );

	}

    }