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.

[engquist]

Now I've tried Slynderdale's fixes that were in that zip.

When I did that, I made all file chages again, then I got to the database part to do those changes again. I executed all those queries again (I assumed there were changes) and then it told me that they already existed so the query didn't finish or something.

so I ignored it. Then I finished the directions, and I still have red x's for pictures.

I decided I would try to re-upload my profile pic as a test. So I deleted in in my user CP, then I went to re-upload it and I got a database error something like this:

Database error in vBulletin 3.0.3:

Invalid SQL: 
			INSERT INTO customprofilepic
			(userid, profilepicdata, thumbnaildata, comment, visible, thumbnaildata, comment, visible, dateline, filename, filesize)
			VALUES


mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

can someone help me by giving me some sql queries I need to run so at least people can add profile pictures again without a database error, because I don't know any SQL.

thank you.

[paulmjno]

Having a prob: everything works fine, with the exception of the actual profile pics in the member album and in the album cp. The images do not display. I rebuilt the album thumbnails.

The image src's are: /path/to/foum/image.php?u=2132&type=pthumb

When I visit that URL, I get a page which displays: Array

[paulmjno]

Hm... I realise that this is yet another unsupported script... *uninstalling*

[Pseudomizer]

Originally Posted by paulmjno

Hm... I realise that this is yet another unsupported script... *uninstalling*

Before you unistall it please read the thread. Your problem has been asked 19223462346 times. RTFM.

Cheers,

[paulmjno]

Originally Posted by Pseudomizer

Before you unistall it please read the thread. Your problem has been asked 19223462346 times. RTFM.

Cheers,

Could you direct me to where the full fix is? And, why hasn't the zip file been updated with the fix?

I am using 3.0.3.

[Pseudomizer]

Originally Posted by paulmjno

Could you direct me to where the full fix is? And, why hasn't the zip file been updated with the fix?

I am using 3.0.3.

I would have to search on my own. Sorry. And the reason why it is not in the zip file is very easy... unsupported thread but great hack.

Cheers,

[paulmjno]

OK, I downloaded the zip file, and made the changes. Things are better, but not completely fine. For instance, most pics show... but a few dont. Also, the signature dates are set to 1970...

[mackers8923]

I'm getting nothing but Red "X's" where the images should be. Is there a fix for this or have I missed something?

[engquist]

Originally Posted by engquist

Now I've tried Slynderdale's fixes that were in that zip.

When I did that, I made all file chages again, then I got to the database part to do those changes again. I executed all those queries again (I assumed there were changes) and then it told me that they already existed so the query didn't finish or something.

so I ignored it. Then I finished the directions, and I still have red x's for pictures.

I decided I would try to re-upload my profile pic as a test. So I deleted in in my user CP, then I went to re-upload it and I got a database error something like this:

Database error in vBulletin 3.0.3:

Invalid SQL: 
			INSERT INTO customprofilepic
			(userid, profilepicdata, thumbnaildata, comment, visible, thumbnaildata, comment, visible, dateline, filename, filesize)
			VALUES


mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

can someone help me by giving me some sql queries I need to run so at least people can add profile pictures again without a database error, because I don't know any SQL.

thank you.

this is my issue if anyone can help ^^ *BUMP*

[Hades-1]

what i say is.....

finish this hack, or take it off this site.

its 100% im complete and probably just messing up most peoples boards.

I got this hack working as good as possible and it still sucks.

So i am removing it, what a waste.

[venomx]

This hack works fine for me.

[Natch]

Originally Posted by Hades-1

what i say is.....

finish this hack, or take it off this site.

its 100% im complete and probably just messing up most peoples boards.

I got this hack working as good as possible and it still sucks.

So i am removing it, what a waste.

And for me...

[Slynderdale]

This hack does work, if you look above, this hack was made for vB 3.0.0, any versions higher then that, your basicly installing it at your own risk. There has been several changes to vB 3.0.3 that breaks this hack. I included some fixes for it that worked on my 3.0.3 after a clean install.


If you have an old member gallery 1.1, theres a migrating tool here that lets you migrate your old album over to the new one:
https://vborg.vbsupport.ru/showpost....3&postcount=76

If you have vBulletin 3.0.3, do a clean install with these fixes I posted here:
https://vborg.vbsupport.ru/showpost....&postcount=320

After you made these changes, you will have to rebuild the thumbnails to get them to show without coming up as an error or a red x. After doing so, clear your browsers cache and refresh the page.

If you already installed this hack, but not my fix above, first install weasel's update here:
https://vborg.vbsupport.ru/showpost....&postcount=281

and then make the updates in the posts on this page or could do a fresh install with the fixed version above which is recommended:
https://vborg.vbsupport.ru/showthrea...&page=21&pp=15

Note: If you already ran the SQL queries, you don't have to do so again. Only file changes are needed to get this hack to work for 3.0.3. This isn't my hack, but Ill try to give limited support for 3.0.3 forums when I can. I was hit by a car in a hit and run incident the other day so I haven't been able to use the computer without being in some pain the past couple days.

[docvader]

Installed easily and working well on 3.03. Thanks very much!

rich
http://x.russbo.com/index.php

[MikaK]

Nice hack for the very purpose. I started installing this on 303 based on the original hack... Boy... I suffered tearing hair off my head... Untill I came a cross the 303 -fix.zip by Sly... err... something (too darn tired to remeber) + a comment by Boofo and the sun started to shine - and that made my day

Thanks!*installs*
-Mika-