Changeset 425 for branches/CombinedTextTables/save.php

Timestamp:

Apr 8, 2010, 7:58:16 AM (15 years ago)

Author:

george

Message:

• Upraveno: Doplněny upravené soubory do vývojové větve CombinedTextTables.
• Nastavení ignorování obsahu složek s ikonami u AoWoW.

File:

• branches/CombinedTextTables/save.php (modified) (7 diffs)

branches/CombinedTextTables/save.php

@@ -10 +10 @@
 $GroupId = LoadGroupIdParameter();
 $Group = $TranslationTree[$GroupId];
-$Table = $Group['TablePrefix'];
 if($User->Licence(LICENCE_USER)) 
 {
@@ -22 +21 @@
     
     // Get source text record from database by ID
-    $DbResult = $System->Database->query('SELECT * FROM `'.$Table.'` WHERE `ID`='.$TextID);
+    $DbResult = $System->Database->query('SELECT * FROM `Translation` WHERE (`Id`='.$TextID.') AND (`Group` = '.$Group['Id'].')');
     if($DbResult->num_rows > 0)
     {
@@ -28 +27 @@
       
       // Get data for english original
-      $DbResult = $System->Database->query('SELECT * FROM `'.$Table.'` WHERE (`Entry`='.$SourceText['Entry'].') AND (`Language` = 0) AND (`VersionStart` = '.$SourceText['VersionStart'].') AND (`VersionEnd` = '.$SourceText['VersionEnd'].')');
-      if($DbResult->num_rows > 0)
+      $DbResult = $System->Database->query('SELECT * FROM `Translation` WHERE (`Entry`='.$SourceText['Entry'].') AND (`Language` = 0) AND (`VersionStart` = '.$SourceText['VersionStart'].') AND (`VersionEnd` = '.$SourceText['VersionEnd'].') AND (`Group` = '.$Group['Id'].')');
+      if($DbResult->num_rows > 0) 
       {
         $EnglishText = $DbResult->fetch_assoc();
@@ -39 +38 @@
             $Filter .= ' AND (`'.$GroupItem['Column'].'` = "'.$EnglishText[$GroupItem['Column']].'")';
         
-        $DbResult = $System->Database->query('SELECT * FROM `'.$Table.'` WHERE (`Language` = 0)'.$Filter);
+        $DbResult = $System->Database->query('SELECT * FROM `Translation` WHERE (`Language` = 0) AND (`Group` = '.$Group['Id'].')'.$Filter);
         while($DbRow = $DbResult->fetch_assoc())
         {         
           // Get user translation paired to found english item entry
-          $DbResult2 = $System->Database->query('SELECT * FROM `'.$Table.'` WHERE (`User` = '.$User->Id.') AND (`Entry` = '.$DbRow['Entry'].') AND (`VersionStart` = '.$SourceText['VersionStart'].') AND (`VersionEnd` = '.$SourceText['VersionEnd'].')');
+          $DbResult2 = $System->Database->query('SELECT * FROM `Translation` WHERE (`User` = '.$User->Id.') AND (`Entry` = '.$DbRow['Entry'].') AND (`VersionStart` = '.$SourceText['VersionStart'].') AND (`VersionEnd` = '.$SourceText['VersionEnd'].') AND (`Group` = '.$Group['Id'].')');
           if($DbResult2->num_rows > 0)
           {
@@ -56 +55 @@
             
             // Update user translation
-            $System->Database->query('UPDATE `'.$Table.'` SET '.$Values.' WHERE `ID` = '.$ExistedText['ID']);
+            $System->Database->query('UPDATE `Translation` SET '.$Values.' WHERE `ID` = '.$ExistedText['ID']);
             
             echo('Změny v překladu <a href="form.php?group='.$GroupId.'&amp;ID='.$ExistedText['ID'].'">'.$ExistedText['ID'].'</a> ('.$ExistedText['Entry'].') uloženy!<br />');
@@ -63 +62 @@
           {
             // Insert new user translation
-            $Columns = '`Entry`, `VersionStart`, `VersionEnd`, `Language`, `Complete`, `User`, `Take`';
-            $Values = $DbRow['Entry'].', '.$DbRow['VersionStart'].', '.$DbRow['VersionEnd'].', '.$Language.', '.$Complete.', '.$User->Id.', '.$SourceText['ID'];
+            $Columns = '`Group`, `Entry`, `VersionStart`, `VersionEnd`, `Language`, `Complete`, `User`, `Take`';
+            $Values = $DbRow['Group'].', '.$DbRow['Entry'].', '.$DbRow['VersionStart'].', '.$DbRow['VersionEnd'].', '.$Language.', '.$Complete.', '.$User->Id.', '.$SourceText['ID'];
             foreach($Group['Items'] as $GroupItem)
             {
@@ -82 +81 @@
               }
             }
-            $System->Database->query('INSERT INTO `'.$Table.'` ('.$Columns.') VALUES ('.$Values.')');
+            $System->Database->query('INSERT INTO `Translation` ('.$Columns.') VALUES ('.$Values.')');
             $LastID = $System->Database->insert_id;