public static int WeaponDbInsert(Weapon _weap)
{
string _fill = "', '";
string _name, _dmgt, _elet, _weapt;
int _range, _dmga, _elea, _dura, _wght;
_name = _weap.GetName();
_range = _weap.GetRange();
_dmgt = _weap.GetDmgType().ToString();
_elet = _weap.GetEleDmgType().ToString();
_weapt = _weap.GetWeapType().ToString();
_dmga = _weap.GetPhysDmgAmt();
_elea = _weap.GetEleDmgAmt();
_dura = _weap.GetDura();
_wght = _weap.GetWeight();
string values = "('" + _name + _fill + _range + _fill + _elet + _fill + _dmgt + _fill + _elea + _fill + _dmga + _fill + _weapt + _fill + _dura + _fill + _wght + "')";
string locations = "(WeaponName, WeaponRange, EleDmgType, DmgType, EleDmgAmt, DmgAmt, WeapType, Durability, Weight)";
string cmdText = "INSERT INTO weapons " + locations + " VALUES" + values;
MySqlCommand _cmd = _masterConnect.CreateCommand();
_cmd.CommandText = cmdText;
_cmd.ExecuteNonQuery();
_cmd.CommandText = "SELECT * FROM thefellnightprison.weapons Where WeaponName = '" +
_name + "' AND WeaponRange = '" +
_range + "' AND DmgType = '" +
_dmgt + "' AND EleDmgType = '" +
_elet + "' AND DmgAmt = '" +
_dmga + "' AND EleDmgAmt = '" +
_elea + "' AND Durability = '" +
_dura + "' AND Weight = '" +
_wght + "'";
MySqlDataReader _reader = _cmd.ExecuteReader();
_reader.Read();
string thing = _reader["idWeapons"].ToString();
_reader.Close();
return Convert.ToInt32(thing);
}
