aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat
-rw-r--r--sql/updates/381_world.sql82
1 files changed, 82 insertions, 0 deletions
diff --git a/sql/updates/381_world.sql b/sql/updates/381_world.sql
new file mode 100644
index 00000000000..742c8b7612b
--- /dev/null
+++ b/sql/updates/381_world.sql
@@ -0,0 +1,82 @@
+-- SELECT `gameobject_template` WHERE `entry` IN (186648, 187021, 186672, 186667);
+DELETE FROM `gameobject_loot_template` WHERE `entry` IN (22699, 22790, 22797, 22968);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33480, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33481, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33483, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33489, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33590, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33591, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33805, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33971, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33490, 0, 1, 13, 7, 2);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33491, 0, 1, 13, 7, 2);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33492, 0, 1, 13, 7, 2);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33493, 0, 1, 13, 7, 2);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33494, 0, 1, 13, 7, 2);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33495, 0, 1, 13, 7, 2);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33496, 0, 1, 13, 7, 3);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33497, 0, 1, 13, 7, 3);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33498, 0, 1, 13, 7, 3);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33499, 0, 1, 13, 7, 3);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33500, 0, 1, 13, 7, 3);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22699, 33809, 100, 0, 13, 7, 4);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33480, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33481, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33483, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33489, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33590, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33591, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33805, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33971, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33490, 0, 1, 13, 7, 2);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33491, 0, 1, 13, 7, 2);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33492, 0, 1, 13, 7, 2);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33493, 0, 1, 13, 7, 2);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33494, 0, 1, 13, 7, 2);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33495, 0, 1, 13, 7, 2);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33496, 0, 1, 13, 7, 3);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33497, 0, 1, 13, 7, 3);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33498, 0, 1, 13, 7, 3);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33499, 0, 1, 13, 7, 3);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33500, 0, 1, 13, 7, 3);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22790, 33809, 100, 0, 13, 7, 4);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33480, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33481, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33483, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33489, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33590, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33591, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33805, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33971, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33490, 0, 1, 13, 7, 2);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33491, 0, 1, 13, 7, 2);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33492, 0, 1, 13, 7, 2);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33493, 0, 1, 13, 7, 2);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33494, 0, 1, 13, 7, 2);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33495, 0, 1, 13, 7, 2);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33496, 0, 1, 13, 7, 3);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33497, 0, 1, 13, 7, 3);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33498, 0, 1, 13, 7, 3);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33499, 0, 1, 13, 7, 3);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33500, 0, 1, 13, 7, 3);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22797, 33809, 100, 0, 13, 7, 4);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33480, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33481, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33483, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33489, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33590, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33591, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33805, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33971, 0, 1, 13, 7, 1);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33490, 0, 1, 13, 7, 2);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33491, 0, 1, 13, 7, 2);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33492, 0, 1, 13, 7, 2);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33493, 0, 1, 13, 7, 2);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33494, 0, 1, 13, 7, 2);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33495, 0, 1, 13, 7, 2);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33496, 0, 1, 13, 7, 3);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33497, 0, 1, 13, 7, 3);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33498, 0, 1, 13, 7, 3);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33499, 0, 1, 13, 7, 3);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33500, 0, 1, 13, 7, 3);
+INSERT INTO `gameobject_loot_template` (`entry`, `item`, `chanceorquestchance`, `groupid`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22968, 33809, 100, 0, 13, 7, 4); \ No newline at end of file