my $sum =0;
my $firststart;
my $laststop;
#my $unixtime;

foreach my $line(@dataSUM) {
   my @lineData      = split(/\t/, $line);
   my $startime      = $lineData[0]  if(&is_numeric($lineData[0]))  || die "$lineData[0]  not numeric\n";
   my $stoptime      = $lineData[1]  if(&is_numeric($lineData[1]))  || die "$lineData[1]  not numeric\n";
#   $unixtime         = scalar localtime $lineData[1]  if(&is_numeric($lineData[1]))  || die "$lineData[1]  not numeric\n";
   my $xover_bytes   = $lineData[7]  if(&is_numeric($lineData[7]))  || die "$lineData[7]  not numeric\n";
   my $art_bytes     = $lineData[9]  if(&is_numeric($lineData[9]))  || die "$lineData[9]  not numeric\n";
   my $list_bytes    = $lineData[11] if(&is_numeric($lineData[11])) || die "$lineData[11] not numeric\n";
   my $newnews_bytes = $lineData[13] if(&is_numeric($lineData[13])) || die "$lineData[13] not numeric\n";
   my $lineSum       = $xover_bytes + $art_bytes + $list_bytes + $newnews_bytes;
   $sum += $lineSum;

   $firststart =  ($startime < $firststart) || $firststart ==0 ? $startime : $firststart;
   $laststop =  ($stoptime > $laststop ) ? $stoptime : $laststop;
}

if($DEBUG) {
   print "This is our sum $sum\n our start $start\n our stop $stop\n";
}

sub is_numeric {
  my $data = shift;
  return($data =~ m/^\d+$/);
}

sleep $MySQLrandom;

openlog('statsdetailed', 'pid', 'user');
my $usagedbhconnect = DBI->connect("DBI:mysql:host=$dbhost2;database=$usagedb",
                              $usagedbuser, $usagedbpass)
                              || die  syslog('alert', '%s', "MySQL connect to $dbhost2 failed data_source: $DBI::errstr")
                              && print LOG "Connection to $usagedb at $dbhost2 failed at $extension\n" if($LOG);

if($usagedbhconnect && $LOG) {
   print LOG "Connection to $usagedb was a success\n";
}

my $usagesqlQuery        = "INSERT INTO usageSum (id,host,reseller,date,startTime,StopTime,totalSum) values (?,?,?,?,?,?,?)";
my $usagesthloc          = $usagedbhconnect->prepare($usagesqlQuery);
$usagesthloc->execute("NULL","$usageHost","gl_design","NULL","$firststart","$laststop","$sum")
                           || die  syslog('alert', '%s', "MySQL execute failed command: $DBI::errstr")
                           && print LOG "usage DB insertion failed at $extension VALUES(NULL,$usageHost,
                                         \"gl_design\",$firststart,$laststop,$sum)\n" if($LOG);

if($usagesthloc && $LOG) {
   print LOG "usage DB insertion was a success\n";
}

$usagesthloc->finish;
$usagedbhconnect->disconnect;