示例#1
0
        public JsonResult GroupStats(long groupid)
        {
            var gStatReply = "";

            using (var DB = new WWContext())
            {
                var day1LynchInfo = DB.GroupDay1Lynch(groupid).FirstOrDefault();
                var night1DieInfo = DB.GroupNight1Death(groupid).FirstOrDefault();
                var day1DieInfo   = DB.GroupDay1Death(groupid).FirstOrDefault();
                var surviverInfo  = DB.GroupSurvivor(groupid).FirstOrDefault();

                ////most slutty
                //// TODO Add visits to database
                ////most common wolf
                //var commonWolfInfo = (from dbgp in DB.GamePlayers
                //                      join dbg in DB.Games on dbgp.GameId equals dbg.Id
                //                      where dbgp.Role == "Wolf" && dbg.GroupName == groupName
                //                      group dbgp by new { dbgp.PlayerId, dbgp.Role }
                //    into grp
                //                      select new
                //                      {
                //                          name = DB.Players.FirstOrDefault(x => x.Id == grp.Key.PlayerId),
                //                          count = grp.Select(x => x.GameId).Distinct().Count(),
                //                          games = DB.GamePlayers.Count(x => x.PlayerId == grp.Key.PlayerId)
                //                      }).Where(x => x.games >= 10)
                //    .OrderByDescending(x => x.count * 100 / x.games)
                //    .FirstOrDefault();
                ////most common villager
                //var commonVillagerInfo = (from dbgp in DB.GamePlayers
                //                          join dbg in DB.Games on dbgp.GameId equals dbg.Id
                //                          where dbgp.Role == "Villager" && dbg.GroupName == groupName
                //                          group dbgp by new { dbgp.PlayerId, dbgp.Role }
                //    into grp
                //                          select new
                //                          {
                //                              name = DB.Players.FirstOrDefault(x => x.Id == grp.Key.PlayerId),
                //                              count = grp.Select(x => x.GameId).Distinct().Count(),
                //                              games = DB.GamePlayers.Count(x => x.PlayerId == grp.Key.PlayerId)
                //                          }).Where(x => x.games >= 10)
                //    .OrderByDescending(x => x.count * 100 / x.games)
                //    .FirstOrDefault();
                //var timesWolfsWon =
                //    DB.Games.Count(
                //        x =>
                //            new[] { "Wolves", "Wolf" }.Contains(x.Winner) &&
                //            x.GroupName == groupName);
                //var timesVillageWon =
                //    DB.Games.Count(
                //        x => (x.Winner == "Village") && x.GroupName == groupName);
                //var timesTannerWon =
                //    DB.Games.Count(x => x.Winner == "Tanner" && x.GroupName == groupName);
                //now build the reply
                string night1dielink, day1lynchlink, day1dielink, survivorlink;
                night1dielink = night1DieInfo != null ? $"<a href='../Player/{night1DieInfo.TelegramId}'>{night1DieInfo.Name}</a>" : "Not enough games";
                day1lynchlink = day1LynchInfo != null ? $"<a href='../Player/{day1LynchInfo.TelegramId}'>{day1LynchInfo.Name}</a>" : "Not enough games";
                day1dielink   = day1DieInfo != null ? $"<a href='../Player/{day1DieInfo.TelegramId}'>{day1DieInfo.Name}</a>" : "Not enough games";
                survivorlink  = surviverInfo != null ? $"<a href='../Player/{surviverInfo.TelegramId}'>{surviverInfo.Name}</a>" : "Not enough games";
                gStatReply   +=

                    "<table class=\"table table-hover\"><tbody>" +
                    $"<tr><td>Games played total</td><td><b>{DB.Games.Count(x => x.GroupId == groupid)}</b></td></tr>" +
                    // $"<tr><td>Times Wolf / Wolves have won</td><td><b>{timesWolfsWon}</b></td></tr>" +
                    //$"<tr><td>Times Village won</td><td><b>{timesVillageWon}</b></td></tr>" +
                    //$"<tr><td>Times Tanner won</td><td><b>{timesTannerWon}</b></td></tr>" +
                    $"<tr><td>Most likely to die first night</td><td><b>{night1dielink}</td><td>{(night1DieInfo?.pct ?? 0)}%</b></td></tr>" +
                    $"<tr><td>Most likely to get lynched first day</td><td><b>{day1lynchlink}</td><td>{(day1LynchInfo?.pct ?? 0)}%</b></td></tr>" +
                    $"<tr><td>Most likely to die first 24 hours</td><td><b>{day1dielink}</td><td>{(day1DieInfo?.pct ?? 0)}%</b></td></tr>" +
                    $"<tr><td>Best survivor</td><td><b>{survivorlink}</td><td>{surviverInfo?.pct ?? 0}%</b></td></tr>" +
                    //$"<tr><td>Most common villager</td><td><b>{commonVillagerInfo?.name.Name}</td><td>{(commonVillagerInfo?.count ?? 0) * 100 / commonVillagerInfo?.games ?? 1}%</b></td></tr>" +
                    //$"<tr><td>Most common wolf</td><td><b>{commonWolfInfo?.name.Name}</td><td>{(commonWolfInfo?.count ?? 0) * 100 / commonWolfInfo?.games ?? 1}%</b></td></tr>" +

                    "</tbody></table>";
            }
            return(Json(gStatReply, JsonRequestBehavior.AllowGet));
        }
