Changeset 714 for trunk/Modules/User/User.php

Timestamp:

Jan 5, 2014, 4:47:51 PM (11 years ago)

Author:

chronos

Message:

• Fixed: If user is logged from multiple sites then show him only once in online user list.

File:

• trunk/Modules/User/User.php (modified) (1 diff)

trunk/Modules/User/User.php

@@ -42 +42 @@
         {
                 $Output = T('Online translators').':<br />';
-                $DbResult = $this->System->Database->query('SELECT `User`.`Name`, `User`.`ID` FROM `UserOnline` '.
+                $DbResult = $this->System->Database->query('SELECT * FROM ('. 
+'SELECT `User`.`Name`, `User`.`ID` FROM `UserOnline` '.
                                 'JOIN `User` ON `User`.`ID` = `UserOnline`.`User` '.
-                                'WHERE (`ActivityTime` >= NOW() - 300) ');
+                                'WHERE (`ActivityTime` >= NOW() - 300) '.
+                                'ORDER BY `ActivityTime` DESC ) AS `T` GROUP BY `Name`');
                 while($DbUser = $DbResult->fetch_assoc())
                 {