/// <summary>
/// 解封用户
/// </summary>
public static int ACCOUNT_OPEN(string serverIP, int usersn, string userNick, string userName, int userbyid, string Reason, ref string strDesc)
{
int result = -1;
string sql = null;
try
{
serverIP = CommonInfo.JW2_FindDBIP(serverIP, 8);
sql = "select sql_statement from sqlexpress where sql_type='JW2_ACCOUNT_OPEN' and sql_condition = 'JW2_ACCOUNT_OPEN'";
System.Data.DataSet ds = SqlHelper.ExecuteDataset(sql);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
sql = ds.Tables[0].Rows[0].ItemArray[0].ToString();
sql = string.Format(sql, usersn);
result = MySqlHelper.ExecuteNonQuery(SqlHelper.JW2GetConnectionString(serverIP, SqlHelper.jw2User, SqlHelper.jw2UserPwd, SqlHelper.jw2loginDB), sql);
}
if (result == 1)
{
strDesc = lg.JW2API_ACCOUNTOPEN + userName.ToString() + lg.JW2API_PlayerSN + userNick.ToString() + lg.JW2API_Success;
result = CommonInfo.JW2_UnBanUser(serverIP, userbyid, usersn, userName, Reason);
SqlHelper.insertGMtoolsLog(userbyid, "JW2", serverIP, "JW2_ACCOUNT_OPEN", lg.JW2API_ACCOUNTOPEN + userName.ToString() + lg.JW2API_Success);
}
else
{
strDesc = lg.JW2API_ACCOUNTOPEN + userName.ToString() + lg.JW2API_PlayerSN + userNick.ToString() + lg.JW2API_Failure;
result = CommonInfo.JW2_UnBanUser(serverIP, userbyid, usersn, userName, Reason);
SqlHelper.insertGMtoolsLog(userbyid, "JW2", serverIP, "JW2_ACCOUNT_OPEN", lg.JW2API_ACCOUNTOPEN + userName.ToString() + lg.JW2API_Failure);
}
}
catch (System.Exception ex)
{
strDesc = lg.JW2API_DatebaseConnectError;
SqlHelper.errLog.WriteLog("ServerIP" + serverIP + ex.Message);
}
// catch (MySqlException ex)
// {
// strDesc = "数据库连接失败，请重新尝试！";
// SqlHelper.errLog.WriteLog("服务器IP"+serverIP+ex.Message);
// }
return(result);
}
