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.

highlander_RD · #**182** 06-18-2004, 10:33 PM

Quote:

Originally Posted by Pseudomizer

Ok. The reason why i asked was if you have seen my migration script from the old version to this new version. But you don't need it any more.

Cheers,

Maybe I don't... but many members likely need your hack, so I would suggest to publish this useful link anyway! ;D

Pseudomizer · #**183** 06-18-2004, 11:27 PM

Quote:

Originally Posted by highlander_RD

Maybe I don't... but many members likely need your hack, so I would suggest to publish this useful link anyway! ;D

Just read the first posting. It's already in there as 3-rd party add-on. I thought you missed that but in fact you don't need it. :-)

Cheers,

Photon · #**184** 06-19-2004, 12:49 AM

I've read this whole thread but I can't find the solution for my problem..

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

Warning: Division by zero in /usr/home/elimina/public_html/drive/forums/includes/functions.php on line 1707

Code:

Database error in vBulletin 3.0.1:

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

can someone help me??

Cypjaxion · #**185** 06-19-2004, 02:38 AM

Edit - nevermind, nevermind at all

highlander_RD · #**186** 06-19-2004, 07:31 AM

Quote:

Originally Posted by Photon

I've read this whole thread but I can't find the solution for my problem..

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

Warning: Division by zero in /usr/home/elimina/public_html/drive/forums/includes/functions.php on line 1707
can someone help me??

the problem is caused by LIMIT=0 in SQL.
In fact the SQL syntax in album.php is:

PHP Code:


			
    // Query: fetch profile pictures

    ////////////////////////////////////





    $images = $DB_site->query("

        SELECT user.userid, dateline, 

        comment, user.username, user.usertitle, 

        user.joindate, user.usergroupid, user.notescount

        FROM ".TABLE_PREFIX."customprofilepic 

        LEFT JOIN ".TABLE_PREFIX."user USING (userid) 

        WHERE visible=1

        $condition 

        ORDER BY $sort $order

        LIMIT " . ($minlimit-1) . ", $perpage

    ");

LIMIT is determined by the variable $minlimit in album.php that shouldn't give 0.
$minlimit is determined so:

PHP Code:


			
// Build page scope

///////////////////////





$pagenumber = $page > 0 ? $page : 1;



$rows = $result['count'];



$pages = ceil($rows / $perpage);



if ($pagenumber < 1)

{

    $pagenumber = 1;

}

else if ($pagenumber > $rows)

{

    $pagenumber = $rows;

}



$minlimit = ($pagenumber - 1) * $perpage+1;

$maxlimit = ($pagenumber) * $perpage;



if ($maxlimit > $rows)

{

    $maxlimit = $rows;

    

    $minlimit = $minlimit > $rows ? $rows-$perpage : $minlimit;

}



$minlimit = $minlimit <= 0 ? 1 : $minlimit;



$pagenav = construct_page_nav(

    $rows, 

    "album.php?$session[sessionurl]type=$_REQUEST[type]", 

    "&amp;pp=$perpage&ltr=$ltr&sort=$sort&order=$order"

);

maybe you need to change the setting perpage and rows?
Or better reinstalling the whole hack?
:-D

Martin64 · #**187** 06-21-2004, 12:54 AM

Great hack, this should be lots of fun. Feel free to link from our album from the first post:

http://www.emutalk.net/album.php?

Though at the moment I'm the only member with a profile pic, there should be more soon.

Cold Steel · #**188** 06-24-2004, 08:15 PM

Quote:

Originally Posted by Photon

I've read this whole thread but I can't find the solution for my problem..

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

Warning: Division by zero in /usr/home/elimina/public_html/drive/forums/includes/functions.php on line 1707

Code:

Database error in vBulletin 3.0.1:
 
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

can someone help me??

I got that error too. It was simple to fix.

Just go into your admincp and save your settings for the member album.

Cold Steel · #**189** 06-24-2004, 08:23 PM

I've got it running at http://forums.asiansinc.com/gallery.php

You can use mine as an example, if you want.

Cold Steel · #**190** 06-24-2004, 09:06 PM

Bug?

All of my signatures show this:

Last modified:
12.31.69, 07:00 PM

will_lean · #**191** 06-24-2004, 11:07 PM

Hi
just installed this on 3.0.1 and have a few questions.
My album seems to run fine however when i upload a picture there is no feild to add a comment,is the comment portion an addon or has it been added and i missed something?

great hack !

Cold Steel · #**192** 06-25-2004, 12:29 AM

Would this hack cause me to have this problem "File system directory is not writable. " when trying to upload attachments during normal posting operations? My attachments go into the file server, not the database.

Cold Steel · #**193** 06-25-2004, 05:02 AM

Well, I fixed that by chmodding everything in the attachments folder 777.

However if you check out http://forums.asiansinc.com/album.php sometimes the picture showing up in the album doesn't match with what shows up in the profile. Also, sometimes it replaced either the profile pic or the avatar -- I'm not sure which.

Onkel_Tom · #**194** 07-01-2004, 11:06 AM

updated to version 2.0, works great !
thanks you

Cold Steel · #**195** 07-01-2004, 06:40 PM

All the signatures show this:

Last modified:
12.31.69, 07:00 PM

And now I can't change my profile pic -- it always ends up as my avatar, although the album still shows my old profile pic.

Help, please.

buro9 · #**196** 07-02-2004, 07:02 AM

There's a pretty serious problem with your memberlist pages if you have installed this hack.

The hack changed the PRIMARY KEY on the customprofilepic table, and this causes a massive degradation in the speed of the query that memberlist.php uses.

What happens is documented in this thread along with the fix:
https://vborg.vbsupport.ru/showthread.php?t=66765

Note that the fix merely adds an index to restore it more closely to the vBulletin defaults by adding an index back to the table in place of the removed PRIMARY KEY.

I'm pretty furious about it though. IMO no hack should ever touch the vBulletin indexes and schema... they should only extend it. This hack broke that, and in turn created a hundred fold drop in performance of the regular vBulletin memberlist.php

This isn't the first time hacks have done dumb things, but this one was painful because of the 6+ seconds lock on the database table and the resulting performance drop elsewhere on the board.

Add the index back if you run this hack.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.07385 seconds Memory Usage 2,388KB Queries Executed 30 (?)
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 (2)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 (16)post_thanks_box (16)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (16)post_thanks_postbit_info (15)postbit (16)postbit_onlinestatus (16)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!