------------------------------------------------------------- $Id: history,v 1.4 1998/01/28 17:30:24 nick Exp nick $ ------------------------------------------------------------- 98/01/30 - PTS/daa Version 1.71.33 PHP3 o I felt that it was time for a larger version hop :) o The database interface (db.php3) has been split up. This makes it easier to write support for other database engines. Another sideeffect is that the execution time of the parser is shortened. (This feature also appeared in PTS/DBS 1.72.00 PHP/FI.) ------------------------------------------------------------- 98/01/28 - PTS/daa Version 1.71.32c PHP3 o Now it doesn´t generate a notifying mail if the closing or modifying person is also the owner of the task. The owner of the project is still informed, even if he or she is the same person again. o Fixed small issue when generating notifying messages: There were
s instead of \ns. Looked nasty when viewing the mail. o When adding a new task, the contact name is filled with the login name (i.e. short name) of the opener. ------------------------------------------------------------- 98/01/26 - PTS/daa Version 1.71.32b PHP3 o removed the html link from the notifying messages. Mail reading programs should activate the link, though. ------------------------------------------------------------- 98/01/26 - PTS/daa Version 1.71.32a PHP3 o Fixed a couple of bugs in the modify-php3s. ------------------------------------------------------------- 98/01/19 - PTS/daa Version 1.71.32 PHP3 (an announced release) o Added to notifying messages a link which can be used to jump directly to the view of the pid/tid involved. ------------------------------------------------------------- 98/01/14 - PTS/daa Version 1.71.31b PHP3 o Fixed bug in statlist.inc (generates list of available statii for add.php3) Bug was only visible on certain browsers. ------------------------------------------------------------- 98/01/12 - PTS/daa Version 1.71.31a PHP3 o Passwords can be set using the normal User editing form. ------------------------------------------------------------- 98/01/05 - PTS/daa Version 1.71.31 PHP3 o Fixed "database issue" when closing a task. ------------------------------------------------------------- 97/12/31 - PTS/daa Version 1.71.30 PHP3 o Beginning the development of our PTS branch. o Ported the source code to PHP3, the new version of PHP/FI. See ISSUES for known issues. o Hacked in a message of the day. o Hacked it out ;) o Updated docs/ - please read them. ------------------------------------------------------------- 08/21/97 - Version 1.71.30 o Added 'mailer' variable to header.phtml so folks can set their own mailer. o Continued cleanup of LYNX-able code, including auto- detection of Lynx clients (sets the '$gui' var) etc. o Change of password authentication and cookie scheme. All passwords are now stored in the 'people' table in md5 hash form. Passwords can now not be entered via the 'people' table editor - they have to be set in the 'Change password' function in the maintenance menu. o The cookie stored in the client upon logging in is now far more difficult to spoof. It is a combination of an adminsitrator-defined server key, the users password, and their account name, in md5 hashed form. All these have to be right for a login to occur. o Users can now change their passwords via the 'prefs' function. o There is a new prefs tag called 'sel2' which defines how the second selection criteria works for the user. If it has the value 'assigned', then the user can select open tasks and projects that are 'assigned' to a specific user (including themselves). If it has the value 'opened', then the user can select tasks and project that were -opened by- a specific user (including themselves). o Data structures in the MYSQL tables have changed to set the larger text fields to 'BLOB' data types, to allow full free-form text, without restrictions on data length. o Added 'wrap=soft' tags to textarea fields to allow auto-cr when typing longer lines in. o Added commentary fields when updating/modifying a task or project. IN the case of a task, the commentary is added after the text of the change, ala "Changed assigned to tech from steve to frank
Cuz steve is out on vacation this week." This avoids having to double- followup a task when making a change so that more detail is on file. o Fixed formatting of date fields in project and task summary - was using wrong character to denote 'minute' on each task and project. (was using 'month'. oops) o Fixed typos in mysql structure files and some others in msql structure files. ------------------------------------------------------------- 07/08/97 - Version 1.71.22 o Ugh. 1.71.21 had a lot of problems. GROUP bugs now fixed, mysql structure files with correct varchar field sizes, 'prefs' bug probably squished. Problems with ',' handling in query string building fixed. Problem with 'Status' not being displayed right fixed. Other 'group' changes incorporated in properly. Problem with HTML links on the index page. o PostGresSQL support added, and db.phtml file adjusted. This required hcanges to rowid handling in other modules, so a lot of files changed to make the database interface more generic. o "install" document updated with postgres stuff. ------------------------------------------------------------- 07/07/97 - Version 1.71.21 o Mostly bug fixes submitted from the pts-users list. ------------------------------------------------------------- 06/20/97 - Version 1.71.20 o Converted all database dependent functions to use a generic 'db.phtml' module, which abstracts database calls into generic 'db_*' function calls. For instance, the standard 'msql(dbname,"select foo from blah")' is now just 'db_query("select foo from blah")'. These are all handled with the 'db.phtml' module. Support for msql 2.0b4 or later as well as MySQL 3.20.xx is included within db.phtml. I'd like to encourage folks to expand db.phtml to include other database engines (such as sybase and postgres), preferably without changes to the rest of PTS, but syntactic differences in SQL calls may make that impossible. For now, MSQL and MySQL are fully supported, and PTS runs identically under both. o Altered MYSQL structure files (with help) to have better index and rowid handling, also for backward compatibility. (in 'msql', '_rowid' is a system variable. By adding it to the table definitions, we can use the same codebase for both MSQL and MYSQL. o Allow modify of full details of tasks or projects if your user level is 10 or higher. o Fixed bug in m*.phtml that screwed up when indexes were present in msql tables. (somewhere along the line the field type went from 'unknown' to 'index') o Fixed bug when deleting rows in maintenance functions (some of the fixes I received in email were... very creative) o Cleaned up various post result screens that were just plain ugly. 'Return' button in top bar is fairly consistent now. ------------------------------------------------------------- 02/12/97 - Version 1.70.10 o Converted all msql functions to msql 2.0 for speed and robustness. o Changed field types for summaries to Msql 2.0 'text' fields, allowing unlimited length problem descriptions. o Changed database maintenance functions to handle _rowid editing, rather than guessing that the first field is the primary key. o Added 'group' table to allow grouping of projects under a specific workgroup. o Added 'function' menu within project zoom to allow selective viewing of tasks (open/closed/all) when viewing a project. o Added allowance of system administrator (or anyone with a level over 90) to edit a projects summary or details) o Added 'mail update' functions where someone will receive email when a change happens to hir project (configurable within prefs) o Added graphic buttons, changed layout of header a bit. o Added more detail on project and task zooms (show details about current tech, etc). ------------------------------------------------------------- 12/02/96 alpha update (Alpha-1.61) o Added special user 'guest' handling. If a user has a security level less than '10', they cannot edit or change any date, nor can they set their own preferences. NOTE - the 'guest' login is hardcoded into 'login.phtml' as the only account that is allowed access without a password. o Added '_tech' handling. If '_tech' is set for a user (can have the value of 'all'), then this is used as the default name to use in the browse screen for 'Assigned to'. The main use for this is to set a default for the 'guest' user to see 'all' tasks/projects when they log in. o Added '_dataset' handling. If this value is set for a user, it controls whether the browse screen defaults to 'projects' or 'tasks' (those are the two values that should go into the field). NOTE that the admin must add a default value into prefs for _dataset in order for other users to set their own prefs. If it is left alone, it defaults to 'tasks'. o Added 'preferences' to maintenance menu to help admins set defaults. o Took out the tabs in the