[LF] Need DB developers for the Emucoach repack projects
What's new

Quest Crawfish Creole fix 7.02

eyerobot

eyerobot

Gold Supporter
Superior Member
916
2015
24
Location
Barryton Michigan USA
No crawfish were spawned, And they were attackable, Not lootable.

Placement of crawfish
Code: 
DELETE FROM `creature` WHERE `guid`=717896;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (717896, 42548, 1, 1637, 5168, 1, 65535, 0, 0, 1990.14, -4659.83, 20.8678, 4.81456, 300, 0, 0, 55, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=717897;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (717897, 42548, 1, 1637, 5168, 1, 65535, 0, 0, 2002.32, -4651.93, 21.6676, 0.989668, 300, 0, 0, 55, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=717905;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (717905, 42548, 1, 1637, 5168, 1, 65535, 0, 0, 2025.08, -4763.88, 22.1869, 4.9834, 300, 0, 0, 86, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=717900;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (717900, 42548, 1, 1637, 5168, 1, 65535, 0, 0, 1965.67, -4700.94, 22.6149, 3.63254, 300, 0, 0, 86, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=717904;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (717904, 42548, 1, 1637, 5168, 1, 65535, 0, 0, 2022.52, -4745.57, 23.2345, 6.24397, 300, 0, 0, 55, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=717901;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (717901, 42548, 1, 1637, 5168, 1, 65535, 0, 0, 1974.46, -4705.16, 22.2822, 5.28973, 300, 0, 0, 42, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=717903;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (717903, 42548, 1, 1637, 5168, 1, 65535, 0, 0, 2000.82, -4733.9, 23.6461, 5.2426, 300, 0, 0, 86, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=717893;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (717893, 42548, 1, 1637, 5168, 1, 65535, 0, 0, 2039.25, -4593.31, 32.8365, 6.26754, 300, 0, 0, 55, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=717891;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (717891, 42548, 1, 1637, 5168, 1, 65535, 0, 0, 1996.3, -4598.84, 32.1608, 0.137505, 300, 0, 0, 55, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=717892;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (717892, 42548, 1, 1637, 5168, 1, 65535, 0, 0, 2011.21, -4596.02, 32.3346, 0.208192, 300, 0, 0, 102, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=717894;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (717894, 42548, 1, 1637, 5168, 1, 65535, 0, 0, 1990.54, -4621.67, 23.8785, 5.00698, 300, 0, 0, 71, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=717895;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (717895, 42548, 1, 1637, 5168, 1, 65535, 0, 0, 1988.92, -4642.96, 18.6633, 4.48863, 300, 0, 0, 71, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=717899;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (717899, 42548, 1, 1637, 5168, 1, 65535, 0, 0, 1981.17, -4694.15, 23.2065, 3.91529, 300, 0, 0, 86, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=717902;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (717902, 42548, 1, 1637, 5168, 1, 65535, 0, 0, 1984.82, -4716.07, 23.3854, 5.65493, 300, 0, 0, 86, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=717898;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (717898, 42548, 1, 1637, 5168, 1, 65535, 0, 0, 1996.26, -4673.18, 22.6171, 4.12341, 300, 0, 0, 86, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=78665;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (78665, 42548, 1, 0, 0, 1, 1, 32939, 0, 1951.35, -4342.41, 24.026, 5.49977, 90, 10, 0, 55, 0, 1, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=75427;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (75427, 42548, 1, 0, 0, 1, 1, 0, 0, 1892.57, -4342.83, 24.4566, 3.61622, 90, 0, 0, 1, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=75416;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (75416, 42548, 1, 0, 0, 1, 1, 0, 0, 1940.64, -4335.13, 24.0742, 1.70654, 90, 0, 0, 1, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=717906;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (717906, 42548, 1, 1637, 5168, 1, 65535, 0, 0, 2037.5, -4770.56, 23.7888, 5.9887, 300, 0, 0, 71, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=717907;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (717907, 42548, 1, 1637, 5168, 1, 65535, 0, 0, 2029.55, -4785.04, 23.5609, 4.08019, 300, 0, 0, 42, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=717908;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (717908, 42548, 1, 1637, 5168, 1, 65535, 0, 0, 2038.85, -4797.83, 23.3933, 5.62348, 300, 0, 0, 55, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=717909;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (717909, 42548, 1, 1637, 5168, 1, 65535, 0, 0, 2039.59, -4812.17, 23.736, 4.44147, 300, 0, 0, 102, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=717910;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (717910, 42548, 1, 1637, 5168, 1, 65535, 0, 0, 2033.19, -4825.28, 25.2508, 4.3158, 300, 0, 0, 86, 0, 0, 0, 0, 0, 0);

Set creature flags
Code: 
DELETE FROM `creature_template` WHERE `entry`=42548;
INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `exp_unk`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `speed_swim`, `speed_fly`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `type_flags2`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `currencyId`, `currencyCount`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Mana_mod_extra`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (42548, 0, 0, 0, 0, 0, 32939, 32941, 32940, 32942, 'Muddy Crawfish', '', 'LootAll', 0, 1, 5, 0, 0, 190, 190, 1, 1, 1.14286, 1, 1.14286, 1, 0, 5, 7, 0, 32, 1, 2000, 2000, 1, 33536, 2048, 2048, 0, 0, 0, 0, 0, 5, 7, 32, 1, 0, 0, 42548, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 'SmartAI', 0, 1, 0, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '', 13623);

Smartscripts
Code: 
DELETE FROM `smart_scripts` WHERE `entryorguid`=42548 AND `source_type`=0 AND `id`=0 AND `link`=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 (42548, 0, 0, 1, 64, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Muddy Crawfish on Gossip Hello - Gossip Close');
DELETE FROM `smart_scripts` WHERE `entryorguid`=42548 AND `source_type`=0 AND `id`=1 AND `link`=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 (42548, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 56, 57765, 1, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Muddy Crawfish on Gossip Hello - Add Item');
DELETE FROM `smart_scripts` WHERE `entryorguid`=42548 AND `source_type`=0 AND `id`=2 AND `link`=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 (42548, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 41, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Muddy Crawfish on Gossip Hello - Despawn Self');
DELETE FROM `smart_scripts` WHERE `entryorguid`=42548 AND `source_type`=0 AND `id`=3 AND `link`=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 (42548, 0, 3, 0, 64, 0, 100, 0, 0, 0, 0, 0, 72, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Muddy Crawfish on Gossip Hello - Gossip Close without quest');
 
Last edited:
You must log in or register to reply here.
Top