[icinga-checkins] icinga.org: icinga-reports/mluebben/default: Fix wrong reasontype_id in tables raw_availibility_breakdowns_

git at icinga.org git at icinga.org
Wed Apr 27 10:26:05 CEST 2011


Module: icinga-reports
Branch: mluebben/default
Commit: 505e68bda7fed489bfba9539a8ebbd9d03f0df7b
URL:    https://git.icinga.org/?p=icinga-reports.git;a=commit;h=505e68bda7fed489bfba9539a8ebbd9d03f0df7b

Author: Michael Luebben <michael_luebben at web.de>
Date:   Wed Apr 27 10:25:53 2011 +0200

Fix wrong reasontype_id in tables raw_availibility_breakdowns_

---

 AvailReportParser/Modules/Reporting/DBHandler.pm |    6 +++---
 1 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/AvailReportParser/Modules/Reporting/DBHandler.pm b/AvailReportParser/Modules/Reporting/DBHandler.pm
index 4e5dc9a..bbd3366 100755
--- a/AvailReportParser/Modules/Reporting/DBHandler.pm
+++ b/AvailReportParser/Modules/Reporting/DBHandler.pm
@@ -336,7 +336,7 @@ sub insertAvailBreakdown {
 		case "time" {
 			my ($days, $hours, $minutes, $seconds) = @_;
 
-			$sth = $self->{dbh}->prepare("INSERT INTO ".$table_avail_breakdowns_time." (report_id, state_id, reasontype_id, timetype_id, days, hours, minutes, seconds) VALUES (".$reportID.", ".$stateID.",".$timeTypeID.", ".$reasonTimeID.", ".$days.", ".$hours.", ".$minutes.", ".$seconds.")");
+			$sth = $self->{dbh}->prepare("INSERT INTO ".$table_avail_breakdowns_time." (report_id, state_id, reasontype_id, timetype_id, days, hours, minutes, seconds) VALUES (".$reportID.", ".$stateID.",".$reasonTimeID.", ".$timeTypeID.", ".$days.", ".$hours.", ".$minutes.", ".$seconds.")");
 			$sth->execute();
 			$insertID = $self->{dbh}->{ q{mysql_insertid} };
 			$sth->finish;
@@ -344,7 +344,7 @@ sub insertAvailBreakdown {
 		case "knowntime" {
 			my ($percent) = @_;
 			
-			$sth = $self->{dbh}->prepare("INSERT INTO ".$table_avail_breakdowns_percent." (report_id, state_id, reasontype_id, timetype_id, percent) VALUES (".$reportID.", ".$stateID.",".$timeTypeID.", ".$reasonTimeID.", ".$percent.")");
+			$sth = $self->{dbh}->prepare("INSERT INTO ".$table_avail_breakdowns_percent." (report_id, state_id, reasontype_id, timetype_id, percent) VALUES (".$reportID.", ".$stateID.",".$reasonTimeID.", ".$timeTypeID.", ".$percent.")");
 			$sth->execute();
 			$insertID = $self->{dbh}->{ q{mysql_insertid} };
 			$sth->finish;
@@ -353,7 +353,7 @@ sub insertAvailBreakdown {
 		case "totaltime" {
 			my ($percent) = @_;
 			
-			$sth = $self->{dbh}->prepare("INSERT INTO ".$table_avail_breakdowns_percent." (report_id, state_id, reasontype_id, timetype_id, percent) VALUES (".$reportID.", ".$stateID.",".$timeTypeID.", ".$reasonTimeID.", ".$percent.")");
+			$sth = $self->{dbh}->prepare("INSERT INTO ".$table_avail_breakdowns_percent." (report_id, state_id, reasontype_id, timetype_id, percent) VALUES (".$reportID.", ".$stateID.",".$reasonTimeID.", ".$timeTypeID.", ".$percent.")");
 			$sth->execute();
 			$insertID = $self->{dbh}->{ q{mysql_insertid} };
 			$sth->finish;





More information about the icinga-checkins mailing list