Index: modules/affiliate/affiliate.module
===================================================================
RCS file: /c/Docume~1/bjaspan/Home/CVSROOT/drupal-4.6/modules/affiliate/affiliate.module,v
retrieving revision 1.1
diff -u -r1.1 affiliate.module
--- modules/affiliate/affiliate.module	8 Apr 2006 13:57:29 -0000	1.1
+++ modules/affiliate/affiliate.module	8 Apr 2006 13:58:28 -0000
@@ -148,9 +148,9 @@
       array('data' => t('last access'), 'field' => 'changed', 'sort' => 'desc'),
       array('data' => t('operations'))
     );
-  $sql = 'SELECT uid, u.name, u.status, u.changed FROM {users} u INNER JOIN {affiliates} a ON u.affiliate = a.aid WHERE affiliate = '. check_query($aid);
+  $sql = 'SELECT uid, u.name, u.status, u.changed FROM {users} u INNER JOIN {affiliates} a ON u.affiliate = a.aid WHERE affiliate = %d';
   $sql .= tablesort_sql($header);
-  $result = pager_query($sql, 50);
+  $result = pager_query($sql, 50, 0, NULL, $aid);
   $status = array(t('blocked'), t('active'));
   while ($row = db_fetch_object($result)) {
     $rows[] = array(