コード例 #1
0
ファイル: ScoreInfoEmbed.cs プロジェクト: rheehot/osu-tracker
        public ScoreInfoEmbed(UserBest userBest)
        {
            ScoreInfo scoreInfo = userBest.newScore;

            UserInfo userInfo = ConvertOsuData.GetUserInfo(scoreInfo.user_id);
            MapInfo  mapInfo  = ConvertOsuData.getMapInfo(scoreInfo.beatmap_id);

            EmbedBuilder builder = new EmbedBuilder()
                                   .WithTitle(string.Format("\n{0} - {1}", mapInfo.artist, mapInfo.title))
                                   .WithDescription(string.Format("**[{0}] {1}**\n​", mapInfo.version, ConvertOsuData.modsToString(scoreInfo.enabled_mods)))
                                   .WithUrl(string.Format("https://osu.ppy.sh/beatmapsets/{0}#osu/{1}", mapInfo.beatmapset_id, scoreInfo.beatmap_id))
                                   .WithColor(new Color(0xFF69B4))
                                   .WithTimestamp(ConvertOsuData.dateToOffset(scoreInfo.date))
                                   .WithFooter(footer => { footer
                                                           .WithText((userBest.newScoreIndex + 1) + "번째 탑 플레이"); })
                                   .WithThumbnailUrl(ConvertOsuData.rankToImageUrl(scoreInfo.rank))
                                   .WithImageUrl(string.Format("https://assets.ppy.sh/beatmaps/{0}/covers/cover.jpg", mapInfo.beatmapset_id))
                                   .WithAuthor(author => { author
                                                           .WithName(userInfo.username)
                                                           .WithUrl("https://osu.ppy.sh/users/" + userInfo.user_id)
                                                           .WithIconUrl("https://github.com/ppy/osu/blob/master/assets/lazer.png?raw=true"); })
                                   .AddField("퍼포먼스", string.Format("{0:0.0#}pp", scoreInfo.pp))
                                   .AddField("콤보", string.Format("{0}/{1}", scoreInfo.maxcombo, mapInfo.max_combo), true)
                                   .AddField("정확도", string.Format("{0:0.0#}%", ConvertOsuData.getAccuracy(scoreInfo.count300, scoreInfo.count100, scoreInfo.count50, scoreInfo.countmiss)), true)
                                   .AddField("\u200B", "\u200B", true)
                                   .AddField("300", "x" + scoreInfo.count300, true)
                                   .AddField("100", "x" + scoreInfo.count100, true)
                                   .AddField("\u200B", "\u200B", true)
                                   .AddField("50", "x" + scoreInfo.count50, true)
                                   .AddField("미스", "x" + scoreInfo.countmiss, true)
                                   .AddField("\u200B", "\u200B", true);

            embed = builder.Build();
        }
コード例 #2
0
        public async Task checkNewScores()
        {
            DataTable users = Sql.Get("SELECT user_id FROM targets GROUP BY user_id");

            // 타겟 유저 마다 검사
            foreach (DataRow user in users.Rows)
            {
                try
                {
                    string user_id  = user["user_id"].ToString();
                    var    userBest = new UserBest(user_id);

                    // 새로운 베퍼포가 있을 경우
                    if (userBest.newScore != null)
                    {
                        var       scoreInfoEmbed = new ScoreInfoEmbed(userBest);
                        DataTable channels       = Sql.Get("SELECT guild_id, channel_id FROM targets WHERE user_id = '{0}'", user_id);

                        foreach (DataRow channel in channels.Rows)
                        {
                            ulong guild_id   = 0;
                            ulong channel_id = 0;

                            // 스코어 정보 전송
                            try
                            {
                                guild_id   = ulong.Parse(channel["guild_id"].ToString());
                                channel_id = ulong.Parse(channel["channel_id"].ToString());

                                var socketTextChannel = _client.GetGuild(guild_id).GetTextChannel(channel_id);
                                await socketTextChannel.SendMessageAsync(embed : scoreInfoEmbed.embed);
                            }
                            // 실패 시 채널이 삭제된 것으로 판단하고 DB에서 삭제
                            catch (NullReferenceException)
                            {
                                Sql.Execute("DELETE FROM targets WHERE channel_id = '{0}'", channel_id);

                                // 해당 서버에서 삭제한 유저가 타겟에 더 이상 없을 경우 점수 기록도 삭제
                                DataTable findUser = Sql.Get("SELECT user_id FROM targets WHERE user_id = {0}", user_id);

                                if (findUser.Rows.Count == 0)
                                {
                                    Sql.Execute("DELETE FROM pphistories WHERE user_id = {0}", user_id);
                                }
                            }
                        }
                    }
                }
                catch (Exception e)
                {
                    Console.WriteLine(e.Message);
                }
            }

            Thread.Sleep(1000);
            await Task.Factory.StartNew(() => checkNewScores());
        }
