"><i class="blog-awsome" ></i><?php
echo __("Blog", 'ProjectTheme');
?>
</a></li>
<?php
}
?>
<?php
if (is_user_logged_in()) {
global $current_user;
get_currentuserinfo();
$u = $current_user;
?>
<li><a href="<?php
echo projectTheme_my_account_link();
?>
"><i class="account-awsome" ></i><?php
echo __("MyAccount", 'ProjectTheme');
?>
</a></li>
<li><a href="<?php
echo wp_logout_url();
?>
"><i class="logout-awsome" ></i><?php
echo __("Log Out", 'ProjectTheme');
?>
</a></li>
<?php
} else {
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
}
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
}
function projectTheme_template_redirect()
{
global $wp;
global $wp_query, $post, $wp_rewrite;
$my_pid = $post->ID;
$parent = $post->post_parent;
$paagee = $wp_query->query_vars['my_custom_page_type'];
$p_action = $wp_query->query_vars['p_action'];
$ProjectTheme_my_account_page_id = get_option('ProjectTheme_my_account_page_id');
$ProjectTheme_post_new_page_id = get_option('ProjectTheme_post_new_page_id');
$ProjectTheme_my_account_page_id = get_option('ProjectTheme_my_account_page_id');
//-------------
if ($parent == $ProjectTheme_my_account_page_id) {
if (!is_user_logged_in()) {
wp_redirect(ProjectTheme_login_url());
exit;
}
}
//-------------
$ProjectTheme_enable_2_user_tp = get_option('ProjectTheme_enable_2_user_tp');
if ($ProjectTheme_enable_2_user_tp == "yes" && $p_action != 'choose_user_tp') {
if (is_user_logged_in()) {
global $current_user;
get_currentuserinfo();
$user_tp = get_user_meta($current_user->ID, 'user_tp', true);
if (empty($user_tp) && !current_user_can('level_10')) {
wp_redirect(get_bloginfo('siteurl') . "/?p_action=choose_user_tp");
exit;
}
}
}
if (isset($_GET['notify_chained'])) {
if ($_POST['status'] == "COMPLETED") {
$trID = $_POST['tracking_id'];
$trID = explode("_", $trID);
$pid = $trID[0];
update_post_meta($pid, 'paid_user', "1");
update_post_meta($pid, "paid_user_date", current_time('timestamp', 0));
$projectTheme_get_winner_bid = projectTheme_get_winner_bid($pid);
ProjectTheme_send_email_when_on_completed_project($pid, $projectTheme_get_winner_bid->uid, $projectTheme_get_winner_bid->bid);
}
}
if (isset($_GET['return_chained'])) {
$ret_id = $_GET['return_chained'];
$pid_d = get_option('adaptive_payment_ID_thing_' . $ret_id);
wp_redirect(projectTheme_my_account_link());
exit;
}
//------------
if ($my_pid == $ProjectTheme_post_new_page_id) {
if (!is_user_logged_in()) {
wp_redirect(ProjectTheme_login_url());
exit;
}
global $current_user;
get_currentuserinfo();
if (!ProjectTheme_is_user_business($current_user->ID)) {
wp_redirect(get_bloginfo('siteurl'));
exit;
}
if (!isset($_GET['projectid'])) {
$set_ad = 1;
} else {
$set_ad = 0;
}
if (!empty($_GET['projectid'])) {
$my_main_post = get_post($_GET['projectid']);
if ($my_main_post->post_author != $current_user->ID) {
wp_redirect(get_bloginfo('siteurl'));
exit;
}
}
if ($set_ad == 1) {
$pid = ProjectTheme_get_auto_draft($current_user->ID);
wp_redirect(ProjectTheme_post_new_with_pid_stuff_thg($pid));
}
include 'lib/post_new_post.php';
}
//-------------
if ($my_pid == $ProjectTheme_my_account_page_id) {
if (!is_user_logged_in()) {
wp_redirect(ProjectTheme_login_url());
exit;
}
}
//----------------------------------------------------
if ($p_action == "choose_user_tp") {
include 'lib/choose_user_tp.php';
die;
}
if (isset($_GET['autosuggest'])) {
include 'autosuggest.php';
}
if ($p_action == "mark_delivered") {
include 'lib/my_account/mark_delivered.php';
die;
}
if ($p_action == "mark_completed") {
include 'lib/my_account/mark_completed.php';
die;
}
if ($p_action == "credits_listing") {
include 'lib/gateways/credits_listing.php';
die;
}
if ($p_action == "relist_this_done") {
include 'lib/my_account/relist_this_done.php';
die;
}
if ($p_action == "mb_listing_response") {
include 'lib/gateways/moneybookers_listing_response.php';
die;
}
if ($p_action == "mb_listing") {
include 'lib/gateways/moneybookers_listing.php';
die;
}
if ($p_action == "paypal_listing") {
include 'lib/gateways/paypal_listing.php';
die;
}
if ($p_action == "pay_for_project_paypal") {
include 'lib/gateways/pay_for_project_paypal.php';
die;
}
if ($p_action == "edit_project") {
include 'lib/my_account/edit_project.php';
die;
}
if ($p_action == "rate_user") {
include 'lib/my_account/rate_user.php';
die;
}
if ($p_action == "choose_winner") {
include 'lib/choose_winner.php';
die;
}
if ($p_action == "user_profile") {
include 'lib/user-profile.php';
die;
}
if ($p_action == "user_feedback") {
include 'lib/user-feedback.php';
die;
}
if ($p_action == "delete_project") {
include 'lib/my_account/delete_project.php';
die;
}
if ($p_action == "repost_project") {
include 'lib/my_account/repost_project.php';
die;
}
if ($p_action == "paypal_deposit_pay") {
include 'lib/gateways/paypal_deposit_pay.php';
die;
}
if ($p_action == "mb_deposit_response") {
include 'lib/gateways/mb_deposit_response.php';
die;
}
if ($p_action == "mb_deposit_pay") {
include 'lib/gateways/mb_deposit_pay.php';
die;
}
if ($paagee == "pay_projects_by_credits") {
include 'lib/pay-projects-by-credits.php';
die;
}
if ($paagee == "show-all-categories") {
include 'lib/show-all-categories.php';
die;
}
if ($paagee == "show-all-locations") {
include 'lib/show-all-locations.php';
die;
}
if ($paagee == "post-new") {
include 'post-new.php';
die;
}
if ($paagee == "pay_paypal") {
include 'lib/gateways/paypal.php';
die;
}
if ($paagee == "advanced_search") {
include 'lib/advanced-search.php';
die;
}
if ($paagee == "alert-pay-return") {
include 'lib/gateways/alert-pay-return.php';
die;
}
if (isset($_GET['get_files_panel'])) {
include 'lib/get_files_panel.php';
die;
}
if (isset($_GET['get_bidding_panel'])) {
include 'lib/bidding-panel.php';
die;
}
if (isset($_GET['get_message_board'])) {
include 'lib/message-board.php';
die;
}
if ($paagee == "all-blog-posts") {
include 'lib/blog.php';
die;
}
if ($paagee == "all_featured_projects") {
include 'lib/all_featured_projects.php';
die;
}
if ($paagee == "user_feedback") {
include 'lib/user-feedback.php';
die;
}
if ($paagee == "buy_now") {
include 'lib/buy-now.php';
die;
}
if ($paagee == "pay-for-project") {
include 'lib/gateways/paypal-project.php';
die;
}
if ($paagee == "deposit_pay") {
include 'lib/gateways/deposit-pay.php';
die;
}
}
