|
Lines 588-594
sub GetSubscriptions {
Link Here
|
| 588 |
$tmpstring =~ s/^AND //; |
588 |
$tmpstring =~ s/^AND //; |
| 589 |
push @sqlstrings, $tmpstring; |
589 |
push @sqlstrings, $tmpstring; |
| 590 |
} |
590 |
} |
| 591 |
$sqlwhere .= ( $sqlwhere ? " AND " : " WHERE " ) . "(" . join( ") OR (", @sqlstrings ) . ")"; |
591 |
$sqlwhere .= ( $sqlwhere ? " AND " : " WHERE " ) . "((" . join( ") OR (", @sqlstrings ) . "))"; |
| 592 |
} |
592 |
} |
| 593 |
if ($issn) { |
593 |
if ($issn) { |
| 594 |
my @sqlstrings; |
594 |
my @sqlstrings; |
|
Lines 601-607
sub GetSubscriptions {
Link Here
|
| 601 |
$tmpstring =~ s/^OR //; |
601 |
$tmpstring =~ s/^OR //; |
| 602 |
push @sqlstrings, $tmpstring; |
602 |
push @sqlstrings, $tmpstring; |
| 603 |
} |
603 |
} |
| 604 |
$sqlwhere .= ( $sqlwhere ? " AND " : " WHERE " ) . "(" . join( ") OR (", @sqlstrings ) . ")"; |
604 |
$sqlwhere .= ( $sqlwhere ? " AND " : " WHERE " ) . "((" . join( ") OR (", @sqlstrings ) . "))"; |
| 605 |
} |
605 |
} |
| 606 |
$sql .= "$sqlwhere ORDER BY title"; |
606 |
$sql .= "$sqlwhere ORDER BY title"; |
| 607 |
$debug and warn "GetSubscriptions query: $sql params : ", join( " ", @bind_params ); |
607 |
$debug and warn "GetSubscriptions query: $sql params : ", join( " ", @bind_params ); |
| 608 |
- |
|
|