[3.3.5] DB/item: Restore item Deprecated BKP "Impact" Shot [cosmetic]

TrinityCore rev. 94e4bdd 2015-12-01 19:27:17 +0100 (3.3.5 branch) (Win64, Release)
TDB 335.60 + updates up to and including 2015_12_01_00_world.sql

Issue: item 3034 (bullet) has got DB values from Glyphed Breastplate & can't be put in ammo pouches.

http://www.wowhead.com/item=3030/razor-arrow (Razor Arrow)
http://www.wowhead.com/item=3031/depricated-razor-arrow (Depricated Razor Arrow)
http://www.wowhead.com/item=3033/solid-shot (Solid Shot)

http://www.wowhead.com/item=3034/deprecated-bkp-impact-shot (Deprecated BKP "Impact" Shot)
http://wotlk.openwow.com/item=3034 (Glyphed Breastplate, bullet)
http://www.wowhead.com/item=4058/glyphed-breastplate (Glyphed Breastplate, Chest Leather armor)

https://web.archive.org/web/20110203003035/http://www.wowhead.com/item=3034 (Adds 9.0 dps)

While looking in the DB and on wotlk.openwow.com for a bullet "upgrade" for use on a GM test character, I found this weird info: http://wotlk.openwow.com/item=3034

So I searched for any other items named "Glyphed Breastplate":
http://wotlk.openwow.com/?search=Glyphed+Breastplate

It seems that somebody somehow has inserted wrong information in the database and that this wrong information was not discovered earlier. I tried searching the TC repository for any SQL containing the bugged information, but could not find it. I also tried searching Google and the web archives for more information about this item previous to patch 4.0.1, but the only information that I could find was that this bullet used to add 9.0 damage when used with a gun item. This is from the web archives:

https://web.archive.org/web/20110203003035/http://www.wowhead.com/item=3034

(Similar info can be found on http://www.wowhead.com/item=3034/deprecated-bkp-impact-shot
without the extra information "Adds 9.0 damage per second",
but with the red text This item is not available to players. )

To solve this issue, mostly for myself, but also to clean up in the item DB info, I compared item 3030 (Razor Arrow), 3031 (Depricated Razor Arrow), 3033 (Solid Shot), 3034 (Glyphed Breastplate, bullet) and 4058 (Glyphed Breastplate, Chest Leather armor):

SELECT * FROM `item_template` WHERE `entry` IN (3030,3031,3033,3034,4058);

 entry   class  subclass  SoundOverrideSubclass  name                    displayid  Quality   Flags  FlagsExtra  BuyCount  BuyPrice  SellPrice  InventoryType  AllowableClass  AllowableRace  ItemLevel  RequiredLevel  RequiredSkill  RequiredSkillRank  requiredspell  requiredhonorrank  RequiredCityRank  RequiredReputationFaction  RequiredReputationRank  maxcount  stackable  ContainerSlots  StatsCount  stat_type1  stat_value1  stat_type2  stat_value2  stat_type3  stat_value3  stat_type4  stat_value4  stat_type5  stat_value5  stat_type6  stat_value6  stat_type7  stat_value7  stat_type8  stat_value8  stat_type9  stat_value9  stat_type10  stat_value10  ScalingStatDistribution  ScalingStatValue  dmg_min1  dmg_max1  dmg_type1  dmg_min2  dmg_max2  dmg_type2   armor  holy_res  fire_res  nature_res  frost_res  shadow_res  arcane_res   delay  ammo_type  RangedModRange  spellid_1  spelltrigger_1  spellcharges_1  spellppmRate_1  spellcooldown_1  spellcategory_1  spellcategorycooldown_1  spellid_2  spelltrigger_2  spellcharges_2  spellppmRate_2  spellcooldown_2  spellcategory_2  spellcategorycooldown_2  spellid_3  spelltrigger_3  spellcharges_3  spellppmRate_3  spellcooldown_3  spellcategory_3  spellcategorycooldown_3  spellid_4  spelltrigger_4  spellcharges_4  spellppmRate_4  spellcooldown_4  spellcategory_4  spellcategorycooldown_4  spellid_5  spelltrigger_5  spellcharges_5  spellppmRate_5  spellcooldown_5  spellcategory_5  spellcategorycooldown_5  bonding  description  PageText  LanguageID  PageMaterial  startquest  lockid  Material  sheath  RandomProperty  RandomSuffix   block  itemset  MaxDurability    area     Map  BagFamily  TotemCategory  socketColor_1  socketContent_1  socketColor_2  socketContent_2  socketColor_3  socketContent_3  socketBonus  GemProperties  RequiredDisenchantSkill  ArmorDamageModifier  duration  ItemLimitCategory  HolidayId  ScriptName  DisenchantID  FoodType  minMoneyLoot  maxMoneyLoot  flagsCustom  VerifiedBuild
