<?php

include "db.php";

$query = "SELECT * FROM users WHERE type = 'Staff' AND password > '' AND password IS NOT NULL AND password_crypt = ''";
$staff = db_query($query);

while ($row = db_fetch_assoc($staff)) {
   extract($row);

   $password_crypt = encrypt_password($password);
   // echo("$userid - $password - $password_crypt\n");
   db_query("UPDATE users SET password_crypt = '".db_escape_string($password_crypt)."' WHERE record_num = $record_num");
}

?>