/// <summary> /// 请求游戏服务器IP列表 /// </summary> /// <returns></returns> public Message packServerInfoResp() { int gameID = 0; int gameDbID = 0; TLV_Structure tlvStrut = new TLV_Structure(TagName.ServerInfo_GameID, 4, message.m_packet.m_Body.getTLVByTag(TagName.ServerInfo_GameID).m_bValueBuffer); gameID = (int)tlvStrut.toInteger(); tlvStrut = new TLV_Structure(TagName.ServerInfo_GameDBID, 4, message.m_packet.m_Body.getTLVByTag(TagName.ServerInfo_GameDBID).m_bValueBuffer); gameDbID = (int)tlvStrut.toInteger(); DataSet ds = CommonInfo.serverIP_Query(gameID, gameDbID); if (ds != null && ds.Tables[0].Rows.Count <= 0) { return(Message.COMMON_MES_RESP(LanguageAPI.API_CommonAPI_GameListEmpty, Msg_Category.COMMON, ServiceKey.SERVERINFO_IP_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } else { Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[0]); strut.AddTagKey(TagName.ServerInfo_IP, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[1]); strut.AddTagKey(TagName.ServerInfo_City, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[2]); strut.AddTagKey(TagName.ServerInfo_GameName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); structList[i] = strut; } return(Message.COMMON_MES_RESP(structList, Msg_Category.COMMON, ServiceKey.SERVERINFO_IP_QUERY_RESP, 3)); } }
/// <summary> /// 得到所有游戏信息 /// </summary> /// <returns>游戏数据集</returns> public Message GM_QueryAll() { GMLogAPI logAPI = new GMLogAPI(); DataSet ds = null; try { ds = GMGameInfo.SelectAll(); logAPI.writeTitle(LanguageAPI.API_Display + LanguageAPI.API_GameInfoAPI_GameList, LanguageAPI.API_Display + LanguageAPI.API_GameInfoAPI_GameList); logAPI.writeContent(LanguageAPI.API_GameInfoAPI_GameID, LanguageAPI.API_GameInfoAPI_GameTitle, LanguageAPI.API_GameInfoAPI_GameDesp); Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[0]); strut.AddTagKey(TagName.GameID, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[1]); strut.AddTagKey(TagName.GameName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[2]); strut.AddTagKey(TagName.GameContent, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); structList[i] = strut; logAPI.writeData(ds.Tables[0].Rows[i].ItemArray[0].ToString(), ds.Tables[0].Rows[i].ItemArray[1].ToString(), ds.Tables[0].Rows[i].ItemArray[2].ToString()); } Console.Write(logAPI.Buffer.ToString()); return(Message.COMMON_MES_RESP(structList, Msg_Category.GAME_ADMIN, ServiceKey.GAME_QUERY_RESP, 3)); } catch (Common.Logic.Exception ex) { Console.WriteLine(ex.Message); return(null); } }
/// <summary> /// 得到GM帐号信息类 /// </summary> /// <param name="userID">用户ID</param> /// <returns>GM帐号类</returns> public Message GM_QuerySysAdminInfo(int userID) { //int sysAdmin = -1; System.Data.DataSet ds = null; try { //将GM帐号信息存入DATASET ds = GMUserInfo.getUserInfo(userID); Query_Structure[] structList = new Query_Structure[1]; if(ds!=null && ds.Tables[0].Rows.Count>0) { Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[0].ItemArray.Length); strut.AddTagKey(TagName.SysAdmin,TagFormat.TLV_INTEGER,4,TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER,ds.Tables[0].Rows[0].ItemArray[9])); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER,ds.Tables[0].Rows[0].ItemArray[5]); strut.AddTagKey(TagName.DepartID,TagFormat.TLV_INTEGER,(uint)bytes.Length,bytes); structList[0] = strut; return Message.COMMON_MES_RESP(structList,Msg_Category.USER_ADMIN,ServiceKey.USER_SYSADMIN_QUERY_RESP,2); } else { return Message.COMMON_MES_RESP(LanguageAPI.API_UserInfoAPI_NoAdmin,Msg_Category.USER_ADMIN,ServiceKey.USER_SYSADMIN_QUERY_RESP,TagName.ERROR_Msg,TagFormat.TLV_STRING); } } catch(System.Exception ex) { return Message.COMMON_MES_RESP(LanguageAPI.API_UserInfoAPI_NoAdmin,Msg_Category.USER_ADMIN,ServiceKey.USER_SYSADMIN_QUERY_RESP,TagName.ERROR_Msg,TagFormat.TLV_STRING); } }
/// <summary> /// 查询频道列表 /// </summary> /// <param name="account"></param> /// <param name="serverIP"></param> /// <returns></returns> public Message CR_Channel_QueryAll() { System.Data.DataSet ds = null; string serverIP = null; try { serverIP = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.CR_ServerIP).m_bValueBuffer); SqlHelper.log.WriteLog(lg.API_Display + lg.CR_CR + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.CR_CallBoardAPI_ChannelList); Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.CR_CR + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.CR_CallBoardAPI_ChannelList); ds = CRCallBoardInfo.Channel_QueryAll(serverIP); if (ds != null && ds.Tables[0].Rows.Count > 0) { Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[0])); strut.AddTagKey(TagName.CR_ChannelID, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[1]); strut.AddTagKey(TagName.CR_ChannelName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); structList[i] = strut; } return(Message.COMMON_MES_RESP(structList, Msg_Category.CR_ADMIN, ServiceKey.CR_CHANNEL_QUERY_RESP, 2)); } else { return(Message.COMMON_MES_RESP(lg.CR_CallBoardAPI_NoChannelList, Msg_Category.CR_ADMIN, ServiceKey.CR_CHANNEL_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception ex) { return(Message.COMMON_MES_RESP(lg.CR_CallBoardAPI_NoChannelList, Msg_Category.CR_ADMIN, ServiceKey.CR_CHANNEL_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
/// <summary> /// 得到模块信息类 /// </summary> /// <param name="moduleID">模块ID</param> /// <returns>模块类</returns> public GMModuleInfo GM_QueryModuleInfo(int moduleID) { System.Data.DataSet ds = null; GMModuleInfo ModuleInfo = null; try { //将模块信息存入DATASET ds = GMModuleInfo.QueryModuleInfo(moduleID); //构造一个模块信息类 Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length); strut.AddTagKey(TagName.Module_ID, TagFormat.TLV_INTEGER, 4, TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[0])); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[1]); strut.AddTagKey(TagName.GameName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[2]); strut.AddTagKey(TagName.ModuleName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[3]); strut.AddTagKey(TagName.ModuleClass, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[4]); strut.AddTagKey(TagName.ModuleContent, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); structList[i] = strut; } } catch (System.Exception ex) { Console.WriteLine(ex.Message); } return(ModuleInfo); }
/// <summary> /// 查询停封玩家信息 /// </summary> /// <param name="index">第几页</param> /// <param name="pageSize">每页记录数</param> /// <returns></returns> public Message Soccer_AccountState_Query(int index, int pageSize) { System.Data.DataSet ds = null; string serverIP = null; string str_type = ""; string str_string = ""; try { serverIP = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.Soccer_ServerIP).m_bValueBuffer); str_type = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.Soccer_Type).m_bValueBuffer); str_string = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.Soccer_String).m_bValueBuffer); SqlHelper.log.WriteLog(lg.API_Display + lg.Soccer_Soccer + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.Soccer_CharacterInfoAPI_Account + str_string + lg.Soccer_CharacterInfoAPI_BanInfo); Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.Soccer_Soccer + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.Soccer_CharacterInfoAPI_Account + str_string + lg.Soccer_CharacterInfoAPI_BanInfo); ds = SOCCERCharacterInfo.Soccer_AccountState_Query(serverIP, str_type, str_string); if (ds != null && ds.Tables[0].Rows.Count > 0) { //总页数 int pageCount = 0; pageCount = ds.Tables[0].Rows.Count % pageSize; if (pageCount > 0) { pageCount = ds.Tables[0].Rows.Count / pageSize + 1; } else { pageCount = ds.Tables[0].Rows.Count / pageSize; } if (index + pageSize > ds.Tables[0].Rows.Count) { pageSize = ds.Tables[0].Rows.Count - index; } Query_Structure[] structList = new Query_Structure[pageSize]; for (int i = index; i < index + pageSize; i++) { Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length + 1); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, UserValidate.validData(ds.Tables[0].Rows[i].ItemArray[0])); strut.AddTagKey(TagName.Soccer_loginId, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, UserValidate.validData(ds.Tables[0].Rows[i].ItemArray[1])); strut.AddTagKey(TagName.Soccer_regDate, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[2])); strut.AddTagKey(TagName.Soccer_m_id, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); strut.AddTagKey(TagName.PageCount, TagFormat.TLV_INTEGER, 4, TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, pageCount)); structList[i - index] = strut; } return(Message.COMMON_MES_RESP(structList, Msg_Category.SOCCER_ADMIN, ServiceKey.SOCCER_ACCOUNTSTATE_QUERY_RESP, 4)); } else { return(Message.COMMON_MES_RESP(lg.Soccer_CharacterInfoAPI_NoBan, Msg_Category.SOCCER_ADMIN, ServiceKey.SOCCER_ACCOUNTSTATE_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception ex) { return(Message.COMMON_MES_RESP(ex.Message, Msg_Category.SOCCER_ADMIN, ServiceKey.SOCCER_ACCOUNTSTATE_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
/// <summary> /// 玩家活动卡查询 /// </summary> /// <returns></returns> public Message RcUserActiveCard_Query() { string activeCode = null; string strDesc = null; int atype = 0; System.Collections.ArrayList ds = new System.Collections.ArrayList(); try { activeCode = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_activename).m_bValueBuffer); TLV_Structure strut1 = new TLV_Structure(TagName.RayCity_ActionType, 4, msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_ActionType).m_bValueBuffer); atype = (int)strut1.toInteger(); SqlHelper.log.WriteLog(lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Account + activeCode + lg.RayCityAPI_ActiveCard_Query); Console.WriteLine(DateTime.Now + lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Account + activeCode + lg.RayCityAPI_ActiveCard_Query); if (atype == 1) { ds = CharacterInfo.ActiveCard_Query(activeCode, 1, ref strDesc); } else if (atype == 2) { ds = CharacterInfo.ActiveCard_Query(activeCode, 2, ref strDesc); } if (ds != null && ds.Count > 0) { Query_Structure[] structList = new Query_Structure[1]; Query_Structure strut = new Query_Structure((uint)ds.Count); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds[0]); strut.AddTagKey(TagName.RayCity_rccdkey, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds[1]); strut.AddTagKey(TagName.RayCity_getuser, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds[2]); strut.AddTagKey(TagName.RayCity_gettime, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds[3]); strut.AddTagKey(TagName.RayCity_use_state, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds[4]); strut.AddTagKey(TagName.RayCity_activename, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); structList[0] = strut; return(Message.COMMON_MES_RESP(structList, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_ActiveCard_Query_Resp, 5)); } else { return(Message.COMMON_MES_RESP(strDesc, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_ActiveCard_Query_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception) { return(Message.COMMON_MES_RESP(strDesc, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_ActiveCard_Query_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
//频道列表请求 public Message ChannelList_Query() { System.Data.DataSet ds = null; string serverIP = null; try { serverIP = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_ServerIP).m_bValueBuffer); //发送登陆请求消息 connect_Req(serverIP); NoticeDataInfo.TruncateTable_Req(); while (listCnt <= 7) { //接受消息 if (receiveMsg() > 0) { //解析消息 parseMsg(); } //Thread.Sleep(1000); } client.Close(); SqlHelper.log.WriteLog(lg.API_Display + lg.SDOAPI_SDO + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.SDOAPI_SDONoticeInfoAPI_ChannelList); Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.SDOAPI_SDO + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.SDOAPI_SDONoticeInfoAPI_ChannelList); //从数据库里面将频道列表读出来 ds = NoticeDataInfo.ChannelList_Req(); if (ds != null && ds.Tables[0].Rows.Count > 0) { Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Query_Structure strut = new Query_Structure(5); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[0]); strut.AddTagKey(TagName.SDO_wPlanetID, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[1]); strut.AddTagKey(TagName.SDO_wChannelID, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[2]); strut.AddTagKey(TagName.SDO_iLimitUser, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[3]); strut.AddTagKey(TagName.SDO_iCurrentUser, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[4]); strut.AddTagKey(TagName.SDO_ipaddr, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); structList[i] = strut; } return(Message.COMMON_MES_RESP(structList, Msg_Category.SDO_ADMIN, ServiceKey.SDO_CHANNELLIST_QUERY_RESP, 5)); } else { return(Message.COMMON_MES_RESP(lg.SDOAPI_SDONoticeInfoAPI_NoChannelInfo, Msg_Category.SDO_ADMIN, ServiceKey.SDO_ACCOUNT_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception ex) { Console.WriteLine(ex.Message); return(Message.COMMON_MES_RESP(lg.SDOAPI_SDONoticeInfoAPI_NoChannelInfo, Msg_Category.SDO_ADMIN, ServiceKey.SDO_ACCOUNT_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
/// <summary> /// 查看本地被封停的帐号 /// </summary> /// <returns></returns> public Message O2JAMBanishmentLocal_Query() { DataSet ds = null; string serverIP = null; string account = null; try { serverIP = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_ServerIP).m_bValueBuffer); account = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_Account).m_bValueBuffer); SqlHelper.log.WriteLog(lg.API_Display + lg.O2JAM_O2JAM + "+>" + lg.O2JAM_CharacterInfoAPI_Account + account + lg.O2JAM_MemberInfoAPI_BanInfo); Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.O2JAM_O2JAM + "+>" + lg.O2JAM_CharacterInfoAPI_Account + account + lg.O2JAM_MemberInfoAPI_BanInfo); ds = MemberInfo.SDO_BanishmentLocal_Query(serverIP, account); if (ds != null && ds.Tables[0].Rows.Count > 0) { Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length); object context; if (ds.Tables[0].Rows[i].IsNull(0) == false) { context = ds.Tables[0].Rows[i].ItemArray[0]; } else { context = ""; } byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, context); strut.AddTagKey(TagName.SDO_Context, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_TIMESTAMP, ds.Tables[0].Rows[i].ItemArray[1]); strut.AddTagKey(TagName.SDO_StopTime, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes); object reason; if (ds.Tables[0].Rows[i].IsNull(2) == false) { reason = ds.Tables[0].Rows[i].ItemArray[2]; } else { reason = ""; } bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, reason); strut.AddTagKey(TagName.SDO_REASON, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); structList[i] = strut; } return(Message.COMMON_MES_RESP(structList, Msg_Category.SDO_ADMIN, ServiceKey.SDO_MEMBERLOCAL_BANISHMENT_RESP, 3)); } else { return(Message.COMMON_MES_RESP(lg.O2JAM_MemberInfoAPI_NoAccountBanInfo, Msg_Category.SDO_ADMIN, ServiceKey.SDO_MEMBERLOCAL_BANISHMENT_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception ex) { Console.WriteLine(ex.Message); return(Message.COMMON_MES_RESP(lg.O2JAM_MemberInfoAPI_NoAccountBanInfo, Msg_Category.SDO_ADMIN, ServiceKey.SDO_MEMBERLOCAL_BANISHMENT_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
/// <summary> /// 查看游戏里面所有道具 /// </summary> /// <returns></returns> public Message AvatarList_QueryALL() { string serverIP = null; string item_Name = null; int sex = 0; DataSet ds = null; try { serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AU_ServerIP).m_bValueBuffer); //道具名 item_Name = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AU_ItemName).m_bValueBuffer); SqlHelper.log.WriteLog(lg.API_Display + lg.AU_AU + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.AU_AUAvatarListAPI_AllGameItem); Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.AU_AU + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.AU_AUAvatarListAPI_AllGameItem); //请求所有分类道具列表 ds = AUAvatarListInfo.AvatarList_QueryAll(serverIP, item_Name); if (ds != null && ds.Tables[0].Rows.Count > 0) { Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length); //道具编号 byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[0])); strut.AddTagKey(TagName.AU_ItemID, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); //道具名 object itemName; if (ds.Tables[0].Rows[i].IsNull(1) == false) { itemName = ds.Tables[0].Rows[i].ItemArray[1]; } else { itemName = ""; } bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, itemName); strut.AddTagKey(TagName.AU_ItemName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[2])); strut.AddTagKey(TagName.AU_SexIndex, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[3])); strut.AddTagKey(TagName.AU_Cash, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); structList[i] = strut; } return(Message.COMMON_MES_RESP(structList, Msg_Category.AU_ADMIN, ServiceKey.AU_ITEMSHOP_QUERY_RESP, 4)); } else { return(Message.COMMON_MES_RESP(lg.AU_AUAvatarListAPI_NoGameItem, Msg_Category.AU_ADMIN, ServiceKey.AU_ITEMSHOP_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception ex) { return(Message.COMMON_MES_RESP(lg.AU_AUAvatarListAPI_NoGameItem, Msg_Category.AU_ADMIN, ServiceKey.AU_ITEMSHOP_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
public Message UpdateList_Query() { DataSet ds = null; try { SqlHelper.log.WriteLog(LanguageAPI.API_CommonAPI_UpdateInfo); Console.WriteLine(DateTime.Now + " -" + LanguageAPI.API_CommonAPI_UpdateInfo); ds = CommonInfo.UpdateList_Query(); if (ds != null && ds.Tables[0].Rows.Count > 0) { Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[0])); strut.AddTagKey(TagName.Update_ID, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); string updateModule; if (ds.Tables[0].Rows[i].IsNull(1) == false) { updateModule = ds.Tables[0].Rows[i].ItemArray[1].ToString(); } else { updateModule = ""; } bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, updateModule); strut.AddTagKey(TagName.Update_Module, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); string updateContext; if (ds.Tables[0].Rows[i].IsNull(2) == false) { updateContext = ds.Tables[0].Rows[i].ItemArray[2].ToString(); } else { updateContext = ""; } bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, updateContext); strut.AddTagKey(TagName.Update_Context, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_TIMESTAMP, Convert.ToDateTime(ds.Tables[0].Rows[i].ItemArray[3])); strut.AddTagKey(TagName.Update_Date, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes); structList[i] = strut; } return(Message.COMMON_MES_RESP(structList, Msg_Category.COMMON, ServiceKey.GMTOOLS_UPDATELIST_QUERY_RESP, 4)); } else { return(Message.COMMON_MES_RESP(LanguageAPI.API_CommonAPI_NoUpdateInfo, Msg_Category.COMMON, ServiceKey.GMTOOLS_UPDATELIST_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception ex) { return(Message.COMMON_MES_RESP(ex.Message, Msg_Category.COMMON, ServiceKey.GMTOOLS_UPDATELIST_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
/// <summary> /// 查看服务器所有停封帐号 /// </summary> /// <returns></returns> public Message O2JAMMember_banishment_QueryAll(int index, int pageSize) { string serverIP = null; DataSet ds = null; try { serverIP = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_ServerIP).m_bValueBuffer); SqlHelper.log.WriteLog(lg.API_Display + lg.O2JAM_O2JAM + "+>" + lg.API_CommonAPI_ServerIP + serverIP + lg.O2JAM_MemberInfoAPI_AllBanAccount); Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.O2JAM_O2JAM + "+>" + lg.API_CommonAPI_ServerIP + serverIP + lg.O2JAM_MemberInfoAPI_AllBanAccount); ds = MemberInfo.SDO_Banishment_QueryAll(serverIP); if (null != ds && ds.Tables[0].Rows.Count > 0) { //总页数 int pageCount = 0; pageCount = ds.Tables[0].Rows.Count % pageSize; if (pageCount > 0) { pageCount = ds.Tables[0].Rows.Count / pageSize + 1; } else { pageCount = ds.Tables[0].Rows.Count / pageSize; } if (index + pageSize > ds.Tables[0].Rows.Count) { pageSize = ds.Tables[0].Rows.Count - index; } Query_Structure[] structList = new Query_Structure[pageSize]; for (int i = index; i < index + pageSize; i++) { Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length + 1); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[0]); strut.AddTagKey(TagName.SDO_UserIndexID, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[1]); strut.AddTagKey(TagName.SDO_Account, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_TIMESTAMP, ds.Tables[0].Rows[i].ItemArray[2]); strut.AddTagKey(TagName.SDO_StopTime, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes); //总页数 strut.AddTagKey(TagName.PageCount, TagFormat.TLV_INTEGER, 4, TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, pageCount)); structList[i - index] = strut; } return(Message.COMMON_MES_RESP(structList, Msg_Category.SDO_ADMIN, ServiceKey.SDO_MEMBERBANISHMENT_QUERY_RESP, 4)); } else { return(Message.COMMON_MES_RESP(lg.O2JAM_MemberInfoAPI_NoBanAccount, Msg_Category.SDO_ADMIN, ServiceKey.SDO_MEMBERBANISHMENT_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception e) { return(Message.COMMON_MES_RESP(e.Message, Msg_Category.SDO_ADMIN, ServiceKey.SDO_MEMBERBANISHMENT_QUERY_RESP)); } }
/// <summary> /// 网关查询 /// </summary> /// <returns></returns> public Message SDO_GateWay_Query(int index, int pageSize) { string serverIP = null; string gatewayIP = null; System.Data.DataSet ds = null; try { serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_ServerIP).m_bValueBuffer); gatewayIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_Address).m_bValueBuffer); SqlHelper.log.WriteLog(DateTime.Now + " - " + lg.API_Display + lg.SDOAPI_SDO + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.SDOAPI_SDOCharacterInfoAPI_GateWay); Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.SDOAPI_SDO + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.SDOAPI_SDOCharacterInfoAPI_GateWay); //查询GATEWAY IP ds = CharacterInfo.ServerGateWay_Query(serverIP, gatewayIP); if (ds != null && ds.Tables[0].Rows.Count > 0) { //总页数 int pageCount = 0; pageCount = ds.Tables[0].Rows.Count % pageSize; if (pageCount > 0) { pageCount = ds.Tables[0].Rows.Count / pageSize + 1; } else { pageCount = ds.Tables[0].Rows.Count / pageSize; } if (index + pageSize > ds.Tables[0].Rows.Count) { pageSize = ds.Tables[0].Rows.Count - index; } Query_Structure[] structList = new Query_Structure[pageSize]; for (int i = index; i < index + pageSize; i++) { Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length + 1); //ADDR IP byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[0]); strut.AddTagKey(TagName.SDO_Address, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); //总页数 strut.AddTagKey(TagName.PageCount, TagFormat.TLV_INTEGER, 4, TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, pageCount)); structList[i - index] = strut; } return(Message.COMMON_MES_RESP(structList, Msg_Category.SDO_ADMIN, ServiceKey.SDO_GATEWAY_QUERY_RESP, 2)); } else { return(Message.COMMON_MES_RESP(lg.SDOAPI_SDOCharacterInfoAPI_NotOnline, Msg_Category.SDO_ADMIN, ServiceKey.SDO_GATEWAY_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception ex) { return(Message.COMMON_MES_RESP(lg.SDOAPI_SDOCharacterInfoAPI_NotOnline, Msg_Category.SDO_ADMIN, ServiceKey.SDO_GATEWAY_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
/// <summary> /// 查看本地被封停的帐号 /// </summary> /// <returns></returns> public Message Audition_BanishmentLocal_Query() { System.Data.DataSet ds = null; string serverIP = null; string account = null; try { serverIP = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AU_ServerIP).m_bValueBuffer); account = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AU_ACCOUNT).m_bValueBuffer); //account = AUMemberInfo.Audition_Identity9you_Query(serverIP,account); SqlHelper.log.WriteLog(lg.API_Display + lg.AU_AU + "+>" + lg.AU_AUAvatarListAPI_Account + account + lg.AU_AUMemberInfoAPI_BanInfo); Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.AU_AU + "+>" + lg.AU_AUAvatarListAPI_Account + account + lg.AU_AUMemberInfoAPI_BanInfo); ds = AUMemberInfo.Audition_BanishmentLocal_Query(serverIP, account); if (ds != null && ds.Tables[0].Rows.Count > 0) { Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[0]); strut.AddTagKey(TagName.AU_ACCOUNT, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[1]); strut.AddTagKey(TagName.AU_UserNick, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[2]); strut.AddTagKey(TagName.AU_ServerIP, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); object reason; if (ds.Tables[0].Rows[i].IsNull(3) == false) { reason = ds.Tables[0].Rows[i].ItemArray[3]; } else { reason = ""; } bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, reason); strut.AddTagKey(TagName.AU_Reason, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_TIMESTAMP, ds.Tables[0].Rows[i].ItemArray[4]); strut.AddTagKey(TagName.AU_BanDate, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes); structList[i] = strut; } return(Message.COMMON_MES_RESP(structList, Msg_Category.AU_ADMIN, ServiceKey.AU_ACCOUNTLOCAL_QUERY_RESP, 5)); } else { return(Message.COMMON_MES_RESP(lg.AU_AUMemberInfoAPI_NoAccountBanInfo, Msg_Category.AU_ADMIN, ServiceKey.AU_ACCOUNTLOCAL_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception ex) { Console.WriteLine(ex.Message); return(Message.COMMON_MES_RESP(lg.AU_AUMemberInfoAPI_NoAccountBanInfo, Msg_Category.AU_ADMIN, ServiceKey.AU_ACCOUNTLOCAL_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
/// <summary> /// 查询玩家宠物信息 /// </summary> /// <returns></returns> public Message SDO_PetInfo_Query() { string serverIP = null; int userIndexID = 0; System.Data.DataSet ds = null; try { serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_ServerIP).m_bValueBuffer); TLV_Structure strut = new TLV_Structure(TagName.SDO_UserIndexID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.SDO_UserIndexID).m_bValueBuffer); userIndexID = (int)strut.toInteger(); SqlHelper.log.WriteLog("流覽超級舞者+>" + CommonInfo.serverIP_Query(serverIP) + "玩家" + userIndexID + "寵物資訊!"); Console.WriteLine(DateTime.Now + " - 流覽超級舞者+>" + CommonInfo.serverIP_Query(serverIP) + "玩家" + userIndexID + "寵物資訊!"); ds = ItemShopInfo.SDOPetInfo_Query(serverIP, userIndexID); if (ds != null && ds.Tables[0].Rows.Count > 0) { Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Query_Structure strut1 = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[0]); strut1.AddTagKey(TagName.SDO_NickName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[1]); strut1.AddTagKey(TagName.SDO_ItemName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_TIMESTAMP, ds.Tables[0].Rows[i].ItemArray[2]); strut1.AddTagKey(TagName.SDO_DateLimit, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[3]); strut1.AddTagKey(TagName.SDO_State, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[4]); strut1.AddTagKey(TagName.SDO_Level, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[5]); strut1.AddTagKey(TagName.SDO_Exp, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[6]); strut1.AddTagKey(TagName.SDO_Food, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[7]); strut1.AddTagKey(TagName.SDO_mood, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); structList[i] = strut1; } return(Message.COMMON_MES_RESP(structList, Msg_Category.SDO_ADMIN, ServiceKey.SDO_PetInfo_Query_RESP, 8)); } else { return(Message.COMMON_MES_RESP("沒有相關寵物資訊", Msg_Category.SDO_ADMIN, ServiceKey.SDO_PetInfo_Query_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception ex) { Console.WriteLine(ex.Message); return(Message.COMMON_MES_RESP("沒有相關寵物資訊", Msg_Category.SDO_ADMIN, ServiceKey.SDO_PetInfo_Query_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
/// <summary> /// 修改用户令牌 /// </summary> /// <returns></returns> public Message Modify_User_Token() { string userName = null; string esn = null; string code = null; string description = null; string service = null; try { esn = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.TOKEN_esn).m_bValueBuffer); userName = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.TOKEN_username).m_bValueBuffer); service = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.TOKEN_service).m_bValueBuffer); SqlHelper.log.WriteLog("修改用户" + userName + "的当前状态!"); Console.WriteLine(DateTime.Now + " - 修改用户" + userName + "的当前状态!"); ArrayList ds = UserauthenticInfo.Modify_User_Token("asas", service, userName, esn); if (ds != null && ds.Count > 0) { for (int i = 0; i < ds.Count; i++) { ArrayList para = (ArrayList)ds[i]; if (para[0].ToString() == "code") { code = ConfigurationSettings.AppSettings[para[1].ToString()]; } if (para[0].ToString() == "description") { description = para[1].ToString(); } } Query_Structure[] structList = new Query_Structure[1]; Query_Structure strut = new Query_Structure(2); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, code); strut.AddTagKey(TagName.TOKEN_code, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, description); strut.AddTagKey(TagName.TOKEN_description, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); structList[0] = strut; return(Message.COMMON_MES_RESP(structList, Msg_Category.CARD_ADMIN, ServiceKey.TOKEN_MODIFYUSER_QUERY_RESP, 2)); } else { return(Message.COMMON_MES_RESP("FAILURE", Msg_Category.CARD_ADMIN, ServiceKey.TOKEN_MODIFYUSER_QUERY_RESP)); } } catch (System.Exception ex) { return(Message.COMMON_MES_RESP("FAILURE", Msg_Category.CARD_ADMIN, ServiceKey.TOKEN_MODIFYUSER_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
/// <summary> /// 查看玩家服务器激活状态 /// </summary> /// <returns></returns> public Message O2JAMMemberInfo_Query() { string serverIP = null; string account = null; DataSet ds = null; try { serverIP = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_ServerIP).m_bValueBuffer); account = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_Account).m_bValueBuffer); SqlHelper.log.WriteLog(lg.API_Display + lg.O2JAM_O2JAM + "+>" + lg.API_CommonAPI_ServerIP + serverIP + lg.O2JAM_CharacterInfoAPI_Account + account + lg.O2JAM_MemberInfoAPI_ActiveState); Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.O2JAM_O2JAM + "+>" + lg.API_CommonAPI_ServerIP + serverIP + lg.O2JAM_CharacterInfoAPI_Account + account + lg.O2JAM_MemberInfoAPI_ActiveState); ds = MemberInfo.memberInfo_Query(serverIP, account); if (ds != null && ds.Tables[0].Rows.Count > 0) { Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length + 1); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[0]); strut.AddTagKey(TagName.SDO_Account, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[1]); strut.AddTagKey(TagName.SDO_9YouAccount, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[2]); strut.AddTagKey(TagName.SDO_NickName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_BOOLEAN, ds.Tables[0].Rows[i].ItemArray[3]); strut.AddTagKey(TagName.SDO_SEX, TagFormat.TLV_BOOLEAN, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_DATE, ds.Tables[0].Rows[i].ItemArray[4]); strut.AddTagKey(TagName.SDO_RegistDate, TagFormat.TLV_DATE, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_DATE, ds.Tables[0].Rows[i].ItemArray[5]); strut.AddTagKey(TagName.SDO_FirstLogintime, TagFormat.TLV_DATE, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_DATE, ds.Tables[0].Rows[i].ItemArray[6]); strut.AddTagKey(TagName.SDO_LastLogintime, TagFormat.TLV_DATE, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[7]); strut.AddTagKey(TagName.SDO_Ispad, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, 1); strut.AddTagKey(TagName.SDO_ActiveStatus, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); structList[i] = strut; } return(Message.COMMON_MES_RESP(structList, Msg_Category.SDO_ADMIN, ServiceKey.SDO_ACCOUNT_QUERY_RESP, 9)); } else { return(Message.COMMON_MES_RESP(lg.O2JAM_MemberInfoAPI_NoActived, Msg_Category.SDO_ADMIN, ServiceKey.SDO_ACCOUNT_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception e) { Console.WriteLine(e.Message); return(Message.COMMON_MES_RESP(lg.O2JAM_MemberInfoAPI_NoActived, Msg_Category.SDO_ADMIN, ServiceKey.SDO_ACCOUNT_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
public Message UserNick_Query() { string account = ""; string nickName = ""; System.Data.DataSet ds = null; try { account = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.UserName).m_bValueBuffer); ds = CardDetailInfo.UserName_Query(account, nickName); Query_Structure[] structList = new Query_Structure[1]; if (ds != null && ds.Tables[0].Rows.Count > 0) { Query_Structure strut = new Query_Structure(1); nickName = ds.Tables[0].Rows[0].ItemArray[1].ToString(); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, nickName); strut.AddTagKey(TagName.CARD_nickname, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); structList[0] = strut; return(Message.COMMON_MES_RESP(structList, Msg_Category.CARD_ADMIN, ServiceKey.CARD_USERNICK_QUERY_RESP, 1)); } else { return(Message.COMMON_MES_RESP(lg.CardDetail_NoRegisterInfo, Msg_Category.CARD_ADMIN, ServiceKey.CARD_USERNICK_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception ex) { return(Message.COMMON_MES_RESP(lg.CardDetail_NoRegisterInfo, Msg_Category.CARD_ADMIN, ServiceKey.CARD_USERNICK_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
/// <summary> /// 玩家人物资料信息 /// </summary> /// <returns></returns> public Message friendsnick_Query() { string serverIP = null; string account = null; DataSet ds = null; try { serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_ServerIP).m_bValueBuffer); account = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_Account).m_bValueBuffer); Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.SDOAPI_SDO + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + " " + account + lg.SDOAPI_SDOCharacterInfoAPI_FriendList + "!"); ds = CharacterInfo.friendsnick_Query(serverIP, account); if (ds != null && ds.Tables[0].Rows.Count > 0) { Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[0]); strut.AddTagKey(TagName.SDO_NickName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); structList[i] = strut; } return(Message.COMMON_MES_RESP(structList, Msg_Category.SDO_ADMIN, ServiceKey.SDO_FRIENDS_QUERY_RESP, 1)); } else { return(Message.COMMON_MES_RESP(lg.SDOAPI_SDOCharacterInfoAPI_NoFriendList, Msg_Category.SDO_ADMIN, ServiceKey.SDO_FRIENDS_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception ex) { Console.WriteLine(ex.Message); return(Message.COMMON_MES_RESP(lg.SDOAPI_SDOCharacterInfoAPI_NoFriendList, Msg_Category.SDO_ADMIN, ServiceKey.SDO_FRIENDS_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
/// <summary> /// 查看玩家消费记录 /// </summary> /// <returns></returns> public Message UserConsume_QuerySum() { string serverIP = null; string account = null; DateTime beginDate; DateTime endDate; int kind = -1; int buyType = -1; DataSet ds = null; try { serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.o2jam_ServerIP).m_bValueBuffer); account = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.o2jam_UserID).m_bValueBuffer); TLV_Structure tlvStrut = new TLV_Structure(TagName.o2jam_KIND, 4, msg.m_packet.m_Body.getTLVByTag(TagName.o2jam_KIND).m_bValueBuffer); kind = (int)tlvStrut.toInteger(); tlvStrut = new TLV_Structure(TagName.O2JAM_BuyType, 4, msg.m_packet.m_Body.getTLVByTag(TagName.O2JAM_BuyType).m_bValueBuffer); buyType = (int)tlvStrut.toInteger(); tlvStrut = new TLV_Structure(TagName.o2jam_BeginDate, 3, msg.m_packet.m_Body.getTLVByTag(TagName.o2jam_BeginDate).m_bValueBuffer); beginDate = tlvStrut.toDate(); tlvStrut = new TLV_Structure(TagName.o2jam_EndDate, 3, msg.m_packet.m_Body.getTLVByTag(TagName.o2jam_EndDate).m_bValueBuffer); endDate = tlvStrut.toDate(); SqlHelper.log.WriteLog(lg.API_Display + lg.O2JAM_O2JAM + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.O2JAM_CharacterInfoAPI_Account + account + lg.O2JAM_ItemShopInfoAPI_SumConsumeRecord); Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.O2JAM_O2JAM + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.O2JAM_CharacterInfoAPI_Account + account + lg.O2JAM_ItemShopInfoAPI_SumConsumeRecord); ds = ItemShopInfo.userConsume_QuerySum(serverIP, account, kind, buyType, beginDate, endDate); if (ds != null && ds.Tables[0].Rows.Count > 0) { Query_Structure[] structList = new Query_Structure[1]; Query_Structure strut = new Query_Structure(2); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[0].ItemArray[0]); strut.AddTagKey(TagName.o2jam_GEM, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[0].ItemArray[1]); strut.AddTagKey(TagName.o2jam_MCASH, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); structList[0] = strut; return(Message.COMMON_MES_RESP(structList, Msg_Category.O2JAM_ADMIN, ServiceKey.O2JAM_CONSUME_SUM_QUERY_RESP, 2)); } else { return(Message.COMMON_MES_RESP(lg.O2JAM_ItemShopInfoAPI_NoSumConsumeRecord, Msg_Category.O2JAM_ADMIN, ServiceKey.O2JAM_CONSUME_SUM_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception) { return(Message.COMMON_MES_RESP(lg.O2JAM_ItemShopInfoAPI_NoSumConsumeRecord, Msg_Category.O2JAM_ADMIN, ServiceKey.O2JAM_CONSUME_SUM_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
/// <summary> /// 请求所有游戏服务器IP列表 /// </summary> /// <returns></returns> public Message packServerInfoALLResp() { DataSet ds = CommonInfo.serverIP_QueryAll(); if (ds != null && ds.Tables[0].Rows.Count <= 0) { return(Message.COMMON_MES_RESP(LanguageAPI.API_CommonAPI_GameListEmpty, Msg_Category.COMMON, ServiceKey.SERVERINFO_IP_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } else { Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[0]); strut.AddTagKey(TagName.ServerInfo_Idx, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[1]); strut.AddTagKey(TagName.ServerInfo_IP, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[2]); strut.AddTagKey(TagName.ServerInfo_City, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[3]); strut.AddTagKey(TagName.ServerInfo_GameID, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[4]); strut.AddTagKey(TagName.ServerInfo_GameName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[5]); strut.AddTagKey(TagName.ServerInfo_GameDBID, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[6]); strut.AddTagKey(TagName.ServerInfo_GameFlag, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); structList[i] = strut; } return(Message.COMMON_MES_RESP(structList, Msg_Category.COMMON, ServiceKey.SERVERINFO_IP_QUERY_RESP, 7)); } }
/// <summary> /// 得到所有模块信息 /// </summary> /// <returns>模块数据集</returns> public Message GM_QueryAll(int index, int pageSize) { GMLogAPI logAPI = new GMLogAPI(); DataSet ds = null; try { logAPI.writeTitle(LanguageAPI.API_Display + LanguageAPI.API_ModuleInfoAPI_ModuleList, LanguageAPI.API_Display + LanguageAPI.API_ModuleInfoAPI_ModuleList); logAPI.writeContent(LanguageAPI.API_GameInfoAPI_ModuleID, LanguageAPI.API_GameInfoAPI_ModuleTitle, LanguageAPI.API_GameInfoAPI_ModuleClass, LanguageAPI.API_GameInfoAPI_ModuleDesp); ds = GMModuleInfo.SelectAll(); if (ds.Tables[0].Rows.Count <= 0) { return(Message.COMMON_MES_RESP(LanguageAPI.API_ModuleInfoAPI_NoModuleList, Msg_Category.MODULE_ADMIN, ServiceKey.MODULE_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } else { //总页数 int pageCount = 0; pageCount = ds.Tables[0].Rows.Count % pageSize; if (pageCount > 0) { pageCount = ds.Tables[0].Rows.Count / pageSize + 1; } else { pageCount = ds.Tables[0].Rows.Count / pageSize; } if (index + pageSize > ds.Tables[0].Rows.Count) { pageSize = ds.Tables[0].Rows.Count - index; } Query_Structure[] structList = new Query_Structure[pageSize]; for (int i = index; i < index + pageSize; i++) { Query_Structure strut = new Query_Structure(7); strut.AddTagKey(TagName.GameID, TagFormat.TLV_INTEGER, 4, TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[0])); strut.AddTagKey(TagName.Module_ID, TagFormat.TLV_INTEGER, 4, TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[1])); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[2]); strut.AddTagKey(TagName.GameName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[3]); strut.AddTagKey(TagName.ModuleName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[4]); strut.AddTagKey(TagName.ModuleClass, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[5]); strut.AddTagKey(TagName.ModuleContent, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); //总页数 strut.AddTagKey(TagName.PageCount, TagFormat.TLV_INTEGER, 4, TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, pageCount)); structList[i - index] = strut; logAPI.writeData(ds.Tables[0].Rows[i].ItemArray[1].ToString(), ds.Tables[0].Rows[i].ItemArray[2].ToString(), ds.Tables[0].Rows[i].ItemArray[3].ToString(), ds.Tables[0].Rows[i].ItemArray[4].ToString()); } Console.Write(logAPI.Buffer.ToString()); return(Message.COMMON_MES_RESP(structList, Msg_Category.MODULE_ADMIN, ServiceKey.MODULE_QUERY_RESP, 7)); } } catch (SqlException ex) { Console.WriteLine(ex.Message); return(Message.COMMON_MES_RESP(ex.Message, Msg_Category.MODULE_ADMIN, ServiceKey.MODULE_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
/// <summary-> /// 玩家积分查询 /// </summary> /// <returns></returns> public Message UserIntegral_Query() { string serverIP = null; string account = null; System.Data.DataSet ds = null; try { serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AU_ServerIP).m_bValueBuffer); account = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AuShop_userid).m_bValueBuffer); SqlHelper.log.WriteLog(lg.API_Display + lg.NineYou + lg.CardDetail_Account + account + lg.UserCashPurchase_Integral); Console.WriteLine(DateTime.Now + " -" + lg.API_Display + lg.NineYou + lg.CardDetail_Account + account + lg.UserCashPurchase_Integral); ds = UserCashPurchase.UserIntegral_Query(serverIP, account); if (ds != null && ds.Tables[0].Rows.Count > 0) { Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[0]); strut.AddTagKey(TagName.AuShop_username, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[1])); strut.AddTagKey(TagName.AuShop_aup, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[2])); strut.AddTagKey(TagName.AuShop_usefeesum, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[3])); strut.AddTagKey(TagName.AuShop_useaupsum, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[4])); strut.AddTagKey(TagName.AuShop_buyitemsum, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); structList[i] = strut; } return(Message.COMMON_MES_RESP(structList, Msg_Category.AUSHOP_ADMIN, ServiceKey.AUSHOP_USERINTERGRAL_QUERY_RESP, 5)); } else { return(Message.COMMON_MES_RESP(lg.UserCashPurchase_NoIntegral, Msg_Category.AUSHOP_ADMIN, ServiceKey.AUSHOP_USERINTERGRAL_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception ex) { Console.WriteLine(ex.Message); return(Message.COMMON_MES_RESP(lg.UserCashPurchase_NoIntegral, Msg_Category.AUSHOP_ADMIN, ServiceKey.AUSHOP_USERINTERGRAL_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
/// <summary-> /// 道具回收兑换详细记录 /// </summary> /// <returns></returns> public Message UserAvatarItemRevDetail_Query() { string serverIP = null; string orderID = null; System.Data.DataSet ds = null; try { serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AU_ServerIP).m_bValueBuffer); orderID = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.AuShop_orderid).m_bValueBuffer); SqlHelper.log.WriteLog(lg.API_Display + lg.NineYou + lg.CardDetail_Account + orderID + lg.UserCashPurchase_ItemChangeDetails); Console.WriteLine(DateTime.Now + " -" + lg.API_Display + lg.NineYou + lg.CardDetail_Account + orderID + lg.UserCashPurchase_ItemChangeDetails); ds = UserCashPurchase.UserAvatarItemRevDetail_Query(serverIP, orderID); if (ds != null && ds.Tables[0].Rows.Count > 0) { Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[0].ItemArray.Length); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[0]); strut.AddTagKey(TagName.AuShop_pname, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[1]); strut.AddTagKey(TagName.AuShop_username, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[2]); strut.AddTagKey(TagName.AuShop_getusername, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_TIMESTAMP, Convert.ToDateTime(ds.Tables[0].Rows[i].ItemArray[3])); strut.AddTagKey(TagName.AuShop_buytime2, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[4]); strut.AddTagKey(TagName.AuShop_zone, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); structList[i] = strut; } return(Message.COMMON_MES_RESP(structList, Msg_Category.AUSHOP_ADMIN, ServiceKey.AUSHOP_AVATARECOVER_DETAIL_QUERY_RESP, 5)); } else { return(Message.COMMON_MES_RESP(lg.UserCashPurchase_NoItemChangeDetails, Msg_Category.AUSHOP_ADMIN, ServiceKey.AUSHOP_AVATARECOVER_DETAIL_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception ex) { Console.WriteLine(ex.Message); return(Message.COMMON_MES_RESP(lg.UserCashPurchase_NoItemChangeDetails, Msg_Category.AUSHOP_ADMIN, ServiceKey.AUSHOP_AVATARECOVER_DETAIL_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
/// <summary> /// lg.SDAPI_SDItemLogInfoAPI_Account+lg.SDAPI_SDItemShopAPI_ConsumeRecord /// </summary> /// <returns>Messagebody</returns> public Message SD_Card_Info_Query() { string activeCode = null; string userName = null; string typeName = null; string strDesc = null; int type = -1; System.Collections.ArrayList ds = new System.Collections.ArrayList(); try { activeCode = Encoding.Unicode.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SD_ActiceCode).m_bValueBuffer); //用户名 userName = Encoding.Unicode.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SD_UserName).m_bValueBuffer); SqlHelper.log.WriteLog(lg.SDAPI_SDItemMsG + lg.SDAPI_SD + "+>" + lg.SDAPI_SDItemShopAPI_ConsumeRecord + activeCode + lg.Logic_Exception_ExpectedValue + lg.SDAPI_SDItemShopAPI_NoIntegral + lg.SDAPI_SDChallengeDataAPI_ProbabilityList + "!"); Console.WriteLine(DateTime.Now + lg.SDAPI_SDItemMsG + lg.SDAPI_SD + "+>" + lg.SDAPI_SDItemShopAPI_ConsumeRecord + activeCode + lg.SDAPI_SDItemShopAPI_NoIntegral + lg.SDAPI_SDChallengeDataAPI_ProbabilityList + "!"); ds = SDAccountInfo.Card_Info_Query(userName, activeCode, ref strDesc); if (ds != null && ds.Count > 0) { Query_Structure[] structList = new Query_Structure[1]; Query_Structure strut = new Query_Structure((uint)ds.Count); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds[0]); strut.AddTagKey(TagName.SD_ActiceCode, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds[1]); strut.AddTagKey(TagName.SD_passWd, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds[2]); strut.AddTagKey(TagName.SD_UserName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds[3]); strut.AddTagKey(TagName.SD_ServerName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, Convert.ToString(ds[4])); strut.AddTagKey(TagName.SD_Time, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, Convert.ToString(ds[5])); strut.AddTagKey(TagName.SD_ServerIP, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); if (ds[6].ToString() == "1") { typeName = "新手卡"; } else { typeName = "鑽石卡"; } bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, typeName); strut.AddTagKey(TagName.Magic_TypeName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); structList[0] = strut; return(Message.COMMON_MES_RESP(structList, Msg_Category.SD_ADMIN, ServiceKey.SD_ActiveCode_Query_Resp, 7)); } else { return(Message.COMMON_MES_RESP(strDesc, Msg_Category.SD_ADMIN, ServiceKey.SD_ActiveCode_Query_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception) { return(Message.COMMON_MES_RESP(strDesc, Msg_Category.SD_ADMIN, ServiceKey.SD_ActiveCode_Query_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
/// <summary> /// 查看玩家上下线状态 /// </summary> /// <returns></returns> public Message UserOnline_Query() { string serverIP = null; string account = null; DataSet ds = null; try { serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.O2JAM2_ServerIP).m_bValueBuffer); account = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.O2JAM2_UserID).m_bValueBuffer); SqlHelper.log.WriteLog(lg.API_Display + lg.O2JAM2API_BAF + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.O2JAM2API_AccountInfoAPI_Account + account + lg.O2JAM2API_ItemShopAPI_OnlineStatus); Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.O2JAM2API_BAF + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.O2JAM2API_AccountInfoAPI_Account + account + lg.O2JAM2API_ItemShopAPI_OnlineStatus); ds = ItemShopInfo.userOnline_Query(serverIP, account); if (ds.Tables[0].Rows.Count > 0) { Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[0]); strut.AddTagKey(TagName.O2JAM2_UserIndexID, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[1]); strut.AddTagKey(TagName.O2JAM2_UserID, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_TIMESTAMP, ds.Tables[0].Rows[i].ItemArray[2]); strut.AddTagKey(TagName.SDO_LoginTime, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_TIMESTAMP, ds.Tables[0].Rows[i].ItemArray[3]); strut.AddTagKey(TagName.SDO_LogoutTime, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes); structList[i] = strut; } return(Message.COMMON_MES_RESP(structList, Msg_Category.O2JAM2_ADMIN, ServiceKey.SDO_USERONLINE_QUERY_RESP, 4)); } else { return(Message.COMMON_MES_RESP(lg.O2JAM2API_ItemShopAPI_NoOnlineStatus, Msg_Category.O2JAM2_ADMIN, ServiceKey.SDO_USERONLINE_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception ex) { Console.WriteLine(ex.Message); return(Message.COMMON_MES_RESP(lg.O2JAM2API_ItemShopAPI_NoOnlineStatus, Msg_Category.O2JAM2_ADMIN, ServiceKey.SDO_USERONLINE_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
/// <summary> /// 即时查看玩家当前状态(服务器/房间/在线状态) /// </summary> /// <returns></returns> public Message SDO_login_Query() { string serverIP = null; string account = null; DataSet ds = null; try { serverIP = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_ServerIP).m_bValueBuffer); account = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_Account).m_bValueBuffer); Console.WriteLine(DateTime.Now + " - " + lg.API_Display + lg.SDOAPI_SDO + "+>" + lg.API_CommonAPI_ServerIP + CommonInfo.serverIP_Query(serverIP) + lg.SDOAPI_SDOItemLogInfoAPI_Account + account + lg.SDOAPI_SDOMemberInfoAPI_CurrentState + "!"); ds = MemberInfo.T_o2jam_login_Query(serverIP, account); if (ds != null && ds.Tables[0].Rows.Count > 0) { Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Query_Structure strut1 = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[0]); strut1.AddTagKey(TagName.SDO_Account, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[1]); strut1.AddTagKey(TagName.SDO_MAINCH, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[2]); strut1.AddTagKey(TagName.SDO_SUBCH, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[3]); strut1.AddTagKey(TagName.SDO_ipaddr, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); structList[i] = strut1; } return(Message.COMMON_MES_RESP(structList, Msg_Category.SDO_ADMIN, ServiceKey.SDO_USERLOGIN_STATUS_QUERY_RESP, 4)); } else { return(Message.COMMON_MES_RESP(lg.SDOAPI_SDOMemberInfoAPI_NoCurrentInfo, Msg_Category.SDO_ADMIN, ServiceKey.SDO_USERLOGIN_STATUS_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception e) { Console.WriteLine(e.Message); return(Message.COMMON_MES_RESP(lg.SDOAPI_SDOMemberInfoAPI_NoCurrentInfo, Msg_Category.SDO_ADMIN, ServiceKey.SDO_USERLOGIN_STATUS_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
/// <summary> /// 查询所有的技能道具 /// </summary> /// <returns></returns> public Message Soccer_Item_Skill_Blur_Query() { System.Data.DataSet ds = null; int item_type = 1; string Content = null; try { SqlHelper.log.WriteLog("劲爆足球+>" + "查询所有道具!"); Console.WriteLine(DateTime.Now + " - 劲爆足球+>服务器地址" + "查询所有道具!"); Content = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.Soccer_content).m_bValueBuffer); ds = SOCCERItemShopInfo.Soccer_Item_Skill_Blur_Query(item_type, Content); if (ds != null && ds.Tables[0].Rows.Count > 0) { Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Query_Structure strut1 = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[0])); strut1.AddTagKey(TagName.Soccer_idx, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, UserValidate.validData(ds.Tables[0].Rows[i].ItemArray[1])); strut1.AddTagKey(TagName.Soccer_i_name, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, UserValidate.validData(ds.Tables[0].Rows[i].ItemArray[2])); strut1.AddTagKey(TagName.Soccer_body_part, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[3])); strut1.AddTagKey(TagName.Soccer_item_type, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); structList[i] = strut1; } return(Message.COMMON_MES_RESP(structList, Msg_Category.SOCCER_ADMIN, ServiceKey.SOCCER_ITEM_SKILL_BLUR_QUERY_RESP, 4)); } else { return(Message.COMMON_MES_RESP("没有道具列表!", Msg_Category.SOCCER_ADMIN, ServiceKey.SOCCER_ITEM_SKILL_BLUR_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception ex) { return(Message.COMMON_MES_RESP("没有道具列表!", Msg_Category.SOCCER_ADMIN, ServiceKey.SOCCER_ITEM_SKILL_BLUR_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
/// <summary> /// 得到该用户所在部门的所拥有的游戏 /// </summary> /// <returns></returns> public Message GM_QueryDepartRelateGameInfo() { int userID = 0; System.Data.DataSet ds = null; GMLogAPI logAPI = new GMLogAPI(); try { TLV_Structure tlvStrut = new TLV_Structure(TagName.User_ID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.User_ID).m_bValueBuffer); userID = (int)tlvStrut.toInteger(); SqlHelper.log.WriteLog(LanguageAPI.API_DepartmentAPI_HoldGame); Console.WriteLine(DateTime.Now + " - " + LanguageAPI.API_DepartmentAPI_HoldGame); ds = GMDepartmentInfo.getDepartRelateGameInfo(userID); if (ds != null && ds.Tables[0].Rows.Count > 0) { Query_Structure[] structList = new Query_Structure[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Query_Structure strut = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length); strut.AddTagKey(TagName.GameID, TagFormat.TLV_INTEGER, 4, TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, ds.Tables[0].Rows[i].ItemArray[0])); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[1]); strut.AddTagKey(TagName.GameName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); structList[i] = strut; } Console.Write(logAPI.Buffer.ToString()); return(Message.COMMON_MES_RESP(structList, Msg_Category.USER_ADMIN, ServiceKey.DEPART_RELATE_GAME_QUERY_RESP, 2)); } else { return(Message.COMMON_MES_RESP(LanguageAPI.API_DepartmentAPI_NoDepInfo, Msg_Category.USER_ADMIN, ServiceKey.DEPART_RELATE_GAME_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception ex) { Console.WriteLine(ex.Message); return(Message.COMMON_MES_RESP(LanguageAPI.API_DepartmentAPI_NoDepInfo, Msg_Category.USER_ADMIN, ServiceKey.DEPART_RELATE_GAME_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }
/// <summary> /// lg.SDAPI_SDItemLogInfoAPI_Account+lg.SDAPI_SDItemLogInfoAPI_Sumlg.SDAPI_SDItemShopAPI_Integral+ /// </summary> /// <returns>Messagebody</returns> public Message SDUserActiveCode_Query() { string activeCode = null; string strDesc = null; System.Collections.ArrayList ds = new System.Collections.ArrayList(); try { activeCode = Encoding.Unicode.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SD_ActiceCode).m_bValueBuffer); SqlHelper.log.WriteLog(lg.SDAPI_SDItemMsG + lg.SDAPI_SD + "+>" + lg.SDAPI_SDItemLogInfoAPI_Sum + activeCode + lg.SDAPI_SDItemShopAPI_NoIntegral + lg.SDAPI_SDChallengeDataAPI_ProbabilityList + "!"); Console.WriteLine(DateTime.Now + lg.SDAPI_SDItemMsG + lg.SDAPI_SD + "+>" + lg.SDAPI_SDItemLogInfoAPI_Sum + activeCode + lg.SDAPI_SDItemShopAPI_NoIntegral + lg.SDAPI_SDChallengeDataAPI_ProbabilityList + "!"); ds = SDAccountInfo.ActiveCode_Query(activeCode, 1, ref strDesc); if (ds != null && ds.Count > 0) { Query_Structure[] structList = new Query_Structure[1]; Query_Structure strut = new Query_Structure((uint)ds.Count); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds[0]); strut.AddTagKey(TagName.SD_ActiceCode, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds[1]); strut.AddTagKey(TagName.SD_GoldAccount, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds[2]); strut.AddTagKey(TagName.SD_IsUsed, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds[3]); strut.AddTagKey(TagName.SD_UserName, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, Convert.ToString(ds[4])); strut.AddTagKey(TagName.SD_UseDate, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); structList[0] = strut; return(Message.COMMON_MES_RESP(structList, Msg_Category.SD_ADMIN, ServiceKey.SD_ActiveCode_Query_Resp, 5)); } else { return(Message.COMMON_MES_RESP(strDesc, Msg_Category.SD_ADMIN, ServiceKey.SD_ActiveCode_Query_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception) { return(Message.COMMON_MES_RESP(strDesc, Msg_Category.SD_ADMIN, ServiceKey.SD_ActiveCode_Query_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }