[MOD] Member personal photo v1.1.3 by V@no (2011-10-23)

[V@no]

this mod does not support comments, u'll need do changes posted by graficalicus on second page.

[universal]

hm, but if it is possible to add a personal photo for guests, the problem (i think) will disapear.
So, is it possible? ;]

[ascanio]

Hi, I was looking the other day in the userp c folder the users that have upload their personal picture and I saw that the name of the pic is the same of the user id, is there any way to show a list of the profiles that have a personal pictures?

For example

Profiles with personal picture:

- user 1 --> link: http://www.yourdomain/4images/member.php?action=showprofile&user_id=1
- user 2 --> link: http://www.yourdomain/4images/member.php?action=showprofile&user_id=2
- user 3 --> link: http://www.yourdomain/4images/member.php?action=showprofile&user_id=3

It would something like the MOD that shows the Last users online. if u have any idea of what files i have to changes or any idea of what i should do or u know how to doit please tell me it is really important for me

[universal]

I still don`t get it...
Look at comments: http://www.pramoga.net/details.php?image_id=2522
Picture is supported perfectly, but one problem guests overtakes photo of previuos registered member.
Any suggestions how to add a photo to guest?

this mod does not support comments, u'll need do changes posted by graficalicus on second page.

[V@no]

I've added Step 10 - 13
try and see if it works. (I didnt not test those changes )

[universal]

great!! it works. thanks ;]

[universal]

by the way, can I somehow show picture in the header? My login box is in the header...

[graficalicus]

you *should* be able to use {userpic} in the header, wherever you want it - - - try it and see (didn't test it either  )

[universal]

I tried, no luck ;]
cant get id of image I think, because link to img not finished. .../

[graficalicus]

cant get id of image I think, because link to img not finished. .../

what is it looking for?  what path?  You may be able to use {userpic_img} instead, as in member_profile.html

Step 12
This steps 12 - 13 are required if you would like show members photos in their comments.
Open details.php
Find:
Code:
$sql = "SELECT c.comment_id, c.image_id, c.user_id, c.user_name AS comment_user_name, c.comment_headline, c.comment_text, c.comment_ip, c.comment_date".get_user_table_field(", u.", "user_level").get_user_table_field(", u.", "user_name").get_user_table_field(", u.", "user_email").get_user_table_field(", u.", "user_showemail").get_user_table_field(", u.", "user_invisible").get_user_table_field(", u.", "user_joindate").get_user_table_field(", u.", "user_lastaction").get_user_table_field(", u.", "user_comments").get_user_table_field(", u.", "user_homepage").get_user_table_field(", u.", "user_icq").

"Replace it with:
Code:
  $sql = "SELECT c.comment_id, c.image_id, c.user_id, c.user_name AS comment_user_name, c.comment_headline, c.comment_text, c.comment_ip, c.comment_date".get_user_table_field(", u.", "user_level").get_user_table_field(", u.", "user_name").get_user_table_field(", u.", "user_email").get_user_table_field(", u.", "user_showemail").get_user_table_field(", u.", "user_invisible").get_user_table_field(", u.", "user_joindate").get_user_table_field(", u.", "user_lastaction").get_user_table_field(", u.", "user_comments").get_user_table_field(", u.", "user_homepage").get_user_table_field(", u.", "user_icq").", u.userpic

V@no -  I've added the "paging in comments" MOD previously, so the above sql statement is commented out in my details.php.  Instead, I have

Code: [Select]

$sql = "SELECT c.comment_id, c.image_id, c.user_id, c.user_name AS comment_user_name, c.comment_headline, c.comment_text, c.comment_ip, c.comment_date".get_user_table_field(", u.", "user_level").get_user_table_field(", u.", "user_name").get_user_table_field(", u.", "user_email").get_user_table_field(", u.", "user_showemail").get_user_table_field(", u.", "user_invisible").get_user_table_field(", u.", "user_joindate").get_user_table_field(", u.", "user_lastaction").get_user_table_field(", u.", "user_comments").get_user_table_field(", u.", "user_homepage").get_user_table_field(", u.", "user_icq").$additional_sql."
gonna try in a bit to see if they work as well (I need to go through the code & see what it's looking for... )

Thanks for the cool addition!

[universal]

what i get

Code: [Select]

<img src="./data/userpic/" border=0>
I`m using it in user_logininfo.html
And user_logininfo.html is in header like that > {user_box}

[graficalicus]

OK - here's what I did (and it works great!)

for the sql statement I mentioned above - the one previously altered with the "paging in comments" MOD - I simply added

Code: [Select]

u.userpicimmediately after

Code: [Select]

c.comment_ip,so it now looks like this

Code: [Select]

$sql = "SELECT c.comment_id, c.image_id, c.user_id, c.user_name AS comment_user_name, c.comment_headline, c.comment_text, c.comment_ip, u.userpic, c.comment_date".get_user_table_field(", u.", "user_level").get_user_table_field(", u.", "user_name").get_user_table_field(", u.", "user_email").get_user_table_field(", u.", "user_showemail").get_user_table_field(", u.", "user_invisible").get_user_table_field(", u.", "user_joindate").get_user_table_field(", u.", "user_lastaction").get_user_table_field(", u.", "user_comments").get_user_table_field(", u.", "user_homepage").get_user_table_field(", u.", "user_icq").$additional_sql."

basically, the only thing added to the sql statement is the "u.userpic, " part - which can be added anywhere inside that blurb. MAKE SURE YOU MATCH THE "," SEQUENCE ALREADY PRESENT. If you manage that, you're good to go.

for use in header.html, I'll mess with it - - unless someone else jumps in first.

many thanks again - this is easier (I think, anyway) to implement than the avatar MOD - and works just as well.

[ascanio]

Hi, it was really cool that modification V@no! I really like it. I have a question about it, like in the MOD where you can select the sex of the user, and when you installed it you need to put all the user by default male writing some comands on phpmyadmin is there any way to put this images by default to the users that don't have personal picture?

[V@no]

ascanio, yes, u can...the easiest and the fastest way without modifying any code is add path to that image into each member's profile, who doesnt have any personal photo.
Did I just hear someone said "Are you out of your mind? You call that the fastest way???"
Well, it is, through your favorite mysql manager (phpmyadmin)
Here is the mysql query that u need execute

UPDATE 4images_users SET userpic = 'noimage.png' WHERE userpic = '';
ALTER TABLE 4images_users CHANGE userpic userpic VARCHAR( 255 ) DEFAULT 'noimage.png' NOT NULL

it will use  data/userpic/noimage.png image (u can name it whatever u want, just update the name in the mysql query).

P.S. the second line is changing the structure of the userpic field, so u dont have to run this query for each new member on your site

[ascanio]

so if i run that query it will no replace the pics of the users that have personal photo rigth? just the ones that don't ?