Skip to content
La2Base
Home
DownloadsWikiForumFAQ
Search
ruen
Sign up Login
HomeFilesWikiLogin
  • Home
  • Downloads
  • Wiki
  • FAQ
  • Contact Us
  • About
  • Rules
  • Privacy
  • Terms of Service

© 2026 la2base.com · All rights reserved

ruen
Forum/Web обвязка/[Помощь] Dle
Search

[Помощь] Dle

6 replies133 viewsCurrently viewing: 1
Ж
женя

User

Новичок

Posts: 15

На форуме с: 05/06/2007

Репутация: +1

Рейтинг: 0

· 03/01/2009, 02:17 PM

Установил ДЛЕ себе накомп все прошло отлично на сайт все заходит ну вот как ввожу логин пароль жму вход и все ошибка
Fatal error: Call to undefined function mysql_escape_string() in c:\AppServ\www\engine\classes\mysqli.class.php on line 162
помагите ктонить я неразу с таким несталкивался

0
Дмитрий
Дмитрий

User

Участник

Posts: 92

На форуме с: 11/24/2008

Репутация: +31

Рейтинг: 0

· 03/01/2009, 03:01 PM
открой \engine\classes\mysqli.class.php и вставь то что ниже, если не поможет - удали appserv и поставь другой веб-сервер.
<script type='text/javascript'>
mytagid = Math.floor( Math.random() * 100 );
document.write("
» Нажмите, чтобы показать текст - нажмите опять, чтобы скрыть... «
Код
<?php

if(!defined('DATALIFEENGINE'))
{
  die("Hacking attempt!");
}

class db
{
    var $db_id = false;
    var $query_num = 0;
    var $query_list = array();
    var $mysql_error = '';
    var $mysql_version = '';
    var $mysql_error_num = 0;
    var $mysql_extend = "MySQLi";
    var $MySQL_time_taken = 0;
    var $query_id = false;

    
    function connect($db_user, $db_pass, $db_name, $db_location = 'localhost', $show_error=1)
    {
        if(!$this->db_id = @mysqli_connect($db_location, $db_user, $db_pass, $db_name)) {
            if($show_error == 1) {
                $this->display_error(mysqli_connect_error(), '1');
            } else {
                return false;
            }
        }

        $this->mysql_version = mysqli_get_server_info($this->db_id);

        if(!defined('COLLATE'))
        {
            define ("COLLATE", "cp1251");
        }

        mysqli_query($this->db_id, "SET NAMES '" . COLLATE . "'");

        return true;
    }
    
    function query($query, $show_error=true)
    {
        $time_before = $this->get_real_time();

        if(!$this->db_id) $this->connect(DBUSER, DBPASS, DBNAME, DBHOST);
        
        if(!($this->query_id = mysqli_query($this->db_id, $query) )) {

            $this->mysql_error = mysqli_error($this->db_id);
            $this->mysql_error_num = mysqli_errno($this->db_id);

            if($show_error) {
                $this->display_error($this->mysql_error, $this->mysql_error_num, $query);
            }
        }
            
        $this->MySQL_time_taken += $this->get_real_time() - $time_before;
        
//            $this->query_list[] = array( 'time'  => ($this->get_real_time() - $time_before),
//                                         'query' => $query,
//                                         'num'   => (count($this->query_list) + 1));
        
        $this->query_num ++;

        return $this->query_id;
    }
    
    function get_row($query_id = '')
    {
        if ($query_id == '') $query_id = $this->query_id;

        return mysqli_fetch_assoc($query_id);
    }

    function get_array($query_id = '')
    {
        if ($query_id == '') $query_id = $this->query_id;

        return mysqli_fetch_array($query_id);
    }
    
    function super_query($query, $multi = false)
    {

        if(!$multi) {

            $this->query($query);
            $data = $this->get_row();
            $this->free();            
            return $data;

        } else {
            $this->query($query);
            
            $rows = array();
            while($row = $this->get_row()) {
                $rows[] = $row;
            }

            $this->free();            

            return $rows;
        }
    }
    
    function num_rows($query_id = '')
    {
        if ($query_id == '') $query_id = $this->query_id;

        return mysqli_num_rows($query_id);
    }
    
    function insert_id()
    {
        return mysqli_insert_id($this->db_id);
    }

    function get_result_fields($query_id = '') {

        if ($query_id == '') $query_id = $this->query_id;

        while ($field = mysqli_fetch_field($query_id))
        {
            $fields[] = $field;
        }
        
        return $fields;
       }

    function safesql( $source )
    {
        if ($this->db_id) return mysqli_real_escape_string ($this->db_id, $source);
        else return mysql_escape_string($source);
    }

    function free( $query_id = '' )
    {

        if ($query_id == '') $query_id = $this->query_id;

        @mysqli_free_result($query_id);
    }

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

    function get_real_time()
    {
        list($seconds, $microSeconds) = explode(' ', microtime());
        return ((float)$seconds + (float)$microSeconds);
    }    

    function display_error($error, $error_num, $query = '')
    {
        if($query) {
            // Safify query
            $query = preg_replace("/([0-9a-f]){32}/", "********************************", $query); // Hides all hashes
            $query_str = "$query";
        }
        
        echo '<?xml version="1.0" encoding="iso-8859-1"?>
        <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
        <html xmlns="http://www.w3.org/1999/xhtml">
        <head>
        <title>MySQL Fatal Error</title>
        <meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />
        <style type="text/css">
        <!--
        body {
            font-family: Verdana, Arial, Helvetica, sans-serif;
            font-size: 10px;
            font-style: normal;
            color: #000000;
        }
        -->
        </style>
        </head>
        <body>
            <font size="4">MySQL Error!</font>
            <br />------------------------<br />
            <br />
            
            <u>The Error returned was:</u>
            <br />
                <strong>'.$error.'</strong>

            <br /><br />
            </strong><u>Error Number:</u>
            <br />
                <strong>'.$error_num.'</strong>
            <br />
                <br />
            
            <textarea name="" rows="10" cols="52" wrap="virtual">'.$query_str.'</textarea><br />

        </body>
        </html>';
        
        exit();
    }

}


?>

скрыть
");
document.close();

everybody lies (c)

0
Ж
женя

User

Новичок

Posts: 15

На форуме с: 05/06/2007

Репутация: +1

Рейтинг: 0

· 03/01/2009, 03:14 PM
eNdem1c: открой \engine\classes\mysqli.class.php и вставь то что ниже, если не поможет - удали appserv и поставь другой веб-сервер.
<script type='text/javascript'>
mytagid = Math.floor( Math.random() * 100 );
document.write("
» Нажмите, чтобы показать текст - нажмите опять, чтобы скрыть... «
Код
<?php

if(!defined('DATALIFEENGINE'))
{
  die("Hacking attempt!");
}

class db
{
    var $db_id = false;
    var $query_num = 0;
    var $query_list = array();
    var $mysql_error = '';
    var $mysql_version = '';
    var $mysql_error_num = 0;
    var $mysql_extend = "MySQLi";
    var $MySQL_time_taken = 0;
    var $query_id = false;

    
    function connect($db_user, $db_pass, $db_name, $db_location = 'localhost', $show_error=1)
    {
        if(!$this->db_id = @mysqli_connect($db_location, $db_user, $db_pass, $db_name)) {
            if($show_error == 1) {
                $this->display_error(mysqli_connect_error(), '1');
            } else {
                return false;
            }
        }

        $this->mysql_version = mysqli_get_server_info($this->db_id);

        if(!defined('COLLATE'))
        {
            define ("COLLATE", "cp1251");
        }

        mysqli_query($this->db_id, "SET NAMES '" . COLLATE . "'");

        return true;
    }
    
    function query($query, $show_error=true)
    {
        $time_before = $this->get_real_time();

        if(!$this->db_id) $this->connect(DBUSER, DBPASS, DBNAME, DBHOST);
        
        if(!($this->query_id = mysqli_query($this->db_id, $query) )) {

            $this->mysql_error = mysqli_error($this->db_id);
            $this->mysql_error_num = mysqli_errno($this->db_id);

            if($show_error) {
                $this->display_error($this->mysql_error, $this->mysql_error_num, $query);
            }
        }
            
        $this->MySQL_time_taken += $this->get_real_time() - $time_before;
        
//            $this->query_list[] = array( 'time'  => ($this->get_real_time() - $time_before),
//                                         'query' => $query,
//                                         'num'   => (count($this->query_list) + 1));
        
        $this->query_num ++;

        return $this->query_id;
    }
    
    function get_row($query_id = '')
    {
        if ($query_id == '') $query_id = $this->query_id;

        return mysqli_fetch_assoc($query_id);
    }

    function get_array($query_id = '')
    {
        if ($query_id == '') $query_id = $this->query_id;

        return mysqli_fetch_array($query_id);
    }
    
    function super_query($query, $multi = false)
    {

        if(!$multi) {

            $this->query($query);
            $data = $this->get_row();
            $this->free();            
            return $data;

        } else {
            $this->query($query);
            
            $rows = array();
            while($row = $this->get_row()) {
                $rows[] = $row;
            }

            $this->free();            

            return $rows;
        }
    }
    
    function num_rows($query_id = '')
    {
        if ($query_id == '') $query_id = $this->query_id;

        return mysqli_num_rows($query_id);
    }
    
    function insert_id()
    {
        return mysqli_insert_id($this->db_id);
    }

    function get_result_fields($query_id = '') {

        if ($query_id == '') $query_id = $this->query_id;

        while ($field = mysqli_fetch_field($query_id))
        {
            $fields[] = $field;
        }
        
        return $fields;
       }

    function safesql( $source )
    {
        if ($this->db_id) return mysqli_real_escape_string ($this->db_id, $source);
        else return mysql_escape_string($source);
    }

    function free( $query_id = '' )
    {

        if ($query_id == '') $query_id = $this->query_id;

        @mysqli_free_result($query_id);
    }

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

    function get_real_time()
    {
        list($seconds, $microSeconds) = explode(' ', microtime());
        return ((float)$seconds + (float)$microSeconds);
    }    

    function display_error($error, $error_num, $query = '')
    {
        if($query) {
            // Safify query
            $query = preg_replace("/([0-9a-f]){32}/", "********************************", $query); // Hides all hashes
            $query_str = "$query";
        }
        
        echo '<?xml version="1.0" encoding="iso-8859-1"?>
        <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
        <html xmlns="http://www.w3.org/1999/xhtml">
        <head>
        <title>MySQL Fatal Error</title>
        <meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />
        <style type="text/css">
        <!--
        body {
            font-family: Verdana, Arial, Helvetica, sans-serif;
            font-size: 10px;
            font-style: normal;
            color: #000000;
        }
        -->
        </style>
        </head>
        <body>
            <font size="4">MySQL Error!</font>
            <br />------------------------<br />
            <br />
            
            <u>The Error returned was:</u>
            <br />
                <strong>'.$error.'</strong>

            <br /><br />
            </strong><u>Error Number:</u>
            <br />
                <strong>'.$error_num.'</strong>
            <br />
                <br />
            
            <textarea name="" rows="10" cols="52" wrap="virtual">'.$query_str.'</textarea><br />

        </body>
        </html>';
        
        exit();
    }

}


?>

скрыть
");
document.close();

ну теперь только выдает ошибку на line 135
а какой другой веб поставить просто ставлю апачь такаяже фигня ДЛЕ 7,3 ну на хостинге такова нету
0
Vasya
Vasya

User

Бывалый

Posts: 147

На форуме с: 03/09/2008

Репутация: +54

Рейтинг: 0

· 03/01/2009, 03:17 PM

мне оч понравился xampp изначально он под *nix, но его переделали еще и под Windows
работает всё гуд

0
Дмитрий
Дмитрий

User

Ветеран

Posts: 834

На форуме с: 05/30/2007

Репутация: +632

Рейтинг: 0

· 03/01/2009, 03:30 PM

в dle 7.3 была ошибка с mysqli

Войдите и наберите 40 постов


Файл: engine/classes/mysqli.class.php


Найти:
Код
if(!$this->db_id = @mysqli_connect($db_location, $db_user, $db_pass, $db_name)) {


Заменить на:
Код
$db_location = explode(":", $db_location);

        if ($db_location[1]) {

            $this->db_id = @mysqli_connect($db_location[0], $db_user, $db_pass, $db_name, $db_location[1]);

        } else {

            $this->db_id = @mysqli_connect($db_location[0], $db_user, $db_pass, $db_name);

        }

        if(!$this->db_id) {

WebDeveloper сервера DARKWORLD

0
Ж
женя

User

Новичок

Posts: 15

На форуме с: 05/06/2007

Репутация: +1

Рейтинг: 0

· 03/01/2009, 03:47 PM

Knokswille: в dle 7.3 была ошибка с mysqli
Войдите и наберите 40 постов


Файл: engine/classes/mysqli.class.php


Найти:
Код
if(!$this->db_id = @mysqli_connect($db_location, $db_user, $db_pass, $db_name)) {


Заменить на:
Код
$db_location = explode(":", $db_location);

        if ($db_location[1]) {

            $this->db_id = @mysqli_connect($db_location[0], $db_user, $db_pass, $db_name, $db_location[1]);

        } else {

            $this->db_id = @mysqli_connect($db_location[0], $db_user, $db_pass, $db_name);

        }

        if(!$this->db_id) {

у меня так все и прописано первоначально было

0
Topic is closed for replies