Activity OpenACS/openacs.org-dev/www/templates/widgets/postings.tcl

Tree
Accordion

Stats

Commits this week: 0

Total Committers:	3
Last Commit:	14 Nov
Commits this week:	0
Total Lines of Code (LoC):	48
Net change in LoC this week:	0

Commit Activity

last updated 2 hours ago

Constraints

Constraints: committers

Committer:

Log Comment:

Constraints: files

File Extension:

File Name:

Constraints: dates

Start Date:

End Date:

Friday 08 Nov 2002

2:28 am

daveb

More
MAIN:daveb:20021108012856
changed 1 file
MAIN

remove order by forum_name, we group them in the adp anyway

- -1
- +1
./postings.tcl
- History
- Source
- Diff
./postings.tcl

Thursday 31 Oct 2002

4:24 am

daveb

More
MAIN:daveb:20021031032425
changed 1 file
MAIN

honor the max days old parameter for postings

- -1
- +2
./postings.tcl
- History
- Source
- Diff
./postings.tcl

Monday 28 Oct 2002

2:05 am

daveb

More
MAIN:daveb:20021028010502
changed 13 files
MAIN

clean up templates, improve context bar handling. still more to do.

- -2
- +7
./postings.tcl
- History
- Source
- Diff
./postings.tcl
… 12 more files in changeset.

Monday 07 Oct 2002

6:55 pm

tracya

More
MAIN:tracya:20021007165513
changed 1 file
MAIN

2 things:

1) Excluded CVS Commits forum from recent postings. The package_id 3061 was hardcoded, so I hardcoded this as well figuring this page was slated as a one-off.

2) Removed the limit form the subquery (fm) and added it to the overall query. This was because the subquery would select messages that were later excluded by the where clauses. There was no messages returned from the query when CVS commits was excluded.

A general question - why was the subquery used as opposed to a straightforward join. If it was for general efficiency, moving the limit probably destroyed that. However, is the straightforward join really that expensive?