Changeset 387 for trunk

Timestamp:

Mar 14, 2010, 6:06:24 PM (15 years ago)

Author:

george

Message:

• Opraveno: Odřátkování samotného SQL příkazu nepřevádět na \n u exportu do SQL.

Location:

trunk

Files:

• export/export.php (modified) (1 diff)
• sql/updates/385.sql (modified) (3 diffs)

trunk/export/export.php

@@ -114 +114 @@
             $Where = substr($Where, 0, -7).')';
           } else $Where = '`'.$Group['MangosTableIndex'].'`';
-          $Where .= ' = "'.$Line[$Group['PrimaryKeyItem']].'";'."\n"; 
+          $Where .= ' = "'.$Line[$Group['PrimaryKeyItem']].'";'; 
           $Line = 'UPDATE `'.$Group['MangosTable'].'` SET '.$Values.' WHERE '.$Where;
           $Line = str_replace("\n", '\n', $Line);
           $Line = str_replace("\r", '', $Line);
-          $Buffer .= $Line;
+          $Buffer .= $Line."\n";
         }     
       }

trunk/sql/updates/385.sql

@@ -1 +1 @@
 UPDATE  `Group` SET  `MangosTableIndex` =  'menu_id,id' WHERE  `Group`.`Id` =16;
+UPDATE `Group` SET `PrimaryKeyItem` = 'Index' WHERE `Group`.`Id` =16;
 ALTER TABLE  `TextNPCOption` ADD  `Index` VARCHAR( 255 ) NOT NULL AFTER  `Take`;
 
 INSERT INTO `GroupItem` (`Id`, `Group`, `Name`, `Column`, `Visible`, `MangosColumn`, `AddonFileName`, `DBCColumnIndex`) VALUES (66, 16, 'Index', 'Index', 0, '', '', 0);
 
-INSERT INTO  `wowpreklad`.`ExportVersion` (
+INSERT INTO  `ExportVersion` (
 `Id` ,
 `ExportType` ,
@@ -12 +13 @@
 NULL ,  '1',  '75'
 );
-INSERT INTO  `wowpreklad`.`ExportVersion` (
+INSERT INTO `ExportVersion` (
 `Id` ,
 `ExportType` ,
@@ -20 +21 @@
 NULL ,  '2',  '75'
 );
+
+UPDATE `Group` SET `MangosTable` = 'creature_ai_texts' WHERE `Group`.`Id` =11;