Esempio n. 1
0
    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
                            );
        }
    }