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.

[Velocd]

I've just installed this on a fresh version of vB3 (it was tested on vB3 Beta 5 and a modified vB3 prior), and the installation was flawless.

Boofo, make sure you run the "Rebuild profile picture thumbnails" from admincp/albumcp.php?do=approve. This is required at first, and consequently every other time you change the dimensions of the attachment thumbnail size.

Then clear your browser internet cache, and restart the browser. The browser probably handles the stream of the image a bit more funky since it's from the database, rather than a file on the server. Therefore it might not be updating properly unless you clear your cache.

You say the avatar doesn't show, also?

How does your forum handle custom avatars? Uploaded into the database, or are they stored in a folder?

[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.

[Vivi Ornitier]

This isn't workin the way i expected it to. Let' see

1. When i upload a picture it says i'm above the dimensions set, how do i change the dimensions for the user profile pic?

2. I go to the album.php page and all i see is the people's username with a X beside their name.

3. I try to go to the verify picture link in admincp and it takes me to a 404

Edit: the admincp problem was due to me just not uploadin it into the admincp directory, lol.

But my original quesoitn still holds, how do i change the dimensions for the profile pics? it is set at 100x100

[Velocd]

I've updated to vma1.1, as there were some important bug fixes concerning approval and aesthetics.

To upgrade, reupload albumcp.php to your admincp, and do steps #3-4 and #28 again.

Originally Posted by Vivi Ornitier

But my original quesoitn still holds, how do i change the dimensions for the profile pics? it is set at 100x100

The thumbnail settings for photos are the same as attachments. So modify your attachment thumbnail settings (via AdminCP options page) if you wish to change the size.

edit:

If you mean the actual profile dimensions, those are defined by each usergroup. Refer to the usergroup page in your AdminCP.

[calvinnguyen]

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

[Floris]

Originally Posted by Velocd

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!

This hack does not support uploading multiple images per account.

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.

Could a comment system be implemented? Like usernotes.

[LeeCHeSSS]

Is this or could it be made compatible with this hack?

That would probably be sweet

[msimplay]

Originally Posted by calvinnguyen

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

weird i got the exact same error

[Oblivion Knight]

Originally Posted by LeeCHeSSS

Is this or could it be made compatible with this hack?

That would probably be sweet

I'm fairly sure it could with a little tweaking..

I may have a play around with the 2 hacks later on my test board and see what I can come up with.

[Boofo]

Originally Posted by Velocd

I've just installed this on a fresh version of vB3 (it was tested on vB3 Beta 5 and a modified vB3 prior), and the installation was flawless.

Boofo, make sure you run the "Rebuild profile picture thumbnails" from admincp/albumcp.php?do=approve. This is required at first, and consequently every other time you change the dimensions of the attachment thumbnail size.

Then clear your browser internet cache, and restart the browser. The browser probably handles the stream of the image a bit more funky since it's from the database, rather than a file on the server. Therefore it might not be updating properly unless you clear your cache.

You say the avatar doesn't show, also?

How does your forum handle custom avatars? Uploaded into the database, or are they stored in a folder?

The avatars are stored in the folder on the server.