public static void SaveHouseMap(MySql database, string mapID, HouseMap map) { bool localTransaction = false; if (database.IsTransactionActive == false) { database.BeginTransaction(); localTransaction = true; } SaveMapDump(database, mapID, map); // Save extra data associated with instanced maps database.UpdateOrInsert("map_house_data", new IDataColumn[] { database.CreateColumn(false, "MapID", mapID), database.CreateColumn(false, "Owner", map.Owner), database.CreateColumn(false, "Room", map.Room.ToString()), database.CreateColumn(false, "StartX", map.StartX.ToString()), database.CreateColumn(false, "StartY", map.StartY.ToString()) }); if (localTransaction) { database.EndTransaction(); } }
public static HouseMap LoadHouseMap(MySql database, string mapID) { if (IsMapIDInUse(database, mapID)) { HouseMap map = new HouseMap(mapID); LoadMapDump(database, mapID, map); string query = "SELECT map_house_data.Owner, map_house_data.Room, map_house_data.StartX, map_house_data.StartY FROM map_house_data WHERE map_house_data.MapID = \'" + database.VerifyValueString(mapID) + "\'"; DataColumnCollection row = database.RetrieveRow(query); if (row != null) { int counter = 0; map.Owner = row[counter++].ValueString; map.Room = Convert.ToInt32(row[counter++].Value); map.StartX = Convert.ToInt32(row[counter++].Value); map.StartY = Convert.ToInt32(row[counter++].Value); } else { throw new Exception("House map data not found"); } return(map); } else { return(null); } }
public static House LoadHouseMap(DatabaseConnection dbConnection, string mapID) { DataManager.Maps.HouseMap loadedMap = MapDataManager.LoadHouseMap(dbConnection.Database, mapID); if (loadedMap != null) { House map = new House(loadedMap); return(map); } else { return(null); } }
public static HouseMap LoadHouseMap(MySql database, string mapID) { if (IsMapIDInUse(database, mapID)) { HouseMap map = new HouseMap(mapID); LoadMapDump(database, mapID, map); string query = "SELECT map_house_data.Owner, map_house_data.Room, map_house_data.StartX, map_house_data.StartY FROM map_house_data WHERE map_house_data.MapID = \'" + database.VerifyValueString(mapID) + "\'"; DataColumnCollection row = database.RetrieveRow(query); if (row != null) { int counter = 0; map.Owner = row[counter++].ValueString; map.Room = Convert.ToInt32(row[counter++].Value); map.StartX = Convert.ToInt32(row[counter++].Value); map.StartY = Convert.ToInt32(row[counter++].Value); } else { throw new Exception("House map data not found"); } return map; } else { return null; } }