}
$attr_info = cw_query_first("SELECT * FROM cw_attributes WHERE field='{$ef_colname}' AND item_type='P' AND addon in ('', 'custom_saratogawine_magazines','custom_saratogawine_backorder', 'clean_urls')");
$attr_id = $attr_info['attribute_id'];
if ($attr_id) {
if ($attr_info['type'] == 'selectbox') {
$id_ef_colname = $ef_colname . "_id";
cw_csvxc_logged_query("ALTER TABLE tmp_load_PRODUCTS_EXTRA_FIELD_VALUES ADD COLUMN `{$id_ef_colname}` int(11) NOT NULL DEFAULT 0");
cw_csvxc_logged_query("UPDATE tmp_load_PRODUCTS_EXTRA_FIELD_VALUES tlpefv, cw_attributes_default cad SET tlpefv.`{$id_ef_colname}`=cad.attribute_value_id WHERE cad.attribute_id='{$attr_id}' AND cad.value=tlpefv.`{$ef_colname}`");
cw_csvxc_logged_query("INSERT INTO cw_attributes_default (value, attribute_id, active, facet) SELECT distinct(`{$ef_colname}`), {$attr_id}, 1, {$attr_info['facet']} FROM tmp_load_PRODUCTS_EXTRA_FIELD_VALUES WHERE `{$id_ef_colname}`=0");
cw_csvxc_logged_query("UPDATE tmp_load_PRODUCTS_EXTRA_FIELD_VALUES tlpefv, cw_attributes_default cad SET tlpefv.`{$id_ef_colname}`=cad.attribute_value_id WHERE cad.attribute_id='{$attr_id}' AND cad.value=tlpefv.`{$ef_colname}` AND tlpefv.`{$id_ef_colname}`=0");
cw_csvxc_logged_query("UPDATE tmp_load_PRODUCTS_EXTRA_FIELD_VALUES tlpefv, cw_attributes_values cav SET tlpefv.ref_is_new=0 WHERE tlpefv.PRODUCTID=cav.item_id AND cav.attribute_id='{$attr_id}' AND cav.item_type='P'", "{$ef_colname} ");
cw_csvxc_logged_query("UPDATE cw_attributes_values cav, tmp_load_PRODUCTS_EXTRA_FIELD_VALUES tlpefv SET cav.value=tlpefv.`{$id_ef_colname}` WHERE tlpefv.ref_is_new=0 AND tlpefv.PRODUCTID=cav.item_id AND cav.item_type='P' AND cav.attribute_id='{$attr_id}'", ' ');
cw_csvxc_logged_query("INSERT INTO cw_attributes_values (item_id, attribute_id, value, code, item_type) SELECT PRODUCTID, {$attr_id}, `{$id_ef_colname}`, 'EN', 'P' FROM tmp_load_PRODUCTS_EXTRA_FIELD_VALUES WHERE ref_is_new=1", ' ');
} else {
cw_csvxc_logged_query("UPDATE tmp_load_PRODUCTS_EXTRA_FIELD_VALUES tlpefv, cw_attributes_values cav SET tlpefv.ref_is_new=0 WHERE tlpefv.PRODUCTID=cav.item_id AND cav.attribute_id='{$attr_id}' AND cav.item_type='P'", "{$ef_colname} ");
cw_csvxc_logged_query("UPDATE cw_attributes_values cav, tmp_load_PRODUCTS_EXTRA_FIELD_VALUES tlpefv SET cav.value=tlpefv.`{$ef_colname}` WHERE tlpefv.ref_is_new=0 AND tlpefv.PRODUCTID=cav.item_id AND cav.item_type='P' AND cav.attribute_id='{$attr_id}'", ' ');
cw_csvxc_logged_query("INSERT INTO cw_attributes_values (item_id, attribute_id, value, code, item_type) SELECT PRODUCTID, {$attr_id}, `{$ef_colname}`, 'EN', 'P' FROM tmp_load_PRODUCTS_EXTRA_FIELD_VALUES WHERE ref_is_new=1", ' ');
}
cw_csvxc_logged_query("UPDATE tmp_load_PRODUCTS_EXTRA_FIELD_VALUES SET ref_is_new=1", ' ');
}
}
}
}
if (cw_csvxc_is_table_exists('tmp_load_DETAILED_IMAGES') && $csvxc_allowed_sections['tmp_load_DETAILED_IMAGES']) {
cw_csvxc_set_col_exist_flag('tmp_load_DETAILED_IMAGES');
cw_csvxc_logged_query("UPDATE tmp_load_DETAILED_IMAGES SET IMAGE=REPLACE(IMAGE,'http://www.thestainlesssteelstore.com/images','')");
cw_csvxc_logged_query("UPDATE tmp_load_DETAILED_IMAGES SET IMAGE=REPLACE(IMAGE,'http://www.justaddressplaques.com/images','')");
cw_csvxc_logged_query("UPDATE tmp_load_DETAILED_IMAGES SET IMAGE=REPLACE(IMAGE,'http://eplanters.com/images', '')");
cw_csvxc_delete_old_images("SELECT cw_products_detailed_images.image_path AS img_full_path, cw_products_detailed_images.id AS img_key_fld FROM cw_products_detailed_images, tmp_load_PRODUCTS WHERE tmp_load_PRODUCTS.PRODUCTID=cw_products_detailed_images.id AND tmp_load_PRODUCTS.PRODUCT!=''", 'products_detailed_images');
cw_csvxc_transfer_import_images('tmp_load_DETAILED_IMAGES', 'IMAGE', 'PRODUCTID');
}
}
}
if (!empty($col_data['imp_field'])) {
$tmp_fields[] = $col_data['imp_field'];
$field_names[] = $_dname;
} elseif (!empty($col_data['custom_sql'])) {
$tmp_fields[] = "(" . $col_data['custom_sql'] . ")";
$field_names[] = $_dname;
}
}
$load_data_tables_qry[] = "CREATE TABLE `{$table_name}` ({$table_key_name} int(11) NOT NULL AUTO_INCREMENT, " . implode(", ", $add_field_qry) . ", PRIMARY KEY `{$table_key_name}` (`{$table_key_name}`))ENGINE=MyISAM;";
$load_data_tables_qry[] = "INSERT INTO `{$table_name}` (" . implode(", ", $field_names) . ") SELECT " . implode(", ", $tmp_fields) . " FROM {$parsed_file['tmp_table']}";
}
$load_data_tables_qry[] = "DROP TABLE IF EXISTS {$parsed_file['tmp_table']}";
foreach ($load_data_tables_qry as $lqry) {
cw_csvxc_logged_query($lqry);
}
cw_include('addons/flexible_import/include/tmp_tables_load.php');
if ($parsed_file['err']) {
cw_add_top_message($parsed_file['err'], 'E');
} else {
cw_add_top_message(cw_get_langvar_by_name('lbl_import_success'), 'I');
}
}
cw_header_location("index.php?target={$target}&mode={$mode}");
}
$search_prefilled['files'] = cw_flexible_import_files_dir();
$search_prefilled['sort_field'] = $sort && $sort != "" ? $sort : "id";
$search_prefilled['sort_direction'] = $sort_direction && $sort_direction != 0 ? 0 : 1;
$search_prefilled['items_per_page'] = $items_per_page ? $items_per_page : 20;
$search_prefilled['page'] = $page ? $page : 1;
function cw_csvxc_restoretable($tabname)
{
if (cw_csvxc_is_table_exists("csvxcbak_{$tabname}")) {
cw_csvxc_logged_query("DELETE FROM `{$tabname}`");
cw_csvxc_logged_query("INSERT INTO `{$tabname}` SELECT * FROM `csvxcbak_{$tabname}`");
cw_csvxc_logged_query("DROP TABLE IF EXISTS `csvxcbak_{$tabname}`");
}
}
