124 |
do { |
do { |
125 |
|
|
126 |
my $where = ''; |
my $where = ''; |
127 |
|
my @data; |
128 |
if ($host_id && $share_id && $num) { |
if ($host_id && $share_id && $num) { |
129 |
$where = qq{ |
$where = qq{ |
130 |
WHERE |
WHERE |
132 |
shares.id = ? AND |
shares.id = ? AND |
133 |
files.backupnum = ? |
files.backupnum = ? |
134 |
}; |
}; |
135 |
|
@data = ( $host_id, $share_id, $num ); |
136 |
} |
} |
137 |
|
|
138 |
my $limit = sprintf('LIMIT '.EST_CHUNK.' OFFSET %d', $offset); |
my $limit = sprintf('LIMIT '.EST_CHUNK.' OFFSET %d', $offset); |
159 |
$limit |
$limit |
160 |
}); |
}); |
161 |
|
|
162 |
$sth->execute(@_); |
$sth->execute(@data); |
163 |
$results = $sth->rows; |
$results = $sth->rows; |
164 |
|
|
165 |
if ($results == 0) { |
if ($results == 0) { |