$children_data              = array();
$children_json_where        = array( "kat_id" => "".$category['kat_id']."" );
$children                   = kat_ust_json_cek($children_json_where);
$category_href              = href_get_cok_dilli ($category['kat_id'],$site);

foreach ($children as $child) {

$children_children_data     = array();
$children_child_json_where  = array( "kat_id" => "".$child['kat_id']."" );
$children_child             = kat_ust_json_cek($children_child_json_where);
$children_data_href         = href_get_cok_dilli ($child['kat_id'],$site);    

foreach ($children_child as $chil) {

$children_children_data_href       = href_get_cok_dilli ($chil['kat_id'],$site);    
$urller[$dil][]                    = ''.$category_href[$dil].'/'.$children_data_href[$dil].'/'.$children_children_data_href[$dil].'' ;
}
$urller[$dil][]                    = ''.$category_href[$dil].'/'.$children_data_href[$dil].'';
}
$urller[$dil][]                    = ''.$category_href[$dil] .'';
}

}

return $urller ;

}

function href_get_g ($category_id,$site,$dil) {
    
global $mysqli ;
global $site ;
global $dil ;
    
$category_href                   = "";    
    
$category_linkler                = on_galeri_kategori_where_cek($wheredata=array("kat_id"=>$category_id),$orderBy="kat_id,asc");
$category_katlink                = $category_linkler["kat_link"]; 
$category_kat_seo                = $category_linkler["kat_seo"]; 
$category_kat_adi                = $category_linkler["kat_adi"]; 

    
echo'
<loc>'.$ayar_site.''.$sayfa_seo.'</loc>';

}

if($key != $dilnormal ) {    
echo'
<xhtml:link  
rel="alternate" 
hreflang="'.$key.'" 
href="'.$ayar_site.''.$sayfa_seo.'"/>    ';
}    
    
}
echo'
</url>';    
}

$cok_dilli_kategoriler = cok_dilli_kategoriler () ;

echo '
<url>
<loc>'.$ayar_site.'</loc>
<lastmod>'.$date.'</lastmod>
<changefreq>daily</changefreq>
<priority>0.5000</priority>
</url>';

echo '
<url>
<loc>'.$ayar_site.'resources</loc>
<lastmod>'.$date.'</lastmod>
<changefreq>daily</changefreq>
<priority>0.5000</priority>
</url>';
    
echo '
<url>
<loc>'.$ayar_site.'contact</loc>

return false;
die();        

}


function yonlendir_sitemap ($config,$dil_kisaltma) {
$dil_sitemap  = $config->get("sitemap") ;

$kat_son                =  array( 

"sayfa_adi"    => "$dil_sitemap" ,
"sayfa_tipi"   => "sitemap" ,
"sayfa_dil"    => $dil_kisaltma ,
"sayfa_seo"    => "sitemap" ,
"sayfa_id"     => "" ,

 );

include('sitemap.php');
return false;
die();    

}


function yonlendir_url ($dil_cek_tumu,$url_son) {
    
global $mysqli ;
    
foreach ($dil_cek_tumu as $dil) {


$kategori_where         = array("".$dil["dil_kisaltma"].""=>"".$url_son."");
$kategori_json          = json_encode($kategori_where, JSON_UNESCAPED_UNICODE);
$kategori_gelen_son     = $mysqli->rawQueryOne ("select * from kategori where kat_durum ='1' and json_contains(kat_seo,'$kategori_json')");


//echo "Last executed query was ". $mysqli->getLastQuery();

"ayar_cep"         => $ayar_cep,
"ayar_email"       => $ayar_email,
"ayar_facebook"    => $ayar_facebook,
"ayar_twitter"     => $ayar_twitter,
"ayar_instagram"   => $ayar_instagram,
"ayar_harita"      => $ayar_harita,
"ayar_site"        => $ayar_site,
"ayar_telefon_temiz"     => $ayar_telefon_temiz,
"ayar_cep_temiz"         => $ayar_cep_temiz,

);

yonlendir_iletisim ($config,$dil_kisaltma,$contact_data);
return false;
die();
}


if( $url_son == "sitemap" ){    
yonlendir_sitemap ($config,$dil_kisaltma);
return false;
die();
}
 
if( $url_son == "demo" ){    

    include('anasayfa.php');    
    return false;
    die();    
}
 
$kat_son = yonlendir_url ($dil_cek_tumu,$url_son);

if($kat_son){
 
if(count($kat_son) != 0) {
    
include(''.$kat_son["sayfa_tipi"].'.php');
return false;
die();