OpenACS

openacs-4

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 3
Total Committers: 144
Last Commit: 20 Dec
Commits this week: 3
Total Lines of Code (LoC): 6,317,726
Net change in LoC this week: 335

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 7 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Friday 20 Jul 2001
8:01 am

gilbertw

added db_map for sysdate calls in a dynamic query.

Options
    • -0
    • +19
    ./packages/ecommerce/www/admin/products/edit-3-oracle.xql
    • -0
    • +19
    ./packages/ecommerce/www/admin/products/edit-3-postgresql.xql
8:00 am

gilbertw

added db_map for partialquery. expanded the ec_products query to get date in standard format for ad_dateentrywidget.

Options
    • -2
    • +4
    ./packages/ecommerce/www/admin/products/edit-3.tcl
    • -1
    • +12
    ./packages/ecommerce/www/admin/products/edit.tcl
    • -1
    • +1
    ./packages/ecommerce/www/admin/products/edit.xql
12:41 am

gilbertw

updated with correct names for sql creation/deletion scripts

Options
    • -4
    • +6
    ./packages/simple-survey/simple-survey.info
12:40 am

gilbertw

renamed files to package-name-create/drop format so that the APM will recognize it during installation.

Options
    • -0
    • +584
    ./packages/simple-survey/sql/postgresql/simple-survey-create.sql
    • -0
    • +73
    ./packages/simple-survey/sql/postgresql/simple-survey-drop.sql
    • -584
    • +0
    ./packages/simple-survey/sql/postgresql/survsimp-create.sql
    • -73
    • +0
    ./packages/simple-survey/sql/postgresql/survsimp-drop.sql
12:36 am

gilbertw

renamed the files to package-name-create/drop.sql so the APM will recognize it

Options
    • -0
    • +548
    ./packages/simple-survey/sql/oracle/simple-survey-create.sql
    • -0
    • +69
    ./packages/simple-survey/sql/oracle/simple-survey-drop.sql
    • -548
    • +0
    ./packages/simple-survey/sql/oracle/survsimp-create.sql
    • -69
    • +0
    ./packages/simple-survey/sql/oracle/survsimp-drop.sql
Thursday 19 Jul 2001
6:01 pm

kenk

Fixed error in actually selecting bookmarks to view. Hadn't tried that yet...you can use them now.

Options
    • -0
    • +2
    ./packages/bookmarks/bookmarks.info
    • -5
    • +5
    ./packages/bookmarks/tcl/bookmarks-init-postgresql.xql
    • -0
    • +16
    ./packages/bookmarks/www/bookmark-access-oracle.xql
    • -0
    • +26
    ./packages/bookmarks/www/bookmark-access-postgresql.xql
5:15 pm

kenk

Fixed error in sort order on index page. Added editing and viewing. Basic

functionality is working.

Options
    • -0
    • +8
    ./packages/bookmarks/bookmarks.info
    • -44
    • +16
    ./packages/bookmarks/sql/postgresql/bookmarks-create.sql
    • -0
    • +47
    ./packages/bookmarks/www/bookmark-add-one-2-oracle.xql
    • -0
    • +49
    ./packages/bookmarks/www/bookmark-add-one-2-postgresql.xql
    • -0
    • +34
    ./packages/bookmarks/www/bookmark-add-one-2.xql
    • -0
    • +35
    ./packages/bookmarks/www/bookmark-edit-2-oracle.xql
    • -0
    • +45
    ./packages/bookmarks/www/bookmark-edit-2-postgresql.xql
    • -0
    • +20
    ./packages/bookmarks/www/bookmark-edit-2.xql
    • -0
    • +8
    ./packages/bookmarks/www/bookmark-edit-oracle.xql
    • -0
    • +15
    ./packages/bookmarks/www/bookmark-edit-postgresql.xql
    • -1
    • +1
    ./packages/bookmarks/www/bookmark-edit.tcl
    • -0
    • +40
    ./packages/bookmarks/www/bookmark-edit.xql
    • -0
    • +32
    ./packages/bookmarks/www/bookmark-view-oracle.xql
    • -2
    • +1
    ./packages/bookmarks/www/bookmark-view.tcl
    • -0
    • +22
    ./packages/bookmarks/www/bookmark-view.xql
    • -2
    • +3
    ./packages/bookmarks/www/index-postgresql.xql
1:46 am

gilbertw

fixed naming of fullquery. did initial pass on proc vs. QE verification.

