OpenACS / openacs-4 / packages / chat

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 11
Last Commit: 23 Apr
Commits this week: 0
Total Lines of Code (LoC): 2,881
Net change in LoC this week: 0

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 15 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 23 Nov 2016
8:51 pm

antoniop

file upgrade-5.0d12-5.0d13.sql was initially added on branch oacs-5-9.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.0d12-5.0d13.sql
Tuesday 22 Nov 2016
7:34 pm

antoniop

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.

Options
    • -110
    • +11
    ./postgresql/chat-create.sql
    • -0
    • +57
    ./postgresql/upgrade/upgrade-5.0d11-5.0d12.sql
  3. … 10 more files in changeset.
7:34 pm

antoniop

file upgrade-5.0d11-5.0d12.sql was initially added on branch oacs-5-9.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.0d11-5.0d12.sql
Friday 28 Oct 2016
9:10 pm

antoniop

Fix typo from previous commit

Options
    • -1
    • +2
    ./postgresql/chat-create.sql
    • -0
    • +1
    ./postgresql/upgrade/upgrade-5.0d10-5.0d11.sql
8:57 pm

antoniop

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

Options
    • -4
    • +19
    ./oracle/chat-create.sql
    • -0
    • +255
    ./oracle/upgrade/upgrade-5.0d10-5.0d11.sql
    • -20
    • +47
    ./postgresql/chat-create.sql
    • -0
    • +113
    ./postgresql/upgrade/upgrade-5.0d10-5.0d11.sql
  5. … 12 more files in changeset.
8:57 pm

antoniop

file upgrade-5.0d10-5.0d11.sql was initially added on branch oacs-5-9.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.0d10-5.0d11.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.0d10-5.0d11.sql
Monday 20 Jun 2016
11:00 am

gustafn

- modernize SQL

Options
    • -107
    • +193
    ./postgresql/chat-create.sql
    • -53
    • +60
    ./postgresql/chat-drop.sql
    • -32
    • +50
    ./postgresql/upgrade/upgrade-5.0d4-5.0d5.sql
    • -42
    • +68
    ./postgresql/upgrade/upgrade-5.0d6-5.0d7.sql
    • -13
    • +20
    ./postgresql/upgrade/upgrade-5.0d8-5.0d9.sql
  6. … 4 more files in changeset.
Tuesday 14 Dec 2010
4:04 pm

victorg

PG 9.0 support. Avoiding using acs_object_id_seq view for fetchting next value for the t_acs_object_id_seq sequence.

Options
    • -2
    • +2
    ./postgresql/chat-create.sql
    • -0
    • +49
    ./postgresql/upgrade/upgrade-5.0d8-5.0d9.sql
  3. … 1 more file in changeset.
Wednesday 05 Mar 2008
10:44 am

avni

upgrade script for 2.3.0->2.4 which is really a downgrade ; does the same as upgrade-5.0d4-5.0d5.sql

Options
    • -0
    • +264
    ./oracle/upgrade/upgrade-5.0d6-5.0d7.sql
Tuesday 04 Mar 2008
9:16 am

avni

upgrade scripts which is really a downgrade; does the same as upgrade-5.0d4-5.0d5.sql

Options
    • -0
    • +92
    ./postgresql/upgrade/upgrade-5.0d6-5.0d7.sql
Monday 19 Nov 2007
2:14 am

donb

Rolled back HEAD to the version on the 5.3 branch

Options
    • -1
    • +1
    ./oracle/chat-create.sql
    • -1
    • +1
    ./oracle/chat-drop.sql
    • -758
    • +156
    ./postgresql/chat-create.sql
    • -39
    • +5
    ./postgresql/chat-drop.sql
    • -677
    • +0
    ./postgresql/upgrade/upgrade-5.0d6-5.1d.sql
  6. … 106 more files in changeset.
Tuesday 03 Jul 2007
9:49 am

avni

reverting pablom's commits to oacs-5-2: see http://openacs.org/forums/message-view?message_id=1042586

Options
    • -0
    • +0
    ./oracle/chat-create.sql
    • -0
    • +0
    ./oracle/chat-drop.sql
    • -170
    • +71
    ./postgresql/chat-create.sql
    • -4
    • +2
    ./postgresql/chat-drop.sql
  5. … 54 more files in changeset.
Sunday 24 Jun 2007
5:21 pm

maltes

Fixing a lot of bad programming techniques and try to get .LRN out of the package, in vain...

Options
    • -21
    • +5
    ./postgresql/chat-create.sql
    • -21
    • +6
    ./postgresql/upgrade/upgrade-5.0d6-5.1d.sql
  3. … 7 more files in changeset.
