• last updated 17 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
improve spelling

  1. … 7 more files in changeset.
Fix oracle upgrade, remembering to keep privilege creation, which should indeed happen in the upgrade

  1. … 1 more file in changeset.
Skip column and attribute creation in this upgrade: people will get it from xotcl ORM in version 6.* and this upgrade would conflict

Fix upgrade script

file upgrade-6.0.0d1-6.0.0d2.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade-6.0.0d1-6.0.0d2.sql
  1. … 1 more file in changeset.
Chat Reform: reduce complexity by removing the 'chat_avatar_allow' privilege, 'chat_room_edit' should suffice.

  1. … 7 more files in changeset.
Chat data-model reform:

- introduce on delete cascade on foreign key constraints so package can be removed easily e.g. from the subsite UI

- remove remaining stored procedures (and function_args definitions) to relieve the burden on the development process and reduce divergency between oracle and postgres code

- converge oracle and postgres datamodels:

. oracle -> add missing messages_time_window column

. postgres -> remove creation_date from chat_transcripts, which was found to be still existing on old downstream installations

  1. … 9 more files in changeset.
file upgrade-5.0.1d6-5.0.1d7.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade-5.0.1d6-5.0.1d7.sql
  1. … 1 more file in changeset.
Chat Redesign: enable/disable avatar pictures by room, using the new attribute 'avatar_p', instead of by package instance, using the 'ShowAvatar' parameter.

  1. … 19 more files in changeset.
file upgrade-5.0.1d5-5.0.1d6.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./upgrade-5.0.1d5-5.0.1d6.sql
  1. … 1 more file in changeset.
Align case of acs_object_type with that of the actual table (fixes automated tests)

This change intentionally ignores Oracle, as its behavior with respect to case is not clear to me.

    • -0
    • +8
    ./upgrade-5.0-5.0.1d0.sql
  1. … 2 more files in changeset.
merged changes from the oacs-5-9 branch and resolved conflicts

  1. … 7829 more files in changeset.
Fix spelling errors

  1. … 16 more files in changeset.
Allow user to specify how far in the past people connecting to the chat will see.

This is important on Learn@WU because people joining the chat room later want to

see the full conversation and before this was not settable from the UI. (Now defaults

to 4 hours) Useful also when somebody accidentally refreshes the chat after the

timewindow has passed.

Took this chance to ease a bit every future development: removed stored procedures

slowing greatly any change on the data model in favor of plain sql statements.

Incremented usage of cache.

Removed duplicated database operation when managing transcripts.

Fixed transcript name not being shown when deleting.

  1. … 12 more files in changeset.
file upgrade-5.0d12-5.0d13.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./upgrade-5.0d12-5.0d13.sql
Chats won't throw an error anymore when people keep looking to a room that has been closed.

Instead, user will be informed that the room is unavailable.

Added missing locale key source of errors in the log.

Fixed wrong stored procedure, stating different arguments than in actual usage.

Cleaned up weird idioms in xql files and chat api, moved many db operations into tcl api.

Exploited cache (ns_cache) to retrieve quickly chat room information.

Improved code quality a bit.

Ported upstream some local modification, like prettifying of flags in chat room management

and fix of double quoting in chat's javascript.

  1. … 11 more files in changeset.
file upgrade-5.0d11-5.0d12.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./upgrade-5.0d11-5.0d12.sql
Fix typo from previous commit

  1. … 1 more file in changeset.
Introduced new options to set chat rooms so login and/or logout message are not issued everytime a user enters/exits the chat.

  1. … 15 more files in changeset.
file upgrade-5.0d10-5.0d11.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./upgrade-5.0d10-5.0d11.sql
  1. … 1 more file in changeset.
- modernize SQL

  1. … 6 more files in changeset.
PG 9.0 support. Avoiding using acs_object_id_seq view for fetchting next value for the t_acs_object_id_seq sequence.

    • -0
    • +49
    ./upgrade-5.0d8-5.0d9.sql
  1. … 2 more files in changeset.
upgrade scripts which is really a downgrade; does the same as upgrade-5.0d4-5.0d5.sql

    • -0
    • +92
    ./upgrade-5.0d6-5.0d7.sql
Rolled back HEAD to the version on the 5.3 branch

  1. … 110 more files in changeset.
Fixing a lot of bad programming techniques and try to get .LRN out of the package, in vain...

  1. … 8 more files in changeset.
removing dependencies with xotcl

adding upgrade script for postgres

    • -0
    • +692
    ./upgrade-5.0d6-5.1d.sql
  1. … 5 more files in changeset.
brought chat in cvs head to the same level as in oacs-5-2, normalized comparisons and expr (using eq etc.)

  1. … 81 more files in changeset.
update to make xotcl a dependency

  1. … 12 more files in changeset.
file upgrade-5.0d4-5.0d5.sql was initially added on branch oacs-5-2.

    • -0
    • +0
    ./upgrade-5.0d4-5.0d5.sql
Support flushing of messages at night

  1. … 18 more files in changeset.