------  ------  --------  ---------------------  ----------------------  ---------  -------  ------  ----------  --------  --------  ---------  -------------  --------------  -------------  ---------  -------------  -------------  -----------------  -------------  -----------------  ----------------  -------------------------  ----------------------  --------  ---------  --------------  ----------  ----------  -----------  ----------  -----------  ----------  -----------  ----------  -----------  ----------  -----------  ----------  -----------  ----------  -----------  ----------  -----------  ----------  -----------  -----------  ------------  -----------------------  ----------------  --------  --------  ---------  --------  --------  ---------  ------  --------  --------  ----------  ---------  ----------  ----------  ------  ---------  --------------  ---------  --------------  --------------  --------------  ---------------  ---------------  -----------------------  ---------  --------------  --------------  --------------  ---------------  ---------------  -----------------------  ---------  --------------  --------------  --------------  ---------------  ---------------  -----------------------  ---------  --------------  --------------  --------------  ---------------  ---------------  -----------------------  ---------  --------------  --------------  --------------  ---------------  ---------------  -----------------------  -------  -----------  --------  ----------  ------------  ----------  ------  --------  ------  --------------  ------------  ------  -------  -------------  ------  ------  ---------  -------------  -------------  ---------------  -------------  ---------------  -------------  ---------------  -----------  -------------  -----------------------  -------------------  --------  -----------------  ---------  ----------  ------------  --------  ------------  ------------  -----------  -------------
  3030       6         2                     -1  Razor Arrow                 26497        1       0           0       200       300          0             24              -1             -1         30             25              0                  0              0                  0                 0                          0                       0         0       1000               0           0           0            0           0            0           0            0           0            0           0            0           0            0           0            0           0            0           0            0            0             0                        0                 0         7         8          0         0         0          0       0         0         0           0          0           0           0    3000          0               0          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1        0                      0           0             0           0       0         2       0               0             0       0        0              0       0       0          1              0              0                0              0                0              0                0            0              0                       -1                    0         0                  0          0                         0         0             0             0            0          12340
  3031       6         2                     -1  Depricated Razor Arrow       5996        1      16        8192       200       450          0             24              -1             -1         35             30              0                  0              0                  0                 0                          0                       0         0       1000               0           0           0            0           0            0           0            0           0            0           0            0           0            0           0            0           0            0           0            0            0             0                        0                 0         0         0          0         0         0          0       0         0         0           0          0           0           0    3000          0               0          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1        0                      0           0             0           0       0         2       0               0             0       0        0              0       0       0          1              0              0                0              0                0              0                0            0              0                       -1                    0         0                  0          0                         0         0             0             0            0          15595
  3033       6         3                     -1  Solid Shot                   5998        1       0           0       200       300          0             24              -1             -1         30             25              0                  0              0                  0                 0                          0                       0         0       1000               0           0           0            0           0            0           0            0           0            0           0            0           0            0           0            0           0            0           0            0            0             0                        0                 0         7         8          0         0         0          0       0         0         0           0          0           0           0    3000          0               0          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1        0                      0           0             0           0       0         2       0               0             0       0        0              0       0       0          2              0              0                0              0                0              0                0            0              0                       -1                    0         0                  0          0                         0         0             0             0            0          12340
  3034       6         3                     -1  Glyphed Breastplate          5998        2       0           0         1     30283       6056             24              -1             -1         41             36              0                  0              0                  0                 0                          0                       0         0          1               0           2           7            4           6           15           0            0           0            0           0            0           0            0           0            0           0            0           0            0            0             0                        0                 0         0         0          0         0         0          0     113         0         0           0          0           0           0       0          0               0          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1        2                      0           0             0           0       0         2       0               0             0       0        0             85       0       0          0              0              0                0              0                0              0                0            0              0                        0                    0         0                  0          0                        27         0             0             0            0              0
  4058       4         2                     -1  Glyphed Breastplate         14674        2       0           0         1     30283       6056              5              -1             -1         41             36              0                  0              0                  0                 0                          0                       0         0          1               0           2           7            4           6           15           0            0           0            0           0            0           0            0           0            0           0            0           0            0            0             0                        0                 0         0         0          0         0         0          0     113         0         0           0          0           0           0       0          0               0          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1        2                      0           0             0           0       0         8       0               0             0       0        0             85       0       0          0              0              0                0              0                0              0                0            0              0                      125                    0         0                  0          0                         7         0             0             0            0          12340

