Custom DPS polearm and bow for TDB 434 (for GM use)

-- ---------------------------------------------
-- -- Bow of Precision and Polearm of Insight --
-- ---------------------------------------------

-- Custom bow and polearm for DPS, intended for GM use on TrinityCore 4.3.4

-- class restrictions can be changed/removed, but they are as follows:
-- bow is hunter/rogue restricted
-- polearm is hunter/druid restricted

-- Feel free to change the names of these weapons

SET @GMBOW         := 133477;
SET @GMPOLEARM     := 133478;
SET @DISPIDBOW     := 30926; -- War-Torn (or Charmed) Ancient Bone Bow
SET @DISPIDPOLEARM := 37410; -- Blood-Tempered Ranseur

DELETE FROM `item_template` WHERE `entry`=@GMBOW OR `entry`=@GMPOLEARM;
INSERT INTO `item_template` (`entry`, `class`, `subclass`, `SoundOverrideSubclass`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `Unk430_1`, `Unk430_2`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `stat_type1`, `stat_value1`, `stat_unk1_1`, `stat_unk2_1`, `stat_type2`, `stat_value2`, `stat_unk1_2`, `stat_unk2_2`, `stat_type3`, `stat_value3`, `stat_unk1_3`, `stat_unk2_3`, `stat_type4`, `stat_value4`, `stat_unk1_4`, `stat_unk2_4`, `stat_type5`, `stat_value5`, `stat_unk1_5`, `stat_unk2_5`, `stat_type6`, `stat_value6`, `stat_unk1_6`, `stat_unk2_6`, `stat_type7`, `stat_value7`, `stat_unk1_7`, `stat_unk2_7`, `stat_type8`, `stat_value8`, `stat_unk1_8`, `stat_unk2_8`, `stat_type9`, `stat_value9`, `stat_unk1_9`, `stat_unk2_9`, `stat_type10`, `stat_value10`, `stat_unk1_10`, `stat_unk2_10`, `ScalingStatDistribution`, `DamageType`, `delay`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `RandomSuffix`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `ArmorDamageModifier`, `duration`, `ItemLimitCategory`, `HolidayId`, `StatScalingFactor`, `CurrencySubstitutionId`, `CurrencySubstitutionCount`, `flagsCustom`, `WDBVerified`)
VALUES
    (@GMBOW, 2, 2, -1, 'Bow of Precision', @DISPIDBOW, 6, 0, 8192, 1.0174, 1, 1, 4531696, 906339, 15, 12, -1, 576, 85, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 3, 2400, 0, 0, 7, 3850, 0, 0, 31, 1250, 0, 0, 32, 1250, 0, 0, 49, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 200, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 1, 'You just can''t miss.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 2, 0, 2, 0, 4150, 0, 0, 0, 0, 0, 0.4, 0, 0, 0
, 15595),
    (@GMPOLEARM, 2, 6, -1, 'Polearm of Insight', @DISPIDPOLEARM, 6, 0, 8192, 1.0174, 1, 1, 4531696, 906339, 17, 1028, -1, 576, 85, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 3, 2400, 0, 0, 7, 3867, 0, 0, 31, 1250, 0, 0, 32, 1250, 0, 0, 49, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2250, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 1, 'Granting you the vision to see your opponent''s next move.', 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 2, 0, 2, 0, 4150, 0, 0, 0, 0, 0, 0.4, 0, 0, 0, 15595);