Can you Fix the AccountCreate for this server like this, please ? Thank's in advance
Code:
public bool CreateAccount(string login, string password)
{
try
{
using (MySqlConnection mySqlConnection = SQLjec.getInstance().conn())
{
MySqlCommand command = mySqlConnection.CreateCommand();
mySqlConnection.Open();
command.CommandText = "SELECT COUNT(*) FROM accounts WHERE login='" + login + "';";
command.ExecuteScalar();
command.CommandText = "INSERT INTO accounts (login, password, weapon_primary, weapon_secondary, weapon_melee, weapon_thrown_normal, weapon_thrown_special, char_red, char_blue, char_helmet, char_dino) VALUES ('" + login + "', '" + password + "', '100003004', '601002003', '702001001', '803007001', '904007002', '1001001005', '1001002006', '1102003001', '1006003042');";
command.CommandType = CommandType.Text;
command.ExecuteNonQuery();
command.CommandText = "SELECT * FROM accounts WHERE login='" + login + "';";
command.CommandType = CommandType.Text;
MySqlDataReader mySqlDataReader = command.ExecuteReader();
Account acc = new Account();
while (mySqlDataReader.Read())
acc.player_id = mySqlDataReader.GetInt32("player_id");
acc.name = login;
acc.password = password;
acc.weapon_primary = 100003004;
acc.weapon_secondary = 601002003;
acc.weapon_melee = 702001001;
acc.weapon_thrown_normal = 803007001;
acc.weapon_thrown_special = 904007002;
acc.char_red = 1001001005;
acc.char_blue = 1001002006;
acc.char_helmet = 1102003001;
acc.char_dino = 1006003042;
acc.setInventory(new PlayerInventory(acc.player_id));
this.AddAccount(acc);
return true;
}
}
catch (Exception ex)
{
CLogger.getInstance().error("|[ACM]| Não foi possível ver a conta '" + login + "'");
CLogger.getInstance().error("|[ACM]| " + ((object)ex).ToString());
return false;
}
}