>> aroundme

  Copyright (c) 2003-2005 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 configured 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.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
   
