chamilo / chamilo-lms

        // Getting sessions that are related to a coach in the session_rel_course_rel_user table

        if (api_is_allowed_to_create_course()) {

            $sessionListFromCourseCoach = array();

            $sql =" SELECT DISTINCT session_id

                    FROM $tbl_session_course_user

                    WHERE user_id = $user_id AND status = 2 ";

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

            if (Database::num_rows($result)) {

                $result = Database::store_result($result);

                foreach ($result as $session) {

                    $sessionListFromCourseCoach[]= $session['session_id'];

                }

            }

            if (!empty($sessionListFromCourseCoach)) {

                $condition = implode("','", $sessionListFromCourseCoach);

                $coachCourseConditions = " OR ( s.id IN ('$condition'))";

            }

        }

        // Get the list of sessions where the user is subscribed

        // This is divided into two different queries

    				$condition_user = " AND exe_user_id = '$student_id' ";

    			}

    			if (empty($exercise_id)) {

    				$sql = "SELECT id FROM $tbl_course_quiz

    						WHERE c_id = {$course_info['real_id']} $condition_active $condition_quiz";

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

                    $exercise_list = array();

    				$exercise_id = null;

                    if (Database::num_rows($result)) {

                        while ($row = Database::fetch_array($result)) {

                            $exercise_list[] = $row['id'];

                        }

                    }

                    if (!empty($exercise_list)) {

                        $exercise_id = implode("','",$exercise_list);

                    }

    			}

    			$count_quiz = Database::fetch_row(Database::query($sql));