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.

[welo]

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

	$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]

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:

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]

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]

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]

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

[Pseudomizer]

Hello subu1,

no, you don't need a column in the user table. The column should be located in your customprofilepic table.

Please try in the phpmyadmin or in mysql command line the following query and tell me what you get:

PHP Code:

SELECT userid, dateline, comment, visible FROM customprofilepic WHERE userid = '1'; 


Cheers,

[subu1]

Originally Posted by Pseudomizer

Hello subu1,

no, you don't need a column in the user table. The column should be located in your customprofilepic table.

Please try in the phpmyadmin or in mysql command line the following query and tell me what you get:

PHP Code:

SELECT userid, dateline, comment, visible FROM customprofilepic WHERE userid = '1'; 


Cheers,

ok I see that :disappointed:

Fehler

SQL-Befehl :

SELECT userid, dateline,
COMMENT , visible
FROM customprofilepic
WHERE userid = '1'
LIMIT 0, 30

MySQL meldet:


Unknown column 'COMMENT' in 'field list'

[Pseudomizer]

What do you get for:

PHP Code:

select * from customprofilepic limit 1; 


If you are missing comments, is the rest there ?

Cheers,

[subu1]

now I see this

[Pseudomizer]

Ok. The solution is easy:

You missed that line during the installation:

PHP Code:

ALTER TABLE `customprofilepic` ADD comment varchar(255) NOT NULL AFTER filename; 


Please do this command and all should work fine.

Cheers,