• last updated 7 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Added last two (hopefully) .xql files

Made aliases for all subselects to make it easier to follow which is which; also removed commented out connect by's

Corrected typo when refering to table acs_objects

Corrected typo in original version: user_ud should be user_id

Initial port

    • -0
    • +35
    /openacs-4/packages/file-storage/www/folder_list-oracle.xql
    • -0
    • +41
    /openacs-4/packages/file-storage/www/folder_list-postgresql.xql
Added dm_map for dynamic part of query

Forgot to update bookmarks.info

Adding files for Javascript view

    • -0
    • +33
    /openacs-4/packages/bookmarks/www/tree-dynamic-oracle.xql
    • -0
    • +14
    /openacs-4/packages/bookmarks/www/tree-dynamic.xql
fixup to get base item creation working

    • -2
    • +2
    /openacs-4/packages/cms/tcl/form-procs.tcl
    • -2
    • +2
    /openacs-4/packages/cms/tcl/form-procs.xql
Added dynamic queries

Changed query name fle-delete to file_delete.

cleanup of add item routines

    • -0
    • +38
    /openacs-4/packages/cms/tcl/content-method-procs-oracle.xql
    • -0
    • +38
    /openacs-4/packages/cms/tcl/content-method-procs-postgresql.xql
    • -19
    • +1
    /openacs-4/packages/cms/tcl/form-procs-oracle.xql
    • -43
    • +43
    /openacs-4/packages/cms/tcl/form-procs.tcl
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