[geeklog-cvs] geeklog-1.3/system lib-user.php,1.3,1.4

[dhaun at iowaoutdoors.org]

Update of /var/cvs/geeklog-1.3/system
In directory www:/tmp/cvs-serv9828/system

Modified Files:
	lib-user.php 
Log Message:
Minor optimization: added a LIMIT 1 when searching for a Root user.


Index: lib-user.php
===================================================================
RCS file: /var/cvs/geeklog-1.3/system/lib-user.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** lib-user.php	15 May 2004 13:02:21 -0000	1.3
--- lib-user.php	27 Jul 2004 07:33:57 -0000	1.4
***************
*** 132,136 ****
      // them to the Root user with the lowest uid
      $rootgroup = DB_getItem ($_TABLES['groups'], 'grp_id', "grp_name = 'Root'");
!     $result = DB_query ("SELECT DISTINCT ug_uid FROM {$_TABLES['group_assignments']} WHERE ug_main_grp_id = $rootgroup ORDER BY ug_uid");
      $A = DB_fetchArray ($result);
      $rootuser = $A['ug_uid'];
--- 132,136 ----
      // them to the Root user with the lowest uid
      $rootgroup = DB_getItem ($_TABLES['groups'], 'grp_id', "grp_name = 'Root'");
!     $result = DB_query ("SELECT DISTINCT ug_uid FROM {$_TABLES['group_assignments']} WHERE ug_main_grp_id = $rootgroup ORDER BY ug_uid LIMIT 1");
      $A = DB_fetchArray ($result);
      $rootuser = $A['ug_uid'];