View Single Post
  #205  
Old 08-17-2007, 07:08 PM
gldtn gldtn is offline
 
Join Date: Apr 2003
Location: US
Posts: 169
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by cellarius View Post
Hot fix, quick and dirty:

in geek-gallery-popup.php in/around line 219 replace
PHP Code:
$pages $db->query_first("SELECT count(id) total FROM $gallery_db$pp_prefix "photos WHERE userid=$userid "); 
with
PHP Code:
$pages $db->query_first("SELECT count(id) total FROM $gallery_db$pp_prefix "photos WHERE userid=$userid and storeid=0 "); 
and in/around line 228 replace
PHP Code:
WHERE images.userid=$userid and images.approved=1 ORDER BY images.date DESC LIMIT $start ," . ($perpage); 
with
PHP Code:
WHERE images.userid=$userid and images.approved=and images.storeid=0 ORDER BY images.date DESC LIMIT $start ," . ($perpage); 

No guarantee whatsoever, works well for me.

HTH,
cellarius
I've gotten this to work somewhat with vBGallery v2.3 and vB3.6.8 by downloading jluerken provided geek-gallery-popup.php. Since I use vBGallery the above mod didn't work so I just followed your idea for the "vba" queries, which it's similar to what you did by default.

I replaced:
Code:
WHERE images.userid=$userid and extension in ($media_ext) $catwhere ORDER BY dateline DESC LIMIT $start ," . $perpage ;
With:
Code:
WHERE images.userid=$userid and images.catid=$catid and extension in ($media_ext) $catwhere ORDER BY dateline DESC LIMIT $start ," . $perpage ;
In which the and images.catid=VALUE did no really matter what I put there.

In my gallery I only have one main category and the rest is all sub-cats which works fine with what I added to the code since I hard coded in the popup options?data dir to /files/1 cause I can't get the code to count the different dirs within it. So if you have multiple Main Cats this would problem still show up with images as they weren't there since it's looking in the wrong dir.

Does anyone have a fix for this? Everything else works fine

I hope the above makes since! :P
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01551 seconds
  • Memory Usage 1,782KB
  • 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
  • (4)bbcode_php
  • (1)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