<?php
set_time_limit(0);
//error_reporting (0);
$_SERVER['DOCUMENT_ROOT'] = realpath(dirname(__FILE__)."/..");
require($_SERVER['DOCUMENT_ROOT'] . "/libs/setup.php");
require($_SERVER['DOCUMENT_ROOT'] . "/libs/sitemap.class.php");
$setup = new setup();

$siteMap = new SiteMap($setup->db);
$siteMap->addUrl("http://extremstyle.ua/","1.0",date("Y-m-d"),"daily");
$siteMap->addUrl("http://extremstyle.ua/address.kml","0.5",date("Y-m-d"),"daily");
$siteMap->addUrl("http://extremstyle.ua/payment/","0.5",date("Y-m-d"),"daily");
$siteMap->addUrl("http://extremstyle.ua/shops/","0.5",date("Y-m-d"),"daily");
$siteMap->addUrl("http://extremstyle.ua/services/","0.5",date("Y-m-d"),"daily");
$siteMap->addUrl("http://extremstyle.ua/vacancy/","0.5",date("Y-m-d"),"daily");
$siteMap->addUrl("http://extremstyle.ua/training/","0.5",date("Y-m-d"),"daily");
$siteMap->addUrl("http://extremstyle.ua/line/","0.5",date("Y-m-d"),"daily");

$siteMap->addUrl("http://extremstyle.ua/ukr/","1.0",date("Y-m-d"),"daily");
$siteMap->addUrl("http://extremstyle.ua/ukr/payment/","0.5",date("Y-m-d"),"daily");
$siteMap->addUrl("http://extremstyle.ua/ukr/shops/","0.5",date("Y-m-d"),"daily");
$siteMap->addUrl("http://extremstyle.ua/ukr/services/","0.5",date("Y-m-d"),"daily");
$siteMap->addUrl("http://extremstyle.ua/ukr/vacancy/","0.5",date("Y-m-d"),"daily");
$siteMap->addUrl("http://extremstyle.ua/ukr/training/","0.5",date("Y-m-d"),"daily");
$siteMap->addUrl("http://extremstyle.ua/ukr/line/","0.5",date("Y-m-d"),"daily");

$siteMap->addTable("http://extremstyle.ua/%s-catalogs/","0.9",date("Y-m-d"),"daily", "catalogs_rubrics",array("translit"),"parent_id>0",1);
//and p.id='65146'
$siteMap->addTable("http://extremstyle.ua/%s-catalogs/%s-%s/","0.8",date("Y-m-d"),"daily", "catalogs_products p LEFT JOIN catalogs_rubrics r ON r.id=p.rubric_id",array("r.translit as rubric_translit","p.translit","p.id"),"p.count_modifications>0",1);
$siteMap->addTable("http://extremstyle.ua/%s-catalogs/filter;brend=%s;/","0.8",date("Y-m-d"),"daily", "catalogs_brends b LEFT JOIN catalogs_rubrics r ON r.id=b.rubric_id",array("r.translit as rubric_translit","b.name"),"b.name<>'' and r.translit<>'' GROUP BY b.name",1);

$siteMap->addTable("http://extremstyle.ua/%s-catalogs/filter;filter=f%s_%s/","0.7",date("Y-m-d"),"daily", "catalogs_filters f LEFT JOIN catalogs_rubrics r ON r.id=f.rubric_id",array("r.translit as rubric_translit","f.id","f.prefix"),"r.translit<>''",1);
$siteMap->addTable("http://extremstyle.ua/%s-catalogs/filter;filter=y%s_%s/","0.7",date("Y-m-d"),"daily", "catalogs_years y LEFT JOIN catalogs_rubrics r ON r.id=y.rubric_id",array("r.translit as rubric_translit","y.id","y.name"),"r.translit<>''",1);

