[ABD] Google sitemap mod

[kjcdude]

I installed this mod on two phpBB sites and it works great!

Now I'm wondering if anyone knows of a similar mod that would scan a non-phpBB site. Any suggestions would be greatly appreciated!

Google offers you a Sitemap Generator
https://www.google.com/webmasters/sitem ... rator.html

[kjcdude]

For some reason on my sitemap today i got an invalid date error from google.

Mine and googles recomended date

2005-08-08T11:34:29+00:00
2004-10-26T08:56:39+00:00

There in the exact same format...

I resubmited my sitemap to google, hopefully i dont get an error this time.

http://theocsucks.com/sitemap.php
-Kyle

Sumited again AND STILL GETTING THE ERROR.

Sitemap Errors

1. Invalid date
* An invalid date was found. Please see How do I specify time? for more information before resubmitting.

[beggers]

I installed this mod on two phpBB sites and it works great!

Now I'm wondering if anyone knows of a similar mod that would scan a non-phpBB site. Any suggestions would be greatly appreciated!

Google offers you a Sitemap Generator
https://www.google.com/webmasters/sitem ... rator.html

Thanks, but I'm not a rocket scientist. That has to be the most unfriendly application ever. It has about ten pages of instructions. I need a "plug-n-map" solution.

[kjcdude]

I installed this mod on two phpBB sites and it works great!

Now I'm wondering if anyone knows of a similar mod that would scan a non-phpBB site. Any suggestions would be greatly appreciated!

Google offers you a Sitemap Generator
https://www.google.com/webmasters/sitem ... rator.html

Thanks, but I'm not a rocket scientist. That has to be the most unfriendly application ever. It has about ten pages of instructions. I need a "plug-n-map" solution.

I havent ever used it so i wouldnt know
after a quick search i found this
http://www.auditmypc.com/free-sitemap-generator.asp

[kjcdude]

For some reason on my sitemap today i got an invalid date error from google.

Mine and googles recomended date

2005-08-08T11:34:29+00:00
2004-10-26T08:56:39+00:00

There in the exact same format...

I resubmited my sitemap to google, hopefully i dont get an error this time.

http://theocsucks.com/sitemap.php
-Kyle

Sumited again AND STILL GETTING THE ERROR.

Sitemap Errors

1. Invalid date
* An invalid date was found. Please see How do I specify time? for more information before resubmitting.

can anyone take a look at my sitemap http://theocsucks.com/sitemap.php
and see why my dates are the same as googles and still getting denied.

Thanks,
Kyle

[kjcdude]

My .htaccess file is as follows.

Code: Select all

Options +FollowSymlinks

RewriteEngine On
#this may cause isues with subdirs and so I have not enabled it.
#RewriteBase /

RewriteRule [.]*-vf([0-9]*) viewforum.php?%{QUERY_STRING}&f=$1
RewriteRule [.]*-vp([0-9]*) viewtopic.php?%{QUERY_STRING}&p=$1
RewriteRule [.]*-vt([0-9]*) viewtopic.php?%{QUERY_STRING}&t=$1 

My urls look like
http://carcommons.com/general-car-maintenance-vf61.html for category
and
http://carcommons.com/more-biker-happy- ... t8684.html for post

For anyone that has the Google Keywords Mod or is using Mod Rewrite, add these lines to your sitemap.php page.

Around line 81 find

Code: Select all

$sql = "SELECT t.topic_id,

in line after add

Code: Select all

 t.topic_title,

find

Code: Select all

