/// <summary>
///
/// </summary>
/// <param name="table"></param>
public static void UpdateNonIdentityCompleteTableAsExpandoObjectProperties(CompleteTable table)
{
var now = DateTime.SpecifyKind(
DateTime.Parse(DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:ss.fffff")),
DateTimeKind.Unspecified);
var item = table as IDictionary <string, object>;
item["ColumnBigInt"] = Convert.ToInt64(2);
item["ColumnBigIntAsArray"] = new long[] { 1, 2, 3, 4, 5 };
item["ColumnBigSerial"] = Convert.ToInt64(2);
//item["ColumnBit"] = true;
item["ColumnBoolean"] = true;
item["ColumnChar"] = 'C';
item["ColumnCharacter"] = "C";
item["ColumnCharacterVarying"] = "ColumnCharacterVarying";
item["ColumnDate"] = now.Date;
item["ColumnDateAsArray"] = new[] { now.Date, now.Date, now.Date };
item["ColumnInteger"] = Convert.ToInt32(2);
item["ColumnIntegerAsArray"] = new[] { 1, 2, 3, 4, 5 };
item["ColumnInterval"] = now.TimeOfDay;
item["ColumnIntervalAsArray"] = new[] { now.TimeOfDay, now.TimeOfDay, now.TimeOfDay };
//item["ColumnJson"] = "{\"field1\": 1, \"field2\": 2}";
item["ColumnMoney"] = Convert.ToDecimal(2);
item["ColumnName"] = $"ColumnName-{Guid.NewGuid()}-Updated";
item["ColumnReal"] = Convert.ToSingle(2);
item["ColumnSmallInt"] = Convert.ToInt16(2);
item["ColumnText"] = $"ColumnText-{Guid.NewGuid()}-Updated";
item["ColumnTimestampWithoutTimeZone"] = now;
}
// Creates the Train and Test collections using the provided text document.
public void CreateTrainAndTestSets()
{
// Temporary variables.
var aRand = new Random();
var aCompleteRandomTable = new DataTable();
for (int col = 0; col < CompleteTable.Columns.Count; col++)
{
aCompleteRandomTable.Columns.Add(new DataColumn("Column" + (col + 1).ToString()));
}
// Add designated size of train set data points from complete set to train table. Completely randomized.
aCompleteRandomTable = CompleteTable.AsEnumerable().OrderBy(r => aRand.Next()).Take(CompleteTable.Rows.Count).CopyToDataTable();
int rowNumber = 0;
foreach (DataRow row in aCompleteRandomTable.Rows)
{
if (rowNumber < 4000)
{
TrainTable.ImportRow(row);
}
else
{
TestTable.ImportRow(row);
}
rowNumber++;
}
}
/// <summary>
///
/// </summary>
/// <param name="table"></param>
public static void UpdateCompleteTableProperties(CompleteTable table)
{
var now = DateTime.SpecifyKind(
DateTime.Parse(DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:ss.fffff")),
DateTimeKind.Unspecified);
table.ColumnBigInt = Convert.ToInt64(2);
table.ColumnBigIntAsArray = new long[] { 1, 2, 3, 4, 5 };
table.ColumnBigSerial = Convert.ToInt64(2);
//table.ColumnBit = true;
table.ColumnBoolean = (Randomizer.Next() % 2 != 0);
table.ColumnChar = 'C';
table.ColumnCharacter = "C";
table.ColumnCharacterVarying = "ColumnCharacterVarying";
table.ColumnDate = now.Date;
table.ColumnDateAsArray = new[] { now.Date, now.Date, now.Date };
table.ColumnInteger = Convert.ToInt32(2);
table.ColumnIntegerAsArray = new[] { 1, 2, 3, 4, 5 };
table.ColumnInterval = now.TimeOfDay;
table.ColumnIntervalAsArray = new[] { now.TimeOfDay, now.TimeOfDay, now.TimeOfDay };
//table.ColumnJson = "{\"field1\": 1, \"field2\": 2}";
table.ColumnMoney = Convert.ToDecimal(2);
table.ColumnName = $"{table.ColumnName} (Updated)";
table.ColumnReal = Convert.ToSingle(2);
table.ColumnSmallInt = Convert.ToInt16(2);
table.ColumnText = $"{table.ColumnText} (Updated)";
table.ColumnTimestampWithoutTimeZone = now;
}
public void OnKrampusKilled()
{
Krampus = null;
CompleteTable.Clear();
TotalTradesComplete = 0;
}
public void OnKrampusKilled()
{
Krampus = null;
CompleteTable.Clear();
TotalTradesComplete = 0;
if (!Enabled)
{
Encounter = null;
}
}
/// <summary>
/// Update the properties of <see cref="CompleteTable"/> instance.
/// </summary>
/// <param name="table">The instance to be updated.</param>
public static void UpdateCompleteTableProperties(CompleteTable table)
{
var now = DateTime.SpecifyKind(
DateTime.Parse(DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:ss.fffff")),
DateTimeKind.Unspecified);
table.ColumnVarchar = $"ColumnVarChar:{1}-Updated";
table.ColumnInt = 1;
table.ColumnDecimal2 = Convert.ToDecimal(1);
table.ColumnDateTime = EpocDate;
table.ColumnBlob = Encoding.Default.GetBytes($"ColumnBlob:{1}-Updated");
table.ColumnBlobAsArray = Encoding.Default.GetBytes($"ColumnBlobAsArray:{1}-Updated");
table.ColumnBinary = Encoding.Default.GetBytes($"ColumnBinary:{1}-Updated");
table.ColumnLongBlob = Encoding.Default.GetBytes($"ColumnLongBlob:{1}-Updated");
table.ColumnMediumBlob = Encoding.Default.GetBytes($"ColumnMediumBlob:{1}-Updated");
table.ColumnTinyBlob = Encoding.Default.GetBytes($"ColumnTinyBlob:{1}-Updated");
table.ColumnVarBinary = Encoding.Default.GetBytes($"ColumnVarBinary:{1}-Updated");
table.ColumnDate = EpocDate;
table.ColumnDateTime2 = now;
table.ColumnTime = EpocDate.AddHours(5).AddMinutes(7).AddSeconds(12).TimeOfDay;
table.ColumnTimeStamp = now;
table.ColumnYear = Convert.ToInt16(now.Year);
//table.ColumnGeometry = Encoding.Default.GetBytes($"ColumnGeometry:{1}");
//table.ColumnLineString = Encoding.Default.GetBytes($"ColumnLineString:{1}");
//table.ColumnMultiLineString = Encoding.Default.GetBytes($"ColumnMultiLineString:{1}");
//table.ColumnMultiPoint = Encoding.Default.GetBytes($"ColumnMultiPoint:{1}");
//table.ColumnMultiPolygon = Encoding.Default.GetBytes($"ColumnMultiPolygon:{1}");
//table.ColumnPoint = Encoding.Default.GetBytes($"ColumnPoint:{1}");
//table.ColumnPolygon = Encoding.Default.GetBytes($"ColumnPolygon:{1}");
table.ColumnBigint = 1;
table.ColumnDecimal = Convert.ToDecimal(1);
table.ColumnDouble = Convert.ToDouble(1);
table.ColumnFloat = Convert.ToSingle(1);
table.ColumnInt2 = 1;
table.ColumnMediumInt = 1;
table.ColumnReal = Convert.ToDouble(1);
table.ColumnSmallInt = Convert.ToInt16(1);
table.ColumnTinyInt = (SByte)1;
table.ColumnChar = "C";
table.ColumnJson = "{\"Field\": \"Value-Updated\"}";
table.ColumnNChar = "C";
table.ColumnNVarChar = $"ColumnNVarChar:{1}-Updated";
table.ColumnLongText = $"ColumnLongText:{1}-Updated";
table.ColumnMediumText = $"ColumnMediumText:{1}-Updated";
table.ColumnText = $"ColumText:{1}-Updated";
table.ColumnTinyText = $"ColumnTinyText:{1}-Updated";
table.ColumnBit = (UInt64)1;
}
public string EncryptData(string data)
{
var extKey = ExtendKeyPhrase(data.Length);
var encrypted = new byte[data.Length];
if (!CompleteTable.VerifyString(data))
{
throw new ArgumentException("Plaintext data contains characters that does not exist in the cipher table");
}
if (!CompleteTable.VerifyString(KeyPhrase))
{
throw new ArgumentException("Key data contains characters that does not exist in the cipher table");
}
var tbl = CompleteTable.Table;
for (var i = 0; i < data.Length; i++)
{
if (char.IsWhiteSpace(data[i]))
{
encrypted[i] = (byte)' ';
continue;
}
int plainPos = 0;
for (var j = 0; j < CompleteTable.RawStringRow.Length; j++)
{
if (data[i] == CompleteTable.RawStringRow[j])
{
plainPos = j;
break;
}
}
foreach (var row in tbl.Where(row => row[0] == extKey[i]))
{
encrypted[i] = row[plainPos];
break;
}
}
return(Encoding.Default.GetString(encrypted));
}
/// <summary>
/// Update the properties of <see cref="CompleteTable"/> instance.
/// </summary>
/// <param name="table">The instance to be updated.</param>
public static void UpdateCompleteTableProperties(CompleteTable table)
{
var now = DateTime.SpecifyKind(
DateTime.Parse(DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:ss.fffff")),
DateTimeKind.Unspecified);
table.ColumnBigInt = Convert.ToInt64(1);
table.ColumnBoolean = (Randomizer.Next() % 2 != 0);
table.ColumnCharacter = "C";
table.ColumnDate = now.Date;
table.ColumnInteger = Convert.ToInt32(1);
table.ColumnInterval = now.TimeOfDay;
table.ColumMoney = Convert.ToDecimal(1);
table.ColumName = $"ColumnName{1}";
table.ColumnReal = Convert.ToSingle(1);
table.ColumnSmallInt = Convert.ToInt16(1);
table.ColumnText = $"ColumnText{1}";
table.ColumnTimestampWithoutTimeZone = now;
}
/// <summary>
/// Update the properties of <see cref="CompleteTable"/> instance.
/// </summary>
/// <param name="table">The instance to be updated.</param>
public static void UpdateCompleteTableProperties(CompleteTable table)
{
table.ColumnBigInt = long.MaxValue;
table.ColumnBlob = Encoding.UTF32.GetBytes(Guid.NewGuid().ToString());
table.ColumnBoolean = true;
table.ColumnChar = char.Parse("C").ToString();
table.ColumnDate = DateTime.SpecifyKind(DateTime.UtcNow, DateTimeKind.Unspecified).Date;
table.ColumnDateTime = DateTime.SpecifyKind(DateTime.UtcNow, DateTimeKind.Unspecified);
table.ColumnDecimal = Convert.ToDecimal(Randomizer.Next(1000000));
table.ColumnDouble = Convert.ToDouble(Randomizer.Next(1000000));
table.ColumnInt = Randomizer.Next(1000000);
table.ColumnInteger = Convert.ToInt64(Randomizer.Next(1000000));
table.ColumnNumeric = Convert.ToDecimal(Randomizer.Next(1000000));
table.ColumnReal = Convert.ToSingle(Randomizer.Next(1000000));
table.ColumnString = $"{table.ColumnString} - Updated with {Guid.NewGuid().ToString()}";
table.ColumnText = $"{table.ColumnText} - Updated with {Guid.NewGuid().ToString()}";
table.ColumnTime = DateTime.SpecifyKind(DateTime.UtcNow, DateTimeKind.Unspecified);
table.ColumnVarChar = $"{table.ColumnVarChar} - Updated with {Guid.NewGuid().ToString()}";
}
/// <summary>
/// Update the properties of <see cref="CompleteTable"/> instance.
/// </summary>
/// <param name="table">The instance to be updated.</param>
public static void UpdateCompleteTableProperties(CompleteTable table)
{
var now = DateTime.SpecifyKind(
DateTime.Parse(DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:ss.fffff")),
DateTimeKind.Unspecified);
table.ColumnBigInt = Convert.ToInt64(2);
table.ColumnBinary = (byte[])null;
table.ColumnBit = true;
table.ColumnChar = "C";
table.ColumnDate = now.Date;
table.ColumnDateTime = now.Date;
table.ColumnDateTime2 = now;
table.ColumnDateTimeOffset = new DateTimeOffset(now.Date).ToOffset(TimeSpan.FromHours(2));
table.ColumnDecimal = Convert.ToDecimal(2);
table.ColumnFloat = Convert.ToDouble(2);
//table.ColumnGeography = (object)null;
//table.ColumnGeometry = (object)null;
//table.ColumnHierarchyId = (object)null;
table.ColumnImage = (byte[])null;
table.ColumnInt = Convert.ToInt32(2);
table.ColumnMoney = Convert.ToDecimal(2);
table.ColumnNChar = "C";
table.ColumnNText = "NText - Updated";
table.ColumnNumeric = Convert.ToDecimal(2);
table.ColumnNVarChar = "NVarChar - Updated";
table.ColumnReal = Convert.ToSingle(2);
table.ColumnSmallDateTime = now.Date;
table.ColumnSmallInt = Convert.ToInt16(2);
table.ColumnSmallMoney = Convert.ToDecimal(2);
table.ColumnSqlVariant = (object)null;
table.ColumnText = "Text - Updated";
table.ColumnTime = now.TimeOfDay;
//table.ColumnTimestamp = (byte[])null;
table.ColumnTinyInt = (byte)0;
table.ColumnUniqueIdentifier = Guid.NewGuid();
table.ColumnVarBinary = (byte[])null;
table.ColumnVarChar = "VarChar - Updated";
table.ColumnXml = (string)null;
table.SessionId = Guid.NewGuid();
}
public void OnTradeComplete(Mobile m, TradeEntry entry)
{
bool distCheck = entry.Distance > 0;
// 0 distance indicates they used a moongate
if (m is PlayerMobile pm && distCheck)
{
if (!CompleteTable.ContainsKey(pm))
{
CompleteTable[pm] = 1;
}
else
{
CompleteTable[pm]++;
}
}
if (TotalTradesComplete > MinComplete || distCheck)
{
TotalTradesComplete++;
}
}
public override string ToString()
{
return(CompleteTable.ToString());
}
