Changeset 366 for trunk/import/import_sql_mangos.php

Timestamp:

Mar 9, 2010, 1:01:14 PM (15 years ago)

Author:

george

Message:

• Upraveno: Přejmenovány všechny tabulky textů na názvy s prvními velkými písmeny ve slovech plus pro odlišení s prefixem Text.
• Upraveno: Další SQL dotazy doplněny o SQL uvozovky.

File:

• trunk/import/import_sql_mangos.php (modified) (6 diffs)

trunk/import/import_sql_mangos.php

@@ -104 +104 @@
         $Columns = substr($Columns, 1);
 
-        if($Group['Id'] == 8)$DbResult2 = $Database->SQLCommand('SELECT VersionEnd, ID, entry, '.$Columns.' FROM '.$Group['TablePrefix'].' WHERE Name="'.$Value['name'].'" AND (Language=0) ORDER BY VersionStart DESC LIMIT 1');
-        else $DbResult2 = $Database->SQLCommand('SELECT VersionEnd, ID, entry, '.$Columns.' FROM '.$Group['TablePrefix'].' WHERE entry='.$Value[$Group['MangosTableIndex']].' AND (Language=0) ORDER BY VersionStart DESC LIMIT 1');
+        if($Group['Id'] == 8)$DbResult2 = $Database->SQLCommand('SELECT `VersionEnd`, `ID`, `Entry`, '.$Columns.' FROM `'.$Group['TablePrefix'].'` WHERE `Name`="'.$Value['name'].'" AND (`Language`=0) ORDER BY `VersionStart` DESC LIMIT 1');
+        else $DbResult2 = $Database->SQLCommand('SELECT `VersionEnd`, `ID`, `Entry`, '.$Columns.' FROM `'.$Group['TablePrefix'].'` WHERE `Entry`='.$Value[$Group['MangosTableIndex']].' AND (`Language`=0) ORDER BY `VersionStart` DESC LIMIT 1');
         if(isset($DbResult2) and (mysql_num_rows($DbResult2) > 0))
         {
@@ -114 +114 @@
             if ($DbRow2['VersionEnd'] <> $BuildNumber) 
             {
-              $Database->SQLCommand('UPDATE `'.$Group['TablePrefix'].'` SET VersionEnd = "'.$BuildNumber.'" WHERE ID='.$DbRow2['ID']);
+              $Database->SQLCommand('UPDATE `'.$Group['TablePrefix'].'` SET `VersionEnd` = "'.$BuildNumber.'" WHERE `ID`='.$DbRow2['ID']);
               echo(', '); 
             } else echo('. '); 
           } else 
           {       
-            $Columns = 'entry, language, VersionStart, VersionEnd';
-            $Values = $DbRow2['entry'].', 0, '.$BuildNumber.', '.$BuildNumber;
+            $Columns = '`Entry`, `Language`, `VersionStart`, `VersionEnd`';
+            $Values = $DbRow2['Entry'].', 0, '.$BuildNumber.', '.$BuildNumber;
             foreach($Group['Items'] as $GroupItem) 
             { 
@@ -131 +131 @@
               $Database->SQLCommand('INSERT `'.$Group['TablePrefix'].'` ('.$Columns.') VALUES ('.$Values.')');
               echo('# ');
-              WriteLog('Text <a href="form.php?group='.$Group['Id'].'&amp;ID='.mysql_insert_id().'">'.mysql_insert_id().'</a> ('.$DbRow2['entry'].') ze skupiny '.$Group['Name'].' byl v nové verzi '.$import_version.' změněn.', LOG_TYPE_IMPORT);
+              WriteLog('Text <a href="form.php?group='.$Group['Id'].'&amp;ID='.mysql_insert_id().'">'.mysql_insert_id().'</a> ('.$DbRow2['Entry'].') ze skupiny '.$Group['Name'].' byl v nové verzi '.$import_version.' změněn.', LOG_TYPE_IMPORT);
             } else echo('. ');        
           }       
@@ -141 +141 @@
           {
             $Entry = 1;
-            $DbResult = $Database->SQLCommand('SELECT MAX(`entry`) FROM `'.$Group['TablePrefix'].'`');
+            $DbResult = $Database->SQLCommand('SELECT MAX(`Entry`) FROM `'.$Group['TablePrefix'].'`');
             if(mysql_num_rows($DbResult) > 0)
             {
@@ -151 +151 @@
           }
 
-          $Columns = 'entry, language, VersionStart, VersionEnd';
+          $Columns = '`Entry`, `Language`, `VersionStart`, `VersionEnd`';
           $Values = $Entry.', 0, '.$BuildNumber.', '.$BuildNumber;
           foreach($Group['Items'] as $GroupItem)
@@ -168 +168 @@
   }
   echo('<br />Celkem: '.$Count.'  Nových: '.$NewCount.'<br />');
-  $Database->SQLCommand('UPDATE `group` SET LastVersion = "'.$BuildNumber.'", LastImport = NOW() WHERE Id='.$GroupId);
+  $Database->SQLCommand('UPDATE `Group` SET `LastVersion` = "'.$BuildNumber.'", `LastImport` = NOW() WHERE `Id`='.$GroupId);
 }