Changeset 817 for trunk/Modules/Import/Import.php

Timestamp:

Feb 23, 2015, 12:03:22 AM (10 years ago)

Author:

chronos

Message:

• Fixed: Regeneration of team level images from admin page.
• Added: Show link to client version from import table and translation list table.

File:

• trunk/Modules/Import/Import.php (modified) (3 diffs)

trunk/Modules/Import/Import.php

@@ -54 +54 @@
      // $Values .= ', "'.$Value[$GroupItem['Column']].'"';
     }
-   // echo $Values;
     $Columns = substr($Columns, 1);
     $Where = ' (`'.$this->Group['PrimaryKeyItem'].'` = "'.$Value[$this->Group['PrimaryKeyItem']].'")  AND (`Language`=0) ' ;
-    //print_r($Value);
 
     $DbResultMiddle = $this->System->Database->query('SELECT `VersionEnd`,`VersionStart`, `ID`, `Entry`, '.$Columns.' FROM `'.$this->Group['TablePrefix'].'` WHERE '.$Where.' AND `VersionStart` <= '.$this->Version['BuildNumber'].' AND `VersionEnd` >= '.$this->Version['BuildNumber'].' ORDER BY `VersionEnd` DESC LIMIT 1');
     $DbResultBefore = $this->System->Database->query('SELECT `VersionEnd`,`VersionStart`, `ID`, `Entry`, '.$Columns.' FROM `'.$this->Group['TablePrefix'].'` WHERE '.$Where.' AND `VersionEnd` <= '.$this->Version['BuildNumber'].' ORDER BY `VersionEnd` DESC LIMIT 1');
     $DbResultAfter  = $this->System->Database->query('SELECT `VersionEnd`,`VersionStart`, `ID`, `Entry`, '.$Columns.' FROM `'.$this->Group['TablePrefix'].'` WHERE '.$Where.' AND `VersionStart` >= '.$this->Version['BuildNumber'].' ORDER BY `VersionStart` LIMIT 1');
-    //echo('SELECT `VersionEnd`, `ID`, `Entry`, '.$Columns.' FROM `'.$this->Group['TablePrefix'].'` WHERE '.$Where.' AND (`Language`=0) ORDER BY `VersionStart` DESC LIMIT 1');
+
     if(($DbResultMiddle->num_rows > 0) or ($DbResultBefore->num_rows > 0) or ($DbResultAfter->num_rows > 0))
     {
@@ -223 +221 @@
               $Line = substr($Line, strpos($Line, ';') + 1);
               $Value['Comment'] = addslashes(stripslashes(substr($Line, 3))); // Skip " --"
-              //print_r($Value);
 
               $this->InsertItem($Value);
@@ -260 +257 @@
         while($DbRow = $DbResult->fetch_assoc())
         {
-          echo '`';
+          echo('`');
           $this->System->Database->query('UPDATE `'.$Group['TablePrefix'].'` SET `VersionEnd` = '.$DbRow['VersionEnd_orig'].', `VersionStart` = '.$DbRow['VersionStart_orig'].' WHERE `ID` = '.$DbRow['ID']);
           $Output .= '. ';