PCPIN Chat 6.22 released

[admin]

PCPIN Chat 6.22 released. This is a "light-weight" update from PCPIN Chat version 6.21

Fixed bugs:
(bugfix) 0000449 Error: Invalid XML received!

New features:
(new feature) 0000448 Allow users to delete their accounts

Download PCPIN Chat 6.22

[admin]

Important: back up chat files and database before you begin!

1. Recommended way (all users)
This method is also described in INSTALL.txt file ("Upgrade instructions" section).

1.1. Delete *all* existing chat files and directories.
1.2. Upload new chat files to your server.
1.3. Upload new chat files to your server.
1.4. Edit file /config/db.inc.php end enter there your database connection data.
1.5. Point your browser to the file upgrade.php (located in the chat main directory) and follow onscreen instructions. Please note that you will need valid administrator access data in order to execute upgrade script.
1.6. Delete file /upgrade.php.
1.7. Log in using administrator account and check all settings.
1.8. Upgrade is finished now.

2. Manual upgrade (advanced users only)
This section describes manual steps for upgrading PCPIN Chat from version 6.21 to version 6.22

2.1. Update files
File modification must be made according to PCPIN Chat 6 CVS. You can use either [colored diff] or [diff] variant:

• /inc/ajax/delete_user.inc.php [colored diff] [diff] [full version]
  
• /inc/profile_main.inc.php [colored diff] [diff] [full version]
  
• /js/profile.js [colored diff] [diff] [full version]
  
• /tpl/profile_main.tpl [colored diff] [diff] [full version]
  
• /init.inc.php [colored diff] [diff] [full version]
  
• /funcs.inc.php [colored diff] [diff] [full version]
  
2.2. Update database
Execute following SQL queries on chat database:


Code: Select all

  INSERT INTO `pcpin_config` ( `_conf_id` , `_conf_group` , `_conf_subgroup` , `_conf_name` , `_conf_value` , `_conf_type` , `_conf_choices` , `_conf_description` )  VALUES ( '88', 'account', '{LNG_USERS}', 'allow_account_unsubscribe', '0', 'boolean_choice', '1={LNG_YES}|0={LNG_NO}', '{LNG__CONF_ALLOW_ACCOUNT_UNSUBSCRIBE}' ) ;
  INSERT INTO `pcpin_language_expression` ( `language_id`, `code`, `value`, `multi_row` ) SELECT DISTINCT `pcpin_language_expression`.`language_id` AS `language_id`, '_conf_allow_account_unsubscribe' AS `code`, 0x416c6c6f7720757365727320746f2064656c657465206f776e206163636f756e743f AS `value`, 'n' AS `multi_row` FROM `pcpin_language_expression` ;
  INSERT INTO `pcpin_language_expression` ( `language_id`, `code`, `value`, `multi_row` ) SELECT DISTINCT `pcpin_language_expression`.`language_id` AS `language_id`, 'delete_my_account' AS `code`, 0x44656c657465206d79206163636f756e74 AS `value`, 'n' AS `multi_row` FROM `pcpin_language_expression` ;
  INSERT INTO `pcpin_language_expression` ( `language_id`, `code`, `value`, `multi_row` ) SELECT DISTINCT `pcpin_language_expression`.`language_id` AS `language_id`, 'delete_my_account_confirmation' AS `code`, 0x5761726e696e672120596f75206172652061626f757420746f2064656c65746520796f7572206f776e2075736572206163636f756e742e20546869732063616e277420626520756e646f6e652e0d0a41726520796f75207375726520796f752077616e7420746f2064656c65746520796f7572206163636f756e743f AS `value`, 'n' AS `multi_row` FROM `pcpin_language_expression` ;
  UPDATE `pcpin_language` AS `la` LEFT JOIN `pcpin_language_expression` AS `le` ON `le`.`language_id` = `la`.`id` SET `le`.`value` = 0x44656e2042656e75747a65726e2065726c617562656e2c20656967656e65732042656e75747a65726b6f6e746f207a75206cc3b6736368656e3f WHERE `le`.`code` = '_conf_allow_account_unsubscribe' AND `la`.`iso_name` = 'de' ;
  UPDATE `pcpin_language` AS `la` LEFT JOIN `pcpin_language_expression` AS `le` ON `le`.`language_id` = `la`.`id` SET `le`.`value` = 0x4d65696e2042656e75747a65726b6f6e746f206cc3b6736368656e WHERE `le`.`code` = 'delete_my_account' AND `la`.`iso_name` = 'de' ;
  UPDATE `pcpin_language` AS `la` LEFT JOIN `pcpin_language_expression` AS `le` ON `le`.`language_id` = `la`.`id` SET `le`.`value` = 0x41636874756e6721205369652073696e6420696d20426567726966662c204968722042656e75747a65726b6f6e746f207a75206cc3b6736368656e2e20446965736520416b74696f6e206b616e6e206e696368742072c3bc636b67c3a46e6769672067656d616368742077657264656e2e0d0a576f6c6c656e20536965204968722042656e75747a65726b6f6e746f207769726b6c696368206cc3b6736368656e3f WHERE `le`.`code` = 'delete_my_account_confirmation' AND `la`.`iso_name` = 'de' ;
  TRUNCATE TABLE `pcpin_cache` ;
  DELETE FROM `pcpin_version` ;
  INSERT INTO `pcpin_version` ( `version`, `version_check_key`, `last_version_check` ) VALUES ( "6.22", "-", "0000-00-00 00:00:00" ) ;
 


2.3. Log in using administrator account and check all settings.
2.4. Upgrade is finished now.