Northrend rares under-spawned in 7.1 — small DB audit

[Kneuma]

Hey,

Was chasing down a rare-spawn issue with Doomsayer Jurim / TLPD / Dirkee in Discord and ended up noticing a wider pattern in the 7.1 repack — a bunch of WotLK rares have way fewer spawn entries in the creature table than Wowhead documents.

Quick audit of well-known WotLK rares (rank 4) in the live DB:

Putridus the Ancient    —  1
Vyragosa                —  1
King Krush              —  2
High Thane Jorfus       —  3
Skoll                   —  3
Terror Spinner          —  4
Hildana Deathstealer    —  4
Dirkee                  —  4   (Wowhead documents 18)
Aotona                  —  6
Gondria                 —  6
Griegen                 —  7
Loque'nahak             —  7
Time-Lost Proto-Drake   — 21

Only one I've cross-checked against Wowhead so far is Dirkee (18 documented pins in Storm Peaks, DB has 4). Not 100% certain on canonical counts for the others without looking each up, but Vyragosa at 1 and King Krush at 2 stand out — they normally have several spawn points each.

Quick context — the Cataclysm v13 changelog from 2020 mentions "Added pool data for Northrend rare spawns so the mobs will actually spawn", so the fix pattern is precedented. Looks like MoP 7.x may not have inherited the same patch.

Fix shape would be backfilling pool_creature + creature rows using Wowhead spawn coords, keeping max_limit = 1 in pool_template so only one of N spawn points is active at a time (matches the existing rare-spawn behavior).

Happy to put together the SQL for any of these if someone has Wowhead-sourced coords handy. Posting in case it's useful for a future fix pass.

Cheers