define('BEGIN_TRANSACTION', 1);
define('END_TRANSACTION', 2);

/***************************************************************************
*                                MySQL Class
*                            -------------------                        
*   Created              : Tuesday, Mar 11, 2003
*   Copyright            : (C) 2003 ENIGMA Designs - PHPBIT
*   Email                : support@3nigma.com                          
*                                                          
*                                                        
*                                                            
*
***************************************************************************/

class db {
var $db_connect_id;
var $query_result;
var $row = array();
var $rowset = array();
var $num_queries = 0;
var $in_transaction = 0;

function db ($server, $username, $password, $database, $persistence = false) {
 $this->server = $server;
 $this->username = $username;
 $this->password = $password;
 $this->database = $database;
 $this->persistence = $persistence;
 
 $this->db_connect_id = ($this->persistence) ? mysql_pconnect($server, $username, $password) : mysql_connect($server, $username, $password);
 
 if ($this->db_connect_id) {
  if ($database != "") {
   mysql_select_db($this->database);
  } else {
   return false;
  }
 
  return $this->db_connect_id;
 } else {
  return false;
 }
}

function close () {
 if ($this->db_connect_id) {
  if ($this->in_transaction) {
   mysql_query("COMMIT", $this->db_connect_id);
  }
 
  return mysql_close($this->db_connect_id);
 } else {
  return false;
 }
}

function query ($query = "", $transaction = false) {
 unset($this->query_result);
 
 if ($query != "") {
  $this->num_queries++;
 
  if ($transaction == BEGIN_TRANSACTION && !$this->in_transaction) {
   
   if (!mysql_query("BEGIN", $this->cb_connect_id)) {
   
    return false;
   }
   
   $this->in_transaction = true;
  }
 
  $this->query_result = mysql_query($query, $this->db_connect_id);
 } else {
  if ($transaction == END_TRANSACTION && $this->in_transaction) {
   $this->in_transaction = false;
   
   if (!mysql_query("COMMIT", $this->db_connect_id)) {
    mysql_query("ROLLBACK", $this->db_connect_id);
   
    return false;
   }
  }
 }
 
 if ($this->query_result) {
  unset($this->row[$this->query_result]);
  unset($this->rowset[$this->query_result]);
 
  if ($transaction == END_TRANSACTION && $this->in_transaction) {
   $this->in_transaction = false;
   
   if (!mysql_query("COMMIT", $this->db_connect_id)) {
    mysql_query("ROLLBACK", $this->db_connect_id);
   
    return false;
   }
  }
 
  return $this->query_result;
 } else {
  if ($this->in_transaction) {
   mysql_query("ROLLBACK", $this->db_connect_id);
   
   $this->in_transaction = false;
  }
 
  return false;
 }
}

function numrows ($query_id = 0) {
 if (!$query_id) {
  $query_id = $this->query_result;
 }
 
 return ($query_id) ? mysql_num_rows($query_id) : false;
}

function affectedrows () {
 return ($this->db_connect_id) ? mysql_affected_rows($this->db_connect_id) : false;
}

function numfields ($query_id = 0) {
 if (!$query_id) {
  $query_id = $this->query_result;
 }
 
 return ($query_id) ? mysql_num_fields($query_id) : false;
}

function fieldname ($query_id = 0, $offset) {
 if (!$query_id) {
  $query_id = $this->query_result;
 }
 
 return ($query_id) ? mysql_field_name($query_id, $offset) : false;
}

function fieldtype ($query_id = 0, $offset) {
 if (!$query_id) {
  $query_id = $this->query_result;
 }
 
 return ($query_id) ? mysql_field_type($query_id, $offset) : false;
}

function fetchrow ($query_id = 0) {
 if (!$query_id) {
  $query_id = $this->query_result;
 }
 
 if ($query_id) {
  $this->row[$query_id] = mysql_fetch_array($query_id, MYSQL_ASSOC);
 
  return $this->row[$query_id];
 } else {
  return false;
 }
}

function fetchrowset ($query_id = 0) {
 if (!$query_id) {
  $query_id = $this->query_result;
 }
 
 if ($query_id) {
  unset($this->rowset[$query_id]);
  unset($this->row[$query_id]);

  while($this->rowset[$query_id] = mysql_fetch_array($query_id, MYSQL_ASSOC)) {
   $result[] = $this->rowset[$query_id];
  }

  return $result;
 } else {
  return false;
 }
}

function fetchfield ($query_id = 0, $rownum = -1, $field) {
 if (!$query_id) {
  $query_id = $this->query_result;
 }
 
 if ($query_id) {
  if ($rownum > -1) {
   $result = mysql_result($query_id, $rownum, $field);
  } else {
   if (empty($this->row[$query_id]) && empty($this->rowset[$query_id])) {
    if ($this->fetchrow()) {
     $result = $this->row[$query_id][$field];
    } else {
     if ($this->rowset[$query_id]) {
      $result = $this->rowset[$query_id][$field];
     } else if ($this->row[$query_id]) {
      $result = $this->row[$query_id][$field];
     }
    }
   }
  }
 
  return $result;
 } else {
  return false;
 }
}

function rowseek ($query_id = 0, $rownum) {
 if (!$query_id) {
  $query_id = $this->query_result;
 }
 
 return ($query_id) ? mysql_data_seek($query_id, $rownum) : false;
}

function nextid () {
 return ($this->db_connect_id) ? mysql_insert_id($this->db_connect_id) : false;
}

function freeresult ($query_id = 0) {
 if (!$query_id) {
  $query_id = $this->query_result;
 }
 
 if ($query_id) {
  unset($this->row[$query_id]);
  unset($this->rowset[$query_id]);
 
  mysql_free_result($query_id);
 
  return true;
 } else {
  return false;
 }
}

function error () {
 $result['message'] = mysql_error($this->db_connect_id);
 $result['code'] = mysql_errno($this->db_connect_id);
 
 return $result;
}
}