Options
    • -2
    • +2
    ./packages/ecommerce/tcl/ec-audit-trail-procs.tcl
    • -1
    • +1
    ./packages/ecommerce/tcl/ec-style-procs.xql
    • -2
    • +2
    ./packages/ecommerce/tcl/ecommerce-credit-procs-oracle.xql
    • -2
    • +2
    ./packages/ecommerce/tcl/ecommerce-credit-procs-postgresql.xql
    • -30
    • +40
    ./packages/ecommerce/tcl/ecommerce-email-procs-oracle.xql
    • -47
    • +56
    ./packages/ecommerce/tcl/ecommerce-email-procs-postgresql.xql
    • -23
    • +23
    ./packages/ecommerce/tcl/ecommerce-email-procs.tcl
    • -24
    • +16
    ./packages/ecommerce/tcl/ecommerce-email-procs.xql
    • -8
    • +8
    ./packages/ecommerce/tcl/ecommerce-procs.xql
    • -16
    • +16
    ./packages/ecommerce/tcl/ecommerce-scheduled-procs-oracle.xql
    • -16
    • +16
    ./packages/ecommerce/tcl/ecommerce-scheduled-procs-postgresql.xql
    • -3
    • +3
    ./packages/ecommerce/tcl/ecommerce-scheduled-procs.tcl
    • -13
    • +13
    ./packages/ecommerce/tcl/ecommerce-scheduled-procs.xql
    • -1
    • +1
    ./packages/ecommerce/tcl/ecommerce-ssl-procs.tcl
    • -1
    • +1
    ./packages/ecommerce/tcl/ecommerce-utilities-procs.tcl
Wednesday 18 Jul 2001
8:19 pm

gilbertw

changed all procs/proc_docs to ad_proc.

Options
    • -170
    • +170
    ./packages/ecommerce/tcl/cybercash-emulator-procs.tcl.for.testing
    • -6
    • +7
    ./packages/ecommerce/tcl/ec-audit-trail-procs.tcl
    • -19
    • +20
    ./packages/ecommerce/tcl/ec-style-procs.tcl
    • -80
    • +82
    ./packages/ecommerce/tcl/ecommerce-credit-procs.tcl
    • -14
    • +13
    ./packages/ecommerce/tcl/ecommerce-customer-service-procs.tcl
    • -4
    • +4
    ./packages/ecommerce/tcl/ecommerce-money-computations-procs.tcl
    • -49
    • +56
    ./packages/ecommerce/tcl/ecommerce-procs.tcl
    • -16
    • +15
    ./packages/ecommerce/tcl/ecommerce-scheduled-procs.tcl
    • -25
    • +27
    ./packages/ecommerce/tcl/ecommerce-state-changes-procs.tcl
    • -4
    • +3
    ./packages/ecommerce/tcl/ecommerce-utilities-procs.tcl
    • -38
    • +35
    ./packages/ecommerce/tcl/ecommerce-widgets-procs.tcl
    • -3
    • +3
    ./packages/ecommerce/tcl/qmail-procs.tcl
7:40 am

gilbertw

fixed ec_product__new for postgresql. also did a db_map for sysdate call.

Options
    • -0
    • +8
    ./packages/ecommerce/www/admin/products/add-4-oracle.xql
    • -31
    • +44
    ./packages/ecommerce/www/admin/products/add-4-postgresql.xql
    • -1
    • +4
    ./packages/ecommerce/www/admin/products/add-4.tcl
7:39 am

gilbertw

fixed ec_product__new function

Options
    • -21
    • +16
    ./packages/ecommerce/sql/postgresql/ec-product-package-create.sql
4:52 am

gilbertw

fixed sort key calculation. postgres driver encloses bind variables in ' ' which makes the sort key calculation fail. the key calculation is done in tcl now.

Options
    • -1
    • +5
    ./packages/ecommerce/www/admin/cat/subsubcategory-add-0.tcl
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/subsubcategory-add-0.xql
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/subsubcategory-add-2-oracle.xql
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/subsubcategory-add-2-postgresql.xql
    • -2
    • +7
    ./packages/ecommerce/www/admin/cat/subsubcategory-add-2.tcl
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/subsubcategory-add-2.xql
    • -1
    • +5
    ./packages/ecommerce/www/admin/cat/subsubcategory-add.tcl
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/subsubcategory-add.xql
2:03 am

gilbertw

fixed queryname names. fixed outer join which wasn't picked up by the query extractor.

