aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/includes/db/firebird.php
diff options
context:
space:
mode:
authorNathan Guse <nathaniel.guse@gmail.com>2012-09-08 15:48:46 -0500
committerNathan Guse <nathaniel.guse@gmail.com>2012-09-08 15:48:46 -0500
commit7fee0cfdf60c9aeebcd498d2f41696bb7fed2dd0 (patch)
tree47313d9dbe6adc84d67c08d06a510a4c6fb05b43 /phpBB/includes/db/firebird.php
parent7b0b6fc63c2593cafaa84cc38a9b3029af1ed369 (diff)
downloadforums-7fee0cfdf60c9aeebcd498d2f41696bb7fed2dd0.tar
forums-7fee0cfdf60c9aeebcd498d2f41696bb7fed2dd0.tar.gz
Diffstat (limited to 'checksetup.pl')
-rwxr-xr-xchecksetup.pl8<[ticket/11103] Work on the pm type and email method
PHPBB3-11103
Diffstat (limited to 'phpBB/includes/db/firebird.php')
0 files changed, 0 insertions, 0 deletions
"(series_id, date, value) " .
"VALUES (?, ?, ?)");
+ my $deletesth = $dbh->prepare("DELETE FROM series_data
+ WHERE series_id = ? AND date = ?");
+
# Fields in the data file (matches the current collectstats.pl)
my @statuses =
qw(NEW ASSIGNED REOPENED UNCONFIRMED RESOLVED VERIFIED CLOSED);
@@ -3786,6 +3789,11 @@ if (!$series_exists) {
# Insert values into series_data: series_id, date, value
my %fielddata = %{$data{$field}};
foreach my $date (keys %fielddata) {
+ # We need to delete in case the text file had duplicate entries
+ # in it.
+ $deletesth->execute($seriesids{$field},
+ $dbh->quote($date));
+
# We prepared this above
$seriesdatasth->execute($seriesids{$field},
$dbh->quote($date),