Google Sitemap v2.7

[grynmoors]

I think you might have to enable the mime type, I'm not sure...google the error message and see what you get. I'm not certain but I think you need to put the mime type in .htaccess. Check around. Nothing fishy about this, I've seen it before.

[Blain]

So if I leave it as is, still displaying this message, google should still be able to gather all of the required information for this function to be useful? Or do I need to correct the sitemap before it will be functional?

Any ideas?

--
Many thanks,

[grynmoors]

If it errors out, Google Site Map will indicate this in the web master tools by telling you there's an error.

[stazome]

i just check in robots.txt file followin lines..

User-agent: *
Disallow: /admin/
Sitemap: sitemap.xml

but we make sitemap.php for site so what you think we need to change sitemap.xml to sitemap.php?

[nitramf]

I had to insert my url manually, but now it works.

[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.

[clonevideos]

This is google sitemap for vshre 2.7

Include channels, videos and tags works only in v2.7

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

<?php
header("content-type:text/xml;charset=utf-8");
echo "<?xml version='1.0' encoding='UTF-8'?>";
require 'include/config.php';
$url = VSHARE_URL;
echo "
<urlset xmlns='http://www.google.com/schemas/sitemap/0.84'>
<url>
  <loc>$url/</loc>
    <priority>1.0</priority>
    <changefreq>hourly</changefreq>
  </url>
  <url>
    <loc>$url/recent/</loc>
    <priority>0.9</priority>
 
    <changefreq>daily</changefreq>
  </url>
  <url>
    <loc>$url/recent/2</loc>
    <priority>0.8</priority>
    <changefreq>daily</changefreq>
  </url>
 
  <url>
    <loc>$url/recent/3</loc>
    <priority>0.7</priority>
    <changefreq>daily</changefreq>
  </url>
  <url>
    <loc>$url/recent/4</loc>
 
    <priority>0.7</priority>
    <changefreq>daily</changefreq>
  </url>
  <url>
    <loc>$url/recent/5</loc>
    <priority>0.7</priority>
    <changefreq>daily</changefreq>
  </url>
  <url>
    <loc>$url/recent/6</loc>
    <priority>0.7</priority>
    <changefreq>daily</changefreq>
  </url>
  <url>
 
    <loc>$url/recent/7</loc>
    <priority>0.7</priority>
    <changefreq>daily</changefreq>
  </url>
  <url>
    <loc>$url/recent/8</loc>
    <priority>0.7</priority>
    <changefreq>daily</changefreq>
  </url>
  <url>
    <loc>$url/recent/9</loc>
    <priority>0.7</priority>
    <changefreq>daily</changefreq>
  </url>
  <url>
    <loc>$url/channels/</loc>
    <priority>0.9</priority>
    <changefreq>weekly</changefreq>
  </url>
  <url>
    <loc>$url/favorites/</loc>
    <priority>0.7</priority>
    <changefreq>daily</changefreq>
  </url>
  <url>
    <loc>$url/featured/</loc>
    <priority>0.8</priority>
    <changefreq>daily</changefreq>
  </url>
  <url>
    <loc>$url/random/</loc>
    <priority>0.7</priority>
    <changefreq>daily</changefreq>
  </url>
  <url>
    <loc>$url/rated/</loc>
    <priority>0.7</priority>
    <changefreq>daily</changefreq>
  </url>";
 
# channels
$sql = "SELECT channel_id, channel_name FROM `channels`
                ORDER BY `channel_sort_order` ASC";
$res = mysql_query($sql,$conn)
or die( "Error: " . mysql_error() );
while ($info = mysql_fetch_row($res)) {
$SefUrl=strtolower(preg_replace("/[^a-zA-Z0-9]+/","-", $info[1]));
srand ((double) microtime( )*1000000);
$random_number = rand(6,7);
 
echo "
<url>
<loc>$url/channel/".$info[0]."/".$SefUrl."/</loc>";
echo "
<changefreq>monthly</changefreq>";
echo "
<priority>0.$random_number</priority>";
echo "
</url>";
}
 
# videos
$sql = "SELECT video_id, video_title, video_add_date FROM `videos` WHERE
           `video_active`='1' AND
           `video_approve`='1' AND
           `video_type`='public'
            ORDER BY `video_id` DESC";
$res = mysql_query($sql,$conn)
or die( "Error: " . mysql_error() );
while ($info = mysql_fetch_row($res)) {
$SefUrl=strtolower(preg_replace("/[^a-zA-Z0-9]+/","-", $info[1]));
srand ((double) microtime( )*1000000);
$random_number = rand(4,6);
 
echo "
<url>
<loc>$url/view/".$info[0]."/".$SefUrl."/</loc>";
echo "
<lastmod>".$info[2]."</lastmod>
<changefreq>monthly</changefreq>";
echo "
<priority>0.$random_number</priority>";
echo "
</url>";
}
# tags
$sql = "SELECT tag FROM `tags` WHERE
           `active`='1' AND
           `tag_count` > 0
            ORDER BY `tag_count` DESC";
 
$res = mysql_query($sql,$conn)
or die( "Error: " . mysql_error() );
while ($info = mysql_fetch_row($res)) {
$SefUrl=strtolower(preg_replace("/[^a-zA-Z0-9]+/","-", $info[0]));
srand ((double) microtime( )*1000000);
$random_number = rand(1,4);
 
echo "
<url>
<loc>$url/tag/".$SefUrl."/</loc>";
echo "
<changefreq>monthly</changefreq>";
echo "
<priority>0.$random_number</priority>";
echo "
</url>";
}
 
mysql_close($conn);
echo "
</urlset>";
?>

UPDATED AND WORKING

I just uploaded this code to my vshare folder and try to check if it is working and found there is not xml links but giving me millions of codes with links and bla bla how to fix it? please help me. i tried like this http://www.clonevideos.com/sitemap.php

[lenco12]

Can't the db login stuff be eliminated by using the config include?

require 'include/config.php';

and instead of this echo "<url><loc>http://www.site.com/video/".$info[0]."/".$SefUrl."/</loc></url>";

put echo "<url><loc>{$base_url}/video/".$info[0]."/".$SefUrl."/</loc></url>";

or will that bork the whole thing....Imma go try it.

I made it as a stand alone script. But both ways are fine

[clonevideos]

I made it as a stand alone script. But both ways are fine

Do i need to edit the codes? or it is working? which file i have to edit now? please make it clear. i am still unable to make it work.

[mersh]

The sitemap works great:

http://thewall.net/sitemap.php

Kudos and thanks, RAMMSTEIN!

BUT.... apparently a sitemap on a vshare site doesn't do a thing for Google.

Google webmaster tools recognizes 4,283 links in my sitemap, and has indexed TWO. My guess is it's "thewall.net" and "thewall.net/index.php"


My site's been online since 1997, and I had a lot more pages in Google when I was doing nothing with the site. I've had vshare on it for three years now, and am yet to see one of my videos show up in Google.

Anyone know what the deal is with that? Does anyone have a different story?