aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/381_world.sql
blob: 742c8b7612b832f9d9fa0c38a7572eaba90ca0ed (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
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);