Changeset 64 for trunk

Timestamp:

Feb 5, 2009, 10:39:11 AM (16 years ago)

Author:

george

Message:

• Přidáno: Import textů z dbc souborů. Přidány překladové skupiny gametips a spell.

Location:

trunk

Files:

• TranslationList.php (modified) (2 diffs)
• dbc (added)
• dbc/Achievement.dbc (added)
• dbc/Achievement_Category.dbc (added)
• dbc/GameTips.dbc (added)
• dbc/Spell.dbc (added)
• dbc/dbc.php (added)
• fill_database.php (modified) (2 diffs)
• sql/full.sql (deleted)
• sql/text_table_init_structure.sql (modified) (1 diff)
• sql/updates/63.sql (modified) (1 diff)
• sql/updates/64.sql (added)

trunk/TranslationList.php

@@ -51 +51 @@
     Zobrazit stránku: ');
 
+  $limitx = 0;
   for($i = 0; $i < $CountLists; ++$i) 
   {
@@ -60 +61 @@
   }
         
-  if(@$_SESSION['limitx'] > $limitx) $_SESSION['limitx'] = 0;       
+  if(!array_key_exists('limitx', $_SESSION)) $_SESSION['limitx'] = 0;
+  if($_SESSION['limitx'] > $limitx) $_SESSION['limitx'] = 0;  
 }
 

trunk/fill_database.php

@@ -2 +2 @@
 
 include('includes/global.php');
+include('dbc/dbc.php');
   
 echo('Načítání textů z databáze MaNGOSu: ');
@@ -55 +56 @@
         }
         echo('<br />Celkem: '.$Count.'  Nových: '.$NewCount.'<br />');
-  }
+  } else
+  if(($Group['DBCFileName'] != '') and ($Group['TablePrefix'] != ''))
+  {
+        echo('<br />'.$Group['Name'].'<br />'); 
+        $DBCFile = new DBCReader();
+        $DBCFile->loadDbc('dbc/'.$Group['DBCFileName'].'.dbc', $Group['DBCColumns']);
+        $ItemCount = $DBCFile->count();
+        $NewCount = 0;
+        $Count = 0;
+        for($i = 0; $i < $ItemCount; $i++)
+    {
+      $ItemId = $DBCFile->getUint($i, 0);  
+      $DbResult2 = $Database->SQLCommand('SELECT ID FROM '.$Group['TablePrefix'].' WHERE entry='.$ItemId.' AND Language=0');
+      if(isset($DbResult2) and (mysql_num_rows($DbResult2) > 0))
+          {
+                $DbRow2 = mysql_fetch_assoc($DbResult2);
+                //echo($DbRow2['ID']);
+                $ColumnsValues = '';
+            foreach($Group['Items'] as $GroupItem)
+                {
+              $ColumnsValues .= ', `'.$GroupItem['Column'].'`="'.addslashes($DBCFile->getString($i, $GroupItem['DBCColumnIndex'])).'"';
+                }
+                $ColumnsValues = substr($ColumnsValues, 2);
+                echo('. '); //'UPDATE `'.$Group['TablePrefix'].'` SET '.$ColumnsValues.' WHERE ID='.$DbRow2['ID']."<br>");
+                //print_r($DbRow2);
+                $Database->SQLCommand('UPDATE `'.$Group['TablePrefix'].'` SET '.$ColumnsValues.' WHERE ID='.$DbRow2['ID']);
+          } else 
+          {
+                $Columns = 'entry, language';
+                $Values = $ItemId.', 0';
+            foreach($Group['Items'] as $GroupItem)
+                {
+              $Columns .= ', `'.$GroupItem['Column'].'`';
+                  $Values .= ', "'.addslashes($DBCFile->getString($i, $GroupItem['DBCColumnIndex'])).'"';
+                }
+                //$Columns = substr($Columns, 2);
+                //$Values = substr($Values, 2);
+                $Database->SQLCommand('INSERT `'.$Group['TablePrefix'].'` ('.$Columns.') VALUES ('.$Values.')');
+                echo('# ');
+                //echo('INSERT `'.$Group['TablePrefix'].'` ('.$Columns.') VALUES ('.$Values.')'."<br>");
+            $NewCount++;
+          }
+          $Count++;
+        }
+        echo('<br />Celkem: '.$Count.'  Nových: '.$NewCount.'<br />');
+  }  
 }
 echo('Dokončeno.</div>');

trunk/sql/text_table_init_structure.sql

@@ -14 +14 @@
   KEY `Take` (`Take`),
   KEY `Language` ( `Language` ),
-  KEY `Complete` ( `Complete` ),
+  KEY `Complete` ( `Complete` )
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 

trunk/sql/updates/63.sql

@@ -1 +1 @@
 CREATE TABLE `news` (
-`Id` INT NOT NULL ,
+`Id` INT NOT NULL auto_increment,
 `Time` DATETIME NOT NULL ,
 `User` INT NOT NULL ,
-`Text` TEXT NOT NULL
-) ENGINE = MYISAM ;
+`Text` TEXT NOT NULL,
+PRIMARY KEY  (`Id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;