chamilo / chamilo-lms

        $orderby = 'ORDER BY user.lastname, user.firstname';

    }

    if (api_get_session_id()) {

        $session_info = api_get_session_info(api_get_session_id());

        $user_to_avoid = "'".$session_info['id_coach']."', '".$session_info['session_admin_id']."'";

        //not showing coaches

        $sql = "SELECT DISTINCT user.id, user.lastname, user.firstname, thread_id

                  FROM $t_posts p, $t_users user, $t_session_rel_user session_rel_user_rel_course

                  WHERE p.poster_id = user.id AND

                  user.id = session_rel_user_rel_course.user_id AND

                  session_rel_user_rel_course.status<>'2' AND

                  session_rel_user_rel_course.user_id NOT IN ($user_to_avoid) AND

                  p.thread_id = ".intval($thread_id)." AND

                  session_id = ".api_get_session_id()." AND

                  p.c_id = $course_id AND

                  session_rel_user_rel_course.c_id = ".$course_id." $orderby ";

    } else {

        $sql = "SELECT DISTINCT user.id, user.lastname, user.firstname, thread_id

                  FROM $t_posts p, $t_users user, $t_course_user course_user

                  WHERE p.poster_id = user.id

                  AND user.id = course_user.user_id

                  AND course_user.relation_type<>".COURSE_RELATION_TYPE_RRHH."

                  AND p.thread_id = ".intval($thread_id)."

                  AND course_user.status NOT IN('1') AND

                  p.c_id = $course_id AND

                  course_user.c_id = ".$course_id." $orderby";

    }

    $result = Database::query($sql);

    return $result;

        $cad = substr($cad, 0, strlen($cad) - 1);

    }

    if (api_get_session_id()) {

        $session_info = api_get_session_info(api_get_session_id());

        $user_to_avoid = "'".$session_info['id_coach']."', '".$session_info['session_admin_id']."'";

        //not showing coaches

        $sql = "SELECT DISTINCT user.id, user.lastname, user.firstname, post.thread_id

                FROM $t_posts post , $t_users user, $t_session_rel_user session_rel_user_rel_course

                WHERE poster_id = user.id

                    AND user.id NOT IN (".$cad.")

                    AND user.id = session_rel_user_rel_course.user_id

                    AND session_rel_user_rel_course.status<>'2'

                    AND session_rel_user_rel_course.user_id NOT IN ($user_to_avoid)

                    AND post.thread_id = ".intval($thread_id)."

                    AND session_id = ".api_get_session_id()."

                    AND session_rel_user_rel_course.c_id = $course_id AND post.c_id = $course_id $orderby ";

    } else {

        $sql = "SELECT DISTINCT user.id, user.lastname, user.firstname, post.thread_id

                FROM $t_posts post, $t_users user,$t_course_user course_user

                WHERE post.poster_id = user.id

                AND user.id NOT IN (".$cad.")

                AND user.id = course_user.user_id

                AND course_user.relation_type<>".COURSE_RELATION_TYPE_RRHH."

                AND post.thread_id = ".intval($thread_id)."

                AND course_user.status not in('1')

                AND course_user.c_id = $course_id AND post.c_id = $course_id  $orderby";

    }

    $result = Database::query($sql);

    return $result;