$template->assign_block_vars('topics', array(

above add

Code: Select all

		$topic['topic_title'] = strtolower(str_replace(array(' ','"','&','\r\n','\n','/','\\','+','<','>'), '-', $topic['topic_title']));
		$topic['topic_title'] = strtolower(str_replace(array('é','è','ë','ê','É','È','Ë','Ê'), 'e', $topic['topic_title']));
		$topic['topic_title'] = strtolower(str_replace(array('í','ì','î','ï','Í','Ì','Î','Ï'), 'i', $topic['topic_title']));
		$topic['topic_title'] = strtolower(str_replace(array('ó','ò','ô','Ó','Ò','Ô'), 'o', $topic['topic_title']));
		$topic['topic_title'] = strtolower(str_replace(array('ö','Ö'), 'oe', $topic['topic_title']));
		$topic['topic_title'] = strtolower(str_replace(array('á','à','â','Á','À','Â'), 'a', $topic['topic_title']));
		$topic['topic_title'] = strtolower(str_replace(array('ä','Ä'), 'ae', $topic['topic_title']));
		$topic['topic_title'] = strtolower(str_replace(array('ú','ù','û','Ú','Ù','Û'), 'u', $topic['topic_title']));
		$topic['topic_title'] = strtolower(str_replace(array('ü','Ü'), 'ue', $topic['topic_title']));
		$topic['topic_title'] = strtolower(str_replace(array('ß'), 'ss', $topic['topic_title']));
		$topic['topic_title'] = strtolower(str_replace(array('/[^a-z0-9\-<>]/','/[\-]+/','/<[^>]*>/'), '-', $topic['topic_title']));
		$topic['topic_title'] = strtolower(str_replace(array('--'), '-', $topic['topic_title']));
		$topic['topic_title'] = strtolower(str_replace(array('<b>','</b>','\'','?','!',',','.','/'), '', $topic['topic_title']));

Replace line

Code: Select all

'TOPIC_URL' => $server_url."viewtopic.$phpEx?t=" . $topic['topic_id'],

with

Code: Select all

'TOPIC_URL' => $server_url. stripslashes($topic['topic_title']) . '-' . 'vt' . $topic['topic_id'] . '.html',

-=NOTE=-
I am getting errors with the date output after this modification.
Referr to - http://www.phpbb.com/phpBB/viewtopic.ph ... 73#1710673
DEMO - http://theocsucks.com/sitemap.php

[kulinar]

can anyone take a look at my sitemap http://theocsucks.com/sitemap.php
and see why my dates are the same as googles and still getting denied.

Did you try applying sitemap mod without keywords mod (the original one)?

[kjcdude]

can anyone take a look at my sitemap http://theocsucks.com/sitemap.php
and see why my dates are the same as googles and still getting denied.

Did you try applying sitemap mod without keywords mod (the original one)?

Yes, the date and time are EXACTLY the same, as the one i posted above.
The only difference ive noticed after my modifciation is that there is a line between <loc> and the url on some urls.
I just checked google for the sitemap again and now im getting

Parsing error (Line 1491)
* We were unable to read your Sitemap. It may contain an entry we are unable to recognize.

[r_ekkie]

I saw the error before in this topic but no reply yet so I post mine as wel.

Error obtaining topic data

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near '' at line 1

SELECT t.topic_id, t.topic_type, t.topic_status, p.post_time FROM phpbb_topics AS t, phpbb_posts AS p WHERE t.topic_last_post_id=p.post_id AND t.forum_id IN (3,2,69,13,14,15,16,17,19,21,25,68,61,70) ORDER BY t.topic_id LIMIT

Line : 84
File : sitemap.php

What I think is strange that the error talks about phpbb_posts and phpbb_topics my databas prefix is mysite not phpbb.

what did I do wrong?

[webmedic]

for some reason for some people but not all the mod does not like some servers i guess. But the issue is the the very first line gets truncated to instead of saying <xml the < gets left off and this is what creates the error. Try adding an extra < in the template file right at the very top.

[r_ekkie]

nope doesn't solve the problem.

What I think is strange that he is talking about phpbb_topics and phpbb_posts. the tables doesn't have these names on my forum. doe I have to change there names some where to mysite_topics and mysite _posts?

thanks

[webmedic]

well i would say yes but a better question would be why is yours different?

[r_ekkie]

Yes thats my question as wel..

he is using the main config file I supose so if my board works this should work aswell..

can't I not just put the names of the tables in de code??

[webmedic]

yes you could hard code them if you want it wont hurt anything as always keep a backup of the file in case things get really messed up.

[megablastadmin]

whoa!!!!!

after reading all the pages

hehehheh
i found that download link for mod dont work

anyone can update it please ??

Thanks