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); }