$Header: /cvsroot/tutos/tutos/ChangeLog,v 1.111.2.3 2005/03/06 09:44:07 gokohnert Exp $
March 6 2005
	* release 1.2.20050306
	* support of eaccelerator
	* fixed bug with mailattachements
	* some more translations
	* more dynamic loading of dlls for windows apache/php installations
	* support custom fields with team objects
	* changed all occurences of HTTP_POST_FILES to _FILES
	* added default Message of Today to motd_default.html (updates won't overwrite existing ones)
	* fixes in checklist module
	* mysql update swill runb a alter table change statement to adjust field sizes
	* fixed bug with debug.out file versioning
	* better handling of meanwhile deleted creators of objects
	* allow reminders to depend on task start and end dates
	* moved phpinfo.php to amdin dir
	* bugfixes
	* Updated language spanish Javier Linares <devel at javierlinares.com>
September 6 2004
	* made the start-stop timetracking for users available again
	* fix a problem with the main help page
	* some swedish language updates
	* fix Bugtracking
	* fix mailmode 4
	* fix repeating appointments in res_cal.php
September 1 2004
	* Release of 1.2.20040901
April xx 2004
	* Release of 1.2beta.200404xx	
	* BETA support of MS SQL server as a database hosting server
	* more fixes to handle code injection in userinput
	* display projects in RsourceOverview of Project Managers (res_cal.php)
	* new email flag when create / modify tasks  (thanks to ecosoft.net)
	* new custom dataase fields support (see tutos/php/db/table_custom_example.pinc)
April 12 2004
	* Release of 1.2beta.20040412	
	* document import via mail (see php/file/file_import.README)
	* documents can have multiple parent objects
	* new milestone flag for tasks
	* new reminder modul
	* new rate modul to support hourly rates (thanks to ecosoft.net)
	* excel export for timetrack_overview   (add a $format=excel to the url)
	* one step creation of users without defineing a adressentry first
	* a new (per database) baseurl config variable which will be used in generated mails and other output of TUTOS
	* note reminders will now work with given times.
	* new XML export. To get a XML File just add a &format=xml to address_show.php,company_show.php etc..
	* new permission type "use". This right is neccessary to use a object i.e. to attach something or to 
	  use a person as a participant in an meeting (not for own team members)
	* invoice pdf is now using fpdf package (see http://www.fpdf.org) 
	* performance fix in history browsing
	* bugtracking is a own module now
	* massupdate for "Add to watchlist"/"Delete from watchlist" in a lot of the overview pages
	* locations for addresses/companies and departments are now created together with the base entries
	* documents and notes and other objects could be reattached to another "related" object
	* history for changes by user (new link on mytutos)
	* massupdate for addresses
	* minical uses week start settings
	* team feature permissions
	* Session info in admin_show
	* project cloning (Thanks to Michal Salaban emes at pld-linux.org)
	* show inherited permissions on user_new dialog
	* logins are stored in users history
	* a per layout stylesheet
October 17 2003
	* Release of 1.1.20031017 (bugfixes)
July 15 2003
	* Release of 1.1.20030715
July 1 2003
	* task volume management has changed (volume planned, on the fly volume estimation)
	* support for new date formats
	* period selection on task overview
April  2003
	* mail to watchlist
	* webstack
March 5 2003
	* mail2sms gateway support. See $tutos[smsmail] variable in config
	* bug changes will only be mailed to creator / solver of bugs .
	  Project Teams have to set a bug on their watchlist to stay informed
	* team/permission handling will now support teams that are member of other teams
	* file attachment on mails
	* fixed default assignment of new bugs
	* pop before smtp support for mailer access authentifications
	* better conflict detectection on appointments
	* minical shows week numbers for better orientation
February 5 2003
	* Release of 1.1 (beta) for public testing
	* new handler (factbook/phpweather/fax/sms) for displayed infos
	* new changing the task reference
	* new changing the bug reference
	* new history of last visited objects
	* new backreferences from related products
	* change moved installations to a module
	* change moved url management to a module
	* change moved document management to a module
	* enhance complete bug overview in products
	* enhance complete timetrack overview in products
	* massupdate for object acl/permissions
September 5 2002
	* new support of database prefixes  
	  (add something like  $tutos[dbprefix][0] + "FOO_"; to your config.pinc) 
September 2 2002
	* new hungarian nameday file (contributed by Ferenc Raffael <raffaelf at interware.hu>)
September 1 2002
	* new conflict check on creation of appointments
August 31 2002
	* new email link for all project members
August 29 2002
	* new newsticker module
August 11 2002
	* started new page creation mechanism using "Layout Engines" (see php/layout/*)
	  This will allow a free choice of different layouts 
August 3 2002
	* new birthday reminder via watchlist (requires cronjob)
August 2 2002
	* new timetrack overview of all project related (bug/task etc) records
	 select the sum on the project detail page
July 26 2002
	* Release of 1.0
July 11 2002
	* fixed a problem with equally named departments in several companies
	  input fields for departmentnames now understand a syntax like DEPNAME / COMPANYNAME
July 9 2002
	* made notes and resources to modules
July 1 2002
	* made invoices to a module
June 12 2002
	* New Indicating the sort order on overview pages
	* Invoices will show task related timetracking
June 11 2002
	* Changed nearly all files in order to run with register_gloabls
	  set to Off
June 10 2002
	* new Timerecord function will create timetrack entries with start
	  and end timestamp. (See link on mytutos page)
June 5 2002
	* Added Spanish/Nicaragua language files
	  Contributed by Antonio Gallardo, AG Software, S. A. <agssa at ibw.com.ni>
May 30 2002
	* Added some new dutch special dates. 
	  Contributed by Robert Brouwer <rbrouwer at wise-guys dot nl>
May 26 2002
	* new: CRM Group module
May 25 2002
	* new: module support
May 22 2002
	* new: gantt graphics using the jpgraph package ( > verison 1.6.3)
	  contributed by Dimitri Fontaine <tapoueh at users.sourceforge.net>
May 3 2002
	* new: password reminder feature (see $tutos[pwlostfeature])
May 2 2002
	* new: feature permissions for teams. Teams can now provide their
	users with feature permissions. (team_new.php)
April 28 2002
	* updated spanish localization and new mail prototypes in spanish
	by Jordi Torne <tornej at grupocp.com>
April 27 2002
	* added support of namedays (by Sergiusz Pawlowicz <serek at
          users.sourceforge.net>),weekstart and workingdays to the users
	  profiles
April 26 2002
	* reschedule of tasks on task overview by Dimitri Fontaine <dfontaine at cvf.fr>
April 22 2002
	* bugfix searching bugs now looks for the new name field
April 18 2002
	* added PAM authentification using the PHP pam_auth  extension
	  from	http://www.math.ohio-state.edu/~ccunning/pam_auth.html
	  see $tutos[pamauth] and $tutos[pamservice] in config.pinc
April 12 2002
	* added LDAP authentification
	  contributed by Dimitri Fontaine <dfontaine at cvf.fr>
	  see $tutos[ldapauth***] in config.pinc
April 10 2002
	* added calendar view for resource usage. Called from resource_show.php
March 31 2002
	* added greek translation thanks to Dimitris Korbetis <korb at adbytel.com>
March 27 2002
	* RELEASE 20020327	
March 25 2002
	* new feature finetuning. All TUTOS features can now be finetuned
	  (create/see/search etc) on the "User Modify" Page (user.pinc / user_new.php)
March 23 2002
	* new swedish translation contributed by Lindqvist Jonas
	  <Jonas.Lindqvist at sweco.se>
March 10 2002
	* bugnames can be generated with a name rule
	  see $tutos[bugautoname] in config.pinc
February 24 2002
	* added oracle OCI support (db_oci.pinc) as Database type 8
February 23 2002
	* added thumbnail display of EXIF thumbnails in jpeg files
	  (file.pinc and file_show.php)
February 19 2002
	* disabled calendar display for unknown/not visible users and teams
February 10 2002
	* new update.php page for updating the database layout. No more
	alter table calls are neccessary now
February 9 2002
	* new table.pinc file with all table layouts and indices
February 8 2002
	* new invoice feature
February 7 2002
	* all objects are now derived from a common base class base.pinc
February 1 2002
	* new swiss holiday file from  Ludwig Raffler
	<Ludwig.Raffler at aia.ch> (see holiday_ch.pinc)
January 18 2002
	* new british holiday file from Jeremy Nicholson <jnicho02 at
	users.sourceforge.net> (see holiday_en_uk.pinc)
January 13 2002
	* allow to limit bug search to bugs that were assigned to the current_user
	* new mass update in the Appointment Overview Page
January 11 2002
	* new mass update in the Bug Overview
December 21 2001
	* new mass update in the ProductOverview and the TaskOverview Page
December 20 2001
	* new direct jump to appointment creation from department and
	company display
December 19 2001
	* bugfix repositories other then ../repository  (file: database.pinc)
	* bugfix display history sometimes stops  (file: history_show.php)
	* bugfix typo in department creation  (file: department_new.php)
December 18 2001
	* RELEASE 20011218
December 17 2001
	* mailbox functionality for moving,copying and deleting mails
	* more fields in timetrack for generating invoices (invoice support will
	come in a later release)
          in mysql:
!! -->      alter table timetrack add (currency varchar(4)); 
!! -->      alter table timetrack add (cph float); 
!! -->      alter table timetrack add (state int4); 
!! -->      alter table timetrack add (invoice int4); 
          in postgres:
!! -->      alter table timetrack add currency varchar(4); 
!! -->      alter table timetrack add cph float; 
!! -->      alter table timetrack add state int4; 
!! -->      alter table timetrack add invoice int4; 
          in oracle:
!! -->      alter table timetrack add column (currency varchar(4)); 
!! -->      alter table timetrack add column (cph float); 
!! -->      alter table timetrack add column (state int4); 
!! -->      alter table timetrack add column (invoice int4); 
December 10 2001
	* updated help system. The help system now uses PHP in its pages.
	* new ACL for adress and location entries
	* history for adressbook entries
November 10 2001
	* fixed bug with reapearing permissions when a user saves his own record
	* new Product Relations for Projects/Products
	  it is possible to define base products and/or sucessors
	  ancestors for a project/product using the same mechanisms like
	  roles
	* new per user holiday display. This needs a new column in the
	  people table. To create it you may perrform the following command:
          in mysql:
!! -->      alter table people add (holidays varchar(60)); 
          in postgres:
!! -->      alter table people add holidays varchar(60); 
          in oracle:
!! -->      alter table people add column (holidays varchar(60)); 
November 8 2001
	* added white CSS theme
October 16 2001
	* new display notes in the calendar at their "remember" date
	(thanks to Jeroen Baten <jbaten at i2rs.nl>)
September 27 2001
	* new external holiday files (php/holiday_es.pinc
	php/holiday_fr.pinc php/holiday_ko.pinc php/holiday_nl.pinc
	php/holiday_pl.pinc php/holiday_ru.pinc ) Please expand and
	translate !
September 16 2001
	* new urls that are added to team descriptions will appear in the
	  main navigation of all team members
	* new support of Interbase 6 Databases
September 13 2001
	* new mexican spanish translation < hcartagena at si-mx.com >
September 12 2001
	* new mexican holidays < hcartagena at si-mx.com >  holiday_mx.pinc
September 11 2001
	* moved holidays to own files
September 9 2001
	* added a new database table "tutos_dbs" to store info about
	  synced remote tutos databases.
	  To add this to existing installations please do

!! -->	  create table tutos_dbs (
	  id	       int4 primary key,        -- a ID
	  name	       varchar(30) not null,    -- database name
	  dbalias      varchar(60),             -- short text
	  dbhost       varchar(30),             -- hostname
	  dbuser       varchar(30),             -- username
	  dbpass       varchar(30),             -- password
	  dbhome       varchar(60),             -- path of ora_inst
	  dbport       int4,                    -- network port 
	  dbtype       int4,                    -- type: pg = 1 or 4, mysql = 2, oracle = 3, msql = 5, sybase = 6
	  repository   varchar(60),             -- path for files
	  last_date    $TS_TYPE,                -- date of last sync
	  last_id      int4,                    -- sequencer id at last sync
	  creator      int4,                    -- who is responsible, see adresses(id)
	  creation     $TS_TYPE not null        -- when was it created
	  );

	  where $TS_TYPE is timestamp in postgres, datetime in mysql and
	  date in oracle, for oracle also change the int4 to number(30,0)
	  This feature will hopefully allow database synchronisation in the
	  next release. TUTOS on mobile clients and resync after work. Cool !!
September 7 2001
	* new file search page file_select.php
September 6 2001
	* new usage of the jpgraph tool for statistic graphs (if
	  available). Make a [tutosdir]/php/jpgraph directory and put the
	  jpgraph files in there. You'll find jpgraph here
	  http://www.aditus.nu/jpgraph/
	* new watchlist support for documents
	* fix bug with task_overviews
September 5 2001
	* new users watchlist overview via the mytutos page
	* updated polish translation (serek)
August 31 2001
	* RELEASE 20010831
August 30 2001
	* finished tasks are no longer shown in the mytutos and personal
	  taskoverview page
August 27 2001
	* new acl_overview and message_overview and message_del scripts (Boris)
August 26 2001
	* NOTE: the task/timetrack mechanism has changed a bit since the
	  last release: accumulated time for a task is now stored in
	  timetrack entries and you have to book your old time as a new
	  one. Visit all tasks and check if the time displayed is correct
	  and if there is a are timetrack entries for all times (sum
	  timetrack == volume done ?). If your release is not too old
	  everything should be ok.
August 25 2001
	* the default theme is now the first one in the config.pinc list
August 22 2001
	* new/updated themes blue,red
	* completely reworked german translation (Boris)
August 21 2001
	* renamed calendar_ files to app_....
	* fixed: remaining comment in db.p3 (Oracle only)
	* fixed: permissions on note display
	* new: address_show, company_show and departemt_show will display all
	  roles in projects
August 19 2001
	* started a documentation project in order to minimize my time spent
	  with mails :-) (please see under [tutosdir]/documentation)
	* new projects and installations will show the time summaries from
	  subtasks and/or bugs,installations in the detail pages
August 11 2001
	* new watchlists will send a mail on object deletion
	  (see html/watch_del* for prototypes)
August 9 2001
	* fixed Product/Project Roles are now extendable by simply adding new
	  descriptions to the language files
	* new Resources can now be added to Projects ,Tasks and Installations
	* new dutch translation thanks to Marcel <mvisscher at mac.com>
August 8 2001
	* fixed Translation of Weekday names in title section
	* fixed some HTML errors using a validator
July 29 2001
	* ONE YEAR ChangeLog  (Salut !)
July 28 2001
	* fixed display order change machanism in file and appointment overviews
	* new weekstart config parameter. Weeks can start on Sunday or Monday.
	  See config.pinc
	* fixed personal tasks creation;
	* fixed missing sequencer for MySQL in the easy install routine
	  (scheme.php)
July 26 2001
	* RELEASE 20010726 (with a lot of file corruption problems on
	  sourceforge )
July 22 2001
	* new: task creation on the mytutos page. This is a first step towards
	  a new ToDO feature. personal task have no relation to a product or
	  project
	* fixed: file upoads with konquerer browser
	* updated: bug summaries are displayed with the accumulated time for
	  the bugs
July 18 2001
	* new: list of locations for appointments is now expandable using the
	  language files (see the comments there) and the .css files in html
	  subdir
	* new: logo in headline. You can define a url for a logo (i.e. your
	  organisation) in the TUTOS headline. It will be resized to 40 pixels
	  height. See config.pinc
July 15 2001
	* new: locations for departments
July 10 2001
	* new: Polish translation thanks to <ser at metalab.unc.edu>
July 06 2001
	* new: LDAP Search via address search page. LDAP Server could be
	  defined in config.pinc and PHP must know about LDAP
July 05 2001
	* new: installation without shellscripts
	  Please test this by calling http://[yourserver]/tutos/php/scheme.php
	  Still problems with postgres and oracle here
June 22 2001
	* bugfix: Quotes in texts made problems with Oracle Databases
June 21 2001
	* updated italian translation. Thanks to Alessandro Ciancaglini
	  <alo at mail.overweb.it>
	* mail via the new mail interface goes as bcc to the sender to let
	  him keep a copy
	* new: bugs can be deleted via the modify page when the bugdelete
	  flag is set in config.pinc
June 20 2001
	* fixed bug solver problem with teams as solver.
	* added "assigned to" to the Bug Overview list.
	* added optional Bug column to product overview page
	  (thanks to Thomas GIBERT <thomas.gibert at temis-group.com>).
June 18 2001
	* RELEASE 20010618 (and again my small Pentium 133 demo server could
	  not handle the freshmeat announcement !!)
	* recognition of urls in note texts. these will be "translated" to
	  useable links. (based on an idea of hannes kegel)
	* bugs can now be added to tasks
June 14 2001
	* new holiday mechanism. TUTOS now knows about most/some US holidays.
	  Thanks goes to Steve Lumos <slumos at users.sourceforge.net>
	  Holidayset selection is possible in config.pinc (currently US and
	  DE only)
	* new mail feature. You can write mails inside of TUTOS. Todo so just
	  enable the usemail flag in config.pinc and mailto: links will be
	  substituted with some internal mail application.
	  There is still a lot to do like attachments etc.
June 2 2001
	* new export of timetrack data. You'll see a link for export on the
	  timetrack_overview page. Exported data is a CSV file with one line
	  for each entry seperated by commas.
	* adressbook entries (new ones) can now only be modified by the
	  addressee and the creator. All other can only see the entry.
May 28 2001
	* new note search feature (note_select and note_overview). Thanks to
	  <nonn at resce.com>
May 14 2001
	* new (up to now partly) korean translation. Thanks to
	  <jack at mizi.com>
May 12 2001
	* some improvements with a seperate addressbook permission. It's
	  possible to restrict seeing/using the addressbook (incl. companies
	  and departments).
April 23 2001
	* new files can be attached to bugs.
	* date check for remember dates of notes
April 19 2001
	* fixed a bug with Opera Browser. These Browsers send an empty
	  parameter when nothing in a list is selected. This is bad with
	  resource lists and a new appointment.
April 16 2001
	* fixed some problems with the mailer code. Single dots in a message
	  should now be mailed.
	* fixed problems with mailing smtp (mailmode 2) via qmail and other
	  rfc strict mail servers
April 13 2001
	* product_overview got some JavaScript tool to select all fields
	* product_overview highlights the search text
	* product_select can search for all not closed or cancceled projects
	* company and department entries honour the acl default behaviour
	* company and department entries allow permission handling
April 8 2001
	* RELEASE 20010408
	* you now don't need to store a password in mailbox datasets
	  TUTOS will ask for it when open failed and tore it in its session
	  data for the remaining time of your login session
	* some more help files (resources)
April 5 2001
	* address/company and product overviews jump to the detail
	  page when only one result is found
	* company address/location record includes fax and phone
	* bugfix resources and access control list will work now
	  Attention: a user will need the modify right to use a resource !
April 3 2001
	* bugfix mistypes in scheme.sh fixed
April 2 2001
	* RELEASE 20010402
March 30 2001
	* fixed: product overview and bug overview do no longer show
	  invisible (due to permissions) entries
March 29 2001
	* new cascading style sheet "visual" from the nice guys at
	  Visual Inventor <designservices at visual-inventor.com>
	* new method for style dependent icons.
	  Style Icons shoould be stored in a subdir under [tutosdir]/html with
	  the same name as the style.
	  TUTOS defaults back to [tutosdir]/html
	  For known icon names look at setImages in user.pinc
March 28 2001
	* new two fields in product table for estimated start and end of a
	  project or product lifecycle.
	  On Postgres
!! -->    alter table products add (p_start timestamp,p_end timestamp);
	  On MySQL
!! -->    alter table products add (p_start datetime,p_end datetime);
	  On ORACLE
!! -->    alter table products add (p_start date,p_end date);
March 23 2001
	* new project/product statistics. For a Product Overview you can get a
	  graphical statistics page with some useful information.
March 22 2001
	* new project/product classifications.
	  There are two new classifications fields in the project description
	  It is possible to select descriptions from a list defined in the
	  language files. In order to customize these lists it is recommended
	  to use the custom language files.
	  See February 11.
	  new tables: projectclass1 and projectclass2
!! -->	  create table projectclass1 (pro_id int4, class_id int4);
!! -->	  create table projectclass2 (pro_id int4, class_id int4);
March 21 2001
	* new en-US language file which only includes the differences in date
	  formatting
	* new link from task display to timetrack fractions of this task
March 15 2001
	* mailbox overview now displays subfolders
March 5 2001
	* started work on resource management
February 25 2001
	* RELEASE 20010225
February 23 2001
	* new feature: Printable Project main page with unlimited display of
	  notes,documents installations etc.
February 21 2001
	* bugfix: problems when inserting a company location solved
	* new features: show the description of a person when displaying a
	  company or department. Show the project or visitor when displaying
	  appointments of company/department or project
February 20 2001
	* new mytutos.php page which shows recent files, notes, bugs and
	  projects of a user along with a one week calendar for appointments
	  and tasks. You can reach this page by clicking on the username in
	  the lefthand navigation bar everywhere in TUTOS
February 18 2001
	* new calendar search feature (see link at the end of calendar page)
	* new field in creation in files table
	  To Upgrade do this:
	  On Postgres
!! -->    alter table files add (creation timestamp);
	  On MySQL
!! -->    alter table files add (creation datetime);
	  On Oracle
!! -->    alter table files add (creation date);
February 17 2001
	* new note remember feature. TUTOS will send remember emails about
	  notes if asked to do so. This needs a running check.php feature.
	  See below at Oktober 21 2000 how to do this.
	  There are prototypes for english and german mail texts in the html
	  subdirectory (note_remember.proto.*). Defaults to english.
	* new field in notes table to describe the time to remember
	  To Upgrade do this:
	  On Postgres
!! -->    alter table notes add (remember timestamp);
	  On MySQL
!! -->    alter table notes add (remember datetime);
	  On Oracle
!! -->    alter table notes add (remember date);
February 15 2001
	* updated to real french translation (thanks to Eric Garrigues
	  <ericg at easynet.fr>)
February 14 2001
	* bugfixes: never a release with bugs immediately after releasing :-(
	  some mistyped variables in calendar_new and calendar_new_r that are
	  disturbing in some cases.
February 13 2001
	* RELEASE 20010213
February 11 2001
	* new feature custom language files:
	  TUTOS will include a custom language file fi available. This
	  allows customizing without problems when upgrading TUTOS.
	  Filenames are   "de_custom.p3", "en_custom.p3" etc. or simply
	  "lang_custom.p3".
	* new feature time booked on a task will also be booked on the
	  users timetrack table. Changes on these timetrack entry do
	  not affect the tasks.
	* new field in location table to describe the Function/Position
!! -->    alter table location add (desc1 varchar(30));
	* new feature when entering a address location wou can select to
	  copy a companies location
February 08 2001
	* new feature pictures with addresses
February 07 2001
!! -->	* added picture id to addresses table
	  To do this in an existing ebvironment do
	  alter table addresses add (pic_id int4);
February 05 2001
	* Bugfix wrong default permissions for tasks. Thanks to
	  kharpeet at kernel.hu
February 04 2001
	* start work on multiple database support
	  You can define multiple database in config.pinc.
!! -->	* CHANGE: On existing config.pinc files you have to add a [0] after
	  database related entries (have a look at the distributed config.pinc
February 01 2001
	* renamed classes user and address to tutos_user and tutos_address
	  This should help some people with preloaded PHP stuff
January 06 2001
	* Bugfix in minical.php & Date.php: Off by 1 Error with the new year
	  and some hardcoded stuff
	* new feature Statistic in Timetracking Overview Page
January 02 2001
	* new feature: watchlist view from project/bug/task modification page
	  you can see all users who are watching that object
December 28 2000
	* RELEASE 20001228
December 21 2000
	* new brazilian portuguese translation. Thanks to Eri R. Bastos
	  <erirb at sti.com.br>
December 20 2000
	* new tutos[defaultacl] variable in config.pinc.
	  This allows to select the access rights of some objects a creation
	  time. Either everybody can see the new object or only members of the
	  creators teams.
December 19 2000
	* bugfix: wrong content-types for Chinese (thanks to chusj at yahoo.com)
	  (Bug: #126278 at sourceforge)
December 17 2000
	* bugfix: missing getShortname in team.pinc (called by product_overview)
	* bugfix: missing sprintf in task_new.php (Bugs: #124325 and #124893 at
	  sourceforge)
December 5 2000
	* extended feature selection. A superuser can set every single feature
	  a user will use. i.e. You can have a user using only the calendar and
	  notes while other users can use project and bug management in
	  addition.
	  File: user_new.php , config.pinc
December 4 2000
	* bugfix: problem with calendar showing "all your teams"
December 3 2000
	* new watchlist feature. A user can set projects, tasks and bugs on his
	  personal watchlist and will be informed by mail whenever something
	  changed.
!! -->	  This needs a new table "watchlist" (see scheme.sh)
	* new private appointments. Those entries are only visible to
	  participants and will appear in a special color in the
	  timetable/calendar sheet
	* better checking of user inputs. (duplicate names and bad dates)
	  It is not longer possible to create a company, address, department,
	  product with the same name as a already existing one.
	* bugfix: missing initialzed date in team.pinc (Supportticket: #109412
	  at sourceforge)
December 2 2000
	* renamed the php3 files to php. This will make live easier for those
	  how have to maintain a additional PHP3 on their servers.
	* new Prototypes for mails (invitation, inivitation remember, bug new,
	  bug modify)
	  Look at html/....proto.[language]
	  Every participant of an appointment or stakeholder in a bug will be
	  informed in his/her preferred language (if available)
	  This fixes also Supportticket: #110179 at sourceforge.
	* new bug timeout feature. If a bug stays in "OPEN" for too long the
	  "assigned" user will be informed by email. You have to run check.php
	  by crontab to do this (see below Oct 21)
!! -->	  new table bugremember (see scheme.sh)
November 29 2000
	* RELEASE 20001129
November 27 2000
	* new translations for russian (file php/ru.p3)
	  Thanks to Alexandr Smirnov <smialex at ru.echo.fr>
	* bugfix sorting of projects by probability
	  Thanks to Alexandr Smirnov <smialex at ru.echo.fr> for finding the bug
November 26 2000
	* fixes problems with timezones (should work now with non postgres
	  databases)
	* new companies can now have a location set
November 25 2000
	* mail interface extended. You can now decide to send mail either via
	  sendmail or direct via smtp. See config.pinc for configuration
November 20 2000
	* new/updated translation for spanish
	  Thanks to Luca Olivetti <luca at wetron.es>
November 17 2000
	* new translations for simpliefied and tradional chinese
	  Thanks to Keith Tsao <keith.tsao at vatgroup.net>
	* new fax send feature
	  fax numbers will be clickable
	  This supports faxmail and faxspool from the mgetty package and should
	  be easily adoptable to other dax solutions (Please mail me !)
	* new SMS send feature
	  We only give some links to SMS service sites. All sites I checked do
	  not allow to automatically fill their forms. If someone knows a
	  better solution please inform me !!
November 15 2000
	* RELEASE 20001115
November 14 2000
	* new: timetrack feature
	  You can book time fractions on bugs and projects and will see the
	  sum of all hours book to a project or bug
November 12 2000
	* new: enabled Middle Initials in addresses
	  Please run the following SQL command:
	  update addresses set m_name = '' where m_name = null;
	* new: it is now possible to disable various parts of TUTOS
	  i.e if you dont like the notes just edit config.pinc and
	  change the $tutos[usenotes] to 0
November 11 2000
	* new: bug statistics (on bug_overview select the statistics link)
	* bugfix: language was set twice in user.pinc Updates (Oracle does not
	  like this) (thanks to Huy Nguyen)
November 10 2000
	* bugfix: modifying bugs does not work because of problems with project
	  roles
November 7 2000
	* bugfix: deleting notes does not worked not correctly
November 7 2000
	* some more check on delete links
November 6 2000
	* RELEASE 20001106
November 5 2000
	* some development on servlet version
November 4 2000
	* added some more help files
	* documetation update
October 28 2000
	* added a confirmation window (javascript) to most "delete_something"
	  links
	* new projectroles table
	  a "create table projectroles ...." is neccesary (see scheme.sh fori
	  details)
	  For Updating do something like:
	  MYSQL:
	  insert into projectroles (pro_id,adr_id,role_id) select id,manager,1 from products;
	  insert into projectroles (pro_id,adr_id,role_id) select id,manager2,3 from products;
	  insert into projectroles (pro_id,adr_id,role_id) select id,seller,4 from products;
	  POSTGRES:
	  insert into projectroles (pro_id,adr_id,role_id) (select id,manager,1 from products);
	  insert into projectroles (pro_id,adr_id,role_id) (select id,manager2,3 from products);
	  insert into projectroles (pro_id,adr_id,role_id) (select id,seller,4 from products);
October 26 2000
	* bugfix product overview sorted by state instead of creation
October 25 2000
	* bugfix added missing calendar_overview.php3 to Makefile and release
	  packages
October 21 2000
	* new remember mechanism. Calling check.php3 will sent remember emails
	  for appointments that asked for that.
	  Simply add something like:
	  */5 * * * * /usr/bin/lynx -accept_all_cookies -dump http://[yourhost]/tutos/php/check.php3 > /dev/null
	  to your crontab.
	  or use wget instead of lynx
October 20 2000
	* new history of changes for products
	  all modifications to a product are stored in history table
	  a "create table history ...." is neccesary (see scheme.sh for details)
	  Files: php/history.pinc php/history_show.php3
October 16 2000
	* RELEASE 20001016
October 15 2000
	* new map support clicking on a city name will take you (via 1 more
	  step) to a mapquest page with the city map
	* changed layout of note creation/modification
	* new createdb.sh handels ORACLE create/drop/dump/restore
October 14 2000
	* new notes are displayed with small icons
	* new moved from png to gif for icons (missed transparent handling)
October 8 2000
	* new bugs can now refer to installations of a product
October 6 2000
	* bugfix: mark required fields in address insertion form
October 4 2000
	* bugfix: product_overview sorting on pages > 1
	* bugfix: product_overview dispay of costs
	* bugfix: user.pinc save theme on creation time
	* bugfix: product.pinc save/read costs
	* bugfix: address_overview works now with multiple pages
	* bugfix: mailbox_overview display more than xx messages (missing
	  navigation)
October 3 2000
	* started french language support
	  by babelfish translation, so please ignore all bad translations :-)
October 2 2000
	* RELEASE 20001002
	* new The sequence of displayed fields for product overview is given
	  by config.pinc
	* new cost field for products/projects
October 1 2000
	* new documentation http://www.tutos.org/docs.html
	  Files: homepage/docs.html homepage/source_php.html
	  homepage/database.html homepage/source_java.html homepage/object.html
	* new handling of work volume that was done over the scheduled plan
	* new real start and end of tasks is now set
September 29 2000
	* bugfix deleting products
September 29 2000
	* new documentation files homepage/database.html homepage/docs.html
September 25 2000
	* new createdb.sh script that allows creation/deletion/dump/restore of
	  databases
	* bugfix when running scheme.sh (sequencers where not created)
	  (in file shellfunc.sh) [Sam Tilders" <sam at jovianprojects.com>]
September 24 2000
	* new extended permissions handling
	  most objects allow to grant/revoke permissions to users/teams that
	  are not initially connected (creator , manager etc) to it.
	  Have a look at the small (permissions) link in the upper right of
	  modification masks
	  Files: acl_new.php3 acl_show.php3 acl.pinc acl_ins.php3
	* bugfix when running inittutos.sh (missed creator field)
	  thanks to [Sam Tilders" <sam at jovianprojects.com>]
	* bugfix repeating appointments had troubles when inserting with enddate
September 23 2000
	* new mailbox support for projects and produts
	  TUTOS can handle a mailbox for projects.
	  We need a new table "mailboxes" (see scheme.sh)
	  Currently we store the clear password for the imap/pop3
	  Account in that table !!!
	  So I recommend to make a tutos only account without a login shell
	  to host the mailbox(es). To differ between different
	  products/projects you may use a .procmailrc for that account.
	  i.e.
	  ----------------------
	  MAILDIR=$HOME/Mail
	  :0
	  * Cc:.*project1.*
	  $MAILDIR/project
	  :0
	  * To:.*project1.*
	  $MAILDIR/project
	  ----------------------
	  So all mail with project1 in To or Cc will appear in a mailbox-file
	  that is accesible via TUTOS
	  Files: mailbox_new.php3 mailbox_show.php3 mailbox.pinc
		 mailbox_ins.php3 mailbox_del.php3
September 21 2000
	* bugfix showing a task
September 20 2000
	* bugfix inserting new bugs failed in last release. creation time was
	  missing.
	* new triming username and password on login check
September 19 2000
	* new extended search pages now remember their previuos settings
	* started a poorly translated spanish language file
	* new extended search with timeranges for bugs / and products
	* tested Zend Optimizer for php. It works ! see http://www.zend.com
September 18 2000
	* changed TIMESTAMP(14) to DATETIME in MySQL (make things easier)
	* ORACLE tests looked fine
September 17 2000
	* new file "mail.pinc" to handel all mail related things
	* mail notifications on bugs are sent to the Projects Manager the
	  assigned bug solver and the good guy who inserted the bug.
	* mail sending could be disabled in config.pinc
	  (I needed this on my demo side. Too many mails were sent
	   to bill.gates@...)
	* extended search modes for products (state) and bugs (state and/or
	  class) click on extended in the search pages
	* task overview links in "Team Detail" and "Address Detail" (for users)
	  page.
September 16 2000
	* some tuning on the MySQL and Oracle Interfaces
	* more translated strings
September 15 2000
	* file handling offers access to older version in TUTOS versioning
	  system
	* tutos[caltable] in config.pinc can make calendar display faster if
	  set to 1 for less complex table handling
	* handling for appointment reoccurence
	  You have to add some fields to the calendar table
	    repeat int4 default 0
	    r_arg  varchar(10)
	    r_ignore  int4 default 0
	* repeating events are m,marked with an (R) in the calendar sheet
September 14 2000
	* team_show, company_show, department_show and address_overview use
	  the same function for address listing now.
September 10 2000
	* More separation between PHP and SERVLET Version
	* TUTOS will appear in three different Versions all,php and java per
	  release
September 9 2000
	* Added theme mechanism. You can select a theme in the user modify
	  dialog.
	  Themes are css files lying around in [tutosdir]/html
	  Currently availabe tutos.css (default) and blue.css (just an example)
	* Added a team_overview page, which is only available to superusers.
	* Started with Timezone support , so appointments will display times in
	  the timezone of the current user. (Still not working !)
September 8 2000
	* rebuild installation guide. install.html is now part of every release
September 2 2000
	* after long stagnation played with JAVA part again
	* added projects and tasks to JAVA part
September 1 2000
	* Make the example.sh running again (with MYSql now)
	* Cleaned up parameter Transfer between *_new.php3 and *_ins.php3 files
August 31 2000
	* Make it run with MySQL  (still need testing)
	* Make it run with Oracle (still needs testing)
	* Installations Form has useful defaults now (derived from product)
	* Made new screenshots for homepage section
	* better transaction locking and errorhandling
August 28 2000
	* Ups there was a bug in scheme.sh. table files was not created.
	  I should to more testing
	* Inlucde this ChangeLog in distribution
	* Added php/.htaccess for security
August 27 2000
	* Display in overviews is limited to $tutos[maxshow] rows
	  and some navigation links are displayed to get the next/previous page
	  You can change this in [tutoshome]/php/config.pinc . Nice to have
	  this file :-)
	* added a global config file for all the things
	  that are different for each installation
	  have a look at [tutoshome]/php/config.pinc
August 26 2000
	* file/document management works with RCS now
	  three different versioning modes will be supported
	  - NO versioning (old files are substituted)
	  - TUTOS old files are simply copied away
	  - RCS old files are stored in RCS
	* new table needed
	  create table files ( ........ )   see scheme.sh for details
August 25 2000
	* got a translation for italian for free
	  see [tutoshome]/php/it.p3
	  thanks to Luca Pescatore <l.pescatore at network.it>
August 24 2000
	* announced TUTOS at freshmeat
August 22 2000
	* started file document management support
	  see [tutoshome]/php/file.pinc
August 21 2000
	* added seller to products
	  alter table products add (seller int4);
August 20 2000
	* today was the beginning of the user-help system
	  if help is available a help link automatically appears in the main
	  link list on the left side
August 19 2000
	* I realized that tutos now runs only with newer PHP
	  php 4RC2 seems not to have the sscanf function we use in product_ins
	  and installation_ins
	* Again more translated Strings (Error Messages).
August 18 2000
	* new resource calendar res_cal.php3 which shows appointments and
	  task (for team or address) combined in one page
	* more fields in products
	  please add
	  alter table products add (price float8);
	  alter table products add (currency varchar(4));
	* better product sorting and display in products_overview.php3
August 17 2000
	* sorting in bug_overview , address_overview , product_overview
August 12 2000
	A lot of changes
	* Tasks are now fairly usable
	* TUTOS starts to work with Mysql
	* the example.sql uses all features
	* switched to PHP 4.0.1pl2 (cause of mysql)
	* some new javascript hacks to help in calendar selection (minical.php3)
	* in order to run with mysql in the future we need some renamings
	  (dont ask me why):
	  alter table calendar rename column starting to a_start;
	  alter table calendar rename column ending to a_end;
	* new messsage of today feature
August 9 2000
	Introduced tasks because a collegue ask for it.
	Updaters have to add a new table tasks. Please see scheme.sql
	for details. Products can contain tasks and tasks can contain tasks
	again. My goal is to make some kind of netplan and give some
	documentation for projects.
	Stay tuned !
August 6 2000
	New ical/vCalendar and vCard support.
	Tutos can produce information for these technologys now.
	I'm looking for some usefull applications that need this feature :-)
August 5 2000
	Added some caching for Objects. We don't reread objects from the
	DB if they are in cache.
	I don't like cookies. So I started to add a SESSIONKEY to all
	generated links (this needs some testing).
	Now we are are using persistent DB Connections.
	* Introduced the long prepared notes.
	* It is possible to force the language by adding a &lg=de or &lg=en
	to the url. Good feature to find leaks in the translation !
	* Again more translated Strings.
	* the notes tabe layout changed in the database ! You will have to
	generate a new notes table. Look in scheme.sql for details.
August 2 2000
	Played with overlib (See http://www.bosrup.com/web/overlib/)
	Now if you have overlib.js in [tutoshome]/html
	we will you some nice features.
August 1 2000
	Companies as Visitors are possible now
	Found some nasty behaviour when ' Characters are in Database
	Querys. AddSlashes and StripSlashes should help here.
	More Translated Strings
	Product Table got new fields
	* desc1	   for free use
	* desc2	   for free use
	* state	   pre ongoing or finished
	* path	    for some url (e.g. cvs web)
July 29 2000
	Start ChangeLog

	Added product feature to calendar
	* links from appointments to products

	Added calendar link from addresses/users
	so it will be possible to see the calendar
	of a user. Up to now it was only possible
	to see calendars of your own or your teams
-------------------------------------------------------------------
Please send all your feedback to gokohnert at users.sourceforge.net