Changeset 363 for trunk/export/export.php

Timestamp:

Mar 8, 2010, 1:54:55 PM (15 years ago)

Author:

george

Message:

• Opraveno: Import export lua souborů. Při importu převádět lomítkovou notaci do databáze na funkční znaky \n => odřádkování, \" => uvozovky. V databázi musí být uloženo správně bez lomítek.

File:

• trunk/export/export.php (modified) (3 diffs)

trunk/export/export.php

@@ -297 +297 @@
           $Value['ShortCut'] = trim($LineParts2[0]);
           $Value['Text'] = substr(trim($LineParts2[1]), 1, -1);
-          $Value['Comment'] = addslashes(substr(trim($LineParts[1]), 3));
-
-          $Query = 'SELECT * FROM (SELECT * FROM '.$Group['TablePrefix'].' WHERE (Complete = 1) AND '.$this->WhereLang.' AND '.$this->WhereUsers.' AND (ShortCut="'.$Value['ShortCut'].'") AND (VersionStart <= '.$this->ClientVersion['BuildNumber'].') AND (VersionEnd >= '.$this->ClientVersion['BuildNumber'].')'.$this->OrderByUserList.') AS T GROUP BY T.entry';
+          $Value['Comment'] = substr(trim($LineParts[1]), 3);
+
+          $Query = 'SELECT * FROM (SELECT * FROM `'.$Group['TablePrefix'].'` WHERE (`Complete` = 1) AND '.$this->WhereLang.' AND '.$this->WhereUsers.' AND (`ShortCut`="'.$Value['ShortCut'].'") AND (`VersionStart` <= '.$this->ClientVersion['BuildNumber'].') AND (`VersionEnd` >= '.$this->ClientVersion['BuildNumber'].')'.$this->OrderByUserList.') AS `T` GROUP BY `T`.`entry`';
           //echo($Query);
           $DbResult2 = $this->Database->query($Query);
@@ -305 +305 @@
           {
             $DbRow = $DbResult2->fetch_assoc();
-            $Value['Text'] = $DbRow['Text'];
-            $Value['Comment'] = $DbRow['Comment'];
+            $Value['Text'] = addslashes($DbRow['Text']);
+            $Value['Comment'] = addslashes($DbRow['Comment']);
             //echo('.');
           }
@@ -315 +315 @@
         } else $File2->WriteLine($Line."\n");
       }
-      echo('Hotovo <br />');
+      echo('Hotovo <br/>');
     }
   }