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

[wirewolf]

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 (http://www.shipmodeling.net/vb_forum/member.php?u=3) 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 (http://shipmodeling.net/vb_forum/showthread.php?p=2161#post2161) and see the attached images. Photopostdev Post (http://www.photopostdev.com/showthread.php?t=1318)

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 (https://vborg.vbsupport.ru/showthread.php?t=72335), 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">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 NULLIf 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:
[U]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/attachment.php?attachmentid=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.

[Gutspiller]

What if we have 2 photopost installations using the same user database of our forums?

[Khashyar]

Hi wirewolf...

Thanks for posting your hack.

By "This will work only if your photopost and vbulletin share the same database!!", do you mean that they have to share the same user information (i.e., photopost using Vb's users, OR... do you mean that the photopost installation must COMPLETELY share and use the VB database, and cannot have it's own database?

Thanks,

Khashyar

[wirewolf]

Hi wirewolf...

Thanks for posting your hack.

By "This will work only if your photopost and vbulletin share the same database!!", do you mean that they have to share the same user information (i.e., photopost using Vb's users, OR... do you mean that the photopost installation must COMPLETELY share and use the VB database, and cannot have it's own database?

Thanks,

KhashyarFirst, you're welcome and thanks.
Well, they could be separate, but a lot more coding would have to be done to make it work. It would be essential for the user table to be the same for both vbulletin and photopost. Is your forum set up that way, separate databases?
John

[Khashyar]

Hi John,

Thank you for the quick reply...

Yes, my PP and VB installations share the same user info (taken from the VB database). The photos and other information are in their respective databases.

You did a great job with your hack, and I am sure that there are a lot of people who have sepreate PP and VB databases who would love to install your hack is you can post some of the additional code.

My understanding is that you would just need to include login config information for the PhotoPost database in the code that you include in VB (since it is pulling the photos from a different database that is not in the VB database).... I am wondering whether it would be a secure option to include login DB info for the Photopost database in the script.

If you have ideas as to how to alter your code for different databases (but shared user info), than I would appreciate it.

Thank you again for sharing your hack,

Khashyar

[Kristoph]

got this installed and running like a charm on my forums, made a few alterations, used a camera icon in the postbit for the link... I also added an extra profile field for last photo timestamp, modified the query to "SET fieldx=1,fieldy=UNIX_TIMESTAMP()" then put in a quick conditional, so as it displays a "new photos" message underneath if there's been any photos uploaded in the last 24 hours....

[digidivakathy]

Will this work with vB 3.5.2? It is EXACTLY what I need so I hope so!

[slvr ralliart]

Will this work with vB 3.5.2? It is EXACTLY what I need so I hope so!

I wanna know this too but I have 3.5.1 vb version

[Zachariah]

In it's current state no.
- There may be a good amount of things done w/ plugins vs. edits.

[slvr ralliart]

In it's current state no.
- There may be a good amount of things done w/ plugins vs. edits.

would you make this compatiable for vb 3.5.1 please?

[slvr ralliart]

bump

hello???

[slvr ralliart]

anyone like to answer?

make this work for 3.5.1 please

[wirewolf]

anyone like to answer?

make this work for 3.5.1 pleaseSorry to answer so late. Been very busy of late.

I haven't even looked at 3.5.x yet. As it is, I don't know if this will work with 3.5.x. I haven't upgraded to it yet, and I don't know if I ever will. I'm quite happy with 3.0.x

If some one else wants to give it a try, please do.

The only script edits are to the two photopost files, with only edits to two of vbulletins templates (no script edits) and the added Custom Profile Field. If you want, save the files affected first, apply the changes and see what happens.

John

[slvr ralliart]

anyone wanna give this a shot then?

[glowinggal]

bummmer.... was so excited and then saw they have to share the same database.... my pp is outside my vb but uses vb for my member registration - maybe it's time I copy the tables over to my vb database with a prefix.... just might be worth it to use this hack!

[SherryG]

This hack is EXACTLY what I have been looking for. Are there any plans to release this hack for 3.6.2? Please, oh pretty please, say yes!

[rareclownfish]

this would be a nice hack for 3.6.XX

[glowinggal]

this would be a nice hack for 3.6.XX

ditto! Anyone get it to work for 3.6.#