/**
* Find a user by userid.
*
* @param int $userid The userid to look up
* @return UserRecord The matching user record or null if none
*/
static function getUser($userid)
{
$db = new DatabaseConnection();
$record = $db->getSingleRow("SELECT a.*,u.*,a.id AS userid FROM users a LEFT JOIN userdata u ON a.id=u.id WHERE a.id=%d", $userid);
if ($record) {
$u = new UserRecord();
$u->assign($record);
return $u;
}
return null;
}
