Minor fixes for v14 05.04.2021

OMGhixD

Gold Supporter
Epic Member
522
2014
58
This release is rather minor but i do hope it helps and that it is of quality enough to be added. These were a few minor things i noticed while i was setting up the core locally.
I'll be committing more work by the time that passes by, should it be wanted of course :)

This resolves the following issues
Changelogs:
1.) Removes a Spell Value used in the DB that doesn't exist per the DBC
2.) Defias Overseers was set to a "null" AIName creature, and these dungeon creatures are usually ALWAYS SmartAI's unless they are a boss (Then we take use of a scriptname instead).
3.) Custom creature information was present in Creature_Template_Addon even tho it doesn't exist in Creature_Template at all.
4.) Creature_Template_Addon doesn't like it when we use 0's as auras as it does still count it as a probable ID, thus it was changed to "nothing"
5.) Removed data from Creature_Formations which holds info for 2 LeaderGuids and about 18 followup MemberGuids (None of these are spawned, thus that data is also unused and just throws a console error)
6.) Removed a duplicate Den Grunt in Valley of Trials and gave the remaining Den Grunt its proper Waypoints, MovementType and a Path_ID.
7.) Removed a Duplicate Cactus Apple gameobject which is used in the quest Calgar's Cactus Apple Surprise (more of these dupes might exist and we should expect that they do, Keep a lookout for them :) )


SQL:
-- Spell Doesnt Exist in DBC (Per console this is skipped)
DELETE FROM `disables` WHERE `sourceType`=0 AND `entry`=25584;

-- Dungeon Creature Defias Overseer (This creature is a SmartAI).
UPDATE `creature_template` SET AIName = 'SmartAI' WHERE `entry` =48421;

-- Creature does not exist but has a record in Creature_Template_Addon
DELETE FROM `creature_template_addon` WHERE `entry`=190000;

-- Doesnt like 0 - We use nothing instead
UPDATE `creature_template_addon` SET auras = "" WHERE `entry`=49539;
UPDATE `creature_template_addon` SET auras = "" WHERE `entry`=49535;
UPDATE `creature_template_addon` SET auras = "" WHERE `entry`=39731;

-- None of these GUIDs exist, this data shouldnt be present.
DELETE FROM `creature_formations` WHERE `leaderGUID` =242888;
DELETE FROM `creature_formations` WHERE `leaderGUID` =242889;

-- Adding proper waypoint for Den Grunt and MovementType to support it.
UPDATE `creature` SET `MovementType` = 2 WHERE `guid` = 81770;
-- Waypoint Data for Den Grunt
DELETE FROM `waypoint_data` WHERE `id` =81770;
INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `inverse_formation_angle`, `wpguid`) VALUES
(81770, 1, -600.287, -4350.52, 38.1624, 0, 0, 0, 0, 100, 0, 0),
(81770, 2, -602.112, -4394.73, 42.5741, 0, 0, 0, 0, 100, 0, 0),
(81770, 3, -597.704, -4417.01, 43.1964, 0, 0, 0, 0, 100, 0, 0),
(81770, 4, -584.362, -4449.36, 41.6141, 0, 0, 0, 0, 100, 0, 0),
(81770, 5, -572.001, -4474.46, 42.4255, 0, 0, 0, 0, 100, 0, 0),
(81770, 6, -568.071, -4492.65, 42.566, 0, 0, 0, 0, 100, 0, 0),
(81770, 7, -590.048, -4523.82, 41.6343, 0, 0, 0, 0, 100, 0, 0),
(81770, 8, -570.072, -4500.35, 42.5662, 0, 0, 0, 0, 100, 0, 0),
(81770, 9, -570.904, -4476.55, 42.5041, 0, 0, 0, 0, 100, 0, 0),
(81770, 10, -599.212, -4410.17, 43.6179, 0, 0, 0, 0, 100, 0, 0),
(81770, 11, -600.698, -4377.64, 39.9254, 0, 0, 0, 0, 100, 0, 0),
(81770, 12, -600.284, -4293.12, 37.8159, 0, 0, 0, 0, 100, 0, 0),
(81770, 13, -599.563, -4323.3, 37.5985, 0, 0, 0, 0, 100, 0, 0);
-- Adding path_id etc to the appropriate creature and ensuring clean data
DELETE FROM `creature_addon` WHERE `guid`=81770;
INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`, `VisibilityDistanceType`) VALUES (81770, 81770, 0, 0, 0, 0, NULL, -1);

-- Duplicate removal of Den Grunt which was is fixed in query above.
DELETE FROM `creature` WHERE `guid`=63011;
DELETE FROM `creature_addon` WHERE `guid`=63011;

-- Duplicate Cactus Apple Gameobject
DELETE FROM `gameobject` WHERE `guid`=13142;
 
Last edited:

ExO

Admin
5,084
2014
1,442
Awesome! It's great when people want to contribute too - it really helps everyone. Thanks!
Guys - make sure to show your appreciation to "OMGhixD" as well! :)
 

Jenniy

I collect profile flairs.
Silver Supporter
Senior User
351
2020
70
Magnificent! These community fixes and contributions are one of the biggest reasons why EmuCoach as a whole is so great! Thank you for these DB updates OMGhixD, they are always very much appreciated!
 

Kein666

Gold Supporter
Veteran Member
95
2019
47
Thank You very much @OMGhixD !
All these lines go in "World" and executes, right?
 

OMGhixD

Gold Supporter
Epic Member
522
2014
58
Thanks mate ?
We need more people like you and Dolgan
Awesome! It's great when people want to contribute too - it really helps everyone. Thanks!
Guys - make sure to show your appreciation to "OMGhixD" as well! :)
thanks you very much =)
Thank You very much @OMGhixD !
All these lines go in "World" and executes, right?
Thanks OMGhixD! Love your avatar and your attention to the details!

Ohh woaw! Did not expect this much. You all and this community is truly wholesome <3
 
Top