Photopost vbGallery Addon For vBSEO Google/Yahoo Sitemap

[Lizard King]

All Credits go to benFF as he created the original script for photopost pro.

I manually edited the file to work with Photopost vbGallery

Download the attached file , upload it to your vbseo_sitemap/addon/ folder.
In your vbulletin settings vBseo Google/yahoo sitemap settings add vbseo_sm_vbagallery.php to your Addon Generator Modules and save your settings.

Edit php file and change $gallery_url = according to your gallery folder

If you are using Photopost vBGallery v2.0 or v2.1 download vbseo_sm_gallery1.php otherwise you can still use the old one.

This mod also works for vB 3.6.x

For vBSEO (http://www.vbseo.com) users if you use CRR (Custom Rewrite Rules) for your gallery you may modify the file to work with your CRR's. Here is the url example :

Categorie Links (don't forget to change the url's to match your CRR's)

$url = $gallery_url.'/kategori-'.$mod['catid'].'-album.html';

Image Links (don't forget to change the url's to match your CRR's)

$url = $gallery_url.'/resim-'.$mod['imageid'].'.html';

Thanks to loonytune15 as reminding me that the database tables have changed.

26.10 : Updated the script to work with the new Photopost vbgallery since the database tables have changed. Corrected a bug fix with url priority.

15.07 : Updated the script since there was a small bug with it. Also gallery categories are also included in the new version.

[Murty]

yeah first post, dunno what this hack does yet

[Lizard King]

yeah first post, dunno what this hack does yet
This addon allows you to add your Photopost vbGallery url's to your sitemap and google , yahoo and other search engines can crawl your images easier.

[Jim O]

Download the attached file , upload it to your vbseo_sitemap/addon/ folder.
In your vbulletin settings vBseo Google/yahoo sitemap settings add vbseo_sm_vbagallery.php to your Addon Generator Modules and save your settings.
You probably should add that the script needs to be edited before uploading to your site. I haven't installed it yet but likely will.

[Snake]

Thank you very much! :)

[sensimilla]

Thanks I was in need of this one :)

[trackpads]

Outstanding!!

[Lizard King]

Updated the script. I advise everyone to download the new file and replace with the previous file.

[trackpads]

Thanks for the update!!

[rinkrat]

Thanks! Any help in getting more pages on Google is a good thing :)

[glorify]

Hey lizard--

Does this work with vbadvanced gallery 1.0.1?

Also, the URL's do not have to be rewritten by VBSEO for this to work, correct?

[bada_bing]

This is cool will update tomorrow.. Subscribing

[Sean James]

nice, does this work for vbulletin 3.6.0?

[SaN-DeeP]

nice, does this work for vbulletin 3.6.0?
yes it does :)

[loonytune15]

But it doesn't work with the new gallery 2.0
*edit*

To get it work without errors, open the file in an editor,

Find:

adv_gallery_categories


Replace with:

ppgal_categories


Then find:

adv_gallery_images


Replace with:

ppgal_images


Should work fine then..

[Lizard King]

But it doesn't work with the new gallery 2.0
*edit*

To get it work without errors, open the file in an editor,

Find:

adv_gallery_categories


Replace with:

ppgal_categories


Then find:

adv_gallery_images


Replace with:

ppgal_images


Should work fine then..
Thanks , totally forget that the database structure have been changed.

I also applied a small fix that caused error in sitemaps.

[loonytune15]

cool no worries :D

[aacircle]

vbGallery has now been renamed to Photopost quite a while back. So does this hack work on PhotoPost PHP Pro v5.5? Or is this hack only for those who still use the old vbGallery?

[bada_bing]

vbGallery has now been renamed to Photopost quite a while back. So does this hack work on PhotoPost PHP Pro v5.5? Or is this hack only for those who still use the old vbGallery?
Yes good question.. ANYONE?

[MissKalunji]

