Title: devtotte's Replies | WordPress.org --- # devtotte [ ](https://wordpress.org/support/users/devtotte/) * [Profile](https://wordpress.org/support/users/devtotte/) * [Topics Started](https://wordpress.org/support/users/devtotte/topics/) * [Replies Created](https://wordpress.org/support/users/devtotte/replies/) * [Reviews Written](https://wordpress.org/support/users/devtotte/reviews/) * [Topics Replied To](https://wordpress.org/support/users/devtotte/replied-to/) * [Engagements](https://wordpress.org/support/users/devtotte/engagements/) * [Favorites](https://wordpress.org/support/users/devtotte/favorites/) Search replies: ## Forum Replies Created Viewing 13 replies - 1 through 13 (of 13 total) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Max Mega Menu] Mega menu lost css in secon language](https://wordpress.org/support/topic/mega-menu-lost-css-in-secon-language/) * [devtotte](https://wordpress.org/support/users/devtotte/) * (@devtotte) * [4 years, 11 months ago](https://wordpress.org/support/topic/mega-menu-lost-css-in-secon-language/#post-14784169) * found the solution - This reply was modified 4 years, 11 months ago by [devtotte](https://wordpress.org/support/users/devtotte/). - This reply was modified 4 years, 11 months ago by [devtotte](https://wordpress.org/support/users/devtotte/). * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[FileBird - WordPress Media Library Folders & File Manager] filebird taxonomies cant be found](https://wordpress.org/support/topic/filebird-taxonomies-cant-be-found/) * [devtotte](https://wordpress.org/support/users/devtotte/) * (@devtotte) * [5 years, 10 months ago](https://wordpress.org/support/topic/filebird-taxonomies-cant-be-found/page/2/#post-13443289) * I successfully got the other images excluded from the all images query but if there is a empty folder and filter those images, it return all images uploaded to wp because the `'post__in' => $wpdb->get_col("SELECT attachment_id FROM ". $wpdb->prefix . "fbv_attachment_folder WHERE folder_id = $all_folders_ids")` argument is then empty and the deafault setting in wp is that the query returns all of that type, in this case ‘attachment’. * Havent found a way to fix this yet. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[FileBird - WordPress Media Library Folders & File Manager] filebird taxonomies cant be found](https://wordpress.org/support/topic/filebird-taxonomies-cant-be-found/) * [devtotte](https://wordpress.org/support/users/devtotte/) * (@devtotte) * [5 years, 10 months ago](https://wordpress.org/support/topic/filebird-taxonomies-cant-be-found/#post-13442672) * Yes, that worked, but maybe its better to have the notice or try to find away to do the `wpdb->prepare` request properly. * I just noticed that the filter function returns all images uploaded to wordpress when getting all images. How can i exclude all images that are not added to a folder? I have this in my arguments and folder_id should be all folders. I tried this but it still return all images uploaded to wp. `'post__in' => $wpdb->get_col(" SELECT attachment_id FROM " . $wpdb->prefix . "fbv_attachment_folder WHERE folder_id = 1" OR "2" OR "3" OR "4" OR "5")` Also tried this but since $all_folders_ids is an array it didnt work. * ``` $query = "SELECT attachment_id FROM {$wpdb->prefix}fbv_attachment_folder"; $all_folders_ids = $wpdb->get_col($query); $image_args = array( 'post_type' => 'attachment', 'post_status' => 'inherit', 'posts_per_page' => -1, 'post__in' => $wpdb->get_col("SELECT attachment_id FROM " . $wpdb->prefix . "fbv_attachment_folder WHERE folder_id = $all_folders_ids") ); ``` * Any suggestions on how i can exclude all other images? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[FileBird - WordPress Media Library Folders & File Manager] filebird taxonomies cant be found](https://wordpress.org/support/topic/filebird-taxonomies-cant-be-found/) * [devtotte](https://wordpress.org/support/users/devtotte/) * (@devtotte) * [5 years, 10 months ago](https://wordpress.org/support/topic/filebird-taxonomies-cant-be-found/#post-13437755) * Thanks! `global $wpdb;` was missing and now it works. * The WP_debug is on and prints a couple of notices: `Notice: wpdb::prepare was called incorrectly. The query argument of wpdb::prepare() must have a placeholder.` * and * `Notice: Undefined offset: 0` in wp-includes/wp-db.php on line 1319 * Since they are notices they’re probably not that important and the code works now. * Thank you! * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[FileBird - WordPress Media Library Folders & File Manager] filebird taxonomies cant be found](https://wordpress.org/support/topic/filebird-taxonomies-cant-be-found/) * [devtotte](https://wordpress.org/support/users/devtotte/) * (@devtotte) * [5 years, 10 months ago](https://wordpress.org/support/topic/filebird-taxonomies-cant-be-found/#post-13437066) * Ajax is sending the correct folder_id to the filtering function and i can echo the correct folder_id on the page but there is something wrong in the the query because it returns all the images and not only the images in that folder. So this line probably is the problem: `'post__in' => $wpdb->get_col("SELECT attachment_id FROM " . $wpdb->prefix . "fbv_attachment_folder WHERE folder_id = $folder_id")` * That probably also is the reason tor the 500 internal server error in the js console. * $folder_id is the folder id that ajax sends to the filtering function. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[FileBird - WordPress Media Library Folders & File Manager] filebird taxonomies cant be found](https://wordpress.org/support/topic/filebird-taxonomies-cant-be-found/) * [devtotte](https://wordpress.org/support/users/devtotte/) * (@devtotte) * [5 years, 10 months ago](https://wordpress.org/support/topic/filebird-taxonomies-cant-be-found/#post-13436926) * Hi, * Thanks for the suggestion. I tried it out and get a couple o notices and the filtering isn’t working. * The buttons and the first query works but gives also a “Notice: wpdb::prepare was called incorrectly. The query argument of wpdb::prepare() must have a placeholder.” and “Notice: Undefined offset: 0 in wp-includes/wp-db.php on line 1319”. These notices appear 2 times, one for the filtering buttons and one for the image query. * When clicking on a filtering button i get “POST localhost…wp-admin/admin-ajax. php 500 (Internal Server Error)” in js console. * Can you help me how to send the ajax data to the filtering function? * This was the old ajax when i was querying with a taxonomy id * ``` jQuery.ajax({ type: 'POST', url: ajaxurl, data: {"action": "load-filter", term: termID }, ``` * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[FileBird - WordPress Media Library Folders & File Manager] filebird taxonomies cant be found](https://wordpress.org/support/topic/filebird-taxonomies-cant-be-found/) * [devtotte](https://wordpress.org/support/users/devtotte/) * (@devtotte) * [5 years, 10 months ago](https://wordpress.org/support/topic/filebird-taxonomies-cant-be-found/#post-13406994) * for the category buttons: * ``` $taxonomy = get_terms('nt_wmc_folder'); $args = array( 'post_type' => 'attachment', 'post_status' => 'inherit', 'posts_per_page' => -1, ); ?>
``` * Then just a basic query to display images: * ``` $image_taxonomy = 'nt_wmc_folder'; $taxonomy_terms = get_terms( $image_taxonomy, array( 'hide_empty' => 0, 'fields' => 'ids' ) ); $image_args = array( 'post_type' => 'attachment', 'post_status' => 'inherit', 'posts_per_page' => -1, 'orderby' => 'rand', 'tax_query' => array( array( 'taxonomy' => $image_taxonomy, 'field' => 'id', 'terms' => $taxonomy_terms ), ), ); ?>