/// <summary>
/// 9you用户邮件地址查询
/// </summary>
/// <returns></returns>
public Message SDOEmailQuery()
{
string result = null;
string account = null;
try
{
account = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_Account).m_bValueBuffer);
result = GlobalAccount.SDOEmail_Query(account.Trim());
if (result != null)
{
SqlHelper.log.WriteLog("久游用户中心+>玩家" + account + "邮件地址!");
Console.WriteLine(DateTime.Now + " - 久游用户中心+>玩家" + account + "邮件地址!");
return(Message.COMMON_MES_RESP(result, Msg_Category.SDO_ADMIN, ServiceKey.SDO_EMAIL_QUERY_RESP, TagName.SDO_Email, TagFormat.TLV_STRING));
}
else
{
SqlHelper.log.WriteLog("久游用户中心+>玩家" + account + "邮件地址!");
Console.WriteLine(DateTime.Now + " - 久游用户中心+>玩家" + account + "邮件地址!");
return(Message.COMMON_MES_RESP("該玩家EMAI為空!", Msg_Category.SDO_ADMIN, ServiceKey.SDO_EMAIL_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception ex)
{
string str = ex.Message;
SqlHelper.log.WriteLog("久游用户中心+>玩家" + account + "邮件地址!");
Console.WriteLine(DateTime.Now + " - 久游用户中心+>玩家" + account + "邮件地址!");
return(Message.COMMON_MES_RESP("該玩家EMAI為空!", Msg_Category.SDO_ADMIN, ServiceKey.SDO_EMAIL_QUERY_RESP, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 查询所有帮会成员的資訊
/// </summary>
/// <returns></returns>
public Message Guildmember_Query()
{
string serverIP = null;
int guildID = 0;
DataSet ds = null;
try
{
serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_ServerIP).m_bValueBuffer);
TLV_Structure strut = new TLV_Structure(TagName.RayCity_GuildIDX, 4, msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_GuildIDX).m_bValueBuffer);
guildID = (int)strut.toInteger();
SqlHelper.log.WriteLog(lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + CommonInfo.serverIP_Query(serverIP) + lg.RayCityAPI_GuildMember);
Console.WriteLine(DateTime.Now + lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + CommonInfo.serverIP_Query(serverIP) + lg.RayCityAPI_GuildMember);
ds = GlobalAccount.GuildMember_Query(serverIP, guildID);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
Query_Structure[] structList = Message.buildTLV(ds, 0, 100, false);
return(Message.COMMON_MES_RESP(structList, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_GuildMember_Query_Resp, (int)structList[0].structLen));
}
else
{
return(Message.COMMON_MES_RESP(lg.RayCityAPI_NoGuildMember, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_GuildMember_Query_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception ex)
{
SqlHelper.errLog.WriteLog("伺服器IP" + serverIP + ex.Message);
return(Message.COMMON_MES_RESP(lg.RayCityAPI_NoGuildMember, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_GuildMember_Query_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 取回玩家光線飛車仓库密码
/// </summary>
/// <returns></returns>
public Message Get_WarehousePassword()
{
int operateUserID = 0;
string serverIP = null;
string account = null;
string passwd = null;
string email = null;
int characterID = 0;
int result = -1;
try
{
TLV_Structure strut = new TLV_Structure(TagName.UserByID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.UserByID).m_bValueBuffer);
operateUserID = (int)strut.toInteger();
serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_ServerIP).m_bValueBuffer);
account = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_NyUserID).m_bValueBuffer);
email = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.SDO_Email).m_bValueBuffer);
string signpasswd = MD5EncryptAPI.nextID(6);
MD5Encrypt st = new MD5Encrypt();
passwd = st.getMD5ofStr(signpasswd).ToLower();
strut = new TLV_Structure(TagName.RayCity_CharacterID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_CharacterID).m_bValueBuffer);
characterID = (int)strut.toInteger();
SqlHelper.log.WriteLog(lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + CommonInfo.serverIP_Query(serverIP) + lg.RayCityAPI_Set + lg.RayCityAPI_Account + characterID + lg.RayCityAPI_WarehousePassword);
Console.WriteLine(DateTime.Now + lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + CommonInfo.serverIP_Query(serverIP) + lg.RayCityAPI_Set + lg.RayCityAPI_Account + characterID + lg.RayCityAPI_WarehousePassword);
result = GlobalAccount.Get_WarehousePassword(operateUserID, serverIP, characterID, account, signpasswd, passwd);
if (result == 1)
{
if (sendRayCityMail("*****@*****.**", email, account, signpasswd) == 1)
{
return(Message.COMMON_MES_RESP("SCUESS", Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_WareHousePwd_Update_Resp));
}
else
{
return(Message.COMMON_MES_RESP("FAILURE", Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_WareHousePwd_Update_Resp));
}
}
else
{
return(Message.COMMON_MES_RESP(lg.API_Error, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_WareHousePwd_Update_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception ex)
{
SqlHelper.errLog.WriteLog("伺服器IP" + serverIP + ex.Message);
return(Message.COMMON_MES_RESP(lg.API_Error, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_WareHousePwd_Update_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 公告資訊查询
/// </summary>
/// <returns></returns>
public Message RayCity_BoardList_Query()
{
string serverIP = null;
DataSet ds = null;
try
{
serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_ServerIP).m_bValueBuffer);
SqlHelper.log.WriteLog(lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + CommonInfo.serverIP_Query(serverIP) + lg.RayCityAPI_Notices);
Console.WriteLine(DateTime.Now + lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + CommonInfo.serverIP_Query(serverIP) + lg.RayCityAPI_Notices);
ds = GlobalAccount.BoardList_Query(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.RayCity_NoticeID, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_TIMESTAMP, Convert.ToDateTime(ds.Tables[0].Rows[i].ItemArray[1]));
strut.AddTagKey(TagName.RayCity_StartDate, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_TIMESTAMP, Convert.ToDateTime(ds.Tables[0].Rows[i][2].ToString()));
strut.AddTagKey(TagName.RayCity_EndDate, TagFormat.TLV_TIMESTAMP, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, Convert.ToInt32(ds.Tables[0].Rows[i][3].ToString()));
strut.AddTagKey(TagName.RayCity_Interval, 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.RayCity_Repeat, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, Convert.ToString(ds.Tables[0].Rows[i].ItemArray[5]));
strut.AddTagKey(TagName.RayCity_Message, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, Convert.ToString(ds.Tables[0].Rows[i].ItemArray[6]));
strut.AddTagKey(TagName.RayCity_use_state, TagFormat.TLV_STRING, (uint)bytes.Length, bytes);
structList[i] = strut;
}
return(Message.COMMON_MES_RESP(structList, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_BoardList_Query_Resp, 7));
}
else
{
return(Message.COMMON_MES_RESP(lg.RayCityAPI_NoNotices, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_BoardList_Query_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
catch (System.Exception ex)
{
SqlHelper.errLog.WriteLog("伺服器IP" + serverIP + ex.Message);
return(Message.COMMON_MES_RESP(lg.RayCityAPI_NoNotices, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_BoardList_Query_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
public Message CharacterName_Query()
{
string name = "";
int characterID = 0;
string serverIP = "";
try
{
serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_ServerIP).m_bValueBuffer);
TLV_Structure strut = new TLV_Structure(TagName.RayCity_CharacterID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_CharacterID).m_bValueBuffer);
characterID = (int)strut.toInteger();
name = GlobalAccount.CharacterName_Query(serverIP, characterID);
return(Message.COMMON_MES_RESP(name, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_CashItemDetailLog_Query_Resp, TagName.RayCity_CharacterName, TagFormat.TLV_STRING));
}
catch (System.Exception)
{
return(Message.COMMON_MES_RESP(lg.API_Error, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_CashItemDetailLog_Query_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 添加公告内容
/// </summary>
/// <returns></returns>
public Message RayCity_BoardList_Insert()
{
int result = -1;
int operateUserID = 0;
string serverIP = null;
string city = null;
int interval = 0;
string msgContent = null;
DateTime startDate = new DateTime();
DateTime endDate = new DateTime();
try
{
TLV_Structure strut = new TLV_Structure(TagName.UserByID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.UserByID).m_bValueBuffer);
operateUserID = (int)strut.toInteger();
serverIP = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_ServerIP).m_bValueBuffer);
strut = new TLV_Structure(TagName.RayCity_BeginDate, 6, msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_BeginDate).m_bValueBuffer);
startDate = strut.toTimeStamp();
strut = new TLV_Structure(TagName.RayCity_EndDate, 6, msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_EndDate).m_bValueBuffer);
endDate = strut.toTimeStamp();
strut = new TLV_Structure(TagName.FJ_Interval, 4, msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_Interval).m_bValueBuffer);
interval = (int)strut.toInteger();
msgContent = System.Text.Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_Message).m_bValueBuffer);
result = GlobalAccount.RayCityBoardList_Insert(operateUserID, serverIP, city, msgContent, startDate, endDate, interval);
if (result == 1)
{
SqlHelper.log.WriteLog(lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + serverIP + lg.RayCityAPI_Notices + lg.API_Add + lg.API_Success);
Console.WriteLine(DateTime.Now + lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + serverIP + lg.RayCityAPI_Notices + lg.API_Add + lg.API_Success);
return(Message.COMMON_MES_RESP("SUCESS", Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_BoardList_Insert_Resp));
}
else
{
SqlHelper.log.WriteLog(lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + serverIP + lg.RayCityAPI_Notices + lg.API_Add + lg.API_Failure);
Console.WriteLine(DateTime.Now + lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + serverIP + lg.RayCityAPI_Notices + lg.API_Add + lg.API_Failure);
return(Message.COMMON_MES_RESP("FAILURE", Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_BoardList_Insert_Resp));
}
}
catch (System.Exception e)
{
return(Message.COMMON_MES_RESP(lg.RayCityAPI_Notices + lg.API_Add + lg.API_Failure, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_BoardList_Insert_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
/// <summary>
/// 添加GM帳號
/// </summary>
/// <returns></returns>
public Message GMAccount_Update()
{
int operateUserID = 0;
string serverIP = null;
string account = null;
int accountState = 0;
int result = -1;
try
{
TLV_Structure strut = new TLV_Structure(TagName.UserByID, 4, msg.m_packet.m_Body.getTLVByTag(TagName.UserByID).m_bValueBuffer);
operateUserID = (int)strut.toInteger();
serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_ServerIP).m_bValueBuffer);
account = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_NyUserID).m_bValueBuffer);
strut = new TLV_Structure(TagName.RayCity_AccountState, 4, msg.m_packet.m_Body.getTLVByTag(TagName.RayCity_AccountState).m_bValueBuffer);
accountState = (int)strut.toInteger();
result = GlobalAccount.GMAccount_Update(operateUserID, serverIP, account, accountState);
if (result == 1)
{
SqlHelper.log.WriteLog(lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + CommonInfo.serverIP_Query(serverIP) + lg.API_Add + lg.RayCityAPI_GMAccount + account + lg.API_Success);
Console.WriteLine(DateTime.Now + lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + CommonInfo.serverIP_Query(serverIP) + lg.API_Add + lg.RayCityAPI_GMAccount + account + lg.API_Success);
return(Message.COMMON_MES_RESP("SUCCESS", Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_GMUser_Update_Resp, TagName.Status, TagFormat.TLV_STRING));
}
else
{
SqlHelper.log.WriteLog(lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + CommonInfo.serverIP_Query(serverIP) + lg.API_Add + lg.RayCityAPI_GMAccount + account + lg.API_Failure);
Console.WriteLine(DateTime.Now + lg.API_Look + lg.RayCityAPI_Name + "+>" + lg.RayCityAPI_Address + CommonInfo.serverIP_Query(serverIP) + lg.API_Add + lg.RayCityAPI_GMAccount + account + lg.API_Failure);
return(Message.COMMON_MES_RESP("FAILURE", Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_GMUser_Update_Resp, TagName.Status, TagFormat.TLV_STRING));
}
}
catch (System.Exception ex)
{
SqlHelper.errLog.WriteLog("伺服器IP" + serverIP + ex.Message);
return(Message.COMMON_MES_RESP(lg.API_Error, Msg_Category.RAYCITY_ADMIN, ServiceKey.RayCity_GMUser_Update_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING));
}
}
