v12 - missing rare NPC

[lolilolpoo]

Hello,

[Location, Faction, Race]Outlands & Northrend
[Name, Type] NPCs, Rare
[Problem Description] Rares are not spawning in Outland & Northrend
[How it should work] Rares should be spawned at all time unless under respawn timer

I've noticed that some Rares are not spawning in Outland & Northrend.
First 3 I checked:
- 18677
- 18678
- 18679

I've checked a dozen in outlands and i'd say there's 50% of them missing. However in Northrend there's none at all.
I can't see them in gm mode either and this issue was not in v10

I can see that their references are here in the DB, yet they're not in-game.

I've tried using .npc add 18677 command, it works, the correct npc spawns and the achievement registers it.
I can also use .go creature id, gets me to the proper area but they're not around.

Is there a quick fix for this or something to look at in the DB ?
I could use .npc add but I think its dirty, and as the line already exists in the DB I am led to believe that a fix would be rather easy.

Thanks

 

[dolgan]

Hello,

[Location, Faction, Race]Outlands & Northrend
[Name, Type] NPCs, Rare
[Problem Description] Rares are not spawning in Outland & Northrend
[How it should work] Rares should be spawned at all time unless under respawn timer

I've noticed that some Rares are not spawning in Outland & Northrend.
First 3 I checked:
- 18677
- 18678
- 18679

I've checked a dozen in outlands and i'd say there's 50% of them missing. However in Northrend there's none at all.
I can't see them in gm mode either and this issue was not in v10

I can see that their references are here in the DB, yet they're not in-game.

I've tried using .npc add 18677 command, it works, the correct npc spawns and the achievement registers it.
I can also use .go creature id, gets me to the proper area but they're not around.

Is there a quick fix for this or something to look at in the DB ?
I could use .npc add but I think its dirty, and as the line already exists in the DB I am led to believe that a fix would be rather easy.

Thanks

Run this query for outland spawns

DELETE FROM pool_template WHERE entry BETWEEN 1073 AND 1085;
INSERT INTO pool_template (entry,max_limit,description) VALUES
(1073,1, 'Okrek Rare Spawn (1 out 4)'),
(1074,1, 'Ambassador Jerrikar Rare Spawn (1 out 5)'),
(1075,1, 'Okrek Rare Spawn (1 out 3)'),
(1076,1, 'Crippler Rare Spawn (1 out 1)'),
(1077,1, 'Doomsayer Jurim Rare Spawn (1 out 5)'),
(1078,1, 'Ever-Core the Punisher Rare Spawn (1 out 4)'),
(1079,1, 'Fulgore Rare Spawn (1 out 3)'),
(1080,1, 'Goretooth Rare Spawn (1 out 4)'),
(1081,1, 'Hemathion Rare Spawn (1 out 2)'),
(1082,1, 'Mekthorg the Wild Rare Spawn (1 out 2)'),
(1083,1, 'Speaker Margrom Rare Spawn (1 out 5)'),
(1084,1, 'Voidhunter Yar Rare Spawn (1 out 1)'),
(1085,1, 'Vorakem Doomspeaker Rare Spawn (1 out 4)');

 

[Blackvision]

Run this query for outland spawns

DELETE FROM pool_template WHERE entry BETWEEN 1073 AND 1085;
INSERT INTO pool_template (entry,max_limit,description) VALUES
(1073,1, 'Okrek Rare Spawn (1 out 4)'),
(1074,1, 'Ambassador Jerrikar Rare Spawn (1 out 5)'),
(1075,1, 'Okrek Rare Spawn (1 out 3)'),
(1076,1, 'Crippler Rare Spawn (1 out 1)'),
(1077,1, 'Doomsayer Jurim Rare Spawn (1 out 5)'),
(1078,1, 'Ever-Core the Punisher Rare Spawn (1 out 4)'),
(1079,1, 'Fulgore Rare Spawn (1 out 3)'),
(1080,1, 'Goretooth Rare Spawn (1 out 4)'),
(1081,1, 'Hemathion Rare Spawn (1 out 2)'),
(1082,1, 'Mekthorg the Wild Rare Spawn (1 out 2)'),
(1083,1, 'Speaker Margrom Rare Spawn (1 out 5)'),
(1084,1, 'Voidhunter Yar Rare Spawn (1 out 1)'),
(1085,1, 'Vorakem Doomspeaker Rare Spawn (1 out 4)');

You are en angle dolgan.
What should we do without you

Anything for Northrend :innocent:

 

[dolgan]

You are en angle dolgan.
What should we do without you

Anything for Northrend :innocent:

What would you do without me? :innocent:

For Northrend Rares (The one's not listed here already work)

DELETE FROM pool_template WHERE entry BETWEEN 1086 AND 1106;
INSERT INTO pool_template (entry,max_limit,description) VALUES
(1086,1, 'Old Crystalbark Rare Spawn (1 out 4)'),
(1087,1, 'Fumblub Gearwind Rare Spawn (1 out 1)'),
(1088,1, 'Icehorn Rare Spawn (1 out 3)'),
(1089,1, 'Crazed Indu''le Survivor Rare Spawn (1 out 1)'),
(1090,1, 'Scarlet Highlord Daion Rare Spawn (1 out 4)'),
(1091,1, 'Perobas the Boodthirster Rare Spawn (1 out 3)'),
(1092,1, 'Vigdis the War Maiden Rare Spawn (1 out 6)'),
(1093,1, 'King Ping Rare Spawn (1 out 5)'),
(1094,1, 'Tukemuth Rare Spawn (1 out 8)'),
(1095,1, 'Grocklar Rare Spawn (1 out 6)'),
(1096,1, 'Seething Hate Rare Spawn (1 out 3)'),
(1097,1, 'Syreian the Bonecarver Rare Spawn (1 out 6)'),
(1098,1, 'Hildana Deathstealer Rare Spawn (1 out 4)'),
(1099,1, 'High Thane Jorfus Rare Spawn (1 out 3)'),
(1100,1, 'Terror Spinner Rare Spawn (1 out 3)'),
(1101,1, 'Griegen Rare Spawn (1 out 7)'),
(1102,1, 'King Krush Rare Spawn (1 out 2)'),
(1103,1, 'Aotona Rare Spawn (1 out 6)'),
(1104,1, 'Dirkee Rare Spawn (1 out 4)'),
(1105,1, 'Putridus the Ancient Rare Spawn (1 out 5)'),
(1106,1, 'Zul Drak Sentinel Rare Spawn (1 out 2)');

 

[lolilolpoo]

Thanks a bunch !

Pushed both command sets, fixed the issue for Outlands and Northrend as expected.

 

[lolilolpoo]

Would it be possible to have the same command set for Cataclysm rares ? They are also missing in cata regions.

At some point probably the whole rare list is necessary ?

 

[dolgan]

Would it be possible to have the same command set for Cataclysm rares ? They are also missing in cata regions.

At some point probably the whole rare list is necessary ?

Sure, working on it now.
Most of them ARE there though.

Updates will be a bit slower now.
My holidays are over and I am back at work.