#9 Status should not be case sensitive

HEAD
open
nobody
Database (7)
5
2008-02-07
2008-02-07
Benjamin Oshrin
No

status is stored in mrsbs_meeting_info as UPPERCASE for active and lowercase for canceled. However, this is not necessarily portable across databases for searching purposes.

Revise status to be two chars wide, using I / XI notation. Would need to change

lib/database-schema.xml
lib/functions.php
lib/meetinginfo.php
schedule/confirm.php
schedule/review.php

Note that in PHP (string)$foo{0} = C (char *)foo[0].

Should probably also write a cancelled_status($status) function to determine if a status is a cancelled status.

See also:

https://sourceforge.net/tracker/index.php?func=detail&aid=1777359&group_id=194682&atid=950407

Discussion

  • Logged In: YES
    user_id=92307
    Originator: YES

    This might also require updatedb to be run to alter the column and convert existing values.