function ProjectTheme_my_account_completed_projects_area_function() { global $current_user, $wpdb, $wp_query; get_currentuserinfo(); $uid = $current_user->ID; ?> <div id="content" class="account-main-area"> <?php global $current_user; get_currentuserinfo(); $uid = $current_user->ID; global $wp_query, $wpdb; $query_vars = $wp_query->query_vars; $post_per_page = 10; $querystr = "\n SELECT p.ID \n FROM {$wpdb->posts} AS p\n LEFT JOIN {$wpdb->prefix}project_bids AS pb ON p.ID = pb.pid\n WHERE p.post_author = '{$uid}'\n AND pb.winner = '1'\n AND pb.paid = '1'\n AND p.post_type = 'project' "; $pageposts = $wpdb->get_col($querystr); if (empty($pageposts)) { echo '<div class="my_box3 border_bottom_0"> <div class="box_content"> '; _e("There are no completed projects yet.", 'ProjectTheme'); echo '</div> </div> '; } else { // $paid = array( // 'key' => 'paid_user', // 'value' => "1", // 'compare' => '=' // ); // // $args = array('post_type' => 'project','author' => $uid, 'order' => 'DESC', 'orderby' => 'date', 'posts_per_page' => $post_per_page, // 'paged' => $query_vars['paged'], 'meta_query' => array($paid)); $args = array('post_type' => 'project', 'author' => $uid, 'order' => 'DESC', 'orderby' => 'date', 'posts_per_page' => $post_per_page, 'paged' => $query_vars['paged'], 'post__in' => $pageposts); query_posts($args); if (have_posts()) { while (have_posts()) { the_post(); projectTheme_get_post_paid(); } if (function_exists('wp_pagenavi')) { wp_pagenavi(); } } else { echo '<div class="my_box3 border_bottom_0"> <div class="box_content"> '; _e("There are no completed projects yet.", 'ProjectTheme'); echo '</div> </div> '; } wp_reset_query(); } ?> </div> <?php ProjectTheme_get_users_links(); }
function ProjectTheme_my_account_completed_projects_area_function() { global $current_user, $wpdb, $wp_query; get_currentuserinfo(); $uid = $current_user->ID; ?> <div id="content"> <div class="my_box3 border_bottom_0"> <div class="box_title"><?php _e("Completed Payments", 'ProjectTheme'); ?> </div> <div class="box_content"> <?php global $current_user; get_currentuserinfo(); $uid = $current_user->ID; global $wp_query; $query_vars = $wp_query->query_vars; $post_per_page = 10; $paid = array('key' => 'paid_user', 'value' => "1", 'compare' => '='); $args = array('post_type' => 'project', 'author' => $uid, 'order' => 'DESC', 'orderby' => 'date', 'posts_per_page' => $post_per_page, 'pages' => $query_vars['paged'], 'meta_query' => array($paid)); query_posts($args); if (have_posts()) { while (have_posts()) { the_post(); projectTheme_get_post_paid(); } if (function_exists('wp_pagenavi')) { wp_pagenavi(); } } else { _e("There are no completed projects yet.", 'ProjectTheme'); } wp_reset_query(); ?> </div> </div> </div> <?php ProjectTheme_get_users_links(); }