mysql.php

<?php

/*
+---------------------------------------------------------------------------
|   PHP-IRC v2.2.3 Service Release
|   ========================================================
|   by Manick
|   (c) 2001-2005 by http://www.phpbots.org/
|   Contact: manick@manekian.com
|   irc: #manekian@irc.rizon.net
|   ========================================
|   Maintained by g2x3k
|   2011-2015 https://github.com/g2x3k/php-irc
|   contant: g2x3k@layer13.net
|   irc: #root @ irc.layer13.net:+7000
+---------------------------------------------------------------------------
|   > Database class module
|   > Module written by Manick
|   > Module Version Number: 2.2.0
+---------------------------------------------------------------------------
|   > 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, post a pull request or issue on github and i will into it
|   > https://github.com/g2x3k/php-irc
|   >                                            maintained by g2x3k
+---------------------------------------------------------------------------
|   Changes
|   =======-------
|   > Update PixiBixi
|   > According to php7.0-mysqli
|   > Fixing functions
|   >                                            maintained by PixiBixi
+---------------------------------------------------------------------------
*/

class mysql
{

    private $dbIndex;
    private $prefix;
    private $queries = 0;
    public $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 = mysqli_connect($host,$user,$pass,$database);
		mysqli_set_charset($db,"utf8");

        if (!$db) {
            return;
        }

        $this->prefix = $prefix;
        $this->dbIndex = $db;
        $this->isConnected = true;
    }

    public function reconnect()
    {
        $db = mysqli_connect($this->host . ":" . $this->port, $this->user, $this->pass, true);

        if ($db === false) {
            return false;
        }

        $dBase = mysqli_select_db($this->database, $db);

        if ($dBase === false) {
            return false;
        }

        $this->dbIndex = $db;
        $this->isConnected = true;
        return true;
    }

    public function getInsid()
    {
        return (@mysqli_insert_id($this->dbIndex));
    }

    public function getErrno()
    {
        return (@mysqli_errno($this->dbIndex));
    }

    public function getError()
    {
        return (@mysqli_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 mysqli_real_escape_string($values[intval($id) - 1], $this->dbIndex);
    }

    public function query($query, $values = [])
    {

        if (!is_array($values))
            $values = array($values);

        $this->queries++;

        $data = mysqli_query($this->dbIndex,$query);

        if (!$data) {
            return false;
        } else
            return $data;
    }


    public function queryFetch($query, $values = array())
    {

        if (!is_array($values))
            $values = array($values);

        $this->queries++;

        $data = mysqli_query($this->dbIndex,$query);
        if (!$data) {
            return false;
        }

        return mysqli_fetch_array($data);
    }


    public function fetchArray($toFetch)
    {
        return mysqli_fetch_array($toFetch);
    }

    public function fetchRow($toFetch)
    {
        return mysqli_fetch_row($toFetch);
    }

    public function close()
    {
        @mysqli_close($this->dbIndex);
    }

    public function lastID()
    {
        return mysqli_insert_id();
    }

    public function numRows($toFetch)
    {
        return mysqli_num_rows($toFetch);
    }

    public function numQueries()
    {
        return $this->queries;
    }

}

?>