• last updated 23 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates

fixed a few more subsite issues, and added a special case to query dispatcher.

set default TemplateRoot=templates/store

more cleanup of cms

    • -62
    • +122
    /openacs-4/packages/cms/tcl/browser-procs.tcl
    • -85
    • +122
    /openacs-4/packages/cms/tcl/clipboard-procs.tcl
    • -1
    • +14
    /openacs-4/packages/cms/tcl/content-add-procs.tcl
    • -80
    • +32
    /openacs-4/packages/cms/tcl/form-procs-oracle.xql
    • -379
    • +527
    /openacs-4/packages/cms/tcl/form-procs.tcl
    • -17
    • +6
    /openacs-4/packages/cms/tcl/item-procs-oracle.xql
    • -232
    • +276
    /openacs-4/packages/cms/tcl/item-procs.tcl
  1. … 12 more files in changeset.

updated the .info file with new acs-geo-tables files

temporarily add acs-geo-tables to the ecommerce package. will remove after acs-references is completed

    • -0
    • +53
    /openacs-4/packages/ecommerce/sql/oracle/acs_geo_parents.sql
    • -0
    • +6602
    /openacs-4/packages/ecommerce/sql/oracle/counties-create.sql
    • -0
    • +149
    /openacs-4/packages/ecommerce/sql/oracle/states-create.sql

added acs-geo-tables to the ecommerce package as a temporary solution until acs-references is completed

removed acs-geo-tables requirement. will replace with acs-references when it is completed.

Initial addition

    • -0
    • +3
    /openacs-4/packages/timezones/cvs-add
    • -0
    • +31
    /openacs-4/packages/timezones/timezones.info
    • -0
    • +532
    /openacs-4/packages/timezones/sql/oracle/timezone-data.sql
    • -0
    • +25
    /openacs-4/packages/timezones/sql/oracle/timezone-drop.sql

1. Fixed a bug in the oracle version of acs-mail-nt-create.sql

2. Fixed a bug in the oracle version of the APM - a standard SQL92

left join was being executed rather than the nasty Oracle-specific

notation.

3. Futzed with the APM a bit - you can now only set "watch" commands on

those .xql files which are used by the current installation, you can

only install packages supported by the current installation's RDBMS.

    • -1
    • +15
    /openacs-4/packages/acs-tcl/tcl/apm-xml-procs.tcl

Superceded by acs-mail.

Superceded by acs-reference.

    • -69
    • +0
    /openacs-4/packages/places/places.info
    • -803
    • +0
    /openacs-4/packages/places/doc/design.html
    • -41
    • +0
    /openacs-4/packages/places/doc/index.html
    • -272
    • +0
    /openacs-4/packages/places/doc/requirements.html
  1. … 21 more files in changeset.

fixed a few more queries in subsite, added a correction to the API for subsite nodes.

Changed dm_dml to db_exec_plsql since query is a select (bug in original).

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