Calling the photo outside the forum software
PHP/mySQL is a hobby and not a profession. I've written a nice little site for a league I belong to with a custom database and using PHP and queries I can pull stats down and display them. The site has really grown over the years. I've always wanted to add a section for logged in people to upload photos and adjust profile but being conscious of security and of my lack of skill I never created this feature. I recently installed Vanilla forums and it easily fit into my site. I have been able to construct pages that pull up a vanilla user ID and a user ID from my database and display information from both databases. I spent a while on the photo when I realized the IMG src is different than the file name and I’ve discovered this is due to some kind of algorithm that I won’t be able to understand. I would like to be able to hook into this somehow or disable it. In effect, I want to be able to write a select statement against the vanilla database (using a connection file I created) and grab the photo URL – then take that and correctly display the photo. I did a bunch of searches but haven’t found much information. I was hoping someone could point me in the right direction. I played around with the XML and indeed there is a photo URL there but it goes to a very small copy of the photo (thumbnail). If I could get this to show the right photo I might be able to parse the xml and grab that value.