コード例 #3
0
        public async Task CheckNewBest()
        {
            DataTable userTable = Sql.Get("SELECT user_id FROM targets GROUP BY user_id");

            // 타겟 유저 마다 검사
            foreach (DataRow userRow in userTable.Rows)
            {
                try
                {
                    UserBest userBest;
                    User     user = User.Search((int)userRow["user_id"]);

                    // 이전 pp 기록이 있는지 확인
                    DataTable ppHistorySearchTable = Sql.Get(
                        "SELECT p.user_id FROM pphistories p, targets t " +
                        "WHERE p.user_id = {0} AND p.user_id = t.user_id", user.user_id
                        );

                    // 이전 pp 기록이 없을 경우 새로 삽입하고 다음 타겟 검사
                    if (ppHistorySearchTable.Rows.Count == 0)
                    {
                        userBest = new UserBest(user.user_id);
                        Sql.Execute("INSERT INTO pphistories VALUES ({0}, {1}, {2}, {3})", user.user_id, userBest.pp_sum, user.pp_raw, user.pp_rank);

                        continue;
                    }

                    double previous_pp_raw = Convert.ToDouble(Sql.Get("SELECT pp_raw FROM pphistories WHERE user_id = {0}", user.user_id).Rows[0]["pp_raw"]);

                    // pp 변화가 없을 경우 다음 타겟 검사
                    if (previous_pp_raw.IsCloseTo(user.pp_raw))
                    {
                        continue;
                    }

                    // pp 변화가 있을 경우 새로운 베퍼포가 있는지 확인
                    userBest = new UserBest(user.user_id);
                    userBest.GetNewBest();

                    // 새로운 베퍼포가 없을 경우 다음 타겟 검사
                    if (userBest.newBest == null)
                    {
                        continue;
                    }

                    ScoreEmbed scoreEmbed = new ScoreEmbed(userBest);
                    DataTable  guildTable = Sql.Get("SELECT guild_id FROM targets WHERE user_id = '{0}'", user.user_id);

                    foreach (DataRow guildRow in guildTable.Rows)
                    {
                        ulong       guild_id = ulong.Parse(guildRow["guild_id"].ToString());
                        SocketGuild guild    = _client.GetGuild(guild_id);

                        try
                        {
                            SocketTextChannel osuTrackerChannel = await guild.CreateChannelIfNotExist("osu-tracker");

                            await osuTrackerChannel.SendMessageAsync(embed : scoreEmbed.Build());
                        }
                        catch (Exception e)
                        {
                            Console.WriteLine(e.Message);
                        }
                    }
                }
                catch (Exception e)
                {
                    Console.WriteLine(e.Message);
                }

                Console.WriteLine(userRow["user_id"]);
            }

            Sql.Execute("DELETE FROM pphistories WHERE user_id NOT IN (SELECT user_id FROM targets)");
            await Task.Factory.StartNew(() => CheckNewBest());
        }