DB: Add some legion scene_template

Closes #22618

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);