Exemplo n.º 1
0
        public static Dictionary <string, string> GetAllConfigs()
        {
            Dictionary <string, string> ret = new Dictionary <string, string>();
            DBProvider db      = new DBProvider("Game");
            var        configs = db.Select("configs", "Name,Value", "");

            foreach (var config in configs)
            {
                ret.Add((string)config["Name"], (string)config["Value"]);
            }
            return(ret);
        }
Exemplo n.º 2
0
        public static Dictionary <string, string> GetConfigs(int type)
        {
            Dictionary <string, string> ret = new Dictionary <string, string>();
            DBProvider db      = new DBProvider("Game");
            var        configs = db.Select("configs", "Name,Value", "Type=" + type.ToString() + " or Type=0");

            foreach (var config in configs)
            {
                ret.Add((string)config["Name"], (string)config["Value"]);
            }
            return(ret);
        }
Exemplo n.º 3
0
        public static void CheckAndUpdateDataTable(object state)
        {
            DBProvider db       = new DBProvider("Game");
            var        versions = db.Select("dataTableVersions", "Name,UsedVersion,LatestVersion", "");

            foreach (var version in versions)
            {
                if ((int)version["LatestVersion"] > (int)version["UsedVersion"])
                {
                    FileInfo dtfile = new FileInfo("DataTables/" + (string)version["Name"] + ".txt");
                    DataTableLoader.LoadDataTableFile(dtfile);
                    Dictionary <string, object> sqlparams = new Dictionary <string, object>();
                    sqlparams["UsedVersion"] = version["LatestVersion"];
                    db.Update("dataTableVersions", sqlparams, "Name = '" + version["Name"] + "'");
                }
            }
        }
Exemplo n.º 4
0
        public void Execute()
        {
            DBProvider db        = new DBProvider("Game");
            string     now       = DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:ss");
            string     condition = string.Format("BeginTime < '{0}' and ExpireTime > '{1}'", now, now);
            var        announces = db.Select(Table, "Id,Type,Message,BeginTime,IntervalMinutes", condition);

            foreach (var announce in announces)
            {
                if ((int)announce["IntervalMinutes"] == 0 && (int)announce["Pushed"] == 0)
                {
                    var dt = (DateTime)announce["BeginTime"];
                    if (DateTime.UtcNow.Ticks - dt.Ticks <= TimeSpan.TicksPerMinute)
                    {
                        if ((int)announce["Type"] == (int)AnnounceType.SystemNotice)
                        {
                            AnnouncementLogic.PushSystemNotice((string)announce["Message"]);
                        }
                        else
                        {
                            AnnouncementLogic.PushAdvertisement((string)announce["Message"]);
                        }
                    }
                }
                else if ((int)announce["IntervalMinutes"] != 0)
                {
                    var dt = (DateTime)announce["BeginTime"];
                    if (((DateTime.UtcNow.Ticks - dt.Ticks) / TimeSpan.TicksPerMinute) % (int)announce["IntervalMinutes"] == 0)
                    {
                        if ((int)announce["Type"] == (int)AnnounceType.SystemNotice)
                        {
                            AnnouncementLogic.PushSystemNotice((string)announce["Message"]);
                        }
                        else
                        {
                            AnnouncementLogic.PushAdvertisement((string)announce["Message"]);
                        }
                    }
                }
                else
                {
                    continue;
                }
            }
        }
Exemplo n.º 5
0
        public void AddNewMail(string message, int AttachId, int AttachCount)
        {
            if (CacheSet.ItemTable.GetData(AttachId) == null && CacheSet.GearTable.GetData(AttachId) == null && CacheSet.SoulTable.GetData(AttachId) == null && CacheSet.EpigraphTable.GetData(AttachId) == null)
            {
                return;
            }
            DBProvider db = new DBProvider("Game");
            Dictionary <string, object> values = new Dictionary <string, object>();

            values["Message"]     = message;
            values["AttachType"]  = AttachId;
            values["AttachCount"] = AttachCount;
            values["BeginTime"]   = DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:ss");
            DateTime expireDay = DateTime.UtcNow.AddDays(GameConfigs.GetInt("Mail_Expire_Days", 7));

            values["ExpireTime"] = expireDay.ToString("yyyy-MM-dd HH:mm:ss");
            values["ToUser"]     = m_UserId;
            db.Insert("mails", values);
        }
Exemplo n.º 6
0
        public override bool TakeAction()
        {
            DBProvider db = new DBProvider("Game");
            var        localNotifications = db.Select("localNotifications", "Name,Time,Message,Status");

            foreach (var ln in localNotifications)
            {
                if ((int)ln["Status"] == 1)
                {
                    m_ResponsePacket.RegisterKey.Add((string)ln["Name"]);
                    m_ResponsePacket.RegisterDate.Add((string)ln["Time"]);
                    m_ResponsePacket.RegisterMessage.Add((string)ln["Message"]);
                }
                else
                {
                    m_ResponsePacket.CanceledKey.Add((string)ln["Name"]);
                }
            }
            return(true);
        }
Exemplo n.º 7
0
        public int GetMailsFromDB()
        {
            DBProvider  db = new DBProvider("Game");
            PlayerLogic p  = new PlayerLogic();

            p.SetUser(m_UserId);
            string condition = String.Format("Id > {0} AND ToUser in ({1}) AND BeginTime < '{2}' AND ExpireTime > '{3}' AND BeginTime > '{4}'",
                                             m_Mails.ReceivedId, "-1," + m_UserId, DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:ss"), DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:ss"), new DateTime(p.MyPlayer.CreateTime).ToString("yyyy-MM-dd HH:mm:ss"));
            var newMails = db.Select("mails", "Id,Message,AttachType,AttachCount,BeginTime,ExpireTime", condition);

            foreach (var mail in newMails)
            {
                Mail m = new Mail();
                m.Message       = (string)mail["Message"];
                m.AttachedId    = (int)(uint)mail["AttachType"];
                m.AttachedCount = (int)(uint)mail["AttachCount"];
                m.ExpireTime    = ((DateTime)mail["ExpireTime"]).Ticks;
                m.StartTime     = ((DateTime)mail["BeginTime"]).Ticks;
                m_Mails.Mails.Add((int)(uint)mail["Id"], m);
                m_Mails.ReceivedId = (int)(uint)mail["Id"];
            }
            return(m_Mails.Mails.Count);
        }
Exemplo n.º 8
0
 public BILogger()
 {
     db = new DBProvider("BI");
 }