Originally Posted by MPDev

Actually, if they are in seperate databases, as long as they share a common userid/password for access, you could just use the query:

SELECT pp_photos.id, pp_photos.title, user.userid, pp_photos.cat, pp_photos.approved, pp_photos.bigimage
FROM ppost_photos AS pp_photos
LEFT JOIN " . TABLE_PREFIX ."user AS user ON pp_photos.userid = user.userid

and add in a tablename before the ppost_photos like:

photopostdb.ppost_photos

Then it would pull it from the other database without having to switch or combine dbs.

Originally Posted by MPDev

Actually, if they are in seperate databases, as long as they share a common userid/password for access, you could just use the query:

SELECT pp_photos.id, pp_photos.title, user.userid, pp_photos.cat, pp_photos.approved, pp_photos.bigimage
FROM ppost_photos AS pp_photos
LEFT JOIN " . TABLE_PREFIX ."user AS user ON pp_photos.userid = user.userid

and add in a tablename before the ppost_photos like:

photopostdb.ppost_photos

Then it would pull it from the other database without having to switch or combine dbs.

Originally Posted by Intex

Nice work sabret00the . Do you have any plans to release a vBadvanced CMPS module to show the last photo on the homepage? I think a lot of people would be interested in that.

Originally Posted by SVTBlackLight01

Thanks for the tip. I got it working, but for some reason the image is broken for just one member (that I have been able to see so far). The path isn't correct. It should be http://www.modernengineuity.com/gallery/data/500/468108_0841-thumb.JPG, but it's trying to find it in http://www.modernengineuity.com/gallery/data/503/468108_0841-thumb.JPG

Any ideas? :confused:

Originally Posted by Triple_T

this could be good, if members have the option to turn it off. I would also like it to be set off by default and only show avatar OR PP pic, not both.