By whizy on

Greetings,

I'm in the process of migrating my homemade CMS to Drupal and am stumped by the password discrepancy between the two databases. The password field from my original site is generated from the generic SQL statement below:

INSERT INTO users (password) VALUES (password('$p'));

The statement yields a hashed 16-character value in the SQL table cell, whereas the password field in the drupal users table contains a 32-character value. Upon instituing the Drupal system, I'd like to mitigate the environmental shock of my existing users in the database by keeping the login system unchanged; specifically pertaining to their username and password. Any words of wisdom as to how I can better accomplish this task would be greatly appreciated. Thanks.

Curiously,

CS

PS: I could simply migrate the system and ask the members to re-register their password, but this is a possibility I'd like to reserve as a last resort.