>> Igloo

  Copyright (c) 2003-2006 Barnraiser. All rights reserved.

>> This file lists database, template and language file changes and will allow you to upgrade rather 
   than reinstall.
   
   Most installations do not customise either their templates or their language files. If you have not 
   then simply backup, copy all the files in this installation into your required destination and 
   perform run the database queries below. If you have customised your templates and language files 
   then read the template and language file sections below.
   
   Please note: you will need to replace your config files for this upgrade.
   
   ** ALWAYS PERFORM A FULL FILE AND DATABASE BACKUP BEFORE UPGRADING **
   
   
>> from version 0.1.7 to 0.1.8
   LANGUAGE
   arrays/arr_links.php - remove
   blg_view.lang.php insert $lang['nav_breadcrumb'] = "wiki";
   chl_view.lang.php insert $lang['nav_breadcrumb'] = "channels";
   frm_view.lang.php insert $lang['nav_breadcrumb'] = "discussions";
   lib_view.lang.php insert $lang['nav_breadcrumb'] = "discussions";
   my_publishing.lang.php insert $lang['nav_breadcrumb'] = "publishing";
   my_tags.lang.php insert $lang['nav_breadcrumb'] = "tags";
   my_view.lang.php insert $lang['nav_breadcrumb'] = "my overview";
   pol_view.lang.php insert $lang['nav_breadcrumb'] = "poll";
   sch_view.lang.php insert $lang['nav_breadcrumb'] = "schedule";
   search.lang.php insert $lang['nav_breadcrumb'] = "search";
   sn_list.lang.php insert $lang['nav_breadcrumb'] = "network";
   sn_profile.lang.php insert $lang['nav_breadcrumb'] = "profile";
   blg_edit.lang.php - replace $lang['hdr_blog'] with $lang['hdr_blog_edit']
   blg_edit.lang.php - replace $lang['hdr_blog'] with $lang['hdr_blog_edit']
   frm_edit.lang.php - replace $lang['hdr_subject'] with $lang['hdr_subject_edit']
   lib_edit.lang.php - replace $lang['hdr_library'] with $lang['hdr_library_edit']
   pol_edit.lang.php - replace $lang['hdr_poll'] with $lang['hdr_poll_edit']
   sch_edit.lang.php - replace $lang['hdr_schedule'] with $lang['hdr_schedule_edit']
   sch_edit_task.lang.php - replace $lang['hdr_schedule'] with $lang['hdr_schedule_edit']
   nlt_digest_send.lang.php - rename $lang['txt_subject'] to $lang['txt_email_subject']
   
   node_user.lang.php - insert $lang['txt_col_user_id'] = "id";
   node_user.lang.php - insert $lang['txt_col_firstname'] =	"first";
   node_user.lang.php - insert $lang['txt_col_surname'] =	"surname";
   node_user.lang.php - insert $lang['txt_col_hometown'] =	"hometown";
   node_user.lang.php - insert $lang['txt_col_create_datetime'] = "joined";
   node_user.lang.php - insert $lang['txt_col_language'] = "language";
   node_user.lang.php - insert $lang['txt_col_status'] = "status";
   node_user.lang.php - insert $lang['txt_col_role'] =	"role";
   spl_view.lang.php - insert $lang['form_user_homepage'] = "don't show this page again";
   
   replace entire /texts directory (or look for SYS_KEYWORD replacements)
   
   TEMPLATE
   blg_edit.tpl.php - replace line 49
   frm_edit.tpl.php - replace line 225
   frm_edit.tpl.php - replace line 42
   pol_edit.tpl.php - replace line 38
   sch_edit.tpl.php - replace line 180
   node_register_user.tpl.php - replace line 142
   
   
   
>> from version 0.1.6 to 0.1.7
   TEMPLATE
   sch_view.tpl.php - replace line 889
   
   
>> from version 0.1.5 to 0.1.6
   DATABASE ------------------------------------------------------------------
   ALTER TABLE `igloo_comment` ADD `item_user_id` INT( 11 ) ;
   ALTER TABLE `igloo_bookmark` ADD `bookmark_notify` INT( 1 ) ;
   ALTER TABLE `igloo_bookmark` ADD `bookmark_batch_request` INT( 1 ) ;
   ALTER TABLE `igloo_rsp` ADD `rsp_featured` INT( 1 ) AFTER `rsp_sticky` ;
   
   SQL ------------------------------------------------------------------
   A major change has been implemented to the publishing. If you are using 
   this software then you will need to perform the following SQL queries to 
   update the publishing tables:
   
   DELETE FROM igloo_rsp where level_id=32;
   UPDATE igloo_rsp set level_id=32 where level_id=64;
   
   If you would like the latest group information to appear on the group 
   featured page then:
   
   UPDATE igloo_rsp set rsp_featured=1 where level_id=16 AND degree_id is null;
   
   If you would like the latest public information to appear on the public 
   featured page then:
   
   UPDATE igloo_rsp set rsp_featured=1 where level_id=32;
   
   
   LANGUAGE ------------------------------------------------------------------
   man/wiki_formatting man - replace
   arrays/arr_error.lang.php - insert lines 76 and 77
   spl_view.lang.php - insert $lang['hdr_start'] = "getting started";
   common.lang.php - insert $lang['txt_featured'] = "featured";
   common.lang.php - insert $lang['menu_overview'] = "overview";
   common.lang.php - insert $lang['href_edit'] = "edit";
   common.lang.php - insert $lang['href_watch_this_notify'] = "mark &amp; track";
   common.lang.php - insert $lang['txt_item_options'] =	"item options";
   frm_view.lang.php - insert $lang['href_network_subject'] = "view their discussions";
   frm_view.lang.php - insert $lang['href_view_node'] = "latest from the group";
   frm_view.lang.php - insert $lang['href_view_network'] = "latest from my network";
   frm_view.lang.php - insert $lang['href_my_subjects'] = "my discussions";
   frm_view.lang.php - insert $lang['href_marked'] = "marked subjects";
   frm_view.lang.php - insert $lang['href_list_subjects'] = "list discussions";
   frm_view.lang.php - insert $lang['href_add_subject'] = "add a discussion to this group";
   frm_view.lang.php - insert $lang['href_add_topic'] = "add a topic to this group";
   frm_view.lang.php - insert $lang['href_edit_topics'] = "manage topics";
   frm_view.lang.php - insert $lang['href_add_subject_topic'] = "add a dicussion under this topic";
   frm_view.lang.php - insert $lang['err_no_add_subject'] = "sorry, you are not allowed to add a discussion to this topic.";
   frm_view.lang.php - insert $lang['txt_options'] = "options";
   frm_view.lang.php - insert $lang['txt_view'] = "view";
   frm_view.lang.php - insert $lang['txt_intro_node'] = "Listed are the last MAXLISTNUMBER (max) discussions that have been published by a member of this group.";
   frm_view.lang.php - insert $lang['txt_intro_network'] = "Listed are the last MAXLISTNUMBER (max) discussions that have been published by a person in your network.";
   frm_view.lang.php - insert $lang['txt_outro_network'] = "The following people in your network have not published a discussion within the last MAXLISTNUMBER.";
   frm_view.lang.php - insert $lang['txt_intro_latest'] = "These are the latest discussions for the group. If you want to add a discussion click on a topic first.";
   blg_view.lang.php - insert $lang['hdr_my_network_blogs'] = "latest blog entries from my network";
   blg_view.lang.php - insert $lang['hdr_options'] ="blog options";
   blg_view.lang.php - insert $lang['hdr_blog_author'] = "author";
   blg_view.lang.php - insert $lang['href_network_blog'] = "view their blog";
   blg_view.lang.php - insert $lang['href_view_node'] = "latest from the group";
   blg_view.lang.php - insert $lang['href_view_network'] = "latest from my network";
   blg_view.lang.php - insert $lang['href_my_blog'] = "my blog";
   blg_view.lang.php - insert $lang['href_marked'] = "marked blog entries";
   blg_view.lang.php - insert $lang['href_list_blog'] = "list entries for this blog";
   blg_view.lang.php - insert $lang['href_add_blog'] = "add a blog entry to my blog";
   blg_view.lang.php - insert $lang['txt_options'] = "options";
   blg_view.lang.php - insert $lang['txt_view'] = "view";
   blg_view.lang.php - insert $lang['txt_intro_node'] = "Listed are the last MAXLISTNUMBER (max) blog entries that have been published by a member of this group.";
   blg_view.lang.php - insert $lang['txt_intro_network'] = "Listed are the last MAXLISTNUMBER (max) blog entries that have been published by a person in your network.";
   blg_view.lang.php - insert $lang['txt_outro_network'] = "The following people in your network have not published a blog entry within the last MAXLISTNUMBER.";
   lib_view.lang.php - insert $lang['href_view_firstpage'] = "first page";
   lib_view.lang.php - insert $lang['href_view_contents'] = "contents";
   lib_view.lang.php - insert $lang['href_my_library'] = "my wiki pages";
   lib_view.lang.php - insert $lang['href_marked'] = "marked wiki pages";
   lib_view.lang.php - insert $lang['txt_view'] = "view";
   lib_view.lang.php - insert $lang['txt_options'] = "options";
   lib_view.lang.php - insert $lang['txt_intro_contents'] = "Listed are the wiki pages that have been published by members of this community.";
   lib_view.lang.php - insert $lang['txt_intro_history'] = "Listed is the history of this wiki page.";
   pol_view.lang.php - insert $lang['hdr_my_network_polls'] = "latest polls from my network";
   pol_view.lang.php - insert $lang['hdr_poll_author'] = "author";
   pol_view.lang.php - insert $lang['href_network_poll'] = "view their polls";
   pol_view.lang.php - insert $lang['href_view_node'] = "latest from the group";
   pol_view.lang.php - insert $lang['href_view_network'] = "latest from my network";
   pol_view.lang.php - insert $lang['href_my_polls'] = "my polls";
   pol_view.lang.php - insert $lang['href_marked'] = "marked polls";
   pol_view.lang.php - insert $lang['href_add_poll'] = "add a poll to my polls";
   pol_view.lang.php - insert $lang['href_voted'] = "polls i've voted in";
   pol_view.lang.php - insert $lang['href_list_polls'] = "list polls for this author";
   pol_view.lang.php - insert $lang['txt_tag'] = "tags";
   pol_view.lang.php - insert $lang['txt_options'] = "options";
   pol_view.lang.php - insert $lang['txt_view'] = "view";
   pol_view.lang.php - insert $lang['txt_group_link'] = "This poll is from the group";
   pol_view.lang.php - insert $lang['txt_intro_group'] = "Listed are the last MAXLISTNUMBER (max) polls that have been published by the groups that you are a member of.";
   pol_view.lang.php - insert $lang['txt_intro_node'] = "Listed are the last MAXLISTNUMBER (max) polls that have been published by a member of this community.";
   pol_view.lang.php - insert $lang['txt_intro_network'] = "Listed are the last MAXLISTNUMBER (max) polls that have been published by a person in your network.";
   pol_view.lang.php - insert $lang['txt_outro_group'] = "The following groups have not published a polls within the last MAXLISTNUMBER.";
   pol_view.lang.php - insert $lang['txt_outro_network'] = "The following people in your network have not published a poll within the last MAXLISTNUMBER.";
   pol_view.lang.php - insert $lang['txt_intro_voted'] = "The following polls are polls that have received your vote.";
   sch_view.lang.php - insert $lang['hdr_my_network_schedule_items'] = 	"latest schedule items from my network";
   sch_view.lang.php - insert $lang['hdr_options'] ="schedule options";
   sch_view.lang.php - insert $lang['hdr_schedule_item_author'] = "author";
   sch_view.lang.php - insert $lang['hdr_allocation'] = "allocation";
   sch_view.lang.php - insert $lang['hdr_detail'] = "details";
   sch_view.lang.php - insert $lang['hdr_attendance'] = "attendance";
   sch_view.lang.php - insert $lang['href_network_schedule'] = "view their schedule";
   sch_view.lang.php - insert $lang['href_view_node'] = "latest from the group";
   sch_view.lang.php - insert $lang['href_view_network'] = "latest from my network";
   sch_view.lang.php - insert $lang['href_my_schedule'] = "my schedule";
   sch_view.lang.php - insert $lang['href_marked'] = "marked schedule items";
   sch_view.lang.php - insert $lang['href_add_event'] = "add an event to my schedule";
   sch_view.lang.php - insert $lang['href_add_task'] = "add a task to my schedule";
   sch_view.lang.php - insert $lang['href_allocation'] = "allocation";
   sch_view.lang.php - insert $lang['txt_event_allocation_intro'] = "You can attend this event. You can withdraw from an event at any time.";
   sch_view.lang.php - insert $lang['txt_tag'] = "tags";
   sch_view.lang.php - insert $lang['txt_options'] = "options";
   sch_view.lang.php - insert $lang['txt_view'] = "view";
   sch_view.lang.php - insert $lang['txt_intro_node'] = "Listed are the last MAXLISTNUMBER (max) schedule items that have been published by a member of this community.";
   sch_view.lang.php - insert $lang['txt_intro_network'] = "Listed are the last MAXLISTNUMBER (max) schedule items that have been published by a person in your network.";
   sch_view.lang.php - insert $lang['txt_outro_network'] = "The following people in your network have not published a schedule item within the last MAXLISTNUMBER.";
   msg_view.lang.php - insert $lang['hdr_messages'] = "messages";
   msg_view.lang.php - insert $lang['hdr_in_box'] = "inbox";
   msg_view.lang.php - insert $lang['hdr_message'] = "message";
   msg_view.lang.php - insert $lang['hdr_message_statistics'] = "message statistics";
   msg_view.lang.php - insert $lang['hdr_out_box'] = "outbox";
   msg_view.lang.php - insert $lang['hdr_save_box'] = "savebox";
   msg_view.lang.php - insert $lang['sub_send'] = "send";
   msg_view.lang.php - insert $lang['sub_select_all'] = "select all";
   msg_view.lang.php - insert $lang['sub_read'] = "mark as read";
   msg_view.lang.php - insert $lang['sub_unread'] = "mark as unread";
   msg_view.lang.php - insert $lang['sub_move'] = "move to savebox";
   msg_view.lang.php - insert $lang['sub_delete'] = "delete";
   msg_view.lang.php - insert $lang['href_reply'] = "reply";
   msg_view.lang.php - insert $lang['href_inbox'] = "inbox";
   msg_view.lang.php - insert $lang['href_outbox'] = "outbox";
   msg_view.lang.php - insert $lang['href_savebox'] = "savebox";
   msg_view.lang.php - insert $lang['href_compose'] = "compose";
   msg_view.lang.php - insert $lang['err_no_messages'] = "Sorry, you have no messages.";
   msg_view.lang.php - insert $lang['err_no_file'] = "Sorry, file available.";
   msg_view.lang.php - insert $lang['txt_message_list'] = "message list";
   msg_view.lang.php - insert $lang['txt_options'] = "options";
   msg_view.lang.php - insert $lang['txt_view'] = "view";
   nlt_view.lang.php - insert $lang['href_list'] = "list newsletters";
   nlt_view.lang.php - insert $lang['href_list_group'] = "list group newsletters";
   nlt_view.lang.php - insert $lang['href_edit'] = "resend";
   nlt_view.lang.php - insert $lang['href_add_newsletter'] = "send a newsletter";
   nlt_view.lang.php - insert $lang['href_add_group_newsletter'] = "send a group newsletter";
   my_bookmarks.lang.php - insert $lang['hdr_notify'] = "tracking an item (email notification)";
   my_bookmarks.lang.php - insert $lang['href_track'] =	"track";
   my_bookmarks.lang.php - insert $lang['href_untrack'] ="remove tracking";
   my_bookmarks.lang.php - insert $lang['txt_notify'] = "you can request an email to be sent to you when an item receives a new comment. This is called tracking and you can activiate it using the 'track'. Once activated you can always return here and 'remove tracker' to stop emails being sent to you.";
   my_membership.lang.php - insert $lang['txt_rss_help'] = "An RSS feed is available for this node. Please note, if you change your password you will need to recreate this feed. See the help group for more information on RSS.";
   my_membership.lang.php - insert $lang['txt_public_rss_help'] = "An public RSS feed is available for this node. Please note, if you log in you can get a feed which contains non public content. See the help section for more information RSS.";
   arrays/arr_rsp.lang.php - insert $lang['rsp']['rsp_level_degree'][1] = "1st degree network";
   node_rsp.lang.php - insert $lang['ttl_featured'] = "F";
   node_rsp.lang.php - $lang['txt_featured'] = "featured";
   
   
   TEMPLATES ------------------------------------------------------------------
   Replace all templates
   
   
   
