//Insert entries into orders_products_attributes
$orders_products_id = $db->insert_ID();
if (isset($products[$i]['attributes']) && is_array($products[$i]['attributes'])) {
while (list($option, $value) = each($products[$i]['attributes'])) {
$attributes = $db->Execute("select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix
from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " . TABLE_PRODUCTS_ATTRIBUTES . " pa
where pa.products_id = '" . $products[$i]['id'] . "'
and pa.options_id = '" . makeSqlString($option) . "'
and pa.options_id = popt.products_options_id
and pa.options_values_id = '" . makeSqlString($value) . "'
and pa.options_values_id = poval.products_options_values_id
and popt.language_id = '" . $languages_id . "'
and poval.language_id = '" . $languages_id . "'");
$sql_data_array = array('orders_id' => $orders_id,
'orders_products_id' => $orders_products_id,
'products_options' => makeSqlString($attributes->fields['products_options_name']),
'products_options_values' => $attributes->fields['products_options_values_name'],
'options_values_price' => makeSqlFloat($attributes->fields['options_values_price']),
'price_prefix' => makeSqlString($attributes->fields['price_prefix']));
$db->Execute(TABLE_ORDERS_PRODUCTS_ATTRIBUTES, $sql_data_array);
}
}
}
Bookmarks