//
//--Used to return stats of a game
//
public static String returnCurrentGameStatus()
{
String gameID = "";
String status = "";
String startTime = "";
String startDate = "";
String gameTime = "";
MySqlCommand loader = new MySqlCommand(BotSQL.sqlLatestGame(), (MySqlConnection)BotSettings.DefConnection);
try
{
((MySqlConnection)BotSettings.DefConnection).Open();
object o = loader.ExecuteScalar();
gameID = Convert.ToString(o);
loader = new MySqlCommand(BotSQL.sqlStartTime(), (MySqlConnection)BotSettings.DefConnection);
o = loader.ExecuteScalar();
startTime = Convert.ToString(o);
loader = new MySqlCommand(BotSQL.sqlGameTime(Convert.ToInt32(gameID)), (MySqlConnection)BotSettings.DefConnection);
o = loader.ExecuteScalar();
o = TimeSpan.FromSeconds(Convert.ToDouble(o)).Duration();
gameTime = Convert.ToString(o);
loader = new MySqlCommand(BotSQL.sqlStartDate(), (MySqlConnection)BotSettings.DefConnection);
o = loader.ExecuteScalar();
o = Convert.ToDateTime(o).ToShortDateString();
startDate = Convert.ToString(o);
((MySqlConnection)BotSettings.DefConnection).Close();
}
catch (MySqlException err)
{
Console.WriteLine(err.Message);
}
status = "Latest Game: " + gameID + " started at " + startTime + " on " + startDate + " at last check has been running " + gameTime + ".";
return(status);
}
public static HashSet <String> returnGameChat(int gameID, MySqlConnection conn)
//specific connection
{
MySqlCommand loader = new MySqlCommand(BotSQL.sqlChatLog(gameID), conn);
HashSet <String> playerChatLog = new HashSet <String>();
try
{
conn.Open();
MySqlDataReader o = loader.ExecuteReader();
if (o == null)
{
;
}
else
{
while (o.Read())
{
playerChatLog.Add(
"[" + o[0] + "]" +
"**" + o[1] + "**:" +
"" + o[2] + "");
}
}
conn.Close();
}
catch (MySqlException err)
{
Console.WriteLine(err.Message);
}
return(playerChatLog);
}
