AscEmu/sql/world/updates/20210605-00_creature_spawns.sql

-- Remove transport spawns on wrong map
-- The Zephyr	647
DELETE FROM creature_spawns WHERE id IN(257601, 257602, 257603, 257604, 257605, 257306, 257607, 257609, 257610, 257611, 257612);

-- Ship, Icebreaker (Northspear)	612
DELETE FROM creature_spawns WHERE id IN(138990, 138987, 138973, 138974, 138986, 138989);

-- Zeppelin, Horde (Cloudkisser)	610
DELETE FROM creature_spawns WHERE id IN(128203, 128197, 138992, 12198, 128204);

-- Sister Mercy	594
DELETE FROM creature_spawns WHERE id IN(138995, 138948, 138949, 138950, 138951, 138952, 138953, 138954, 138955, 138956, 138957, 138958, 138959, 138960, 138961, 138962, 138963, 138964, 138965, 138966, 138967, 138968, 138969, 138970);

-- Turtle (Walker of Waves)	620
DELETE FROM creature_spawns WHERE id IN(128411, 128412);

-- Turtle (Green Island)	621
DELETE FROM creature_spawns WHERE id IN(139737);

-- Ship, Icebreaker (Stormwind's Pride)	614
DELETE FROM creature_spawns WHERE id IN(138857, 138856, 138858, 138855, 138854, 138853);

-- The Skybreaker	623
DELETE FROM creature_spawns WHERE id IN(139327, 139321, 139326, 139319, 139145, 139186, 139142);

-- Ship (The Maiden's Fancy)	593
DELETE FROM creature_spawns WHERE min_build = 15595 AND id IN(263764, 263762, 263760, 263757, 263761, 263758, 263759);


-- Remove duplicate data for transport spawns (multiversion)
-- The Zephyr	647
DELETE FROM creature_spawns WHERE id IN(491847, 491846, 491838, 491837, 491836, 472109, 472043, 472018, 472001, 460492, 428526, 428414);

-- Ship (The Maiden's Fancy)	593
DELETE FROM creature_spawns WHERE id IN(593204, 593203, 593202, 593201, 593200, 593199, 593198, 593197);

-- Zeppelin (The Thundercaller)	591
DELETE FROM creature_spawns WHERE id IN(593225, 593224, 593223, 593222, 593221, 593220, 593219, 593218, 593217, 593216, 593215, 593214, 593213, 593212, 593211, 593210, 593209, 593208, 593207, 593206, 593205);

-- Zeppelin (The Iron Eagle)	589
DELETE FROM creature_spawns WHERE id IN(593247, 593246, 593245, 593244, 593243, 593242, 593241, 593240, 593239, 593238, 593237);

-- Ship (The Lady Mehley)	584
DELETE FROM creature_spawns WHERE id IN(594205, 594204, 594203, 594202, 594201, 594200, 594199, 592410, 592409, 592391, 591770);

-- Ship, Night Elf (Moonspray)	582
DELETE FROM creature_spawns WHERE id IN(593278, 593277, 593276, 593275, 593274, 593273, 460501, 438220);

-- Ship (The Bravery)	588
DELETE FROM creature_spawns WHERE id IN(593257, 593256, 593255, 593254, 593253, 593252, 593251, 593250, 593249, 593248);

-- Zeppelin (The Purple Princess)	590
DELETE FROM creature_spawns WHERE id IN(593236, 593235, 593234, 593233, 593232, 593231, 593230, 593229, 593228, 593227, 593226);

-- Ship, Night Elf (Feathermoon Ferry)	587
DELETE FROM creature_spawns WHERE id IN(593266, 593265, 593264, 593263, 593262, 593261, 593260, 593259, 593258);

-- Ship, Night Elf (Elune's Blessing)	586
DELETE FROM creature_spawns WHERE id IN(593272, 593271, 593270, 593269, 593268, 593267, 454288, 454287);

-- Ship, Icebreaker (Northspear)	612
DELETE FROM creature_spawns WHERE id IN(593165, 593164, 593163, 593162, 593161, 593160);

-- Zeppelin, Horde (Cloudkisser)	610
DELETE FROM creature_spawns WHERE id IN(593172, 593171, 593170, 593169, 593168, 593167, 593166);

-- Zeppelin, Horde (The Mighty Wind)	613
DELETE FROM creature_spawns WHERE id IN(593159, 593158, 593157, 593156, 593155, 593154, 593153);

-- Sister Mercy	594
DELETE FROM creature_spawns WHERE id IN(593196, 593195, 593194, 593193, 593192, 593191, 593190, 593189, 593188, 593187, 593186, 593185, 593184, 593183, 593182, 593181, 593180, 593179, 593178, 593177, 593176, 593175, 593174, 593173);

-- Turtle (Walker of Waves)	620
DELETE FROM creature_spawns WHERE id IN(592449, 592448);

-- Turtle (Green Island)	621
DELETE FROM creature_spawns WHERE id IN(591836);

-- Ship, Icebreaker (Stormwind's Pride)	614
DELETE FROM creature_spawns WHERE id IN(593152, 593151, 593150, 593149, 593148, 593147);

-- Orgrim's Hammer	622
DELETE FROM creature_spawns WHERE id IN(595193, 595192, 595191, 595190, 595189, 595188, 595187, 595186, 595185, 595184, 595183, 595182, 593146, 593145, 593144, 593143, 593142, 593141, 593140, 593139, 593138, 593137, 593136, 593135, 593134, 593133, 593132, 593131, 593130, 593129, 593128, 593127, 593126, 593125, 593124, 593123, 593122, 593121, 593120, 593119, 593118, 593117, 593116, 593115, 593114, 593113, 593112, 593111, 593110, 593109, 593108, 593107, 593106, 593105, 593104, 593103, 593102, 593101, 593100, 593099, 593098, 593097, 593096, 593095, 593094, 593093, 592591, 592590, 592589, 592588, 524422);

-- The Skybreaker	623
DELETE FROM creature_spawns WHERE id IN(593092, 593091, 593090, 593089, 593088, 593087, 593086, 593085, 593084, 593083, 593082, 593081, 593080, 593079, 593078, 593077, 593076, 593075, 593074, 593073, 593072, 593071, 593070, 593069, 593068, 593067, 593066, 593065, 593064, 593063, 593062, 593061, 593060, 593059, 593058, 593057, 593056, 593055, 593054, 593053, 593052, 593051, 593050, 593049, 593048, 593047, 593046, 593045, 593044, 593043, 593042, 593041, 593040, 593039, 593038, 593037, 593036, 593035, 593034, 593033, 592600, 592599, 592598, 592597, 592596, 592595, 592594, 592593, 592592, 592587, 592586, 592585, 592584, 592583, 591703, 591702524423);


-- Update transport data for other versions
-- The Zephyr	647
UPDATE creature_spawns SET max_build = 15595 WHERE id IN(317147, 317148, 317149, 317150, 317151, 317152, 317153, 317154, 317155, 317156, 317157, 317158);

-- Ship (The Maiden's Fancy)	593
UPDATE creature_spawns SET max_build = 15595 WHERE id IN(316902, 316903, 316904, 316905, 316906, 316907, 316908, 316909);
UPDATE creature_spawns SET min_build = 12340 WHERE id IN(553995, 553994);

-- Zeppelin (The Thundercaller)	591
UPDATE creature_spawns SET max_build = 15595 WHERE id IN(316881, 316882, 316883, 316884, 316885, 316886, 316887, 316888, 316889, 316890, 316891, 316892, 316893, 316894, 316895, 316896, 316897, 316898, 316899, 316900, 316901);

-- Zeppelin (The Iron Eagle)	589
UPDATE creature_spawns SET max_build = 15595 WHERE id IN(316859, 316860, 316861, 316862, 316863, 316864, 316865, 316866, 316867, 316868, 316869);

-- Ship (The Lady Mehley)	584
UPDATE creature_spawns SET max_build = 15595 WHERE id IN(316821, 316822, 316823, 316824, 316825, 316826, 316827, 316828, 316829, 316830, 316831);

-- Ship, Night Elf (Moonspray)	582
UPDATE creature_spawns SET max_build = 15595 WHERE id IN(316813, 316814, 316815, 316816, 316817, 316818, 316819, 316820);

-- Ship (The Bravery)	588
UPDATE creature_spawns SET max_build = 15595 WHERE id IN(316849, 316850, 316851, 316852, 316853, 316854, 316855, 316856, 316857, 316858);

-- Zeppelin (The Purple Princess)	590
UPDATE creature_spawns SET max_build = 15595 WHERE id IN(316870, 316871, 316872, 316873, 316874, 316875, 316876, 316877, 316878, 316879, 316880);

-- Ship, Night Elf (Feathermoon Ferry)	587
UPDATE creature_spawns SET max_build = 15595 WHERE id IN(316840, 316841, 316842, 316843, 316844, 316845, 316846, 316847, 316848);

-- Ship, Night Elf (Elune's Blessing)	586
UPDATE creature_spawns SET max_build = 15595 WHERE id IN(316832, 316833, 316834, 316835, 316836, 316837, 316838, 316839);

-- Ship, Icebreaker (Northspear)	612
UPDATE creature_spawns SET max_build = 15595 WHERE id IN(316941, 316942, 316943, 316944, 316945, 316946);

-- Zeppelin, Horde (Cloudkisser)	610
UPDATE creature_spawns SET max_build = 15595 WHERE id IN(316934, 316935, 316936, 316937, 316938, 316939, 316940);

-- Zeppelin, Horde (The Mighty Wind)	613
UPDATE creature_spawns SET max_build = 15595 WHERE id IN(316947, 316948, 316949, 316950, 316951, 316952, 316953);

-- Sister Mercy	594
UPDATE creature_spawns SET max_build = 15595 WHERE id IN(316910, 316911, 316912, 316913, 316914, 316915, 316916, 316917, 316918, 316919, 316920, 316921, 316922, 316923, 316924, 316925, 316926, 316927, 316928, 316929, 316930, 316931, 316932, 316933);

-- Turtle (Walker of Waves)	620
UPDATE creature_spawns SET max_build = 15595 WHERE id IN(316960, 316961);

-- Turtle (Green Island)	621
UPDATE creature_spawns SET max_build = 15595 WHERE id IN(316962);

-- Ship, Icebreaker (Stormwind's Pride)	614
UPDATE creature_spawns SET max_build = 15595 WHERE id IN(316954, 316955, 316956, 316957, 316958, 316959);

-- Orgrim's Hammer	622
UPDATE creature_spawns SET max_build = 15595 WHERE id IN(316963, 316964, 316965, 316966, 316967, 316968, 316969, 316970, 316971, 316972, 316973, 316974, 316975, 316976, 316977, 316978, 316979, 316980, 316981, 316982, 316983, 316984, 316985, 316986, 316987, 316988, 316989, 316990, 316991, 316992, 316993, 316994, 316995, 316996, 316997, 316998, 316999, 317000, 317001, 317002, 317003, 317004, 317005, 317006, 317007, 317008, 317009, 317010, 317011, 317012, 317013, 317014, 317015, 317016, 317017, 317018, 317019, 317020, 317021, 317022, 317023, 317024, 317025, 317026, 317027, 317028, 317029, 317030, 317031, 317032, 317033);

-- The Skybreaker	623
UPDATE creature_spawns SET max_build = 15595 WHERE id IN(317034, 317035, 317036, 317037, 317038, 317039, 317040, 317041, 317042, 317043, 317044, 317045, 317046, 317047, 317048, 317049, 317050, 317051, 317052, 317053, 317054, 317055, 317056, 317057, 317058, 317059, 317060, 317061, 317062, 317063, 317064, 317065, 317066, 317067, 317068, 317069, 317070, 317071, 317072, 317073, 317074, 317075, 317076, 317077, 317078, 317079, 317080, 317081, 317082, 317083, 317084, 317085, 317086, 317087, 317088, 317089, 317090, 317091, 317092, 317093, 317094, 317095, 317096, 317097, 317098, 317099, 317100, 317101, 317102, 317103, 317104, 317105, 317106, 317107, 317108, 317109, 317110);


-- update world db version
INSERT INTO `world_db_version` VALUES ('77', '20210605-00_creature_spawns');