Changeset 353 for trunk/admin.php

Timestamp:

Mar 3, 2010, 1:42:04 PM (15 years ago)

Author:

george

Message:

• Opraveno: U exportů v tabulce výpisu překladatelů také používat přímo sloupec počtu překladů TranslatedCount.
• Opraveno: Nemazat překladatele, kteří mají vytvořen nějaký export.

File:

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

trunk/admin.php

@@ -37 +37 @@
     ' AND (`ID` != 128)'. // Skip user Neznámý
     ' AND (`LastLogin` < DATE_SUB(NOW(), INTERVAL 3 MONTH))'. // Time limit
-    ' AND (NOT EXISTS (SELECT `ID` FROM `dictionary` WHERE `user`.`ID` = `dictionary`.`user`))'. // dictionary
-    ' AND (NOT EXISTS (SELECT `Id` FROM `news` WHERE `user`.`ID` = `news`.`user`))'. // news
-    ' AND (NOT EXISTS (SELECT `ID` FROM `shoutbox` WHERE `user`.`user` = `shoutbox`.`user`))'. // shoutbox
+    ' AND (NOT EXISTS (SELECT `Id` FROM `Export` WHERE `user`.`ID` = `Export`.`User`))'. // Without exports
+    ' AND (NOT EXISTS (SELECT `ID` FROM `dictionary` WHERE `user`.`ID` = `dictionary`.`user`))'. // Without dictionary words
+    ' AND (NOT EXISTS (SELECT `Id` FROM `news` WHERE `user`.`ID` = `news`.`user`))'. // Without news
+    ' AND (NOT EXISTS (SELECT `ID` FROM `shoutbox` WHERE `user`.`user` = `shoutbox`.`user`))'. // Without shoutbox messages
     '';
   $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `user`'.$Condition);