source: extensions/MyPiwiShop/include/functions.inc.php @ 27781

<?php
defined('MPS_PATH') or die('Hacking attempt!');

//add a product to all selected image
function add_product_image($product, $images)
{
  if (count($product) == 0 or count($images) == 0)
  {
    return;
  }

  pwg_query('
  DELETE
  FROM '.MPS_PROD_IMG_TABLE.'
  WHERE image_id IN ('.implode(',', $images).')
  AND product_id IN ('.implode(',', $product).')
  ;');

  foreach ($images as $image_id) {
  
   foreach ( array_unique($product) as $product_id) {
    $inserts[] = array(
     'image_id' => $image_id,
     'product_id' => $product_id,
    );
   }
  }
  
  mass_inserts(
   MPS_PROD_IMG_TABLE,
   array_keys($inserts[0]),
   $inserts
  );
}

//delet all product for all selected image
function deletAll_product_image($product, $images)
{
  pwg_query('
  DELETE
  FROM '.MPS_PROD_IMG_TABLE.'
  WHERE image_id IN ('.implode(',', $images).')
  AND product_id IN ('.implode(',', $product).')
  ;');
}

//delet all product to specific image
function delet_Allproduct_Thisimage($images)
{
  $query = '
        DELETE
        FROM '.MPS_PROD_IMG_TABLE.'
        WHERE image_id IN ('.$images.')

        ;';
  pwg_query($query);

}

//add a product to specific image
function add_product_Thisimage($product, $images)
{
  if (count($product) == 0 or count($images) == 0)
  {
    return;
  }

  $query = '
        DELETE
        FROM '.MPS_PROD_IMG_TABLE.'
        WHERE image_id IN ('.implode(',', $images).')

        ;';
  pwg_query($query);

  $inserts = array();
  foreach ($images as $image_id)
  {
    foreach ( array_unique($product) as $product_id)
    {
      $inserts[] = array(
          'image_id' => $image_id,
          'product_id' => $product_id,
        );
    }
  }
    mass_inserts(
    MPS_PROD_IMG_TABLE,
    array_keys($inserts[0]),
    $inserts
    );
}