View | Details | Raw Unified | Return to bug 8753
Collapse All | Expand All

(-)a/C4/Passwordrecovery.pm (-1 / +1 lines)
Lines 164-170 sub SendPasswordRecoveryEmail { Link Here
164
164
165
=head2 CompletePasswordRecovery
165
=head2 CompletePasswordRecovery
166
166
167
    $bool = CompletePasswordRevovery($uuid);
167
    $bool = CompletePasswordRecovery($uuid);
168
168
169
    Deletes a password recovery entry.
169
    Deletes a password recovery entry.
170
170
(-)a/Koha/Schema/Result/BorrowerPasswordRecovery.pm (-3 / +14 lines)
Lines 57-68 __PACKAGE__->add_columns( Link Here
57
  },
57
  },
58
);
58
);
59
59
60
=head1 PRIMARY KEY
60
61
61
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-11-03 12:08:20
62
=over 4
62
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ORAWxUHIkefSfPSqrcfeXA
63
63
64
=item * L</borrowernumber>
65
66
=back
67
68
=cut
64
69
65
# You can replace this text with custom code or comments, and it will be preserved on regeneration
66
__PACKAGE__->set_primary_key("borrowernumber");
70
__PACKAGE__->set_primary_key("borrowernumber");
67
71
72
73
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2016-01-22 10:16:52
74
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:c4ehAGqOD6YHpGg85BX8YQ
75
76
77
# You can replace this text with custom code or comments, and it will be preserved on regeneration
78
68
1;
79
1;
(-)a/installer/data/mysql/atomicupdate/bug_8753-Add_forgot_password_link_to_OPAC.sql (-1 / +2 lines)
Lines 5-12 CREATE TABLE IF NOT EXISTS borrower_password_recovery ( Link Here
5
  borrowernumber int(11) NOT NULL,
5
  borrowernumber int(11) NOT NULL,
6
  uuid varchar(128) NOT NULL,
6
  uuid varchar(128) NOT NULL,
7
  valid_until timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
7
  valid_until timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
8
  PRIMARY KEY (borrowernumber),
8
  KEY borrowernumber (borrowernumber)
9
  KEY borrowernumber (borrowernumber)
9
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
10
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
10
11
11
INSERT IGNORE INTO `letter` (module, code, branchcode, name, is_html, title, content, message_transport_type)
12
INSERT IGNORE INTO `letter` (module, code, branchcode, name, is_html, title, content, message_transport_type)
12
VALUES ('members','PASSWORD_RESET','','Online password reset',1,'Koha password recovery','<html>\r\n<p>This email has been sent in response to your password recovery request for the account <strong><<user>></strong>.\r\n</p>\r\n<p>\r\nYou can now create your new password using the following link:\r\n<br/><a href=\"<<passwordreseturl>>\"><<passwordreseturl>></a>\r\n</p>\r\n<p>This link will be valid for 2 days from this email\'s reception, then you must reapply if you do not change your password.</p>\r\n<p>Thank you.</p>\r\n</html>\r\n','email');
13
VALUES ('members','PASSWORD_RESET','','Online password reset',1,'Koha password recovery','<html>\r\n<p>This email has been sent in response to your password recovery request for the account <strong><<user>></strong>.\r\n</p>\r\n<p>\r\nYou can now create your new password using the following link:\r\n<br/><a href=\"<<passwordreseturl>>\"><<passwordreseturl>></a>\r\n</p>\r\n<p>This link will be valid for 2 days from this email\'s reception, then you must reapply if you do not change your password.</p>\r\n<p>Thank you.</p>\r\n</html>\r\n','email');
(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
Lines 365-372 CREATE TABLE IF NOT EXISTS `borrower_password_recovery` ( -- holds information a Link Here
365
  `borrowernumber` int(11) NOT NULL, -- the user asking a password recovery
365
  `borrowernumber` int(11) NOT NULL, -- the user asking a password recovery
366
  `uuid` varchar(128) NOT NULL, -- a unique string to identify a password recovery attempt
366
  `uuid` varchar(128) NOT NULL, -- a unique string to identify a password recovery attempt
367
  `valid_until` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, -- a time limit on the password recovery attempt
367
  `valid_until` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, -- a time limit on the password recovery attempt
368
  PRIMARY KEY (`borrowernumber`),
368
  KEY borrowernumber (borrowernumber)
369
  KEY borrowernumber (borrowernumber)
369
) ENGINE=InnoDB DEFAULT CHARSET=utf8
370
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
370
371
371
--
372
--
372
-- Table structure for table borrower_sync
373
-- Table structure for table borrower_sync
(-)a/opac/opac-password-recovery.pl (-2 lines)
Lines 1-6 Link Here
1
#!/usr/bin/perl
1
#!/usr/bin/perl
2
2
3
use strict;
4
use Modern::Perl;
3
use Modern::Perl;
5
use CGI;
4
use CGI;
6
5
7
- 

Return to bug 8753