Changeset 693 for trunk/Common/Setup/Updates.php

Timestamp:

Sep 14, 2014, 8:26:20 PM (10 years ago)

Author:

chronos

Message:

• Modified: PhoneNumber converted from User table columnt to generic Contacts table.
• Fixed: Removed ICQ and PhoneNumber fields from user registration.

File:

• trunk/Common/Setup/Updates.php (modified) (2 diffs)

trunk/Common/Setup/Updates.php

@@ -899 +899 @@
 }
 
+function UpdateTo692($Manager)
+{
+  // Convert user emails to contacts
+  $DbResult = $Manager->Execute('SELECT `Id` FROM `ContactCategory` WHERE `Name` = "Telefón"');
+  $DbRow = $DbResult->fetch_assoc();
+  $ContactCategoryId = $DbRow['Id'];
+
+  $Manager->Execute('INSERT INTO `Contact` (SELECT NULL AS `Id`, '.$ContactCategoryId.' AS `Category`, '.
+  '`PhoneNumber` AS `Value`, NULL AS `Subject`, `Id` AS `User`, "" AS `Descriptions`, 1 AS `Receive` FROM `User`
+WHERE (`PhoneNumber` != "") AND (`PhoneNumber` != 0))');
+  $Manager->Execute('ALTER TABLE `User` DROP `PhoneNumber`;');
+}
+
 class Updates
 {
@@ -948 +961 @@
       678 => array('Revision' => 679, 'Function' => 'UpdateTo679'),
       679 => array('Revision' => 688, 'Function' => 'UpdateTo688'),
+      688 => array('Revision' => 692, 'Function' => 'UpdateTo692'),
     ));
   }