devtotte

found the solution

• This reply was modified 4 years, 9 months ago by devtotte.
• This reply was modified 4 years, 9 months ago by devtotte.

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?

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.

for the category buttons:

$taxonomy = get_terms('nt_wmc_folder');

     $args = array(
        'post_type' => 'attachment',
        'post_status' => 'inherit',
        'posts_per_page' => -1,

        );
?>
            <div class="row">
                <div class="col-sm-12">

                	<ul class="image-filter">

                        <li class="filter-btn cat-0">
                            <a href="#imagebank" onclick="cat_ajax_get(0)" class="ajax">Kaikki</a>
                        </li>

                        <?php foreach ($taxonomy as $tax) :
                                $tax_id = $tax->term_id;
                                    if ($tax_id !== 1) : ?>

                                    <li class="filter-btn cat-<?php echo $tax->term_id ?>">
                                        <a href="#imagebank" onclick="cat_ajax_get('<?php echo $tax->term_id; ?>')" class="ajax"><?php echo $tax->name; ?></a>
                                    </li>

                                    <?php endif; ?>

                         <?php endforeach; ?>

                	</ul>

                </div>
            </div>

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
               ),
            ),
        );

    ?>

<div class="row">
    <div class="col-sm-12">

        <ul class="masonry image-list" id="imagebank">

        <?php

            $all_images = new WP_Query($image_args);

                if ( $all_images->have_posts() ) : while ( $all_images->have_posts() ) : $all_images->the_post();
                    ?>

                <li class="image-item">

The filtering function (uses ajax also):

function prefix_load_cat_images() {

    $tax_id = $_POST[ 'term' ];
    $taxonomy_terms = get_terms( $image_taxonomy, array(
        'hide_empty' => 0,
        'fields' => 'ids'
    ) );
        if ($tax_id != 0) {
            $image_args = array(
                    'post_type' => 'attachment',
                    'post_mime_type' =>'image',
                    'post_status' => 'inherit',
                    'posts_per_page' => -1,
                    // 'category__not_in' => array( 1 ),
                    'tax_query' => array(
                        array(
                            'taxonomy' => 'nt_wmc_folder',
                            'field'    => 'id',
                            'terms'    => $tax_id,
                            'operator' => 'IN'
                        )
                    )
            );
        } else {
            $image_args = array(
                    'post_type' => 'attachment',
                    'post_status' => 'inherit',
                    'posts_per_page' => -1,
                    'tax_query' => array(
                       array(
                           'taxonomy' => 'nt_wmc_folder',
                           'field'    => 'id',
                           'terms'    => $taxonomy_terms
                       ),
                    ),
                );
        }

cant put the whole code here. its too long.

Hi,

I have a similar problem. I have created a gallery with a filtering system but now it gives me an error when trying to get the terms: object(WP_Error)#1865 (2) { [“errors”]=> array(1) { [“invalid_taxonomy”]=> array(1)

Has the taxonomy name changed (if so, to what?) or do i need to build this system in another way from scratch?

Thanks!

This update broke my feed to. I have a endless looping feed done with marquee.js. Now the marquee code does not work at all and the custom css that i had broke.

What is the “wprss_ajax” div doing? That seems to be the cause to my problems

take a look at what @rfmcomposer is doing.

https://ww.wp.xz.cn/support/topic/new-cookie-law-requirement-yes-no-selection/

https://ww.wp.xz.cn/support/topic/auto-block-doesnt-work-fix/

Also if you check the “Auto block” checkbox all scripts should be blocked on page load.