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

//change product check	
  if(isset($_POST['imgid'])) {
   $imgid = $_POST['imgid'];
   $imgen = array($imgid);
   
	if (!isset($_POST['productcheck'])) {
	 delet_Allproduct_Thisimage($imgid);
	} else {
	 $product_id = $_POST['productcheck'];
	 add_product_Thisimage($product_id, $imgen);
    }
  }	
	
//set batch manager unit
  global $template, $element_ids;
 
  $query='
  SELECT `id`, `product`, `noteAdmin`, `price`
  FROM '.MPS_PRODUCT_TABLE.'
  ORDER BY `order`
  ;';
  $result = pwg_query($query);
  
  while($row = pwg_db_fetch_assoc($result)){
   $products[]= $row;
  }

  $query='
  SELECT * 
  FROM '.MPS_CONF_TABLE.';';
  $result 	= pwg_query($query);
  
  while($row = pwg_db_fetch_assoc($result)){
    $config = $row ;
  }

  $query='
  SELECT i.id, pi.image_id, pi.product_id
  FROM '.IMAGES_TABLE.' AS i
  LEFT JOIN '.MPS_PROD_IMG_TABLE.' AS pi ON pi.image_id = i.id
  WHERE id IN ('.implode(',', $element_ids).')
  ;';
  $result = pwg_query($query);
  
  while($row = pwg_db_fetch_assoc($result)){
   $productcheck[] = $row;
  }
		
//template assign 
  $template->assign(array(
   'mps_products'	  => $products,
   'mps_conf'		  => $config,
   'mps_productcheck' => $productcheck,
));