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.

[Marco van Herwaarden]

Change the line:

PHP Code:

FROM " . TABLE_PREFIX . "customprofilepic 
LEFT JOIN " . TABLE_PREFIX . "user 


to:

PHP Code:

FROM " . TABLE_PREFIX . "customprofilepic AS customprofilepic
LEFT JOIN " . TABLE_PREFIX . "user AS user 


[osariase]

Hi Marco,
after doing what you told me to do I think it fixed it but I cant see pictures on the admin cp and there is no link to the photo album. Do you think there is something I missed? Please advise

thanks for your help

[Marco van Herwaarden]

Just double check the instructions, or wait for the help of the coder.

Sorry i don't have this hack installed myself, so a bit difficult to help you more.

[osariase]

Hi VeloCD,
I have a problem with this hack, the problems keep shifting. I have installed and reinstalled this hack and I was able to see the admincp controls but I only have two options there, 1 is options and the 2nd one is verify pictures. I don't see anything else. When I click on the album link on the navbar i get an error message, please click below to see error message:

http://www.naijaworld.com/album.php


I would really appreciate it if you could help me, everybody seems to have it working except for me.

thanks

[osariase]

Hi all,
anyone here that have used this hack on vb3 successfully, please send me instructions on how to get this thing setup. I will really appreciate it, since he owner of the hack has suspended all support for the hack.

Anyone who think they can help me this hack please contact me at ozinetdot@yahoo.com

I get this error message whenever i try to run the queries requested in step #33, below is the error message

Error
SQL-query:

ALTER TABLE `customprofilepic` DROP PRIMARY KEY
MySQL said:

#1146 - Table 'naijawor_testvbdb.customprofilepic' doesn't exist


I have been getting this error message and I don't know what to do with it. If I am understanding this currectly it is saying customprofilepic doesn't exist which is true, but I do have something else

vb3_customprofilepic.

I am not sure if I should edit the query to match what I already have anyone please help thanks

I will appreciate it

[Marco van Herwaarden]

Seems you are using a table prefix and the hack script on't support that here. Edit the file and put your table prefix in fron of the table names.

[boeserwolf]

Does this hack work with the 3.07 too.

Not found a suitable answer here

yours

Markus

[MichaelJM13k]

Every time i try to install this hack i get an error:

Warning: Division by zero in /album.php on line 142
Warning: Division by zero in /includes/functions.php on line 1861

There seems to have been a slight problem with the xbimpulse.com forums 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.7:

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: Friday 06th of May 2005 12:38:22 AM
Script: http://www.xbimpulse.com/forums/album.php
Referer: http://www.xbimpulse.com/
Username: MY USERNAME
IP Address: MY IP

Could you help me please? :surprised:

[blueuniverse]

Funnily enough, I get exactly the same error. I'd appreciate any help you could give us.

[blueuniverse]

Can somebody help me reverse the queries. To be honest, I've spent ages on this, installing all the fixes and I still get the same errors. :S

The initial queries are

ALTER TABLE `customprofilepic` ADD thumbnaildata mediumtext NOT NULL AFTER profilepicdata;
ALTER TABLE `customprofilepic` ADD comment varchar(255) NOT NULL AFTER filename;
ALTER TABLE `customprofilepic` ADD disapproved smallint(5) not null default'0';
ALTER TABLE `customprofilepic` ADD reason varchar(100) not null;
ALTER TABLE `usertextfield` ADD sigdateline int(10) unsigned NOT NULL default '0';

ALTER TABLE `customprofilepic` DROP PRIMARY KEY;
ALTER TABLE `customprofilepic` ADD picture_id int(10) unsigned NOT NULL default '0' AUTO_INCREMENT PRIMARY KEY AFTER userid;

INSERT INTO `settinggroup` (`grouptitle`, `displayorder`, `volatile`) VALUES ('vb3album', 968, 0);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('album_perpage', 'vb3album', '18', '18', '', 10, 0, 0);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('album_pertr', 'vb3album', '3', '3', '', 20, 0, 0);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('album_approval', 'vb3album', '0', '0', 'yesno', 30, 0, 0);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('album_exempt', 'vb3album', '6,7,5', '6, 7, 5', '', 40, 0, 0);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9231, 0, 'settinggroup_vb3album', 'vB3 Member Album', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9232, 0, 'setting_album_perpage_title', 'Entries Per Page', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9233, 0, 'setting_album_perpage_desc', 'Specify how many entries will show for each page.', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9234, 0, 'setting_album_pertr_title', 'Entries Per Row', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9235, 0, 'setting_album_pertr_desc', 'Specify how many entries will show for each row.', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9236, 0, 'setting_album_approval_title', 'Require Approval', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9237, 0, 'setting_album_approval_desc', 'If selected, pictures will have to be approved via the AdminCP before visible by the public.', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9238, 0, 'setting_album_exempt_title', 'Exempted Usergroups', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9239, 0, 'setting_album_exempt_desc', 'If you have approval enabled, but would like specific usergroups to be exempt from it, then <u>in a comma separated list</u>, specify those usergroup IDs.', 5000);

[MichaelJM13k]

Yeah, this hack sucks.
We need support!

[dsboyce8624]

Velocd hasn't posted since last year, I doubt he'll be helping. Maybe sombody else could pickup the slack. I would love to use this, but I'm too noob-ish to do it without the chance of help.

Dennis

[dsboyce8624]

Originally Posted by MichaelJM13k

Yeah, this hack sucks.
We need support!

Yeah, there's a good way to get help.

[dsboyce8624]

Okay, I muddled through this. Of course I installed before I found there were fixes throughout the thread.

I found this link:

https://vborg.vbsupport.ru/showpost....&postcount=388

Which a mod should put up top and maybe replace the file to save some of us a bit of work.

I poked through the new file and if memory serves I found one difference which I edited in. Then I replaced the files.

I also noticed that if you paste all of the SQL lines in at once it errors, that's because they have CR/LF crap at the end of each line. Do them individually.

The only one I couldn't get was:

ALTER TABLE `customprofilepic` ADD picture_id int(10) unsigned NOT NULL default '0' AUTO_INCREMENT PRIMARY KEY AFTER userid;

Which (prolly screwed myself somehow) I removed "AUTO_INCREMENT PRIMARY KEY AFTER userid" from and it took. If somebody has a better way please post it. Or a way to fix what my change screwed up.

The only problem I have now is that my thumb nails aren't working. I clicked the rebuild and got the attached pic.

If you intend to install this please follow the link above first.

Now, suggestions on fixing my thumbs please?

EDIT: Actually, if somebody who does and somebody who doesn't have this installed could screen shot me the above mentioned table from MSQLAdmin I'd appreciate it.

EDIT: Okay, I created a test user and his thumb works. This one I don't understand.

EDIT: Okay, now I feel really stupid. After closing all windows everything works fine.

Go figure.

[Marco van Herwaarden]

You should have left the AUTO_INCREMENT in that statement, only remove the default value there.