/** * Check to see if we can authenticate this user with a remote server * A user has not managed to login localy, but has an @ in their user * name and we have enabled distributed authentication. Firstly, try to * see if we have cached the module that we used to authenticate them * when they signed up (i.e. they've actualy changed their password * elsewhere and we need to synch.) If not, then try to authenticate * them with /every/ authentication module. If this suceeds, create * a user for them. * * @param string $loginname Their username * @param string $passwd The password entered * @param string $service The service portion of $username * @param string $uid OUTPUT parameter, pass it by ref to get uid back. * @return int user status, -1 for fail. */ function SEC_remoteAuthentication(&$loginname, $passwd, $service, &$uid) { global $_CONF, $_TABLES; /* First try a local cached login */ $remoteusername = DB_escapeString($loginname); $remoteservice = DB_escapeString($service); $result = DB_query("SELECT passwd, status, uid FROM {$_TABLES['users']} WHERE remoteusername='******' AND remoteservice='{$remoteservice}'"); $tmp = DB_error(); $nrows = DB_numRows($result); if ($tmp == 0 && $nrows == 1) { $U = DB_fetchArray($result); $uid = $U['uid']; $mypass = $U['passwd']; // also used to see if the user existed later. if ($mypass == SEC_encryptPassword($passwd)) { /* Valid password for cached user, return status */ return $U['status']; } } $service = COM_sanitizeFilename($service); $servicefile = $_CONF['path_system'] . 'classes/authentication/' . $service . '.auth.class.php'; if (file_exists($servicefile)) { require_once $servicefile; $authmodule = new $service(); if ($authmodule->authenticate($loginname, $passwd)) { /* check to see if they have logged in before: */ if (empty($mypass)) { // no such user, create them // Check to see if their remoteusername is unique locally $checkName = DB_getItem($_TABLES['users'], 'username', "username='******'"); if (!empty($checkName)) { // no, call custom function. if (function_exists('CUSTOM_uniqueRemoteUsername')) { $loginname = CUSTOM_uniqueRemoteUsername($loginname, $service); } } USER_createAccount($loginname, $authmodule->email, $passwd, $authmodule->fullname, $authmodule->homepage, $remoteusername, $remoteservice); $uid = DB_getItem($_TABLES['users'], 'uid', "remoteusername = '******' AND remoteservice='{$remoteservice}'"); // Store full remote account name: DB_query("UPDATE {$_TABLES['users']} SET remoteusername='******', remoteservice='{$remoteservice}', status=3 WHERE uid='{$uid}'"); // Add to remote users: $remote_grp = DB_getItem($_TABLES['groups'], 'grp_id', "grp_name='Remote Users'"); DB_query("INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,ug_uid) VALUES ({$remote_grp}, {$uid})"); return 3; // Remote auth precludes usersubmission, // and integrates user activation, see? } else { // user existed, update local password: DB_change($_TABLES['users'], 'passwd', SEC_encryptPassword($passwd), array('remoteusername', 'remoteservice'), array($remoteusername, $remoteservice)); // and return their status return DB_getItem($_TABLES['users'], 'status', "remoteusername='******' AND remoteservice='{$remoteservice}'"); } } else { return -1; } } else { return -1; } }
public function doAction($info) { global $_TABLES, $LANG04, $status, $uid, $_CONF, $checkMerge; $users = $this->_getCreateUserInfo($info); $userinfo = $this->_getUpdateUserInfo($info); $sql = "SELECT uid,status FROM {$_TABLES['users']} WHERE remoteusername = '******'remoteusername']) . "' AND remoteservice = '" . DB_escapeString($users['remoteservice']) . "'"; $result = DB_query($sql); $tmp = DB_error(); $nrows = DB_numRows($result); if (empty($tmp) && $nrows == 1) { // existing user... list($uid, $status) = DB_fetchArray($result); $checkMerge = false; } else { if ($_CONF['disable_new_user_registration']) { echo COM_siteHeader(); echo $LANG04[122]; echo COM_siteFooter(); exit; } // initial login - create account $loginname = $users['loginname']; $checkName = DB_getItem($_TABLES['users'], 'username', "username='******'"); if (!empty($checkName)) { if (function_exists('CUSTOM_uniqueRemoteUsername')) { $loginname = CUSTOM_uniqueRemoteUsername(loginname, $remoteservice); } if (strcasecmp($checkName, $loginname) == 0) { $loginname = USER_uniqueUsername($loginname); } } $users['loginname'] = $loginname; $uid = USER_createAccount($users['loginname'], $users['email'], '', $users['fullname'], $users['homepage'], $users['remoteusername'], $users['remoteservice']); if (is_array($users)) { $this->_DBupdate_users($uid, $users); } if (is_array($userinfo)) { $this->_DBupdate_userinfo($uid, $userinfo); } $status = DB_getItem($_TABLES['users'], 'status', 'uid=' . (int) $uid); $remote_grp = DB_getItem($_TABLES['groups'], 'grp_id', "grp_name = 'Remote Users'"); DB_query("INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid) VALUES ({$remote_grp}, {$uid})"); if (isset($users['socialuser'])) { $social_result = DB_query("SELECT * FROM {$_TABLES['social_follow_services']} WHERE service_name='" . DB_escapeString($users['socialservice']) . "' AND enabled=1"); if (DB_numRows($social_result) > 0) { $social_row = DB_fetchArray($social_result); $sql = "REPLACE INTO {$_TABLES['social_follow_user']} (ssid,uid,ss_username) "; $sql .= " VALUES (" . (int) $social_row['ssid'] . "," . $uid . ",'" . $users['socialuser'] . "');"; DB_query($sql, 1); } } if (isset($users['email']) && $users['email'] != '') { $sql = "SELECT * FROM {$_TABLES['users']} WHERE account_type = " . LOCAL_USER . " AND email='" . DB_escapeString($users['email']) . "' AND uid > 1"; $result = DB_query($sql); $numRows = DB_numRows($result); if ($numRows == 1) { $row = DB_fetchArray($result); $remoteUID = $uid; $localUID = $row['uid']; USER_mergeAccountScreen($remoteUID, $localUID); } } } }
public function doAction($info) { global $_TABLES, $status, $uid, $_CONF; // COM_errorLog("doAction() method ------------------"); // remote auth precludes usersubmission, and integrates user activation $status = USER_ACCOUNT_ACTIVE; $users = $this->_getCreateUserInfo($info); $userinfo = $this->_getUpdateUserInfo($info); $passwords = USER_createPassword(); $users['passwd2'] = $passwords['encrypted']; $sql = "SELECT uid,status FROM {$_TABLES['users']} WHERE remoteusername = '******'remoteusername']}' AND remoteservice = '{$users['remoteservice']}'"; // COM_errorLog("sql={$sql}"); $result = DB_query($sql); $tmp = DB_error(); // COM_errorLog("DB_error={$tmp}"); $nrows = DB_numRows($result); // COM_errorLog("DB_numRows={$nrows}"); if (empty($tmp) && $nrows == 1) { list($uid, $status) = DB_fetchArray($result); // COM_errorLog("user found! uid={$uid} status={$status}"); } else { // COM_errorLog("user not found - creating new account"); // initial login - create account $status = USER_ACCOUNT_ACTIVE; // COM_errorLog("checking remoteuser login name for uniqueness"); $checkName = DB_getItem($_TABLES['users'], 'username', "username='******'loginname']}'"); if (!empty($checkName)) { if ($checkName == $users['loginname']) { if (function_exists('CUSTOM_uniqueRemoteUsername')) { // COM_errorLog("CUSTOM_uniqueRemoteUserName function exists, calling it"); $users['loginname'] = CUSTOM_uniqueRemoteUsername($users['loginname'], $users['remoteservice']); } else { // COM_errorLog("loginname is not unique, using USER_uniqueUsername() to create one"); $users['loginname'] = USER_uniqueUsername($users['loginname']); } } } $uid = USER_createAccount($users['loginname'], $users['email'], $users['passwd2'], $users['fullname'], $users['homepage'], $users['remoteusername'], $users['remoteservice']); // COM_errorLog("after creation, uid={$uid}"); // COM_errorLog("updating users[]"); if (is_array($users)) { $this->_DBupdate_users($uid, $users); } // COM_errorLog("updating userinfo[]"); if (is_array($userinfo)) { $this->_DBupdate_userinfo($uid, $userinfo); } // COM_errorLog("adding uid={$uid} to Remote Users group"); $remote_grp = DB_getItem($_TABLES['groups'], 'grp_id', "grp_name = 'Remote Users'"); DB_query("INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid) VALUES ({$remote_grp}, {$uid})"); // usercreate after trigger if (method_exists($this, '_after_trigger')) { $this->_after_trigger($uid, $users, $userinfo); } } }
public function doAction($info) { global $_TABLES, $status, $uid, $_CONF; // remote auth precludes usersubmission, and integrates user activation $status = USER_ACCOUNT_ACTIVE; $users = $this->_getCreateUserInfo($info); $userinfo = $this->_getUpdateUserInfo($info); $sql = "SELECT uid,status FROM {$_TABLES['users']} WHERE remoteusername = '******'remoteusername']) . "' AND remoteservice = '" . DB_escapeString($users['remoteservice']) . "'"; $result = DB_query($sql); $tmp = DB_error(); $nrows = DB_numRows($result); if (empty($tmp) && $nrows == 1) { list($uid, $status) = DB_fetchArray($result); } else { // initial login - create account $status = USER_ACCOUNT_ACTIVE; $loginname = $users['loginname']; $checkName = DB_getItem($_TABLES['users'], 'username', "username='******'"); if (!empty($checkName)) { if (function_exists('CUSTOM_uniqueRemoteUsername')) { $loginname = CUSTOM_uniqueRemoteUsername(loginname, $remoteservice); } if (strcasecmp($checkName, $loginname) == 0) { $loginname = USER_uniqueUsername($loginname); } } $users['loginname'] = $loginname; $uid = USER_createAccount($users['loginname'], $users['email'], '', $users['fullname'], $users['homepage'], $users['remoteusername'], $users['remoteservice']); if (is_array($users)) { $this->_DBupdate_users($uid, $users); } if (is_array($userinfo)) { $this->_DBupdate_userinfo($uid, $userinfo); } $remote_grp = DB_getItem($_TABLES['groups'], 'grp_id', "grp_name = 'Remote Users'"); DB_query("INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id, ug_uid) VALUES ({$remote_grp}, {$uid})"); } }