Changeset 6399 for extensions/NBC_UserAdvManager/trunk/include

Timestamp:

May 27, 2010, 9:40:17 PM (14 years ago)

Author:

Eric

Message:

[NBC_UserAdvManager]

• Bug 1310 improved: Sorting work for multiple pages table.
• Adding tips on table sorting in languages help files.

File:

• extensions/NBC_UserAdvManager/trunk/include/functions.inc.php (modified) (3 diffs)

extensions/NBC_UserAdvManager/trunk/include/functions.inc.php

@@ -808 +808 @@
   }
   $query.= '
-ORDER BY id ASC
+ORDER BY ui.registration_date ASC
 ;';
 
@@ -873 +873 @@
     ON u.'.$conf['user_fields']['id'].' = lv.user_id
 WHERE (TO_DAYS(NOW()) - TO_DAYS(lv.lastvisit) >= "'.$conf_UAM[17].'")
-ORDER BY id ASC;';
+ORDER BY lv.lastvisit ASC;';
 
         $result = pwg_query($query);
@@ -913 +913 @@
     ON u.'.$conf['user_fields']['id'].' = ug.user_id
 WHERE u.'.$conf['user_fields']['id'].' >= 3
-ORDER BY lastvisit DESC
+ORDER BY ug.lastvisit DESC
 ;';