DB/WorldEvent - Love is in the Air

closes #29484
Co-authored-by: Jinnaix <jinnaix@users.noreply.github.com>

1 files changed, 97 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2024_02_16_04_world.sql b/sql/updates/world/3.3.5/2024_02_16_04_world.sql
new file mode 100644
index 00000000000..a8beeb1d5b6
--- /dev/null
+++ b/sql/updates/world/3.3.5/2024_02_16_04_world.sql
@@ -0,0 +1,97 @@
+-- small correction
+DELETE FROM `npc_vendor` WHERE `item` IN (21829,21833);
+DELETE FROM `game_event_npc_vendor` WHERE `guid` IN (42755,21575,24772,4661,22681,79841,38407,199,14139,14986,28340,9460,46341,17865,7671,28304,80346,66978,6889,42181,33073,54188,15287,41839,1745,690,46343,32451,537,13550,29233,50060,11273,15326,28474,30676,10076,8219,37069,24774,4208,31947,50059,92923,92884,29239) AND `item`=21829;
+DELETE FROM `game_event_npc_vendor` WHERE `guid` IN (42755,21575,24772,4661,22681,79841,38407,199,14139,14986,28340,9460,46341,17865,7671,28304,80346,66978,6889,42181,33073,54188,15287,41839,1745,690,46343,32451,537,13550,29233,50060,11273,15326,28474,30676,10076,8219,37069,24774,4208,31947,50059,92923,92884,29239) AND `item`=21833;
+INSERT INTO `game_event_npc_vendor` (`eventEntry`, `guid`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES 
+(8, 42755, 0, 21829, 0, 0, 0),
+(8, 42755, 1, 21833, 0, 0, 0),
+(8, 21575, 0, 21829, 0, 0, 0),
+(8, 21575, 1, 21833, 0, 0, 0),
+(8, 24772, 0, 21829, 0, 0, 0),
+(8, 24772, 1, 21833, 0, 0, 0),
+(8, 4661, 0, 21829, 0, 0, 0),
+(8, 4661, 1, 21833, 0, 0, 0),
+(8, 22681, 0, 21829, 0, 0, 0),
+(8, 22681, 1, 21833, 0, 0, 0),
+(8, 79841, 0, 21829, 0, 0, 0),
+(8, 79841, 1, 21833, 0, 0, 0),
+(8, 38407, 0, 21829, 0, 0, 0),
+(8, 38407, 1, 21833, 0, 0, 0),
+(8, 199, 0, 21829, 0, 0, 0),
+(8, 199, 1, 21833, 0, 0, 0),
+(8, 14139, 0, 21829, 0, 0, 0),
+(8, 14139, 1, 21833, 0, 0, 0),
+(8, 14986, 0, 21829, 0, 0, 0),
+(8, 14986, 1, 21833, 0, 0, 0),
+(8, 28340, 0, 21829, 0, 0, 0),
+(8, 28340, 1, 21833, 0, 0, 0),
+(8, 9460, 0, 21829, 0, 0, 0),
+(8, 9460, 1, 21833, 0, 0, 0),
+(8, 46341, 0, 21829, 0, 0, 0),
+(8, 46341, 1, 21833, 0, 0, 0),
+(8, 17865, 0, 21829, 0, 0, 0),
+(8, 17865, 1, 21833, 0, 0, 0),
+(8, 7671, 0, 21829, 0, 0, 0),
+(8, 7671, 1, 21833, 0, 0, 0),
+(8, 28304, 0, 21829, 0, 0, 0),
+(8, 28304, 1, 21833, 0, 0, 0),
+(8, 80346, 0, 21829, 0, 0, 0),
+(8, 80346, 1, 21833, 0, 0, 0),
+(8, 66978, 0, 21829, 0, 0, 0),
+(8, 66978, 1, 21833, 0, 0, 0),
+(8, 6889, 0, 21829, 0, 0, 0),
+(8, 6889, 1, 21833, 0, 0, 0),
+(8, 42181, 0, 21829, 0, 0, 0),
+(8, 42181, 1, 21833, 0, 0, 0),
+(8, 33073, 0, 21829, 0, 0, 0),
+(8, 33073, 1, 21833, 0, 0, 0),
+(8, 54188, 0, 21829, 0, 0, 0),
+(8, 54188, 1, 21833, 0, 0, 0),
+(8, 15287, 0, 21829, 0, 0, 0),
+(8, 15287, 1, 21833, 0, 0, 0),
+(8, 41839, 0, 21829, 0, 0, 0),
+(8, 41839, 1, 21833, 0, 0, 0),
+(8, 1745, 0, 21829, 0, 0, 0),
+(8, 1745, 1, 21833, 0, 0, 0),
+(8, 690, 0, 21829, 0, 0, 0),
+(8, 690, 1, 21833, 0, 0, 0),
+(8, 46343, 0, 21829, 0, 0, 0),
+(8, 46343, 1, 21833, 0, 0, 0),
+(8, 32451, 0, 21829, 0, 0, 0),
+(8, 32451, 1, 21833, 0, 0, 0),
+(8, 537, 0, 21829, 0, 0, 0),
+(8, 537, 1, 21833, 0, 0, 0),
+(8, 13550, 0, 21829, 0, 0, 0),
+(8, 13550, 1, 21833, 0, 0, 0),
+(8, 29233, 0, 21829, 0, 0, 0),
+(8, 29233, 1, 21833, 0, 0, 0),
+(8, 50060, 0, 21829, 0, 0, 0),
+(8, 50060, 1, 21833, 0, 0, 0),
+(8, 11273, 0, 21829, 0, 0, 0),
+(8, 11273, 1, 21833, 0, 0, 0),
+(8, 15326, 0, 21829, 0, 0, 0),
+(8, 15326, 1, 21833, 0, 0, 0),
+(8, 28474, 0, 21829, 0, 0, 0),
+(8, 28474, 1, 21833, 0, 0, 0),
+(8, 30676, 0, 21829, 0, 0, 0),
+(8, 30676, 1, 21833, 0, 0, 0),
+(8, 10076, 0, 21829, 0, 0, 0),
+(8, 10076, 1, 21833, 0, 0, 0),
+(8, 8219, 0, 21829, 0, 0, 0),
+(8, 8219, 1, 21833, 0, 0, 0),
+(8, 37069, 0, 21829, 0, 0, 0),
+(8, 37069, 1, 21833, 0, 0, 0),
+(8, 24774, 0, 21829, 0, 0, 0),
+(8, 24774, 1, 21833, 0, 0, 0),
+(8, 4208, 0, 21829, 0, 0, 0),
+(8, 4208, 1, 21833, 0, 0, 0),
+(8, 31947, 0, 21829, 0, 0, 0),
+(8, 31947, 1, 21833, 0, 0, 0),
+(8, 50059, 0, 21829, 0, 0, 0),
+(8, 50059, 1, 21833, 0, 0, 0),
+(8, 92923, 0, 21829, 0, 0, 0),
+(8, 92923, 1, 21833, 0, 0, 0),
+(8, 92884, 0, 21829, 0, 0, 0),
+(8, 92884, 1, 21833, 0, 0, 0),
+(8, 29239, 0, 21829, 0, 0, 0),
+(8, 29239, 1, 21833, 0, 0, 0);