WOW!!! Very sorry for taking such a long time to respond and I want to thank you for trying to help so fast. I have searched hundreds of threads and searched many keywords...their search on this application is not as good as yours and they have pretty much no documentation. Below is what I found so far in regards to their application. Your software is so much easier to use and that is why I want to create separate forms using your software instead to interface with their database to confirm the user is log in as well as making a new log in form connecting to their database. Thanks in advance for any help.
The final field we require for this table is the password. It is split up into 2 fields:
password
password_salt
The field: password
holds a 32 character salted MD5 hashed version of their password. In order to get this value we use the following PHP code:
md5(md5($PASSWORD) . md5($SALT))
The variable: $PASSWORD
holds the users password. The variable:
$SALT
holds a random set of characters. The PHP function we use is:
function getSalt($iTotal = 3)
{
$sSalt = '';
for ($i = 0; $i < $iTotal; $i++)
{
$sSalt .= chr(rand(33, 91));
}
return $sSalt;
}
For the field: password_salt
we input the value for the salt we created earlier and used in the MD5 hash.