>> AROUNDMe

  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.
   
   You should aim to replace all files except the config directory and any language and template 
   files you may have modified. For those follow the instructions below.
   
   Most installations do not customise either their templates or their language files. If you have not 
   then simply backup and copy all the files in this installation into your required destination and 
   run any database queries listed below. If you have customised your templates and language files 
   then read the template and language file sections below and replace or modify where stated.
   
   ** ALWAYS PERFORM A FULL FILE AND DATABASE BACKUP BEFORE UPGRADING **
   
   
>> From version 0.6.3 to version 0.6.4
   
   TEMPLATE
   grp_view.tpl.php - insert lines 411 to 415
   sch_view.tpl.php - replace line 1146 and 1151
   
   LANGUAGE
   arr_newsletter.lang.php - add
   
   
>> From version 0.6.2 to version 0.6.3
   DATABASE ------------------------------------------------------------------
   ALTER TABLE `am_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 am_rsp where level_id=32;
   UPDATE am_rsp set level_id=32 where level_id=64;
   
   If you would like the latest community information to appear on the community 
   featured page then:
   
   UPDATE am_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 am_rsp set rsp_featured=1 where level_id=32;
   
   
   LANGUAGE ------------------------------------------------------------------
   common.lang.php - insert $lang['txt_filenames'] = "files";
   common.lang.php - insert $lang['txt_wikipagenames'] = "wiki links";
   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";
   common.lang.php - insert $lang['txt_featured'] = "featured";
   node_rsp.lang.php - insert $lang['ttl_featured'] = "F";
   node_rsp.lang.php - $lang['txt_featured'] = "featured";
   
   TEMPLATES ------------------------------------------------------------------
   Replace all templates
   
   
>> From version 0.6.1 to version 0.6.2
   DATABASE
   ALTER TABLE `am_comment` ADD `item_user_id` INT( 11 ) ;
   ALTER TABLE `am_bookmark` ADD `bookmark_notify` INT( 1 ) ;
   ALTER TABLE `am_bookmark` ADD `bookmark_batch_request` INT( 1 ) ;
   
   TEMPLATES
   blg_view.tpl.php - insert line 152 to 154 (comment form input - blog user_id)
   lib_edit.tpl.php - replace
   blg_edit.tpl.php - replace
   
   LANGUAGE
   common.lang.php - insert $lang['menu_featured'] = "featured";
   common.lang.php - delete $lang['menu_latest'] = "latest";
   common.lang.php - insert $lang['href_edit'] = "edit this";
   common.lang.php - insert $lang['menu_group_mgmt'] = "groups";
   common.lang.php - insert $lang['txt_everyone'] = "everyone";
   man/wiki_formatting man - replace
   arrays/arr_error.lang.php - insert lines 76 and 77
   blg_view.lang.php - insert $lang['hdr_my_group_blogs'] = "latest blog entries from my groups";
   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['err_no_latest_group_blogs'] = "Sorry, there are no recent blog entries.";
   blg_view.lang.php - insert $lang['href_group_blog'] = "view group blog";
   blg_view.lang.php - insert $lang['href_network_blog'] = "view their blog";
   blg_view.lang.php - insert $lang['href_view_node'] = "latest from everyone";
   blg_view.lang.php - insert $lang['href_view_network'] = "latest from my network";
   blg_view.lang.php - insert $lang['href_view_my_groups'] = "latest from my groups";
   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['href_group_add_blog'] = "add a blog entry to this group";
   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_group_link'] = "This blog is from the group";
   blg_view.lang.php - insert $lang['txt_intro_group'] = "Listed are the last MAXLISTNUMBER (max) blog entries that have been published by the groups that you are a member of.";
   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 community.";
   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 social network.";
   blg_view.lang.php - insert $lang['txt_outro_group'] = "The following groups have not published a blog entry within the last MAXLISTNUMBER.";
   blg_view.lang.php - insert $lang['txt_outro_network'] = "The following people in your social network have not published a blog entry within the last MAXLISTNUMBER.";
   blg_view.lang.php - insert $lang['hdr_blog_author'] = "author";
   blg_view.lang.php - insert $lang['hdr_blog_group_author'] = "authoring group";
   blg_view.lang.php - delete $lang['txt_my_options'] = "my options";
   blg_view.lang.php - delete $lang['txt_group_options'] = 	"group options";
   blg_view.lang.php - delete $lang['txt_option_items'] = "my blog entries";
   blg_view.lang.php - delete $lang['txt_option_marked'] = "marked blog entries";
   blg_view.lang.php - delete $lang['txt_option_tipped'] = "tipped blog entries";
   blg_view.lang.php - delete $lang['txt_option_list'] = "list entries for this blog";
   blg_view.lang.php - delete $lang['txt_option_edit'] = "edit this blog entry";
   blg_view.lang.php - delete $lang['txt_option_add'] = "add a blog entry";
   blg_view.lang.php - delete $lang['txt_group_link'] = "This blog is from the group";
   blg_view.lang.php - delete $lang['txt_option_group_add'] = "add a group blog entry";
   blg_view.lang.php - delete $lang['txt_option_group_list'] = "list entries for this group blog";

   frm_view.lang.php - insert $lang['hdr_options'] = "discussion options";
   frm_view.lang.php - insert $lang['hdr_forum_author'] = "author";
   frm_view.lang.php - insert $lang['hdr_forum_group_author'] =	"authoring group";
   frm_view.lang.php - insert $lang['href_group_forum'] = "view group discussions";
   frm_view.lang.php - insert $lang['href_network_forum'] = "view their discussions";
   frm_view.lang.php - insert $lang['href_view_node'] = "latest from the community";
   frm_view.lang.php - insert $lang['href_view_network'] = "latest from my network";
   frm_view.lang.php - insert $lang['href_view_my_groups'] = "latest from my groups";
   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 community";
   frm_view.lang.php - insert $lang['href_group_add_subject'] = "add a dicussion to this group";
   frm_view.lang.php - insert $lang['href_add_topic'] = "add a topic to this community";
   frm_view.lang.php - insert $lang['href_group_add_topic'] = "add a topic to this group";
   frm_view.lang.php - insert $lang['href_group_add_topic'] = "add a topic to this group";
   frm_view.lang.php - insert $lang['href_edit_topics'] = "manage community topics";
   frm_view.lang.php - insert $lang['href_edit_group_topics'] = "manage group topics";
   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_group_link'] = "This discussion is from the group";
   frm_view.lang.php - insert $lang['txt_intro_group'] = "Listed are the last MAXLISTNUMBER (max) discussions that have been published by the groups that you are a member of.";
   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 community.";
   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_group'] = "The following groups have not published a discussion within the last MAXLISTNUMBER.";
   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 - delete $lang['href_topic'] = "view topic";
   frm_view.lang.php - delete $lang['href_edit_this'] = "edit this";
   frm_view.lang.php - delete $lang['href_edit_topics'] = "edit topics";
   frm_view.lang.php - delete $lang['href_add_subject'] = "add subject";
   frm_view.lang.php - delete $lang['href_see_all_sub'] = "go to topic";
   frm_view.lang.php - delete $lang['href_latest_discussions'] = "latest";
   blg_edit.lang.php - insert $lang['txt_degree_nw'] = "my network only";
   blg_edit.lang.php - insert $lang['txt_publish_all'] = "everyone in our community";
   blg_edit.lang.php - insert $lang['txt_publish_group_help'] = "submit to group editor for inclusion in the groups first page";
   blg_edit.lang.php - insert $lang['txt_publish_auto_group_help'] = "include on the groups first page";
   lib_view.lang.php - insert $lang['hdr_group_author'] = "authoring group";
   lib_view.lang.php - insert $lang['txt_options'] = "options";
   lib_view.lang.php - insert $lang['txt_view'] = "view";
   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['href_add_group_library'] = "add wiki page to this group";
   lib_view.lang.php - insert $lang['txt_group_link'] = "This blog is from the group";
   lib_view.lang.php - insert $lang['txt_intro_contents_group'] = "Listed are the wiki pages that have been published by this group.";
   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.";
   lib_edit.lang.php - insert $lang['txt_publish_group_help'] =	"submit to group editor for inclusion in the groups first page";
   lib_edit.lang.php - insert $lang['txt_publish_auto_group_help'] = "include on the groups first page";
   lib_edit.lang.php - insert $lang['txt_degree_nw'] = "my network only";
   lib_edit.lang.php - insert $lang['txt_publish_all'] = "everyone in our community";
   frm_view.lang.php - insert $lang['hdr_my_group_subjects'] = "latest discussions from my groups";
   frm_view.lang.php - insert $lang['hdr_my_network_subjects'] = "latest discussions from my network";
   frm_view.lang.php - insert $lang['href_group_subject'] = "view group discussions";
   frm_view.lang.php - insert $lang['href_network_subject'] = "view their discussions";
   frm_view.lang.php - insert $lang['txt_tag'] = "tags";
   frm_view.lang.php - insert $lang['txt_intro_latest'] = "These are the latest discussions for the community. If you want to add a discussion click on a topic first.";
   frm_view.lang.php - insert $lang['err_no_add_subject'] = "sorry, you are not allowed to add a discussion to this topic.";
   frm_edit.lang.php - insert $lang['txt_publish_node_help'] = "submit to 'Stuff' editor for inclusion in the featured page";
   frm_edit.lang.php - insert $lang['txt_publish_auto_node_help'] = "include in the 'Stuff' featured page";
   frm_edit.lang.php - insert $lang['txt_publish_public_help'] = "submit to public web site editor";
   frm_edit.lang.php - insert $lang['txt_publish_auto_public_help'] = "include in the public web site";
   frm_edit.lang.php - insert $lang['txt_publish_group_help'] =	"submit to group editor for inclusion in the groups first page";
   frm_edit.lang.php - insert $lang['txt_publish_auto_group_help'] = "include on the groups first page";
   frm_edit.lang.php - insert $lang['txt_degree_nw'] = "my network only";
   frm_edit.lang.php - insert $lang['txt_publish_all'] = "everyone in our community";

   pol_view.lang.php - insert $lang['hdr_group_poll'] = "group poll";
   pol_view.lang.php - insert $lang['hdr_my_group_polls'] = "latest polls from my groups";
   pol_view.lang.php - insert $lang['hdr_my_network_polls'] = "latest polls from my network";
   pol_view.lang.php - insert $lang['hdr_options'] = "poll options";
   pol_view.lang.php - insert $lang['hdr_poll_author'] = "author";
   pol_view.lang.php - insert $lang['hdr_poll_group_author'] = "authoring group";
   pol_view.lang.php - insert $lang['href_group_poll'] = "view group polls";
   pol_view.lang.php - insert $lang['href_network_poll'] = "view their polls";
   pol_view.lang.php - insert $lang['href_view_node'] = "latest from the community";
   pol_view.lang.php - insert $lang['href_view_network'] = "latest from my network";
   pol_view.lang.php - insert $lang['href_view_my_groups'] = "latest from my groups";
   pol_view.lang.php - insert $lang['href_my_poll'] = "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_group_add_poll'] = "add a poll to this group";
   pol_view.lang.php - insert $lang['href_voted'] = "polls i've voted in";
   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_group_schedule'] = "group schedule";
   sch_view.lang.php - insert $lang['hdr_my_group_schedule_items'] = "latest schedule items from my groups";
   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_schedule_item_group_author'] = "authoring group";
   sch_view.lang.php - insert $lang['href_group_schedule'] = "view group schedule";
   sch_view.lang.php - insert $lang['href_network_schedule'] = "view their schedule";
   sch_view.lang.php - insert $lang['href_view_node'] = "latest from the community";
   sch_view.lang.php - insert $lang['href_view_network'] = "latest from my network";
   sch_view.lang.php - insert $lang['href_view_my_groups'] = "latest from my groups";
   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_group_add_event'] = "add an event to this group";
   sch_view.lang.php - insert $lang['href_add_task'] = "add a task to my schedule";
   sch_view.lang.php - insert $lang['href_group_add_task'] = "add a task to this group";
   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_group_link'] = "This schedule is from the group";
   sch_view.lang.php - insert $lang['txt_intro_group'] = "Listed are the last MAXLISTNUMBER (max) schedule items that have been published by the groups that you are a member of.";
   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_group'] = "The following groups have not published a schedule item within the last MAXLISTNUMBER.";
   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.";
   sch_view.lang.php - insert $lang['href_allocation'] = "allocation";

   common.lang.php - insert $lang['href_watch_this_notify'] = "mark &amp; track";

   my_bookmarks.lang.php - insert $lang['href_track'] =	"track";
   my_bookmarks.lang.php - insert $lang['href_untrack'] = "remove tracking";

   common.lang.php - insert $lang['menu_overview'] = "overview";
   
   chl_view.lang.php - insert $lang['hdr_group_channels'] = "group channels";

   pol_edit.lang.php - insert $lang['txt_publish_node_help'] = "submit to 'Community' editor for inclusion in the featured page";
   pol_edit.lang.php - insert $lang['txt_publish_auto_node_help'] = "include in the 'Community' featured page";
   pol_edit.lang.php - insert $lang['txt_publish_public_help'] = "submit to public web site editor";
   pol_edit.lang.php - insert $lang['txt_publish_auto_public_help'] = "include in the public web site";
   pol_edit.lang.php - insert $lang['txt_publish_group_help'] = "submit to group editor for inclusion in the groups first page";
   pol_edit.lang.php - insert $lang['txt_publish_auto_group_help'] = "include on the groups first page";
   pol_edit.lang.php - insert $lang['txt_degree_nw'] = "my network only";
   pol_edit.lang.php - insert $lang['txt_publish_all'] = "everyone in our community";

   sch_edit.lang.php - insert $lang['txt_publish_node_help'] = "submit to 'Community' editor for inclusion in the featured page";
   sch_edit.lang.php - insert $lang['txt_publish_auto_node_help'] = "include in the 'Community' featured page";
   sch_edit.lang.php - insert $lang['txt_publish_public_help'] = "submit to public web site editor";
   sch_edit.lang.php - insert $lang['txt_publish_auto_public_help'] = "include in the public web site";
   sch_edit.lang.php - insert $lang['txt_publish_group_help'] = "submit to group editor for inclusion in the groups first page";
   sch_edit.lang.php - insert $lang['txt_publish_auto_group_help'] = "include on the groups first page";
   sch_edit.lang.php - insert $lang['txt_degree_nw'] = "my network only";
   sch_edit.lang.php - insert $lang['txt_publish_all'] = "everyone in our community";

   
   blg_edit.lang.php - insert $lang['txt_publish_node_help'] ="submit to 'Group' editor for inclusion in the featured page";
   blg_edit.lang.php - insert $lang['txt_publish_auto_node_help'] = "include in the 'Group' featured page";
   blg_edit.lang.php - insert $lang['txt_publish_public_help'] ="submit to public web site editor";
   blg_edit.lang.php - insert $lang['txt_publish_auto_public_help'] =	"include in the public web site";
   blg_edit.lang.php - insert $lang['txt_degree_nw'] = "my network only";
   blg_edit.lang.php - insert $lang['txt_publish_all'] = "everyone in our group";
   
   lib_edit.lang.php - insert $lang['txt_publish_node_help'] ="submit to 'Group' editor for inclusion in the featured page";
   lib_edit.lang.php - insert $lang['txt_publish_auto_node_help'] = "include in the 'Group' featured page";
   lib_edit.lang.php - insert $lang['txt_publish_public_help'] ="submit to public web site editor";
   lib_edit.lang.php - insert $lang['txt_publish_auto_public_help'] ="include in the public web site";
   lib_edit.lang.php - insert $lang['txt_degree_nw'] = "my network only";
   lib_edit.lang.php - insert $lang['txt_publish_all'] = "everyone in our group";
   
   frm_edit.lang.php - insert $lang['txt_publish_node_help'] ="submit to 'Group' editor for inclusion in the featured page";
   frm_edit.lang.php - insert $lang['txt_publish_auto_node_help'] = "include in the 'Group' featured page";
   frm_edit.lang.php - insert $lang['txt_publish_public_help'] ="submit to public web site editor";
   frm_edit.lang.php - insert $lang['txt_publish_auto_public_help'] = "include in the public web site";
   frm_edit.lang.php - insert $lang['txt_degree_nw'] = "my network only";
   frm_edit.lang.php - insert $lang['txt_publish_all'] = "everyone in our group";
   
   pol_edit.lang.php - insert $lang['txt_publish_node_help'] ="submit to 'Group' editor for inclusion in the featured page";
   pol_edit.lang.php - insert $lang['txt_publish_auto_node_help'] = "include in the 'Group' featured page";
   pol_edit.lang.php - insert $lang['txt_publish_public_help'] ="submit to public web site editor";
   pol_edit.lang.php - insert $lang['txt_publish_auto_public_help'] =	"include in the public web site";
   pol_edit.lang.php - insert $lang['txt_degree_nw'] = "my network only";
   pol_edit.lang.php - insert $lang['txt_publish_all'] = "everyone in our group";
   
   sch_edit.lang.php - insert $lang['txt_until'] = 	"until";
   sch_edit.lang.php - insert $lang['txt_publish_help'] ="How wide do you want the audience of your event to be? You can publish to just your friends, wider degrees of aquaintances or the Splash magazine page.";
   sch_edit.lang.php - insert $lang['txt_publish_node_help'] ="submit to 'Group' editor for inclusion in the featured page";
   sch_edit.lang.php - insert $lang['txt_publish_auto_node_help'] = 	"include in the 'Group' featured page";
   sch_edit.lang.php - insert $lang['txt_publish_public_help'] ="submit to public web site editor";
   sch_edit.lang.php - insert $lang['txt_publish_auto_public_help'] =	"include in the public web site";
   sch_edit.lang.php - insert $lang['txt_degree_nw'] = "my network only";
   sch_edit.lang.php - insert $lang['txt_publish_all'] = "everyone in our group";


   
   CSS
   insert metadata_top


>> From version 0.6.0 to version 0.6.1
   CONFIG
   config_aroundme.inc.php - add line 321 (node_visitor_role).
   
   TEMPLATES
   msg_view.tpl.php - swap line 412
   
   LANGUAGE
   add /arrays/arr_message.lang.php
   
>> From version 0.5.4 to version 0.6.0
   Sorry, no upgrade path is offered for this release. You can upgrade the 
   database manually by reading the aroundme.sql file.
   
   
>> From version 0.5.3 to version 0.5.4
   
   XXX add schedule db changes
   ALTER TABLE `am_schedule` ADD `schedule_alarm_datetime` DATETIME AFTER `schedule_end_datetime` ;
   
   ALTER TABLE `am_newsletter` ADD `role_id` INT( 11 ) AFTER `group_id` ;
   ALTER TABLE `am_poll` ADD `poll_body` TEXT AFTER `poll_question` ;
   ALTER TABLE `am_bookmark` ADD `bookmark_alarm_datetime` DATETIME;
   
   TEMPLATES
   Apply the following changes to your template files. If you have not 
   customised the file them simply replace it.
   
   g_group.tpl.php - Line 489 - replace 'g_profile' with 'g_member_profile'
   
   
   LANGUAGE
   Apply the following changes to your language files. If you have not 
   customised the file them simply replace it.
   
   sch_list.lang.php - rename $lang['form_label_network'] to $lang['form_label_view']
   sch_edit.lang.php - add note to end of $lang['txt_date_intro']
   sch_edit.lang.php - add $lang['form_label_occurence'] = "Occurence";
   sch_edit.lang.php - add $lang['form_label_alarm'] = "Alarm";
   pol_edit.lang.php - add $lang['txt_header_7'] = 	"3. Details";
   pol_edit.lang.php - add $lang['txt_detail_intro'] = 	"You can optionally add detailed text which will appear under the question.";
   pol_edit.lang.php - add $lang['txt_check_spelling'] = "check spelling";
   pol_edit.lang.php - add $lang['form_submit_preview'] = "preview";
   pol_edit.lang.php - add $lang['form_body'] = "details";
   pol_edit.lang.php - add $lang['form_label_preview'] = "preview";
   
   
   
   
>> From version 0.5.2 to version 0.5.3
   
   DATABASE
   Apply the following queries to your database:
   
   CREATE TABLE `am_user_preference` (`user_id` INT(11) ,`user_preference_id` INT(3)) TYPE=InnoDB CHARACTER SET utf8;
   
   
   TEMPLATES
   Apply the following changes to your template files. If you have not 
   customised the file them simply replace it.
   
   msg_list.tpl.php - Lines 52 to 75 - added in profile link.
   tag_inc.tpl.php - Line 140 - add width style
   sn_menu.tpl.php - Line 127 - move image tag above table
   index.tpl.php - Line 241 - add width style
   lib_item.tpl.php - Line 128 - change g_profile to g_member_profile
   lib_item.tpl.php - Line 172 - change lib_item to lib_list
   comment.inc.tpl.php - replace.
   node_rsp.tpl.php - Line 214 - change group_library_item_sticky to library_item_sticky
   g_rsp.tpl.php - replace.
   my_membership.tpl.php - replace (or add in email subscriptions section).
   frm_edit.tpl.php - Add in php in lines 287 to 293 (or replace template)
   nlt_edit.tpl.php - Add in newsletter wiki formatting box (or replace template)
   nlt_edit.tpl.php - Add - Lines 71 to 84
   
   
   LANGUAGE
   Apply the following changes to your language files. If you have not 
   customised the file them simply replace it.
   
   sch_list.lang.php - Add $lang['txt_allocation'] = "allocation";
   lib_item.lang.php - Add $lang['href_item_comments_only'] = "Show only the comment against this version of this page";
   lib_item.lang.php - Add $lang['href_all_comments'] = "Show all comments associated with this page";
   mag_item.lang.php - Add $lang['href_item_comments_only'] = "Show only the comment against this version of this page";
   mag_item.lang.php - Add $lang['href_all_comments'] = "Show all comments associated with this page";
   p_item.lang.php - Add $lang['href_item_comments_only'] = "Show only the comment against this version of this page";
   p_item.lang.php - Add $lang['href_all_comments'] = "Show all comments associated with this page";
   index.lang.php - Add $lang['txt_login_note'] = "You will remain logged in until you press 'logoff' or exit the browser.";
   arr_error.lang.php - Add - $lang['arr_error'][46] = "When updating a file you can only replace a file with a file with the same type - ie: you can only replace a jpg with a jpg.";
   arr_acs.lang.php - ADD - $lang['arr_acs']['privilege'][15] = "allow locking";
   texts/mail_email_message.txt.php - Add
   nlt_edit.lang.php - Add $lang['txt_croncomplete'] = "Your newsletter has been processed and will be sent out soon.";
   
   
   
>> From version 0.5.1 to version 0.5.2
   
   DATABASE
   CREATE TABLE `am_forum_topic_role` (`topic_id` int(11) default NULL, `role_id` int(11) default NULL) TYPE=InnoDB CHARACTER SET utf8;
   ALTER TABLE `am_forum_topic` ADD `topic_order` INT( 11 ) AFTER `topic_hidden` ;
   ALTER TABLE `am_blog` DROP `genre_id` 
   ALTER TABLE `am_rsp` DROP `genre_id` 
   ALTER TABLE `am_newsletter` ADD `group_id` INT( 11 ) AFTER `language_id` ;
   CREATE TABLE `am_tag` (
	  `group_id` int(11) default NULL,
	  `item_id` int(11) default NULL,
	  `item_name` varchar(50) default NULL,
	  `rsp_item_type_id` int(3) default NULL,
	  `tag_body` varchar(50) default NULL,
	  `user_id` int(11) default NULL
	) TYPE=InnoDB;
   
   LANGUAGE FILES
   In frm_edit.lang.php add $lang['txt_topic_roles'] = "Which group roles can add a new subject under this topics?";
   In frm_edit.lang.php add $lang['err_item_edit'] = "Sorry, you are not allowed to edit this item.";
   In frm_list.lang.php add $lang['txt_topic_role_add'] = "The following roles can add subjects to this topic";
   In sn_network.lang.php add $lang['txt_tag'] = "tags";
   In blg_item.lang.php add $lang['hdr_tag'] = "tags";
   In blg_item.lang.php add $lang['txt_tag_intro'] = "This article has been tagged with";
   In blg_item.lang.php add $lang['txt_tag_network'] = "My network have tagged this blog with";
   In blg_item.lang.php add $lang['txt_tag_group'] = "This group has tagged this blog with";
   In blg_item.lang.php add $lang['sub_update_tag'] = "update my tags";
   In sn_profile.lang.php add $lang['hdr_tag'] = "tags";
   In sn_profile.lang.php add $lang['txt_tag_intro'] = "This person has been tagged with";
   In sn_profile.lang.php add $lang['sub_update_tag'] = "update my tags";
   In sn_network.lang.php add $lang['hdr_tag'] = "tags";
   In sn_network.lang.php add $lang['txt_tag'] = "tags";
   In sn_network.lang.php add $lang['txt_view_all_network'] = "view all";
   In lib_item.lang.php add $lang['hdr_tag'] = "tags";
   In lib_item.lang.php add $lang['txt_tag_intro'] = "This wiki page has been tagged with";
   In lib_item.lang.php add $lang['txt_tag_network'] = "My network have tagged this wiki page with";
   In lib_item.lang.php add $lang['txt_tag_group'] = "This group has tagged this wiki page with";
   In lib_item.lang.php add $lang['sub_update_tag'] = "update my tags";
   In pol_item.lang.php add $lang['hdr_tag'] = "tags";
   In pol_item.lang.php add $lang['txt_tag_intro'] = "This poll has been tagged with";
   In pol_item.lang.php add $lang['txt_tag_network'] = "My network have tagged this poll with";
   In pol_item.lang.php add $lang['txt_tag_group'] = "This group has tagged this poll with";
   In pol_item.lang.php add $lang['sub_update_tag'] = "update my tags";
   In frm_item.lang.php add $lang['hdr_tag'] = "tags";
   In frm_item.lang.php add $lang['txt_tag_intro'] = "This subject has been tagged with";
   In frm_item.lang.php add $lang['txt_tag_network'] = "My network have tagged this subject with";
   In frm_item.lang.php add $lang['txt_tag_group'] = "This group has tagged this subject with";
   In frm_item.lang.php add $lang['sub_update_tag'] = "update my tags";
   In search.lang.php add $lang['txt_tag_network'] = "network tags";
   In search.lang.php add $lang['txt_tag_group'] = "group tags";
   In search.lang.php add $lang['txt_tag'] = "tags";
   In sch_item.lang.php add $lang['txt_check_spelling'] = "Check Spelling";
   In sch_item.lang.php add $lang['txt_no_comment_allowed'] = "Sorry, this shedule item is not open to receive your comments.";
   In sch_item.lang.php add $lang['txt_tag_intro'] = "This shedule item has been tagged with";
   In sch_item.lang.php add $lang['txt_tag_network'] = "My network have tagged this shedule item with";
   In sch_item.lang.php add $lang['txt_tag_group'] = "This group has tagged this shedule item with";
   In sch_item.lang.php add $lang['txt_comment_help'] = "Remember to observe the rules of the group. Reply in group language only.";
   In sch_item.lang.php add $lang['txt_from'] = "from";
   In sch_item.lang.php add $lang['href_comments'] = "comments";
   In sch_item.lang.php add $lang['sub_edit_again'] = "edit again";
   In sch_item.lang.php add $lang['sub_save'] = "save";
   In sch_item.lang.php add $lang['sub_update_tag'] = "update my tags";
   In sch_item.lang.php add $lang['sub_preview'] = "preview";
   In sch_item.lang.php add $lang['sub_add'] = 	"add";
   In sch_item.lang.php add $lang['err_no_comments'] = 	"Sorry, there are no comments available.";
   In sch_item.lang.php add $lang['section_add_comment'] = 	"add comment";
   In sch_item.lang.php add $lang['section_comments'] = "comments";
   In sch_item.lang.php add $lang['hdr_comment_preview'] = "comment preview";
   In sch_item.lang.php add $lang['hdr_tag'] = "tags";
   In g_common.lang.php add $lang['txt_search'] = "group search";
   In g_group.lang.php add $lang['txt_tag_intro'] = "This group has been tagged with";
   In g_group.lang.php add $lang['txt_tag_network'] = "My network have tagged this group with";
   In g_group.lang.php add $lang['txt_tag_group'] = "This group has tagged this group with";
   In g_group.lang.php add $lang['hdr_tag'] = "tags";
   In g_group.lang.php add $lang['sub_update_tag'] = "update my tags";
   In search.lang.php add $lang['txt_search_basic_intro_group'] = "Search on articles published within this group. You can search using 3 or more characters.";
   In sn_invite.lang.php add $lang['err_invite_denied'] = "Sorry, you do not have permissions to invite people into this network.";
   In blg_item.lang.php add $lang['txt_non_member'] = "NON MEMBER";
   In blg_item.lang.php add $lang['txt_joined'] = "Joined";
   In blg_item.lang.php add $lang['txt_hometown'] = "Hometown";
   In lib_item.lang.php add $lang['txt_non_member'] = "NON MEMBER";
   In lib_item.lang.php add $lang['txt_joined'] = "Joined";
   In lib_item.lang.php add $lang['txt_hometown'] = "Hometown";
   In mag_common.lang.php add $lang['txt_non_member'] = "NON MEMBER";
   In mag_common.lang.php add $lang['txt_joined'] = "Joined";
   In mag_common.lang.php add $lang['txt_hometown'] = "Hometown";
   In pol_item.lang.php add $lang['txt_non_member'] = "NON MEMBER";
   In pol_item.lang.php add $lang['txt_joined'] = "Joined";
   In pol_item.lang.php add $lang['txt_hometown'] = "Hometown";
   In p_item.lang.php add $lang['txt_hometown'] = "Hometown";
   In sch_item.lang.php add $lang['txt_non_member'] = "NON MEMBER";
   In sch_item.lang.php add $lang['txt_joined'] = "Joined";
   In sch_item.lang.php add $lang['txt_hometown'] = "Hometown";
   In frm_item.lang.php add $lang['txt_non_member'] = "NON MEMBER";
   In frm_item.lang.php add $lang['txt_joined'] = "Joined";
   In frm_item.lang.php add $lang['txt_hometown'] = "Hometown";


   TEMPLATES
   mag_overview.tpl.php - tidied up display.
   sn_network.tpl.php - add tags
   sn_profile.tpl.php - add tags
   blg_item.tpl.php - add tags
   sch_item.tpl.php - add tags and comments
   tag.inc.tpl.php - add
   comment.inc.tpl.php - add "non member" and language options.
   
   
>> From version 0.5.0 to version 0.5.1
   
   DATABASE
   ALTER TABLE `am_newsletter` DROP `item_type` 
   ALTER TABLE `am_newsletter` CHANGE `item_type_id` `item_id` INT( 11 ) DEFAULT NULL 
   
   TEMPLATES
   Either replace default.tpl.php if you have not customised it or:
       1. Search default.tpl.php for </span" and replace with </span>"
	   2. Add in channels into top nav bar. Open default.tpl.php and copy the 
	      channel menu section to you default.tpl.php
	   3. msg_compose.tpl.php - replace line 53
	   4. print_item.tpl.php - add "$print_view = 1;" to line 202
	   5. swap out (overwrite) poll_detail.inc.tpl.php
   
>> From version 0.4.3 to version 0.5.0
   
   DATABASE
   You will need to build a new set of tables as this upgrade switches to 
   UNICODE. Please use /install/aroundme.sql to create tables and then export 
   and import your data. We apologise for any inconvenience caused.
   
   TEMPLATES
   A full new set of templates has been supplied. Replace any previous templates.
   
>> From version 0.4.2 to version 0.4.3
   g_membership.tpl.php - update to line 205 
   node_menu.inc.tpl.php - insert line 39, update 45, insert 47, update 53
   
>> From version 0.4.2 to version 0.4.3

   DATABASE
   No changes
   
   TEMPLATES
   my_library.tpl.php - move 'colspan="2"' from line 214 to 215
   my_library_edit.tpl.php - line 279 change txt_publish_node_help to txt_publish_public_help
  
  
  
   
>> From version 0.4.1 to version 0.4.2

   DATABASE
   If you have do not want to start a fresh database then apply the following queries to your current 
   database.
   
   ALTER TABLE `am_user` ADD `user_feed_password` VARCHAR(6) AFTER `user_password`;
   
   
   TEMPLATES
   All templates need to be upgraded to resolve CCS issue in Internet Explorer
   
   LANGUAGE FILES
   rss_feed.lang.php - added
   index.tpl.php - line 94 RSS button added
   rss_feed_mag.lang.php - added
   rss_feed_group.lang.php - added
   Welcome.lang.php - spelling error (welcoem) corrected.
   my_common.lang.php = added TITLE vars
   



>> From version 0.4.0 to version 0.4.1

   DATABASE
   If you have do not want to start a fresh database then apply the following queries to your current 
   database.
   
   ALTER TABLE am_user_profile CHANGE COLUMN profile_msn_account `profile_text1` varchar(100) default NULL;
   ALTER TABLE am_user_profile CHANGE COLUMN profile_yahoo_account `profile_text2` varchar(100) default NULL;
   ALTER TABLE am_user_profile CHANGE COLUMN profile_icq_account `profile_text3` varchar(100) default NULL;
   ALTER TABLE am_user_profile CHANGE COLUMN profile_mobile_phone `profile_text4` varchar(100) default NULL;
   ALTER TABLE am_user_profile CHANGE COLUMN profile_skype_account `profile_text5` varchar(100) default NULL;
   ALTER TABLE `am_user_profile` ADD `profile_text6` VARCHAR(100) AFTER `profile_text5`;
   ALTER TABLE `am_user_profile` ADD `profile_text7` VARCHAR(100) AFTER `profile_text6`;
   ALTER TABLE `am_user_profile` ADD `profile_text8` VARCHAR(100) AFTER `profile_text7`;
   ALTER TABLE `am_user_profile` ADD `profile_text9` VARCHAR(100) AFTER `profile_text8`;
   ALTER TABLE `am_user_profile` ADD `profile_text10` VARCHAR(100) AFTER `profile_text9`;



   TEMPLATES
   If you have configured your templates you many wish to replicate the following changes in your templates.

   \aroundme_0_4_1\www\template
   register.tpl.php - gender undisclosed added
   index.tpl.php - cms added
   item.tpl.php - added
   
   \aroundme_0_4_1\www\aroundme_0_4_1\template\am_default
   line 146 - my_shoutbox.tpl.php
   my_files.tpl.php - moved storage box and add button
   node_cms.tpl.php - replace library and blog sections
   mag_overview.tpl.php - udated all foreach statements
   g_group.tpl.php - left hand menu rebuilt
   node_register_user.tpl.php - gender undisclosed added
   welcome.tpl.php - if statement added on line 102
   sn_menu.tpl.php - if statement added on line 132
   my_blog.tpl.php - public level added
   my_library_edit.tpl.php - public level added
   node_cms.tpl.php - group and user blog/library sections added
   g_library_edit.tpl.php - public level added
   g_blog_edit.tpl.php - public level added
   g_poll_edit.tpl.php - public level added
   node_cms.tpl.php - public level added
   
   
   
   LANGUAGES
   If you have configured your language files you many wish to replicate the following changes in your them.
   
   \aroundme_0_4_1\www\language
   register.lang.php - gender undisclosed added
   index.lang.php - cms lang vars added
   item.lang.php - added
   
   \aroundme_0_4_1\www\aroundme_0_4_1\language\1\am_default
   line 57 - welcome.lang.php
   node_register_user.lang.php - gender undisclosed added
   arrays\arr_acs.lang.php - line 101 added
   my_blog.lang.php - publishing vars changed
   my_library_edit.lang.php - publishing vars changed
   g_common.lang.php - publishing vars changed
   node_cms.lang.php - public level added
   
