|
   |
| Модератор форума: Dimitro |
| Форум » TrinityCore » Патчи / Моды / Фиксы для Trinity » фиксы в базу для 4.3.4 |
| фиксы в базу для 4.3.4 |
Выкладываю фиксы может кому пригодится
4.3.4 фикс на лут Throne of the Four Winds Код UPDATE creature_template SET lootid =45870 WHERE entry = 45870; UPDATE creature_template SET lootid =45871 WHERE entry =45871; UPDATE creature_template SET lootid =45872 WHERE entry = 45872; UPDATE creature_template SET lootid =46753 WHERE entry = 46753; DELETE FROM `creature_loot_template` WHERE entry =45870; INSERT INTO `creature_loot_template` VALUES ('45870', '63497', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45870', '63498', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45870', '63490', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45870', '63493', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45870', '63488', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45870', '63495', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45870', '63496', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45870', '63489', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45870', '63491', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45870', '63494', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45870', '63492', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45870', '65367', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45870', '65368', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45870', '65369', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45870', '65370', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45870', '65371', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45870', '65372', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45870', '65373', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45870', '65374', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45870', '65375', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45870', '65376', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45870', '65377', '0.55', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =45872; INSERT INTO `creature_loot_template` VALUES ('45872', '63488', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45872', '63489', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45872', '63490', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45872', '63491', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45872', '63492', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45872', '63493', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45872', '63494', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45872', '63495', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45872', '63496', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45872', '63497', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45872', '63498', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45872', '65367', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45872', '65368', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45872', '65369', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45872', '65370', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45872', '65371', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45872', '65372', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45872', '65373', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45872', '65374', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45872', '65375', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45872', '65376', '0.55', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45872', '65377', '0.55', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =46753; INSERT INTO `creature_loot_template` VALUES ('46753', '63507', '13.1188', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '63505', '12.3639', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '63506', '12.2153', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '63504', '11.2624', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '63499', '9.1584', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '63501', '9.0718', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '63503', '8.9356', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '63502', '8.8985', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '63500', '8.7995', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '64314', '7.3515', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '63682', '7.302', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '64315', '6.9678', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '63684', '6.7698', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '64316', '6.7079', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '63683', '6.5223', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '68127', '4.3317', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '66998', '3.5025', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '68129', '3.1807', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '68128', '2.8094', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '65384', '0.7921', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '63041', '0.7426', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '65000', '0.7178', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '65386', '0.6807', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '65001', '0.5569', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '65385', '0.5322', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '65382', '0.4827', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '65378', '0.4084', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '65087', '0.3837', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '65383', '0.3837', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '65088', '0.3465', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '65002', '0.3218', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '65379', '0.3218', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '65380', '0.2847', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '65381', '0.2228', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '65089', '0.1856', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '68132', '0.1733', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '68131', '0.0743', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '68130', '0.0619', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '69827', '7', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '69828', '7', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '69830', '7', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '69829', '6', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '69878', '0.5', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '69882', '0.5', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '69881', '0.4', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '69834', '0.5', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '69831', '0.5', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '69885', '0.7', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '69883', '0.6', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '69880', '0.7', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '69879', '0.5', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('46753', '69884', '0.5', '1', '0', '1', '1'); DELETE FROM creature_loot_template WHERE entry =45871; INSERT INTO `creature_loot_template` VALUES ('45871', '63497', '23', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45871', '63496', '23', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45871', '63494', '23', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45871', '63498', '23', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45871', '63495', '23', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45871', '63489', '19', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45871', '63490', '19', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45871', '63492', '19', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45871', '63491', '19', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45871', '63493', '19', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45871', '63488', '18', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45871', '65377', '2', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45871', '65373', '2', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45871', '65376', '2', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45871', '65375', '2', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45871', '71716', '2', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45871', '65370', '1.9', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45871', '65374', '1.8', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45871', '65367', '1.8', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45871', '65369', '1.8', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45871', '65372', '1.7', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45871', '65368', '1.7', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('45871', '65371', '1.6', '1', '0', '1', '1'); Фикс на лут loot-npc-zulaman Код UPDATE creature_template SET lootid =23587 WHERE entry = 23587; UPDATE creature_template SET lootid =24138 WHERE entry = 24138; UPDATE creature_template SET lootid =24175 WHERE entry = 24175; UPDATE creature_template SET lootid =52956 WHERE entry = 52956; UPDATE creature_template SET lootid =52958 WHERE entry = 52958; UPDATE creature_template SET lootid =52962 WHERE entry = 52962; UPDATE creature_template SET lootid =53021 WHERE entry = 53021; DELETE FROM creature WHERE id =52914; INSERT INTO `creature` VALUES ('6829051', '52914', '568', '1', '1', '0', '0', '133.085', '1638.14', '42.0216', '3.1848', '300', '0', '0', '34', '0', '0', '0', '0', '0'); UPDATE creature_template SET exp =3 WHERE entry =52914; UPDATE creature_template SET npcflag =384 WHERE entry =52914; DELETE FROM npc_vendor WHERE entry =52914; INSERT INTO `npc_vendor` VALUES ('52914', '0', '33928', '0', '0', '0', '1'); DELETE FROM creature WHERE id =52915; INSERT INTO `creature` VALUES ('6829047', '52915', '568', '1', '1', '0', '0', '108.074', '1642.84', '42.0216', '0.0903299', '300', '0', '0', '4675', '0', '0', '0', '0', '0'); UPDATE creature_template SET exp =3 WHERE entry =52915; DELETE FROM npc_vendor WHERE entry =52915; INSERT INTO `npc_vendor` VALUES ('52915', '0', '58261', '0', '0', '0', '1'); INSERT INTO `npc_vendor` VALUES ('52915', '0', '58257', '0', '0', '0', '1'); INSERT INTO `npc_vendor` VALUES ('52915', '0', '58260', '0', '0', '0', '1'); INSERT INTO `npc_vendor` VALUES ('52915', '0', '58256', '0', '0', '0', '1'); INSERT INTO `npc_vendor` VALUES ('52915', '0', '58274', '0', '0', '0', '1'); INSERT INTO `npc_vendor` VALUES ('52915', '0', '58275', '0', '0', '0', '1'); DELETE FROM npc_vendor WHERE entry =23897; INSERT INTO `npc_vendor` VALUES ('23897', '0', '59230', '0', '0', '0', '1'); INSERT INTO `npc_vendor` VALUES ('23897', '0', '59228', '0', '0', '0', '1'); INSERT INTO `npc_vendor` VALUES ('23897', '0', '59229', '0', '0', '0', '1'); INSERT INTO `npc_vendor` VALUES ('23897', '0', '59227', '0', '0', '0', '1'); DELETE FROM creature WHERE id =52938; INSERT INTO `creature` VALUES ('6829053', '52938', '568', '1', '1', '0', '0', '120.952', '1609.96', '43.4835', '4.72025', '300', '0', '0', '176043', '0', '0', '0', '0', '0'); DELETE FROM creature WHERE id =52933; INSERT INTO `creature` VALUES ('6829055', '52933', '568', '1', '1', '0', '0', '110.461', '1682.22', '42.0218', '4.87734', '300', '0', '0', '58681', '0', '0', '0', '0', '0'); DELETE FROM creature WHERE id =52924; INSERT INTO `creature` VALUES ('6829135', '52924', '568', '1', '1', '0', '38225', '129.447', '1681.23', '42.0224', '4.62599', '300', '0', '0', '46944800', '0', '0', '0', '0', '0'); DELETE FROM `creature_loot_template` WHERE entry =23574; INSERT INTO `creature_loot_template` VALUES ('23574', '69549', '27', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23574', '69552', '18', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23574', '69551', '18', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23574', '69550', '18', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23574', '69553', '18', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =23863; INSERT INTO `creature_loot_template` VALUES ('23863', '52078', '87', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23863', '69581', '28', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23863', '69577', '22', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23863', '69576', '21', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23863', '69582', '21', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23863', '69574', '20', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23863', '69575', '18', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23863', '69579', '15', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23863', '69578', '15', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23863', '69583', '14', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23863', '69580', '14', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =23577; INSERT INTO `creature_loot_template` VALUES ('23577', '69566', '29', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23577', '69565', '21', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23577', '69564', '21', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23577', '69568', '14', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23577', '69567', '14', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =24239; INSERT INTO `creature_loot_template` VALUES ('24239', '69572', '19', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24239', '69571', '19', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24239', '69569', '18', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24239', '69570', '18', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24239', '69264', '17', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24239', '69573', '12', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24239', '70080', '6', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24239', '69762', '1', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =23578; INSERT INTO `creature_loot_template` VALUES ('23578', '69559', '23', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23578', '69560', '23', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23578', '69563', '23', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23578', '69562', '15', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23578', '69561', '15', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =23576; INSERT INTO `creature_loot_template` VALUES ('23576', '69557', '25', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23576', '69554', '24', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23576', '69555', '17', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23576', '69556', '16', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23576', '69558', '16', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =23584; INSERT INTO `creature_loot_template` VALUES ('23584', '25418', '5', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23584', '25421', '1.1', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23584', '27854', '0.3', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23584', '27860', '0.18', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =24047; INSERT INTO `creature_loot_template` VALUES ('24047', '30466', '6', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24047', '30467', '1.5', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24047', '27854', '0.3', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24047', '27860', '0.17', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =23834; INSERT INTO `creature_loot_template` VALUES ('23834', '25426', '8', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23834', '25428', '1.8', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23834', '27854', '0.4', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =24530; INSERT INTO `creature_loot_template` VALUES ('24530', '25418', '3', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24530', '25421', '0.7', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24530', '27854', '0.14', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24530', '27860', '0.08', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =24043; INSERT INTO `creature_loot_template` VALUES ('24043', '25418', '3', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24043', '25421', '0.6', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24043', '27854', '0.13', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24043', '27860', '0.07', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =24064; INSERT INTO `creature_loot_template` VALUES ('24064', '25418', '25', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24064', '25421', '6', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24064', '27854', '1.3', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24064', '27860', '0.06', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =23542; INSERT INTO `creature_loot_template` VALUES ('23542', '33865', '27', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23542', '21877', '2', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23542', '27854', '0.4', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23542', '33106', '0.2', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23542', '27860', '0.19', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23542', '22829', '0.1', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =24059; INSERT INTO `creature_loot_template` VALUES ('24059', '33865', '29', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24059', '21877', '8', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24059', '27854', '1.3', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24059', '27860', '0.6', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24059', '22829', '0.4', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =24374; INSERT INTO `creature_loot_template` VALUES ('24374', '33865', '29', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24374', '21877', '8', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24374', '27854', '1.3', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24374', '27860', '0.6', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24374', '22829', '0.4', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =23596; INSERT INTO `creature_loot_template` VALUES ('23596', '33865', '29', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23596', '21877', '8', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23596', '27854', '1.3', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23596', '27860', '0.6', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23596', '22829', '0.4', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =23597; INSERT INTO `creature_loot_template` VALUES ('23597', '33865', '27', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23597', '21877', '2', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23597', '27854', '0.4', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23597', '33106', '0.2', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23597', '27860', '0.19', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23597', '22829', '0.1', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =24065; INSERT INTO `creature_loot_template` VALUES ('24065', '33865', '29', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24065', '21877', '8', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24065', '27854', '1.3', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24065', '27860', '0.6', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24065', '22829', '0.4', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =24175; INSERT INTO `creature_loot_template` VALUES ('24175', '63349', '24', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24175', '63310', '24', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24175', '58269', '21', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24175', '63291', '17', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24175', '63317', '14', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24175', '63316', '10', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24175', '63348', '7', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24175', '63300', '3', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =23581; INSERT INTO `creature_loot_template` VALUES ('23581', '33865', '26', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23581', '21877', '2', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23581', '27854', '1.4', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23581', '27860', '0.2', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23581', '22829', '0.2', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =53021; INSERT INTO `creature_loot_template` VALUES ('53021', '53010', '56', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('53021', '68198', '20', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('53021', '58268', '11', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('53021', '58256', '6', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =24180; INSERT INTO `creature_loot_template` VALUES ('24180', '33865', '41', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24180', '21877', '37', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24180', '27854', '7', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24180', '33106', '5', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24180', '27860', '4', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24180', '22829', '1.9', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =23587; INSERT INTO `creature_loot_template` VALUES ('23587', '63317', '41', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23587', '63291', '24', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23587', '63348', '24', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23587', '63310', '18', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =23586; INSERT INTO `creature_loot_template` VALUES ('23586', '21877', '41', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23586', '27854', '24', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23586', '27860', '24', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23586', '22829', '18', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23586', '22832', '18', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =24549; INSERT INTO `creature_loot_template` VALUES ('24549', '33865', '41', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24549', '33106', '22', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24549', '21877', '21', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24549', '27854', '20', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24549', '27860', '14', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24549', '22829', '11', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24549', '22832', '11', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =23774; INSERT INTO `creature_loot_template` VALUES ('23774', '33865', '41', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23774', '33106', '31', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23774', '21877', '21', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23774', '27854', '14', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23774', '27860', '14', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23774', '22829', '11', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23774', '22832', '11', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =23582; INSERT INTO `creature_loot_template` VALUES ('23582', '33865', '28', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23582', '33106', '2', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23582', '21877', '0.3', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23582', '27854', '0.1', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23582', '27860', '0.1', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23582', '22829', '0.1', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23582', '22832', '0.1', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =23580; INSERT INTO `creature_loot_template` VALUES ('23580', '33865', '28', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23580', '33106', '2', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23580', '21877', '0.3', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23580', '27854', '0.1', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('23580', '27860', '0.1', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =24179; INSERT INTO `creature_loot_template` VALUES ('24179', '33865', '28', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24179', '33106', '2', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24179', '21877', '0.3', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24179', '27854', '0.1', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24179', '27860', '0.1', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24179', '22829', '0.1', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24179', '22832', '0.1', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =24138; INSERT INTO `creature_loot_template` VALUES ('24138', '60576', '28', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24138', '33865', '2', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('24138', '60577', '0.3', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =52958; INSERT INTO `creature_loot_template` VALUES ('52958', '53010', '28', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('52958', '68198', '2', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('52958', '58268', '0.3', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('52958', '58256', '0.3', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =52962; INSERT INTO `creature_loot_template` VALUES ('52962', '53010', '28', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('52962', '68198', '2', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('52962', '58268', '0.3', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('52962', '58256', '0.3', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('52962', '68197', '0.3', '1', '0', '1', '1'); DELETE FROM `creature_loot_template` WHERE entry =52956; INSERT INTO `creature_loot_template` VALUES ('52956', '53010', '28', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('52956', '68198', '2', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('52956', '58268', '0.3', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('52956', '58256', '0.3', '1', '0', '1', '1'); INSERT INTO `creature_loot_template` VALUES ('52956', '68197', '0.3', '1', '0', '1', '1'); DELETE FROM reference_loot_template WHERE entry =34078; DELETE FROM reference_loot_template WHERE entry =34079; DELETE FROM reference_loot_template WHERE entry =34150; DELETE FROM reference_loot_template WHERE entry =34151; DELETE FROM reference_loot_template WHERE entry =34152; DELETE FROM reference_loot_template WHERE entry =34153; Добавлено (23.02.2013, 00:56) --------------------------------------------- 687-world-misc-434-update Код -- Mark of the Wild DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=1126; DELETE FROM `spell_script_names` WHERE `spell_id`=1126 OR `ScriptName`='spell_dru_mark_of_the_wild'; INSERT INTO `spell_script_names` VALUES (1126,'spell_dru_mark_of_the_wild'); -- Arcane Brilliance DELETE FROM `spell_script_names` WHERE `spell_id`=1459 OR `ScriptName`='spell_mage_arcane_brilliance'; INSERT INTO `spell_script_names` VALUES (1459,'spell_mage_arcane_brilliance'); -- Dalaran Brilliance DELETE FROM `spell_script_names` WHERE `spell_id`=61316 OR `ScriptName`='spell_mage_dalaran_brilliance'; INSERT INTO `spell_script_names` VALUES (61316,'spell_mage_dalaran_brilliance'); -- Blessing of Kings DELETE FROM `spell_script_names` WHERE `spell_id`=20217 OR `ScriptName`='spell_pal_blessing_of_kings'; INSERT INTO `spell_script_names` VALUES (20217,'spell_pal_blessing_of_kings'); -- Blessing of Might DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=19740; DELETE FROM `spell_script_names` WHERE `spell_id`=19740 OR `ScriptName`='spell_pal_blessing_of_might'; INSERT INTO `spell_script_names` VALUES (19740,'spell_pal_blessing_of_might'); -- Power Word: Fortitude DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=21562; DELETE FROM `spell_script_names` WHERE `spell_id`=21562 OR `ScriptName`='spell_pri_power_word_fortitude'; INSERT INTO `spell_script_names` VALUES (21562,'spell_pri_power_word_fortitude'); -- Shadow Protection DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=27683; DELETE FROM `spell_scripts` WHERE `id`=27683; DELETE FROM `spell_script_names` WHERE `spell_id`=27683 OR `ScriptName`='spell_pri_shadow_protection'; INSERT INTO `spell_script_names` VALUES (27683,'spell_pri_shadow_protection'); -- -------- DELETE FROM `command` WHERE `name`='flusharenapoints'; DELETE FROM `trinity_string` WHERE `entry` IN ('741','742','743','744','745','746'); Fixed Darkflight Код UPDATE `instance_template` SET `script`='instance_baradin_hold' WHERE `map`=757; DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (77769, -77769); INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (77769, 82946, 2, 'Trap Launcher - Add/Remove'); DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gen_running_wild'; DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gen_two_forms'; DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gen_darkflight'; INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (87840,'spell_gen_running_wild'), (68996,'spell_gen_two_forms'), (68992,'spell_gen_darkflight'); -- 85256 - Templar's Verdict DELETE FROM `spell_script_names` WHERE `spell_id`=85256; INSERT INTO `spell_script_names` VALUES (85256,'spell_pal_templar_s_verdict'); Добавлено (23.02.2013, 01:26) --------------------------------------------- zul gurub 4.3.4 fix Код UPDATE `creature_template` SET `ScriptName`='npc_chained_spirit' WHERE `entry`=52156; UPDATE `creature_template` SET `ScriptName`='npc_ohgan' WHERE `entry`=52157; DELETE FROM `creature` WHERE `id`=52156; DELETE FROM `spell_script_names` WHERE `spell_id` IN (96682,96776,96761,96821,96721,96722,96724,96740,28471); INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (96682,'spell_mandokir_decapitate'), (96776,'spell_mandokir_bloodletting'), (96761,'spell_mandokir_devastating_slam'), (96821,'spell_mandokir_spirit_vengeance_cancel'), (96721,'spell_mandokir_ohgan_orders'), (96722,'spell_mandokir_ohgan_orders_trigger'), (96724,'spell_mandokir_reanimate_ohgan'), (96740,'spell_mandokir_devastating_slam_damage'), (28471,'spell_clear_all'); DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`IN (96724,96721); INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (13, 3, 96724, 0, 0, 31, 0, 3, 52157, 0, 0, 0, 0, '', 'Earth Spike - Ohgan'), (13, 1, 96721, 0, 0, 31, 0, 3, 52156, 0, 0, 0, 0, '', 'Ohgan''s Orders - Chained Spirit'); DELETE FROM `achievement_criteria_data` WHERE `criteria_id`=16848; INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`, `ScriptName`) VALUES (16848,11,0,0,'achievement_ohganot_so_fast'), (16848,12,1,0,''); |
| |||
| |||