• last updated 4 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
sanitized the query: removed unnecessary subqueries and the query now uses the same permission clause like calendar::calendar_list

    • -5
    • +8
    ./www/view-list-display-postgresql.xql
    • -10
    • +16
    ./www/view-one-day-display-postgresql.xql
Retrieve calendar_id directly from calendars table

    • -2
    • +2
    ./www/view-month-display-postgresql.xql
sanitized the query: removed unnecessary subqueries and the query now uses the same permission clause like calendar::calendar_list

    • -15
    • +12
    ./www/view-month-display-postgresql.xql
    • -12
    • +8
    ./www/view-week-display-postgresql.xql
the calendar_list is now created in the caller of cal-options which saves a lot of unnecessary queries.

moved to using ad_form

added calendar_name, calendar_admin_p to select_calendar_list and removed the unnecesary adjust_calendar_list_query

moved adjust_calendar_list functionality into the calendar_list proc and then removed it

debugged the query and the corresponding page. calendar-preferences now syntactically works fine, however I am not sure about the supposed semantics of this page...

    • -25
    • +7
    ./www/admin/calendar-preferences-postgresql.xql
    • -47
    • +4
    ./www/admin/calendar-preferences.tcl
Removing unused files

Removing unused files.

Added a link to admin/ for admins

removed junk code

Fixed SQL query so that daily events and events with time are properly retrieved from the database

    • -2
    • +4
    ./www/view-one-day-display-postgresql.xql
Added link to calendar-item-types, so that calendar_admins can manipulate calendar item types

noquote fixes: moved as much html generation into adp files

    • -1
    • +0
    ./www/cal-item-delete-all-occurrences.tcl
  1. … 28 more files in changeset.
Fixed some minor acs-lang stuff and a few noquote things.

    • -0
    • +11
    ./tcl/calendar-display-procs-oracle.xql
    • -3
    • +91
    ./tcl/calendar-display-procs-postgresql.xql
  1. … 5 more files in changeset.
committing all translations on the translation server at http://translate.dotlrn.collaboraid.net

    • -1
    • +1
    ./catalog/calendar.da_DK.ISO-8859-1.xml
    • -3
    • +3
    ./catalog/calendar.de_DE.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/calendar.en_US.ISO-8859-1.xml
    • -4
    • +4
    ./catalog/calendar.es_ES.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/calendar.fi_FI.ISO-8859-15.xml
    • -0
    • +130
    ./catalog/calendar.fr_FR.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/calendar.gl_ES.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/calendar.it_IT.ISO-8859-1.xml
    • -0
    • +130
    ./catalog/calendar.ko_KR.EUC-KR.xml
    • -0
    • +66
    ./catalog/calendar.ms_my.US-ASCII.xml
    • -1
    • +1
    ./catalog/calendar.nl_NL.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/calendar.no_NO.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/calendar.pl_PL.ISO-8859-2.xml
    • -1
    • +1
    ./catalog/calendar.pt_BR.ISO-8859-1.xml
  1. … 532 more files in changeset.
added calendar wish list and comment to the old docs that they are outdated

reverted to 1.34 o maintain backward compatibility and marked the tcl procs as deprecatd

    • -9
    • +267
    ./tcl/calendar-display-procs.tcl
removed unused variables

removed unused variables

draft version of noquoted calendar package

    • -117
    • +0
    ./tcl/calendar-display-procs-postgresql.xql
    • -244
    • +4
    ./tcl/calendar-display-procs.tcl
    • -0
    • +42
    ./www/view-list-display-postgresql.xql
    • -0
    • +14
    ./www/view-list-display.adp
    • -0
    • +92
    ./www/view-list-display.tcl
    • -0
    • +40
    ./www/view-month-display-postgresql.xql
    • -0
    • +1
    ./www/view-month-display.adp
    • -0
    • +89
    ./www/view-month-display.tcl
  1. … 8 more files in changeset.
fixed select_list_items query so that column names are the ones expected in the tcl files

    • -3
    • +5
    ./tcl/calendar-display-procs-postgresql.xql
fixed select_item_data so that result column names are the ones expected in the tcl file

noquote changes (Dirk Gomez)

  1. … 85 more files in changeset.
merge of 4.6.3b1 to HEAD

    • -15
    • +15
    ./sql/postgresql/calendar-create.sql
    • -2
    • +44
    ./tcl/calendar-display-procs-postgresql.xql
    • -7
    • +7
    ./tcl/calendar-outlook-procs-postgresql.xql
  1. … 62 more files in changeset.
removing the file listings from the info files since those are no longer used by OpenACS

  1. … 28 more files in changeset.
A variety of changes that add up to making outlook synchronization work

with PostgreSQL (at all) and Oracle (better).

1. Changed calendar to read SystemTimezone rather than hardwire it to

US/Eastern.

2. Made calendar depend on acs-lang since that's where the param lives.

3. Fixed the query on the acs-lang page that lets you set the timezone

(used the Oracle-ism UNIQUE rather than the standard DISTINCT)

4. Saw that the test stuff doesn't work and got rid of the links on the

index page - people can live without testing it for this release (we

should fix it for 4.7)

5. Fixed timezone__local_to_utc so it works with calendar, though it's

very whacky (shifted so the timezone'd date part is the UTC date, would

be much much better to use timestamp without timezone but PG doesn't

accept that syntax for function returns and we're not ready to drop

PG 7.2 support yet so I can't take advantage of the timestamp/timestamptz

type names, sigh)

    • -7
    • +7
    ./tcl/calendar-outlook-procs-postgresql.xql
  1. … 4 more files in changeset.
Using new form builder maxlength instead. Also made description optional.

setting maxlength to 255 for name of calendar item text field, fixing bug 322