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.

Onkel_Tom · #92 04-23-2004, 06:42 PM

Okay, I think I'm too stupid to understand the hack...
Now the right pictures are shown in admincp but only with 100 Pixel instead of 200. Also in album.php the pictures are still 100 pixel...

Pseudomizer · #93 04-23-2004, 08:15 PM

Quote:

Originally Posted by Onkel_Tom

Okay, I think I'm too stupid to understand the hack...
Now the right pictures are shown in admincp but only with 100 Pixel instead of 200. Also in album.php the pictures are still 100 pixel...

Hello Onkel_Tom,

just a question. This hack is for version 3.0.0 from VBulletin. Your board is running 2.3.5 ( yes, i just registered there ;-) ). Are you in the process of upgrading ?

If not, there is a version for 2.3.x VBs out.

How long does it take until a member gets full status on your site ?

Cheers,

Onkel_Tom · #94 04-23-2004, 09:30 PM

I have more than one board

It depends on the admins how long the activation needs, I will have a look in 2 Minutes...
The board for the Hack is a vB3.0.1 !

Pseudomizer · #95 04-23-2004, 09:35 PM

Quote:

Originally Posted by Onkel_Tom

I have more than one board

It depends on the admins how long the activation needs, I will have a look in 2 Minutes...
The board for the Hack is a vB3.0.1 !

Oh. Ok. Do you have ICQ ? It would make this much more easier. My number is in my profile.

Cheers,

Christine · #96 04-23-2004, 11:03 PM

I am attaching a file with 3 minor add-ons for anyone interested.

Included:

1. Ties the album viewing permissions to the memberlist viewing permissions
2. Adds the ability to add/update the photo with a comment in the Admin CP
3. Adds the ability to add/update the photo with a comment in the Mod CP

Thanks again, Velocd -- my members LOVE the album!!

Christine · #97 04-24-2004, 03:56 PM

Quote:

Originally Posted by Pseudomizer

Now i will add a link to my menu, but after reading your second answer with the permissions how about addind this to the memberlist as a pop-up like the search button ?

I really liked this idea, as adding the donations link for subscriptions is making Navbar a bit crowded.

Attached is a template mod for Navbar that will put the Memberlist and Velocd's album into a dropdown menu like QuickLinks is, with a fallback for those who can't view the JS.

Boofo · #98 04-24-2004, 06:11 PM

Quote:

Originally Posted by Christine

I really liked this idea, as adding the donations link for subscriptions is making Navbar a bit crowded.

Attached is a template mod for Navbar that will put the Memberlist and Velocd's album into a dropdown menu like QuickLinks is, with a fallback for those who can't view the JS.

What goes into the phrases? You have the titles for the phrases, but no content.

Christine · #99 04-24-2004, 06:18 PM

Quote:

Originally Posted by Boofo

What goes into the phrases? You have the titles for the phrases, but no content.

members and members_list are already there -- the only one that needs to be added is photo_album, unless I missed something, and if so, please let me know which ones!!

Boofo · #**100** 04-24-2004, 06:22 PM

Quote:

Originally Posted by Christine

members and members_list are already there -- the only one that needs to be added is photo_album, unless I missed something, and if so, please let me know which ones!!

You're right, my bad. I didn't look at it close enough. You didn't have Type, Varnme or Text there, it threw me off. Sorry about that.

welo · #**101** 04-25-2004, 08:20 AM

Installing on 3.0.1 and receive this error in albumcp.php?do=approve

Code:

Invalid SQL: 
		SELECT customprofilepic.*, user.username 
		FROM vb3_customprofilepic 
		LEFT JOIN vb3_user 
		USING (userid) 
		ORDER BY visible, username
	
mysql error: Unknown table 'customprofilepic'

mysql error number: 1051

This corresponds to line 56 of albumcp.php so for gits and shiggles I tried:

Code:

SELECT " . TABLE_PREFIX . "customprofilepic.*, " . TABLE_PREFIX . "user.username

...and it worked, except I got broken images in the ACP exactly like Bofoo was getting, and the MySQL 1064 error on album.php Calvin got.

Now you say ACP -> vB3 Member Photo -> Settings (which is actually 'Options') is the key, so I set entries per page from 18 to 12. Making progress. Now I get this error on album.php:

Code:

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, 12
	
mysql error: Unknown table 'user' in field list

mysql error number: 1109

Yet another table prefixing issue, right? This around line 193 in album.php, so now I have:

