[Release] The NEXUS Instance FULL FIX

bulle7proof

New Member
Joined
Feb 10, 2009
Messages
344
Reaction score
68
Here is a fix of the npcs in nexus!

--Azure Scale-Binder

Code:
DELETE FROM `creature_loot_template` WHERE (`entry`=26735);
INSERT INTO `creature_loot_template` VALUES 
(26735, 33360, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 33361, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 33363, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 33366, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 33375, 0.3527, 0, 1, 1, 0, 0, 0),
(26735, 33377, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 33378, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 33390, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 33391, 0.3527, 0, 1, 1, 0, 0, 0),
(26735, 33392, 0.3527, 0, 1, 1, 0, 0, 0),
(26735, 33394, 3.5273, 0, 1, 1, 0, 0, 0),
(26735, 33405, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 33407, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 33409, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 33410, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 33424, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 33425, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 33426, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 33427, 0.3527, 0, 1, 1, 0, 0, 0),
(26735, 33428, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 33454, 2.4691, 0, 1, 1, 0, 0, 0),
(26735, 33462, 0.3527, 0, 1, 1, 0, 0, 0),
(26735, 33470, 27.1605, 0, 1, 1, 0, 0, 0),
(26735, 35966, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 35975, 0.3527, 0, 1, 1, 0, 0, 0),
(26735, 35982, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 35984, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 35985, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 36075, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 36078, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 36085, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 36088, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 36089, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 36189, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 36198, 0.3527, 0, 1, 1, 0, 0, 0),
(26735, 36200, 3.7037, 0, 1, 1, 0, 0, 0),
(26735, 36207, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 36208, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 36303, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 36304, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 36322, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 36419, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 36434, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 36448, 3.5273, 0, 1, 1, 0, 0, 0),
(26735, 36462, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 36630, 0.1908, 0, 1, 1, 0, 0, 0),
(26735, 36657, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 36671, 0.3527, 0, 1, 1, 0, 0, 0),
(26735, 36685, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 36686, 0.1764, 0, 1, 1, 0, 0, 0),
(26735, 37748, 0.3817, 0, 1, 1, 0, 0, 0),
(26735, 37783, 0.1764, 0, 1, 1, 0, 0, 0);

--Azure Enforcer:

