function ProjectTheme_get_users_links() { global $current_user, $wpdb; get_currentuserinfo(); $rd = projectTheme_get_unread_number_messages($current_user->ID); if ($rd > 0) { $ssk = "<span class='notif_a'>" . $rd . "</span>"; } else { $ssk = ''; } $uid = $current_user->ID; //----------------------- $query = "select id from " . $wpdb->prefix . "project_ratings where fromuser='******' AND awarded='0'"; $r = $wpdb->get_results($query); $ttl_fdbks = count($r); if ($ttl_fdbks > 0) { $ttl_fdbks2 = "<span class='notif_a'>" . $ttl_fdbks . "</span>"; } $ProjectTheme_enable_2_user_tp = get_option('ProjectTheme_enable_2_user_tp'); $user_tp = get_user_meta($uid, 'user_tp', true); ?> <div id="right-sidebar" class="account-sidebar"> <ul class="xoxo"> <li class="widget-container widget_text"> <p> <ul id="my-account-admin-menu"> <li><a href="<?php echo projectTheme_my_account_link(); ?> " <?php echo $current_page == "home" ? "class='active'" : ""; ?> ><?php _e("MyAccount Home", 'ProjectTheme'); ?> </a></li> <?php $pmnts_lnk = get_permalink(get_option('ProjectTheme_my_account_payments_id')); $pmnts_lnk = apply_filters('ProjectTheme_my_account_payments_id_link', $pmnts_lnk); $ProjectTheme_enable_credits_wallet = get_option('ProjectTheme_enable_credits_wallet'); if ($ProjectTheme_enable_credits_wallet != 'no') { ?> <li><a href="<?php echo $pmnts_lnk; ?> "><?php _e("Finances", 'ProjectTheme'); ?> </a></li> <?php } ?> <li><a href="<?php echo get_permalink(get_option('ProjectTheme_my_account_private_messages_id')); ?> "><?php echo sprintf(__("Private Messages %s", 'ProjectTheme'), $ssk); ?> </a></li> <li><a href="<?php echo get_permalink(get_option('ProjectTheme_my_account_personal_info_id')); ?> "><?php _e("Personal Info", 'ProjectTheme'); ?> </a></li> <li><a href="<?php echo get_permalink(get_option('ProjectTheme_my_account_feedback_id')); ?> "><?php printf(__("Feedback/Reviews %s", 'ProjectTheme'), $ttl_fdbks2); ?> </a></li> <?php do_action('ProjectTheme_my_account_main_menu'); ?> </ul> </p> </li> <!-- ###### --> <?php if (ProjectTheme_is_user_business($uid)) { ?> <li class="widget-container widget_text"><h3 class="widget-title"><?php _e("Project Owner Menu", 'ProjectTheme'); ?> </h3> <p> <?php global $wpdb; // $querystr = " // // SELECT distinct wposts.ID // // FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta2, $wpdb->postmeta wpostmeta3 // // WHERE wposts.post_author='$uid' AND wposts.ID = wpostmeta2.post_id // // AND wpostmeta2.meta_key='paid_user' AND wpostmeta2.meta_value='0' // // // // AND wposts.ID = wpostmeta3.post_id AND // // wpostmeta3.meta_key='delivered' AND wpostmeta3.meta_value='1' // // // // AND wposts.post_type = 'project' "; $querystr = "\n\n\t\t\t\t\tSELECT distinct p.ID \n \n FROM {$wpdb->posts} AS p\n \n LEFT JOIN " . $wpdb->prefix . "project_bids AS pb ON p.ID = pb.pid\n \n WHERE p.post_author = '{$uid}'\n AND pb.winner = '1'\n AND pb.paid = '0'\n AND pb.delivered = '1'\n AND p.post_type = 'project' "; $pageposts = $wpdb->get_results($querystr, OBJECT); $ttl_prj = count($pageposts); if ($ttl_prj > 0) { $scn = "<span class='notif_a'>" . $ttl_prj . "</span>"; } //------------------------------------------------ /*$querystr = " SELECT distinct wposts.ID FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta2 WHERE wposts.post_author='$uid' AND wposts.ID = wpostmeta2.post_id AND wpostmeta2.meta_key='paid' AND wpostmeta2.meta_value='0' AND wposts.post_type = 'project' AND wposts.post_status = 'draft' ";*/ $querystr = "\n\n\t\t\t\t\tSELECT distinct wposts.ID \n\n\t\t\t\t\tFROM {$wpdb->posts} wposts\n\n\t\t\t\t\tWHERE wposts.post_author='{$uid}' AND wposts.post_type = 'project' AND wposts.post_status = 'draft' "; $pageposts = $wpdb->get_results($querystr, OBJECT); $ttl_prj2 = count($pageposts); if ($ttl_prj2 > 0) { $scn2 = "<span class='notif_a'>" . $ttl_prj2 . "</span>"; } //------------------------------------------------ $querystr = "\n\n\t\t\t\t\tSELECT distinct wposts.ID \n\n\t\t\t\t\tFROM {$wpdb->posts} wposts, {$wpdb->postmeta} wpostmeta2, {$wpdb->postmeta} wpostmeta3\n\n\t\t\t\t\tWHERE wposts.post_author='{$uid}' AND wposts.ID = wpostmeta2.post_id AND wposts.ID = wpostmeta3.post_id AND\n\n\t\t\t\t\twpostmeta2.meta_key='outstanding' AND wpostmeta2.meta_value='1' AND wposts.post_type = 'project' AND wposts.post_status= 'publish' " . " AND wpostmeta3.meta_key='mark_coder_delivered' AND wpostmeta3.meta_value = '1'"; $pageposts = $wpdb->get_results($querystr, OBJECT); $ttl_prj2 = count($pageposts); if ($ttl_prj2 > 0) { $compl = "<span class='notif_a'>" . $ttl_prj2 . "</span>"; } $querystr = "\n\n\t\t\t\t\tSELECT distinct wposts.ID \n\n\t\t\t\t\tFROM {$wpdb->posts} wposts, {$wpdb->postmeta} wpostmeta2\n\n\t\t\t\t\tWHERE wposts.post_author='{$uid}' AND wposts.ID = wpostmeta2.post_id AND\n\n\t\t\t\t\twpostmeta2.meta_key='closed' AND wpostmeta2.meta_value='1' AND wposts.post_type = 'project' AND wposts.post_status = 'publish'"; $pageposts = $wpdb->get_results($querystr, OBJECT); $ttl_prj2 = count($pageposts); if ($ttl_prj2 > 0) { $closed_number = "<span class='notif_a'>" . $ttl_prj2 . "</span>"; } $querystr = "\n\n\t\t\t\t\tSELECT distinct wposts.ID \n\n\t\t\t\t\tFROM {$wpdb->posts} wposts, {$wpdb->postmeta} wpostmeta2\n\n\t\t\t\t\tWHERE wposts.post_author='{$uid}' AND wposts.ID = wpostmeta2.post_id AND\n\n\t\t\t\t\twpostmeta2.meta_key='closed' AND wpostmeta2.meta_value='0' AND wposts.post_type = 'project' AND wposts.post_status = 'publish'"; $pageposts = $wpdb->get_results($querystr, OBJECT); $ttl_prj2 = count($pageposts); if ($ttl_prj2 > 0) { $active_number = "<span class='notif_a'>" . $ttl_prj2 . "</span>"; } // $querystr = " // // SELECT distinct wposts.ID // // FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta3, $wpdb->postmeta wpostmeta4 // // WHERE // // wposts.ID = wpostmeta4.post_id AND // // wpostmeta4.meta_key='paid_user' AND wpostmeta4.meta_value='1' // // AND wposts.post_type = 'project' AND wposts.post_author='$uid'"; $querystr = "\n SELECT pb.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_results($querystr, OBJECT); $paid = count($pageposts); if ($paid > 0) { $paid = "<span class='notif_a'>" . $paid . "</span>"; } else { $paid = ''; } ?> <ul id="my-account-admin-menu_seller"> <li><a href="<?php echo projectTheme_post_new_link(); ?> " ><?php _e("Post New Project", 'ProjectTheme'); ?> </a></li> <li><a href="<?php echo get_permalink(get_option('ProjectTheme_my_account_active_projects_id')); ?> "><?php printf(__("Active Projects %s", 'ProjectTheme'), $active_number); /*_e("Active Projects",'ProjectTheme');*/ ?> </a></li> <li><a href="<?php echo get_permalink(get_option('ProjectTheme_my_account_closed_projects_id')); ?> "><?php printf(__("Closed Projects %s", 'ProjectTheme'), $closed_number); /*_e("Closed Projects",'ProjectTheme');*/ ?> </a></li> <li><a href="<?php echo get_permalink(get_option('ProjectTheme_my_account_unpublished_projects_id')); ?> "><?php printf(__("Unpublished Projects %s", 'ProjectTheme'), $scn2); ?> </a></li> <li><a href="<?php echo get_permalink(get_option('ProjectTheme_my_account_awaiting_completion_id')); ?> "><?php printf(__("Awaiting Completion %s", 'ProjectTheme'), $compl); ?> </a></li> <li><a href="<?php echo get_permalink(get_option('ProjectTheme_my_account_outstanding_payments_id')); ?> "><?php printf(__("Outstanding Payments %s", 'ProjectTheme'), $scn); ?> </a></li> <li><a href="<?php echo get_permalink(get_option('ProjectTheme_my_account_completed_payments_id')); ?> "><?php printf(__("Completed Payments %s", 'ProjectTheme'), $paid); /*_e("Completed Payments",'ProjectTheme');*/ ?> </a></li> <?php do_action('ProjectTheme_my_account_service_contractor_menu'); ?> </ul> </p> </li> <!-- ###### --> <?php } if (ProjectTheme_is_user_provider($uid)) { ?> <li class="widget-container widget_text"><h3 class="widget-title"><?php _e("QA Engineer Menu", 'ProjectTheme'); ?> </h3> <p> <?php $querystr = "\n\n\t\t\t\t\tSELECT distinct wposts.ID \n\n\t\t\t\t\tFROM {$wpdb->posts} wposts, {$wpdb->postmeta} wpostmeta2\n\n\t\t\t\t\tWHERE wposts.ID = wpostmeta2.post_id AND\n\n\t\t\t\t\twpostmeta2.meta_key='winner' AND wpostmeta2.meta_value='{$uid}'\n\n\t\t\t\t\tAND wposts.post_type = 'project' AND wposts.post_status = 'publish' "; $pageposts = $wpdb->get_results($querystr, OBJECT); $won = count($pageposts); if ($won > 0) { $won = "<span class='notif_a'>" . $won . "</span>"; } else { $won = ''; } $querystr = "\n\t\t\t\t\tSELECT p.ID\n FROM {$wpdb->posts} AS p\n LEFT JOIN {$wpdb->prefix}project_bids AS b ON p.ID = b.pid\n LEFT JOIN {$wpdb->prefix}postmeta AS wpostmeta2 ON p.ID = wpostmeta2.post_id\n LEFT JOIN {$wpdb->prefix}postmeta AS wpostmeta3 ON p.ID = wpostmeta3.post_id\n WHERE \n b.uid = '916' AND b.outstanding = '1'\n AND wpostmeta2.meta_key='winner' AND wpostmeta2.meta_value='916'\n AND wpostmeta3.meta_key='outstanding' AND wpostmeta3.meta_value='1' \n AND p.post_type = 'project' AND p.post_status = 'publish' "; $pageposts = $wpdb->get_results($querystr, OBJECT); $outsnr = count($pageposts); if ($outsnr > 0) { $outsnr = "<span class='notif_a'>" . $outsnr . "</span>"; } else { $outsnr = ''; } //--------------------------------------- // $querystr = " // // SELECT distinct wposts.ID // // FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta2, $wpdb->postmeta wpostmeta3, $wpdb->postmeta wpostmeta4 // // WHERE wposts.ID = wpostmeta2.post_id AND // // wpostmeta2.meta_key='winner' AND wpostmeta2.meta_value='$uid' AND // // // // // // wposts.ID = wpostmeta3.post_id AND // // wpostmeta3.meta_key='delivered' AND wpostmeta3.meta_value='1' AND // // // // wposts.ID = wpostmeta4.post_id AND // // wpostmeta4.meta_key='paid_user' AND wpostmeta4.meta_value='0' // // // // AND wposts.post_type = 'project' "; $querystr = "\n SELECT distinct p.ID \n FROM {$wpdb->posts} AS p\n LEFT JOIN {$wpdb->prefix}project_bids AS pb ON p.ID = pb.pid\n WHERE pb.uid = '{$uid}'\n AND pb.winner = '1'\n AND pb.paid = '0'\n AND pb.delivered = '1'\n AND p.post_type = 'project' "; $pageposts = $wpdb->get_results($querystr, OBJECT); $awnr = count($pageposts); if ($awnr > 0) { $awnr = "<span class='notif_a'>" . $awnr . "</span>"; } else { $awnr = ''; } // $querystr = " // // SELECT distinct wposts.ID // // FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta2, $wpdb->postmeta wpostmeta3, $wpdb->postmeta wpostmeta4 // // WHERE wposts.ID = wpostmeta2.post_id AND // // wpostmeta2.meta_key='winner' AND wpostmeta2.meta_value='$uid' AND // // // wposts.ID = wpostmeta3.post_id AND // // wpostmeta3.meta_key='delivered' AND wpostmeta3.meta_value='1' AND // // // wposts.ID = wpostmeta4.post_id AND // // wpostmeta4.meta_key='paid_user' AND wpostmeta4.meta_value='1' // // AND wposts.post_type = 'project' "; $querystr = "\n SELECT distinct p.ID \n FROM {$wpdb->posts} AS p\n LEFT JOIN {$wpdb->prefix}project_bids AS pb ON p.ID = pb.pid\n WHERE pb.uid = '{$uid}'\n AND pb.winner = '1'\n AND pb.paid = '1'\n AND pb.delivered = '1'\n AND p.post_type = 'project' "; $pageposts = $wpdb->get_results($querystr, OBJECT); $deliv = count($pageposts); if ($deliv > 0) { $deliv = "<span class='notif_a'>" . $deliv . "</span>"; } else { $deliv = ''; } $s = "select * from " . $wpdb->prefix . "project_bids where uid='{$uid}'"; $r = $wpdb->get_results($s); $pids = array(); foreach ($r as $k => $rr) { $pids[] = $rr->pid; } $pids = implode(',', $pids); $querystr = "\n\n\t\t\t\t\tSELECT distinct wposts.ID \n\n\t\t\t\t\tFROM {$wpdb->posts} wposts\n\n\t\t\t\t\tWHERE wposts.ID IN ({$pids})\n\n\t\t\t\t\t\n\n\t\t\t\t\tAND wposts.post_type = 'project' AND wposts.post_status = 'publish'"; $pageposts = $wpdb->get_results($querystr, OBJECT); $prop = count($pageposts); if ($prop > 0) { $prop = "<span class='notif_a'>" . $prop . "</span>"; } else { $prop = ''; } ?> <ul id="my-account-admin-menu_buyer"> <li><a href="<?php echo get_permalink(get_option('ProjectTheme_my_account_won_projects_id')); ?> "><?php printf(__("Projects I’ve Won %s", 'ProjectTheme'), $won); /*_e("Projects I’ve Won",'ProjectTheme');*/ ?> </a></li> <li><a href="<?php echo get_permalink(get_option('ProjectTheme_my_account_outstanding_projects_id')); ?> "><?php printf(__("Projects in progress %s", 'ProjectTheme'), $outsnr); ?> </a></li> <li><a href="<?php echo get_permalink(get_option('ProjectTheme_my_account_awaiting_payments_id')); ?> "><?php printf(__("Awaiting Payments %s", 'ProjectTheme'), $awnr); ?> </a></li> <li><a href="<?php echo get_permalink(get_option('ProjectTheme_my_account_delivered_projects_id')); ?> "><?php printf(__("Delivered & Paid Projects %s", 'ProjectTheme'), $deliv); /*_e("Delivered & Paid Projects",'ProjectTheme');*/ ?> </a></li> <li><a href="<?php echo get_permalink(get_option('ProjectTheme_my_account_bid_projects_id')); ?> "><?php printf(__("My Proposals %s", 'ProjectTheme'), $prop); /*_e("My Proposals",'ProjectTheme');*/ ?> </a></li> <?php do_action('ProjectTheme_my_account_service_provider_menu'); ?> </ul> </p> </li> <?php } ?> </ul> </div> <?php }
<div class="rama1"><input type="text" placeholder="<?php _e('What service do you need? (e.g. website design)', 'ProjectTheme'); ?> " id="findService" name="term"></div> <div class="rama1 rama2"><input type="image" src="<?php bloginfo('template_url'); ?> /images/sear1.png" width="44" height="44" /></div> </div> </div> </form> <div class="buttons_box_main"> <ul class="regular_ul"> <li><a href="<?php echo projectTheme_post_new_link(); ?> "><?php _e('Post Your Project', 'ProjectTheme'); ?> </a></li> <li><a href="<?php bloginfo('siteurl'); ?> /wp-login.php?action=register"><?php _e("Join Us. It's Free", 'ProjectTheme'); ?> </a></li> </ul> </div>
function ProjectTheme_get_users_links() { global $current_user, $wpdb; get_currentuserinfo(); $rd = projectTheme_get_unread_number_messages($current_user->ID); if ($rd > 0) { $ssk = "<span class='notif_a'>" . $rd . "</span>"; } else { $ssk = ''; } $uid = $current_user->ID; //----------------------- $query = "select id from " . $wpdb->prefix . "project_ratings where fromuser='******' AND awarded='0'"; $r = $wpdb->get_results($query); $ttl_fdbks = count($r); if ($ttl_fdbks > 0) { $ttl_fdbks2 = "<span class='notif_a'>" . $ttl_fdbks . "</span>"; } $ProjectTheme_enable_2_user_tp = get_option('ProjectTheme_enable_2_user_tp'); $user_tp = get_user_meta($uid, 'user_tp', true); ?> <div id="right-sidebar" class="account-sidebar"> <ul class="xoxo"> <li class="widget-container widget_text"> <p> <ul id="my-account-admin-menu"> <li><a href="<?php echo projectTheme_my_account_link(); ?> " <?php echo $current_page == "home" ? "class='active'" : ""; ?> ><?php _e("MyAccount Home", 'ProjectTheme'); ?> </a></li> <?php $pmnts_lnk = get_permalink(get_option('ProjectTheme_my_account_payments_id')); $pmnts_lnk = apply_filters('ProjectTheme_my_account_payments_id_link', $pmnts_lnk); $ProjectTheme_enable_credits_wallet = get_option('ProjectTheme_enable_credits_wallet'); if ($ProjectTheme_enable_credits_wallet != 'no') { ?> <li><a href="<?php echo $pmnts_lnk; ?> "><?php _e("Finances", 'ProjectTheme'); ?> </a></li> <?php } ?> <li><a href="<?php echo get_permalink(get_option('ProjectTheme_my_account_private_messages_id')); ?> "><?php echo sprintf(__("Private Messages %s", 'ProjectTheme'), $ssk); ?> </a></li> <li><a href="<?php echo get_permalink(get_option('ProjectTheme_my_account_personal_info_id')); ?> "><?php _e("Personal Info", 'ProjectTheme'); ?> </a></li> <li><a href="<?php echo get_permalink(get_option('ProjectTheme_my_account_feedback_id')); ?> "><?php printf(__("Reviews/Feedback %s", 'ProjectTheme'), $ttl_fdbks2); ?> </a></li> <?php do_action('ProjectTheme_my_account_main_menu'); ?> </ul> </p> </li> <!-- ###### --> <?php if (ProjectTheme_is_user_business($uid)) { ?> <li class="widget-container widget_text"><h3 class="widget-title"><?php _e("Service Contractor Menu", 'ProjectTheme'); ?> </h3> <p> <?php global $wpdb; $querystr = "\n\t\t\t\t\tSELECT distinct wposts.ID \n\t\t\t\t\tFROM {$wpdb->posts} wposts, {$wpdb->postmeta} wpostmeta2, {$wpdb->postmeta} wpostmeta3\n\t\t\t\t\tWHERE wposts.post_author='{$uid}' AND wposts.ID = wpostmeta2.post_id AND\n\t\t\t\t\twpostmeta2.meta_key='paid_user' AND wpostmeta2.meta_value='0'\n\t\t\t\t\t\n\t\t\t\t\tAND wposts.ID = wpostmeta3.post_id AND\n\t\t\t\t\twpostmeta3.meta_key='delivered' AND wpostmeta3.meta_value='1'\n\t\t\t\t\t\n\t\t\t\t\t AND wposts.post_type = 'project' "; $pageposts = $wpdb->get_results($querystr, OBJECT); $ttl_prj = count($pageposts); if ($ttl_prj > 0) { $scn = "<span class='notif_a'>" . $ttl_prj . "</span>"; } //------------------------------------------------ $querystr = "\n\t\t\t\t\tSELECT distinct wposts.ID \n\t\t\t\t\tFROM {$wpdb->posts} wposts, {$wpdb->postmeta} wpostmeta2\n\t\t\t\t\tWHERE wposts.post_author='{$uid}' AND wposts.ID = wpostmeta2.post_id AND\n\t\t\t\t\twpostmeta2.meta_key='paid' AND wpostmeta2.meta_value='0' AND wposts.post_type = 'project' AND wposts.post_status = 'draft' "; $pageposts = $wpdb->get_results($querystr, OBJECT); $ttl_prj2 = count($pageposts); if ($ttl_prj2 > 0) { $scn2 = "<span class='notif_a'>" . $ttl_prj2 . "</span>"; } //------------------------------------------------ $querystr = "\n\t\t\t\t\tSELECT distinct wposts.ID \n\t\t\t\t\tFROM {$wpdb->posts} wposts, {$wpdb->postmeta} wpostmeta2\n\t\t\t\t\tWHERE wposts.post_author='{$uid}' AND wposts.ID = wpostmeta2.post_id AND\n\t\t\t\t\twpostmeta2.meta_key='outstanding' AND wpostmeta2.meta_value='1' AND wposts.post_type = 'project' "; $pageposts = $wpdb->get_results($querystr, OBJECT); $ttl_prj2 = count($pageposts); if ($ttl_prj2 > 0) { $compl = "<span class='notif_a'>" . $ttl_prj2 . "</span>"; } ?> <ul id="my-account-admin-menu_seller"> <li><a href="<?php echo projectTheme_post_new_link(); ?> " ><?php _e("Post New Project", 'ProjectTheme'); ?> </a></li> <li><a href="<?php echo get_permalink(get_option('ProjectTheme_my_account_active_projects_id')); ?> "><?php _e("Active Projects", 'ProjectTheme'); ?> </a></li> <li><a href="<?php echo get_permalink(get_option('ProjectTheme_my_account_closed_projects_id')); ?> "><?php _e("Closed Projects", 'ProjectTheme'); ?> </a></li> <li><a href="<?php echo get_permalink(get_option('ProjectTheme_my_account_unpublished_projects_id')); ?> "><?php printf(__("Unpublished Projects %s", 'ProjectTheme'), $scn2); ?> </a></li> <li><a href="<?php echo get_permalink(get_option('ProjectTheme_my_account_awaiting_completion_id')); ?> "><?php printf(__("Awaiting Completion %s", 'ProjectTheme'), $compl); ?> </a></li> <li><a href="<?php echo get_permalink(get_option('ProjectTheme_my_account_outstanding_payments_id')); ?> "><?php printf(__("Outstanding Payments %s", 'ProjectTheme'), $scn); ?> </a></li> <li><a href="<?php echo get_permalink(get_option('ProjectTheme_my_account_completed_payments_id')); ?> "><?php _e("Completed Payments", 'ProjectTheme'); ?> </a></li> <?php do_action('ProjectTheme_my_account_service_contractor_menu'); ?> </ul> </p> </li> <!-- ###### --> <?php } if (ProjectTheme_is_user_provider($uid)) { ?> <li class="widget-container widget_text"><h3 class="widget-title"><?php _e("Freelancer Menu", 'ProjectTheme'); ?> </h3> <p> <?php $querystr = "\n\t\t\t\t\tSELECT distinct wposts.ID \n\t\t\t\t\tFROM {$wpdb->posts} wposts, {$wpdb->postmeta} wpostmeta2, {$wpdb->postmeta} wpostmeta3\n\t\t\t\t\tWHERE wposts.ID = wpostmeta2.post_id AND\n\t\t\t\t\twpostmeta2.meta_key='winner' AND wpostmeta2.meta_value='{$uid}' AND\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\twposts.ID = wpostmeta3.post_id AND\n\t\t\t\t\twpostmeta3.meta_key='outstanding' AND wpostmeta3.meta_value='1' \n\t\t\t\t\t\n\t\t\t\t\tAND wposts.post_type = 'project' "; $pageposts = $wpdb->get_results($querystr, OBJECT); $outsnr = count($pageposts); if ($outsnr > 0) { $outsnr = "<span class='notif_a'>" . $outsnr . "</span>"; } else { $outsnr = ''; } //--------------------------------------- $querystr = "\n\t\t\t\t\tSELECT distinct wposts.ID \n\t\t\t\t\tFROM {$wpdb->posts} wposts, {$wpdb->postmeta} wpostmeta2, {$wpdb->postmeta} wpostmeta3, {$wpdb->postmeta} wpostmeta4\n\t\t\t\t\tWHERE wposts.ID = wpostmeta2.post_id AND\n\t\t\t\t\twpostmeta2.meta_key='winner' AND wpostmeta2.meta_value='{$uid}' AND\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\twposts.ID = wpostmeta3.post_id AND\n\t\t\t\t\twpostmeta3.meta_key='delivered' AND wpostmeta3.meta_value='1' AND\n\t\t\t\t\t\n\t\t\t\t\twposts.ID = wpostmeta4.post_id AND\n\t\t\t\t\twpostmeta4.meta_key='paid_user' AND wpostmeta4.meta_value='0' \n\t\t\t\t\t\n\t\t\t\t\tAND wposts.post_type = 'project' "; $pageposts = $wpdb->get_results($querystr, OBJECT); $awnr = count($pageposts); if ($awnr > 0) { $awnr = "<span class='notif_a'>" . $awnr . "</span>"; } else { $awnr = ''; } ?> <ul id="my-account-admin-menu_buyer"> <li><a href="<?php echo get_permalink(get_option('ProjectTheme_my_account_won_projects_id')); ?> "><?php _e("Won Projects", 'ProjectTheme'); ?> </a></li> <li><a href="<?php echo get_permalink(get_option('ProjectTheme_my_account_outstanding_projects_id')); ?> "><?php printf(__("Outstanding Projects %s", 'ProjectTheme'), $outsnr); ?> </a></li> <li><a href="<?php echo get_permalink(get_option('ProjectTheme_my_account_awaiting_payments_id')); ?> "><?php printf(__("Awaiting Payments %s", 'ProjectTheme'), $awnr); ?> </a></li> <li><a href="<?php echo get_permalink(get_option('ProjectTheme_my_account_delivered_projects_id')); ?> "><?php _e("Delivered & Paid Projects", 'ProjectTheme'); ?> </a></li> <li><a href="<?php echo get_permalink(get_option('ProjectTheme_my_account_bid_projects_id')); ?> "><?php _e("My Proposals", 'ProjectTheme'); ?> </a></li> <?php do_action('ProjectTheme_my_account_service_provider_menu'); ?> </ul> </p> </li> <?php } ?> </ul> </div> <?php }