diff options
| -rw-r--r-- | sql/updates/world/6.x/2016_09_26_01_world.sql | 44 |
1 files changed, 44 insertions, 0 deletions
diff --git a/sql/updates/world/6.x/2016_09_26_01_world.sql b/sql/updates/world/6.x/2016_09_26_01_world.sql new file mode 100644 index 00000000000..a3d792d23dc --- /dev/null +++ b/sql/updates/world/6.x/2016_09_26_01_world.sql @@ -0,0 +1,44 @@ +DELETE FROM `npc_text` WHERE `ID` IN (26678 /*26678*/, 28832 /*28832*/, 26585 /*26585*/, 29194 /*29194*/, 28805 /*28805*/, 30340 /*30340*/, 27379 /*27379*/, 27218 /*27218*/, 28603 /*28603*/, 27527 /*27527*/, 28880 /*28880*/, 28919 /*28919*/, 30146 /*30146*/, 30589 /*30589*/, 28819 /*28819*/, 30262 /*30262*/, 26915 /*26915*/, 26917 /*26917*/, 26916 /*26916*/, 26707 /*26707*/, 28995 /*28995*/, 28687 /*28687*/, 28533 /*28533*/, 25533 /*25533*/, 25868 /*25868*/, 25869 /*25869*/, 26006 /*26006*/, 29719 /*29719*/, 30323 /*30323*/, 28813 /*28813*/, 27106 /*27106*/, 26154 /*26154*/, 25989 /*25989*/); +INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES +(26678, 1, 0, 0, 0, 0, 0, 0, 0, 95400, 0, 0, 0, 0, 0, 0, 0, 22624), -- 26678 +(28832, 1, 0, 0, 0, 0, 0, 0, 0, 108547, 0, 0, 0, 0, 0, 0, 0, 22624), -- 28832 +(26585, 1, 0, 0, 0, 0, 0, 0, 0, 94924, 0, 0, 0, 0, 0, 0, 0, 22624), -- 26585 +(29194, 1, 0, 0, 0, 0, 0, 0, 0, 111485, 0, 0, 0, 0, 0, 0, 0, 22624), -- 29194 +(28805, 1, 0, 0, 0, 0, 0, 0, 0, 108366, 0, 0, 0, 0, 0, 0, 0, 22624), -- 28805 +(30340, 1, 0, 0, 0, 0, 0, 0, 0, 120838, 0, 0, 0, 0, 0, 0, 0, 22624), -- 30340 +(27379, 1, 0, 0, 0, 0, 0, 0, 0, 99648, 0, 0, 0, 0, 0, 0, 0, 22624), -- 27379 +(27218, 1, 0, 0, 0, 0, 0, 0, 0, 98671, 0, 0, 0, 0, 0, 0, 0, 22624), -- 27218 +(28603, 1, 0, 0, 0, 0, 0, 0, 0, 106945, 0, 0, 0, 0, 0, 0, 0, 22624), -- 28603 +(27527, 1, 0, 0, 0, 0, 0, 0, 0, 100253, 0, 0, 0, 0, 0, 0, 0, 22624), -- 27527 +(28880, 1, 0, 0, 0, 0, 0, 0, 0, 108805, 0, 0, 0, 0, 0, 0, 0, 22624), -- 28880 +(28919, 1, 0, 0, 0, 0, 0, 0, 0, 109036, 0, 0, 0, 0, 0, 0, 0, 22624), -- 28919 +(30146, 1, 0, 0, 0, 0, 0, 0, 0, 120832, 0, 0, 0, 0, 0, 0, 0, 22624), -- 30146 +(30589, 1, 0, 0, 0, 0, 0, 0, 0, 122710, 0, 0, 0, 0, 0, 0, 0, 22624), -- 30589 +(28819, 1, 0, 0, 0, 0, 0, 0, 0, 108383, 0, 0, 0, 0, 0, 0, 0, 22624), -- 28819 +(30262, 1, 0, 0, 0, 0, 0, 0, 0, 121463, 0, 0, 0, 0, 0, 0, 0, 22624), -- 30262 +(26915, 1, 0, 0, 0, 0, 0, 0, 0, 96671, 0, 0, 0, 0, 0, 0, 0, 22624), -- 26915 +(26917, 1, 0, 0, 0, 0, 0, 0, 0, 96675, 0, 0, 0, 0, 0, 0, 0, 22624), -- 26917 +(26916, 1, 0, 0, 0, 0, 0, 0, 0, 96674, 0, 0, 0, 0, 0, 0, 0, 22624), -- 26916 +(26707, 1, 0, 0, 0, 0, 0, 0, 0, 95524, 0, 0, 0, 0, 0, 0, 0, 22624), -- 26707 +(28995, 1, 0, 0, 0, 0, 0, 0, 0, 109693, 0, 0, 0, 0, 0, 0, 0, 22624), -- 28995 +(28687, 1, 0, 0, 0, 0, 0, 0, 0, 107614, 0, 0, 0, 0, 0, 0, 0, 22624), -- 28687 +(28533, 1, 0, 0, 0, 0, 0, 0, 0, 106482, 0, 0, 0, 0, 0, 0, 0, 22624), -- 28533 +(25533, 1, 0, 0, 0, 0, 0, 0, 0, 90247, 0, 0, 0, 0, 0, 0, 0, 22624), -- 25533 +(25868, 1, 0, 0, 0, 0, 0, 0, 0, 91584, 0, 0, 0, 0, 0, 0, 0, 22624), -- 25868 +(25869, 1, 0, 0, 0, 0, 0, 0, 0, 91585, 0, 0, 0, 0, 0, 0, 0, 22624), -- 25869 +(26006, 1, 0, 0, 0, 0, 0, 0, 0, 92418, 0, 0, 0, 0, 0, 0, 0, 22624), -- 26006 +(29719, 1, 0, 0, 0, 0, 0, 0, 0, 115829, 0, 0, 0, 0, 0, 0, 0, 22624), -- 29719 +(30323, 1, 0, 0, 0, 0, 0, 0, 0, 121771, 0, 0, 0, 0, 0, 0, 0, 22624), -- 30323 +(28813, 1, 0, 0, 0, 0, 0, 0, 0, 108424, 0, 0, 0, 0, 0, 0, 0, 22624), -- 28813 +(27106, 1, 0, 0, 0, 0, 0, 0, 0, 97607, 0, 0, 0, 0, 0, 0, 0, 22624), -- 27106 +(26154, 1, 0, 0, 0, 0, 0, 0, 0, 92912, 0, 0, 0, 0, 0, 0, 0, 22624), -- 26154 +(25989, 1, 0, 0, 0, 0, 0, 0, 0, 92343, 0, 0, 0, 0, 0, 0, 0, 22624); -- 25989 + +UPDATE `npc_text` SET `VerifiedBuild`=22624 WHERE `ID`=16830; -- 16830 +UPDATE `npc_text` SET `VerifiedBuild`=22624 WHERE `ID`=12709; -- 12709 +UPDATE `npc_text` SET `VerifiedBuild`=22624 WHERE `ID`=12709; -- 12709 +UPDATE `npc_text` SET `VerifiedBuild`=22624 WHERE `ID`=17627; -- 17627 +UPDATE `npc_text` SET `VerifiedBuild`=22624 WHERE `ID`=16830; -- 16830 +UPDATE `npc_text` SET `VerifiedBuild`=22624 WHERE `ID`=24248; -- 24248 +UPDATE `npc_text` SET `VerifiedBuild`=22624 WHERE `ID`=13349; -- 13349 +UPDATE `npc_text` SET `VerifiedBuild`=22624 WHERE `ID`=13583; -- 13583 |