• last updated 9 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
fixup to get main screen working

    • -283
    • +284
    /openacs-4/packages/cms/cms.info
Removed level attribute in fs_context_bar_lis.context_bar query

moving timezones to a seperate package

Initial port

    • -0
    • +19
    /openacs-4/packages/file-storage/www/search-oracle.xql
    • -0
    • +19
    /openacs-4/packages/file-storage/www/search-postgresql.xql
    • -0
    • +46
    /openacs-4/packages/file-storage/www/version-add-2-oracle.xql
    • -0
    • +17
    /openacs-4/packages/file-storage/www/version-add.xql
    • -0
    • +22
    /openacs-4/packages/file-storage/www/version-delete-oracle.xql
    • -0
    • +25
    /openacs-4/packages/file-storage/www/version-delete.xql
    • -0
    • +29
    /openacs-4/packages/file-storage/www/download/index-oracle.xql
Use db_map for dynamically creeated query

Bookmark Import working

    • -0
    • +70
    /openacs-4/packages/bookmarks/www/bookmarks-import.xql
Inital port

    • -0
    • +13
    /openacs-4/packages/file-storage/www/file-copy-2.xql
Initial port.

    • -0
    • +72
    /openacs-4/packages/file-storage/www/file-add-2-postgresql.xql
    • -0
    • +17
    /openacs-4/packages/file-storage/www/file-edit-oracle.xql
Initial port

    • -0
    • +64
    /openacs-4/packages/file-storage/www/file-add-2-oracle.xql
    • -0
    • +17
    /openacs-4/packages/file-storage/www/file-add-2.xql
    • -0
    • +56
    /openacs-4/packages/file-storage/www/file-copy-2-oracle.xql
    • -0
    • +70
    /openacs-4/packages/file-storage/www/file-copy-2-postgresql.xql
    • -0
    • +17
    /openacs-4/packages/file-storage/www/file-copy.xql
    • -0
    • +38
    /openacs-4/packages/file-storage/www/file-delete-oracle.xql
    • -0
    • +36
    /openacs-4/packages/file-storage/www/file-delete-postgresql.xql
    • -0
    • +13
    /openacs-4/packages/file-storage/www/file-delete.xql
    • -0
    • +32
    /openacs-4/packages/file-storage/www/file-edit-2-oracle.xql
    • -0
    • +30
    /openacs-4/packages/file-storage/www/file-edit-2-postgresql.xql
    • -0
    • +17
    /openacs-4/packages/file-storage/www/file-edit-postgresql.xql
    • -0
    • +20
    /openacs-4/packages/file-storage/www/file-move-2-oracle.xql
    • -0
    • +18
    /openacs-4/packages/file-storage/www/file-move-2-postgresql.xql
    • -0
    • +36
    /openacs-4/packages/file-storage/www/file-move-2.xql
    • -0
    • +17
    /openacs-4/packages/file-storage/www/file-move-oracle.xql
  1. … 3 more files in changeset.
Includes all .xql files

Fix broken threading due to incorrect query name.

Syncing with server after move; adding fixes to CONNECT BY replacements. Presently, some are broken once multiple users are added to site

Fixed posting error due to incorrect partialquery name.

Added patch form Luke Pond that updates bboard_garbage_collect_postgresql

so that general_comments are prevented from being garbage collected.

Fixes the broken forum page. Wrap else clause of the "messages_select"

query in to_char so that the datatypes of both claues match.

adp page used dollar sign instead of at signs..

    • -1
    • +1
    /openacs-4/packages/faq/www/one-faq.adp
Fixed naming of queries in .xql files. Along the way I also fixed other things that I have overseen.

    • -41
    • +34
    /openacs-4/packages/cms/tcl/form-procs-oracle.xql
    • -5
    • +5
    /openacs-4/packages/cms/tcl/form-procs.tcl
    • -23
    • +31
    /openacs-4/packages/cms/tcl/form-procs.xql
    • -3
    • +3
    /openacs-4/packages/cms/tcl/module-procs.tcl
    • -3
    • +3
    /openacs-4/packages/cms/tcl/module-procs.xql
    • -123
    • +0
    /openacs-4/packages/cms/tcl/perm-procs-oracle.xql
    • -1
    • +1
    /openacs-4/packages/cms/tcl/user-procs.xql
made register_content one transaction

fixed to use new acs-mail notifications

cleanup of old oracle code

made date format prettier

fixed to use new acs_mail notifications

fixed an APM install bug.

first stab at a document that describes changes I've made, usage instructions and other miscellaneous notes.

    • -0
    • +482
    /openacs-4/packages/acs-mail/www/doc/openacs-mail.html
created index page to link to other docs

    • -0
    • +25
    /openacs-4/packages/acs-mail/www/doc/index.html
fixed queries to use CR

added acs_mail_base64_encode - a tcl proc that uuencodes

fixed acs_mail_set_content to use CR

same for acs_mail_set_content_file

added acs_mail_uuencode_file to uuencode a file

changed acs_mail_encode_content a lot to properly read data from the CR and encode it as needed

changed recursive db_foreach to a db_list_of_lists followed by a foreach to prevent running out of handles

added a check of MIME type to decide whether to add 'Content-Transfer_Encoding: base 64'

commented out the code that puts To: and From: address into Headers to prevent duplicate To: and From: addresses in the email

changed acs_mail_content_new to be private. doesn't make sense to call it without a message_body

changed to use content repository, rather than acs-content

fixed 'FIXME LOB'

changed to use content repository, rather than acs-content

added 'on delete cascade'

changed content_object_id to content_item_id

added declaration for v_header_message_id

changed acs_mail_body__body_p to return boolean

fixed acs_mail_link__new