<?php

header("Content-Type: application/xml; charset=utf-8");

echo '<?xml version="1.0" encoding="UTF-8"?>'.PHP_EOL;

echo '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">'.PHP_EOL;

$credentials = array(
	array('localhost', 'civilengijceae', 'p=9F7#tN~Zqb', 'civilengineeringjournalsijceae', 'ijceae'),
	array('localhost', 'civilengijcec', '#9AR8fIi=*nJ', 'civilengineeringjournalsijcec', 'ijcec'),
	array('localhost', 'civilengijhce', 'r6F+AK^JX1N%', 'civilengineeringjournalsijhce', 'ijhce'),
	array('localhost', 'civilengijrcet', '6d,@Zu=&}h3Q', 'civilengineeringjournalsijrcet', 'ijrcet'),
	array('localhost', 'civilengijsde', '1n]n;%ZzI~qH', 'civilengineeringjournalsijsde', 'ijsde'),
	array('localhost', 'civilengijsse', 'aC&1*6XIw_L9', 'civilengineeringjournalsijsse', 'ijsse'),
	array('localhost', 'civilengjcea', 'c=H7,@?Nx}}x', 'civilengineeringjournalsjcea', 'jcea'),
);

foreach ($credentials as $credential) {
	$db = new mysqli($credential[0], $credential[1], $credential[2], $credential[3]);
	
	$baseurl = 'https://www.civilengineeringjournals.com/'.$credential[4].'/';

	$stmt = $db->prepare("SELECT name FROM pages WHERE name != 'search'") or die('An error occurred. Please try after some time.');
	$stmt->execute();
	$stmt->store_result();
	$stmt->bind_result($name);
	while ($stmt->fetch()) {
		echo '<url>'.PHP_EOL;
		echo '<loc>'.($name == $credential[4] ? $baseurl : $baseurl.$name).'</loc>'.PHP_EOL;
		echo '<lastmod>'.date('Y-m-d').'</lastmod>'.PHP_EOL;
		echo '<changefreq>'.(in_array($name, array($credential[4], 'archives')) ? 'daily' : 'monthly').'</changefreq>'.PHP_EOL;
		echo '<priority>'.(in_array($name, array($credential[4], 'archives')) ? '1.0' : '0.8').'</priority>'.PHP_EOL;
		echo '</url>'.PHP_EOL;
	}
	$stmt->close();

	$stmt = $db->prepare("SELECT archivesid, year, refnumber, volume, issue, part, file FROM archives") or die('An error occurred. Please try after some time.');
	$stmt->execute();
	$stmt->store_result();
	$stmt->bind_result($archivesid, $year, $refnumber, $volume, $issue, $part, $file);
	while ($stmt->fetch()) {
		echo '<url>'.PHP_EOL;
		echo '<loc>'.$baseurl.'archives/'.$year.'.v'.$volume.'.i'.$issue.'.'.$part.'</loc>'.PHP_EOL;
		echo '<lastmod>'.date('Y-m-d').'</lastmod>'.PHP_EOL;
		echo '<changefreq>monthly</changefreq>'.PHP_EOL;
		echo '<priority>0.8</priority>'.PHP_EOL;
		echo '</url>'.PHP_EOL;
	
		echo '<url>'.PHP_EOL;
		echo '<loc>'.$baseurl.'archives/'.$year.'.v'.$volume.'.i'.$issue.'.'.$part.'.'.$archivesid.'</loc>'.PHP_EOL;
		echo '<lastmod>'.date('Y-m-d').'</lastmod>'.PHP_EOL;
		echo '<changefreq>monthly</changefreq>'.PHP_EOL;
		echo '<priority>0.8</priority>'.PHP_EOL;
		echo '</url>'.PHP_EOL;
	
		echo '<url>'.PHP_EOL;
		echo '<loc>'.$baseurl.'article/'.$archivesid.'/'.$file.'</loc>'.PHP_EOL;
		echo '<lastmod>'.date('Y-m-d').'</lastmod>'.PHP_EOL;
		echo '<changefreq>monthly</changefreq>'.PHP_EOL;
		echo '<priority>0.8</priority>'.PHP_EOL;
		echo '</url>'.PHP_EOL;
	}
	$stmt->close();
}

echo '</urlset>'.PHP_EOL;