<?php

	/*
	 * Include config  files
	 */
	$security_key = 'akz2TaXRfaZ4dAqEeugt';
	require_once "includes/main.inc.php";

	/*
	 * Cassette object
	 */
	$cassette = new cassetteFrontend();
	$cassette->connectDB();
	
	$cassette->base = "https://www.oudlondon.nl/";
	
	$xml = new SimpleXMLElement('<urlset/>');
	$xml->addAttribute('xmlns', 'http://www.sitemaps.org/schemas/sitemap/0.9');
	
	
	// main pages
	$navs 	= $cassette->run("SELECT * FROM `secties` WHERE `active` = '1' ORDER BY `position` ASC");
	
	//$main_nav		= $p->getNavigation(1);
	foreach($navs as $i => $n){
		$link 	= $i != 0 ? $cassette->base.vl($n["naam"]) : $cassette->base;
	
		$url 	= $xml->addChild('url');
		$url->addChild('loc', $link);

		if($i == 0) continue;

		// top level
		$data = $cassette->entries($n["naam"]);
		

		//if($n["naam"] == "Locaties") d($data);
		
		foreach($data as $s){
			
			$fn		= $s->first_field;
			
			
			$link 	= $cassette->base.$s->entry_link;//$config->base.vl2($n["naam"]).'/'.vl($s->$fn)."-".$s->unique_id;
			
			$url 	= $xml->addChild('url');
			$url->addChild('loc', $link);
			
		}	
		// categories
		$categories 	= $cassette->run("SELECT * FROM `categories` WHERE `sectie_id` = '". $n["sectie_id"] ."' AND `active`='1' ORDER BY position ASC");
		foreach($categories as $c){
			//d($c);
			$entries = $cassette->entries($n["naam"],$c["naam"]);
			
			foreach($entries as $s){
			
				$fn		= $s->first_field;
			
			
				$link 	= $cassette->base.$s->entry_link;//$config->base.vl2($n["naam"]).'/'.vl($s->$fn)."-".$s->unique_id;
			
				$url 	= $xml->addChild('url');
				$url->addChild('loc', $link);
			
			}	
		}
			
		
	}

	Header('Content-type: text/xml');
	print($xml->asXML());
	
?>