[module] Google sitemap.xml Generator

[freeSbee]

Hi

Google reports an ERROR running WB on ISO-8859-1 (or others than utf-8) within the html commented page title lines. If the title contains an eg. umlaut the XML sitemap will not validate.
So I decided to remove the feature as it is not really needed.

Second I added a module auto dedection. This way users can add or delete modules without bothering about google_sitemap configuration.

I attached a new version v1.3 of the google_sitemap.

Christoph

[freeSbee]

Hi

New Version of Google Sitemap:

 - Replaced the hardcoded page directory name /pages by the wb constant PAGES_DIRECTORY
 - Added feature to hide page urls which contain unwanted words (eg. for web pages which are blocked by robots.txt)

Find google_sitemap v1.4 attached to this post.

Christoph

[alexander1951]

Hi to all,
thanks to all the modul authors for this fine sitemap modul. I copied the google_sitemap.php to my wb-root and it works sufficiently.

Now I do not only want to submit it to GOOGLE, but i also want to present the output on my website as a "Sitemap"-page. Has anybody an idea, how to customize the output of the google_sitemap.php, so that I can use it on my site as a navigation page? Do I need to use another script, that can work with the output or can I customize it with CSS-styles? Has anybody an example for that?

I hope my questions fit this thread and look forward for an idea-giving answer. Thanks.

Alexander

[freeSbee]

Hi Alexander

Please have a look at the WB module page where you find all completed modules as well as a listing not being exhaustive with unofficial and unsupported modules.
Try the sitemap module or read about the ShowMenu2.

Regards Christoph

[alexander1951]

Hello Christoph [freeSbee],

thanks a lot for that hint! Of course I know the repository, but obviously I failed in recognizing the >sitemap modul<. My mistake. I loaded it now and will try it out asap. Additionally I was not aware of the fact that I can realize a sitemap with the show_menu2 modul. Thanks again!

Alexander

[Vincent]

Hi all,

do I understand correctly that the name of this thread doesn't reflect the output (a sitemap.xml file)anymore? That the root of this thread is actually the post by vuilian on the second page?  That we don't need to install any module anymore, and just upload the latest version of google_sitemap.php? I was a little confused, since I had Google look for the sitemap.xml file, which was also on the server (output of the original module).