Categorie Links (don't forget to change the url's to match your CRR's)


Code:
$url = $gallery_url.'/kategori-'.$mod['catid'].'-album.html';
Image Links (don't forget to change the url's to match your CRR's)


Code:
$url = $gallery_url.'/resim-'.$mod['imageid'].'.html';

I dont understand that part?

am i supposed to change #gallery_url to something? or kategory? (not talking in the php but inside vbseo)

[bada_bing]

Yes good question.. ANYONE?
Hello is the author still here?

[MissKalunji]

and is it supposed to change the showimage.php to showimagine.html something something?

[Lizard King]

vbGallery has now been renamed to Photopost quite a while back. So does this hack work on PhotoPost PHP Pro v5.5? Or is this hack only for those who still use the old vbGallery?
It already has the answer in the thread name. It says Photopost vBGallery.

Photopost have couple products but only one Photopost vBgallery.

I dont understand that part?

am i supposed to change #gallery_url to something? or kategory? (not talking in the php but inside vbseo)

If you prepared CRR's for your Photopost vBGallery then you can imply your CRR's to the file in order to prevent duplicate content. I just showed you a way to how to do that.

For categorie links please check your CRR and change the green code to match your CRR. The codes below in Green is prepared to match my CRR settings ;) Since everyone uses different you need to modify it according to your settings.

Categorie
$url = $gallery_url.'/kategori-'.$mod['catid'].'-album.html';

ShowImage
$url = $gallery_url.'/resim-'.$mod['imageid'].'.html';

If you still didn't understand please drop me a Pm with your gallery CRR settings so i can modify these two lines for you.

[aacircle]

Great! Thanks Lizard King. Will install this hack right away. Cheers.

[aacircle]

Well this hack no longer works in 3.6.4 with Photopost. Following database error occurs:

MySQL Error : Table 'anime10_forums.adv_gallery_categories' doesn't exist

[ConqSoft]

Well this hack no longer works in 3.6.4 with Photopost. Following database error occurs:

It's not related to vBulletin 3.6.4, it's related to vBGallery 2.1 which changed some tables around.

[bulbasnore]

First off, great stuff. We have a lot of treasure in our gallery, and we'd like to get it out there and into the search.

I can't get google to accept the map for the gallery section (rev1 of your hack, vB364, PPVB2.1, no seo). Apparently, google is wanting the lastmod object populated.

Line:
27076
Invalid date
An invalid date was found. Please fix the date or formatting before resubmitting. [?] Parent tag:
Tag:
Value: url
lastmod

The line shows up like this:

<url>
<loc>http://mysite.com/gallery/showimage.php?i=15995</loc>
<priority>0.4</priority>
<lastmod></lastmod>
<changefreq>daily</changefreq>
</url>

It looks like your code and the standard vbacmps module addon that comes with the vbseo mapper pass a url much like the 'extra_urls' format to the hack. There isn't a place there for the date.

Is that the problem, no place to send the date modified to the parent hack?

If its a matter of helping extract that data from ppgal_ tables, I could submit some code to you. But if its a matter of the parent hack's API (what they'll take from the addons) then maybe I should talk to them, first.

Please let me know and thanks again!

[for now, disabled add-on]

[puregraf]

hi, will this also work with Photopost ? not photopost vbgallery , the other one and how would this effect when upgrading photopost, would i need to remove this hack before upgrading?

thanks

[Neo_obs]

First off, great stuff. We have a lot of treasure in our gallery, and we'd like to get it out there and into the search.

I can't get google to accept the map for the gallery section (rev1 of your hack, vB364, PPVB2.1, no seo). Apparently, google is wanting the lastmod object populated.

Line:
27076 Invalid date
An invalid date was found. Please fix the date or formatting before resubmitting. [?] Parent tag:
Tag:
Value: url
lastmod

The line shows up like this:

<url>
<loc>http://mysite.com/gallery/showimage.php?i=15995</loc>
<priority>0.4</priority>
<lastmod></lastmod>
<changefreq>daily</changefreq>
</url>

It looks like your code and the standard vbacmps module addon that comes with the vbseo mapper pass a url much like the 'extra_urls' format to the hack. There isn't a place there for the date.

Is that the problem, no place to send the date modified to the parent hack?

If its a matter of helping extract that data from ppgal_ tables, I could submit some code to you. But if its a matter of the parent hack's API (what they'll take from the addons) then maybe I should talk to them, first.

Please let me know and thanks again!

[for now, disabled add-on]

I found the error. Was getting the same issue here and decided to look at the other add-ons as a template.

