Google Sitemap v2.7

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

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

[grynmoors]

SWEET! Thanks!

[bhanuprasad1981]

it shows error :-

XML Parsing Error: XML or text declaration not at start of entity

[mule]

Different error here:

The XML page cannot be displayed

Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later. The following tags were not closed: urlset. Error processing resource 'http://yourgasm.net/sitemap.php'.

[carefree2]

This works - save as sitemap.php

    <?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 = "";
    // Username
    $dbuser = "";
    // Password
    $dbpass = "";

    // 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  VID, title, description, adddate, flvdoname, duration from video where approve=1 and 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.site.com/video/".$info[0]."/".$SefUrl."/</loc></url>";
    
    } 
    echo "</urlset>";

    // mysql_close() function
    mysql_close($conn);
    ?>

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

[carefree2]

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

[grynmoors]

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";

[grynmoors]

I'm trying to automate this as much as I can so that I can just upload it to all my vshare sites without having to configure each one each time...the only thing I can't get to work is the {$base_url} part. Comes out looking weird

http:///6/using_satchel_and_claymore_in_ctf/http:///etc

[carefree2]

I'm trying to automate this as much as I can so that I can just upload it to all my vshare sites without having to configure each one each time...the only thing I can't get to work is the {$base_url} part. Comes out looking weird

http:///6/using_satchel_and_claymore_in_ctf/http:///etc

Keep in mind its still xml format even though it has php extension

$config['baseurl']