chamilo / chamilo-lms

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

        if (Database::num_rows($rs) > 0) {

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

                $completeName = api_get_person_name($row['firstname'], $row['lastname']);

                $coaches[] = $row + ['full_name' => $completeName];

            }

            return $coaches;

        } else {

        while ($list_users = Database::fetch_array($res)) {

            $result = Database::query("SELECT * FROM " . Database::get_main_table(TABLE_MAIN_USER) . "

                    WHERE user_id=" . $list_users['user_id']);

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

                $name_teacher = api_get_person_name($row_user['firstname'], $row_user['lastname']);

                $list[] = array($row_user['email'] => $name_teacher);

            }

        }

        return $list;

    }

                    blogs_rel_user.blog_id = '".(int) $blog_id."'";

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

        $blog_members = array();

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

            $blog_members[$user['user_id']] = api_get_person_name(

                $user['firstname'],

                $user['lastname']

            );

        }

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

        $options = array();

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

            $options[$user['user_id']] = api_get_person_name($user['firstname'], $user['lastname']);

        }

        // Get tasks in this blog / make select list of it

        $sql = "