Google Sitemap v2.7

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.

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,

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

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

Quote:

---

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?

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

Quote:

---

Originally Posted by carefree2

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.

Quote:

---

Originally Posted by RAMMSTEIN

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.

Code:

---

<?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

Quote:

---

Originally Posted by grynmoors

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

Quote:

---

Originally Posted by lenco12

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.

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?

The issue is that the sitemaps on this forum are no longer acceptable for Google Video. About 2 years ago, Google changed the requirements for video sitemaps and no one has bothered to update the code to match the new requirements.

I'm not sure that's it - I had a google- video sitemap up for over a year before the new vshare version, and the same situation existed.

And even so, you'd think that the page itself even without the video should show up in the index, due to title and descriptive text. Not to mention that Vshare is very SEO friendly.

Unfortunately, no, that is not true. Google only indexes further into the page based upon PageRank. If the pagerank of the site is low, then Google will only index a few pages. The purpose of a video site map is only to provide sites like Google with your site's meta data. It doesn't mean that Google will choose to index each page. The original intent of how Google implemented video sitemaps was for the Google Video service. Since Google has gotten rid of that service they did around 2006-2007 (it was replaced with YouTube), the only real point to it now is for meta data.

Not sure I agree. Google has no way of knowing from the non-video sitemap that this is a video site. Without a video sitemap, all it's got to go by is the text on the pages. Page ranking doesn't affect indexing, only what's displayed in a search. I have sites with a zero page ranking that have most of their pages indexed.

Actually, that's not true. Google very much knows that the site is a video site without a sitemap. It is able to do that based on object codes. What happens is that when Google scans the sites, it is able to detect the video codes and the links to the FLVs (for those people who do not hide it). It then knows that the site is a video site. The video sitemap helps provide Google with the meta data for each page and each video.

Pagerank very much affects indexing. It doesn't effect the process of indexing, itself. What it does is it affects what gets and stays indexed. Since a portion of the pagerank formula is relevance, a site that contains content deemed not as relevant by Google may find itself removed from the index. This is very much true for sites in which its only content is video (which is why video sites are hard to SEO). While your site may provide meta data, the real content isn't text, it's video. So, Google has to determine how popular a video is based upon direct links into that video. If it finds that people are directly going to a page, it may or may not keep the site indexed. It isn't until the page's rank increases in that it has a better shot of being included in the index. This is also why sites with zero ranking have more of their site index than pages with ranks between 1-5. It's because Google has done it's analysis and retains what is relevant to what people are looking at with regards to your site. With sites with zero ranking, it doesn't know this yet.

No one said anything about non-video sitemaps so I do not know what you are talking about there.

non-video sitemap = standard sitemap. The one on my site, copied from here, is not a video sitemap.

You must either have two heads or a huge brain, to retain all the information you share :)

Appreciate your time and input, always.

Actually, I just found one of my videos listed in a Google search.... so apparently Google does index these sitemaps.

Quote:

---

Originally Posted by carefree2

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

---

Yeah, the inlude works but I think the DB stuff needs to be this:

$sql = "Select video_id, video_title, video_description, video_add_date, video_flv_name, video_length from videos where video_approve=1 and video_active=1";