Google Sitemap v2.7

[carefree2]

Yeah im still using version 2.6. Version 2.7 database is different

Change:

    $sql = "Select  VID, title, description, adddate, flvdoname, duration from video where approve=1 and active=1";

to

    $sql = "Select  * from videos where video_approve=1 and video_active=1";

[grynmoors]

Those of you using this for 2.7, just eliminate the database connection (you can also do this for 2.6) and use the sql that I posted (it's for 2.7)

[grynmoors]

Oh...gonna have to scratch it, it doesn't work for 2.7 at all and nothing was indexed by google. Here's what Google said:

Paths don't match
We've detected that you submitted your Sitemap using a URL path that doesn't include the www prefix (for instance, http://example.com/sitemap.xml). However, the URLs listed inside your Sitemap do use the www prefix (for instance, http://www.example.com/myfile.htm).

Parsing error
We were unable to read your Sitemap. It may contain an entry we are unable to recognize. Please validate your Sitemap before resubmitting.

Empty Sitemap
Your Sitemap does not contain any URLs. Please validate and resubmit your Sitemap.

Invalid XML tag
This tag was not recognized. Please fix it and resubmit. (this one is my fault, I'm going to fix it)

Leading whitespace
We've detected that your Sitemap file begins with whitespace. We've accepted the file, but you may want to remove the whitespace so that the file adheres to the XML standard.


I'm gonna fix the XML tag thing and resubmit, the only other issue is the www.

*IF* any one has problems with this, there is another post with a sitemap somewhere in the forums. I had been using it the entire time I had 2.6 so if this one posted by carefree doesn't work, try the other one. It works for him, it should work for you too but check for the other one.

[ikhebdexfactor]

So Ã*t don't work voor 2.7 at all pitty :S
what now?

[grynmoors]

Well, it is *probably* due to the error in my xml tag. I just took it out and am resubmitting to google....the only other problem after that is the www part (I hope).

[carefree2]

If you dont give up you wont fail.

[grynmoors]

If this doesn't pan out I'll find the original sitemap posted for 2.6 in the forums (hopefully it didn't get deleted for being old) and change the reference to the database to reflect the changes in 2.7 since that old one always worked for me in the past (for 2.6) and see what the difference is between that one and yours.

[housefull]

If you dont give up you wont fail.

f this doesn't pan out I'll find the original sitemap posted for 2.6 in the forums (hopefully it didn't get deleted for being old) and change the reference to the database to reflect the changes in 2.7 since that old one always worked for me in the past (for 2.6) and see what the difference is between that one and yours.

[Blain]

"Just copy this code and save it as sitemap.php at you vshare files."

What does, "You vshare files" mean? It is, of course, simply a flaw within your English here but unfortunately it does not specify enough where it should go. Does it need to be put in public_html, or does it need placement within public_html/templates, etc.

Thanks for the clarification.

[grynmoors]

put it in the same directory as your index.php