- 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 )
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:
