Sign in to follow this  
Followers 0
Florix

[Accepted][Battle for Azeroth]: Pooped

2 posts in this topic

Title: Pooped
Bugtracker Link:


Patch Content:

 

Their faction is friendly, should be hostile.

https://www.wowhead.com/quest=31704/pooped
https://www.wowhead.com/quest=31716/pooped
https://www.wowhead.com/item=89052/tiny-bag-of-poop
https://www.wowhead.com/item=89053/big-bag-of-poop
https://www.wowhead.com/npc=65711/siftworm
https://www.wowhead.com/npc=67084/giant-siftworm
https://www.wowhead.com/object=214863/hatchling-poop
https://www.wowhead.com/object=214862/hatchling-poop

 

 

UPDATE `creature_template` SET `faction`='14' WHERE `entry` IN ('65711','67084');
DELETE FROM `creature_loot_template` WHERE `entry` IN ('65711','67084');
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `shared`) VALUES (65711, 82330, 34.221, 0, 0, 1, 1, 0);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `shared`) VALUES (65711, 89052, -52.964, 0, 0, 1, 1, 0);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `shared`) VALUES (65711, 89053, -18.0853, 0, 0, 1, 1, 0);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `shared`) VALUES (67084, -738, 0.8689, 0, 0, 1, 1, 0);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `shared`) VALUES (67084, 82330, 96.9046, 0, 0, 1, 1, 0);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `shared`) VALUES (67084, 82340, 2.6311, 0, 0, 1, 1, 0);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `shared`) VALUES (67084, 88567, 0.2752, 0, 0, 1, 1, 0);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `shared`) VALUES (67084, 89052, -44.5056, 0, 0, 1, 1, 0);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `shared`) VALUES (67084, 89053, -15.7696, 0, 0, 1, 1, 0);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `shared`) VALUES (67084, 89112, 9.166, 0, 0, 1, 1, 0);
DELETE FROM `gameobject` WHERE `id` IN ('214862','214863');
insert into `gameobject` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `AiID`, `state`, `isActive`, `personal_size`) values('214862','870','5785','5931','1','65535','','1511.02','-2495.22','156.03','1.9197','0','0','0.819106','0.573642','300','0','0','1','0','0');
insert into `gameobject` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `AiID`, `state`, `isActive`, `personal_size`) values('214862','870','5785','5931','1','65535','','1534.27','-2501.26','156.758','6.20797','0','0','0.0375966','-0.999293','300','0','0','1','0','0');
insert into `gameobject` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `AiID`, `state`, `isActive`, `personal_size`) values('214862','870','5785','5931','1','65535','','1510.15','-2521.32','155.258','0.914387','0','0','0.441432','0.897295','300','0','0','1','0','0');
insert into `gameobject` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `AiID`, `state`, `isActive`, `personal_size`) values('214862','870','5785','5931','1','65535','','1513.09','-2524.27','155.042','5.61107','0','0','0.329769','-0.944062','300','0','0','1','0','0');
insert into `gameobject` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `AiID`, `state`, `isActive`, `personal_size`) values('214862','870','5785','5931','1','65535','','1517.1','-2551.68','151.772','5.4697','0','0','0.395622','-0.918413','300','0','0','1','0','0');
insert into `gameobject` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `AiID`, `state`, `isActive`, `personal_size`) values('214862','870','5785','5931','1','65535','','1515.5','-2545.6','151.732','4.93563','0','0','0.623944','-0.781469','300','0','0','1','0','0');
insert into `gameobject` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `AiID`, `state`, `isActive`, `personal_size`) values('214862','870','5785','5931','1','65535','','1500.75','-2569.73','154.622','4.75106','0','0','0.693305','-0.720644','300','0','0','1','0','0');
insert into `gameobject` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `AiID`, `state`, `isActive`, `personal_size`) values('214862','870','5785','5931','1','65535','','1493.22','-2573.29','155.638','5.30476','0','0','0.469931','-0.882703','300','0','0','1','0','0');
insert into `gameobject` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `AiID`, `state`, `isActive`, `personal_size`) values('214862','870','5785','5931','1','65535','','1477.43','-2572.54','154.781','2.10033','0','0','0.867506','0.497426','300','0','0','1','0','0');
insert into `gameobject` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `AiID`, `state`, `isActive`, `personal_size`) values('214862','870','5785','5931','1','65535','','1461.1','-2565.37','151.372','4.01278','0','0','0.90662','-0.421948','300','0','0','1','0','0');
insert into `gameobject` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `AiID`, `state`, `isActive`, `personal_size`) values('214862','870','5785','5931','1','65535','','1453.15','-2566.98','150.258','4.46831','0','0','0.787929','-0.615767','300','0','0','1','0','0');
insert into `gameobject` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `AiID`, `state`, `isActive`, `personal_size`) values('214862','870','5785','5931','1','65535','','1453.12','-2541.23','151.31','0.926165','0','0','0.446708','0.89468','300','0','0','1','0','0');
insert into `gameobject` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `AiID`, `state`, `isActive`, `personal_size`) values('214862','870','5785','5931','1','65535','','1472.73','-2538.74','153.481','1.05576','0','0','0.503701','0.863878','300','0','0','1','0','0');
insert into `gameobject` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `AiID`, `state`, `isActive`, `personal_size`) values('214862','870','5785','5931','1','65535','','1474.55','-2533.75','153.477','1.12251','0','0','0.532251','0.846587','300','0','0','1','0','0');
insert into `gameobject` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `AiID`, `state`, `isActive`, `personal_size`) values('214862','870','5785','5931','1','65535','','1475.12','-2509.59','153.986','5.46969','0','0','0.395623','-0.918413','300','0','0','1','0','0');
insert into `gameobject` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `AiID`, `state`, `isActive`, `personal_size`) values('214862','870','5785','5931','1','65535','','1567.3','-2489.42','155.388','0.54132','0','0','0.267368','0.963595','300','0','0','1','0','0');
DELETE FROM `gameobject_loot_template` WHERE `entry` IN ('214862','214863');
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (214862, 89052, -95.6908, 1, 0, 1, 1);
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (214862, 89053, -4.154, 1, 0, 1, 1);
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (214863, 89053, -100, 1, 0, 1, 1);

 

 

Edited by Florix

Share this post


Link to post
Share on other sites

Greetings @Florix,

Your patch is accepted, thank you for contributing to Firestorm.

Regards, Thyvene.

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.
Sign in to follow this  
Followers 0