Index: openacs-4/packages/acs-admin/www/users/registration-history-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/users/Attic/registration-history-oracle.xql,v diff -u -N --- openacs-4/packages/acs-admin/www/users/registration-history-oracle.xql 29 Apr 2001 00:47:48 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,18 +0,0 @@ - - - - oracle8.1.6 - - - - select to_char(creation_date,'YYYYMM') as sort_key, rtrim(to_char(creation_date,'Month')) as pretty_month, to_char(creation_date,'YYYY') as pretty_year, count(*) as n_new -from users, acs_objects -where users.user_id = acs_objects.object_id -and creation_date is not null -group by to_char(creation_date,'YYYYMM'), to_char(creation_date,'Month'), to_char(creation_date,'YYYY') -order by 1 - - - - - Index: openacs-4/packages/acs-admin/www/users/registration-history-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/users/Attic/registration-history-postgresql.xql,v diff -u -N --- openacs-4/packages/acs-admin/www/users/registration-history-postgresql.xql 11 Nov 2003 14:30:35 -0000 1.2 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,19 +0,0 @@ - - - - postgresql7.1 - - - - select to_char(creation_date,'YYYYMM') as sort_key, rtrim(to_char(creation_date,'Month')) as pretty_month, to_char(creation_date,'YYYY') as pretty_year, count(*) as n_new -from users, acs_objects -where users.user_id = acs_objects.object_id -and creation_date is not null -and user_id <> 0 -group by to_char(creation_date,'YYYYMM'), to_char(creation_date,'Month'), to_char(creation_date,'YYYY') -order by 1 - - - - - Index: openacs-4/packages/acs-admin/www/users/registration-history.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/users/registration-history.xql,v diff -u -N --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-admin/www/users/registration-history.xql 30 May 2018 14:11:03 -0000 1.3 @@ -0,0 +1,16 @@ + + + + + + select to_char(creation_date,'YYYYMM') as sort_key, rtrim(to_char(creation_date,'Month')) as pretty_month, to_char(creation_date,'YYYY') as pretty_year, count(*) as n_new + from users, acs_objects + where users.user_id = acs_objects.object_id + and creation_date is not null + and user_id <> 0 + group by to_char(creation_date,'YYYYMM'), to_char(creation_date,'Month'), to_char(creation_date,'YYYY') + order by 1 + + + +