Changeset 607 for trunk

Timestamp:

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

Author:

maron

Message:

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

Location:

trunk

Files:

• admin/index.php (modified) (3 diffs)
• includes/Version.php (modified) (1 diff)

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();  

trunk/includes/Version.php

@@ -6 +6 @@
 // and system will need database update. 
 
-$Revision = 605; // Subversion revision
+$Revision = 607; // Subversion revision
 $DatabaseRevision = 604; // Database structure revision 
-$ReleaseTime = '2013-11-25';
+$ReleaseTime = '2013-11-26';