[ABD] Google sitemap mod

[jhaskins]

This is a simple little mod to generate a listing of your forum's topics in Google's sitemap xml format (anyone not familiar with this should see http://www.google.com/webmasters/sitemaps/docs/en/faq.html).

Note: this just generates the sitemap, it doesn't submit it. That must be done manually.

download here

Suggestions/comments/constructive criticism always welcomed.

[mighty b]

this is just what i have been looking for. Thanks!

Il give it a try and post my results

[Uchiha Nick]

could you give us a explanation of how it works? ive read it on google, dont really understand it tho oO

[Jugulator]

In http://patch/forum/sitemap.php appear only

Code: Select all

<urlset>
-
   <url>
<loc>http://patch/forum</loc>
<lastmod/>
<changefreq>always</changefreq>
</url>
</urlset>

It is not display any link!

[jozomannen]

It's not working for me either, same as yours Jugulator.

[ewelin]

try this one then

http://www.phpbbstyles.com/viewtopic.php?p=38305#38305

[jhaskins]

Sorry I wasn't able to get to this sooner. After checking over the files, I realized that part of the problem was that I included the wrong template file. I've updated the file on my site with the right one.

Before you use this, you will have to open "sitemap.php" and set $forumids to the forums you want included. I've also fixed one minor issue that turned up & updated the instructions to include a list of the variables that control various config options & what each one is for.

Finally, I've addded a couple new features:
*Set priority for announcements & sticky topics (each can be set seprately)
*Locked topics have <changefreq> set to never (who's gonna reply if it's locked?)

download link

demo

[tomythius]

I love this mod!
And there I was messing around in the shell with python...
Godsend, well done!
All I'd like to see (and these are suggestions, not demands!) would be a gzip option, and the option to sort by most recent. I tried changing the SQL to do the latter, but got in a tangle .
Good luck with this.

PS How would I set this as a cron job? I've never needed one before...

[khisanthax]

can I run this script using a cron job??

[MHobbit]

can I run this script using a cron job??

Why would you want to? It doesn't automatically submit your sitemap to Google. Also, it doesn't create static XML files AFAIK.

[tomythius]

Why would you want to? It doesn't automatically submit your sitemap to Google. Also, it doesn't create static XML files AFAIK.

Thanks MennoniteHobbit, was having a moment...
I think google auto-retrieves it regularly once submitted as well, doesn't it?

[jhaskins]

Regarding compression: I've added compression to the sitemap for my forums using ob_gzhandler & I'm waiting for google to reindex it to see if they send the header needed to trigger it.

Regarding auto submission/cron jobs: If you want to resubmit your sitemap on a regular basis or don't wan't to manually submit it for some reason, you can use the script below:

Code: Select all

<?php
//based heavily on the fsockopen() example from php.net
$sitemap="http://www.yoursite.com/forums/sitemap.php";
$fp = fsockopen("www.google.com", 80, $errno, $errstr, 30);
if (!$fp) {
   echo "$errstr ($errno)<br />\n";
} else {
   $out = "GET /webmasters/sitemaps/ping?sitemap=".urlencode($sitemap)." HTTP/1.1\r\n";
   $out .= "Host: www.google.com\r\n";
   $out .= "Connection: Close\r\n\r\n";

   fwrite($fp, $out);
   while (!feof($fp)) {
       $response .= fgets($fp, 128);
   }
   fclose($fp);
   if(preg_match("/200\sOK/", $response))
         {
      print "Sitemap submitted sucessfully.";
      }
   else
      {
      print "Problem submitting sitemap: \n $response";
      }
}
?>

Note that you should set $sitemap to the full url to your sitemap.php file.

Regarding sort by most recent: This could get ugly . The way I coded this, it gets the topics in groups to keep large boards from causing load problems. Unfortunatly, I didn't give much thought to sorting when I came up with this . I'll see what I can come up with & post back when I have something.

[ridinhighspeeds]

Great work with this mod!!

Heres a demo from my site.

[tomythius]

Mine now sits in the folder above my phpbb root, in the real root of my whole site.
A few hardcoded lines in the template means that my static pages are included in the same map.
DEMO

[ridinhighspeeds]

Only one problem with mine...Google rejected it because of the dates. Heres an example of mine with the date. Anyway to fix this??

<url>
<loc>http://defendingthetruth.com/viewtopic.php?t=3</loc>
<lastmod>2005-05-06T02:25:10-07:00</lastmod>
<changefreq>always</changefreq>
<priority>0.5</priority>
</url>

I think Google wants it like this

Example: 2005-05-06T02:25:10+08:00

http://www.google.com/schemas/sitemap/0.84/sitemap.xsd