!!!!!!!!!!!!!!!!
If you're updating from an earlier version than 1.35 you may have to run the update_..._to_....php in the 
correct order to bring the database to the actual state
!!!!!!!!!!!!!!!!

You could upload all files into a new directory (e.g. spm20) 
rename or delete setup.php edit database and directory information in conf.php
and everything should working fine.

OR follow these update instructions to update from 1.52 to 2.01

make sure to backup all of your files and your database before updating/replacing

replace conf.php and edit or (now just for version checkings)

#
# ---- [ OPEN ] --------------- 
#
conf.php
#
# ---- [ FIND LINE BEGINNING WITH ] ---------------
#
$version = "1.5
#
# ---- [ REPLACE LINE WITH ] ---------------
#
$version = "2.01";
#
# ---- [ SAVE AND CLOSE ] ---------------


+++++++++++++++++
+ Please replace the following files:
+++++++++++++++++

customers.php
functions.js
functions.php
profile.php
projects.php
styles.css
todos.php
users.php

includes/customers_actions.php
includes/footer.php
includes/header.php
includes/profile_actions.php
includes/projects_actions_01.php
includes/projects_actions_02.php
includes/todos_actions.php
includes/users_actions.php


++++
+ Language changes - new entries can be found at the bottom of each file marked with //new since 2.0
+ new Netherland entries are still in english - would be nice to get updated NL-Versions :)
++++

lang/de/common.lang.php
lang/de/projects.lang.php
lang/de/users.lang.php

lang/en/common.lang.php
lang/en/projects.lang.php
lang/en/users.lang.php

lang/nl/common.lang.php
lang/nl/projects.lang.php
lang/nl/users.lang.php


++++
+ Upload new language files
+ NL is still in english :)
++++

lang/de/knowledgebase.lang.php
lang/en/knowledgebase.lang.php
lang/nl/knowledgebase.lang.php


+++++++++++++++++
+ Upload the following new files and folders:
+++++++++++++++++

jwysiwyg/

jquery.countdown.min.js
knowledgebase.php
serverTime.php
timer.css
timer.php

includes/knowledgebase_actions.php
includes/projects_actions_03_header.php

images/spmtimer_bg.png

images/icons/lightbulb.png
images/icons/lightbulb_off.png
images/icons/winopen.png
images/icons/winopen2.png



To upgrade your database you can upload update_1.52_2.0.php to your server (spm directory) and point your browser to this file

OR:

SQL Updates (take care of the prefix, add it if missing)

CREATE TABLE `knowledgebase` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`uid` INT NOT NULL ,
`custid` INT NULL ,
`pid` INT NULL ,
`title` VARCHAR( 200 ) NOT NULL ,
`comment` TEXT NOT NULL ,
`keywords` VARCHAR( 255 ) NULL ,
`status` TINYINT NOT NULL DEFAULT '1',
`created` DATETIME NOT NULL ,
`created_by` VARCHAR( 20 ) NOT NULL ,
`edited` DATETIME NULL ,
`edited_by` VARCHAR( 20 ) NULL
)

ALTER TABLE `users` ADD `acl_kb_edit` TINYINT NOT NULL DEFAULT '0' AFTER `acl_pf_admin` ,
ADD `acl_kb_add` TINYINT NOT NULL DEFAULT '0' AFTER `acl_kb_edit` ,
ADD `acl_kb_admin` TINYINT NOT NULL DEFAULT '0' AFTER `acl_kb_add` ;

ALTER TABLE `project_times` ADD `cat` VARCHAR( 50 ) NULL AFTER `milestone` ;