chamilo / chamilo-lms

     * @return array link info

     *

     **/

    public static function get_link_info($id)

    {

        $tbl_link = Database:: get_course_table(TABLE_LINK);

        $course_id = api_get_course_int_id();

        if (empty($id) || empty($course_id)) {

            return [];

        }

        $sql = "SELECT * FROM $tbl_link

                WHERE c_id = $course_id AND id='" . intval($id) . "' ";

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

        $data = array();

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

            $data = Database::fetch_array($result);

        }

        return $data;

    }

    /**

     * @param int $id

     * @param int $id

     * @return array

     */

    public static function getCategory($id)

    {

        $table = Database::get_course_table(TABLE_LINK_CATEGORY);

        $id = intval($id);

        $courseId = api_get_course_int_id();

        if (empty($id) || empty($courseId)) {

            return [];

        }

        $sql = "SELECT * FROM $table 

                WHERE id = $id AND c_id = $courseId";

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

        $category = Database::fetch_array($result, 'ASSOC');

        return $category;

    }

    /**

     * Move a link inside its category (display_order field)

     * @param int $sessionId The session id

     * @return array

     */

    public static function getTotalUserCoursesInSession($sessionId)

    {

        $tableUser = Database::get_main_table(TABLE_MAIN_USER);

        $table = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);

        if (empty($sessionId)) {

            return [];

        }

        $sql = "SELECT 

                    COUNT(u.id) as count, 

                    u.id, 

                    scu.status status_in_session, 

                    u.status user_status

                FROM $table scu

                INNER JOIN $tableUser u 

                ON scu.user_id = u.id

                WHERE scu.session_id = " . intval($sessionId) ."

                GROUP BY u.id";

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

        $list = array();

        while ($data = Database::fetch_assoc($result)) {

            $list[] = $data;

        }

        return $list;

    }

    /**