示例#2
0
        static void GroupStats(long groupid)
        {
            Console.WriteLine("Group stats for " + groupid);
            try
            {
                var runStats = false;
                using (var db = new WWContext())
                {
                    //first, check that we should even run stats on this group
                    var grp  = db.Groups.FirstOrDefault(x => x.GroupId == groupid);
                    var stat = db.GroupStats.FirstOrDefault(x => x.GroupId == groupid);

                    if (grp == null) //that's a problem..
                    {
                        return;
                    }
                    if (stat == null)
                    {
                        runStats = true;
                    }
                    else
                    {
                        if ((grp.Games.OrderByDescending(x => x.TimeEnded).FirstOrDefault()?.TimeEnded ??
                             DateTime.MinValue) > (stat.LastRun ?? DateTime.MinValue.AddSeconds(1)))
                        {
                            runStats = true;
                        }
                    }

                    if (!runStats)
                    {
                        return;
                    }
                    var gamesPlayed = grp.Games.Count;
                    var night1death = db.GroupNight1Death(groupid).FirstOrDefault();
                    var day1lynch   = db.GroupDay1Lynch(groupid).FirstOrDefault();
                    var day1death   = db.GroupDay1Death(groupid).FirstOrDefault();
                    var survivor    = db.GroupSurvivor(groupid).FirstOrDefault();

                    if (stat == null)
                    {
                        stat         = db.GroupStats.Create();
                        stat.GroupId = groupid;
                        db.GroupStats.Add(stat);
                    }

                    stat.GroupName = grp.Name;
                    //TODO add this metric later
                    //stat.PlayersKilled = db.GamePlayers.Count(x => !x.Survived);
                    //stat.PlayersSurvived = db.GamePlayers.Count(x => x.Survived);

                    if (survivor != null)
                    {
                        stat.BestSurvivor        = survivor.Name;
                        stat.BestSurvivorPercent = (int)survivor.pct;
                    }
                    stat.GamesPlayed = gamesPlayed;
                    stat.LastRun     = DateTime.Now;
                    if (day1death != null)
                    {
                        stat.MostDeadFirstDay     = day1death.Name;
                        stat.MostDeadFirstPercent = day1death.pct;
                    }
                    if (night1death != null)
                    {
                        stat.MostKilledFirstNight   = night1death.Name;
                        stat.MostKilledFirstPercent = night1death.pct;
                    }
                    if (day1lynch != null)
                    {
                        stat.MostLynchedFirstNight = day1lynch.Name;
                        stat.MostLynchFirstPercent = day1lynch.pct;
                    }
                    db.SaveChanges();
                }
            }
            catch
            {
                // ignored
            }
        }
