function csvProdSeoUrlAlias($new = 'no', $newarray = '', $folder = '') { $csv_file = '"URL_ALIAS_ID";"QUERY";"KEYWORD"' . "\r\n"; if ($new == 'yes') { $query = $this->db->query("SELECT product_id, short_product_name, category_name, subcategory_name FROM cv_products WHERE product_id IN ({$newarray})"); } else { $query = $this->db->query("SELECT product_id, short_product_name, category_name, subcategory_name FROM cv_products"); } if ($query->num_rows() > 0) { foreach ($query->result() as $row) { $subCatSeo = ''; if (!empty($row->subcategory_name)) { $subCatSeo = seofromname($row->subcategory_name) . '/'; } $seoUrl = seofromname($row->category_name) . '/' . $subCatSeo . seofromname($row->short_product_name); $csv_file .= '"";"product_id=' . $row->product_id . '";"' . $seoUrl . '.html"' . "\r\n"; } // $csv_file .= 'FINISH'."\r\n"; $file_name = 'oc_product__url_alias.csv'; $file_path = $_SERVER["DOCUMENT_ROOT"] . '/upload/opencart/' . $folder; $file_path_name = $file_path . $file_name; array_map("unlink", glob($_SERVER["DOCUMENT_ROOT"] . "/upload/opencart/*.csv")); $file = fopen($file_path_name, "w"); fwrite($file, trim($csv_file)); fclose($file); return $file_name; } }
function parseImages($imgurl) { $imgurl = trim($imgurl); if (filter_var($imgurl, FILTER_VALIDATE_URL) !== FALSE) { include 'php/simple_html_dom.php'; if (!is_dir(SAVE_IMAGES_PATH)) { return 'PLEASE: setup SAVE_IMAGES_PATH path to your desctop in application\\config\\constants.php'; } $link = str_replace("http://", "https://", trim($imgurl)); $lin_arr = array(); $kk = 0; $q = 1; $curl = curl_init(); curl_setopt($curl, CURLOPT_URL, $link); curl_setopt($curl, CURLOPT_RETURNTRANSFER, true); curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($curl, CURLOPT_USERAGENT, 'Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2 GTB5'); // set user agent $out = curl_exec($curl); $httpCode = curl_getinfo($curl, CURLINFO_HTTP_CODE); if ($httpCode == 200) { $html = str_get_html($out); foreach ($html->find('h1[class="fn"]') as $h1t) { //echo $h1t->innertext; $title = seofromname($h1t->innertext); // this function from 'chinavasion' helper } $filename = SAVE_IMAGES_PATH . '\\gallery\\' . $title; // if we have such folder on desctop so we skip it if (file_exists($filename)) { curl_close($curl); // clean content return 'File: ' . $title . ' already exists at Your DESKTOP'; } else { // create folder on the desktop mkdir(SAVE_IMAGES_PATH . '\\' . $title); foreach ($html->find('#xxyts img') as $element) { $main_img_url = "http:{$element->src}"; $ext = pathinfo($main_img_url); // get file data $extension = $ext['extension']; // get file extension $path = SAVE_IMAGES_PATH . '/' . $title . '.' . $extension; // set path where will save image file_put_contents($path, file_get_contents($main_img_url)); // download image and save it } // find & save ADDITIONAL images $i = 1; foreach ($html->find('#xys img') as $element2) { $add_img_url = "http:{$element2->src}"; $add_img_url = str_replace('.thumb_70x70.jpg', '', $add_img_url); $add_img_url = str_replace('.thumb_140x140.jpg', '', $add_img_url); $add_img_url = str_replace('images/thumbnails/', 'images/', $add_img_url); $ext2 = pathinfo($add_img_url); // get file data $extension2 = $ext2['extension']; // get file extension $path2 = SAVE_IMAGES_PATH . '/' . $title . '/' . $i . '.' . $extension2; // set path where will save image file_put_contents($path2, file_get_contents($add_img_url)); // download image and save it $i++; } $gallery = htmlentities($title); curl_close($curl); // clean content return $gallery; } } else { return FALSE; } } else { return FALSE; } }