[DB/Events] Midsummer Fire Festival Spawns #1515

Closed
click opened this Issue May 16, 2011 · 7 comments

Comments

Projects
None yet
6 participants
Member

click commented May 16, 2011

Here's a list of the spawns of the Midsummer Fire Festival Flame Keepers/Flame Wardens and the bugs related.
NB: double spawn means that the npcs are spawned twice in the same location.

Eastern Kingdoms

  • Burning Steppes A: missing 25892

Kalimdor

  • Feralas A: missing 25899
  • Mulgore H: missing 25936
  • Azumeryst Isle A: missing 25888
  • Bloodmyst Isle A: missing 25891

Outland

  • Terokkar forest A: missing 25907
  • Shadowmoon valley A/H: missing 25938, 25905
  • Zangarmarsh A: missing 25912
  • Nagrand A: missing 25903
  • Blade's Edge A/H: missing 25889, 25926
  • Netherstorm A/H: missing 25913, 25918

Northrend

All spawns in Northrend are missing.
Borean Tundra: 32801, 32809
Sholazar Basin: 32810, 32802
Dragonblight: 32811, 32803
Howling Fjord: 32812, 32804
Grizzly Hills: 32813, 32805
Storm Peaks: 32814, 32806
Crystalsong Forest: 32815, 32807
Zul'Drak: 32816, 32808

Contributor

kaelima commented May 18, 2011

Good report, thank you.

@ghost ghost assigned kaelima May 18, 2011

Owner

Aokromes commented Jan 22, 2012

cleaned list, no need of report the correct ones :P

@ghost ghost assigned malcrom Nov 18, 2012

Aokromes added a commit that referenced this issue Feb 16, 2014

Owner

Aokromes commented Feb 16, 2014

Deleted dupe mobs, added ids of missing mobs.

raczman pushed a commit to raczman/TrinityCore that referenced this issue Apr 20, 2014

Owner

Aokromes commented Jun 9, 2014

Only 4.x sniffs avariable but they work for 3.3.5a

SET @cguid := xxxxxx;
(@cguid+0, 32801, 571, 1, 1, 4131.279, 5394.604, 26.09047, 3.595378, 120, 0, 0), -- 32801
(@cguid+1, 32809, 571, 1, 1, 4454.667, 5623.537, 56.91562, 4.13643, 120, 0, 0), -- 32809
(@cguid+2, 32810, 571, 1, 1, 5499.812, 4878.976, -197.8652, 3.176499, 120, 0, 0), -- 32810
(@cguid+3, 32802, 571, 1, 1, 5360.002, 4834.393, -196.3981, 5.550147, 120, 0, 0), -- 32802
(@cguid+4, 32811, 571, 1, 1, 3762.387, 1481.287, 92.8882, 3.438299, 120, 0, 0), -- 32811
(@cguid+5, 32803, 571, 1, 1, 3936.924, -595.4437, 241.1534, 5.951573, 120, 0, 0), -- 32803
(@cguid+6, 32812, 571, 1, 1, 2586.682, -4337.068, 276.0698, 4.13643, 120, 0, 0), -- 32812
(@cguid+7, 32804, 571, 1, 1, 2466.965, -4892.675, 262.5474, 2.303835, 120, 0, 0), -- 32804
(@cguid+8, 32813, 571, 1, 1, 3376.009, -2124.778, 124.664, 0.1396263, 120, 0, 0), -- 32813
(@cguid+9, 32805, 571, 1, 1, 3400.944, -2890.375, 201.4968, 2.303835, 120, 0, 0), -- 32805
(@cguid+10, 32814, 571, 1, 1, 6150.945, -1023.05, 408.3642, 1.43117, 120, 0, 0), -- 32814
(@cguid+11, 32806, 571, 1, 1, 6087.442, -1105.523, 418.2672, 1.099557, 120, 0, 0), -- 32806
(@cguid+12, 32815, 571, 1, 1, 5536.516, -733.7185, 149.6217, 3.124139, 120, 0, 0), -- 32815
(@cguid+13, 32807, 571, 1, 1, 5141.776, -685.0027, 170.2738, 5.951573, 120, 0, 0), -- 32807
(@cguid+14, 32816, 571, 1, 1, 5280.307, -2766.146, 292.5019, 2.303835, 120, 0, 0), -- 32816
(@cguid+15, 32808, 571, 1, 1, 5627.932, -2616.493, 292.5019, 1.518436, 120, 0, 0), -- 32808
(@cguid+16, 25892, 0, 1, 1, -8258.798, -2618.704, 133.3752, 1.343904, 120, 0, 0), -- 25892
(@cguid+17, 25899, 1, 1, 1, -4391.495, 2187.865, 12.22644, 5.864306, 120, 0, 0), -- 25899
(@cguid+18, 25936, 1, 1, 1, -2321.744, -619.7491, -9.089149, 5.67232, 120, 0, 0), -- 25936
(@cguid+19, 25888, 530, 1, 1, -4219.219, -12310.55, 2.439188, 5.934119, 120, 0, 0), -- 25888
(@cguid+20, 25891, 530, 1, 1, -2234.83, -11895.94, 26.62421, 4.694936, 120, 0, 0), -- 25891
(@cguid+21, 25907, 530, 1, 1, -2998.854, 4164.042, 5.169014, 0.5934119, 120, 0, 0), -- 25907
(@cguid+22, 25938, 530, 1, 1, -3067.278, 2387.903, 62.19349, 3.368485, 120, 0, 0), -- 25938
(@cguid+23, 25905, 530, 1, 1, -3951.305, 2045.65, 95.14804, 4.520403, 120, 0, 0), -- 25905
(@cguid+24, 25912, 530, 1, 1, 193.7309, 6016.713, 22.73373, 6.161012, 120, 0, 0), -- 25912
(@cguid+25, 25903, 530, 1, 1, -2517.064, 7555.085, -1.793157, 5.375614, 120, 0, 0), -- 25903
(@cguid+26, 25889, 530, 1, 1, 2024.906, 6590.532, 135.3214, 5.934119, 120, 0, 0), -- 25889
(@cguid+27, 25926, 530, 1, 1, 2286.707, 6137.618, 136.3056, 1.570796, 120, 0, 0), -- 25926
(@cguid+28, 25913, 530, 1, 1, 3127.551, 3743.148, 141.7706, 6.161012, 120, 0, 0), -- 25913
(@cguid+29, 25918, 530, 1, 1, 2917.222, 3693.411, 143.7703, 2.932153, 120, 0, 0), -- 25918

@Aokromes Aokromes closed this in 04d72fa Jun 25, 2014

Where can I find CGUID value? Thanks.

Member

tkrokli commented Jun 21, 2015

@MoonJeina : questions like that one belongs to the TrinityCore Forum pages. Anyway, look for the tool to find free GUIDs in the forum pages too, in the download section. (Before inserting any GUID values in a script, you have to find free and available GUID values.)

Ahh, now I understood completely. I thought we needed to use some spesific GUID, now I understand we need to use a free GUID. So, if the last GUID in database is 15000 for example, then I can use 15001 for insert this values. Thank you so much. :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment