[help]hellevil 1.5

<?php
if(!defined('DATALIFEENGINE')) {
    die("Hacking attempt!");
}
class sql_db {
    var $persistency = "";
    var $user = "";
    var $password = "";
    var $server = "";
    var $dbname = "";
    var $db_connect_id;
    var $query_result;
    var $row = array();
    var $rowset = array();
    var $num_queries = 0;
    var $version = 0;
    var $debug = true;
    var $debug_die = true;
// Constructor
    function sql_db($sqlserver, $sqluser, $sqlpassword, $database, $version, $persistency = false) {
        $this->persistency = $persistency;
        $this->user = $sqluser;
        $this->password = $sqlpassword;
        $this->server = $sqlserver;
        $this->dbname = $database;
        $this->version = $version;
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 ($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 ($this->db_connect_id) {
                @mysql_query("SET NAMES cp1251", $this->db_connect_id);
            }
            return $this->db_connect_id;
        } else {
            return false;
        }
    }
function sql_close() {
        if($this->db_connect_id) {
            if($this->query_result) {
                @mysql_free_result($this->query_result);
            }
            $result = @mysql_close($this->db_connect_id);
            return $result;
        } else {
            return false;
        }
    }
// Выполнение запроса
    function sql_query($query = "", $transaction = FALSE) {
        $this->num_queries++;
        if ($this->dbname != "") {
            $dbselect = @mysql_select_db($this->dbname, $this->db_connect_id);
            if(!$dbselect) {
                @mysql_close($this->db_connect_id);
                $this->db_connect_id = $dbselect;
                return false;
            }
        }

        // Удаление предыдущих результатов
        unset($this->query_result);
        if ($query != "") {
            //$this->query_result = @mysql_query($query, $this->db_connect_id) || die(mysql_errno($this->db_connect_id));
            $this->query_result = mysql_query($query, $this->db_connect_id);
    
            // Вывод ошибки
            if ($this->debug && @mysql_errno($this->db_connect_id)) {
                $text = "<div style='font-family: verdana; font-size: 10px'>Ошибка запроса (".$this->server.", ".$this->dbname."): <p style='padding-left: 15px;'>".nl2br(trim($query))."</p>".mysql_errno($this->db_connect_id).", ".mysql_error($this->db_connect_id)."</div>";
                if ($this->debug_die) {
                    die ($text);
                } else {
                    echo ($text);
                }
            }
        }
        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;
        }
    }
    
    // Обработчик запросов
    function sql_query_jdb($table = "", $function = "", $param = array()) {
        return $this->sql_query(GetQuery($this->version, $table, $function, $param));
    }
// Количество записей
    function sql_numrows($query_id = 0) {
        if(!$query_id) {
            $query_id = $this->query_result;
        }
        if($query_id) {
            $result = @mysql_num_rows($query_id);
            return $result;
        } else {
            return false;
        }
    }
    
    // Количество обработанных записей
    function sql_affectedrows() {
        if($this->db_connect_id) {
            $result = @mysql_affected_rows($this->db_connect_id);
            return $result;
        } else {
            return false;
        }
    }
    
    // Обработчик результата
    function sql_fetchrow($query_id = 0) {
        if(!$query_id) {
            $query_id = $this->query_result;
        }
        if($query_id) {
            $this->row[$query_id] = @mysql_fetch_array($query_id);
            return $this->row[$query_id];
        } else {
            return false;
        }
    }
    
    function sql_fetchfield($field, $rownum = -1, $query_id = 0) {
        if(!$query_id) {
            $query_id = $this->query_result;
        }
        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];
                    } elseif($this->row[$query_id])    {
                        $result = $this->row[$query_id][$field];
                    }
                }
            }
            return $result;
        } else {
            return false;
        }
    }
    
    function sql_nextid() {
        if($this->db_connect_id) {
            $result = @mysql_insert_id($this->db_connect_id);
            return $result;
        } else {
            return false;
        }
    }
    
    function sql_freeresult($query_id = 0) {
        if (!$query_id) {
            $query_id = $this->query_result;
        }

        if ($query_id) {
            unset($this->row[$query_id]);
            unset($this->rowset[$query_id]);
            @mysql_free_result($query_id);
return true;
} else {
return false;
}}
function sql_error($query_id = 0) {
$result["message"] = @mysql_error($this->db_connect_id);
$result["code"] = @mysql_errno($this->db_connect_id);
return ($result["code"]>0)?$result:NULL;
}
function escape($str) {
if (function_exists('mysql_real_escape_string')) {
return mysql_real_escape_string($str, $this->db_connect_id);
} else {
return mysql_escape_string($str);
}}
function result($query_id = 0, $row = 0) {
return ($query_id) ? @mysql_result($query_id, $row) : false;}}
?>