public void Update() { if (!IsNeedDownload()) { return; } try { ClientServerListData clientListData = new ClientServerListData(); clientListData.lTime = TimeUtil.NOW(); clientListData.strMD5 = MD5Helper.get_md5_string(ConstData.HTTP_MD5_KEY + clientListData.lTime.ToString()); byte[] clientBytes = DataHelper2.ObjectToBytes <ClientServerListData>(clientListData); byte[] responseData = WebHelper.RequestByPost(KuaFuServerManager.GetPlatChargeKingUrl, clientBytes, 2000, 30000); if (responseData == null) { return; } InputKingPaiHangDataEx tmpRankEx = DataHelper2.BytesToObject <InputKingPaiHangDataEx>(responseData, 0, responseData.Length); if (tmpRankEx != null) { rankEx = tmpRankEx; } } catch (Exception ex) { LogManager.WriteLog(LogTypes.Error, "PlatChargeKingManager.Update exception", ex); } }
public KFRebornRoleData Reborn_GetRebornRoleData(int ptId, int roleId) { try { IKuaFuWorld kuaFuService = this.GetKuaFuService(false); if (null == kuaFuService) { return(null); } try { lock (this.Mutex) { KeyValuePair <int, int> key = new KeyValuePair <int, int>(ptId, roleId); KuaFuData <KFRebornRoleData> RebornRoleData = null; if (!this.RebornRoleDataDict.TryGetValue(key, out RebornRoleData)) { RebornRoleData = new KuaFuData <KFRebornRoleData>(); this.RebornRoleDataDict[key] = RebornRoleData; } KuaFuCmdData result = kuaFuService.Reborn_GetRebornRoleData(ptId, roleId, RebornRoleData.Age); if (result == null || result.Age < 0L) { return(null); } if (result != null && result.Age > RebornRoleData.Age) { RebornRoleData.Age = result.Age; if (null != result.Bytes0) { RebornRoleData.V = DataHelper2.BytesToObject <KFRebornRoleData>(result.Bytes0, 0, result.Bytes0.Length); } if (null != RebornRoleData.V) { this.RebornRoleDataDict[key] = RebornRoleData; } } return(RebornRoleData.V); } } catch (Exception ex) { this.ResetKuaFuService(); } } catch (Exception ex) { LogManager.WriteException(ex.ToString()); } return(null); }
public bool LoadZhanDuiData(Dictionary <int, TianTi5v5ZhanDuiData> dict) { bool result = false; string sql = "select `zhanduiid`,`leaderid`,`xuanyan`,`zhanduiname`,`duanweiid`,`zhanli`,`data1`,`duanweijifen`,`duanweirank`,`liansheng`,`fightcount`,`successcount`,`lastfighttime`,`monthduanweirank`,leaderrolename,zoneid,zorkjifen,zorklastfighttime,escapejifen,escapelastfighttime from t_kf_5v5_zhandui"; using (MySqlDataReader reader = DbHelperMySQL.ExecuteReader(sql, false)) { result = true; while (reader.Read()) { try { TianTi5v5ZhanDuiData data = new TianTi5v5ZhanDuiData(); data.ZhanDuiID = Convert.ToInt32(reader[0].ToString()); data.LeaderRoleID = Convert.ToInt32(reader["leaderid"].ToString()); data.XuanYan = reader["xuanyan"].ToString(); data.ZhanDuiName = reader["zhanduiname"].ToString(); data.DuanWeiId = Convert.ToInt32(reader["duanweiid"].ToString()); data.ZhanDouLi = Convert.ToInt64(reader["zhanli"].ToString()); byte[] bytes = (reader["data1"] as byte[]) ?? new byte[0]; data.teamerList = DataHelper2.BytesToObject <List <TianTi5v5ZhanDuiRoleData> >(bytes, 0, bytes.Length); data.DuanWeiJiFen = Convert.ToInt32(reader["duanweijifen"].ToString()); data.DuanWeiRank = Convert.ToInt32(reader["duanweirank"].ToString()); data.LianSheng = Convert.ToInt32(reader["liansheng"].ToString()); data.FightCount = Convert.ToInt32(reader["fightcount"].ToString()); data.SuccessCount = Convert.ToInt32(reader["successcount"].ToString()); data.LastFightTime = Convert.ToDateTime(reader["lastfighttime"].ToString()); data.MonthDuanWeiRank = Convert.ToInt32(reader["monthduanweirank"].ToString()); data.LeaderRoleName = reader["leaderrolename"].ToString(); data.ZoneID = Convert.ToInt32(reader["zoneid"].ToString()); data.ZorkJiFen = Convert.ToInt32(reader["zorkjifen"].ToString()); data.ZorkLastFightTime = Convert.ToDateTime(reader["zorklastfighttime"].ToString()); data.EscapeJiFen = Convert.ToInt32(reader["escapejifen"].ToString()); data.EscapeLastFightTime = Convert.ToDateTime(reader["escapelastfighttime"].ToString()); dict[data.ZhanDuiID] = data; } catch (Exception ex) { LogManager.WriteException(ex.ToString()); } } } return(result); }
public KuaFuLueDuoBHData GetBHDataByBhid_KuaFuLueDuo(int bhid) { IKuaFuService kuaFuService = this.GetKuaFuService(false); if (null != kuaFuService) { try { lock (this.Mutex) { KuaFuData <KuaFuLueDuoBHData> bhdata = null; if (!this.KuaFuLueDuoBHDataDict.TryGetValue(bhid, out bhdata)) { bhdata = new KuaFuData <KuaFuLueDuoBHData>(); this.KuaFuLueDuoBHDataDict[bhid] = bhdata; } KuaFuCmdData result = kuaFuService.GetBHDataByBhid_KuaFuLueDuo(bhid, bhdata.Age); if (result == null || result.Age < 0L) { return(null); } if (result != null && result.Age > bhdata.Age) { bhdata.Age = result.Age; if (null != result.Bytes0) { bhdata.V = DataHelper2.BytesToObject <KuaFuLueDuoBHData>(result.Bytes0, 0, result.Bytes0.Length); } if (null != bhdata.V) { this.KuaFuLueDuoBHDataDict[bhid] = bhdata; } } return(bhdata.V); } } catch (Exception ex) { LogManager.WriteException(ex.ToString()); } } return(null); }
public int LoadZhanDuiRankList(List <TianTi5v5ZhanDuiData> list, int dayID) { int result = 0; string sql = string.Format("select `zhanduiid`,`leaderid`,`xuanyan`,`zhanduiname`,`duanweiid`,`zhanli`,`data1`,`duanweijifen`,`duanweirank`,`liansheng`,`fightcount`,`successcount`,`lastfighttime`,`monthduanweirank`,leaderrolename,zoneid from t_kf_5v5_zhandui_paihang where dayid={0} order by duanweirank", dayID); using (MySqlDataReader reader = DbHelperMySQL.ExecuteReader(sql, false)) { result = 1; while (reader.Read()) { try { TianTi5v5ZhanDuiData data = new TianTi5v5ZhanDuiData(); data.ZhanDuiID = Convert.ToInt32(reader[0].ToString()); data.LeaderRoleID = Convert.ToInt32(reader["leaderid"].ToString()); data.XuanYan = reader["xuanyan"].ToString(); data.ZhanDuiName = reader["zhanduiname"].ToString(); data.DuanWeiId = Convert.ToInt32(reader["duanweiid"].ToString()); data.ZhanDouLi = Convert.ToInt64(reader["zhanli"].ToString()); byte[] bytes = (reader["data1"] as byte[]) ?? new byte[0]; data.teamerList = DataHelper2.BytesToObject <List <TianTi5v5ZhanDuiRoleData> >(bytes, 0, bytes.Length); data.DuanWeiJiFen = Convert.ToInt32(reader["duanweijifen"].ToString()); data.DuanWeiRank = Convert.ToInt32(reader["duanweirank"].ToString()); data.LianSheng = Convert.ToInt32(reader["liansheng"].ToString()); data.FightCount = Convert.ToInt32(reader["fightcount"].ToString()); data.SuccessCount = Convert.ToInt32(reader["successcount"].ToString()); data.LastFightTime = Convert.ToDateTime(reader["lastfighttime"].ToString()); data.MonthDuanWeiRank = Convert.ToInt32(reader["monthduanweirank"].ToString()); data.LeaderRoleName = reader["leaderrolename"].ToString(); data.ZoneID = Convert.ToInt32(reader["zoneid"].ToString()); list.Add(data); } catch (Exception ex) { LogManager.WriteException(ex.ToString()); } } } return(result); }
private List <ZhanDuiZhengBaZhanDuiData> LoadZhengBaRankData(int nowMonth) { List <ZhanDuiZhengBaZhanDuiData> roleList = new List <ZhanDuiZhengBaZhanDuiData>(); try { string strSql = string.Format("SELECT zhanduiid,zhanduiname,zoneid,duanweiid,duanweijifen,duanweirank,zhanli,grade,`group`,state,data1,data2 FROM t_zhandui_zhengba where `month`={0} ORDER BY duanweirank ASC;", nowMonth); using (MySqlDataReader sdr = DbHelperMySQL.ExecuteReader(strSql, false)) { while (sdr != null && sdr.Read()) { ZhanDuiZhengBaZhanDuiData roleData = new ZhanDuiZhengBaZhanDuiData(); roleData.ZhanDuiID = Convert.ToInt32(sdr["zhanduiid"]); roleData.ZoneId = Convert.ToInt32(sdr["zoneid"]); roleData.ZhanDuiName = sdr["zhanduiname"].ToString(); roleData.DuanWeiId = Convert.ToInt32(sdr["duanweiid"]); roleData.DuanWeiRank = Convert.ToInt32(sdr["duanweirank"]); roleData.ZhanLi = Convert.ToInt64(sdr["zhanli"]); if (!sdr.IsDBNull(sdr.GetOrdinal("data1"))) { byte[] bytes = (byte[])sdr["data1"]; roleData.MemberList = DataHelper2.BytesToObject <List <RoleOccuNameZhanLi> >(bytes, 0, bytes.Length); } roleData.Grade = Convert.ToInt32(sdr["grade"]); roleData.Group = Convert.ToInt32(sdr["group"]); roleData.State = Convert.ToInt32(sdr["state"]); roleList.Add(roleData); } } } catch (Exception ex) { LogManager.WriteException(ex.ToString()); } return(roleList); }
/// <summary> /// 检测生成众生争霸排行榜 /// </summary> /// <param name="now"></param> private bool CheckBuildZhengBaRank(int selectRoleIfNewCreate, int nowMonth) { bool bMonthFirst = false; try { DbHelperMySQL.ExecuteSql( string.Format("INSERT IGNORE INTO t_async(`id`,`value`) VALUES({0},{1});", AsyncTypes.ZhengBaCurrMonth, ZhengBaConsts.DefaultAsyncMonth) ); // 防止人为的重新reload月排行榜导致众神争霸战斗信息丢失 /* 这里有一些细节要注意: * 1:每月1号凌晨3点更新月排行榜,然后触发更新争霸角色 * 2: 服务器启动的时候,尝试生成争霸角色 * 3:要防止当月的争霸角色重复生成 * 4:必须保证天梯排行角色已经生成,才能生成争霸角色 -->例如,1号凌晨两点启动,必须保证等到3点的时候,天梯月排行榜生成之后,能够生成本月的争霸角色 */ int oldMonth = (int)DbHelperMySQL.GetSingle("select value from t_async where id = " + AsyncTypes.ZhengBaCurrMonth); object ageObj_tiantiMonth = DbHelperMySQL.GetSingle("select value from t_async where id = " + AsyncTypes.TianTiPaiHangModifyOffsetDay); if (oldMonth != nowMonth && ageObj_tiantiMonth != null && ZhengBaUtils.MakeMonth(DataHelper2.GetRealDate((int)ageObj_tiantiMonth)) == nowMonth) { string strSql = string.Format("SELECT rid,rname,zoneid,duanweiid,duanweijifen,duanweirank,zhanli,data1,data2 FROM t_tianti_month_paihang ORDER BY duanweirank ASC LIMIT {0};", selectRoleIfNewCreate); var sdr = DbHelperMySQL.ExecuteReader(strSql); while (sdr != null && sdr.Read()) { ZhengBaRoleInfoData roleData = new ZhengBaRoleInfoData(); roleData.RoleId = (int)Convert.ToInt32(sdr["rid"]); roleData.ZoneId = (int)Convert.ToInt32(sdr["zoneid"]); roleData.DuanWeiId = (int)Convert.ToInt32(sdr["duanweiid"]); roleData.DuanWeiJiFen = (int)Convert.ToInt32(sdr["duanweijifen"]); roleData.DuanWeiRank = (int)Convert.ToInt32(sdr["duanweirank"]); roleData.ZhanLi = (int)Convert.ToInt32(sdr["zhanli"]); roleData.RoleName = sdr["rname"].ToString(); if (!sdr.IsDBNull(sdr.GetOrdinal("data1"))) { roleData.TianTiPaiHangRoleData = (byte[])(sdr["data1"]); } if (!sdr.IsDBNull(sdr.GetOrdinal("data2"))) { roleData.PlayerJingJiMirrorData = (byte[])(sdr["data2"]); } if (string.IsNullOrEmpty(roleData.RoleName) && roleData.TianTiPaiHangRoleData != null) { var onlyName = DataHelper2.BytesToObject <TianTiPaiHangRoleData_OnlyName>( roleData.TianTiPaiHangRoleData, 0, roleData.TianTiPaiHangRoleData.Length); if (onlyName != null) { roleData.RoleName = onlyName.RoleName; } } string repSql = string.Format( "REPLACE INTO t_zhengba_roles(`month`,rid,zoneid,duanweiid,duanweijifen,duanweirank,zhanli,`grade`,`group`,state,rname,data1,data2) " + "VALUES({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},'{10}',@content,@mirror)", nowMonth, roleData.RoleId, roleData.ZoneId, roleData.DuanWeiId, roleData.DuanWeiJiFen, roleData.DuanWeiRank, roleData.ZhanLi, (int)EZhengBaGrade.Grade100, (int)ZhengBaConsts.NoneGroup, (int)EZhengBaState.None, roleData.RoleName); DbHelperMySQL.ExecuteSqlInsertImg(repSql, new List <Tuple <string, byte[]> > { new Tuple <string, byte[]>("content", roleData.TianTiPaiHangRoleData), new Tuple <string, byte[]>("mirror", roleData.PlayerJingJiMirrorData) }); } if (sdr != null) { sdr.Close(); } DbHelperMySQL.ExecuteSql( string.Format("REPLACE INTO t_async(`id`,`value`) VALUES({0},{1});", AsyncTypes.ZhengBaCurrMonth, nowMonth) ); bMonthFirst = true; } } catch (Exception ex) { LogManager.WriteExceptionUseCache(ex.ToString()); } return(bMonthFirst); }
public void Update() { try { lock (this.Mutex) { if (this.IsNeedDownload()) { bool flag = false; List <InputKingPaiHangDataEx> list = new List <InputKingPaiHangDataEx>(); if (KuaFuServerManager.GetPlatChargeKingUrl != null) { for (int i = 0; i < KuaFuServerManager.GetPlatChargeKingUrl.Length; i++) { ClientServerListData clientListData = new ClientServerListData(); clientListData.lTime = TimeUtil.NOW(); clientListData.strMD5 = MD5Helper.get_md5_string(ConstData.HTTP_MD5_KEY + clientListData.lTime.ToString()); byte[] clientBytes = DataHelper2.ObjectToBytes <ClientServerListData>(clientListData); byte[] responseData = WebHelper.RequestByPost(KuaFuServerManager.GetPlatChargeKingUrl[i], clientBytes, 2000, 30000); if (responseData == null) { flag = true; break; } InputKingPaiHangDataEx tmpRankEx = DataHelper2.BytesToObject <InputKingPaiHangDataEx>(responseData, 0, responseData.Length); if (tmpRankEx == null) { flag = true; break; } list.Add(tmpRankEx); } if (flag) { this.rankEx = new InputKingPaiHangDataEx(); } else { this.rankEx = this.MergePlatfromInputKingList(list); } } } if (this.IsNeedDownloadEveryDay()) { if (KuaFuServerManager.GetPlatChargeKingUrl_EveryDay != null) { bool flag = false; Dictionary <int, List <InputKingPaiHangDataEx> > dict = new Dictionary <int, List <InputKingPaiHangDataEx> >(); for (int i = 0; i < KuaFuServerManager.GetPlatChargeKingUrl_EveryDay.Length; i++) { List <InputKingPaiHangDataEx> tempRankExList = new List <InputKingPaiHangDataEx>(); if (this.MeiRiPCKingFromDate < this.MeiRiPCKingToDate) { DateTime timeLoop = this.MeiRiPCKingFromDate; while (timeLoop < this.MeiRiPCKingToDate && timeLoop < TimeUtil.NowDateTime()) { InputKingPaiHangDataEx tmpRankEx = null; byte[] clientBytes = DataHelper2.ObjectToBytes <InputKingPaiHangDataSearch>(new InputKingPaiHangDataSearch { startDate = timeLoop.ToString("yyyy-MM-dd HH:mm:ss"), endDate = timeLoop.AddDays(1.0).AddSeconds(-1.0).ToString("yyyy-MM-dd HH:mm:ss") }); byte[] responseData = WebHelper.RequestByPost(KuaFuServerManager.GetPlatChargeKingUrl_EveryDay[i], clientBytes, 2000, 30000); if (responseData != null) { tmpRankEx = DataHelper2.BytesToObject <InputKingPaiHangDataEx>(responseData, 0, responseData.Length); } if (null != tmpRankEx) { tempRankExList.Add(tmpRankEx); } else { tempRankExList.Add(new InputKingPaiHangDataEx()); flag = true; } if (flag) { break; } timeLoop = timeLoop.AddDays(1.0); } if (flag) { break; } if (!dict.ContainsKey(i)) { dict.Add(i, tempRankExList); } } } if (flag) { this.rankExList = new List <InputKingPaiHangDataEx>(); } else { this.rankExList = this.MergePlatfromInputKingListEveryDay(dict); } } } } } catch (Exception ex) { LogManager.WriteLog(LogTypes.Error, "PlatChargeKingManager.Update exception", ex, true); } }
public static bool UpdateDataFromServer() { if (Monitor.TryEnter(MutexServerList)) { try { int nextServerListAge = DataHelper2.UnixSecondsNow(); int nextServerGameConfigAge = DataHelper2.UnixSecondsNow(); if (Math.Abs(nextServerListAge - _ServerListAge) < 3) { return(false); } if (!LoadConfigFromServer) { return(false); } //确认是否配置了获取接口地址 if (string.IsNullOrEmpty(KuaFuServerListUrl) || string.IsNullOrEmpty(ServerListUrl)) { return(false); } //首先获取普通服务器列表 //1其次获取跨服活动服务器列表 ClientServerListData clientListData = new ClientServerListData(); clientListData.lTime = TimeUtil.NOW(); clientListData.strMD5 = MD5Helper.get_md5_string(ConstData.HTTP_MD5_KEY + clientListData.lTime.ToString()); byte[] clientBytes = DataHelper2.ObjectToBytes <ClientServerListData>(clientListData); byte[] responseData = WebHelper.RequestByPost(ServerListUrl, clientBytes, 2000, 30000); if (responseData == null) { return(false); } bool serverInfoChanged = false; HashSet <int> existAllIds = new HashSet <int>(); HashSet <int> existKfIds = new HashSet <int>(); BuffServerListData serverListResponseData; BuffServerListData kuaFuServerListResponseData; serverListResponseData = DataHelper2.BytesToObject <BuffServerListData>(responseData, 0, responseData.Length); if (null == serverListResponseData || null == serverListResponseData.listServerData || serverListResponseData.listServerData.Count == 0) { return(false); } //其次获取跨服活动服务器列表 clientListData = new ClientServerListData(); clientListData.lTime = TimeUtil.NOW(); clientListData.strMD5 = MD5Helper.get_md5_string(ConstData.HTTP_MD5_KEY + clientListData.lTime.ToString()); clientBytes = DataHelper2.ObjectToBytes <ClientServerListData>(clientListData); responseData = WebHelper.RequestByPost(KuaFuServerListUrl, clientBytes, 2000, 30000); if (responseData == null) { return(false); } kuaFuServerListResponseData = DataHelper2.BytesToObject <BuffServerListData>(responseData, 0, responseData.Length); if (null == kuaFuServerListResponseData || null == kuaFuServerListResponseData.listServerData || kuaFuServerListResponseData.listServerData.Count == 0) { return(false); } if (null != serverListResponseData && null != serverListResponseData.listServerData) { lock (Mutex) { foreach (var item in serverListResponseData.listServerData) { existAllIds.Add(item.nServerID); KuaFuServerInfo data; if (UpdateServerInfo(item, _ServerListAge, ServerFlags.NormalServer, out data, _ServerIdServerInfoDict)) { serverInfoChanged = true; } } } } if (null != kuaFuServerListResponseData && null != kuaFuServerListResponseData.listServerData) { lock (Mutex) { foreach (var item in kuaFuServerListResponseData.listServerData) { existAllIds.Add(item.nServerID); KuaFuServerInfo data; if (UpdateServerInfo(item, _ServerListAge, ServerFlags.KuaFuServer, out data, _ServerIdServerInfoDict)) { serverInfoChanged = true; } } foreach (var id in _ServerIdServerInfoDict.Keys) { if (!existAllIds.Contains(id)) { RemoveServerInfo(id, _ServerIdServerInfoDict); serverInfoChanged = true; } } if (serverInfoChanged) { _ServerListAge = nextServerListAge; } //默认所有跨服服务器都允许分配幻影寺院活动 foreach (var item in _ServerIdServerInfoDict.Values) { if ((item.Flags & ServerFlags.KuaFuServer) > 0) { existKfIds.Add(item.ServerId); } item.Age = _ServerListAge; } } } ClientAgentManager.Instance().SetAllKfServerId(existKfIds); } catch (System.Exception ex) { LogManager.WriteExceptionUseCache(ex.ToString()); return(false); } finally { Monitor.Exit(MutexServerList); } } return(true); }
private bool CheckBuildZhengBaRank(int selectRoleIfNewCreate, int nowMonth) { bool bMonthFirst = false; try { DbHelperMySQL.ExecuteSql(string.Format("INSERT IGNORE INTO t_async(`id`,`value`) VALUES({0},{1});", 30, 201111)); int oldMonth = (int)DbHelperMySQL.GetSingle("select value from t_async where id = " + 30); object ageObj_tiantiMonth = DbHelperMySQL.GetSingle("select value from t_async where id = " + 4); if (oldMonth != nowMonth && ageObj_tiantiMonth != null && ZhengBaUtils.MakeMonth(DataHelper2.GetRealDate((int)ageObj_tiantiMonth)) == nowMonth) { string strSql = string.Format("SELECT rid,rname,zoneid,duanweiid,duanweijifen,duanweirank,zhanli,data1,data2 FROM t_tianti_month_paihang ORDER BY duanweirank ASC LIMIT {0};", selectRoleIfNewCreate); MySqlDataReader sdr = DbHelperMySQL.ExecuteReader(strSql, false); while (sdr != null && sdr.Read()) { ZhengBaRoleInfoData roleData = new ZhengBaRoleInfoData(); roleData.RoleId = Convert.ToInt32(sdr["rid"]); roleData.ZoneId = Convert.ToInt32(sdr["zoneid"]); roleData.DuanWeiId = Convert.ToInt32(sdr["duanweiid"]); roleData.DuanWeiJiFen = Convert.ToInt32(sdr["duanweijifen"]); roleData.DuanWeiRank = Convert.ToInt32(sdr["duanweirank"]); roleData.ZhanLi = Convert.ToInt32(sdr["zhanli"]); roleData.RoleName = sdr["rname"].ToString(); if (!sdr.IsDBNull(sdr.GetOrdinal("data1"))) { roleData.TianTiPaiHangRoleData = (byte[])sdr["data1"]; } if (!sdr.IsDBNull(sdr.GetOrdinal("data2"))) { roleData.PlayerJingJiMirrorData = (byte[])sdr["data2"]; } if (string.IsNullOrEmpty(roleData.RoleName) && roleData.TianTiPaiHangRoleData != null) { TianTiPaiHangRoleData_OnlyName onlyName = DataHelper2.BytesToObject <TianTiPaiHangRoleData_OnlyName>(roleData.TianTiPaiHangRoleData, 0, roleData.TianTiPaiHangRoleData.Length); if (onlyName != null) { roleData.RoleName = onlyName.RoleName; } } string repSql = string.Format("REPLACE INTO t_zhengba_roles(`month`,rid,zoneid,duanweiid,duanweijifen,duanweirank,zhanli,`grade`,`group`,state,rname,data1,data2) VALUES({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},'{10}',@content,@mirror)", new object[] { nowMonth, roleData.RoleId, roleData.ZoneId, roleData.DuanWeiId, roleData.DuanWeiJiFen, roleData.DuanWeiRank, roleData.ZhanLi, 100, 0, 0, roleData.RoleName }); DbHelperMySQL.ExecuteSqlInsertImg(repSql, new List <Tuple <string, byte[]> > { new Tuple <string, byte[]>("content", roleData.TianTiPaiHangRoleData), new Tuple <string, byte[]>("mirror", roleData.PlayerJingJiMirrorData) }); } if (sdr != null) { sdr.Close(); } DbHelperMySQL.ExecuteSql(string.Format("REPLACE INTO t_async(`id`,`value`) VALUES({0},{1});", 30, nowMonth)); bMonthFirst = true; } } catch (Exception ex) { LogManager.WriteExceptionUseCache(ex.ToString()); } return(bMonthFirst); }