コード例 #1
0
        public int HandlePacket(GameClient client, GSPacketIn packet)
        {
            if (client.Player.PlayerCharacter.ConsortiaID == 0)
                return 0;

            int id = packet.ReadInt();
            bool result = false;
            string msg = "ConsortiaApplyLoginPassHandler.Failed";
            using (ConsortiaBussiness db = new ConsortiaBussiness())
            {
                int consortiaRepute = 0;
                ConsortiaUserInfo info = new ConsortiaUserInfo();
                if (db.PassConsortiaApplyUsers(id, client.Player.PlayerCharacter.ID, client.Player.PlayerCharacter.NickName, client.Player.PlayerCharacter.ConsortiaID, ref msg, info, ref consortiaRepute))
                {
                    msg = "ConsortiaApplyLoginPassHandler.Success";
                    result = true;
                    if (info.UserID != 0)
                    {
                        info.ConsortiaID = client.Player.PlayerCharacter.ConsortiaID;
                        info.ConsortiaName = client.Player.PlayerCharacter.ConsortiaName;
                        GameServer.Instance.LoginServer.SendConsortiaUserPass(client.Player.PlayerCharacter.ID, client.Player.PlayerCharacter.NickName, info, false, consortiaRepute, info.LoginName, client.Player.PlayerCharacter.FightPower);
                    }
                }
            }

            packet.WriteBoolean(result);
            packet.WriteString(LanguageMgr.GetTranslation(msg));
            client.Out.SendTCP(packet);

            return 0;
        }
コード例 #2
0
        public int HandlePacket(GameClient client, GSPacketIn packet)
        {
            if (client.Player.PlayerCharacter.ConsortiaID != 0)
                return 0;

            int id = packet.ReadInt();
            bool result = false;
            int consortiaID = 0;
            string consortiaName = "";
            string msg = "ConsortiaInvitePassHandler.Failed";
            int tempID = 0;
            string tempName = "";
            using (ConsortiaBussiness db = new ConsortiaBussiness())
            {
                int consortiaRepute = 0;
                ConsortiaUserInfo info = new ConsortiaUserInfo();
                if (db.PassConsortiaInviteUsers(id, client.Player.PlayerCharacter.ID, client.Player.PlayerCharacter.NickName, ref consortiaID, ref consortiaName, ref msg, info, ref tempID, ref tempName, ref consortiaRepute))
                {
                    client.Player.PlayerCharacter.ConsortiaID = consortiaID;
                    client.Player.PlayerCharacter.ConsortiaName = consortiaName;
                    client.Player.PlayerCharacter.DutyLevel = info.Level;
                    client.Player.PlayerCharacter.DutyName = info.DutyName;
                    client.Player.PlayerCharacter.Right = info.Right;
                    ConsortiaInfo consotia = ConsortiaMgr.FindConsortiaInfo(consortiaID);
                    if (consotia != null)
                        client.Player.PlayerCharacter.ConsortiaLevel = consotia.Level;
                    msg = "ConsortiaInvitePassHandler.Success";
                    result = true;

                    info.UserID = client.Player.PlayerCharacter.ID;
                    info.UserName = client.Player.PlayerCharacter.NickName;
                    info.Grade = client.Player.PlayerCharacter.Grade;
                    info.Offer = client.Player.PlayerCharacter.Offer;
                    info.RichesOffer = client.Player.PlayerCharacter.RichesOffer;
                    info.RichesRob = client.Player.PlayerCharacter.RichesRob;
                    info.Win = client.Player.PlayerCharacter.Win;
                    info.Total = client.Player.PlayerCharacter.Total;
                    info.Escape = client.Player.PlayerCharacter.Escape;
                    info.ConsortiaID = consortiaID;
                    info.ConsortiaName = consortiaName;

                    GameServer.Instance.LoginServer.SendConsortiaUserPass(tempID, tempName, info, true, consortiaRepute, client.Player.PlayerCharacter.UserName, client.Player.PlayerCharacter.FightPower);
                }
            }
            packet.WriteBoolean(result);
            packet.WriteInt(consortiaID);
            packet.WriteString(consortiaName);
            packet.WriteString(LanguageMgr.GetTranslation(msg));
            client.Out.SendTCP(packet);

            return 0;
        }
