vB3 Member Album 2.0

In vBulletin 3 there is an option for members to upload a profile picture. This hack provides more incentive for members to upload their picture, as it integrates a gallery to browse them all. :up:

In addition to browsing profile pictures, there is an option for viewing signatures. This comes in handy, for you don't have to browse through each individual member. Also, a "edit signature" link is provided for moderators, for fast access to editing signatures that aren't in accordance with your rules.

Other Features

• Require pictures to be approved in order to be visible. You can exempt specified usergroups from this.
• Thumbnails are generated for profile pictures. You must have GD installed and enabled via the AdminCP options page.
• For more insight, refer to the attached screenshots, or install it!

Upgrade to 2.0

• Redo steps 7-8, 11-12, 19-20, 26, 27, and 34
• Revert the template "modifyprofilepic", and do steps 29-32
• Run the following queries:
  [sql]
  ALTER TABLE `customprofilepic` ADD disapproved smallint(5) not null default'0';
  ALTER TABLE `customprofilepic` ADD reason varchar(100) not null;
  [/sql]

Notes

• This hack does not support uploading multiple images per account.
• Profile thumbnail sizes are defined by the attachment thumbnail sizes. So modify the attachment thumbnail sizes in your AdminCP options page if you wish to change the profile picture thumbnail sizes. Be sure to run "re-generate thumbnails" via the vB3 Member Album -> Approve Images" page.
• Profile picture sizes (not thumbnails) are defined for each usergroup. Modify a usergroup via AdminCP to change the dimensions members under that group are allowed to have for profile pictures.

3rd Party Add-ons

• Pseudomizer has posted a migration script that will transfer your files from my old vB2 Member Photo to the correct tables in this vB3 hack. Click here to view.
• Pseudomizer also posted a portal-integration allowing you to display a random profile picture on your portal.
  Click here to view.
• Thanks to those who posted add-ons!

Galleries in Action

• iKwak - http://www.calpolyonline.com/forums/album.php
• Mudxx - http://www.musictalk.com/album.php
• Velocd - http://forums.animesystem.com/album.php

If you have this hack installed on your forum, and could provide me a demo, please PM a link so I can post it in this thread.

[Vivi Ornitier]

hmmm . . . i was hopin this would be like the vb2 hack where it would thumbnail the picture to be put on the photo album page but then if u click on the thumbnailed picture, it would become the original large size.

[Boofo]

Originally Posted by mudxx

Installed it, works great

Btw, Boofo, be sure you have jpeg support enabled in GD...

It's most likely you've got something wrong with GD... ran into that problem myself.

Yes, it's enabled and running fine.

[Boofo]

Ok, it works now. Whatever you did in the new update, Mike, it seems to have fixed it. Thank you for a great hack, buddy!

[Vivi Ornitier]

hmmm .. . disregard what i said. This hack uses the profile pic as the basis for the photo album. I remember the last version created a whole new feature where you uploaded the picture so in the photo album, you could click on the thumbnil and it would show the original unthumbnaield version.

However, I'm sure you could do what i asked for in my previous post but it would show in the case that the picture the user uploaded was really large, it would show that picture instead of a thumbnailed version in the member's profile.

Mehh . ..oh well, it all works lol, great hack

[Velocd]

I got this error below: Can anyone help me out with this error?

Warning: Division by zero in /home/vietmyen/public_html/album.php on line 149

Warning: Division by zero in /home/vietmyen/public_html/includes/functions.php on line 1707



There seems to have been a slight problem with the VietSuperModel Net database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 3.0.0:

Invalid SQL:
SELECT user.userid, dateline,
comment, user.username, user.usertitle,
user.joindate, user.usergroupid
FROM customprofilepic
LEFT JOIN user USING (userid)
WHERE visible=0

ORDER BY posts desc
LIMIT 0,

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 9

mysql error number: 1064

Did you run the MySQL queries?

It's giving a division by zero because the $perpage variable is empty. You should have this field set in AdminCP -> vB3 Member Photo -> Settings.

Also..

FROM customprofilepic 
LEFT JOIN user USING (userid) 
WHERE visible=0

In my code, it is not visible=0 but visible=1. It would be good to change that.

[Velocd]

Also note, I usually release my hacks in full featured status.

Meaning, I don't plan to add-on any enhancements. This hack is a simple gallery system for current vB3 profile pictures and signatures. I wont be adding multiple image support, a commenting system, etc.

If you would like to do so, feel free.

[calvinnguyen]

Originally Posted by Velocd

Did you run the MySQL queries?

It's giving a division by zero because the $perpage variable is empty. You should have this field set in AdminCP -> vB3 Member Photo -> Settings.

Also..

FROM customprofilepic 
LEFT JOIN user USING (userid) 
WHERE visible=0

In my code, it is not visible=0 but visible=1. It would be good to change that.

yes, visible is 1

yes, I did run individual each line query for a time. And completed run to all.

I didn't see any opotion like you said:AdminCP -> vB3 Member Photo -> Settings.

I only see : AdminCP -> vB3 Member Photo

under vB3 Member Photo have:
options
approve images

[Velocd]

vB3 Member Photo -> Options is what I meant.

Is the images per page value set?

Try editing your album.php, and under where it says:

PHP Code:

$perpage = $vboptions['album_perpage']; 


Place:

PHP Code:

echo $perpage; 


And see if there is any output.

[Christine]

Working like a champ on the first install.

I can't thank you enough for this. You wrote this WAY more thorough then I would have been capable of doing in just slapping something together. Saved me a MOUNTAIN of time and aggrivation.



Edit to add -- I just changed my favorite hack to this one.

[Velocd]

Heh, I'm glad I could help such a large way.

This was probably the quickest hack I've coded, since Mudxx requested it on Wednesday or Tuesday.