diff -u -r -N karmapools.orig/admin/includes/admin.app.functions.php karmapools/admin/includes/admin.app.functions.php
--- karmapools.orig/admin/includes/admin.app.functions.php	2004-09-13 20:42:52.000000000 -0500
+++ karmapools/admin/includes/admin.app.functions.php	2004-09-14 00:29:30.043577064 -0500
@@ -156,7 +156,7 @@
 /*****************************************************************************
  *
  *****************************************************************************/
-function queryUsers($start='0',$order='un',$search='',$searchfield='') {
+function queryUsers($start='0',$order='un',$search='',$field='') {
 
 if (!is_numeric($start)) { return false; }
 
@@ -171,10 +171,10 @@
 
 $where      = '';
 $wherefield = '';
-if (!empty($search) and !empty($searchfield)) {
-	$search      = addslashes($search);
-	$searchfield = addslashes($searchfield);
-	switch ($searchfield) {
+if (!empty($search) and !empty($field)) {
+	$search = addslashes($search);
+	$field  = addslashes($field);
+	switch ($field) {
 		case "un": $wherefield = 'user_name';  break;
 		case "ue": $wherefield = 'user_email'; break;
 		case "ip": $wherefield = 'user_ip';    break;
@@ -183,7 +183,12 @@
 		case "au": $wherefield = 'user_audit'; break;
 		}
 	if (!empty($wherefield)) {
-		$where = "where $wherefield='$searchtext'";
+		$pos = strpos($search,"%");
+		if ($pos === false) {
+			$where = "where $wherefield='$search'";
+			} else {
+			$where = "where $wherefield like '$search'";
+			}
 		}
 	}
 
diff -u -r -N karmapools.orig/admin/includes/admin.html.functions.php karmapools/admin/includes/admin.html.functions.php
--- karmapools.orig/admin/includes/admin.html.functions.php	2004-09-13 20:40:43.000000000 -0500
+++ karmapools/admin/includes/admin.html.functions.php	2004-09-14 01:28:47.755722608 -0500
@@ -9,6 +9,31 @@
 /*****************************************************************************
  *
  *****************************************************************************/
+function displaySearchUserList($echo=true,$order='',$search='',$field='') {
+
+$html  = "<form name=\"user_list\" method=\"post\" action=\"./\">\n";
+$html .= "<input type=\"hidden\" name=\"a\" value=\"";
+$html .= LIST_USER_QS . "\">\n";
+if (isset($order) and !empty($order)) {
+	$html .= "<input type=\"hidden\" name=\"o\" value=\"$order\">\n";
+	}
+$html .= "Search&nbsp;" . selectUserListField(false,$field) . "&nbsp";
+$html .= "&nbsp;For:&nbsp;";
+if (isset($search) and !empty($search)) {
+	$html .= "<input type=\"text\" name=\"q\" value=\"$search\" ";
+	$html .= "size=\"20\" maxlength=\"50\">\n";
+	} else {
+	$html .= "<input type=\"text\" name=\"q\" size=\"20\" maxlength=\"50\">";
+	}
+$html .= "</form>\n";
+
+if ($echo) { echo $html; } else { return $html; }
+
+}
+
+/*****************************************************************************
+ *
+ *****************************************************************************/
 function displayUserList($echo=true,$qid='') {
 
 if ($qid == '') { return false; }
@@ -53,4 +78,152 @@
 
 }
 
+/*****************************************************************************
+ *
+ *****************************************************************************/
+function displayUserListHeader($echo=true,$order='',$search='',$field='') {
+
+$qs = '';
+if (isset($search) and !empty($search)) {
+	$qs .= "&q=" . urlencode($search);
+	}
+if (isset($field) and !empty($field)) {
+	$qs .= "&f=" . urlencode($field);
+	}
+
+
+$text = "<a class=\"header\" href=\"./?a=" . LIST_USER_QS . $qs . "&o=";
+$o_userid = $text . "un\">Userid</a>";
+$o_email  = $text . "ue\">Email</a>";
+$o_ip     = $text . "ip\">IP</a>";
+$o_ua     = $text . "ua\">User Agent</a>";
+$o_access = $text . "ul\">Access</a>";
+$o_audit  = $text . "au\">Audit</a>";
+
+$html = "	<tr>
+		<td class=\"header\">$o_userid</td>
+		<td class=\"header\">$o_email</td>
+		<td class=\"header\">$o_ip</td>
+		<td class=\"header\">$o_ua</td>
+		<td class=\"header\">$o_access</td>
+		<td class=\"header\">$o_audit</td>
+		<td class=\"header\">&nbsp;</td>
+	</tr>\n";
+
+if ($echo) { echo $html; } else { return $html; }
+
+}
+
+/*****************************************************************************
+ *                                                                           *
+ *****************************************************************************/
+function displayUserListIndex($echo=true,$page='',$hits='',$field='',
+						$txt='') {
+
+if ($page == '' or $hits == '' ) { return false; }
+
+$num_pages = ceil($hits / MAX_ROWS);
+if ($num_pages < 2) {
+	$html = "&nbsp;";
+	if ($echo) { echo $html; return true; } else { return $html; }
+	}
+if ( ! $txt == '') {
+	$qt = urlencode($txt);
+	$search = true;
+	} else {
+	$search = false;
+	}
+if ( $field !== '') { $field = urlencode($field); }
+
+$prev_page = $page - 1;
+$next_page = $page + 1;
+
+$html = "<font size=\"-2\">Page $page of $num_pages</font>&nbsp;&nbsp;";
+
+if ($prev_page > 0) {
+	$p_url     = "./?a=" . LIST_USER_QS . "&p=$prev_page";
+	if ($search) { $p_url .= "&q=$qt";    }
+	if ($field)  { $p_url .= "&f=$field"; }
+	$prev_url  = "<a class=\"info\" href=\"$p_url\">";
+	$prev_url .= "&lt;</a>&nbsp;";
+	} else {
+	$prev_url  = "&lt;&nbsp;";
+	}
+
+if ($next_page <= $num_pages) {
+	$n_url     = "./?a=" . LIST_USER_QS . "&p=$next_page";
+	if ($search) { $n_url .= "&q=$qt";    }
+	if ($field)  { $n_url .= "&f=$field"; }
+	$next_url  = "<a class=\"info\" href=\"$n_url\">&gt;</a>&nbsp;";
+	} else {
+	$next_url  = "&gt;&nbsp;";
+	}
+$html .= $prev_url;
+$maxbf    = 10;
+$max_back = $page - $maxbf;
+$max_forw = $page + $maxbf;
+if ($max_back < 1) {
+	$diff = abs($max_back) + 1;
+	$max_back = ($max_back + $diff);
+	$max_forw = $max_forw + $diff;
+	}
+if (($max_forw > $num_pages) and ($num_pages > $maxbf)) {
+	$diff     = $num_pages - $max_forw;
+	$max_back = $max_back + $diff;
+	$max_forw = $num_pages;
+	}
+if ($max_forw > $num_pages) { $max_forw = $num_pages; }
+// pad numbers so they don't jump around on the page list
+$max_len = strlen($num_pages);
+
+for ($j=$max_back; $j <= $max_forw; $j++ ) {
+	$nurl = "./?a=" . LIST_USER_QS . "&p=$j";
+	if ($search) { $nurl .= "&q=$qt";    }
+	if ($field)  { $nurl .= "&f=$field"; }
+	$num_text = str_pad("$j",$max_len,"0",STR_PAD_LEFT);
+	if ("$j" !== "$page") {
+		$html .= "<a class=\"info\" href=\"$nurl\"><font size=\"-2\">";
+		$html .= "$num_text</font></a>&nbsp;";
+		} else {
+		$html .= "<u><font size=\"-2\">$num_text</font></u>&nbsp;";
+		}
+	}
+
+$html .= $next_url;
+
+if ($echo) { echo $html; } else { return $html; }
+
+}
+
+/*****************************************************************************
+ *
+ *****************************************************************************/
+function selectUserListField($echo=true,$default='') {
+
+$tmp_ar   = array();
+$tmp_ar[] = array("un","Userid");
+$tmp_ar[] = array("ue","Email");
+$tmp_ar[] = array("ip","IP");
+$tmp_ar[] = array("ua","User Agent");
+$tmp_ar[] = array("ul","Access");
+$tmp_ar[] = array("au","Audit");
+
+$html = "<select name=\"f\">\n";
+foreach($tmp_ar as $foo) {
+	$fv    = $foo[0];
+	$fn    = $foo[1];
+	if ("$default" == "$fv") {
+		$option = "option selected";
+		} else {
+		$option = "option";
+		}
+	$html .= "<$option value=\"$fv\">$fn\n";
+	}
+$html .= "</select>\n";
+
+if ($echo) { echo $html; } else { return $html; }
+
+
+}
+ 
 ?>
diff -u -r -N karmapools.orig/admin/user.list.php karmapools/admin/user.list.php
--- karmapools.orig/admin/user.list.php	2004-09-13 20:42:33.000000000 -0500
+++ karmapools/admin/user.list.php	2004-09-14 01:02:04.841402624 -0500
@@ -7,25 +7,23 @@
 if (basename($PHP_SELF) == basename(__FILE__)) { die("Access Denied"); }
 $cols       = 7;
 $title      = DEFAULT_SITE_TITLE . "::Admin Menu::List Users";
-$back_qs    = INCPREFIX;
 $back_img   = "<img src=\"" . INCPREFIX . "images/left.png\" border=\"0\">";
-$back_href  = "<a class=\"footer\" href=\"$back_qs\">$back_img</a>";
+$back_href  = "<a class=\"footer\" href=\"./\">$back_img</a>";
 
-$text       = "<a class=\"header\" href=\"./?a=" . LIST_USER_QS . "&o=";
-$o_userid   = $text . "un\">Userid</a>";
-$o_email    = $text . "ue\">Email</a>";
-$o_ip       = $text . "ip\">IP</a>";
-$o_ua       = $text . "ua\">User Agent</a>";
-$o_access   = $text . "ul\">Access</a>";
-$o_audit    = $text . "au\">Audit</a>";
-
-$q_ar = queryUsers(0,$o);
+// set up pagination
+if (!isset($p) or empty($p)) { $page = 1; } else { $page = $p; }
+$tmp_page = $page - 1;
+if ($tmp_page > 0) {
+	$start = $tmp_page * MAX_ROWS;
+	} else {
+	$start = 0;
+	}
+$q_ar = queryUsers($start,$o,$q,$f);
 if (is_array($q_ar)) {
 	$total_hits = $q_ar['total_hits'];
 	$qid        = $q_ar['qid'];
 	$hits       = db_num_rows($qid);
 	}
-
 pageHeader(true,$title); tableOpen(true,array('width'=>'100%'));
 ?>
 	<tr class="title">
@@ -33,16 +31,22 @@
 			<? echo $title; ?>
 		</td>
 	</tr>
-	<tr>
-		<td class="header"><? echo $o_userid; ?></td>
-		<td class="header"><? echo $o_email; ?></td>
-		<td class="header"><? echo $o_ip; ?></td>
-		<td class="header"><? echo $o_ua; ?></td>
-		<td class="header"><? echo $o_access; ?></td>
-		<td class="header"><? echo $o_audit; ?></td>
-		<td class="header">&nbsp;</td>
+	<tr class="info">
+		<td colspan="<? echo $cols; ?>" align="right">
+			<? displaySearchUserList(true,"$o","$q","$f"); ?>
+		</td>
+	</tr>
+<?
+displayUserListHeader(true,$o,$q,$f);
+displayUserList(true,$qid);
+if ($total_hits > MAX_ROWS) {
+?>
+	<tr class="info">
+		<td align="right" colspan="<? echo $cols; ?>">
+			<? displayUserListIndex(true,$page,$total_hits,$f,$q); ?>
+		</td>
 	</tr>
-	<? displayUserList(true,$qid); ?>
+<? } ?>
 	<tr class="footer">
 		<td colspan="<? echo $cols; ?>" align="left">
 			<? echo $back_href; ?>
diff -u -r -N karmapools.orig/docs/ChangeLog karmapools/docs/ChangeLog
--- karmapools.orig/docs/ChangeLog	2004-09-13 21:00:36.000000000 -0500
+++ karmapools/docs/ChangeLog	2004-09-14 01:33:12.282508424 -0500
@@ -4,6 +4,15 @@
 
 *karmapools-0.0.4 (13 Sep 2004)
 
+  14 Sep 2004; Mike Green <mikey@badpenguins.com> docs/ChangeLog,
+  admin/includes/admin.app.functions.php, admin.html.functions.php,
+  admin/user.list.php, docs/date_pools.sql, patch-0.0.4-04:
+  
+  Added pagination code to user list.  Dropped unique column on email
+  address since it is not required.  Blank addresses result in duplicate
+  matches, preventing more than one person from registering without an
+  email address.
+
   13 Sep 2004; Mike Green <mikey@badpenguins.com> docs/ChangeLog,
   includes/html.functions.php, patch-0.0.4-03:
   
diff -u -r -N karmapools.orig/docs/date_pools.sql karmapools/docs/date_pools.sql
--- karmapools.orig/docs/date_pools.sql	2004-09-13 09:36:45.000000000 -0500
+++ karmapools/docs/date_pools.sql	2004-09-14 01:14:25.998729584 -0500
@@ -48,7 +48,6 @@
   user_level varchar(5) NOT NULL default 'user',
   user_audit tinyint(1) unsigned NOT NULL default '0',
   PRIMARY KEY  (user_id),
-  UNIQUE KEY user_name (user_name),
-  UNIQUE KEY user_email (user_email)
+  UNIQUE KEY user_name (user_name)
 ) TYPE=MyISAM;