public void VieHahmo(Playerstats player) { using (connection) { yhdista(); string command = "INSERT INTO characters(Name, lifeleech, manaleech, defence, dmg, speed, hp, accuracy, level, incdmg, critchance, critdmg, locationX, locationY, towerlvl, hpregen ,inchp, exp, exptonextlvl) VALUES(@name, @lifeleech, @manaleech, @def, @dmg, @speed, @hp, @accuracy, @lvl, @incDMG, @critchance, @critdmg, @locationX, @locationY, @towerlvl, @hpregen, @inchp, @exp, @expToNext)"; SqlCommand sqlCommand = new SqlCommand(command, connection); sqlCommand.Parameters.AddWithValue("@name", player.Name); sqlCommand.Parameters.AddWithValue("@lifeleech", player.Lifeleech); sqlCommand.Parameters.AddWithValue("@manaleech", player.Manaleech); sqlCommand.Parameters.AddWithValue("@def", player.Def); sqlCommand.Parameters.AddWithValue("@dmg", player.Dmg); sqlCommand.Parameters.AddWithValue("@speed", player.Speed); sqlCommand.Parameters.AddWithValue("@hp", player.Hp); sqlCommand.Parameters.AddWithValue("@accuracy", player.Accuracy); sqlCommand.Parameters.AddWithValue("@lvl", player.Lvl); sqlCommand.Parameters.AddWithValue("@critchance", player.Critchance); sqlCommand.Parameters.AddWithValue("@critdmg", player.Critdmg); sqlCommand.Parameters.AddWithValue("@locationX", player.LocationX); sqlCommand.Parameters.AddWithValue("@locationY", player.LocationY); sqlCommand.Parameters.AddWithValue("@towerlvl", player.Towerlvl); sqlCommand.Parameters.AddWithValue("@hpregen", player.Hpregen); sqlCommand.Parameters.AddWithValue("@inchp", player.Inchp); sqlCommand.Parameters.AddWithValue("@incDMG", player.Increaseddmg); sqlCommand.Parameters.AddWithValue("@exp", player.Exp); sqlCommand.Parameters.AddWithValue("@expToNext", player.Exptonext); sqlCommand.ExecuteNonQuery(); ViePassivetree(player); } }
public Playerstats Haeskilltree(Playerstats player) { string command = "Select * From skillpoints WHERE characterid = @id"; using (SqlCommand sqlCommand = new SqlCommand(command, connection)) { yhdista(); sqlCommand.Parameters.AddWithValue("@id", player.Id); using (SqlDataReader reader = sqlCommand.ExecuteReader()) { while (reader.Read()) { player.Def1 = reader.GetInt32(4); player.Def2 = reader.GetInt32(5); player.Dmg1 = reader.GetInt32(2); player.Dmg2 = reader.GetInt32(3); player.Dmglesslife = reader.GetInt32(7); player.Doublearmor = reader.GetBoolean(15); player.Dualstrike = reader.GetBoolean(8); player.Life1 = reader.GetInt32(11); player.Life2 = reader.GetInt32(12); player.Lifereg1 = reader.GetInt32(13); player.Lifereg2 = reader.GetInt32(14); player.Lifesteal1 = reader.GetInt32(9); player.Lifesteal2 = reader.GetInt32(10); player.Bigdef = reader.GetInt32(6); } } } return(player); }
public void luohahmo(Playerstats player) { using (connection) { yhdista(); string command = "INSERT INTO characters(Name, lifeleech, manaleech, defence, dmg, speed, hp, accuracy, level, incdmg, critchance, critdmg, locationX, locationY, towerlvl, hpregen ,inchp, exp, exptonextlvl) VALUES(@name, @lifeleech, @manaleech, @def, @dmg, @speed, @hp, @accuracy, @lvl, @incDMG, @critchance, @critdmg, @locationX, @locationY, @towerlvl, @hpregen, @inchp, @exp, @expToNext)"; SqlCommand sqlCommand = new SqlCommand(command, connection); sqlCommand.Parameters.AddWithValue("@name", player.Name); sqlCommand.Parameters.AddWithValue("@lifeleech", player.Lifeleech); sqlCommand.Parameters.AddWithValue("@manaleech", player.Manaleech); sqlCommand.Parameters.AddWithValue("@def", player.Def); sqlCommand.Parameters.AddWithValue("@dmg", player.Dmg); sqlCommand.Parameters.AddWithValue("@speed", player.Speed); sqlCommand.Parameters.AddWithValue("@hp", player.Hp); sqlCommand.Parameters.AddWithValue("@accuracy", player.Accuracy); sqlCommand.Parameters.AddWithValue("@lvl", player.Lvl); sqlCommand.Parameters.AddWithValue("@critchance", player.Critchance); sqlCommand.Parameters.AddWithValue("@critdmg", player.Critdmg); sqlCommand.Parameters.AddWithValue("@locationX", player.LocationX); sqlCommand.Parameters.AddWithValue("@locationY", player.LocationY); sqlCommand.Parameters.AddWithValue("@towerlvl", player.Towerlvl); sqlCommand.Parameters.AddWithValue("@hpregen", player.Hpregen); sqlCommand.Parameters.AddWithValue("@inchp", player.Inchp); sqlCommand.Parameters.AddWithValue("@incDMG", player.Increaseddmg); sqlCommand.Parameters.AddWithValue("@exp", player.Exp); sqlCommand.Parameters.AddWithValue("@expToNext", player.Exptonext); sqlCommand.ExecuteNonQuery(); // tässä välissä haetaan pelaajan id koska sitä tarvitaan command = "SELECT TOP 1 * FROM characters ORDER BY ID DESC"; using (sqlCommand = new SqlCommand(command, connection)) { using (SqlDataReader reader = sqlCommand.ExecuteReader()) { while (reader.Read()) { player.Id = reader.GetInt32(0); } } } command = "INSERT INTO skillpoints(characterid, dmg1, dmg2, def1, def2, bigdef, life1, life2, lifesteal1, lifesteal2, dmglesslife, dualstrike, lifereg1, lifereg2, doublearmor) Values(@characterid, @dmg1, @dmg2, @def1, @def2, @bigdef, @life1, @life2, @lifesteal1, @lifesteal2, @dmglesslife, @dualstrike, @lifereg1, @lifereg2, @doublearmor)"; sqlCommand = new SqlCommand(command, connection); sqlCommand.Parameters.AddWithValue("@dmg1", player.Dmg1); sqlCommand.Parameters.AddWithValue("@dmg2", player.Dmg2); sqlCommand.Parameters.AddWithValue("@def1", player.Def1); sqlCommand.Parameters.AddWithValue("@def2", player.Def2); sqlCommand.Parameters.AddWithValue("@dmglesslife", player.Dmglesslife); sqlCommand.Parameters.AddWithValue("@doublearmor", player.Doublearmor); sqlCommand.Parameters.AddWithValue("@dualstrike", player.Dualstrike); sqlCommand.Parameters.AddWithValue("@life1", player.Life1); sqlCommand.Parameters.AddWithValue("@life2", player.Life2); sqlCommand.Parameters.AddWithValue("@lifereg1", player.Lifereg1); sqlCommand.Parameters.AddWithValue("@lifereg2", player.Lifereg2); sqlCommand.Parameters.AddWithValue("@lifesteal1", player.Lifesteal1); sqlCommand.Parameters.AddWithValue("@lifesteal2", player.Lifesteal2); sqlCommand.Parameters.AddWithValue("@bigdef", player.Bigdef); sqlCommand.Parameters.AddWithValue("@characterid", player.Id); sqlCommand.ExecuteNonQuery(); } }
public inventoryform(List <Esineet> inventory, Playerstats playerstats, TheGame theGame) { InitializeComponent(); player = playerstats; game = theGame; newinventory = inventory; Itemsorting(); }
public List <Playerstats> HaeHahmot() { List <Playerstats> players = new List <Playerstats>(); using (connection) { yhdista(); string command = "Select * From characters"; using (SqlCommand sqlCommand = new SqlCommand(command, connection)) { using (SqlDataReader reader = sqlCommand.ExecuteReader()) { while (reader.Read()) { Playerstats player = new Playerstats(); player.Id = reader.GetInt32(0); player.Name = reader.GetString(1); player.Increaseddmg = reader.GetDecimal(10); player.Lifeleech = reader.GetDecimal(2); player.Manaleech = reader.GetDecimal(3); player.Def = reader.GetDecimal(4); player.Dmg = reader.GetDecimal(5); player.Speed = reader.GetDecimal(6); player.Hp = reader.GetDecimal(7); player.Accuracy = reader.GetDecimal(8); player.Lvl = reader.GetInt32(9); player.Critchance = reader.GetDecimal(11); player.Critdmg = reader.GetDecimal(12); player.LocationX = reader.GetInt32(13); player.LocationY = reader.GetInt32(14); player.Towerlvl = reader.GetInt32(15); player.Hpregen = reader.GetDecimal(16); player.Inchp = reader.GetDecimal(17); player.Exp = reader.GetInt32(18); player.Exptonext = reader.GetInt32(19); players.Add(player); } } } } List <Playerstats> allplayerstats = new List <Playerstats>(); foreach (Playerstats player in players) { Haeskilltree(player); allplayerstats.Add(player); } return(allplayerstats); }
public TheGame(Playerstats gotplayer) { InitializeComponent(); this.DoubleBuffered = true; gc = new Gamecontroller(this); CreateWorld(); gc.CalculatePlayerHp(); gc.Player = gotplayer; gc.Playerhp = gc.Player.Hp; gc.HaeInventory(); UpdateStyles(); UpdateUi(); gc.PassiveTree1 = new PassiveTree(gc); }
public void ViePassivetree(Playerstats player) { using (connection) { string command = "UPDATE skillpoints SET dmg1 = @dmg1, dmg2 = @dmg2, def1 = @def1, def2 = @def2, bigdef = @bigdef, life1 = @life1, life2 = @life2, lifesteal1 = @lifesteal1, lifesteal2 = @lifesteal2, dmglesslife = @dmglesslife, dualstrike = @dualstrike, lifereg1 = @lifereg1, lifereg2 = @lifereg2, doublearmor = @doublearmor WHERE characterid = @id"; SqlCommand sqlCommand = new SqlCommand(command, connection); sqlCommand.Parameters.AddWithValue("@id", player.Id); sqlCommand.Parameters.AddWithValue("@dmg1", player.Dmg1); sqlCommand.Parameters.AddWithValue("@dmg2", player.Dmg2); sqlCommand.Parameters.AddWithValue("@def1", player.Def1); sqlCommand.Parameters.AddWithValue("@def2", player.Def2); sqlCommand.Parameters.AddWithValue("@dmglesslife", player.Dmglesslife); sqlCommand.Parameters.AddWithValue("@doublearmor", player.Doublearmor); sqlCommand.Parameters.AddWithValue("@dualstrike", player.Dualstrike); sqlCommand.Parameters.AddWithValue("@life1", player.Life1); sqlCommand.Parameters.AddWithValue("@life2", player.Life2); sqlCommand.Parameters.AddWithValue("@lifereg1", player.Lifereg1); sqlCommand.Parameters.AddWithValue("@lifereg2", player.Lifereg2); sqlCommand.Parameters.AddWithValue("@lifesteal1", player.Lifesteal1); sqlCommand.Parameters.AddWithValue("@lifesteal2", player.Lifesteal2); sqlCommand.Parameters.AddWithValue("@bigdef", player.Bigdef); sqlCommand.ExecuteNonQuery(); } }
public void Setplayer(Playerstats player) { this.player = player; }
public void Setplayerinv(List <Esineet> lista, Playerstats gotplayer) { gc.Inventory = lista; gc.Player = gotplayer; }