ocs1409

hello

suddenly everyone is moving from Msql_query to Msqli_query

in order to work with Msqli_query can all msql_**** commands and functions be replaced with the corresponding
Msqli_****  commands and funtion

for example from  admin/includes/modules/database_optimizer_common.php

   /*********************** REMOVE FROM CUSTOMER TABLES *****************************/
    if (! empty($config['customers']) && $config['customers'] < $daysLastRan) {
    $dateCustomers = date("Ymd", time() - ($config['customers'] * 86400));
    $wasUpdated = true;
    $message .= "\r\n" . 'Customers tables were trimmed.';

   mysql_query("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " WHERE (`products_id`, `customers_id`) in (select `products_id`, `customers_id` from " . TABLE_CUSTOMERS_BASKET . " where customers_basket_date_added < '" . $dateCustomers . "')");
    mysql_query("delete from " . TABLE_CUSTOMERS_BASKET . " where customers_basket_date_added < '" . $dateCustomers . "'"); //clear the customers basket table of entries greater than one month old
    mysql_query("update database_optimizer set customers_last_update = now()");
    }   

change to

   /*********************** REMOVE FROM CUSTOMER TABLES *****************************/
    if (! empty($config['customers']) && $config['customers'] < $daysLastRan) {
    $dateCustomers = date("Ymd", time() - ($config['customers'] * 86400));
    $wasUpdated = true;
    $message .= "\r\n" . 'Customers tables were trimmed.';

   mysqli_query("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " WHERE (`products_id`, `customers_id`) in (select `products_id`, `customers_id` from " . TABLE_CUSTOMERS_BASKET . " where customers_basket_date_added < '" . $dateCustomers . "')");
   mysqli_query("delete from " . TABLE_CUSTOMERS_BASKET . " where customers_basket_date_added < '" . $dateCustomers . "'"); //clear the customers basket table of entries greater than one month old
   mysqli_query("update database_optimizer set customers_last_update = now()");
    }   


greetings
eric