Google Sitemap
Posted: Thu 29. Dec 2005, 11:25
Implemented in Version phpwcms 1.2.8
phpwcms Support Forum
The phpwcms support forum will help to find answers to your questions. The small but strong community is here since more than 10 years.
https://forum.phpwcms.org/
Google Sitemap
Page 1 of 2
Posted: Thu 29. Dec 2005, 11:50
a demo, please?
Posted: Thu 29. Dec 2005, 17:53
hi markoehl,
nice work ! works with phpwcms 1.2.6 ( 14.12.05 )
don't forget chmod 666 to sitemap.xml ...
squidi
nice work ! works with phpwcms 1.2.6 ( 14.12.05 )
don't forget chmod 666 to sitemap.xml ...squidi
Posted: Tue 3. Jan 2006, 23:45
This doesnt support re-written urls?
Sitemaps
Posted: Wed 4. Jan 2006, 10:50
Hi Folks,
if i use thise sitemap hack and i transer it to google, google says.
this format is not supported
Any ideas ?
if i use thise sitemap hack and i transer it to google, google says.
this format is not supported
Any ideas ?
Re: Sitemaps
Posted: Wed 4. Jan 2006, 10:59
Can you post the link of the sitemap.xml file?Buletti wrote:Hi Folks,
if i use thise sitemap hack and i transer it to google, google says.
this format is not supported
Any ideas ?
Or checkout new version Get the new Files http://www.pagewerkstatt.ch/phpwcms_mod_sitemap.zip
Posted: Wed 4. Jan 2006, 11:02
As much I know rewritten urls works only for the structure. This scrpt is reading the content from phpwcms_article.. But I will have a closer look at that..Glovebox wrote:This doesnt support re-written urls?
Posted: Wed 4. Jan 2006, 23:07
two suggestions:
1. in googleSitemap.inc.php on line 62 after
i would replace
with
this will format your sitemap in a nice way.
2. in article.editcontent.inc.php on line 33 i would add at the end of the sql-statement
so it saves only active and public articles and articles that are marked for the phpwcms-sitemap-module.
the correct line would be
1. in googleSitemap.inc.php on line 62 after
Code: Select all
function generateSitemap()
{
Code: Select all
$strSitemap = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";
$strSitemap .= "<urlset xmlns=\"http://www.google.com/schemas/sitemap/0.84\">\n";
Code: Select all
$strSitemap = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";
$strSitemap .= "<?xml-stylesheet type=\"text/xsl\" href=\"gss.xsl\"?>\n";
$strSitemap .= "<urlset xmlns=\"http://www.google.com/schemas/sitemap/0.84\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:schemaLocation=\"http://www.google.com/schemas/sitemap/0.84 http://www.google.com/schemas/sitemap/0.84/sitemap.xsd\">\n";
2. in article.editcontent.inc.php on line 33 i would add at the end of the sql-statement
Code: Select all
WHERE article_public=1 AND article_aktiv=1 AND article_nositemap=1
the correct line would be
Code: Select all
$sql = "SELECT article_id, article_cid, date_format(article_tstamp, '%Y-%m-%d %H:%i:%s') AS article_date FROM ".DB_PREPEND."phpwcms_article WHERE article_public=1 AND article_aktiv=1 AND article_nositemap=1;";
Update google sitemap
Posted: Thu 5. Jan 2006, 00:02
Thanx Mate
great feedback. I implemented this new code and added also the gss files. Looks much better now!!
Get the new Files http://www.pagewerkstatt.ch/phpwcms_mod_sitemap.zip
great feedback. I implemented this new code and added also the gss files. Looks much better now!!
Get the new Files http://www.pagewerkstatt.ch/phpwcms_mod_sitemap.zip
Posted: Thu 5. Jan 2006, 16:38
Thanks, please let us know.markoehl wrote:As much I know rewritten urls works only for the structure. This scrpt is reading the content from phpwcms_article.. But I will have a closer look at that..Glovebox wrote:This doesnt support re-written urls?
Posted: Sat 14. Jan 2006, 13:27
hi,
problem with a local installation ( xampplite - XJ! )
squidi
problem with a local installation ( xampplite - XJ! )
Code: Select all
Fatal error: URL http://localhost:8888/phpwcms/ not valid. Must be http[s]://[some.]domain.ext/ in C:\xampplite\htdocs\phpwcms\include\inc_lib\googleSitemap.inc.php on line 24Posted: Sat 14. Jan 2006, 13:40
To test with a local installation you have do replace codesquidi wrote:hi,
problem with a local installation ( xampplite - XJ! )
squidiCode: Select all
Fatal error: URL http://localhost:8888/phpwcms/ not valid. Must be http[s]://[some.]domain.ext/ in C:\xampplite\htdocs\phpwcms\include\inc_lib\googleSitemap.inc.php on line 24
if (!preg_match("/^https?:\/\/[a-z]([a-z0-9-.]+)+?.[a-z]+\/$/i", $strBaseURL))
{
trigger_error("URL {$strBaseURL} not valid. Must be http://[some.]domain.ext/", E_USER_ERROR);
}
else
{
$this->strBaseURL = $strBaseURL;
}
with
$this->strBaseURL = $strBaseURL;
Regards
Posted: Tue 14. Mar 2006, 10:53
@arkon
I added
in article.editcontent.inc.php on line 33 to avoid listing deleted articles in the sitemap
volkman
I added
Code: Select all
AND article_deleted=0volkman
Posted: Tue 14. Mar 2006, 11:19
Thanx. I modified the script too....volkman wrote:@arkon
I addedin article.editcontent.inc.php on line 33 to avoid listing deleted articles in the sitemapCode: Select all
AND article_deleted=0
volkman
Alias ind sitemapfile
Posted: Tue 14. Mar 2006, 12:58
I wanted the aliasname in the sitemapfile instead of /index.php?id=92,0,26,0....
So i modified the SQL-Statement in article.editcontent.inc.php. I am selecting fields from two tables (phpwcms_article and phpwcms_articlecat). If article_cid (from phpwcms_article) and acat_id (from phpwcms_articlecat) are the same fetch the acat_alias, thats it.
We only need $row[1] (the alias) and $row[3] (date of modification).
After editing the file the map looks like this:
Hope that helps,
volkman
So i modified the SQL-Statement in article.editcontent.inc.php. I am selecting fields from two tables (phpwcms_article and phpwcms_articlecat). If article_cid (from phpwcms_article) and acat_id (from phpwcms_articlecat) are the same fetch the acat_alias, thats it.
Code: Select all
$sql = "SELECT acat_id, acat_alias, article_cid, date_format(article_tstamp, '%Y-%m-%d %H:%i:%s') AS article_date ";
$sql .= "FROM ".DB_PREPEND."phpwcms_articlecat, phpwcms_article WHERE (acat_id = article_cid) AND article_public=1 AND article_aktiv=1 AND article_nositemap=1 AND article_deleted=0;";
if($result = mysql_query($sql, $db)) {
while($row = mysql_fetch_row($result)) {
$oSitemap->addEntry(
array('loc' => 'index.php?'.$row[1].'',
'lastmod' => $row[3],
'changefreq' => 'monthly',
'priority' => '0.8'));
}
mysql_free_result($result);
}
After editing the file the map looks like this:
Code: Select all
<loc>http://www.yourdomain.de/index.php?sitemap</loc>
<lastmod>2006-03-05T18:15:30+00:00</lastmod>
<changefreq>monthly</changefreq>
<priority>0.8</priority>
</url>
<url>
<loc>http://www.yourdomain.de/index.php?kompetenznetz</loc>
<lastmod>2006-03-14T10:07:21+00:00</lastmod>
<changefreq>monthly</changefreq>
<priority>0.8</priority>
</url>
<url>
<loc>http://www.yourdomain.de/index.php?patient</loc>
<lastmod>2006-03-05T16:33:36+00:00</lastmod>
<changefreq>monthly</changefreq>
<priority>0.8</priority>
</url>
volkman