diff options
| author | Filip <boev.filip@gmail.com> | 2013-10-27 19:15:57 +0100 |
|---|---|---|
| committer | Filip <boev.filip@gmail.com> | 2013-10-27 19:15:57 +0100 |
| commit | fa33c428e920a7ae60029f1fb85810a41e959758 (patch) | |
| tree | 965829bcfc5b5b3a472dd94ea788e0bbd4748f09 | |
| parent | f0794d75850a0c43938a9cddf2c42e0aab08d4ff (diff) | |
DB/Cond: Prevent multiple spawns in vicinity
By @dr-j fixes #11128
| -rw-r--r-- | sql/updates/world/2013_10_27_00_world_conditions.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/2013_10_27_00_world_conditions.sql b/sql/updates/world/2013_10_27_00_world_conditions.sql new file mode 100644 index 00000000000..401053b80c7 --- /dev/null +++ b/sql/updates/world/2013_10_27_00_world_conditions.sql @@ -0,0 +1,6 @@ +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry` IN(66661,66642,30015,3678); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(17, 0, 66661, 0, 0, 29, 0, 35012, 40, 0, 1, 0, 0, '', 'Cant use Captured Kvaldir Banner within 40 yards of Ornolf The Scarred'), +(17, 0, 66642, 0, 0, 29, 0, 34980, 40, 0, 1, 0, 0, '', 'Cant use Kvaldir War Horn within 40 yards of Drottinn Hrothgar'), +(17, 0, 30015, 0, 0, 29, 0, 17207, 100, 0, 1, 0, 0, '', 'Cant use Gift of Naias within 100 yards of Naias'), +(17, 0, 3678, 0, 0, 29, 0, 2624, 100, 0, 1, 0, 0, '', 'Cant use Catelyns Blade within 100 yards of Gazban'); |