$cat_result = xos_db_query("\n SELECT\n c.categories_or_pages_id,\n c.parent_id,\n cd.language_id,\n UNIX_TIMESTAMP(c.date_added) as date_added,\n UNIX_TIMESTAMP(c.last_modified) as last_modified\n FROM \n " . TABLE_CATEGORIES_OR_PAGES . " c,\n " . TABLE_CATEGORIES_OR_PAGES_DATA . " cd\n WHERE\n c.categories_or_pages_status='1' AND\n c.categories_or_pages_id = cd.categories_or_pages_id AND\n cd.language_id = '" . $value['id'] . "'\n ORDER by \n cd.categories_or_pages_id\n ");
$cat_array = array();
if (xos_db_num_rows($cat_result) > 0) {
while ($cat_data = xos_db_fetch_array($cat_result)) {
$cat_array[$cat_data['categories_or_pages_id']][$lng_code] = $cat_data;
}
}
reset($cat_array);
foreach ($cat_array as $lang_array) {
foreach ($lang_array as $cat_id => $cat_data) {
$lang_param = sizeof($lng->catalog_languages) > 1 ? '&lnc=' . $lng_code : '';
$date = $cat_data['last_modified'] != NULL ? $cat_data['last_modified'] : $cat_data['date_added'];
reset($currencies->currencies);
while (list($key) = each($currencies->currencies)) {
$curr_param = sizeof($currencies->currencies) > 1 ? '&cur=' . $key : '';
$string = sprintf(SITEMAP_ENTRY, xos_href_link('index.php', rv_get_path($cat_data['categories_or_pages_id'], $lng_code) . $lang_param . $curr_param, 'NONSSL', false), PRIORITY_CATEGORIES, iso8601_date($date), CHANGEFREQ_CATEGORIES);
$function_write($fp, $string);
$strlen += strlen($string);
$c++;
if ($autogenerate) {
// 500000 entrys or filesize > 10,485,760 - some space for the last entry
if ($c == MAX_ENTRYS || $strlen >= MAX_SIZE) {
$function_write($fp, SITEMAP_FOOTER);
$function_close($fp);
$c = 0;
$i++;
$fp = $function_open(($output_to_doc_root ? str_replace(DIR_WS_CATALOG, '/', DIR_FS_CATALOG) : DIR_FS_CATALOG) . 'sitemap' . $i . $file_extension, 'w');
$function_write($fp, SITEMAP_HEADER);
$strlen = strlen(SITEMAP_HEADER);
$string = '';
}
$cat_result = olc_db_query("\n SELECT\n c.categories_id,\n c.parent_id,\n cd.language_id,\n UNIX_TIMESTAMP(c.date_added) as date_added,\n UNIX_TIMESTAMP(c.last_modified) as last_modified,\n l.code\n FROM\n " . TABLE_CATEGORIES . " c,\n " . TABLE_CATEGORIES_DESCRIPTION . " cd,\n " . TABLE_LANGUAGES . " l\n WHERE\n \tc.categories_status='1' AND\n c.categories_id = cd.categories_id AND\n cd.language_id = l.languages_id\n ORDER by\n cd.categories_id\n ");
$cat_array = array();
if (olc_db_num_rows($cat_result) > 0) {
while ($cat_data = olc_db_fetch_array($cat_result)) {
$cat_array[$cat_data['categories_id']][$cat_data['code']] = $cat_data;
}
}
reset($cat_array);
$index_php = 'index.php';
$product_info_php = 'product_info.php';
foreach ($cat_array as $lang_array) {
foreach ($lang_array as $cat_id => $cat_data) {
//$lang_param = ($cat_data['code'] != DEFAULT_LANGUAGE) ? '&language='.$cat_data['code'] : EMPTY_STRING;
$lang_param = '&language=' . $cat_data['code'];
$date = $cat_data['last_modified'] != NULL ? $cat_data['last_modified'] : $cat_data['date_added'];
$string = sprintf(SITEMAP_ENTRY, htmlspecialchars(utf8_encode(olc_href_link_catalog($index_php, rv_get_path($cat_data['categories_id'], $cat_data['code']) . $lang_param, NONSSL, false, USE_SEO, false))), PRIORITY_CATEGORIES, iso8601_date($date), CHANGEFREQ_CATEGORIES);
$c_cat_total++;
output_entry();
}
}
$product_result = olc_db_query("\n SELECT\n p.products_id,\n pd.language_id,\n UNIX_TIMESTAMP(p.products_date_added) as products_date_added,\n UNIX_TIMESTAMP(p.products_last_modified) as products_last_modified,\n l.code\n FROM\n " . TABLE_PRODUCTS . " p,\n " . TABLE_PRODUCTS_DESCRIPTION . " pd,\n " . TABLE_LANGUAGES . " l\n WHERE\n p.products_status='1' AND\n p.products_id = pd.products_id AND\n pd.language_id = l.languages_id\n ORDER BY\n p.products_id\n ");
if (olc_db_num_rows($product_result) > 0) {
while ($product_data = olc_db_fetch_array($product_result)) {
//$lang_param = ($product_data['code'] != DEFAULT_LANGUAGE) ? '&language='.$product_data['code'] : EMPTY_STRING;
$lang_param = '&language=' . $product_data['code'];
$date = $product_data['products_last_modified'] != NULL ? $product_data['products_last_modified'] : $product_data['products_date_added'];
$string = sprintf(SITEMAP_ENTRY, htmlspecialchars(utf8_encode(olc_href_link_catalog($product_info_php, 'products_id=' . $product_data['products_id'] . $lang_param, NONSSL, false, SEARCH_ENGINE_FRIENDLY_URLS, false))), PRIORITY_PRODUCTS, iso8601_date($date), CHANGEFREQ_PRODUCTS);
$c_prod_total++;
output_entry();
}
}
