Changeset 354 for trunk/admin.php

Timestamp:

Mar 3, 2010, 2:02:57 PM (15 years ago)

Author:

george

Message:

• Opraveno: Mazat výběr smazaných překladatelů u exportů.

File:

• trunk/admin.php (modified) (1 diff)

trunk/admin.php

@@ -55 +55 @@
   echo('Smazáno '.$DbRow[0].' položek logu ze všech '.$DbRow2[0].'<br/>');     
       
+  // Delete invalid ExportUser
+  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `ExportUser`');
+  $DbRow2 = mysql_fetch_row($DbResult);
+  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `ExportUser` WHERE (NOT EXISTS (SELECT `Id` FROM `user` WHERE `user`.`ID` = `ExportUser`.`User`))');
+  $DbRow = mysql_fetch_row($DbResult);
+  $Database->SQLCommand('DELETE FROM `ExportUser` WHERE (NOT EXISTS (SELECT `Id` FROM `user` WHERE `user`.`ID` = `ExportUser`.`User`))');
+  echo('Smazáno '.$DbRow[0].' položek výběru překladatelů u exportů ze všech '.$DbRow2[0].'<br/>');     
+
   // Delete all teams without users
   $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `Team`');