Bravo List

Bravo List (http://www.bvlist.com/index.php)
-   TBDev (http://www.bvlist.com/forumdisplay.php?f=20)
-   -   Doesn't work with mysqli! (how to fix) (http://www.bvlist.com/showthread.php?t=11783)

darkalchemy 25th November 2018 18:06

Quote:

Originally Posted by Tedmorris (Post 52834)
No mate its not but the orignal source would be. Whats a PR?

"PR" === Pull Request. It's how someone can make changes to your code and offer those changes to you.

Tedmorris 26th November 2018 03:26

Quote:

Originally Posted by Napon (Post 52835)
mine is on github to mysqli

Link?

Napon 19th October 2019 09:40

Code:

function dbconn($autoclean = false){
global $TBDEV;
if (!@($GLOBALS["___mysqli_ston"] = mysqli_connect($TBDEV['mysql_host'],  $TBDEV['mysql_user'],  $TBDEV['mysql_pass']))){
    switch (((is_object($GLOBALS["___mysqli_ston"])) ? mysqli_errno($GLOBALS["___mysqli_ston"]) : (($___mysqli_res = mysqli_connect_errno()) ? $___mysqli_res : false))) {
    case 1040:
    case 2002:
if ($_SERVER['REQUEST_METHOD'] == "GET")
    die("

The server load is very high at the moment. Retrying, please wait...

");
    else
    die("Too many users. Please press the Refresh button in your browser to retry.");
    default:
    die("[".((is_object($GLOBALS["___mysqli_ston"])) ? mysqli_errno($GLOBALS["___mysqli_ston"]) : (($___mysqli_res = mysqli_connect_errno()) ? $___mysqli_res : false))."] dbconn: mysql_connect: ".((is_object($GLOBALS["___mysqli_ston"])) ? mysqli_error($GLOBALS["___mysqli_ston"]) : (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : false)));
    }
}
    ((bool)mysqli_query($GLOBALS["___mysqli_ston"], "USE {$TBDEV['mysql_db']}")) or die('dbconn: mysql_select_db: ' . ((is_object($GLOBALS["___mysqli_ston"])) ? mysqli_error($GLOBALS["___mysqli_ston"]) : (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : false)));
    userlogin();
if ($autoclean)
    register_shutdown_function("autoclean");
}


BT-loader 2nd January 2020 15:27

Can you please fix the database connection for "tbdev-01-03-06" too?

PHP Code:

function dbconn($autoclean false)
{
    global 
$mysql_host$mysql_user$mysql_pass$mysql_db;

    if (!@
mysql_connect($mysql_host$mysql_user$mysql_pass))
    {
      switch (
mysql_errno())
      {
        case 
1040:
        case 
2002:
            if (
$_SERVER[REQUEST_METHOD] == "GET")
                die(
"<html><head><meta http-equiv=refresh content=\"5 $_SERVER[REQUEST_URI]\"></head><body><table border=0 width=100% height=100%><tr><td><h3 align=center>The server load is very high at the moment. Retrying, please wait...</h3></td></tr></table></body></html>");
            else
                die(
"Too many users. Please press the Refresh button in your browser to retry.");
        default:
            die(
"[" mysql_errno() . "] dbconn: mysql_connect: " mysql_error());
      }
    }
    
mysql_select_db($mysql_db)
        or die(
'dbconn: mysql_select_db: ' mysql_error());

    
userlogin();

    if (
$autoclean)
        
register_shutdown_function("autoclean");



smoky28 2nd January 2020 16:27

Simple formula in every function you need to call global $ mysqli; call and then the dbconn function can be omitted.

BT-loader 2nd January 2020 17:40

Quote:

Originally Posted by smoky28 (Post 54383)
Simple formula in every function you need to call global $ mysqli; call and then the dbconn function can be omitted.

It's not that simple.
I also need the dbconn()-function to be changed for MySQLi.

smoky28 2nd January 2020 17:54

Create mysqli.php include folder
add bittorrent.php.

require_once("mysqli.php");



and put the global $ mysqli line for each function or where blobal i have just paste the $ mysqli add-on and at the very bottom of mysqli php there is a database connection there and enter and enter the database entry. but if you get stuck on skype you will be happy to help.


Code:

global $mysqli;halt('The PHP MySQLi extension is not loaded,!', false);        parent::__construct($host, $user, $pass, $db);        if($this->connect_errno)            $this->halt('Could not connect to MySQL server,');            }    public function affected_rows()    {        return $this->affected_rows;    }    public function close()    {        return @parent::close();    }    public function escape($input)    {        return $this->real_escape_string($input);    }    public function query($query_str)    {        if (func_num_args() > 1)        {            $args = func_get_args();            unset($args[0]);            $args = array_map(array($this, "real_escape_string"), $args);            $query_str = vsprintf($query_str, $args);        }        $QueryTime = microtime(true);        $this->query_id = parent::query($query_str);        $QueryTime = microtime(true) - $QueryTime;        if ($this->debug)        {            $this->querydebug[] = array('time' => $QueryTime, 'sql' => $query_str);            $this->querytime += $QueryTime;        }        if(!$this->query_id)            $this->halt('Querly error: '.$query_str);        $this->queries++;        return $this->query_id;    }    public function fetch_array($query_id = -1, $datatype = 'assoc')    {        if($query_id != -1)            $this->query_id = $query_id;        if($datatype === 'num')            $datatype = MYSQL_NUM;        else            $datatype = MYSQL_ASSOC;        $this->record = $query_id->fetch_array($datatype);        return $this->record;    }        public function fetch_assoc($query_id = -1)    {        if($query_id != -1)            $this->query_id = $query_id;        $this->record = $query_id->fetch_array(MYSQL_ASSOC);        return $this->record;    }    public function fetch_row($query_id = -1)    {        if($query_id != -1)            $this->query_id = $query_id;        $this->record = $query_id->fetch_row();        return $this->record;    }    public function num_rows($query_id=-1)    {        if($query_id!=-1)            $this->query_id = $query_id;        return $query_id->num_rows;    }    public function free_result($query_id=-1)    {        if($query_id!=-1)            $this->query_id = $query_id;        return $query_id->free();    }    private function halt($errormsg, $mysqli = true)    {        if (!$this->showerr)            return;        if($mysqli)        {            $errormsg .= "\n";            $errormsg .= 'MySQLi error code: '.$this->errno."\n";            $errormsg .= 'MySQLi Problem Description: '.$this->error."\n";        }        $errormsg .= 'Time: '.date('Y-m-d H:i:s')  ."\n";        $errormsg .= 'Script: '.htmlspecialchars(getenv('REQUEST_URI'))  ."\n";        $errormsg .= 'Referer: '.htmlspecialchars(getenv('HTTP_REFERER')) ."\n";        die("

MySQLi error

".nl2br($errormsg));    }}$mysqli = new mysqlidb('localhost','user','pass','database');?>


Napon 2nd January 2020 19:07

Quote:

Originally Posted by BT-loader (Post 54382)
Can you please fix the database connection for "tbdev-01-03-06" too?

PHP Code:

function dbconn($autoclean false){    global $mysql_host$mysql_user$mysql_pass$mysql_db;    if (!@mysql_connect($mysql_host$mysql_user$mysql_pass))    {      switch (mysql_errno())      {        case 1040:        case 2002:            if ($_SERVER[REQUEST_METHOD] == "GET")                die("<html><head><meta http-equiv=refresh content="5 $_SERVER[REQUEST_URI]"></head><body><table border=0 width=100% height=100%><tr><td><h3 align=center>The server load is very high at the moment. Retrying, please wait...</h3></td></tr></table></body></html>");            else                die("Too many users. Please press the Refresh button in your browser to retry.");        default:            die("[" mysql_errno() . "] dbconn: mysql_connect: " mysql_error());      }    }    mysql_select_db($mysql_db)        or die('dbconn: mysql_select_db: ' mysql_error());    userlogin();    if ($autoclean)        register_shutdown_function("autoclean"); } 




yes i can fix this the above is wrong hes given you too lol


All times are GMT +2. The time now is 07:43.

Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.