| Server IP : 162.0.232.25 / Your IP : 18.191.171.72 Web Server : LiteSpeed System : Linux premium276.web-hosting.com 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64 User : kwacuqig ( 988) PHP Version : 8.2.26 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/kwacuqig/malawisounds.com/ |
Upload File : |
<?php
include './connect.php';
include './php/filterFile.php';
$lastmod=date('c');
$data_xml='<?xml version="1.0" encoding="UTF-8"?>';
$data_xml.="\n";
$data_xml.='<?xml-stylesheet type="text/xsl" href="sitemap-style.xsl"?>';
$data_xml.='<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.sitemaps.org/schemas/sitemap/0.9 http://www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd">';
$data_xml.="
<url>
<loc>https://malawisounds.com</loc>
<lastmod>$lastmod</lastmod>
<priority>1.00</priority>
</url>
";
//Static URLs
$static_url=['home','singles','biography','albums','e-news','videos','oldies','contact-us','about-us','upload-music'];
foreach($static_url as $url){
$data_xml.="
<url>
<loc>https://malawisounds.com/$url</loc>
<lastmod>$lastmod</lastmod>
<priority>0.90</priority>
</url>
";
}
//Dynamic URLs
//Singles
$query="SELECT * FROM `tbl_uploads` WHERE `verify`=1 ORDER BY `id` DESC";
$run=mysqli_query($conn,$query) or die(mysqli_error($conn));
while($row=mysqli_fetch_array($run)){
if($row['song_mode']=='free'){
$song=$row['id'].'-'.strtolower(str_replaceHyphen($row['title'])).'-by-'.strtolower(str_replaceHyphen($row['artist']));
$data_xml.="
<url>
<loc>https://malawisounds.com/$song</loc>
<lastmod>$lastmod</lastmod>
<priority>0.80</priority>
</url>
";
} else {
$song=$row['id'].'-buy-'.strtolower(str_replaceHyphen($row['title'])).'-by-'.strtolower(str_replaceHyphen($row['artist']));
$data_xml.="
<url>
<loc>https://malawisounds.com/$song</loc>
<lastmod>$lastmod</lastmod>
<priority>0.80</priority>
</url>
";
}
}
//Albums
$query="SELECT * FROM `ulbum` ORDER BY `id` DESC";
$run=mysqli_query($conn,$query) or die(mysqli_error($conn));
while($row=mysqli_fetch_array($run)){
if($row['mode']=='free'){
$album=strtolower(str_replaceHyphen($row['title'])).'-by-'.strtolower(str_replaceHyphen($row['artist']));
$data_xml.="
<url>
<loc>https://malawisounds.com/$album</loc>
<lastmod>$lastmod</lastmod>
<priority>0.80</priority>
</url>
";
} else {
$album='buy-'.strtolower(str_replaceHyphen($row['title'])).'-'.$row['type'].'-by-'.strtolower(str_replaceHyphen($row['artist']));
$data_xml.="
<url>
<loc>https://malawisounds.com/$album</loc>
<lastmod>$lastmod</lastmod>
<priority>0.80</priority>
</url>
";
}
}
//Artists
$query="SELECT * FROM `biography` ORDER BY `id` DESC";
$run=mysqli_query($conn,$query) or die(mysqli_error($conn));
while($row=mysqli_fetch_array($run)){
$artist='artist='.str_replaceHyphen($row['artist_name']);
$data_xml.="
<url>
<loc>https://malawisounds.com/$artist</loc>
<lastmod>$lastmod</lastmod>
<priority>0.90</priority>
</url>
";
}
//News
$query="SELECT * FROM `news` ORDER BY `nid` DESC";
$run=mysqli_query($conn,$query) or die(mysqli_error($conn));
while($row=mysqli_fetch_array($run)){
$article='article='.$row['nid'];
$data_xml.="
<url>
<loc>https://malawisounds.com/$article</loc>
<lastmod>$lastmod</lastmod>
<priority>0.70</priority>
</url>
";
}
//Videos
$query="SELECT * FROM `videos` ORDER BY `id` DESC";
$run=mysqli_query($conn,$query) or die(mysqli_error($conn));
while($row=mysqli_fetch_array($run)){
$video='video='.$row['id'].'-'.strtolower(str_replaceHyphen($row['title'])).'-by-'.strtolower(str_replaceHyphen($row['artist']));
$data_xml.="
<url>
<loc>https://malawisounds.com/$video</loc>
<lastmod>$lastmod</lastmod>
<priority>0.80</priority>
</url>
";
}
$data_xml.='</urlset>';
//File Handling
$file=fopen('sitemap.xml', 'w');
fwrite($file, $data_xml);
fclose($file);
header('location:home');