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

(-)a/installer/data/mysql/atomicupdate/bug_25090-add_STAFF_VER_OPAC_REG_and_SELF_REG_APPROVED_notices.perl (+51 lines)
Line 0 Link Here
1
$DBversion = 'XXX';  # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do(q{
4
        INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'STAFF_VER_OPAC_REG', 'New patron Opac Self-Registration to verify', 'Verify new Opac patron self registration', '<h3>Opac self registration pending verification</h3>
5
<p><h4>Submitted Opac patron self registration:<h4>
6
    <ul>
7
    <li><<borrower_modifications.cardnumber>></li>
8
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
9
    <li>Physical address: <<borrower_modifications.streetnumber>> <<borrower_modifications.streettype>> <<borrower_modifications.address>> <<borrower_modifications.address2>>, <<borrower_modifications.city>>, <<borrower_modifications.state>> <<borrower_modifications.zipcode>>, <<borrower_modifications.country>></li>
10
    <li>Email: <<borrower_modifications.email>></li>
11
    <li>Phone: <<borrower_modifications.phone>></li>
12
    <li>Mobile: <<borrower_modifications.mobile>></li>
13
    <li>Fax: <<borrower_modifications.fax>></li>
14
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
15
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
16
    <li>Home library: <<borrower_modifications.branchcode>></li>
17
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
18
    </ul>
19
    </p>
20
    <p>
21
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
22
    </p>
23
    <p>
24
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
25
    </p>
26
    <p>
27
    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
28
    </p>
29
    </p>', 1, 'email')
30
    });
31
32
    $dbh->do(q{
33
        INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
34
    <p>Before we can create your library account two things need to happen:
35
    <br>1. You verify your email address - To do this please click this link:<br>
36
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
37
    <br>2. A librarian will review your registration and if approved you will receive an email containing a link to the Koha password reset page where you can set a Koha password.
38
    </p>
39
    <p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>', 1, 'email')
40
    });
41
42
    $dbh->do(q{
43
        INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '<h3>Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:</h3>
44
    <p>
45
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
46
    </p>', 1, 'email')
47
    });
48
49
    SetVersion( $DBversion );
50
    print "Upgrade to $DBversion done (Bug 25090 - Choose to send OPAC self registration verification emails to the library and/or patron allowing libraries to moderate which registrations get Koha accounts)\n";
51
}
(-)a/installer/data/mysql/de-DE/mandatory/sample_notices.sql (+35 lines)
Lines 386-388 INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, Link Here
386
    </tr>
386
    </tr>
387
</tfoot>
387
</tfoot>
388
</table>', 'print', 'default');
388
</table>', 'print', 'default');
389
390
INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'STAFF_VER_OPAC_REG', 'New patron Opac Self-Registration to verify', 'Verify new Opac patron self registration', '<h3>Opac self registration pending verification</h3>
391
<p><h4>Submitted Opac patron self registration:<h4>
392
    <ul>
393
    <li><<borrower_modifications.cardnumber>></li>
394
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
395
    <li>Physical address: <<borrower_modifications.streetnumber>> <<borrower_modifications.streettype>> <<borrower_modifications.address>> <<borrower_modifications.address2>>, <<borrower_modifications.city>>, <<borrower_modifications.state>> <<borrower_modifications.zipcode>>, <<borrower_modifications.country>></li>
396
    <li>Email: <<borrower_modifications.email>></li>
397
    <li>Phone: <<borrower_modifications.phone>></li>
398
    <li>Mobile: <<borrower_modifications.mobile>></li>
399
    <li>Fax: <<borrower_modifications.fax>></li>
400
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
401
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
402
    <li>Home library: <<borrower_modifications.branchcode>></li>
403
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
404
    </ul>
405
    </p>
406
    <p>
407
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
408
    <p>
409
    <p>
410
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
411
    </p>
412
    <p>
413
    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
414
    </p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
415
    <p>Before we can create your library account two things need to happen:
416
    <br>1. You verify your email address - To do this please click this link:<br>
417
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
418
    <br>2. A librarian will review your registration and if approved you will receive an email containing a link to the Koha password reset page where you can set a Koha password.
419
    </p>
