mysql.php

Go to the documentation of this file.

<?php
/***************************************************************************
 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.
 ***************************************************************************/

Class Mysql {

  var $link_id  = 0;        
  var $query_id = 0;        
  var $aRecord  = array();  

  var $strError     = '';   
  var $intErrno     = 0;    
  var $booShowError = true; 
  var $strLogfile   = 'mysql_error.log';    
  var $intQueryCount = 0;   

  var $tblActionlog;
  var $tblGuild;
  var $tblMap;
  var $tblMapData;
  var $tblPlayer;
  var $tblTown;
  var $tblUser;
  var $tblUsergroup;

    function Mysql ( $strServer, $strUser, $strPass, $strDB ) {
        if ( 0 == $this->link_id ) {
            $this->link_id = mysql_connect ( $strServer, $strUser, $strPass );

            if ( !$this->link_id ) {
                $this->print_error ( 'Link-ID == false, connect failed' );
                return false;
            }
            if ( $strDB != '' ) {
                return $this->select_db ( $strDB );
            }
            return true;
        }
        return false;
    }

    function setPrefix( $str )
    {
        $this->tblActionlog = $str.'actionlog';
        $this->tblGuild     = $str.'guild';
        $this->tblMap       = $str.'map';
        $this->tblMapData   = $str.'map_data';
        $this->tblPlayer    = $str.'player';
        $this->tblTown      = $str.'town';
        $this->tblUser      = $str.'user';
        $this->tblUsergroup = $str.'usergroup';
    }

    function getError() {
        $this->strError = mysql_error();
        return $this->strError;
    }

    function getErrno() {
        $this->intErrno = mysql_errno();
        return $this->intErrno;
    }

    function select_db ( $strDB = '' ) {
        if ( !@mysql_select_db ( $strDB, $this->link_id ) ) {
            $this->print_error ( 'cannot use database '.$strDB );
            return false;
        }
        return true;
    }

    function query ( $strQuery ) {
        $this->query_id = @mysql_query ( $strQuery, $this->link_id );

        $this->intQueryCount++;
        if ( !$this->query_id ) {
            $this->print_error( $strQuery );
            return false;
        }
        return $this->query_id;
    }

    function fetch_array ( $query_id = -1 ) {
        if ( $query_id != -1 ) {
            $this->query_id = $query_id;
        }
        $this->record = @mysql_fetch_array ( $this->query_id );
        return $this->record;
    }

    function fetch_assoc ( $query_id = -1 ) {
        if ( $query_id != -1 ) {
            $this->query_id = $query_id;
        }
        $this->record = @mysql_fetch_assoc ( $this->query_id );
        return $this->record;
    }

    function fetch_row ( $query_id = -1 ) {
        if ( $query_id != -1 ) {
            $this->query_id = $query_id;
        }
        $this->record = @mysql_fetch_row ( $this->query_id );
        return $this->record;
    }

    function free_result ( $query_id = -1 ) {
        if ( $query_id != -1 ) {
            $this->query_id = $query_id;
        }
        return @mysql_free_result ( $this->query_id );
    }

    function query_first ( $strQuery ) {
        $this->query ( $strQuery );
        $returnarray = $this->fetch_array($this->query_id);
        $this->free_result($this->query_id);
        return $returnarray;
    }

    function num_rows ( $query_id = -1 ) {
        if ( $query_id != -1 ) {
            $this->query_id = $query_id;
        }
        return @mysql_num_rows ( $this->query_id );
    }

    function affected_rows() {
        return @mysql_affected_rows();
    }

    function insert_id() {
        return @mysql_insert_id ( $this->link_id );
    }

    function print_error ( $msg )
    {
        global $strTmpl_inhalt, $strTmplNav;
        $this->getError();
        $this->getErrno();

        if ( $this->intErrno == 1146 && isset ( $GLOBALS['oStyle'] ) )
        {
            // table does not exist, print special error
            $oStyle =& $GLOBALS['oStyle'];
            $oStyle->addReplacements ( array ( 'DB_TABLE' => $this->strError ) );
            $strTmpl_inhalt = $oStyle->get_area ( 'NoDbMsg' );
            $strTmplNav = '';
            output();
        }

        $line = 0;
        $file = '';
        $debug = debug_backtrace();
        for ( $i = 0; $i < count ( $debug ); $i++ ) {
            if ( $debug[$i]['file'] != __FILE__ ) {
                $line = $debug[$i]['line'];
                $file = $debug[$i]['file'];
                $i    = count ( $debug );
            }
        }

        if( $this->strLogfile != '' && is_writable( $this->strLogfile ) )
        {
            $logfile  = fopen ( $this->strLogfile, 'a' );
            // strip line breaks
            $msg = str_replace("\n", '', str_replace("\r\n", '', $msg) );
            $error = sprintf ('%s : #%04d - %s in Datei: %s, Zeile: %d %s', date("Y/m/d H:i:s"), $this->intErrno, '"'.$msg.'" Meldung: '.$this->strError, $file, $line, "\n");
            fputs ( $logfile, $error );
            fclose( $logfile);
        }

        $message  = '<pre>';
        $message .= "<b>Database error!</b>\n";
        $message .= "SQL Query:          $msg\n";
        $message .= "mysql error:        $this->strError\n";
        $message .= "mysql error number: $this->intErrno\n";
        $message .= "Date:               ".date("d.m.Y @ H:i")."\n";
        if ( $line > 0 && $file ) {
            $message .= "File:               <b>".$file.'</b> on line <b>'.$line."</b>\n";
        }
        $message .= "Referer:            ".getenv('HTTP_REFERER')."\n";
        if( $this->strLogfile != '' && !is_writable( $this->strLogfile ) )
        {
            $message .= "Fehlerlog konnte nicht geschrieben werden.";
        }
        $message .= "</pre>\n";

        if ( $this->booShowError ) {
            @ob_end_clean();
            @ob_start();
            die($message);
        } else {
            echo "\n<!-- SQL Fehler: $msg -->\n";
        }
    }
}

---