ffiiprojrank: sorting the FFII projects

--> [ make project menu | project table | mlht database | aktiv | project news ]

News & Chronology

• 2004-10-18 phm improves and starts to document this script

• 2004-09-00 phm writes this script in order to produce a more usable list of projects in the aktiv menu

Synopsis

See

• genba:/var/www/adm/bin/ffiiprojrank

This perl script generates the table 'projrank' in the ffii database. The table consists of two fields

• proj: project id
• projrank: project rank string: position in hierarchy top down from the trunk to the leaf, with interspersed 2-digit numbers based on evaluation of the project by the owner of its upper level project (upproj).

To sort projects, we now only need to add 'natural join projrank ... order by projrank' to the 'select' command. Without this auxiliary table, sorting would cost a lot of time (and coding effort).

To Do

• add an integer field for level depth (usable for indenting in tables and menus)