420
    <p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '<h3>Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:</h3>
421
    <p>
422
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
423
    </p>', 1, 'email');
(-)a/installer/data/mysql/en/mandatory/sample_notices.yml (+65 lines)
Lines 734-739 tables: Link Here
734
            - "<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>"
734
            - "<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>"
735
            - ""
735
            - ""
736
            - "If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly."
736
            - "If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly."
737
        - module: members
738
          code: PATRON_AND_LIB_VER
739
          branchcode: ""
740
          name: "Opac Self-Registration Verify Your Email"
741
          is_html: 1
742
          title: "Verify your entered OPAC Self registration email address"
743
          message_transport_type: email
744
          lang: default
745
          content:
746
            - "Hello!"
747
            - ""
748
            - "<p>Before we can create your library account two things need to happen:"
749
            - "<br>1. You verify your email address - To do this please click this link:<br>"
750
            - "<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>"
751
            - "<br>2. A librarian will review your registration and if approved you will receive an email containing a link to the Koha password reset page where you can set a Koha password."
752
            - "</p>"
753
            - "<p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>"
754
755
        - module: members
756
          code: STAFF_VER_OPAC_REG
757
          branchode: ""
758
          name: "New patron Opac Self-Registration to verify"
759
          is_html: 1
760
          title: "Verify new Opac patron self registration"
761
          message_transport_type: email
762
          lang: default
763
          content:
764
              - "<h3>Opac self registration pending verification</h3>"
765
              - "<p><h4>Submitted Opac patron self registration:<h4>"
766
              - "<ul>"
767
              - "<li><<borrower_modifications.cardnumber>></li>"
768
              - "<li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>"
769
              - "<li>Physical address: <<borrower_modifications.streetnumber>> <<borrower_modifications.streettype>> <<borrower_modifications.address>> <<borrower_modifications.address2>>, <<borrower_modifications.city>>, <<borrower_modifications.state>> <<borrower_modifications.zipcode>>, <<borrower_modifications.country>></li>"
770
              - "<li>Email: <<borrower_modifications.email>></li>"
771
              - "<li>Phone: <<borrower_modifications.phone>></li>"
772
              - "<li>Mobile: <<borrower_modifications.mobile>></li>"
773
              - "<li>Fax: <<borrower_modifications.fax>></li>"
774
              - "<li>Secondary email: <<borrower_modifications.emailpro>></li>"
775
              - "<li>Secondary phone:<<borrower_modifications.phonepro>></li>"
776
              - "<li>Home library: <<borrower_modifications.branchcode>></li>"
777
              - "<li>Temporary patron category: <<borrower_modifications.categorycode>></li>"
778
              - "</ul>"
779
              - "</p>"
780
              - "<p>"
781
              - "If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:"
782
              - "<p>"
783
              - "<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1"
784
              - "</p>"
785
              - "If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly."
786
              - "</p>"
787
788
        - module: members
789
          code: SELF_REG_APPROVED
790
          branchcode: ""
791
          name: "Self registration approved"
792
          is_html: 1
793
          title: "Your self registration has been approved"
794
          message_transport_type: email
795
          lang: default
796
          content:
797
            - "<html>"
798
            - "<h3>Please click the password reset link below to reset your Koha password then you'll be able to login to the OPAC:</h3>"
799
            - "<p>"
800
            - "<<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>"
801
            - "</p>"
737
802
738
        - module: members
803
        - module: members
739
          code: PASSWORD_RESET
804
          code: PASSWORD_RESET
(-)a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql (+36 lines)
Lines 268-270 INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, Link Here
268
    </tr>
268
    </tr>
269
</tfoot>
269
</tfoot>
270
</table>', 'print', 'default');
270
</table>', 'print', 'default');
271
272
273
INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'STAFF_VER_OPAC_REG', 'New patron Opac Self-Registration to verify', 'Verify new Opac patron self registration', '<h3>Opac self registration pending verification</h3>
274
<p><h4>Submitted Opac patron self registration:<h4>
275
    <ul>
276
    <li><<borrower_modifications.cardnumber>></li>
