DB: Fix DB errors related to quest_details

1 files changed, 82 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2016_07_07_02_world.sql b/sql/updates/world/3.3.5/2016_07_07_02_world.sql
new file mode 100644
index 00000000000..90193d3ab45
--- /dev/null
+++ b/sql/updates/world/3.3.5/2016_07_07_02_world.sql
@@ -0,0 +1,82 @@
+-- 
+DELETE FROM `quest_details` WHERE `ID` IN (997, 6182, 6183, 6184, 6186, 7441, 9424, 9446, 9474, 9496, 9589, 9607, 9697, 9701, 9702, 9708, 9709, 9715, 9717, 9719, 9724, 9726, 9727, 9738, 9789, 9854, 9855, 9951, 9957, 9968, 9971, 9978, 9979, 10096,11576,11582,11587,11590,11646,11648,11663,11671,11679,11682,11900,11905,11911,11912,11914,11918,11919,11931,11936,11946,11951,11957,11984,11989,11990,11991,12037,12042,12068,12113,12114,12120,12123,12152,12190,12657,12766,264, 833, 857, 862, 1106, 9534,10177, 11538);
+INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES
+(6182, 1, 1, 1, 1, 1000, 2000, 3000, 4000, 12340),
+(6183, 1, 1, 1, 6, 1000, 2000, 3000, 4000, 12340),
+(6184, 1, 1, 1, 1, 1000, 2000, 3000, 4000, 12340),
+(6186, 33, 1, 1, 25, 1000, 2000, 3000, 4000, 12340),
+(7441, 1, 1, 1, 1, 500, 1000, 1500, 2000, 12340),
+(9424, 0, 0, 0, 0, 500, 0, 0, 0, 12340),
+(9446, 1, 6, 0, 0, 0, 1000, 0, 0, 12340),
+(9474, 1, 1, 1, 0, 0, 1000, 1000, 0, 12340),
+(9496, 1, 0, 0, 0, 0, 0, 0, 0, 12340),
+(9589, 1, 1, 6, 0, 0, 1000, 1000, 0, 12340),
+(9607, 1, 6, 0, 0, 0, 1000, 0, 0, 12340),
+(9697, 1, 1, 0, 0, 0, 1000, 0, 0, 12340),
+(9701, 1, 1, 0, 0, 0, 1000, 0, 0, 12340),
+(9702, 6, 1, 1, 0, 0, 1000, 1000, 0, 12340),
+(9708, 1, 1, 6, 0, 0, 1000, 1000, 0, 12340),
+(9709, 1, 1, 1, 0, 0, 1000, 1000, 0, 12340),
+(9715, 1, 1, 1, 0, 0, 1000, 1000, 0, 12340),
+(9717, 1, 1, 0, 0, 0, 1000, 0, 0, 12340),
+(9719, 1, 1, 6, 0, 0, 1000, 1000, 0, 12340),
+(9724, 1, 1, 0, 0, 0, 1000, 0, 0, 12340),
+(9726, 1, 1, 0, 0, 0, 1000, 0, 0, 12340),
+(9727, 1, 1, 0, 0, 0, 1000, 0, 0, 12340),
+(9738, 1, 1, 1, 0, 0, 1000, 1000, 0, 12340),
+(9789, 6, 1, 11, 0, 0, 1000, 1000, 0, 12340),
+(9854, 6, 1, 1, 0, 0, 1000, 1000, 0, 12340),
+(9855, 1, 1, 0, 0, 0, 1000, 0, 0, 12340),
+(9951, 5, 1, 5, 0, 0, 1000, 1000, 0, 12340),
+(9957, 1, 1, 0, 0, 0, 1000, 0, 0, 12340),
+(9968, 1, 1, 1, 0, 0, 1000, 1000, 0, 12340),
+(9971, 1, 1, 1, 0, 0, 1000, 1000, 0, 12340),
+(9978, 1, 1, 1, 0, 0, 1000, 1000, 0, 12340),
+(9979, 1, 1, 0, 0, 0, 1000, 0, 0, 12340),
+(10096, 1, 1, 6, 0, 0, 0, 1000, 0, 12340),
+(11576, 2, 1, 1, 0, 0, 500, 1000, 0, 12340),
+(11582, 1, 1, 0, 0, 0, 1000, 0, 0, 12340),
+(11587, 1, 1, 0, 0, 0, 1000, 0, 0, 12340),
+(11590, 1, 1, 1, 0, 0, 1000, 500, 0, 12340),
+(11646, 1, 1, 0, 0, 0, 1000, 0, 0, 12340),
+(11648, 1, 1, 0, 0, 0, 500, 0, 0, 12340),
+(11663, 5, 1, 0, 0, 0, 1000, 0, 0, 12340),
+(11671, 1, 1, 1, 0, 0, 1000, 1000, 0, 12340),
+(11679, 5, 1, 1, 0, 0, 1000, 500, 0, 12340),
+(11682, 2, 1, 0, 0, 0, 1000, 0, 0, 12340),
+(11900, 5, 1, 0, 0, 0, 1000, 0, 0, 12340),
+(11905, 1, 5, 1, 0, 0, 500, 1000, 0, 12340),
+(11911, 1, 1, 1, 0, 0, 1000, 1000, 0, 12340),
+(11912, 1, 1, 0, 0, 0, 1000, 0, 0, 12340),
+(11914, 1, 1, 0, 0, 0, 1000, 0, 0, 12340),
+(11918, 1, 1, 1, 0, 0, 500, 500, 0, 12340),
+(11919, 1, 1, 1, 0, 0, 500, 500, 0, 12340),
+(11931, 1, 1, 0, 0, 0, 1000, 0, 0, 12340),
+(11936, 1, 1, 0, 0, 0, 1000, 0, 0, 12340),
+(11946, 1, 1, 1, 0, 0, 1000, 500, 0, 12340),
+(11951, 1, 1, 1, 0, 0, 500, 1000, 0, 12340),
+(11957, 1, 1, 1, 0, 0, 1000, 1000, 0, 12340),
+(11984, 1, 1, 1, 0, 0, 500, 1000, 0, 12340),
+(11989, 1, 1, 0, 0, 0, 1000, 0, 0, 12340),
+(11990, 1, 1, 0, 0, 0, 1000, 0, 0, 12340),
+(11991, 1, 1, 0, 0, 0, 1000, 0, 0, 12340),
+(12037, 1, 1, 0, 0, 0, 500, 0, 0, 12340),
+(12042, 1, 1, 0, 0, 0, 1000, 0, 0, 12340),
+(12068, 1, 1, 0, 0, 0, 1000, 0, 0, 12340),
+(12113, 1, 6, 0, 0, 0, 1000, 0, 0, 12340),
+(12114, 5, 1, 5, 0, 0, 1000, 0, 0, 12340),
+(12120, 1, 1, 0, 0, 0, 1000, 0, 0, 12340),
+(12123, 273, 1, 1, 0, 2000, 0, 0, 0, 12340),
+(12152, 1, 1, 0, 0, 0, 1000, 0, 0, 12340),
+(12190, 1, 1, 0, 0, 0, 500, 0, 0, 12340),
+(12657, 396, 15, 396, 0, 1000, 2000, 2000, 2000, 12340),
+(12766, 1, 6, 1, 0, 1000, 0, 0, 0, 12340),
+(997, 6, 1, 0, 0, 0, 1000, 0, 0, 15595),
+(264, 1, 0, 0, 0, 0, 0, 0, 0, 12340),
+(833, 4, 0, 0, 0, 0, 0, 0, 0, 12340),
+(857, 4, 0, 0, 0, 0, 0, 0, 0, 12340),
+(862, 4, 0, 0, 0, 0, 0, 0, 0, 12340),
+(1106, 4, 0, 0, 0, 0, 0, 0, 0, 12340),
+(9534, 4, 0, 0, 0, 0, 0, 0, 0, 12340),
+(10177, 4, 0, 0, 0, 0, 0, 0, 0, 12340),
+(11538, 4, 0, 0, 0, 0, 0, 0, 0, 12340);