Need 3 different modifications done to the Project Pier management system.
1.) Need the ability to be able to search for projects from the dashboard. Currently you can only search within an open project, but I need the ability to query all available projects directly from the dashboard.
2.) Need the ability to 'lock' the editing of messages after 30 days. Currently the user who posted the message can edit the message indefinitely. I need to change this so that the message is locked after 30 days time.
3.) Need the ability to archive old projects. Currently this cannot be done, I need to be able to place projects in a 'closed' status so that their archived and can be searched somewhere for record keeping.
This database is currently up and running with documents already created. The changes would need to be made without bringing this database down, or late at night EST.