[geeklog-cvs] geeklog-1.3/public_html/admin user.php,1.82,1.83

[dhaun at iowaoutdoors.org]

Update of /var/cvs/geeklog-1.3/public_html/admin
In directory www:/tmp/cvs-serv12160

Modified Files:
	user.php 
Log Message:
Fixed SQL statement to count the number of users.


Index: user.php
===================================================================
RCS file: /var/cvs/geeklog-1.3/public_html/admin/user.php,v
retrieving revision 1.82
retrieving revision 1.83
diff -C2 -d -r1.82 -r1.83
*** user.php	15 Aug 2004 09:37:03 -0000	1.82
--- user.php	24 Sep 2004 10:27:06 -0000	1.83
***************
*** 436,443 ****
      $user_templates->set_var($limit . '_selected', 'selected="selected"');
      
!     if (!empty($query)) {
          $query = addslashes (str_replace ('*', '%', $query));
          $num_pages = ceil (DB_getItem ($_TABLES['users'], 'count(*)',
!                            "uid > 1 AND username LIKE '$query'") / $limit);
          if ($num_pages < $curpage) {
              $curpage = 1;
--- 436,443 ----
      $user_templates->set_var($limit . '_selected', 'selected="selected"');
      
!     if (!empty ($query)) {
          $query = addslashes (str_replace ('*', '%', $query));
          $num_pages = ceil (DB_getItem ($_TABLES['users'], 'count(*)',
!                 "uid > 1 AND (username LIKE '$query' OR email LIKE '$query' OR fullname LIKE '$query')") / $limit);
          if ($num_pages < $curpage) {
              $curpage = 1;
***************
*** 476,480 ****
          $user_templates->set_var('google_paging',COM_printPageNavigation($base_url,$curpage,$num_pages));
      } else {
!     $user_templates->set_var('google_paging', '');
      }
      $user_templates->parse('output', 'list');
--- 476,480 ----
          $user_templates->set_var('google_paging',COM_printPageNavigation($base_url,$curpage,$num_pages));
      } else {
!         $user_templates->set_var('google_paging', '');
      }
      $user_templates->parse('output', 'list');