google sitemap

[Lhotch]

Here is a sitemap file you can point google at to take advantage of their sitemap service.

The only thing you will need to do to get this file to work is add your own time zone to the listing section which is lines 5- to 60 and looks like this.

PHP Code:

//now the listings
$sSQL = "SELECT id,dateadded FROM ".PREFIX."products WHERE expiration > NOW() AND display='Y'";
$result = mysql_query($sSQL) or print(mysql_error());
while($rs=mysql_fetch_array($result)){
    if($modrewrite=="Y"){
        echo "<url>\n<loc>".$url."/view/".urlencode($rs['id'])."</loc>\n<lastmod>".str_replace(" ","T",$rs['dateadded'])."-06:00</lastmod>\n<changefreq>monthly</changefreq>\n<priority>.5</priority>\n</url>\n";    
    }else{
        echo "<url>\n<loc>".$url."/viewlisting.php?view=".urlencode($rs['id'])."</loc>\n<lastmod>".str_replace(" ","T",$rs['dateadded'])."-06:00</lastmod>\n<changefreq>monthly</changefreq>\n<priority>.5</priority>\n</url>\n";
    }
}
mysql_free_result($result); 


there are 2 spots above, just after $rs['dateadded'] where I have -06:00 this is my timezone, you can change it to your own if desired or it will work fine with mine as well.

[civ]

Thanks Larry, just what I was looking for.

[civ]

Can anyone confirm that this still works on a 3.1 installation?

[Lhotch]

Originally Posted by civ

Can anyone confirm that this still works on a 3.1 installation?

I was afraid this got lost in the crash, I will take a look at it and see what I can do to make it compatable with v3.1.x

[Lhotch]

Ok the sitemap in the 1st post seems to work fine with one minor change. At approx line 16 we have the following line....

require_once(FILESYSTEM_PATH .'includes/init.php');

change it to

require_once('includes/init.php');

[CB]

Larry, does google accept sitemaps with a php extention, I thought they only crawled .xml. I'm submitting this threw my google webmaster account, is that how you do it too? Also, www.classifords.com/sitemap.php whats up with that, is that you on the left haha

[Lhotch]

Originally Posted by CB

Larry, does google accept sitemaps with a php extention, I thought they only crawled .xml. I'm submitting this threw my google webmaster account, is that how you do it too? Also, www.classifords.com/sitemap.php whats up with that, is that you on the left haha

Yea, they will accept a file with a php exctension. The file name is irrelevent its what the spider sees that matters and in this case the sitemap builds xml.

My classifieds are in a subdire of the domain so it would be www.classifords.com/ads/sitemap.php, what your seeing above is just a test alternate 404 page not found error.

[calaf6]

Also, www.classifords.com/sitemap.php whats up with that, is that you on the left haha

Euk!!

And NO, its not me on the right

[CB]

Larry looks good, urls like: /ads/category.php?type=10 google won't accept, i've been trying and it rejects any url with a session id or dynamic ?type= I installed the SEO module, does this work with the SEO and does it pull the friendly url. Thanks Larry.

[juven14]

Thanks Larry, I'm using it too.