[RESOLVED] MySQLi Issue

[Reecers]

Heya, recently got back into the retro scene and came back to help out a pal when setting it up we got this error:

You must be registered for see images attach

When I change it to MySQLi I get this:

You must be registered for see images attach

 

[Joe]

What's on line 48 of the class.engine.php? You need to make sure this is a string.

 

[Reecers]

What's on line 48 of the class.engine.php? You need to make sure this is a string.

Original:

You must be registered for see images attach

How I get the error:

You must be registered for see images attach

 

[Chuckie_]

What cms is this? Would you be able to share the entire class.engine file?

*EDIT:
Try using this:

$this->connection = mysqli_connect($_CONFIG['mysql']['hostname'], $_CONFIG['mysql']['username'], $_CONFIG['mysql']['password'], $_CONFIG['mysql']['database']);

If database isn't configured in your configs, add it.

 

[Reecers]

What cms is this? Would you be able to share the entire class.engine file?

*EDIT:
Try using this:

$this->connection = mysqli_connect($_CONFIG['mysql']['hostname'], $_CONFIG['mysql']['username'], $_CONFIG['mysql']['password'], $_CONFIG['mysql']['database']);

If database isn't configured in your configs, add it.

I used this and got

You must be registered for see images attach

Also following is the class.engine

<?php

namespace Revolution;
if(!defined('IN_INDEX')) { die('Sorry, you cannot access this file.'); }
class engine
{
    private $initiated;
    private $connected;
    
    private $connection;
    
    
    final public function Initiate()
    {
        global $_CONFIG;
        if(!$this->initiated)
        {
            $this->setMySQL('connect', mysql_connect);
            $this->setMySQL('pconnect', mysql_pconnect);
            $this->setMysql('select_db', mysql_select_db);
            $this->setMySQL('query', mysql_query);
            $this->setMySQL('num_rows', mysql_num_rows);
            $this->setMySQL('fetch_assoc', mysql_fetch_assoc);
            $this->setMySQL('fetch_array',mysql_fetch_array);
            $this->setMySQL('result', mysql_result);
            $this->setMySQL('free_result', mysql_free_result);
            $this->setMySQL('escape_string', mysql_real_escape_string);
            
            $this->initiated = true;
        
            $this->connect($_CONFIG['mysql']['connection_type']);
        }
    }
    
    final public function setMySQL($key, $value)
    {
        $this->mysql[$key] = $value;
    }
    
    
    /*-------------------------------Manage Connection-------------------------------------*/
    
    final public function connect($type)
    {
        global $core, $_CONFIG;
        if(!$this->connected)
        {
            $this->connection = mysqli_connect($_CONFIG['mysql']['hostname'], $_CONFIG['mysql']['username'], $_CONFIG['mysql']['password'], $_CONFIG['mysql']['database']);

            
            if($this->connection)
            {
                $mydatabase = $this->mysql['select_db']($_CONFIG['mysql']['database'], $this->connection);
                
                if($mydatabase)
                {
                    $this->connected = true;   
                }
                else
                {
                    $core->systemError('MariaDB Engine', mysql_error());
                }
            }
            else
            {
                $core->systemError('MariaDB Engine', mysql_error());       
            }
        }
    }
    
    final public function disconnect()
    {
        global $core;
        if($this->connected)
        {
            if($this->mysql['close'])
            {
                $this->connected = false;
            }
            else
            {
                $core->systemError('MySQL Engine', 'MySQL could not disconnect.');
            }
        }
    }
    
    /*-------------------------------Secure MySQL variables-------------------------------------*/
    
    final public function secure($var)
    {
        return $this->mysql['escape_string'](stripslashes(htmlspecialchars($var)));
    }
    
    /*-------------------------------Manage MySQL queries-------------------------------------*/
    
    final public function query($sql)
    {
        return $this->mysql['query']($sql, $this->connection) or die(mysql_error());
    }
    
    final public function num_rows($sql)
    {
        return $this->mysql['num_rows']($this->mysql['query']($sql, $this->connection));
    }
    
    final public function result($sql)
    {
        return $this->mysql['result']($this->mysql['query']($sql, $this->connection), 0);
    }
    
    final public function free_result($sql)
    {
        return $this->mysql['free_result']($sql);
    }
    
    final public function fetch_array($sql)
    {
        $query = $this->mysql['query']($sql, $this->connection);
        
        $data = array();
        
        while($row = $this->mysql['fetch_array']($query))
        {
            $data[] = $row;
        }
        
        return $data;
    }
    
    final public function fetch_assoc($sql)
    {
        return $this->mysql['fetch_assoc']($this->mysql['query']($sql, $this->connection));
    }




}
?>

 

[Chuckie_]

Again, what CMS is this? Seems it has configuration to either use mysql or mysqli. Redo what I sent and try changing your mysql type in the configs to mysqli.

 

[Reecers]

Again, what CMS is this? Seems it has configuration to either use mysql or mysqli. Redo what I sent and try changing your mysql type in the configs to mysqli.

Just changed the CMS its a rp rev edit unsure which one fully as is a custom one
I get this error now

You must be registered for see images attach

 

[Chuckie_]

Try changing all the mysql functions to their respective mysqli version in the initiate function.

 

[Reecers]

Try changing all the mysql functions to their respective mysqli version in the initiate function.

You must be registered for see images attach

Pretty sure ive done it correctly but get this, do u have discord?

 

[Chuckie_]

I prefer not using my discord for that. You'd learn more from messing around with the migration yourself too, but make sure that you've provided 4 arguments in your connection and are using a proper mysql version. Google is your friend too.