[Admin]

Ok, this is a bit more complicated.

In email.php (admin folder), add this:

    if ($location!="") {
      $condition.=" AND INSTR(field2,'".addslashes($location)."')>0";
    }

after this:

    if ($usertitle!="") {
      $condition.=" AND INSTR(usertitle,'".addslashes($usertitle)."')>0";
    }

(Note: this appears *twice*)

Now replace this:

	$counter = $DB_site->query_first("SELECT COUNT(*) AS total FROM user WHERE $condition AND adminemail=1");

with this:

	$counter = $DB_site->query_first("SELECT COUNT(*) AS total FROM user,userfield WHERE user.userid=userfield.userid AND $condition AND adminemail=1");

Also replace this:

		$users=$DB_site->query("SELECT userid,usergroupid,username,email,joindate FROM user WHERE $condition AND adminemail=1 ORDER BY userid DESC LIMIT $startat,$perpage");

with this:

		$users=$DB_site->query("SELECT userid,usergroupid,username,email,joindate FROM user,userfield WHERE user.userid=userfield.userid AND $condition AND adminemail=1 ORDER BY userid DESC LIMIT $startat,$perpage");

Now, add this:

	    makehiddencode("homepage",$homepage);

after this:

	    makehiddencode("location",$location);

Also add this:

  makeinputcode("and location contains","location");

after this:
[code] makeinputcode("and homepage contains","homepage");
(Note: this appears *twice*)

And lastly replace this:

  $users=$DB_site->query("SELECT email FROM user WHERE $condition AND adminemail=1");

with this:

  $users=$DB_site->query("SELECT email FROM user,userfield WHERE user.userid=userfield.userid AND $condition AND adminemail=1");

That's it I think.