コード例 #3
0
        public bool PassConsortiaInviteUsers(int inviteID, int userID, string userName, ref int consortiaID, ref string consortiaName, ref string msg, ConsortiaUserInfo info, ref int tempID, ref string tempName, ref int consortiaRepute)
        {
            bool result = false;
            try
            {
                SqlParameter[] para = new SqlParameter[24];
                para[0] = new SqlParameter("@ID", inviteID);
                para[1] = new SqlParameter("@UserID", userID);
                para[2] = new SqlParameter("@UserName", userName);
                para[3] = new SqlParameter("@ConsortiaID", consortiaID);
                para[3].Direction = ParameterDirection.InputOutput;
                para[4] = new SqlParameter("@ConsortiaName", System.Data.SqlDbType.NVarChar, 100);
                para[4].Value = consortiaName;
                para[4].Direction = ParameterDirection.InputOutput;
                para[5] = new SqlParameter("@Result", System.Data.SqlDbType.Int);
                para[5].Direction = ParameterDirection.ReturnValue;
                para[6] = new SqlParameter("@tempName", System.Data.SqlDbType.NVarChar, 100);
                para[6].Direction = ParameterDirection.InputOutput;
                para[6].Value = tempName;
                para[7] = new SqlParameter("@tempDutyID", System.Data.SqlDbType.Int);
                para[7].Direction = ParameterDirection.InputOutput;
                para[7].Value = info.DutyID;
                para[8] = new SqlParameter("@tempDutyName", System.Data.SqlDbType.NVarChar, 100);
                para[8].Direction = ParameterDirection.InputOutput;
                para[8].Value = "";
                para[9] = new SqlParameter("@tempOffer", System.Data.SqlDbType.Int);
                para[9].Direction = ParameterDirection.InputOutput;
                para[9].Value = info.Offer;
                para[10] = new SqlParameter("@tempRichesOffer", System.Data.SqlDbType.Int);
                para[10].Direction = ParameterDirection.InputOutput;
                para[10].Value = info.RichesOffer;
                para[11] = new SqlParameter("@tempRichesRob", System.Data.SqlDbType.Int);
                para[11].Direction = ParameterDirection.InputOutput;
                para[11].Value = info.RichesRob;
                para[12] = new SqlParameter("@tempLastDate", System.Data.SqlDbType.DateTime);
                para[12].Direction = ParameterDirection.InputOutput;
                para[12].Value = DateTime.Now;
                para[13] = new SqlParameter("@tempWin", System.Data.SqlDbType.Int);
                para[13].Direction = ParameterDirection.InputOutput;
                para[13].Value = info.Win;
                para[14] = new SqlParameter("@tempTotal", System.Data.SqlDbType.Int);
                para[14].Direction = ParameterDirection.InputOutput;
                para[14].Value = info.Total;
                para[15] = new SqlParameter("@tempEscape", System.Data.SqlDbType.Int);
                para[15].Direction = ParameterDirection.InputOutput;
                para[15].Value = info.Escape;
                para[16] = new SqlParameter("@tempID", System.Data.SqlDbType.Int);
                para[16].Direction = ParameterDirection.InputOutput;
                para[16].Value = tempID;
                para[17] = new SqlParameter("@tempGrade", System.Data.SqlDbType.Int);
                para[17].Direction = ParameterDirection.InputOutput;
                para[17].Value = info.Level;
                para[18] = new SqlParameter("@tempLevel", System.Data.SqlDbType.Int);
                para[18].Direction = ParameterDirection.InputOutput;
                para[18].Value = info.Level;
                para[19] = new SqlParameter("@tempCUID", System.Data.SqlDbType.Int);
                para[19].Direction = ParameterDirection.InputOutput;
                para[19].Value = info.ID;
                para[20] = new SqlParameter("@tempState", System.Data.SqlDbType.Int);
                para[20].Direction = ParameterDirection.InputOutput;
                para[20].Value = info.State;
                para[21] = new SqlParameter("@tempSex", System.Data.SqlDbType.Bit);
                para[21].Direction = ParameterDirection.InputOutput;
                para[21].Value = info.Sex;
                para[22] = new SqlParameter("@tempRight", System.Data.SqlDbType.Int);
                para[22].Direction = ParameterDirection.InputOutput;
                para[22].Value = info.Right;
                para[23] = new SqlParameter("@tempConsortiaRepute", System.Data.SqlDbType.Int);
                para[23].Direction = ParameterDirection.InputOutput;
                para[23].Value = consortiaRepute;

                db.RunProcedure("SP_ConsortiaInviteUser_Pass", para);
                int returnValue = (int)para[5].Value;

                result = returnValue == 0;
                if (result)
                {
                    consortiaID = (int)para[3].Value;
                    consortiaName = para[4].Value.ToString();

                    tempName = para[6].Value.ToString();
                    info.DutyID = (int)para[7].Value;
                    info.DutyName = para[8].Value.ToString();
                    info.Offer = (int)para[9].Value;
                    info.RichesOffer = (int)para[10].Value;
                    info.RichesRob = (int)para[11].Value;
                    info.LastDate = (DateTime)para[12].Value;
                    info.Win = (int)para[13].Value;
                    info.Total = (int)para[14].Value;
                    info.Escape = (int)para[15].Value;
                    tempID = (int)para[16].Value;
                    info.Grade = (int)para[17].Value;
                    info.Level = (int)para[18].Value;
                    info.ID = (int)para[19].Value;
                    info.State = (int)para[20].Value;
                    info.Sex = (bool)para[21].Value;
                    info.Right = (int)para[22].Value;
                    consortiaRepute = (int)para[23].Value;
                }

                switch (returnValue)
                {
                    case 3:
                        msg = "ConsortiaBussiness.PassConsortiaInviteUsers.Msg3";
                        break;
                    case 6:
                        msg = "ConsortiaBussiness.PassConsortiaInviteUsers.Msg6";
                        break;
                }
            }
            catch (Exception e)
            {
                if (log.IsErrorEnabled)
                    log.Error("Init", e);
            }
            return result;
        }