示例#3
0
        public static void GetFullStats(Update u, string[] args)
        {
            var    name     = u.Message.From.FirstName;
            var    id       = u.Message.From.Id;
            var    username = u.Message.From.Username;
            string Content;

            try
            {
                using (var db = new WWContext())
                {
                    Content = "";
                    using (var DB = new WWContext())
                    {
                        DB.Database.CommandTimeout = 600;
                        var gamePlayed  = DB.Games.Count();
                        var night1death = DB.GlobalNight1Death().First();
                        var day1lynch   = DB.GlobalDay1Lynch().First();
                        var day1death   = DB.GlobalDay1Death().First();
                        var survivor    = DB.GlobalSurvivor().First();


                        var playersKilled             = DB.GamePlayers.Count(x => !x.Survived);
                        var playersSurvived           = DB.GamePlayers.Count(x => x.Survived);
                        var totalGroups               = DB.Groups.Count();
                        var totalPlayers              = DB.Players.Count();
                        var bestSurvivor              = survivor.Name;
                        var bestSurvivorPercent       = (int)survivor.pct;
                        var bestSurvivorId            = survivor.TelegramId;
                        var mostKilledFirstDay        = day1death.Name;
                        var mostKilledFirstDayPercent = day1death.pct;
                        var mostKilledFirstDayId      = day1death.TelegramId;
                        var mostKilledFirstNight      = night1death.Name;
                        var mostKilledFirstPercent    = night1death.pct;
                        var mostKilledFirstNightId    = night1death.TelegramId;
                        var mostLynchedFirstDay       = day1lynch.Name;
                        var mostLynchedFirstPercent   = day1lynch.pct;
                        var mostLynchedFirstDayId     = day1lynch.TelegramId;

                        Content += $"Total Games: {gamePlayed}\nNo. of Groups: {totalGroups}\nNo. of Players: {totalPlayers}\n";
                        Content += $"Best Survivor: {bestSurvivor} ({bestSurvivorPercent}%)\nMost Killed 1st Night: {mostKilledFirstNight} ({mostKilledFirstPercent}%)\n";
                        Content += $"Most Lynched 1st Day: {mostLynchedFirstDay} ({mostLynchedFirstPercent}%)";


                        if (u.Message.Chat.Id < 0)
                        {
                            // group
                            var groupid = u.Message.Chat.Id;
                            var grp     = db.Groups.FirstOrDefault(x => x.GroupId == groupid);

                            Content += $"\nGroup Stats for {u.Message.Chat.Title}:\n";

                            var runStats = false;

                            //first, check that we should even run stats on this group
                            var stat = db.GroupStats.FirstOrDefault(x => x.GroupId == groupid);

                            if (stat == null)
                            {
                                runStats = true;
                            }
                            else
                            {
                                if ((grp.Games.OrderByDescending(x => x.TimeEnded).FirstOrDefault()?.TimeEnded ??
                                     DateTime.MinValue) > (stat.LastRun ?? DateTime.MinValue.AddSeconds(1)))
                                {
                                    runStats = true;
                                }
                            }

                            if (!runStats)
                            {
                                // later
                            }
                            var gamesPlayed  = grp.Games.Count;
                            var night1death1 = db.GroupNight1Death(groupid).FirstOrDefault();
                            var day1lynch1   = db.GroupDay1Lynch(groupid).FirstOrDefault();
                            var day1death1   = db.GroupDay1Death(groupid).FirstOrDefault();
                            var survivor1    = db.GroupSurvivor(groupid).FirstOrDefault();

                            if (stat == null)
                            {
                                stat         = db.GroupStats.Create();
                                stat.GroupId = groupid;
                                db.GroupStats.Add(stat);
                            }

                            stat.GroupName = grp.Name;
                            //TODO add this metric later
                            //stat.PlayersKilled = db.GamePlayers.Count(x => !x.Survived);
                            //stat.PlayersSurvived = db.GamePlayers.Count(x => x.Survived);

                            if (survivor1 != null)
                            {
                                stat.BestSurvivor        = survivor1.Name;
                                stat.BestSurvivorPercent = (int)survivor1.pct;
                            }
                            stat.GamesPlayed = gamesPlayed;
                            stat.LastRun     = DateTime.Now;
                            if (day1death1 != null)
                            {
                                stat.MostDeadFirstDay     = day1death1.Name;
                                stat.MostDeadFirstPercent = day1death1.pct;
                            }
                            if (night1death1 != null)
                            {
                                stat.MostKilledFirstNight   = night1death1.Name;
                                stat.MostKilledFirstPercent = night1death1.pct;
                            }
                            if (day1lynch1 != null)
                            {
                                stat.MostLynchedFirstNight = day1lynch1.Name;
                                stat.MostLynchFirstPercent = day1lynch1.pct;
                            }

                            Content += $"No. of Games: {gamesPlayed}\n";
                            Content += $"Best Survivor: {survivor1.Name} ({(int)survivor1.pct}%)\nMost Killed 1st Night: {night1death1.Name} ({night1death1.pct}%)\n";
                            Content += $"Most Lynched 1st Day: {day1lynch1.Name} ({day1lynch1.pct}%)";
                        }

                        DB.SaveChanges();
                        Console.WriteLine("Done");
                        Bot.Api.SendTextMessage(u.Message.Chat.Id, Content, replyToMessageId: u.Message.MessageId);
                    }
                }
            }
            catch
            {
                // nothing
            }
        }