iPath Telemedicine Platform

File Release Notes and Changelog

Release Name: 2.1

Notes:
iPath-Server
------------

more information about iPath can be found on the website
http://ipath.sourceforge.net/

look under documentation -> manual -> admin and installation manual for details



mailing list
------------
for further discussion on details of the iPath development, 
please subscribe to our developers mailing list 
<ipath-developers@lists.sourceforge.net>. 

more information and subscription is on:
https://lists.sourceforge.net/lists/listinfo/ipath-developers



for any questions: brauchlik@users.sourceforge.net

Changes:
iPath-2 changelog
-----------------


version 2.1.0
-------------
Start of a new development cycle.

***ATTENTION***
the db installation file "install/database.mysql" contains 
the new database layout which is not (yet) 100% compatible 
with the old data structure. DO NOT upgrade a 2.0 database 
to version 2.1 yet!!!!


* Change code to MVC. The first module to make use
  of this is the community module.
  new files:
  - include/template.inc.php 
  - include/abstractRecord.inc.php
  - include/abstractController.inc.php
  - include/validators.inc.php
  
  In order to keep compatibility with the old *.functions.php
  file, there is a config values to give old function precedence.
  only if you set $ipath->conf['newviews']=true then the
  new controller driven views are used (unless no old view
  exists - like e.g. the community or referral modules)

* integration of jquery javascript library as
  integral part of iPath.

* inroducing a community level.
  Communities are containers for many groups. Every
  community has an administrator and can have many
  members and many groups. Groups as well as users can 
  be member of several communities.
  table update for community support (see bottom):

* virtual portals are now handled not only through URL
  but also in a special database table. communities can 
  be linked to certain portals

* a new referral module handles case referrals
  it provides a way for other modules to publish
  referral types.
  it includes itself an "email referral" type that 
  will submit a case by email to any email address.

* a new distance presentation module

* a new dashboard module

* new referral module - the part to refer an object 
  has been remove from virin and is now separate.
  objects can also be referred to a user (or a group)
  these are stored in the object_referral table
  however, this is only a temporary solution.

* rework of the chat module
  - there is a new element of a chat_session
  - every chat message (in the chat table) is 
    linked to a chat_session
  - in turn, a chat_session can be linked to 
    - objects
    - presentations
    - groups
    - webmeeting


data base changes for version 2.1.0:

create table community (
  id int unsigned auto_increment primary key,
  name varchar(127),
  description text,
  created_by int,
  created_on datetime,
  modified_by int,
  modified_on datetime,
  status int
);
create table community_group (
  community_id int,
  group_id int,
  link_status tinyint,
  created_by int,
  created_on datetime
); 
create table community_member (
  community_id int,
  user_id int,
  status int,
  admin tinyint,
  created_by int,
  created_on datetime
);



--
-- Table structure for table `presentation`
--

DROP TABLE IF EXISTS `presentation`;
CREATE TABLE `presentation` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `created_by` int(11) default NULL,
  `created_on` datetime default NULL,
  `access` tinyint(4) default NULL,
  `pointerenabled` tinyint(4) default NULL,
  `pointershared` tinyint(4) default NULL,
  `startdate` datetime default NULL,
  `object_id` int(11) default NULL,
  `streamtype` varchar(12) default NULL,
  `streamurl` varchar(255) default NULL,
  `status` int(11) default '0',
  `title` varchar(255) default NULL,
  `description` tinytext,
  `cachestat` int(11) default '0',
  `objects` text,
  `cachedir` varchar(32) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=83 DEFAULT CHARSET=latin1;

--
-- Table structure for table `presentation_chat`
--

