2){ $fg = @fopen(dirname ( __FILE__ )."/tmp/noDB_mod.csv","w+"); fclose($fg); } for($i=$su;$i0){ $db->query("UPDATE `catalogs_modifications` SET `active` = '1' WHERE `code` = '".trim($line[0])."';"); } $row = $db->super_query("SELECT * FROM `catalogs_modifications` WHERE `code`='".trim($line[0])."' LIMIT 1;"); $row2 = $db->super_query("SELECT COUNT(*) as count FROM `catalogs_modifications` WHERE `active`>0 AND `product_id`=".$row['product_id'].";"); if($row2['count'] <= 0){ $db->query("UPDATE `catalogs_products` SET `count_modifications` = 0,`active` = '0' WHERE `id` = '".$row['product_id']."';"); echo "


UPDATE `catalogs_products` SET `count_modifications` = 0,`active` = '0' WHERE `id` = '".$row['product_id']."';


"; $get_out = 1; } $row = $db->super_query("SELECT * FROM `catalogs_modifications` WHERE `code`='".trim($line[0])."' LIMIT 1;"); $ggggggggggg = ""; if(@$row['product_id']!='') $ggggggggggg = $row['product_id']; $row['product_id'] = 0; $row_city = @$db->super_query("SELECT * FROM `catalogs_cities` WHERE `name`='".trim($line[4])."' LIMIT 1;"); if(!@$row_city['id']){ @$db->query("INSERT INTO `catalogs_cities` (`name`) VALUES ('".trim($line[4])."');"); $row_city['id'] = $db->insert_id(); //@$db->query("INSERT INTO `catalogs_keys_products_cities` (`product_id`,`mod_code`,`city_id`,`count`,`mktime`) VALUES //('".$ggggggggggg."','".trim($line[0])."','".$row_city['id']."','".trim($line[3])."','".time()."');"); } $row_code = @$db->super_query("SELECT * FROM `catalogs_keys_products_cities` WHERE `mod_code`='".trim($line[0])."' AND `city_id`='".$row_city['id']."' LIMIT 1;"); echo "SELECT * FROM `catalogs_keys_products_cities` WHERE `mod_code`='".trim($line[0])."' AND `city_id`='".$row_city['id']."' LIMIT 1;
\n"; if(@$row_code['product_id']==''){ //$row_code_s = @$db->super_query("SELECT * FROM `catalogs_keys_products_cities` WHERE `mod_code`='".trim($line[0])."' LIMIT 1;"); //if(@$row_code_s){ if(!@$rrrrrrrrrrrr[$ggggggggggg] && @$ggggggggggg){ $db->query("UPDATE `catalogs_keys_products_cities` SET `count`='0' WHERE `product_id`='".$ggggggggggg."';"); $rrrrrrrrrrrr[$ggggggggggg] = "1"; } $db->query("INSERT INTO `catalogs_keys_products_cities` (`product_id`,`mod_code`,`count`,`mktime`,`city_id`) VALUES ('".$ggggggggggg."','".trim($line[0])."','".trim($line[3])."','".time()."','".$row_city['id']."');"); $row['product_id'] = $ggggggggggg; echo "INSERT INTO `catalogs_keys_products_cities` (`product_id`,`mod_code`,`count`,`mktime`,`city_id`) VALUES ('".$ggggggggggg."','".trim($line[0])."','".trim($line[3])."','".time()."','".$row_city['id']."');\n
"; //} }else{ if(!@$rrrrrrrrrrrr[@$row_code['product_id']] && @$row_code['product_id']){ $db->query("UPDATE `catalogs_keys_products_cities` SET `count`='".trim($line[3])."' WHERE `mod_code`='".trim($line[0])."' AND `city_id`=".trim($row_city['id']).";"); $rrrrrrrrrrrr[@$row_code['product_id']] = "1"; } echo trim($row['product_id'])."==".$row_code['product_id']; $db->query("UPDATE `catalogs_keys_products_cities` SET `count`='".trim($line[3])."' WHERE `mod_code`='".trim($line[0])."' AND `city_id`=".trim($row_city['id']).";"); $row['product_id'] = $row_code['product_id']; } if(trim(@$row['product_id'])){ $row2 = $db->super_query("SELECT * FROM `catalogs_products` WHERE `id`='".trim($row['product_id'])."' LIMIT 1;"); ///////echo trim($line[0])."--".$row['product_id']."(".$ggggggggggg.")---
"; //////////////////////////// $row_code = @$db->super_query("SELECT COUNT(*) as count FROM `catalogs_modifications` WHERE `product_id`='".$row['product_id']."' AND `active`>0 LIMIT 1;"); if($row_code['count']>0 && $get_out == 0) @$db->query("UPDATE `catalogs_products` SET `count_modifications`='".$row_code['count']."' WHERE `id`='".trim($row['product_id'])."';"); //////////////////////////// //$pid = ""; //if(trim($ggggggggggg)!="") $yyyyyyyyyy = $db->query("UPDATE `catalogs_keys_products_cities` SET `count`=".trim($line[3])." WHERE `mod_code`='".trim($line[0])."' AND `city_id`=".trim($row_city['id']).";"); echo "

UPDATE `catalogs_keys_products_cities` SET `count`=".trim($line[3])." WHERE `mod_code`='".trim($line[0])."' AND `city_id`=".trim($row_city['id']).";

"; if(trim($line[2])!="0.00") $iiiiii = $db->query("UPDATE `catalogs_products` SET `cine_last`='".trim($line[1])."', `cine`='".trim($line[2])."' WHERE `id`='".trim($row['product_id'])."';"); else $iiiiii = $db->query("UPDATE `catalogs_products` SET `cine`='".trim($line[1])."' WHERE `id`='".trim($row['product_id'])."';"); if(trim($line[2])!="0.00") $iiiiii = "UPDATE `catalogs_products` SET `cine2`='".trim($line[1])."', `cine`='".trim($line[2])."' WHERE `id`='".trim($row['product_id'])."';"; else $iiiiii = "UPDATE `catalogs_products` SET `cine`='".trim($line[1])."' WHERE `id`='".trim($row['product_id'])."';"; echo $iiiiii."
\n"; }else{ if(!@$ma[trim($line[0])]){ $ma[trim($line[0])]="1"; $fg2 = @fopen(dirname ( __FILE__ )."/tmp/noDB_mod.csv","a"); fputs($fg2,implode(";",$line)); fclose($fg2); } } if($su2>=1000) exit; $yy = @fopen("counter.txt","w+"); fputs($yy,$su); fclose($yy); $su++; $su2++; } $yy = @fopen("counter.txt","w+"); fputs($yy,"0"); fclose($yy); if($su==(count($cot)-1)) @unlink(dirname( __FILE__ )."/cron/file_1.csv"); ?>