diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2017_01_11_01_world_335.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_01_11_01_world_335.sql b/sql/updates/world/3.3.5/2017_01_11_01_world_335.sql new file mode 100644 index 00000000000..722f6aa8618 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_01_11_01_world_335.sql @@ -0,0 +1,5 @@ +-- +DELETE FROM `gameobject_addon` WHERE `guid` IN (2966, 2969, 2970, 3062, 3074, 3091, 3127, 3149, 3150, 3151, 3219, 3280, 3470, 3555, 3629, 3661, 3699, 3799, 3859, 3873, 3892, 3897, 3899, 3901, 3905, 3918, 3920, 3928, 3929, 3930, 3933, 3940, 3947, 3948, 3956, 3959, 3966, 3972, 3973, 3975, 3976, 3978, 3980, 3981, 3986, 3992, 3997, 3999, 4001, 4002, 4010, 4011, 4012, 4013, 4015, 4016, 4017, 4020, 4022, 4023, 4026, 4031, 4038, 4040, 4051, 4056, 4057, 4058, 4062, 4068, 4069, 4072, 4074, 4075, 4076, 4081, 4083, 4087, 4090, 4091, 4094, 4098, 4099, 4105, 4106, 4109, 4113, 4114, 4119, 4121, 4122, 4123, 4124, 4129, 4132, 4133, 4141, 4144, 4146, 4147, 4148, 4154, 4157, 4158, 4159, 4161, 4162, 4163, 4168, 4172, 4175, 4176, 4177, 4180, 4184, 4188, 4191, 4192, 4195, 4203, 4208, 4213, 4214, 4215, 4230, 4231, 4236, 4240, 4244, 4245, 4247, 4262, 4263, 4271, 4287, 4296, 4322, 4337, 4366, 4385, 4403, 4408, 4449, 4459, 4464, 4467, 4469, 4472, 21227, 7330, 7334, 7338, 7339, 7340, 7341, 7342, 7343, 7344, 7345, 7356, 7364, 7368, 7369, 7370, 7374, 7375, 7380, 7383, 7384, 7390, 7392, 7429, 7430, 7431, 7448, 7449, 7450, 7460, 7467, 7495, 7505, 7513, 7516, 7518, 7526, 7533, 7534, 7535, 7541, 7542, 7543, 7557, 7559, 7582, 7587, 7589, 7601, 7610, 7611, 7612, 7613, 7614, 7617, 7618, 7619, 7620, 7627, 7628, 7629, 7630, 7632, 7648, 7653, 7654, 7655, 7661, 7662, 7667, 7669, 7674, 7715, 7717, 7719, 7730, 7741, 7752, 7753, 7755, 7756, 7777, 7785, 7790, 7791, 7792, 7793, 7794, 7818, 7829, 7846, 7850, 7857, 7858, 7864, 7865, 7866, 7867, 7868, 7869, 7888, 7893, 7894, 7895, 7896, 7903, 7942, 7943, 7947, 7953, 7954, 7955, 7956, 7957, 8002, 8003, 8004, 8005, 8006, 8018, 8029, 8034, 8036, 8037, 8038, 8053, 8054, 8057, 8059, 8076, 8077, 8078, 8083, 8090, 8091, 8105, 8106, 8117, 8118, 8125, 8143, 8144, 8145, 8146, 8147, 8148, 8149, 8166, 8179, 8180, 8230, 8471, 8610, 8611, 8612, 8615, 8640, 8652, 8659, 8665, 8666, 8667, 8668, 8675, 8682, 8683, 8687, 8688, 8693, 8697, 8698, 8699, 8711, 8719, 8740, 8742, 8743, 8744, 8754, 8777, 8779, 8780, 8781, 8782, 8783, 8784, 8785, 8786, 8787, 8788, 8789, 8790, 8803, 8806, 8818, 8820, 8830, 8833, 8840, 8847, 8848, 8849, 8850, 8863, 8870, 8871, 8897, 8907, 8908, 8909, 8912, 8934, 8954, 8955, 8960, 8961, 8962, 8981, 8982, 9028, 9029, 9030, 9047, 9058, 9060, 9092, 9093, 9094, 9095, 9106, 9107, 9108, 9109, 9110, 9111, 9112, 9123, 9129, 9133, 9145, 9149, 9150, 9151, 9152, 9163, 9164, 9169, 9177, 9178, 9179, 9181, 9182, 9201, 9202, 9203, 9209, 9215, 9216, 16942, 16941, 16940, 16939, 16937, 16936, 16935, 16934, 16925, 16923, 16922, 16918, 16916, 16913, 16912, 16911, 16907, 16905, 16900, 16898, 16897, 16813, 16801, 16799, 16798, 16797, 16796, 16793, 16792, 16790, 16783, 16764, 46454, 16758, 16753, 16751, 6967, 6966, 46462, 46461, 32174, 33380, 33381, 33388, 33850, 34911, 34912, 35554, 35556, 35557, 35559, 35561, 35565, 35572, 35574, 35575, 35576, 46303, 64038, 64091, 64092, 64093, 65060, 65071, 65074, 65076, 65077, 65079, 65080, 65081, 65082, 65084, 65087, 65088, 65089, 65090, 65091, 65094, 65100, 65104, 65105, 65106, 65108, 65111, 65120, 65312, 65318, 65320, 65321, 65322, 65325, 65326, 65327, 65328, 65330, 65331, 65332, 65333, 65334, 65368, 65370, 65372, 65373, 65374, 86309, 86319, 86335, 86341, 86343, 86854, 86961, 86974, 86976, 86977, 86983, 87245, 87266, 87337, 87346, 87353, 87368, 87372); +DELETE FROM `gameobject_addon` WHERE `guid` IN (29997, 3030, 3031, 3034, 3038, 3111, 3112, 3176, 3332, 3362, 3435, 3545, 3564, 3607, 3608, 3609, 3610, 3671, 3676, 3853, 3926, 3927, 3931, 4046, 4078, 4102, 4104, 4151, 4156, 4171, 4182, 4201, 4204, 4250, 4256, 4257, 4260, 4278, 4354, 4371, 4444, 4445, 4450, 4492, 4497, 4498, 21279, 21220, 7357, 7379, 7388, 7389, 7391, 7396, 7397, 7401, 7402, 7403, 7404, 7405, 7406, 7407, 7408, 7409, 7415, 7420, 7421, 7422, 7423, 7424, 7436, 7451, 7452, 7457, 7459, 7465, 7474, 7507, 7508, 7510, 7511, 7512, 7515, 7527, 7529, 7548, 7549, 7550, 7551, 7552, 7575, 7576, 7585, 7621, 7646, 7647, 7665, 7668, 7670, 7675, 7678, 7683, 7684, 7685, 7688, 7689, 7690, 7691, 7696, 7697, 7699, 7702, 7704, 7707, 7716, 7721, 7723, 7731, 7732, 7738, 7760, 7768, 7773, 7774, 7775, 7797, 7820, 7822, 7825, 7831, 7832, 7841, 7843, 7902, 7906, 7919, 7959, 7981, 7982, 7989, 8015, 8026, 8030, 8051, 8055, 8062, 8063, 8064, 8071, 8092, 8102, 8120, 8128, 8130, 8132, 8133, 8162, 8164, 8172, 8174, 8190, 8191, 8192, 8193, 8194, 8195, 8196, 8197, 8198, 8199, 8200, 8201, 8202, 8203, 8204, 8205, 8206, 8207, 8208, 8209, 8210, 8211, 8212, 8213, 8214, 8215, 8240, 8526, 8621, 8622, 8624, 8625, 8630, 8631, 8633, 8634, 8635, 8638, 8639, 8649, 8654, 8655, 8680, 8684, 8685, 8715, 8716, 8747, 8749, 8752, 8753, 8769, 8771, 8792, 8798, 8819, 8851, 8855, 8867, 8873, 8878, 8885, 8892, 8926, 8927, 8939, 8946, 8974, 8984, 8987, 8988, 8989, 8990, 8991, 9002, 9004, 9008, 9009, 9010, 9031, 9046, 9048, 9049, 9050, 9051, 9057, 9102, 9105, 9141, 9142, 9143, 9162, 9165, 9171, 9172, 9173, 9190, 9191, 9211, 9213, 33310, 33305, 33203, 33201, 33197, 33174, 33168, 33141, 33140, 33137, 33135, 32693, 32644, 32643, 32284, 32217, 32211, 32210, 32209, 32204, 32203, 32202, 32201, 32200, 32199, 32198, 32197, 32195, 32194, 32190, 32188, 35372, 35375, 35379, 35388, 35389, 35390, 32185, 35394, 32182, 35397, 35404, 35407, 32114, 63407, 64067, 64094, 65095, 65310, 86323, 86336, 86801, 86808, 86836, 87249); +DELETE FROM `pool_gameobject` WHERE `pool_entry`=959; +DELETE FROM `pool_template` WHERE `entry`= 959; |