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.

[FleaBag]

I was thinking the same thing, but I couldn't say for sure.

[maddawg138]

nvm i forgot to clear my cookies and clean my cache...its fine now

[Dead End Society]

Originally Posted by Nordinho

Hello,

When I try to run the sql-queries, I get this error:


An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 ';
ALTER TABLE `customprofilepic` ADD comment varchar(255) NOT

Does anyone have an idea how to fix this??

Greets,

I solved this problem by executing each SQL command (line) separately, leaving out the semicolon. There's got to be an easier way, but oh well, it worked.

[nautiqeman]

Is there any way to change the fact that people can only upload just one?

[FleaBag]

OK so maybe I jumped the gun... I just get clear like images when users update their profile pictures... In the profile they show up fine, so it's something to do with the thumbnails I guess...

[Reeve of shinra]

hmmm I am getting an error where only red-x's show up. I rebuilt the thumbnails and while on that page, I click the link to a members thumbnail and it gives me an error saying that "http://www.shinraonline.com/board/image.php?u=1570&type=pthumb" cant be displayed because of errors. Any idea on what it refers to?

[Slynderdale]

Originally Posted by Reeve of shinra

hmmm I am getting an error where only red-x's show up. I rebuilt the thumbnails and while on that page, I click the link to a members thumbnail and it gives me an error saying that "http://www.shinraonline.com/board/image.php?u=1570&type=pthumb" cant be displayed because of errors. Any idea on what it refers to?

If you use vBulletin 3.0.3 try the fixes here:
https://vborg.vbsupport.ru/showpost....&postcount=320

[Boofo]

Has anyone come up with a way to send an pm or email to the Admin when someone uploads a pic that needs to be verified?

[Reeve of shinra]

Slynderdale -- thanks. I will check it out this weekend when I have a chance. I dont know how I missed that. :-p

[Slynderdale]

Originally Posted by Reeve of shinra

Slynderdale -- thanks. I will check it out this weekend when I have a chance. I dont know how I missed that. :-p

Remember to rebuild the thumbnails after you install the fixes in that file for them to show properly.

[HarryBO]

After 3 hours hard work, the Hack runs perfect!

Just one question? See the Screenshot!

Is there something missing?

[PitchouneN64ngc]

Have you executed all queries?

[HarryBO]

Yes, but I became an error message!

This part doesn?t work

INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9231, 0, 'settinggroup_vb3album', 'vB3 Member Album', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9232, 0, 'setting_album_perpage_title', 'Entries Per Page', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9233, 0, 'setting_album_perpage_desc', 'Specify how many entries will show for each page.', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9234, 0, 'setting_album_pertr_title', 'Entries Per Row', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9235, 0, 'setting_album_pertr_desc', 'Specify how many entries will show for each row.', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9236, 0, 'setting_album_approval_title', 'Require Approval', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9237, 0, 'setting_album_approval_desc', 'If selected, pictures will have to be approved via the AdminCP before visible by the public.', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9238, 0, 'setting_album_exempt_title', 'Exempted Usergroups', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9239, 0, 'setting_album_exempt_desc', 'If you have approval enabled, but would like specific usergroups to be exempt from it, then <u>in a comma separated list</u>, specify those usergroup IDs.', 5000);

[PitchouneN64ngc]

Try this:

[SQL]INSERT INTO `phrase` (`languageid`, `varname`, `text`, `phrasetypeid`) VALUES (0, 'settinggroup_vb3album', 'vB3 Member Album', 5000);
INSERT INTO `phrase` (`languageid`, `varname`, `text`, `phrasetypeid`) VALUES (0, 'setting_album_perpage_title', 'Entries Per Page', 5000);
INSERT INTO `phrase` (`languageid`, `varname`, `text`, `phrasetypeid`) VALUES (0, 'setting_album_perpage_desc', 'Specify how many entries will show for each page.', 5000);
INSERT INTO `phrase` (`languageid`, `varname`, `text`, `phrasetypeid`) VALUES (0, 'setting_album_pertr_title', 'Entries Per Row', 5000);
INSERT INTO `phrase` (`languageid`, `varname`, `text`, `phrasetypeid`) VALUES (0, 'setting_album_pertr_desc', 'Specify how many entries will show for each row.', 5000);
INSERT INTO `phrase` (`languageid`, `varname`, `text`, `phrasetypeid`) VALUES (0, 'setting_album_approval_title', 'Require Approval', 5000);
INSERT INTO `phrase` (`languageid`, `varname`, `text`, `phrasetypeid`) VALUES (0, 'setting_album_approval_desc', 'If selected, pictures will have to be approved via the AdminCP before visible by the public.', 5000);
INSERT INTO `phrase` (`languageid`, `varname`, `text`, `phrasetypeid`) VALUES (0, 'setting_album_exempt_title', 'Exempted Usergroups', 5000);
INSERT INTO `phrase` (`languageid`, `varname`, `text`, `phrasetypeid`) VALUES (0, 'setting_album_exempt_desc', 'If you have approval enabled, but would like specific usergroups to be exempt from it, then <u>in a comma separated list</u>, specify those usergroup IDs.', 5000);[/SQL]

[HarryBO]

Fehler

SQL-Befehl :  

INSERT INTO `phrase` ( `languageid` , `varname` , `text` , `phrasetypeid` ) 
VALUES ( 0, 'settinggroup_vb3album', 'vB3 Member Album', 5000 ) 

MySQL meldet: 


#1062 - Duplicate entry 'settinggroup_vb3album-0-5000' for key 2

Same as before!