Add-on for vBadvanced Gallery URLs

I would like to request an add-on module for including PhotoPost (was vBadvanced) Gallery URLs in my sitemap.

Can the vbseo_sm_vba.php add-on be modified to perform that operation?

Thanks.

Anything can be done with some code-hacking.

I'd rather have this as a core-feature, I don't like modifying code and doing that seems like the only thing you could do.

The module support was added for just this sort of thing; so it *is* a core feature.

Someone should be able to use the included CMPS module as a guide to make one for Gallery.

Is there anything (example links, etc.) I can provide to help this along?

I tried to modify the photopost addon for vba gallery but as i am not a php guru i am not sure if this will work Can someone check if this will work or not

Code:

<?
	# vbSEO Google Sitemap Generator - PhotoPost Add On.
	# Written by Ben Griffiths (http://www.fiatforum.com)
	
	# NOTE: THIS ONLY WORKS IF YOUR PHOTOPOST DB IS THE SAME AS YOUR VB ONE

	# Full HTTP path to your gallery root (including trailing forwardslash)
	$gallery_url = 'http://www.ayyas.com/galeri/';
	
	# Priority you want to assign to the sitemap pages
	$sitemap_priority = 0.5;
	
	# How often you wish to flag for updates
	$sitemap_update = 'weekly';

	# PP Table Prefix
	//$pp_tableprefix = 'pp_';


	# DON'T EDIT PAST HERE #############################################
	$adv_gallery_images = $db->query_read('SELECT id,lastpost,date FROM ' . TABLE_PREFIX . 'adv_gallery_images');
	while ($adv_gallery_images = $db->fetch_array($adv_gallery_images))
	{
		$modified = $adv_gallery_images['lastpost'];
		$modifiedphoto = $adv_gallery_images['date'];
		if ($modified == '0')
		{
			$modified = gmdate("Y-m-d",  $modifiedphoto );
		}
		else
		{
			$modified = gmdate("Y-m-d",  $modified );
		}

  		vbseo_add_url(
  			$gallery_url . 'showimage.php?' . $adv_gallery_images['id'],
     		$sitemap_priority, $modified, $sitemap_update
  		);
	}
?>

I believe this addon shall work

Create a file named vbseo_sm_vbagallery.php with the following code inside.
Upload it to your addon folder , add it to your settings in admincp and save it.

Code:

<?
	# vbSEO Google Sitemap Generator - PhotoPost Add On.
	# Written by Ben Griffiths (http://www.fiatforum.com)
	
	# NOTE: THIS ONLY WORKS IF YOUR PHOTOPOST DB IS THE SAME AS YOUR VB ONE

	# Full HTTP path to your gallery root (including trailing forwardslash)
	$gallery_url = 'http://www.ayyas.com/galeri/';
	
	# Priority you want to assign to the sitemap pages
	$sitemap_priority = 0.5;
	
	# How often you wish to flag for updates
	$sitemap_update = 'weekly';

	# PP Table Prefix
	//$pp_tableprefix = 'pp_';


	# DON'T EDIT PAST HERE #############################################
	$adv_gallery_images = $db->query_read('SELECT imageid,lastpostdateline,dateline FROM ' . TABLE_PREFIX . 'adv_gallery_images');
	while ($adv_gallery_images = $db->fetch_array($adv_gallery_images))
	{
		$modified = $adv_gallery_images['lastpostdateline'];
		$modifiedphoto = $adv_gallery_images['dateline'];
		if ($modified == '0')
		{
			$modified = gmdate("Y-m-d",  $modifiedphoto );
		}
		else
		{
			$modified = gmdate("Y-m-d",  $modified );
		}

  		vbseo_add_url(
  			$gallery_url . 'showimage.php?' . $adv_gallery_images['imageid'],
     		$sitemap_priority, $modified, $sitemap_update
  		);
	}
?>

Thanks, I will try this today.

Do I need to include the .php extension when adding it the the admincp?

Originally Posted by Ocean

Thanks, I will try this today.

Do I need to include the .php extension when adding it the the admincp?

It works
You need to upload php to vbseo_sitemap addon folder and write the exact filename with extensin in admincp

I don't think this is working for me. The reports don't show an increased number of URLs in the sitemap. Since I have 1500+ images in the gallery, I think it should show those URLs added the first time I run it.

Is there another way to see if it worked?

Some info:
the path to my gallery root is like http://gallery.mydomain.com
my table prefix is adv_

What is the significance of the setting:
# How often you wish to flag for updates
$sitemap_update = 'weekly';

Check your sitemap folder the results are not in the reports also for me but i have 7 new sitemaps created after running the plugin.

I checked the folder. Still doesn't work.
I set //$pp_tableprefix = ''; since my tables only have the adv_ prefix
and then ran Sitemap again. It doesn't add any sitemaps or URLs to the existing sitemap files.

Is there anything else I can try?

Thank you for your help with this.

You don't need to enter any table prefix. adv_gallery_images is the regular table that is added by photopost vbgallery.
I am not sure but maybe it is not working for you because you have your gallery in subdomain but what i think it shall work

for your gallery url can you try with $gallery_url = 'http://www.yourdomain.com/gallery/';

Code:

[addon module] vbseo_sm_vbagallery.php [29,125s (+0)]<br/>
[create sitemap file] filename: sitemap_23.xml.gz, number of urls: 1492 [29,125s (+0)]<br/>

I tried the gallery URLs both ways with the same result. I don't see any 'showimage.php' URLs in my sitemaps. I don't know what I'm missing here...:(

When I run sitemap, I see this :

[addon module] vbseo_sm_vbagallery.php [79s (+6)]
[create sitemap file] filename: sitemap_3.xml.gz, number of urls: 8152 [79s (+0)]
[create sitemap in text format] part #4 [79s (+0)]
[create sitemap index] filename: sitemap_index.xml.gz, number of sitemaps: 3 [79s (+0)]

But, then I don't see any URLs with 'showimage.php' in the urllist.txt file or any of the xml sitemap files.

Can you try with this

Code:

<?php
	# vbSEO Google Sitemap Generator - PhotoPost vbGallery Add On.
	# Written by Lizard King (http://www.ayyas.com)
	# Full HTTP path to your gallery root (including trailing forwardslash)
	$gallery_url = 'http://www.ayyas.com/galeri';
	
	$mods = $db->query("SELECT catid,title FROM " . TABLE_PREFIX . "adv_gallery_categories ORDER BY `displayorder`");
	while ($mod = $db->fetch_array($mods))
	{	
		$url = $gallery_url.'/browseimages.php?c='.$mod['catid'];

		if(VBSEO_ON)
			$url = vbseo_any_url($url);

  		vbseo_add_url($url, 1.0, '', 'daily');
	}

	$mods = $db->query_read('SELECT imageid,dateline FROM ' . TABLE_PREFIX . 'adv_gallery_images');
	while ($mod = $db->fetch_array($mods))
	{	
		$url = $gallery_url.'/showimage.php?'.$mod['imageid'];

		if(VBSEO_ON)
			$url = vbseo_any_url($url);
  		vbseo_add_url($url, 1.0, '', 'daily');
	}
?>