<?php
$db = new sql_db(&#39;localhost&#39;,&#39;user&#39;,&#39;pass&#39;,&#39;datebase_pl&#39;);

if(!defined("SQL_LAYER"))
{
        define("SQL_LAYER","mysql");
        class sql_db
        {
                var $total_queries;
                var $db_connect_id;
                var $query_result;
                var $row = array();
                var $rowset = array();
                var $num_queries = 0;
                function sql_db($sqlserver, $sqluser, $sqlpassword, $database, $persistency = true)
                {
                        $this->persistency = $persistency;
                        $this->user = $sqluser;
                        $this->password = $sqlpassword;
                        $this->server = $sqlserver;
                        $this->dbname = $database;
                        if($this->persistency)
                        {
                                $this->db_connect_id = @mysql_pconnect($this->server, $this->user, $this->password);
                        }
                        else
                        {
                                $this->db_connect_id = @mysql_connect($this->server, $this->user, $this->password);
                        }
                        if($this->db_connect_id)
                        {
                                if($database != "")
                                {
                                        $this->dbname = $database;
                                        $dbselect = @mysql_select_db($this->dbname);
                                        if(!$dbselect)
                                        {
                                                @mysql_close($this->db_connect_id);
                                                $this->db_connect_id = $dbselect;
                                        }
                                }
                                return $this->db_connect_id;
                        }
                        else
                        {
                                return false;
                        }
                }
                function sql_close()
                {
                        if($this->db_connect_id)
                        {
                                if($this->query_result)
                                {
                                        @mysql_free_result($this->query_result);
                                }
                                $result = @mysql_close($this->db_connect_id);
                                return $result;
                        }
                        else
                        {
                                return false;
                        }
                }

                function sql_query($query = "", $transaction = FALSE)
                {
                        // Remove any pre-existing queries
                        unset($this->query_result);
                        if($query != "")
                        {
                                $this->query_result = @mysql_query($query, $this->db_connect_id);
                                $this->total_queries = $this->total_queries + 1;
                        }
                        if($this->query_result)
                        {
                                unset($this->row[$this->query_result]);
                                unset($this->rowset[$this->query_result]);
                                return $this->query_result;
                        }
                        else
                        {
                                return ( $transaction == END_TRANSACTION ) ? true : false;
                        }
                }
                function sql_numrows($query_id = 0)
                {
                        if(!$query_id)
                        {
                                $query_id = $this->query_result;
                        }
                        if($query_id)
                        {
                                $result = @mysql_num_rows($query_id);
                                return $result;
                        }
                        else
                        {
                                return false;
                        }
                }
                function sql_affectedrows()
                {
                        if($this->db_connect_id)
                        {
                                $result = @mysql_affected_rows($this->db_connect_id);
                                return $result;
                        }
                        else
                        {
                                return false;
                        }
                }
                function sql_numfields($query_id = 0)
                {
                        if(!$query_id)
                        {
                                $query_id = $this->query_result;
                        }
                        if($query_id)
                        {
                                $result = @mysql_num_fields($query_id);
                                return $result;
                        }
                        else
                        {
                                return false;
                        }
                }
                function sql_fieldname($offset, $query_id = 0)
                {
                        if(!$query_id)
                        {
                                $query_id = $this->query_result;
                        }
                        if($query_id)
                        {
                                $result = @mysql_field_name($query_id, $offset);
                                return $result;
                        }
                        else
                        {
                                return false;
                        }
                }
                function sql_fieldtype($offset, $query_id = 0)
                {
                        if(!$query_id)
                        {
                                $query_id = $this->query_result;
                        }
                        if($query_id)
                        {
                                $result = @mysql_field_type($query_id, $offset);
                                return $result;
                        }
                        else
                        {
                                return false;
                        }
                }
                function sql_fetchrow($query_id = 0)
                {
                        if(!$query_id)
                        {
                                $query_id = $this->query_result;
                        }
                        if($query_id)
                        {
                                $this->row[$query_id] = @mysql_fetch_array($query_id);
                                return $this->row[$query_id];
                        }
                        else
                        {
                                return false;
                        }
                }
                function sql_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))
                                {
                                        $result[] = $this->rowset[$query_id];
                                }
                                return $result;
                        }
                        else
                        {
                                return false;
                        }
                }
                function sql_fetchfield($field, $rownum = -1, $query_id = 0)
                {
                        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->sql_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 sql_rowseek($rownum, $query_id = 0){
                        if(!$query_id)
                        {
                                $query_id = $this->query_result;
                        }
                        if($query_id)
                        {
                                $result = @mysql_data_seek($query_id, $rownum);
                                return $result;
                        }
                        else
                        {
                                return false;
                        }
                }
                function sql_nextid(){
                        if($this->db_connect_id)
                        {
                                $result = @mysql_insert_id($this->db_connect_id);
                                return $result;
                        }
                        else
                        {
                                return false;
                        }
                }
                function sql_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 sql_error($query_id = 0)
                {
                        $result["message"] = @mysql_error($this->db_connect_id);
                        $result["code"] = @mysql_errno($this->db_connect_id);
                        return $result;
                }
                function __sleep()
                {
                        $this->sql_close();
                }
                function __wakeup()
                {
                        $this->sql_db($sqlserver, $sqluser, $sqlpassword, $database, $persistency = true);
                }
        }
}

?>