pls help with code, its for latest post jobs , i modified it with random , but i need to show just featured jobs, what is needed to change?
now it shows all jobs
<?php
global $wp_query;
$query_vars = $wp_query->query_vars;
$job_category = $query_vars['job_category'];
$page = $query_vars['page'];
$my_page = $page;
$job_sort = $query_vars['job_sort'];
$job_tax = $query_vars['job_tax'];
$term_search = $query_vars['term_search'];
if(empty($term_search)) $term_search = $_GET['term_search'];
//----------
if(empty($job_category)) $job_category = "all";
if(empty($page)) $page = "1";
if(empty($job_sort)) $job_sort = "";
if(empty($job_tax)) $job_tax = "category";
if($job_tax == "category")
$job_tax2 = "job_cat";
else
$job_tax2 = "job_location";
//----------
if($job_category != "all" and $job_tax == "category")
{
$term_ct = get_term_by('slug', $job_category, 'job_cat');
$posted_jobs = sprintf(__('All %s Jobs','PricerrTheme'), $term_ct->name);
}
elseif($job_category != "all" and $job_tax == "location")
{
$term_ct = get_term_by('slug', $job_category, 'job_location');
$posted_jobs = sprintf(__('All Jobs in %s','PricerrTheme'), $term_ct->name);
}
else
{
$posted_jobs = __('All Posted Jobs','PricerrTheme');
}
if(1) //!sitemile_check_if_home())
{
echo '<h3 class="widget-title">'.$posted_jobs.'</h3>';
}
?>
<?php
$view = pricerrtheme_get_current_view_grid_list();
echo '<div class="switchers">';
echo '<div class="switch_view_link">'.__('Switch View:','PricerrTheme').'</div>';
if($view != "grid")
{
echo '<a href="'.pricerrtheme_switch_link_from_home_page('grid').'" class="grid"></a>';
echo '<a href="'.pricerrtheme_switch_link_from_home_page('list').'" class="list-selected"></a>';
}
else
{
echo '<a href="'.pricerrtheme_switch_link_from_home_page('grid').'" class="grid-selected"></a>';
echo '<a href="'.pricerrtheme_switch_link_from_home_page('list').'" class="list"></a>';
}
echo '</div>';
?>
<?php
function jobTheme_posts_where( $where ) {
global $wpdb, $term;
$where .= " AND ({$wpdb->posts}.post_title LIKE '%$term%' OR {$wpdb->posts}.post_content LIKE '%$term%')";
return $where;
}
global $term, $wpdb;
$term = $term_search;
if(!empty($term_search))
{
$term = $term_search;
$where_term = " AND ("; // AND (posts.post_title LIKE '%$term%' OR posts.post_content LIKE '%$term%')";
$split_stemmed = split ( " ", $term );
while ( list ( $key,$val ) = each ( $split_stemmed ) )
{
if( $val!='' && strlen ( $val ) > 0 )
{
$where_term .= "( posts.post_title LIKE '%".$val."%' OR posts.post_content LIKE '%".$val."%') OR ";
}
}
$where_term .= " 0!=0 )";
}
global $wpdb;
$prefix = $wpdb->prefix;
$nrpostsPage = 10;
$PricerrTheme_show_limit_job_cnt = get_option('PricerrTheme_show_limit_job_cnt');
if(!empty($PricerrTheme_show_limit_job_cnt)) $nrpostsPage = $PricerrTheme_show_limit_job_cnt;
if($job_category != "all")
{
$tmp = "select term_id from ".$prefix."terms where slug='$job_category'";
$res = $wpdb->get_results($tmp);
$term_id = $res[0]->term_id;
$ors = ' OR 0=1 ';
$childs = get_term_children( $term_id, $job_tax2 );
foreach($childs as $child)
{
$term_id_ms = $child;
$tmp1 = "select term_taxonomy_id from ".$prefix."term_taxonomy where term_id='$term_id_ms' AND taxonomy='$job_tax2'";
$res1 = $wpdb->get_results($tmp1);
$term_id1 = $res1[0]->term_taxonomy_id;
$ors .= " OR tax.term_taxonomy_id='$term_id1' ";
}
//echo $ors;
$tmp = "select term_taxonomy_id from ".$prefix."term_taxonomy where term_id='$term_id' AND taxonomy='$job_tax2'";
$res = $wpdb->get_results($tmp);
$term_id = $res[0]->term_taxonomy_id;
$cate_inner = " INNER JOIN ".$prefix."term_relationships tax ON (posts.ID = tax.object_id) ";
$cate_where = " AND (tax.term_taxonomy_id='$term_id' ".$ors. " ) ";
//$cate = " posts.ID=tax.object_id AND tax.term_taxonomy_id='$term_id' AND ";
}
if($job_sort == 'popularity')
{
$likes_inner = " INNER JOIN ".$prefix."postmeta meta7 ON (posts.ID = meta7.post_id) ";
$likes_where = " AND (meta7.meta_key = 'likes' ) ";
$likes_sort = " meta7.meta_value+0 DESC , ";
}
if($job_sort == 'views')
{
$views_inner = " INNER JOIN ".$prefix."postmeta meta7 ON (posts.ID = meta7.post_id) ";
$views_where = " AND (meta7.meta_key = 'views' ) ";
$views_sort = " meta7.meta_value+0 DESC , ";
}
if($job_sort == 'express')
{
$views_inner = " INNER JOIN ".$prefix."postmeta meta7 ON (posts.ID = meta7.post_id) ";
$views_where = " AND (meta7.meta_key = 'max_days' ) AND (meta7.meta_value = '1' ) ";
$views_sort = " meta7.meta_value+0 DESC , ";
}
if($job_sort == 'instant')
{
$views_inner = " INNER JOIN ".$prefix."postmeta meta7 ON (posts.ID = meta7.post_id) ";
$views_where = " AND (meta7.meta_key = 'instant' ) AND (meta7.meta_value = '1' ) ";
$views_sort = " meta7.meta_value+0 DESC , ";
}
if($job_sort == 'rating')
{
$rating_inner = " INNER JOIN ".$prefix."postmeta meta5 ON (posts.ID = meta5.post_id) ";
$rating_where = " AND (meta5.meta_key = 'rating' ) ";
$rating_sort = " meta5.meta_value+0 DESC , ";
}
if($job_sort == 'videos')
{
$hasvideo_inner = " INNER JOIN ".$prefix."postmeta AS meta9 ON (posts.ID = meta9.post_id) ";
$hasvideo_where = " AND (meta9.meta_key = 'has_video' ) AND (meta9.meta_value = '1' ) ";
}
if($job_sort == 'pictures')
{
$haspictures_where = " AND EXISTS (select ID from ".$prefix."posts second_posts where
second_posts.post_parent=posts.ID AND post_type='attachment' AND post_mime_type like '%image%' LIMIT 1) ";
}
//----------------------------------------------
$closed_inner = " INNER JOIN ".$prefix."postmeta AS meta89 ON (posts.ID = meta89.post_id) ";
$closed_where = " AND (meta89.meta_key = 'closed' ) AND (meta89.meta_value = '0' ) ";
$active_inner = " INNER JOIN ".$prefix."postmeta AS meta88 ON (posts.ID = meta88.post_id) ";
$active_where = " AND (meta88.meta_key = 'active' ) AND (meta88.meta_value = '1' ) ";
//----------------------------------------------
$featured_sort = "";
if($job_sort == "auto") $featured_sort = "meta1.meta_value+0 ASC, ";
//---------------------------------------------------------------
$sql = "SELECT SQL_CALC_FOUND_ROWS posts.* FROM ".$prefix."posts posts
INNER JOIN ".$prefix."postmeta meta1 ON (posts.ID = meta1.post_id)
INNER JOIN ".$prefix."postmeta AS meta3 ON (posts.ID = meta3.post_id) ". $closed_inner ." ". $active_inner. " ".$cate_inner."
".$hasvideo_inner." ".$rating_inner." ".$views_inner." ".$likes_inner." ".$cate_where."
WHERE ".$cate." posts.post_type = 'job' AND (posts.post_status = 'publish')
AND meta1.meta_key = 'featured' ".$where_term." AND meta3.meta_key = 'closed' AND meta3.meta_value = '0'
".$hasvideo_where." ".$closed_where." ".$active_where." ".$rating_where." ".$likes_where." ".$views_where." ".$haspictures_where."
GROUP BY posts.ID ORDER BY ".$featured_sort." ".$rating_sort." ".$views_sort." ".$likes_sort." posts.post_modified desc ";
//----------------------------------------------------------------
$sql_temp = "SELECT SQL_CALC_FOUND_ROWS posts.ID FROM ".$prefix."posts posts
INNER JOIN ".$prefix."postmeta meta1 ON (posts.ID = meta1.post_id)
INNER JOIN ".$prefix."postmeta AS meta3 ON (posts.ID = meta3.post_id) ". $closed_inner ." ". $active_inner. " ".$cate_inner."
".$hasvideo_inner." ".$rating_inner." ".$views_inner." ".$likes_inner." ".$cate_where."
WHERE ".$cate." posts.post_type = 'job' AND (posts.post_status = 'publish')
AND meta1.meta_key = 'featured' ".$where_term." AND meta3.meta_key = 'closed' AND meta3.meta_value = '0'
".$hasvideo_where." ".$closed_where." ".$active_where." ".$rating_where." ".$likes_where." ".$views_where." ".$haspictures_where."
GROUP BY posts.ID ORDER BY ".$featured_sort." ".$rating_sort." ".$views_sort." ".$likes_sort." posts.post_modified desc ";
//---------------------------------------------------------------
//echo $sql;
$limit = " LIMIT ".($nrpostsPage * ($page - 1) ).", $nrpostsPage ";
//mysql_query($sql) or die(mysql_error());
//echo $sql;
//$totalposts = $wpdb->get_results($sql_temp, OBJECT);
//$nrposts = count($totalposts);
//$totalPages = ceil($nrposts / $nrpostsPage);
//$pagess = $totalPages;
//====================================================
// The Loop
//$pageposts = $wpdb->get_results($sql.$limit, OBJECT);
//$posts_per = 5;
$nrpostsPage = 20;
$nrpostsPage_home_page = get_option('PricerrTheme_nrpostsPage_home_page');
if(!empty($nrpostsPage_home_page)) $nrpostsPage = $nrpostsPage_home_page;
//-------------------------------------
$pj = get_query_var('paged');
$meta_querya = array(array(
'key' => 'active',
'value' => "1",
'compare' => '='
) );
$args = array('posts_per_page' => $nrpostsPage, 'paged' => $pj, 'post_type' => 'job', 'order' => "DESC" , 'meta_query' => $meta_querya ,'meta_key' => 'featured', 'orderby'=> 'rand' );
$the_query = new WP_Query( $args );
if($the_query->have_posts()):
while ( $the_query->have_posts() ) : $the_query->the_post();
?>
<?php
if($view != "grid")
PricerrTheme_get_post();
else
PricerrTheme_get_post_thumbs();
?>
<?php endwhile; ?>
<?php
$pricerrtheme_show_pagination_homepage = get_option('pricerrtheme_show_pagination_homepage');
if($pricerrtheme_show_pagination_homepage != "yes"):
?>
<div class="show_all_jobs">
<a href="<?php echo get_post_type_archive_link('job') ?>"><?php _e('Show All Jobs','PricerrTheme'); ?></a>
</div>
<?php else:
if(function_exists('wp_pagenavi')):
echo '<div class="my_pagination">';
wp_pagenavi( array( 'query' => $the_query ) );
echo '</div>'; endif;
endif;
?>
<?php else : ?> <?php $no_p = 1; ?>
<div class="padd100"><p class="center"><?php _e("Sorry, there are no posted jobs yet",'PricerrTheme'); ?>.</p></div>
<?php endif; ?>
