Lines 7472-7482
if ( CheckVersion($DBversion) ) {
Link Here
|
7472 |
|); |
7472 |
|); |
7473 |
my $check_numberpatterns_sth = $dbh->prepare(qq| |
7473 |
my $check_numberpatterns_sth = $dbh->prepare(qq| |
7474 |
SELECT * FROM subscription_numberpatterns |
7474 |
SELECT * FROM subscription_numberpatterns |
7475 |
WHERE add1 = ? AND add2 = ? AND add3 = ? |
7475 |
WHERE (add1 = ? OR (add1 IS NULL AND ? IS NULL)) AND (add2 = ? OR (add2 IS NULL AND ? IS NULL)) |
7476 |
AND every1 = ? AND every2 = ? AND every3 = ? |
7476 |
AND (add3 = ? OR (add3 IS NULL AND ? IS NULL)) AND (every1 = ? OR (every1 IS NULL AND ? IS NULL)) |
7477 |
AND whenmorethan1 = ? AND whenmorethan2 = ? AND whenmorethan3 = ? |
7477 |
AND (every2 = ? OR (every2 IS NULL AND ? IS NULL)) AND (every3 = ? OR (every3 IS NULL AND ? IS NULL)) |
7478 |
AND setto1 = ? AND setto2 = ? AND setto3 = ? |
7478 |
AND (whenmorethan1 = ? OR (whenmorethan1 IS NULL AND ? IS NULL)) AND (whenmorethan2 = ? OR (whenmorethan2 IS NULL AND ? IS NULL)) |
7479 |
AND numberingmethod = ? |
7479 |
AND (whenmorethan3 = ? OR (whenmorethan3 IS NULL AND ? IS NULL)) AND (setto1 = ? OR (setto1 IS NULL AND ? IS NULL)) |
|
|
7480 |
AND (setto2 = ? OR (setto2 IS NULL AND ? IS NULL)) AND (setto3 = ? OR (setto3 IS NULL AND ? IS NULL)) |
7481 |
AND (numberingmethod = ? OR (numberingmethod IS NULL AND ? IS NULL)) |
7480 |
LIMIT 1 |
7482 |
LIMIT 1 |
7481 |
|); |
7483 |
|); |
7482 |
my $update_subscription_sth = $dbh->prepare(qq| |
7484 |
my $update_subscription_sth = $dbh->prepare(qq| |
Lines 7489-7499
if ( CheckVersion($DBversion) ) {
Link Here
|
7489 |
my $i = 1; |
7491 |
my $i = 1; |
7490 |
while(my $sub = $sth->fetchrow_hashref) { |
7492 |
while(my $sub = $sth->fetchrow_hashref) { |
7491 |
$check_numberpatterns_sth->execute( |
7493 |
$check_numberpatterns_sth->execute( |
7492 |
$sub->{add1}, $sub->{add2}, $sub->{add3}, |
7494 |
$sub->{add1}, $sub->{add1}, $sub->{add2}, $sub->{add2}, $sub->{add3}, $sub->{add3}, |
7493 |
$sub->{every1}, $sub->{every2}, $sub->{every3}, |
7495 |
$sub->{every1}, $sub->{every1}, $sub->{every2}, $sub->{every2}, $sub->{every3}, $sub->{every3}, |
7494 |
$sub->{whenmorethan1}, $sub->{whenmorethan2}, $sub->{whenmorethan3}, |
7496 |
$sub->{whenmorethan1}, $sub->{whenmorethan1}, $sub->{whenmorethan2}, $sub->{whenmorethan2}, |
7495 |
$sub->{setto1}, $sub->{setto2}, $sub->{setto3}, |
7497 |
$sub->{whenmorethan3}, $sub->{whenmorethan3}, $sub->{setto1}, $sub->{setto1}, $sub->{setto2}, |
7496 |
$sub->{numberingmethod} |
7498 |
$sub->{setto2}, $sub->{setto3}, $sub->{setto3}, $sub->{numberingmethod}, $sub->{numberingmethod} |
7497 |
); |
7499 |
); |
7498 |
my $p = $check_numberpatterns_sth->fetchrow_hashref; |
7500 |
my $p = $check_numberpatterns_sth->fetchrow_hashref; |
7499 |
if (defined $p) { |
7501 |
if (defined $p) { |
7500 |
- |
|
|