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.

[Pseudomizer]

Originally Posted by MorrisMcD

It may not have anything to do with VBulletin. but it does have to do with this hack. Rather than responding like this, you could just as easily point me in the right direction

But thanks anyway

Hello Morris,

google for GD support or GD installation manual. You will find a lot of places and manuals.

Cheers,

[Oblivion Knight]

Using Slynderdale's fixed zip here, this is working very well on 3.0.5..


[EDIT]
I spoke to soon, the approval part of the mod isn't 100%.

[eblivion]

In albumcp.php

PHP Code:

 
$images = $DB_site->query("
 
SELECT customprofilepic.*, user.username 
 
FROM " . TABLE_PREFIX . "customprofilepic 
 
LEFT JOIN " . TABLE_PREFIX . "user 
 
USING (userid) 
 
ORDER BY username 


Should be:

PHP Code:

 
$images = $DB_site->query("
 
SELECT " . TABLE_PREFIX . "customprofilepic.*, " . TABLE_PREFIX . "user.username 
 
FROM " . TABLE_PREFIX . "customprofilepic 
 
LEFT JOIN " . TABLE_PREFIX . "user 
 
USING (userid) 
 
ORDER BY username 


Also, similar problem in album.php in both select statements.

[eblivion]

Originally Posted by TyC

Fatal error: Call to undefined function: build_image() in /home/httpd/vhosts/URL/httpdocs/forum/includes/functions_upload.php on line 204

I'm was getting the call to undefined function: build_image() error too. I reverted the functions_upload.php file to what it was prior to modification and re-did it. It then worked.

My album thumbnail images are broken. The profile pics display properly, though. Does anyone know what is causing it to be broken. I do have GD 2+ installed and enabled on the forum.

[deta]

Hello

I have in addition times questions:

1. My MySQL tables is called thus always vb3_user..., a vb3 _ before it.
What here do I have to change, so that also then with me functions?

2. A Member Voting would not be bad. With announcement of the TopVotings for man and woman. Is that feasible?

cu Deta

[eblivion]

If the table is:

user

then you should change it to

" . TABLE_PREFIX . "user

Use the same format for all the table names.

[bbwlva]

I'm getting this error;

Database error in vBulletin 3.0.6:

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

ORDER BY posts desc
LIMIT 0, 18

mysql error: Unknown table 'user' in field list

mysql error number: 1109

Date: Tuesday 25th of January 2005 09:11:53 PM
Script: http://forums/album.php
Referer:

[Andreas]

In album.php FIND (2 instances)

PHP Code:

LEFT JOIN ".TABLE_PREFIX."user USING (userid) 


REPLACE that with

PHP Code:

LEFT JOIN ".TABLE_PREFIX."user AS user USING (userid) 


FIND

PHP Code:

FROM ".TABLE_PREFIX."customprofilepic 


REPLACE that with

PHP Code:

FROM ".TABLE_PREFIX."customprofilepic AS customprofilepic 


FIND

PHP Code:

LEFT JOIN ".TABLE_PREFIX."usertextfield 


REPLACE that with

PHP Code:

LEFT JOIN ".TABLE_PREFIX."usertextfield AS usertextfield 


FIND

PHP Code:

FROM ".TABLE_PREFIX."user 


REPLACE that with

PHP Code:

FROM ".TABLE_PREFIX."user AS user 


This should take care of table prefixes.

[eblivion]

Does anyone know how to fix the broken images? I have GD 2+ andthe profile pictures show correctly on the memberlist and profile page,but all the images are broken in the album and the admincp.

[deta]

Originally Posted by eblivion

Does anyone know how to fix the broken images? I have GD 2+ andthe profile pictures show correctly on the memberlist and profile page,but all the images are broken in the album and the admincp.

The Same i have