Thread: Major Additions - Ultimate Media Gallery LITE
View Single Post
  #47  
Old 02-06-2009, 11:31 AM
Tophon Tophon is offline
 
Join Date: Jan 2009
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Coroner, very happy with this so far, great work.

Two things:

I have set up a public gallery and set permissions for guests to view images. It shows the main category (inc the thumbnail on the index) but cannot seem to view images in sub categories?
The permisions look ok that have been set but on the sub category, the option for unregistered and guests cannot be checked on the radio button? Any ideas?

Also, Ecards are disallowed but with permissions it still shows the option and on clicking it, it gives this error:

Code:
Invalid SQL:
SELECT 
	media.*,user.username,COUNT(comment.comid) AS ccount,
	ca.userid AS gallery,ca.title AS cattitle,ca.description AS catdescription,ca.rateit,ca.comments,ca.modcomm,cat.permission,
	ca.buddies,ca.friends,ca.timestamp,ca.password,ca.real_pass,ca.parentid 
	FROM umg_media AS media 
	LEFT JOIN umg_category AS ca ON (ca.catid=media.catid) 
	LEFT JOIN user AS user ON (user.userid=media.userid) 
	LEFT JOIN umg_comment AS comment ON (comment.mediaid=media.mediaid 
	AND comment.moderate=0 OR 
	IF(ca.userid=0, 
		(comment.moderate=1 AND
			(comment.mediaid=media.mediaid AND (1 OR 1) OR 
				(comment.mediaid=media.mediaid AND comment.userid=25) OR 
				(comment.mediaid=media.mediaid AND comment.userid=25 AND (64 OR 128 AND 25))
			)
		),
		(comment.moderate=1 AND 
			(comment.mediaid=media.mediaid AND (1 OR 1) OR 
				(comment.mediaid=media.mediaid AND comment.userid=25) OR 
				(comment.mediaid=media.mediaid AND comment.userid=25 AND (64 OR 128 AND 25)) OR 
				(comment.mediaid=media.mediaid AND 25 AND 256)
			)
		)
	)
) 
	WHERE media.mediaid=55
	
	GROUP BY media.mediaid;
Not so much a big deal as I guess normal reg users cannot see the ecard option, but thought I would bring it to your attention.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01092 seconds
  • Memory Usage 1,767KB
  • 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
  • (1)bbcode_code
  • (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