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

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

/**
*product/image
**/
function add_product_image($product, $images)
{
  if (count($product) == 0 or count($images) == 0)
  {
    return;
  }

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

        ;';
  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
    );
}

/**
*product/image
**/
function deletAll_product_image($product, $images)
{
  $query = '
        DELETE
        FROM '.MPS_PROD_IMG_TABLE.'
        WHERE image_id IN ('.implode(',', $images).')
        AND product_id IN ('.implode(',', $product).')

        ;';
  pwg_query($query);

}

function deletThis_image_Allproduct($images)
{
  $query = '
        DELETE
        FROM '.MPS_PROD_IMG_TABLE.'
        WHERE image_id IN ('.$images.')

        ;';
  pwg_query($query);

}

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
    );
}