Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.0 > vBulletin 3.0 Full Releases

Reply
 
Thread Tools
vB3 Member Album 2.0 Details »»
vB3 Member Album 2.0
Version: 1.00, by Velocd Velocd is offline
Developer Last Online: Nov 2023 Show Printable Version Email this Page

Version: 3.0.0 Rating:
Released: 04-09-2004 Last Update: Never Installs: 100
 
No support by the author.



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

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #362  
Old 11-13-2004, 09:09 PM
PitchouneN64ngc's Avatar
PitchouneN64ngc PitchouneN64ngc is offline
Senior Member
 
Join Date: Aug 2002
Location: France
Posts: 515
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

No, this query was executed successfully during the first attempt (during the installation).

Try the other queries and see if all is ok after
Reply With Quote
  #363  
Old 11-13-2004, 09:13 PM
HarryBO HarryBO is offline
 
Join Date: Jan 2003
Posts: 68
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yor?re my personal Jesus! Big Thx that works!
Reply With Quote
  #364  
Old 11-14-2004, 08:29 PM
HarryBO HarryBO is offline
 
Join Date: Jan 2003
Posts: 68
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Argh! I´ve found some error again! When User Update there Pic, it would be changed in ACP! There´s ever there first postet Pic!
Reply With Quote
  #365  
Old 11-16-2004, 06:05 PM
Hades-1 Hades-1 is offline
 
Join Date: May 2004
Posts: 114
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

these ae my errors, i swear to god i tried eveythign inthis thread and nothing works, please help.

Invalid SQL:
SELECT customprofilepic.*, user.username
FROM vb3_customprofilepic
LEFT JOIN vb3_user
USING (userid)
ORDER BY username

mysql error: Unknown table 'customprofilepic'

ALSO

Warning: Division by zero in /home/rvadmin/public_html/x-six/V.3/VB3/album.php on line 142

Warning: Division by zero in /home/rvadmin/public_html/x-six/V.3/VB3/includes/functions.php on line 1730
Invalid SQL:
SELECT user.userid, dateline,
comment, user.username, user.usertitle,
user.joindate, user.usergroupid
FROM vb3_customprofilepic
LEFT JOIN vb3_user USING (userid)
WHERE visible=1

ORDER BY posts desc
LIMIT 0,

I even ran the entire installation again, someone help please
Reply With Quote
  #366  
Old 11-19-2004, 12:21 AM
ecarabin ecarabin is offline
 
Join Date: Oct 2004
Location: France
Posts: 10
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi all, here's my first post.

Thanx for this hack. ^_^

I'm trying to install it on my board, and it seems to work. ( I installed the fixed version for 3.0.3 )
The queries were successfully executed, the first look at the album was ok ...

But I have some troubles

* In the Admincp, I just get red crosses for new picture profiles that have to be approved

* In the album, some of new pictures are ok, but some just show red crosses. I dont really understand.

* When I try type2 ( should show signatures ) I get this error

Code:
Database error in vBulletin 3.0.3:

Invalid SQL: 
		SELECT user.userid, user.username, user.usergroupid,
		user.usertitle, usertextfield.signature, usertextfield.sigdateline, 
		avatar.avatarpath, user.avatarrevision, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, 
		customavatar.dateline AS avatardateline 
		FROM vb3_user 
		LEFT JOIN vb3_usertextfield AS usertextfield
		USING (userid) 
		LEFT JOIN vb3_avatar AS avatar 
		ON(avatar.avatarid = user.avatarid) 
		LEFT JOIN vb3_customavatar AS customavatar 
		ON(customavatar.userid = user.userid) 
		WHERE usertextfield.signature!='' 
		ORDER BY posts desc 
		LIMIT 0, 18
	
mysql error: Unknown table 'user' in field list

mysql error number: 1109
I don't understand, since the table vb3_user exists ?!

An idea please ? ^_^

