diff options
| -rw-r--r-- | sql/updates/world/2014_02_11_00_world_creature_template.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/2014_02_11_00_world_creature_template.sql b/sql/updates/world/2014_02_11_00_world_creature_template.sql new file mode 100644 index 00000000000..7b671d7fa34 --- /dev/null +++ b/sql/updates/world/2014_02_11_00_world_creature_template.sql @@ -0,0 +1,8 @@ +-- +UPDATE item_template SET Material = -1 WHERE `entry` IN (52202, 50435, 49334, 46055, 46054, 44851, 43964, 43963, 43304, 43303, 43302, 42590, 41811, 41804, 40777, 40389, 40307, 38265, 37827, 37348, 37346, 37345, 37343, 37338, 37337, 37336, 37335, 37329, 37326, 37126, 36942, 35854, 34030, 33610, 33604, 33475, 33316, 33121, 31266, 30595, 29565, 29225, 29120, 29041, 28676, 27863, 27419, 25877, 23952, 23882, 23378, 23360, 23330, 23227, 23224, 23193, 23157, 22899, 22387, 22386, 21591, 21578, 21577, 21560, 21159, 21152, 21043, 20524, 20020, 20005, 20003, 19986, 18303, 18153, 16082, 15780, 11903, 11672, 11671, 11616, 11613, 11111, 8993, 6650, 5531, 5515, 5410, 5400, 5353, 4868, 4749, 4704, 4524, 4200, 3584, 3513, 3316, 3168, 3122, 2755, 2668, 2638, 2599, 1672, 1356, 1352, 996, 960, 958, 956, 900, 813, 734, 35840, 35777, 35555, 34967, 34746, 34745, 34744, 34743, 34742, 34741, 34740, 34739, 34738, 34737, 34735); +UPDATE item_template SET sheath = 0 WHERE `entry` IN (20003, 20005, 38469); +UPDATE item_template SET Material = 0 WHERE `entry`=34187; +UPDATE item_template SET Material = 5 WHERE `entry`=34025; +UPDATE item_template SET sheath = 1 WHERE `entry`=36603; +UPDATE item_template SET sheath = 3 WHERE `entry`=36561; +UPDATE item_template SET InventoryType = 12 WHERE `entry`=40727; |