ID); $appearance_settings = get_option("wppm-ap-task-list"); $wppm_task_time = get_option('wppm_task_time'); $wppm_current_user_capability = get_user_meta( $current_user->ID, 'wppm_capability', true ); if($current_user->has_cap('manage_options') || $wppm_current_user_capability=='wppm_admin'){ $query = ( "SELECT * FROM {$wpdb->prefix}wppm_task where project='$project_id'"); } else{ $query = ( "SELECT Task.* FROM {$wpdb->prefix}wppm_task AS Task Left join {$wpdb->prefix}wppm_project proj ON Task.project = proj.id Left join {$wpdb->prefix}wppm_project_users proj_users ON Task.project = proj_users.proj_id Left join {$wpdb->prefix}wppm_project_meta proj_meta ON Task.project = proj_meta.project_id where Task.project = '$project_id' AND ((FIND_IN_SET('$cu_id',Task.users)>0) OR (Task.created_by= '$cu_id') OR (proj_users.user_id = '$cu_id' AND proj_users.role_id = 1 AND (FIND_IN_SET('$cu_id',proj.users)>0)) OR (Task.project = proj_meta.project_id AND proj_meta.meta_key='public_project' AND proj_meta.meta_value=1) OR (Task.project = proj.id AND proj.created_by='$cu_id')) Group by Task.id"); } $query = apply_filters('wppm_get_project_tasks_query',$query,$project_id); $tasks = $wpdb->get_results($query); ob_start(); ?>