vmangos/sql/custom/WSG_invis_walls.sql
Daribon daff3ae553
Add custom invisible walls to WSG from Classic. (#1684)
This is a separate file, not part of the database.
2023-08-14 21:56:44 +03:00

17 lines
No EOL
1.8 KiB
SQL

-- This adds invisible walls at terrain exploit spots in WSG
-- From Classic but the invisible walls never existed in vanilla
-- The object exists in 1.7.0 and forward, if you are using 1.12.1 you can change patch_min
SET @OINVIS = 3998750;
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
(@OINVIS+0, 180322, 489, 917.462, 1431.63, 361.555, 3.14995, -0.256078, -0.127144, -0.957513, 0.0377819, 25, 25, 100, 1, 1, 350, 5, 10),
(@OINVIS+1, 180322, 489, 1536.53, 1410.2, 371.014, 1.96517, 0, 0, 0.831934, 0.554875, 25, 25, 100, 1, 1, 350, 5, 10),
(@OINVIS+2, 180322, 489, 1528.47, 1511.9, 359.055, 0, 0, 0, 0, 1, 25, 25, 100, 1, 1, 350, 5, 10),
(@OINVIS+3, 180322, 489, 1541, 1416, 372, 6.10865, 0, 0, -0.0871553, 0.996195, 25, 25, 100, 1, 1, 350, 5, 10),
(@OINVIS+4, 180322, 489, 1471.05, 1442.52, 371.495, 4.67748, 0.692015, -0.716602, 0.0605431, 0.0627004, 25, 25, 100, 1, 1, 350, 5, 10),
(@OINVIS+5, 180322, 489, 997.53, 1282.98, 358.421, 0.581384, 0, 0, 0.286615, 0.958046, 25, 25, 100, 1, 1, 350, 5, 10),
(@OINVIS+6, 180322, 489, 990.203, 1294.89, 357.31, 0.170133, 0, 0, 0.0849638, 0.996384, 25, 25, 100, 1, 1, 350, 5, 10),
(@OINVIS+8, 180322, 489, 1442.77, 1667.75, 366.105, 2.60508, 0, 0, 0.964234, 0.265051, 25, 25, 100, 1, 1, 350, 5, 10),
(@OINVIS+9, 180322, 489, 1146.96, 1688.87, 351.199, 1.47358, 0, 0, 0.671914, 0.740629, 25, 25, 100, 1, 1, 350, 5, 10),
(@OINVIS+10, 180322, 489, 1186.25, 1256.99, 337.158, 1.18015, 0, 0, 0.556424, 0.830898, 25, 25, 100, 1, 1, 350, 5, 10),
(@OINVIS+11, 180322, 489, 969.54, 1547.69, 358.262, 1.10841, 0, 0, 0.526268, 0.850319, 25, 25, 100, 1, 1, 350, 5, 10);