eduVPN / vpn-server-api

        return $stmt->fetch(PDO::FETCH_ASSOC);

    }

    public function getVootToken($userId)

    {

        $userId = $this->getId($userId);

        $stmt = $this->db->prepare(

<<< 'SQL'

    SELECT

        voot_token

    FROM 

        voot_tokens

    WHERE 

        user_id = :user_id

SQL

        );

        $stmt->bindValue(':user_id', $userId, PDO::PARAM_INT);

        $stmt->execute();

        return $stmt->fetchColumn();

    }

    public function setVootToken($userId, $vootToken)

    {

        return 1 === (int) $stmt->fetchColumn();

    }

    public function getTotpSecret($userId)

    {

        $userId = $this->getId($userId);

        $stmt = $this->db->prepare(

<<< 'SQL'

    SELECT

        totp_secret

    FROM 

        totp_secrets

    WHERE 

        user_id = :user_id

SQL

        );

        $stmt->bindValue(':user_id', $userId, PDO::PARAM_INT);

        $stmt->execute();

        return $stmt->fetchColumn();

    }

    public function setTotpSecret($userId, $totpSecret)

    {

        return $stmt->fetchColumn();

    }

    public function setMotd($motdMessage)

    {

        $this->deleteMotd();

        $stmt = $this->db->prepare(

<<< 'SQL'

    INSERT INTO motd 

        (motd_message) 

    VALUES

        (:motd_message)

SQL

        );

        $stmt->bindValue(':motd_message', $motdMessage, PDO::PARAM_STR);

        $stmt->execute();