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

Tree
Accordion

Stats

Commits this week: 0

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

Commit Activity

last updated 4 hours ago

Constraints

Constraints: committers

Committer:

Log Comment:

Constraints: files

File Extension:

File Name:

Constraints: dates

Start Date:

End Date:

Tuesday 08 Jul 2003

7:08 pm

daveb

More
MAIN:daveb:20030708170829
changed 1 file
MAIN

Changed to order posts by last_child_post instead of posting date. This

lists the most recently active threads on the home page.

- -3
- +4
./postings.tcl
- History
- Source
- Diff
./postings.tcl

Sunday 02 Feb 2003

1:01 am

daveb

More
MAIN:daveb:20030202000128
changed 1 file
MAIN

html quote subject

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

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?