Code:

	$images = $DB_site->query("
		SELECT ".TABLE_PREFIX."user.userid, dateline, 
		comment, ".TABLE_PREFIX."user.username, ".TABLE_PREFIX."user.usertitle, 
		".TABLE_PREFIX."user.joindate, ".TABLE_PREFIX."user.usergroupid
		FROM ".TABLE_PREFIX."customprofilepic 
		LEFT JOIN ".TABLE_PREFIX."user USING (userid) 
		WHERE visible=1

Now it appears to be working. Beginning to look like you need to update a couple of files in your zip though.

welo · #**102** 04-25-2004, 08:31 AM

Oh, and everything for your sorting selectors in album.php neglects prefixes too:

Code:

	$users = $DB_site->query("
		SELECT ".TABLE_PREFIX."user.userid, ".TABLE_PREFIX."user.username, ".TABLE_PREFIX."user.usergroupid,
		".TABLE_PREFIX."user.usertitle, ".TABLE_PREFIX."usertextfield.signature, ".TABLE_PREFIX."usertextfield.sigdateline, 
		".TABLE_PREFIX."avatar.avatarpath, ".TABLE_PREFIX."user.avatarrevision, NOT ISNULL(".TABLE_PREFIX."customavatar.avatardata) AS hascustomavatar, 
		".TABLE_PREFIX."customavatar.dateline AS avatardateline 
		FROM ".TABLE_PREFIX."user 
		LEFT JOIN ".TABLE_PREFIX."usertextfield 
		USING (userid) 
		LEFT JOIN ".TABLE_PREFIX."avatar AS ".TABLE_PREFIX."avatar 
		ON(".TABLE_PREFIX."avatar.avatarid = ".TABLE_PREFIX."user.avatarid) 
		LEFT JOIN ".TABLE_PREFIX."customavatar AS ".TABLE_PREFIX."customavatar 
		ON(".TABLE_PREFIX."customavatar.userid = ".TABLE_PREFIX."user.userid) 
		WHERE ".TABLE_PREFIX."usertextfield.signature!=''$condition 
		ORDER BY " . ($sort == 'dateline' ? 'sigdateline' : $sort) . " $order 
		LIMIT " . ($minlimit-1) . ", $perpage
	");

welo · #**103** 04-25-2004, 09:14 AM

Okay, hate to be a pest but this one I'm not tracking down. For some reason whenever I update my profile picture info from UCP, I get an error (a VB error - not SQL) saying:

Quote:

There has been an error in the upload. Please ensure that the file has been correctly selected and that the upload has taken place successfully.

I assume this indicates a glitch either with profile.php or includes/functions_upload.php, but I'm sure not seeing it. I'm not trying to upload a pic btw, just trying to add a comment to it.

subu1 · #**104** 04-25-2004, 06:48 PM

verry nice Hack, i installed on vB3.0 Gold and i have an error by album.php

PHP Code:


			
Datenbankfehler in vBulletin 3.0.0:



Ungueltige SQL-Abfrage: 

        SELECT user.userid, dateline, 

        comment, user.username, user.usertitle, 

        user.joindate, user.usergroupid

        FROM customprofilepic 

        LEFT JOIN user USING (userid) 

        WHERE visible=1

         

        ORDER BY posts desc

        LIMIT 0, 18

    

mysql error: Unknown column 'comment' in 'field list'



mysql error number: 1054



Datum: 25.04.2004 21:46:36

Skript: [url]http://www.starlight-board.net/board/album.php[/url]

sorry i can't find my error, all queries are run

Pseudomizer · #**105** 04-25-2004, 06:58 PM

Quote:

Originally Posted by subu1

verry nice Hack, i installed on vB3.0 Gold and i have an error by album.php

PHP Code:


			
Datenbankfehler in vBulletin 3.0.0:



Ungueltige SQL-Abfrage: 

        SELECT user.userid, dateline, 

        comment, user.username, user.usertitle, 

        user.joindate, user.usergroupid

        FROM customprofilepic 

        LEFT JOIN user USING (userid) 

        WHERE visible=1

         

        ORDER BY posts desc

        LIMIT 0, 18

    

mysql error: Unknown column 'comment' in 'field list'



mysql error number: 1054



Datum: 25.04.2004 21:46:36

Skript: [url]http://www.starlight-board.net/board/album.php[/url]

sorry i can't find my error, all queries are run

Hello subu1,

there is no column 'comment' in the user table. Where is this query located and when do you get this error ? Seems something to be wrong with your source code. Did you check again if you implemented all the changes correctly ?

Cheers,

subu1 · #**106** 04-25-2004, 07:22 PM

..the query is locatet only in my profile.php

search:

PHP Code:


			
$profilepic = $DB_site->query_first("

            SELECT userid, dateline

            FROM " . TABLE_PREFIX . "customprofilepic

            WHERE userid = $bbuserinfo[userid]

        ");

replace it with:

PHP Code:


			
$profilepic = $DB_site->query_first("

            SELECT userid, dateline, comment, visible

            FROM " . TABLE_PREFIX . "customprofilepic

            WHERE userid = $bbuserinfo[userid]

        ");

        

        $profilepic['comment'] = fetch_censored_text($profilepic['comment']);

it's correct i don't have 'comment' in the user table

I thing i need a command for my User Table... INSERT INTO `User....only I do not know like

what can i do :nervous:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.10751 seconds Memory Usage 2,404KB 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 (5)bbcode_code (4)bbcode_php (8)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!