Attachment #112495 for bug #25090

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




$DBversion = 'XXX';  # will be replaced by the RM
if( CheckVersion( $DBversion ) ) {
    $dbh->do(q{
        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>
<p><h4>Submitted Opac patron self registration:<h4>
    <ul>
    <li><<borrower_modifications.cardnumber>></li>
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
    <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>
    <li>Email: <<borrower_modifications.email>></li>
    <li>Phone: <<borrower_modifications.phone>></li>
    <li>Mobile: <<borrower_modifications.mobile>></li>
    <li>Fax: <<borrower_modifications.fax>></li>
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
    <li>Home library: <<borrower_modifications.branchcode>></li>
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
    </ul>
    </p>
    <p>
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
    </p>
    <p>
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
    </p>
    <p>
    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
    </p>
    </p>', 1, 'email')
    });

    $dbh->do(q{
        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!
    <p>Before we can create your library account two things need to happen:
    <br>1. You verify your email address - To do this please click this link:<br>
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
    <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.
    </p>
    <p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>', 1, 'email')
    });

    $dbh->do(q{
        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>
    <p>
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
    </p>', 1, 'email')
    });

    SetVersion( $DBversion );
    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";
}




            - "<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>"
            - ""
            - "If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly."
        - module: members
          code: PATRON_AND_LIB_VER
          branchcode: ""
          name: "Opac Self-Registration Verify Your Email"
          is_html: 1
          title: "Verify your entered OPAC Self registration email address"
          message_transport_type: email
          lang: default
          content:
            - "Hello!"
            - ""
            - "<p>Before we can create your library account two things need to happen:"
            - "<br>1. You verify your email address - To do this please click this link:<br>"
            - "<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>"
            - "<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."
            - "</p>"
            - "<p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>"

        - module: members
          code: STAFF_VER_OPAC_REG
          branchode: ""
          name: "New patron Opac Self-Registration to verify"
          is_html: 1
          title: "Verify new Opac patron self registration"
          message_transport_type: email
          lang: default
          content:
              - "<h3>Opac self registration pending verification</h3>"
              - "<p><h4>Submitted Opac patron self registration:<h4>"
              - "<ul>"
              - "<li><<borrower_modifications.cardnumber>></li>"
              - "<li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>"
              - "<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>"
              - "<li>Email: <<borrower_modifications.email>></li>"
              - "<li>Phone: <<borrower_modifications.phone>></li>"
              - "<li>Mobile: <<borrower_modifications.mobile>></li>"
              - "<li>Fax: <<borrower_modifications.fax>></li>"
              - "<li>Secondary email: <<borrower_modifications.emailpro>></li>"
              - "<li>Secondary phone:<<borrower_modifications.phonepro>></li>"
              - "<li>Home library: <<borrower_modifications.branchcode>></li>"
              - "<li>Temporary patron category: <<borrower_modifications.categorycode>></li>"
              - "</ul>"
              - "</p>"
              - "<p>"
              - "If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:"
              - "<p>"
              - "<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1"
              - "</p>"
              - "If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly."
              - "</p>"

        - module: members
          code: SELF_REG_APPROVED
          branchcode: ""
          name: "Self registration approved"
          is_html: 1
          title: "Your self registration has been approved"
          message_transport_type: email
          lang: default
          content:
            - "<html>"
            - "<h3>Please click the password reset link below to reset your Koha password then you'll be able to login to the OPAC:</h3>"
            - "<p>"
            - "<<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>"
            - "</p>"

        - module: members
          code: PASSWORD_RESET




[% END %]", 'email');

INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');

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>
<p><h4>Submitted Opac patron self registration:<h4>
    <ul>
    <li><<borrower_modifications.cardnumber>></li>
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
    <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>
    <li>Email: <<borrower_modifications.email>></li>
    <li>Phone: <<borrower_modifications.phone>></li>
    <li>Mobile: <<borrower_modifications.mobile>></li>
    <li>Fax: <<borrower_modifications.fax>></li>
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
    <li>Home library: <<borrower_modifications.branchcode>></li>
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
    </ul>
    </p>
    <p>
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
    <p>
    <p>
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
    </p>
    <p>
    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
    </s>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
    <p>Before we can create your library account two things need to happen:
    <br>1. You verify your email address - To do this please click this link:<br>
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
    <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.
    </p>
    <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>
    <p>
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
    </p>', 1, 'email');




[% END %]", 'email');

INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');

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>
<p><h4>Submitted Opac patron self registration:<h4>
    <ul>
    <li><<borrower_modifications.cardnumber>></li>
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
    <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>
    <li>Email: <<borrower_modifications.email>></li>
    <li>Phone: <<borrower_modifications.phone>></li>
    <li>Mobile: <<borrower_modifications.mobile>></li>
    <li>Fax: <<borrower_modifications.fax>></li>
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
    <li>Home library: <<borrower_modifications.branchcode>></li>
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
    </ul>
    </p>
    <p>
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
    <p>
    <p>
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
    </p>
    <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', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
    <p>Before we can create your library account two things need to happen:
    <br>1. You verify your email address - To do this please click this link:<br>
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
    <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.
    </p>
    <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>
    <p>
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
    </p>', 1, 'email');




[% END %]", 'email');

INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');

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>
<p><h4>Submitted Opac patron self registration:<h4>
    <ul>
    <li><<borrower_modifications.cardnumber>></li>
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
    <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>
    <li>Email: <<borrower_modifications.email>></li>
    <li>Phone: <<borrower_modifications.phone>></li>
    <li>Mobile: <<borrower_modifications.mobile>></li>
    <li>Fax: <<borrower_modifications.fax>></li>
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
    <li>Home library: <<borrower_modifications.branchcode>></li>
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
    </ul>
    </p>
    <p>
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
    <p>
    <p>
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
    </p>
    <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', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
    <p>Before we can create your library account two things need to happen:
    <br>1. You verify your email address - To do this please click this link:<br>
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
    <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.
    </p>
    <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>
    <p>
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
    </p>', 1, 'email');




[% END %]", 'email');

INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');

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>
<p><h4>Submitted Opac patron self registration:<h4>
    <ul>
    <li><<borrower_modifications.cardnumber>></li>
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
    <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>
    <li>Email: <<borrower_modifications.email>></li>
    <li>Phone: <<borrower_modifications.phone>></li>
    <li>Mobile: <<borrower_modifications.mobile>></li>
    <li>Fax: <<borrower_modifications.fax>></li>
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
    <li>Home library: <<borrower_modifications.branchcode>></li>
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
    </ul>
    </p>
    <p>
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
    <p>
    <p>
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
    </p>
    <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', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
    <p>Before we can create your library account two things need to happen:
    <br>1. You verify your email address - To do this please click this link:<br>
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
    <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.
    </p>
    <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>
    <p>
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
    </p>', 1, 'email');




[% END %]", 'email');

INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');

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>
<p><h4>Submitted Opac patron self registration:<h4>
    <ul>
    <li><<borrower_modifications.cardnumber>></li>
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
    <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>
    <li>Email: <<borrower_modifications.email>></li>
    <li>Phone: <<borrower_modifications.phone>></li>
    <li>Mobile: <<borrower_modifications.mobile>></li>
    <li>Fax: <<borrower_modifications.fax>></li>
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
    <li>Home library: <<borrower_modifications.branchcode>></li>
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
    </ul>
    </p>
    <p>
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
    <p>
    <p>
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
    </p>
    <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', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
    <p>Before we can create your library account two things need to happen:
    <br>1. You verify your email address - To do this please click this link:<br>
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
    <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.
    </p>
    <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>
    <p>
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
    </p>', 1, 'email');




[% END %]", 'email');

INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');

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>
<p><h4>Submitted Opac patron self registration:<h4>
    <ul>
    <li><<borrower_modifications.cardnumber>></li>
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
    <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>
    <li>Email: <<borrower_modifications.email>></li>
    <li>Phone: <<borrower_modifications.phone>></li>
    <li>Mobile: <<borrower_modifications.mobile>></li>
    <li>Fax: <<borrower_modifications.fax>></li>
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
    <li>Home library: <<borrower_modifications.branchcode>></li>
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
    </ul>
    </p>
    <p>
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
    <p>
    <p>
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
    </p>
    <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', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
    <p>Before we can create your library account two things need to happen:
    <br>1. You verify your email address - To do this please click this link:<br>
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
    <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.
    </p>
    <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>
    <p>
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
    </p>', 1, 'email');




[% END %]", 'email');

INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');

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>
<p><h4>Submitted Opac patron self registration:<h4>
    <ul>
    <li><<borrower_modifications.cardnumber>></li>
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
    <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>
    <li>Email: <<borrower_modifications.email>></li>
    <li>Phone: <<borrower_modifications.phone>></li>
    <li>Mobile: <<borrower_modifications.mobile>></li>
    <li>Fax: <<borrower_modifications.fax>></li>
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
    <li>Home library: <<borrower_modifications.branchcode>></li>
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
    </ul>
    </p>
    <p>
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
    <p>
    <p>
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
    </p>
    <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', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
    <p>Before we can create your library account two things need to happen:
    <br>1. You verify your email address - To do this please click this link:<br>
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
    <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.
    </p>
    <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>
    <p>
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
    </p>', 1, 'email');

Return to bug 25090

Lines 734-739 tables: Link Here

(-)a/installer/data/mysql/en/mandatory/sample_notices.yml (+65 lines)
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

Lines 291-293 The following item, [% biblio.title %], has correctly been renewed and is now du Link Here

(-)a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql (+35 lines)
291	[% END %]", 'email');	291	[% END %]", 'email');
292		292
293	INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');	293	INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
		294
		295	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>
		296	<p><h4>Submitted Opac patron self registration:<h4>
		297	<ul>
		298	<li><<borrower_modifications.cardnumber>></li>
		299	<li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
		300	<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>
		301	<li>Email: <<borrower_modifications.email>></li>
		302	<li>Phone: <<borrower_modifications.phone>></li>
		303	<li>Mobile: <<borrower_modifications.mobile>></li>
		304	<li>Fax: <<borrower_modifications.fax>></li>
		305	<li>Secondary email: <<borrower_modifications.emailpro>></li>
		306	<li>Secondary phone:<<borrower_modifications.phonepro>></li>
		307	<li>Home library: <<borrower_modifications.branchcode>></li>
		308	<li>Temporary patron category: <<borrower_modifications.categorycode>></li>
		309	</ul>
		310	</p>
		311	<p>
		312	If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
		313	<p>
		314	<p>
		315	<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
		316	</p>
		317	<p>
		318	If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
		319	</s>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
		320	<p>Before we can create your library account two things need to happen:
		321	<br>1. You verify your email address - To do this please click this link:<br>
		322	<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
		323	<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.
		324	</p>
		325	<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>
		326	<p>
		327	<<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
		328	</p>', 1, 'email');

Lines 402-404 The following item, [% biblio.title %], has correctly been renewed and is now du Link Here

(-)a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql (+35 lines)
402	[% END %]", 'email');	402	[% END %]", 'email');
403		403
404	INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');	404	INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
		405
		406	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>
		407	<p><h4>Submitted Opac patron self registration:<h4>
		408	<ul>
		409	<li><<borrower_modifications.cardnumber>></li>
		410	<li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
		411	<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>
		412	<li>Email: <<borrower_modifications.email>></li>
		413	<li>Phone: <<borrower_modifications.phone>></li>
		414	<li>Mobile: <<borrower_modifications.mobile>></li>
		415	<li>Fax: <<borrower_modifications.fax>></li>
		416	<li>Secondary email: <<borrower_modifications.emailpro>></li>
		417	<li>Secondary phone:<<borrower_modifications.phonepro>></li>
		418	<li>Home library: <<borrower_modifications.branchcode>></li>
		419	<li>Temporary patron category: <<borrower_modifications.categorycode>></li>
		420	</ul>
		421	</p>
		422	<p>
		423	If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
		424	<p>
		425	<p>
		426	<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
		427	</p>
		428	<p>
		429	If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
		430	</p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
		431	<p>Before we can create your library account two things need to happen:
		432	<br>1. You verify your email address - To do this please click this link:<br>
		433	<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
		434	<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.
		435	</p>
		436	<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>
		437	<p>
		438	<<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
		439	</p>', 1, 'email');

Lines 405-407 The following item, [% biblio.title %], has correctly been renewed and is now du Link Here

(-)a/installer/data/mysql/it-IT/necessari/notices.sql (+35 lines)
405	[% END %]", 'email');	405	[% END %]", 'email');
406		406
407	INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');	407	INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
		408
		409	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>
		410	<p><h4>Submitted Opac patron self registration:<h4>
		411	<ul>
		412	<li><<borrower_modifications.cardnumber>></li>
		413	<li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
		414	<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>
		415	<li>Email: <<borrower_modifications.email>></li>
		416	<li>Phone: <<borrower_modifications.phone>></li>
		417	<li>Mobile: <<borrower_modifications.mobile>></li>
		418	<li>Fax: <<borrower_modifications.fax>></li>
		419	<li>Secondary email: <<borrower_modifications.emailpro>></li>
		420	<li>Secondary phone:<<borrower_modifications.phonepro>></li>
		421	<li>Home library: <<borrower_modifications.branchcode>></li>
		422	<li>Temporary patron category: <<borrower_modifications.categorycode>></li>
		423	</ul>
		424	</p>
		425	<p>
		426	If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
		427	<p>
		428	<p>
		429	<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
		430	</p>
		431	<p>
		432	If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
		433	</p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
		434	<p>Before we can create your library account two things need to happen:
		435	<br>1. You verify your email address - To do this please click this link:<br>
		436	<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
		437	<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.
		438	</p>
		439	<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>
		440	<p>
		441	<<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
		442	</p>', 1, 'email');

Lines 420-422 The following item, [% biblio.title %], has correctly been renewed and is now du Link Here

