citywebshop_cms/sitemap.php

<?php

require_once('application/config/config.php');
$conn = mysqli_connect($config['db_host'],$config['db_username'],$config['db_password'],$config['db_name']);

$tipus = array('elado','kiado');
$jelleg = array('lakas','csaladihaz','epuletresz','hazresz','ikerhaz','teljesepulet','garazs','kereskedelmi','mezogazdasagi','tarolo','telek');
$limit = 24;
$prefix = 'https://rockhome.hu/';

$roman = array(
    "budapest-i-kerulet",
    "budapest-ii-kerulet",
    "budapest-iii-kerulet",
    "budapest-iv-kerulet",
    "budapest-v-kerulet",
    "budapest-vi-kerulet",
    "budapest-vii-kerulet",
    "budapest-viii-kerulet",
    "budapest-ix-kerulet",
    "budapest-x-kerulet",
    "budapest-xi-kerulet",
    "budapest-xii-kerulet",
    "budapest-xiii-kerulet",
    "budapest-xiv-kerulet",
    "budapest-xv-kerulet",
    "budapest-xvi-kerulet",
    "budapest-xvii-kerulet",
    "budapest-xviii-kerulet",
    "budapest-xix-kerulet",
    "budapest-xx-kerulet",
    "budapest-xxi-kerulet",
    "budapest-xxii-kerulet",
    "budapest-xxiii-kerulet");

$arab = array(
    "Budapest 1 kerület", 
    "Budapest 2 kerület", 
    "Budapest 3 kerület", 
    "Budapest 4 kerület", 
    "Budapest 5 kerület", 
    "Budapest 6 kerület", 
    "Budapest 7 kerület", 
    "Budapest 8 kerület", 
    "Budapest 9 kerület", 
    "Budapest 10 kerület", 
    "Budapest 11 kerület", 
    "Budapest 12 kerület", 
    "Budapest 13 kerület", 
    "Budapest 14 kerület", 
    "Budapest 15 kerület", 
    "Budapest 16 kerület", 
    "Budapest 17 kerület", 
    "Budapest 18 kerület", 
    "Budapest 19 kerület", 
    "Budapest 20 kerület", 
    "Budapest 21 kerület", 
    "Budapest 22 kerület", 
    "Budapest 23 kerület"
);

$xml = '<?xml version="1.0" encoding="UTF-8"?>
    <urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">';

foreach ($tipus as $tip) {
    foreach ($jelleg as $jel) {
        for ($i=1;$i<$limit;$i++) {
            $temp = 'Budapest '.$i.' kerület';
            $kerulet = str_replace($arab,$roman,$temp);
            $xml.= '
            <url>
                <loc>'.$prefix.$tip.'/'.$jel.'/'.$kerulet.'</loc>
                <lastmod>'.date('Y-m-d').'</lastmod>
            </url>';
        }
    }
}

$conn = mysqli_connect($config['db_host'],$config['db_username'],$config['db_password'],$config['db_name']);
mysqli_query($conn,"SET NAMES utf8");
mysqli_query($conn,"SET CHARACTER utf8");
mysqli_select_db($conn,'rockhome_backend');

$res = mysqli_query($conn,"SELECT * FROM hiper_ingatlan WHERE telepules NOT LIKE '%Budapest%' AND telepules<>'' GROUP BY telepules;");
while ($row = mysqli_fetch_array($res)) {
    foreach ($tipus as $tip) {
        foreach ($jelleg as $jel) {
            $varos = strtolower($row['telepules']);
            $varos = str_replace(" ","-",$varos);
            $varos = str_replace(".","",$varos);
            $accented = array( "á", "é", "í", "ó", "ö", "ő", "ú", "ü", "ű" );
            $mask = array( "a", "e", "i", "o", "o", "o", "u", "u", "u" );
            $varos = str_replace($accented,$mask,$varos);
            
            $xml.= '
            <url>
                <loc>'.$prefix.$tip.'/'.$jel.'/'.$varos.'</loc>
                <lastmod>'.date('Y-m-d').'</lastmod>
            </url>';
        }
    }
}

mysqli_select_db($conn,$config['db_name']);

$res = mysqli_query($conn,"SELECT * FROM azonics_pages WHERE page_slug LIKE '%/%' AND page_status='1';");
while ($row = mysqli_fetch_array($res)) {
            $xml.= '
            <url>
                <loc>'.$prefix.$row['page_slug'].'</loc>
                <lastmod>'.date('Y-m-d').'</lastmod>
            </url>';
}

$xml.= '
</urlset>';

file_put_contents("sitemap.xml",$xml);

echo 'XML sitemap generated...'.PHP_EOL;