• last updated 19 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Added dynamic queries

    • -0
    • +37
    ./packages/file-storage/www/file-oracle.xql
Changed query name fle-delete to file_delete.

    • -2
    • +2
    ./packages/file-storage/www/file-delete.tcl
cleanup of add item routines

    • -0
    • +38
    ./packages/cms/tcl/content-method-procs-oracle.xql
    • -0
    • +38
    ./packages/cms/tcl/content-method-procs-postgresql.xql
    • -5
    • +5
    ./packages/cms/tcl/content-method-procs.tcl
    • -0
    • +28
    ./packages/cms/tcl/content-method-procs.xql
    • -19
    • +1
    ./packages/cms/tcl/form-procs-oracle.xql
    • -22
    • +20
    ./packages/cms/tcl/form-procs-postgresql.xql
    • -43
    • +43
    ./packages/cms/tcl/form-procs.tcl
fixup to get main screen working

    • -1
    • +1
    ./packages/cms/tcl/form-procs-postgresql.xql
    • -6
    • +58
    ./packages/cms/tcl/module-procs-postgresql.xql
Removed level attribute in fs_context_bar_lis.context_bar query

moving timezones to a seperate package

    • -532
    • +0
    ./packages/acs-reference/sql/common/timezone-data.sql
Initial port

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

    • -12
    • +16
    ./packages/file-storage/www/file.tcl
Bookmark Import working

    • -0
    • +66
    ./packages/bookmarks/www/bookmarks-import-oracle.xql
    • -0
    • +70
    ./packages/bookmarks/www/bookmarks-import-postgresql.xql
    • -0
    • +70
    ./packages/bookmarks/www/bookmarks-import.xql
Inital port

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

    • -0
    • +17
    ./packages/file-storage/www/file-edit-oracle.xql
Initial port

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

    • -0
    • +46
    ./packages/file-storage/file-storage.info
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

    • -22
    • +22
    ./packages/bookmarks/bookmarks.info
    • -1
    • +1
    ./packages/bookmarks/www/folder-selection.tcl
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..

Fixed naming of queries in .xql files. Along the way I also fixed other things that I have overseen.

    • -1
    • +1
    ./packages/cms/tcl/cms-folder-procs-oracle.xql
    • -1
    • +1
    ./packages/cms/tcl/cms-folder-procs-postgresql.xql
    • -2
    • +2
    ./packages/cms/tcl/content-add-procs.xql
    • -1
    • +1
    ./packages/cms/tcl/content-method-procs.xql
    • -41
    • +34
    ./packages/cms/tcl/form-procs-oracle.xql
    • -34
    • +34
    ./packages/cms/tcl/form-procs-postgresql.xql
    • -23
    • +31
    ./packages/cms/tcl/form-procs.xql
    • -67
    • +55
    ./packages/cms/tcl/module-procs-oracle.xql
    • -75
    • +33
    ./packages/cms/tcl/module-procs-postgresql.xql
    • -123
    • +0
    ./packages/cms/tcl/perm-procs-oracle.xql
    • -124
    • +0
    ./packages/cms/tcl/perm-procs-postgresql.xql
    • -1
    • +1
    ./packages/cms/tcl/user-procs-oracle.xql
    • -1
    • +1
    ./packages/cms/tcl/user-procs-postgresql.xql
made register_content one transaction

fixed to use new acs-mail notifications

    • -8
    • +6
    ./packages/download/www/admin/spam-users-2.tcl
cleanup of old oracle code

made date format prettier

fixed to use new acs_mail notifications

fixed an APM install bug.

    • -2
    • +2
    ./packages/acs-subsite/tcl/attribute-procs.tcl
    • -4
    • +4
    ./packages/acs-tcl/tcl/apm-install-procs.tcl
first stab at a document that describes changes I've made, usage instructions and other miscellaneous notes.

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

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

    • -66
    • +75
    ./packages/acs-mail/tcl/acs-mail-procs.xql
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

    • -165
    • +337
    ./packages/acs-mail/tcl/acs-mail-procs.tcl
changed to use content repository, rather than acs-content

fixed 'FIXME LOB'