169 lines
3.7 KiB
PHP
169 lines
3.7 KiB
PHP
<?php
|
|
/*
|
|
+---------------------------------------------------------------------------
|
|
| PHP-IRC v2.2.1 Service Release
|
|
| ========================================================
|
|
| by Manick
|
|
| (c) 2001-2005 by http://phpbots.sf.net/
|
|
| Contact: manick@manekian.com
|
|
| irc: #manekian@irc.rizon.net
|
|
| ========================================
|
|
+---------------------------------------------------------------------------
|
|
| > database module
|
|
| > Module written by Manick
|
|
| > Module Version Number: 2.2.0 alpha1
|
|
+---------------------------------------------------------------------------
|
|
| > 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.
|
|
| >
|
|
| > This program is distributed in the hope that it will be useful,
|
|
| > but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
| > MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
|
| > GNU General Public License for more details.
|
|
| >
|
|
| > You should have received a copy of the GNU General Public License
|
|
| > along with this program; if not, write to the Free Software
|
|
| > Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
|
|
+---------------------------------------------------------------------------
|
|
| Changes
|
|
| =======-------
|
|
| > If you wish to suggest or submit an update/change to the source
|
|
| > code, email me at manick@manekian.com with the change, and I
|
|
| > will look to adding it in as soon as I can.
|
|
+---------------------------------------------------------------------------
|
|
*/
|
|
|
|
class mysql {
|
|
|
|
private $dbIndex;
|
|
private $prefix;
|
|
private $queries = 0;
|
|
private $isConnected = false;
|
|
|
|
private $user;
|
|
private $pass;
|
|
private $database;
|
|
private $host;
|
|
private $port;
|
|
|
|
public function __construct($host, $database, $user, $pass, $prefix, $port = 3306)
|
|
{
|
|
$this->user = $user;
|
|
$this->pass = $pass;
|
|
$this->host = $host;
|
|
$this->database = $database;
|
|
$this->port = $port;
|
|
|
|
$db = mysql_connect($host . ":" . $port, $user, $pass);
|
|
|
|
if (!$db)
|
|
{
|
|
return;
|
|
}
|
|
|
|
$dBase = mysql_select_db($database, $db);
|
|
|
|
if (!$dBase)
|
|
{
|
|
return;
|
|
}
|
|
|
|
$this->prefix = $prefix;
|
|
$this->dbIndex = $db;
|
|
$this->isConnected = true;
|
|
}
|
|
|
|
public function getError()
|
|
{
|
|
return (@mysql_error($this->dbIndex));
|
|
}
|
|
|
|
public function isConnected()
|
|
{
|
|
return $this->isConnected;
|
|
}
|
|
|
|
//Call by reference switched to function declaration, 05/13/05
|
|
private function fixVar($id, &$values)
|
|
{
|
|
return mysql_real_escape_string($values[intval($id)-1], $this->dbIndex);
|
|
}
|
|
|
|
public function query($query, $values = array())
|
|
{
|
|
|
|
if (!is_array($values))
|
|
$values = array($values);
|
|
|
|
$query = preg_replace('/\[([0-9]+)]/e', "\$this->fixVar(\\1, \$values)", $query);
|
|
|
|
$this->queries++;
|
|
|
|
$data = mysql_query($query, $this->dbIndex);
|
|
|
|
if (!$data)
|
|
{
|
|
return false;
|
|
}
|
|
|
|
return $data;
|
|
}
|
|
|
|
|
|
public function queryFetch($query, $values = array())
|
|
{
|
|
|
|
if (!is_array($values))
|
|
$values = array($values);
|
|
|
|
$query = preg_replace('/\[([0-9]+)]/e', "\$this->fixVar(\\1, &\$values)", $query);
|
|
|
|
$this->queries++;
|
|
|
|
$data= mysql_query($query, $this->dbIndex);
|
|
|
|
if (!$data)
|
|
{
|
|
return false;
|
|
}
|
|
|
|
return mysql_fetch_array($data);
|
|
}
|
|
|
|
|
|
public function fetchArray($toFetch)
|
|
{
|
|
return mysql_fetch_array($toFetch);
|
|
}
|
|
|
|
public function fetchRow($toFetch)
|
|
{
|
|
return mysql_fetch_row($toFetch);
|
|
}
|
|
|
|
public function close()
|
|
{
|
|
@mysql_close($this->dbIndex);
|
|
}
|
|
|
|
public function lastID()
|
|
{
|
|
return mysql_insert_id();
|
|
}
|
|
|
|
public function numRows($toFetch)
|
|
{
|
|
return mysql_num_rows($toFetch);
|
|
}
|
|
|
|
public function numQueries()
|
|
{
|
|
return $this->queries;
|
|
}
|
|
|
|
}
|
|
|
|
?>
|
|
|