diff options
| -rw-r--r-- | data/sql/updates/db_world/2025_08_23_00.sql (renamed from data/sql/updates/pending_db_world/creature-spawns.sql) | 1 | ||||
| -rw-r--r-- | data/sql/updates/db_world/2025_08_23_01.sql (renamed from data/sql/updates/pending_db_world/game-events.sql) | 1 | ||||
| -rw-r--r-- | data/sql/updates/db_world/2025_08_23_02.sql (renamed from data/sql/updates/pending_db_world/gobject-spawns.sql) | 1 |
3 files changed, 3 insertions, 0 deletions
diff --git a/data/sql/updates/pending_db_world/creature-spawns.sql b/data/sql/updates/db_world/2025_08_23_00.sql index 23346778e4..064b7cb64b 100644 --- a/data/sql/updates/pending_db_world/creature-spawns.sql +++ b/data/sql/updates/db_world/2025_08_23_00.sql @@ -1,3 +1,4 @@ +-- DB update 2025_08_19_00 -> 2025_08_23_00 SET @GUID = 83113; DELETE FROM `creature` WHERE `id1` IN (3296, 5595, 15383, 15431, 15432, 15434, 15437, 15445, 15446, 15448, 15450, 15451, 15452, 15453, 15455, 15456, 15457, 15458, 15459, 15460, 15469, 15477, 15508, 15512, 15515, 15522, 15525, 15528, 15529, 15532, 15533, 15534, 15535, 15539, 15663, 15696, 15700, 15701, 15702, 15703, 15704, 15707, 15708, 15709, 15731, 15733, 15734, 15735, 15736, 15737, 15738, 15739, 15761, 15762, 15763, 15764, 15765, 15766, 15767, 15768) AND `guid` BETWEEN @GUID AND @GUID+69; diff --git a/data/sql/updates/pending_db_world/game-events.sql b/data/sql/updates/db_world/2025_08_23_01.sql index 17b1fb9390..d63bf23ff8 100644 --- a/data/sql/updates/pending_db_world/game-events.sql +++ b/data/sql/updates/db_world/2025_08_23_01.sql @@ -1,3 +1,4 @@ +-- DB update 2025_08_23_00 -> 2025_08_23_01 SET @EventID = 131, @OGUID = 3639, @CGUID = 83113; diff --git a/data/sql/updates/pending_db_world/gobject-spawns.sql b/data/sql/updates/db_world/2025_08_23_02.sql index 8b2082ea4f..acc01795c5 100644 --- a/data/sql/updates/pending_db_world/gobject-spawns.sql +++ b/data/sql/updates/db_world/2025_08_23_02.sql @@ -1,3 +1,4 @@ +-- DB update 2025_08_23_01 -> 2025_08_23_02 SET @GUID = 3639; -- Note: Some of these are CO2s, especially since there's some weird destroy/recreate thing going on on official, but I just noted them as CO1s for the time being. DELETE FROM `gameobject` WHERE `id` IN (180598, 180674, 180675, 180676, 180677, 180678, 180679, 180680, 180681, 180692, 180693, 180694, 180695, 180696, 180714, 180780, 180781, 180782, 180783, 180784, 180800, 180801, 180802, 180803, 180804, 180805, 180806, 180807, 180808, 180809, 180812, 180813, 180814, 180815, 180816, 180817, 180818, 180819, 180820, 180821, 180822, 180823, 180826, 180827, 180828, 180829, 180830, 180831, 180832, 180833, 180834, 180835, 180836, 180837, 180838, 180839, 180840, 180841, 180842, 180843) AND `guid` BETWEEN @GUID AND @GUID+81; |