Code:
public static void LoadMonsterSpawns() { lock (DatabaseConnection.Connection) { MySqlCommand Cmd = new MySqlCommand("SELECT * FROM `mobspawns`", DatabaseConnection.Connection); MySqlDataReader DR = Cmd.ExecuteReader(); int TotalSpawns = 0; while (DR.Read()) { MonsterSpawn MS = new MonsterSpawn(); MS.Map = Convert.ToInt32(DR["Map"]); MS.MobID = Convert.ToInt32(DR["ID"]); MS.SpawnID = Convert.ToInt32(DR["UniSpawnID"]); MS.SpawnNumber = Convert.ToInt32(DR["NumberToSpawnf"]); MS.MaxSpawnNumber = MS.SpawnNumber; TotalSpawns += MS.SpawnNumber; MS.X = Convert.ToInt32(DR["x-start"]); MS.XStop = Convert.ToInt32(DR["x-stop"]); MS.Y = Convert.ToInt32(DR["y-start"]); MS.YStop = Convert.ToInt32(DR["y-stop"]); if (!Nano.MonsterSpawns.ContainsKey(MS.SpawnID)) { Nano.MonsterSpawns.Add(MS.SpawnID, MS); } } Console.WriteLine("[GameServer] Loaded " + Nano.MonsterSpawns.Count + " unique monster spawns."); Console.WriteLine("[GameServer] Will theoretically spawn " + TotalSpawns + " monsters into the world."); DR.Close(); } }