void OnBMSLoaded()
{
bmsEvents = bmsManager.LoadedChart.Events;
if (preQueueMapper != null)
{
preQueueMapper.BMSEvent -= OnHasKeyFrame;
}
preQueueMapper = bmsManager.LoadedChart.GetEventDispatcher();
preQueueMapper.BMSEvent += OnHasKeyFrame;
preQueueMapper.Seek(TimeSpan.MinValue, false);
if (postQueueMapper != null)
{
postQueueMapper.BMSEvent -= OnPostMap;
}
postQueueMapper = bmsManager.LoadedChart.GetEventDispatcher();
postQueueMapper.BMSEvent += OnPostMap;
postQueueMapper.Seek(TimeSpan.MinValue, false);
foreach (var channel in bmsManager.GetAllChannelIds())
{
if (!bmsManager.GetAllAdoptedChannels().Contains(channel))
{
continue;
}
GetChannelQueue(channel).Clear();
}
}
public void CreateRecord(BMSManager bmsManager, string playerName = DefaultPlayerName)
{
const string queryCommandText = "SELECT `play_count`, `combos`, `score` FROM `records` WHERE `hash` = ? AND `player_name` = ? AND `channel_config` = ?;";
const string updateCommandText = "UPDATE `records` SET `combos` = ?, `score` = ?, `play_count` = ?, `time` = (strftime('%s', 'now')) WHERE " +
"`hash` = ? AND `player_name` = ? AND `channel_config` = ?;";
const string insertCommandText = "INSERT INTO `records`(`hash`, `player_name`, `channel_config`, `combos`, `score`, `play_count`)" +
"VALUES (?, ?, ?, ?, ?, ?);";
string bmsHash = bmsManager.GetHash(SongInfoLoader.CurrentEncoding, hashAlgorithm);
// string timeHash = DateTime.UtcNow.Ticks.ToBaseString(32);
int channelConfig = GetAdoptedChannelHash(bmsManager.GetAllAdoptedChannels());
int playCount = 0;
int maxCombos = bmsManager.MaxCombos;
int maxScore = bmsManager.Score;
OpenDatabase();
foreach (var record in database.QuerySql(queryCommandText, bmsHash, playerName, channelConfig))
{
playCount += record.GetValueAsInt32(0);
maxCombos = Math.Max(maxCombos, record.GetValueAsInt32(1));
maxScore = Math.Max(maxScore, record.GetValueAsInt32(2));
}
if (playCount > 0)
{
database.RunSql(updateCommandText,
maxCombos, maxScore, playCount + 1,
bmsHash, playerName, channelConfig
);
}
else
{
database.RunSql(insertCommandText,
bmsHash, playerName, channelConfig,
maxCombos, maxScore, playCount + 1
);
}
}