コード例 #4
0
        public ConsortiaUserInfo[] GetConsortiaUsersPage(int page, int size, ref int total, int order, int consortiaID, int userID, int state)
        {
            List<ConsortiaUserInfo> infos = new List<ConsortiaUserInfo>();
            try
            {
                string sWhere = " IsExist=1 ";
                if (consortiaID != -1)
                {
                    sWhere += " and ConsortiaID =" + consortiaID + " ";
                }
                if (userID != -1)
                {
                    sWhere += " and UserID =" + userID + " ";
                }
                if (state != -1)
                {
                    sWhere += " and state =" + state + " ";
                }
                string sOrder = "UserName";
                switch (order)
                {
                    case 1:
                        sOrder = "DutyID";
                        break;
                    case 2:
                        sOrder = "Grade";
                        break;
                    case 3:
                        sOrder = "Repute";
                        break;
                    case 4:
                        sOrder = "GP";
                        break;
                    case 5:
                        sOrder = "State";
                        break;
                    case 6:
                        sOrder = "Offer";
                        break;
                }

                sOrder += ",ID ";

                DataTable dt = GetPage("V_Consortia_Users", sWhere, page, size, "*", sOrder, "ID", ref total);
                foreach (DataRow dr in dt.Rows)
                {
                    ConsortiaUserInfo info = new ConsortiaUserInfo();
                    info.ID = (int)dr["ID"];
                    info.ConsortiaID = (int)dr["ConsortiaID"];
                    info.DutyID = (int)dr["DutyID"];
                    info.DutyName = dr["DutyName"].ToString();
                    info.IsExist = (bool)dr["IsExist"];
                    info.RatifierID = (int)dr["RatifierID"];
                    info.RatifierName = dr["RatifierName"].ToString();
                    info.Remark = dr["Remark"].ToString();
                    info.UserID = (int)dr["UserID"];
                    info.UserName = dr["UserName"].ToString();
                    info.Grade = (int)dr["Grade"];
                    info.GP = (int)dr["GP"];
                    info.Repute = (int)dr["Repute"];
                    info.State = (int)dr["State"];
                    info.Right = (int)dr["Right"];
                    info.Offer = (int)dr["Offer"];
                    info.Colors = dr["Colors"].ToString();
                    info.Style = dr["Style"].ToString();
                    info.Hide = (int)dr["Hide"];
                    info.Skin = dr["Skin"] == null ? "" : info.Skin;
                    info.Level = (int)dr["Level"];
                    info.LastDate = (DateTime)dr["LastDate"];
                    info.Sex = (bool)dr["Sex"];
                    info.IsBanChat = (bool)dr["IsBanChat"];
                    info.Win = (int)dr["Win"];
                    info.Total = (int)dr["Total"];
                    info.Escape = (int)dr["Escape"];
                    info.RichesOffer = (int)dr["RichesOffer"];
                    info.RichesRob = (int)dr["RichesRob"];
                    info.LoginName = dr["LoginName"] == null ? "" : dr["LoginName"].ToString();
                    info.Nimbus = (int)dr["Nimbus"];
                    info.FightPower = (int)dr["FightPower"];
                    info.typeVIP = Convert.ToByte(dr["typeVIP"]);
                    info.VIPLevel = (int)dr["VIPLevel"];
                    infos.Add(info);
                }

            }
            catch (Exception e)
            {
                if (log.IsErrorEnabled)
                    log.Error("Init", e);
            }
            finally
            {
            }

            return infos.ToArray();
        }
