Changeset 40 for branches/2/mangos_import.php

Timestamp:

Jan 24, 2009, 5:55:02 PM (15 years ago)

Author:

george

Message:

• Upraveno: Změna kódování znaků souborů na UTF-8.

File:

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

branches/2/mangos_import.php

@@ -29 +29 @@
       while($DbRow = $DbResult->fetch_array())
       { 
-        $this->Database->replace('TextGroup', array('Language' => 1, 'User' => 1, 'Revision' => 1, 'Time' => 'NOW()', 'Group' => $Group['Id'], 'Index' => $DbRow[$Group['MangosTableIndex']]));
+        $this->Database->query('REPLACE INTO `TextGroup` (`Language`, `User`, `Revision`, `Time`, `Group`, `Index`) VALUES (1, 2, 1, "NOW()", '.$Group['Id'].', '.$DbRow[$Group['MangosTableIndex']].')');
         $TranslationGroupId = $this->Database->insert_id;
         foreach($GroupItemList as $GroupItem)
@@ -51 +51 @@
     // Import users
     $this->Database->query('TRUNCATE TABLE `User`');
+    $this->Database->insert('User', array('Name' => 'Anonym', 'Password' => '', 'Email' => '', 'TranslationLanguage' => 1, 'LastLoginTime' => '', 'LastIpAddress' => '', 'Role' => 1));
+    $AnonymousId = $this->Database->insert_id;
+    $this->Database->insert('User', array('Name' => 'MaNGOS', 'Password' => '', 'Email' => '', 'TranslationLanguage' => 1, 'LastLoginTime' => '', 'LastIpAddress' => '', 'Role' => 1));
+    $MangosId = $this->Database->insert_id;
+    $this->Database->insert('User', array('Name' => 'WoWEmu', 'Password' => '', 'Email' => '', 'TranslationLanguage' => 1, 'LastLoginTime' => '',     'LastIpAddress' => '', 'Role' => 1));
+    $WowemuId = $this->Database->insert_id;
+    $this->Database->insert('User', array('Name' => 'Neznámý', 'Password' => '', 'Email' => '', 'TranslationLanguage' => 1, 'LastLoginTime' => '',     'LastIpAddress' => '', 'Role' => 1));
+    $UnknownUserId = $this->Database->insert_id;
+    $UserIdIncrement = 4;
+
+    // Load old users
     $DbResult = $this->Database->query('SELECT * FROM `quests`.`user`');
     while($User = $DbResult->fetch_array())
@@ -59 +70 @@
       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' => $User['user'], 'Password' => $User['pass'], 'Email' => $User['Email'], 'TranslationLanguage' => $Language, 'LastLoginTime' => $User['LastLogin'], 'LastIpAddress' => $User['LastIP'], 'Role' => $Role, 'Id' => ($User['ID'] + $UserIdIncrement)));
     }
-    $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('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`');
@@ -75 +82 @@
       if($Quest['Language'] > 0)
       {
-        if($Quest['User'] == 0) $Quest['User'] = $UnknownUserId;
+        if($Quest['User'] == 0) $Quest['User'] = $UnknownUserId; else $Quest['User'] = $Quest['User'] + $UserIdIncrement;
         if($Quest['Take'] > 0)
         {