• last updated 1 hour ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Remove unneded xql

.xql-file reform of acs-admin

- remove sql statements from the code, where these are provided via .xql

- prefer empty sql statements over various forms of *SQL*

- remove obsolete Oracle queries

member_approve

member_ban

member_reject

member_deleted

member_unapprove

user_info

- remove obsolete .xql files (containing only unused query names)

www/users/modify-admin-privileges-oracle.xql

www/users/modify-admin-privileges-postgresql.xql

www/users/user-add-2.xql

  1. … 13 more files in changeset.
Moved double-click check up before we create the user, so we don't get the annoying error message in the error log. Also, got rid of the from the error we spit out if something does go wrong, since this variable is not defined, so we'd get a database error, then an internal server error.

  1. … 1 more file in changeset.
Merged with the 4.5 branch (oacs-4-5 tag "don-merge-1")

  1. … 58 more files in changeset.

Applied Tilmann Singer's patch #205 which sets the admin e-mail address as

the "from" field for e-mail mailed to a newly-registered user.

  1. … 1 more file in changeset.

1. Changed a lot of package info files to fix problems ...

2. Added Vinod's bboard patch

3. Rationalized party e-mail checking by putting a "before insert or update"

trigger on the table that lower-cases email (this was already done by the

party.new() func but at least one update missed this). Got rid of all

"lower(email) = " and "upper(email) = " checks and just made all use the

db email column directly and lower-cased Tcl vars. In this way the index

on the email column is always and consistently used without needing to

define functional indexes on the column (an EE feature for Oracle).

4. Rationalized naming of a couple of workflows and fixed a glossary PG bug

where apparently its workflow got overwritten by one from the CMS at some

point in time.

5. Made the .cmp/.dat/.frm filters in the template code usable though not

very beautiful nor exactly correct. But with practice you can use them

to debug pages in the packages/* hierarchy. I also turned these off by

default as there's no need to run these filters on a production site!

6. Performed minor surgery on templating, including adding a new

"ad_return_exception_template" that allows you to return a templated

error page and aborts the script.

7. ??? probably but I think this covers most stuff.

  1. … 74 more files in changeset.

More porting changes ...

  1. … 13 more files in changeset.

Fixed extractor and re-ran it, causing some file shuffling.

  1. … 11 more files in changeset.

1. Fixed apm_load_queries. Again? Yes, again. I fixed it real good this

time.

2. Added .xql files for acs-admin. APM .xql files have mostly but not

completely been ported. It sort of works though, cool!

1. Fixed apm_load_queries. Again? Yes, again. I fixed it real good this

time.

2. Added .xql files for acs-admin. APM .xql files have mostly but not

completely been ported. It sort of works though, cool!

  1. … 60 more files in changeset.