[r188]: createPasswords / trunk / createPasswords.php Maximize Restore History

Download this file

createPasswords.php    65 lines (46 with data), 2.1 kB

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
<?php
## Copyright 2007 Kyle Hall
## This file is part of koha-tools.
## koha-tools is free software; you can redistribute it and/or modify
## it under the terms of the GNU General Public License as published by
## the Free Software Foundation; either version 2 of the License, or
## (at your option) any later version.
## koha-tools is distributed in the hope that it will be useful,
## but WITHOUT ANY WARRANTY; without even the implied warranty of
## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
## GNU General Public License for more details.
## You should have received a copy of the GNU General Public License
## along with koha-tools; if not, write to the Free Software
## Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
/**
* Creates a default login and password for all borrowers who do not have one yet.
* The login and password are set to the borrowers cardnumber, but this script
* could be modified easily to change the login and password to other things.
* @package koha-tools
* @subpackage createPasswords
* @author Kyle Hall
* @copyright 2007
*/
ini_set("memory_limit", "256M");
require_once("classes/MySQLConnectionFactory.class.php");
$mysql = MySQLConnectionFactory::create();
$query = 'SELECT cardnumber FROM borrowers WHERE password IS NULL';
$patronData = array();
if ( $result = mysql_query( $query ) ) {
/* fetch associative array */
while ( $row = mysql_fetch_assoc($result) ) {
$cardnumber = $row['cardnumber'];
$userid = $cardnumber;
$password = md5_base64( $cardnumber );
$query = "UPDATE borrowers SET password = '" . mysql_escape_string($password) . "', userid = '$userid' WHERE cardnumber = '$cardnumber'";
$rows = mysql_query( $query );
echo $rows . " rows affected.\nCardnumber $cardnumber\n";
}
} else {
printf("Connect failed: %s\n", mysql_error() );
}
function md5_base64 ( $data ) {
return rtrim( base64_encode( pack( "H*", md5( $data ) ) ), "=" );
# return preg_replace( '/=+$/', '', base64_encode( pack( 'H*', md5( $data ) ) ) );
}
?>