getAll("select * from catalogs_products where catalog_id=? and brend_id=?",array(75,15),DB_FETCHMODE_ASSOC);
foreach($res as $row){
$p = $db->getRow('select * from catalogs_gallery where product_id=? order by id limit 1',array($row['id']),DB_FETCHMODE_ASSOC);
$fields_values['pic'] = upload_ImageResize(array('tmp_name'=>"../pics/catalogs_gallery/big/".$p['pic_big'],'name'=>$p['pic_big']),array('width'=>"147",'height'=>"147",'upload_path'=>'../pics/products/'));
$fields_values['pic_big'] = upload_ImageResize(array('tmp_name'=>"../pics/catalogs_gallery/big/".$p['pic_big'],'name'=>$p['pic_big']),array('width'=>"700",'height'=>"700",'upload_path'=>'../pics/products/big/'));
$db->autoExecute("catalogs_products",$fields_values,DB_AUTOQUERY_UPDATE,'id='.$row['id']);
}
/**
$db->query('delete from catalogs_products where catalog_id=? and brend_id=?',array(75,15));
if (($handle = fopen("ep.csv", "r")) !== FALSE) {
while (($data = fgetcsv($handle, 1000, ";")) !== FALSE) {
echo $data[0] . "
\n";
if(strlen(trim($data[3]))>0){
$table = 'Ïðîèçâîäèòåëü: '.$data[2].'
'. 'Öâåò: '.$data[4].'
'. 'Äèàïàçîí ÷àñòîò: '.$data[5].'
'. 'Ñîïðîòèâëåíèå: '.$data[6].'
'. '×óâñòâèòåëüíîñòü: '.$data[7].'
'. 'Äëèíà øíóðà: '.$data[8].'
'. 'Âåñ: '.$data[9].'
';
$fields_values = array(
'catalog_id' => 75,
'brend_id' => 15,
'status' => 1,
'name' => $data[3],
'code' => $data[11],
'translit' => translitIt($data[3]),
'text' => $data[10],
'features' => $table,
//'video_code' => $data['video_code'],
//'cost' => $data['cost'],
//'recommended' => $data['recommended'],
'meta_title' => $data[3],
'meta_description' => $data[3],
'meta_keywords' =>$data[3],
'meta_about' => $data[3]
);
//$fields_values['pic'] = upload_ImageResize($upload[0],array('crop'=>true,'width'=>"147",'height'=>"147",'upload_path'=>'../pics/products/'));
//$fields_values['pic_big'] = upload_ImageResize($upload[0],array('width'=>"700",'height'=>"700",'upload_path'=>'../pics/products/big/'));
print"";
print_r($data);
$db->autoExecute("catalogs_products",$fields_values,DB_AUTOQUERY_INSERT); $product_id = mysql_insert_id();
$dir = "../files/skullcandy/".$data[16];
// Îòêðûòü èçâåñòíûé êàòàëîã è íà÷àòü ñ÷èòûâàòü åãî ñîäåðæèìîå
if (is_dir($dir)) {
if ($dh = opendir($dir)) {
while (($file = readdir($dh)) !== false) {
if( $file == '.' || $file == '..') continue;
//echo "ôàéë: $file
";
$data = array("name"=>'',
"product_id"=>$product_id,
"type"=>'img',
"code"=>''
);
$upload['pic']['name'] = $file;
print $upload['pic']['tmp_name'] = $dir . '/' . $file;
$gallery->save($data,$upload);
}
closedir($dh);
}
}
}
}
fclose($handle);
}**/
?>