I want to add filter function and show user profile page by using search form. This is what I have now:
function test_where_filter($where){
global $wpdb;
if( is_search() ) {
$search= get_query_var('s');
$query=$wpdb->prepare("SELECT id FROM $wpdb->users WHERE ( meta_key='user_nicename' AND meta_value LIKE '%%%s%%' )", $search ,$search);
$authorID= $wpdb->get_var( $query );
if($authorID){
...
}
}
return $where;
}
add_filter('posts_where','test_where_filter');
Is my code correct and how to open author page if it will be found? Not a search result page, but user page with this link: example/author/nicename
? Thank's for any help with this!