internal void AddArena(Arena a) { Query("INSERT INTO CWArenas (Name, HomeX, HomeY, RedSpawnX, RedSpawnY, BlueSpawnX, BlueSpawnY, ArenaTopLeftX, ArenaTopLeftY, ArenaBottomRightX, ArenaBottomRightY, " + "RedBunkerTileID, BlueBunkerTileID, RedBunkerWallID, BlueBunkerWallID, RedBunkerPaintID, BlueBunkerPaintID, Stats, Scripts) " + "VALUES (@1, @2, @3, @4, @5, @6, @7, @8, @9, @10, @11, @12, @13, @14, @15, @16, @17, @18)", a.Name, a.Home.X, a.Home.Y, a.RedSpawn.X, a.RedSpawn.Y, a.BlueSpawn.X, a.BlueSpawn.Y, a.TopLeft.X, a.TopLeft.Y, a.BottomRight.X, a.BottomRight.Y, a.Red.ID, a.Blue.ID, a.Red.Wall, a.Blue.Wall, a.Red.Paint, a.Blue.Paint, ArenaStat.Blob(a.Stats), Script.Blob(a.Scripts)); }
internal void UpdateArena(Arena a) { Query("UPDATE CWArenas SET HomeX = @0, HomeY = @1, RedSpawnX = @2, RedSpawnY = @3, BlueSpawnX = @4, BlueSpawnY = @5, ArenaTopLeftX = @6, " + "ArenaTopLeftY = @7, ArenaBottomRightX = @8, ArenaBottomRightY = @9, RedBunkerTileID = @10, BlueBunkerTileID = @11, RedBunkerWallID = @12, " + "BlueBunkerWallID = @13, RedBunkerPaintID = @14, BlueBunkerPaintID = @15, Stats = @16, Scripts = @17 WHERE Name = @18" , a.Home.X, a.Home.Y, a.RedSpawn.X, a.RedSpawn.Y, a.BlueSpawn.X, a.BlueSpawn.Y, a.TopLeft.X, a.TopLeft.Y, a.BottomRight.X, a.BottomRight.Y, a.Red.ID, a.Blue.ID, a.Red.Wall, a.Blue.Wall, a.Red.Paint, a.Blue.Paint, ArenaStat.Blob(a.Stats), Script.Blob(a.Scripts), a.Name); }