<?php
/***************************************************************************
 *                                 mysql.php
 *                            -------------------
 *   begin                : Saturday, Feb 13, 2001
 *   copyright            : (C) 2001 The phpBB Group
 *   email                : support@phpbb.com
 *
 *   $Id: mysql.php,v 1.16 2002/03/19 01:07:36 psotfx Exp $
 *
 ***************************************************************************/

/***************************************************************************
 *
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 *
 ***************************************************************************/

/***************************************************************************
 * PHP-Nuke Platinum: Expect to be impressed                      COPYRIGHT
 *
 * Copyright (c) 2004 - 2006 by http://www.techgfx.com
 *     Techgfx - Graeme Allan                       (goose@techgfx.com)
 *
 * Copyright (c) 2004 - 2006 by http://www.conrads-berlin.de
 *     MrFluffy - Axel Conrads                 (axel@conrads-berlin.de)
 *
 * Refer to TechGFX.com for detailed information on PHP-Nuke Platinum
 *
 * TechGFX: Your dreams, our imagination
 ***************************************************************************/

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;

		//
		// Constructor
		//
		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
		/**/
		$cs1 = "SET character_set_results=tis620";
		mysql_query($cs1) or die('Error query: ' . mysql_error());

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

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


			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;
					}#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[$query_id] = @mysql_fetch_assoc( $query_id );
				return $this->row[$query_id];
			} 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 );
			return $result;
		}#sql_error

	} // class sql_db

} // if ... define

?>