[Hwulex]

Fixed

In the MySQL query I had; SELECT * FROM user. And because of the JOIN to the avatar table, the userid field was ambiguous.

To fix the problem, find:

$users=$DB_site->query("
	SELECT *
	".iif($avatarenabled,",avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline","")."
	FROM user
	".iif ($avatarenabled,"LEFT JOIN avatar ON avatar.avatarid=user.avatarid
		LEFT JOIN customavatar ON customavatar.userid=user.userid","")."
	WHERE $condition
	".iif($memberAllGood, " AND usergroupid NOT IN (1,3,4) ", "")."
	ORDER BY $orderby $direction
	LIMIT ".($limitlower-1).",$limitupper
");

And replace it with:

$users=$DB_site->query("
	SELECT user.*
	".iif($avatarenabled,",avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline","")."
	FROM user
	".iif ($avatarenabled,"LEFT JOIN avatar ON avatar.avatarid=user.avatarid
		LEFT JOIN customavatar ON customavatar.userid=user.userid","")."
	WHERE $condition
	".iif($memberAllGood, " AND usergroupid NOT IN (1,3,4) ", "")."
	ORDER BY $orderby $direction
	LIMIT ".($limitlower-1).",$limitupper
");

The instructions and zip have been updated