Пример #1
0
        private void GetDbInfo()
        {
            if (!Database.ContainsPlayer(Name))
            {
                Database.CreatePlayer(Name, _client.Ip);
            }

            DataTable dbEntry = Database.GetDataTable($"SELECT * FROM PlayerDB WHERE Name='{Name}' LIMIT 1");

            CurrentRank = Rank.GetRank(Convert.ToInt32(dbEntry.Rows [0] ["Rank"]));
            PrettyName  = CurrentRank.Prefix + Name + CurrentRank.Suffix;
            Stopped     = Convert.ToBoolean(dbEntry.Rows[0]["Stopped"]);
            _banned     = Convert.ToBoolean(dbEntry.Rows[0]["Banned"]);

            var bannedUntil = (long)dbEntry.Rows[0]["BannedUntil"];
            var mutedUntil  = (long)dbEntry.Rows[0]["Time_Muted"];

            DateTime banTime =
                (new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc).AddSeconds(bannedUntil));

            if (banTime > DateTime.UtcNow)
            {
                _banned = true;
            }

            MutedUntil = (new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc).AddSeconds(mutedUntil));
        }