} else {
if ($_POST["delimiter"] == 2) {
$delimiter = ",";
} elseif ($_POST["delimiter"] == 3) {
$delimiter = "\t";
} else {
$delimiter = ";";
}
$delimiterv = $_POST["delimiter"];
if (isset($_POST["proceed"]) && isset($_POST["mode"])) {
if (CONF_BACKEND_SAFEMODE) {
Redirect(ADMIN_FILE . "?dpt=catalog&sub=excel_import&safemode=yes");
}
$res = 0;
if ($_POST["mode"] == 2) {
imDeleteAllProducts();
$res = 1;
$smarty->assign("excel_import_result", "ok");
} else {
//upload CSV-file
if (isset($_FILES["csv"]) && $_FILES["csv"]["name"]) {
if (preg_match("/^(.+?)\\.csv(\\.(bz2|gz))?\$/", $_FILES["csv"]["name"], $matches)) {
if (isset($matches[2]) && $matches[3] == 'gz') {
$file_excel_name = "core/temp/file.csv.gz";
$method_parse = 1;
} else {
$file_excel_name = "core/temp/file.csv";
$method_parse = 0;
}
if (file_exists($file_excel_name)) {
unlink($file_excel_name);
function serDeleteProductAndCategories()
{
/* SLOW OBSOLETE METHOD
$q = db_query( "select categoryID from ".CATEGORIES_TABLE." where categoryID<>0" );
while( $row=db_fetch_row($q) )
DeleteAllProductsOfThisCategory( $row["categoryID"] );
$xmlTables=new XmlNode();
$xmlTables->LoadInnerXmlFromFile( DATABASE_STRUCTURE_XML_PATH );
$array=$xmlTables->SelectNodes("DataBaseStructure/tables/table");
foreach($array as $xmlTable)
{
$attrubtes = $xmlTable->GetXmlNodeAttributes();
if ( isset($attrubtes["PRODUCTANDCATEGORYSYNC"]) )
if ( strtoupper($attrubtes[ "PRODUCTANDCATEGORYSYNC" ]) == "TRUE" )
db_query( _getDeleteStatement($xmlTable) );
}
//add root category
db_query("insert into ".CATEGORIES_TABLE."( name, parent, categoryID )".
"values( 'ROOT', NULL, 1 )");
*/
imDeleteAllProducts();
}
