$q = "SELECT products_id, color, material FROM jng_sp_catalog WHERE jng_sp_id={$jng_sp_id}";
$r = tep_db_query($q);
while ($row = tep_db_fetch_array($r)) {
$products_id = $row['products_id'];
$ca = explode(',', $row['color']);
foreach ($ca as $key => $c) {
$ca[$key] = trim($c);
}
$color_pattern_id = array();
foreach ($ca as $c) {
if ($c != '' && isset($colors[$c])) {
$color_pattern_id[] = $colors[$c];
}
}
if (count($color_pattern_id) > 0) {
$class_pm->setColorPattern($products_id, $color_pattern_id);
}
$ma = explode(',', $row['material']);
foreach ($ma as $key => $m) {
$ma[$key] = trim($m);
}
$products_materials_id = array();
foreach ($ma as $m) {
if ($m != '' && in_array($m, $materials)) {
$products_materials_id[] = array_search($m, $materials);
}
}
if (count($products_materials_id) > 0) {
$class_pm->setProductMaterials($products_id, $products_materials_id);
}
}