As a reference, I also used this lookup to see what is normal for bullets and arrows:

SELECT * FROM `item_template` WHERE `InventoryType`= 24 ORDER BY `entry`;

(I skipped listing the resulting 57 ammo rows from TDB 335.60 world DB to save your reading time.)

Suggested solution:
This will fix the tooltip info, make the bullet stackable again and allow it to be put in ammo pouches:

-- 
-- Restore correct values for bullet item "Deprecated BKP "Impact" Shot":
UPDATE `item_template` SET `name`= 'Deprecated BKP "Impact" Shot', `Quality`= 1,
 `Flags`= 16, `FlagsExtra`= 8192, `BuyCount`= 200, `BuyPrice`= 450, `SellPrice`= 0,
 `ItemLevel`= 35, `RequiredLevel`= 30, `stackable`= 1000, `StatsCount`= 0, 
 `stat_type1`= 0, `stat_value1`= 0, `stat_type2`= 0, `stat_value2`= 0, `dmg_min1`= 9,
 `dmg_max1`= 9, `armor`= 0, `delay`= 3000, `bonding`= 0, `MaxDurability`= 0, `BagFamily`= 2,
 `RequiredDisenchantSkill`= -1, `DisenchantID`= 0 WHERE `entry`= 3034;

(Delete the game Cache folder before verifying the end result, otherwise it will look as if it doesn't work.)

Result after running the query above and then looking up the previously mentioned items:

SELECT * FROM `item_template` WHERE `entry` IN (3030,3031,3033,3034,4058);

 entry   class  subclass  SoundOverrideSubclass  name                          displayid  Quality   Flags  FlagsExtra  BuyCount  BuyPrice  SellPrice  InventoryType  AllowableClass  AllowableRace  ItemLevel  RequiredLevel  RequiredSkill  RequiredSkillRank  requiredspell  requiredhonorrank  RequiredCityRank  RequiredReputationFaction  RequiredReputationRank  maxcount  stackable  ContainerSlots  StatsCount  stat_type1  stat_value1  stat_type2  stat_value2  stat_type3  stat_value3  stat_type4  stat_value4  stat_type5  stat_value5  stat_type6  stat_value6  stat_type7  stat_value7  stat_type8  stat_value8  stat_type9  stat_value9  stat_type10  stat_value10  ScalingStatDistribution  ScalingStatValue  dmg_min1  dmg_max1  dmg_type1  dmg_min2  dmg_max2  dmg_type2   armor  holy_res  fire_res  nature_res  frost_res  shadow_res  arcane_res   delay  ammo_type  RangedModRange  spellid_1  spelltrigger_1  spellcharges_1  spellppmRate_1  spellcooldown_1  spellcategory_1  spellcategorycooldown_1  spellid_2  spelltrigger_2  spellcharges_2  spellppmRate_2  spellcooldown_2  spellcategory_2  spellcategorycooldown_2  spellid_3  spelltrigger_3  spellcharges_3  spellppmRate_3  spellcooldown_3  spellcategory_3  spellcategorycooldown_3  spellid_4  spelltrigger_4  spellcharges_4  spellppmRate_4  spellcooldown_4  spellcategory_4  spellcategorycooldown_4  spellid_5  spelltrigger_5  spellcharges_5  spellppmRate_5  spellcooldown_5  spellcategory_5  spellcategorycooldown_5  bonding  description  PageText  LanguageID  PageMaterial  startquest  lockid  Material  sheath  RandomProperty  RandomSuffix   block  itemset  MaxDurability    area     Map  BagFamily  TotemCategory  socketColor_1  socketContent_1  socketColor_2  socketContent_2  socketColor_3  socketContent_3  socketBonus  GemProperties  RequiredDisenchantSkill  ArmorDamageModifier  duration  ItemLimitCategory  HolidayId  ScriptName  DisenchantID  FoodType  minMoneyLoot  maxMoneyLoot  flagsCustom  VerifiedBuild
------  ------  --------  ---------------------  ----------------------------  ---------  -------  ------  ----------  --------  --------  ---------  -------------  --------------  -------------  ---------  -------------  -------------  -----------------  -------------  -----------------  ----------------  -------------------------  ----------------------  --------  ---------  --------------  ----------  ----------  -----------  ----------  -----------  ----------  -----------  ----------  -----------  ----------  -----------  ----------  -----------  ----------  -----------  ----------  -----------  ----------  -----------  -----------  ------------  -----------------------  ----------------  --------  --------  ---------  --------  --------  ---------  ------  --------  --------  ----------  ---------  ----------  ----------  ------  ---------  --------------  ---------  --------------  --------------  --------------  ---------------  ---------------  -----------------------  ---------  --------------  --------------  --------------  ---------------  ---------------  -----------------------  ---------  --------------  --------------  --------------  ---------------  ---------------  -----------------------  ---------  --------------  --------------  --------------  ---------------  ---------------  -----------------------  ---------  --------------  --------------  --------------  ---------------  ---------------  -----------------------  -------  -----------  --------  ----------  ------------  ----------  ------  --------  ------  --------------  ------------  ------  -------  -------------  ------  ------  ---------  -------------  -------------  ---------------  -------------  ---------------  -------------  ---------------  -----------  -------------  -----------------------  -------------------  --------  -----------------  ---------  ----------  ------------  --------  ------------  ------------  -----------  -------------
  3030       6         2                     -1  Razor Arrow                       26497        1       0           0       200       300          0             24              -1             -1         30             25              0                  0              0                  0                 0                          0                       0         0       1000               0           0           0            0           0            0           0            0           0            0           0            0           0            0           0            0           0            0           0            0            0             0                        0                 0         7         8          0         0         0          0       0         0         0           0          0           0           0    3000          0               0          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1        0                      0           0             0           0       0         2       0               0             0       0        0              0       0       0          1              0              0                0              0                0              0                0            0              0                       -1                    0         0                  0          0                         0         0             0             0            0          12340
  3031       6         2                     -1  Depricated Razor Arrow             5996        1      16        8192       200       450          0             24              -1             -1         35             30              0                  0              0                  0                 0                          0                       0         0       1000               0           0           0            0           0            0           0            0           0            0           0            0           0            0           0            0           0            0           0            0            0             0                        0                 0         0         0          0         0         0          0       0         0         0           0          0           0           0    3000          0               0          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1        0                      0           0             0           0       0         2       0               0             0       0        0              0       0       0          1              0              0                0              0                0              0                0            0              0                       -1                    0         0                  0          0                         0         0             0             0            0          15595
  3033       6         3                     -1  Solid Shot                         5998        1       0           0       200       300          0             24              -1             -1         30             25              0                  0              0                  0                 0                          0                       0         0       1000               0           0           0            0           0            0           0            0           0            0           0            0           0            0           0            0           0            0           0            0            0             0                        0                 0         7         8          0         0         0          0       0         0         0           0          0           0           0    3000          0               0          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1        0                      0           0             0           0       0         2       0               0             0       0        0              0       0       0          2              0              0                0              0                0              0                0            0              0                       -1                    0         0                  0          0                         0         0             0             0            0          12340
  3034       6         3                     -1  Deprecated BKP "Impact" Shot       5998        1      16        8192       200       450          0             24              -1             -1         35             30              0                  0              0                  0                 0                          0                       0         0       1000               0           0           0            0           0            0           0            0           0            0           0            0           0            0           0            0           0            0           0            0            0             0                        0                 0         9         9          0         0         0          0       0         0         0           0          0           0           0    3000          0               0          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1        0                      0           0             0           0       0         2       0               0             0       0        0              0       0       0          2              0              0                0              0                0              0                0            0              0                       -1                    0         0                  0          0                         0         0             0             0            0              0
  4058       4         2                     -1  Glyphed Breastplate               14674        2       0           0         1     30283       6056              5              -1             -1         41             36              0                  0              0                  0                 0                          0                       0         0          1               0           2           7            4           6           15           0            0           0            0           0            0           0            0           0            0           0            0           0            0            0             0                        0                 0         0         0          0         0         0          0     113         0         0           0          0           0           0       0          0               0          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1          0               0               0               0               -1                0                       -1        2                      0           0             0           0       0         8       0               0             0       0        0             85       0       0          0              0              0                0              0                0              0                0            0              0                      125                    0         0                  0          0                         7         0             0             0            0          12340