Anderson Narciso

I am extremely grateful for the replies, and my apologize for my bad English understanding of you. But I’m not looking for a search plugin, I’m trying to develop a select, search is something like the plugin mentioned but anything more specific. Let me give you an example straight down:

This select below search the posts a post whose custom field exists other than NULL, if he finds one or more, it lists within the select option. A custom post type value for trading (sale, lease, barter). DISTINCT, without repeated values and status of published ok?

<select name="negotiation" id="negotiation">
<option value="">Select the Negotiation</option>
<?php
global $wpdb;
$sql = "SELECT DISTINCT
retorno.meta_value
FROM
".$wpdb->posts." // IN ALL POSTS IN ALL NETWORK
LEFT JOIN ".$wpdb->postmeta." AS retorno ON retorno.post_id = ".$wpdb->posts.".ID // IN ALL POSTS IN ALL NETWORK
WHERE
retorno.meta_key = 'negotiation' AND
retorno.meta_value <> '' AND
".$wpdb->posts.".post_status = 'publish'
ORDER BY
retorno.meta_value ASC";
foreach($wpdb->get_results($sql, OBJECT) as $rss){
?>
<option value="<?=$rss->meta_value?>"<?php if($_GET['negotiation'] == $rss->meta_value){ ?> selected="selected"<?php } ?>><?=$rss->meta_value?></option>
<?php } ?>
</select>

The question is do they get (sale, lease, barter) throughout my network and return the value of all posts on the network that have any of the values (sale, lease, barter). If the site 1 own some post that has the custom field negotiation with any value between “sale, lease and Exchange”, it pulls, if the site 2 own some post that has the custom field negotiation with any value between “sale, lease and exchange”, it pulls..

@david Sader thanks for reply!

When i say infinitely is that at any moment can be added a new blog to the network, then the select (a searcher) would have to look for this new blog too, my select has to be made entirely in the hand, as it is a select to search buildings, a network of real estate websites

So i just need to know what to put in the place of $wpdb-> postmeta or $wpdb-> posts that did he select in all wp_prefix_posts and wp_prefix_postmeta

I’ve got a select to do something like https://en.wordpress.com/fresh/ via this link https://www.bappi-d-great.com/wordpress-multisite-how-to-show-popular-post-acrosee-the-network-without-any-plugin

But this other i’m trying to assemble not only search posts, search custom fields in custom post types in sequence of combobox

Select Negotiation
Select type of property
Select State
Select City
Select Neighborhood

In all the network sites. So I needed to know what to use in place of this select

$sql = “SELECT DISTINCT retorno.meta_value FROM “.$wpdb->posts.”

FROM??? In all the blogs on the network..

I use advanced custom fields and gallery fields..

Solved, thanks guys

I find

main / settings

Permalink Structure

———————————–
Now, i have one big problem… How to pull the custon fields of custon post type, and images?

I can pull just the title and the permalink…

Hey guys, i find this code

function get_popular_posts() {
        global $wpdb;

        $blogs = $wpdb->get_results( "SELECT blog_id FROM {$wpdb->blogs} WHERE blog_id != {$wpdb->blogid} AND site_id = '{$wpdb->siteid}' AND spam = '0' AND deleted = '0' AND archived = '0' order by blog_id", ARRAY_A);
        array_unshift($blogs, 1); /*Including parent blog in the array*/
        $html = '<ul>';
        foreach($blogs as $blog) {
            switch_to_blog( $blog[ 'blog_id' ] );
            $posts = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}posts WHERE post_type='post' AND post_status='publish' AND comment_count != 0 ORDER BY comment_count DESC LIMIT 10");
            foreach($posts as $post) {
                $html .= '<li><a href="'.get_permalink($post->ID).'">'.$post->post_title.'</a></li>';
            }
        }
        $html .= '</ul>';
        return $html;
    }

And he solve the problem, however i use custon post type and the permalinks are with https://www.mainsite/networksite/blog/postname, as remolver the/blog for a direct link to the network Web site post?

I don’t have much experience, i won’t know how to do that in a way. There is no simpler way how a simple mysql sql select where i can pull all the posts or post types the network?

Plugin or simples function in fucntions.php? @jkhongusc thanks

For me dont work.. https://www.andersonnarciso.com/prints/bugadminmenu.png

He actually returns an array within a loop or outside of a loop? Because i used it in the index of the main site of the network and not returned anything, and i have 3 sites in network, i put it exactly as it is in https://codex.www.ads-software.com/Function_Reference/wp_get_sites

Please, could you give me an example?

How are things, by an irony of fate ended up finding what i needed

I accessed this link i found on google https://jasonlawton.com/blog/advanced-custom-fields-modification/and in the middle of the code i ended up finding this

$acf_values = $wpdb->prefix.'acf_values';
$acf_fields = $wpdb->prefix.'acf_fields';
$wp_postmeta = $wpdb->prefix.'postmeta';

$wp_postmeta = $wpdb->prefix.’postmeta’;

And it was exactly what i needed, sorry to post useless.

I get it, exists only in Pro version

Still does not work if you use conditional logic..

Mas ent?o me fala ai pela imagem o que tem de errado, https://www.andersonnarciso.com/prints/correios.png

E o log https://www.andersonnarciso.com/prints/correios-b1ad34ee496042ea4e0f6a30f3b747be.txt

é realmente n?o funciona…

“Desculpe, aparentemente n?o existem métodos de entrega disponíveis para sua localidade (Brasil).”