2 /************************************************************************/
4 /************************************************************************/
5 /* Copyright (c) 2002-2008 by Greg Gay, Joel Kronenberg, Heidi Hazelton */
8 /* This program is free software. You can redistribute it and/or */
9 /* modify it under the terms of the GNU General Public License */
10 /* as published by the Free Software Foundation. */
11 /************************************************************************/
14 define('AT_INCLUDE_PATH', '../../include/');
15 require (AT_INCLUDE_PATH.'vitals.inc.php');
17 print "Checking database<br><br>";
19 $sql = "SELECT member_id, first_name, last_name, password FROM ".TABLE_PREFIX."members";
20 $result = mysql_query($sql, $db);
22 while ($row = mysql_fetch_assoc($result))
24 if (strlen($row["password"]) < 40)
26 print "updating member ".$row["first_name"]." ".$row["last_name"].": from ".$row["password"]." to " .sha1($row["password"])."<br>";
27 $sql_update = "UPDATE ".TABLE_PREFIX."members set password = '".sha1($row["password"])."', creation_date = creation_date WHERE member_id=".$row["member_id"];
28 $result_update = mysql_query($sql_update, $db);