$numrows = mysql_num_rows($result); if ($numrows == 0) { // version is not available, so add it with status VERSION_STATUS_AVAILABLE $query = 'INSERT INTO ' . $dbversiontable . " (bundleidentifier, version, status, notify) values ('" . $crash['bundleidentifier'] . "', '" . $crash['version'] . "', " . VERSION_STATUS_UNKNOWN . ', ' . $notify_default_version . ')'; $result = mysql_query($query) or die(xml_for_result(FAILURE_SQL_ADD_VERSION)); } else { $row = mysql_fetch_row($result); $crash['version_status'] = $row[1]; $notify = $row[2]; mysql_free_result($result); } if ($crash['version_status'] == VERSION_STATUS_DISCONTINUED) { $lastError = FAILURE_VERSION_DISCONTINUED; continue; } $error = groupCrashReport($crash, $link, $notify); if ($error != '') { die(xml_for_result($error)); } $lastError = 0; } elseif ($acceptlog == false) { $lastError = FAILURE_INVALID_INCOMING_DATA; continue; } } /* schliessen der Verbinung */ mysql_close($link); /* Ausgabe der Ergebnisse in XML */ if ($lastError != 0) { echo xml_for_result($lastError); } else {
// get the log data $logdata = ""; $query = "SELECT log FROM " . $dbcrashtable . " WHERE id = '" . $crashid . "' ORDER BY systemversion desc, timestamp desc LIMIT 1"; $result = mysql_query($query) or die(end_with_result('Error in SQL ' . $query)); $numrows = mysql_num_rows($result); if ($numrows > 0) { // get the status $row = mysql_fetch_row($result); $logdata = $row[0]; mysql_free_result($result); } $crash["bundleidentifier"] = $bundleidentifier; $crash["version"] = $version; $crash["logdata"] = $logdata; $crash["id"] = $crashid; $error = groupCrashReport($crash, $link, NOTIFY_OFF); if ($error != "") { die(end_with_result($error)); } } mysql_free_result($result1); } mysql_close($link); ?> <html> <head> <META http-equiv="refresh" content="0;URL=groups.php?&bundleidentifier=<?php echo $bundleidentifier; ?> &version=<?php echo $version;