Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- add_filter('query_vars','sw_add_vars');
- add_filter('posts_join', 'sw_join' );
- add_filter('posts_select', 'sw_join' );
- $bio_keys = array('dob','loc');
- function sw_add_vars($q) {
- global $bio_keys;
- var_dump($q);
- foreach ($bio_keys as $key) {
- $q[] = $key;
- }
- var_dump($q);
- return $q;
- }
- function sw_join($join) {
- global $wpdb; global $wp_query; global $bio_keys;
- foreach ($bio_keys as $key) {
- if (isset($wp_query->query_vars[$key])) {
- $join .=
- " JOIN ".$wpdb->postmeta." AS ".$key." ON (
- ".$wpdb->posts.".ID = ".$key.".post_id
- AND ".$key.".meta_value = '".$wp_query->query_vars[$key]."'
- ) ";
- }
- }
- echo $join;
- return $join;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement