>> 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.8 to 0.1.9
   DATABASE ------------------------------------------------------------------
   ALTER TABLE `igloo_user_preference` ADD `user_preference_value` INT( 3 ) AFTER `user_preference_id` ;
   
   CREATE TABLE `igloo_user_skill` (
     `skill_id` int(11) NOT NULL auto_increment,
     `user_id` int(11) default NULL,
     `skill_name` varchar(200) default NULL,
     `skill_rating` int(3) default NULL,
     `skill_experience` text,
     `degree_id` int(3) default '1',
     PRIMARY KEY  (`skill_id`)
   ) TYPE=InnoDB CHARACTER SET utf8;
   
   TEMPLATE ------------------------------------------------------------------
   lib_edit.tpl.php - insert line 31
   lib_view.tpl.php - replace line 209 ($library for $blog).
   sn_profile.tpl.php - insert 557 to 597 (poll participation table).
   spl_view.tpl.php - replace (dormant user added).
   node_register_user.tpl.php - replace (mass user invite added).
   setup.tpl.php - replace (preferences added)
   blg_view.tpl.php - replace (tipped entry listing added)
   frm_view.tpl.php - replace (tipped entry listing added)
   lib_view.tpl.php - replace line 237 ($library for $blog).
   pol_view.tpl.php - replace (tipped entry listing added)
   sch_view.tpl.php - replace (tipped entry listing added)
   my_membership.tpl.php - replace (preferences added).
   comment.inc.tpl.php - replace (comment views added).
   my_view.tpl.php - insert line 97 (link to blog)
   my_profile.tpl.php - insert lines 774 to 776
   
   
   LANGUAGE ------------------------------------------------------------------
   search.tpl.php - insert $lang['txt_search'] = "search";
   sn_pofile.lang.php - insert $lang['hdr_poll_participation'] = "poll participation";
   blg_view.lang.php - insert $lang['href_tipped'] = "tipped blog entries";
   blg_view.lang.php - insert $lang['txt_intro_marked'] = "You have bookmarked the following items for reading. You can manage your bookmarks under 'Me', 'marks &amp; tips'.";
   blg_view.lang.php - insert $lang['txt_intro_tipped'] = "Your network have recommended (tipped) the following items for reading. You can manage your recommendations to your network under 'Me', 'marks &amp; tips'.";
   frm_view.lang.php - insert $lang['href_tipped'] = "tipped subjects";
   frm_view.lang.php - insert $lang['txt_intro_marked'] = "You have bookmarked the following items for reading. You can manage your bookmarks under 'Me', 'marks &amp; tips'.";
   frm_view.lang.php - insert $lang['txt_intro_tipped'] = "Your network have recommended (tipped) the following items for reading. You can manage your recommendations to your network under 'Me', 'marks &amp; tips'.";
   pol_view.lang.php - insert $lang['href_tipped'] = "tipped polls";
   pol_view.lang.php - insert $lang['txt_intro_marked'] = "You have bookmarked the following items for reading. You can manage your bookmarks under 'Me', 'marks &amp; tips'.";
   pol_view.lang.php - insert $lang['txt_intro_tipped'] = "Your network have recommended (tipped) the following items for reading. You can manage your recommendations to your network under 'Me', 'marks &amp; tips'.";
   lib_view.lang.php - insert $lang['txt_tag'] = "tags";
   sch_view.lang.php - insert $lang['href_tipped'] = "tipped polls";
   sch_view.lang.php - insert $lang['txt_intro_marked'] = "You have bookmarked the following items for reading. You can manage your bookmarks under 'Me', 'marks &amp; tips'.";
   sch_view.lang.php - insert $lang['txt_intro_tipped'] = "Your network have recommended (tipped) the following items for reading. You can manage your recommendations to your network under 'Me', 'marks &amp; tips'.";
   arrays/arr_user.lang.php - replace;
   my_membership.lang.php - replace $lang['txt_email_set_help']
   my_membership.lang.php - insert $lang['sub_update_account'] = "update account";
   my_membership.lang.php - insert $lang['sub_update_email'] = 	"update email";
   spl_view.lang.php - insert $lang['hdr_dormant'] = "your account is dormant";
   spl_view.lang.php - insert $lang['hdr_activate'] = "re-activate your account";
   spl_view.lang.php - insert $lang['sub_send'] = "re-activate";
   spl_view.lang.php - insert $lang['txt_intro_dormant'] = "Your account is set to 'dormant' which mean that you have 'paused' your account. Maybe you did this because you want on holiday or maybe it is because you changed your email. Just type in your email and date of birth and we will re-active your account by sending you an email with a new password in it.";
   spl_view.lang.php - insert $lang['txt_dob'] = "your date of birth";
   spl_view.lang.php - insert $lang['txt_email'] = "your email address";
   spl_view.lang.php - insert $lang['txt_captcha'] = "Captcha";
   spl_view.lang.php - insert $lang['txt_captcha_intro'] = "Please type the characters that you see below.";
   spl_view.lang.php - insert $lang['txt_email_subject_activate'] = "Your new password";
   node_register_user.lang.php - insert $lang['txt_emails'] = "email addresses";
   node_register_user.lang.php - insert $lang['txt_invite_to_help'] = "Hint: You can either put each email address on a new line or use a comma (,) between them like 'foo@barnraiser.org, bar@barnraiser.org'. We do not recommend sending more than 25 emails at a time.";
   node_register_user.lang.php - insert $lang['txt_emails_registered'] = "emails registered";
   my_membership.lang.php - insert $lang['hdr_preferences'] = "your preferences";
   setup.lang.php - insert $lang['txt_preferences_intro'] = "Check the following checkboxes if you would like to...";
   setup.lang.php - delete $lang['txt_messaging_help']
   setup.lang.php - delete $lang['txt_email_message_help']
   setup.lang.php - delete $lang['txt_digest_newsletter_help']
   common.lang.php - insert $lang['href_comment_hybrid'] = "switch to hybrid mode";
   common.lang.php - insert $lang['href_comment_normal'] = "switch to normal mode";
   common.lang.php - insert $lang['href_comment_threaded'] = "switch to threaded mode";
   common.lang.php - insert $lang['href_comment_reply'] = "reply";
   common.lang.php - insert $lang['txt_comment_normal'] = "You are viewing in normal mode - date ordered list of main comments.";
   common.lang.php - insert $lang['txt_comment_threaded'] = "You are viewing in threaded mode - hierachical sorting of comments.";
   common.lang.php - insert $lang['txt_comment_hybrid'] = "You are viewing in hybrid (mixed) mode - date ordered list of all comments.";
   common.lang.php - insert $lang['txt_comment_position'] = "This comment will be added against the main item.";
   common.lang.php - insert $lang['txt_comment_position1'] = "This comment will be added against the item marked in blue";
   common.lang.php - insert $lang['txt_comment_normal_hint'] = "date ordered list of main comments.";
   common.lang.php - insert $lang['txt_comment_hybrid_hint'] = "date ordered list of all comments.";
   common.lang.php - insert $lang['txt_comment_threaded_hint'] = "hierachical sorting of comments.";
   my_view.lang.php - insert $lang['href_view_blog_entry'] = "view blog entry";
   common.lang.php - insert $lang['menu_skills_finder'] = "skills finder";
   common.lang.php - insert $lang['menu_skills'] = "skills";
   UPGRADE ENDS --------------------------------------------------------------
   
   
>> 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 ) ;
