public void AddUpdatePlayer(string steamId, string lastDisplayName)
{
try
{
AddUpdatePlayerParameter classAddUpdatePlayerParameter = new AddUpdatePlayerParameter(steamId, lastDisplayName);
ThreadPool.QueueUserWorkItem
(new WaitCallback(AddUpdatePlayerThread), classAddUpdatePlayerParameter);
}
catch (Exception ex)
{
Logger.LogException(ex);
}
}
public void AddUpdatePlayer(string steamId, string lastDisplayName)
{
try
{
AddUpdatePlayerParameter classAddUpdatePlayerParameter = new AddUpdatePlayerParameter(steamId, lastDisplayName);
ThreadPool.QueueUserWorkItem
(new WaitCallback(AddUpdatePlayerThread), classAddUpdatePlayerParameter);
}
catch (Exception ex)
{
Logger.LogException(ex);
}
}
private void AddUpdatePlayerThread(object objectAddUpdatePlayerParameter)
{
try
{
AddUpdatePlayerParameter classAddUpdatePlayerParameter = (AddUpdatePlayerParameter)objectAddUpdatePlayerParameter;
MySqlConnection connection = CreateConnection();
MySqlCommand command = connection.CreateCommand();
command.CommandText = "INSERT INTO `" + Init.Instance.Configuration.Instance.PDatabaseTableName + "` (`steamId`,`lastDisplayName`) VALUES (@steamId,@lastDisplayName) ON DUPLICATE KEY UPDATE lastDisplayName = @lastDisplayName;";
command.Parameters.AddWithValue("@steamId", classAddUpdatePlayerParameter.steamId);
command.Parameters.AddWithValue("@lastDisplayName", classAddUpdatePlayerParameter.lastDisplayName);
connection.Open();
command.ExecuteNonQuery();
connection.Dispose();
}
catch (Exception ex)
{
Logger.LogException(ex);
}
}
