categories-procs-postgresql.xql

  • last updated 22 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
merge of all changes on oacs-5-0 branch between tag openacs-5-0-0-final and jcd-merge-pre503 (except those in lars-blogger).

  1. … 5 more files in changeset.
- Fixed bug in caterogies where it gathered custom fields belonging

to children of a category, when it should get from itself and any

parent category.

- Fixed noquote bug in index.

  1. … 1 more file in changeset.
- Many fixes.

- More API refactoring (needs more).

- ad-new not working because I need to figure out a problem with default

values.

  1. … 8 more files in changeset.
- Realized I made a boo-boo by adding the keyword_id column that allows

per-category custom fields to the wrong table. Moved it to ca_attributes

and changed pl/pgsql and tcl api's accordingly.

- Create index in ca_attributes to improve speed. Still need to assess

where else we need indices.

- Changed API a bit. A couple functions named _exists_p were not boolean

at all, hence confusing.

- Updated user/admin files to reflect changes.

- Adding of custom fields now lets site-wide admin add site-wide custom

fields, otherwise only package-wise custom-fields.

- Improved fields UI. Needs more work.

- Updated Tcl callbacks.

  1. … 20 more files in changeset.
- Retrieving ads now returns all the custom fields for the category

asked for.

- New proc categories::get_custom_fields to return list of custom fields.

- Adding of custom fields now completely integrated with per-category

custom fields, plus improved UI.

  1. … 9 more files in changeset.
- Initial revision of the classified-ads package written by Deds Castillo

and Paul Doerwalds.

- Some modifications and improvements by Roberto Mello.

- Added Bugs and Features to the www/doc/index page.

- Will be committing more changes soon.

    • -0
    • +101
    ./categories-procs-postgresql.xql
  1. … 77 more files in changeset.