Euhero Content locker script update

[menssouri83]

Hello everyone ,
I have find i script made in 2013 that use Mysql , Today the mysql has removed and remplaced by Mysqli or PDO
Can any one help me please to convert the mysql code to mysqli
Exemple :

<?php
$num_queries = 0;
$total_time =   0;
class ADO
{
    function ADO($host,$user,$password,$database)
    {
        $this->connection=mysql_connect($host,$user,$password);
        if(!$this->connection)
        {
            echo "<br>Database Error!!!<br>".mysql_error();         
        }
        mysql_select_db($database);
    }

    function exec($sql)
    {   
    //  echo "<br />".$sql;
        //exit;
//      global $num_queries;
//      global  $total_time;
//      $num_queries++;     
//      $start_time = microtime(true);
//      echo "<br />".$num_queries." ".$sql;
        $result=mysql_query($sql,$this->connection)  ;
        if(!$result)
            echo "<p>ERROR::".mysql_error()."<br><strong>".$sql."</strong></p>";
//      $time_taken = round(microtime(true) - $start_time, 4 );
//      $total_time +=  $time_taken ;
//      if($time_taken >= 0.01)
//          echo "<br /> Time taken is ".$time_taken.' total time is  '.$total_time;
    //  echo $sql;
    //  exit;
        if($result)
        {
            return $result;
        }
        else
        {
            //echo "<br>Error in Query!!! $sql<br>".mysql_error();
            return false;
            //exit();           
        }
    }

    function error()
    {
        return mysql_error();
    }
    function affected_rows()
    {
        return mysql_affected_rows();
    }

    function fetch($result)
    {

        $res = mysql_fetch_array($result);
    //  echo mysql_error();
        return $res;
    }

    function fetch_assoc($result)
    {
        return mysql_fetch_assoc($result);
    }

    function free($result)
    {
        return mysql_free_result($result);
    }

    function count($result)
    {
        return mysql_num_rows($result);
    }

    function count_res($result)
    {

            return @mysql_num_rows($result);

    }

    function id()
    {
        return mysql_insert_id();
    }

    function end()
    {
        mysql_close($this->connection);
    }
}

global $ado;
$ado = new ADO($DB_HOST, $DB_USER, $DB_PASS, $DB_NAME) or die("database connection error");

[Dani]

While the mysql_* functions were procedural, MySQLi supports either procedural or object oriented methods. Since you're already using procedural style, the simplest thing to do would be to replace the functions with their MySQLi counterparts.

I think you should just be able to replace:

• mysql_connect with mysqli_connect (https://www.php.net/manual/en/function.mysqli-connect.php)
• mysql_select_db with mysqli_select_db (https://www.php.net/manual/en/mysqli.select-db.php)
• mysql_query with mysqli_query (https://www.php.net/manual/en/mysqli.query.php)
• mysql_affected_rows with mysqli_affected_rows
• mysql_fetch_array with mysqli_fetch_array

And so on, and so forth ...