public void HandleGameRoomCreate(GSPacketIn pkg)
{
int roomId = pkg.ReadInt();
int gameType = pkg.ReadInt();
int count = pkg.ReadInt();
IGamePlayer[] players = new IGamePlayer[count];
for (int i = 0; i < count; i++)
{
PlayerInfo info = new PlayerInfo();
info.ID = pkg.ReadInt();
info.Attack = pkg.ReadInt();
info.Defence = pkg.ReadInt();
info.Agility = pkg.ReadInt();
info.Luck = pkg.ReadInt();
double baseAttack = pkg.ReadDouble();
double baseDefence = pkg.ReadDouble();
double baseAgility = pkg.ReadDouble();
double baseBlood = pkg.ReadDouble();
int templateId = pkg.ReadInt();
ItemTemplateInfo itemTemplate = ItemMgr.FindItemTemplate(templateId);
ItemInfo item = new ItemInfo(itemTemplate);
players[i] = new ProxyPlayer(info, item, baseAttack, baseDefence, baseAgility, baseBlood);
}
ProxyRoomMgr.CreateRoom(players, roomId, this);
}
public bool ActivePlayer(ref PlayerInfo player, string userName, string passWord, bool sex, int gold, int money, string IP, string site)
{
bool result = false;
try
{
player = new PlayerInfo();
player.Agility = 0;
player.Attack = 0;
player.Colors = ",,,,,,";
player.Skin = "";
player.ConsortiaID = 0;
player.Defence = 0;
player.Gold = gold;
player.GP = 1;
player.Grade = 1;
player.ID = 0;
player.Luck = 0;
player.Money = money;
player.NickName = "";
player.Sex = sex;
player.State = 0;
player.Style = ",,,,,,";
player.Hide = 1111111111;
//isFirst = true;
SqlParameter[] para = new SqlParameter[21];
para[0] = new SqlParameter("@UserID", System.Data.SqlDbType.Int);
para[0].Direction = ParameterDirection.Output;
para[1] = new SqlParameter("@Attack", player.Attack);
para[2] = new SqlParameter("@Colors", player.Colors == null ? "" : player.Colors);
para[3] = new SqlParameter("@ConsortiaID", player.ConsortiaID);
para[4] = new SqlParameter("@Defence", player.Defence);
para[5] = new SqlParameter("@Gold", player.Gold);
para[6] = new SqlParameter("@GP", player.GP);
para[7] = new SqlParameter("@Grade", player.Grade);
para[8] = new SqlParameter("@Luck", player.Luck);
para[9] = new SqlParameter("@Money", player.Money);
para[10] = new SqlParameter("@Style", player.Style == null ? "" : player.Style);
para[11] = new SqlParameter("@Agility", player.Agility);
para[12] = new SqlParameter("@State", player.State);
para[13] = new SqlParameter("@UserName", userName);
para[14] = new SqlParameter("@PassWord", passWord);
para[15] = new SqlParameter("@Sex", sex);
para[16] = new SqlParameter("@Hide", player.Hide);
para[17] = new SqlParameter("@ActiveIP", IP);
para[18] = new SqlParameter("@Skin", player.Skin == null ? "" : player.Skin);
para[19] = new SqlParameter("@Result", System.Data.SqlDbType.Int);
para[19].Direction = ParameterDirection.ReturnValue;
para[20] = new SqlParameter("@Site", site);
result = db.RunProcedure("SP_Users_Active", para);
player.ID = (int)para[0].Value;
result = (int)para[19].Value == 0;
}
catch (Exception e)
{
if (log.IsErrorEnabled)
log.Error("Init", e);
}
return result;
}
public GamePlayer(int playerId, string account, GameClient client, PlayerInfo info)
: base()
{
m_playerId = playerId;
m_account = account;
m_client = client;
m_character = info;
LastChatTime = DateTime.Today;
m_mainBag = new PlayerEquipInventory(this);
m_propBag = new PlayerInventory(this, true, 49, 1, 0, true);
m_storeBag = new PlayerInventory(this, true, 100, 11, 0, true);
m_storeBag2 = new PlayerInventory(this, true, 20, 12, 0, true);
m_fightBag = new PlayerInventory(this, false, 3, 3, 0, false);
m_tempBag = new PlayerInventory(this, false, 60, 4, 0, true);
m_caddyBag = new PlayerInventory(this, false, 20, 5, 0, true);
m_cardBag = new PlayerInventory(this, true, 20, 15, 0, true);
m_questInventory = new QuestInventory(this);
m_bufferList = new BufferList(this);
m_equipEffect = new List<int>();
//双倍经验卡初始化
GPAddPlus = 1;
X = 646;
Y = 1241;
MarryMap = 0;
m_converter = new System.Text.UTF8Encoding();
}
public bool ActivePlayer(ref PlayerInfo player, string userName, string passWord, bool sex, int gold, int money, string IP, string site)
{
bool flag = false;
try
{
player = new PlayerInfo();
player.Agility = 0;
player.Attack = 0;
player.Colors = ",,,,,,";
player.Skin = "";
player.ConsortiaID = 0;
player.Defence = 0;
player.Gold = 0;
player.GP = 1;
player.Grade = 1;
player.ID = 0;
player.Luck = 0;
player.Money = 0;
player.NickName = "";
player.Sex = sex;
player.State = 0;
player.Style = ",,,,,,";
player.Hide = 1111111111;
SqlParameter[] SqlParameters = new SqlParameter[21];
SqlParameters[0] = new SqlParameter("@UserID", SqlDbType.Int);
SqlParameters[0].Direction = ParameterDirection.Output;
SqlParameters[1] = new SqlParameter("@Attack", (object)player.Attack);
SqlParameters[2] = new SqlParameter("@Colors", player.Colors == null ? (object)"" : (object)player.Colors);
SqlParameters[3] = new SqlParameter("@ConsortiaID", (object)player.ConsortiaID);
SqlParameters[4] = new SqlParameter("@Defence", (object)player.Defence);
SqlParameters[5] = new SqlParameter("@Gold", (object)player.Gold);
SqlParameters[6] = new SqlParameter("@GP", (object)player.GP);
SqlParameters[7] = new SqlParameter("@Grade", (object)player.Grade);
SqlParameters[8] = new SqlParameter("@Luck", (object)player.Luck);
SqlParameters[9] = new SqlParameter("@Money", (object)player.Money);
SqlParameters[10] = new SqlParameter("@Style", player.Style == null ? (object)"" : (object)player.Style);
SqlParameters[11] = new SqlParameter("@Agility", (object)player.Agility);
SqlParameters[12] = new SqlParameter("@State", (object)player.State);
SqlParameters[13] = new SqlParameter("@UserName", (object)userName);
SqlParameters[14] = new SqlParameter("@PassWord", (object)passWord);
SqlParameters[15] = new SqlParameter("@Sex", (object)(int)(sex ? 1 : 0));
SqlParameters[16] = new SqlParameter("@Hide", (object)player.Hide);
SqlParameters[17] = new SqlParameter("@ActiveIP", (object)IP);
SqlParameters[18] = new SqlParameter("@Skin", player.Skin == null ? (object)"" : (object)player.Skin);
SqlParameters[19] = new SqlParameter("@Result", SqlDbType.Int);
SqlParameters[19].Direction = ParameterDirection.ReturnValue;
SqlParameters[20] = new SqlParameter("@Site", (object)site);
flag = this.db.RunProcedure("SP_Users_Active", SqlParameters);
player.ID = (int)SqlParameters[0].Value;
flag = (int)SqlParameters[19].Value == 0;
}
catch (Exception ex)
{
if (BaseBussiness.log.IsErrorEnabled)
BaseBussiness.log.Error((object)"Init", ex);
}
return flag;
}
public ProxyPlayer(ServerClient client, PlayerInfo character, ItemTemplateInfo currentWeapon, ItemInfo secondweapon, double baseAttack, double baseDefence, double baseAglilty, double baseBoold, double gprate, double offerrate, double rate, List<BufferInfo> infos, int serverid)
{
m_client = client;
m_character = character;
m_baseAttack = baseAttack;
m_baseDefence = baseDefence;
m_baseAglilty = baseAglilty;
m_baseBlood = baseBoold;
m_currentWeapon = currentWeapon;
m_secondWeapon = secondweapon;
m_equipEffect = new List<int>();
GPRate = gprate;
OfferRate = offerrate;
Rate = rate;
Buffers = infos;
m_serverid = serverid;
}
public void SendSYSMessages(GamePlayer player, PlayerInfo spouse)
{
string name1 = player.PlayerCharacter.Sex ? player.PlayerCharacter.NickName : spouse.NickName;
string name2 = player.PlayerCharacter.Sex ? spouse.NickName : player.PlayerCharacter.NickName;
string msg = LanguageMgr.GetTranslation("MarryApplyReplyHandler.Msg1", name1, name2);
GSPacketIn pkg = new GSPacketIn((byte)ePackageType.SYS_NOTICE);
pkg.WriteInt(2);
pkg.WriteString(msg);
GameServer.Instance.LoginServer.SendPacket(pkg);
GamePlayer[] players = Game.Server.Managers.WorldMgr.GetAllPlayers();
foreach (GamePlayer p in players)
{
p.Out.SendTCP(pkg);
}
}
public bool UpdatePlayer(PlayerInfo player)
{
bool result = false;
try
{
if (player.Grade < 1)
return result;
SqlParameter[] para = new SqlParameter[35];
para[0] = new SqlParameter("@UserID", player.ID);
para[1] = new SqlParameter("@Attack", player.Attack);
para[2] = new SqlParameter("@Colors", player.Colors == null ? "" : player.Colors);
para[3] = new SqlParameter("@ConsortiaID", player.ConsortiaID);
para[4] = new SqlParameter("@Defence", player.Defence);
para[5] = new SqlParameter("@Gold", player.Gold);
para[6] = new SqlParameter("@GP", player.GP);
para[7] = new SqlParameter("@Grade", player.Grade);
para[8] = new SqlParameter("@Luck", player.Luck);
para[9] = new SqlParameter("@Money", player.Money);
para[10] = new SqlParameter("@Style", player.Style == null ? "" : player.Style);
para[11] = new SqlParameter("@Agility", player.Agility);
para[12] = new SqlParameter("@State", player.State);
para[13] = new SqlParameter("@Hide", player.Hide);
para[14] = new SqlParameter("@ExpendDate", player.ExpendDate == null ? "" : player.ExpendDate.ToString());
para[15] = new SqlParameter("@Win", player.Win);
para[16] = new SqlParameter("@Total", player.Total);
para[17] = new SqlParameter("@Escape", player.Escape);
para[18] = new SqlParameter("@Skin", player.Skin == null ? "" : player.Skin);
para[19] = new SqlParameter("@Offer", player.Offer);
para[20] = new SqlParameter("@AntiAddiction", player.AntiAddiction);
para[20].Direction = ParameterDirection.InputOutput;
para[21] = new SqlParameter("@Result", System.Data.SqlDbType.Int);
para[21].Direction = ParameterDirection.ReturnValue;
para[22] = new SqlParameter("@RichesOffer", player.RichesOffer);
para[23] = new SqlParameter("@RichesRob", player.RichesRob);
para[24] = new SqlParameter("@CheckCount", player.CheckCount);
para[24].Direction = ParameterDirection.InputOutput;
para[25] = new SqlParameter("@MarryInfoID", player.MarryInfoID);
para[26] = new SqlParameter("@DayLoginCount", player.DayLoginCount);
para[27] = new SqlParameter("@Nimbus", player.Nimbus);
para[28] = new SqlParameter("@LastAward", player.LastAward);
para[29] = new SqlParameter("@GiftToken", player.GiftToken);
para[30] = new SqlParameter("@QuestSite", player.QuestSite);
para[31] = new SqlParameter("@PvePermission", player.PvePermission);
para[32] = new SqlParameter("@FightPower", player.FightPower);
para[33] = new SqlParameter("@AnswerSite", player.AnswerSite);
para[34] = new SqlParameter("@LastAuncherAward", player.LastAward);
//para[34].Direction = ParameterDirection.Output;
db.RunProcedure("SP_Users_Update", para);
result = (int)para[21].Value == 0;
//TrieuLSL
//result = true;
if (result)
{
player.AntiAddiction = (int)para[20].Value;
player.CheckCount = (int)para[24].Value;
}
player.IsDirty = false;
}
catch (Exception e)
{
if (log.IsErrorEnabled)
log.Error("Init", e);
}
return result;
}
public GSPacketIn SendUserEquip(PlayerInfo player, List<ItemInfo> items)
{
GSPacketIn pkg = new GSPacketIn((byte)ePackageType.ITEM_EQUIP, player.ID, 10240);
pkg.WriteInt(player.ID);
pkg.WriteInt(player.Agility);
pkg.WriteInt(player.Attack);
pkg.WriteString(player.Colors);
pkg.WriteString(player.Skin);
pkg.WriteInt(player.Defence);
pkg.WriteInt(player.GP);
pkg.WriteInt(player.Grade);
pkg.WriteInt(player.Luck);
pkg.WriteInt(player.Hide);
pkg.WriteInt(player.Repute);
pkg.WriteBoolean(player.Sex);
pkg.WriteString(player.Style);
pkg.WriteInt(player.Offer);
pkg.WriteString(player.NickName);
pkg.WriteBoolean(true);
pkg.WriteInt(5);
pkg.WriteInt(player.Win);
pkg.WriteInt(player.Total);
pkg.WriteInt(player.Escape);
pkg.WriteInt(player.ConsortiaID);
pkg.WriteString(player.ConsortiaName);
pkg.WriteInt(player.RichesOffer);
pkg.WriteInt(player.RichesRob);
pkg.WriteBoolean(player.IsMarried);
pkg.WriteInt(player.SpouseID);
pkg.WriteString(player.SpouseName);
pkg.WriteString(player.DutyName);
pkg.WriteInt(player.Nimbus);
pkg.WriteInt(player.FightPower);
pkg.WriteInt(5);
pkg.WriteInt(-1);
pkg.WriteString("Master");
pkg.WriteInt(5);
pkg.WriteString("HoNorMaster");
//AchievementPoint
pkg.WriteInt(9999);
pkg.WriteString("Honor");
pkg.WriteDateTime(DateTime.Now.AddDays(-2));
pkg.WriteInt(items.Count);
foreach (ItemInfo info in items)
{
pkg.WriteByte((byte)info.BagType);
pkg.WriteInt(info.UserID);
pkg.WriteInt(info.ItemID);
pkg.WriteInt(info.Count);
pkg.WriteInt(info.Place);
pkg.WriteInt(info.TemplateID);
pkg.WriteInt(info.AttackCompose);
pkg.WriteInt(info.DefendCompose);
pkg.WriteInt(info.AgilityCompose);
pkg.WriteInt(info.LuckCompose);
pkg.WriteInt(info.StrengthenLevel);
pkg.WriteBoolean(info.IsBinds);
pkg.WriteBoolean(info.IsJudge);
pkg.WriteDateTime(info.BeginDate);
pkg.WriteInt(info.ValidDate);
pkg.WriteString(info.Color);
pkg.WriteString(info.Skin);
pkg.WriteBoolean(info.IsUsed);
pkg.WriteInt(info.Hole1);
pkg.WriteInt(info.Hole2);
pkg.WriteInt(info.Hole3);
pkg.WriteInt(info.Hole4);
pkg.WriteInt(info.Hole5);
pkg.WriteInt(info.Hole6);
pkg.WriteString(info.Template.Pic);
pkg.WriteInt(info.Template.RefineryLevel);
pkg.WriteDateTime(DateTime.Now);
pkg.WriteByte(5);
pkg.WriteInt(5);
pkg.WriteByte(5);
pkg.WriteInt(5);
//item.Hole5Level = pkg.readByte();
//item.Hole5Exp = pkg.readInt();
//item.Hole6Level = pkg.readByte();
//item.Hole6Exp = pkg.readInt();
}
pkg.Compress();
SendTCP(pkg);
return pkg;
}
public void SendUpdatePrivateInfo(PlayerInfo info)
{
GSPacketIn pkg = new GSPacketIn((byte)ePackageType.UPDATE_PRIVATE_INFO, info.ID);
pkg.WriteInt(info.Money);
//Medal
pkg.WriteInt(1);
pkg.WriteInt(info.Gold);
pkg.WriteInt(info.GiftToken);
SendTCP(pkg);
}
public bool UpdateVIPInfo(PlayerInfo p)
{
bool flag = false;
try
{
SqlParameter[] SqlParameters = new SqlParameter[10]
{
new SqlParameter("@ID", (object) p.ID),
new SqlParameter("@VIPLevel", (object) p.VIPLevel),
new SqlParameter("@VIPExp", (object) p.VIPExp),
new SqlParameter("@VIPOnlineDays", SqlDbType.BigInt),
new SqlParameter("@VIPOfflineDays", SqlDbType.BigInt),
new SqlParameter("@VIPExpireDay", (object) p.VIPExpireDay.ToString()),
new SqlParameter("@VIPLastDate", (object) DateTime.Now),
new SqlParameter("@VIPNextLevelDaysNeeded", SqlDbType.BigInt),
new SqlParameter("@CanTakeVipReward", (object) (int) (p.CanTakeVipReward ? 1 : 0)),
new SqlParameter("@Result", SqlDbType.Int)
};
SqlParameters[9].Direction = ParameterDirection.ReturnValue;
this.db.RunProcedure("SP_UpdateVIPInfo", SqlParameters);
flag = true;
}
catch (Exception ex)
{
if (BaseBussiness.log.IsErrorEnabled)
BaseBussiness.log.Error((object)"SP_UpdateVIPInfo", ex);
}
return flag;
}
public bool UpdatePlayer(PlayerInfo player)
{
bool flag = false;
try
{
if (player.Grade < 1)
return flag;
SqlParameter[] SqlParameters = new SqlParameter[81];
SqlParameters[0] = new SqlParameter("@UserID", (object)player.ID);
SqlParameters[1] = new SqlParameter("@Attack", (object)player.Attack);
SqlParameters[2] = new SqlParameter("@Colors", player.Colors == null ? (object)"" : (object)player.Colors);
SqlParameters[3] = new SqlParameter("@ConsortiaID", (object)player.ConsortiaID);
SqlParameters[4] = new SqlParameter("@Defence", (object)player.Defence);
SqlParameters[5] = new SqlParameter("@Gold", (object)player.Gold);
SqlParameters[6] = new SqlParameter("@GP", (object)player.GP);
SqlParameters[7] = new SqlParameter("@Grade", (object)player.Grade);
SqlParameters[8] = new SqlParameter("@Luck", (object)player.Luck);
SqlParameters[9] = new SqlParameter("@Money", (object)player.Money);
SqlParameters[10] = new SqlParameter("@Style", player.Style == null ? (object)"" : (object)player.Style);
SqlParameters[11] = new SqlParameter("@Agility", (object)player.Agility);
SqlParameters[12] = new SqlParameter("@State", (object)player.State);
SqlParameters[13] = new SqlParameter("@Hide", (object)player.Hide);
SqlParameters[14] = new SqlParameter("@ExpendDate", !player.ExpendDate.HasValue ? (object)"" : (object)player.ExpendDate.ToString());
SqlParameters[15] = new SqlParameter("@Win", (object)player.Win);
SqlParameters[16] = new SqlParameter("@Total", (object)player.Total);
SqlParameters[17] = new SqlParameter("@Escape", (object)player.Escape);
SqlParameters[18] = new SqlParameter("@Skin", player.Skin == null ? (object)"" : (object)player.Skin);
SqlParameters[19] = new SqlParameter("@Offer", (object)player.Offer);
SqlParameters[20] = new SqlParameter("@AntiAddiction", (object)player.AntiAddiction);
SqlParameters[20].Direction = ParameterDirection.InputOutput;
SqlParameters[21] = new SqlParameter("@Result", SqlDbType.Int);
SqlParameters[21].Direction = ParameterDirection.ReturnValue;
SqlParameters[22] = new SqlParameter("@RichesOffer", (object)player.RichesOffer);
SqlParameters[23] = new SqlParameter("@RichesRob", (object)player.RichesRob);
SqlParameters[24] = new SqlParameter("@CheckCount", (object)player.CheckCount);
SqlParameters[24].Direction = ParameterDirection.InputOutput;
SqlParameters[25] = new SqlParameter("@MarryInfoID", (object)player.MarryInfoID);
SqlParameters[26] = new SqlParameter("@DayLoginCount", (object)player.DayLoginCount);
SqlParameters[27] = new SqlParameter("@Nimbus", (object)player.Nimbus);
SqlParameters[28] = new SqlParameter("@LastAward", (object)player.LastAward);
SqlParameters[29] = new SqlParameter("@GiftToken", (object)player.GiftToken);
SqlParameters[30] = new SqlParameter("@QuestSite", (object)player.QuestSite);
SqlParameters[31] = new SqlParameter("@PvePermission", (object)player.PvePermission);
SqlParameters[32] = new SqlParameter("@FightPower", (object)player.FightPower);
SqlParameters[33] = new SqlParameter("@AnswerSite", (object)player.AnswerSite);
SqlParameters[34] = new SqlParameter("@LastAuncherAward", (object)player.LastAward);
SqlParameters[35] = new SqlParameter("@hp", (object)player.hp);
SqlParameters[36] = new SqlParameter("@ChatCount", (object)player.ChatCount);
SqlParameters[37] = new SqlParameter("@SpaPubGoldRoomLimit", (object)player.SpaPubGoldRoomLimit);
SqlParameters[38] = new SqlParameter("@LastSpaDate", (object)player.LastSpaDate);
SqlParameters[39] = new SqlParameter("@FightLabPermission", (object)player.FightLabPermission);
SqlParameters[40] = new SqlParameter("@SpaPubMoneyRoomLimit", (object)player.SpaPubMoneyRoomLimit);
SqlParameters[41] = new SqlParameter("@IsInSpaPubGoldToday", (object)(int)(player.IsInSpaPubGoldToday ? 1 : 0));
SqlParameters[42] = new SqlParameter("@IsInSpaPubMoneyToday", (object)(int)(player.IsInSpaPubMoneyToday ? 1 : 0));
SqlParameters[43] = new SqlParameter("@AchievementPoint", (object)player.AchievementPoint);
SqlParameters[44] = new SqlParameter("@LastWeekly", (object)player.LastWeekly);
SqlParameters[45] = new SqlParameter("@LastWeeklyVersion", (object)player.LastWeeklyVersion);
SqlParameters[46] = new SqlParameter("@GiftGp", (object)player.GiftGp);
SqlParameters[47] = new SqlParameter("@GiftLevel", (object)player.GiftLevel);
SqlParameters[48] = new SqlParameter("@IsOpenGift", (object)(int)(player.IsOpenGift ? 1 : 0));
SqlParameters[49] = new SqlParameter("@WeaklessGuildProgressStr", (object)player.WeaklessGuildProgressStr);
SqlParameters[50] = new SqlParameter("@IsOldPlayer", (object)(int)(player.IsOldPlayer ? 1 : 0));
SqlParameters[51] = new SqlParameter("@VIPLevel", (object)player.VIPLevel);
SqlParameters[52] = new SqlParameter("@VIPExp", (object)player.VIPExp);
SqlParameters[53] = new SqlParameter("@Score", (object)player.Score);
SqlParameters[54] = new SqlParameter("@OptionOnOff", (object)player.OptionOnOff);
SqlParameters[55] = new SqlParameter("@isOldPlayerHasValidEquitAtLogin", (object)(int)(player.isOldPlayerHasValidEquitAtLogin ? 1 : 0));
SqlParameters[56] = new SqlParameter("@badLuckNumber", (object)player.badLuckNumber);
SqlParameters[57] = new SqlParameter("@luckyNum", (object)player.luckyNum);
SqlParameters[58] = new SqlParameter("@lastLuckyNumDate", (object)player.lastLuckyNumDate.ToString());
SqlParameters[59] = new SqlParameter("@lastLuckNum", (object)player.lastLuckNum);
SqlParameters[60] = new SqlParameter("@CardSoul", (object)player.CardSoul);
SqlParameters[61] = new SqlParameter("@uesedFinishTime", (object)player.uesedFinishTime);
SqlParameters[62] = new SqlParameter("@totemId", (object)player.totemId);
SqlParameters[63] = new SqlParameter("@damageScores", (object)player.damageScores);
SqlParameters[64] = new SqlParameter("@petScore", (object)player.petScore);
SqlParameters[65] = new SqlParameter("@IsShowConsortia", (object)(int)(player.IsShowConsortia ? 1 : 0));
SqlParameter[] sqlParameterArray1 = SqlParameters;
int index1 = 66;
string parameterName1 = "@LastRefreshPet";
DateTime dateTime = player.LastRefreshPet;
string str1 = dateTime.ToString();
SqlParameter sqlParameter1 = new SqlParameter(parameterName1, (object)str1);
sqlParameterArray1[index1] = sqlParameter1;
SqlParameters[67] = new SqlParameter("@GetSoulCount", (object)player.GetSoulCount);
SqlParameters[68] = new SqlParameter("@isFirstDivorce", (object)player.isFirstDivorce);
SqlParameters[69] = new SqlParameter("@needGetBoxTime", (object)player.needGetBoxTime);
SqlParameters[70] = new SqlParameter("@myScore", (object)player.myScore);
SqlParameter[] sqlParameterArray2 = SqlParameters;
int index2 = 71;
string parameterName2 = "@TimeBox";
dateTime = player.TimeBox;
string str2 = dateTime.ToString();
SqlParameter sqlParameter2 = new SqlParameter(parameterName2, (object)str2);
sqlParameterArray2[index2] = sqlParameter2;
SqlParameters[72] = new SqlParameter("@IsFistGetPet", (object)(int)(player.IsFistGetPet ? 1 : 0));
SqlParameters[73] = new SqlParameter("@MaxBuyHonor", (object)player.MaxBuyHonor);
SqlParameters[74] = new SqlParameter("@Medal", (object)player.medal);
SqlParameters[75] = new SqlParameter("@myHonor", (object)player.myHonor);
SqlParameters[76] = new SqlParameter("@LeagueMoney", (object)player.LeagueMoney);
SqlParameters[77] = new SqlParameter("@Honor", (object)player.Honor);
SqlParameters[78] = new SqlParameter("@necklaceExp", (object)player.necklaceExp);
SqlParameters[79] = new SqlParameter("@necklaceExpAdd", (object)player.necklaceExpAdd);
SqlParameters[80] = new SqlParameter("@hardCurrency", (object)player.hardCurrency);
this.db.RunProcedure("SP_Users_Update", SqlParameters);
flag = (int)SqlParameters[21].Value == 0;
if (flag)
{
player.AntiAddiction = (int)SqlParameters[20].Value;
player.CheckCount = (int)SqlParameters[24].Value;
}
player.IsDirty = false;
}
catch (Exception ex)
{
if (BaseBussiness.log.IsErrorEnabled)
BaseBussiness.log.Error((object)"Init", ex);
}
return flag;
}
public PlayerInfo[] GetPlayerPage(int page, int size, ref int total, int order, int userID, ref bool resultValue)
{
List<PlayerInfo> list = new List<PlayerInfo>();
try
{
string queryWhere = " IsExist=1 and IsFirst<> 0 ";
if (userID != -1)
queryWhere = string.Concat(new object[4]
{
(object) queryWhere,
(object) " and UserID =",
(object) userID,
(object) " "
});
string str = "GP desc";
switch (order)
{
case 1:
str = "Offer desc";
break;
case 2:
str = "AddDayGP desc";
break;
case 3:
str = "AddWeekGP desc";
break;
case 4:
str = "AddDayOffer desc";
break;
case 5:
str = "AddWeekOffer desc";
break;
case 6:
str = "FightPower desc";
break;
case 7:
str = "AchievementPoint desc";
break;
case 8:
str = "AddDayAchievementPoint desc";
break;
case 9:
str = "AddWeekAchievementPoint desc";
break;
case 10:
str = "GiftGp desc";
break;
case 11:
str = "AddDayGiftGp desc";
break;
case 12:
str = "AddWeekGiftGp desc";
break;
}
string fdOreder = str + ",UserID";
foreach (DataRow dataRow in (InternalDataCollectionBase)this.GetPage("V_Sys_Users_Detail", queryWhere, page, size, "*", fdOreder, "UserID", ref total).Rows)
{
PlayerInfo playerInfo = new PlayerInfo();
playerInfo.Agility = (int)dataRow["Agility"];
playerInfo.Attack = (int)dataRow["Attack"];
playerInfo.Colors = dataRow["Colors"] == null ? "" : dataRow["Colors"].ToString();
playerInfo.ConsortiaID = (int)dataRow["ConsortiaID"];
playerInfo.Defence = (int)dataRow["Defence"];
playerInfo.Gold = (int)dataRow["Gold"];
playerInfo.GP = (int)dataRow["GP"];
playerInfo.Grade = (int)dataRow["Grade"];
playerInfo.ID = (int)dataRow["UserID"];
playerInfo.Luck = (int)dataRow["Luck"];
playerInfo.Money = (int)dataRow["Money"];
playerInfo.NickName = dataRow["NickName"] == null ? "" : dataRow["NickName"].ToString();
playerInfo.Sex = (bool)dataRow["Sex"];
playerInfo.State = (int)dataRow["State"];
playerInfo.Style = dataRow["Style"] == null ? "" : dataRow["Style"].ToString();
playerInfo.Hide = (int)dataRow["Hide"];
playerInfo.Repute = (int)dataRow["Repute"];
playerInfo.UserName = dataRow["UserName"] == null ? "" : dataRow["UserName"].ToString();
playerInfo.ConsortiaName = dataRow["ConsortiaName"] == null ? "" : dataRow["ConsortiaName"].ToString();
playerInfo.Offer = (int)dataRow["Offer"];
playerInfo.Skin = dataRow["Skin"] == null ? "" : dataRow["Skin"].ToString();
playerInfo.IsBanChat = (bool)dataRow["IsBanChat"];
playerInfo.ReputeOffer = (int)dataRow["ReputeOffer"];
playerInfo.ConsortiaRepute = (int)dataRow["ConsortiaRepute"];
playerInfo.ConsortiaLevel = (int)dataRow["ConsortiaLevel"];
playerInfo.StoreLevel = (int)dataRow["StoreLevel"];
playerInfo.ShopLevel = (int)dataRow["ShopLevel"];
playerInfo.SmithLevel = (int)dataRow["SmithLevel"];
playerInfo.ConsortiaHonor = (int)dataRow["ConsortiaHonor"];
playerInfo.RichesOffer = (int)dataRow["RichesOffer"];
playerInfo.RichesRob = (int)dataRow["RichesRob"];
playerInfo.DutyLevel = (int)dataRow["DutyLevel"];
playerInfo.DutyName = dataRow["DutyName"] == null ? "" : dataRow["DutyName"].ToString();
playerInfo.Right = (int)dataRow["Right"];
playerInfo.ChairmanName = dataRow["ChairmanName"] == null ? "" : dataRow["ChairmanName"].ToString();
playerInfo.Win = (int)dataRow["Win"];
playerInfo.Total = (int)dataRow["Total"];
playerInfo.Escape = (int)dataRow["Escape"];
playerInfo.AddDayGP = (int)dataRow["AddDayGP"] == 0 ? playerInfo.GP : (int)dataRow["AddDayGP"];
playerInfo.AddDayOffer = (int)dataRow["AddDayOffer"] == 0 ? playerInfo.Offer : (int)dataRow["AddDayOffer"];
playerInfo.AddWeekGP = (int)dataRow["AddWeekGP"] == 0 ? playerInfo.GP : (int)dataRow["AddWeekyGP"];
playerInfo.AddWeekOffer = (int)dataRow["AddWeekOffer"] == 0 ? playerInfo.Offer : (int)dataRow["AddWeekOffer"];
playerInfo.ConsortiaRiches = (int)dataRow["ConsortiaRiches"];
playerInfo.CheckCount = (int)dataRow["CheckCount"];
playerInfo.Nimbus = (int)dataRow["Nimbus"];
playerInfo.GiftToken = (int)dataRow["GiftToken"];
playerInfo.QuestSite = dataRow["QuestSite"] == null ? new byte[200] : (byte[])dataRow["QuestSite"];
playerInfo.PvePermission = dataRow["PvePermission"] == null ? "" : dataRow["PvePermission"].ToString();
playerInfo.FightPower = (int)dataRow["FightPower"];
list.Add(playerInfo);
}
resultValue = true;
}
catch (Exception ex)
{
if (BaseBussiness.log.IsErrorEnabled)
BaseBussiness.log.Error((object)"Init", ex);
}
return list.ToArray();
}
public bool UpdatePlayer(PlayerInfo player)
{
bool result = false;
try
{
if (player.Grade < 1)
return result;
SqlParameter[] para = new SqlParameter[53]; //trminhpc
para[0] = new SqlParameter("@UserID", player.ID);
para[1] = new SqlParameter("@Attack", player.Attack);
para[2] = new SqlParameter("@Colors", player.Colors == null ? "" : player.Colors);
para[3] = new SqlParameter("@ConsortiaID", player.ConsortiaID);
para[4] = new SqlParameter("@Defence", player.Defence);
para[5] = new SqlParameter("@Gold", player.Gold);
para[6] = new SqlParameter("@GP", player.GP);
para[7] = new SqlParameter("@Grade", player.Grade);
para[8] = new SqlParameter("@Luck", player.Luck);
para[9] = new SqlParameter("@Money", player.Money);
para[10] = new SqlParameter("@Style", player.Style == null ? "" : player.Style);
para[11] = new SqlParameter("@Agility", player.Agility);
para[12] = new SqlParameter("@State", player.State);
para[13] = new SqlParameter("@Hide", player.Hide);
para[14] = new SqlParameter("@ExpendDate", player.ExpendDate == null ? "" : player.ExpendDate.ToString());
para[15] = new SqlParameter("@Win", player.Win);
para[16] = new SqlParameter("@Total", player.Total);
para[17] = new SqlParameter("@Escape", player.Escape);
para[18] = new SqlParameter("@Skin", player.Skin == null ? "" : player.Skin);
para[19] = new SqlParameter("@Offer", player.Offer);
para[20] = new SqlParameter("@AntiAddiction", player.AntiAddiction);
para[20].Direction = ParameterDirection.InputOutput;
para[21] = new SqlParameter("@Result", System.Data.SqlDbType.Int);
para[21].Direction = ParameterDirection.ReturnValue;
para[22] = new SqlParameter("@RichesOffer", player.RichesOffer);
para[23] = new SqlParameter("@RichesRob", player.RichesRob);
para[24] = new SqlParameter("@CheckCount", player.CheckCount);
para[24].Direction = ParameterDirection.InputOutput;
para[25] = new SqlParameter("@MarryInfoID", player.MarryInfoID);
para[26] = new SqlParameter("@DayLoginCount", player.DayLoginCount);
para[27] = new SqlParameter("@Nimbus", player.Nimbus);
para[28] = new SqlParameter("@LastAward", player.LastAward);
para[29] = new SqlParameter("@GiftToken", player.GiftToken);
para[30] = new SqlParameter("@QuestSite", player.QuestSite);
para[31] = new SqlParameter("@PvePermission", player.PvePermission);
para[32] = new SqlParameter("@FightPower", player.FightPower);
para[33] = new SqlParameter("@AnswerSite", player.AnswerSite);
para[34] = new SqlParameter("@LastAuncherAward", player.LastAward);
para[35] = new SqlParameter("@Medal", player.medal);
para[36] = new SqlParameter("@ChatCount", player.ChatCount);
para[37] = new SqlParameter("@SpaPubGoldRoomLimit", player.SpaPubGoldRoomLimit);
para[38] = new SqlParameter("@LastSpaDate", player.LastSpaDate);
para[39] = new SqlParameter("@FightLabPermission", player.FightLabPermission);
para[40] = new SqlParameter("@SpaPubMoneyRoomLimit", player.SpaPubMoneyRoomLimit);
para[41] = new SqlParameter("@IsInSpaPubGoldToday", player.IsInSpaPubGoldToday);
para[42] = new SqlParameter("@IsInSpaPubMoneyToday", player.IsInSpaPubMoneyToday);
para[43] = new SqlParameter("@AchievementPoint", player.AchievementPoint);
para[44] = new SqlParameter("@LastWeekly", player.LastWeekly);
para[45] = new SqlParameter("@LastWeeklyVersion", player.LastWeeklyVersion);
para[46] = new SqlParameter("@GiftGp", player.GiftGp);
para[47] = new SqlParameter("@GiftLevel", player.GiftLevel);
para[48] = new SqlParameter("@IsOpenGift", player.IsOpenGift);
para[49] = new SqlParameter("@WeaklessGuildProgressStr", player.WeaklessGuildProgressStr);
para[50] = new SqlParameter("@IsOldPlayer", player.IsOldPlayer);
para[51] = new SqlParameter("@VIPLevel", player.VIPLevel);
para[52] = new SqlParameter("@VIPExp", player.VIPExp);
db.RunProcedure("SP_Users_Update", para);
result = (int)para[21].Value == 0;
if (result)
{
player.AntiAddiction = (int)para[20].Value;
player.CheckCount = (int)para[24].Value;
}
player.IsDirty = false;
}
catch (Exception e)
{
if (log.IsErrorEnabled)
log.Error("Init", e);
}
return result;
}
public GSPacketIn SendUpdatePublicPlayer(PlayerInfo info)
{
GSPacketIn pkg = new GSPacketIn((byte)ePackageType.UPDATE_PLAYER_INFO, info.ID);
pkg.WriteInt(info.GP);
pkg.WriteInt(info.Offer);
pkg.WriteInt(info.RichesOffer);
pkg.WriteInt(info.RichesRob);
pkg.WriteInt(info.Win);
pkg.WriteInt(info.Total);
pkg.WriteInt(info.Escape);
pkg.WriteInt(info.Attack);
pkg.WriteInt(info.Defence);
pkg.WriteInt(info.Agility);
pkg.WriteInt(info.Luck);
pkg.WriteInt(info.hp);//info.hp = pkg.readInt();
pkg.WriteInt(info.Hide);
pkg.WriteString(info.Style);
pkg.WriteString(info.Colors);
pkg.WriteString(info.Skin);
pkg.WriteBoolean(false);//info.IsShowConsortia = pkg.readBoolean();
pkg.WriteInt(info.ConsortiaID);
pkg.WriteString(info.ConsortiaName);
pkg.WriteInt(0);//info.badgeID = pkg.readInt();
pkg.WriteInt(info.ConsortiaLevel);//unknown1 = pkg.readInt();
pkg.WriteInt(info.ConsortiaRepute);//unknown2 = pkg.readInt();
pkg.WriteInt(info.Nimbus);
pkg.WriteString(info.PvePermission);
pkg.WriteString(info.FightLabPermission);
pkg.WriteInt(info.FightPower);
pkg.WriteInt(5);//apprenticeshipState = pkg.readInt();
pkg.WriteInt(-1);//masterID = pkg.readInt();
pkg.WriteString("Master");//setMasterOrApprentices(pkg.readUTF());
pkg.WriteInt(0);//graduatesCount = pkg.readInt();
pkg.WriteString("HoNorMaster");//honourOfMaster = pkg.readUTF();
pkg.WriteInt(info.AchievementPoint);
pkg.WriteString("Danh hiệu Gunny"); //honor = pkg.readUTF();
pkg.WriteDateTime((DateTime)info.LastSpaDate);
pkg.WriteInt(100);//charmgp
pkg.WriteInt(100); //unknown3 = pkg.readInt();
pkg.WriteDateTime(DateTime.MinValue); //info.shopFinallyGottenTime
pkg.WriteInt(info.Offer);//info.UseOffer = pkg.readInt();
pkg.WriteInt(info.Offer);//info.matchInfo.dailyScore = pkg.readInt();
pkg.WriteInt(info.Offer);//info.matchInfo.dailyWinCount = pkg.readInt();
pkg.WriteInt(info.Offer);//info.matchInfo.dailyGameCount = pkg.readInt();
pkg.WriteInt(info.Offer);//info.matchInfo.weeklyScore = pkg.readInt();
pkg.WriteInt(info.Offer);//info.matchInfo.weeklyGameCount = pkg.readInt();
pkg.WriteInt(info.Offer);//info.spdTexpExp = pkg.readInt();
pkg.WriteInt(info.Offer);//info.attTexpExp = pkg.readInt();
pkg.WriteInt(info.Offer);//info.defTexpExp = pkg.readInt();
pkg.WriteInt(info.Offer);//info.hpTexpExp = pkg.readInt();
pkg.WriteInt(info.Offer);//info.lukTexpExp = pkg.readInt();
pkg.WriteInt(info.Offer);//info.texpTaskCount = pkg.readInt();
pkg.WriteInt(info.Offer);//info.texpCount = pkg.readInt();
pkg.WriteDateTime(DateTime.Now.AddDays(-5));//info.texpTaskDate = pkg.readDate();
pkg.WriteInt(1);//len = pkg.readInt();
for (int i = 0; i < 1; i++)
{
pkg.WriteInt(1);//mapId = pkg.readInt();
pkg.WriteByte(1);//flag = pkg.readByte();
}
SendTCP(pkg);
return pkg;
}
public void SendUpdatePrivateInfo(PlayerInfo info)
{
GSPacketIn pkg = new GSPacketIn((byte)ePackageType.UPDATE_PRIVATE_INFO, info.ID);
pkg.WriteInt(info.Money);
pkg.WriteInt(info.GiftToken); //this._self.DDTMoney = event.pkg.readInt();
pkg.WriteInt(1);//this._self.Score = event.pkg.readInt();
pkg.WriteInt(info.Gold);
pkg.WriteInt(1);//_self.badLuckNumber = event.pkg.readInt();
pkg.WriteInt(1);//_self.damageScores = event.pkg.readInt();
SendTCP(pkg);
}
public GSPacketIn SendUpdatePetInfo(PlayerInfo player, List<ItemInfo> items)
{
GSPacketIn pkg = new GSPacketIn((byte)ePackageType.PET, player.ID);
pkg.WriteByte((byte)Game.Logic.eTankCmdType.UPDATE_PET);
pkg.WriteInt(player.ID);
pkg.WriteInt(1);
//foreach (ItemInfo info in items)
//{
pkg.WriteInt(0);//_loc_11.Place = _loc_7;
//if (items.Count > 0)
//{
pkg.WriteBoolean(true);
pkg.WriteInt(1);//_loc_11.ID = _loc_2.readInt();
//pkg.WriteInt(100703);//_loc_11.TemplateID = _loc_2.readInt();
//pkg.WriteString("Gà Du Kích");//_loc_11.Name = _loc_2.readUTF();
pkg.WriteInt(140403);//_loc_11.TemplateID = _loc_2.readInt();
pkg.WriteString("远古魔龙");//_loc_11.Name = _loc_2.readUTF();
pkg.WriteInt(player.ID);//_loc_11.UserID = _loc_2.readInt();
pkg.WriteInt(5000);//_loc_11.Attack = _loc_2.readInt();
pkg.WriteInt(3000);//_loc_11.Defence = _loc_2.readInt();
pkg.WriteInt(4000);//_loc_11.Luck = _loc_2.readInt();
pkg.WriteInt(6000);//_loc_11.Agility = _loc_2.readInt();
pkg.WriteInt(4000);//_loc_11.Blood = _loc_2.readInt();
pkg.WriteInt(6000);//_loc_11.Damage = _loc_2.readInt();
pkg.WriteInt(1500);//_loc_11.Guard = _loc_2.readInt();
pkg.WriteInt(2700);//_loc_11.AttackGrow = _loc_2.readInt();
pkg.WriteInt(500);//_loc_11.DefenceGrow = _loc_2.readInt();
pkg.WriteInt(800);//_loc_11.LuckGrow = _loc_2.readInt();
pkg.WriteInt(600);//_loc_11.AgilityGrow = _loc_2.readInt();
pkg.WriteInt(700);//_loc_11.BloodGrow = _loc_2.readInt();
pkg.WriteInt(500);//_loc_11.DamageGrow = _loc_2.readInt();
pkg.WriteInt(400);//_loc_11.GuardGrow = _loc_2.readInt();
pkg.WriteInt(60);//_loc_11.Level = _loc_2.readInt();
pkg.WriteInt(0);//_loc_11.GP = _loc_2.readInt();
pkg.WriteInt(10);//_loc_11.MaxGP = _loc_2.readInt();
pkg.WriteInt(10000);//_loc_11.Hunger = _loc_2.readInt();
pkg.WriteInt(3);//_loc_11.PetHappyStar = _loc_2.readInt();
pkg.WriteInt(100);//_loc_11.MP = _loc_2.readInt();
pkg.WriteInt(3);// _loc_2.readInt();==>Ky nang thu cung
for (int i = 0; i < 3; i++)
{
pkg.WriteInt(110 + i);//_loc_2.readInt();
pkg.WriteInt(i);//_loc_17 = _loc_2.readInt();
}
pkg.WriteInt(3);// _loc_2.readInt();==>ky nang chien dau
for (int ii = 0; ii < 3; ii++)
{
pkg.WriteInt(ii);//_loc_19 = _loc_2.readInt();
pkg.WriteInt(110 + ii);//_loc_20 = _loc_2.readInt();
}
pkg.WriteBoolean(true);//_loc_11.IsEquip = _loc_2.readBoolean();
//}
//else { pkg.WriteBoolean(false); }
//}
//pkg.Compress();
SendTCP(pkg);
return pkg;
}
public PlayerInfo[] GetPlayerPage(int page, int size, ref int total, int order, int userID, ref bool resultValue)
{
List<PlayerInfo> infos = new List<PlayerInfo>();
try
{
string sWhere = " IsExist=1 and IsFirst<> 0 ";
if (userID != -1)
{
sWhere += " and UserID =" + userID + " ";
}
string sOrder = "GP desc";
//string sOrder = "LastDayGP desc";
switch (order)
{
case 1:
sOrder = "Offer desc";
//sOrder = "LastDayOffer desc";
break;
case 2:
sOrder = "AddDayGP desc";
break;
case 3:
sOrder = "AddWeekGP desc";
break;
case 4:
sOrder = "AddDayOffer desc";
break;
case 5:
sOrder = "AddWeekOffer desc";
break;
case 6:
sOrder = "FightPower desc";
break;
}
sOrder += ",UserID";
DataTable dt = GetPage("V_Sys_Users_Detail", sWhere, page, size, "*", sOrder, "UserID", ref total);
foreach (DataRow dr in dt.Rows)
{
PlayerInfo info = new PlayerInfo();
info.Agility = (int)dr["Agility"];
info.Attack = (int)dr["Attack"];
info.Colors = dr["Colors"] == null ? "" : dr["Colors"].ToString();
info.ConsortiaID = (int)dr["ConsortiaID"];
info.Defence = (int)dr["Defence"];
info.Gold = (int)dr["Gold"];
info.GP = (int)dr["GP"];
info.Grade = (int)dr["Grade"];
info.ID = (int)dr["UserID"];
info.Luck = (int)dr["Luck"];
info.Money = (int)dr["Money"];
info.NickName = dr["NickName"] == null ? "" : dr["NickName"].ToString();
info.Sex = (bool)dr["Sex"];
info.State = (int)dr["State"];
info.Style = dr["Style"] == null ? "" : dr["Style"].ToString();
info.Hide = (int)dr["Hide"];
info.Repute = (int)dr["Repute"];
info.UserName = dr["UserName"] == null ? "" : dr["UserName"].ToString();
info.ConsortiaName = dr["ConsortiaName"] == null ? "" : dr["ConsortiaName"].ToString();
info.Offer = (int)dr["Offer"];
info.Skin = dr["Skin"] == null ? "" : dr["Skin"].ToString();
info.IsBanChat = (bool)dr["IsBanChat"];
info.ReputeOffer = (int)dr["ReputeOffer"];
info.ConsortiaRepute = (int)dr["ConsortiaRepute"];
info.ConsortiaLevel = (int)dr["ConsortiaLevel"];
info.StoreLevel = (int)dr["StoreLevel"];
info.ShopLevel = (int)dr["ShopLevel"];
info.SmithLevel = (int)dr["SmithLevel"];
info.ConsortiaHonor = (int)dr["ConsortiaHonor"];
info.RichesOffer = (int)dr["RichesOffer"];
info.RichesRob = (int)dr["RichesRob"];
info.DutyLevel = (int)dr["DutyLevel"];
info.DutyName = dr["DutyName"] == null ? "" : dr["DutyName"].ToString();
info.Right = (int)dr["Right"];
info.ChairmanName = dr["ChairmanName"] == null ? "" : dr["ChairmanName"].ToString();
info.Win = (int)dr["Win"];
info.Total = (int)dr["Total"];
info.Escape = (int)dr["Escape"];
info.AddDayGP = (int)dr["AddDayGP"];
info.AddDayOffer = (int)dr["AddDayOffer"];
info.AddWeekGP = (int)dr["AddWeekGP"];
info.AddWeekOffer = (int)dr["AddWeekOffer"];
info.ConsortiaRiches = (int)dr["ConsortiaRiches"];
info.CheckCount = (int)dr["CheckCount"];
info.Nimbus = (int)dr["Nimbus"];
info.GiftToken = (int)dr["GiftToken"];
info.QuestSite = dr["QuestSite"] == null ? new byte[200] : (byte[])dr["QuestSite"];
info.PvePermission = dr["PvePermission"] == null ? "" : dr["PvePermission"].ToString();
info.FightPower = (int)dr["FightPower"];
infos.Add(info);
}
resultValue = true;
}
catch (Exception e)
{
if (log.IsErrorEnabled)
log.Error("Init", e);
}
finally
{
}
return infos.ToArray();
}
public PlayerInfo InitPlayerInfo(SqlDataReader reader)
{
PlayerInfo player = new PlayerInfo();
player.Password = (string)reader["Password"];
player.IsConsortia = (bool)reader["IsConsortia"];
player.Agility = (int)reader["Agility"];
player.Attack = (int)reader["Attack"];
player.Colors = reader["Colors"] == null ? "" : reader["Colors"].ToString();
player.ConsortiaID = (int)reader["ConsortiaID"];
player.Defence = (int)reader["Defence"];
player.Gold = (int)reader["Gold"];
player.GP = (int)reader["GP"];
player.Grade = (int)reader["Grade"];
player.ID = (int)reader["UserID"];
player.Luck = (int)reader["Luck"];
player.Money = (int)reader["Money"];
player.NickName = reader["NickName"] == null ? "" : reader["NickName"].ToString();
player.Sex = (bool)reader["Sex"];
player.State = (int)reader["State"];
player.Style = reader["Style"] == null ? "" : reader["Style"].ToString();
player.Hide = (int)reader["Hide"];
player.Repute = (int)reader["Repute"];
player.UserName = reader["UserName"] == null ? "" : reader["UserName"].ToString();
player.ConsortiaName = reader["ConsortiaName"] == null ? "" : reader["ConsortiaName"].ToString();
player.Offer = (int)reader["Offer"];
player.Win = (int)reader["Win"];
player.Total = (int)reader["Total"];
player.Escape = (int)reader["Escape"];
player.Skin = reader["Skin"] == null ? "" : reader["Skin"].ToString();
player.IsBanChat = (bool)reader["IsBanChat"];
player.ReputeOffer = (int)reader["ReputeOffer"];
player.ConsortiaRepute = (int)reader["ConsortiaRepute"];
player.ConsortiaLevel = (int)reader["ConsortiaLevel"];
player.StoreLevel = (int)reader["StoreLevel"];
player.ShopLevel = (int)reader["ShopLevel"];
player.SmithLevel = (int)reader["SmithLevel"];
player.ConsortiaHonor = (int)reader["ConsortiaHonor"];
player.RichesOffer = (int)reader["RichesOffer"];
player.RichesRob = (int)reader["RichesRob"];
player.AntiAddiction = (int)reader["AntiAddiction"];
player.DutyLevel = (int)reader["DutyLevel"];
player.DutyName = reader["DutyName"] == null ? "" : reader["DutyName"].ToString();
player.Right = (int)reader["Right"];
player.ChairmanName = reader["ChairmanName"] == null ? "" : reader["ChairmanName"].ToString();
player.AddDayGP = (int)reader["AddDayGP"];
player.AddDayOffer = (int)reader["AddDayOffer"];
player.AddWeekGP = (int)reader["AddWeekGP"];
player.AddWeekOffer = (int)reader["AddWeekOffer"];
player.ConsortiaRiches = (int)reader["ConsortiaRiches"];
player.CheckCount = (int)reader["CheckCount"];
player.IsMarried = (bool)reader["IsMarried"];
player.SpouseID = (int)reader["SpouseID"];
player.SpouseName = reader["SpouseName"] == null ? "" : reader["SpouseName"].ToString();
player.MarryInfoID = (int)reader["MarryInfoID"];
player.IsCreatedMarryRoom = (bool)reader["IsCreatedMarryRoom"];
player.DayLoginCount = (int)reader["DayLoginCount"];
player.PasswordTwo = reader["PasswordTwo"] == null ? "" : reader["PasswordTwo"].ToString();
player.SelfMarryRoomID = (int)reader["SelfMarryRoomID"];
player.IsGotRing = (bool)reader["IsGotRing"];
player.Rename = (bool)reader["Rename"];
player.ConsortiaRename = (bool)reader["ConsortiaRename"];
player.IsDirty = false;
player.IsFirst = (int)reader["IsFirst"];
player.Nimbus = (int)reader["Nimbus"];
player.LastAward = (DateTime)reader["LastAward"];
player.GiftToken = (int)reader["GiftToken"];
player.QuestSite = reader["QuestSite"] == null ? new byte[200] : (byte[])reader["QuestSite"];
player.PvePermission = reader["PvePermission"] == null ? "" : reader["PvePermission"].ToString();
player.FightPower = (int)reader["FightPower"];
player.PasswordQuest1 = reader["PasswordQuestion1"] == null ? "" : reader["PasswordQuestion1"].ToString();
player.PasswordQuest2 = reader["PasswordQuestion2"] == null ? "" : reader["PasswordQuestion2"].ToString();
player.FailedPasswordAttemptCount = (DateTime)reader["LastFindDate"] == null ? 5 : (int)reader["FailedPasswordAttemptCount"];
player.AnswerSite = (int)reader["AnswerSite"];
return player;
}
public bool UpdatePlayerMarry(PlayerInfo player)
{
bool result = false;
try
{
SqlParameter[] para = new SqlParameter[7];
para[0] = new SqlParameter("@UserID", player.ID);
para[1] = new SqlParameter("@IsMarried", player.IsMarried);
para[2] = new SqlParameter("@SpouseID", player.SpouseID);
para[3] = new SqlParameter("@SpouseName", player.SpouseName);
para[4] = new SqlParameter("@IsCreatedMarryRoom", player.IsCreatedMarryRoom);
para[5] = new SqlParameter("@SelfMarryRoomID", player.SelfMarryRoomID);
para[6] = new SqlParameter("@IsGotRing", player.IsGotRing);
result = db.RunProcedure("SP_Users_Marry", para);
}
catch (Exception e)
{
if (log.IsErrorEnabled)
log.Error("UpdatePlayerMarry", e);
}
return result;
}
public GSPacketIn SendUserEquip(SqlDataProvider.Data.PlayerInfo info, List <SqlDataProvider.Data.ItemInfo> items)
{
throw new NotImplementedException();
}
public GSPacketIn SendUpdatePetInfo(SqlDataProvider.Data.PlayerInfo player, List <SqlDataProvider.Data.ItemInfo> items)
{
throw new NotImplementedException();
}
public GSPacketIn SendUserEquip(PlayerInfo player, List<ItemInfo> items)
{
GSPacketIn pkg = new GSPacketIn((byte)ePackageType.ITEM_EQUIP, player.ID, 10240);
pkg.WriteInt(player.ID);
pkg.WriteString(player.NickName);
pkg.WriteInt(player.Agility);
pkg.WriteInt(player.Attack);
pkg.WriteString(player.Colors);
pkg.WriteString(player.Skin);
pkg.WriteInt(player.Defence);
pkg.WriteInt(player.GP);
pkg.WriteInt(player.Grade);
pkg.WriteInt(player.Luck);
pkg.WriteInt(player.hp);//_loc_5.hp = _loc_2.readInt();
pkg.WriteInt(player.Hide);
pkg.WriteInt(player.Repute);
pkg.WriteBoolean(player.Sex);
pkg.WriteString(player.Style);
pkg.WriteInt(player.Offer);
pkg.WriteByte(player.typeVIP);
pkg.WriteInt(player.VIPLevel);
pkg.WriteInt(player.Win);
pkg.WriteInt(player.Total);
pkg.WriteInt(player.Escape);
pkg.WriteInt(player.ConsortiaID);
pkg.WriteString(player.ConsortiaName);
pkg.WriteInt(0);//_loc_5.badgeID = _loc_2.readInt();
pkg.WriteInt(player.RichesOffer);
pkg.WriteInt(player.RichesRob);
pkg.WriteBoolean(player.IsMarried);
pkg.WriteInt(player.SpouseID);
pkg.WriteString(player.SpouseName);
pkg.WriteString(player.DutyName);
pkg.WriteInt(player.Nimbus);
pkg.WriteInt(player.FightPower);
pkg.WriteInt(5);//apprenticeshipState = _loc_2.readInt();
pkg.WriteInt(-1);//masterID = _loc_2.readInt();
pkg.WriteString("Master");//setMasterOrApprentices(_loc_2.readUTF());
pkg.WriteInt(0);//graduatesCount = _loc_2.readInt();
pkg.WriteString("HoNorMaster");//honourOfMaster = _loc_2.readUTF();
pkg.WriteInt(player.AchievementPoint);//
pkg.WriteString("Tân Binh");//honor = _loc_2.readUTF();
pkg.WriteDateTime(DateTime.Now.AddDays(-2));
pkg.WriteInt(player.Offer); //_loc_5.spdTexpExp = _loc_2.readInt();
pkg.WriteInt(player.Offer); //_loc_5.attTexpExp = _loc_2.readInt();
pkg.WriteInt(player.Offer); //_loc_5.defTexpExp = _loc_2.readInt();
pkg.WriteInt(player.Offer); //_loc_5.hpTexpExp = _loc_2.readInt();
pkg.WriteInt(player.Offer); //_loc_5.lukTexpExp = _loc_2.readInt();
pkg.WriteBoolean(false); //_loc_5.DailyLeagueFirst = _loc_2.readBoolean();
pkg.WriteInt(player.Offer); //_loc_5.DailyLeagueLastScore = _loc_2.readInt();
pkg.WriteInt(items.Count);
foreach (ItemInfo info in items)
{
pkg.WriteByte((byte)info.BagType);
pkg.WriteInt(info.UserID);
pkg.WriteInt(info.ItemID);
pkg.WriteInt(info.Count);
pkg.WriteInt(info.Place);
pkg.WriteInt(info.TemplateID);
pkg.WriteInt(info.AttackCompose);
pkg.WriteInt(info.DefendCompose);
pkg.WriteInt(info.AgilityCompose);
pkg.WriteInt(info.LuckCompose);
pkg.WriteInt(info.StrengthenLevel);
pkg.WriteBoolean(info.IsBinds);
pkg.WriteBoolean(info.IsJudge);
pkg.WriteDateTime(info.BeginDate);
pkg.WriteInt(info.ValidDate);
pkg.WriteString(info.Color);
pkg.WriteString(info.Skin);
pkg.WriteBoolean(info.IsUsed);
pkg.WriteInt(info.Hole1);
pkg.WriteInt(info.Hole2);
pkg.WriteInt(info.Hole3);
pkg.WriteInt(info.Hole4);
pkg.WriteInt(info.Hole5);
pkg.WriteInt(info.Hole6);
pkg.WriteString(info.Template.Pic);
pkg.WriteInt(info.Template.RefineryLevel);
pkg.WriteDateTime(DateTime.Now);
pkg.WriteByte((byte)info.Hole5Level);
pkg.WriteInt(info.Hole5Exp);
pkg.WriteByte((byte)info.Hole6Level);
pkg.WriteInt(info.Hole6Exp);
if (info.IsGold)
{
pkg.WriteBoolean(info.IsGold);//_loc_8.isGold = _loc_2.readBoolean();
pkg.WriteInt(365);//_loc_8.goldValidDate = _loc_2.readInt();
pkg.WriteDateTime(DateTime.Now);//_loc_8.goldBeginTime = _loc_2.readDateString();
}
else { pkg.WriteBoolean(false); }
}
pkg.Compress();
SendTCP(pkg);
return pkg;
}
public bool UpdateLastVIPPackTime(PlayerInfo info)
{
bool flag = false;
try
{
SqlParameter[] sqlParameters = new SqlParameter[] {
new SqlParameter("@UserID", info.ID),
new SqlParameter("@LastVIPPackTime", DateTime.Now.Date),
new SqlParameter("@Result", SqlDbType.Int) };
sqlParameters[2].Direction = ParameterDirection.ReturnValue;
db.RunProcedure("SP_UpdateUserLastVIPPackTime", sqlParameters);
flag = true;
}
catch (Exception exception)
{
if (BaseBussiness.log.IsErrorEnabled)
{
BaseBussiness.log.Error("SP_UpdateUserLastVIPPackTime", exception);
}
}
return flag;
}
public GSPacketIn SendPlayerCardInfo(PlayerInfo player, List<ItemInfo> items)
{
GSPacketIn pkg = new GSPacketIn((byte)ePackageType.CARDS_DATA, player.ID);
pkg.WriteInt(player.ID);
pkg.WriteInt(items.Count);
foreach (ItemInfo info in items)
{
pkg.WriteInt(info.Place);
if (items.Count > 0)
{
pkg.WriteBoolean(true);
pkg.WriteInt(info.ItemID);
pkg.WriteInt(player.ID);
pkg.WriteInt(info.Count);
pkg.WriteInt(info.Place);
pkg.WriteInt(info.Template.TemplateID);
pkg.WriteInt(info.Attack);
pkg.WriteInt(info.Defence);
pkg.WriteInt(info.Agility);
pkg.WriteInt(info.Luck);
pkg.WriteInt(info.AttackCompose);
pkg.WriteInt(info.DefendCompose);
pkg.WriteInt(info.StrengthenLevel);
pkg.WriteInt(info.Hole5Exp);
pkg.WriteBoolean(info.IsGold);
}
else { pkg.WriteBoolean(false); }
}
//pkg.Compress();
SendTCP(pkg);
return pkg;
}
public PlayerInfo InitPlayerInfo(SqlDataReader reader)
{
PlayerInfo playerInfo1 = new PlayerInfo();
playerInfo1.Password = (string)reader["Password"];
playerInfo1.IsConsortia = (bool)reader["IsConsortia"];
playerInfo1.Agility = (int)reader["Agility"];
playerInfo1.Attack = (int)reader["Attack"];
playerInfo1.hp = (int)reader["hp"];
playerInfo1.Colors = reader["Colors"] == null ? "" : reader["Colors"].ToString();
playerInfo1.ConsortiaID = (int)reader["ConsortiaID"];
playerInfo1.Defence = (int)reader["Defence"];
playerInfo1.Gold = (int)reader["Gold"];
playerInfo1.GP = (int)reader["GP"];
playerInfo1.Grade = (int)reader["Grade"];
playerInfo1.ID = (int)reader["UserID"];
playerInfo1.Luck = (int)reader["Luck"];
playerInfo1.Money = (int)reader["Money"];
playerInfo1.NickName = (string)reader["NickName"] == null ? "" : (string)reader["NickName"];
playerInfo1.Sex = (bool)reader["Sex"];
playerInfo1.State = (int)reader["State"];
playerInfo1.Style = reader["Style"] == null ? "" : reader["Style"].ToString();
playerInfo1.Hide = (int)reader["Hide"];
playerInfo1.Repute = (int)reader["Repute"];
playerInfo1.UserName = reader["UserName"] == null ? "" : reader["UserName"].ToString();
playerInfo1.ConsortiaName = reader["ConsortiaName"] == null ? "" : reader["ConsortiaName"].ToString();
playerInfo1.Offer = (int)reader["Offer"];
playerInfo1.Win = (int)reader["Win"];
playerInfo1.Total = (int)reader["Total"];
playerInfo1.Escape = (int)reader["Escape"];
playerInfo1.Skin = reader["Skin"] == null ? "" : reader["Skin"].ToString();
playerInfo1.IsBanChat = (bool)reader["IsBanChat"];
playerInfo1.ReputeOffer = (int)reader["ReputeOffer"];
playerInfo1.ConsortiaRepute = (int)reader["ConsortiaRepute"];
playerInfo1.ConsortiaLevel = (int)reader["ConsortiaLevel"];
playerInfo1.StoreLevel = (int)reader["StoreLevel"];
playerInfo1.ShopLevel = (int)reader["ShopLevel"];
playerInfo1.SmithLevel = (int)reader["SmithLevel"];
playerInfo1.ConsortiaHonor = (int)reader["ConsortiaHonor"];
playerInfo1.RichesOffer = (int)reader["RichesOffer"];
playerInfo1.RichesRob = (int)reader["RichesRob"];
playerInfo1.AntiAddiction = (int)reader["AntiAddiction"];
playerInfo1.DutyLevel = (int)reader["DutyLevel"];
playerInfo1.DutyName = reader["DutyName"] == null ? "" : reader["DutyName"].ToString();
playerInfo1.Right = (int)reader["Right"];
playerInfo1.ChairmanName = reader["ChairmanName"] == null ? "" : reader["ChairmanName"].ToString();
playerInfo1.AddDayGP = (int)reader["AddDayGP"];
playerInfo1.AddDayOffer = (int)reader["AddDayOffer"];
playerInfo1.AddWeekGP = (int)reader["AddWeekGP"];
playerInfo1.AddWeekOffer = (int)reader["AddWeekOffer"];
playerInfo1.ConsortiaRiches = (int)reader["ConsortiaRiches"];
playerInfo1.CheckCount = (int)reader["CheckCount"];
playerInfo1.IsMarried = (bool)reader["IsMarried"];
playerInfo1.SpouseID = (int)reader["SpouseID"];
playerInfo1.SpouseName = reader["SpouseName"] == null ? "" : reader["SpouseName"].ToString();
playerInfo1.MarryInfoID = (int)reader["MarryInfoID"];
playerInfo1.IsCreatedMarryRoom = (bool)reader["IsCreatedMarryRoom"];
playerInfo1.DayLoginCount = (int)reader["DayLoginCount"];
playerInfo1.PasswordTwo = reader["PasswordTwo"] == null ? "" : reader["PasswordTwo"].ToString();
playerInfo1.SelfMarryRoomID = (int)reader["SelfMarryRoomID"];
playerInfo1.IsGotRing = (bool)reader["IsGotRing"];
playerInfo1.Rename = (bool)reader["Rename"];
playerInfo1.ConsortiaRename = (bool)reader["ConsortiaRename"];
playerInfo1.IsDirty = false;
playerInfo1.IsFirst = (int)reader["IsFirst"];
playerInfo1.Nimbus = (int)reader["Nimbus"];
playerInfo1.LastAward = (DateTime)reader["LastAward"];
playerInfo1.GiftToken = (int)reader["GiftToken"];
playerInfo1.QuestSite = reader["QuestSite"] == null ? new byte[200] : (byte[])reader["QuestSite"];
playerInfo1.PvePermission = reader["PvePermission"] == null ? "" : reader["PvePermission"].ToString();
playerInfo1.FightPower = (int)reader["FightPower"];
playerInfo1.PasswordQuest1 = reader["PasswordQuestion1"] == null ? "" : reader["PasswordQuestion1"].ToString();
playerInfo1.PasswordQuest2 = reader["PasswordQuestion2"] == null ? "" : reader["PasswordQuestion2"].ToString();
PlayerInfo playerInfo2 = playerInfo1;
DateTime dateTime = (DateTime)reader["LastFindDate"];
playerInfo2.FailedPasswordAttemptCount = (int)reader["FailedPasswordAttemptCount"];
playerInfo1.AnswerSite = (int)reader["AnswerSite"];
playerInfo1.medal = (int)reader["Medal"];
playerInfo1.ChatCount = (int)reader["ChatCount"];
playerInfo1.SpaPubGoldRoomLimit = (int)reader["SpaPubGoldRoomLimit"];
playerInfo1.LastSpaDate = (DateTime)reader["LastSpaDate"];
playerInfo1.FightLabPermission = (string)reader["FightLabPermission"];
playerInfo1.SpaPubMoneyRoomLimit = (int)reader["SpaPubMoneyRoomLimit"];
playerInfo1.IsInSpaPubGoldToday = (bool)reader["IsInSpaPubGoldToday"];
playerInfo1.IsInSpaPubMoneyToday = (bool)reader["IsInSpaPubMoneyToday"];
playerInfo1.AchievementPoint = (int)reader["AchievementPoint"];
playerInfo1.LastWeekly = (DateTime)reader["LastWeekly"];
playerInfo1.LastWeeklyVersion = (int)reader["LastWeeklyVersion"];
playerInfo1.GiftGp = (int)reader["GiftGp"];
playerInfo1.GiftLevel = (int)reader["GiftLevel"];
playerInfo1.IsOpenGift = (bool)reader["IsOpenGift"];
playerInfo1.badgeID = (int)reader["badgeID"];
playerInfo1.typeVIP = Convert.ToByte(reader["typeVIP"]);
playerInfo1.VIPLevel = (int)reader["VIPLevel"];
playerInfo1.VIPExp = (int)reader["VIPExp"];
playerInfo1.VIPExpireDay = (DateTime)reader["VIPExpireDay"];
playerInfo1.LastVIPPackTime = (DateTime)reader["LastVIPPackTime"];
playerInfo1.CanTakeVipReward = (bool)reader["CanTakeVipReward"];
playerInfo1.WeaklessGuildProgressStr = (string)reader["WeaklessGuildProgressStr"];
playerInfo1.IsOldPlayer = (bool)reader["IsOldPlayer"];
playerInfo1.LastDate = (DateTime)reader["LastDate"];
playerInfo1.VIPLastDate = (DateTime)reader["VIPLastDate"];
playerInfo1.Score = (int)reader["Score"];
playerInfo1.OptionOnOff = (int)reader["OptionOnOff"];
playerInfo1.isOldPlayerHasValidEquitAtLogin = (bool)reader["isOldPlayerHasValidEquitAtLogin"];
playerInfo1.badLuckNumber = (int)reader["badLuckNumber"];
playerInfo1.luckyNum = (int)reader["luckyNum"];
playerInfo1.lastLuckyNumDate = (DateTime)reader["lastLuckyNumDate"];
playerInfo1.lastLuckNum = (int)reader["lastLuckNum"];
playerInfo1.CardSoul = (int)reader["CardSoul"];
playerInfo1.uesedFinishTime = (int)reader["uesedFinishTime"];
playerInfo1.totemId = (int)reader["totemId"];
playerInfo1.damageScores = (int)reader["damageScores"];
playerInfo1.petScore = (int)reader["petScore"];
playerInfo1.IsShowConsortia = (bool)reader["IsShowConsortia"];
playerInfo1.LastRefreshPet = (DateTime)reader["LastRefreshPet"];
playerInfo1.GetSoulCount = (int)reader["GetSoulCount"];
playerInfo1.isFirstDivorce = (int)reader["isFirstDivorce"];
playerInfo1.myScore = (int)reader["myScore"];
playerInfo1.LastGetEgg = (DateTime)reader["LastGetEgg"];
playerInfo1.TimeBox = (DateTime)reader["TimeBox"];
playerInfo1.IsFistGetPet = (bool)reader["IsFistGetPet"];
playerInfo1.myHonor = (int)reader["myHonor"];
playerInfo1.hardCurrency = (int)reader["hardCurrency"];
playerInfo1.MaxBuyHonor = (int)reader["MaxBuyHonor"];
playerInfo1.LeagueMoney = (int)reader["LeagueMoney"];
playerInfo1.Honor = (string)reader["Honor"];
playerInfo1.necklaceExp = (int)reader["necklaceExp"];
playerInfo1.necklaceExpAdd = (int)reader["necklaceExpAdd"];
return playerInfo1;
}
public bool LoadFromDatabase()
{
using (PlayerBussiness db = new PlayerBussiness())
{
PlayerInfo detail = db.GetUserSingleByUserID(m_character.ID);
if (detail == null)
{
Out.SendKitoff(LanguageMgr.GetTranslation("UserLoginHandler.Forbid"));
Client.Disconnect();
return false;
}
else
{
m_character = detail;
}
ChargeToUser();
int[] sole = new int[] { 0, 1, 2 };
Out.SendUpdateInventorySlot(FightBag, sole);
UpdateItemForUser(1);
UpdateVIPForUser();
//AddGP(0);
UpdateWeapon(m_mainBag.GetItemAt(6));
UpdateSecondWeapon(m_mainBag.GetItemAt(15));
m_pvepermissions = string.IsNullOrEmpty(detail.PvePermission) ? InitPvePermission() : m_converter.GetBytes(detail.PvePermission);
_friends = new Dictionary<int, int>();
_friends = db.GetFriendsIDAll(m_character.ID);
m_character.State = 1;
db.UpdatePlayer(m_character);
// db.UpdateVIPInfo(m_character);
return true;
}
}
public bool UpdatePlayerMarry(PlayerInfo player)
{
bool flag = false;
try
{
flag = this.db.RunProcedure("SP_Users_Marry", new SqlParameter[7]
{
new SqlParameter("@UserID", (object) player.ID),
new SqlParameter("@IsMarried", (object) (int) (player.IsMarried ? 1 : 0)),
new SqlParameter("@SpouseID", (object) player.SpouseID),
new SqlParameter("@SpouseName", (object) player.SpouseName),
new SqlParameter("@IsCreatedMarryRoom", (object) (int) (player.IsCreatedMarryRoom ? 1 : 0)),
new SqlParameter("@SelfMarryRoomID", (object) player.SelfMarryRoomID),
new SqlParameter("@IsGotRing", (object) (int) (player.IsGotRing ? 1 : 0))
});
}
catch (Exception ex)
{
if (BaseBussiness.log.IsErrorEnabled)
BaseBussiness.log.Error((object)"UpdatePlayerMarry", ex);
}
return flag;
}
public GamePlayer(int playerId, string account, GameClient client, PlayerInfo info)
: base()
{
m_playerId = playerId;
m_account = account;
m_client = client;
m_character = info;
LastChatTime = DateTime.Today;
m_mainBag = new PlayerEquipInventory(this);
m_propBag = new PlayerInventory(this, true, 50, (int)eBageType.PropBag, 0, true);
m_storeBag = new PlayerInventory(this, true, 100, (int)eBageType.Bank, 0, true);//bank
m_storeBag2 = new PlayerInventory(this, true, 20, (int)eBageType.Store, 0, true);
m_fightBag = new PlayerInventory(this, false, 3, (int)eBageType.FightBag, 0, false);
m_tempBag = new PlayerInventory(this, false, 60, (int)eBageType.TempBag, 0, true);
m_caddyBag = new PlayerInventory(this, false, 30, (int)eBageType.CaddyBag, 0, true);
m_farm = new PlayerInventory(this, false, 30, (int)eBageType.FARM, 0, true);
m_vegetable = new PlayerInventory(this, false, 30, (int)eBageType.VEGETABLE, 0, true);
m_food = new PlayerInventory(this, false, 30, (int)eBageType.FOOD, 0, true);
m_petEgg = new PlayerInventory(this, false, 30, (int)eBageType.PETEGG, 0, false);
m_cardBag = new PlayerInventory(this, true, 20, 15, 0, true);
m_questInventory = new QuestInventory(this);
m_bufferList = new BufferList(this);
m_equipEffect = new List<int>();
//双倍经验卡初始化
GPAddPlus = 1;
X = 646;
Y = 1241;
MarryMap = 0;
m_converter = new System.Text.UTF8Encoding();
}
public virtual PlayerInfo LoginGame(string name, string pass, ref bool isFirst)
{
try
{
using (CenterServiceClient client = new CenterServiceClient())
{
int userID = 0;
if (client.ValidateLoginAndGetID(name, pass, ref userID, ref isFirst))
{
PlayerInfo player = new PlayerInfo();
player.ID = userID;
player.UserName = name;
return player;
}
}
}
catch (Exception ex)
{
log.Error("LoginGame", ex);
}
return null;
}
public void SendUpdatePrivateInfo(SqlDataProvider.Data.PlayerInfo info)
{
throw new NotImplementedException();
}
public GSPacketIn SendUpdatePublicPlayer(PlayerInfo info)
{
GSPacketIn pkg = new GSPacketIn((byte)ePackageType.UPDATE_PlAYER_INFO, info.ID);
pkg.WriteInt(info.GP);
pkg.WriteInt(info.Offer);
pkg.WriteInt(info.RichesOffer);
pkg.WriteInt(info.RichesRob);
pkg.WriteInt(info.Win);
pkg.WriteInt(info.Total);
pkg.WriteInt(info.Escape);
pkg.WriteInt(info.Attack);
pkg.WriteInt(info.Defence);
pkg.WriteInt(info.Agility);
pkg.WriteInt(info.Luck);
pkg.WriteInt(info.Hide);
//pkg.WriteInt(info.Grade);
pkg.WriteString(info.Style);
pkg.WriteString(info.Colors);
pkg.WriteString(info.Skin);
pkg.WriteInt(info.ConsortiaID);
pkg.WriteString(info.ConsortiaName);
pkg.WriteInt(info.ConsortiaLevel);
pkg.WriteInt(info.ConsortiaRepute);
pkg.WriteInt(info.Nimbus);
//PVE难度等级测试
pkg.WriteString(info.PvePermission);
//fightPermission
//pkg.WriteString(info.PvePermission);
pkg.WriteString("1");
pkg.WriteInt(info.FightPower);
//info.apprenticeshipState = pkg.readInt();
//info.masterID = pkg.readInt();
//info.setMasterOrApprentices(pkg.readUTF());
//info.graduatesCount = pkg.readInt();
//info.honourOfMaster = pkg.readUTF();
pkg.WriteInt(1);
pkg.WriteInt(-1);
pkg.WriteString("ss");
pkg.WriteInt(1);
pkg.WriteString("ss");
////AchievementPoint
pkg.WriteInt(0);
////honor
pkg.WriteString("honor");
//LastSpaDate
if (info.ExpendDate != null)
pkg.WriteDateTime((DateTime)info.ExpendDate);
else { pkg.WriteDateTime(DateTime.MinValue); }
//charmgp
pkg.WriteInt(100);
//consortiaCharmGP
pkg.WriteInt(100);
pkg.WriteDateTime(DateTime.MinValue);
////DeputyWeaponID
pkg.WriteInt(10001);
pkg.WriteInt(0);
// box gi ko biet
pkg.WriteInt(info.AnswerSite);
// pkg.WriteInt(0);
SendTCP(pkg);
return pkg;
}
public GSPacketIn SendUpdatePublicPlayer(SqlDataProvider.Data.PlayerInfo info)
{
throw new NotImplementedException();
}
public void HandleGameRoomCreate(GSPacketIn pkg)
{
int roomId = pkg.ReadInt();
int gameType = pkg.ReadInt();
int guildId = pkg.ReadInt();
int count = pkg.ReadInt();
int totalLevel = 0;
IGamePlayer[] players = new IGamePlayer[count];
for (int i = 0; i < count; i++)
{
PlayerInfo info = new PlayerInfo();
info.ID = pkg.ReadInt();
info.NickName = pkg.ReadString();
info.Sex = pkg.ReadBoolean();
info.Hide = pkg.ReadInt();
info.Style = pkg.ReadString();
info.Colors = pkg.ReadString();
info.Skin = pkg.ReadString();
info.Offer = pkg.ReadInt();
info.GP = pkg.ReadInt();
info.Grade = pkg.ReadInt();
info.Repute = pkg.ReadInt();
info.ConsortiaID = pkg.ReadInt();
info.ConsortiaName = pkg.ReadString();
info.ConsortiaLevel = pkg.ReadInt();
info.ConsortiaRepute = pkg.ReadInt();
info.Attack = pkg.ReadInt();
info.Defence = pkg.ReadInt();
info.Agility = pkg.ReadInt();
info.Luck = pkg.ReadInt();
double baseAttack = pkg.ReadDouble();
double baseDefence = pkg.ReadDouble();
double baseAgility = pkg.ReadDouble();
double baseBlood = pkg.ReadDouble();
int templateId = pkg.ReadInt();
bool canUserProp = pkg.ReadBoolean();
int secondWeapon = pkg.ReadInt();
int strengthLevel = pkg.ReadInt();
double gprate = pkg.ReadDouble();
double offerrate = pkg.ReadDouble();
double rate = pkg.ReadDouble();
int serverid = pkg.ReadInt();
ItemTemplateInfo itemTemplate = ItemMgr.FindItemTemplate(templateId);
ItemInfo item = null;
if (secondWeapon != 0)
{
ItemTemplateInfo secondWeaponTemp = ItemMgr.FindItemTemplate(secondWeapon);
item = ItemInfo.CreateFromTemplate(secondWeaponTemp, 1, 1);
item.StrengthenLevel = strengthLevel;
}
List<BufferInfo> infos = new List<BufferInfo>();
int buffercout = pkg.ReadInt();
for (int j = 0; j < buffercout; j++)
{
BufferInfo buffinfo = new BufferInfo();
buffinfo.Type = pkg.ReadInt();
buffinfo.IsExist = pkg.ReadBoolean();
buffinfo.BeginDate = pkg.ReadDateTime();
buffinfo.ValidDate = pkg.ReadInt();
buffinfo.Value = pkg.ReadInt();
if (info != null)
infos.Add(buffinfo);
}
players[i] = new ProxyPlayer(this, info, itemTemplate, item, baseAttack, baseDefence, baseAgility, baseBlood, gprate, offerrate, rate, infos, serverid);
players[i].CanUseProp = canUserProp;
int ec = pkg.ReadInt();
for (int j = 0; j < ec; j++)
{
players[i].EquipEffect.Add(pkg.ReadInt());
}
totalLevel += info.Grade;
}
ProxyRoom room = new ProxyRoom(ProxyRoomMgr.NextRoomId(), roomId, players, this);
room.GuildId = guildId;
room.GameType = (eGameType)gameType;
lock (m_rooms)
{
if (!m_rooms.ContainsKey(roomId))
{
m_rooms.Add(roomId, room);
}
else
{
room = null;
}
}
if (room != null)
{
ProxyRoomMgr.AddRoom(room);
}
else
{
log.ErrorFormat("Room already exists:{0}", roomId);
}
}
public bool UpdateVIPInfo(PlayerInfo p)
{
bool flag = false;
try
{
SqlParameter[] sqlParameters = new SqlParameter[] {
new SqlParameter("@UserID", p.ID),
new SqlParameter("@VIPLevel", p.VIPLevel),
new SqlParameter("@VIPExp", p.VIPExp),
new SqlParameter("@VIPOnlineDays", p.VIPOnlineDays),
new SqlParameter("@VIPOfflineDays", p.VIPOfflineDays),
new SqlParameter("@VIPExpireDay", p.VIPExpireDay.ToString()),
new SqlParameter("@VIPLastDate", DateTime.Now),
new SqlParameter("@VIPNextLevelDaysNeeded", p.VIPNextLevelDaysNeeded),
new SqlParameter("@CanTakeVipReward", p.CanTakeVipReward),
new SqlParameter("@Result", SqlDbType.Int) };
sqlParameters[9].Direction = ParameterDirection.ReturnValue;
db.RunProcedure("SP_UpdateVIPInfo", sqlParameters);
//p.IsDirty = false;
flag = true;
}
catch (Exception exception)
{
if (BaseBussiness.log.IsErrorEnabled)
{
BaseBussiness.log.Error("SP_UpdateVIPInfo", exception);
}
}
return flag;
}