(-)a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql (+35 lines)
420	[% END %]", 'email');	420	[% END %]", 'email');
421		421
422	INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');	422	INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
		423
		424	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>
		425	<p><h4>Submitted Opac patron self registration:<h4>
		426	<ul>
		427	<li><<borrower_modifications.cardnumber>></li>
		428	<li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
		429	<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>
		430	<li>Email: <<borrower_modifications.email>></li>
		431	<li>Phone: <<borrower_modifications.phone>></li>
		432	<li>Mobile: <<borrower_modifications.mobile>></li>
		433	<li>Fax: <<borrower_modifications.fax>></li>
		434	<li>Secondary email: <<borrower_modifications.emailpro>></li>
		435	<li>Secondary phone:<<borrower_modifications.phonepro>></li>
		436	<li>Home library: <<borrower_modifications.branchcode>></li>
		437	<li>Temporary patron category: <<borrower_modifications.categorycode>></li>
		438	</ul>
		439	</p>
		440	<p>
		441	If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
		442	<p>
		443	<p>
		444	<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
		445	</p>
		446	<p>
		447	If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
		448	</p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
		449	<p>Before we can create your library account two things need to happen:
		450	<br>1. You verify your email address - To do this please click this link:<br>
		451	<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
		452	<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.
		453	</p>
		454	<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>
		455	<p>
		456	<<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
		457	</p>', 1, 'email');

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_25090-add_STAFF_VER_OPAC_REG_and_SELF_REG_APPROVED_notices.perl (+51 lines)
	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	}

Lines 399-401 The following item, [% biblio.title %], has correctly been renewed and is now du Link Here

(-)a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql (+35 lines)
399	[% END %]", 'email');	399	[% END %]", 'email');
400		400
401	INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');	401	INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
		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');

Lines 401-403 The following item, [% biblio.title %], has correctly been renewed and is now du Link Here

(-)a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql (+35 lines)
401	[% END %]", 'email');	401	[% END %]", 'email');
402		402
403	INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');	403	INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
		404
		405	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>
		406	<p><h4>Submitted Opac patron self registration:<h4>
		407	<ul>
		408	<li><<borrower_modifications.cardnumber>></li>
		409	<li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
		410	<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>
		411	<li>Email: <<borrower_modifications.email>></li>
		412	<li>Phone: <<borrower_modifications.phone>></li>
		413	<li>Mobile: <<borrower_modifications.mobile>></li>
		414	<li>Fax: <<borrower_modifications.fax>></li>
		415	<li>Secondary email: <<borrower_modifications.emailpro>></li>
		416	<li>Secondary phone:<<borrower_modifications.phonepro>></li>
		417	<li>Home library: <<borrower_modifications.branchcode>></li>
		418	<li>Temporary patron category: <<borrower_modifications.categorycode>></li>
		419	</ul>
		420	</p>
		421	<p>
		422	If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
		423	<p>
		424	<p>
		425	<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
		426	</p>
		427	<p>
		428	If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
		429	</p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
		430	<p>Before we can create your library account two things need to happen:
		431	<br>1. You verify your email address - To do this please click this link:<br>
		432	<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
		433	<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.
		434	</p>
		435	<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>
		436	<p>
		437	<<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
		438	</p>', 1, 'email');

Lines 492-494 The following item, [% biblio.title %], has correctly been renewed and is now du Link Here

(-)a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql (-1 / +35 lines)
492	[% END %]", 'email');	492	[% END %]", 'email');
493		493
494	INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');	494	INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
495	-	495
		496	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>
		497	<p><h4>Submitted Opac patron self registration:<h4>
		498	<ul>
		499	<li><<borrower_modifications.cardnumber>></li>
		500	<li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
		501	<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>
		502	<li>Email: <<borrower_modifications.email>></li>
		503	<li>Phone: <<borrower_modifications.phone>></li>
		504	<li>Mobile: <<borrower_modifications.mobile>></li>
		505	<li>Fax: <<borrower_modifications.fax>></li>
		506	<li>Secondary email: <<borrower_modifications.emailpro>></li>
		507	<li>Secondary phone:<<borrower_modifications.phonepro>></li>
		508	<li>Home library: <<borrower_modifications.branchcode>></li>
		509	<li>Temporary patron category: <<borrower_modifications.categorycode>></li>
		510	</ul>
		511	</p>
		512	<p>
		513	If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
		514	<p>
		515	<p>
		516	<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
		517	</p>
		518	<p>
		519	If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
		520	</p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
		521	<p>Before we can create your library account two things need to happen:
		522	<br>1. You verify your email address - To do this please click this link:<br>
		523	<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
		524	<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.
		525	</p>
		526	<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>
		527	<p>
		528	<<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
		529	</p>', 1, 'email');