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.

tobkat · #**392** 12-18-2004, 11:46 AM

I've installed the Hack successfully and it seems to work. I tried to upload a picture with the admin account but the picture won't show up in the album. the name "admin" is displayed but there is no picture beside it. help, anyone ?

tobkat · #**393** 12-18-2004, 03:41 PM

Quote:

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:

Code:

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.

Same Problem here....

Boofo · #**394** 12-18-2004, 05:40 PM

Quote:

Originally Posted by tobkat

Same Problem here....

List that whole query and maybe we can look at it. What are the values?

boo.3 · #**395** 12-26-2004, 04:50 PM

ok for the GD Graphics Library how do i know if i have it?

PitchouneN64ngc · #**396** 12-26-2004, 06:09 PM

Quote:

Originally Posted by boo.3

ok for the GD Graphics Library how do i know if i have it?

View your phpinfo if it says "GD" inside

MajorFm.com · #**397** 12-31-2004, 11:48 AM

Im gettin a small error...

When i rebuild the thumbs, it displays the list on a white page without any styles and then goes stagnant, nothing happens...

And the images are not showing...

www.majorfm.com/forum/album.php

MajorFm.com · #**398** 12-31-2004, 01:37 PM

Quote:

Originally Posted by Slynderdale

In vBulletin 3.0.3 the thumbnail code changed a bit so invalid thumbnails were made.

If you already installed this hack and Weasel's update:
( Weasles update can be found here: https://vborg.vbsupport.ru/showpost....&postcount=281 )
In the file path/to/forums/includes/functions_upload.php, find

PHP Code:


			
      if ($thumbnail)

       {        

         $image['update'] = ", thumbnaildata = '". $DB_site->escape_string($thumbnail)."'";

           $image['insert'] = "'".$DB_site->escape_string($thumbnail)."',";

Replace that with:

PHP Code:


			
      if ($thumbnail)

       {        

           $image['update'] = ", thumbnaildata = '$thumbnail'";

           $image['insert'] = "'$thumbnail',";

and then in admincp/albumcp.php find:

PHP Code:


			
         $DB_site->query("

             UPDATE " . TABLE_PREFIX . "customprofilepic

             SET thumbnaildata = '" . $DB_site->escape_string($thumbnail) . "' 

             WHERE picture_id = $image[picture_id]

         ");

and replace it with:

PHP Code:


			
         $DB_site->query("

             UPDATE " . TABLE_PREFIX . "customprofilepic

             SET thumbnaildata = '$thumbnail' 

             WHERE picture_id = $image[picture_id]

         ");

I did these changes, still no luck... also... the link for Weasel's update seems to be a fresh install, which means i can't actually follow it as its asking me to find and replace items that have already been replaced...

I know this hack/thread is kinda old now... but i hope someone can help.

boo.3 · #**399** 01-03-2005, 02:45 PM

ok i get this error and don't know why..

when you say run the querys.. i see it has space in some do u run the "3" or all of them 1 at a time? i ran 1 at a time

Code:

Warning: Division by zero in /home/*******/public_html/forums/album.php on line 142

Warning: Division by zero in /home/*****/public_html/forums/includes/functions.php on line 1730

any idea what i did wrong?

Pseudomizer · #**400** 01-03-2005, 03:03 PM

Quote:

Originally Posted by boo.3

ok i get this error and don't know why..

when you say run the querys.. i see it has space in some do u run the "3" or all of them 1 at a time? i ran 1 at a time

Code:

Warning: Division by zero in /home/*******/public_html/forums/album.php on line 142

Warning: Division by zero in /home/*****/public_html/forums/includes/functions.php on line 1730

any idea what i did wrong?

This has been handled already in this thread ( if i am not wrong ).

Cheers,

MajorFm.com · #**401** 01-03-2005, 11:54 PM

any help with me...?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.12543 seconds Memory Usage 2,334KB Queries Executed 25 (?)
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 (3)bbcode_code (4)bbcode_php (5)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 (2)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)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!