From 27a4e48771eb74faf015a68f0b70c28e906bcbed Mon Sep 17 00:00:00 2001 From: Aokromes Date: Sun, 3 Nov 2013 03:43:53 +0100 Subject: DB/Conditions: Skill requirements to ride flying carpets and flying machines By dr-j, closes #10572 --- sql/updates/world/2013_11_03_06_world_conditions.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sql/updates/world/2013_11_03_06_world_conditions.sql (limited to 'sql') diff --git a/sql/updates/world/2013_11_03_06_world_conditions.sql b/sql/updates/world/2013_11_03_06_world_conditions.sql new file mode 100644 index 00000000000..0be141bf2e8 --- /dev/null +++ b/sql/updates/world/2013_11_03_06_world_conditions.sql @@ -0,0 +1,9 @@ +-- Skill requirements for Flying Carpets and Flying Machines +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry` IN (75596,61309,61451,44153,44151); + +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(17, 0, 75596, 0, 0, 7, 0, 197, 425, 0, 0, 0, 0, '', 'Player has must have Tailoring with skill level 425 to Ride Frosty Flying Carpet'), +(17, 0, 61309, 0, 0, 7, 0, 197, 425, 0, 0, 0, 0, '', 'Player has must have Tailoring with skill level 425 to Ride Magnificent Flying Carpet'), +(17, 0, 61451, 0, 0, 7, 0, 197, 300, 0, 0, 0, 0, '', 'Player has must have Tailoring with skill level 300 to Ride Flying Carpet'), +(17, 0, 44153, 0, 0, 7, 0, 202, 300, 0, 0, 0, 0, '', 'Player has must have Engineering with skill level 300 to Ride Flying Machine'), +(17, 0, 44151, 0, 0, 7, 0, 202, 375, 0, 0, 0, 0, '', 'Player has must have Engineering with skill level 375 to Ride Turbo-Charged Flying Machine'); -- cgit v1.2.3