vb.org Archive - PhotoPlog: vBa CMPS Thumbs

Page 10 of 12

« First

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)

- - PhotoPlog: vBa CMPS Thumbs (https://vborg.vbsupport.ru/showthread.php?t=103839)

rickysaltzer

09-05-2007 05:53 AM

Quote:

Originally Posted by BrettMo (Post 1227165)

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

Code:

$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

09-19-2007 08:36 PM

Great hack - thank you!

applyimage

10-01-2007 08:34 PM

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

10-16-2007 12:17 AM

*Installed, thanks for the hack!

Digital Jedi

10-29-2007 06:19 AM

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

12-09-2007 05:45 PM

Installed - works great - thank you

Stile2

12-17-2007 07:29 PM

Great Mod!!

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

Thanks

"Clicked as Installed"
:D

maniacop

12-22-2007 09:26 PM

Quote:

Originally Posted by applyimage (Post 1350965)

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

01-10-2008 11:38 PM

Quote:

Originally Posted by maniacop (Post 1407115)

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

02-09-2008 08:04 PM

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?

All times are GMT. The time now is 12:51 PM.

Page 10 of 12

« First

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01459 seconds Memory Usage 1,740KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)bbcode_php_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: