diff options
| -rw-r--r-- | sql/updates/hotfixes/2015_05_02_00_hotfixes.sql | 220 |
1 files changed, 220 insertions, 0 deletions
diff --git a/sql/updates/hotfixes/2015_05_02_00_hotfixes.sql b/sql/updates/hotfixes/2015_05_02_00_hotfixes.sql new file mode 100644 index 00000000000..7260bd50b85 --- /dev/null +++ b/sql/updates/hotfixes/2015_05_02_00_hotfixes.sql @@ -0,0 +1,220 @@ +DELETE FROM `hotfix_data` WHERE (`TableHash`=331613093 AND `RecordID`=185123 AND `Timestamp`=1430365287) OR (`TableHash`=331613093 AND `RecordID`=212293 AND `Timestamp`=1430365287) OR (`TableHash`=599752208 AND `RecordID`=1789 AND `Timestamp`=1430365287) OR (`TableHash`=599752208 AND `RecordID`=1790 AND `Timestamp`=1430365287) OR (`TableHash`=599752208 AND `RecordID`=1791 AND `Timestamp`=1430365287) OR (`TableHash`=599752208 AND `RecordID`=1792 AND `Timestamp`=1430365287) OR (`TableHash`=599752208 AND `RecordID`=1793 AND `Timestamp`=1430365287) OR (`TableHash`=599752208 AND `RecordID`=1794 AND `Timestamp`=1430365287) OR (`TableHash`=666345498 AND `RecordID`=83942 AND `Timestamp`=1430365287) OR (`TableHash`=666345498 AND `RecordID`=83982 AND `Timestamp`=1430365287) OR (`TableHash`=666345498 AND `RecordID`=83983 AND `Timestamp`=1430365287) OR (`TableHash`=666345498 AND `RecordID`=84043 AND `Timestamp`=1430365287) OR (`TableHash`=1344507586 AND `RecordID`=120989 AND `Timestamp`=1430365287) OR (`TableHash`=1344507586 AND `RecordID`=121820 AND `Timestamp`=1430365287) OR (`TableHash`=1344507586 AND `RecordID`=121837 AND `Timestamp`=1430365287) OR (`TableHash`=1344507586 AND `RecordID`=122101 AND `Timestamp`=1430365287) OR (`TableHash`=1344507586 AND `RecordID`=122147 AND `Timestamp`=1430365287) OR (`TableHash`=1344507586 AND `RecordID`=122154 AND `Timestamp`=1430365287) OR (`TableHash`=1344507586 AND `RecordID`=122706 AND `Timestamp`=1430365287) OR (`TableHash`=1344507586 AND `RecordID`=122707 AND `Timestamp`=1430365287) OR (`TableHash`=1627543382 AND `RecordID`=16443 AND `Timestamp`=1430365287) OR (`TableHash`=1821637041 AND `RecordID`=1449 AND `Timestamp`=1430365287) OR (`TableHash`=1821637041 AND `RecordID`=1636 AND `Timestamp`=1430365287) OR (`TableHash`=1880017466 AND `RecordID`=3101 AND `Timestamp`=1430365287) OR (`TableHash`=1880017466 AND `RecordID`=4865 AND `Timestamp`=1430365287); +DELETE FROM `hotfix_data` WHERE (`TableHash`=1880017466 AND `RecordID`=5182 AND `Timestamp`=1430365287) OR (`TableHash`=3108775943 AND `RecordID`=6148 AND `Timestamp`=1430365287) OR (`TableHash`=3108775943 AND `RecordID`=7498 AND `Timestamp`=1430365287) OR (`TableHash`=3108775943 AND `RecordID`=7499 AND `Timestamp`=1430365287) OR (`TableHash`=3108775943 AND `RecordID`=7501 AND `Timestamp`=1430365287) OR (`TableHash`=3108775943 AND `RecordID`=7743 AND `Timestamp`=1430365287) OR (`TableHash`=3108775943 AND `RecordID`=8980 AND `Timestamp`=1430365287) OR (`TableHash`=3108775943 AND `RecordID`=8981 AND `Timestamp`=1430365287) OR (`TableHash`=3108775943 AND `RecordID`=8989 AND `Timestamp`=1430365287) OR (`TableHash`=3108775943 AND `RecordID`=8990 AND `Timestamp`=1430365287) OR (`TableHash`=3108775943 AND `RecordID`=8993 AND `Timestamp`=1430365287) OR (`TableHash`=3108775943 AND `RecordID`=9915 AND `Timestamp`=1430365287) OR (`TableHash`=3108775943 AND `RecordID`=9916 AND `Timestamp`=1430365287) OR (`TableHash`=3108775943 AND `RecordID`=9917 AND `Timestamp`=1430365287) OR (`TableHash`=3108775943 AND `RecordID`=9918 AND `Timestamp`=1430365287) OR (`TableHash`=3108775943 AND `RecordID`=9920 AND `Timestamp`=1430365287) OR (`TableHash`=3108775943 AND `RecordID`=9921 AND `Timestamp`=1430365287) OR (`TableHash`=3108775943 AND `RecordID`=10265 AND `Timestamp`=1430365287) OR (`TableHash`=3108775943 AND `RecordID`=11037 AND `Timestamp`=1430365287) OR (`TableHash`=3108775943 AND `RecordID`=12747 AND `Timestamp`=1430365287) OR (`TableHash`=3108775943 AND `RecordID`=13736 AND `Timestamp`=1430365287) OR (`TableHash`=3108775943 AND `RecordID`=28354 AND `Timestamp`=1430365287) OR (`TableHash`=3108775943 AND `RecordID`=34074 AND `Timestamp`=1430365287) OR (`TableHash`=3108775943 AND `RecordID`=34075 AND `Timestamp`=1430365287) OR (`TableHash`=3108775943 AND `RecordID`=34076 AND `Timestamp`=1430365287); +DELETE FROM `hotfix_data` WHERE (`TableHash`=3108775943 AND `RecordID`=34077 AND `Timestamp`=1430365287) OR (`TableHash`=3108775943 AND `RecordID`=34078 AND `Timestamp`=1430365287) OR (`TableHash`=3108775943 AND `RecordID`=34079 AND `Timestamp`=1430365287) OR (`TableHash`=3108775943 AND `RecordID`=34081 AND `Timestamp`=1430365287) OR (`TableHash`=3108775943 AND `RecordID`=34082 AND `Timestamp`=1430365287) OR (`TableHash`=3108775943 AND `RecordID`=34083 AND `Timestamp`=1430365287) OR (`TableHash`=3130494798 AND `RecordID`=10037 AND `Timestamp`=1430365287) OR (`TableHash`=3322146344 AND `RecordID`=126057 AND `Timestamp`=1430365287) OR (`TableHash`=3322146344 AND `RecordID`=129047 AND `Timestamp`=1430365287) OR (`TableHash`=3322146344 AND `RecordID`=129096 AND `Timestamp`=1430365287) OR (`TableHash`=3322146344 AND `RecordID`=130275 AND `Timestamp`=1430365287) OR (`TableHash`=3322146344 AND `RecordID`=130608 AND `Timestamp`=1430365287) OR (`TableHash`=3322146344 AND `RecordID`=133297 AND `Timestamp`=1430365287) OR (`TableHash`=3322146344 AND `RecordID`=133455 AND `Timestamp`=1430365287) OR (`TableHash`=3322146344 AND `RecordID`=136620 AND `Timestamp`=1430365287) OR (`TableHash`=3322146344 AND `RecordID`=137703 AND `Timestamp`=1430365287) OR (`TableHash`=3322146344 AND `RecordID`=140581 AND `Timestamp`=1430365287) OR (`TableHash`=3322146344 AND `RecordID`=142312 AND `Timestamp`=1430365287) OR (`TableHash`=3322146344 AND `RecordID`=147181 AND `Timestamp`=1430365287) OR (`TableHash`=3322146344 AND `RecordID`=147185 AND `Timestamp`=1430365287) OR (`TableHash`=3322146344 AND `RecordID`=147186 AND `Timestamp`=1430365287) OR (`TableHash`=3322146344 AND `RecordID`=148759 AND `Timestamp`=1430365287) OR (`TableHash`=3322146344 AND `RecordID`=148760 AND `Timestamp`=1430365287) OR (`TableHash`=3322146344 AND `RecordID`=148827 AND `Timestamp`=1430365287) OR (`TableHash`=3322146344 AND `RecordID`=149497 AND `Timestamp`=1430365287); +DELETE FROM `hotfix_data` WHERE (`TableHash`=3322146344 AND `RecordID`=150373 AND `Timestamp`=1430365287) OR (`TableHash`=3322146344 AND `RecordID`=152224 AND `Timestamp`=1430365287) OR (`TableHash`=3322146344 AND `RecordID`=153925 AND `Timestamp`=1430365287) OR (`TableHash`=3322146344 AND `RecordID`=158926 AND `Timestamp`=1430365287) OR (`TableHash`=3322146344 AND `RecordID`=159299 AND `Timestamp`=1430365287) OR (`TableHash`=3326241424 AND `RecordID`=1708 AND `Timestamp`=1430365287) OR (`TableHash`=3326241424 AND `RecordID`=1709 AND `Timestamp`=1430365287) OR (`TableHash`=3326241424 AND `RecordID`=1710 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=73406 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=73419 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=73504 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=73517 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=73546 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=73702 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=73703 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=73945 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=73994 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=74104 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=74385 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=74466 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=74635 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=75757 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=75759 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=75760 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=76334 AND `Timestamp`=1430365287); +DELETE FROM `hotfix_data` WHERE (`TableHash`=3386943305 AND `RecordID`=77758 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78254 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78256 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78257 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78258 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78259 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78346 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78347 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78348 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78349 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78350 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78351 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78352 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78353 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78395 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78399 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78404 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78670 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78728 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78729 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78730 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78731 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78734 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78738 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78739 AND `Timestamp`=1430365287); +DELETE FROM `hotfix_data` WHERE (`TableHash`=3386943305 AND `RecordID`=78742 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78743 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78746 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78747 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78750 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78751 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78758 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78759 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78904 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78906 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78988 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78989 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78990 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=78991 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=79817 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=79823 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=79824 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=79825 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=80244 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=80245 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=80246 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=80317 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=80318 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=80652 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=80653 AND `Timestamp`=1430365287); +DELETE FROM `hotfix_data` WHERE (`TableHash`=3386943305 AND `RecordID`=80654 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=80658 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=80659 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=80660 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=80667 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=80668 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=80669 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=81731 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=82327 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=82328 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=82329 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=83010 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=83011 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=83012 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=83756 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=84264 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=85199 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=85263 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=85264 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=85265 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=85266 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=85267 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=85268 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=85269 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=85270 AND `Timestamp`=1430365287); +DELETE FROM `hotfix_data` WHERE (`TableHash`=3386943305 AND `RecordID`=86788 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=88104 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=88105 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=88110 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=88111 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=88113 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=88115 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=88116 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=89548 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=89649 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=89660 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=89684 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=90161 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=90200 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=90302 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=90305 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=90354 AND `Timestamp`=1430365287) OR (`TableHash`=3386943305 AND `RecordID`=90371 AND `Timestamp`=1430365287); +INSERT INTO `hotfix_data` (`TableHash`, `RecordID`, `Timestamp`, `Deleted`) VALUES +(331613093, 185123, 1430365287, 1), -- GameObjects - 185123 - 185123 +(331613093, 212293, 1430365287, 1), -- GameObjects - 212293 - 212293 +(599752208, 1789, 1430365287, 0), -- SpellEffectGroupSize - 1789 - 1789 +(599752208, 1790, 1430365287, 0), -- SpellEffectGroupSize - 1790 - 1790 +(599752208, 1791, 1430365287, 0), -- SpellEffectGroupSize - 1791 - 1791 +(599752208, 1792, 1430365287, 0), -- SpellEffectGroupSize - 1792 - 1792 +(599752208, 1793, 1430365287, 0), -- SpellEffectGroupSize - 1793 - 1793 +(599752208, 1794, 1430365287, 0), -- SpellEffectGroupSize - 1794 - 1794 +(666345498, 83942, 1430365287, 1), -- SpellXSpellVisual - 83942 - 83942 +(666345498, 83982, 1430365287, 1), -- SpellXSpellVisual - 83982 - 83982 +(666345498, 83983, 1430365287, 1), -- SpellXSpellVisual - 83983 - 83983 +(666345498, 84043, 1430365287, 1), -- SpellXSpellVisual - 84043 - 84043 +(1344507586, 120989, 1430365287, 0), -- Item - 120989 - 120989 +(1344507586, 121820, 1430365287, 0), -- Item - 121820 - 121820 +(1344507586, 121837, 1430365287, 0), -- Item - 121837 - 121837 +(1344507586, 122101, 1430365287, 0), -- Item - 122101 - 122101 +(1344507586, 122147, 1430365287, 0), -- Item - 122147 - 122147 +(1344507586, 122154, 1430365287, 0), -- Item - 122154 - 122154 +(1344507586, 122706, 1430365287, 0), -- Item - 122706 - 122706 +(1344507586, 122707, 1430365287, 0), -- Item - 122707 - 122707 +(1627543382, 16443, 1430365287, 0), -- SpellCastingRequirements - 16443 - 16443 +(1821637041, 1449, 1430365287, 0), -- BattlePetSpecies - 1449 - 1449 +(1821637041, 1636, 1430365287, 0), -- BattlePetSpecies - 1636 - 1636 +(1880017466, 3101, 1430365287, 0), -- CurvePoint - 3101 - 3101 +(1880017466, 4865, 1430365287, 0), -- CurvePoint - 4865 - 4865 +(1880017466, 5182, 1430365287, 0), -- CurvePoint - 5182 - 5182 +(3108775943, 6148, 1430365287, 1), -- PlayerCondition - 6148 - 6148 +(3108775943, 7498, 1430365287, 1), -- PlayerCondition - 7498 - 7498 +(3108775943, 7499, 1430365287, 1), -- PlayerCondition - 7499 - 7499 +(3108775943, 7501, 1430365287, 1), -- PlayerCondition - 7501 - 7501 +(3108775943, 7743, 1430365287, 1), -- PlayerCondition - 7743 - 7743 +(3108775943, 8980, 1430365287, 1), -- PlayerCondition - 8980 - 8980 +(3108775943, 8981, 1430365287, 1), -- PlayerCondition - 8981 - 8981 +(3108775943, 8989, 1430365287, 1), -- PlayerCondition - 8989 - 8989 +(3108775943, 8990, 1430365287, 1), -- PlayerCondition - 8990 - 8990 +(3108775943, 8993, 1430365287, 1), -- PlayerCondition - 8993 - 8993 +(3108775943, 9915, 1430365287, 1), -- PlayerCondition - 9915 - 9915 +(3108775943, 9916, 1430365287, 1), -- PlayerCondition - 9916 - 9916 +(3108775943, 9917, 1430365287, 1), -- PlayerCondition - 9917 - 9917 +(3108775943, 9918, 1430365287, 1), -- PlayerCondition - 9918 - 9918 +(3108775943, 9920, 1430365287, 1), -- PlayerCondition - 9920 - 9920 +(3108775943, 9921, 1430365287, 1), -- PlayerCondition - 9921 - 9921 +(3108775943, 10265, 1430365287, 1), -- PlayerCondition - 10265 - 10265 +(3108775943, 11037, 1430365287, 1), -- PlayerCondition - 11037 - 11037 +(3108775943, 12747, 1430365287, 1), -- PlayerCondition - 12747 - 12747 +(3108775943, 13736, 1430365287, 1), -- PlayerCondition - 13736 - 13736 +(3108775943, 28354, 1430365287, 1), -- PlayerCondition - 28354 - 28354 +(3108775943, 34074, 1430365287, 1), -- PlayerCondition - 34074 - 34074 +(3108775943, 34075, 1430365287, 1), -- PlayerCondition - 34075 - 34075 +(3108775943, 34076, 1430365287, 1), -- PlayerCondition - 34076 - 34076 +(3108775943, 34077, 1430365287, 1), -- PlayerCondition - 34077 - 34077 +(3108775943, 34078, 1430365287, 1), -- PlayerCondition - 34078 - 34078 +(3108775943, 34079, 1430365287, 1), -- PlayerCondition - 34079 - 34079 +(3108775943, 34081, 1430365287, 1), -- PlayerCondition - 34081 - 34081 +(3108775943, 34082, 1430365287, 1), -- PlayerCondition - 34082 - 34082 +(3108775943, 34083, 1430365287, 1), -- PlayerCondition - 34083 - 34083 +(3130494798, 10037, 1430365287, 0), -- SpellAuraRestrictions - 10037 - 10037 +(3322146344, 126057, 1430365287, 0), -- SpellMisc - 126057 - 126057 +(3322146344, 129047, 1430365287, 0), -- SpellMisc - 129047 - 129047 +(3322146344, 129096, 1430365287, 0), -- SpellMisc - 129096 - 129096 +(3322146344, 130275, 1430365287, 0), -- SpellMisc - 130275 - 130275 +(3322146344, 130608, 1430365287, 0), -- SpellMisc - 130608 - 130608 +(3322146344, 133297, 1430365287, 1), -- SpellMisc - 133297 - 133297 +(3322146344, 133455, 1430365287, 0), -- SpellMisc - 133455 - 133455 +(3322146344, 136620, 1430365287, 0), -- SpellMisc - 136620 - 136620 +(3322146344, 137703, 1430365287, 0), -- SpellMisc - 137703 - 137703 +(3322146344, 140581, 1430365287, 0), -- SpellMisc - 140581 - 140581 +(3322146344, 142312, 1430365287, 0), -- SpellMisc - 142312 - 142312 +(3322146344, 147181, 1430365287, 0), -- SpellMisc - 147181 - 147181 +(3322146344, 147185, 1430365287, 0), -- SpellMisc - 147185 - 147185 +(3322146344, 147186, 1430365287, 0), -- SpellMisc - 147186 - 147186 +(3322146344, 148759, 1430365287, 0), -- SpellMisc - 148759 - 148759 +(3322146344, 148760, 1430365287, 0), -- SpellMisc - 148760 - 148760 +(3322146344, 148827, 1430365287, 0), -- SpellMisc - 148827 - 148827 +(3322146344, 149497, 1430365287, 0), -- SpellMisc - 149497 - 149497 +(3322146344, 150373, 1430365287, 0), -- SpellMisc - 150373 - 150373 +(3322146344, 152224, 1430365287, 0), -- SpellMisc - 152224 - 152224 +(3322146344, 153925, 1430365287, 0), -- SpellMisc - 153925 - 153925 +(3322146344, 158926, 1430365287, 1), -- SpellMisc - 158926 - 158926 +(3322146344, 159299, 1430365287, 1), -- SpellMisc - 159299 - 159299 +(3326241424, 1708, 1430365287, 0), -- ChrUpgradeBucketSpell - 1708 - 1708 +(3326241424, 1709, 1430365287, 0), -- ChrUpgradeBucketSpell - 1709 - 1709 +(3326241424, 1710, 1430365287, 0), -- ChrUpgradeBucketSpell - 1710 - 1710 +(3386943305, 73406, 1430365287, 1), -- CreatureDifficulty - 73406 - 73406 +(3386943305, 73419, 1430365287, 1), -- CreatureDifficulty - 73419 - 73419 +(3386943305, 73504, 1430365287, 1), -- CreatureDifficulty - 73504 - 73504 +(3386943305, 73517, 1430365287, 1), -- CreatureDifficulty - 73517 - 73517 +(3386943305, 73546, 1430365287, 1), -- CreatureDifficulty - 73546 - 73546 +(3386943305, 73702, 1430365287, 1), -- CreatureDifficulty - 73702 - 73702 +(3386943305, 73703, 1430365287, 1), -- CreatureDifficulty - 73703 - 73703 +(3386943305, 73945, 1430365287, 1), -- CreatureDifficulty - 73945 - 73945 +(3386943305, 73994, 1430365287, 1), -- CreatureDifficulty - 73994 - 73994 +(3386943305, 74104, 1430365287, 0), -- CreatureDifficulty - 74104 - 74104 +(3386943305, 74385, 1430365287, 1), -- CreatureDifficulty - 74385 - 74385 +(3386943305, 74466, 1430365287, 1), -- CreatureDifficulty - 74466 - 74466 +(3386943305, 74635, 1430365287, 1), -- CreatureDifficulty - 74635 - 74635 +(3386943305, 75757, 1430365287, 0), -- CreatureDifficulty - 75757 - 75757 +(3386943305, 75759, 1430365287, 0), -- CreatureDifficulty - 75759 - 75759 +(3386943305, 75760, 1430365287, 0), -- CreatureDifficulty - 75760 - 75760 +(3386943305, 76334, 1430365287, 0), -- CreatureDifficulty - 76334 - 76334 +(3386943305, 77758, 1430365287, 1), -- CreatureDifficulty - 77758 - 77758 +(3386943305, 78254, 1430365287, 1), -- CreatureDifficulty - 78254 - 78254 +(3386943305, 78256, 1430365287, 0), -- CreatureDifficulty - 78256 - 78256 +(3386943305, 78257, 1430365287, 0), -- CreatureDifficulty - 78257 - 78257 +(3386943305, 78258, 1430365287, 0), -- CreatureDifficulty - 78258 - 78258 +(3386943305, 78259, 1430365287, 0), -- CreatureDifficulty - 78259 - 78259 +(3386943305, 78346, 1430365287, 1), -- CreatureDifficulty - 78346 - 78346 +(3386943305, 78347, 1430365287, 1), -- CreatureDifficulty - 78347 - 78347 +(3386943305, 78348, 1430365287, 1), -- CreatureDifficulty - 78348 - 78348 +(3386943305, 78349, 1430365287, 1), -- CreatureDifficulty - 78349 - 78349 +(3386943305, 78350, 1430365287, 1), -- CreatureDifficulty - 78350 - 78350 +(3386943305, 78351, 1430365287, 1), -- CreatureDifficulty - 78351 - 78351 +(3386943305, 78352, 1430365287, 1), -- CreatureDifficulty - 78352 - 78352 +(3386943305, 78353, 1430365287, 1), -- CreatureDifficulty - 78353 - 78353 +(3386943305, 78395, 1430365287, 1), -- CreatureDifficulty - 78395 - 78395 +(3386943305, 78399, 1430365287, 1), -- CreatureDifficulty - 78399 - 78399 +(3386943305, 78404, 1430365287, 1), -- CreatureDifficulty - 78404 - 78404 +(3386943305, 78670, 1430365287, 1), -- CreatureDifficulty - 78670 - 78670 +(3386943305, 78728, 1430365287, 1), -- CreatureDifficulty - 78728 - 78728 +(3386943305, 78729, 1430365287, 1), -- CreatureDifficulty - 78729 - 78729 +(3386943305, 78730, 1430365287, 1), -- CreatureDifficulty - 78730 - 78730 +(3386943305, 78731, 1430365287, 1), -- CreatureDifficulty - 78731 - 78731 +(3386943305, 78734, 1430365287, 1), -- CreatureDifficulty - 78734 - 78734 +(3386943305, 78738, 1430365287, 1), -- CreatureDifficulty - 78738 - 78738 +(3386943305, 78739, 1430365287, 1), -- CreatureDifficulty - 78739 - 78739 +(3386943305, 78742, 1430365287, 1), -- CreatureDifficulty - 78742 - 78742 +(3386943305, 78743, 1430365287, 1), -- CreatureDifficulty - 78743 - 78743 +(3386943305, 78746, 1430365287, 1), -- CreatureDifficulty - 78746 - 78746 +(3386943305, 78747, 1430365287, 1), -- CreatureDifficulty - 78747 - 78747 +(3386943305, 78750, 1430365287, 1), -- CreatureDifficulty - 78750 - 78750 +(3386943305, 78751, 1430365287, 1), -- CreatureDifficulty - 78751 - 78751 +(3386943305, 78758, 1430365287, 1), -- CreatureDifficulty - 78758 - 78758 +(3386943305, 78759, 1430365287, 1), -- CreatureDifficulty - 78759 - 78759 +(3386943305, 78904, 1430365287, 1), -- CreatureDifficulty - 78904 - 78904 +(3386943305, 78906, 1430365287, 1), -- CreatureDifficulty - 78906 - 78906 +(3386943305, 78988, 1430365287, 1), -- CreatureDifficulty - 78988 - 78988 +(3386943305, 78989, 1430365287, 1), -- CreatureDifficulty - 78989 - 78989 +(3386943305, 78990, 1430365287, 1), -- CreatureDifficulty - 78990 - 78990 +(3386943305, 78991, 1430365287, 1), -- CreatureDifficulty - 78991 - 78991 +(3386943305, 79817, 1430365287, 1), -- CreatureDifficulty - 79817 - 79817 +(3386943305, 79823, 1430365287, 1), -- CreatureDifficulty - 79823 - 79823 +(3386943305, 79824, 1430365287, 1), -- CreatureDifficulty - 79824 - 79824 +(3386943305, 79825, 1430365287, 1), -- CreatureDifficulty - 79825 - 79825 +(3386943305, 80244, 1430365287, 1), -- CreatureDifficulty - 80244 - 80244 +(3386943305, 80245, 1430365287, 1), -- CreatureDifficulty - 80245 - 80245 +(3386943305, 80246, 1430365287, 1), -- CreatureDifficulty - 80246 - 80246 +(3386943305, 80317, 1430365287, 1), -- CreatureDifficulty - 80317 - 80317 +(3386943305, 80318, 1430365287, 1), -- CreatureDifficulty - 80318 - 80318 +(3386943305, 80652, 1430365287, 1), -- CreatureDifficulty - 80652 - 80652 +(3386943305, 80653, 1430365287, 1), -- CreatureDifficulty - 80653 - 80653 +(3386943305, 80654, 1430365287, 1), -- CreatureDifficulty - 80654 - 80654 +(3386943305, 80658, 1430365287, 1), -- CreatureDifficulty - 80658 - 80658 +(3386943305, 80659, 1430365287, 1), -- CreatureDifficulty - 80659 - 80659 +(3386943305, 80660, 1430365287, 1), -- CreatureDifficulty - 80660 - 80660 +(3386943305, 80667, 1430365287, 1), -- CreatureDifficulty - 80667 - 80667 +(3386943305, 80668, 1430365287, 1), -- CreatureDifficulty - 80668 - 80668 +(3386943305, 80669, 1430365287, 1), -- CreatureDifficulty - 80669 - 80669 +(3386943305, 81731, 1430365287, 0), -- CreatureDifficulty - 81731 - 81731 +(3386943305, 82327, 1430365287, 1), -- CreatureDifficulty - 82327 - 82327 +(3386943305, 82328, 1430365287, 1), -- CreatureDifficulty - 82328 - 82328 +(3386943305, 82329, 1430365287, 1), -- CreatureDifficulty - 82329 - 82329 +(3386943305, 83010, 1430365287, 1), -- CreatureDifficulty - 83010 - 83010 +(3386943305, 83011, 1430365287, 1), -- CreatureDifficulty - 83011 - 83011 +(3386943305, 83012, 1430365287, 1), -- CreatureDifficulty - 83012 - 83012 +(3386943305, 83756, 1430365287, 1), -- CreatureDifficulty - 83756 - 83756 +(3386943305, 84264, 1430365287, 1), -- CreatureDifficulty - 84264 - 84264 +(3386943305, 85199, 1430365287, 1), -- CreatureDifficulty - 85199 - 85199 +(3386943305, 85263, 1430365287, 1), -- CreatureDifficulty - 85263 - 85263 +(3386943305, 85264, 1430365287, 1), -- CreatureDifficulty - 85264 - 85264 +(3386943305, 85265, 1430365287, 1), -- CreatureDifficulty - 85265 - 85265 +(3386943305, 85266, 1430365287, 1), -- CreatureDifficulty - 85266 - 85266 +(3386943305, 85267, 1430365287, 1), -- CreatureDifficulty - 85267 - 85267 +(3386943305, 85268, 1430365287, 1), -- CreatureDifficulty - 85268 - 85268 +(3386943305, 85269, 1430365287, 1), -- CreatureDifficulty - 85269 - 85269 +(3386943305, 85270, 1430365287, 1), -- CreatureDifficulty - 85270 - 85270 +(3386943305, 86788, 1430365287, 0), -- CreatureDifficulty - 86788 - 86788 +(3386943305, 88104, 1430365287, 1), -- CreatureDifficulty - 88104 - 88104 +(3386943305, 88105, 1430365287, 1), -- CreatureDifficulty - 88105 - 88105 +(3386943305, 88110, 1430365287, 1), -- CreatureDifficulty - 88110 - 88110 +(3386943305, 88111, 1430365287, 1), -- CreatureDifficulty - 88111 - 88111 +(3386943305, 88113, 1430365287, 1), -- CreatureDifficulty - 88113 - 88113 +(3386943305, 88115, 1430365287, 1), -- CreatureDifficulty - 88115 - 88115 +(3386943305, 88116, 1430365287, 1), -- CreatureDifficulty - 88116 - 88116 +(3386943305, 89548, 1430365287, 1), -- CreatureDifficulty - 89548 - 89548 +(3386943305, 89649, 1430365287, 1), -- CreatureDifficulty - 89649 - 89649 +(3386943305, 89660, 1430365287, 1), -- CreatureDifficulty - 89660 - 89660 +(3386943305, 89684, 1430365287, 1), -- CreatureDifficulty - 89684 - 89684 +(3386943305, 90161, 1430365287, 1), -- CreatureDifficulty - 90161 - 90161 +(3386943305, 90200, 1430365287, 1), -- CreatureDifficulty - 90200 - 90200 +(3386943305, 90302, 1430365287, 1), -- CreatureDifficulty - 90302 - 90302 +(3386943305, 90305, 1430365287, 1), -- CreatureDifficulty - 90305 - 90305 +(3386943305, 90354, 1430365287, 1), -- CreatureDifficulty - 90354 - 90354 +(3386943305, 90371, 1430365287, 1); -- CreatureDifficulty - 90371 - 90371 + +UPDATE `battle_pet_species` SET `VerifiedBuild`=19865 WHERE `ID` IN (1449 /*1449*/, 1636 /*1636*/); +UPDATE `creature_difficulty` SET `VerifiedBuild`=19865 WHERE `Id` IN (81731, 86788, 75757, 76334, 75759, 75760, 78256, 78257, 78258, 78259, 74104); + +DELETE FROM `spell_aura_restrictions` WHERE `ID`=10037; +INSERT INTO `spell_aura_restrictions` (`ID`, `CasterAuraState`, `TargetAuraState`, `ExcludeCasterAuraState`, `ExcludeTargetAuraState`, `CasterAuraSpell`, `TargetAuraSpell`, `ExcludeCasterAuraSpell`, `ExcludeTargetAuraSpell`, `VerifiedBuild`) VALUES +(10037, 0, 0, 0, 0, 0, 0, 0, 0, 19865); -- 10037 + +DELETE FROM `spell_casting_requirements` WHERE `ID`=16443; +INSERT INTO `spell_casting_requirements` (`ID`, `FacingCasterFlags`, `MinFactionID`, `MinReputation`, `RequiredAreasID`, `RequiredAuraVision`, `RequiresSpellFocus`, `VerifiedBuild`) VALUES +(16443, 0, 0, 0, 3951, 0, 0, 19865); -- 16443 + + +DELETE FROM `spell_misc` WHERE `ID` IN (126057, 129096, 137703); +INSERT INTO `spell_misc` (`ID`, `Attributes`, `AttributesEx`, `AttributesExB`, `AttributesExC`, `AttributesExD`, `AttributesExE`, `AttributesExF`, `AttributesExG`, `AttributesExH`, `AttributesExI`, `AttributesExJ`, `AttributesExK`, `AttributesExL`, `AttributesExM`, `CastingTimeIndex`, `DurationIndex`, `RangeIndex`, `Speed`, `SpellVisualID1`, `SpellVisualID2`, `SpellIconID`, `ActiveIconID`, `SchoolMask`, `MultistrikeSpeedMod`, `VerifiedBuild`) VALUES +(126057, 2147811344, 1048576, 0, 1024, 8, 0, 65536, 16777216, 4096, 8388608, 512, 0, 0, 1048576, 1, 36, 11, 0, 37013, 0, 9824, 0, 1, 0, 19865), -- 126057 +(129096, 67108864, 136, 0, 1048576, 0, 1024, 0, 0, 1073745920, 0, 0, 0, 0, 0, 1, 6, 6, 0, 0, 0, 8880, 0, 1, 0, 19865), -- 129096 +(137703, 2147745920, 1024, 0, 0, 0, 0, 0, 0, 4096, 0, 0, 0, 0, 0, 1, 27, 11, 0, 0, 0, 9824, 0, 1, 0, 19865); -- 137703 |