Changeset 516 for trunk

Timestamp:

Feb 16, 2013, 10:20:41 PM (12 years ago)

Author:

chronos

Message:

• Opraveno: Zobrazení statistiky dokončení.
• Opraveno: V aktualizaci databáze před nastavením cizích klíčů se musí smazat neplatné vazby.

Location:

trunk

Files:

• admin/UpdateTrace.php (modified) (1 diff)
• statistic.php (modified) (1 diff)

trunk/admin/UpdateTrace.php

@@ -2379 +2379 @@
     $Manager->Execute('UPDATE `'.$Group['TablePrefix'].'` SET `Take` = NULL WHERE `Take` =0;');
     $Manager->Execute('ALTER TABLE `'.$Group['TablePrefix'].'` CHANGE `ID` `ID` INT( 11 ) NOT NULL AUTO_INCREMENT; ');
+    $Manager->Execute('UPDATE `'.$Group['TablePrefix'].'` SET `Take` = NULL WHERE NOT EXISTS (SELECT `Id` FROM ('.
+        'SELECT `Id` FROM `'.$Group['TablePrefix'].'` ) AS `T` WHERE `T`.`Id` = `'.$Group['TablePrefix'].
+        '`.`Take` ) AND `Take` IS NOT NULL');
     $Manager->Execute('ALTER TABLE `'.$Group['TablePrefix'].'` ADD FOREIGN KEY ( `Take` ) REFERENCES `'.$Group['TablePrefix'].'` ('.
       '`ID`) ON DELETE RESTRICT ON UPDATE RESTRICT ;');

trunk/statistic.php

@@ -10 +10 @@
 function ShowStatTable()
 {
-  global $System;
+  global $System, $User;
   
   $Output = '';