aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2014-07-21 13:20:39 +0200
committerAokromes <Aokromes@users.noreply.github.com>2014-07-21 13:20:39 +0200
commitbdd4b443207748daf25d765811cb1efd0615cc35 (patch)
treebed73c687a7d3181d51f0cd446e3fdc340384227
parent0540983f3f85e093574b4f1711652f547f64c0d7 (diff)
DB/Creature: Oglethorpe Obnoticus
By dr-j, closes #12315
-rw-r--r--sql/updates/world/2014_07_21_06_world_misc.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/2014_07_21_06_world_misc.sql b/sql/updates/world/2014_07_21_06_world_misc.sql
new file mode 100644
index 00000000000..5d66620740d
--- /dev/null
+++ b/sql/updates/world/2014_07_21_06_world_misc.sql
@@ -0,0 +1,9 @@
+--
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=1467;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(14, 1467, 2135, 0, 0, 9, 0, 836, 0, 0, 1, 0, 0, '', 'Show gossip text if player has not completed Rescue OOX-09/HL!'), -- AND
+(14, 1467, 2135, 0, 0, 9, 0, 648, 0, 0, 1, 0, 0, '', 'Show gossip text if player has not completed Rescue OOX-09/TN!'), -- AND
+(14, 1467, 2135, 0, 0, 9, 0, 2767, 0, 0, 1, 0, 0, '', 'Show gossip text if player has not completed Rescue OOX-09/FE!'), -- AND
+(14, 1467, 2136, 0, 0, 9, 0, 836, 0, 0, 0, 0, 0, '', 'Show gossip text if player has completed Rescue OOX-09/HL!'), -- OR
+(14, 1467, 2136, 0, 1, 9, 0, 648, 0, 0, 0, 0, 0, '', 'Show gossip text if player has completed Rescue OOX-09/TN!'), -- OR
+(14, 1467, 2136, 0, 2, 9, 0, 2767, 0, 0, 0, 0, 0, '', 'Show gossip text if player has completed Rescue OOX-09/FE!'); -- OR