Changeset 524 for trunk/admin/UpdateTrace.php

Timestamp:

Feb 20, 2013, 9:40:53 PM (12 years ago)

Author:

chronos

Message:

• Přidáno: Nastavení předvolené verze klienta pro překládání v profilu překladatelů.
• Přidáno: Vlastní text v profilu uživatele.
• Upraveno: Nyní lze veřejně zobrazovat profily překladatelů.
• Opraveno: Na některých místech opraveno použití id originálního jazyka textů.

File:

• trunk/admin/UpdateTrace.php (modified) (2 diffs)

trunk/admin/UpdateTrace.php

@@ -2361 +2361 @@
 (13, 'CzWoW', 'violet', 'Překládací addon CzWoW'),
 (14, 'Administrace', 'olive', 'Administrativní akce');");
+  $Manager->Execute("INSERT INTO `ClientVersion` (`Id`, `Version`, `BuildNumber`, `ReleaseDate`, `Title`, `Imported`) VALUES
+(1, '3.1.3', 9947, '2009-06-02', '', 0),
+(2, '3.1.2', 9901, '2009-05-15', '', 0),
+(3, '3.1.1a', 9835, '2009-04-28', '', 0),
+(4, '3.1.1', 9806, '2009-04-21', '', 0),
+(5, '3.1.0', 9767, '2009-04-14', 'Secrets of Ulduar', 0),
+(6, '3.0.9', 9551, '2009-02-10', '', 0),
+(7, '3.0.8a', 9506, '2009-01-27', '', 0),
+(8, '3.0.8', 9464, '2009-01-20', '', 0),
+(9, '3.0.3', 9183, '2008-11-04', '', 0),
+(10, '3.0.2', 9056, '2008-10-14', 'Echoes of Doom', 0),
+(11, '2.4.3', 8606, '2008-07-15', '', 0),
+(12, '2.4.2', 8209, '2008-06-13', '', 0),
+(13, '2.4.1', 8125, '2008-04-01', '', 0),
+(14, '2.4.0', 8089, '2008-03-25', 'Fury of the Sunwell', 0),
+(15, '2.3.3', 7799, '2008-01-22', '', 0),
+(16, '2.3.2', 7741, '2008-01-08', '', 0),
+(17, '2.3.0', 7561, '2007-11-13', 'The Gods of Zul''Aman', 0),
+(18, '2.2.3', 7359, '2007-10-09', '', 0),
+(19, '2.2.2', 7318, '2007-10-02', '', 0),
+(20, '2.2.0', 7272, '2007-09-25', 'Voice Chat!', 0),
+(21, '2.1.3', 6898, '2007-07-10', '', 0),
+(22, '2.1.2', 6803, '2007-06-19', '', 0),
+(23, '2.1.1', 6739, '2007-06-05', '', 0),
+(24, '2.1.0a', 6729, '2007-05-22', '', 0),
+(25, '2.1.0', 6692, '2007-05-22', 'The Black Temple', 0),
+(26, '2.0.12', 6546, '2007-04-03', '', 0),
+(27, '2.0.10', 6448, '2007-03-06', '', 0),
+(28, '2.0.8', 6403, '2007-02-16', '', 0),
+(29, '2.0.7', 6383, '2007-02-13', '', 0),
+(30, '2.0.6', 6337, '2007-01-23', '', 0),
+(31, '2.0.5', 6320, '2007-01-14', '', 0),
+(32, '2.0.4', 6320, '2007-01-12', '', 0),
+(33, '2.0.3', 6299, '2007-01-09', '', 0),
+(34, '2.0.1', 6180, '2006-12-05', 'Before the Storm', 0),
+(35, '1.12.2', 6005, '2006-11-13', '', 0),
+(36, '1.12.1', 5875, '2006-09-26', '', 0),
+(37, '1.12.0', 5595, '2006-09-22', 'Drums of War', 0),
+(38, '1.11.2', 5464, '2006-07-11', '', 0),
+(39, '1.11.1', 5462, '2006-06-28', '', 0),
+(40, '1.11.0', 5428, '2006-06-20', 'Shadow of the Necropolis', 0),
+(41, '1.10.2', 5302, '2006-05-02', '', 0),
+(42, '1.10.1', 5230, '2006-04-11', '', 0),
+(43, '1.10.0', 5195, '2006-03-28', 'Storms of Azeroth', 0),
+(44, '1.9.4', 5086, '2006-03-14', '', 0),
+(45, '1.9.3', 5059, '2006-02-07', 'Love is in the Air', 0),
+(46, '1.9.2', 4996, '2006-01-12', '', 0),
+(47, '1.9.1', 4983, '2006-01-10', '', 0),
+(48, '1.9.0', 4937, '2006-01-03', 'The Gates of Ahn''Qiraj', 0),
+(49, '1.8.4', 4878, '2005-12-05', '', 0),
+(50, '1.8.3', 4807, '2005-11-15', '', 0),
+(51, '1.8.2', 4784, '2005-10-27', '', 0),
+(52, '1.8.1', 4769, '2005-10-25', '', 0),
+(53, '1.8.0', 4735, '2005-10-10', 'Dragons of Nightmare', 0),
+(54, '1.7.1', 4695, '2005-09-22', '', 0),
+(55, '1.7.0', 4671, '2006-09-13', 'Rise of the Blood God', 0),
+(56, '1.6.1', 4544, '2005-08-02', '', 0),
+(57, '1.6.0', 4500, '2005-07-12', 'Assault on Blackwing Lair', 0),
+(58, '1.5.1', 4449, '2005-06-14', '', 0),
+(59, '1.5.0', 4442, '2005-06-07', 'Battlegrounds', 0),
+(60, '1.4.2', 4375, '2005-05-03', '', 0),
+(61, '1.4.1', 4364, '2005-05-03', '', 0),
+(62, '1.4.0', 4341, '2005-04-08', 'The Call to War', 0),
+(63, '1.3.2', 4299, '2005-03-22', '', 0),
+(64, '1.3.1', 4297, '2005-03-22', '', 0),
+(65, '1.3.0', 4284, '2005-03-07', 'Ruins of the Dire Maul', 0),
+(66, '1.2.4', 4222, '2005-02-22', '', 0),
+(67, '1.2.3', 4211, '2005-02-22', '', 0),
+(68, '1.2.2', 4196, '2005-02-15', '', 0),
+(69, '1.2.1', 4150, '2004-12-21', '', 0),
+(70, '1.2.0', 4149, '2004-12-18', 'Mysteries of Maraudon', 0),
+(71, '1.1.2', 4125, '2004-12-06', '', 0),
+(72, '1.1.1', 4062, '2004-11-17', '', 0),
+(73, '1.1.0', 4044, '2004-11-07', 'World of Warcraft', 0),
+(74, '3.2.0', 10192, '2009-08-05', 'Call of the Crusade', 0),
+(75, '3.3.0', 10958, '2009-11-08', 'Fall of the Lich King', 0),
+(76, '3.2.2a', 10505, '2009-09-25', '', 0),
+(77, '3.2.2', 10482, '2009-09-22', '', 0),
+(78, '3.2.0a', 10314, '2009-08-19', '', 0),
+(79, '3.3.0a', 11159, '2009-11-14', '', 0),
+(80, '3.3.2', 11403, '2010-02-02', '', 0),
+(81, '3.3.3', 11685, '2010-03-23', '', 0),
+(82, '3.3.3a', 11723, '2010-03-26', '', 0),
+(83, '3.3.5', 12213, '2010-06-22', 'Defending the Ruby Sanctum', 0),
+(84, '3.3.5a', 12340, '2010-06-29', '', 0),
+(85, '4.0.1', 13164, '2010-10-12', 'Cataclysm Systems', 0),
+(86, '4.0.3', 13202, '2010-11-17', 'The Shattering', 0),
+(87, '4.0.1a', 13205, '2010-10-26', '', 0),
+(88, '4.0.3a', 13329, '2010-11-23', '', 0),
+(89, '4.0.6', 13596, '2011-02-08', '', 0),
+(90, '4.0.6a', 13623, '2012-02-11', '', 0),
+(91, '4.1.0', 13914, '2011-04-26', 'Rise of the Zandalari', 0),
+(92, '4.2.0', 14333, '2011-06-28', 'Rage of the Firelands', 0),
+(93, '4.2.0a', 14480, '2011-08-08', '', 0),
+(94, '4.2.2', 14545, '2011-08-30', '', 0),
+(95, '4.3.0', 15005, '2011-11-29', 'Hour of Twilight', 0),
+(96, '4.3.0a', 15050, '2011-12-02', '', 0),
+(97, '4.3.2', 15211, '2012-01-31', '', 0),
+(98, '4.3.3', 15354, '2012-02-28', '', 0),
+(99, '4.3.4', 15595, '2012-04-17', '', 0),
+(100, '5.0.4', 16016, '2012-08-27', 'Mists of Pandaria', 0),
+(101, '5.0.5', 16057, '2012-09-13', '', 0),
+(102, '5.0.5b', 16135, '2012-10-11', '', 0),
+(103, '5.1.0', 16309, '2012-11-27', 'Landfall', 0),
+(104, '5.1.0a', 16357, '2012-12-10', '', 0);");
 }
 
@@ -2406 +2511 @@
 }
 
+function UpdateTo524($Manager)
+{      
+  global $System;
+  
+  $Manager->Execute('ALTER TABLE `User` ADD `PreferredVersion` INT NULL DEFAULT NULL');
+  $Manager->Execute('ALTER TABLE `User` ADD INDEX ( `PreferredVersion` )');
+  $Manager->Execute('ALTER TABLE `User` ADD FOREIGN KEY ( `PreferredVersion` ) '.
+        'REFERENCES `ClientVersion` (`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;');
+  $Manager->Execute('ALTER TABLE `User` ADD `Info` TEXT NOT NULL');
+}
+
 $Updates = array(
         498 => array('Revision' => 506, 'Function' => 'UpdateTo506'),
         506 => array('Revision' => 510, 'Function' => 'UpdateTo510'),
+        510 => array('Revision' => 524, 'Function' => 'UpdateTo524'),
 );