Automatically include a link to a users' photopost gallery in vbulletin

Updated on May 14th, 2005 to include as an option:
Gallery stats for the user in the MEMBERINFO template that will show next to the gallery link, like this: View username's Photo Gallery - Has xxx photos in the Photo Gallery, with a total of xx,xxx views to date.
Edit to vbulletins' member.php file required and change to the MEMBERINFO template edit.

Example - Member Profile and attachment #6

readme.zip file updated to readme2.zip

I found a way to automatically include a link to a users' gallery in the users' postbit dropdown menu, in the edit line of the postbit (graphic image), and in the users' profile page. It involves adding two lines of code (a query) in the image-inc.php file, in the editphoto.php file, creating a new User Profile field (in vbulletin), and editing of the postbit and the MEMBERINFO templates. Click here to see an example and see the attached images. Photopostdev Post

Works with vBulletin Version 3.0.7 integrated with PhotoPost PHP 5.02 vB3 Enhanced, but it should work with earlier versions of both. With thanks to MarcoH64, vBulletin.org Moderator for assistance with working out the sql query.

This will work only if your photopost and vbulletin share the same database!!

What this modification does:
Whenever a user uploads a photo, a line of code in the image-inc.php file will automatically UPDATE the userfield (vbulletin's) table by SETTING the value of 1 to a field number you create below. The link to his gallery will then show in the postbit and in the MEMBERINFO template based on the condition of this field. If the number is already set to 1 (user has previously uploaded photos), it will just overwrite with another value of 1 (no harm). If it is the first time a user is uploading photo(s), the value in this field will be null, but the line of code in the image-inc.php or editphoto.php files will now set it to a value of 1

So far the only little kink in this mod, is if a users has only uploaded one photo and if they delete this one photo (if you have allowed permissions for user delete), the field will still be set to 1, meaning the link in the postbit and MEMBERINFO will still be there. In experimenting on my board with this hack, I had such a case. But if you click the link, and even though the user has no photo(s), it doesn't generate an error, just shows the normal gallery page for this member, but with no photos to display (see attachment5). I'm trying to work out some code to check if a user has ANY photos at all in the database, and based on that condition, "reset" the field value back to NULL.

1 - Create a New User Profile field
2 - Edit two files in photopost, image-inc.php and editphoto.php.
3 - Edit two templates in vBulletin, postbit and MEMBERINFO.

See attachments

In attached zip file:
readme2.txt with the instructions

Note:
Members that already have Photos in the Gallery prior to installing this mod, will have to go to their UserCP's Options to Check the "Show Link to Photo Gallery" box, or you will have to do it in the Admin Users'. When I first installed this, I made a general announcement to my Members and included an update in our Forum's weekly Bulletin. Most did update, but I had to select just a few members that hadn't.

If a member already has photos in the Gallery, does not have the box Checked in their UserCP prior to installing this mod, but then uploads a photo(s), the "Show Link to Photo Gallery" will then be updated.

In other words, this mod will not automatically update the check boxs when you first install it. Only after, when a user uploads new photos, or uploads photos for the first time.

John

[larryd]

That's awesome; now if I can get around to uninstalling the other one and installing this one

[wirewolf]

Thanks larryd.
I should add that the thumbnail of the "Latest Photo" you see in the postbit attachment image above and in the sample url to my post are from this hack - Latest Photopost Photo In Postbit, by sabret00the. It works in vBulletin v 3.0.7. If you want to install his hack in combination with mine, it won't cause any conflict. Where you made the template edit to postbit and MEMBERINFO:

<if condition="$post['fieldx']">
<tr><td class="vbmenu_option"><a target="_blank" href="/your_photopost_directory/showgallery.php?cat=500&ppuser=$userinfo[userid]">View $userinfo[username]'s Photo Gallery </a></td></tr>
</if>

Just wrap his tag edit (from his hack) around mine, like this:

<if condition="$post[galleryavatar]">
<if condition="$post['fieldx']">
<tr><td class="vbmenu_option"><a target="_blank" href="/your_photopost_directory/showgallery.php?cat=500&ppuser=$userinfo[userid]">View $userinfo[username]'s Photo Gallery </a></td></tr>
</if></if>

And if you used the optional Image link in the Edit line of postbit:

<if condition="$post[galleryavatar]">
<if condition="$post['fieldx']">
<a target="_blank" href="/your_photopost_directory/showgallery.php?cat=500&ppuser=$userinfo[userid]">
<img src="$stylevar[imgdir_button]/gallery.gif" alt="View this Members' Photo Gallery" border="0" /></a>
</if></if>

Now this may seem redundant, but it works quite nicely. If a member has never uploaded a photo, then as soon as they do, then the link and the thumbnail will show in their postbit. However, if they go into their UserCP Options, they can "Uncheck" the "Show Link to Photo Gallery" box and the link will not show, and it kind of solves the little problem I described above,

So far the only little kink in this mod, ......................................(see attachment5). I'm trying to work out some code to check if a user has ANY photos at all in the database, and based on that condition, "reset" the field value back to NULL

If they ever do delete the only photo they have ever uploaded, then the userfield "x" doesn't have to be "Reset to 'NULL'", but the tag from his hack

<if condition="$post[galleryavatar]">
blah blah blah
</if>

Will act like a master switch, the userfield will act as User Option (and Admin Option), and if you change the owner of a photo to a user that does not have any photos as yet, both the thumbnail and the link will show.

I know, sounds a bit confusing, but it works like a charm!

I'll be updating this hack soon to include some gallery stats for the user in the MEMBERINFO template that will show next to the gallery link, like this:
View username's Photo Gallery - Has xxx photos in the Photo Gallery, with a total of xx,xxx views to date.

Updated - See top post

John

[Internet]

Hello,

I would only like to do this for my forum :

https://vborg.vbsupport.ru/attachmen...chmentid=26278

What, where, how do i get the above?

Thanks a lot.

[wirewolf]

Easy, just download the readme2.zip file, open and follow the instructions. Then only include the one graphic link at line 96:
"This is for an optional graphic image link in the edit line of postbit."

[Internet]

Thanks Wirewolf! I got it done!

[David Bott]

Hello...

Ok, this is great! So here is something that is needed.

As this point we have all these people who have posted photos. At this time, unless they go in and check the box in the profile, the link will now show. If they add a new photo or edit one or something, it will auto check the box. (Unless I am mistaken.)

Need a script that can be run ONCE, that will look look though PhotoPost database and update the users VB3 profile to check the box for all members that have photos already in Photopost. Then they are all on and if they want,then they can turn them off. (Not sure why they would want to though.)

BTW...Unless I am mistaken, your code added into the Photopost files will check the box in the members profile if they add another photo or what have you. The issue is, what if they already have set their profile to NOT show it. It will set it back. (again, not sure why they would want to.)

[T3MEDIA]

But there is no need to hack the photopost files... this should be a template only mod no?
I did this for a client and I didnt have to mod anything besides the Memberinfo Template...
I didnt look into this but I assume its the same.

I would love someone to make a cron job that deletes users photos if they are moved to a banned group.

[David Bott]

From the instructions...

open:
image-inc.php 

=========look for (around line 757):=========
if ($Globals['ppostcount'] == "yes")
 inc_user_posts();
 
 ===Add above==(user uploads photo(s))=======edit fieldX to x being the post field number you created above:

$query = "UPDATE {$Globals['dprefix']}userfield SET fieldX=1 WHERE  userid = $upuserid";
$resulta = ppmysql_query($query,$db_link);

===============save and upload===============

AND

open:
editphoto.php 

=========look for (around line 451):=========
$newname = addslashes($newname);
$query = "UPDATE {$Globals['pp_db_prefix']}photos SET  user='$newname',userid='$newuserid' WHERE id='$phoedit'";
$result = ppmysql_query($query, $link);


=Add below==(Admin changes owner of a photo)==edit fieldX to x being the post field number you created above:

$query = "UPDATE {$Globals['dprefix']}userfield SET fieldX=1 WHERE userid = $newuserid";
$result = ppmysql_query($query,$db_link);

===============save and upload===============

Thus their is a changes to a PhotoPost files.

[kall]

Why not use the /photopost/forums/vb3.php edit that changes the 'photo' total correctly?

ie: When a user adds a photo, their photo count goes up by one. If it is removed, it goes down by one.

It does remove the 'photos add to post count' functionality, but I think that function is redundant and strange.