<?php
include "application.php";
 
if ($_REQUEST['c']) {
  ConvertMD5password();
}
else {
  print "<p>Do you want to convert user password to MD5? <br>
         Make sure that the password is not in MD5</p>
         <p><a href='convertmd5.php?c=yes'>Convert now</a></p>";
}
 
function ConvertMD5password(){
  global $dbConn;
 
  $result = $dbConn->Execute("select * from `idx_users` where length(password) <30");
  while (!$result->EOF) {
    $dbConn->Execute("UPDATE `idx_users` SET `password` = '".md5($result->Fields("password"))."' WHERE `username` = '".$result->Fields("username")."'");
    $result->MoveNext();
  }
 
  return true;
}
?>