Version: 1.00, by Velocd
Developer Last Online: Nov 2023
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.
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
Quote:
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);
Hi Guys,
I am still struggling with this hack, but i'm making head way, my latest issue is the error that I am getting when i click on upload picture, below is the error message i receive:
Parse error: parse error, unexpected '{' in /home/naijawor/public_html/includes/functions_upload.php on line 448
can someone please tell me how to fix it, I am not good with this code
Hi Guys,
I am still struggling with this hack, but i'm making head way, my latest issue is the error that I am getting when i click on upload picture, below is the error message i receive:
Parse error: parse error, unexpected '{' in /home/naijawor/public_html/includes/functions_upload.php on line 448
can someone please tell me how to fix it, I am not good with this code
Marco, you are the man please help thanks man
Open the file and go to that line. Compare any changes you made to what the instructions say. You probably have a stray bracket that should have been part of the edit.
Hi Guys,
I am still struggling with this hack, but i'm making head way, my latest issue is the error that I am getting when i click on upload picture, below is the error message i receive:
Parse error: parse error, unexpected '{' in /home/naijawor/public_html/includes/functions_upload.php on line 448
can someone please tell me how to fix it, I am not good with this code
Marco, you are the man please help thanks man
Oops sorry, i missed your reply. Still need help on this?
PS Better send me a PM, or i might miss your reply again.