get_project_meta($id,'project_auth_code',true); $auth_id = sanitize_text_field($auth_id); $project = $wpdb->get_row( "SELECT * FROM {$wpdb->prefix}wppm_project where id = $id" ); $project_comment = $wpdb->get_results( "SELECT * FROM {$wpdb->prefix}wppm_project_comment where proj_id=".$id." ORDER BY create_time DESC"); if(isset($project->users)){ $users = explode(",",$project->users); }else{ $users = ""; } $wppm_users_role = get_option('wppm_user_role'); if(isset($project->status)){ $project_status = $wpdb->get_row("SELECT * FROM {$wpdb->prefix}wppm_project_statuses where id=".$project->status); } if(isset($project->cat_id)){ $project_category = $wpdb->get_row("SELECT * FROM {$wpdb->prefix}wppm_project_categories where id=".$project->cat_id); } if(!empty($project->description)){ $project_description = stripslashes((htmlspecialchars_decode($project->description, ENT_QUOTES))); } if($wppm_project_time == 1){ $proj_start_date = isset($project->start_date)? $project->start_date:""; $proj_end_date = isset($project->end_date) ? $project->end_date: "" ; } elseif($wppm_project_time == 0){ $psDate = isset($project->start_date) ? new DateTime($project->start_date): ""; $peDate = isset($project->end_date) ? new DateTime($project->end_date):""; $proj_start_date = !empty($psDate) ? $psDate->format('Y-m-d'):""; $proj_end_date = !empty($peDate) ? $peDate->format('Y-m-d'):""; } ?>