public PrepareDataForEnterGameOutMessage(ClientAgentBase sender, ulong __characterId__, int serverId) : base(sender, ServiceType.Rank, 6000, (int)MessageType.SS) { Request = new __RPC_Rank_PrepareDataForEnterGame_ARG_int32_serverId__(); mMessage.CharacterId = __characterId__; Request.ServerId = serverId; }
public AsyncReturnValue <int> UpdateReStateAsync(Coroutine co, string code, ClientAgentBase agent) { var ret = AsyncReturnValue <int> .Create(); ret.Value = -1; Task.Run(() => { var iData = new MySqlParameter[2]; iData[0] = new MySqlParameter("@incode", code) { MySqlDbType = MySqlDbType.VarChar }; iData[1] = new MySqlParameter("@myreturn", MySqlDbType.Int16); iData[1].Direction = ParameterDirection.Output; MySqlConnection conn = null; try { conn = CheckConnection(); using (var command = conn.CreateCommand()) { command.CommandText = UpdateReStateProcedureName; command.CommandType = CommandType.StoredProcedure; command.Parameters.AddRange(iData); using (var reader = command.ExecuteReader()) { if (!reader.Read()) { ret.Value = -1; } else { ret.Value = reader.GetInt16("myreturn"); reader.Close(); } } } } catch (Exception ex) { Logger.Error("RunProcedure error !! storedProcName: {0} ,ex{1}", UpdateStateProcedureName, ex); } finally { if (conn != null) { mConnections.Push(conn); } } if (!agent.mWaitingEvents.IsAddingCompleted) { agent.mWaitingEvents.Add(new Scorpion.ContinueEvent(co)); } }); return(ret); }
public GMCommandOutMessage(ClientAgentBase sender, ulong __characterId__, StringArray commonds) : base(sender, ServiceType.Rank, 6900, (int)MessageType.SS) { Request = new __RPC_Rank_GMCommand_ARG_StringArray_commonds__(); mMessage.CharacterId = __characterId__; Request.Commonds = commonds; }
public SBGetAllOnlineCharacterInServerOutMessage(ClientAgentBase sender, ulong __characterId__, int serverId) : base(sender, ServiceType.Rank, 6030, (int)MessageType.SB) { Request = new __RPC_Rank_SBGetAllOnlineCharacterInServer_ARG_int32_serverId__(); mMessage.CharacterId = __characterId__; Request.ServerId = serverId; }
public QueryBrokerStatusOutMessage(ClientAgentBase sender, ulong __characterId__, uint placeholder) : base(sender, ServiceType.Rank, 6040, (int)MessageType.SB) { Request = new __RPC_Rank_QueryBrokerStatus_ARG_uint32_placeholder__(); mMessage.CharacterId = __characterId__; Request.Placeholder = placeholder; }
public CheckLostOutMessage(ClientAgentBase sender, ulong __characterId__, ulong characterId) : base(sender, ServiceType.Rank, 6032, (int)MessageType.SS) { Request = new __RPC_Rank_CheckLost_ARG_uint64_characterId__(); mMessage.CharacterId = __characterId__; Request.CharacterId = characterId; }
public UpdateServerOutMessage(ClientAgentBase sender, ulong __characterId__, int placeholder) : base(sender, ServiceType.Rank, 6051, (int)MessageType.SAS) { Request = new __RPC_Rank_UpdateServer_ARG_int32_placeholder__(); mMessage.CharacterId = __characterId__; Request.Placeholder = placeholder; }
public SSCharacterChangeDataListOutMessage(ClientAgentBase sender, ulong __characterId__, RankChangeDataList changes) : base(sender, ServiceType.Rank, 6050, (int)MessageType.SS) { Request = new __RPC_Rank_SSCharacterChangeDataList_ARG_RankChangeDataList_changes__(); mMessage.CharacterId = __characterId__; Request.Changes = changes; }
public PrepareDataForLogoutOutMessage(ClientAgentBase sender, ulong __characterId__, uint placeholder) : base(sender, ServiceType.Rank, 6003, (int)MessageType.SS) { Request = new __RPC_Rank_PrepareDataForLogout_ARG_uint32_placeholder__(); mMessage.CharacterId = __characterId__; Request.Placeholder = placeholder; }
public PrepareDataForCreateCharacterOutMessage(ClientAgentBase sender, ulong __characterId__, int type) : base(sender, ServiceType.Rank, 6001, (int)MessageType.SS) { Request = new __RPC_Rank_PrepareDataForCreateCharacter_ARG_int32_type__(); mMessage.CharacterId = __characterId__; Request.Type = type; }
public SSNotifyCharacterOnConnetOutMessage(ClientAgentBase sender, ulong __characterId__, ulong clientId, ulong characterId) : base(sender, ServiceType.Rank, 6501, (int)MessageType.SS) { Request = new __RPC_Rank_SSNotifyCharacterOnConnet_ARG_uint64_clientId_uint64_characterId__(); mMessage.CharacterId = __characterId__; Request.ClientId = clientId; Request.CharacterId = characterId; }
public SBCleanClientCharacterDataOutMessage(ClientAgentBase sender, ulong __characterId__, ulong clientId, ulong characterId) : base(sender, ServiceType.Rank, 6500, (int)MessageType.SB) { Request = new __RPC_Rank_SBCleanClientCharacterData_ARG_uint64_clientId_uint64_characterId__(); mMessage.CharacterId = __characterId__; Request.ClientId = clientId; Request.CharacterId = characterId; }
public SSGetServerRankDataOutMessage(ClientAgentBase sender, ulong __characterId__, int serverId, int ranktype) : base(sender, ServiceType.Rank, 6054, (int)MessageType.SS) { Request = new __RPC_Rank_SSGetServerRankData_ARG_int32_serverId_int32_ranktype__(); mMessage.CharacterId = __characterId__; Request.ServerId = serverId; Request.Ranktype = ranktype; }
public ServerGMCommandOutMessage(ClientAgentBase sender, ulong __characterId__, string cmd, string param) : base(sender, ServiceType.Rank, 6048, (int)MessageType.SAS) { Request = new __RPC_Rank_ServerGMCommand_ARG_string_cmd_string_param__(); mMessage.CharacterId = __characterId__; Request.Cmd = cmd; Request.Param = param; }
public Rank_GetP1vP1ListOutMessage(ClientAgentBase sender, ulong __characterId__, int serverId, ulong characterId, string name) : base(sender, ServiceType.Rank, 6044, (int)MessageType.SS) { Request = new __RPC_Rank_Rank_GetP1vP1List_ARG_int32_serverId_uint64_characterId_string_name__(); mMessage.CharacterId = __characterId__; Request.ServerId = serverId; Request.CharacterId = characterId; Request.Name = name; }
public CompareRankOutMessage(ClientAgentBase sender, ulong __characterId__, int serverId, ulong characterId, int rank) : base(sender, ServiceType.Rank, 6045, (int)MessageType.SS) { Request = new __RPC_Rank_CompareRank_ARG_int32_serverId_uint64_characterId_int32_rank__(); mMessage.CharacterId = __characterId__; Request.ServerId = serverId; Request.CharacterId = characterId; Request.Rank = rank; }
public GetRankValueOutMessage(ClientAgentBase sender, ulong __characterId__, int serverId, int rankType, int idx) : base(sender, ServiceType.Rank, 6052, (int)MessageType.SS) { Request = new __RPC_Rank_GetRankValue_ARG_int32_serverId_int32_rankType_int32_idx__(); mMessage.CharacterId = __characterId__; Request.ServerId = serverId; Request.RankType = rankType; Request.Idx = idx; }
public SSGetRankDataByServerIdOutMessage(ClientAgentBase sender, ulong __characterId__, Int32Array serverList, long time, int ranktype) : base(sender, ServiceType.Rank, 6055, (int)MessageType.SS) { Request = new __RPC_Rank_SSGetRankDataByServerId_ARG_Int32Array_serverList_int64_time_int32_ranktype__(); mMessage.CharacterId = __characterId__; Request.ServerList = serverList; Request.Time = time; Request.Ranktype = ranktype; }
public NodifyModifyPlayerNameOutMessage(ClientAgentBase sender, ulong __characterId__, int serverId, ulong guid, string modifyName) : base(sender, ServiceType.Rank, 6901, (int)MessageType.SS) { Request = new __RPC_Rank_NodifyModifyPlayerName_ARG_int32_serverId_uint64_guid_string_modifyName__(); mMessage.CharacterId = __characterId__; Request.ServerId = serverId; Request.Guid = guid; Request.ModifyName = modifyName; }
public CharacterChangeDataOutMessage(ClientAgentBase sender, ulong __characterId__, int rankType, int serverId, ulong guid, string name, long value) : base(sender, ServiceType.Rank, 6042, (int)MessageType.SS) { Request = new __RPC_Rank_CharacterChangeData_ARG_int32_rankType_int32_serverId_uint64_guid_string_name_int64_value__(); mMessage.CharacterId = __characterId__; Request.RankType = rankType; Request.ServerId = serverId; Request.Guid = guid; Request.Name = name; Request.Value = value; }
public CharacterChangeLevelOutMessage(ClientAgentBase sender, ulong __characterId__, int serverId, ulong guid, string name, int level, int exp) : base(sender, ServiceType.Rank, 6041, (int)MessageType.SS) { Request = new __RPC_Rank_CharacterChangeLevel_ARG_int32_serverId_uint64_guid_string_name_int32_level_int32_exp__(); mMessage.CharacterId = __characterId__; Request.ServerId = serverId; Request.Guid = guid; Request.Name = name; Request.Level = level; Request.Exp = exp; }
public RankP1vP1FightOverOutMessage(ClientAgentBase sender, ulong __characterId__, int serverId, ulong characterId, ulong pvpCharacterId, int result, string name, string pvpName) : base(sender, ServiceType.Rank, 6046, (int)MessageType.SS) { Request = new __RPC_Rank_RankP1vP1FightOver_ARG_int32_serverId_uint64_characterId_uint64_pvpCharacterId_int32_result_string_name_string_pvpName__(); mMessage.CharacterId = __characterId__; Request.ServerId = serverId; Request.CharacterId = characterId; Request.PvpCharacterId = pvpCharacterId; Request.Result = result; Request.Name = name; Request.PvpName = pvpName; }
// 查看当前礼品码是否可以使用 public AsyncReturnValue <bool> CheckCodeIsActiveAsync(Coroutine co, string code, ClientAgentBase agent) { var ret = AsyncReturnValue <bool> .Create(); ret.Value = false; Task.Run(() => { var sql = string.Format("SELECT * FROM giftcodedb.giftcode where code = '{0}' and state = 0;", code); MySqlConnection conn = null; MySqlDataReader reader = null; try { conn = CheckConnection(); using (var cmd = conn.CreateCommand()) { cmd.CommandText = sql; cmd.CommandType = CommandType.Text; using (reader = cmd.ExecuteReader()) { if (reader != null) { if (reader.Read()) { ret.Value = true; } } } } } catch (Exception ex) { Logger.Error(ex, "CheckCodeIsActiveAsync error !! {0}"); } finally { if (conn != null) { mConnections.Push(conn); } if (!agent.mWaitingEvents.IsAddingCompleted) { agent.mWaitingEvents.Add(new Scorpion.ContinueEvent(co)); } } }); return(ret); }
public AsyncReturnValue <int, int, int> GetUngetPlayerLevel(Coroutine co, string userid, ClientAgentBase agent) { AsyncReturnValue <int, int, int> ret = AsyncReturnValue <int, int, int> .Create(); ret.Value1 = -1; ret.Value2 = -1; ret.Value3 = -1; Task.Run(() => { MySqlConnection conn = null; try { var iData = new MySqlParameter[4]; iData[0] = new MySqlParameter("@incode", userid) { MySqlDbType = MySqlDbType.VarChar }; iData[1] = new MySqlParameter("@returnLevel", MySqlDbType.Int16); iData[2] = new MySqlParameter("@returnRecharge", MySqlDbType.Int32); iData[3] = new MySqlParameter("@returnVipExp", MySqlDbType.Int32); iData[1].Direction = ParameterDirection.Output; iData[2].Direction = ParameterDirection.Output; iData[3].Direction = ParameterDirection.Output; conn = CheckConnection(); using (var command = conn.CreateCommand()) { command.CommandText = GetLevelProcedureName; command.CommandType = CommandType.StoredProcedure; command.Parameters.AddRange(iData); using (var reader = command.ExecuteReader()) { if (!reader.Read()) { ret.Value1 = -1; ret.Value2 = -1; ret.Value3 = -1; } else { if (reader.FieldCount < 3) { reader.Close(); } else { ret.Value1 = reader.GetInt16("returnLevel"); ret.Value2 = reader.GetInt16("returnRecharge"); ret.Value3 = reader.GetInt16("returnVipExp"); reader.Close(); } } } } } catch (Exception ex) { Logger.Error("RunProcedure error !! storedProcName: {0} ,ex{1}", UpdateStateProcedureName, ex); } finally { if (conn != null) { mConnections.Push(conn); } if (!agent.mWaitingEvents.IsAddingCompleted) { agent.mWaitingEvents.Add(new Scorpion.ContinueEvent(co)); } } }); return(ret); }
// 修改玩家反馈消息状态 public AsyncReturnValue <int> SetCharacterFanKuiStateAsync(Coroutine co, List <int> Ids, int State, ClientAgentBase agent) { var ret = AsyncReturnValue <int> .Create(); ret.Value = 0; Task.Run(() => { var ids = string.Empty; for (int i = 0; i < Ids.Count; i++) { if (i != Ids.Count - 1) { ids = ids + Ids[i] + ","; } else { ids = ids + Ids[i]; } } var sql = string.Format("Update giftcodedb.question set state = {0} where id IN({1});", State, ids); MySqlConnection conn = null; try { conn = CheckConnection(); using (var cmd = conn.CreateCommand()) { cmd.CommandText = sql; cmd.CommandType = CommandType.Text; ret.Value = cmd.ExecuteNonQuery(); } } catch (Exception ex) { Logger.Error(ex, "GetCharacterFanKuiAsync error !! {0}"); } finally { if (conn != null) { mConnections.Push(conn); } if (!agent.mWaitingEvents.IsAddingCompleted) { agent.mWaitingEvents.Add(new ContinueEvent(co)); } } }); return(ret); }
/// <summary> /// 执行多条SQL语句,实现数据库事务。 /// </summary> /// sql2000数据库 /// <param name="sqls">多条SQL语句</param> public AsyncReturnValue <int> ExecuteSqlTranAsync(Coroutine co, IEnumerable <string> sqls, ClientAgentBase agent) { AsyncReturnValue <int> ret = AsyncReturnValue <int> .Create(); ret.Value = 0; Task.Run(() => { MySqlConnection conn = null; try { conn = CheckConnection(); using (var cmd = conn.CreateCommand()) { foreach (var sql in sqls) { cmd.CommandText += sql; } ret.Value = cmd.ExecuteNonQuery(); } } catch (Exception ex) { Logger.Error("RunProcedure error !! storedProcName: {0} ,ex{1}", UpdateStateProcedureName, ex); } finally { if (conn != null) { mConnections.Push(conn); } if (!agent.mWaitingEvents.IsAddingCompleted) { agent.mWaitingEvents.Add(new ContinueEvent(co)); } } }); return(ret); }
// 返回玩家反馈消息 public AsyncReturnValue <GMGetFanKuiList> GetCharacterFanKuiAsync(Coroutine co, string TimeBegin, string TimeEnd, int StartIndex, int EndIndex, int State, ClientAgentBase agent) { var ret = AsyncReturnValue <GMGetFanKuiList> .Create(); ret.Value = new GMGetFanKuiList(); Task.Run(() => { var sql = string.Format( "SELECT * FROM giftcodedb.question where createtime >= '{0}' and createtime <= '{1}' and state = {2} limit {3},{4};", TimeBegin, TimeEnd, State, StartIndex, EndIndex); MySqlConnection conn = null; MySqlDataReader reader = null; try { conn = CheckConnection(); using (var cmd = conn.CreateCommand()) { cmd.CommandText = sql; cmd.CommandType = CommandType.Text; using (reader = cmd.ExecuteReader()) { if (reader != null) { while (reader.Read()) { // result += " CharacterId: " + reader.GetUInt32("ById").ToString(); // result += " CharacterName: " + reader.GetString("ByName"); // result += " Title: " + reader.GetString("Title"); // result += " Content: " + reader.GetString("Text"); // result += " createTime: " + reader.GetString("createtime"); // result += " state " + reader.GetInt16("state") + "; "; var tmp = new GMGetFanKui(); tmp.Id = reader.GetUInt32("id"); tmp.CharacterId = reader.GetInt64("ById"); tmp.Name = reader.GetString("ByName"); tmp.Title = reader.GetString("Title"); tmp.Content = reader.GetString("Text"); tmp.CreateTime = reader.GetString("createtime"); tmp.State = reader.GetInt32("state"); ret.Value.FanKuiList.Add(tmp); } } } } } catch (Exception ex) { Logger.Error(ex, "GetCharacterFanKuiAsync error !! {0}"); } finally { if (conn != null) { mConnections.Push(conn); } if (!agent.mWaitingEvents.IsAddingCompleted) { agent.mWaitingEvents.Add(new Scorpion.ContinueEvent(co)); } } }); return(ret); }