PhotoPlog: vBa CMPS Thumbs

Purpose: add PhotoPlog random thumbs to vBa CMPS in horizontal/vertical form.

Requirements: both PhotoPlog Lite v.1.0.7+ and vBadvanced CMPS are required.

Fine Print: no redistribution, copyright retained in full, right reserved to uncheck support box.

Sorry, no screenshot provided. Imagine some horizontal or vertical thumbs.

Fun Fact: there were 209 downloads and 37 installs at the time this add-on was last updated.
Fun Fact: there were 644 downloads and 112 installs at the time this add-on was last updated.

[rickysaltzer]

Originally Posted by BrettMo

Some help with some SQL please...

I want to exclude a few galleries from showing up in the thumbs on my home page. How would I change the SQL to not pull pics from them? Thanks.

Current SQL:

PHP Code:

$photoplog_file_infos = $db->query_read("SELECT *
                        FROM photoplog_fileuploads
                        WHERE moderate = 0
                        ORDER BY RAND()
                        LIMIT 4 


If you want to use a static Image, start by going to where the image is located using PhotoPlog, look at the URL , you'll notice at the end it says "n=x" x being the fileid #.

So, I just modified the SQL query to get only that image. Here is what I got

$photoplog_file_infos = $db->query_read("SELECT *
						FROM photoplog_fileuploads
						WHERE fileid = 4

4 being the x that was in my URL.

Hope this helps

[JadedSouls]

Great hack - thank you!

[applyimage]

Installed! fantastic!

Is there a way to direct my url www.applyimage.co.uk/forum to the new CMPS page(http://www.applyimage.co.uk/forum/home.php)?

[JimmyJames]

*Installed, thanks for the hack!

[Digital Jedi]

I realize that this mod is marked as unsupported, but does anyone happen to know why the thumbs are superseding the page thier on as the location on Who's Online? What I mean is, when viewing the index page, Who's Online shows it as "Viewing Photoplog" and then puts the direct URL to one of the thumbs. It this a problem with the mod or something else? If it matters, my CMPS is also my index page and the forums are not located in a subfolder.

[beanymonster]

Installed - works great - thank you

[Stile2]

Great Mod!!

Exactly what I was looking for, and easy to do.

Thanks

"Clicked as Installed"

[maniacop]

Originally Posted by applyimage

Installed! fantastic!

Is there a way to direct my url www.applyimage.co.uk/forum to the new CMPS page(http://www.applyimage.co.uk/forum/home.php)?

I have a question, how did you add the random pics bar on top of your forum home??

[applyimage]

Originally Posted by maniacop

I have a question, how did you add the random pics bar on top of your forum home??

I can't remember atall =/ better asking here: http://www.photoplog.com/

[Caerydd]

Anyone know how to filter by category?

On different areas of my vba, I'd like to pull images from different categories, e.g. images from Activity A with the area about Activity A, and images from acitvity B with area about activity B?