public void SavePlayerInfo_UpdateServerDB()
{
this.lastPos = PlayerCoordinator.Instance.PlayerPos;
this.moveSpeed = PlayerStat.Instance.GetStat("Origin_MoveSpeed");
this.jumpSpeed = PlayerStat.Instance.GetStat("Origin_JumpSpeed");
float saveHealthPoint = 0;
if (PlayerStat.Instance.GetStat("HealthPoint") >= PlayerStat.Instance.GetStat("MaxHealthPoint"))
{
saveHealthPoint = PlayerStat.Instance.GetStat("MaxHealthPoint");
}
else
{
saveHealthPoint = PlayerStat.Instance.GetStat("HealthPoint");
}
this.healthPoint = saveHealthPoint;
this.maxHealthPoint = PlayerStat.Instance.GetStat("Origin_MaxHealthPoint");
this.shieldPoint = PlayerStat.Instance.GetStat("Origin_ShieldPoint");
this.attackPoint = PlayerStat.Instance.GetStat("Origin_AttackPoint");
this.attackSpeed = PlayerStat.Instance.GetStat("Origin_AttackSpeed");
this.gatheringPower = PlayerStat.Instance.GetStat("Origin_GatheringPower");
this.levelupExperience = PlayerStat.Instance.GetStat("LevelupExperience");
this.currentExperience = PlayerStat.Instance.GetStat("CurrentExperience");
this.level = (int)PlayerStat.Instance.GetStat("Level");
float saveWorkPoint = 0;
if (PlayerStat.Instance.GetStat("WorkPoint") >= PlayerStat.Instance.GetStat("MaxWorkPoint"))
{
saveWorkPoint = PlayerStat.Instance.GetStat("MaxWorkPoint");
}
else
{
saveWorkPoint = PlayerStat.Instance.GetStat("WorkPoint");
}
this.workPoint = saveWorkPoint;
this.maxWorkPoint = PlayerStat.Instance.GetStat("Origin_MaxWorkPoint");
this.gold = (int)PlayerStat.Instance.GetStat("Gold");
this.statPoint = (int)PlayerStat.Instance.GetStat("StatPoint");
this.statUsage = PlayerStat.Instance.StatUsage;
this.firstLogin = PlayerStat.Instance.FirstLogin;
PlayerStat.Instance.StatUsage.SaveUsageForServerUpdate();
DBConnector.Instance.Save_PlayerStat();
}
public string LoadUserInfo(string accountID)
{
string dbErrorMSG = string.Empty;
string query = $"SELECT * FROM dbo.PlayerStatus WHERE UserAccount = '{accountID}'";
DataSet dataSet = ConnectDB_GetDataSet("PlayerInfo_DB", query, out dbErrorMSG);
if (dataSet == null)
{
return($"서버에 연결할 수 없습니다 : {dbErrorMSG}");
}
DataRow row = dataSet.Tables[0].Rows[0];
string statUsageJSON = row["StatUsageJSON"].ToString();
PlayerStatUsage statUsage = JsonUtility.FromJson <PlayerStatUsage>(statUsageJSON);
UserInfoProvider.Instance.Initialize(row["UserAccount"].ToString(),
row["LastMap"].ToString(),
row["LastPos"].ToString(),
Convert.ToSingle(row["MoveSpeed"]),
Convert.ToSingle(row["JumpSpeed"]),
Convert.ToSingle(row["HealthPoint"]),
Convert.ToSingle(row["MaxHealthPoint"]),
Convert.ToSingle(row["ShieldPoint"]),
Convert.ToSingle(row["AttackPoint"]),
Convert.ToSingle(row["AttackSpeed"]),
Convert.ToSingle(row["GatheringPower"]),
Convert.ToSingle(row["LevelupExperience"]),
Convert.ToSingle(row["CurrentExperience"]),
(int)row["Level"],
Convert.ToSingle(row["WorkPoint"]),
Convert.ToSingle(row["MaxWorkPoint"]),
(int)row["Gold"],
(int)row["StatPoint"],
statUsage,
(bool)row["FirstLogin"]);
return("Success");
}
public void Initialize(string account, string lastMap, string lastPos, float moveSpeed, float jumpSpeed,
float healthPoint, float maxHealthPoint, float shieldPoint, float attackPoint, float attackSpeed, float gatheringPower, float levelupExperience, float currentExperience, int level,
float workPoint, float maxWorkPoint, int gold, int statPoint, PlayerStatUsage statUsage, bool firstLogin)
{
// Account
userAccount = account;
this.lastMap = lastMap;
if (!string.IsNullOrEmpty(lastPos))
{
string[] splitedPos = lastPos.Split(',');
this.lastPos = new Vector3(float.Parse(splitedPos[0]), float.Parse(splitedPos[1]), float.Parse(splitedPos[2]));
}
else
{
this.lastPos = Vector3.zero;
}
// Stat
this.moveSpeed = moveSpeed;
this.jumpSpeed = jumpSpeed;
this.healthPoint = healthPoint;
this.maxHealthPoint = maxHealthPoint;
this.shieldPoint = shieldPoint;
this.attackPoint = attackPoint;
this.attackSpeed = attackSpeed;
this.gatheringPower = gatheringPower;
this.levelupExperience = levelupExperience;
this.currentExperience = currentExperience;
this.level = level;
this.workPoint = workPoint;
this.maxWorkPoint = maxWorkPoint;
this.gold = gold;
this.statPoint = statPoint;
this.statUsage = statUsage;
this.firstLogin = firstLogin;
}
private void InitPlayerStat()
{
UserInfoProvider userData = UserInfoProvider.Instance;
floatStatDic.Add("Origin_MoveSpeed", userData.MoveSpeed);
floatStatDic.Add("Origin_JumpSpeed", userData.JumpSpeed);
floatStatDic.Add("Origin_MaxHealthPoint", userData.MaxHealthPoint);
floatStatDic.Add("Origin_ShieldPoint", userData.ShieldPoint);
floatStatDic.Add("Origin_AttackPoint", userData.AttackPoint);
floatStatDic.Add("Origin_AttackSpeed", userData.AttackSpeed);
floatStatDic.Add("Origin_GatheringPower", userData.GatheringPower);
floatStatDic.Add("Origin_MaxWorkPoint", userData.MaxWorkPoint);
floatStatDic.Add("MoveSpeed", GetStat("Origin_MoveSpeed"));
floatStatDic.Add("JumpSpeed", GetStat("Origin_JumpSpeed"));
floatStatDic.Add("MaxHealthPoint", GetStat("Origin_MaxHealthPoint"));
floatStatDic.Add("HealthPoint", userData.HealthPoint);
floatStatDic.Add("ShieldPoint", GetStat("Origin_ShieldPoint"));
floatStatDic.Add("AttackPoint", GetStat("Origin_AttackPoint"));
floatStatDic.Add("AttackSpeed", GetStat("Origin_AttackSpeed"));
floatStatDic.Add("GatheringPower", GetStat("Origin_GatheringPower"));
floatStatDic.Add("LevelupExperience", userData.LevelupExperience);
floatStatDic.Add("CurrentExperience", userData.CurrentExperience);
floatStatDic.Add("WorkPoint", userData.WorkPoint);
floatStatDic.Add("MaxWorkPoint", userData.MaxWorkPoint);
integerStatDic.Add("Gold", userData.Gold);
integerStatDic.Add("Level", userData.Level);
integerStatDic.Add("StatPoint", userData.StatPoint);
userAccount = userData.UserAccount;
lastMap = userData.LastMap;
statUsage = userData.StatUsage;
firstLogin = userData.FirstLogin;
statUsage.Initialize();
}
