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)