コード例 #5
0
 public void SendConsortiaUserPass(int playerid, string playerName, ConsortiaUserInfo info, bool isInvite, int consortiaRepute, string loginName,int fightpower)
 {
     GSPacketIn pkg = new GSPacketIn((byte)eChatServerPacket.CONSORTIA_RESPONSE, playerid);
     pkg.WriteByte(1);
     pkg.WriteInt(info.ID);
     pkg.WriteBoolean(isInvite);
     pkg.WriteInt(info.ConsortiaID);
     pkg.WriteString(info.ConsortiaName);
     pkg.WriteInt(info.UserID);
     pkg.WriteString(info.UserName);
     pkg.WriteInt(playerid);
     pkg.WriteString(playerName);
     pkg.WriteInt(info.DutyID);
     pkg.WriteString(info.DutyName);
     pkg.WriteInt(info.Offer);
     pkg.WriteInt(info.RichesOffer);
     pkg.WriteInt(info.RichesRob);
     pkg.WriteDateTime(info.LastDate);
     pkg.WriteInt(info.Grade);
     pkg.WriteInt(info.Level);
     pkg.WriteInt(info.State);
     pkg.WriteBoolean(info.Sex);
     pkg.WriteInt(info.Right);
     pkg.WriteInt(info.Win);
     pkg.WriteInt(info.Total);
     pkg.WriteInt(info.Escape);
     pkg.WriteInt(consortiaRepute);
     pkg.WriteString(loginName);
     pkg.WriteInt(fightpower);
     pkg.WriteInt(500);
     //New
     pkg.WriteString("Honor");
     SendTCP(pkg);
 }
コード例 #6
0
ファイル: PlayerBussiness.cs プロジェクト: nuinfo/Source
 public ConsortiaUserInfo InitConsortiaUserInfo(SqlDataReader dr)
 {
     ConsortiaUserInfo consortiaUserInfo = new ConsortiaUserInfo();
     consortiaUserInfo.ID = (int)dr["ID"];
     consortiaUserInfo.ConsortiaID = (int)dr["ConsortiaID"];
     consortiaUserInfo.DutyID = (int)dr["DutyID"];
     consortiaUserInfo.DutyName = dr["DutyName"].ToString();
     consortiaUserInfo.IsExist = (bool)dr["IsExist"];
     consortiaUserInfo.RatifierID = (int)dr["RatifierID"];
     consortiaUserInfo.RatifierName = dr["RatifierName"].ToString();
     consortiaUserInfo.Remark = dr["Remark"].ToString();
     consortiaUserInfo.UserID = (int)dr["UserID"];
     consortiaUserInfo.UserName = dr["UserName"].ToString();
     consortiaUserInfo.Grade = (int)dr["Grade"];
     consortiaUserInfo.GP = (int)dr["GP"];
     consortiaUserInfo.Repute = (int)dr["Repute"];
     consortiaUserInfo.State = (int)dr["State"];
     consortiaUserInfo.Right = (int)dr["Right"];
     consortiaUserInfo.Offer = (int)dr["Offer"];
     consortiaUserInfo.Colors = dr["Colors"].ToString();
     consortiaUserInfo.Style = dr["Style"].ToString();
     consortiaUserInfo.Hide = (int)dr["Hide"];
     consortiaUserInfo.Skin = dr["Skin"] == null ? "" : consortiaUserInfo.Skin;
     consortiaUserInfo.Level = (int)dr["Level"];
     consortiaUserInfo.LastDate = (DateTime)dr["LastDate"];
     consortiaUserInfo.Sex = (bool)dr["Sex"];
     consortiaUserInfo.IsBanChat = (bool)dr["IsBanChat"];
     consortiaUserInfo.Win = (int)dr["Win"];
     consortiaUserInfo.Total = (int)dr["Total"];
     consortiaUserInfo.Escape = (int)dr["Escape"];
     consortiaUserInfo.RichesOffer = (int)dr["RichesOffer"];
     consortiaUserInfo.RichesRob = (int)dr["RichesRob"];
     consortiaUserInfo.LoginName = dr["LoginName"] == null ? "" : dr["LoginName"].ToString();
     consortiaUserInfo.Nimbus = (int)dr["Nimbus"];
     consortiaUserInfo.FightPower = (int)dr["FightPower"];
     consortiaUserInfo.typeVIP = Convert.ToByte(dr["typeVIP"]);
     consortiaUserInfo.VIPLevel = (int)dr["VIPLevel"];
     return consortiaUserInfo;
 }