277
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
278
    <li>Physical address: <<borrower_modifications.streetnumber>> <<borrower_modifications.streettype>> <<borrower_modifications.address>> <<borrower_modifications.address2>>, <<borrower_modifications.city>>, <<borrower_modifications.state>> <<borrower_modifications.zipcode>>, <<borrower_modifications.country>></li>
279
    <li>Email: <<borrower_modifications.email>></li>
280
    <li>Phone: <<borrower_modifications.phone>></li>
281
    <li>Mobile: <<borrower_modifications.mobile>></li>
282
    <li>Fax: <<borrower_modifications.fax>></li>
283
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
284
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
285
    <li>Home library: <<borrower_modifications.branchcode>></li>
286
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
287
    </ul>
288
    </p>
289
    <p>
290
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
291
    <p>
292
    <p>
293
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
294
    </p>
295
    <p>
296
    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
297
    </s>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
298
    <p>Before we can create your library account two things need to happen:
299
    <br>1. You verify your email address - To do this please click this link:<br>
300
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
301
    <br>2. A librarian will review your registration and if approved you will receive an email containing a link to the Koha password reset page where you can set a Koha password.
302
    </p>
303
    <p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '<h3>Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:</h3>
304
    <p>
305
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
306
    </p>', 1, 'email');
(-)a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql (+35 lines)
Lines 379-381 INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, Link Here
379
    </tr>
379
    </tr>
380
</tfoot>
380
</tfoot>
381
</table>', 'print', 'default');
381
</table>', 'print', 'default');
382
383
INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'STAFF_VER_OPAC_REG', 'New patron Opac Self-Registration to verify', 'Verify new Opac patron self registration', '<h3>Opac self registration pending verification</h3>
384
<p><h4>Submitted Opac patron self registration:<h4>
385
    <ul>
386
    <li><<borrower_modifications.cardnumber>></li>
387
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
388
    <li>Physical address: <<borrower_modifications.streetnumber>> <<borrower_modifications.streettype>> <<borrower_modifications.address>> <<borrower_modifications.address2>>, <<borrower_modifications.city>>, <<borrower_modifications.state>> <<borrower_modifications.zipcode>>, <<borrower_modifications.country>></li>
389
    <li>Email: <<borrower_modifications.email>></li>
390
    <li>Phone: <<borrower_modifications.phone>></li>
391
    <li>Mobile: <<borrower_modifications.mobile>></li>
392
    <li>Fax: <<borrower_modifications.fax>></li>
393
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
394
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
395
    <li>Home library: <<borrower_modifications.branchcode>></li>
396
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
397
    </ul>
398
    </p>
399
    <p>
400
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
401
    <p>
402
    <p>
403
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
404
    </p>
405
    <p>
406
    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
407
    </p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
408
    <p>Before we can create your library account two things need to happen:
409
    <br>1. You verify your email address - To do this please click this link:<br>
410
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
411
    <br>2. A librarian will review your registration and if approved you will receive an email containing a link to the Koha password reset page where you can set a Koha password.
412
    </p>
413
    <p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '<h3>Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:</h3>
414
    <p>
415
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
416
    </p>', 1, 'email');
(-)a/installer/data/mysql/it-IT/necessari/notices.sql (+35 lines)
Lines 382-384 INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, Link Here
382
    </tr>
382
    </tr>
383
</tfoot>
383
</tfoot>
384
</table>', 'print', 'default');
384
</table>', 'print', 'default');
385
386
INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'STAFF_VER_OPAC_REG', 'New patron Opac Self-Registration to verify', 'Verify new Opac patron self registration', '<h3>Opac self registration pending verification</h3>
387
<p><h4>Submitted Opac patron self registration:<h4>
388
    <ul>
389
    <li><<borrower_modifications.cardnumber>></li>
390
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
391
    <li>Physical address: <<borrower_modifications.streetnumber>> <<borrower_modifications.streettype>> <<borrower_modifications.address>> <<borrower_modifications.address2>>, <<borrower_modifications.city>>, <<borrower_modifications.state>> <<borrower_modifications.zipcode>>, <<borrower_modifications.country>></li>
392
    <li>Email: <<borrower_modifications.email>></li>
393
    <li>Phone: <<borrower_modifications.phone>></li>
