Password encryption on UNA

Thank you Leonid, that answers my question however I was trying to find the function call for this in PHP where user registers and logs in, so they can verify user name / password. Registration involves calling this function to store the password in tables and login involves comparing the passwords. That's what I'm trying to find in the code, which is actually called as the code executes. 

Same code I can use in my other website to perform registration and login functionality, so I can make UNA as main website. 

Thank you Alex, Well I tried to create the user using below query when users are signing up from other website and insert the records in UNA sys accounts table. When they sign up on other website, the same record is updated in UNA table(s), so I can use it to verify their login, when they login to UNA in future. 

$query = "insert into sys_accounts (name, email, password, salt) values ('$full_name', '$email', SHA1(CONCAT(MD5('$password'), '$salt')), '$salt')";
After executing this query, record gets updated in sys_accounts table successfully. But when I try to verify the login on UNA website, it fails. Reason could be that 
I didn't update all required values like added, logged, profile_id etc in sys_accounts and some other values in other tables (which I don't know).
So I'd like to know, to which function I should pass these four values in UNA, so it updates all required tables and default values, which we don't pass 
while creating new registration? Or what values should be updated in which tables to create a new registered user, so we can verify them using default UNA login functionality. 

Reposting as I see the message text was out of view boundary (which could be another bug).

Thank you Alex, Well I tried to create the user using below query when users are signing up from other website and insert the records in UNA sys accounts table. When they sign up on other website, the same record is updated in UNA table(s), so I can use it to verify their login, when they login to UNA in future. 

$query = "insert into sys_accounts (name, email, password, salt) 
values ('$full_name', '$email', SHA1(CONCAT(MD5('$password'), '$salt')), '$salt')";
After executing this query, record gets updated in sys_accounts table successfully. 
But when I try to verify the login on UNA website, it fails. Reason could be that 
I didn't update all required values like added, logged, profile_id etc in sys_accounts and some other values 
in other tables (which I don't know).
So I'd like to know, to which function I should pass these four values in UNA, so it updates all required tables and 
default values, which I'm not passing while creating new registration? 
Or what values should be updated in which tables to create a new registered user, so we can verify them using 
default UNA login functionality. 

Hello, any help in finding query or function calls, which creates profile and related login info into required tables? I'm stuck here as of now. 

I understand it now. However I was not able to find the query or code / function call, which inserts data in all these three tables. E.g. When we register profile, we use 4 fields, Account Name, email, password and newsletters. Somewhere in code UNA might be passing these parameters to a function... which automatically call other functions and executes the queries. So I wanted to call the same function and pass these parameters, coming from other website to UNA, so rest of the things happen smoothly. I'm not PHP programmer, the guy who is working on it, is beginner in PHP too, so we would appreciate spoon feeding to get started. 

Ok, great, that explains everything, as a novice we were confused by the code.  

So once the login is successful, which cookie or session ID is used to maintain session for further communication? 

Ok great after understanding the code a bit more, I think you guys are beyond Awesome :)

Here is another one now. On each successful login action, I'd like to update a unique website name value in sys_accounts table in the same row against user name and password, this would be useful to identify which website this profile belongs to and whether certain actions need to be taken for that particular user depending on the value. This value is being passed as hidden field from login form and I have added column for this value too.

I'd like to know what would be best way to update this new hidden value from login form in sys_accounts table after user is verified? Is there any other place too, where I need to perform this action?

Here is what I had in mind, please check the bold statement : 

/**
* Check if user is logged in (necessary cookies are present) and set some global variables
*/
function check_logged()
{
$aAccTypes = array(
BX_DOL_ROLE_ADMIN => 'admin',
BX_DOL_ROLE_MEMBER => 'member'
);

$sID = isset($_COOKIE['memberID']) ? bx_process_input($_COOKIE['memberID']) : false;
$sPassword = isset($_COOKIE['memberPassword']) ? bx_process_input($_COOKIE['memberPassword']) : false;

$bLogged = false;
foreach ($aAccTypes as $iRole => $sValue) {
if ($GLOBALS['logged'][$sValue] = ($sID && !bx_check_login($sID, $sPassword, $iRole))) {
$bLogged = true;

// Update website value here in sys_accounts table... (My question is, can I access $iWebsite, which is hidden value in sys-form-login form and run update query here something like update sys_accounts with $iWebsite value where UserID = $sID?)

break;
}
}

if ((isset($_COOKIE['memberID']) || isset($_COOKIE['memberPassword'])) && !$bLogged)
bx_logout(false);
}

Thank you Leonid. This is awesome and explanation is very clear, I would have never figured this out for long as I'm from Java background and just started in PHP. 

Will try this and post more, if I get into any issue.