public static int GetClubMemberEquipmentCount(int clubID)
{
var totalCount = 0;
var ucs = ClubLogic.GetClubMembers(clubID);
foreach (var uc in ucs)
{
var player = GetPlayerInfo(uc.Userid.Value);
var numbers = GetMyNumbers(uc.Userid.Value);
if (player != null)
{
totalCount += (player.Shirt + player.Shorts + player.Sock);
}
totalCount += numbers.Count;
foreach (var number in numbers)
{
if (number.IsActive)
{
totalCount += 15;
}
}
totalCount += (Entity.UserVideo.GetUserVideosByUserID(uc.Userid.Value).Count *16);
}
return(totalCount);
}
public static void SetBonusGot(int playerID, int bonusToClub, int clubID, int luckyPlayerID)
{
var sql = "UPDATE dbo.Arsenalcn_Config SET ConfigValue = 'true' WHERE ConfigKey = 'LuckyPlayerBonusGot'; ";
sql = sql +
"UPDATE dbo.AcnClub_LogLuckyPlayer SET BonusGot = 1 WHERE [ID] = (SELECT TOP 1 [ID] FROM AcnClub_LogLuckyPlayer ORDER BY [Date] DESC); ";
using (var con = SQLConn.GetConnection())
{
var com = new SqlCommand(sql, con);
con.Open();
com.ExecuteNonQuery();
//con.Close();
}
var player = PlayerStrip.GetPlayerInfoByPlayerID(playerID);
var lPlayer = PlayerStrip.GetPlayerInfoByPlayerID(luckyPlayerID);
if (player != null && clubID > 0)
{
var ch = new ClubHistory();
ch.ClubID = clubID;
ch.ActionUserName = lPlayer.UserName;
ch.OperatorUserName = player.UserName;
ch.ActionType = ClubHistoryActionType.LuckyPlayer.ToString();
ch.ActionDescription = ClubLogic.BuildClubHistoryActionDesc(ClubHistoryActionType.LuckyPlayer,
bonusToClub.ToString(), lPlayer.UserName);
ClubLogic.SaveClubHistory(ch);
}
}
public static void UpdateBingoResultLog(int userID, BingoResult result)
{
var sql =
"UPDATE AcnClub_LogBingo SET Result = @result, ResultDetail = @resultDetail WHERE [ID] = (SELECT TOP 1 [ID] FROM AcnClub_LogBingo WHERE UserID = @userID AND Result is NULL ORDER BY ActionDate DESC)";
using (var con = SQLConn.GetConnection())
{
var com = new SqlCommand(sql, con);
object tempValue = null;
com.Parameters.Add(new SqlParameter("@userID", userID));
if (result.Result == BingoResultType.Null)
{
tempValue = DBNull.Value;
}
else
{
tempValue = (int)result.Result;
}
com.Parameters.Add(new SqlParameter("@result", tempValue));
com.Parameters.Add(new SqlParameter("@resultDetail", ClubLogic.ParseNullableParam(result.ResultDetail)));
con.Open();
com.ExecuteNonQuery();
//con.Close();
}
}
internal static bool JoinClub(int userID, string userName, int clubID)
{
var ah = ClubLogic.GetActiveApplyHistoryByUserClub(userID, clubID);
if (ah == null)
{
//proceed it
ApplyJoinClub(userID, userName, clubID);
return(true);
}
return(false);
}
public static void ApplyJoinClub(int userID, string userName, int clubID)
{
var ah = new ApplyHistory();
ah.Userid = userID;
ah.UserName = userName;
ah.ClubUid = clubID;
ah.ApplyDate = DateTime.Now;
ClubLogic.SaveApplyHistory(ah);
ClubSysPrivateMessage.SendMessage(clubID, userName, ClubSysMessageType.ApplyJoinClub);
}
public static void ApproveJoinClub(int applyHistoryId, bool approved, string operatorUserName)
{
var ah = ClubLogic.GetApplyHistory(applyHistoryId);
ah.IsAccepted = approved;
ClubLogic.SaveApplyHistory(ah);
var ch = new ClubHistory();
ch.ClubID = ah.ClubUid;
ch.ActionUserName = ah.UserName;
ch.OperatorUserName = operatorUserName;
ch.ActionDate = DateTime.Now;
if (approved)
{
//insert user club
var uc = new UserClub();
uc.ClubUid = ah.ClubUid;
uc.JoinClubDate = DateTime.Now;
uc.FromDate = DateTime.Now;
uc.IsActive = true;
uc.Responsibility = (int)Responsibility.Member;
uc.Userid = ah.Userid;
uc.UserName = ah.UserName;
ClubLogic.SaveUserClub(uc);
ch.ActionType = ClubHistoryActionType.JoinClub.ToString();
ch.ActionDescription = ClubLogic.BuildClubHistoryActionDesc(ClubHistoryActionType.JoinClub, null);
}
else
{
ch.ActionType = ClubHistoryActionType.RejectJoinClub.ToString();
ch.ActionDescription = ClubLogic.BuildClubHistoryActionDesc(ClubHistoryActionType.RejectJoinClub, null);
}
ClubLogic.SaveClubHistory(ch);
if (approved)
{
ClubSysPrivateMessage.SendMessage(ah.ClubUid, ah.UserName, ClubSysMessageType.ApproveJoinClub);
}
else
{
ClubSysPrivateMessage.SendMessage(ah.ClubUid, ah.UserName, ClubSysMessageType.RejectJoinClub);
}
}
public static bool LeaveClub(int userID, int clubID, bool isKicked, string kickUserName)
{
var uc = ClubLogic.GetActiveUserClub(userID, clubID);
if (uc != null)
{
uc.ToDate = DateTime.Now;
uc.IsActive = false;
if (uc.Responsibility == (int)Responsibility.Manager)
{
return(false);
}
ClubLogic.SaveUserClub(uc);
var ch = new ClubHistory();
ch.ClubID = clubID;
ch.ActionUserName = uc.UserName;
if (isKicked)
{
ch.ActionType = ClubHistoryActionType.MandatoryLeaveClub.ToString();
ch.ActionDescription = ClubLogic.BuildClubHistoryActionDesc(
ClubHistoryActionType.MandatoryLeaveClub, null);
ch.OperatorUserName = kickUserName;
}
else
{
ch.ActionType = ClubHistoryActionType.LeaveClub.ToString();
ch.ActionDescription = ClubLogic.BuildClubHistoryActionDesc(ClubHistoryActionType.LeaveClub, null);
ch.OperatorUserName = uc.UserName;
}
ClubLogic.SaveClubHistory(ch);
if (isKicked)
{
ClubSysPrivateMessage.SendMessage(clubID, uc.UserName, ClubSysMessageType.MandatoryLeaveClub);
}
else
{
ClubSysPrivateMessage.SendMessage(clubID, uc.UserName, ClubSysMessageType.LeaveClub);
}
return(true);
}
return(false);
}
internal static bool CancelApplication(int userID, string userName, int clubID)
{
var ah = ClubLogic.GetActiveApplyHistoryByUserClub(userID, clubID);
if (ah != null)
{
//proceed to cancel it
ah.IsAccepted = false;
ClubLogic.SaveApplyHistory(ah);
return(true);
}
return(false);
}
public static void UserClubStatistics()
{
foreach (var club in ClubLogic.GetActiveClubs())
{
try
{
var clubMemberFortune = 0;
var clubMemberCredit = 0;
var clubMemberLoyalty = 0;
var clubMemberRP = 0;
var members = ClubLogic.GetClubMembers(club.ID.Value);
foreach (var member in members)
{
try
{
var userInfo = Users.GetShortUserInfo(member.Userid.Value);
if (userInfo != null)
{
clubMemberFortune += (int)userInfo.Extcredits2;
clubMemberCredit += userInfo.Credits;
clubMemberLoyalty += (int)(DateTime.Now - member.JoinClubDate.Value).TotalDays;
clubMemberRP += (int)userInfo.Extcredits4;
}
}
catch
{
}
}
club.MemberFortune = clubMemberFortune;
club.MemberCredit = clubMemberCredit;
club.MemberLoyalty = clubMemberLoyalty;
club.MemberRP = clubMemberRP;
var ra = new RankAlgorithm(club);
club.RankScore = ra.SummaryRankPoint;
ClubLogic.SaveClub(club);
}
catch
{
}
}
}
public static void TransferMemberExtcredit(int clubID, int fromUserID, int toUserID, float extCredit,
int extCreditType)
{
//UserClub ucFrom = ClubLogic.GetActiveUserClub(fromUserID, clubID);
//UserClub ucTo = ClubLogic.GetActiveUserClub(toUserID, clubID);
var userFrom = Users.GetUserInfo(fromUserID);
var userTo = Users.GetUserInfo(toUserID);
if (fromUserID != toUserID)
{
if (extCredit > Users.GetUserExtCredits(fromUserID, extCreditType))
{
throw new Exception("Insufficient Founds");
}
var list = ClubLogic.GetUserManagedClubs(fromUserID);
if (list == null || list.Count <= 0)
{
throw new Exception("No privilege of tranfer");
}
// Transfer Logic
Users.UpdateUserExtCredits(fromUserID, extCreditType, -extCredit);
Users.UpdateUserExtCredits(toUserID, extCreditType, extCredit);
// Club History Log & SMS
var ch = new ClubHistory();
ch.ClubID = clubID;
ch.ActionUserName = userTo.Username.Trim();
ch.ActionType = ClubHistoryActionType.TransferExtcredit.ToString();
ch.ActionDescription = ClubLogic.BuildClubHistoryActionDesc(ClubHistoryActionType.TransferExtcredit,
userTo.Username.Trim(), extCredit.ToString(), "枪手币");
ch.OperatorUserName = userFrom.Username.Trim();
ClubLogic.SaveClubHistory(ch);
ClubSysPrivateMessage.SendMessage(clubID, userTo.Username.Trim(), ClubSysMessageType.TransferExtcredit,
userFrom.Username.Trim(), extCredit.ToString("N0"), "枪手币");
}
else
{
throw new Exception("Can't transfer to yourself");
}
}
public static void CalcClubFortuneIncrement()
{
foreach (var club in ClubLogic.GetActiveClubs())
{
try
{
var clubFortuneIncrement = 0;
var members = ClubLogic.GetClubMembers(club.ID.Value);
foreach (var member in members)
{
try
{
var userInfo = Users.GetShortUserInfo(member.Userid.Value);
if (userInfo != null)
{
clubFortuneIncrement += FortuneContributeAlgorithm.CalcContributeFortune(userInfo, true);
//int memberFortune = (int)userInfo.Extcredits2;
//int memberCredit = userInfo.Credits;
//float memberMana = userInfo.Extcredits1;//威望
//clubFortuneIncrement += (int)(Config.ClubFortuneIncrementVariable * Math.Pow(Math.Log10(memberCredit), 4)) + (int)((memberMana + 1) * Math.Log10(memberFortune));
}
}
catch
{
}
}
club.Fortune = club.Fortune.Value + clubFortuneIncrement;
var ra = new RankAlgorithm(club);
club.RankLevel = RankLevel.GetInstance().GetRank(club.Fortune.Value).ID;
ClubLogic.SaveClub(club);
}
catch
{
}
}
}
public static int GetClubMemberVideoCount(int clubID)
{
var totalCount = 0;
var ucs = ClubLogic.GetClubMembers(clubID);
foreach (var uc in ucs)
{
var player = GetPlayerInfo(uc.Userid.Value);
//DataTable dt = UserVideo.GetUserVideo(uc.Userid.Value);
if (player != null)
{
totalCount += Entity.UserVideo.GetUserVideosByUserID(uc.Userid.Value).Count;
}
}
return(totalCount);
}
public static int GetClubMemberCardCount(int clubID)
{
var totalCount = 0;
var ucs = ClubLogic.GetClubMembers(clubID);
foreach (var uc in ucs)
{
var player = GetPlayerInfo(uc.Userid.Value);
var numbers = GetMyNumbers(uc.Userid.Value);
if (player != null)
{
totalCount += numbers.Count;
}
}
return(totalCount);
}
//for internal temp leave usage
internal static bool LeaveClub(int userID, int clubID)
{
var uc = ClubLogic.GetActiveUserClub(userID, clubID);
if (uc != null)
{
uc.ToDate = DateTime.Now;
uc.IsActive = false;
if (uc.Responsibility == (int)Responsibility.Manager)
{
return(false);
}
ClubLogic.SaveUserClub(uc);
return(true);
}
return(false);
}
public static void SendMessage(int clubID, string userName, ClubSysMessageType messageType, params string[] para)
{
var userID = Users.GetUserId(userName);
var club = ClubLogic.GetClubInfo(clubID);
PrivateMessageInfo pm;
switch (messageType)
{
case ClubSysMessageType.ApplyClub:
foreach (var aID in ConfigGlobal.PluginAdmin)
{
pm = new PrivateMessageInfo();
pm.Msgfrom = ClubSysAdminName;
pm.Msgfromid = 0;
pm.Folder = 0;
pm.Message = string.Format(ApplyClub_Message, userName, club.FullName);
pm.Msgtoid = Convert.ToInt32(aID);
pm.Msgto = Users.GetUserInfo(aID).Username.Trim();
pm.New = 1;
pm.Postdatetime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
pm.Subject = string.Format(ApplyClub_Subject, userName);
PrivateMessages.CreatePrivateMessage(pm, 0);
}
break;
case ClubSysMessageType.ApplyJoinClub:
var users = ClubLogic.GetClubLeads(clubID);
foreach (var userClub in users)
{
pm = new PrivateMessageInfo();
pm.Msgfrom = ClubSysAdminName;
pm.Msgfromid = 0;
pm.Folder = 0;
pm.Message = string.Format(ApplyJoinClub_Message, userName, club.FullName);
pm.Msgto = userClub.UserName;
pm.Msgtoid = userClub.Userid.Value;
pm.New = 1;
pm.Postdatetime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
pm.Subject = string.Format(ApplyJoinClub_Subject, userName);
PrivateMessages.CreatePrivateMessage(pm, 0);
}
break;
case ClubSysMessageType.ApproveClub:
if (club != null)
{
var result = "通过";
if (!club.IsActive.Value)
{
result = "驳回";
}
pm = new PrivateMessageInfo();
pm.Msgfrom = ClubSysAdminName;
pm.Msgfromid = 0;
pm.Folder = 0;
pm.Message = string.Format(ApproveClub_Message, club.FullName, result);
pm.Msgto = club.CreatorUserName;
pm.Msgtoid = club.CreatorUid.Value;
pm.New = 1;
pm.Postdatetime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
pm.Subject = ApproveClub_Subject;
PrivateMessages.CreatePrivateMessage(pm, 0);
}
break;
case ClubSysMessageType.ApproveJoinClub:
pm = new PrivateMessageInfo();
pm.Msgfrom = ClubSysAdminName;
pm.Msgfromid = 0;
pm.Folder = 0;
pm.Message = string.Format(ApproveJoinClub_Message, club.FullName);
pm.Msgto = userName;
pm.Msgtoid = userID;
pm.New = 1;
pm.Postdatetime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
pm.Subject = ApproveJoinClub_Subject;
PrivateMessages.CreatePrivateMessage(pm, 0);
break;
case ClubSysMessageType.LeaveClub:
pm = new PrivateMessageInfo();
pm.Msgfrom = ClubSysAdminName;
pm.Msgfromid = 0;
pm.Folder = 0;
pm.Message = string.Format(LeaveClub_Message, club.FullName);
pm.Msgto = userName;
pm.Msgtoid = userID;
pm.New = 1;
pm.Postdatetime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
pm.Subject = LeaveClub_Subject;
PrivateMessages.CreatePrivateMessage(pm, 0);
break;
case ClubSysMessageType.MandatoryLeaveClub:
pm = new PrivateMessageInfo();
pm.Msgfrom = ClubSysAdminName;
pm.Msgfromid = 0;
pm.Folder = 0;
pm.Message = string.Format(MandatoryLeaveClub_Message, club.FullName);
pm.Msgto = userName;
pm.Msgtoid = userID;
pm.New = 1;
pm.Postdatetime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
pm.Subject = MandatoryLeaveClub_Subject;
PrivateMessages.CreatePrivateMessage(pm, 0);
break;
case ClubSysMessageType.RejectJoinClub:
pm = new PrivateMessageInfo();
pm.Msgfrom = ClubSysAdminName;
pm.Msgfromid = 0;
pm.Folder = 0;
pm.Message = string.Format(RejectJoinClub_Message, club.FullName);
pm.Msgto = userName;
pm.Msgtoid = userID;
pm.New = 1;
pm.Postdatetime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
pm.Subject = RejectJoinClub_Subject;
PrivateMessages.CreatePrivateMessage(pm, 0);
break;
case ClubSysMessageType.TransferExtcredit:
pm = new PrivateMessageInfo();
pm.Msgfrom = para[0];
pm.Msgfromid = Users.GetUserId(para[0]);
pm.Folder = 0;
pm.Message = string.Format(TransferExtcredit_Message, para[0], para[1], para[2]);
pm.Msgto = userName;
pm.Msgtoid = userID;
pm.New = 1;
pm.Postdatetime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
pm.Subject = string.Format(TransferExtcredit_Subject, club.FullName);
PrivateMessages.CreatePrivateMessage(pm, 0);
break;
default:
break;
}
}
public RankAlgorithm(Club club)
{
currentClub = club;
memberCount = ClubLogic.GetClubMemberCount(currentClub.ID.Value);
}
public static void ChangeResponsibility(int userID, string userName, int clubID, Responsibility res,
string operatorUserName)
{
var userClub = ClubLogic.GetActiveUserClub(userID, clubID);
if (userClub != null && userClub.Responsibility == (int)res)
{
return;
}
var club = ClubLogic.GetClubInfo(clubID);
if (club != null)
{
if (res == Responsibility.Manager)
{
#region Proceed previous manager user club info
var preManagerUid = club.ManagerUid.Value;
var preManagerName = club.ManagerUserName;
LeaveClub(preManagerUid, clubID);
var preManagerUc = ClubLogic.GetActiveUserClub(preManagerUid, clubID);
var preUC = new UserClub();
preUC.ClubUid = clubID;
preUC.JoinClubDate = preManagerUc.JoinClubDate;
preUC.FromDate = DateTime.Now;
preUC.IsActive = true;
preUC.Responsibility = (int)Responsibility.Member;
preUC.Userid = preManagerUid;
preUC.UserName = preManagerName;
ClubLogic.SaveUserClub(preUC);
#endregion
club.ManagerUid = userID;
club.ManagerUserName = userName;
club.UpdateDate = DateTime.Now;
ClubLogic.SaveClub(club);
}
LeaveClub(userID, clubID);
var uc = new UserClub();
uc.ClubUid = clubID;
uc.JoinClubDate = userClub.JoinClubDate;
uc.FromDate = DateTime.Now;
uc.IsActive = true;
uc.Userid = userID;
uc.UserName = userName;
var ch = new ClubHistory();
ch.ClubID = clubID;
ch.ActionUserName = userName;
ch.OperatorUserName = operatorUserName;
if (userClub.Responsibility.Value > (int)res)
{
//nominate
ch.ActionType = ClubHistoryActionType.Nominated.ToString();
ch.ActionDescription = ClubLogic.BuildClubHistoryActionDesc(ClubHistoryActionType.Nominated,
ClubLogic.TranslateResponsibility(res));
}
else
{
//dismiss
ch.ActionType = ClubHistoryActionType.Dismiss.ToString();
ch.ActionDescription = ClubLogic.BuildClubHistoryActionDesc(ClubHistoryActionType.Dismiss,
ClubLogic.TranslateResponsibility(res));
}
uc.Responsibility = (int)res;
ClubLogic.SaveUserClub(uc);
ClubLogic.SaveClubHistory(ch);
}
else
{
throw new Exception("Club not exist.");
}
}