chamilo / chamilo-lms

    while ($coachs = Database::fetch_array($result_coachs)) {

        $id_coach = $coachs["id_coach"];

        if (isset($_GET["id_student"])) {

            $sql_infos_coach = "SELECT lastname, firstname

            FROM $tbl_user

            WHERE user_id='$id_coach'";

            $result_coachs_infos = Database::query($sql_infos_coach);

            $lastname = Database::result($result_coachs_infos, 0, "lastname");

            $firstname = Database::result($result_coachs_infos, 0, "firstname");

        } else {

            $lastname = $coachs["lastname"];

            $firstname = $coachs["firstname"];

        }

        $sql_connection_time = "SELECT login_date, logout_date

        FROM $tbl_track_login

                    $desired_username = self::make_username($user['FirstName'], $user['LastName'], $user['UserName']);

                    $user['UserName'] = $desired_username['username'].$desired_username['sufix'];

                    $user['create'] = '1';

                } else {

                    $is_session_avail = self::user_available_in_session($user['UserName'], $course_list, $id_session);

                    if ($is_session_avail == 0) {

                        $user_name = $user['UserName'];

                        $sql_select = "SELECT user_id FROM $table_user WHERE username ='$user_name' ";

                        $rs = Database::query($sql_select);

                        $user['create'] = Database::result($rs, 0, 0); // This should be the ID because the user exists.

                    } else {

                        $user['create'] = $is_session_avail;

                    }

                }

            }

            // Usernames is the current list of users in the file.

            $result_array = self::check_user_in_array($usernames, $desired_username);