>> from version 0.1.4 to 0.1.5
   TEMPLATES
   If you have not customised these templates then replace them.
   
   my_profile.tpl.php - replace
   msg_edit.tpl.php - replace
   lib_
   sch_view.tpl.php - insert lines 155 to 157
   
>> from version 0.1.3 to 0.1.4
   TEMPLATES
   If you have not customised these templates then replace them.
   
   frm_view.tpl.php - replace 479-482 with lines 479-487
   pol_view.tpl.php - replace 352-355 with lines 352-370
   search.tpl.php - replace 57-60 with lines 57-71
   search.tpl.php - replace line 202 - subject synopsis
   my_tags.tpl.php - add
   sch_view.tpl.php - replace
   sch_edit.tpl.php - replace
   pol_edit.tpl.php - replace
   blg_view.tpl.php - replace
   blg_edit.tpl.php - replace
   frm_edit.tpl.php - replace
   lib_view.tpl.php - replace
   lib_edit.tpl.php - replace
   
   DATABASE
   ALTER TABLE `igloo_tag` ADD `level_id` INT( 1 ) ;
   
>> from version 0.1.2 to 0.1.3
   DATABASE
   ALTER TABLE `igloo_sn` CHANGE `sn_cron_update_request` `sn_batch_request` INT( 1 ) DEFAULT NULL 
   ALTER TABLE `igloo_newsletter` ADD `role_id` INT( 11 ) AFTER `item_id`;
   ALTER TABLE `igloo_newsletter` CHANGE `message_status` `status_id` INT( 1 ) DEFAULT '0' NOT NULL 
   ALTER TABLE `igloo_newsletter` CHANGE `start_id` `start_user_id` INT( 11 ) DEFAULT NULL 
   
   
>> from version 0.1.1 to 0.1.2
   TEMPLATE
   node_user.tpl.php - replace
   igloo.css - add - listnav
   fil_view.tpl.php - update - line 131
   frm_edit.tpl.php - update lines 589 to 591 (include div tag)
   blg_view.tpl.php - replace
   
   LANGUAGE
   common.lang.php - add $lang['txt_list_nav_start'] = "start";
   common.lang.php - add $lang['txt_list_nav_end'] = "end";
   common.lang.php - add $lang['txt_list_nav_prev'] = "previous";
   common.lang.php - add $lang['txt_list_nav_next'] = "next";
   replace /man/wiki_formatting.man.php 
   

>> from version 0.1.0 to 0.1.1
   TEMPLATE
   igloo.css - change line 90 to #content .metadata {
   replace setup.tpl.php
   replace default.tpl.php
   replace comment.inc.tpl.php
   replace sch_view.tpl.php
   replace sn_list.tpl.php (pending invites moved to main column)
   replace error.tpl.php
   sch_edit.tpl.php - replace line 251
   msg_view.tpl.php - replace
   
   LANGUAGE
   replace setup.lang.php
   
   
>> Development build (version 0.1.1) - no upgrade options

>> First build (version 0.1.0) - no upgrade options