Anyway, I now changed it, but maybe one of the moderators could clean the thread a little in order to avoid confusion (I guess I'm not the only one...)

Regards,

Vincent

[viulian]

Well, it used to be on the first page, and it started a long time ago

Things have evolved, but back then, a module was needed to be able to run from a view. And it was a convenient way to 'view' the module page, which just triggered the writing the sitemap.xml file.

Probably now you can call it directly - I have yet to upgrade to the latest version of wb and try out the new module.

[Ruud]

Probably now you can call it directly - I have yet to upgrade to the latest version of wb and try out the new module.

Thats right, you can just add the "google_sitemap.php" in the webmaster tools page on Google (or any other searchengine that supports the format).

There is no installation, just ftp the google_sitemap.php file found in the .zip archive to the root of your website (where config.php is found).
Call the page with your browser once to see if it is working and you're done.

Ruud

[Vincent]

Thanks for your reply, Ruud.

Vincent

[nuke]

The google_sitemap_v1.4 has worked great for me - but since upgrading to V2.7 I've noticed in my google webmaster tools sitemap section I now have warnings:

URLs not followed
When we tested a sample of the URLs from your Sitemap, we found that some URLs were not accessible to Googlebot because they contained too many redirects. Please change the URLs in your Sitemap that redirect and replace them with the destination URL (the redirect target). All valid URLs will still be submitted.

And the warning are for Menu Links, that link to other pages on my site... is this something other people are experiencing? Would it  be possible to not include menu links (no content) in the sitemap?

Thanks for any help.
-Mike

[zarathustra.at]

I've had this warning once and checked back a few days laters Google - now the warning is gone.

Can anyone explain this behaviour?

[crnogorac081]

I uploaded this php file and when i opent this file it shows me sitemap as xml file... Do I have to save that output as xml file and then to upload it to google, or I can just point google to this sitemap.php file ?

[ruebenwurzel]

Hello,

or I can just point google to this sitemap.php file

Yes, this is all you need to do. Simply tell google to use google_sitemap.php as sitemap.xml.

Matthias

[mike]

Hello,

first another answer to

or I can just point google to this sitemap.php file ?

You can point every searchengine to the sitemap.php.
http://www.sitemaps.org/protocol.php#informing

Specifying the Sitemap location in your robots.txt file
You can specify the location of the Sitemap using a robots.txt file. To do this, simply add the following line:
Sitemap: <sitemap_location>
The <sitemap_location> should be the complete URL to the Sitemap, such as: http://www.example.com/sitemap.xml

And a "bugfix" to the script himself:

The "first page", which is displayed as the home or root page ("/") is not included with this URL. It is included with /pages/...php 
This produce internal duplicate content.

I change the line for the <loc> into the following:

Code:

   <loc><?php if (($page['parent'] == 0) AND ($page['position'] == 1)) {  
                 echo WB_URL . '/';
            } else {
              echo htmlspecialchars($wb->page_link($page['link']));
            }  ?></loc>

Maybe you can implement this in the next version of your script?

Ciao,
Mike

(from Germany, so sorry for my English)

[Ruud]

Mike,

This makes sence (homepage url).
I added it to the google_sitemap.php (coded a little bit different).

Attached to this post (version 1.5) and updated in the AMASP site.

Thanks,
Ruud

[albatros]

Hi,

thanks a lot to mike an Ruud!!!

Best Regards

Uwe

[tiesy]

Hi,

the Google sitemap.xml Generator is a great tool, very helpful. What I need is an extra Google-News-Sitemap for my News-Pages, because they are listed on Google-News. Width a News-Sitemap, all the News could by found much better and faster by Google-News.

My question: Is it possible to modify the sitemap-generator to automatically generate an special Google News-Sitemap? I´m not a coder and not shure, what to do.

For more information about Google-News-Sitemaps have a look here:
http://www.google.com/support/news_pub/bin/answer.py?hl=en&answer=74288

Thanks

[Xagone]

The sitemap is realy great! love it, found a little bug

google tools ( https://www.google.com/webmasters/tools/ ) warm me :
-     URLs not followed

the link he warned was a "Menu Link" that linked outside the domain name. so i'll check the code so an outside link (redirect) will not show...

[Xagone]

found it...

line 92 call to // Pages

Code:

// Pages
$sql = "SELECT link,modified_when,parent,position FROM " . TABLE_PREFIX . "pages WHERE visibility = 'public' ORDER BY position ASC";
$rs = $database->query($sql);

switch to :

Code:

// Pages
if (mysql_query("SELECT 1 FROM `" . TABLE_PREFIX . "mod_menu_link` LIMIT 0")) {
    $sql = "SELECT `link`, `modified_when`, `parent`, `position` FROM `" . TABLE_PREFIX . "pages` WHERE `visibility` = 'public' AND `page_id` != (SELECT `page_id` FROM `" . TABLE_PREFIX . "mod_menu_link` WHERE `target_page_id` = '-1') ORDER BY `position` ASC";
} else {
    $sql = "SELECT `link`, `modified_when`, `parent`, `position` FROM `" . TABLE_PREFIX . "pages` WHERE `visibility` = 'public' ORDER BY `position` ASC";
}
$rs = $database->query($sql);

[Mte90]

it's possible to update this script with this bugfix?

[Xagone]

I thought they had.. so here 1.5.1 (i added .1 to be sure, it's the code from websitebakers.com)

[Xagone]

added portfolio module application, so i've saved it as 1.5.2...

[gioweb]

Hello, the pages of the gocart mod, are not detected by the google_sitemap mod.
How can I detect pages gocart? 

 

[gila]

hi im using thi module but i have some problems, using the 1.5 version google webmaster tool gave me an error sitemap

usinge the 1.5.2 version the maps is empty so i add some comment:

Code:

/*if (mysql_query("SELECT 1 FROM `" . TABLE_PREFIX . "mod_menu_link` LIMIT 0")) {
    $sql = "SELECT `link`, `modified_when`, `parent`, `position` FROM `" . TABLE_PREFIX . "pages` WHERE `visibility` = 'public' AND `page_id` != (SELECT `page_id` FROM `" . TABLE_PREFIX . "mod_menu_link` WHERE `target_page_id` = '-1') ORDER BY `position` ASC";
} else {
*/    $sql = "SELECT `link`, `modified_when`, `parent`, `position` FROM `" . TABLE_PREFIX . "pages` WHERE `visibility` = 'public' ORDER BY `position` ASC";
//}
$rs = $database->query($sql);

and now the maps works but google tell me that the site map is not well formatted...

i have a site with an intro page http://www.xxx.com/pages/intro.php
and also two language, so there is for example the page  http://http://www.xxx.com/pages/english/home.php
that redirect to http://www.xxx.com/pages/english/home.php

may be this is the problem?

thanks

[SickBoy75]

I simply don't know how to use this php.

I put the file google_sitemap.php in my root dir.
Then, I can see the output by going to the url www.myweb/google_sitemap.php

So, now what should I do??

This script don't generate the file sitemap.xml. does it??
It won't send the file to google neither

If I'm wrong, please show mo how to do it, thanks

Also, i have to coment this line

Code:

// $bakery['link'] = preg_replace('/^\\'.PAGES_DIRECTORY.'/', '', $bakery['link'], 1);

without commenting, all my bakery items url are www.myweb.com.php
It's maybe because i change a few things in bakery (like the dir for the items), i'm not sure if thats the problem