[[!Login?
&loginTpl=`loginTpl`
&logoutTpl=`loginSuccess`
&errTpl=`loginErrTpl`
&loginResourceId=`13`
&logoutResourceId=`14`]]
[[!Register?
&submitVar=`registerbtn`
&usernameField=`email`
&activationEmailTpl=`lgnActivateEmailTpl`
&activationEmailSubject=`Благодарим за регистрацию!`
&activationResourceId=`16`
&usergroups=`Пользователи`
&preHooks=`captchaValidate`
&successMsg=`register_success`
&excludeExtended=`email:required:email,login-updprof-btn,phone:required,inn:required`
]]
<?php
$query = '"inn":"'.$inn.'"';
$c = $modx->newQuery('modUser');
$c->innerJoin ('modUserProfile','Profile');
$c->where(array('Profile.extended:LIKE' => '%'.$query.'%'));
$c->limit(1);
$c->prepare();
$c->stmt->execute();
$result = $c->stmt->fetchAll(PDO::FETCH_ASSOC);
return $result[0]['modUser_username'];if (is_numeric($fields['username']))
{
$snippet = $this->modx->newObject( 'modSnippet' );
$snippet->set( 'name', 'inn_email' );
$snippet->setContent( $fields['username'] );
$fields['username'] = $snippet;
}