Changeset 714

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.

Location:

trunk

Files:

• Modules/User/User.php (modified) (1 diff)
• includes/Version.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())
                 {

trunk/includes/Version.php

@@ -6 +6 @@
 // and system will need database update. 
 
-$Revision = 713; // Subversion revision
+$Revision = 714; // Subversion revision
 $DatabaseRevision = 712; // Database structure revision 
 $ReleaseTime = '2014-01-05';