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.
* 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.
For future reference, any time you have more than one table accessed in a query, you must have each table AS table.
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.
Having a prob: everything works fine, with the exception of the actual profile pics in the member album and in the album cp. The images do not display. I rebuilt the album thumbnails.
The image src's are: /path/to/foum/image.php?u=2132&type=pthumb
When I visit that URL, I get a page which displays: Array