cr_____.php
6.06 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
<?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");
?>