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_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_my_account_private_messages_area_function() { global $current_user, $wpdb, $wp_query; get_currentuserinfo(); $uid = $current_user->ID; $myuid = $uid; ?> <?php global $wpdb, $wp_rewrite, $wp_query; $third_page = $wp_query->query_vars['pg']; if (empty($third_page)) { $third_page = 'home'; } ?> <div class="clear10"></div> <div id="content" class="account-main-area mess_break"> <div class="my_box3"><div class="padd10"> <div class="clear10"></div> <ul class="cms_cms"> <li><a href="<?php echo ProjectTheme_get_priv_mess_page_url(); ?> " class="green_btn"><?php _e("Messaging Home", "ProjectTheme"); ?> </a></li> <li> <a href="<?php echo ProjectTheme_get_priv_mess_page_url('send'); ?> " class="green_btn"><?php _e("Send New Message", "ProjectTheme"); ?> </a></li> <li><a href="<?php echo ProjectTheme_get_priv_mess_page_url('inbox'); ?> " class="green_btn"><?php _e("Inbox", "ProjectTheme"); global $current_user; get_currentuserinfo(); $rd = projectTheme_get_unread_number_messages($current_user->ID); if ($rd > 0) { echo ' (' . $rd . ')'; } ?> </a></li> <li><a href="<?php echo ProjectTheme_get_priv_mess_page_url('sent-items'); ?> " class="green_btn"><?php _e("Sent Items", "ProjectTheme"); ?> </a></li> </ul> </div></div> <div class="clear10"></div> <?php if ($third_page == 'home') { global $current_user; get_currentuserinfo(); $myuid = $current_user->ID; ?> <!-- page content here --> <div class="my_box3"> <div class="box_title"><?php _e("Latest Received Messages", "ProjectTheme"); ?> </div> <div class="box_content"> <?php global $wpdb; $uidsss = $current_user->ID; $s = "select * from " . $wpdb->prefix . "project_pm where user='******' AND show_to_destination='1' and approved='1' order by id desc limit 4"; $r = $wpdb->get_results($s); if (count($r) > 0) { echo '<table width="100%" class="privatemesg">'; echo '<tr>'; echo '<td>' . __('From User', 'ProjectTheme') . '</td>'; echo '<td>' . __('Subject', 'ProjectTheme') . '</td>'; echo '<td>' . __('Date', 'ProjectTheme') . '</td>'; echo '<td>' . __('Options', 'ProjectTheme') . '</td>'; echo '</tr>'; foreach ($r as $row) { if ($row->rd == 0) { $cls = 'bold_stuff'; } else { $cls = ''; } $user = get_userdata($row->initiator); echo '<tr>'; echo '<td class="' . $cls . '"><a href="' . get_bloginfo('siteurl') . '/?p_action=user_profile&post_author=' . $user->ID . '">' . $user->user_login . '</a></td>'; echo '<td class="' . $cls . '">' . substr($row->subject, 0, 30) . '</td>'; //echo '<td class="'.$cls.'">'.date_i18n('d-M-Y H:i:s',$row->datemade).'</td>'; echo '<td class="' . $cls . ' conv_time">' . $row->datemade . '</td>'; echo '<td><a href="' . ProjectTheme_get_priv_mess_page_url('read-message', $row->id) . '">' . __('Read', 'ProjectTheme') . '</a> | <a href="' . ProjectTheme_get_priv_mess_page_url('delete-message', $row->id) . '">' . __('Delete', 'ProjectTheme') . '</a></td>'; echo '</tr>'; } echo '</table>'; } else { _e('No messages here.', 'ProjectTheme'); } ?> </div> </div> <!--#######--> <div class="clear10"></div> <div class="my_box3"> <div class="box_title"><?php _e("Latest Sent Items", "ProjectTheme"); ?> </div> <div class="box_content"> <?php global $wpdb; $uidss = $current_user->ID; $s = "select * from " . $wpdb->prefix . "project_pm where initiator='{$uidss}' AND show_to_source='1' order by id desc limit 4"; $r = $wpdb->get_results($s); if (count($r) > 0) { echo '<table width="100%" class="privatemesg">'; echo '<tr>'; echo '<td>' . __('To User', 'ProjectTheme') . '</td>'; echo '<td>' . __('Subject', 'ProjectTheme') . '</td>'; echo '<td>' . __('Date', 'ProjectTheme') . '</td>'; echo '<td>' . __('Options', 'ProjectTheme') . '</td>'; echo '</tr>'; foreach ($r as $row) { //if($row->rd == 0) $cls = 'bold_stuff'; //else $cls = ''; $user = get_userdata($row->user); echo '<tr>'; echo '<td class="' . $cls . '"><a href="' . ProjectTheme_get_user_profile_link($row->user) . '">' . $user->user_login . '</a></td>'; echo '<td class="' . $cls . '">' . substr($row->subject, 0, 30) . '</td>'; //echo '<td class="'.$cls.'">'.date_i18n('d-M-Y H:i:s',$row->datemade).'</td>'; echo '<td class="' . $cls . ' conv_time">' . $row->datemade . '</td>'; echo '<td><a href="' . ProjectTheme_get_priv_mess_page_url('read-message', $row->id) . '">' . __('Read', 'ProjectTheme') . '</a> | <a id="privatedel" href="' . ProjectTheme_get_priv_mess_page_url('delete-message', $row->id) . '">' . __('Delete', 'ProjectTheme') . '</a></td>'; echo '</tr>'; } echo '</table>'; } else { _e('No messages here.', 'ProjectTheme'); } ?> </div> </div> <!-- page content here --> <?php } elseif ($third_page == 'inbox') { global $current_user; get_currentuserinfo(); $myuid = $current_user->ID; //echo $myuid; ?> <!-- page content here --> <div class="my_box3"> <div class="box_title"><?php _e("Private Messages: Inbox", "ProjectTheme"); ?> </div> <div class="box_content"> <?php global $wpdb; $page_rows = 20; $page_rows = apply_filters('ProjectTheme_nr_of_messages_priv_pagination', $page_rows); $pagenum = isset($_GET['pagenum']) ? $_GET['pagenum'] : 1; $max = ' limit ' . ($pagenum - 1) * $page_rows . ',' . $page_rows; $s = "select count(id) tots from " . $wpdb->prefix . "project_pm where user='******' AND show_to_destination='1' and approved='1'"; $r = $wpdb->get_results($s); $total = $r[0]->tots; $last = ceil($total / $page_rows); //------------------------- $s = "select * from " . $wpdb->prefix . "project_pm where user='******' AND show_to_destination='1' and approved='1' order by id desc " . $max; $r = $wpdb->get_results($s); if (count($r) > 0) { ?> <script> $(document).ready(function() { //set initial state. $('#privatedel').click(function(){ var ss=$(this).parent().text(); alert(ss); }); $('#select_all_stuff').change(function() { if($(this).is(":checked")) { $('.message_select_bx').attr("checked", true); } else { $('.message_select_bx').attr("checked", false); } }); }); </script> <?php echo '<form method="post" action="' . ProjectTheme_get_priv_mess_page_url('delete-message', '', '&return=inbox') . '">'; echo '<table width="100%">'; echo '<tr>'; echo '<td><input type="checkbox" name="" id="select_all_stuff" value="1" /> ' . __('Select All', 'ProjectTheme') . ' </td>'; echo '<td>' . __('From User', 'ProjectTheme') . '</td>'; echo '<td>' . __('Subject', 'ProjectTheme') . '</td>'; echo '<td>' . __('Date', 'ProjectTheme') . '</td>'; echo '<td>' . __('Options', 'ProjectTheme') . '</td>'; echo '</tr>'; foreach ($r as $row) { if ($row->rd == 0) { $cls = 'bold_stuff'; } else { $cls = ''; } $user = get_userdata($row->initiator); echo '<tr>'; echo '<td><input type="checkbox" class="message_select_bx" name="message_ids[]" value="' . $row->id . '" /></td>'; echo '<td class="' . $cls . '"><a href="' . get_bloginfo('siteurl') . '/?p_action=user_profile&post_author=' . $user->ID . '">' . $user->user_login . '</a></td>'; echo '<td class="' . $cls . '">' . substr($row->subject, 0, 30) . '</td>'; //echo '<td class="'.$cls.'">'.date_i18n('d-M-Y H:i:s',$row->datemade).'</td>'; echo '<td class="' . $cls . ' conv_time">' . $row->datemade . '</td>'; echo '<td><a href="' . ProjectTheme_get_priv_mess_page_url('read-message', $row->id) . '">' . __('Read', 'ProjectTheme') . '</a> | <a href="' . ProjectTheme_get_priv_mess_page_url('delete-message', $row->id) . '">' . __('Delete', 'ProjectTheme') . '</a></td>'; echo '</tr>'; } echo '<tr><td colspan="5"><input type="submit" value="' . __('Delete Selected', 'ProjectTheme') . '" name="delete_sel" /></td></tr>'; echo '<tr><td colspan="5"> '; echo ProjectTheme_get_my_pagination_main(get_bloginfo('siteurl') . "/?page_id=" . get_option('ProjectTheme_my_account_private_messages_id'), $pagenum, 'pagenum', $last, '&pg=inbox'); echo ' </td></tr>'; echo '</table></form>'; } else { _e('No messages here.', 'ProjectTheme'); } ?> </div> </div> <!-- page content here --> <?php } elseif ($third_page == 'sent-items') { global $current_user; get_currentuserinfo(); $myuid = $current_user->ID; ?> <script> $(document).ready(function() { //set initial state. $('#select_all_stuff').change(function() { if($(this).is(":checked")) { $('.message_select_bx').attr("checked", true); } else { $('.message_select_bx').attr("checked", false); } }); }); </script> <!-- page content here --> <div class="my_box3"> <div class="box_title"><?php _e("Private Messages: Sent Items", "ProjectTheme"); ?> </div> <div class="box_content"> <?php global $wpdb; $page_rows = 20; $page_rows = apply_filters('ProjectTheme_nr_of_messages_priv_pagination', $page_rows); $pagenum = isset($_GET['pagenum']) ? $_GET['pagenum'] : 1; $max = ' limit ' . ($pagenum - 1) * $page_rows . ',' . $page_rows; //--------------------------------- $s = "select count(id) tots from " . $wpdb->prefix . "project_pm where initiator='{$myuid}' AND show_to_source='1' and approved='1'"; $r = $wpdb->get_results($s); $total = $r[0]->tots; $last = ceil($total / $page_rows); //--------------------------------- $s = "select * from " . $wpdb->prefix . "project_pm where initiator='{$myuid}' AND show_to_source='1' and approved='1' order by id desc " . $max; $r = $wpdb->get_results($s); if (count($r) > 0) { echo '<form method="post" action="' . ProjectTheme_get_priv_mess_page_url('delete-message', '', '&return=outbox') . '">'; echo '<table width="100%">'; echo '<tr>'; echo '<td><input type="checkbox" name="" id="select_all_stuff" value="1" /> ' . __('Select All', 'ProjectTheme') . ' </td>'; echo '<td>' . __('To User', 'ProjectTheme') . '</td>'; echo '<td>' . __('Subject', 'ProjectTheme') . '</td>'; echo '<td>' . __('Date', 'ProjectTheme') . '</td>'; echo '<td>' . __('Options', 'ProjectTheme') . '</td>'; echo '</tr>'; foreach ($r as $row) { //if($row->rd == 0) $cls = 'bold_stuff'; //else $cls = ''; $user = get_userdata($row->user); echo '<tr>'; echo '<td><input type="checkbox" class="message_select_bx" name="message_ids[]" value="' . $row->id . '" /></td>'; echo '<td class="' . $cls . '"><a href="' . ProjectTheme_get_user_profile_link($row->user) . '">' . $user->user_login . '</a></td>'; echo '<td class="' . $cls . '">' . substr($row->subject, 0, 30) . '</td>'; //echo '<td class="'.$cls.'">'.date_i18n('d-M-Y H:i:s',$row->datemade).'</td>'; echo '<td class="' . $cls . ' conv_time">' . $row->datemade . '</td>'; echo '<td><a href="' . ProjectTheme_get_priv_mess_page_url('read-message', $row->id) . '">' . __('Read', 'ProjectTheme') . '</a> | <a href="' . ProjectTheme_get_priv_mess_page_url('delete-message', $row->id) . '">' . __('Delete', 'ProjectTheme') . '</a></td>'; echo '</tr>'; } echo '<tr><td colspan="5"><input type="submit" value="' . __('Delete Selected', 'ProjectTheme') . '" name="delete_sel" /></td></tr>'; echo '<tr><td colspan="5"> '; echo ProjectTheme_get_my_pagination_main(get_bloginfo('siteurl') . "/?page_id=" . get_option('ProjectTheme_my_account_private_messages_id'), $pagenum, 'pagenum', $last, '&pg=sent-items'); echo ' </td></tr>'; echo '</table></form>'; } else { _e('No messages here.', 'ProjectTheme'); } ?> </div> </div> <!-- page content here --> <?php } elseif ($third_page == 'delete-message') { $id = $_GET['id']; $s = "select * from " . $wpdb->prefix . "project_pm where id='{$id}' AND (user='******' OR initiator='{$myuid}')"; $r = $wpdb->get_results($s); $row = $r[0]; global $current_user; get_currentuserinfo(); $myuid = $current_user->ID; if ($myuid == $row->initiator) { $owner = true; } else { $owner = false; } //if(!$owner) //$wpdb->query("update_i18n ".$wpdb->prefix."auction_pm set rd='1' where id='{$row->id}'"); ?> <!-- page content here --> <div class="my_box3"> <div class="padd10"> <div class="box_title"><?php if (isset($_POST['delete_sel'])) { _e("Delete Selected Message: ", "ProjectTheme"); } else { _e("Delete Message: ", "ProjectTheme"); echo " " . substr($row->subject, 0, 30); } ?> </div> <div class="box_content"> <?php if (isset($_POST['message_ids'])) { $message_ids2 = $_POST['message_ids']; foreach ($message_ids2 as $message_id) { $ss1 = "select * from " . $wpdb->prefix . "project_pm where id='{$message_id}'"; $rr1 = $wpdb->get_results($ss1); $rrow1 = $rr1[0]; $user = get_userdata($rrow1->initiator); // echo '#'.$rrow1->id." ".substr($rrow1->subject,0,30).'<br/>'; echo 'Message from <b>' . $user->user_login . '</b>. Subject: ' . substr($rrow1->subject, 0, 30) . '<br/>'; } echo '<br/>'; } ?> <?php //echo $row->content; ?> <br/> <br/> <?php if (1) { //$owner == false): if (isset($_POST['delete_sel'])) { $message_ids = $_POST['message_ids']; if (count($message_ids) == 0) { _e("No messsages selected.", "ProjectTheme"); } else { $attash = ''; foreach ($message_ids as $message_id) { $attash .= '&message_id[]=' . $message_id; } ?> <a href="javascript:history.go(-1)<?php //echo ($_GET['rdr']); ?> " class="nice_link"><?php _e("Cancel", 'ProjectTheme'); ?> </a> <a href="<?php echo ProjectTheme_get_priv_mess_page_url('delete-message', '', '&confirm_message_deletion=yes&return=' . urlencode($_GET['rdr'])) . $attash; ?> " class="nice_link" onclick="return privatedel()"><?php _e("Confirm Deletion", 'ProjectTheme'); ?> </a> <?php } } else { ?> <a href="javascript:history.go(-1)<?php //echo ($_GET['rdr']); ?> " class="nice_link"><?php _e("Cancel", 'ProjectTheme'); ?> </a> <a href="<?php echo ProjectTheme_get_priv_mess_page_url('delete-message', $row->id, '&confirm_message_deletion=yes&return=' . urlencode($_GET['rdr'])); ?> " class="nice_link" onclick="return privatedel()"><?php _e("Confirm Deletion", 'ProjectTheme'); ?> </a> <?php } } ?> </div> </div> </div> <script type="text/javascript"> function privatedel() { var ms='Want To Delete <?php echo $row->subject; ?> '; //alert(ms); if(confirm(ms)) {return true;} else {return false;} } </script> <!-- page content here --> <?php } elseif ($third_page == 'read-message') { global $current_user, $wpdb; get_currentuserinfo(); $myuid = $current_user->ID; $id = $_GET['id']; $s = "select * from " . $wpdb->prefix . "project_pm where id='{$id}' AND (user='******' OR initiator='{$myuid}')"; $r = $wpdb->get_results($s); $row = $r[0]; if ($myuid == $row->initiator) { $owner = true; } else { $owner = false; } // mark messags is read if user = myuid if ($myuid == $row->user) { $wpdb->query("update " . $wpdb->prefix . "project_pm set rd='1' where id='{$row->id}'"); } ?> <!-- page content here --> <div class="my_box3"> <div class="box_title"><?php _e("Read Message: ", "ProjectTheme"); echo " " . $row->subject; ?> </div> <div class="box_content"> <?php echo $row->content; ?> <br/> <br/> <?php if (!empty($row->file_attached)) { echo sprintf(__('File Attached: %s', 'ProjectTheme'), '<a href="' . wp_get_attachment_url($row->file_attached) . '">' . wp_get_attachment_url($row->file_attached) . "</a>"); } ?> <?php if ($owner == false) { ?> <br><a href="<?php echo ProjectTheme_get_priv_mess_page_url('send', '', '&pid=' . $row->pid . '&uid=' . $row->initiator . '&in_reply_to=' . $row->id); ?> " class="nice_link"><?php _e("Reply", 'ProjectTheme'); ?> </a> <?php } ?> </div> </div> <!-- page content here --> <?php } elseif ($third_page == 'send') { ?> <?php $pid = $_GET['pid']; $uid = $_GET['uid']; $user = get_userdata($uid); if (!empty($pid)) { $post = get_post($pid); $subject = "RE: " . $post->post_title; } elseif (!empty($_GET['in_reply_to'])) { global $wpdb; $ssp = "select * from " . $wpdb->prefix . "project_pm where id='" . $_GET['in_reply_to'] . "'"; $sspq = $wpdb->get_results($ssp); if (strpos($sspq[0]->subject, 'RE:') !== false) { $subject = $sspq[0]->subject; } else { $subject = "RE: " . substr($sspq[0]->subject, 0, 30); } //$sspq[0]->subject; } if (isset($_POST['send_a'])) { require_once ABSPATH . "wp-admin" . '/includes/file.php'; require_once ABSPATH . "wp-admin" . '/includes/image.php'; if (!empty($_FILES['file_instant']['name'])) { $pids = 0; $upload_overrides = array('test_form' => true); $uploaded_file = wp_handle_upload($_FILES['file_instant'], $upload_overrides); $file_name_and_location = $uploaded_file['file']; $file_title_for_media_library = $_FILES['file_instant']['name']; $arr_file_type = wp_check_filetype(basename($_FILES['file_instant']['name'])); $uploaded_file_type = $arr_file_type['type']; if ($uploaded_file_type == "application/zip" or $uploaded_file_type == "application/pdf" or $uploaded_file_type == "application/msword" or $uploaded_file_type == "application/msexcel" or $uploaded_file_type == "application/doc" or $uploaded_file_type == "application/docx" or $uploaded_file_type == "application/xls" or $uploaded_file_type == "application/xlsx" or $uploaded_file_type == "application/csv" or $uploaded_file_type == "application/ppt" or $uploaded_file_type == "application/pptx" or $uploaded_file_type == "application/vnd.ms-excel" or $uploaded_file_type == "application/txt" or $uploaded_file_type == "text/plain" or $uploaded_file_type == "application/vnd.ms-powerpoint" or $uploaded_file_type == "application/vnd.openxmlformats-officedocument.presentationml.presentation" or $uploaded_file_type == "application/octet-stream" or $uploaded_file_type == "image/png" or $uploaded_file_type == "image/jpg" or $uploaded_file_type == "image/jpeg" or $uploaded_file_type == "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" or $uploaded_file_type == "application/vnd.openxmlformats-officedocument.wordprocessingml.document") { $attachment = array('post_mime_type' => $uploaded_file_type, 'post_title' => 'Uploaded ZIP ' . addslashes($file_title_for_media_library), 'post_content' => '', 'post_status' => 'inherit', 'post_parent' => 0, 'post_author' => $uid); $attach_id = wp_insert_attachment($attachment, $file_name_and_location, $pids); $attach_data = wp_generate_attachment_metadata($attach_id, $file_name_and_location); wp_update_attachment_metadata($attach_id, $attach_data); } else { $error_mm = '1'; } } $subject = $_POST['subject_a']; $message = $_POST['message_a']; $uids = $_POST['to_as']; if (empty($uids)) { $uids = $_GET['uid']; } if (!empty($_POST['send-to-all']) && $_POST['send-to-all'] == 'on') { global $current_user; get_currentuserinfo(); $users = get_users(); foreach ($users as $one) { $uids = $one->ID; ProjectTheme_send_priv_mess_to_person($uids, $uid, $error_mm, $subject, $message, $pid, $attach_id, $user, $post, $cant_send, true); } ?> <div class="my_box3"> <div class="padd10"> <?php echo sprintf(__('Your message has been sent to all users.', 'ProjectTheme')); ?> </div> </div> <?php } elseif (!empty($_POST['to_as']) || !empty($_POST['projectss'])) { global $current_user; get_currentuserinfo(); if (is_array($_POST['to_as']) || is_array($_POST['projectss'])) { for ($index = 0; $index < count($_POST['projectss']); $index++) { if ($_POST['projectss'][$index] !== "") { $to_as = get_user_by('id', $_POST['projectss'][$index]); } else { $to_as = get_user_by('email', $_POST['to_as'][$index]); } $uids = projectTheme_get_userid_from_username($to_as->user_login); ProjectTheme_send_priv_mess_to_person($uids, $uid, $error_mm, $subject, $message, $pid, $attach_id, $user, $post, $cant_send); } } else { // it isn't array if ($_POST['projectss'] !== '') { $to_as = get_user_by('id', $_POST['projectss']); } else { $to_as = get_user_by('email', $_POST['to_as']); } $uids = projectTheme_get_userid_from_username($to_as->user_login); ProjectTheme_send_priv_mess_to_person($uids, $uid, $error_mm, $subject, $message, $pid, $attach_id, $user, $post, $cant_send); //if($uids == $current_user->ID) { $uids = false; $error_mm = 1; $cant_send = 1; } } } } else { ?> <script> function getdataoftextarea() { alert($(".message_content").val()); } function validate_form() { var to = document.form5.to_as.value; if (to == null || to == "") { alert("Please enter email id"); document.form5.to_as.focus(); return false; } var to = document.form5.to_as.value; var email= /^\w+([\.-]?\w+)*@\w+([\.-]?\w+)*(\.\w{2,3})+$/; var em= email.test(to); if(em==false) { alert("please enter valide email id"); document.form5.to_as.focus(); return false; } var subj = document.form5.subject_a.value; if (subj == null || subj == "") { alert("Please fill the subject field"); document.form5.subject_a.focus(); return false; } // var x1 = tinymce.get('jander').getContent(); // alert(x1); var x = tinymce.get('message_a').getContent(); if (x == null || x == "") { alert("MESSAGE FIELD CANNOT BE BLANK"); document.form5.message_a.focus(); return false; } } </script> <div class="my_box3"> <div class="box_title"><?php _e("Send Private Message to: ", "ProjectTheme"); ?> <?php echo $user->user_login; ?> </div> <div class="box_content"> <form method="post" enctype="multipart/form-data" name="form5" id="form5" onsubmit="return validate_form();"> <input type="hidden" name="tm" value="<?php echo current_time('timestamp', 0); ?> " /> <table> <?php if (empty($uid)) { $rtt = ProjectTheme_get_my_awarded_projects2($current_user->ID, true); ?> <?php if (current_user_can('manage_options')) { ?> <tr> <td width="140" class="no_wrap"><?php _e("Send To All", "ProjectTheme"); ?> :</td> <td> <input type="checkbox" id="send-to-all" name="send-to-all" /> <span>Send message to ALL users on site</span> </td> </tr> <script> jQuery(document).ready(function(){ jQuery('#send-to-all').on('change', function(){ var inputs = jQuery('.send-to-raw').children('td').children('input,select'); if ($(this).attr('checked')) { inputs.attr('disabled', true); } else { inputs.removeAttr('disabled'); } }); }); </script> <?php } ?> <tr class="send-to-raw"> <td width="140" class="no_wrap"><?php _e("Send To (e-mail)", "ProjectTheme"); ?> <font style="color:red;">*</font> :</td> <td width="200"><input size="20" name="to_as[]" class="to_as" type="text" value="" /> <?php if ($rtt) { _e('or', 'ProjectTheme'); echo " " . $rtt; } ?> </td> <td><input type="button" class="add_email" value="+" onclick="add_raw()"/></td> </tr> <?php } ?> <tr> <td width="140" class="no_wrap"><?php _e("Subject", "ProjectTheme"); ?> <font style="color:red;">*</font> :</td> <td><input size="50" name="subject_a" id="subject_a" type="text" value="<?php echo $subject; ?> " /></td> </tr> <script> function add_raw(){ var html = jQuery('.send-to-raw:first').html(); var btn_remove = '<td><input type="button" class="remove_email" value="X" onclick="remove_raw(this)"/></td>' html = '<tr class="send-to-raw">' + html +btn_remove +'</tr>'; jQuery('.send-to-raw:last').after(html); } function remove_raw(el){ jQuery(el).parent('td').parent('tr').remove(); } jQuery(document).ready(function(){ tinyMCE.init({ mode : "specific_textareas", theme : "modern", /*plugins : "autolink, lists, spellchecker, style, layer, table, advhr, advimage, advlink, emotions, iespell, inlinepopups, insertdatetime, preview, media, searchreplace, print, contextmenu, paste, directionality, fullscreen, noneditable, visualchars, nonbreaking, xhtmlxtras, template",*/ editor_selector :"tinymce-enabled" }); }); </script> <tr> <td valign="top" class="no_wrap"><?php _e("Message", "ProjectTheme"); ?> <font style="color:red;">*</font> :</td> <td><textarea name="message_a" class="tinymce-enabled" id="message_a" rows="6" cols="50" ></textarea></td> </tr> <tr> <td valign="top" class="no_wrap"><?php _e("Attach File", "ProjectTheme"); ?> :</td> <td> <div style="display: block;"> <span style="display:inline-block;"><input type="file" id="file_instant" name="file_instant" class="" multiple=""/></span> <span class="del21" style="float:right;cursor:pointer;" value="clear" onclick="file_clear(); textarea_instant();">Delete</span> </div> <div style="display: block;"> <?php _e('Only PDF, TXT, ZIP, Office files and Images.', 'ProjectTheme'); ?> </div> </td> </tr> <tr> <td width="140"> </td> <td></td> </tr> <tr> <td width="140"> </td> <td><input name="send_a" class="submit_bottom2" type="submit" value="<?php _e("Send Message", 'ProjectTheme'); ?> " /></td> </tr> </table> </form> </div> </div> <?php } } ?> </div> <!-- end dif content --> <script type="text/javascript"> $(document).ready(function(){ $('.conv_time').each(function(){ var tm = parseInt($(this).text())*1000; console.log(tm); var time = new Date(tm); $(this).text(time.toLocaleString()); }); }); function file_clear(){ $('#file_instant').val(''); } </script> <?php ProjectTheme_get_users_links(); ?> <?php }
function ProjectTheme_my_account_private_messages_area_function() { global $current_user, $wpdb, $wp_query; get_currentuserinfo(); $uid = $current_user->ID; $myuid = $uid; ?> <?php global $wpdb, $wp_rewrite, $wp_query; $third_page = $wp_query->query_vars['pg']; if (empty($third_page)) { $third_page = 'home'; } ?> <div class="clear10"></div> <div id="content" class="account-main-area"> <div class="my_box3"><div class="padd10"> <div class="clear10"></div> <ul class="cms_cms"> <li><a href="<?php echo ProjectTheme_get_priv_mess_page_url(); ?> " class="green_btn"><?php _e("Messaging Home", "ProjectTheme"); ?> </a></li> <li> <a href="<?php echo ProjectTheme_get_priv_mess_page_url('send'); ?> " class="green_btn"><?php _e("Send New Message", "ProjectTheme"); ?> </a></li> <li><a href="<?php echo ProjectTheme_get_priv_mess_page_url('inbox'); ?> " class="green_btn"><?php _e("Inbox", "ProjectTheme"); global $current_user; get_currentuserinfo(); $rd = projectTheme_get_unread_number_messages($current_user->ID); if ($rd > 0) { echo ' (' . $rd . ')'; } ?> </a></li> <li><a href="<?php echo ProjectTheme_get_priv_mess_page_url('sent-items'); ?> " class="green_btn"><?php _e("Sent Items", "ProjectTheme"); ?> </a></li> </ul> </div></div> <div class="clear10"></div> <?php if ($third_page == 'home') { global $current_user; get_currentuserinfo(); $myuid = $current_user->ID; ?> <!-- page content here --> <div class="my_box3"> <div class="box_title"><?php _e("Latest Received Messages", "ProjectTheme"); ?> </div> <div class="box_content"> <?php global $wpdb; $uidsss = $current_user->ID; $s = "select * from " . $wpdb->prefix . "project_pm where user='******' AND show_to_destination='1' and approved='1' order by id desc limit 4"; $r = $wpdb->get_results($s); if (count($r) > 0) { echo '<table width="100%">'; echo '<tr>'; echo '<td>' . __('From User', 'ProjectTheme') . '</td>'; echo '<td>' . __('Subject', 'ProjectTheme') . '</td>'; echo '<td>' . __('Date', 'ProjectTheme') . '</td>'; echo '<td>' . __('Options', 'ProjectTheme') . '</td>'; echo '</tr>'; foreach ($r as $row) { if ($row->rd == 0) { $cls = 'bold_stuff'; } else { $cls = ''; } $user = get_userdata($row->initiator); echo '<tr>'; echo '<td class="' . $cls . '"><a href="' . get_bloginfo('siteurl') . '/?p_action=user_profile&post_author=' . $user->ID . '">' . $user->user_login . '</a></td>'; echo '<td class="' . $cls . '">' . $row->subject . '</td>'; echo '<td class="' . $cls . '">' . date_i18n('d-M-Y H:i:s', $row->datemade) . '</td>'; echo '<td><a href="' . ProjectTheme_get_priv_mess_page_url('read-message', $row->id) . '">' . __('Read', 'ProjectTheme') . '</a> | <a href="' . ProjectTheme_get_priv_mess_page_url('delete-message', $row->id) . '">' . __('Delete', 'ProjectTheme') . '</a></td>'; echo '</tr>'; } echo '</table>'; } else { _e('No messages here.', 'ProjectTheme'); } ?> </div> </div> <!--#######--> <div class="clear10"></div> <div class="my_box3"> <div class="box_title"><?php _e("Latest Sent Items", "ProjectTheme"); ?> </div> <div class="box_content"> <?php global $wpdb; $uidss = $current_user->ID; $s = "select * from " . $wpdb->prefix . "project_pm where initiator='{$uidss}' AND show_to_source='1' order by id desc limit 4"; $r = $wpdb->get_results($s); if (count($r) > 0) { echo '<table width="100%">'; echo '<tr>'; echo '<td>' . __('To User', 'ProjectTheme') . '</td>'; echo '<td>' . __('Subject', 'ProjectTheme') . '</td>'; echo '<td>' . __('Date', 'ProjectTheme') . '</td>'; echo '<td>' . __('Options', 'ProjectTheme') . '</td>'; echo '</tr>'; foreach ($r as $row) { //if($row->rd == 0) $cls = 'bold_stuff'; //else $cls = ''; $user = get_userdata($row->user); echo '<tr>'; echo '<td class="' . $cls . '"><a href="' . ProjectTheme_get_user_profile_link($row->user) . '">' . $user->user_login . '</a></td>'; echo '<td class="' . $cls . '">' . $row->subject . '</td>'; echo '<td class="' . $cls . '">' . date_i18n('d-M-Y H:i:s', $row->datemade) . '</td>'; echo '<td><a href="' . ProjectTheme_get_priv_mess_page_url('read-message', $row->id) . '">' . __('Read', 'ProjectTheme') . '</a> | <a href="' . ProjectTheme_get_priv_mess_page_url('delete-message', $row->id) . '">' . __('Delete', 'ProjectTheme') . '</a></td>'; echo '</tr>'; } echo '</table>'; } else { _e('No messages here.', 'ProjectTheme'); } ?> </div> </div> <!-- page content here --> <?php } elseif ($third_page == 'inbox') { global $current_user; get_currentuserinfo(); $myuid = $current_user->ID; //echo $myuid; ?> <!-- page content here --> <div class="my_box3"> <div class="box_title"><?php _e("Private Messages: Inbox", "ProjectTheme"); ?> </div> <div class="box_content"> <?php global $wpdb; $page_rows = 20; $page_rows = apply_filters('ProjectTheme_nr_of_messages_priv_pagination', $page_rows); $pagenum = isset($_GET['pagenum']) ? $_GET['pagenum'] : 1; $max = ' limit ' . ($pagenum - 1) * $page_rows . ',' . $page_rows; $s = "select count(id) tots from " . $wpdb->prefix . "project_pm where user='******' AND show_to_destination='1' and approved='1'"; $r = $wpdb->get_results($s); $total = $r[0]->tots; $last = ceil($total / $page_rows); //------------------------- $s = "select * from " . $wpdb->prefix . "project_pm where user='******' AND show_to_destination='1' and approved='1' order by id desc " . $max; $r = $wpdb->get_results($s); if (count($r) > 0) { ?> <script> $(document).ready(function() { //set initial state. $('#select_all_stuff').change(function() { if($(this).is(":checked")) { $('.message_select_bx').attr("checked", true); } else { $('.message_select_bx').attr("checked", false); } }); }); </script> <?php echo '<form method="post" action="' . ProjectTheme_get_priv_mess_page_url('delete-message', '', '&return=inbox') . '">'; echo '<table width="100%">'; echo '<tr>'; echo '<td><input type="checkbox" name="" id="select_all_stuff" value="1" /> ' . __('Select All', 'ProjectTheme') . ' </td>'; echo '<td>' . __('From User', 'ProjectTheme') . '</td>'; echo '<td>' . __('Subject', 'ProjectTheme') . '</td>'; echo '<td>' . __('Date', 'ProjectTheme') . '</td>'; echo '<td>' . __('Options', 'ProjectTheme') . '</td>'; echo '</tr>'; foreach ($r as $row) { if ($row->rd == 0) { $cls = 'bold_stuff'; } else { $cls = ''; } $user = get_userdata($row->initiator); echo '<tr>'; echo '<td><input type="checkbox" class="message_select_bx" name="message_ids[]" value="' . $row->id . '" /></td>'; echo '<td class="' . $cls . '"><a href="' . get_bloginfo('siteurl') . '/?p_action=user_profile&post_author=' . $user->ID . '">' . $user->user_login . '</a></td>'; echo '<td class="' . $cls . '">' . substr($row->subject, 0, 30) . '</td>'; echo '<td class="' . $cls . '">' . date_i18n('d-M-Y H:i:s', $row->datemade) . '</td>'; echo '<td><a href="' . ProjectTheme_get_priv_mess_page_url('read-message', $row->id) . '">' . __('Read', 'ProjectTheme') . '</a> | <a href="' . ProjectTheme_get_priv_mess_page_url('delete-message', $row->id) . '">' . __('Delete', 'ProjectTheme') . '</a></td>'; echo '</tr>'; } echo '<tr><td colspan="5"><input type="submit" value="' . __('Delete Selected', 'ProjectTheme') . '" name="delete_sel" /></td></tr>'; echo '<tr><td colspan="5"> '; echo ProjectTheme_get_my_pagination_main(get_bloginfo('siteurl') . "/?page_id=" . get_option('ProjectTheme_my_account_private_messages_id'), $pagenum, 'pagenum', $last, '&pg=inbox'); echo ' </td></tr>'; echo '</table></form>'; } else { _e('No messages here.', 'ProjectTheme'); } ?> </div> </div> <!-- page content here --> <?php } elseif ($third_page == 'sent-items') { global $current_user; get_currentuserinfo(); $myuid = $current_user->ID; ?> <script> $(document).ready(function() { //set initial state. $('#select_all_stuff').change(function() { if($(this).is(":checked")) { $('.message_select_bx').attr("checked", true); } else { $('.message_select_bx').attr("checked", false); } }); }); </script> <!-- page content here --> <div class="my_box3"> <div class="box_title"><?php _e("Private Messages: Sent Items", "ProjectTheme"); ?> </div> <div class="box_content"> <?php global $wpdb; $page_rows = 20; $page_rows = apply_filters('ProjectTheme_nr_of_messages_priv_pagination', $page_rows); $pagenum = isset($_GET['pagenum']) ? $_GET['pagenum'] : 1; $max = ' limit ' . ($pagenum - 1) * $page_rows . ',' . $page_rows; //--------------------------------- $s = "select count(id) tots from " . $wpdb->prefix . "project_pm where initiator='{$myuid}' AND show_to_source='1' and approved='1'"; $r = $wpdb->get_results($s); $total = $r[0]->tots; $last = ceil($total / $page_rows); //--------------------------------- $s = "select * from " . $wpdb->prefix . "project_pm where initiator='{$myuid}' AND show_to_source='1' and approved='1' order by id desc " . $max; $r = $wpdb->get_results($s); if (count($r) > 0) { echo '<form method="post" action="' . ProjectTheme_get_priv_mess_page_url('delete-message', '', '&return=outbox') . '">'; echo '<table width="100%">'; echo '<tr>'; echo '<td><input type="checkbox" name="" id="select_all_stuff" value="1" /> ' . __('Select All', 'ProjectTheme') . ' </td>'; echo '<td>' . __('To User', 'ProjectTheme') . '</td>'; echo '<td>' . __('Subject', 'ProjectTheme') . '</td>'; echo '<td>' . __('Date', 'ProjectTheme') . '</td>'; echo '<td>' . __('Options', 'ProjectTheme') . '</td>'; echo '</tr>'; foreach ($r as $row) { //if($row->rd == 0) $cls = 'bold_stuff'; //else $cls = ''; $user = get_userdata($row->user); echo '<tr>'; echo '<td><input type="checkbox" class="message_select_bx" name="message_ids[]" value="' . $row->id . '" /></td>'; echo '<td class="' . $cls . '"><a href="' . ProjectTheme_get_user_profile_link($row->user) . '">' . $user->user_login . '</a></td>'; echo '<td class="' . $cls . '">' . substr($row->subject, 0, 30) . '</td>'; echo '<td class="' . $cls . '">' . date_i18n('d-M-Y H:i:s', $row->datemade) . '</td>'; echo '<td><a href="' . ProjectTheme_get_priv_mess_page_url('read-message', $row->id) . '">' . __('Read', 'ProjectTheme') . '</a> | <a href="' . ProjectTheme_get_priv_mess_page_url('delete-message', $row->id) . '">' . __('Delete', 'ProjectTheme') . '</a></td>'; echo '</tr>'; } echo '<tr><td colspan="5"><input type="submit" value="' . __('Delete Selected', 'ProjectTheme') . '" name="delete_sel" /></td></tr>'; echo '<tr><td colspan="5"> '; echo ProjectTheme_get_my_pagination_main(get_bloginfo('siteurl') . "/?page_id=" . get_option('ProjectTheme_my_account_private_messages_id'), $pagenum, 'pagenum', $last, '&pg=sent-items'); echo ' </td></tr>'; echo '</table></form>'; } else { _e('No messages here.', 'ProjectTheme'); } ?> </div> </div> <!-- page content here --> <?php } elseif ($third_page == 'delete-message') { $id = $_GET['id']; $s = "select * from " . $wpdb->prefix . "project_pm where id='{$id}' AND (user='******' OR initiator='{$myuid}')"; $r = $wpdb->get_results($s); $row = $r[0]; global $current_user; get_currentuserinfo(); $myuid = $current_user->ID; if ($myuid == $row->initiator) { $owner = true; } else { $owner = false; } //if(!$owner) //$wpdb->query("update_i18n ".$wpdb->prefix."auction_pm set rd='1' where id='{$row->id}'"); ?> <!-- page content here --> <div class="my_box3"> <div class="padd10"> <div class="box_title"><?php if (isset($_POST['delete_sel'])) { _e("Delete Multiple Messages: ", "ProjectTheme"); } else { _e("Delete Message: ", "ProjectTheme"); echo " " . $row->subject; } ?> </div> <div class="box_content"> <?php if (isset($_POST['message_ids'])) { $message_ids2 = $_POST['message_ids']; foreach ($message_ids2 as $message_id) { $ss1 = "select * from " . $wpdb->prefix . "project_pm where id='{$message_id}'"; $rr1 = $wpdb->get_results($ss1); $rrow1 = $rr1[0]; echo '#' . $rrow1->id . " " . $rrow1->subject . '<br/>'; } echo '<br/>'; } ?> <?php //echo $row->content; ?> <br/> <br/> <?php if (1) { //$owner == false): if (isset($_POST['delete_sel'])) { $message_ids = $_POST['message_ids']; if (count($message_ids) == 0) { _e("No messsages selected.", "ProjectTheme"); } else { $attash = ''; foreach ($message_ids as $message_id) { $attash .= '&message_id[]=' . $message_id; } ?> <a href="<?php echo $_GET['rdr']; ?> " class="nice_link"><?php _e("Cancel", 'ProjectTheme'); ?> </a> <a href="<?php echo ProjectTheme_get_priv_mess_page_url('delete-message', '', '&confirm_message_deletion=yes&return=' . urlencode($_GET['rdr'])) . $attash; ?> " class="nice_link"><?php _e("Confirm Deletion", 'ProjectTheme'); ?> </a> <?php } } else { ?> <a href="<?php echo $_GET['rdr']; ?> " class="nice_link"><?php _e("Cancel", 'ProjectTheme'); ?> </a> <a href="<?php echo ProjectTheme_get_priv_mess_page_url('delete-message', $row->id, '&confirm_message_deletion=yes&return=' . urlencode($_GET['rdr'])); ?> " class="nice_link"><?php _e("Confirm Deletion", 'ProjectTheme'); ?> </a> <?php } } ?> </div> </div> </div> <!-- page content here --> <?php } elseif ($third_page == 'read-message') { global $current_user, $wpdb; get_currentuserinfo(); $myuid = $current_user->ID; $id = $_GET['id']; $s = "select * from " . $wpdb->prefix . "project_pm where id='{$id}' AND (user='******' OR initiator='{$myuid}')"; $r = $wpdb->get_results($s); $row = $r[0]; if ($myuid == $row->initiator) { $owner = true; } else { $owner = false; } if (!$owner) { $wpdb->query("update " . $wpdb->prefix . "project_pm set rd='1' where id='{$row->id}'"); } ?> <!-- page content here --> <div class="my_box3"> <div class="box_title"><?php _e("Read Message: ", "ProjectTheme"); echo " " . $row->subject; ?> </div> <div class="box_content"> <?php echo $row->content; ?> <br/> <br/> <?php if (!empty($row->file_attached)) { echo sprintf(__('File Attached: %s', 'ProjectTheme'), '<a href="' . wp_get_attachment_url($row->file_attached) . '">' . wp_get_attachment_url($row->file_attached) . "</a>"); } ?> <?php if ($owner == false) { ?> <a href="<?php echo ProjectTheme_get_priv_mess_page_url('send', '', '&pid=' . $row->pid . '&uid=' . $row->initiator . '&in_reply_to=' . $row->id); ?> " class="nice_link"><?php _e("Reply", 'ProjectTheme'); ?> </a> <?php } ?> </div> </div> <!-- page content here --> <?php } elseif ($third_page == 'send') { ?> <?php $pid = $_GET['pid']; $uid = $_GET['uid']; $user = get_userdata($uid); if (!empty($pid)) { $post = get_post($pid); $subject = "RE: " . $post->post_title; } elseif (!empty($_GET['in_reply_to'])) { global $wpdb; $ssp = "select * from " . $wpdb->prefix . "project_pm where id='" . $_GET['in_reply_to'] . "'"; $sspq = $wpdb->get_results($ssp); if (strpos($sspq[0]->subject, 'RE:') !== false) { $subject = $sspq[0]->subject; } else { $subject = "RE: " . $sspq[0]->subject; } } if (isset($_POST['send_a'])) { require_once ABSPATH . "wp-admin" . '/includes/file.php'; require_once ABSPATH . "wp-admin" . '/includes/image.php'; if (!empty($_FILES['file_instant']['name'])) { $pids = 0; $upload_overrides = array('test_form' => false); $uploaded_file = wp_handle_upload($_FILES['file_instant'], $upload_overrides); $file_name_and_location = $uploaded_file['file']; $file_title_for_media_library = $_FILES['file_instant']['name']; $arr_file_type = wp_check_filetype(basename($_FILES['file_instant']['name'])); $uploaded_file_type = $arr_file_type['type']; if ($uploaded_file_type == "application/zip" or $uploaded_file_type == "application/pdf" or $uploaded_file_type == "application/msword" or $uploaded_file_type == "application/msexcel" or $uploaded_file_type == "application/doc" or $uploaded_file_type == "application/docx" or $uploaded_file_type == "application/xls" or $uploaded_file_type == "application/xlsx" or $uploaded_file_type == "application/csv" or $uploaded_file_type == "application/ppt" or $uploaded_file_type == "application/pptx" or $uploaded_file_type == "application/vnd.ms-excel" or $uploaded_file_type == "application/vnd.ms-powerpoint" or $uploaded_file_type == "application/vnd.openxmlformats-officedocument.presentationml.presentation" or $uploaded_file_type == "application/octet-stream" or $uploaded_file_type == "image/png" or $uploaded_file_type == "image/jpg" or $uploaded_file_type == "image/jpeg" or $uploaded_file_type == "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" or $uploaded_file_type == "application/vnd.openxmlformats-officedocument.wordprocessingml.document") { $attachment = array('post_mime_type' => $uploaded_file_type, 'post_title' => 'Uploaded ZIP ' . addslashes($file_title_for_media_library), 'post_content' => '', 'post_status' => 'inherit', 'post_parent' => 0, 'post_author' => $uid); $attach_id = wp_insert_attachment($attachment, $file_name_and_location, $pids); $attach_data = wp_generate_attachment_metadata($attach_id, $file_name_and_location); wp_update_attachment_metadata($attach_id, $attach_data); } else { $error_mm = '1'; } } $subject = $_POST['subject_a']; $message = $_POST['message_a']; $uids = $_POST['to_a']; if (isset($_POST['projectss'])) { if (!empty($_POST['projectss'])) { $uids = $_POST['projectss']; } } if (!empty($_POST['to_as'])) { global $current_user; get_currentuserinfo(); $uids = projectTheme_get_userid_from_username($_POST['to_as']); if ($uids == $current_user->ID) { $uids = false; $error_mm = 1; $cant_send = 1; } } if (empty($uids)) { $uids = $_GET['uid']; } if ($uids != false and $error_mm != "1") { global $current_user; get_currentuserinfo(); $myuid = $current_user->ID; //echo $message; //********************************************* $ProjectTheme_moderate_private_messages = get_option('ProjectTheme_moderate_private_messages'); if ($ProjectTheme_moderate_private_messages == "yes") { $ProjectTheme_moderate_private_messages = true; } else { $ProjectTheme_moderate_private_messages = false; } //-------------------------- if ($ProjectTheme_moderate_private_messages == true) { $approved = '0'; $show_to_destination = '0'; } else { $approved = '1'; $show_to_destination = '1'; } //********************************************* global $wpdb; $wpdb->show_errors = true; $tm = $_POST['tm']; //current_time('timestamp',0); $sr = "select * from " . $wpdb->prefix . "project_pm where initiator='{$myuid}' and user='******' and datemade='{$tm}'"; $rr = $wpdb->get_results($sr); if (count($rr) == 0) { if (empty($pid)) { $pid = 0; } $s = "insert into " . $wpdb->prefix . "project_pm \n\t\t\t\t\t(approved, subject, content, datemade, pid, initiator, user, file_attached, show_to_destination) \n\t\t\t\t\tvalues('{$approved}','{$subject}','{$message}','{$tm}','{$pid}','{$myuid}','{$uids}', '{$attach_id}', '{$show_to_destination}')"; $wpdb->query($s); //echo $s; //echo $wpdb->last_error; //----------------------- $user = get_userdata($uid); $message = sprintf(__("You have just received a private message regarding your project: <a href='%s'>%s</a><br/>\n\t\t\t\t\t<a href='%s'>Click here to read the message</a>.", "ProjectTheme"), get_permalink($pid), $post->post_title, get_bloginfo('siteurl') . "/my-account/private-messages"); //sitemile_send_email($user->user_email, __('Private Message Received','ProjectTheme') , $message); if ($ProjectTheme_moderate_private_messages == false) { ProjectTheme_send_email_on_priv_mess_received($myuid, $uids); } else { //send message to admin to moderate } } //----------------------- ?> <div class="my_box3"> <div class="padd10"> <?php if ($ProjectTheme_moderate_private_messages == false) { _e('Your message has been sent.', 'ProjectTheme'); } else { _e('Your message has been sent but the receiver will receive it only after moderation.', 'ProjectTheme'); } ?> </div> </div> <?php } else { if ($error_mm == "1") { if ($cant_send == 1) { echo __('You cannot send a message to yourself.', 'ProjectTheme'); } else { echo sprintf(__('Wrong File format: %s', 'ProjectTheme'), $uploaded_file_type); } } else { _e('ERROR! wrong username provided.', 'ProjectTheme'); } } } else { ?> <div class="my_box3"> <div class="box_title"><?php _e("Send Private Message to: ", "ProjectTheme"); ?> <?php echo $user->user_login; ?> </div> <div class="box_content"> <form method="post" enctype="multipart/form-data"> <input type="hidden" name="tm" value="<?php echo current_time('timestamp', 0); ?> " /> <table> <?php if (empty($uid)) { $rtt = ProjectTheme_get_my_awarded_projects2($current_user->ID); ?> <tr> <td width="140"><?php _e("Send To", "ProjectTheme"); ?> :</td> <td><input size="20" name="to_as" type="text" value="" /> <?php if ($rtt) { _e('or', 'ProjectTheme'); echo " " . $rtt; } ?> </td> </tr> <?php } ?> <tr> <td width="140"><?php _e("Subject", "ProjectTheme"); ?> :</td> <td><input size="50" name="subject_a" type="text" value="<?php echo $subject; ?> " /></td> </tr> <script> jQuery(document).ready(function(){ tinyMCE.init({ mode : "specific_textareas", theme : "modern", /*plugins : "autolink, lists, spellchecker, style, layer, table, advhr, advimage, advlink, emotions, iespell, inlinepopups, insertdatetime, preview, media, searchreplace, print, contextmenu, paste, directionality, fullscreen, noneditable, visualchars, nonbreaking, xhtmlxtras, template",*/ editor_selector :"tinymce-enabled" }); }); </script> <tr> <td valign="top"><?php _e("Message", "ProjectTheme"); ?> :</td> <td><textarea name="message_a" class="tinymce-enabled" rows="6" cols="50"></textarea></td> </tr> <tr> <td valign="top"><?php _e("Attach File", "ProjectTheme"); ?> :</td> <td><input type="file" name="file_instant" class="" /> <?php _e('Only PDF, ZIP, Office files and Images.', 'ProjectTheme'); ?> </td> </tr> <tr> <td width="140"> </td> <td></td> </tr> <tr> <td width="140"> </td> <td><input name="send_a" class="submit_bottom2" type="submit" value="<?php _e("Send Message", 'ProjectTheme'); ?> " /></td> </tr> </table> </form> </div> </div> <?php } } ?> </div> <!-- end dif content --> <?php ProjectTheme_get_users_links(); ?> <?php }