<?php

/**
  * MSU Sitemaps - Magic SEO URL URL for ZenCart
  * http://www.magic-seo-url.com/zencart/
  *
  * 2009, (c) Inveo s.r.o.
  *
  * This program is free software; you can redistribute it and/or
  * modify it under the terms of the GNU General Public License
  * as published by the Free Software Foundation; either version 2
  * of the License, or (at your option) any later version.
**/

if(!defined('SM_IN_SITEMAPS')) exit();

global $cache, $sm, $db;

foreach($GLOBALS['smInstalledLang'] as $langId => $langCode) {
	//$result = $db->Execute("SELECT products_id, products_type, products_date_added, products_last_modified FROM ".TABLE_PRODUCTS." WHERE products_status = '1' ORDER BY products_id DESC");
	$result = $db->Execute("SELECT p.products_id, p.products_type, p.products_date_added, p.products_last_modified FROM ".TABLE_PRODUCTS." p, ".TABLE_PRODUCTS_DESCRIPTION." pd WHERE p.products_status = '1' AND pd.products_id = p.products_id AND pd.language_id = '".$langId."' ORDER BY p.products_id DESC");
	while(!$result->EOF) {
		$fail = false;
		$url = '';
		
		if($result->fields['products_type'] == 1) {
			$delimeter = '';
		} else {
			$delimeter = $result->fields['products_type'].URI_DELIMETER;
		}

		if(URI_MODE == 'normal') {
			$niceData = $cache->read('categories-products', $result->fields['products_id'], $langId);
			if(!$niceData) {
				$fail = true;
			} else {
				$url = $niceData[1].URI_DELIMETER.$delimeter.$result->fields['products_id'].URI_EXTENSION;
			}
			
			if(!empty($niceData[3])) {
				$url = $niceData[3].URI_DELIMETER.$niceData[2].'/'.$url;
			}
			
			if(!empty($niceData[4])) {
				$parentId = $niceData[4];
				$i = 1;
				do {
					$niceData = $cache->read('categories-subcategories', $parentId, $langId);
					if(!$niceData || $i >= CATEGORY_DEPTH) {
						$fail = true;
						break;
					}
					$url = $niceData[1].URI_DELIMETER.$niceData[2].'/'.$url;
					if(!empty($niceData[3])) {
						$parentId = $niceData[3];
					} else {
						break;
					}
					$i++;
				} while(true);
			}
		} else {
			$niceData = $cache->read('products-tiny', $result->fields['products_id'], $langId);
			if(!$niceData) {
				$fail = true;
			} else {
				$url = $niceData[1].URI_DELIMETER.$delimeter.$result->fields['products_id'].URI_EXTENSION;
			}
		}
		
		if(isset($result->fields['products_last_modified'])) {
			$lastMod = $result->fields['products_last_modified'];
		} else {
			$lastMod = $result->fields['products_date_added'];
		}
		
		if($GLOBALS['smMultilang']) {
			$url = $langCode.'/'.$url;
		}
		
		if($fail) $url = UN_ZENCART_MAINFILE.'?main_page='.FILENAME_PRODUCT_INFO.'&amp;products_id='.$result->fields['products_id'].(($GLOBALS['smMultilang']) ? '&amp;language='.$langCode : '');
		
		//$sm->addUrlToSiteMap($url, 'monthly', '0.9', strtotime($lastMod));
		$sm->addUrlToSiteMap($url, 'monthly', '', strtotime($lastMod));
		$result->MoveNext();
	}
}

?>