<?php

include "db.php";
include "include/functions.php";
include "include/school-functions.php";

$query = "SELECT * FROM users WHERE password > '' AND (password_crypt IS NULL OR password_crypt = '')";
$query = "SELECT * FROM users WHERE password_crypt NOT LIKE '$1$ezssoftw%'";
$users = db_query($query);

while ($row = db_fetch_assoc($users)) {
   extract($row);
   // echo("$first_name $last_name - $type ($password)\n");

   $password_crypt = encrypt_password($password);

   $password_crypt = db_escape_string($password_crypt);
   if ($type == 'Parent' || $type == 'Guest') {
      $query = "UPDATE users SET password = '', password_crypt = '$password_crypt' WHERE record_num = $record_num";
   }
   else {
      $query = "UPDATE users SET password_crypt = '$password_crypt' WHERE record_num = $record_num";
   }
   db_query($query);
}

?>