The Arcive of Official vBulletin Modifications Site.

vB3 Member Album 2.0 · **Released**: 04-09-2004

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.

eblivion · #**437** 01-26-2005, 12:22 AM

If the table is:

user

then you should change it to

" . TABLE_PREFIX . "user

Use the same format for all the table names.

bbwlva · #**438** 01-26-2005, 02:15 AM

I'm getting this error;

Quote:

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 · #**439** 01-26-2005, 02:27 AM

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 · #**440** 01-26-2005, 02:39 AM

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 · #**441** 01-26-2005, 04:30 AM

Quote:

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

deta · #**442** 01-26-2005, 04:37 AM

Quote:

Originally Posted by KirbyDE

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.

Hello

Now I changed in such a way, but now I get one mysql errors.
Before I still "AS user" an "AS.." attached hattte was not the error.
Only the pictures were not indicated.
Neither in the Admincp nor in the album

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

ORDER BY posts desc
LIMIT 0, 18

mysql error: Unknown table 'vb3_user' in field list

mysql error number: 1109

The tables are called with me all vb3 _ and are also present. Also the vb3 _ table.

cu Deta

bbwlva · #**443** 01-26-2005, 07:40 AM

Now I get this error in the albumcp

Quote:

Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT customprofilepic.*, user.username
FROM vb3_customprofilepic
LEFT JOIN vb3_user
USING (userid)
ORDER BY username

mysql error: Unknown table 'customprofilepic'

mysql error number: 1051

Date: Wednesday 26th of January 2005 02:39:33 AM
Script: http://forums/admincp/albumcp.php
Referer: http://forums/admincp/index.php?do=nav
Username: bbwlva
IP Address:

eblivion · #**444** 01-26-2005, 11:17 PM

Quote:

Originally Posted by bbwlva

Now I get this error in the albumcp

See: https://vborg.vbsupport.ru/showpost....&postcount=433

bbwlva · #**445** 01-27-2005, 02:23 AM

Quote:

Originally Posted by eblivion

See: https://vborg.vbsupport.ru/showpost....&postcount=433

Now I get a parse error instead. :[

Also images arent even showing on the album.

deta · #**446** 01-27-2005, 04:58 AM

Hello,

after which I tinkered much and it does not go yet with the pictures,
now times the question.
I have the version 3.0.5 Vbulletin to to run.
What exact do I have to make in this version, which the pictures are indicated with me?
I have the GD2 on the Webserver.

At present I only one X get in the Gallerie indicated.

cu Deta

eblivion · #**447** 01-27-2005, 03:54 PM

PLEASE HELP!!!!!

I still cannot get the thumbnail images to display in the album or admincp, even though the profile pics display correctly.

I have GD2+ installed & enabled.

Do I have to enable attachment thumbnails in posts for the album to work?

If so, is there another way to get it to work because I want the regular sized pics in the posts, not thumbnails?

deta · #**448** 01-27-2005, 05:44 PM

Quote:

Originally Posted by eblivion

PLEASE HELP!!!!!

I still cannot get the thumbnail images to display in the album or admincp, even though the profile pics display correctly.

I have GD2+ installed & enabled.

Do I have to enable attachment thumbnails in posts for the album to work?

If so, is there another way to get it to work because I want the regular sized pics in the posts, not thumbnails?

Hello I Fond the problem.
Look hier: https://vborg.vbsupport.ru/showpost....&postcount=432

You must install all Files, an alle Patches... inkl. Templates..

:-)

cu Deta

eblivion · #**449** 01-27-2005, 08:12 PM

Quote:

Originally Posted by deta

Hello I Fond the problem.
Look hier: https://vborg.vbsupport.ru/showpost....&postcount=432

You must install all Files, an alle Patches... inkl. Templates..

:-)

cu Deta

Thanks. I still couldn't get the images to load after redoing it. Ijustended up displaying the actual profile picture instead of thethumbnail by changing type=pthumb to type=profile in albumcp.php and the album_image_list template.

MustangLisa · #**450** 02-07-2005, 04:09 PM

Thanks, this is great. Everything installed fine, but the profile pics display as red X 's. How can I fix this? Thanks.

MissKalunji · #**451** 02-07-2005, 08:24 PM

Quote:

Originally Posted by MustangLisa

Thanks, this is great. Everything installed fine, but the profile pics display as red X 's. How can I fix this? Thanks.

theres a fix for that browse the msg board...theres a thread about it

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.09573 seconds Memory Usage 2,391KB Queries Executed 30 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (16)bbcode_php (9)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (16)post_thanks_box (16)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (16)post_thanks_postbit_info (15)postbit (16)postbit_onlinestatus (16)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!