Changeset 607 for trunk/admin/index.php

Timestamp:

Nov 26, 2013, 9:30:19 PM (11 years ago)

Author:

maron

Message:

• Added: tool for set uncomplete quest mark complete = 0

File:

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

trunk/admin/index.php

@@ -21 +21 @@
   '<small>Přidá aktualitu na hlavní stranu projektu</small><br/><br/>'.    
   '<a href="'.$System->Link('/admin/?action=testing').'">Testování</a><br/>'.
-  '<small>Testovací funkce</small><br/><br/>';    
+  '<small>Testovací funkce</small><br/><br/>'.    
+  '<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/>';    
   return($Output);
 }
@@ -61 +63 @@
   return($Output);
 }
+function Uncomplete()
+{
+  global $System;
+  
+                $DbResult = $System->Database->query('SELECT  `gs_tran`.`ID`,`gs_tran`.`Details`,`gs_tran`.`Objectives` FROM '
+     .'`textquest` AS  `gs_tran` ' 
+     .'JOIN  `textquest` AS  `gs_orig` ON  `gs_orig`.`Entry` =  `gs_tran`.`Entry` ' 
+    .'AND  `gs_orig`.`Language` =0 '
+    .'WHERE  `gs_tran`.`Language` !=0 '
+    .'AND  `gs_tran`.`Complete` =1 '
+    .'AND ( (`gs_tran`.`Details` =  `gs_orig`.`Details` AND  "" !=  `gs_orig`.`Details` )'
+    .' OR ( `gs_tran`.`Objectives` !=  `gs_orig`.`Objectives` AND  "" =  `gs_tran`.`Objectives` )'
+    .' 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())
+                {
+                  $Output .= $quest['ID'].', '; 
+                        $System->Database->query('UPDATE `textquest` SET `complete` = 0 WHERE ID='.$quest['ID']);
+                }
+  $Output .= '<br / ><br / >Questy nastaveny jako nedokončené!';
+  return($Output);
+}           
 
 $Output = '';
@@ -73 +99 @@
     else if($_GET['action'] == 'testing') $Output .= Testing();
     else if($_GET['action'] == 'phpinfo') $Output .= ShowPHPInfo();
+    else if($_GET['action'] == 'uncomplete') $Output .= Uncomplete();
     else $Output .= ShowMenu();
   } else $Output .= ShowMenu();