Options
    • -2
    • +15
    ./packages/ecommerce/tcl/ecommerce-widgets-procs-oracle.xql
    • -2
    • +16
    ./packages/ecommerce/tcl/ecommerce-widgets-procs-postgresql.xql
    • -1
    • +1
    ./packages/ecommerce/tcl/ecommerce-widgets-procs.tcl
1:59 am

gilbertw

fixed sort key calculations. the postgres driver puts ' ' around the bind variable. the old code performed calculations like "and sort_key = (:prev_sort_key + :next_sort_key)/2", which caused postgres to barf. this calculation is now done in tcl.

Options
    • -1
    • +7
    ./packages/ecommerce/www/admin/cat/category-add-0.tcl
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/category-add-0.xql
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/category-add-2-oracle.xql
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/category-add-2-postgresql.xql
    • -2
    • +7
    ./packages/ecommerce/www/admin/cat/category-add-2.tcl
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/category-add-2.xql
    • -1
    • +6
    ./packages/ecommerce/www/admin/cat/category-add.tcl
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/category-add.xql
    • -1
    • +5
    ./packages/ecommerce/www/admin/cat/subcategory-add-0.tcl
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/subcategory-add-0.xql
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/subcategory-add-2-oracle.xql
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/subcategory-add-2-postgresql.xql
    • -2
    • +7
    ./packages/ecommerce/www/admin/cat/subcategory-add-2.tcl
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/subcategory-add-2.xql
    • -1
    • +5
    ./packages/ecommerce/www/admin/cat/subcategory-add.tcl
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/subcategory-add.xql
Tuesday 17 Jul 2001
11:56 pm

gilbertw

fixed oracle sign() calls

Options
    • -5
    • +5
    ./packages/ecommerce/www/admin/products/offers-postgresql.xql
    • -3
    • +3
    ./packages/ecommerce/www/admin/products/sale-prices-postgresql.xql
9:11 pm

pascals

/bin/bash: q: command not found

Options
    • -1
    • +1
    ./packages/general-comments/www/comment-add-3-postgresql.xql
8:26 am

jong

Initial OpenACS import

Options
    • -0
    • +96
    ./packages/acs-reference/sql/postgresql/country.sql
    • -0
    • +87
    ./packages/acs-reference/sql/postgresql/currency.sql
    • -0
    • +44
    ./packages/acs-reference/sql/postgresql/language.sql
    • -0
    • +43
    ./packages/acs-reference/sql/postgresql/s-and-p.sql
    • -0
    • +91
    ./packages/acs-reference/sql/postgresql/us-counties.sql
    • -0
    • +40
    ./packages/acs-reference/sql/postgresql/us-states.sql
    • -0
    • +68
    ./packages/acs-reference/sql/postgresql/us-zipcodes.sql
8:25 am

jong

Another PG type fix, and added overloaded new.

Options
    • -3
    • +35
    ./packages/acs-reference/sql/postgresql/acs-reference-create.sql
7:49 am

jong

Worked on permissions syntax

Options
    • -14
    • +17
    ./packages/acs-reference/sql/postgresql/acs-reference-create.sql
7:40 am

jong

Initial revision for OpenACS.

Options
    • -0
    • +62
    ./packages/acs-reference/acs-reference.info
7:03 am

jong

Pulled inserts into own files.

Options
    • -43
    • +1
    ./packages/acs-reference/sql/common/s-and-p-data.sql
    • -4
    • +1
    ./packages/acs-reference/sql/common/timezone-data.sql
    • -45
    • +1
    ./packages/acs-reference/sql/common/us-states.sql
    • -5
    • +2
    ./packages/acs-reference/sql/common/us-zipcodes-data.sql
7:03 am

jong

Pulled inserts out of sql files for commonality.

Options
    • -0
    • +259
    ./packages/acs-reference/sql/common/country-data.sql
    • -0
    • +205
    ./packages/acs-reference/sql/common/currency-data.sql
    • -0
    • +146
    ./packages/acs-reference/sql/common/language-data.sql
7:02 am

jong

Moved sql to data dependent dirs

Options
    • -76
    • +0
    ./packages/acs-reference/sql/common/us-zipcodes.sql
7:01 am

jong

Renamed data to -data and moved sql to database dependent directories.

Options
    • -335
    • +0
    ./packages/acs-reference/sql/common/country.sql
    • -284
    • +0
    ./packages/acs-reference/sql/common/currency.sql
    • -188
    • +0
    ./packages/acs-reference/sql/common/language.sql
    • -99
    • +0
    ./packages/acs-reference/sql/common/us-counties.sql
6:59 am

jong

Major change.

I put all database dependent parts in their directories and kept the data only in common.

