<?
include 'modules/medoo.php';

$mdb = new medoo( [
          'database_type' => 'mysql',
          'database_name' => 'host439372_redline',
          'server' => 'localhost',
          'username' => 'host439372_redline',
          'password' => 'zak2VVsmvAsqGFx7',
          'charset' => 'utf8'
        ] );

$rows = $mdb -> select( 'ps_product', '*', [ 'cache_is_pack' => 1 ] );
foreach ( $rows as $row )
{
  $summary_price = 0;
  $rows2 = $mdb -> select( 'ps_pack', '*', [ 'id_product_pack' => $row['id_product'] ] );
  foreach ( $rows2 as $row2 )
  {
    $price = (float)$mdb -> get( 'ps_product', 'price', [ 'id_product' => $row2['id_product_item'] ] );
    $summary_price += $price * $row2['quantity'];
  }

  $mdb -> update( 'ps_product', [ 'price' => $summary_price ], [ 'id_product' => $row['id_product'] ] );
  $mdb -> update( 'ps_product_shop', [ 'price' => $summary_price ], [ 'id_product' => $row['id_product'] ] );
}

$rows = $mdb -> select( 'ps_product', '*', [ 'cache_is_pack' => 1 ] );
foreach ( $rows as $row )
{
  $product_quantity = 999999999;

  $rows2 = $mdb -> select( 'ps_pack', '*', [ 'id_product_pack' => $row['id_product'] ] );
  foreach ( $rows2 as $row2 )
  {
    $quantity = $mdb -> get( 'ps_stock_available', 'quantity', [ 'id_product' => $row2['id_product_item'] ] );
    $product_quantity_tmp = floor( $quantity / $row2['quantity'] );

    if ( $product_quantity > $product_quantity_tmp )
      $product_quantity = $product_quantity_tmp;
  }

  $mdb -> update( 'ps_stock_available', [ 'quantity' => $product_quantity ], [ 'id_product' => $row['id_product'] ] );
}
?>