Find in vbseo_sm_vbagallery(1).php
vbseo_add_url($url, '0.3', 'daily');
and replace with
vbseo_add_url($url, '0.3','', 'daily');

Then find
vbseo_add_url($url, '0.4', 'daily');
and replace with
vbseo_add_url($url, '0.4','', 'daily');

the sitemap generator will add the dates automatically between the '' so basically just add a ,'' to your code lizard

[MissKalunji]

thanks i'll test it out

[MissKalunji]

how would i know if the gallery sitemap was done properly?

[tiger]

Does this work with 3.8 and the new site map version?

[rinkrat]

It's a shame that Google is oblivious to my VBGallery images. This looks like it is no longer supported so I guess I'm screwed.

[Zachariah]

Hey LIZ !!!!!
- Add this too man "if large image add another link for large image"
- also copy / contenue this thread into VB3.8 area

if ($mod['originalname']){
$url = $gallery_url.'/showimage.php?i='.$mod['imageid'].'&original=1';

if(VBSEO_ON)
$url = vbseo_any_url($url);
vbseo_add_url($url, '0.4', $mod['dateline'],'daily');
}


how would i know if the gallery sitemap was done properly?
AdminCP => vBSEO => vBSEO Sitemap Reports
- log-in
-- Show Reports List
--- View details of the last report "by Date"

Here will list all the site maps created:
Sitemap Files
Index File sitemap_index.xml.gz
Sitemap File #1 sitemap_1.xml.gz (5,000 URLs, 1,016.85Kb) 1,016.53Kb uncompressed
Sitemap File #2 sitemap_2.xml.gz (5,000 URLs, 1,072.91Kb) 1,072.58Kb uncompressed
Sitemap File #3 sitemap_3.xml.gz (5,000 URLs, 1,119.71Kb) 1,119.38Kb uncompressed
Sitemap File #4 sitemap_4.xml.gz (5,000 URLs, 954.18Kb) 953.85Kb uncompressed
Sitemap File #5 sitemap_5.xml.gz (5,000 URLs, 900.40Kb) 900.08Kb uncompressed
Sitemap File #6 sitemap_6.xml.gz (5,000 URLs, 901.66Kb) 901.34Kb uncompressed
Sitemap File #7 sitemap_7.xml.gz (5,000 URLs, 899.61Kb) 899.29Kb uncompressed
Sitemap File #8 sitemap_8.xml.gz (5,000 URLs, 901.21Kb) 900.88Kb uncompressed
Sitemap File #9 sitemap_9.xml.gz (5,000 URLs, 901.05Kb) 900.73Kb uncompressed
Sitemap File #10 sitemap_10.xml.gz (5,000 URLs, 902.53Kb) 902.20Kb uncompressed
Sitemap File #11 sitemap_11.xml.gz (5,000 URLs, 905.58Kb) 905.25Kb uncompressed
Sitemap File #12 sitemap_12.xml.gz (5,000 URLs, 905.75Kb) 905.43Kb uncompressed
Sitemap File #13 sitemap_13.xml.gz (5,000 URLs, 905.42Kb) 905.10Kb uncompressed
Sitemap File #14 sitemap_14.xml.gz (5,000 URLs, 906.07Kb) 905.75Kb uncompressed
Sitemap File #15 sitemap_15.xml.gz (10 URLs, 2.14Kb) 1.81Kb uncompressed
Text Format File urllist.txt.gz (3,564.45Kb)

It will be in some of the later GZ files as the images are added after the threads,posts,members (all other forum options) in your forum.

You should see URLS pointing to your gallery.
- <url>
<loc>http://www.xxxx.xxx/gallery/image-10694.html</loc>
<priority>0.4</priority>
<lastmod>2009-07-24T18:28:04+00:00</lastmod>
<changefreq>daily</changefreq>
</url>

Does this work with 3.8 and the new site map version?
yes
It's a shame that Google is oblivious to my VBGallery images. This looks like it is no longer supported so I guess I'm screwed.
working on that @ the moment w/ VBSEO addon I may work on a stand alone version if I get some time.

Keyword Rich URLS with Photopost vBGallery - http://www.vbseo.com/f23/request-keyword-rich-urls-photopost-vbgallery-3962/index2.html

[Xencored]

All i get is errors :mad:

