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