function db_UpdateSeriesCatalog_All() { $result_status = array("inserted" => 0, "updated" => 0); $query = 'SELECT MAX(SiteID), MAX(VariableID), MAX(MethodID), MAX(SourceID), MAX(QualityControlLevelID) FROM ' . get_table_name('DataValues') . ' GROUP BY SiteID, VariableID, SourceID, MethodID, QualityControlLevelID'; $result = mysql_query($query); if (!$result) { die("<p>Error in executing the SQL query " . $query . ": " . mysql_error() . "</p>"); } $result_array = mysql_fetch_rowsarr($result, MYSQL_NUM); foreach ($result_array as $r) { $status = update_series_catalog($r[0], $r[1], $r[2], $r[3], $r[4]); } }
$VariableID2 = $parsedInfo[3]; $PastTimeStamps = file_get_contents("DateRepository.txt"); $parsedData = explode(";", $data); $sql7 = "INSERT INTO `datavalues`(`DataValue`, `LocalDateTime`, `UTCOffset`, `DateTimeUTC`, `SiteID`, `VariableID`, `CensorCode`, `MethodID`, `SourceID`, `QualityControlLevelID`) VALUES "; for ($i = 0, $size = count($parsedData); $i < $size; ++$i) { $parsedMoreData = explode(",", $parsedData[$i]); //parses the individual data records $mydate = "20" . $parsedMoreData[0] . "," . $parsedMoreData[1]; //formats the date so that it is 2014 instead of 14 and adds time value $timestamp = strtotime($mydate); $mydate = date('Y-m-d H:i:s', $timestamp); array_push($dateTimeArray, $mydate); if (strpos($PastTimeStamps, $mydate) !== false) { continue; } $ms = $UTCOffset * 3600; $utctimestamp = $timestamp - $ms; $DateTimeUTC = date("Y-m-d H:i:s", $utctimestamp); $sql7 .= "('{$parsedMoreData['2']}', '{$mydate}', '{$UTCOffset}', '{$DateTimeUTC}', '{$SiteID}', '{$VariableID1}', '{$CensorCode}', '{$MethodID}', '{$SourceID}', '{$QualityControlLevelID}'), "; $sql7 .= "('{$parsedMoreData['3']}', '{$mydate}', '{$UTCOffset}', '{$DateTimeUTC}', '{$SiteID}', '{$VariableID2}', '{$CensorCode}', '{$MethodID}', '{$SourceID}', '{$QualityControlLevelID}'), "; } file_put_contents("DateRepository.txt", $dateTimeArray); $sql7 = substr($sql7, 0, strlen($sql7) - 2); echo $sql7; $result7 = @mysql_query($sql7, $connection) or die(mysql_error()); echo $result7; echo "tests"; require_once 'update_series_catalog_function.php'; update_series_catalog($SiteID, $VariableID1, $MethodID, $SourceID, $QualityControlLevelID); update_series_catalog($SiteID, $VariableID2, $MethodID, $SourceID, $QualityControlLevelID);