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

Timestamp:

May 31, 2014, 11:53:31 PM (11 years ago)

Author:

chronos

Message:

• Upraveno: ICQ kontakty převedeny z tabulky uživatelů do tabulky Kontakty.

File:

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

trunk/Common/Setup/Updates.php

@@ -773 +773 @@
 }
 
+function UpdateTo662($Manager)
+{
+  $Manager->Execute('INSERT INTO `Contact` (SELECT NULL AS `Id`, 2 AS `Category`, `ICQ` AS `Value`, NULL AS `Subject`, `Id` AS `User` FROM `User`
+WHERE (`ICQ` != "") AND (`ICQ` != 0))');
+  $Manager->Execute('ALTER TABLE `User` DROP `ICQ`;');
+  $Manager->Execute('INSERT INTO `ActionIcon` (`Id`, `Name`) VALUES (NULL, "Contact.png");');
+  $IconId = $Manager->Database->insert_id;
+  $Manager->Execute('UPDATE `Action` SET `Icon` = '.$IconId.' WHERE `Title`="Kontakty"');
+
+}
+
 class Updates
 {
@@ -814 +825 @@
       647 => array('Revision' => 657, 'Function' => 'UpdateTo657'),
       657 => array('Revision' => 661, 'Function' => 'UpdateTo661'),
+      661 => array('Revision' => 662, 'Function' => 'UpdateTo662'),
     ));
   }