static bool InsertHttpAttack(MySqlCommand cmd, ulong countryId, HttpAttack item)
{
lock (cmd)
{
HttpQuery d = new HttpQuery()
{
Post = item.Post,
Get = item.Get
};
string query = JsonHelper.Serialize(d);
string url = NotNull(item.HttpUrl);
string host = NotNull(item.HttpHost);
string crc = HashHelper.HashHex(HashHelper.EHashType.Md5, host + "\n" + url + "\n" + query);
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("HOST", countryId);
cmd.Parameters.AddWithValue("PORT", item.Port);
cmd.Parameters.AddWithValue("TYPE", item.Type.ToString());
cmd.Parameters.AddWithValue("DATE", item.Date.Substring(0, 10));
cmd.Parameters.AddWithValue("HOUR", item.Date.Substring(11, 5));
cmd.Parameters.AddWithValue("HTTP_QUERY", query);
cmd.Parameters.AddWithValue("HTTP_URL", url);
cmd.Parameters.AddWithValue("HTTP_HOST", host);
cmd.Parameters.AddWithValue("HTTP_CRC", crc);
cmd.CommandText = "INSERT IGNORE INTO attacks_http(HOST,PORT,TYPE,DATE,HOUR,HTTP_HOST,HTTP_URL,HTTP_QUERY,HTTP_CRC)VALUES(@HOST,@PORT,@TYPE,@DATE,@HOUR,@HTTP_HOST,@HTTP_URL,@HTTP_QUERY,@HTTP_CRC);";
cmd.ExecuteNonQuery();
return(true);
}
}
static void InsertHttpAttack(MySqlCommand cmd, ulong countryId, HttpAttack item)
{
}