DROP TABLE IF EXISTS `presentation_chat`;
CREATE TABLE `presentation_chat` (
  `presentation_id` int(11) default NULL,
  `chat_id` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `presentation_pointer`
--

DROP TABLE IF EXISTS `presentation_pointer`;
CREATE TABLE `presentation_pointer` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `presentation_id` int(11) default NULL,
  `slide_nr` int(11) default NULL,
  `x` int(11) default NULL,
  `y` int(11) default NULL,
  `set_on` datetime default NULL,
  `set_by` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `presentation_slide`
--

DROP TABLE IF EXISTS `presentation_slide`;
CREATE TABLE `presentation_slide` (
  `nr` int(11) default NULL,
  `presentation_id` int(11) default NULL,
  `slide_nr` int(11) default NULL,
  `display_on` datetime default NULL,
  `display_by` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE `object_referral` (
  `id` int(11) NOT NULL auto_increment,
  `object_id` int(11) default NULL,
  `group_id` int(11) default NULL,
  `user_id` int(11) default NULL,
  `external_referral_id` int(11) default NULL,
  `type` varchar(32) default NULL,
  `message` tinytext,
  `created_by` int(11) default NULL,
  `changed_by` int(11) default NULL,
  `created_on` datetime default NULL,
  `changed_on` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;






version 2.0.4
-------------
- support for vocabulary (standardised keywords)
DROP TABLE IF EXISTS `objects_term`;
CREATE TABLE `objects_term` (
  `term_id` int(11) default NULL,
  `object_id` int(11) default NULL,
  `vocabulary_id` int(11) default NULL
) ENGINE=MyISAM;


DROP TABLE IF EXISTS `vocabulary_groups`;
CREATE TABLE `vocabulary_groups` (
  `vocabulary_id` int(11) default NULL,
  `group_id` int(11) default NULL,
  `required` tinyint(4) default NULL
) ENGINE=MyISAM;


DROP TABLE IF EXISTS `vocabulary_term`;
CREATE TABLE `vocabulary_term` (
  `id` int(11) NOT NULL auto_increment,
  `term` varchar(127) default NULL,
  `description` varchar(255) default NULL,
  `parent_id` int(11) default NULL,
  `weight` int(11) default NULL,
  `fkey` varchar(31) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;






version 2.0.3
-------------

* form module: allow multiple select for checkboxes. The input field name must be 
  and array, for example "ingredients[]" ... it must include the [] so that php
  will recongise it as array.


version 2.0.2
-------------

* remote slideshow: now records all images into db
  update database:
  create table remote_slideshow_object (show_id int, user_id int, object_id int, slide_nr int, entered datetime);

* forms: new status field in table forms
  > alter table forms add status int;

  support form form template for comments.



version 2.0
-----------
final release of iPath-2

* some bugfixes for remote presentations. 

* fixing missing tables in DB for virin module. check the install/database.mysql file
  you must create these tables:

CREATE TABLE `virin_duty` (
  `dutyplan_id` int(11) default NULL,
  `user_id` int(11) default NULL,
  `start` datetime default NULL,
  `end` datetime default NULL,
  `entered_by` int(11) default NULL,
  `function` int(11) default NULL,
  `id` int(11) default NULL
) TYPE=MyISAM;

CREATE TABLE `virin_dutyplan` (
  `id` int(11) default NULL,
  `name` text,
  `group_id` int(11) default NULL
) TYPE=MyISAM;

CREATE TABLE `virin_dutyplan_for_group` (
  `dutyplan_id` int(11) default NULL,
  `group_id` int(11) default NULL
) TYPE=MyISAM;  

  (ATTENTION: database.pgsql file is out of date - will be fixed later)




version 2.0rc6
--------------
* object navigation:
  fixing some onconsistencies. after a search or on the "cases to review" list
  the browsing (< | up | >) is now following the list (search result, review).
  only the "list" icon on the toolbar is linking to the actual case list 
  of the specific group.

* news module: news module are now also behaving like properl objects
  they can be added to folders and edited again.
  the baseurl trick to tie news to a certain virtual portal 
  is now handling http and https synonymously!

* virin module: adding a block and a "my cases for review" list

* complety rework of the xmlrpc module
  - now there is only one "server" for all functions
    modules/xmlrpc/server.php
  - specific functions are moved into separate modules
    these modules contain a file "modulename.xmlrpc.php"
    and the main server will include all these files
    the published functions are to be placed into the 
    $ipath->XMLRPC_functions array

* Integration of FCKeditor as rich text editor
  - customized file browser
  - to use it, create the following tree in your data_dir
    FCKfiles
    FCKfile/Image
    (must be writable to web server)
  - FCKeditor itself is in an optional module named fckeditor
    you can download it from the modules section on 
    http://sourceforge.net/projects/ipath

* group specific modules:
  - new table:
    create table group_modules (group_id int, module varchar(255), enabled int); 




version 2.0rc5
--------------
* overhauled remote slideshow:
  - introcution of "cached slideshow" for large audiences:
    only images are supported and are prepared into an image cache
    so that image change is possible without database access. this
    greatly improves performance for large audiences.
  - links are now supported
  - configurable access to pointer for clients
  - context menu and image toolbar in MSIE switched off
  - new fields in database tabel remote_slideshow:
    mysql> alter table remote_slideshow add start_id int;
    mysql> alter table remote_slideshow add options int;
    mysql> alter table remote_slideshow add slide_nr int;
  - man frame is now update through the javascript in ajax.js
    this prevents ugly gap in MSIE
* variable thumbnail size. the size of thumbnail images (preview)
  is now defined by the system variable $ipath->conf['thumb_size'].
  set this variable in sites/default.inc.php or your site 
  specific settings (or in admin/system settings)
* bugs in group_view (crosses and eyes) fixed
* bugs with postgres fixed
* audiostream in distance presentations. you must
  add a field audio_stream_url to the database:
  > alter table remote_slideshow add audio_stream_url varchar(200)
* image cache and preloading for slide shows
* hxp-server (xmlrpc module) allows "login" with a
  combination of user_id and session_id - sent as 
  header['usr'/'session'] - this is used by the image drop module


version 2.0rc4
--------------
* fixing the alert_queue. The system setting "queue_events"  
  will tell ipath to place events in the queue instead of
  processing immediately. alerts must then be dispatched
  by a cronjob
  calling http://.../ipath/admin/processalerts
  (you need to create the alert_queue table in the database. 
   c.f. install/database.mysql file)
* fixing support for Postgres (tested with version 8)
* fixing support for MySQL 3.x
* fixing langsel for servers with clean_url turned off.
* enabling use of adodb session management,
  e.g. crypto session



Version 2.0rc3
--------------
* "scrambled" email addresses 
* the textslide module is now in the base distribution
  as the emailimport module depends on textslide.
* form module: support for select menus and improved handling
* every group can define "default values" for objects
* objects can tell the system if they have default values
  (e.g. form cannot as they first need a template)
* some details in the permission scheme are fixed
* HTMLArea support is now in a separate module.
* country select list for user/registration
* new group option - moderator can change owner
  (in iPath-1 this was always true - now default is false)



Version 2.0rc2
--------------
* changin the default links from ?q=.. to index.php?q=.. so 
  that IIS can handle it without problems
* changing images to binary type in CVS (windows compatibility)
* fixing a problem with the 2MB limit of readfile in php5
  a helper function readfile_chunked is in include/common.inc.php
* installer checks permissions on data, tmp and data/tmp
* virin: add dutyplan (roster)
* introducing an object xml cache.
* group lists: fixing bug with display of marks (crosses/eyes)
  on group list page. first we calculate total of cases with 
  comments and then subtract those that user has visited after
  the comment was added.
* fixing progress Window for clean_url=1
* simpleEmail: will now also include a plain/text in html 
  emails
* link/object: updated the permission scheme for linked objects:
  - first, write the linking object's id into $ipath->link_id
    on object->getPerm() check if this is accessed through a link
  - if no other permission is valid, create a link_table (cache in $ipath) 
    and check if this->toParent is linked and then also 
    check the linking objects permission.
* emailimport: added a delete botton for unwanted emails


Version 2.0rc1 
--------------
* initial release. everything is new!