chamilo / chamilo-lms

            return FillBlanks::getNbResultFillBlankAll($listFillTheBlankResult);

        }

        if (empty($session_id)) {

            $courseCondition = "

            INNER JOIN $courseUser cu

            ON cu.c_id = c.id AND cu.user_id  = exe_user_id";

            $courseConditionWhere = " AND relation_type <> 2 AND cu.status = ".STUDENT;

        } else {

            $courseCondition = "

            INNER JOIN $courseUserSession cu

            ON cu.c_id = c.id AND cu.user_id = exe_user_id";

            $courseConditionWhere = " AND cu.status = 0 ";

        }

        $sql = "SELECT DISTINCT exe_user_id

    		FROM $track_exercises e

        $course_code = Database::escape_string($course_code);

        $session_id = intval($session_id);

        if (empty($session_id)) {

            $courseCondition = "

            INNER JOIN $courseUser cu

            ON cu.c_id = c.id AND cu.user_id  = exe_user_id";

            $courseConditionWhere = " AND relation_type <> 2 AND cu.status = ".STUDENT;

        } else {

            $courseCondition = "

            INNER JOIN $courseUserSession cu

            ON cu.c_id = c.id AND cu.user_id = exe_user_id";

            $courseConditionWhere = " AND cu.status = 0 ";

        }

        $sql = "SELECT DISTINCT exe_user_id

    		FROM $track_exercises e

                $select_condition = " DISTINCT exe_user_id ";

        }

        if (empty($session_id)) {

            $courseCondition = "

            INNER JOIN $courseUser cu

            ON cu.c_id = c.id AND cu.user_id  = exe_user_id";

            $courseConditionWhere = " AND relation_type <> 2 AND cu.status = ".STUDENT;

        } else {

            $courseCondition = "

            INNER JOIN $courseUserSession cu

            ON cu.c_id = a.c_id AND cu.user_id = exe_user_id";

            $courseConditionWhere = " AND cu.status = 0 ";

        }

        $sql = "SELECT $select_condition

    		FROM $track_exercises e