Mysql convertir a Mysqli

[creativobook]

hola amigos necesito ayuda alguien me puede decir como cambiar de msql a mysql ? hasta el momento he logrado este pero me resulta este error

Parse error: syntax error, unexpected '}' in /Applications/MAMP/htdocs/tequila/include/php/database.php on line 301

Código PHP:

<?php
include("constants.php"); 
 
class MySQLDB
{
    var $connection;
    var $num_active_users; 
    var $num_active_guests; 
    var $num_members; 
   
    function MySQLDB()
    {
        /* Make connection to database */
        $connection = mysqli_connect(andres, root, root);
      
 
        $query = mysqli_query($connection, "SELECT * FROM testing");
 
        while ($results = mysqli_fetch_array($query)) {
            # code...
            echo $results[username] . " " . $results[password];
        }
        }
    }
    
    
    function confirmUserPass($username, $password)
    {
        if (!get_magic_quotes_gpc()) {
            $username = addslashes($username);
        }
        
        $q      = "SELECT password FROM " . TBL_USERS . " WHERE username = '$username'";
        $result = mysqli_query($q, $this->connection);
        if (!$result || (mysql_numrows($result) < 1)) {
            return 1; //Indicates username failure
        }
       
        $dbarray             = mysql_fetch_array($result);
        $dbarray['password'] = stripslashes($dbarray['password']);
        $password            = stripslashes($password);
        
        
        if ($password == $dbarray['password']) {
            return 0; 
        } else {
            return 2; 
        }
    }
    
 
    function confirmUserID($username, $userid)
    {
        if (!get_magic_quotes_gpc()) {
            $username = addslashes($username);
        }
        
        $q      = "SELECT userid FROM " . TBL_USERS . " WHERE username = '$username'";
        $result = mysqli_query($q, $this->connection);
        if (!$result || (mysql_numrows($result) < 1)) {
            return 1; //Indicates username failure
        }
        
        $dbarray           = mysql_fetch_array($result);
        $dbarray['userid'] = stripslashes($dbarray['userid']);
        $userid            = stripslashes($userid);
        
        if ($userid == $dbarray['userid']) {
            return 0; //Success! Username and userid confirmed
        } else {
            return 2; //Indicates userid invalid
        }
    }
  
    function usernameTaken($username)
    {
        if (!get_magic_quotes_gpc()) {
            $username = addslashes($username);
        }
        $q      = "SELECT username FROM " . TBL_USERS . " WHERE username = '$username'";
        $result = mysqli_query($q, $this->connection);
        return (mysql_numrows($result) > 0);
    }
    
    function usernameBanned($username)
    {
        if (!get_magic_quotes_gpc()) {
            $username = addslashes($username);
        }
        $q      = "SELECT username FROM " . TBL_BANNED_USERS . " WHERE username = '$username'";
        $result = mysqli_query($q, $this->connection);
        return (mysql_numrows($result) > 0);
    }
   
    function addNewUser($username, $password, $email)
    {
        $time = time();
        /* If admin sign up, give admin user level */
        if (strcasecmp($username, ADMIN_NAME) == 0) {
            $ulevel = ADMIN_LEVEL;
        } else {
            $ulevel = USER_LEVEL;
        }
        $q = "INSERT INTO " . TBL_USERS . " VALUES ('$username', '$password', '0', $ulevel, '$email', $time, 'red')";
        return mysqli_query($q, $this->connection);
    }
    
    
    function updateUserField($username, $field, $value)
    {
        $q = "UPDATE " . TBL_USERS . " SET " . $field . " = '$value' WHERE username = '$username'";
        return mysqli_query($q, $this->connection);
    }
    
    function getUserInfo($username)
    {
        $q      = "SELECT * FROM " . TBL_USERS . " WHERE username = '$username'";
        $result = mysqli_query($q, $this->connection);
        /* Error occurred, return given name by default */
        if (!$result || (mysql_numrows($result) < 1)) {
            return NULL;
        }
        /* Return result array */
        $dbarray = mysql_fetch_array($result);
        return $dbarray;
    }
    
    function getNumMembers()
    {
        if ($this->num_members < 0) {
            $q                 = "SELECT * FROM " . TBL_USERS;
            $result            = mysqli_query($q, $this->connection);
            $this->num_members = mysql_numrows($result);
        }
        return $this->num_members;
    }
  
    function calcNumActiveUsers()
    {
        $q                      = "SELECT * FROM " . TBL_ACTIVE_USERS;
        $result                 = mysqli_query($q, $this->connection);
        $this->num_active_users = mysql_numrows($result);
    }
    
    function calcNumActiveGuests()
    {
 
        $q                       = "SELECT * FROM " . TBL_ACTIVE_GUESTS;
        $result                  = mysqli_query($q, $this->connection);
        $this->num_active_guests = mysql_numrows($result);
    }
    
   
    function addActiveUser($username, $time)
    {
        $q = "UPDATE " . TBL_USERS . " SET timestamp = '$time' WHERE username = '$username'";
        mysqli_query($q, $this->connection);
        
        if (!TRACK_VISITORS)
            return;
        $q = "REPLACE INTO " . TBL_ACTIVE_USERS . " VALUES ('$username', '$time')";
        mysqli_query($q, $this->connection);
        $this->calcNumActiveUsers();
    }
  
    function addActiveGuest($ip, $time)
    {
        if (!TRACK_VISITORS)
            return;
        $q = "REPLACE INTO " . TBL_ACTIVE_GUESTS . " VALUES ('$ip', '$time')";
        mysqli_query($q, $this->connection);
        $this->calcNumActiveGuests();
    }
   
    function removeActiveUser($username)
    {
        if (!TRACK_VISITORS)
            return;
        $q = "DELETE FROM " . TBL_ACTIVE_USERS . " WHERE username = '$username'";
        mysqli_query($q, $this->connection);
        $this->calcNumActiveUsers();
    }
  
    function removeActiveGuest($ip)
    {
        if (!TRACK_VISITORS)
            return;
        $q = "DELETE FROM " . TBL_ACTIVE_GUESTS . " WHERE ip = '$ip'";
        mysqli_query($q, $this->connection);
        $this->calcNumActiveGuests();
    }
 
    function removeInactiveUsers()
    {
        if (!TRACK_VISITORS)
            return;
        $timeout = time() - USER_TIMEOUT * 60;
        $q       = "DELETE FROM " . TBL_ACTIVE_USERS . " WHERE timestamp < $timeout";
        mysqli_query($q, $this->connection);
        $this->calcNumActiveUsers();
    }
    
    function removeInactiveGuests()
    {
        if (!TRACK_VISITORS)
            return;
        $timeout = time() - GUEST_TIMEOUT * 60;
        $q       = "DELETE FROM " . TBL_ACTIVE_GUESTS . " WHERE timestamp < $timeout";
        mysqli_query($q, $this->connection);
        $this->calcNumActiveGuests();
    }
    
    function query($query)
    {
        return mysqli_query($query, $this->connection);
    }
}
$database = new MySQLDB;
 
?>