public void setPlayerValues()
{
conn.Open();
UInt32 charID = Store.currentClient.playerData.getCharID();
string sqlQuery = "Select handle,x,y,z,rotation,healthC,healthM,innerStrC,innerStrM,level,profession,alignment,pvpflag,firstName,lastName,exp,cash,district,districtId,factionId,crewId from characters where charId='" + charID + "'";
queryExecuter = conn.CreateCommand();
queryExecuter.CommandText = sqlQuery;
dr = queryExecuter.ExecuteReader();
while (dr.Read())
{
Store.currentClient.playerInstance.CharacterID.setValue(charID);
Store.currentClient.playerInstance.CharacterName.setValue(dr.GetString(0));
double x = dr.GetDouble(1);
double y = dr.GetDouble(2);
double z = dr.GetDouble(3);
Store.currentClient.playerInstance.Position.setValue(NumericalUtils.doublesToLtVector3d(x, y, z));
Store.currentClient.playerInstance.YawInterval.setValue((byte)dr.GetDecimal(4));
Store.currentClient.playerInstance.Health.setValue((UInt16)dr.GetDecimal(5));
Store.currentClient.playerInstance.MaxHealth.setValue((UInt16)dr.GetDecimal(6));
Store.currentClient.playerInstance.InnerStrengthAvailable.setValue((UInt16)dr.GetDecimal(7));
Store.currentClient.playerInstance.InnerStrengthMax.setValue((UInt16)dr.GetDecimal(8));
Store.currentClient.playerInstance.Level.setValue((byte)dr.GetDecimal(9));
Store.currentClient.playerInstance.TitleAbility.setValue((UInt32)dr.GetDecimal(10));
Store.currentClient.playerInstance.OrganizationID.setValue((byte)dr.GetDecimal(11));
//data.setPlayerValue("pvpFlag",(int)dr.GetDecimal(12));
Store.currentClient.playerInstance.RealFirstName.setValue(dr.GetString(13));
Store.currentClient.playerInstance.RealLastName.setValue(dr.GetString(14));
Store.currentClient.playerData.setExperience((long)dr.GetDecimal(15));
Store.currentClient.playerData.setInfo((long)dr.GetDecimal(16));
Store.currentClient.playerData.setDistrict(dr.GetString(17));
Store.currentClient.playerData.setDistrictId((uint)dr.GetInt16(18));
UInt32 factionId = (uint)dr.GetInt16(19);
UInt32 crewId = (uint)dr.GetInt16(20);
if (factionId > 0)
{
Store.currentClient.playerInstance.FactionID.enable();
Store.currentClient.playerInstance.FactionID.setValue(factionId);
}
if (crewId > 0)
{
Store.currentClient.playerInstance.CrewID.enable();
Store.currentClient.playerInstance.CrewID.setValue(crewId);
}
}
dr.Close();
conn.Close();
}
public void updateLocationByHL(UInt16 district, UInt16 hardline)
{
string sqlQuery = "SELECT DH.X,DH.Y,DH.Z,DH.ROT,DIS.key,DH.DistrictId FROM data_hardlines AS DH, districts as DIS WHERE DH.DistrictId = '" + district.ToString() + "' AND DH.HardLineId = '" + hardline.ToString() + "' AND DH.DistrictId=DIS.id ";
queryExecuter = conn.CreateCommand();
queryExecuter.CommandText = sqlQuery;
dr = queryExecuter.ExecuteReader();
while (dr.Read())
{
double x = (double)(dr.GetFloat(0));
double y = (double)(dr.GetFloat(1));
double z = (double)(dr.GetFloat(2));
string disKey = dr.GetString(4);
Output.WriteLine("USER DIS IS NOW " + disKey);
Store.currentClient.playerData.setDistrict(disKey);
Store.currentClient.playerData.setDistrictId((uint)dr.GetInt16(5));
Store.currentClient.playerInstance.Position.setValue(NumericalUtils.doublesToLtVector3d(x, y, z));
//Store.currentClient.playerInstance.YawInterval.setValue((byte)dr.GetDecimal(3));
}
dr.Close();
savePlayer(Store.currentClient);
}
