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();

        $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 url id

    * @return boolean true if success

    * */

    public static function relation_url_session_exist($session_id, $url_id)

    {

        $table_url_rel_session= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION);

        $session_id = intval($session_id);

        $url_id		= intval($url_id);

        $sql = "SELECT session_id FROM $table_url_rel_session

                WHERE

                    access_url_id = ".intval($url_id)." AND

                    session_id = ".Database::escape_string($session_id);

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

        $num = Database::num_rows($result);

        return $num;

    }

    /**

     * Add a group of users into a group of URLs