Document Finder Template Problems

Thanks Jay,

We’ve noticed this too but are trying to avoid the manual process of un-categorizing everything that is uploaded. We would like a way to limit only certain vetted files to appear within the doc finder but also allow for users to upload files as part of their blog posts without those files showing up in the finder automatically.

Has anyone out there found a way to do this easily?

Best,

Nick

Update on this: I was able to get a temporary fix in place to limit media categories to our choosing. The ht-media-atoz plugin calls a main theme function get_terms_by_media_type (line 1201) which contains the actual SQL that returns the category list. I did a simple change to the SQL to only display category IDs we wanted to see:

I changed:

$query = “SELECT t.*, COUNT(*) as total from $wpdb->terms AS t INNER JOIN $wpdb->term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN $wpdb->term_relationships AS r ON r.term_taxonomy_id = tt.term_taxonomy_id INNER JOIN $wpdb->posts AS p ON p.ID = r.object_id WHERE p.post_status = ‘inherit’ AND p.post_type IN(‘”.join( “‘, ‘”, $post_types ).”‘) AND tt.taxonomy IN(‘”.join( “‘, ‘”, $taxonomies ).”‘) GROUP BY t.term_id order by t.slug”;

to:

$query = “SELECT t.*, COUNT(*) as total from $wpdb->terms AS t INNER JOIN $wpdb->term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN $wpdb->term_relationships AS r ON r.term_taxonomy_id = tt.term_taxonomy_id INNER JOIN $wpdb->posts AS p ON p.ID = r.object_id WHERE p.post_status = ‘inherit’ AND p.post_type IN(‘”.join( “‘, ‘”, $post_types ).”‘) AND tt.taxonomy IN(‘”.join( “‘, ‘”, $taxonomies ).”‘) AND tt.term_id IN ([ID1],[ID2],[ID3]) GROUP BY t.term_id order by t.slug”;

Not an ideal perm fix but is helping to hide media items uploaded by our end users from showing up in the doc finder. What would be an ideal fix would be an update to the plugin which allows the admin to choose categories form the backend UI but I didn’t have the time to dig into what that would involve.

Hope this helps someone.

Best,

Nick