Google Sitemap v2.7 Updated
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
This is the one that worked for me
Quote:
Originally Posted by
grynmoors
Oh good! I couldn't get carefree's code to work with 2.7 so I took RAMMSTEINS code, which looks like this and it works for me in 2.7:
Code:
<?php
header("content-type:text/xml;charset=utf-8");
require 'include/config.php';
$url = VSHARE_URL;
echo "<?xml version='1.0' encoding='iso-8859-1'?>";
echo "<urlset xmlns='http://www.sitemaps.org/schemas/sitemap/0.9' xmlns:video='http://www.google.com/schemas/sitemap-video/1.0'>";
# 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)) {
srand ((double) microtime( )*1000000);
$random_number = rand(6,7);
$SefUrl=strtolower(preg_replace("/[^a-zA-Z0-9]+/","_", $info[1]));
echo "<url><loc>$url/channel/".$info[0]."/".$info[1]."/</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)) {
srand ((double) microtime( )*1000000);
$random_number = rand(4,6);
$SefUrl=strtolower(preg_replace("/[^a-zA-Z0-9]+/","-", $info[1]));
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)) {
srand ((double) microtime( )*1000000);
$random_number = rand(1,4);
$SefUrl=strtolower(preg_replace("/[^a-zA-Z0-9]+/","_", $info[1]));
echo "<url><loc>$url/tag/".$info[0]."/</loc>";
echo "<changefreq>monthly</changefreq>";
echo "<priority>0.$random_number</priority>";
echo "</url>";
}
mysql_close($conn);
echo "</urlset>";
?>
The only thing I had to do to my site was remove the ampersand (&) from my channel titles in vShare which caused the same problem as it did with 2.6. I'm weeding thru this to see what I did last time to fix it, but for now I just took that out of my channel titles in vShare admin panel.
This one worked for me on 2.7 don't remember whos it is but it works fine google visits every day :rolleyes:
PHP Code:
<?php
echo "<?xml version='1.0' encoding='iso-8859-1'?>";
echo "<urlset xmlns=\"http://www.sitemaps.org/schemas/sitemap/0.9\">";
// hostname on which MySQL is (usally localhost)
$dbhost = "localhost";
// Database name
$dbname = "your database";
// Username
$dbuser = "Database username";
// Password
$dbpass = "Database password";
// mysql_connect() fnction
$conn = mysql_connect($dbhost,$dbuser,$dbpass)
or die("Unable to connect to MySQL.");
// mysql_select_db() function
mysql_select_db($dbname,$conn)
or die("Unable to connect to Database $dbname");
$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";
// execute SQL Command
$res = mysql_query($sql,$conn)
or die( "Error: " . mysql_error() );
// Retrieve Results
while ($info = mysql_fetch_row($res)) {
$SefUrl=strtolower(preg_replace("/[^a-zA-Z0-9]+/","_", $info[1]));
echo "<url><loc>http://www.viewmyvids.com/video/".$info[0]."/".$SefUrl."/</loc></url>";
}
echo "</urlset>";
// mysql_close() function
mysql_close($conn);
?>
