Changeset 673 for trunk/admin/index.php

Timestamp:

Dec 29, 2013, 4:59:51 PM (11 years ago)

Author:

maron

Message:

• Fixed: deleting progress file in new task
• Added: Repair all text to right Take index

File:

• trunk/admin/index.php (modified) (3 diffs)

trunk/admin/index.php

@@ -28 +28 @@
   '<a href="'.$System->Link('/admin/?action=uncomplete').'">Nastavit nekompletní texty</a><br/>'.
   '<small>Nastaví questy, které jsou v popisu nebo objektu stejné jako nedokončené</small><br/><br/>'.    
-  '<a href="'.$System->Link('/admin/?action=repairversion').'">Opravit špatně nastavené VersionEnd v kouzlech</a><br/>'.
-  '<small>Nastaví špatné version end v kouzlech, které vzniklo v důsledku importu a špatně indexovaného indexu Take</small><br/><br/>'.    
+  '<a href="'.$System->Link('/admin/?action=repairversion').'">Opravit špatně nastavené VersionEnd</a><br/>'.
+  '<small>Nastaví špatné version end a Take na originální text, které vzniklo v důsledku importu a špatně indexovaného indexu Take</small><br/><br/>'.    
   '<a href="'.$System->Link('/admin/?action=dbcstructure').'">Připravit dbc strukturu</a><br/>'.
   '<small>Otevře dbc soubory převedené do textové formy pro přípravu struktury pro import</small><br/><br/>';    
@@ -87 +87 @@
     .' OR ( `gs_tran`.`Details` !=  `gs_orig`.`Details` AND  "" =  `gs_tran`.`Details` )'
     .' OR (`gs_tran`.`Objectives` =  `gs_orig`.`Objectives` AND  "" !=  `gs_orig`.`Objectives` ))'
-    );
+    ); 
     $Output = 'Questy: <br />';
                 while($quest = $DbResult->fetch_assoc())
@@ -100 +100 @@
 function RepairVersionEnd()
 {
-  global $System;
-  
-    $sql = 'SELECT `T`.`ID`,`T`.`Take`,`sub1`.`ID` as `origID`,T.`VersionStart`,T.`VersionEnd`,`sub1`.`VersionStart` as OrigStart,sub1.`VersionEnd` as `OrigEnd` FROM `TextSpell` as `T` '.
-      ' JOIN `TextSpell` as `sub1` ON `sub1`.`Language` = 0 AND `T`.`Entry` = `sub1`.`Entry` AND `T`.`VersionStart` = `sub1`.`VersionStart`'.
-      ' WHERE `T`.`Language` != 0 AND `T`.`VersionEnd` != `sub1`.`VersionEnd` AND `T`.`Take` NOT IN'. 
-      '(Select `ID` FROM `TextSpell` as `sub2` WHERE `sub2`.`Language` = 0 AND `T`.`Entry` = `sub2`.`Entry` AND `T`.`VersionStart` = `sub2`.`VersionStart`)'.
+  global $System,$TranslationTree;
+  
+  foreach($TranslationTree as $Group)  {
+    
+    $sql = 'SELECT `T`.`ID`,`T`.`Take`,`sub1`.`ID` as `origID`,T.`VersionStart`,T.`VersionEnd`,`sub1`.`VersionStart` as OrigStart,sub1.`VersionEnd` as `OrigEnd` FROM `'.$Group['TablePrefix'] .'` as `T` '.
+      ' JOIN `'.$Group['TablePrefix'].'` as `sub1` ON `sub1`.`Language` = 0 AND `T`.`Entry` = `sub1`.`Entry` AND `T`.`VersionStart` = `sub1`.`VersionStart` '.
+      ' WHERE `T`.`Take` != `sub1`.`Take`'. 
+    //  ' WHERE `T`.`Language` != 0 AND `T`.`VersionEnd` != `sub1`.`VersionEnd` AND `T`.`Take` NOT IN'. 
+    //  '(Select `ID` FROM `'.$Group['TablePrefix'].'` as `sub2` WHERE `sub2`.`Language` = 0 AND `T`.`Entry` = `sub2`.`Entry` AND `T`.`VersionStart` = `sub2`.`VersionStart`)'.
       ' ';  //LIMIT 1000 
       //echo $sql;
                 $DbResult = $System->Database->query($sql);
-    $Output = 'Kouzla: <br />';
+    echo ': <br />'.$Group['TablePrefix'].': <br />';
                 while($line = $DbResult->fetch_assoc())
                 {
                   echo ($line['ID'].', ');              
-                        $System->Database->query('UPDATE `TextSpell` SET `VersionEnd` = '.$line['OrigEnd'].', `Take` = '.$line['origID'].'  WHERE ID='.$line['ID']);
+                        $System->Database->query('UPDATE `'.$Group['TablePrefix'].'` SET `VersionEnd` = '.$line['OrigEnd'].', `Take` = '.$line['origID'].'  WHERE ID='.$line['ID']);
                 }
-  $Output .= '<br / ><br / >Verze kouzel opraveny!';
+    echo '<br / >Verze '.$Group['TablePrefix'].' opraveny!';
+  }
   return($Output);
 }