Advertisement
Guest User

Untitled

a guest
Nov 2nd, 2011
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.17 KB | None | 0 0
  1. <?php
  2. global $post;
  3. global $wpdb;
  4. $post_type = 'post';
  5. if($category)
  6. {
  7. $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) ) ";
  8. }
  9. if($_SESSION['multi_city'])
  10. {
  11. $multi_city_id = $_SESSION['multi_city'];
  12. $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";
  13. }else
  14. {
  15. $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 ";
  16. }
  17.  
  18. $latest_menus = $wpdb->get_results($sql);
  19. if($latest_menus)
  20. {
  21. ?>
  22.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement