==============================================================================
TEAMCAL PRO UPGRADE INFO
==============================================================================

------------------------------------------------------------------------------
[3.2.004] -> [3.3.001]

Backup your current files and database!

Overwrite all files.

Edit config.tcpro.php.and adjust the section 'PERSONALIZATION' and 'DATABASE'
to what it was in your previous version of the file that you have backed up.

After login, open the admin config page first and save it once to add the new 
parameters for the default period.

------------------------------------------------------------------------------
[3.2.003] -> [3.2.004]

Backup your current files and database!

Overwrite all files.

Delete the folders help/english/HTMLHelp and help/english/eBook. These help
formats are not supported anymore and the menu will not have entries to these
files anymore.

Edit config.tcpro.php.and adjust the section 'PERSONALIZATION' and 'DATABASE'
to what it was in your previous version of the file that you have backed up.


------------------------------------------------------------------------------
[3.2.000, 3.2.001, 3.2.002] -> [3.2.003]

Backup your current files and database!

Overwrite all files except(!) config.tcpro.php.


------------------------------------------------------------------------------
[3.2.001] -> [3.2.002]

Backup your current files and database!

Overwrite:
includes/tcmonth.class.php
includes/showmonth.function.php


------------------------------------------------------------------------------
[3.2.000] -> [3.2.001]

Backup your current files and database!

Overwrite all .PHP files except(!) config.tcpro.php.


------------------------------------------------------------------------------
[3.1.006] -> [3.2.000]

Backup your current files and database!

Overwrite all files.
Copy config.default.php to config.tcpro.php.
Edit config.tcpro.php and change your individual settings (e.g. $CONF['app_url'], 
database settings) as they were in your backed up copy.

Change the database as follows:
 
CREATE TABLE `my_tc_regions` (
`regionname` VARCHAR( 40 ) NOT NULL ,
`description` VARCHAR( 100 ) NULL DEFAULT NULL ,
`options` SMALLINT( 6 ) DEFAULT '0'  ,
PRIMARY KEY ( `regionname` )
) TYPE = MYISAM ;

ALTER TABLE `my_tc_daynotes` ADD `region` VARCHAR( 40 ) NOT NULL DEFAULT 'default'; 
ALTER TABLE `my_tc_months` ADD `region` VARCHAR( 40 ) NOT NULL DEFAULT 'default';
ALTER TABLE `my_tc_groups` ADD `min_present` SMALLINT NOT NULL DEFAULT '1';
ALTER TABLE `my_tc_groups` ADD `max_absent` SMALLINT NOT NULL DEFAULT '1';


------------------------------------------------------------------------------
[3.1.005] -> [3.1.006]
No database change.
Overwrite all files (except your config.tcpro.php). 
*.php
includes/*.php


------------------------------------------------------------------------------
[3.1.003/4] -> [3.1.005]
No database change.
Overwrite all files 
*.php
includes/*.php


------------------------------------------------------------------------------
[3.1.002] -> [3.1.003]
Overwrite the following 3.1.001 files with those from the 3.1.002 package:
   about.php
   addprofile.php
   editcprofile.php
   groupassign.php
   showyear.php
   includes/js/tcpro.js
   includes/showmonth.function.php


------------------------------------------------------------------------------
[3.1.001] -> [3.1.002]
Overwrite the following 3.1.001 files with those from the 3.1.002 package:
   includes/showmonth.function.php
   editcalendar.php


------------------------------------------------------------------------------
[3.1.000] -> [3.1.001]
Overwrite the following 3.1.000 files with those from the 3.1.001 package:
   includes/avatar.inc.php
   includes/footer.html.inc.php
   includes/header.html.inc.php
   includes/menu.inc.php
   includes/other.inc.php

Add the following lines in your config.tcpro.php, at the end of the Absence
Type options:
$CONF['A_SHOWTOTAL']   = 0x000004;         // Flag: Include absence total in remainder section
$CONF['A_PRESENCE']    = 0x000008;         // Flag: This absence type counts as 'present'


------------------------------------------------------------------------------
[3.0.001] -> [3.1.000]
I recommend to create a new installation of TeamCal 3.0.000 since many files have
been changed or added (just copy the files to a new directory on your web server).
Also copy your old database using a different prefix.

The database needs to get the following changes:

DROP TABLE `my_tc_options`;
ALTER TABLE `my_tc_log` CHANGE `type` `type` VARCHAR( 40 ) NULL DEFAULT NULL;
ALTER TABLE `my_tc_users` CHANGE `last_login` `last_login` DATETIME NOT NULL;  
ALTER TABLE `my_tc_announcements` CHANGE `timestamp` `timestamp` DATETIME NOT NULL;  
ALTER TABLE `my_tc_user_announcement` CHANGE `ats` `ats` DATETIME NOT NULL;
ALTER TABLE `my_tc_log` CHANGE `timestamp` `timestamp` DATETIME NOT NULL;


------------------------------------------------------------------------------
[3.0.000] -> [3.0.001]
No database changes. You can leave your data as is.
Replace the following files after backing up your old ones:

config.default.php
editcalendar.php
editmonth.php
editprofile.php
index.php
installation.php (not if you have already installed)
showyear.php
includes/header.html.inc.php
includes/showmonth.function.php
includes/tcavatar.class.php
includes/tcusergroup.class.php
includes/version.inc.php

Edit your existing config.tcpro.php. 

Find this line:
$tc_config['ovl_tt_bgbackground'] = 'BGBACKGROUND, \''.$tc_config['app_url'].'themes/'.$theme.'/img/bg_tooltip.gif\', ';
Change it to:
$tc_config['ovl_tt_bgbackground'] = 'BGBACKGROUND, \''.$tc_config['app_url'].'/themes/'.$theme.'/img/bg_tooltip.gif\', ';

Find this line:
$tc_config['ovl_tt_capicon'] = 'CAPICON, \''.$tc_config['app_url'].'themes/'.$theme.'/img/ico_help.png\', ';
Change it to:
$tc_config['ovl_tt_capicon'] = 'CAPICON, \''.$tc_config['app_url'].'/themes/'.$theme.'/img/ico_tt.png\', ';


------------------------------------------------------------------------------
[2.9.004] -> [3.0.000]
I recommend to create a new installation of TeamCal 3.0.000 since many files have
been changed or added (just copy the files to a new directory on your web server).
Also copy your old database using a different prefix.

The database needs to get the following changes:

ALTER TABLE `my_tc_daynotes` CHANGE `daynote` `daynote` TEXT NULL DEFAULT NULL;

ALTER TABLE `my_tc_users` 
ADD `custom1` VARCHAR( 80 ) NOT NULL ,
ADD `custom2` VARCHAR( 80 ) NOT NULL ,
ADD `custom3` VARCHAR( 80 ) NOT NULL ,
ADD `custom4` VARCHAR( 80 ) NOT NULL ,
ADD `custom5` VARCHAR( 80 ) NOT NULL ,
ADD `customFree` TEXT NOT NULL ,
ADD `customPopup` TEXT NOT NULL ;

Now copy config.default.php to config.tcpro.php. Edit the new file and change
$tc_config['app_root'], $tc_config['app_url'] and your database and prefix info.


------------------------------------------------------------------------------
[2.9.003] -> [2.9.004]
I recommend to create a new installation of TeamCal 2.9.004 since many files have
been changed or added (just copy the files to a new directory on your web server).
Also copy your old database using a different prefix.

The database needs to get the following changes:

ALTER TABLE `my_tc_groups` ADD `options` SMALLINT( 6 ) DEFAULT '0' AFTER `description`;
ALTER TABLE `my_tc_holidays` ADD `options` SMALLINT( 6 ) DEFAULT '0' AFTER `dspbgcolor`;

Test your new installation with your data before you cut over for good.

------------------------------------------------------------------------------
[2.9.002] -> [2.9.003]
After the ad-hoc security patch for the remote file inclusion vulnerability
this release eliminates more potential leverages to compromise the application
code. It also displays a warning now on the TeamCal Configuration page so 
the administrator knows about the risk.
It is highly recommended to upgrade your installation to 2.9.003.

The following files were changed:

config.php
doc/releaseinfo.txt
doc/upgradeinfo.txt
includes/absencecount.inc.php
includes/avatar.inc.php
includes/footer.html.inc.php
includes/header.html.inc.php
includes/menu.inc.php
includes/version.inc.php
includes/lang/deutsch.tcpro.php
includes/lang/english.tcpro.php

Just overwrite the files.

------------------------------------------------------------------------------
[2.9.001] -> [2.9.002]
Ad-hoc security patch, the following files were changed/added:

config.tcpro.php
doc/releaseinfo.txt
doc/upgradeinfo.txt
includes/footer.html.inc.php
includes/header.html.inc.php
includes/version.inc.php

Just overwrite the files. However, you need to adjust config.tcpro.php with
your individual settings.

------------------------------------------------------------------------------
[2.8.001] -> [2.9.000]
I recommend to create a new installation of TeamCal 2.9 since many files have
been changed or added (just copy the files to a new directory on your web server).
Also copy your old database using a different prefix.

The database needs to get the following changes:

ALTER TABLE `my_tc_absence` ADD `iconfile` VARCHAR( 100 ) ;
ALTER TABLE `my_tc_users` ADD `idnumber` VARCHAR( 40 ) ;
ALTER TABLE `my_tc_users` ADD `last_login` TIMESTAMP ;
ALTER TABLE `my_tc_announcements` ADD `popup` BOOL DEFAULT '0';
ALTER TABLE `my_tc_announcements` ADD `silent` BOOL DEFAULT '1';

CREATE TABLE `my_tc_config` (
`id` INT NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 40 ) NOT NULL ,
`value` VARCHAR( 160 ) NOT NULL ,
PRIMARY KEY ( `id` ) ,
INDEX ( `name` )
) TYPE = MYISAM ;

CREATE TABLE `my_tc_absence_group` (
  `id` int(11) NOT NULL auto_increment,
  `absence` char(1) default NULL,
  `group` varchar(40) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM ;


------------------------------------------------------------------------------
[2.7.xxx] -> [2.8.000]

Changes to the database:
------------------------
I recommend to create a new installation of TeamCal 2.8 since many files have
been changed or added (just copy the files to a new directory on your web server).
Also copy your old database using a different prefix.
Change two tables:

ALTER TABLE `my_tc_users` ADD `title` VARCHAR( 80 ) NULL AFTER `lastname`;
ALTER TABLE `my_tc_users` ADD `mobile` VARCHAR( 50 ) NULL AFTER `phone`;
ALTER TABLE `my_tc_absence` ADD `options` SMALLINT( 6 ) DEFAULT '0' AFTER `factor`;

Test your new installation with your data before you cut over for good.

[2.6.xxx] -> [2.7.000]
Create a new installation of TeamCal 2.7 since nearly all files have been
changed or deleted (just copy the files to a new directory on your web server).
You can use you old database though except you need to add two more tables:

CREATE TABLE `my_tc_announcements` (
  `id` int(11) NOT NULL auto_increment,
  `timestamp` timestamp(14) NOT NULL,
  `text` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

CREATE TABLE `my_tc_user_announcement` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(40) NOT NULL default '',
  `ats` timestamp(14) NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

To be on the safe side copy your current database and rename the table prefix.
Then point the new TeamCal installation to the new database.


------------------------------------------------------------------------------
[2.6.xxx] -> [2.6.003]
Replace the following files:

addprofile.php
editcalendar.php
editprofile.php
log.php


------------------------------------------------------------------------------
-> [2.6]

Version 2.6 adds more new features and options.

You can keep your existing database but must apply the following changes
(make sure you change the table names according to your naming):

ALTER TABLE `my_tc_absence` ADD `factor` FLOAT DEFAULT '1' NOT NULL;

ALTER TABLE `my_tc_options` ADD `decline` INT( 11 ) DEFAULT '0' NOT NULL;
ALTER TABLE `my_tc_options` ADD `declinebefore` VARCHAR( 8 ) NOT NULL;
ALTER TABLE `my_tc_options` ADD `declinethreshold` TINYINT DEFAULT '0' NOT NULL;

ALTER TABLE `my_tc_user_group` CHANGE `type` `type` VARCHAR( 20 ) DEFAULT NULL;


Overwrite all files and make sure to reapply the setting in your config file.

Create a directory named "export" and give it write rights to the world.


------------------------------------------------------------------------------
-> [2.5]

Version 2.5 is a complete makeover with many new features and changes. It is 
recommended to reinstall the application.

You can keep your existing database and apply the following changes:

CREATE TABLE `my_tc_allowance` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(40) NOT NULL default '',
  `abssym` char(1) NOT NULL default '',
  `lastyear` smallint(6) NOT NULL default '0',
  `curryear` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

CREATE TABLE `my_tc_options` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(40) NOT NULL default '',
  `loglevel` int(11) default NULL,
  `logfilter` int(11) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) TYPE=MyISAM AUTO_INCREMENT=1;

CREATE TABLE `my_tc_user_group` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(40) default NULL,
  `groupname` varchar(40) default NULL,
  `type` tinytext,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

CREATE TABLE `my_tc_user_options` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(40) default NULL,
  `option` varchar(40) default NULL,
  `value` varchar(40) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

ALTER TABLE `my_tc_users` ADD `birthday` DATE DEFAULT NULL;
ALTER TABLE `my_tc_absence` ADD `allowance` smallint(6) NOT NULL DEFAULT '0';

Then recreate the log table (which hasn't been used so far):
DROP TABLE IF EXISTS `my_tc_log`;
CREATE TABLE `my_tc_log` (
  `id` int(11) NOT NULL auto_increment,
  `type` int(11) default NULL,
  `timestamp` timestamp(14) NOT NULL,
  `user` varchar(40) default NULL,
  `event` text,
  PRIMARY KEY  (`id`),
  KEY `idx_occured` (`timestamp`)
) TYPE=MyISAM AUTO_INCREMENT=1;


All source files have been changed. 
The directory structure has been changed.
Three Javascript applications have been added.


------------------------------------------------------------------------------
[2.4.xxx] -> [2.4.005]

No change in the database has been made but new settings have been added to 
config.tcpro.php. Before you overwrite all files make sure you have adjusted
config.tcpro.php to your needs.


------------------------------------------------------------------------------
[2.3] -> [2.4]

If you are using TeamCal Pro 2.3 you can procede using your current database.
But you need to add one field to the tc_daynote table. You can do so using
phpMyAdmin and adding a varchar(40) field named 'username' at the end of the
table and set the default value to 'all'. The structure will then look like:

CREATE TABLE `my_tc_daynotes` (
  `id` int(11) NOT NULL auto_increment,
  `yyyymmdd` varchar(8) NOT NULL default '',
  `daynote` varchar(80) NOT NULL default '',
  `username` varchar(40) NOT NULL default 'all',
  PRIMARY KEY  (`id`),
  KEY `yyyymmdd` (`yyyymmdd`)
) TYPE=MyISAM AUTO_INCREMENT=1;


Backup your personalizations (e.g. config and header), overwrite your files
with the 2.4 files and adjust your personal settings. Done.

If you want to use TeamCal Pro 2.4 from within Mambo 4.5.1 read the 
mambojack.txt file.


------------------------------------------------------------------------------
[2.2] -> [2.3]

If you are using TeamCal Pro 2.2 you can procede using your current database.

Backup your personalizations (e.g. config and header), overwrite your files
with the 2.3 files and adjust your personal settings. Done.

If you want to use TeamCal Pro 2.3 from within Mambo 4.5.1 read the 
mambojack.txt file.


------------------------------------------------------------------------------
[2.0] [2.1] -> [2.2]

If you are using TeamCal Pro 2.0 or 2.1 you can procede using your current
database. However, you need to add one table. In any case I recommend to make
a full backup before you start.

There is a new table in the database called 'my_tc_daynotes'. You need to 
access you database with your MySQL client and execute the following SQL 
statement (If you have chosen a different tabel prefix in config.tcpro.php 
make sure you rename the table accordingly.):

CREATE TABLE `my_tc_daynotes` (
  `id` int(11) NOT NULL auto_increment,
  `yyyymmdd` varchar(8) NOT NULL default '',
  `daynote` varchar(80) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `yyyymmdd` (`yyyymmdd`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

Backup your personalizations (e.g. config and header), overwrite your files
with the 2.3 files and adjust your personal settings. Done.

If you want to use TeamCal Pro 2.3 from within Mambo 4.5.1 read the 
mambojack.txt file.

------------------------------------------------------------------------------

[Support]

I will try to provide support for TeamCal Pro as far as my time allows. 
Please don't be mad if I can't answer right away. I'll try my best.

==============================================================================
George Lewe, george@lewe.com 
December 2004
==============================================================================