. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
| Server IP : 52.223.31.75 / Your IP : 172.31.6.220 [ Web Server : Apache/2.4.66 () OpenSSL/1.0.2k-fips PHP/7.4.33 System : Linux ip-172-31-14-81.eu-central-1.compute.internal 4.14.281-212.502.amzn2.x86_64 #1 SMP Thu May 26 09:52:17 UTC 2022 x86_64 User : apache ( 48) PHP Version : 7.4.33 Disable Function : NONE Domains : 4 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /var/www/ripara.co/ |
Upload File : |
<?php
header("Content-type: application/xhtml+xml");
$output = '<?xml version="1.0" encoding="UTF-8"?>' . "\n";
$output .= '<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">' . "\n";
echo $output;
include "connessioneDb.php";
$sql = "SELECT DISTINCT categoriablog.* FROM categoriablog join blog on categoriablog.idCategoria = blog.idcategoria";
$date = mysqli_query($connessione,$sql);
//echo mysql_error();
while($blog = mysqli_fetch_assoc($date)){
echo '<url>
<loc>https://www.ripara.co/index.php?page=blog&idcat='.$blog['idCategoria'].'&titolo='.str_replace(" ", "-", str_replace("&", "", str_replace("'", "", $blog['nomeCategoria']))).'</loc>
<lastmod>'.date("Y-m-d").'</lastmod>
<changefreq>weekly</changefreq>
<priority>0.8</priority>
</url>';
}
$sql = "SELECT * FROM blog join categoriablog on blog.idcategoria = categoriablog.idCategoria ";
if(array_key_exists("idcat", $_GET) && $_GET['idcat']){
$sql.= " WHERE blog.idcategoria = ". intVal($_GET['idcat']);
}
// echo $sql;
$date = mysqli_query($connessione,$sql);
//echo mysql_error();
$blogs = array();
while($blog = mysqli_fetch_assoc($date)){
$data = explode(" ", $blog['data']);
echo '<url>
<loc>https://www.ripara.co/index.php?page=articolo&id='.$blog['id'].'&titolo='.str_replace(" ", "-", str_replace("&", "", str_replace("'", "", $blog['titolo']))).'</loc>
<lastmod>'.$data[0].'</lastmod>
<changefreq>weekly</changefreq>
<priority>0.8</priority>
</url>';
}
$sql = "SELECT * from prodotto join device on prodotto.idDevice = device.iddevice join marca on device.idMarca = marca.idmarca join categoria on device.idCategoria = categoria.idcategoria";
$date = mysqli_query($connessione,$sql);
while($prodotto = mysqli_fetch_assoc($date)){
echo '<url>
<loc>https://www.ripara.co/index.php?page=articolo&id='.$prodotto['idProdotto'].'&titolo='.str_replace(" ", "-", str_replace("&", "", str_replace("'", "", $prodotto['nomeCategoria']."-".$prodotto['nomeMarca']."-".$prodotto['modello']."-".$prodotto['nome']))).'</loc>
<lastmod>'.date("Y-m-d").'</lastmod>
<changefreq>weekly</changefreq>
<priority>0.8</priority>
</url>';
}
$sql = "SELECT * from prodottoinvendita where attivo=1";
$date = mysqli_query($connessione,$sql);
while($prodotto = mysqli_fetch_assoc($date)){
echo '<url>
<loc>https://www.ripara.co/index.php?page=prodottovendita&id='.$prodotto['idprodotto'].'</loc>
<lastmod>'.date("Y-m-d").'</lastmod>
<changefreq>weekly</changefreq>
<priority>0.8</priority>
</url>';
}
?>
<url>
<loc>https://www.ripara.co/</loc>
</url>
<url>
<loc>https://www.ripara.co/index.php</loc>
</url>
<url>
<loc>https://www.ripara.co/index.php?page=contatti</loc>
</url>
<url>
<loc>https://www.ripara.co/index.php?page=stato</loc>
</url>
<url>
<loc>https://www.ripara.co/index.php?page=ripara</loc>
</url>
<url>
<loc>https://www.ripara.co/index.php?page=shop</loc>
</url>
<url>
<loc>https://www.ripara.co/index.php?page=blog</loc>
</url>
<url>
<loc>https://www.ripara.co/index.php?page=chisiamo</loc>
</url>
<url>
<loc>https://www.ripara.co/index.php?page=bloglavori</loc>
</url>
<url>
<loc>https://www.ripara.co/index.php?page=negozi</loc>
</url>
<url>
<loc>https://www.ripara.co/index.php?page=blog&idcat=4</loc>
</url>
<url>
<loc>https://www.ripara.co/Ripara%20Brochure.pdf</loc>
<lastmod>2016-10-09T22:23:34+00:00</lastmod>
</url>
</urlset>