View Single Post
  #14  
Old 09-26-2005, 05:36 PM
Zachariah's Avatar
Zachariah Zachariah is offline
 
Join Date: Feb 2002
Location: Canoga Park, CA
Posts: 2,125
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Wayne Luke
Can we exclude galleries by ID?

Plugin - Forumhome: Gallery Main

Try this:

Find:
Code:
     $getrand =   $db->query_read("  
                SELECT imageid, images.title, filename, thumbname, originalname, extension, images.catid $query[fields]  
                FROM " . TABLE_PREFIX . "adv_gallery_images AS images  
                $query[tables]  
                WHERE $privcatids valid = 1 $ignquery  
                ORDER BY $galleryorderby   
                LIMIT $galleryimagelimit 
        ");
Replace
Code:
$getrand =   $db->query_read("  
                SELECT imageid, catid, images.title, filename, thumbname, originalname, extension, images.catid $query[fields]  
                FROM " . TABLE_PREFIX . "adv_gallery_images AS images  
                $query[tables]  
                WHERE $privcatids valid = 1 $ignquery  
                AND catid in (1,2,3,4,5,6,7,8,9)
	       ORDER BY $galleryorderby   
                LIMIT $galleryimagelimit 
        ");
The RED can be filled in by Cat ID's

Quote:
Originally Posted by dbembibre
No, is based in gallery permissions
True, but limits of cats is handy to promote ideas you wish to convay to the plublic vs. random all cats.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01690 seconds
  • Memory Usage 1,765KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code
  • (2)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete