[Summary view] [Print] [Text view]

   1  $Header: /cvsroot/tutos/tutos/ChangeLog,v 1.111.2.4 2005/09/04 09:58:50 gokohnert Exp $
   2  Sepetember 4 2005
   3      * release 1.2.20050904
   4      * fixed problems witd dates before 1970
   5      * bugfixes
   6  March 6 2005
   7      * release 1.2.20050306
   8      * support of eaccelerator
   9      * fixed bug with mailattachements
  10      * some more translations
  11      * more dynamic loading of dlls for windows apache/php installations
  12      * support custom fields with team objects
  13      * changed all occurences of HTTP_POST_FILES to _FILES
  14      * added default Message of Today to motd_default.html (updates won't overwrite existing ones)
  15      * fixes in checklist module
  16      * mysql update swill runb a alter table change statement to adjust field sizes
  17      * fixed bug with debug.out file versioning
  18      * better handling of meanwhile deleted creators of objects
  19      * allow reminders to depend on task start and end dates
  20      * moved phpinfo.php to amdin dir
  21      * bugfixes
  22      * Updated language spanish Javier Linares <devel at javierlinares.com>
  23  September 6 2004
  24      * made the start-stop timetracking for users available again
  25      * fix a problem with the main help page
  26      * some swedish language updates
  27      * fix Bugtracking
  28      * fix mailmode 4
  29      * fix repeating appointments in res_cal.php
  30  September 1 2004
  31      * Release of 1.2.20040901
  32  April xx 2004
  33      * Release of 1.2beta.200404xx    
  34      * BETA support of MS SQL server as a database hosting server
  35      * more fixes to handle code injection in userinput
  36      * display projects in RsourceOverview of Project Managers (res_cal.php)
  37      * new email flag when create / modify tasks  (thanks to ecosoft.net)
  38      * new custom dataase fields support (see tutos/php/db/table_custom_example.pinc)
  39  April 12 2004
  40      * Release of 1.2beta.20040412    
  41      * document import via mail (see php/file/file_import.README)
  42      * documents can have multiple parent objects
  43      * new milestone flag for tasks
  44      * new reminder modul
  45      * new rate modul to support hourly rates (thanks to ecosoft.net)
  46      * excel export for timetrack_overview   (add a $format=excel to the url)
  47      * one step creation of users without defineing a adressentry first
  48      * a new (per database) baseurl config variable which will be used in generated mails and other output of TUTOS
  49      * note reminders will now work with given times.
  50      * new XML export. To get a XML File just add a &format=xml to address_show.php,company_show.php etc..
  51      * new permission type "use". This right is neccessary to use a object i.e. to attach something or to 
  52        use a person as a participant in an meeting (not for own team members)
  53      * invoice pdf is now using fpdf package (see http://www.fpdf.org) 
  54      * performance fix in history browsing
  55      * bugtracking is a own module now
  56      * massupdate for "Add to watchlist"/"Delete from watchlist" in a lot of the overview pages
  57      * locations for addresses/companies and departments are now created together with the base entries
  58      * documents and notes and other objects could be reattached to another "related" object
  59      * history for changes by user (new link on mytutos)
  60      * massupdate for addresses
  61      * minical uses week start settings
  62      * team feature permissions
  63      * Session info in admin_show
  64      * project cloning (Thanks to Michal Salaban emes at pld-linux.org)
  65      * show inherited permissions on user_new dialog
  66      * logins are stored in users history
  67      * a per layout stylesheet
  68  October 17 2003
  69      * Release of 1.1.20031017 (bugfixes)
  70  July 15 2003
  71      * Release of 1.1.20030715
  72  July 1 2003
  73      * task volume management has changed (volume planned, on the fly volume estimation)
  74      * support for new date formats
  75      * period selection on task overview
  76  April  2003
  77      * mail to watchlist
  78      * webstack
  79  March 5 2003
  80      * mail2sms gateway support. See $tutos[smsmail] variable in config
  81      * bug changes will only be mailed to creator / solver of bugs .
  82        Project Teams have to set a bug on their watchlist to stay informed
  83      * team/permission handling will now support teams that are member of other teams
  84      * file attachment on mails
  85      * fixed default assignment of new bugs
  86      * pop before smtp support for mailer access authentifications
  87      * better conflict detectection on appointments
  88      * minical shows week numbers for better orientation
  89  February 5 2003
  90      * Release of 1.1 (beta) for public testing
  91      * new handler (factbook/phpweather/fax/sms) for displayed infos
  92      * new changing the task reference
  93      * new changing the bug reference
  94      * new history of last visited objects
  95      * new backreferences from related products
  96      * change moved installations to a module
  97      * change moved url management to a module
  98      * change moved document management to a module
  99      * enhance complete bug overview in products
 100      * enhance complete timetrack overview in products
 101      * massupdate for object acl/permissions
 102  September 5 2002
 103      * new support of database prefixes  
 104        (add something like  $tutos[dbprefix][0] + "FOO_"; to your config.pinc) 
 105  September 2 2002
 106      * new hungarian nameday file (contributed by Ferenc Raffael <raffaelf at interware.hu>)
 107  September 1 2002
 108      * new conflict check on creation of appointments
 109  August 31 2002
 110      * new email link for all project members
 111  August 29 2002
 112      * new newsticker module
 113  August 11 2002
 114      * started new page creation mechanism using "Layout Engines" (see php/layout/*)
 115        This will allow a free choice of different layouts 
 116  August 3 2002
 117      * new birthday reminder via watchlist (requires cronjob)
 118  August 2 2002
 119      * new timetrack overview of all project related (bug/task etc) records
 120       select the sum on the project detail page
 121  July 26 2002
 122      * Release of 1.0
 123  July 11 2002
 124      * fixed a problem with equally named departments in several companies
 125        input fields for departmentnames now understand a syntax like DEPNAME / COMPANYNAME
 126  July 9 2002
 127      * made notes and resources to modules
 128  July 1 2002
 129      * made invoices to a module
 130  June 12 2002
 131      * New Indicating the sort order on overview pages
 132      * Invoices will show task related timetracking
 133  June 11 2002
 134      * Changed nearly all files in order to run with register_gloabls
 135        set to Off
 136  June 10 2002
 137      * new Timerecord function will create timetrack entries with start
 138        and end timestamp. (See link on mytutos page)
 139  June 5 2002
 140      * Added Spanish/Nicaragua language files
 141        Contributed by Antonio Gallardo, AG Software, S. A. <agssa at ibw.com.ni>
 142  May 30 2002
 143      * Added some new dutch special dates. 
 144        Contributed by Robert Brouwer <rbrouwer at wise-guys dot nl>
 145  May 26 2002
 146      * new: CRM Group module
 147  May 25 2002
 148      * new: module support
 149  May 22 2002
 150      * new: gantt graphics using the jpgraph package ( > verison 1.6.3)
 151        contributed by Dimitri Fontaine <tapoueh at users.sourceforge.net>
 152  May 3 2002
 153      * new: password reminder feature (see $tutos[pwlostfeature])
 154  May 2 2002
 155      * new: feature permissions for teams. Teams can now provide their
 156      users with feature permissions. (team_new.php)
 157  April 28 2002
 158      * updated spanish localization and new mail prototypes in spanish
 159      by Jordi Torne <tornej at grupocp.com>
 160  April 27 2002
 161      * added support of namedays (by Sergiusz Pawlowicz <serek at
 162            users.sourceforge.net>),weekstart and workingdays to the users
 163        profiles
 164  April 26 2002
 165      * reschedule of tasks on task overview by Dimitri Fontaine <dfontaine at cvf.fr>
 166  April 22 2002
 167      * bugfix searching bugs now looks for the new name field
 168  April 18 2002
 169      * added PAM authentification using the PHP pam_auth  extension
 170        from    http://www.math.ohio-state.edu/~ccunning/pam_auth.html
 171        see $tutos[pamauth] and $tutos[pamservice] in config.pinc
 172  April 12 2002
 173      * added LDAP authentification
 174        contributed by Dimitri Fontaine <dfontaine at cvf.fr>
 175        see $tutos[ldapauth***] in config.pinc
 176  April 10 2002
 177      * added calendar view for resource usage. Called from resource_show.php
 178  March 31 2002
 179      * added greek translation thanks to Dimitris Korbetis <korb at adbytel.com>
 180  March 27 2002
 181      * RELEASE 20020327    
 182  March 25 2002
 183      * new feature finetuning. All TUTOS features can now be finetuned
 184        (create/see/search etc) on the "User Modify" Page (user.pinc / user_new.php)
 185  March 23 2002
 186      * new swedish translation contributed by Lindqvist Jonas
 187        <Jonas.Lindqvist at sweco.se>
 188  March 10 2002
 189      * bugnames can be generated with a name rule
 190        see $tutos[bugautoname] in config.pinc
 191  February 24 2002
 192      * added oracle OCI support (db_oci.pinc) as Database type 8
 193  February 23 2002
 194      * added thumbnail display of EXIF thumbnails in jpeg files
 195        (file.pinc and file_show.php)
 196  February 19 2002
 197      * disabled calendar display for unknown/not visible users and teams
 198  February 10 2002
 199      * new update.php page for updating the database layout. No more
 200      alter table calls are neccessary now
 201  February 9 2002
 202      * new table.pinc file with all table layouts and indices
 203  February 8 2002
 204      * new invoice feature
 205  February 7 2002
 206      * all objects are now derived from a common base class base.pinc
 207  February 1 2002
 208      * new swiss holiday file from  Ludwig Raffler
 209      <Ludwig.Raffler at aia.ch> (see holiday_ch.pinc)
 210  January 18 2002
 211      * new british holiday file from Jeremy Nicholson <jnicho02 at
 212      users.sourceforge.net> (see holiday_en_uk.pinc)
 213  January 13 2002
 214      * allow to limit bug search to bugs that were assigned to the current_user
 215      * new mass update in the Appointment Overview Page
 216  January 11 2002
 217      * new mass update in the Bug Overview
 218  December 21 2001
 219      * new mass update in the ProductOverview and the TaskOverview Page
 220  December 20 2001
 221      * new direct jump to appointment creation from department and
 222      company display
 223  December 19 2001
 224      * bugfix repositories other then ../repository  (file: database.pinc)
 225      * bugfix display history sometimes stops  (file: history_show.php)
 226      * bugfix typo in department creation  (file: department_new.php)
 227  December 18 2001
 228      * RELEASE 20011218
 229  December 17 2001
 230      * mailbox functionality for moving,copying and deleting mails
 231      * more fields in timetrack for generating invoices (invoice support will
 232      come in a later release)
 233            in mysql:
 234  !! -->      alter table timetrack add (currency varchar(4)); 
 235  !! -->      alter table timetrack add (cph float); 
 236  !! -->      alter table timetrack add (state int4); 
 237  !! -->      alter table timetrack add (invoice int4); 
 238            in postgres:
 239  !! -->      alter table timetrack add currency varchar(4); 
 240  !! -->      alter table timetrack add cph float; 
 241  !! -->      alter table timetrack add state int4; 
 242  !! -->      alter table timetrack add invoice int4; 
 243            in oracle:
 244  !! -->      alter table timetrack add column (currency varchar(4)); 
 245  !! -->      alter table timetrack add column (cph float); 
 246  !! -->      alter table timetrack add column (state int4); 
 247  !! -->      alter table timetrack add column (invoice int4); 
 248  December 10 2001
 249      * updated help system. The help system now uses PHP in its pages.
 250      * new ACL for adress and location entries
 251      * history for adressbook entries
 252  November 10 2001
 253      * fixed bug with reapearing permissions when a user saves his own record
 254      * new Product Relations for Projects/Products
 255        it is possible to define base products and/or sucessors
 256        ancestors for a project/product using the same mechanisms like
 257        roles
 258      * new per user holiday display. This needs a new column in the
 259        people table. To create it you may perrform the following command:
 260            in mysql:
 261  !! -->      alter table people add (holidays varchar(60)); 
 262            in postgres:
 263  !! -->      alter table people add holidays varchar(60); 
 264            in oracle:
 265  !! -->      alter table people add column (holidays varchar(60)); 
 266  November 8 2001
 267      * added white CSS theme
 268  October 16 2001
 269      * new display notes in the calendar at their "remember" date
 270      (thanks to Jeroen Baten <jbaten at i2rs.nl>)
 271  September 27 2001
 272      * new external holiday files (php/holiday_es.pinc
 273      php/holiday_fr.pinc php/holiday_ko.pinc php/holiday_nl.pinc
 274      php/holiday_pl.pinc php/holiday_ru.pinc ) Please expand and
 275      translate !
 276  September 16 2001
 277      * new urls that are added to team descriptions will appear in the
 278        main navigation of all team members
 279      * new support of Interbase 6 Databases
 280  September 13 2001
 281      * new mexican spanish translation < hcartagena at si-mx.com >
 282  September 12 2001
 283      * new mexican holidays < hcartagena at si-mx.com >  holiday_mx.pinc
 284  September 11 2001
 285      * moved holidays to own files
 286  September 9 2001
 287      * added a new database table "tutos_dbs" to store info about
 288        synced remote tutos databases.
 289        To add this to existing installations please do
 290  
 291  !! -->      create table tutos_dbs (
 292        id           int4 primary key,        -- a ID
 293        name           varchar(30) not null,    -- database name
 294        dbalias      varchar(60),             -- short text
 295        dbhost       varchar(30),             -- hostname
 296        dbuser       varchar(30),             -- username
 297        dbpass       varchar(30),             -- password
 298        dbhome       varchar(60),             -- path of ora_inst
 299        dbport       int4,                    -- network port 
 300        dbtype       int4,                    -- type: pg = 1 or 4, mysql = 2, oracle = 3, msql = 5, sybase = 6
 301        repository   varchar(60),             -- path for files
 302        last_date    $TS_TYPE,                -- date of last sync
 303        last_id      int4,                    -- sequencer id at last sync
 304        creator      int4,                    -- who is responsible, see adresses(id)
 305        creation     $TS_TYPE not null        -- when was it created
 306        );
 307  
 308        where $TS_TYPE is timestamp in postgres, datetime in mysql and
 309        date in oracle, for oracle also change the int4 to number(30,0)
 310        This feature will hopefully allow database synchronisation in the
 311        next release. TUTOS on mobile clients and resync after work. Cool !!
 312  September 7 2001
 313      * new file search page file_select.php
 314  September 6 2001
 315      * new usage of the jpgraph tool for statistic graphs (if
 316        available). Make a [tutosdir]/php/jpgraph directory and put the
 317        jpgraph files in there. You'll find jpgraph here
 318        http://www.aditus.nu/jpgraph/
 319      * new watchlist support for documents
 320      * fix bug with task_overviews
 321  September 5 2001
 322      * new users watchlist overview via the mytutos page
 323      * updated polish translation (serek)
 324  August 31 2001
 325      * RELEASE 20010831
 326  August 30 2001
 327      * finished tasks are no longer shown in the mytutos and personal
 328        taskoverview page
 329  August 27 2001
 330      * new acl_overview and message_overview and message_del scripts (Boris)
 331  August 26 2001
 332      * NOTE: the task/timetrack mechanism has changed a bit since the
 333        last release: accumulated time for a task is now stored in
 334        timetrack entries and you have to book your old time as a new
 335        one. Visit all tasks and check if the time displayed is correct
 336        and if there is a are timetrack entries for all times (sum
 337        timetrack == volume done ?). If your release is not too old
 338        everything should be ok.
 339  August 25 2001
 340      * the default theme is now the first one in the config.pinc list
 341  August 22 2001
 342      * new/updated themes blue,red
 343      * completely reworked german translation (Boris)
 344  August 21 2001
 345      * renamed calendar_ files to app_....
 346      * fixed: remaining comment in db.p3 (Oracle only)
 347      * fixed: permissions on note display
 348      * new: address_show, company_show and departemt_show will display all
 349        roles in projects
 350  August 19 2001
 351      * started a documentation project in order to minimize my time spent
 352        with mails :-) (please see under [tutosdir]/documentation)
 353      * new projects and installations will show the time summaries from
 354        subtasks and/or bugs,installations in the detail pages
 355  August 11 2001
 356      * new watchlists will send a mail on object deletion
 357        (see html/watch_del* for prototypes)
 358  August 9 2001
 359      * fixed Product/Project Roles are now extendable by simply adding new
 360        descriptions to the language files
 361      * new Resources can now be added to Projects ,Tasks and Installations
 362      * new dutch translation thanks to Marcel <mvisscher at mac.com>
 363  August 8 2001
 364      * fixed Translation of Weekday names in title section
 365      * fixed some HTML errors using a validator
 366  July 29 2001
 367      * ONE YEAR ChangeLog  (Salut !)
 368  July 28 2001
 369      * fixed display order change machanism in file and appointment overviews
 370      * new weekstart config parameter. Weeks can start on Sunday or Monday.
 371        See config.pinc
 372      * fixed personal tasks creation;
 373      * fixed missing sequencer for MySQL in the easy install routine
 374        (scheme.php)
 375  July 26 2001
 376      * RELEASE 20010726 (with a lot of file corruption problems on
 377        sourceforge )
 378  July 22 2001
 379      * new: task creation on the mytutos page. This is a first step towards
 380        a new ToDO feature. personal task have no relation to a product or
 381        project
 382      * fixed: file upoads with konquerer browser
 383      * updated: bug summaries are displayed with the accumulated time for
 384        the bugs
 385  July 18 2001
 386      * new: list of locations for appointments is now expandable using the
 387        language files (see the comments there) and the .css files in html
 388        subdir
 389      * new: logo in headline. You can define a url for a logo (i.e. your
 390        organisation) in the TUTOS headline. It will be resized to 40 pixels
 391        height. See config.pinc
 392  July 15 2001
 393      * new: locations for departments
 394  July 10 2001
 395      * new: Polish translation thanks to <ser at metalab.unc.edu>
 396  July 06 2001
 397      * new: LDAP Search via address search page. LDAP Server could be
 398        defined in config.pinc and PHP must know about LDAP
 399  July 05 2001
 400      * new: installation without shellscripts
 401        Please test this by calling http://[yourserver]/tutos/php/scheme.php
 402        Still problems with postgres and oracle here
 403  June 22 2001
 404      * bugfix: Quotes in texts made problems with Oracle Databases
 405  June 21 2001
 406      * updated italian translation. Thanks to Alessandro Ciancaglini
 407        <alo at mail.overweb.it>
 408      * mail via the new mail interface goes as bcc to the sender to let
 409        him keep a copy
 410      * new: bugs can be deleted via the modify page when the bugdelete
 411        flag is set in config.pinc
 412  June 20 2001
 413      * fixed bug solver problem with teams as solver.
 414      * added "assigned to" to the Bug Overview list.
 415      * added optional Bug column to product overview page
 416        (thanks to Thomas GIBERT <thomas.gibert at temis-group.com>).
 417  June 18 2001
 418      * RELEASE 20010618 (and again my small Pentium 133 demo server could
 419        not handle the freshmeat announcement !!)
 420      * recognition of urls in note texts. these will be "translated" to
 421        useable links. (based on an idea of hannes kegel)
 422      * bugs can now be added to tasks
 423  June 14 2001
 424      * new holiday mechanism. TUTOS now knows about most/some US holidays.
 425        Thanks goes to Steve Lumos <slumos at users.sourceforge.net>
 426        Holidayset selection is possible in config.pinc (currently US and
 427        DE only)
 428      * new mail feature. You can write mails inside of TUTOS. Todo so just
 429        enable the usemail flag in config.pinc and mailto: links will be
 430        substituted with some internal mail application.
 431        There is still a lot to do like attachments etc.
 432  June 2 2001
 433      * new export of timetrack data. You'll see a link for export on the
 434        timetrack_overview page. Exported data is a CSV file with one line
 435        for each entry seperated by commas.
 436      * adressbook entries (new ones) can now only be modified by the
 437        addressee and the creator. All other can only see the entry.
 438  May 28 2001
 439      * new note search feature (note_select and note_overview). Thanks to
 440        <nonn at resce.com>
 441  May 14 2001
 442      * new (up to now partly) korean translation. Thanks to
 443        <jack at mizi.com>
 444  May 12 2001
 445      * some improvements with a seperate addressbook permission. It's
 446        possible to restrict seeing/using the addressbook (incl. companies
 447        and departments).
 448  April 23 2001
 449      * new files can be attached to bugs.
 450      * date check for remember dates of notes
 451  April 19 2001
 452      * fixed a bug with Opera Browser. These Browsers send an empty
 453        parameter when nothing in a list is selected. This is bad with
 454        resource lists and a new appointment.
 455  April 16 2001
 456      * fixed some problems with the mailer code. Single dots in a message
 457        should now be mailed.
 458      * fixed problems with mailing smtp (mailmode 2) via qmail and other
 459        rfc strict mail servers
 460  April 13 2001
 461      * product_overview got some JavaScript tool to select all fields
 462      * product_overview highlights the search text
 463      * product_select can search for all not closed or cancceled projects
 464      * company and department entries honour the acl default behaviour
 465      * company and department entries allow permission handling
 466  April 8 2001
 467      * RELEASE 20010408
 468      * you now don't need to store a password in mailbox datasets
 469        TUTOS will ask for it when open failed and tore it in its session
 470        data for the remaining time of your login session
 471      * some more help files (resources)
 472  April 5 2001
 473      * address/company and product overviews jump to the detail
 474        page when only one result is found
 475      * company address/location record includes fax and phone
 476      * bugfix resources and access control list will work now
 477        Attention: a user will need the modify right to use a resource !
 478  April 3 2001
 479      * bugfix mistypes in scheme.sh fixed
 480  April 2 2001
 481      * RELEASE 20010402
 482  March 30 2001
 483      * fixed: product overview and bug overview do no longer show
 484        invisible (due to permissions) entries
 485  March 29 2001
 486      * new cascading style sheet "visual" from the nice guys at
 487        Visual Inventor <designservices at visual-inventor.com>
 488      * new method for style dependent icons.
 489        Style Icons shoould be stored in a subdir under [tutosdir]/html with
 490        the same name as the style.
 491        TUTOS defaults back to [tutosdir]/html
 492        For known icon names look at setImages in user.pinc
 493  March 28 2001
 494      * new two fields in product table for estimated start and end of a
 495        project or product lifecycle.
 496        On Postgres
 497  !! -->    alter table products add (p_start timestamp,p_end timestamp);
 498        On MySQL
 499  !! -->    alter table products add (p_start datetime,p_end datetime);
 500        On ORACLE
 501  !! -->    alter table products add (p_start date,p_end date);
 502  March 23 2001
 503      * new project/product statistics. For a Product Overview you can get a
 504        graphical statistics page with some useful information.
 505  March 22 2001
 506      * new project/product classifications.
 507        There are two new classifications fields in the project description
 508        It is possible to select descriptions from a list defined in the
 509        language files. In order to customize these lists it is recommended
 510        to use the custom language files.
 511        See February 11.
 512        new tables: projectclass1 and projectclass2
 513  !! -->      create table projectclass1 (pro_id int4, class_id int4);
 514  !! -->      create table projectclass2 (pro_id int4, class_id int4);
 515  March 21 2001
 516      * new en-US language file which only includes the differences in date
 517        formatting
 518      * new link from task display to timetrack fractions of this task
 519  March 15 2001
 520      * mailbox overview now displays subfolders
 521  March 5 2001
 522      * started work on resource management
 523  February 25 2001
 524      * RELEASE 20010225
 525  February 23 2001
 526      * new feature: Printable Project main page with unlimited display of
 527        notes,documents installations etc.
 528  February 21 2001
 529      * bugfix: problems when inserting a company location solved
 530      * new features: show the description of a person when displaying a
 531        company or department. Show the project or visitor when displaying
 532        appointments of company/department or project
 533  February 20 2001
 534      * new mytutos.php page which shows recent files, notes, bugs and
 535        projects of a user along with a one week calendar for appointments
 536        and tasks. You can reach this page by clicking on the username in
 537        the lefthand navigation bar everywhere in TUTOS
 538  February 18 2001
 539      * new calendar search feature (see link at the end of calendar page)
 540      * new field in creation in files table
 541        To Upgrade do this:
 542        On Postgres
 543  !! -->    alter table files add (creation timestamp);
 544        On MySQL
 545  !! -->    alter table files add (creation datetime);
 546        On Oracle
 547  !! -->    alter table files add (creation date);
 548  February 17 2001
 549      * new note remember feature. TUTOS will send remember emails about
 550        notes if asked to do so. This needs a running check.php feature.
 551        See below at Oktober 21 2000 how to do this.
 552        There are prototypes for english and german mail texts in the html
 553        subdirectory (note_remember.proto.*). Defaults to english.
 554      * new field in notes table to describe the time to remember
 555        To Upgrade do this:
 556        On Postgres
 557  !! -->    alter table notes add (remember timestamp);
 558        On MySQL
 559  !! -->    alter table notes add (remember datetime);
 560        On Oracle
 561  !! -->    alter table notes add (remember date);
 562  February 15 2001
 563      * updated to real french translation (thanks to Eric Garrigues
 564        <ericg at easynet.fr>)
 565  February 14 2001
 566      * bugfixes: never a release with bugs immediately after releasing :-(
 567        some mistyped variables in calendar_new and calendar_new_r that are
 568        disturbing in some cases.
 569  February 13 2001
 570      * RELEASE 20010213
 571  February 11 2001
 572      * new feature custom language files:
 573        TUTOS will include a custom language file fi available. This
 574        allows customizing without problems when upgrading TUTOS.
 575        Filenames are   "de_custom.p3", "en_custom.p3" etc. or simply
 576        "lang_custom.p3".
 577      * new feature time booked on a task will also be booked on the
 578        users timetrack table. Changes on these timetrack entry do
 579        not affect the tasks.
 580      * new field in location table to describe the Function/Position
 581  !! -->    alter table location add (desc1 varchar(30));
 582      * new feature when entering a address location wou can select to
 583        copy a companies location
 584  February 08 2001
 585      * new feature pictures with addresses
 586  February 07 2001
 587  !! -->    * added picture id to addresses table
 588        To do this in an existing ebvironment do
 589        alter table addresses add (pic_id int4);
 590  February 05 2001
 591      * Bugfix wrong default permissions for tasks. Thanks to
 592        kharpeet at kernel.hu
 593  February 04 2001
 594      * start work on multiple database support
 595        You can define multiple database in config.pinc.
 596  !! -->    * CHANGE: On existing config.pinc files you have to add a [0] after
 597        database related entries (have a look at the distributed config.pinc
 598  February 01 2001
 599      * renamed classes user and address to tutos_user and tutos_address
 600        This should help some people with preloaded PHP stuff
 601  January 06 2001
 602      * Bugfix in minical.php & Date.php: Off by 1 Error with the new year
 603        and some hardcoded stuff
 604      * new feature Statistic in Timetracking Overview Page
 605  January 02 2001
 606      * new feature: watchlist view from project/bug/task modification page
 607        you can see all users who are watching that object
 608  December 28 2000
 609      * RELEASE 20001228
 610  December 21 2000
 611      * new brazilian portuguese translation. Thanks to Eri R. Bastos
 612        <erirb at sti.com.br>
 613  December 20 2000
 614      * new tutos[defaultacl] variable in config.pinc.
 615        This allows to select the access rights of some objects a creation
 616        time. Either everybody can see the new object or only members of the
 617        creators teams.
 618  December 19 2000
 619      * bugfix: wrong content-types for Chinese (thanks to chusj at yahoo.com)
 620        (Bug: #126278 at sourceforge)
 621  December 17 2000
 622      * bugfix: missing getShortname in team.pinc (called by product_overview)
 623      * bugfix: missing sprintf in task_new.php (Bugs: #124325 and #124893 at
 624        sourceforge)
 625  December 5 2000
 626      * extended feature selection. A superuser can set every single feature
 627        a user will use. i.e. You can have a user using only the calendar and
 628        notes while other users can use project and bug management in
 629        addition.
 630        File: user_new.php , config.pinc
 631  December 4 2000
 632      * bugfix: problem with calendar showing "all your teams"
 633  December 3 2000
 634      * new watchlist feature. A user can set projects, tasks and bugs on his
 635        personal watchlist and will be informed by mail whenever something
 636        changed.
 637  !! -->      This needs a new table "watchlist" (see scheme.sh)
 638      * new private appointments. Those entries are only visible to
 639        participants and will appear in a special color in the
 640        timetable/calendar sheet
 641      * better checking of user inputs. (duplicate names and bad dates)
 642        It is not longer possible to create a company, address, department,
 643        product with the same name as a already existing one.
 644      * bugfix: missing initialzed date in team.pinc (Supportticket: #109412
 645        at sourceforge)
 646  December 2 2000
 647      * renamed the php3 files to php. This will make live easier for those
 648        how have to maintain a additional PHP3 on their servers.
 649      * new Prototypes for mails (invitation, inivitation remember, bug new,
 650        bug modify)
 651        Look at html/....proto.[language]
 652        Every participant of an appointment or stakeholder in a bug will be
 653        informed in his/her preferred language (if available)
 654        This fixes also Supportticket: #110179 at sourceforge.
 655      * new bug timeout feature. If a bug stays in "OPEN" for too long the
 656        "assigned" user will be informed by email. You have to run check.php
 657        by crontab to do this (see below Oct 21)
 658  !! -->      new table bugremember (see scheme.sh)
 659  November 29 2000
 660      * RELEASE 20001129
 661  November 27 2000
 662      * new translations for russian (file php/ru.p3)
 663        Thanks to Alexandr Smirnov <smialex at ru.echo.fr>
 664      * bugfix sorting of projects by probability
 665        Thanks to Alexandr Smirnov <smialex at ru.echo.fr> for finding the bug
 666  November 26 2000
 667      * fixes problems with timezones (should work now with non postgres
 668        databases)
 669      * new companies can now have a location set
 670  November 25 2000
 671      * mail interface extended. You can now decide to send mail either via
 672        sendmail or direct via smtp. See config.pinc for configuration
 673  November 20 2000
 674      * new/updated translation for spanish
 675        Thanks to Luca Olivetti <luca at wetron.es>
 676  November 17 2000
 677      * new translations for simpliefied and tradional chinese
 678        Thanks to Keith Tsao <keith.tsao at vatgroup.net>
 679      * new fax send feature
 680        fax numbers will be clickable
 681        This supports faxmail and faxspool from the mgetty package and should
 682        be easily adoptable to other dax solutions (Please mail me !)
 683      * new SMS send feature
 684        We only give some links to SMS service sites. All sites I checked do
 685        not allow to automatically fill their forms. If someone knows a
 686        better solution please inform me !!
 687  November 15 2000
 688      * RELEASE 20001115
 689  November 14 2000
 690      * new: timetrack feature
 691        You can book time fractions on bugs and projects and will see the
 692        sum of all hours book to a project or bug
 693  November 12 2000
 694      * new: enabled Middle Initials in addresses
 695        Please run the following SQL command:
 696        update addresses set m_name = '' where m_name = null;
 697      * new: it is now possible to disable various parts of TUTOS
 698        i.e if you dont like the notes just edit config.pinc and
 699        change the $tutos[usenotes] to 0
 700  November 11 2000
 701      * new: bug statistics (on bug_overview select the statistics link)
 702      * bugfix: language was set twice in user.pinc Updates (Oracle does not
 703        like this) (thanks to Huy Nguyen)
 704  November 10 2000
 705      * bugfix: modifying bugs does not work because of problems with project
 706        roles
 707  November 7 2000
 708      * bugfix: deleting notes does not worked not correctly
 709  November 7 2000
 710      * some more check on delete links
 711  November 6 2000
 712      * RELEASE 20001106
 713  November 5 2000
 714      * some development on servlet version
 715  November 4 2000
 716      * added some more help files
 717      * documetation update
 718  October 28 2000
 719      * added a confirmation window (javascript) to most "delete_something"
 720        links
 721      * new projectroles table
 722        a "create table projectroles ...." is neccesary (see scheme.sh fori
 723        details)
 724        For Updating do something like:
 725        MYSQL:
 726        insert into projectroles (pro_id,adr_id,role_id) select id,manager,1 from products;
 727        insert into projectroles (pro_id,adr_id,role_id) select id,manager2,3 from products;
 728        insert into projectroles (pro_id,adr_id,role_id) select id,seller,4 from products;
 729        POSTGRES:
 730        insert into projectroles (pro_id,adr_id,role_id) (select id,manager,1 from products);
 731        insert into projectroles (pro_id,adr_id,role_id) (select id,manager2,3 from products);
 732        insert into projectroles (pro_id,adr_id,role_id) (select id,seller,4 from products);
 733  October 26 2000
 734      * bugfix product overview sorted by state instead of creation
 735  October 25 2000
 736      * bugfix added missing calendar_overview.php3 to Makefile and release
 737        packages
 738  October 21 2000
 739      * new remember mechanism. Calling check.php3 will sent remember emails
 740        for appointments that asked for that.
 741        Simply add something like:
 742        */5 * * * * /usr/bin/lynx -accept_all_cookies -dump http://[yourhost]/tutos/php/check.php3 > /dev/null
 743        to your crontab.
 744        or use wget instead of lynx
 745  October 20 2000
 746      * new history of changes for products
 747        all modifications to a product are stored in history table
 748        a "create table history ...." is neccesary (see scheme.sh for details)
 749        Files: php/history.pinc php/history_show.php3
 750  October 16 2000
 751      * RELEASE 20001016
 752  October 15 2000
 753      * new map support clicking on a city name will take you (via 1 more
 754        step) to a mapquest page with the city map
 755      * changed layout of note creation/modification
 756      * new createdb.sh handels ORACLE create/drop/dump/restore
 757  October 14 2000
 758      * new notes are displayed with small icons
 759      * new moved from png to gif for icons (missed transparent handling)
 760  October 8 2000
 761      * new bugs can now refer to installations of a product
 762  October 6 2000
 763      * bugfix: mark required fields in address insertion form
 764  October 4 2000
 765      * bugfix: product_overview sorting on pages > 1
 766      * bugfix: product_overview dispay of costs
 767      * bugfix: user.pinc save theme on creation time
 768      * bugfix: product.pinc save/read costs
 769      * bugfix: address_overview works now with multiple pages
 770      * bugfix: mailbox_overview display more than xx messages (missing
 771        navigation)
 772  October 3 2000
 773      * started french language support
 774        by babelfish translation, so please ignore all bad translations :-)
 775  October 2 2000
 776      * RELEASE 20001002
 777      * new The sequence of displayed fields for product overview is given
 778        by config.pinc
 779      * new cost field for products/projects
 780  October 1 2000
 781      * new documentation http://www.tutos.org/docs.html
 782        Files: homepage/docs.html homepage/source_php.html
 783        homepage/database.html homepage/source_java.html homepage/object.html
 784      * new handling of work volume that was done over the scheduled plan
 785      * new real start and end of tasks is now set
 786  September 29 2000
 787      * bugfix deleting products
 788  September 29 2000
 789      * new documentation files homepage/database.html homepage/docs.html
 790  September 25 2000
 791      * new createdb.sh script that allows creation/deletion/dump/restore of
 792        databases
 793      * bugfix when running scheme.sh (sequencers where not created)
 794        (in file shellfunc.sh) [Sam Tilders" <sam at jovianprojects.com>]
 795  September 24 2000
 796      * new extended permissions handling
 797        most objects allow to grant/revoke permissions to users/teams that
 798        are not initially connected (creator , manager etc) to it.
 799        Have a look at the small (permissions) link in the upper right of
 800        modification masks
 801        Files: acl_new.php3 acl_show.php3 acl.pinc acl_ins.php3
 802      * bugfix when running inittutos.sh (missed creator field)
 803        thanks to [Sam Tilders" <sam at jovianprojects.com>]
 804      * bugfix repeating appointments had troubles when inserting with enddate
 805  September 23 2000
 806      * new mailbox support for projects and produts
 807        TUTOS can handle a mailbox for projects.
 808        We need a new table "mailboxes" (see scheme.sh)
 809        Currently we store the clear password for the imap/pop3
 810        Account in that table !!!
 811        So I recommend to make a tutos only account without a login shell
 812        to host the mailbox(es). To differ between different
 813        products/projects you may use a .procmailrc for that account.
 814        i.e.
 815        ----------------------
 816        MAILDIR=$HOME/Mail
 817        :0
 818        * Cc:.*project1.*
 819        $MAILDIR/project
 820        :0
 821        * To:.*project1.*
 822        $MAILDIR/project
 823        ----------------------
 824        So all mail with project1 in To or Cc will appear in a mailbox-file
 825        that is accesible via TUTOS
 826        Files: mailbox_new.php3 mailbox_show.php3 mailbox.pinc
 827           mailbox_ins.php3 mailbox_del.php3
 828  September 21 2000
 829      * bugfix showing a task
 830  September 20 2000
 831      * bugfix inserting new bugs failed in last release. creation time was
 832        missing.
 833      * new triming username and password on login check
 834  September 19 2000
 835      * new extended search pages now remember their previuos settings
 836      * started a poorly translated spanish language file
 837      * new extended search with timeranges for bugs / and products
 838      * tested Zend Optimizer for php. It works ! see http://www.zend.com
 839  September 18 2000
 840      * changed TIMESTAMP(14) to DATETIME in MySQL (make things easier)
 841      * ORACLE tests looked fine
 842  September 17 2000
 843      * new file "mail.pinc" to handel all mail related things
 844      * mail notifications on bugs are sent to the Projects Manager the
 845        assigned bug solver and the good guy who inserted the bug.
 846      * mail sending could be disabled in config.pinc
 847        (I needed this on my demo side. Too many mails were sent
 848         to bill.gates@...)
 849      * extended search modes for products (state) and bugs (state and/or
 850        class) click on extended in the search pages
 851      * task overview links in "Team Detail" and "Address Detail" (for users)
 852        page.
 853  September 16 2000
 854      * some tuning on the MySQL and Oracle Interfaces
 855      * more translated strings
 856  September 15 2000
 857      * file handling offers access to older version in TUTOS versioning
 858        system
 859      * tutos[caltable] in config.pinc can make calendar display faster if
 860        set to 1 for less complex table handling
 861      * handling for appointment reoccurence
 862        You have to add some fields to the calendar table
 863          repeat int4 default 0
 864          r_arg  varchar(10)
 865          r_ignore  int4 default 0
 866      * repeating events are m,marked with an (R) in the calendar sheet
 867  September 14 2000
 868      * team_show, company_show, department_show and address_overview use
 869        the same function for address listing now.
 870  September 10 2000
 871      * More separation between PHP and SERVLET Version
 872      * TUTOS will appear in three different Versions all,php and java per
 873        release
 874  September 9 2000
 875      * Added theme mechanism. You can select a theme in the user modify
 876        dialog.
 877        Themes are css files lying around in [tutosdir]/html
 878        Currently availabe tutos.css (default) and blue.css (just an example)
 879      * Added a team_overview page, which is only available to superusers.
 880      * Started with Timezone support , so appointments will display times in
 881        the timezone of the current user. (Still not working !)
 882  September 8 2000
 883      * rebuild installation guide. install.html is now part of every release
 884  September 2 2000
 885      * after long stagnation played with JAVA part again
 886      * added projects and tasks to JAVA part
 887  September 1 2000
 888      * Make the example.sh running again (with MYSql now)
 889      * Cleaned up parameter Transfer between *_new.php3 and *_ins.php3 files
 890  August 31 2000
 891      * Make it run with MySQL  (still need testing)
 892      * Make it run with Oracle (still needs testing)
 893      * Installations Form has useful defaults now (derived from product)
 894      * Made new screenshots for homepage section
 895      * better transaction locking and errorhandling
 896  August 28 2000
 897      * Ups there was a bug in scheme.sh. table files was not created.
 898        I should to more testing
 899      * Inlucde this ChangeLog in distribution
 900      * Added php/.htaccess for security
 901  August 27 2000
 902      * Display in overviews is limited to $tutos[maxshow] rows
 903        and some navigation links are displayed to get the next/previous page
 904        You can change this in [tutoshome]/php/config.pinc . Nice to have
 905        this file :-)
 906      * added a global config file for all the things
 907        that are different for each installation
 908        have a look at [tutoshome]/php/config.pinc
 909  August 26 2000
 910      * file/document management works with RCS now
 911        three different versioning modes will be supported
 912        - NO versioning (old files are substituted)
 913        - TUTOS old files are simply copied away
 914        - RCS old files are stored in RCS
 915      * new table needed
 916        create table files ( ........ )   see scheme.sh for details
 917  August 25 2000
 918      * got a translation for italian for free
 919        see [tutoshome]/php/it.p3
 920        thanks to Luca Pescatore <l.pescatore at network.it>
 921  August 24 2000
 922      * announced TUTOS at freshmeat
 923  August 22 2000
 924      * started file document management support
 925        see [tutoshome]/php/file.pinc
 926  August 21 2000
 927      * added seller to products
 928        alter table products add (seller int4);
 929  August 20 2000
 930      * today was the beginning of the user-help system
 931        if help is available a help link automatically appears in the main
 932        link list on the left side
 933  August 19 2000
 934      * I realized that tutos now runs only with newer PHP
 935        php 4RC2 seems not to have the sscanf function we use in product_ins
 936        and installation_ins
 937      * Again more translated Strings (Error Messages).
 938  August 18 2000
 939      * new resource calendar res_cal.php3 which shows appointments and
 940        task (for team or address) combined in one page
 941      * more fields in products
 942        please add
 943        alter table products add (price float8);
 944        alter table products add (currency varchar(4));
 945      * better product sorting and display in products_overview.php3
 946  August 17 2000
 947      * sorting in bug_overview , address_overview , product_overview
 948  August 12 2000
 949      A lot of changes
 950      * Tasks are now fairly usable
 951      * TUTOS starts to work with Mysql
 952      * the example.sql uses all features
 953      * switched to PHP 4.0.1pl2 (cause of mysql)
 954      * some new javascript hacks to help in calendar selection (minical.php3)
 955      * in order to run with mysql in the future we need some renamings
 956        (dont ask me why):
 957        alter table calendar rename column starting to a_start;
 958        alter table calendar rename column ending to a_end;
 959      * new messsage of today feature
 960  August 9 2000
 961      Introduced tasks because a collegue ask for it.
 962      Updaters have to add a new table tasks. Please see scheme.sql
 963      for details. Products can contain tasks and tasks can contain tasks
 964      again. My goal is to make some kind of netplan and give some
 965      documentation for projects.
 966      Stay tuned !
 967  August 6 2000
 968      New ical/vCalendar and vCard support.
 969      Tutos can produce information for these technologys now.
 970      I'm looking for some usefull applications that need this feature :-)
 971  August 5 2000
 972      Added some caching for Objects. We don't reread objects from the
 973      DB if they are in cache.
 974      I don't like cookies. So I started to add a SESSIONKEY to all
 975      generated links (this needs some testing).
 976      Now we are are using persistent DB Connections.
 977      * Introduced the long prepared notes.
 978      * It is possible to force the language by adding a &lg=de or &lg=en
 979      to the url. Good feature to find leaks in the translation !
 980      * Again more translated Strings.
 981      * the notes tabe layout changed in the database ! You will have to
 982      generate a new notes table. Look in scheme.sql for details.
 983  August 2 2000
 984      Played with overlib (See http://www.bosrup.com/web/overlib/)
 985      Now if you have overlib.js in [tutoshome]/html
 986      we will you some nice features.
 987  August 1 2000
 988      Companies as Visitors are possible now
 989      Found some nasty behaviour when ' Characters are in Database
 990      Querys. AddSlashes and StripSlashes should help here.
 991      More Translated Strings
 992      Product Table got new fields
 993      * desc1       for free use
 994      * desc2       for free use
 995      * state       pre ongoing or finished
 996      * path        for some url (e.g. cvs web)
 997  July 29 2000
 998      Start ChangeLog
 999  
1000      Added product feature to calendar
1001      * links from appointments to products
1002  
1003      Added calendar link from addresses/users
1004      so it will be possible to see the calendar
1005      of a user. Up to now it was only possible
1006      to see calendars of your own or your teams
1007  -------------------------------------------------------------------
1008  Please send all your feedback to gokohnert at users.sourceforge.net