Thursday 21 Jun 2007
1:06 pm

pablom

removing dependencies with xotcl

adding upgrade script for postgres

Options
    • -0
    • +692
    ./postgresql/upgrade/upgrade-5.0d6-5.1d.sql
  2. … 5 more files in changeset.
Thursday 07 Jun 2007
11:14 am

pablom

"New version of the package"

Options
    • -164
    • +683
    ./postgresql/chat-create.sql
    • -5
    • +37
    ./postgresql/chat-drop.sql
  3. … 87 more files in changeset.
Thursday 26 Oct 2006
1:11 pm

pablom

Improvements in order to increase the funcionalities, overall in the creation and using of chat rooms

Options
    • -71
    • +170
    ./postgresql/chat-create.sql
    • -3
    • +5
    ./postgresql/chat-drop.sql
  3. … 11 more files in changeset.
Tuesday 08 Aug 2006
11:26 pm

donb

First shot at merging oacs-5-2 apps used in .LRN to HEAD.

Options
    • -0
    • +0
    ./postgresql/chat-create.sql
  2. … 2478 more files in changeset.
Saturday 24 Jun 2006
4:23 pm

gustafn

brought chat in cvs head to the same level as in oacs-5-2, normalized comparisons and expr (using eq etc.)

Options
    • -19
    • +38
    ./oracle/chat-create.sql
    • -1
    • +2
    ./oracle/chat-drop.sql
    • -0
    • +252
    ./oracle/upgrade/upgrade-5.0d4-5.0d5.sql
    • -19
    • +25
    ./postgresql/chat-create.sql
    • -0
    • +76
    ./postgresql/upgrade/upgrade-5.0d4-5.0d5.sql
  6. … 77 more files in changeset.
Thursday 20 Apr 2006
11:29 am

emmar

Changing chat_msgs.creation_date from date to timestamptz datatype

Options
    • -3
    • +2
    ./postgresql/chat-create.sql
Tuesday 11 Apr 2006
1:29 pm

palberer

update to make xotcl a dependency

Options
    • -2
    • +11
    ./postgresql/upgrade/upgrade-5.0d4-5.0d5.sql
  2. … 12 more files in changeset.
9:18 am

emmar

deleting room_admin privilege was missing

Options
    • -1
    • +2
    ./oracle/chat-drop.sql
Monday 10 Apr 2006
1:52 pm

emmar

fix SQL syntax

Options
    • -20
    • +18
    ./oracle/chat-create.sql
    • -20
    • +19
    ./oracle/upgrade/upgrade-5.0d4-5.0d5.sql
Sunday 09 Apr 2006
6:31 pm

emmar

Adding auto_flush and auto_transcript for chat_rooms

Options
    • -12
    • +33
    ./oracle/chat-create.sql
    • -0
    • +253
    ./oracle/upgrade/upgrade-5.0d4-5.0d5.sql
6:31 pm

emmar

file upgrade-5.0d4-5.0d5.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-5.0d4-5.0d5.sql
Friday 07 Apr 2006
6:59 pm

palberer

file upgrade-5.0d4-5.0d5.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.0d4-5.0d5.sql
6:59 pm

palberer

Support flushing of messages at night

Options
    • -17
    • +24
    ./postgresql/chat-create.sql
    • -0
    • +67
    ./postgresql/upgrade/upgrade-5.0d4-5.0d5.sql
  3. … 17 more files in changeset.
Tuesday 14 Mar 2006
1:16 pm

emmar

Valencia chat package. Provides support for postgresql and few enhancements like user search.

Options
    • -0
    • +699
    ./postgresql/chat-create.sql
    • -0
    • +158
    ./postgresql/chat-drop.sql
  3. … 89 more files in changeset.
Wednesday 08 Oct 2003
6:32 pm

mohanp

Added upgrade to upgrade to changes made for Oracle 9i support

Options
    • -0
    • +344
    ./oracle/upgrade/upgrade-4.0.0-5.0d1.sql
  2. … 3 more files in changeset.
Tuesday 30 Sep 2003
2:10 pm

mohanp

Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

Options
    • -14
    • +14
    ./oracle/chat-create.sql
  2. … 275 more files in changeset.
Friday 20 Apr 2001
10:51 pm

donb

Forgot to define binary files before importing, so .gifs were messed up.

Options
    • -0
    • +0
    ./oracle/chat-create.sql
    • -0
    • +0
    ./oracle/chat-drop.sql
  3. … 2478 more files in changeset.