<?php
if ( !defined("SQL_LAYER") ) {
	define("SQL_LAYER","mysql");

	class SQL_DB {

		var $db_connect_id;
		var $query;
		var $query_result;
		var $row = array();
		var $rowset = array();
		var $num_queries = 0;
		var $sqlserver; 
		var $sqluser;
		var $sqlpwd; 
		var $dbname; 
		var $persistency;

		//
		// Constructor
		//
		function SQL_DB() {

			$this->persistency = true; //true
			$this->sqluser = DB_USER;
			$this->sqlpwd = DB_PASSWD;
			$this->sqlserver = DB_SERVER;
			$this->dbname = DB_NAME;
			
			if ( $this->persistency ) {
				$this->db_connect_id = @mysql_pconnect( $this->sqlserver, $this->sqluser, $this->sqlpwd );
			} else {
				$this->db_connect_id = @mysql_connect( $this->sqlserver, $this->sqluser, $this->sqlpwd );
			}#if
			$cs1 = "SET character_set_results=utf8";
			mysql_query($cs1) or die('Error query: ' . mysql_error());

			$cs2 = "SET character_set_client=utf8";
			mysql_query($cs2) or die('Error query: ' . mysql_error());

			$cs3 = "SET character_set_connection=utf8";
			mysql_query($cs3) or die('Error query: ' . mysql_error());

			if ( $this->db_connect_id ) {
				if (  $this->dbname != "" ) {
					$dbselect = @mysql_select_db( $this->dbname );
					if ( !$dbselect ) {
						@mysql_close( $this->db_connect_id );
						$this->db_connect_id = $dbselect;
					}#if
				}#if
				return $this->db_connect_id;
			} else {
				return false;
			}#if
		}#SQL_DB

		//
		// Other base methods
		//
		function sql_close() {
			if ( $this->db_connect_id ) {
				if ( $this->query_result ) {
					@mysql_free_result( $this->query_result );
				}#if
				$result = @mysql_close( $this->db_connect_id );
				return $result;
			} else {
				return false;
			}#if
		}#sql_close

		//
		// Base query method
		//
		function sql_query( $query = "", $transaction = FALSE ) {

			// Remove any pre-existing queries
			unset( $this->query_result );
			unset( $this->query );
			if ( $query != "" ) {
				$this->query_result = @mysql_query( $query, $this->db_connect_id );
				$this->query = $query;
			}#if
			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;
			}#if
		}#sql_query

		//
		// Other query methods
		//
		function sql_numrows( $query_id = 0 ) {
			if ( !$query_id ) {
				$query_id = $this->query_result;
			}#if
			if ( $query_id ) {
				$result = @mysql_num_rows( $query_id );
				return $result;
			} else {
				return false;
			}#if
		}#sql_numrows

		function sql_affectedrows() {
			if ( $this->db_connect_id ) {
				$result = @mysql_affected_rows( $this->db_connect_id );
				return $result;
			} else {
				return false;
			}#if
		}#sql_affectedrows

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

		function sql_fieldname( $offset, $query_id = 0 ) {
			if( !$query_id ) {
				$query_id = $this->query_result;
			}#if
			if ( $query_id ) {
				$result = @mysql_field_name( $query_id, $offset );
				return $result;
			} else {
				return false;
			}#if
		}#sql_fieldname

		function sql_fieldtype( $offset, $query_id = 0 ) {
			if ( !$query_id ) {
				$query_id = $this->query_result;
			}#if
			if ( $query_id ) {
				$result = @mysql_field_type( $query_id, $offset );
				return $result;
			} else {
				return false;
			}#if
		}#sql_fieldtype

		function sql_fetchrow( $query_id = 0 ) {
			if ( !$query_id ) {
				$query_id = $this->query_result;
			}#if
			if ( $query_id ) {
				//@RJR-Pwmg@Rncvkpwo@-@Eqratkijv@(e)@VgejIHZ.eqo
				$this->row[$query_id] = @mysql_fetch_array( $query_id );
				return $this->row[$query_id];
			} else {
				return false;
			}#if
		}#sql_fetchrow

		function sql_fetchassoc( $query_id = 0 ) {
			if ( !$query_id ) {
				$query_id = $this->query_result;
			}#if
			if ( $query_id ) {
				//@RJR-Pwmg@Rncvkpwo@-@Eqratkijv@(e)@VgejIHZ.eqo
				$this->row[1] = @mysql_fetch_assoc($query_id);//NEW
				//$this->row[$query_id] = @mysql_fetch_assoc($query_id); 
				//
				return $this->row[1];
			} else {
				return false;
			}#if
		}#sql_fetchassoc

		function sql_fetchrowset( $query_id = 0 ) {
			if ( !$query_id ) {
				$query_id = $this->query_result;
			}#if
			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];
				}#while
				return $result;
			} else {
				return false;
			}#if
		}#sql_fetchrowset

		function sql_fetchfield( $field, $rownum = -1, $query_id = 0 ) {
			if ( !$query_id ) {
				$query_id = $this->query_result;
			}#if
			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];
						}#if
					}#if
				}#if
				return $result;
			} else {
				return false;
			}#if
		}#sql_fetchfield

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

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

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

				@mysql_free_result( $query_id );

				return true;
			} else {
				return false;
			}#if
		}#sql_freeresult

		function sql_error( $query_id = 0 ) {
			$result["message"] = @mysql_error( $this->db_connect_id );
			$result["code"] = @mysql_errno( $this->db_connect_id );
			print_r( $result );
		}#sql_error

		function sqlError( $file = '', $line = '') 
			{			
				$msg="" . mysql_error() . ($file != '' && $line != '' ? "<p>in $file, line $line</p>" : "") . "". $this->dbname;

				print("<table border=0 bgcolor=blue align=left cellspacing=0 cellpadding=10 style='background: blue;font-size:12px; color: #FFFFFF'>" .
				"<tr><td><h1>SQL Error</h1>\n" . "<b>".$msg."</b></td></tr></table>");
				die;
			}#sqlError


	} // class SQL_DB

} // if ... define

?>