sindoring/moonwell-core-vanilla
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Files
development
moonwell-core-vanilla/sql/migrations/20251106170051_world.sql
T

212 lines
37 KiB
SQL
Raw Permalink Blame History

DROP PROCEDURE IF EXISTS add_migration;
DELIMITER ??
CREATE PROCEDURE `add_migration`()
BEGIN
DECLARE v INT DEFAULT 1;
SET v = (SELECT COUNT(*) FROM `migrations` WHERE `id`='20251106170051');
IF v = 0 THEN
INSERT INTO `migrations` VALUES ('20251106170051');
-- Add your query below.
/*
World of Warcraft Client Patch 1.3.0 (2005-03-22)
- Certain key NPCs (such as bankers and auctioneers) in the cities and
main outposts are now harder to kill. Additionally, when they die,
they will respawn more quickly.
*/
-- Banker Health
DELETE FROM `creature_template` WHERE `entry` IN (2455, 2456, 2457, 2458, 2459, 2460, 2461, 2625, 2996, 3309, 3318, 3320, 3496, 4155, 4208, 4209, 4549, 4550, 5060, 5099, 7799, 8119, 8123, 8124, 8356, 8357, 13917);
INSERT INTO `creature_template` (`entry`, `patch`, `name`, `subname`, `level_min`, `level_max`, `faction`, `npc_flags`, `gossip_menu_id`, `display_id1`, `display_id2`, `display_id3`, `display_id4`, `display_scale1`, `display_scale2`, `display_scale3`, `display_scale4`, `display_probability1`, `display_probability2`, `display_probability3`, `display_probability4`, `display_total_probability`, `mount_display_id`, `speed_walk`, `speed_run`, `detection_range`, `call_for_help_range`, `leash_range`, `type`, `pet_family`, `rank`, `unit_class`, `xp_multiplier`, `health_multiplier`, `mana_multiplier`, `armor_multiplier`, `damage_multiplier`, `damage_variance`, `damage_school`, `base_attack_time`, `ranged_attack_time`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `loot_id`, `pickpocket_loot_id`, `skinning_loot_id`, `gold_min`, `gold_max`, `spell_id1`, `spell_id2`, `spell_id3`, `spell_id4`, `spell_list_id`, `pet_spell_list_id`, `spawn_spell_id`, `auras`, `ai_name`, `movement_type`, `inhabit_type`, `civilian`, `racial_leader`, `equipment_id`, `trainer_id`, `vendor_id`, `mechanic_immune_mask`, `school_immune_mask`, `immunity_flags`, `static_flags1`, `static_flags2`, `flags_extra`, `script_name`) VALUES
-- Pre 1.3
(2455, 0, 'Olivia Burnside', 'Banker', 45, 45, 12, 257, 699, 1450, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936390, 0, 2, ''),
(2456, 0, 'Newton Burnside', 'Banker', 45, 45, 12, 257, 699, 1436, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936390, 0, 2, ''),
(2457, 0, 'John Burnside', 'Banker', 45, 45, 12, 257, 699, 1437, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936390, 0, 2, ''),
(2458, 0, 'Randolph Montague', 'Banker', 45, 45, 68, 256, 0, 2645, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 2458, 0, 0, 0, 0, 0, 407371846, 0, 2, ''),
(2459, 0, 'Mortimer Montague', 'Banker', 45, 45, 68, 256, 0, 2641, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 2459, 0, 0, 0, 0, 0, 407371846, 0, 2, ''),
(2460, 0, 'Barnum Stonemantle', 'Banker', 45, 45, 55, 256, 0, 3037, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936390, 0, 2, ''),
(2461, 0, 'Bailey Stonemantle', 'Banker', 45, 45, 55, 256, 0, 3038, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936390, 0, 2, ''),
(2625, 0, 'Viznik Goldgrubber', 'Banker', 55, 55, 120, 256, 0, 7160, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 134742086, 0, 2, ''),
(2996, 0, 'Torn', 'Banker', 45, 45, 104, 256, 0, 2104, 0, 0, 0, 1.35, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 1, 0, 0, 2996, 0, 0, 0, 0, 0, 138936390, 0, 2, ''),
(3309, 0, 'Karus', 'Banker', 45, 45, 29, 259, 1623, 1310, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 1, 0, 3309, 0, 0, 0, 0, 0, 4718662, 0, 2, ''),
(3318, 0, 'Koma', 'Banker', 45, 45, 29, 257, 1623, 1318, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 1, 0, 3318, 0, 0, 0, 0, 0, 4718662, 0, 2, ''),
(3320, 0, 'Soran', 'Banker', 45, 45, 29, 257, 1623, 1320, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 1, 0, 3320, 0, 0, 0, 0, 0, 4718662, 0, 2, ''),
(3496, 0, 'Fuzruckle', 'Banker', 45, 45, 69, 256, 0, 7058, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 1, 0, 0, 3496, 0, 0, 0, 0, 0, 134742022, 0, 2, ''),
(4155, 0, 'Idriana', 'Banker', 45, 45, 80, 259, 2404, 2210, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 1, 0, 0, 0, 0, 0, 0, 0, 138936390, 0, 2, ''),
(4208, 0, 'Lairn', 'Banker', 45, 45, 80, 256, 0, 2259, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936390, 0, 2, ''),
(4209, 0, 'Garryeth', 'Banker', 45, 45, 80, 256, 0, 2256, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 1, 0, 0, 0, 0, 0, 0, 0, 138936390, 0, 2, ''),
(4549, 0, 'William Montague', 'Banker', 45, 45, 68, 256, 0, 2655, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 4549, 0, 0, 0, 0, 0, 407371846, 0, 2, ''),
(4550, 0, 'Ophelia Montague', 'Banker', 45, 45, 68, 256, 0, 3942, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1.11111, 1.14286, 18, 5, 0, 6, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 8405008, 0, 0, 138936390, 0, 2, ''),
(5060, 0, 'World Banker', 'Banker', 45, 45, 35, 256, 0, 2575, 0, 0, 0, 1, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 0, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 1, 0, 0, 0, 0, 0, 0, 0, 524390, 0, 0, ''),
(5099, 0, 'Soleil Stonemantle', 'Banker', 45, 45, 55, 256, 0, 3039, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936390, 0, 2, ''),
(7799, 0, 'Gimblethorn', 'Banker', 45, 45, 474, 256, 0, 6882, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 1, 0, 0, 7799, 0, 0, 0, 0, 0, 134742022, 0, 2, ''),
(8119, 0, 'Zikkel', 'Banker', 45, 45, 69, 256, 0, 7332, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 1, 0, 0, 8119, 0, 0, 0, 0, 0, 134742022, 0, 2, ''),
(8123, 0, 'Rickle Goldgrubber', 'Banker', 55, 55, 120, 256, 0, 7337, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 134742086, 0, 2, ''),
(8124, 0, 'Qizzik', 'Banker', 45, 45, 474, 258, 0, 7335, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 1, 0, 0, 8124, 0, 0, 0, 0, 0, 134742022, 0, 2, ''),
(8356, 0, 'Chesmu', 'Banker', 45, 45, 104, 256, 0, 7621, 0, 0, 0, 1.25, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 1, 0, 0, 8356, 0, 0, 0, 0, 0, 138936390, 0, 2, ''),
(8357, 0, 'Atepa', 'Banker', 45, 45, 104, 256, 0, 7620, 0, 0, 0, 1.35, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 1, 0, 0, 8357, 0, 0, 0, 0, 0, 138936390, 0, 2, ''),
-- Post 1.3
(2455, 1, 'Olivia Burnside', 'Banker', 45, 45, 12, 257, 699, 1450, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936390, 0, 2, ''),
(2456, 1, 'Newton Burnside', 'Banker', 45, 45, 12, 257, 699, 1436, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936390, 0, 2, ''),
(2457, 1, 'John Burnside', 'Banker', 45, 45, 12, 257, 699, 1437, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936390, 0, 2, ''),
(2458, 1, 'Randolph Montague', 'Banker', 45, 45, 68, 256, 0, 2645, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 2458, 0, 0, 0, 0, 0, 407371846, 0, 2, ''),
(2459, 1, 'Mortimer Montague', 'Banker', 45, 45, 68, 256, 0, 2641, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 2459, 0, 0, 0, 0, 0, 407371846, 0, 2, ''),
(2460, 1, 'Barnum Stonemantle', 'Banker', 45, 45, 55, 256, 0, 3037, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936390, 0, 2, ''),
(2461, 1, 'Bailey Stonemantle', 'Banker', 45, 45, 55, 256, 0, 3038, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936390, 0, 2, ''),
(2625, 1, 'Viznik Goldgrubber', 'Banker', 55, 55, 120, 256, 0, 7160, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 134742086, 0, 2, ''),
(2996, 1, 'Torn', 'Banker', 45, 45, 104, 256, 0, 2104, 0, 0, 0, 1.35, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 1, 0, 0, 2996, 0, 0, 0, 0, 0, 138936390, 0, 2, ''),
(3309, 1, 'Karus', 'Banker', 45, 45, 29, 259, 1623, 1310, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 1, 0, 3309, 0, 0, 0, 0, 0, 4718662, 0, 2, ''),
(3318, 1, 'Koma', 'Banker', 45, 45, 29, 257, 1623, 1318, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 1, 0, 3318, 0, 0, 0, 0, 0, 4718662, 0, 2, ''),
(3320, 1, 'Soran', 'Banker', 45, 45, 29, 257, 1623, 1320, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 1, 0, 3320, 0, 0, 0, 0, 0, 4718662, 0, 2, ''),
(3496, 1, 'Fuzruckle', 'Banker', 45, 45, 69, 256, 0, 7058, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 1, 0, 0, 3496, 0, 0, 0, 0, 0, 134742022, 0, 2, ''),
(4155, 1, 'Idriana', 'Banker', 45, 45, 80, 259, 2404, 2210, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 1, 0, 0, 0, 0, 0, 0, 0, 138936390, 0, 2, ''),
(4208, 1, 'Lairn', 'Banker', 45, 45, 80, 256, 0, 2259, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936390, 0, 2, ''),
(4209, 1, 'Garryeth', 'Banker', 45, 45, 80, 256, 0, 2256, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 1, 0, 0, 0, 0, 0, 0, 0, 138936390, 0, 2, ''),
(4549, 1, 'William Montague', 'Banker', 45, 45, 68, 256, 0, 2655, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 'EventAI', 0, 3, 0, 0, 4549, 0, 0, 0, 0, 0, 407371846, 0, 2, ''),
(4550, 1, 'Ophelia Montague', 'Banker', 45, 45, 68, 256, 0, 3942, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1.11111, 1.14286, 18, 5, 0, 6, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 8405008, 0, 0, 138936390, 0, 2, ''),
(5060, 1, 'World Banker', 'Banker', 45, 45, 35, 256, 0, 2575, 0, 0, 0, 1, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 0, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 1, 0, 0, 0, 0, 0, 0, 0, 524390, 0, 0, ''),
(5099, 1, 'Soleil Stonemantle', 'Banker', 45, 45, 55, 256, 0, 3039, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936390, 0, 2, ''),
(7799, 1, 'Gimblethorn', 'Banker', 45, 45, 474, 256, 0, 6882, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 1, 0, 0, 7799, 0, 0, 0, 0, 0, 134742022, 0, 2, ''),
(8119, 1, 'Zikkel', 'Banker', 45, 45, 69, 256, 0, 7332, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 1, 0, 0, 8119, 0, 0, 0, 0, 0, 134742022, 0, 2, ''),
(8123, 1, 'Rickle Goldgrubber', 'Banker', 55, 55, 120, 256, 0, 7337, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 134742086, 0, 2, ''),
(8124, 1, 'Qizzik', 'Banker', 45, 45, 474, 258, 0, 7335, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 1, 0, 0, 8124, 0, 0, 0, 0, 0, 134742022, 0, 2, ''),
(8356, 1, 'Chesmu', 'Banker', 45, 45, 104, 256, 0, 7621, 0, 0, 0, 1.25, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 1, 0, 0, 8356, 0, 0, 0, 0, 0, 138936390, 0, 2, ''),
(8357, 1, 'Atepa', 'Banker', 45, 45, 104, 256, 0, 7620, 0, 0, 0, 1.35, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 1, 0, 0, 8357, 0, 0, 0, 0, 0, 138936390, 0, 2, ''),
(13917, 1, 'Izzy Coppergrab', 'Banker', 55, 55, 855, 256, 0, 13969, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 1, 0, 0, 13917, 0, 0, 0, 0, 0, 134742022, 0, 2, '');
-- Banker Respawn Times
UPDATE `creature` SET `spawntimesecsmin`=60, `spawntimesecsmax`=120 WHERE `guid`=41770;
DELETE FROM `creature` WHERE `id` IN (2455, 2456, 2457, 2458, 2459, 2460, 2461, 2625, 2996, 3309, 3318, 3320, 3496, 4155, 4208, 4209, 4549, 4550, 5060, 5099, 7799, 8119, 8123, 8124, 8356, 8357);
INSERT INTO `creature` (`guid`, `id`, `id2`, `id3`, `id4`, `id5`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `spawntimesecsmax`, `wander_distance`, `health_percent`, `mana_percent`, `movement_type`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
-- Pre 1.3
(12628, 8123, 0, 0, 0, 0, 0, -14421.9, 528.898, 5.24876, 5.14872, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12629, 5099, 0, 0, 0, 0, 0, -4895.64, -1004.66, 504.024, 2.23402, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12630, 2625, 0, 0, 0, 0, 0, -14426.2, 527.253, 5.23553, 5.21853, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12631, 2461, 0, 0, 0, 0, 0, -4886.55, -997.594, 504.024, 2.23402, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12632, 2460, 0, 0, 0, 0, 0, -4877.43, -990.034, 504.024, 2.30383, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12633, 3318, 0, 0, 0, 0, 1, 1632.39, -4381.97, 11.8003, 3.57792, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12634, 3320, 0, 0, 0, 0, 1, 1622.9, -4369.06, 11.8099, 3.57792, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12635, 3309, 0, 0, 0, 0, 1, 1627.32, -4376.07, 11.814, 3.4383, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12636, 3496, 0, 0, 0, 0, 1, -915.813, -3724.49, 9.71071, 3.50811, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12637, 8119, 0, 0, 0, 0, 1, -914.106, -3728.58, 9.72148, 3.33358, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12638, 7799, 0, 0, 0, 0, 1, -7205.06, -3827.29, 8.6442, 0.174533, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12639, 8124, 0, 0, 0, 0, 1, -7206.69, -3832.64, 8.64432, 0.349066, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12640, 8356, 0, 0, 0, 0, 1, -1252.82, 24.7438, 128.27, 3.1765, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12641, 8357, 0, 0, 0, 0, 1, -1262.78, 24.0055, 128.27, 0.10472, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12642, 2996, 0, 0, 0, 0, 1, -1257.63, 19.5577, 128.27, 1.72788, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12643, 2458, 0, 0, 0, 0, 0, 1599.96, 240.65, -52.0596, 0.0872665, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12644, 4549, 0, 0, 0, 0, 0, 1591.49, 240.328, -52.0596, 3.03687, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12645, 2459, 0, 0, 0, 0, 0, 1595.89, 236.068, -52.0596, 4.86947, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12646, 4550, 0, 0, 0, 0, 0, 1595.84, 244.236, -52.0596, 1.50098, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12647, 4155, 0, 0, 0, 0, 1, 9938.84, 2521.53, 1317.66, 4.38078, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12648, 4208, 0, 0, 0, 0, 1, 9945.15, 2518.39, 1317.66, 3.9968, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12649, 4209, 0, 0, 0, 0, 1, 9942.03, 2519.24, 1317.66, 4.32842, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12650, 2456, 0, 0, 0, 0, 0, -8935.27, 613.135, 99.606, 0.453786, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12651, 2455, 0, 0, 0, 0, 0, -8931.23, 605.801, 99.606, 0.488692, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12652, 2457, 0, 0, 0, 0, 0, -8939.28, 620.538, 99.606, 0.506145, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
-- Post 1.3
(12653, 8123, 0, 0, 0, 0, 0, -14421.9, 528.898, 5.24876, 5.14872, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12654, 5099, 0, 0, 0, 0, 0, -4895.64, -1004.66, 504.024, 2.23402, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12655, 2625, 0, 0, 0, 0, 0, -14426.2, 527.253, 5.23553, 5.21853, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12656, 2461, 0, 0, 0, 0, 0, -4886.55, -997.594, 504.024, 2.23402, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12657, 2460, 0, 0, 0, 0, 0, -4877.43, -990.034, 504.024, 2.30383, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12658, 3318, 0, 0, 0, 0, 1, 1632.39, -4381.97, 11.8003, 3.57792, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12659, 3320, 0, 0, 0, 0, 1, 1622.9, -4369.06, 11.8099, 3.57792, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12660, 3309, 0, 0, 0, 0, 1, 1627.32, -4376.07, 11.814, 3.4383, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12661, 3496, 0, 0, 0, 0, 1, -915.813, -3724.49, 9.71071, 3.50811, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12662, 8119, 0, 0, 0, 0, 1, -914.106, -3728.58, 9.72148, 3.33358, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12663, 7799, 0, 0, 0, 0, 1, -7205.06, -3827.29, 8.6442, 0.174533, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12664, 8124, 0, 0, 0, 0, 1, -7206.69, -3832.64, 8.64432, 0.349066, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12665, 8356, 0, 0, 0, 0, 1, -1252.82, 24.7438, 128.27, 3.1765, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12666, 8357, 0, 0, 0, 0, 1, -1262.78, 24.0055, 128.27, 0.10472, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12667, 2996, 0, 0, 0, 0, 1, -1257.63, 19.5577, 128.27, 1.72788, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12668, 2458, 0, 0, 0, 0, 0, 1599.96, 240.65, -52.0596, 0.0872665, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12669, 4549, 0, 0, 0, 0, 0, 1591.49, 240.328, -52.0596, 3.03687, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12670, 2459, 0, 0, 0, 0, 0, 1595.89, 236.068, -52.0596, 4.86947, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12671, 4550, 0, 0, 0, 0, 0, 1595.84, 244.236, -52.0596, 1.50098, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12672, 4155, 0, 0, 0, 0, 1, 9938.84, 2521.53, 1317.66, 4.38078, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12673, 4208, 0, 0, 0, 0, 1, 9945.15, 2518.39, 1317.66, 3.9968, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12674, 4209, 0, 0, 0, 0, 1, 9942.03, 2519.24, 1317.66, 4.32842, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12675, 2456, 0, 0, 0, 0, 0, -8935.27, 613.135, 99.606, 0.453786, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12676, 2455, 0, 0, 0, 0, 0, -8931.23, 605.801, 99.606, 0.488692, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12677, 2457, 0, 0, 0, 0, 0, -8939.28, 620.538, 99.606, 0.506145, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10);
-- Actioneer Health
DELETE FROM `creature_template` WHERE `entry` IN (8661, 8669, 8670, 8671, 8672, 8673, 8674, 8719, 8720, 8721, 8722, 8723, 8724, 9856, 9857, 9858, 9859);
INSERT INTO `creature_template` (`entry`, `patch`, `name`, `subname`, `level_min`, `level_max`, `faction`, `npc_flags`, `gossip_menu_id`, `display_id1`, `display_id2`, `display_id3`, `display_id4`, `display_scale1`, `display_scale2`, `display_scale3`, `display_scale4`, `display_probability1`, `display_probability2`, `display_probability3`, `display_probability4`, `display_total_probability`, `mount_display_id`, `speed_walk`, `speed_run`, `detection_range`, `call_for_help_range`, `leash_range`, `type`, `pet_family`, `rank`, `unit_class`, `xp_multiplier`, `health_multiplier`, `mana_multiplier`, `armor_multiplier`, `damage_multiplier`, `damage_variance`, `damage_school`, `base_attack_time`, `ranged_attack_time`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `loot_id`, `pickpocket_loot_id`, `skinning_loot_id`, `gold_min`, `gold_max`, `spell_id1`, `spell_id2`, `spell_id3`, `spell_id4`, `spell_list_id`, `pet_spell_list_id`, `spawn_spell_id`, `auras`, `ai_name`, `movement_type`, `inhabit_type`, `civilian`, `racial_leader`, `equipment_id`, `trainer_id`, `vendor_id`, `mechanic_immune_mask`, `school_immune_mask`, `immunity_flags`, `static_flags1`, `static_flags2`, `flags_extra`, `script_name`) VALUES
-- These auctioneers were not changed.
(8672, 0, 'Auctioneer Leeka', NULL, 50, 50, 68, 4096, 0, 7995, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.25, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936326, 0, 2, ''),
(8674, 0, 'Auctioneer Stampi', NULL, 50, 50, 104, 4096, 0, 7999, 0, 0, 0, 1.35, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.25, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 138936326, 0, 2, ''),
(8721, 0, 'Auctioneer Epitwee', NULL, 50, 50, 68, 4096, 0, 7994, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.25, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936326, 0, 2, ''),
(8722, 0, 'Auctioneer Gullem', NULL, 50, 50, 104, 4096, 0, 7998, 0, 0, 0, 1.35, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.25, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 138936326, 0, 2, ''),
-- Pre 1.3
(8661, 0, 'Auctioneer Beardo', NULL, 50, 50, 474, 4096, 0, 7993, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.25, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 1, 0, 0, 8661, 0, 0, 0, 0, 0, 134742086, 0, 2, ''),
(8669, 0, 'Auctioneer Tolon', NULL, 50, 50, 80, 4096, 0, 7997, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.25, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936326, 0, 2, ''),
(8670, 0, 'Auctioneer Chilton', NULL, 50, 50, 12, 4096, 0, 7991, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.25, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936326, 0, 2, ''),
(8671, 0, 'Auctioneer Buckler', NULL, 50, 50, 55, 4096, 0, 7990, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.25, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936326, 0, 2, ''),
(8673, 0, 'Auctioneer Thathung', NULL, 50, 50, 29, 4096, 0, 8001, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.25, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 4718598, 0, 2, ''),
(8719, 0, 'Auctioneer Fitch', NULL, 50, 50, 12, 4096, 0, 7992, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.25, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936326, 0, 2, ''),
(8720, 0, 'Auctioneer Redmuse', NULL, 50, 50, 55, 4096, 0, 7989, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.25, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936326, 0, 2, ''),
(8723, 0, 'Auctioneer Golothas', NULL, 50, 50, 80, 4096, 0, 7996, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.25, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936326, 0, 2, ''),
(8724, 0, 'Auctioneer Wabang', NULL, 50, 50, 29, 4096, 0, 8000, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.25, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 4718598, 0, 2, ''),
(9856, 0, 'Auctioneer Grimful', NULL, 50, 50, 29, 4096, 0, 9133, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.25, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 4718598, 0, 2, ''),
(9857, 0, 'Auctioneer Grizzlin', NULL, 50, 50, 855, 4096, 0, 9132, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.25, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 138936326, 0, 2, ''),
(9858, 0, 'Auctioneer Kresky', NULL, 50, 50, 120, 4096, 0, 10754, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.25, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936326, 0, 2, ''),
(9859, 0, 'Auctioneer Lympkin', NULL, 50, 50, 55, 4096, 0, 9131, 0, 0, 0, 1.15, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 1.25, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936326, 0, 2, ''),
-- Post 1.3
(8661, 1, 'Auctioneer Beardo', NULL, 50, 50, 474, 4096, 0, 7993, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 1, 0, 0, 8661, 0, 0, 0, 0, 0, 134742086, 0, 2, ''),
(8669, 1, 'Auctioneer Tolon', NULL, 50, 50, 80, 4096, 0, 7997, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936326, 0, 2, ''),
(8670, 1, 'Auctioneer Chilton', NULL, 50, 50, 12, 4096, 0, 7991, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936326, 0, 2, ''),
(8671, 1, 'Auctioneer Buckler', NULL, 50, 50, 55, 4096, 0, 7990, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936326, 0, 2, ''),
(8673, 1, 'Auctioneer Thathung', NULL, 50, 50, 29, 4096, 0, 8001, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 4718598, 0, 2, ''),
(8719, 1, 'Auctioneer Fitch', NULL, 50, 50, 12, 4096, 0, 7992, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936326, 0, 2, ''),
(8720, 1, 'Auctioneer Redmuse', NULL, 50, 50, 55, 4096, 0, 7989, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936326, 0, 2, ''),
(8723, 1, 'Auctioneer Golothas', NULL, 50, 50, 80, 4096, 0, 7996, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936326, 0, 2, ''),
(8724, 1, 'Auctioneer Wabang', NULL, 50, 50, 29, 4096, 0, 8000, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 4718598, 0, 2, ''),
(9856, 1, 'Auctioneer Grimful', NULL, 50, 50, 29, 4096, 0, 9133, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 4718598, 0, 2, ''),
(9857, 1, 'Auctioneer Grizzlin', NULL, 50, 50, 855, 4096, 0, 9132, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 138936326, 0, 2, ''),
(9858, 1, 'Auctioneer Kresky', NULL, 50, 50, 120, 4096, 0, 10754, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936326, 0, 2, ''),
(9859, 1, 'Auctioneer Lympkin', NULL, 50, 50, 55, 4096, 0, 9131, 0, 0, 0, 1.15, 0, 0, 0, 100, 0, 0, 0, 100, 0, 1, 1.14286, 18, 5, 0, 7, 0, 0, 1, 1, 3, 1, 1, 1, 0.14, 0, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 138936326, 0, 2, '');
-- Auctioneer Respawn Times
DELETE FROM `creature` WHERE `id` IN (8661, 8669, 8670, 8671, 8673, 8719, 8720, 8723, 8724, 9856, 9857, 9858, 9859);
INSERT INTO `creature` (`guid`, `id`, `id2`, `id3`, `id4`, `id5`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `spawntimesecsmax`, `wander_distance`, `health_percent`, `mana_percent`, `movement_type`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
-- Pre 1.3
(12678, 8661, 0, 0, 0, 0, 1, -7239.1, -3803.89, 0.813843, 0.0174533, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12679, 8669, 0, 0, 0, 0, 1, 9872.6, 2341.73, 1321.67, 3.52557, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12680, 8670, 0, 0, 0, 0, 0, -8824.28, 665.711, 97.4674, 0.541052, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12681, 8671, 0, 0, 0, 0, 0, -4948.01, -901.528, 505.172, 3.80482, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12682, 8673, 0, 0, 0, 0, 1, 1687.26, -4464.71, 20.1476, 2.00713, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12683, 8719, 0, 0, 0, 0, 0, -8821.53, 659.886, 97.4645, 0.401426, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12684, 8720, 0, 0, 0, 0, 0, -4963.19, -904.619, 505.17, 5.42797, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12685, 8723, 0, 0, 0, 0, 1, 9856.97, 2343.12, 1321.67, 5.67232, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12686, 8724, 0, 0, 0, 0, 1, 1667.62, -4463.76, 20.1475, 1.71042, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12687, 9856, 0, 0, 0, 0, 1, 1695.92, -4455.55, 20.1475, 2.00713, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12688, 9857, 0, 0, 0, 0, 1, 6772.35, -4679.5, 723.853, 0.907571, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12689, 9858, 0, 0, 0, 0, 0, -14446.5, 448.414, 4.12501, 2.9147, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
(12690, 9859, 0, 0, 0, 0, 0, -4967.86, -917.619, 505.169, 0.785398, 300, 480, 0, 100, 0, 0, 0, 0, 0, 0),
-- Post 1.3
(12691, 8661, 0, 0, 0, 0, 1, -7239.1, -3803.89, 0.813843, 0.0174533, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12692, 8669, 0, 0, 0, 0, 1, 9872.6, 2341.73, 1321.67, 3.52557, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12693, 8670, 0, 0, 0, 0, 0, -8824.28, 665.711, 97.4674, 0.541052, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12694, 8671, 0, 0, 0, 0, 0, -4948.01, -901.528, 505.172, 3.80482, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12695, 8673, 0, 0, 0, 0, 1, 1687.26, -4464.71, 20.1476, 2.00713, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12696, 8719, 0, 0, 0, 0, 0, -8821.53, 659.886, 97.4645, 0.401426, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12697, 8720, 0, 0, 0, 0, 0, -4963.19, -904.619, 505.17, 5.42797, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12698, 8723, 0, 0, 0, 0, 1, 9856.97, 2343.12, 1321.67, 5.67232, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12699, 8724, 0, 0, 0, 0, 1, 1667.62, -4463.76, 20.1475, 1.71042, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12700, 9856, 0, 0, 0, 0, 1, 1695.92, -4455.55, 20.1475, 2.00713, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12701, 9857, 0, 0, 0, 0, 1, 6772.35, -4679.5, 723.853, 0.907571, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12702, 9858, 0, 0, 0, 0, 0, -14446.5, 448.414, 4.12501, 2.9147, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10),
(12703, 9859, 0, 0, 0, 0, 0, -4967.86, -917.619, 505.169, 0.785398, 60, 120, 0, 100, 0, 0, 0, 0, 1, 10);
-- These auctioneers were not changed.
UPDATE `creature` SET `spawntimesecsmin`=300, `spawntimesecsmax`=480 WHERE `id` iN (8672, 8674, 8721, 8722);
-- End of migration.
END IF;
END??
DELIMITER ;
CALL add_migration();
DROP PROCEDURE IF EXISTS add_migration;
Reference in New Issue View Git Blame Copy Permalink