Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- global $post;
- global $wpdb;
- $post_type = 'post';
- if($category)
- {
- $subsql = " and p.ID in (select tr.object_id from $wpdb->term_relationships tr join $wpdb->term_taxonomy t on t.term_taxonomy_id=tr.term_taxonomy_id where t.term_id in ($category) ) ";
- }
- if($_SESSION['multi_city'])
- {
- $multi_city_id = $_SESSION['multi_city'];
- $sql = "select p.* from $wpdb->posts p join $wpdb->postmeta pm on pm.post_id=p.ID where p.post_type='".$post_type."' and p.post_status='publish' and (pm.meta_key='post_city_id' and (pm.meta_value like \"%,$multi_city_id,%\" or pm.meta_value like \"$multi_city_id,%\" or pm.meta_value like \"%,$multi_city_id\" or pm.meta_value like \"$multi_city_id\" or pm.meta_value='' or pm.meta_value='0')) $subsql order by p.post_date desc,p.post_title asc limit $post_number";
- }else
- {
- $sql = "select p.* from $wpdb->posts p where p.post_type='".$post_type."' and p.post_status='publish' $subsql order by p.post_date desc,p.post_title asc limit $post_number ";
- }
- $latest_menus = $wpdb->get_results($sql);
- if($latest_menus)
- {
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement