var $db_connect_id;
var $query_result;
var $int_num_queries = 0;
var $commitmode = true;
var $error_transaction = false;

function db($str_db_server, $str_db_user, $str_db_password, $str_db_name, $bool_persistency = false) {
    $this->server = $str_db_server;
    $this->user = $str_db_user;
    $this->password = $str_db_password;
    $this->dbname = $str_db_name;
    $this->persistency = $bool_persistency;

    if ($this->persistency) {
        $this->db_connect_id = @mysqli_pconnect($this->server, $this->user, $this->password, $this->dbname);
    } else {
        $this->db_connect_id = @mysqli_connect($this->server, $this->user, $this->password, $this->dbname);
    }
    if ($this->db_connect_id) {
        return $this->db_connect_id;
    } else {
        return false;
    }
}

function db_close() {
    if ($this->db_connect_id) {
        if ($this->query_result) {
            @mysqli_free_result($this->query_result);
        }
        $result = @mysqli_close($this->db_connect_id);
        return $result;
    } else {
        return false;
    }
}

function sql_query($query = "", $transaction = FALSE) {
    unset($this->query_result);
    if ($query != "") {
        $this->int_num_queries++;
        $this->query_result = @mysqli_query($this->db_connect_id, $query);
    }
    if ($this->query_result) {
        return $this->query_result;
    } else {
        if(!$this->commitmode){
            $this->error_transaction = true;
        }

        return false;
    }
}



function sql_numrows($query_id = 0) {
    if (!$query_id) {
        $query_id = $this->query_result;
    }
    if ($query_id) {
        $result = @mysqli_num_rows($query_id);
        return $result;
    } else {
        return false;
    }
}

function sql_fetchrow($query_id = 0) {
    if (!$query_id) {
        $query_id = $this->query_result;
    }
    if ($query_id) {
        return @mysqli_fetch_array($query_id);
    } else {
        return false;
    }
}

function sql_fetchassoc($query_id = 0) {
    if (!$query_id) {
        $query_id = $this->query_result;
    }
    if ($query_id) {
        return @mysqli_fetch_assoc($query_id);
    } else {
        return false;
    }
}

function sql_rowseek($rownum, $query_id = 0) {
    if (!$query_id) {
        $query_id = $this->query_result;
    }
    if ($query_id) {
        $result = @mysqli_data_seek($query_id, $rownum);
        return $result;
    } else {
        return false;
    }
}

function sql_freeresult($query_id = 0) {
    if (!$query_id) {
        $query_id = $this->query_result;
    }
    if ($query_id) {
        @mysqli_free_result($this->query_result);
        return true;
    } else {
        return false;
    }
}

function sql_nextid() {
    if ($this->db_connect_id) {
        $result = @mysqli_insert_id($this->db_connect_id);
        return $result;
    } else {
        return false;
    }
}

function sql_result($query_id = 0, $rownum, $fieldname = 0) {
    if (!$query_id) {
        $query_id = $this->query_result;
    }

    if ($query_id) {
        $result = @mysqli_result($query_id, $rownum, $fieldname);
        return $result;
    } else {
        return false;
    }
}
function beginTransaction() {
    $this->commitmode = false;
    mysqli_autocommit($this->db_connect_id, $this->commitmode);

}
function rollbackTransaction() {
    $this->commitmode = true;
    mysqli_rollback($this->db_connect_id);
    mysqli_autocommit($this->db_connect_id, $this->commitmode);
}

function commitTransaction() {
    if(!$this->commitmode){
        if($this->error_transaction){
            $this->rollbackTransaction();
            return false;
        }else{
            $this->commitmode = true;
            mysqli_commit($this->db_connect_id);
            mysqli_autocommit($this->db_connect_id, $this->commitmode);
            return true;
        }
    }
    return false;
}