Frank Black
frank_black****@hotma*****
2006年 10月 28日 (土) 03:35:05 JST
植松さんこんにちは。
Frank Blackです。
>
>修正箇所が3箇所あり、1番目と2番目は、
>間違えようがないと思うのですが、3番目が自信ありません。
>
EasyPopulate_v2.61.2
オリジナルファイルの
1114行目から1156行目まで
$iii=0;
$fileheaders = array(
'product_url' => $iii++,
'name' => $iii++,
'description' => $iii++,
'price' => $iii++,
'image_url' => $iii++,
'category' => $iii++,
'offer_id' => $iii++,
'instock' => $iii++,
'shipping' => $iii++,
'brand' => $iii++,
'upc' => $iii++,
'color' => $iii++,
'size' => $iii++,
'quantity' => $iii++,
'product_id' => $iii++,
'manufacturer_id' => $iii++,
'exp_date' => $iii++,
'product_type' => $iii++,
'delete' => $iii++,
'currency' => $iii++,
);
$filelayout_sql = "SELECT
p.products_id as v_products_id,
p.products_model as v_products_model,
p.products_image as v_products_image,
p.products_price as v_products_price,
p.products_weight as v_products_weight,
p.products_date_added as v_date_avail,
p.products_tax_class_id as v_tax_class_id,
p.products_quantity as v_products_quantity,
p.manufacturers_id as v_manufacturers_id,
subc.categories_id as v_categories_id
FROM
products as p,
categories as subc,
products_to_categories as ptoc
WHERE
p.products_id = ptoc.products_id AND
ptoc.categories_id = subc.categories_id
";
break;
の後に
// VJ product attributes begin
case 'attrib':
$iii = 0;
$filelayout = array(
'v_products_model' => $iii++
);
$header_array = array();
$languages = tep_get_languages();
global $attribute_options_array;
$attribute_options_count = 1;
foreach ($attribute_options_array as $attribute_options_values) {
$key1 = 'v_attribute_options_id_' . $attribute_options_count;
$header_array[$key1] = $iii++;
for ($i=0, $n=sizeof($languages); $i<$n; $i++) {
$l_id = $languages[$i]['id'];
$key2 = 'v_attribute_options_name_' . $attribute_options_count . '_' .
$l_id;
$header_array[$key2] = $iii++;
}
$attribute_values_query = "select products_options_values_id from " .
TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " where
products_options_id = '" .
(int)$attribute_options_values['products_options_id'] . "' order by
products_options_values_id";
$attribute_values_values = tep_db_query($attribute_values_query);
$attribute_values_count = 1;
while ($attribute_values = tep_db_fetch_array($attribute_values_values))
{
$key3 = 'v_attribute_values_id_' . $attribute_options_count . '_' .
$attribute_values_count;
$header_array[$key3] = $iii++;
$key4 = 'v_attribute_values_price_' . $attribute_options_count . '_' .
$attribute_values_count;
$header_array[$key4] = $iii++;
for ($i=0, $n=sizeof($languages); $i<$n; $i++) {
$l_id = $languages[$i]['id'];
$key5 = 'v_attribute_values_name_' . $attribute_options_count . '_' .
$attribute_values_count . '_' . $l_id;
$header_array[$key5] = $iii++;
}
$attribute_values_count++;
}
$attribute_options_count++;
}
$filelayout = array_merge($filelayout, $header_array);
$filelayout_sql = "SELECT
p.products_id as v_products_id,
p.products_model as v_products_model
FROM
".TABLE_PRODUCTS." as p
";
break;
// VJ product attributes end
を追加します。
_________________________________________________________________
節約のアイディア300例。お金の悩みは、MSN マネーで自己解決
http://plan.money.jp.msn.com/saving/index.html