<?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;

$result = $db->Execute("SELECT configuration_value FROM ".TABLE_CONFIGURATION." WHERE configuration_key = 'MAX_DISPLAY_NEW_REVIEWS'");
$perPage = $result->fields['configuration_value'];

foreach($GLOBALS['smInstalledLang'] as $langId => $langCode) {
	$result = $db->Execute("SELECT COUNT(reviews_id) AS numReview FROM ".TABLE_REVIEWS_DESCRIPTION." WHERE languages_id = '".$langId."'");
	$reviewsCount = 0;
	while(!$result->EOF) {
		if($result->fields['numReview'] == 0) {
			$result->MoveNext();
			continue;
		}
	
		$url = 'reviews/';
	
		if($GLOBALS['smMultilang']) {
			$url = $langCode.'/'.$url;
		}

		$pagination = 'index'.URI_DELIMETER.'__PAGE__'.URI_EXTENSION;

		//$sm->addUrlToSiteMap($url, 'weekly', '0.5');
		$sm->addUrlToSiteMap($url, 'weekly');

		$pages = ceil($result->fields['numReview'] / $perPage);

		for ($i = 2; $i <= $pages; $i++) {
			//$sm->addUrlToSiteMap($url.str_replace('__PAGE__', $i, $pagination), 'weekly', '0.5');
			$sm->addUrlToSiteMap($url.str_replace('__PAGE__', $i, $pagination), 'weekly');
		}
		
		$reviewsCount++;
		$result->MoveNext();
	}
	if($reviewsCount == 0) {
		if($GLOBALS['smMultilang']) {
			$sm->addUrlToSiteMap($langCode.'/'.'reviews/', 'weekly');
		} else {
			$sm->addUrlToSiteMap('reviews/', 'weekly');
			break;
		}
	}
}

foreach($GLOBALS['smInstalledLang'] as $langId => $langCode) {
	$result = $db->Execute("SELECT r.reviews_id, r.products_id, r.date_added, r.last_modified FROM ".TABLE_REVIEWS." r, ".TABLE_REVIEWS_DESCRIPTION." rd WHERE rd.reviews_id = r.reviews_id AND rd.languages_id = '".$langId."' ORDER BY r.products_id, r.date_added DESC");
	while(!$result->EOF) {
		$fail = false;
		$niceData = $cache->read('products-reviews', $result->fields['products_id'], $langId);
		$url = '';
		if(!$niceData) {
			$fail = true;
		} else {
			$url = 'reviews/'.$niceData[1].URI_DELIMETER.$result->fields['products_id'].'/customers'.URI_DELIMETER.'review'.URI_DELIMETER.$result->fields['reviews_id'].URI_EXTENSION;
		}

		if(isset($result->fields['last_modified'])) {
			$lastMod = $result->fields['last_modified'];
		} else {
			$lastMod = $result->fields['date_added'];
		}
		
		if($GLOBALS['smMultilang']) {
			$url = $langCode.'/'.$url;
		}

		if($fail) $url = UN_ZENCART_MAINFILE.'?main_page='.FILENAME_PRODUCT_REVIEWS_INFO.'&amp;products_id='.$result->fields['products_id'].'&amp;reviews_id='.$result->fields['reviews_id'].(($GLOBALS['smMultilang']) ? '&amp;language='.$langCode : '');
		
		//$sm->addUrlToSiteMap($url, 'weekly', '0.7', strtotime($lastMod));
		$sm->addUrlToSiteMap($url, 'weekly', '', strtotime($lastMod));
		$result->MoveNext();
	}
}

foreach($GLOBALS['smInstalledLang'] as $langId => $langCode) {
	$result = $db->Execute("SELECT COUNT(rd.reviews_id) AS numReviews, r.products_id FROM ".TABLE_REVIEWS." r, ".TABLE_REVIEWS_DESCRIPTION." rd WHERE rd.reviews_id = r.reviews_id AND rd.languages_id = '".$langId."' GROUP BY r.products_id ORDER BY r.products_id DESC");
	while(!$result->EOF) {
		$fail = false;
		$niceData = $cache->read('products-reviews', $result->fields['products_id'], $langId);
		$url = '';
		if(!$niceData) {
			$fail = true;
		} else {
			$url = 'reviews/'.$niceData[1].URI_DELIMETER.$result->fields['products_id'].'/';
		}

		if($GLOBALS['smMultilang']) {
			$url = $langCode.'/'.$url;
		}
		
		if($fail) {
			$url = UN_ZENCART_MAINFILE.'?main_page='.FILENAME_PRODUCT_REVIEWS.'&amp;products_id='.$result->fields['products_id'].(($GLOBALS['smMultilang']) ? '&amp;language='.$langCode : '');
			$pagination = '&amp;page=__PAGE__';
		} else {
			$pagination = 'index'.URI_DELIMETER.'__PAGE__'.URI_EXTENSION;
		}

		//$sm->addUrlToSiteMap($url, 'monthly', '0.6');
		$sm->addUrlToSiteMap($url, 'monthly');

		$pages = ceil($result->fields['numReviews'] / $perPage);
	
		for ($i = 2; $i <= $pages; $i++) {
			//$sm->addUrlToSiteMap($url.str_replace('__PAGE__', $i, $pagination), 'monthly', '0.6');
			$sm->addUrlToSiteMap($url.str_replace('__PAGE__', $i, $pagination), 'monthly');
		}
		$result->MoveNext();
	}
}

?>