Changeset 9 for branches/2/mangos_import.php

Timestamp:

May 9, 2008, 2:04:07 PM (17 years ago)

Author:

george

Message:

Přidáno: Import uživatelů a questů ze starého systému.
Přidáno: Zobrazení vícenásobných překladů.

File:

• branches/2/mangos_import.php (modified) (2 diffs)

branches/2/mangos_import.php

@@ -6 +6 @@
   {
     $Output = '';
-    $this->Database->delete('Text', '`Text`.`TranslationGroup`=(SELECT `TextGroup`.`Id` FROM `TextGroup` WHERE `TextGroup`.`Language`=1)');
+    $this->Database->query('DELETE FROM `Text` JOIN `TextGroup` ON `TextGroup`.`Language`=1 AND `TextGroup`.`Id` = `Text`.`TranslationGroup`');
     echo($this->Database->error);
-    $this->Database->delete('TranslationGroup', '`Language`=1');
+    $this->Database->delete('TextGroup', '`Language`=1');
     echo($this->Database->error);
 
@@ -47 +47 @@
   function ImportOldSystem()
   {
+    $Output = '';
+
+    // Import users
+    $this->Database->query('TRUNCATE TABLE `User`');
+    $DbResult = $this->Database->query('SELECT * FROM `quests`.`user`');
+    while($User = $DbResult->fetch_array())
+    {
+      $Language = $User['Language'] + 1;
+      if($Language == 1) $Language = 2;
+      $Role = 2;
+      if($User['gm'] == 1) $Role = 3;
+      if($User['gm'] == 2) $Role = 4;
+      $this->Database->insert('User', array('Name' => $User['user'], 'Password' => $User['pass'], 'Email' => $User['Email'], 'TranslationLanguage' => $Language, 'LastLoginTime' => $User['LastLogin'], 'LastIpAddress' => $User['LastIP'], 'Role' => $Role, 'Id' => $User['ID']));
+    }
+    $this->Database->insert('User', array('Name' => 'Anonym', 'Password' => '', 'Email' => '', 'TranslationLanguage' => 1, 'LastLoginTime' => '', 'LastIpAddress' => '', 'Role' => 1));
+    $this->Database->insert('User', array('Name' => 'MaNGOS', 'Password' => '', 'Email' => '', 'TranslationLanguage' => 1, 'LastLoginTime' => '', 'LastIpAddress' => '', 'Role' => 1));
+    $this->Database->insert('User', array('Name' => 'WoWEmu', 'Password' => '', 'Email' => '', 'TranslationLanguage' => 1, 'LastLoginTime' => '', 'LastIpAddress' => '', 'Role' => 1));
+    $UnknownUserId = $this->Database->insert_id;
+    $Output .= 'Uživatelé převedeni<br>';
+
+    // Import texts
+    $this->Database->query('CREATE TABLE Transition (OldIndex INT, NewIndex INT, INDEX OldIndex ) ENGINE=MEMORY');
+    //$this->Database->query('TRUNCATE TABLE `User`');
+    $DbResult = $this->Database->query('SELECT * FROM `quests`.`quests`');
+    while($Quest = $DbResult->fetch_array())
+    {
+      if($Quest['Language'] > 0)
+      {
+        if($Quest['User'] == 0) $Quest['User'] = $UnknownUserId;
+        if($Quest['Take'] > 0)
+        {
+          $DbResult2 = $this->Database->select('Transition', 'NewIndex', 'OldIndex='.$Quest['Take']);
+          $DbRow2 = $DbResult2->fetch_array();
+          $Take = $DbRow2['NewIndex'];
+        } else $Take = 0;
+
+        $this->Database->insert('TextGroup', array('Index' => $Quest['entry'], 'Group' => 1, 'Time' => 'NOW()', 'Language' => $Quest['Language'] + 1, 'OldSystem' => 1, 'Complete' => $Quest['complete'], 'OriginalText' => $Take));
+        //echo($this->Database->LastQuery);
+        $TextGroupId = $this->Database->insert_id;
+        $this->Database->insert('Transition', array('OldIndex' => $Quest['ID'], 'NewIndex' => $TextGroupId));
+        if($Quest['Title'] != '') $this->Database->insert('Text', array('TranslationGroup' => $TextGroupId, 'GroupItem' => 1, 'Text' => $Quest['Title']));
+        if($Quest['Details'] != '') $this->Database->insert('Text', array('TranslationGroup' => $TextGroupId, 'GroupItem' => 2, 'Text' => $Quest['Details']));
+        if($Quest['Objectives'] != '') $this->Database->insert('Text', array('TranslationGroup' => $TextGroupId, 'GroupItem' => 3, 'Text' => $Quest['Objectives']));
+        if($Quest['OfferRewardText'] != '') $this->Database->insert('Text', array('TranslationGroup' => $TextGroupId, 'GroupItem' => 4, 'Text' => $Quest['OfferRewardText']));
+        if($Quest['RequestItemsText'] != '') $this->Database->insert('Text', array('TranslationGroup' => $TextGroupId, 'GroupItem' => 5, 'Text' => $Quest['RequestItemsText']));
+        if($Quest['EndText'] != '') $this->Database->insert('Text', array('TranslationGroup' => $TextGroupId, 'GroupItem' => 6, 'Text' => $Quest['EndText']));
+        if($Quest['ObjectiveText1'] != '') $this->Database->insert('Text', array('TranslationGroup' => $TextGroupId, 'GroupItem' => 7, 'Text' => $Quest['ObjectiveText1']));
+        if($Quest['ObjectiveText2'] != '') $this->Database->insert('Text', array('TranslationGroup' => $TextGroupId, 'GroupItem' => 8, 'Text' => $Quest['ObjectiveText2']));
+        if($Quest['ObjectiveText3'] != '') $this->Database->insert('Text', array('TranslationGroup' => $TextGroupId, 'GroupItem' => 9, 'Text' => $Quest['ObjectiveText3']));
+        if($Quest['ObjectiveText4'] != '') $this->Database->insert('Text', array('TranslationGroup' => $TextGroupId, 'GroupItem' => 10, 'Text' => $Quest['ObjectiveText4']));
+      }
+    }
+    $this->Database->query('DROP TABLE Transition');
+    $Output .= 'Questy převedeny<br>';
+    return($Output);
   }
 }