394
    <li>Mobile: <<borrower_modifications.mobile>></li>
395
    <li>Fax: <<borrower_modifications.fax>></li>
396
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
397
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
398
    <li>Home library: <<borrower_modifications.branchcode>></li>
399
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
400
    </ul>
401
    </p>
402
    <p>
403
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
404
    <p>
405
    <p>
406
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
407
    </p>
408
    <p>
409
    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
410
    </p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
411
    <p>Before we can create your library account two things need to happen:
412
    <br>1. You verify your email address - To do this please click this link:<br>
413
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
414
    <br>2. A librarian will review your registration and if approved you will receive an email containing a link to the Koha password reset page where you can set a Koha password.
415
    </p>
416
    <p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '<h3>Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:</h3>
417
    <p>
418
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
419
    </p>', 1, 'email');
(-)a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql (+36 lines)
Lines 398-400 INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, Link Here
398
    </tr>
398
    </tr>
399
</tfoot>
399
</tfoot>
400
</table>', 'print', 'default');
400
</table>', 'print', 'default');
401
402
403
INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'STAFF_VER_OPAC_REG', 'New patron Opac Self-Registration to verify', 'Verify new Opac patron self registration', '<h3>Opac self registration pending verification</h3>
404
<p><h4>Submitted Opac patron self registration:<h4>
405
    <ul>
406
    <li><<borrower_modifications.cardnumber>></li>
407
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
408
    <li>Physical address: <<borrower_modifications.streetnumber>> <<borrower_modifications.streettype>> <<borrower_modifications.address>> <<borrower_modifications.address2>>, <<borrower_modifications.city>>, <<borrower_modifications.state>> <<borrower_modifications.zipcode>>, <<borrower_modifications.country>></li>
409
    <li>Email: <<borrower_modifications.email>></li>
410
    <li>Phone: <<borrower_modifications.phone>></li>
411
    <li>Mobile: <<borrower_modifications.mobile>></li>
412
    <li>Fax: <<borrower_modifications.fax>></li>
413
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
414
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
415
    <li>Home library: <<borrower_modifications.branchcode>></li>
416
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
417
    </ul>
418
    </p>
419
    <p>
420
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
421
    <p>
422
    <p>
423
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
424
    </p>
425
    <p>
426
    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
427
    </p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
428
    <p>Before we can create your library account two things need to happen:
429
    <br>1. You verify your email address - To do this please click this link:<br>
430
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
431
    <br>2. A librarian will review your registration and if approved you will receive an email containing a link to the Koha password reset page where you can set a Koha password.
432
    </p>
433
    <p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '<h3>Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:</h3>
434
    <p>
435
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
436
    </p>', 1, 'email');
(-)a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql (+35 lines)
Lines 376-378 INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, Link Here
376
    </tr>
376
    </tr>
377
</tfoot>
377
</tfoot>
378
</table>', 'print', 'default');
378
</table>', 'print', 'default');
379
380
INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'STAFF_VER_OPAC_REG', 'New patron Opac Self-Registration to verify', 'Verify new Opac patron self registration', '<h3>Opac self registration pending verification</h3>
381
<p><h4>Submitted Opac patron self registration:<h4>
382
    <ul>
383
    <li><<borrower_modifications.cardnumber>></li>
384
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
385
    <li>Physical address: <<borrower_modifications.streetnumber>> <<borrower_modifications.streettype>> <<borrower_modifications.address>> <<borrower_modifications.address2>>, <<borrower_modifications.city>>, <<borrower_modifications.state>> <<borrower_modifications.zipcode>>, <<borrower_modifications.country>></li>
386
    <li>Email: <<borrower_modifications.email>></li>
387
    <li>Phone: <<borrower_modifications.phone>></li>
388
    <li>Mobile: <<borrower_modifications.mobile>></li>
389
    <li>Fax: <<borrower_modifications.fax>></li>
390
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
391
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
392
    <li>Home library: <<borrower_modifications.branchcode>></li>
393
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
394
    </ul>
395
    </p>
396
    <p>
397
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
398
    <p>
399
    <p>
400
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
401
    </p>
402
    <p>
403
    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
404
    </p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
