Changeset 366 for trunk/import/import_lua.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_lua.php (modified) (6 diffs)

trunk/import/import_lua.php

@@ -35 +35 @@
           $Columns = substr($Columns, 1);
 
-          $DbResult2 = $Database->SQLCommand('SELECT `VersionEnd`, `ID`, `entry`, '.$Columns.' FROM '.$Group['TablePrefix'].' WHERE `ShortCut`="'.$Value['ShortCut'].'" AND (`Language`=0) ORDER BY `VersionStart` DESC LIMIT 1');
+          $DbResult2 = $Database->SQLCommand('SELECT `VersionEnd`, `ID`, `Entry`, '.$Columns.' FROM `'.$Group['TablePrefix'].'` WHERE `ShortCut`="'.$Value['ShortCut'].'" AND (`Language`=0) ORDER BY `VersionStart` DESC LIMIT 1');
           if(isset($DbResult2) and (mysql_num_rows($DbResult2) > 0))
           {
@@ -50 +50 @@
             } 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) 
               { 
@@ -59 +59 @@
               $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 
@@ -65 +65 @@
             // Insert new text
             $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)
             {
@@ -71 +71 @@
               $Entry += $DbRow[0];
             }           
-            $Columns = '`entry`, `language`, `VersionStart`, `VersionEnd`';
+            $Columns = '`Entry`, `Language`, `VersionStart`, `VersionEnd`';
             $Values = $Entry.', 0, '.$BuildNumber.', '.$BuildNumber;
             foreach($Group['Items'] as $GroupItem)
@@ -87 +87 @@
       }
       echo('<br />Celkem: '.$Count.'  Nových: '.$NewCount.'<br />');
-      $Database->SQLCommand('UPDATE `group` SET LastVersion = "'.$BuildNumber.'", LastImport = NOW() WHERE Id='.$Group['Id']);
+      $Database->SQLCommand('UPDATE `Group` SET `LastVersion` = "'.$BuildNumber.'", `LastImport` = NOW() WHERE `Id`='.$Group['Id']);
     }   
   }