>> AROUNDMe

  Copyright (c) 2003-2007 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 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.7.5 to 0.7.6

  **  TEMPLATE
  msg_view.tpl.php replace lines 52 and 54 (div tag)
  core_profile.tpl.php - change "core_search" to "core_people" at line 433


>> from version 0.7.5 to 0.7.6
   ** CSS
   add .tooltip {

   ** DATABASE
   CREATE TABLE `am_user_ledger` (
     `ledger_id` int(11) NOT NULL auto_increment,
     `user_id` int(11) NOT NULL,
     `ledger_net` int(11) unsigned NOT NULL,
     `ledger_type` int(3) NOT NULL,
     `ledger_payment_date` date NOT NULL,
     `ledger_expiry_date` date default NULL,
     `ledger_note` varchar(255) NOT NULL,
     PRIMARY KEY  (`ledger_id`)
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

   ALTER TABLE `am_user_identity` ADD `identity_allow_usage` INT( 1 ) NULL AFTER `identity_allow_export` ;
   
   UPDATE am_user_message JOIN am_user_identity 
   ON am_user_message.to_identity_id = am_user_identity.identity_id 
   SET am_user_message.to_user_id = am_user_identity.user_id ;

   UPDATE am_user_message JOIN am_user_identity 
   ON am_user_message.from_identity_id = am_user_identity.identity_id 
   SET am_user_message.owner_user_id = am_user_identity.user_id ;
   
   UPDATE am_user_identity SET identity_allow_usage=1 WHERE identity_type=1

  **  TEMPLATE
   inc/comment.inc.php - replace 'relpy' with '<?php echo $lang['href_comment_reply'];?>' line 118
   maint_user_view.tpl.php - replace "core_profile.php" with "core_profile" line 51
   default.tpl.php - remove lines 102-104 - if (isset($_SESSION['mail']) && $_SESSION['mail'] > 0) {
   default.tpl.php - remove line 103 - <?php }?>
   default.tpl.php - remove lines 121-123 -  if (!empty($_SESSION['outstanding_announcements'])) {
   default.tpl.php - remove line 123 - <?php }?>
   default.tpl.php - replace line 128 - if (!empty($_SESSION['outstanding_contact_reports'])) {
   inc/comment.inc.php - replace (fixes indent width)
   participation_edit.tpl.php - replace (fixed status dropdown and removed help link)
   add /img/discuss.png
   ann_list.tpl.php - replace (security around add announcement button)
   error.tpl.php - replace line 67 (link to index page)
   maint_contact_list.tpl.php - replace
   maint_location.tpl.php - replace
   default.tpl.php - insert lines 156 - 163 (tips inclusion)
   add all editor icons
   ann_edit.tpl.php - replace
   msg_edit.tpl.php - replace

   ** LANGUAGE
   common.lang.php - add $lang['alt_discuss'] = "discuss icon";
   msg_edit.lang.php - add $lang['txt_copy_to_out'] = "Add a copy of this message to my out box?";
   maint_contact_list.lang.php (remove contact_report_type array)
   maint_contact_view.lang.php (remove contact_report_type array)
   contact.lang.php (remove contact_report_type array)
   inc/structure_common.inc.php (add contact_report_type array)
   maint_contact_list.lang.php - add $lang['txt_assigned'] = "assigned to";
   inc/tips_inc.php - add
   common.lang.php - add $lang['user']['preference'][4] = "hide tips from top of page.";
   ann_edit.lang.php - replace
   msg_edit.lang.php - replace


>> from version 0.7.4 to 0.7.5

   ** TEMPLATE
   tie_matrix.tpl.php - replace
   html_email.tpl.php - add
   participation.tpl.php - add
   invite.tpl.php - add
   profile-tpl.php - replace
   msg_edit.tpl.php - change <?php echo $lang['hdr_message'];?><br /> to <h1><?php echo $lang['hdr_message'];?></h1> line 53
   msg_edit.tpl.php - change <?php echo $lang['hdr_recipient'];?><br /> to <h1><?php echo $lang['hdr_recipient'];?></h1> line 156
   me_reputation.tpl.php - change <?php echo $lang['hdr_reputation_calculus'];?><br />  to <h1><?php echo $lang['hdr_reputation_calculus'];?></h1> line 32
   me_reputation.tpl.php - change <?php echo $lang['hdr_reputation'];?><br /> to <h1><?php echo $lang['hdr_reputation'];?></h1> line 51
   people.tpl.php - change <?php echo $lang['hdr_search_results'];?><br /> to <h1><?php echo $lang['hdr_search_results'];?></h1> line 45
   people.tpl.php - change <?php echo $lang['hdr_search'];?><br /> to <h1><?php echo $lang['hdr_search'];?></h1> line 141
   me_ties.tpl.php - replace
   me_identity.tpl.php - change <?php echo $lang['hdr_identities'];?><br /> to <h1><?php echo $lang['hdr_identities'];?></h1> line 43
   me_identity.tpl.php - change <?php echo $lang['hdr_identity_intro'];?><br /> to <h1><?php echo $lang['hdr_identity_intro'];?></h1> line 86
   me_identity.tpl.php - change <?php echo $lang['hdr_identity_creator'];?><br /> to <h1><?php echo $lang['hdr_identity_creator'];?></h1> line 107
   fil_view.tpl.php - add alt="<?php echo $i['file_save_name']; ?>" at line 67 and 69
   testimonial.tpl.php - change <?php echo $lang['hdr_testimonials_received'];?><br /> to <h1><?php echo $lang['hdr_testimonials_received'];?></h1> line 51
   testimonial.tpl.php - change <?php echo $lang['hdr_write_testimonial']; ?><br /> to <h1><?php echo $lang['hdr_write_testimonial']; ?></h1> line 92
   testimonial.tpl.php - change <?php echo $lang['hdr_testimonials_written'];?><br /> to <h1><?php echo $lang['hdr_testimonials_written'];?></h1> line 123
   
   ** DATABASE
   relation_portable is no longer needed.
   alter table am_relation drop column relation_portable;

   ** LANGUAGE
   html_email.lang.php - add
   common.lang.php - insert $lang['alt_home'] = "home";
   common.lang.php - insert $lang['alt_help'] = "help";
   common.lang.php - insert $lang['href_tour'] = "tour";


>> from version 0.7.3 to 0.7.4

   ** DATABASE
   ALTER TABLE `am_user_invite` ADD `default_participation_permission` INT( 11 ) NULL AFTER `default_status_id` ;
   

   
   ** TEMPLATE
   me_view.tpl.php - replace (fixes single language problem)
   profile.tpl.php - replace (cannot see options box if id is mine)
   maint_location.tpl.php - replace (hidden language_id added)
   maint_user_list.tpl.php - change "$i['status_id']" to "$i['login_status']" at lines 100 and 101
   inc/add_comment.inc.php - replace (anchors added)
   

   ** LANGUAGE
   Insert user preference values into common.lang.php



   





>> from version 0.7.2 to 0.7.3
   
   ** TEMPLATE
   ann_list.tpl.php - replace line 63 (profile link)
   core/template/barnraiser_01/inc/comment.inc.php - replace
   core/template/barnraiser_01/img/enter_fs.png
   ann_view.tpl.php - replace
   me_view.tpl.php - replace (fixed templates drop down list)
   default.tpl.php - replace (eye candy - moves AM into centre of page)
   css/aroundme_default.css - insert #outerframe and update #layout (eye candy - moves AM into centre of page)
   msg_edit.tpl.php - replace (html editor added)
   contact.tpl.php - radio button checked
   me_ties.tpl.php - remove help-icon
   maint_permission.tpl.php - replace (if statement on role_id)
   maint_user_view.tpl.php - replace (added "none" to role selector)
   css/aroundme_default.css - replace (menu and sub-menu highlights added)
   statistics.tpl.php - replace (new chart added)
   main_user_view.tpl.php - change for"id_language" to for="id_language"
   profile.tpl.php change user_id to identity_id at line 395


   ** DATABASE
   DB Please confirm that your `am_announce_role` has no primary key set. The table will be empty, so 
   if in doubt drop the table and create a new one from this SQL:

   CREATE TABLE `am_announce_role` (
   `announce_id` INT( 11 ) NULL,
   `role_id` INT( 3 ) NULL
   ) ENGINE = InnoDB DEFAULT CHARSET = utf8;

   ALTER TABLE `am_comment` ADD `comment_type` INT( 1 ) NULL AFTER `comment_create_datetime` ;

   RENAME TABLE `aroundme_0_7_dev`.`am_announce_role`  TO `aroundme_0_7_dev`.`am_announce_membership_type` ;

   ALTER TABLE `am_announce_membership_type` CHANGE `role_id` `membership_type_id` INT( 3 ) NULL DEFAULT NULL

   ALTER TABLE `am_announce` ADD `batch_request` INT( 1 ) NULL ,

   ADD `start_user_id` INT( 11 ) NULL ;


   ** LANGUAGE
   maint_user_view.lang.php - add $lang['txt_membership_type'] = "membership type";
   maint_user_view.lang.php - add $lang['txt_none']
   maint_user_permission.lang.php - replace $lang['resource']['user'] array
   statistics.lang.php - remove $lang['txt_latest_activity'] & $lang['hdr_latest_activity'] add $lang['txt_total_hourly_activity'] & $lang['hdr_total_hourly_activity']



>> from version 0.7.1 to 0.7.2
   
   ** DATABASE
   
   CREATE TABLE `am_announce_role` (
      `announce_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
      `role_id` INT( 3 ) NULL
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8;


   ** TEMPLATE
   
   error.tpl.php - replace
   tie_matrix.tpl.php - replace
   main_permissions.tpl.php - replace
   maint_user_view.tpl.php - replace
   default.tpl.php - replace lines 140 to 154 (logo link and not logged in button)
   profile.tpl.php - replace
   maint_contact_view.tpl - replace
   inc/comment.inc.php - replace
   register.tpl.php - insert hidden invitee_identity_id form field

  
   ** LANGUAGE
   
   main_permissions.lang.php - replace
   common.lang.php - add $lang['href_not_logged_in']



>> from version 0.7.0 to 0.7.1
   
   ** DATABASE

   ALTER TABLE `am_user_identity` ADD `identity_metadata` VARCHAR( 250 ) NULL AFTER `identity_nic` ;
   ALTER TABLE `am_user` DROP `user_metadata`;
   ALTER TABLE `am_user` ADD `invitee_identity_id` INT( 11 ) NULL AFTER `invitee_user_id` ;

   CREATE TABLE `am_mem_type_access` (
     `module_id` int(11) default NULL,
     `item_id` int(11) default NULL,
     `membership_type_id` int(3) default NULL
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

  
   ** LANGUAGE
   
   setup.lang.php - append file errors
   fil_view.lang.php - replace file errors
   register.lang.php - replace $lang['txt_reg_legal']
   me_view.lang.php - replace $lang['homepage']['page'] vars
   people.lang.php - replace
   move $lang['txt_metadata'] from me_view.lang.php to me_identity.lang.php
   move $lang['txt_metadata_intro'] from me_view.lang.php to me_identity.lang.php
   inc/user_preference.inc.php - replace
   me_identity.lang.php - delete $lang['txt_space']
   tie_matrix.lang.php - replace
   common.lang.php - insert $lang['txt_matrix'], $lang['txt_block_warning'], $lang['txt_vouched']


   ** TEMPLATE
   people.tpl.php - replace
   me_view.tpl.php - replace
   me_identity.tpl.php - replace
   profile.tpl.php - replace
   tie_matrix.tpl.php - replace
   maint_user_view.tpl.php - replace
     
   
>> from version 0.6.9 to 0.7.0
   No upgrade path has been issued at this time

----------------------- END OF FILE ---------------------------
