snippet that returns user email from given userID

[[GetEmail? &userid=`[+view.internalKey+]`]]

<?php

/*

	usage [[GetEmail? &userid=`[+internalKeyPlaceholderOrValue+]`]]

	Returns users email from an internalKey

*/



$userid = isset($userid)? $userid : false;



function getEmail($id)

{

	global $modx;

	$id = intval($id);

	

	$table = $modx->getFullTableName(’web_user_attributes’);

	

	$sql = "SELECT email FROM $table WHERE internalKey = $id LIMIT 1";

	

	if($result = $modx->db->query($sql))

	{

		$row = $modx->db->getRow($result);

		return $row[’email’];

	}

	else

		return;//nothing found!!!		

}



if($userid)

	return getEmail($userid);

?>