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 = MySpace::make_username($user['FirstName'], $user['LastName'], $user['UserName']);

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

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

                } else {

                    $is_session_avail = MySpace::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 = MySpace::check_user_in_array($usernames, $desired_username);