Trinitycore: DB/Misc: Hinterlands
Description:
- Add spells/abilities for Savage Owlbeast, Jalinde Summerdrake, Razorbeak Skylord, Grimungous and Shadra
- Add "Call For Help" ability for Silvermane Howler
- Add "Flee on low health" for Highvale Ranger
- Add emote text for Witherbark Zealot and fix health % at which they cast "Enrage"
- Add waypoint movement for Witherheart the Stalker
- Delete wrong spawn for Elder Gray Bear -- What the hell is doing that bear in the Hinterlands? (.go creature 14873)
- Other minor fixes
Branch(es):
3.3.5
TC rev. hash/commit:
TrinityCore rev. 9fa6885 2017-08-08 11:36:46 -0300 (3.3.5 branch) (Win64, Release, Static) (worldserver-daemon)
TDB version: 335.63
Operating system: Windows 7
Suggested Fix:
``sql
-- Zukk'ash Stinger
DELETE FROMsmart_scriptsWHEREentryorguid=5244 ANDsource_type=0 ANDidIN (1,2);
INSERT INTOsmart_scripts(entryorguid,source_type,id,link,event_type,event_phase_mask,event_chance,event_flags,event_param1,event_param2,event_param3,event_param4,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_x,target_y,target_z,target_o,comment`) VALUES
(5244,0,1,0,2,0,100,1,0,15,0,0,11,17170,0,0,0,0,0,2,0,0,0,0,0,0,0,"Zukk'ash Stinger - Between 0-15% Health - Cast Fatal Sting (No Repeat)"),
(5244,0,2,0,2,0,100,1,0,15,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Zukk'ash Stinger - Between 0-15% Health - Say Line 0 (No Repeat)");
DELETE FROM creature_text WHERE CreatureID=5244;
INSERT INTO creature_text (CreatureID, GroupID, ID, Text, Type, Language, Probability, Emote, Duration, Sound, BroadcastTextId, TextRange, comment) VALUES
(5244,0,0,"%s prepares to sting its victim as a last desperate move!",16,0,100,0,0,0,3713,0,"Zukk'ash Stinger");
-- Krellack
DELETE FROM smart_scripts WHERE entryorguid=14476 AND source_type=0;
INSERT INTO smart_scripts (entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o, comment) VALUES
(14476,0,0,0,2,0,100,0,0,15,8000,12000,11,17170,0,0,0,0,0,2,0,0,0,0,0,0,0,"Krellack - Between 0-15% Health - Cast Fatal Sting");
-- Silvermane Howler
DELETE FROM smart_scripts WHERE entryorguid=2925 AND source_type=0 AND id=2;
INSERT INTO smart_scripts (entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o, comment) VALUES
(2925,0,2,0,2,0,100,1,0,50,0,0,39,30,1,0,0,0,0,1,0,0,0,0,0,0,0,"Silvermane Howler - Between 0-50% Health - Call For Help (No Repeat)");
-- Vicious Owlbeast
DELETE FROM smart_scripts WHERE entryorguid=2927 AND source_type=0;
INSERT INTO smart_scripts (entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o, comment) VALUES
(2927,0,0,0,12,0,100,0,0,20,14000,18000,11,7938,0,0,0,0,0,2,0,0,0,0,0,0,0,"Vicious Owlbeast - Target Between 0-20% Health - Cast Fatal Bite");
-- Savage Owlbeast
UPDATE creature_template SET AIName="SmartAI" WHERE entry=2929;
DELETE FROM smart_scripts WHERE entryorguid=2929 AND source_type=0;
INSERT INTO smart_scripts (entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o, comment) VALUES
(2929,0,0,0,12,0,100,0,0,20,14000,18000,11,7938,0,0,0,0,0,2,0,0,0,0,0,0,0,"Savage Owlbeast - Target Between 0-20% Health - Cast Fatal Bite");
-- Jalinde Summerdrake
UPDATE creature_template SET AIName="SmartAI" WHERE entry=8214;
DELETE FROM smart_scripts WHERE entryorguid=8214 AND source_type=0;
INSERT INTO smart_scripts (entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o, comment) VALUES
(8214,0,0,0,0,0,100,0,0,0,2300,3900,11,6660,64,0,0,0,0,2,0,0,0,0,0,0,0,"Jalinde Summerdrake - In Combat CMC - Cast Shoot"),
(8214,0,1,0,9,0,100,0,5,30,9000,13000,11,15495,0,0,0,0,0,5,0,0,0,0,0,0,0,"Jalinde Summerdrake - Within 5-30 Range - Cast Explosive Shot"),
(8214,0,2,0,0,0,100,0,3000,5000,15000,21000,11,8806,32,0,0,0,0,5,0,0,0,0,0,0,0,"Jalinde Summerdrake - In Combat - Cast Poisoned Shot");
-- Highvale Ranger
DELETE FROM smart_scripts WHERE entryorguid=2694 AND source_type=0 AND id=1;
INSERT INTO smart_scripts (entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o, comment) VALUES
(2694,0,1,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Highvale Ranger - Between 0-15% Health - Flee For Assist (No Repeat)");
-- Witherbark Zealot
DELETE FROM smart_scripts WHERE entryorguid=2650 AND source_type=0;
INSERT INTO smart_scripts (entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o, comment) VALUES
(2650,0,0,0,2,0,100,1,0,50,0,0,11,8599,0,0,0,0,0,1,0,0,0,0,0,0,0,"Witherbark Zealot - Between 0-50% Health - Cast Enrage (No Repeat)"),
(2650,0,1,0,2,0,100,1,0,50,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Witherbark Zealot - Between 0-50% Health - Say Line 0 (No Repeat)");
DELETE FROM creature_text WHERE CreatureID=2650;
INSERT INTO creature_text (CreatureID, GroupID, ID, Text, Type, Language, Probability, Emote, Duration, Sound, BroadcastTextId, TextRange, comment) VALUES
(2650,0,0,"%s becomes enraged!",16,0,100,0,0,0,10677,0,"Witherbark Zealot");
-- Razorbeak Skylord
UPDATE creature_template SET AIName="SmartAI" WHERE entry=2659;
DELETE FROM smart_scripts WHERE entryorguid=2659 AND source_type=0;
INSERT INTO smart_scripts (entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o, comment) VALUES
(2659,0,0,0,0,0,100,0,8000,12000,12000,16000,11,11019,0,0,0,0,0,1,0,0,0,0,0,0,0,"Razorbeak Skylord - In Combat - Cast Wing Flap"),
(2659,0,1,0,9,0,100,0,0,5,15000,19000,11,3147,0,0,0,0,0,2,0,0,0,0,0,0,0,"Razorbeak Skylord - Within 0-5 Range - Cast Rend Flesh");
-- Grimungous
UPDATE creature_template SET AIName="SmartAI" WHERE entry=8215;
DELETE FROM smart_scripts WHERE entryorguid=8215 AND source_type=0;
INSERT INTO smart_scripts (entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o, comment) VALUES
(8215,0,0,0,0,0,100,0,6000,9000,9000,13000,11,5568,0,0,0,0,0,1,0,0,0,0,0,0,0,"Grimungous - In Combat - Cast Trample"),
(8215,0,1,0,9,0,100,0,0,5,14000,20000,11,11876,0,0,0,0,0,1,0,0,0,0,0,0,0,"Grimungous - Within 0-5 Range - Cast War Stomp");
-- Shadra
UPDATE creature_template SET AIName="SmartAI" WHERE entry=2707;
DELETE FROM smart_scripts WHERE entryorguid=2707 AND source_type=0;
INSERT INTO smart_scripts (entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o, comment) VALUES
(2707,0,0,0,25,0,100,0,0,0,0,0,11,13299,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadra - On Reset - Cast Poison Proc"),
(2707,0,1,0,25,0,100,0,0,0,0,0,11,8601,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadra - On Reset - Cast Slowing Poison"),
(2707,0,2,0,9,0,100,0,0,10,9000,10000,11,28991,0,0,0,0,0,5,0,0,0,0,0,0,0,"Shadra - Within 0-10 Range - Cast Web");
-- Fix bytes2 for some creatures
UPDATE creature_template_addon SET bytes2=2 WHERE entry IN (2693,2691);
-- Delete wrong spawn for Elder Gray Bear
DELETE FROM creature WHERE guid=14873;
-- Add random movement for some creatures
UPDATE creature SET spawndist=5, MovementType=1 WHERE guid IN (69119,69117);
-- Pathing for Witherheart the Stalker
UPDATE creature SET MovementType=2 WHERE guid=85478;
DELETE FROM creature_addon WHERE guid=85478;
INSERT INTO creature_addon (guid, path_id, mount, bytes1, bytes2, emote, auras) VALUES
(85478,854780,0,0,1,0,"");
DELETE FROM waypoint_data WHERE id=854780;
INSERT INTO waypoint_data (id, point, position_x, position_y, position_z, orientation, delay, move_type, action, action_chance, wpguid) VALUES
(854780,1,-336.731,-2833.29,77.0363,0,0,0,0,100,0),
(854780,2,-334.463,-2814.89,80.383,0,0,0,0,100,0),
(854780,3,-348.051,-2805.34,80.0625,0,0,0,0,100,0),
(854780,4,-364.007,-2805.31,76.9893,0,0,0,0,100,0),
(854780,5,-376.958,-2796.97,77.4724,0,0,0,0,100,0),
(854780,6,-394.72,-2805.83,77.8546,0,0,0,0,100,0),
(854780,7,-390.019,-2822.94,74.1284,0,0,0,0,100,0),
(854780,8,-389.906,-2837.06,74.2824,0,0,0,0,100,0),
(854780,9,-402.354,-2843.73,76.9459,0,0,0,0,100,0),
(854780,10,-416.467,-2844.41,79.3868,0,0,0,0,100,0),
(854780,11,-421.565,-2852.64,79.3284,0,0,0,0,100,0),
(854780,12,-421.623,-2874.12,83.6468,0,0,0,0,100,0),
(854780,13,-428.279,-2885.91,84.8522,0,0,0,0,100,0),
(854780,14,-417.871,-2899.71,83.2011,0,0,0,0,100,0),
(854780,15,-421.714,-2912.49,82.035,0,0,0,0,100,0),
(854780,16,-409.008,-2915.46,80.4308,0,0,0,0,100,0),
(854780,17,-398.058,-2912.56,79.2019,0,0,0,0,100,0),
(854780,18,-388.929,-2926.26,77.9069,0,0,0,0,100,0),
(854780,19,-376.519,-2927.69,75.9121,0,0,0,0,100,0),
(854780,20,-372.09,-2931.3,75.3061,0,0,0,0,100,0),
(854780,21,-354.46,-2929.29,75.2535,0,0,0,0,100,0),
(854780,22,-339.972,-2930.95,76.0707,0,0,0,0,100,0),
(854780,23,-326.085,-2943.36,78.7858,0,0,0,0,100,0),
(854780,24,-313.89,-2944.59,80.8206,0,0,0,0,100,0),
(854780,25,-305.916,-2935.44,82.1426,0,0,0,0,100,0),
(854780,26,-307.534,-2917.76,80.3467,0,0,0,0,100,0),
(854780,27,-298.165,-2903.94,81.5407,0,0,0,0,100,0),
(854780,28,-301.296,-2890.28,81.1735,0,0,0,0,100,0),
(854780,29,-310.921,-2881.96,79.6081,0,0,0,0,100,0),
(854780,30,-313.692,-2872.43,80.082,0,0,0,0,100,0),
(854780,31,-312.576,-2859.04,80.4389,0,0,0,0,100,0),
(854780,32,-320.584,-2852.24,78.3489,0,0,0,0,100,0),
(854780,33,-336.88,-2851.17,77.2118,0,0,0,0,100,0);
ZenoX92
All 9 comments
(2707,0,0,0,0,0,100,0,6000,9000,15000,20000,11,13298,0,0,0,0,0,5,0,0,0,0,0,0,0,"Shadra - In Combat - Cast Poison"),
(2707,0,1,0,0,0,100,0,2000,4000,22000,26000,11,7992,0,0,0,0,0,5,0,0,0,0,0,0,0,"Shadra - In Combat - Cast Slowing Poison"),
http://www.wowhead.com/spell=13299/poison-proc
http://www.wowhead.com/spell=8601/slowing-poison
A ton of similar spells never used with timers. Also better to put them in c_t_a
You can use https://github.com/TrinityCore/TDB_4.3.4_NLU to check sometimes if creature has auras like thrash, poison proc and other similar.
offl
on 9 Jan 2018
Thanks to both of you for contributing and solving these issues.. I never noticed much of them myself, but then again, I never put much work into it.
I do appreciate your work in looking up this information and verifying how it should be. 馃憤
ghost
on 9 Jan 2018
https://pastebin.com/GyaKRXAy
This is incomplete list of all auras for TBC. Sorry, but I'm too lazy to sort them.
Some of them are guessed, some from ACID, TDB 4.3.4, from SAI(converted from SAI to c_t_a).
"Guessed" means here that there's multiple similar auras(Poison Proc, Thrash, for example), their chance to proc is different. But we can't sniff these auras anymore, so sometimes one random is used(if creature has small level, he will use aura with small chance to proc).
offl
on 9 Jan 2018
Thanks for the info, @offl. I will have it in mind next time. For now, I updated the script for Shadra to use the auras you pointed out.
ZenoX92
on 9 Jan 2018
Delete wrong spawn for Elder Gray Bear -- What the hell is doing that bear in the Hinterlands? (.go creature 14873)
Not only wrong zone or area, but it also seems to be spawned into the terrain (teleporting to that creature will be safer if both .gm on and .gm fly on is used first on the GM character). I think maybe the spawn has got one of the X or Y coordinates wrong in the creature table. Need to investigate that and see if that spawn has got a missing - sign either in the X or Y coordinates.
SELECT * FROM `creature` WHERE `id`=2356 ORDER BY `position_x`;
guid id map zoneId areaId spawnMask phaseMask modelid equipment_id position_x position_y position_z orientation spawntimesecs spawndist currentwaypoint curhealth curmana MovementType npcflag unit_flags dynamicflags ScriptName VerifiedBuild
----- ------ ------ ------ ------ --------- --------- ------- ------------ ---------- ---------- ---------- ----------- ------------- --------- --------------- --------- ------- ------------ ------- ---------- ------------ ---------- -------------
15417 2356 0 0 0 1 1 3201 0 -1026.78 -1235.22 55.3446 4.40132 300 10 0 944 0 1 0 0 0 0
15496 2356 0 0 0 1 1 3201 0 -1022.24 -1328.58 55.315 4.77665 300 10 0 944 0 1 0 0 0 0
14865 2356 0 0 0 1 1 3201 0 -1018.39 -1398.95 56.5173 0.450548 300 10 0 944 0 1 0 0 0 0
14860 2356 0 0 0 1 1 3201 0 -1010.29 142.993 57.5302 2.38511 300 10 0 944 0 1 0 0 0 0
15739 2356 0 0 0 1 1 3201 0 -1001.48 -140.175 16.1595 3.18454 300 5 0 944 0 1 0 0 0 0
15420 2356 0 0 0 1 1 3201 0 -999.128 -1244.96 55.4553 4.97112 300 10 0 944 0 1 0 0 0 0
14866 2356 0 0 0 1 1 3201 0 -999.111 120.493 54.7334 5.92174 300 10 0 944 0 1 0 0 0 0
15402 2356 0 0 0 1 1 3201 0 -990.571 88.243 52.563 6.07851 300 10 0 944 0 1 0 0 0 0
15448 2356 0 0 0 1 1 3201 0 -975.31 6.93124 33.4362 2.66478 300 10 0 944 0 1 0 0 0 0
15358 2356 0 0 0 1 1 3201 0 -973.241 -54.3898 21.0261 5.02128 300 3 0 944 0 1 0 0 0 0
15855 2356 0 0 0 1 1 3201 0 -953.82 -309.01 57.5317 4.8061 300 10 0 944 0 1 0 0 0 0
15849 2356 0 0 0 1 1 3201 0 -942.348 125.093 45.2666 3.97392 300 10 0 944 0 1 0 0 0 0
16454 2356 0 0 0 1 1 3201 0 -940.448 -157.44 55.1219 4.45556 300 3 0 944 0 1 0 0 0 0
15458 2356 0 0 0 1 1 3201 0 -931.532 -1205 52.6331 3.82457 300 10 0 944 0 1 0 0 0 0
15464 2356 0 0 0 1 1 3201 0 -921.308 -1268.8 51.6933 1.67843 300 10 0 944 0 1 0 0 0 0
15345 2356 0 0 0 1 1 3201 0 -913.083 -62.5935 20.6685 1.84806 300 10 0 944 0 1 0 0 0 0
15675 2356 0 0 0 1 1 3201 0 -910.833 -1111.2 48.4799 1.06256 300 10 0 944 0 1 0 0 0 0
16484 2356 0 0 0 1 1 3201 0 -901.496 -217.981 49.357 3.21387 300 5 0 944 0 1 0 0 0 0
16489 2356 0 0 0 1 1 3201 0 -884.18 -50.4254 23.0071 1.49247 300 10 0 944 0 1 0 0 0 0
15991 2356 0 0 0 1 1 3201 0 -881.253 -379.278 23.3121 0.646431 300 10 0 944 0 1 0 0 0 0
16036 2356 0 0 0 1 1 3201 0 -877.319 -1290.6 50.9381 0.886684 300 10 0 944 0 1 0 0 0 0
15572 2356 0 0 0 1 1 3201 0 -855.191 -1469.6 58.4068 5.11395 300 5 0 944 0 1 0 0 0 0
15351 2356 0 0 0 1 1 3201 0 -845.23 -136.44 33.2369 5.75047 300 5 0 944 0 1 0 0 0 0
15990 2356 0 0 0 1 1 3201 0 -844.534 -263.891 37.0155 3.08047 300 0 0 944 0 0 0 0 0 0
15657 2356 0 0 0 1 1 3201 0 -831.404 291.294 41.6835 2.77103 300 10 0 944 0 1 0 0 0 0
15863 2356 0 0 0 1 1 3201 0 -829.649 -372.96 19.0983 4.17532 300 10 0 944 0 1 0 0 0 0
16037 2356 0 0 0 1 1 3201 0 -826.047 -1334.96 63.2817 3.16453 300 5 0 944 0 1 0 0 0 0
15409 2356 0 0 0 1 1 3201 0 -818.808 -216.651 35.1432 0.211719 300 0 0 944 0 0 0 0 0 0
15296 2356 0 0 0 1 1 3201 0 -809.068 -207.296 35.9963 2.03183 300 5 0 944 0 1 0 0 0 0
15381 2356 0 0 0 1 1 3201 0 -807.772 -36.9599 28.1008 0.910693 300 10 0 944 0 1 0 0 0 0
15820 2356 0 0 0 1 1 3201 0 -805.364 91.4179 37.0051 0.160089 300 5 0 944 0 1 0 0 0 0
16458 2356 0 0 0 1 1 3201 0 -803.369 -428.865 17.0093 3.36214 300 10 0 944 0 1 0 0 0 0
15823 2356 0 0 0 1 1 3201 0 -781.78 127.34 43.5662 5.31015 300 10 0 944 0 1 0 0 0 0
15883 2356 0 0 0 1 1 3201 0 -780.306 29.5933 33.9577 4.48398 300 5 0 944 0 1 0 0 0 0
15281 2356 0 0 0 1 1 3201 0 -776.073 -1424.26 64.9163 5.53653 300 10 0 944 0 1 0 0 0 0
15647 2356 0 0 0 1 1 3201 0 -758.306 -49.6266 30.1268 0.251464 300 10 0 944 0 1 0 0 0 0
15399 2356 0 0 0 1 1 3201 0 -755.428 243.031 47.8912 0.502929 300 10 0 944 0 1 0 0 0 0
15393 2356 0 0 0 1 1 3201 0 -751.606 -1604.24 54.3439 4.05637 300 3 0 944 0 1 0 0 0 0
15837 2356 0 0 0 1 1 3201 0 -735.729 -180.585 37.4502 0.017576 300 5 0 944 0 1 0 0 0 0
15452 2356 0 0 0 1 1 3201 0 -723.421 -1241.92 59.0946 2.0372 300 5 0 944 0 1 0 0 0 0
15846 2356 0 0 0 1 1 3201 0 -722.575 86.4662 40.9657 0.475582 300 10 0 944 0 1 0 0 0 0
14892 2356 0 0 0 1 1 3201 0 -718.576 -1552.33 56.9426 4.26605 300 10 0 944 0 1 0 0 0 0
15494 2356 0 0 0 1 1 3201 0 -717.936 -1325.88 64.0866 1.32629 300 10 0 944 0 1 0 0 0 0
15431 2356 0 0 0 1 1 3201 0 -717.384 217.487 51.0391 6.15266 300 10 0 944 0 1 0 0 0 0
15861 2356 0 0 0 1 1 3201 0 -717.341 -307.902 18.2617 0.280982 300 10 0 944 0 1 0 0 0 0
15333 2356 0 0 0 1 1 3201 0 -716.667 -1450 64.7344 1.3221 300 10 0 944 0 1 0 0 0 0
16494 2356 0 0 0 1 1 3201 0 -716.492 145.898 45.0026 5.35679 300 10 0 944 0 1 0 0 0 0
15419 2356 0 0 0 1 1 3201 0 -711.968 280.62 50.3726 3.18022 300 10 0 944 0 1 0 0 0 0
14898 2356 0 0 0 1 1 3201 0 -708.808 -1564.22 57.1721 2.4516 300 10 0 944 0 1 0 0 0 0
15446 2356 0 0 0 1 1 3201 0 -694.844 260.69 49.3467 2.96819 300 10 0 944 0 1 0 0 0 0
15660 2356 0 0 0 1 1 3201 0 -685.863 -89.7957 42.4598 4.25747 300 10 0 944 0 1 0 0 0 0
16074 2356 0 0 0 1 1 3201 0 -680.857 -1181.33 61.6242 1.51216 300 10 0 944 0 1 0 0 0 0
15617 2356 0 0 0 1 1 3201 0 -680.263 -179.913 41.8462 0.680252 300 5 0 944 0 1 0 0 0 0
14844 2356 0 0 0 1 1 3201 0 -677.415 -1445.49 63.7163 4.78078 300 10 0 944 0 1 0 0 0 0
15389 2356 0 0 0 1 1 3201 0 -673.206 -953.951 34.3057 3.39414 300 5 0 944 0 1 0 0 0 0
15601 2356 0 0 0 1 1 3201 0 -654.437 -153.729 43.5559 3.50102 300 5 0 944 0 1 0 0 0 0
15677 2356 0 0 0 1 1 3201 0 -644.092 -929.563 35.8359 3.57468 300 10 0 944 0 1 0 0 0 0
16034 2356 0 0 0 1 1 3201 0 -629.613 -962.754 42.5213 1.86198 300 10 0 944 0 1 0 0 0 0
16500 2356 0 0 0 1 1 3201 0 -618.101 -251.71 43.6369 4.89906 300 5 0 944 0 1 0 0 0 0
15680 2356 0 0 0 1 1 3201 0 -615.59 -1021.85 66.6835 5.5116 300 5 0 944 0 1 0 0 0 0
14859 2356 0 0 0 1 1 3201 0 -614.494 -1673.26 61.3654 3.59475 300 10 0 944 0 1 0 0 0 0
16556 2356 0 0 0 1 1 3201 0 -612.918 -288.413 45.2608 1.32112 300 5 0 944 0 1 0 0 0 0
15482 2356 0 0 0 1 1 3201 0 -583.157 -950.196 40.9115 2.38018 300 10 0 944 0 1 0 0 0 0
15396 2356 0 0 0 1 1 3201 0 -521.376 -1813.02 64.3255 0 300 3 0 944 0 1 0 0 0 0
11580 2356 0 0 0 1 1 3201 0 -511.27 -1802.18 67.2102 1.2262 400 5 0 944 0 1 0 0 0 0
15421 2356 0 0 0 1 1 3201 0 -486.045 -1762.78 78.3197 1.89502 300 10 0 944 0 1 0 0 0 0
15459 2356 0 0 0 1 1 3201 0 -473.383 -1739.4 81.8203 3.91594 300 10 0 944 0 1 0 0 0 0
15377 2356 0 0 0 1 1 3201 0 -449.045 -1742.75 85.1255 3.34232 300 10 0 944 0 1 0 0 0 0
15375 2356 0 0 0 1 1 3201 0 -435.174 -1678.54 85.5527 6.15205 300 10 0 944 0 1 0 0 0 0
15868 2356 0 0 0 1 1 3201 0 -409.194 -1718.52 88.3221 4.35617 300 10 0 944 0 1 0 0 0 0
14886 2356 0 0 0 1 1 3201 0 -381.533 -1587.1 71.7978 0.121447 300 10 0 944 0 1 0 0 0 0
15506 2356 0 0 0 1 1 3201 0 -374.216 212.246 89.5004 2.10682 300 10 0 944 0 1 0 0 0 0
14890 2356 0 0 0 1 1 3201 0 -369.407 -1471.97 67.4952 3.72948 300 3 0 944 0 1 0 0 0 0
15631 2356 0 0 0 1 1 3201 0 -365.631 -1719.53 90.7495 1.79349 300 3 0 944 0 1 0 0 0 0
14891 2356 0 0 0 1 1 3201 0 -362.476 -1499.41 67.7939 0.686423 300 10 0 944 0 1 0 0 0 0
14888 2356 0 0 0 1 1 3201 0 -359.228 -1541.89 71.2492 0.271051 300 10 0 944 0 1 0 0 0 0
15391 2356 0 0 0 1 1 3201 0 -350.965 -1654.61 85.1407 5.41251 300 10 0 944 0 1 0 0 0 0
14862 2356 0 0 0 1 1 3201 0 -330.917 202.579 87.4494 0.784019 300 10 0 944 0 1 0 0 0 0
16055 2356 0 0 0 1 1 3201 0 -315.579 -82.5931 62.699 2.37479 300 10 0 944 0 1 0 0 0 0
15972 2356 0 0 0 1 1 3201 0 -314.518 -1318.04 73.0841 0.38232 300 10 0 944 0 1 0 0 0 0
15378 2356 0 0 0 1 1 3201 0 -311.404 -1644.78 91.9629 0.095784 300 10 0 944 0 1 0 0 0 0
15709 2356 0 0 0 1 1 3201 0 -300.846 -1447.99 83.7408 3.2296 300 10 0 944 0 1 0 0 0 0
15330 2356 0 0 0 1 1 3201 0 -287.524 124.381 72.8622 1.65296 300 10 0 944 0 1 0 0 0 0
15513 2356 0 0 0 1 1 3201 0 -278.076 -1385.03 86.8718 4.77371 300 10 0 944 0 1 0 0 0 0
15914 2356 0 0 0 1 1 3201 0 -257.809 -123.868 72.527 1.08276 300 10 0 944 0 1 0 0 0 0
16665 2356 0 0 0 1 1 3201 0 -257.786 163.965 81.7131 1.56264 300 10 0 944 0 1 0 0 0 0
16022 2356 0 0 0 1 1 3201 0 -254.389 -1408.28 95.1853 4.23043 300 10 0 944 0 1 0 0 0 0
14850 2356 0 0 0 1 1 3201 0 -231.367 150.752 71.9621 2.4934 300 10 0 944 0 1 0 0 0 0
16018 2356 0 0 0 1 1 3201 0 -230.366 -1294.41 98.5433 3.22765 300 5 0 944 0 1 0 0 0 0
15425 2356 0 0 0 1 1 3201 0 -218.005 -1152.81 47.0572 1.08909 300 10 0 944 0 1 0 0 0 0
15842 2356 0 0 0 1 1 3201 0 -185.838 -1326.63 101.229 1.40404 300 5 0 944 0 1 0 0 0 0
15723 2356 0 0 0 1 1 3201 0 -149.249 -1187.73 56.6616 2.70944 300 10 0 944 0 1 0 0 0 0
15467 2356 0 0 0 1 1 3201 0 -82.5978 -1282.8 87.5094 1.74943 300 5 0 944 0 1 0 0 0 0
15579 2356 0 0 0 1 1 3201 0 -77.5577 -1195.15 48.3649 1.48755 300 5 0 944 0 1 0 0 0 0
15563 2356 0 0 0 1 1 3201 0 -68.66 -1181.52 47.3617 4.32841 300 10 0 944 0 1 0 0 0 0
17307 2356 0 0 0 1 1 3201 0 -53.8835 351.264 62.5955 0.06163 300 10 0 944 0 1 0 0 0 0
16714 2356 0 0 0 1 1 3201 0 -45.5915 118.028 57.9524 0.005859 300 10 0 944 0 1 0 0 0 0
16767 2356 0 0 0 1 1 3201 0 -29.2921 29.8512 73.5496 4.59094 300 10 0 944 0 1 0 0 0 0
16810 2356 0 0 0 1 1 3201 0 -13.7593 91.8976 54.9062 1.65491 300 10 0 944 0 1 0 0 0 0
16753 2356 0 0 0 1 1 3201 0 43.7503 45.5611 57.517 1.69222 300 10 0 944 0 1 0 0 0 0
16729 2356 0 0 0 1 1 3201 0 60.749 88.7913 49.2333 0.688624 300 10 0 944 0 1 0 0 0 0
16667 2356 0 0 0 1 1 3201 0 81.7462 130.012 49.6645 4.44075 300 10 0 944 0 1 0 0 0 0
16975 2356 0 0 0 1 1 3201 0 86.9317 186.725 45.28 0.382359 300 10 0 944 0 1 0 0 0 0
16788 2356 0 0 0 1 1 3201 0 137.513 177.587 50.0034 2.8075 300 5 0 944 0 1 0 0 0 0
17309 2356 0 0 0 1 1 3201 0 209.326 188.713 44.1624 1.89949 300 10 0 944 0 1 0 0 0 0
16730 2356 0 0 0 1 1 3201 0 210.3 -8.49704 72.8186 2.48637 300 10 0 944 0 1 0 0 0 0
14873 2356 0 0 0 1 1 3201 0 280.125 -3029.01 97.3502 3.764 300 3 0 944 0 1 0 0 0 0
16675 2356 0 0 0 1 1 3201 0 292.679 82.2178 49.298 1.3452 300 10 0 944 0 1 0 0 0 0
16784 2356 0 0 0 1 1 3201 0 390.428 89.3012 46.2104 0.091897 300 5 0 944 0 1 0 0 0 0
I would like to check for these sniffs soon, but if one of the other TC members with experience of checking sniffs can find it, be my guest.
ghost
on 10 Jan 2018
https://github.com/TrinityCoreLegacy/TrinityCore/releases is far more updated than https://github.com/TrinityCore/TDB_4.3.4_NLU (NLU means no longer used)
Aokromes
on 10 Jan 2018
Delete wrong spawn for Elder Gray Bear -- What the hell is doing that bear in the Hinterlands? (.go creature 14873)
Quite possible he's not bad spawn.
offl
on 10 Jan 2018
Fair enough, but maybe that spawn should be corrected to stay above the surface and maybe appear in Arathi Highlands?
ghost
on 10 Jan 2018
There also a ton of spawns under textures, maybe it's normal for Blizzard. Just set InhabitType for all creatures to fly and teleport under map.
Maybe he should be replaced to NPC 2928. Coords: 279.772 -3053.82 117.608 2.71601
It's from cata.
offl
on 10 Jan 2018
Related issues
Tatara902
路
3Comments
Jildor
路
3Comments
Rochet2
路
3Comments
cbcs
路
3Comments
Rushor
路
3Comments
Most helpful comment
Thanks to both of you for contributing and solving these issues.. I never noticed much of them myself, but then again, I never put much work into it.
I do appreciate your work in looking up this information and verifying how it should be. 馃憤