cr_____.php

<?php
//error_reporting (0);
set_time_limit(30);
@include_once(dirname ( __FILE__ )."/new_csv/mysql.class.php");
define ("DBHOST", "db"); 
define ("DBNAME", "extrem");
define ("DBUSER", "extrem");
define ("DBPASS", "9gvs7AbI");  
$db = new db;
$link = mysql_connect(DBHOST,DBNAME,DBPASS);
if(@$link) echo "ok";
else echo "not";
//$fg = @fopen(dirname( __FILE__ )."/cron/file_1.csv","r");
//if(!@$fg) exit;
//@fclose($fg);
//exit;
$rrrrrrrrrrrr = array();
$ma = array();
$su = 0;
$su2 = 0;
$yy = @fopen("counter.txt","r+");
$su = trim(fread($yy,128));
fclose($yy);
$fg = fopen(dirname( __FILE__ )."/cron/file_1.csv","r");
if(@$fg){
$cot = "";
while(!feof($fg))
$cot = $cot.fread($fg,512);
@fclose($fg);
}
$cot = explode("\n",$cot);
if(trim($su)<=0 && count($cot)>2){
$fg = @fopen(dirname ( __FILE__ )."/tmp/noDB_mod.csv","w+");
fclose($fg);
}
for($i=$su;$i<count($cot)-1;$i++){
$get_out = 0;
$line = explode(";",$cot[$i]);
if(trim($line[3])>0){
$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 "<br/><br/><br/>UPDATE `catalogs_products` SET `count_modifications` = 0,`active` = '0' WHERE `id` = '".$row['product_id']."';<br/><br/><br/>";
$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;<br/>\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<br/>";
//}
}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.")---<br/>";
////////////////////////////
$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 "<br/><br/>UPDATE `catalogs_keys_products_cities` SET `count`=".trim($line[3])." WHERE `mod_code`='".trim($line[0])."' AND `city_id`=".trim($row_city['id']).";<br/><br/>";
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."<br/>\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");
?>