Support Forums

Thank you for your reply! Understandably going at this as a feature request turns out to be complicated since the new component has to be implemented following the current S&F methods.

However, I already did an example using WP ‘posts_where’ filter which catches the resulting S&F SQL query and adds to it before its execution:

//modify the Search&Find SQL query
add_filter( 'posts_where' , 'mbs_posts_where_statement' );
function mbs_posts_where_statement( $where ) {
	global $wp_query;

	//check if we're in Search context before altering the query
	if ( 345 != $wp_query->query_vars['sfid'] )
		return $where;
 	
 	//check if this is a Search query or just displaying the search widget
 	if(strpos($where, 'mbs_posts.ID IN')===FALSE)
 		return $where;

 	//alter the query
 	global $wpdb;
 	$where .= $wpdb->prepare(" AND $wpdb->posts.post_title LIKE '%%%s%%'",'elderly') ;
 
	return $where;
}

So this takes care of modifying the query.

The only thing I need to do know is find out – while inside this filter – what was selected on a dropdown – Range – in the search so I can use that selection value to change the query the way I want to. And I can’t seem to figure out how to get that data from S&F while inside the ‘posts_where’ filter, I tried with $_POST & $_REQUEST but these are not available at this point in the execution.

I would still like your input on this, maybe your developer can help. Thank you!

That would be great! Up until now I have figured out a solution, but still I’m looking for a more elegant one.

Here I can change the HTML output and change the _sfm__wpuf_form_id field to _mbssfm__wpuf_form_id so I can still use it’s values for myself but it won’t be included in the S&F DB query.
Of course at the end I might use some DOMDocument manipulation only on the S&F widget instead of acting on all the pages like this. This was just a quick hack.

//modify the buffer of pages
function mbs_callback($buffer) {
  if(strpos($buffer, '_sfm__wpuf_form_id')===FALSE)
  	return $buffer;

  return str_replace('_sfm__wpuf_form_id', '_mbssfm__wpuf_form_id', $buffer);
}
function mbs_buffer_start() { ob_start("mbs_callback"); }
function mbs_buffer_end() { ob_end_flush(); }

add_action('wp_head', 'mbs_buffer_start');
add_action('wp_footer', 'mbs_buffer_end');

Then I get my _mbssfm__wpuf_form_id $_REQUEST value and add it to the result of the initial S&F DB query – that’s how I understood it – so I’m filtering once more the results already filtered by S&F’s search elements.

//modify the Search&Find SQL query
add_filter( 'posts_where' , 'mbs_posts_where_statement' );
function mbs_posts_where_statement( $where ) {
	global $wp_query;

	//check if we're in Search context before altering the query
	if ( 345 != $wp_query->query_vars['sfid'] )
		return $where;
 	
 	//check if this is a Search query or just displaying the search widget
 	if(strpos($where, 'mbs_posts.ID IN')===FALSE)
 		return $where;

 	//check if the desired request field has been passed
 	if(!isset($_REQUEST['_mbssfm__wpuf_form_id']))
 		return $where;

 	//alter the query
 	global $wpdb;
 	$where .= $wpdb->prepare(" AND $wpdb->posts.post_title LIKE '%%%s%%'",$_REQUEST['_mbssfm__wpuf_form_id']) ;

	//removes the actions hooked on the '__after_loop' (post navigation)
	remove_all_actions ( '__after_loop');
 
	return $where;
}

Ofcourse here I’m not going to pass $_REQUEST data to the SQL, I’m going to do a switch with preset values. Again this was just a quick hack.

Overall this way works! But Ross, when you have time, please have a look at it and tell me if you can think of a better approach or have any recommendations.

Replace line
if(strpos($where, ‘mbs_posts.ID IN’)===FALSE) return $where;
with
if(strpos($where, ‘_posts.ID IN’)===FALSE) return $where;

so that the code will work regardless of WP table prefix.

An Edit option on the support forum would be great so users can edit their posts in case they forget something, or need to add extra info / make corrections.

@trevorsf, you might have Edit privileges because you’ve got a ‘Moderator’ role, or I might not have Edit privileges because I have too few posts – that’s how I see it, but this is about the internal workings of your support forum – I wouldn’t know. The certain thing is that I cannot edit my own posts.

As to the $wpdb table prefix for the above line change, it is not necessary to put the WP table prefix since S&F always returns a query that looks like AND mbs_posts.ID IN (*some_posts_ids_here*) + some more query data, so one can always find the ‘_posts.ID IN’ string when filtering the correct S&F query with the ‘posts_where’ filter.

@Ross, when you have time, your input would be appreciated about retaining the input component value in the search form, and about the general idea, maybe you have something more elegant in mind. Thank you!
As far as I’m concerned the solution to my situation regarding S&F SQL query addition is done, I just need to get the SQL geo coordinate search done (lat/lon + aprox distance bounding box -> then ‘great circle’ distance select on remaining results, something like that) and I’ll publish the code here – maybe it helps someone in the future, but that’s outside the scope of S&F support.