$siteMap->addTable("http://extremstyle.ua/ukr/%s-catalogs/","0.9",date("Y-m-d"),"daily", "catalogs_rubrics",array("translit"),"parent_id>0",1);
//and p.id='65146'
$siteMap->addTable("http://extremstyle.ua/ukr/%s-catalogs/%s-%s/","0.8",date("Y-m-d"),"daily", "catalogs_products p LEFT JOIN catalogs_rubrics r ON r.id=p.rubric_id",array("r.translit as rubric_translit","p.translit","p.id"),"p.count_modifications>0",1);
$siteMap->addTable("http://extremstyle.ua/ukr/%s-catalogs/filter;brend=%s;/","0.8",date("Y-m-d"),"daily", "catalogs_brends b LEFT JOIN catalogs_rubrics r ON r.id=b.rubric_id",array("r.translit as rubric_translit","b.name"),"b.name<>'' and r.translit<>'' GROUP BY b.name",1);

$siteMap->addTable("http://extremstyle.ua/ukr/%s-catalogs/filter;filter=f%s_%s/","0.7",date("Y-m-d"),"daily", "catalogs_filters f LEFT JOIN catalogs_rubrics r ON r.id=f.rubric_id",array("r.translit as rubric_translit","f.id","f.prefix"),"r.translit<>''",1);
$siteMap->addTable("http://extremstyle.ua/ukr/%s-catalogs/filter;filter=y%s_%s/","0.7",date("Y-m-d"),"daily", "catalogs_years y LEFT JOIN catalogs_rubrics r ON r.id=y.rubric_id",array("r.translit as rubric_translit","y.id","y.name"),"r.translit<>''",1);


$siteMap->addUrl("http://extremstyle.ua/news/","0.5",date("Y-m-d"),"daily");
$siteMap->addTable("http://extremstyle.ua/news/%s/","0.6",date("Y-m-d"),"daily", "news",array("id"));
$siteMap->addUrl("http://extremstyle.ua/articles/","0.5",date("Y-m-d"),"daily");
$siteMap->addTable("http://extremstyle.ua/articles/%s/","0.6",date("Y-m-d"),"daily", "articles",array("id"));
$siteMap->addUrl("http://extremstyle.ua/video/","0.5",date("Y-m-d"),"daily");
$siteMap->addTable("http://extremstyle.ua/video/%s/","0.6",date("Y-m-d"),"daily", "video",array("id"));
$siteMap->addUrl("http://extremstyle.ua/akcii/","0.5",date("Y-m-d"),"daily");
$siteMap->addUrl("http://extremstyle.ua/catalogs/brends/","0.5",date("Y-m-d"),"daily");


$siteMap->addUrl("http://extremstyle.ua/ukr/news/","0.5",date("Y-m-d"),"daily");
$siteMap->addTable("http://extremstyle.ua/ukr/news/%s/","0.6",date("Y-m-d"),"daily", "news",array("id"));
$siteMap->addUrl("http://extremstyle.ua/ukr/articles/","0.5",date("Y-m-d"),"daily");
$siteMap->addTable("http://extremstyle.ua/ukr/articles/%s/","0.6",date("Y-m-d"),"daily", "articles",array("id"));
$siteMap->addUrl("http://extremstyle.ua/ukr/video/","0.5",date("Y-m-d"),"daily");
$siteMap->addTable("http://extremstyle.ua/ukr/video/%s/","0.6",date("Y-m-d"),"daily", "video",array("id"));
$siteMap->addUrl("http://extremstyle.ua/ukr/akcii/","0.5",date("Y-m-d"),"daily");
$siteMap->addUrl("http://extremstyle.ua/ukr/catalogs/brends/","0.5",date("Y-m-d"),"daily");

$res = $setup->db->getAll('select * from url_tags order by id desc',array(),DB_FETCHMODE_ASSOC);
foreach($res as $l){
$siteMap->addUrl("http://extremstyle.ua".$l['url'],"0.9",date("Y-m-d"),"daily");	
	
}

$siteMap->start();
$siteMap->saveXML($_SERVER['DOCUMENT_ROOT'] . "/sitemap.xml");
?>