405
    <p>Before we can create your library account two things need to happen:
406
    <br>1. You verify your email address - To do this please click this link:<br>
407
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
408
    <br>2. A librarian will review your registration and if approved you will receive an email containing a link to the Koha password reset page where you can set a Koha password.
409
    </p>
410
    <p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '<h3>Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:</h3>
411
    <p>
412
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
413
    </p>', 1, 'email');
(-)a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql (+35 lines)
Lines 378-380 INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, Link Here
378
    </tr>
378
    </tr>
379
</tfoot>
379
</tfoot>
380
</table>', 'print', 'default');
380
</table>', 'print', 'default');
381
382
INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'STAFF_VER_OPAC_REG', 'New patron Opac Self-Registration to verify', 'Verify new Opac patron self registration', '<h3>Opac self registration pending verification</h3>
383
<p><h4>Submitted Opac patron self registration:<h4>
384
    <ul>
385
    <li><<borrower_modifications.cardnumber>></li>
386
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
387
    <li>Physical address: <<borrower_modifications.streetnumber>> <<borrower_modifications.streettype>> <<borrower_modifications.address>> <<borrower_modifications.address2>>, <<borrower_modifications.city>>, <<borrower_modifications.state>> <<borrower_modifications.zipcode>>, <<borrower_modifications.country>></li>
388
    <li>Email: <<borrower_modifications.email>></li>
389
    <li>Phone: <<borrower_modifications.phone>></li>
390
    <li>Mobile: <<borrower_modifications.mobile>></li>
391
    <li>Fax: <<borrower_modifications.fax>></li>
392
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
393
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
394
    <li>Home library: <<borrower_modifications.branchcode>></li>
395
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
396
    </ul>
397
    </p>
398
    <p>
399
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
400
    <p>
401
    <p>
402
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
403
    </p>
404
    <p>
405
    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
406
    </p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
407
    <p>Before we can create your library account two things need to happen:
408
    <br>1. You verify your email address - To do this please click this link:<br>
409
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
410
    <br>2. A librarian will review your registration and if approved you will receive an email containing a link to the Koha password reset page where you can set a Koha password.
411
    </p>
412
    <p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '<h3>Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:</h3>
413
    <p>
414
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
415
    </p>', 1, 'email');
(-)a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql (-1 / +35 lines)
Lines 469-471 INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, Link Here
469
    </tr>
469
    </tr>
470
</tfoot>
470
</tfoot>
471
</table>', 'print', 'default');
471
</table>', 'print', 'default');
472
- 
472
473
INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'STAFF_VER_OPAC_REG', 'New patron Opac Self-Registration to verify', 'Verify new Opac patron self registration', '<h3>Opac self registration pending verification</h3>
474
<p><h4>Submitted Opac patron self registration:<h4>
475
    <ul>
476
    <li><<borrower_modifications.cardnumber>></li>
477
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
478
    <li>Physical address: <<borrower_modifications.streetnumber>> <<borrower_modifications.streettype>> <<borrower_modifications.address>> <<borrower_modifications.address2>>, <<borrower_modifications.city>>, <<borrower_modifications.state>> <<borrower_modifications.zipcode>>, <<borrower_modifications.country>></li>
479
    <li>Email: <<borrower_modifications.email>></li>
480
    <li>Phone: <<borrower_modifications.phone>></li>
481
    <li>Mobile: <<borrower_modifications.mobile>></li>
482
    <li>Fax: <<borrower_modifications.fax>></li>
483
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
484
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
485
    <li>Home library: <<borrower_modifications.branchcode>></li>
486
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
487
    </ul>
488
    </p>
489
    <p>
490
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
491
    <p>
492
    <p>
493
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
494
    </p>
495
    <p>
496
    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
497
    </p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
498
    <p>Before we can create your library account two things need to happen:
499
    <br>1. You verify your email address - To do this please click this link:<br>
500
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
501
    <br>2. A librarian will review your registration and if approved you will receive an email containing a link to the Koha password reset page where you can set a Koha password.
502
    </p>
503
    <p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '<h3>Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:</h3>
504
    <p>
505
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
506
    </p>', 1, 'email');

Return to bug 25090