|
|
read()) { if (ereg('.php$',$entrye)) { $ptitle = implode ('', file ($site_base."$basesp/$entrye")); if (eregi ("", $ptitle, $tits)) {$lastchange = date ("Y-m-d", filemtime($entrye)); $xmltoprint .= " - http://www.greatlocaldeals.co.uk/".$entrye." ".$lastchange." monthly 0.5 "; $pages .= "
".$entrye."
"; }}}$sql = "SELECT * FROM `adverts` WHERE `activeuntil` > ".$current_time." AND `offer_expiry` > ".$current_time." AND `active` = '1' AND `disabled` = '0'"; $result_adverts = mysql_query($sql); $no_adverts = @mysql_num_rows($result_adverts); while ($record_adverts = mysql_fetch_array($result_adverts)) { $lastchange = $record_adverts['lastchange']; $lastchange = substr("$lastchange",0,10); $xmltoprint .= " - http://www.greatlocaldeals.co.uk/adverts.php?adverts_id=".$record_adverts['adverts_id']." ".$lastchange." monthly 0.7 "; $adverts .= "
".$record_adverts['advertstitle']."
"; } $query_categories="SELECT * FROM categories ORDER BY categoriesname ASC"; $result_categories=mysql_query($query_categories); while($record_categories=mysql_fetch_array($result_categories)){ //print $record_categories['categories_id']." "; $lastchange = $record_categories['lastchange']; $lastchange = substr("$lastchange",0,10); $xmltoprint .= " - http://www.greatlocaldeals.co.uk/adverts.php?categories_id=".$record_categories['categories_id']." ".$lastchange." monthly 0.6 "; $categories .= "
".$record_categories['categoriesname'].""; } $fh3 = fopen($base."sitemap2.xml",'w'); fwrite($fh3, ' '.$xmltoprint.''); fclose($fh3) or die('3'); # print "All Our Pages$pages"; # print "All Our Categories$categories"; print "All Our Adverts
$adverts"; ?> |
About