This is needed for the database independence and pl(pg)sql differences.

Options
    • -0
    • +91
    ./packages/acs-reference/sql/oracle/country.sql
    • -0
    • +93
    ./packages/acs-reference/sql/oracle/currency.sql
    • -0
    • +49
    ./packages/acs-reference/sql/oracle/language.sql
    • -0
    • +47
    ./packages/acs-reference/sql/oracle/s-and-p.sql
    • -0
    • +99
    ./packages/acs-reference/sql/oracle/us-counties.sql
    • -0
    • +44
    ./packages/acs-reference/sql/oracle/us-states.sql
    • -0
    • +76
    ./packages/acs-reference/sql/oracle/us-zipcodes.sql
6:55 am

jong

updated to reflect removal of timezone data temporarily

Options
    • -3
    • +4
    ./packages/acs-reference/sql/oracle/acs-reference-data.sql
5:59 am

jong

Initial Postgres port. Rough only.

Options
    • -150
    • +122
    ./packages/acs-reference/sql/postgresql/acs-reference-create.sql
4:01 am

jong

deleted for OpenACS. All files put in common

Options
    • -335
    • +0
    ./packages/acs-reference/sql/oracle/country.sql
    • -284
    • +0
    ./packages/acs-reference/sql/oracle/currency.sql
    • -189
    • +0
    ./packages/acs-reference/sql/oracle/language.sql
    • -124
    • +0
    ./packages/acs-reference/sql/oracle/s-and-p-data.sql
    • -535
    • +0
    ./packages/acs-reference/sql/oracle/timezone-data.sql
    • -25
    • +0
    ./packages/acs-reference/sql/oracle/timezone-drop.sql
    • -40049
    • +0
    ./packages/acs-reference/sql/oracle/timezone-rules.sql
    • -512
    • +0
    ./packages/acs-reference/sql/oracle/timezones.sql
    • -3154
    • +0
    ./packages/acs-reference/sql/oracle/us-counties-data.sql
    • -99
    • +0
    ./packages/acs-reference/sql/oracle/us-counties.sql
    • -123
    • +0
    ./packages/acs-reference/sql/oracle/us-states.sql
    • -42205
    • +0
    ./packages/acs-reference/sql/oracle/us-zipcodes-data.sql
    • -76
    • +0
    ./packages/acs-reference/sql/oracle/us-zipcodes.sql
3:52 am

kenk

Fixed error in tree_sortkey insert trigger; hopefully tree_sortkey being created/updated properly now.

Options
    • -0
    • +3
    ./packages/bookmarks/bookmarks.info
    • -1
    • +1
    ./packages/bookmarks/sql/postgresql/bookmarks-create.sql
    • -1
    • +1
    ./packages/bookmarks/tcl/bookmarks-procs-postgresql.xql
    • -1
    • +1
    ./packages/bookmarks/www/bookmark-add-import.tcl
    • -0
    • +3
    ./packages/bookmarks/www/bookmark-add-one-2.tcl
3:44 am

jong

initial OpenACS revision

Options
    • -0
    • +335
    ./packages/acs-reference/sql/common/country.sql
    • -0
    • +284
    ./packages/acs-reference/sql/common/currency.sql
    • -0
    • +188
    ./packages/acs-reference/sql/common/language.sql
    • -0
    • +123
    ./packages/acs-reference/sql/common/s-and-p-data.sql
    • -0
    • +535
    ./packages/acs-reference/sql/common/timezone-data.sql
    • -0
    • +25
    ./packages/acs-reference/sql/common/timezone-drop.sql
    • -0
    • +40049
    ./packages/acs-reference/sql/common/timezone-rules.sql
    • -0
    • +512
    ./packages/acs-reference/sql/common/timezones.sql
    • -0
    • +3154
    ./packages/acs-reference/sql/common/us-counties-data.sql
    • -0
    • +99
    ./packages/acs-reference/sql/common/us-counties.sql
    • -0
    • +122
    ./packages/acs-reference/sql/common/us-states.sql
    • -0
    • +42205
    ./packages/acs-reference/sql/common/us-zipcodes-data.sql
    • -0
    • +76
    ./packages/acs-reference/sql/common/us-zipcodes.sql
    • -0
    • +219
    ./packages/acs-reference/sql/postgresql/acs-reference-create.sql
    • -0
    • +16
    ./packages/acs-reference/sql/postgresql/acs-reference-data.sql
    • -0
    • +41
    ./packages/acs-reference/sql/postgresql/acs-reference-drop.sql