@IcEcReaM:
I'm not an expert, but I think since the userpic field in the database is for strings, its better use userpic <> '' or NOT userpic in mysql queries
thanks, you are right.
i didn't noticed that,
cause i was working also on an similar mod where the userpic is an integer value,
and the file extension is saved seperatly.
I modified my post,
thanks for this hint.
P.S.: If this "mod" is working correctly,
you can post it if you want as an additional step/option in your first post.
A very old post I am quoting now, I know!
But I cannot get this thing working.
I have added the Member Personal Photo MOD and the Addon which shows random Members on the index. Now I only want to show members, who really HAVE uploaded a profilephoto.
I do not want the placeholder-text to show up.
It does not have any effect with
WHERE ".get_user_table_field("", "user_level")." >= '".USER."' AND userpic>= '0'
nor with
WHERE ".get_user_table_field("", "user_level")." >= '".USER."' AND userpic <> ''
Also: I cannot make the correct membername show up.
I almost always get a memberphoto with the WRONG membername below it.
I removed the user_name if/endif, but it would be really nice to HAVE it there!
Any idea what I have to do?