Users::deleteUserByAccount PHP Method

    public function deleteUserByAccount($account)
    {
        $this->db->beginTransaction();
        try {
            $res = Sql::select('uid')->from('uc_members')->where('username=?', $account)->forUpdate()->get($this->db);
            if (count($res) == 0) {
                $this->db->rollBack();
                return false;
            }
            $uid = $res[0]['uid'];
            Sql::deleteFrom('pre_common_member_profile')->where('uid=?', $uid)->exec($this->db);
            Sql::deleteFrom('uc_members')->where('uid=?', $uid)->exec($this->db);
            $this->db->commit();
        } catch (Exception $e) {
            $this->db->rollBack();
            throw $e;
        }
        return true;
    }