Great idea! I've not played with this hack, but I wonder why it needs database manipulation.
For example, my username is "James Cridland", which is a valid filename. A PHP routine like (from memory) if file_exists("/pictures/James Cridland.jpg") would be able to check whether there's a photo uploaded for me, surely?
Therefore, just a little bit of code to check whether my picture exists - and a thumbnail if you want those - could produce a little camera icon for the member or a message in their profile: and you don't have to touch your database...
James
|