chamilo / chamilo-lms

     * @author Arthur Portugal

     * @version November 2009, dokeos 1.8.6.2

     */

    public static function get_attachment($announcementId)

    {

        $tbl_announcement_attachment = Database::get_course_table(TABLE_ANNOUNCEMENT_ATTACHMENT);

        $announcementId = intval($announcementId);

        $course_id = api_get_course_int_id();

        $row = array();

        $sql = 'SELECT id, path, filename, comment 

                FROM ' . $tbl_announcement_attachment . '

				WHERE c_id = ' . $course_id . ' AND announcement_id = ' . $announcementId;

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

        if (Database::num_rows($result) != 0) {

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

        }

        return $row;

    }

    /**

     * @param    int $id The agenda item ID

     * @return    array    The results of the database query, or null if not found

     */

    public static function get_personal_agenda_item($id)

    {

        $tbl_personal_agenda = Database:: get_main_table(TABLE_PERSONAL_AGENDA);

        $id = intval($id);

        // make sure events of the personal agenda can only be seen by the user himself

        $user = api_get_user_id();

        $sql = " SELECT * FROM ".$tbl_personal_agenda." WHERE id=".$id." AND user = ".$user;

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

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

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

        } else {

            $item = null;

        }

        return $item;

    }

    /**