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.

[Christine]

Originally Posted by Pseudomizer

- where is the link to this new gallery ? Is this not in the modifications ? Do i have to manually edit my navbar to add the link to album.php ?

Yes, so that you can customize it to your forums. Here is the code I used -- but I am restricting the album to members only. If you don't want to restrict that, take out the conditional.

PHP Code:

Add phrase: 
   
   Global
   album
   Album
   
   In Navbar, find:
   
 <td class="vbmenu_control"><a href="memberlist.php?$session[sessionurl]">$vbphrase[members_list]</a></td>
   
   Below it add:
   
   <if condition="$show['member']">
     <td class="vbmenu_control"><a href="album.php?$session[sessionurl]">$vbphrase[album]</a></td>
   </if> 


- when i go to my control panel ( normal user ) and i try to upload a file larger then 100x100 it rejects it. How do i set the size for the pictures ? I searched through all admin settings, but i did not find it.

This is tied into the Attachment thumbnail setting.

That is in Options > Message Attachment Options > Thumbnail Size

[Christine]

Speaking of permissions, if anyone is interested in tying the permissions on the album to the memberlist security field, just add this to album.php:

PHP Code:

Find:

$perpage = $vboptions['album_perpage'];
$pertr   = $vboptions['album_pertr'];

Under it, add:

// permissions check
if (!($permissions['forumpermissions'] & CANVIEW) OR !($permissions['genericpermissions'] & CANVIEWMEMBERS))
{
    print_no_permission();
} 


[Boofo]

Originally Posted by Christine

Bob,

I have all of mine set to the approx. dimensions above for displaying in rows of 3 for 800x600 resolution.

I have my thumbnails set at 150 width right now. But what is a good size to allow the propfilepic so it isn't too small but not too large for the profile itself? There it will show full size.

[calvinnguyen]

Originally Posted by Velocd

vB3 Member Photo -> Options is what I meant.

Is the images per page value set?

Try editing your album.php, and under where it says:

PHP Code:

$perpage = $vboptions['album_perpage']; 


Place:

PHP Code:

echo $perpage; 


And see if there is any output.

Still the same problem
Warning: Division by zero in /home/vietmyen/public_html/album.php on line 151

Warning: Division by zero in /home/vietmyen/public_html/includes/functions.php on line 1707



There seems to have been a slight problem with the Vietmyen Net database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 3.0.0:

Invalid SQL:
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,

mysql error: 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 '' at line 9

mysql error number: 1064

Date: Monday 12th of April 2004 10:55:27 PM

[Pseudomizer]

Hello Christine,

thanks for all your answers. Point 1: This is fine. 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 ? This would make more sense if you already are tying it to memberlist.

Point2: I tried to set it to 200 and rebuild the attachment update counters and i tried to set it to 500 and updated the attachment counters. It is STILL 100x100. Something is going wrong here. Any idea why ?

Cheers,

Pseudomizer

[Christine]

Hi Pseudomizer,

I have it tied to the permissions, but set as a seperate link for navigation. Sure, you can change that, and with all the links I have going on up there now, I may look at that myself!

As far as the rebuild -- you need to run the rebuild function in the vB3 Member Album > Approve Images section as the attachment rebuild is for the attachment table.

[Pseudomizer]

Hi Christine,

i fully understood what you mean but it does not work. After installing all the modifications, templates and uploads my "Approve Images" section is completly empty. Only if i upload one image which is less than 100x100 pixel in my control panel, i get the options in the "Approve Images" section to rebuild the profile picture thumbnails. I could live with that but here is the problem now:

Member attachment options -> Thumbnailsize -> 500
Maintenance -> Update Counters -> Message Thumbnails > Rebuild done
vB3 Member Album -> Approve Images -> Rebuild profile picture thumbnails done

Now if i try to upload any image i still have the damn restriction of 100x100 pixel. Why ? Where is the error ?

Cheers,

Pseudomizer

[Velocd]

Pseudo, you have the thumbnail sizes confused with the actual profile picture size.

As I mentioned on the first page of this thread to Vivi Ornitier, to change the profile image dimensions, you have to edit usergroups. Each usergroup has its own defined size.

https://vborg.vbsupport.ru/showpost....4&postcount=14

[Pseudomizer]

Perfect. Thank you so much. Sorry for being unable to find that error in previous messages. A small hint in the instructions would save you a lot of time answering these kind of requests. :-)

But good work, nice hack. I will try to convert my existing pictures from your old member photo gallery hack into this new hack because all old database entries are still there.

Cheers,

Pseudomizer

[Velocd]

Still the same problem
Warning: Division by zero in /home/vietmyen/public_html/album.php on line 151

Warning: Division by zero in /home/vietmyen/public_html/includes/functions.php on line 1707

Calvin, what I asked before was if placing echo $perpage; below $perpage = $vboptions['album_perpage'] outputted anything to the screen? My answer wasn't a direct solution.

I took a datadump of the customprofilepic table and uploaded it to my test server, deleted the thumbnaildata field all together, and then readded the field under profilepicdata.

I then reset thumbnails to 175 and attempted to resize, and it locked up here:

albumcp.php?do=rebuildthumbs&startat=21&perpage=20

With the thumbnaildata field cleared, it ran through the first 20 pics just fine, but then kept cycling back through startat=21&perpage=20.

I opened another browser program and set the URL for startat=41&perpage=20 to see if I could maybe skip over any problem pics, but it wouldn't take that -- it just refreshed itself to 21 & 20 and kept cycling though those over and over again.

All of the photos are .jpg format, and all original sizes are as mentioned.

If I add a new photo with the 175 limit, it also works fine - it is just trying to change them once they have been added and the limit is changed after that time.

This has me baffled.

This likely has to do with the $perpage value in albumcp.php, and some weird bug.

I don't have a lot of time to debug it now, but one troubleshooting solution I can provide is to erase the $perpage chunk of code, and re-generate all thumbnails in one process.

I've attached a customized albumcp.php that does just this. Be sure to rename it albumcp.php to use it. If it still doesn't work, and locks up, then there might be a problem with the actual GD-image handling functions. (although I sort of doubt it)

[calvinnguyen]

Originally Posted by Velocd

Calvin, what I asked before was if placing echo $perpage; below $perpage = $vboptions['album_perpage'] outputted anything to the screen? My answer wasn't a direct solution.

There is nothing to the screen, whatever the screen it.

when I type: http://mydomain.com/album.php

I got error like as I report here.

[Velocd]

No errors occured when running the install.html queries? The value of $vboptions['album_perpage'] must be blank if nothing is outputting, which means the setting must not exist in the table.

Run this query from PhpMyAdmin, and show me the results.

[sql]SELECT * FROM setting WHERE varname='album_perpage'[/sql]

[calvinnguyen]

Here is the result that I attachment when I run
SELECT * FROM setting WHERE varname='album_perpage'

When I run album.php from my website I got number 18. That's it. I did't see anything else.

[gmarik]

2-3 pics would be even betterm why not?

[Velocd]

Review the thread, I've already explained. I have a very tight schedule with college, my job, and other coding projects, therefore don't have time to spend for "add-ons" to my hacks released at vBulletin.org.