• last updated 56 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
1) Updated .info file to reality

3) Changed '= null' to 'is null' test

removed excess files from .info file

cleaned up email check

1) cleaned up workflows .info file

2) fixed error message in acs-workflow

3) fixed code to reassign tasks to users

4) send return_url to task-action.adp

5) fixed bug in ticket-tracker's clarify_fire callback

6) added return_url to ticket tracker's emails

    • -1
    • +1
    ./obsolete-packages/acs-workflow/www/task.adp
1) added missing param to workflow_case__add_task_assignment

2) Fixed minor typos in workflow docs, ACS->OpenACS

  1. … 3 more files in changeset.

I boo-booed when changing the notification callback signature.

1. Added session-update.tcl, a small utility which somewhat safely allows

you to put up a link that changes a session_property, for instance to

change the number of items displayed or that sort of thing. The caller

must sign their values and URL, which are verified by the callee via

ad_page_contract. If the referrer doesn't match the signed expected

referrer, you get bounced. I think this is reasonably secure (though

permissions should always be rigorously checked on all pages, of course)

2. acs_events had an html_p flag in the datamodel but no way to set it.

Fixed. It should really be a mime-type but since it's not using the

CR, and since I'm extremely busy with other stuff, I didn't fix it.

3. While doing #1 above I learned that signing and verifying arrays didn't

quite work. Fixed.

4. Found and fixed a small problem with my earlier work on the currency widget.

  1. … 8 more files in changeset.
use ad_acs_kernel_id to get package_id

send the proper date format to ad_dateentrywidget

adjusted install sequence to use ad_parameter instead of checking db directly

There were some inconsistencies in the way return_url was being set up...

    • -1
    • +1
    ./obsolete-packages/acs-workflow/www/task.adp

Small change to wf_task_panels ...

fix bug that didn't allow for null charters

make it obvious that null charters are allowed

    • -1
    • +1
    ./obsolete-packages/bboard/www/forum-entry.adp
fix bug to allow for null charters

    • -2
    • +2
    ./obsolete-packages/bboard/www/forum-new-2.tcl
fix bug that dosen't allow null charters

    • -0
    • +2
    ./obsolete-packages/bboard/www/index.adp

Added a new proc to return the panels associated with a workflow ...

Removed references to jobs-start and jobs-kill (it's done in Tcl now)

Added a new function that returns the task_id for a particular case/taskkey.

The only way to get this (needed to fire a message transition) was for one's

client code to poke into the datamodel directly with a select.

1. Changed a couple of ns_schedule_proc calls to ad_schedule_proc.

2. Moved job scheduling for workflow from the db to tcl, because PG doesn't

support in-db job scheduling.

  1. … 4 more files in changeset.

1. Removed call to "schedule_proc" in acs-workflow. It's no longer needed.

2. Changed admin UI so you can enter the sort order when adding or editing

places.

3. Duplicated Bart Teeuwisse's glossary changes for Oracle.

  1. … 5 more files in changeset.
fix "cellpadding" typo that was causing bboard message list table to be very cluttered.

Fixed some errors in my earlier hacking on hierarchical queries...

    • -1
    • +1
    ./obsolete-packages/bboard/www/message-threaded-postgresql.xql
  1. … 3 more files in changeset.

Added code to make use of David Walker's wonderfully abusive hack on the

pg_proc table that showed me how to write recursive SQL functions. We now

have good use of the index on tree_sortkey when climbing the tree, woo-hoo!

  1. … 17 more files in changeset.

Oops - I'd previously committed a query with a literal substituted for

:forum_id, done back when I was hacking these queries for greater efficiency

using real test data. I was using psql so I was using literal values...

Changed the representation of tree_sortkeys from "text" to "bit varying".

    • -3
    • +10
    ./obsolete-packages/bboard/www/message-delete-2-postgresql.xql
    • -3
    • +3
    ./obsolete-packages/bboard/www/message-move-2-postgresql.xql
  1. … 57 more files in changeset.

Changed to the new tree_sortkey comparison scheme. Mostly untested (yet)

will do so shortly!

    • -16
    • +12
    ./obsolete-packages/bboard/tcl/bboard-procs-postgresql.xql
    • -7
    • +12
    ./obsolete-packages/bboard/www/forum.xql
    • -8
    • +3
    ./obsolete-packages/bboard/www/message-delete-2-postgresql.xql
    • -11
    • +6
    ./obsolete-packages/bboard/www/message-move-2-postgresql.xql
    • -7
    • +5
    ./obsolete-packages/bboard/www/message-threaded-postgresql.xql

1. Replaced more "tree_sortkey like" with "tree_sortkey between" expressions

2. Fixed a bad port of an Oracle query in site-nodes-procs.tcl and removed

a needless outer join from both versions in the process.

  1. … 11 more files in changeset.

Check the comments in postgresql.sql - my previous commit didn't quite work

as expected.

I also removed an ugly assumption made in the PG port in bboard-procs.tcl.

  1. … 1 more file in changeset.

Added "tree_left" and "tree_right" in order to optimize tree queries, which

I did for the bboard package. "LIKE (tree_sortkey || %)" never uses the

index as we thought it did, as it turns out ... see postgresql.sql for

example queries that do.

  1. … 1 more file in changeset.