コード例 #7
0
ファイル: FlashUtils.cs プロジェクト: vancourt/BaseGunnyII
 public static XElement CreateConsortiaUserInfo(ConsortiaUserInfo info)
 {
     return new XElement("Item", new XAttribute("ID", info.ID),
         new XAttribute("ConsortiaID", info.ConsortiaID),
         new XAttribute("DutyID", info.DutyID),
         new XAttribute("DutyName", info.DutyName == null ? "" : info.DutyName),
         new XAttribute("GP", info.GP),
         new XAttribute("Grade", info.Grade),
         new XAttribute("Right", info.Right),
         new XAttribute("DutyLevel", info.Level),
         new XAttribute("Offer", info.Offer),
         new XAttribute("RatifierID", info.RatifierID),
         new XAttribute("RatifierName", info.RatifierName == null ? "" : info.RatifierName),
         new XAttribute("Remark", info.Remark == null ? "" : info.Remark),
         new XAttribute("Repute", info.Repute),
         new XAttribute("State", info.State == 1 ? 1 : 0),
         new XAttribute("UserID", info.UserID),
         new XAttribute("Hide", info.Hide),
         new XAttribute("Colors", info.Colors == null ? "" : info.Colors),
         new XAttribute("Skin", info.Skin == null ? "" : info.Skin),
         new XAttribute("Style", info.Style),
         new XAttribute("LastDate", info.LastDate.ToString("yyyy-MM-dd HH:mm:ss")),
         new XAttribute("Sex", info.Sex),
         new XAttribute("IsBanChat", info.IsBanChat),
         new XAttribute("WinCount", info.Win),
         new XAttribute("TotalCount", info.Total),
         new XAttribute("EscapeCount", info.Escape),
         new XAttribute("RichesOffer", info.RichesOffer),
         new XAttribute("RichesRob", info.RichesRob),
         new XAttribute("Nimbus", info.Nimbus),
         new XAttribute("LoginName", info.LoginName == null ? "" : info.LoginName),
         new XAttribute("UserName", info.UserName == null ? "" : info.UserName),
         new XAttribute("typeVIP", info.typeVIP),
         new XAttribute("VIPLevel", info.VIPLevel),
         new XAttribute("AchievementPoint", 1),
         new XAttribute("Rank", "honor"),
         new XAttribute("FightPower", info.FightPower),
         new XAttribute("IsCandidate", false),
         //new XAttribute("IsDownGrade", true),
         //new XAttribute("IsEditorPlacard", true),
         //new XAttribute("IsEditorDescription", true),
         //new XAttribute("IsExpel", true),
         //new XAttribute("IsEditorUser", true),
         new XAttribute("IsVote", false),
         new XAttribute("TotalRichesOffer", 106),
         new XAttribute("LastWeekRichesOffer", 0));
         //new XAttribute("IsRatify", true),
         //new XAttribute("IsChat", true));
 }
コード例 #8
0
ファイル: FlashUtils.cs プロジェクト: vancourt/BaseGunnyII
 public static XElement CreateConsortiaIMInfo(ConsortiaUserInfo info)
 {
     return new XElement("Item", new XAttribute("ID", info.ID),
               new XAttribute("ConsortiaID", info.ConsortiaID),
               new XAttribute("DutyID", info.DutyID),
               new XAttribute("DutyName", info.DutyName == null ? "" : info.DutyName),
               new XAttribute("GP", info.GP),
               new XAttribute("Grade", info.Grade),
               new XAttribute("Level", info.Level),
               new XAttribute("Offer", info.Offer),
               new XAttribute("Remark", info.Remark == null ? "" : info.Remark),
               new XAttribute("Repute", info.Repute),
               new XAttribute("State", info.State == 1 ? 1 : 0),
               new XAttribute("UserID", info.UserID),
               new XAttribute("Hide", info.Hide),
               new XAttribute("Colors", info.Colors == null ? "" : info.Colors),
               new XAttribute("Skin", info.Skin == null ? "" : info.Skin),
               new XAttribute("Style", info.Style),
               new XAttribute("LastDate", info.LastDate.ToString("yyyy-MM-dd HH:mm:ss")),
               new XAttribute("Sex", info.Sex),
               new XAttribute("LoginName", info.LoginName),
               new XAttribute("NickName", info.UserName == null ? "" : info.UserName));
 }