( sorry if there are english mistakes, I'm french ).
Reply With Quote
  #367  
Old 11-24-2004, 12:11 PM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by ecarabin
Hi all, here's my first post.

Thanx for this hack. ^_^

I'm trying to install it on my board, and it seems to work. ( I installed the fixed version for 3.0.3 )
The queries were successfully executed, the first look at the album was ok ...

But I have some troubles

* In the Admincp, I just get red crosses for new picture profiles that have to be approved

* In the album, some of new pictures are ok, but some just show red crosses. I dont really understand.

* When I try type2 ( should show signatures ) I get this error

Code:
Database error in vBulletin 3.0.3:
 
Invalid SQL: 
		SELECT user.userid, user.username, user.usergroupid,
		user.usertitle, usertextfield.signature, usertextfield.sigdateline, 
		avatar.avatarpath, user.avatarrevision, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, 
		customavatar.dateline AS avatardateline 
		FROM vb3_user 
		LEFT JOIN vb3_usertextfield AS usertextfield
		USING (userid) 
		LEFT JOIN vb3_avatar AS avatar 
		ON(avatar.avatarid = user.avatarid) 
		LEFT JOIN vb3_customavatar AS customavatar 
		ON(customavatar.userid = user.userid) 
		WHERE usertextfield.signature!='' 
		ORDER BY posts desc 
		LIMIT 0, 18
 
mysql error: Unknown table 'user' in field list
 
mysql error number: 1109
I don't understand, since the table vb3_user exists ?!

An idea please ? ^_^

( sorry if there are english mistakes, I'm french ).
Try changing:

PHP Code:
 FROM vb3_user 
to

PHP Code:
 FROM vb3_user AS user 
Reply With Quote
  #368  
Old 11-24-2004, 12:59 PM
Hades-1 Hades-1 is offline
 
Join Date: May 2004
Posts: 114
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Slynderdale
Working out a couple bugs if you have it so attachments are saved to the file system and writing some code that lets you rebuild the album thumbnails.

Make my above fixes, that will fix images from being escapes twice. The image gets escaped already if you have it so your attachments are saved in the MySQL data base. This would cause errors with the thumbnails. The thumbnail doesn't get escaped when you save the files to the file system so this code fixes that and also fixes a small bug if theres an error with the thumbnail.


After you installed this hack and weasles fix,
find in path/to/forums/includes/functions_upload.php:
PHP Code:
      if ($type == 'profilepic')
      {
          require_once(
'./includes/functions_image.php');
          
          
$image['name'] = $upload_name;
          
$image['tmp_name'] = $filename;
          
          
$thumbnail fetch_thumbnail_from_image($image);
          
$thumbnail $thumbnail['filedata'];
  
         
// Display thumbnail error to admins in an attempt to cut down on support requests due to failed thumbnails.
         
if (!$thumbnail AND $imageerror AND $permissions['adminpermissions'] & CANCONTROLPANEL)
          {
             eval(
'$error = "' fetch_phrase($imageerrorPHRASETYPEID_ERROR) . '";');
              
$errors[] = array(
                 
'filename' => $attachment_name,
                  
'error' => $error
              
);
          }
      } 
and replace it with:
PHP Code:
    if ($type == 'profilepic')
      {
          require_once(
'./includes/functions_image.php');
  
          
$image['name'] = $upload_name;
          
$image['tmp_name'] = $filename;
  
          
$thumbnail fetch_thumbnail_from_image($image);
          
$imageerror $thumbnail['imageerror'];
      
$thumbnail $thumbnail['filedata'];
  
      if (
$vboptions['attachfile'])
      {
        
$thumbnail $DB_site->escape_string($thumbnail);
      }
  
         
// Display thumbnail error to admins in an attempt to cut down on support requests due to failed thumbnails.
         
if (!$thumbnail AND $imageerror AND $permissions['adminpermissions'] & CANCONTROLPANEL)
          {
             eval(
'$error = "' fetch_phrase($imageerrorPHRASETYPEID_ERROR) . '";');
              
$errors[] = array(
                 
'filename' => $attachment_name,
                  
'error' => $error
              
);
          }
      } 
The rebuilding of the album thumbnails code is almost done.

what do i do if neither of these codes are in functions_upload?

can someon post their functions_upload file for this hack?
Reply With Quote
  #369  
Old 11-24-2004, 12:59 PM
Pseudomizer's Avatar
Pseudomizer Pseudomizer is offline
 
Join Date: Mar 2002
Location: Germany
Posts: 614
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Hades-1
i hate you all

all people care about is themselves, everyone just ignores other peopls problems and posts and goes ahead and posts their own.

I could help but go to hell instead!!
Hello Hades,

[offtopic]
these are not nice words. If you would have read the thread you should have seen that the checkbox "supported" is NOT checked. If you install a hack where the author didn't check this box, you should not expect that people will run to help you. All people here are not paid for support.

So pleaes don't blame people here like this and calm down. ;-)
[/offtopic]

Try Bofo's hints because he is very experienced in coding.

Cheers,
Reply With Quote
  #370  
Old 11-24-2004, 01:11 PM
Hades-1 Hades-1 is offline
 
Join Date: May 2004
Posts: 114
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Pseudomizer
Hello Hades,

[offtopic]
these are not nice words. If you would have read the thread you should have seen that the checkbox "supported" is NOT checked. If you install a hack where the author didn't check this box, you should not expect that people will run to help you. All people here are not paid for support.

So pleaes don't blame people here like this and calm down. ;-)
[/offtopic]

Try Bofo's hints because he is very experienced in coding.

Cheers,
yeah i know and i did not mean the author.

it seems like people post a problem but it get burried by other people who dont even to read to see if its the same as theirs and they dont care, they dont care if you die they just want their album to work and i hate that.
Reply With Quote
  #371  
Old 11-24-2004, 04:08 PM
ecarabin ecarabin is offline
 
Join Date: Oct 2004
Location: France
Posts: 10
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

* Thank you Boofo ! now it works fine !
Merci beaucoup :-)

* Hades I did read all posts of this topic before posting.
Not answering you didn't mean I didn't care about your problem.
If I could have helped you ... I would have done it !
but I really don't know what to do !!
I even find my question stupid now that I see it was so easy ... :-(

So even if I go to hell, I wish someone could help you.

bye.
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:29 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05992 seconds
  • Memory Usage 2,342KB
  • 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
  • (2)bbcode_code
  • (4)bbcode_php
  • (4)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