• last updated 10 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates

The original .xql contained sysdate.

    • -0
    • +18
    ./packages/payflowpro/tcl/payflowpro-procs-oracle.xql
    • -0
    • +18
    ./packages/payflowpro/tcl/payflowpro-procs-postgresql.xql
    • -14
    • +0
    ./packages/payflowpro/tcl/payflowpro-procs.xql

Removed " at the end of the query.

Replaced cleaned_package_key with package_key.

small fix

    • -1
    • +1
    ./packages/dotlrn/tcl/community-procs.xql
fix typo

andrew's tuning mods

    • -2
    • +17
    ./packages/dotlrn/tcl/community-procs.tcl
    • -1
    • +1
    ./packages/dotlrn/tcl/community-procs.xql
    • -2
    • +2
    ./packages/dotlrn/www/admin/users-oracle.xql
adding some indexes

added some indexes

commit

Performance enchancements based on our testing

added "(select acs.magic_object_id('registered_users') from dual)"

clause to registered_users view based on results from scalability testing.

Removed irrelevant calls to apm_tcl_or_sql_name_from_package_key.

    • -1
    • +0
    ./packages/payflowpro/www/admin/index.tcl
added site_nodes_parent_id_idx based on results from scalability testing

changed select_non_member_clubs to use minus anti-join

removed unused admin_p checks

select_non_dotlrn_users_count query now using andrew's faster minus antijoin

    • -31
    • +31
    ./packages/dotlrn/www/admin/users-oracle.xql
added global posting history

    • -0
    • +104
    ./packages/dotlrn-forums/www/user-history.adp
    • -0
    • +70
    ./packages/dotlrn-forums/www/user-history.tcl
    • -0
    • +20
    ./packages/dotlrn-forums/www/user-history.xql

Fixed dublicate Info.InputType.

added do abort

fixed name of portlet and newness tagging

added newness tagging

    • -2
    • +4
    ./packages/forums/www/forum-view-oracle.xql
    • -1
    • +2
    ./packages/forums/www/index-oracle.xql
improved query a tad

some UI improvements i'd forgotten to commit

    • -31
    • +67
    ./packages/dotlrn/www/admin/class.adp
use ad_return where there's an error

fix bug in evaluate_element_raw. don't do "Link" callback

    • -3
    • +3
    ./packages/new-portal/tcl/portal-procs.tcl
some UI improvements i'd forgotten to commit

    • -32
    • +72
    ./packages/dotlrn/www/admin/classes-chunk.adp
    • -17
    • +67
    ./packages/dotlrn/www/admin/clubs.adp
    • -21
    • +64
    ./packages/dotlrn/www/admin/departments.adp
    • -30
    • +51
    ./packages/dotlrn/www/admin/term.adp
    • -17
    • +53
    ./packages/dotlrn/www/admin/terms.adp
width made better

made rejection/approval only available to moderated forums

    • -0
    • +2
    ./packages/forums/www/message-chunk.adp
    • -1
    • +2
    ./packages/forums/www/message-chunk.tcl
    • -3
    • +3
    ./packages/forums/www/message-view.adp
    • -1
    • +7
    ./packages/forums/www/message-view.tcl
added better support for enabling/disabling forums

    • -1
    • +7
    ./packages/forums/www/message-view.tcl
    • -2
    • +2
    ./packages/forums/www/admin/forum-disable.tcl
    • -0
    • +8
    ./packages/forums/www/admin/forum-edit.adp
    • -2
    • +2
    ./packages/forums/www/admin/forum-enable.tcl
more respect of disabled forums