HYGEN Blog

OSCommerce Password Encryption

January 2nd, 2009 | by admin |

To integrate OSCommerce to an existing web application you will need to know how to add passwords to the OSCommerce customers database.  You can use the function below to encrypt the passwords in a compatible manner…

function tep_encrypt_password($plain) {
$password = ”;

for ($i=0; $i<10; $i++) {
$password .= tep_rand();
}

$salt = substr(md5($password), 0, 2);

$password = md5($salt . $plain) . ‘:’ . $salt;

return $password;
}

You will also need this function -

function tep_rand($min = null, $max = null) {
static $seeded;
if (!isset($seeded)) {
mt_srand((double)microtime()*1000000);
$seeded = true;
}
if (isset($min) && isset($max)) {
if ($min >= $max) {
return $min;
}else{
return mt_rand($min, $max);
}
}else{
return mt_rand();
}
}

Looking at the customers table you can see what other data you need to save when users register at your site…

mysql> describe customers;
+——————————+————-+——+—–+———————
+—————-+
| Field                        | Type        | Null | Key | Default
| Extra          |
+——————————+————-+——+—–+———————
+—————-+
| customers_id                 | int(11)     | NO   | PRI | NULL
| auto_increment |
| customers_gender             | char(1)     | NO   |     |
|                |
| customers_firstname          | varchar(32) | NO   |     |
|                |
| customers_lastname           | varchar(32) | NO   |     |
|                |
| customers_dob                | datetime    | NO   |     | 0000-00-00 00:00:00
|                |
| customers_email_address      | varchar(96) | NO   | MUL |
|                |
| customers_default_address_id | int(11)     | YES  |     | NULL
|                |
| customers_telephone          | varchar(32) | NO   |     |
|                |
| customers_fax                | varchar(32) | YES  |     | NULL
|                |
| customers_password           | varchar(40) | NO   |     |
|                |
| customers_newsletter         | char(1)     | YES  |     | NULL
|                |
+——————————+————-+——+—–+———————
+—————-+
11 rows in set (0.00 sec)