Advertisement
Guest User

Ruby Sanctum Fix

a guest
Nov 30th, 2010
919
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 3.33 KB | None | 0 0
  1. -- The Ruby Sanctum 10H,25N and 25H faction and equipment fix
  2. -- Bosses
  3. UPDATE `creature_template` SET `minlevel`=83,`maxlevel`=83,`faction_A`=103,`faction_H`=103,`equipment_id`=1568 WHERE `entry`=39920; -- Baltharus the Warborn (1)
  4. UPDATE `creature_template` SET `minlevel`=83,`maxlevel`=83,`exp`=2,`faction_A`=103,`faction_H`=103,`speed_walk`=2.8,`speed_run`=1.71429,`scale`=1.28,`baseattacktime`=2400,`equipment_id`=1568 WHERE `entry`=39922; -- Baltharus the Warborn Clone (1)
  5. UPDATE `creature_template` SET `minlevel`=83,`maxlevel`=83,`faction_A`=103,`faction_H`=103,`equipment_id`=0 WHERE `entry`=39823; -- Saviana Ragefire (1)
  6. UPDATE `creature_template` SET `minlevel`=83,`maxlevel`=83,`faction_A`=16,`faction_H`=16,`equipment_id`=1764 WHERE `entry`=39805; -- General Zarithrian (1)
  7. UPDATE `creature_template` SET `minlevel`=83,`maxlevel`=83,`faction_A`=14,`faction_H`=14,`equipment_id`=0 WHERE `entry` IN (39864,39944,39945); -- Halion
  8. -- Mobs
  9. UPDATE `creature_template` SET `minlevel`=82,`maxlevel`=82,`faction_A`=103,`faction_H`=103,`equipment_id`=2419 WHERE `entry`=40418; -- Charscale Invoker (1)
  10. UPDATE `creature_template` SET `minlevel`=82,`maxlevel`=82,`faction_A`=103,`faction_H`=103,`equipment_id`=2031 WHERE `entry`=40420; -- Charscale Assaulter (1)
  11. UPDATE `creature_template` SET `minlevel`=82,`maxlevel`=82,`faction_A`=103,`faction_H`=103,`equipment_id`=2031 WHERE `entry`=40419; -- Charscale Assaulter
  12. UPDATE `creature_template` SET `minlevel`=82,`maxlevel`=82,`faction_A`=103,`faction_H`=103,`equipment_id`=10068 WHERE `entry`=40422; -- Charscale Elite (1)
  13. UPDATE `creature_template` SET `minlevel`=82,`maxlevel`=82,`faction_A`=103,`faction_H`=103,`equipment_id`=2420 WHERE `entry`=40424; -- Charscale Commander (1)
  14. -- Living Inferno and Living Ember level, faction and expansion fix
  15. UPDATE `creature_template` SET `minlevel`=82,`maxlevel`=82,`exp`=2,`faction_A`=14,`faction_H`=14 WHERE `entry` IN (40681,40682,40683,40684);
  16. -- Sylvanas' Lamenter level fix
  17. UPDATE `creature_template` SET `minlevel`=70,`maxlevel`=70 WHERE `entry`=39048;
  18. -- Update Attacktime,Unitflags and implement correct Modelinfo for Baltharus the Warborn (ID: 39751 and 39920)
  19. UPDATE `creature_template` SET `baseattacktime`=2000,`unit_flags`=`unit_flags`|64 WHERE `entry`=39751;
  20. UPDATE `creature_template` SET `baseattacktime`=2000,`unit_flags`=`unit_flags`|64 WHERE `entry`=39920;
  21. UPDATE `creature_model_info` SET `bounding_radius`=3,`combat_reach`=9 WHERE `modelid`=31761;
  22. -- Update Attacktime,Unitflags and implement correct Modelinfo for Saviana Ragefire (ID: 39747 and 39823)
  23. UPDATE `creature_template` SET `baseattacktime`=2000,`unit_flags`=`unit_flags`|64 WHERE `entry`=39747;
  24. UPDATE `creature_template` SET `baseattacktime`=2000,`unit_flags`=`unit_flags`|64 WHERE `entry`=39823;
  25. UPDATE `creature_model_info` SET `bounding_radius`=2.625,`combat_reach`=5.25 WHERE `modelid`=31577;
  26. -- Update Attacktime and Unitflags for General Zarithrian (ID: 39746 and 39805)
  27. UPDATE `creature_template` SET `baseattacktime`=1500,`unit_flags`=`unit_flags`|33554752 WHERE `entry`=39746;
  28. UPDATE `creature_template` SET `baseattacktime`=1500,`unit_flags`=`unit_flags`|33554752 WHERE `entry`=39805;
  29. -- Lonely Turkey faction fix
  30. UPDATE `creature_template` SET `faction_A`=189,`faction_H`=189 WHERE `entry`=32956;
  31. -- Elwynn Forest Wolf faction fix
  32. UPDATE `creature_template` SET `faction_A`=14,`faction_H`=14 WHERE `entry`=33286;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement