[ Video Sharing CMS v4 ] Sitemap for 3.6

identicalmedia · 13 October, 2014

WORK FINE NOW

thanks very much

krejcis · 13 October, 2014

Hi Mario,
I made change of htaccess which recommended Ownbond and it seems to work fine. I have in sitemap only URL of videos to my site is ist correct? I thought there should be also tags and description for each video right?
I so...how to modify? But I am happy that sitemap passed on the google webmaster tool.:-)

check it here please:
http://goprotube.com/sitemap_1.xml
.thanks guys...

krejcis · 13 October, 2014

It should looks like here:
http://ivod.co/sitemap-video.php

till now it is not..:-/

Marius P. · 14 October, 2014

Sitemaps only keep the url

tesladisk · 17 October, 2014

Hi to all i use this sitemap code and works really well so far if anyone can make it better beloow is the code

Code Select


<?php
mysql_connect("localhost", "YOUR DATABASE NAME HERE", "YOUR DATABASE PASS HERE") or
    die("Could not connect: " . mysql_error());
mysql_select_db("vaperstu_vibe");//////////// <  
 
  $query = mysql_query ( "SELECT  * FROM vibe_videos WHERE pub > 0 ORDER BY `date` DESC" );
  $row = mysql_fetch_assoc ( $query );
 
 echo '<?xml version="1.0" encoding="utf-8"?>' . "
  ";
  ?>
 
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">
  <?php
  ############# BEGIN LOOP ############
  do {
  $link = 'http://YOURDOMAIN.com/video/' . $row['id'].'/' .$row['title'].'/';
  $lastmod = $row['date']; 
  $priority = 0.5;
  $changefreq = 'weekly';
 
  ?>
  <url>
  <loc><?php $input = $link; $patterns = '/ /'; $replacements = '-'; echo preg_replace($patterns, $replacements, $input); ?></loc>
  <lastmod><?php $datetime = new DateTime($lastmod); $result = $datetime->format('Y-m-d\TH:i:sP'); echo $result; ?></lastmod>
  <priority><?=$priority?></priority>
  <changefreq><?=$changefreq?></changefreq>
  </url>
  <?php
  } while ( $row = mysql_fetch_assoc ( $query ) );
  ############# END LOOP ############
 
  ?>
  </urlset>

maldboy · 27 December, 2014

not works for mee...
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/therap/public_html/sitemap.php on line 7
http://tv-therapy.net/video/// 2014-12-27T16:53:34+00:00 0.5 weekly
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/therap/public_html/sitemap.php on line 30

marketania · 28 December, 2014

Can this be implemented as an option in 4.0 ? Or is it too buggy for official release ?

Marius P. · 28 December, 2014

Quote from: marketania on 28 December, 2014
Can this be implemented as an option in 4.0 ? Or is it too buggy for official release ?

It will come with it's own sitemap suite (html & xml).

PHPVIBE Forums

[ Video Sharing CMS v4 ] Sitemap for 3.6

identicalmedia

krejcis

krejcis

Marius P.

tesladisk

maldboy

marketania

Marius P.

Similar topics (7)

	<?php
	mysql_connect("localhost", "YOUR DATABASE NAME HERE", "YOUR DATABASE PASS HERE") or
	die("Could not connect: " . mysql_error());
	mysql_select_db("vaperstu_vibe");//////////// <

	$query = mysql_query ( "SELECT * FROM vibe_videos WHERE pub > 0 ORDER BY `date` DESC" );
	$row = mysql_fetch_assoc ( $query );

	echo '<?xml version="1.0" encoding="utf-8"?>' . "
	";
	?>

	<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">
	<?php
	############# BEGIN LOOP ############
	do {
	$link = 'http://YOURDOMAIN.com/video/' . $row['id'].'/' .$row['title'].'/';
	$lastmod = $row['date'];
	$priority = 0.5;
	$changefreq = 'weekly';

	?>
	<url>
	<loc><?php $input = $link; $patterns = '/ /'; $replacements = '-'; echo preg_replace($patterns, $replacements, $input); ?></loc>
	<lastmod><?php $datetime = new DateTime($lastmod); $result = $datetime->format('Y-m-d\TH:i:sP'); echo $result; ?></lastmod>
	<priority><?=$priority?></priority>
	<changefreq><?=$changefreq?></changefreq>
	</url>
	<?php
	} while ( $row = mysql_fetch_assoc ( $query ) );
	############# END LOOP ############

	?>
	</urlset>