Warning: gmdate() expects parameter 2 to be long, string given in /home/**********/public_html/forums/vbseo_sitemap/vbseo_sitemap_functions.php on line 920



Over and over again

[tiger]

Hey Zach, where do we add that code exactly?

[Zachariah]

Hey Zach, where do we add that code exactly?

Hey man !

/vbseo_sitemap/addons/vbseo_sm_vbagallery.php

This is my file:

<?php
# vbSEO Google Sitemap Generator - PhotoPost vbGallery Add On.
# Written by Lizard King (http://www.ayyas.com)
# Full HTTP path to your gallery root (without trailing forwardslash ex: 'http://www.ayyas.com/galeri'; )
$gallery_url = 'http://www.website.com/gallery';

$mods = $db->query("SELECT catid,title,lastimagedateline FROM " . TABLE_PREFIX . "ppgal_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, '0.3', $mod['lastimagedateline'], 'daily');
}

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

if(VBSEO_ON)
$url = vbseo_any_url($url);
vbseo_add_url($url, '0.4', $mod['dateline'],'daily');

if ($mod['originalname']){
$url = $gallery_url.'/showimage.php?i='.$mod['imageid'].'&original=1';

if(VBSEO_ON)
$url = vbseo_any_url($url);
vbseo_add_url($url, '0.4', $mod['dateline'],'daily');
}
}
?>

Don't forget to fill out : website
$gallery_url = 'http://www.website.com/gallery';

[tiger]

Thanks big time Zach.

[0ptima]

Anyone use this on VBgallery 2.5? Has it increased traffic to your gallery?

[tpearl5]

Any word on this for v3.0 and vbulletin 4?

[0ptima]

Hey man !

/vbseo_sitemap/addons/vbseo_sm_vbagallery.php

This is my file:

<?php
# vbSEO Google Sitemap Generator - PhotoPost vbGallery Add On.
# Written by Lizard King (http://www.ayyas.com)
# Full HTTP path to your gallery root (without trailing forwardslash ex: 'http://www.ayyas.com/galeri'; )
$gallery_url = 'http://www.website.com/gallery';

$mods = $db->query("SELECT catid,title,lastimagedateline FROM " . TABLE_PREFIX . "ppgal_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, '0.3', $mod['lastimagedateline'], 'daily');
}

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

if(VBSEO_ON)
$url = vbseo_any_url($url);
vbseo_add_url($url, '0.4', $mod['dateline'],'daily');

if ($mod['originalname']){
$url = $gallery_url.'/showimage.php?i='.$mod['imageid'].'&original=1';

if(VBSEO_ON)
$url = vbseo_any_url($url);
vbseo_add_url($url, '0.4', $mod['dateline'],'daily');
}
}
?>Don't forget to fill out : website
$gallery_url = 'http://www.website.com/gallery';

This works perfectly on VBG 2.5.1 and VB 3.8! Thanks!

[sweetguy2004]

thank you very much

[0ptima]

Will this work with the 3.0 version of the sitemap generator?

https://vborg.vbsupport.ru/showthread.php?t=253516

[appsfinder]

just testing now

Hey man !

/vbseo_sitemap/addons/vbseo_sm_vbagallery.php

This is my file:

<?php
# vbSEO Google Sitemap Generator - PhotoPost vbGallery Add On.
# Written by Lizard King (http://www.ayyas.com)
# Full HTTP path to your gallery root (without trailing forwardslash ex: 'http://www.ayyas.com/galeri'; )
$gallery_url = 'http://www.website.com/gallery';

$mods = $db->query("SELECT catid,title,lastimagedateline FROM " . TABLE_PREFIX . "ppgal_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, '0.3', $mod['lastimagedateline'], 'daily');
}

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

if(VBSEO_ON)
$url = vbseo_any_url($url);
vbseo_add_url($url, '0.4', $mod['dateline'],'daily');

if ($mod['originalname']){
$url = $gallery_url.'/showimage.php?i='.$mod['imageid'].'&original=1';

if(VBSEO_ON)
$url = vbseo_any_url($url);
vbseo_add_url($url, '0.4', $mod['dateline'],'daily');
}
}
?>

Don't forget to fill out : website
$gallery_url = 'http://www.website.com/gallery';