Attachment 30850 Details for Bug 12371 – Bug 12371 - Links in every patron self-registration email points to a single borrower

[patch] Bug 12371 - Links in every patron self-registration email points to a single borrower

Bug-12371---Links-in-every-patron-self-registratio.patch (text/plain), 1.67 KB, created by Kyle M Hall (khall) on 2014-08-15 16:48:19 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2014-08-15 16:48:19 UTC

Size: 1.67 KB

patch

obsolete

>From e0159500b472f4c81716874d4a0a14dd0a879295 Mon Sep 17 00:00:00 2001
>From: Kyle M Hall <kyle@bywatersolutions.com>
>Date: Fri, 15 Aug 2014 12:45:44 -0400
>Subject: [PATCH] Bug 12371 - Links in every patron self-registration email points to a single borrower
>
>If multiple registrations are submitted, the first patron to register
>will be used for the first patron to click the registration confirmation
>link!
>
>Test Plan:
>1) Submit 2 new patron registrations
>2) Use the confirm link from the 2nd registration
>3) Note you end up registering as the first submitted registration
>4) Apply the patch
>5) Repeat steps 1 and 2
>6) Note you are now confirmed correctly
>---
> C4/Letters.pm |    2 +-
> 1 files changed, 1 insertions(+), 1 deletions(-)
>
>diff --git a/C4/Letters.pm b/C4/Letters.pm
>index 1d916e0..2ce2b78 100644
>--- a/C4/Letters.pm
>+++ b/C4/Letters.pm
>@@ -563,7 +563,7 @@ sub _parseletter_sth {
>     ($table eq 'aqbooksellers') ? "SELECT * FROM $table WHERE             id = ?"                                  :
>     ($table eq 'aqorders'     ) ? "SELECT * FROM $table WHERE    ordernumber = ?"                                  :
>     ($table eq 'opac_news'    ) ? "SELECT * FROM $table WHERE          idnew = ?"                                  :
>-    ($table eq 'borrower_modifications') ? "SELECT * FROM $table WHERE borrowernumber = ? OR verification_token =?":
>+    ($table eq 'borrower_modifications') ? "SELECT * FROM $table WHERE ( borrowernumber = 0 OR borrowernumber = ? ) AND ( verification_token = '' OR verification_token = ? ) AND ( verification_token != '' OR borrowernumber != 0 )" :
>     undef ;
>     unless ($query) {
>         warn "ERROR: No _parseletter_sth query for table '$table'";
>-- 
>1.7.2.5

Actions: View | Diff | Splinter Review

Attachments on bug 12371: 30850 | 30877 | 31037