« first day (1677 days earlier)      last day (1496 days later) » 

 
7 hours later…
8:08 AM
@s_ha_dum: I implemented the posts_where, posts_join and posts_groupby in a way that I can now implement my custom query in a WordPress' way.
But I found one difference in both the query, and may be that's causing some problem fetching exact data:
This is my WHERE clause:
WHERE 1=1
	AND (( ({$wpdb->posts}.post_title LIKE '%$searchQ%') OR ({$wpdb->posts}.post_content LIKE '%$searchQ%') OR ({$wpdb->users}.display_name LIKE '%$searchQ%') OR ({$wpdb->usermeta}.meta_value LIKE '%$searchQ%') ))
	AND {$wpdb->posts}.post_type IN ( 'offers' )
	AND {$wpdb->posts}.post_status = 'publish'
But this is how the filter is making the query:
      WHERE 1=1
		AND ((({$wpdb->posts}.post_title LIKE '%aarong%') OR ({$wpdb->posts}.post_content LIKE '%aarong%')))
		AND {$wpdb->posts}.post_type IN ('offers')
		AND ({$wpdb->posts}.post_status = 'publish' OR {$wpdb->posts}.post_author = 1 AND {$wpdb->posts}.post_status = 'private')

	OR ({$wpdb->users}.display_name LIKE '%aarong%')
	OR ({$wpdb->usermeta}.meta_value LIKE '%aarong%')
what I did is:
$join .= "INNER JOIN {$wpdb->postmeta}
			ON ( {$wpdb->posts}.ID = {$wpdb->postmeta}.post_id )
		INNER JOIN {$wpdb->users}
			ON ( {$wpdb->postmeta}.meta_value = {$wpdb->users}.ID )
		INNER JOIN {$wpdb->usermeta}
			ON ( {$wpdb->usermeta}.user_id = {$wpdb->users}.ID )";
	return $join;
$where .= " OR ({$wpdb->users}.display_name LIKE '%". get_search_query(). "%') OR ({$wpdb->usermeta}.meta_value LIKE '%". get_search_query(). "%')";
return $where;
 
anu
8:35 AM
Happy to see that WooCommerce will be a first party plugin and therefore in scope for WPSE :)
runs away
 
This actually was the first thing I thought (speak worried about) when I read that announcement...
Probably one more reason to push the Area51 proposal
 
Or send them to the wordpress.com support forum.
 
8:56 AM
lol
 
9:28 AM
Any recommendations for creating a complex multi-step form with all bells and whistles (uploads, conditional logic,...). My research points towards Gravity Forms, anything else I haven't seen?
 
how is woocommerce on-topic, just because automattic acquired it....I'd say it isn't
 
anu
Pretty simple, first party plugins are on topic
 
sure, first party, like your own plug-ins
but as long as woo isn't going to be part of core - imagine - in my mind it isn't on-topic
 
anu
9:43 AM
no plugins are part of core
that's the definition of a plugin, surely?
 
true, but we accept WP-API questions for example, because it will be part of core
 
I don't really see the potential problem that it really is on topic, but even more people will think so and dump their questions here.
 
anu
Again, wp-api is really a first party plugin,so is fine
 
my point is, the question of first or third party has be answered from the perspective of the asker
not from the perspective of automattic
surely there will be more questions, but we do what we always do - now at least - check if they can be on-topic and otherwise close them
 
10:09 AM
0
Q: What are first party plugins?

ialocinThe question arose - in The Loop chat - because Automattic now Woocommerce acquired. Personally I don't think that this makes Woocommerce a first party plugin. We don't consider all those other Automattic plugins automatically on topic, right? Besides - in my mind - the question of first or third...

 
 
8 hours later…
5:39 PM
anyone know how much automattic paid to woo?
 
supposedly 30 million IIRC
 
6:00 PM
where'd you get that?
 
I read it somewhere, the reasoning/derivation was somewhat along the line, because Matt said it is 6 times bigger then formerly biggest purchase, it has to be about that amount
 

« first day (1677 days earlier)      last day (1496 days later) »