Display vBGallery Link In Postbit If User Has One

Here is a simple mod to display a link in postbit to post user gallery only if he has one.

in showthread.php make the following changes highlighted in red once.
I had to change the select statement to select distinct because for some reasons, it was displaying the post in triplicate (thanks to Dark Visor).

$posts = $DB_site->query("
SELECT DISTINCT
post.*, post.username AS postusername, post.ipaddress AS ip,
user.*, userfield.*, usertextfield.*,galleries.catuserid,

a few lines down in the same query

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN " . TABLE_PREFIX . "adv_gallery_categories AS galleries ON(galleries.catuserid = user.userid)

then place that conditional in postbit/posbit legacy template where you want to display it, replacing the red with your own.

<if condition="$post['catuserid']">
<a href="http://www.site.com/forums/gallery/browseimages.php?c=XX&userid=$post[catuserid]">My Gallery</a>
</if>

update:

For those who don't have a specific member category use this link
browseimages.php?do=member&imageuser=$post[catuserid]

[bold]

how would i make it display a link only if a member has an image in the members gallery since i don't allow sub-cats in my members gallery?

[Lionel]

browseimages.php?c=XX&userid=$post[catuserid]

XX is your main membercategory. That will pull all images under if you have, if not then...

[bold]

but it only shows a link if the user has created a category in the members category. i'm wondering how i can make it so that it shows a link if they have uploaded an image to the members category without creating a category.

[Lionel]

The way I understand it, the first time a member uploads, regardless if he created a category or not, a folder with his userid is automatically created on the server. This is that folderid that is being pulled.

Why don't you just try. Can't hurt.

[Allan]

this hack walk with which gallery ?

[Lionel]

<a href="http://www.vbadvanced.com/products.php?do=productinfo&p=5" target="_blank">celle la</a>

[Vega]

I'll try that. Thank you!

[bold]

Originally Posted by Lionel

The way I understand it, the first time a member uploads, regardless if he created a category or not, a folder with his userid is automatically created on the server. This is that folderid that is being pulled.

Why don't you just try. Can't hurt.

i was asking because it wasn't working for me.

[bold]

the link only showed if a member had created another category.