diff options
| -rw-r--r-- | sql/updates/world/master/2018_10_11_00_world.sql | 76 |
1 files changed, 76 insertions, 0 deletions
diff --git a/sql/updates/world/master/2018_10_11_00_world.sql b/sql/updates/world/master/2018_10_11_00_world.sql new file mode 100644 index 00000000000..4fc4eab3ef3 --- /dev/null +++ b/sql/updates/world/master/2018_10_11_00_world.sql @@ -0,0 +1,76 @@ +DELETE FROM `scene_template` WHERE (`SceneId`=1773 AND `ScriptPackageID`=1880) OR (`SceneId`=1688 AND `ScriptPackageID`=1872) OR (`SceneId`=1673 AND `ScriptPackageID`=1855) OR (`SceneId`=1387 AND `ScriptPackageID`=1669) OR (`SceneId`=1481 AND `ScriptPackageID`=1757) OR (`SceneId`=1485 AND `ScriptPackageID`=1761) OR (`SceneId`=1483 AND `ScriptPackageID`=1760) OR (`SceneId`=1531 AND `ScriptPackageID`=1775) OR (`SceneId`=1497 AND `ScriptPackageID`=1766) OR (`SceneId`=1771 AND `ScriptPackageID`=1879) OR (`SceneId`=1806 AND `ScriptPackageID`=1887) OR (`SceneId`=1808 AND `ScriptPackageID`=1884) OR (`SceneId`=1805 AND `ScriptPackageID`=1883) OR (`SceneId`=1761 AND `ScriptPackageID`=1886) OR (`SceneId`=1751 AND `ScriptPackageID`=1878) OR (`SceneId`=1362 AND `ScriptPackageID`=1669) OR (`SceneId`=1448 AND `ScriptPackageID`=1727) OR (`SceneId`=1438 AND `ScriptPackageID`=1713) OR (`SceneId`=1435 AND `ScriptPackageID`=1709) OR (`SceneId`=1426 AND `ScriptPackageID`=1704) OR (`SceneId`=1461 AND `ScriptPackageID`=1726) OR (`SceneId`=1455 AND `ScriptPackageID`=1733) OR (`SceneId`=1452 AND `ScriptPackageID`=1731) OR (`SceneId`=1460 AND `ScriptPackageID`=1725) OR (`SceneId`=1459 AND `ScriptPackageID`=1714) OR (`SceneId`=1141 AND `ScriptPackageID`=1508) OR (`SceneId`=1092 AND `ScriptPackageID`=1477) OR (`SceneId`=1246 AND `ScriptPackageID`=1594) OR (`SceneId`=1350 AND `ScriptPackageID`=1676) OR (`SceneId`=1194 AND `ScriptPackageID`=1560) OR (`SceneId`=1368 AND `ScriptPackageID`=1687) OR (`SceneId`=1146 AND `ScriptPackageID`=1518) OR (`SceneId`=1339 AND `ScriptPackageID`=1665) OR (`SceneId`=937 AND `ScriptPackageID`=1380) OR (`SceneId`=936 AND `ScriptPackageID`=1379) OR (`SceneId`=935 AND `ScriptPackageID`=1378) OR (`SceneId`=1281 AND `ScriptPackageID`=1630) OR (`SceneId`=1280 AND `ScriptPackageID`=1629) OR (`SceneId`=1279 AND `ScriptPackageID`=1628) OR (`SceneId`=1326 AND `ScriptPackageID`=1655) OR (`SceneId`=1304 AND `ScriptPackageID`=1642) OR (`SceneId`=1305 AND `ScriptPackageID`=1645) OR (`SceneId`=1312 AND `ScriptPackageID`=1650) OR (`SceneId`=1311 AND `ScriptPackageID`=1649) OR (`SceneId`=1125 AND `ScriptPackageID`=1500) OR (`SceneId`=1269 AND `ScriptPackageID`=1717) OR (`SceneId`=1449 AND `ScriptPackageID`=1728) OR (`SceneId`=1467 AND `ScriptPackageID`=1747) OR (`SceneId`=1445 AND `ScriptPackageID`=1722) OR (`SceneId`=1474 AND `ScriptPackageID`=1750) OR (`SceneId`=1373 AND `ScriptPackageID`=1691) OR (`SceneId`=1356 AND `ScriptPackageID`=1678) OR (`SceneId`=1351 AND `ScriptPackageID`=1677) OR (`SceneId`=1335 AND `ScriptPackageID`=1661) OR (`SceneId`=1450 AND `ScriptPackageID`=1653) OR (`SceneId`=1341 AND `ScriptPackageID`=1667) OR (`SceneId`=1472 AND `ScriptPackageID`=1746) OR (`SceneId`=1327 AND `ScriptPackageID`=1657) OR (`SceneId`=1324 AND `ScriptPackageID`=1653) OR (`SceneId`=1328 AND `ScriptPackageID`=1658) OR (`SceneId`=1301 AND `ScriptPackageID`=1641) OR (`SceneId`=1458 AND `ScriptPackageID`=1737) OR (`SceneId`=1287 AND `ScriptPackageID`=1638) OR (`SceneId`=994 AND `ScriptPackageID`=1403) OR (`SceneId`=1223 AND `ScriptPackageID`=1588) OR (`SceneId`=1842 AND `ScriptPackageID`=1928) OR (`SceneId`=1801 AND `ScriptPackageID`=1905) OR (`SceneId`=1775 AND `ScriptPackageID`=1928) OR (`SceneId`=1818 AND `ScriptPackageID`=1959) OR (`SceneId`=1674 AND `ScriptPackageID`=1858) OR (`SceneId`=1499 AND `ScriptPackageID`=1768) OR (`SceneId`=1496 AND `ScriptPackageID`=1765) OR (`SceneId`=1495 AND `ScriptPackageID`=1764) OR (`SceneId`=1494 AND `ScriptPackageID`=1762); +INSERT INTO `scene_template` (`SceneId`, `Flags`, `ScriptPackageID`) VALUES +(1773, 27, 1880), +(1688, 17, 1872), +(1673, 16, 1855), +(1387, 20, 1669), +(1481, 25, 1757), +(1485, 16, 1761), +(1483, 16, 1760), +(1531, 16, 1775), +(1497, 16, 1766), +(1771, 27, 1879), +(1806, 27, 1887), +(1808, 27, 1884), +(1805, 27, 1883), +(1761, 27, 1886), +(1751, 27, 1878), +(1362, 20, 1669), +(1448, 31, 1727), +(1438, 31, 1713), +(1435, 23, 1709), +(1426, 23, 1704), +(1461, 11, 1726), +(1455, 25, 1733), +(1452, 16, 1731), +(1460, 11, 1725), +(1459, 11, 1714), +(1141, 24, 1508), +(1092, 16, 1477), +(1246, 1, 1594), +(1350, 17, 1676), +(1194, 1, 1560), +(1368, 17, 1687), +(1146, 17, 1518), +(1339, 16, 1665), +(937, 16, 1380), +(936, 16, 1379), +(935, 16, 1378), +(1281, 4, 1630), +(1280, 4, 1629), +(1279, 4, 1628), +(1326, 20, 1655), +(1304, 16, 1642), +(1305, 16, 1645), +(1312, 21, 1650), +(1311, 25, 1649), +(1125, 21, 1500), +(1269, 21, 1717), +(1449, 58, 1728), +(1467, 16, 1747), +(1445, 16, 1722), +(1474, 16, 1750), +(1373, 62, 1691), +(1356, 62, 1678), +(1351, 52, 1677), +(1335, 26, 1661), +(1450, 27, 1653), +(1341, 16, 1667), +(1472, 25, 1746), +(1327, 25, 1657), +(1324, 11, 1653), +(1328, 17, 1658), +(1301, 27, 1641), +(1458, 16, 1737), +(1287, 25, 1638), +(994, 16, 1403), +(1223, 20, 1588), +(1842, 27, 1928), +(1801, 17, 1905), +(1775, 27, 1928), +(1818, 20, 1959), +(1674, 16, 1858), +(1499, 21, 1768), +(1496, 20, 1765), +(1495, 17, 1764), +(1494, 25, 1762); |