UBB.threads PHP Forum Software Community Forums Resources and Customizing How Do I? Avatar in a custom island

$query = "
	SELECT t1.USER_DISPLAY_NAME,t1.USER_ID,t2.USER_NAME_COLOR,t1.USER_MEMBERSHIP_LEVEL,t2.USER_AVATAR,t1.USER_REGISTERED_ON,t2.USER_TOTAL_POSTS,t2.USER_AVATAR_WIDTH,t2.USER_AVATAR_HEIGHT
	FROM   {$config['TABLE_PREFIX']}USERS as t1,
		   {$config['TABLE_PREFIX']}USER_PROFILE as t2,
		   {$config['TABLE_PREFIX']}USER_DATA as t3
	WHERE  t1.USER_ID = t2.USER_ID
	AND	   t1.USER_ID = t3.USER_ID
	AND    t1.USER_IS_BANNED != '1'
	AND	   t1.USER_ID > 1
	$thisclause
	ORDER BY rand() limit 1 
";