diff options
| author | Killyana <morphone1@gmail.com> | 2016-03-23 19:35:48 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2016-03-23 19:35:48 +0100 |
| commit | 22e425bc58090973fefb0f18b88b83dc27708e4c (patch) | |
| tree | 3a8404938ee6136f06a0f62bd7da194a64f7d770 | |
| parent | 0d643fdff25f9e05985d32f4c078002a0af428cb (diff) | |
DB/Misc: Remove ammo
closes #16313
by msoky
| -rw-r--r-- | sql/updates/world/2016_03_23_00_world.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/2016_03_23_00_world.sql b/sql/updates/world/2016_03_23_00_world.sql new file mode 100644 index 00000000000..b5a31f35526 --- /dev/null +++ b/sql/updates/world/2016_03_23_00_world.sql @@ -0,0 +1,4 @@ +-- +DELETE FROM `npc_vendor` WHERE `item` IN (2512,2515,3030,3464,9399,11285,19316,18042,12654,28053,24417,28056,30611,31949,33803,34581,31737,30319,41165,41586,52021,2516,8067,4960,2519,8068,5568,3033,8069,3465,10512,11284,10513,19317,15997,11630,13377,28060,23772,28061,30612,32883,32882,23773,34582,31735,41164,41584,52020); +DELETE FROM `creature_loot_template` WHERE `Item` IN (2512,2515,3030,3464,9399,11285,19316,18042,12654,28053,24417,28056,30611,31949,33803,34581,31737,30319,41165,41586,52021,2516,8067,4960,2519,8068,5568,3033,8069,3465,10512,11284,10513,19317,15997,11630,13377,28060,23772,28061,30612,32883,32882,23773,34582,31735,41164,41584,52020); +DELETE FROM `gameobject_loot_template` WHERE `Item` IN (2512,2515,3030,3464,9399,11285,19316,18042,12654,28053,24417,28056,30611,31949,33803,34581,31737,30319,41165,41586,52021,2516,8067,4960,2519,8068,5568,3033,8069,3465,10512,11284,10513,19317,15997,11630,13377,28060,23772,28061,30612,32883,32882,23773,34582,31735,41164,41584,52020); |