$q .= " FROM elements e"; $q .= " LEFT JOIN elements_description ed1 ON ed1.elements_id=e.elements_id AND ed1.languages_id=1"; $q .= " LEFT JOIN elements_description ed2 ON ed2.elements_id=e.elements_id AND ed2.languages_id=2"; $q .= " LEFT JOIN elements_images ei ON ei.elements_id=e.elements_id AND ei.elements_sample_name='EC1'"; $q .= " WHERE e.elements_id IN (" . implode(',', $elements_keep_id) . ")"; $r = tep_db_query($q); $elements = array(); while ($row = tep_db_fetch_array($r)) { $elements[] = $row; } $count = 0; $copy_time = date('Y-m-d H:i:s'); foreach ($elements as $e) { $element = new element($e['elements_id']); if (is_null($element->id)) { $element->forceID($e['elements_id']); $element->create($e['elements_code'], $e['name'], $e['elements_weight'], '', 0, $copy_time, 'auto'); if ($e['elements_image'] != '') { $image_uploaded = DIR_WS_IMAGES . $e['elements_image']; $image_filename = basename($image_uploaded); $element->uploadImage($image_uploaded, $image_filename); } $suppliers = $element->getSuppliers(); $sup_name = ''; $sup_name = 0; foreach ($suppliers as $sup) { if ($sup['is_default'] == '1') { $sup_name = $sup['suppliers_name']; $sup_price = calculateCurrency($sup['elements_price'] / $sup['pieces_per_qty_type'], $sup['price_currency']); break 1; }