Code:
REPLACE INTO `creature_template` (`entry`, `heroic_entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (26734, 30516, 14886, 0, 14886, 0, 'Azurblauer Vollstrecker', '', '', 70, 71, 37164, 37164, 0, 0, 7500, 14, 14, 0, 1, 1, 1, 1483, 2524, 0, 6011, 2000, 1500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 8, 26734, 0, 26734, 0, 0, 0, 0, 0, 0, 15284, 39171, 0, 0, 0, 0, 0, '', 0, 3, 0, 1, 4837, 0, 0, 'generic_creature');

DELETE FROM `creature_loot_template` WHERE (`entry`=26734);
INSERT INTO `creature_loot_template` VALUES 
(26734, 22829, 2.7607, 0, 1, 1, 0, 0, 0),
(26734, 23107, 0.2045, 0, 1, 1, 0, 0, 0),
(26734, 33358, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 33359, 0.2045, 0, 1, 1, 0, 0, 0),
(26734, 33361, 0.2045, 0, 1, 1, 0, 0, 0),
(26734, 33363, 2.045, 0, 1, 1, 0, 0, 0),
(26734, 33372, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 33373, 0.2045, 0, 1, 1, 0, 0, 0),
(26734, 33376, 4.09, 0, 1, 1, 0, 0, 0),
(26734, 33390, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 33391, 0.2045, 0, 1, 1, 0, 0, 0),
(26734, 33402, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 33406, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 33407, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 33408, 0.2045, 0, 1, 1, 0, 0, 0),
(26734, 33409, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 33423, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 33424, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 33426, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 33429, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 33431, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 33437, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 33444, 2.863, 0, 1, 1, 0, 0, 0),
(26734, 33445, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 33454, 7.6687, 0, 1, 1, 0, 0, 0),
(26734, 33461, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 33470, 30.2658, 0, 1, 1, 0, 0, 0),
(26734, 35963, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 35965, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 35966, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 35968, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 35972, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 35973, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 35974, 0.2045, 0, 1, 1, 0, 0, 0),
(26734, 35979, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 35984, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36049, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36051, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36080, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36083, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36086, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36087, 2.045, 0, 1, 1, 0, 0, 0),
(26734, 36093, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36096, 2.045, 0, 1, 1, 0, 0, 0),
(26734, 36097, 0.2045, 0, 1, 1, 0, 0, 0),
(26734, 36098, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36165, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36190, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36196, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36198, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36209, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36260, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36266, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36299, 0.2045, 0, 1, 1, 0, 0, 0),
(26734, 36305, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36306, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36308, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36310, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36313, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36314, 0.2045, 0, 1, 1, 0, 0, 0),
(26734, 36318, 0.2045, 0, 1, 1, 0, 0, 0),
(26734, 36319, 2.045, 0, 1, 1, 0, 0, 0),
(26734, 36420, 0.2045, 0, 1, 1, 0, 0, 0),
(26734, 36433, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36442, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36447, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36460, 0.2045, 0, 1, 1, 0, 0, 0),
(26734, 36517, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36546, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36558, 2.045, 0, 1, 1, 0, 0, 0),
(26734, 36560, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36573, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36586, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36600, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36609, 0.7874, 0, 1, 1, 0, 0, 0),
(26734, 36656, 0.2045, 0, 1, 1, 0, 0, 0),
(26734, 36670, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36672, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 36708, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 37744, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 37795, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 39153, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 43297, 0.1022, 0, 1, 1, 0, 0, 0),
(26734, 43463, 0.1022, 0, 1, 1, 0, 0, 0);

--Crazed Mana-Wraith
Code:
REPLACE INTO `creature_template` (`entry`, `heroic_entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (26746, 30520, 27810, 0, 27810, 0, 'Wahnsinniges Managespenst', '', '', 70, 71, 5574, 5574, 29328, 29328, 7500, 14, 14, 0, 1, 1, 0, 231, 569, 0, 1200, 2000, 1500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 33833, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 0, 'mob_crazed_mana_wraith');

--Alliance Ranger

Code:
REPLACE INTO `creature_template` (`entry`, `heroic_entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (26802, 30509, 24355, 0, 24355, 0, 'Waldläufer der Allianz', '', '', 71, 71, 37164, 37164, 16155, 16155, 1050, 14, 14, 0, 1, 1, 1, 1208, 1956, 0, 4746, 2000, 1500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 8, 26802, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 0, '');

DELETE FROM `creature_loot_template` WHERE (`entry`=26802);
INSERT INTO `creature_loot_template` VALUES 
(26802, 33361, 1.0638, 0, 1, 1, 0, 0, 0),
(26802, 33364, 0.5319, 0, 1, 1, 0, 0, 0),
(26802, 33375, 0.5319, 0, 1, 1, 0, 0, 0),
(26802, 33390, 0.5319, 0, 1, 1, 0, 0, 0),
(26802, 33407, 0.5319, 0, 1, 1, 0, 0, 0),
(26802, 33408, 1.0638, 0, 1, 1, 0, 0, 0),
(26802, 33414, 0.5319, 0, 1, 1, 0, 0, 0),
(26802, 33429, 10.6383, 0, 1, 1, 0, 0, 0),
(26802, 33444, 1.5957, 0, 1, 1, 0, 0, 0),
(26802, 33454, 12.234, 0, 1, 1, 0, 0, 0),
(26802, 35983, 0.5319, 0, 1, 1, 0, 0, 0),
(26802, 36077, 0.5319, 0, 1, 1, 0, 0, 0),
(26802, 36078, 1.0638, 0, 1, 1, 0, 0, 0),
(26802, 36082, 0.5319, 0, 1, 1, 0, 0, 0),
(26802, 36085, 0.5319, 0, 1, 1, 0, 0, 0),
(26802, 36160, 4.7619, 0, 1, 1, 0, 0, 0),
(26802, 36165, 0.5319, 0, 1, 1, 0, 0, 0),
(26802, 36205, 0.5319, 0, 1, 1, 0, 0, 0),
(26802, 36309, 0.5319, 0, 1, 1, 0, 0, 0),
(26802, 36315, 0.5319, 0, 1, 1, 0, 0, 0),
(26802, 36419, 0.5319, 0, 1, 1, 0, 0, 0),
(26802, 36420, 0.5319, 0, 1, 1, 0, 0, 0),
(26802, 36428, 0.5319, 0, 1, 1, 0, 0, 0),
(26802, 36474, 0.5319, 0, 1, 1, 0, 0, 0),
(26802, 36485, 0.5319, 0, 1, 1, 0, 0, 0),
(26802, 36553, 0.5319, 0, 1, 1, 0, 0, 0),
(26802, 43507, 0.5319, 0, 1, 1, 0, 0, 0);
 
  • Like
Reactions: dragonbs and diko