blacknight

November 17, 2016

bl actually matched a http var for the rest api this data come from so any one using this table would know what its for.

this table is used to cache items from the WoW api and save them to cut down on making requests to the main api over and over again

a basic item is an item where no other upgrades to it are present where as context and bl (bonuslist) can change the stats lvl or rarity of the item

and yes at this time i am current making sure all fields are called but this dosent seem very effective to me and i thought maybe i was doing something wrong lol

November 16, 2016

ok here is some data for you to look at ...

CREATE TABLE `roster_api_items` (
  `id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `context` varchar(100) DEFAULT NULL,
  `bl` varchar(100) DEFAULT NULL,
  `item_name` varchar(96) NOT NULL,
  `item_color` varchar(16) NOT NULL,
  `item_texture` varchar(64) NOT NULL,
  `item_tooltip` mediumtext NOT NULL,
  `level` int(11) DEFAULT NULL,
  `item_level` int(11) DEFAULT NULL,
  `item_type` varchar(64) DEFAULT NULL,
  `item_subtype` varchar(64) DEFAULT NULL,
  `item_rarity` int(4) NOT NULL DEFAULT '0',
  `locale` varchar(16) DEFAULT NULL,
  `timestamp` int(10) NOT NULL,
  `json` longtext
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `roster_api_items`
--

INSERT INTO `roster_api_items` (`id`, `item_id`, `context`, `bl`, `item_name`, `item_color`, `item_texture`, `item_tooltip`, `level`, `item_level`, `item_type`, `item_subtype`, `item_rarity`, `locale`, `timestamp`, `json`) VALUES
(2116, 123910, '', '', 'Demonsteel Breastplate', '0070dd', 'inv_chest_plate_legionendgame_c_01', 'Demonsteel Breastplate<br /> Obliterum: 0/8<br />Binds when equipped<br />Item Level 815<br />Chest	Plate<br />632 Armor<br />+1404 Stamina<br />+936 Strenght or Intelect<br />Durability 140 / 140 <br />Requires Level 110<br />', 110, 815, '', '', 3, 'en_US', 1479323908, '{"id":123910,"disenchantingSkillRank":0,"description":"","name":"Demonsteel Breastplate","icon":"inv_chest_plate_legionendgame_c_01","stackable":1,"itemBind":2,"bonusStats":[{"stat":74,"amount":936},{"stat":7,"amount":1404}],"itemSpells":[],"buyPrice":1970200,"itemClass":4,"itemSubClass":4,"containerSlots":0,"inventoryType":5,"equippable":true,"itemLevel":815,"maxCount":0,"maxDurability":140,"minFactionId":0,"minReputation":0,"quality":3,"sellPrice":394040,"requiredSkill":0,"requiredLevel":110,"requiredSkillRank":0,"itemSource":{"sourceId":182951,"sourceType":"CREATED_BY_SPELL"},"baseArmor":632,"hasSockets":false,"isAuctionable":true,"armor":632,"displayInfoId":145092,"nameDescription":" Obliterum: 0/8","nameDescriptionColor":"00ff00","upgradable":true,"heroicTooltip":false,"context":"trade-skill","bonusLists":[596,3408],"availableContexts":["trade-skill"],"bonusSummary":{"defaultBonusLists":[596,689,3408],"chanceBonusLists":[600,601,1676,1677,1678,1679,1680,1681,1682,1683,1684,1685,1686,1687,1688,1689,1690,1691,1692,1693,1694,1695,1696,1697,1698,1699,1700,1701,1702,1703,1704,1705,1706,1707,1708,1709,1710,1711,1712,1713,1714,1715,1716,1717,1718,1719,1720,1721],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Fireflash","id":13150},"stats":[{"statId":"32","delta":327,"maxDelta":818},{"statId":"36","delta":327,"maxDelta":818}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Peerless","id":13151},"stats":[{"statId":"32","delta":327,"maxDelta":818},{"statId":"49","delta":327,"maxDelta":818}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Quickblade","id":13152},"stats":[{"statId":"32","delta":327,"maxDelta":818},{"statId":"40","delta":327,"maxDelta":818}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Feverflare","id":13156},"stats":[{"statId":"36","delta":327,"maxDelta":818},{"statId":"49","delta":327,"maxDelta":818}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Aurora","id":13157},"stats":[{"statId":"36","delta":327,"maxDelta":818},{"statId":"40","delta":327,"maxDelta":818}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Harmonious","id":13161},"stats":[{"statId":"40","delta":327,"maxDelta":818},{"statId":"49","delta":327,"maxDelta":818}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Impatient","id":13170},"stats":[{"statId":"36","delta":1145}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Savant","id":13171},"stats":[{"statId":"49","delta":1145}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Adaptable","id":13172},"stats":[{"statId":"40","delta":1145}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Decimator","id":13176},"stats":[{"statId":"32","delta":1145}],"sockets":[]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:26 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1b-112.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"2","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1849","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"3090","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/123910?id=123910&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2117, 134185, '', '', 'Skoldiir Sabatons', '0070dd', 'inv_boot_plate_legionendgame_c_01', 'Skoldiir Sabatons<br /><br />Binds when picked up<br />Item Level 810<br />Feet	Plate<br />430 Armor<br />+1005 Stamina<br />+530 Critical Strike<br />+313 Mastery<br />+670 Strenght or Intelect<br />Durability 65 / 65 <br />Requires Level 101<br />', 101, 810, '', '', 3, 'en_US', 1479323910, '{"id":134185,"disenchantingSkillRank":0,"description":"","name":"Skoldiir Sabatons","icon":"inv_boot_plate_legionendgame_c_01","stackable":1,"itemBind":1,"bonusStats":[{"stat":32,"amount":530},{"stat":74,"amount":670},{"stat":49,"amount":313},{"stat":7,"amount":1005}],"itemSpells":[],"buyPrice":1251538,"itemClass":4,"itemSubClass":4,"containerSlots":0,"inventoryType":8,"equippable":true,"itemLevel":810,"maxCount":0,"maxDurability":65,"minFactionId":0,"minReputation":0,"quality":3,"sellPrice":250307,"requiredSkill":0,"requiredLevel":101,"requiredSkillRank":0,"itemSource":{"sourceId":0,"sourceType":"NONE"},"baseArmor":430,"hasSockets":false,"isAuctionable":false,"armor":430,"displayInfoId":145075,"nameDescription":"","nameDescriptionColor":"000000","upgradable":true,"heroicTooltip":false,"context":"dungeon-level-up-1","bonusLists":[1795],"availableContexts":["dungeon-level-up-1","dungeon-normal","dungeon-heroic","challenge-mode","dungeon-mythic","world-quest-1","world-quest-2","world-quest-3","world-quest-4","world-quest-5","world-quest-6","challenge-mode-2","challenge-mode-3","challenge-mode-jackpot","world-quest-7","world-quest-8","world-quest-9"],"bonusSummary":{"defaultBonusLists":[1795],"chanceBonusLists":[],"bonusChances":[]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:29 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1b-127.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"3","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1854","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1265","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/134185?id=134185&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2118, 139065, '', '', 'Dreamwalker\' s Band', '0070dd', 'inv_70_quest_ring8a', 'Dreamwalker\' s Band<br /><br />Binds when picked up<br />Item Level 810<br />Finger	Miscellaneous<br />+754 Stamina<br />+994 Haste<br />+587 Mastery<br />Requires Level 101<br />', 101, 810, '', '', 3, 'en_US', 1479323911, '{"id":139065,"disenchantingSkillRank":0,"description":"","name":"Dreamwalker\' s Band","icon":"inv_70_quest_ring8a","stackable":1,"itemBind":1,"bonusStats":[{"stat":49,"amount":587},{"stat":36,"amount":994},{"stat":7,"amount":754}],"itemSpells":[],"buyPrice":1111301,"itemClass":4,"itemSubClass":0,"containerSlots":0,"inventoryType":11,"equippable":true,"itemLevel":810,"maxCount":0,"maxDurability":0,"minFactionId":0,"minReputation":0,"quality":3,"sellPrice":222260,"requiredSkill":0,"requiredLevel":101,"requiredSkillRank":0,"itemSource":{"sourceId":0,"sourceType":"NONE"},"baseArmor":0,"hasSockets":false,"isAuctionable":false,"armor":0,"displayInfoId":0,"nameDescription":"","nameDescriptionColor":"000000","upgradable":true,"heroicTooltip":false,"context":"dungeon-level-up-1","bonusLists":[1795],"availableContexts":["dungeon-level-up-1","dungeon-normal","dungeon-heroic","challenge-mode","dungeon-mythic","world-quest-1","world-quest-2","world-quest-3","world-quest-4","world-quest-5","world-quest-6","challenge-mode-2","challenge-mode-3","challenge-mode-jackpot","world-quest-7","world-quest-8","world-quest-9"],"bonusSummary":{"defaultBonusLists":[1795],"chanceBonusLists":[],"bonusChances":[]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:29 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1b-115.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"2","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1856","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1218","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/139065?id=139065&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2119, 113900, '', '', 'Vertebrae Protector', 'a335ee', 'inv_6_0raid_necklace_2d', 'Vertebrae Protector<br /><br />Binds when picked up<br />Item Level 670<br />Neck	Miscellaneous<br />+136 Strength<br />+204 Stamina<br />+92 Critical Strike<br />+89 Haste<br />Requires Level 100<br />', 100, 670, '', '', 4, 'en_US', 1479323916, '{"id":113900,"disenchantingSkillRank":0,"description":"","name":"Vertebrae Protector","icon":"inv_6_0raid_necklace_2d","stackable":1,"itemBind":1,"bonusStats":[{"stat":4,"amount":136},{"stat":36,"amount":89},{"stat":32,"amount":92},{"stat":7,"amount":204}],"itemSpells":[],"buyPrice":906067,"itemClass":4,"itemSubClass":0,"containerSlots":0,"inventoryType":2,"equippable":true,"itemLevel":670,"maxCount":0,"maxDurability":0,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":181213,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":0,"sourceType":"NONE"},"baseArmor":0,"hasSockets":false,"isAuctionable":false,"armor":0,"displayInfoId":0,"nameDescription":"","nameDescriptionColor":"000000","upgradable":true,"heroicTooltip":false,"context":"raid-normal","bonusLists":[],"availableContexts":["raid-normal","raid-heroic","raid-mythic"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[560,563,40,41,42],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"4","delta":9},{"statId":"7","delta":13},{"statId":"32","delta":6},{"statId":"36","delta":5}],"sockets":[]},{"chanceType":"STAT","stats":[{"statId":"61","delta":78},{"statId":"62","delta":78},{"statId":"63","delta":78}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:35 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1e-126.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"2","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1862","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1444","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/113900?id=113900&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2120, 113990, '', '', 'Overdriven Spaulders', 'a335ee', 'inv_shoulder_plate_raidpaladin_o_01', 'Overdriven Spaulders<br /><br />Binds when picked up<br />Item Level 670<br />Shoulder	Plate<br />264 Armor<br />+273 Stamina<br />+118 Haste<br />+123 Mastery<br />+182 Strenght or Intelect<br />Durability 100 / 100 <br />Requires Level 100<br />', 100, 670, '', '', 4, 'en_US', 1479323917, '{"id":113990,"disenchantingSkillRank":0,"description":"","name":"Overdriven Spaulders","icon":"inv_shoulder_plate_raidpaladin_o_01","stackable":1,"itemBind":1,"bonusStats":[{"stat":74,"amount":182},{"stat":49,"amount":123},{"stat":36,"amount":118},{"stat":7,"amount":273}],"itemSpells":[],"buyPrice":1565888,"itemClass":4,"itemSubClass":4,"containerSlots":0,"inventoryType":3,"equippable":true,"itemLevel":670,"maxCount":0,"maxDurability":100,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":313177,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":0,"sourceType":"NONE"},"baseArmor":264,"hasSockets":false,"isAuctionable":false,"armor":264,"displayInfoId":132618,"nameDescription":"","nameDescriptionColor":"000000","upgradable":true,"heroicTooltip":false,"context":"raid-normal","bonusLists":[],"availableContexts":["raid-normal","raid-heroic","raid-mythic"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[560,563,40,41,42,43],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"armor","delta":5},{"statId":"74","delta":10},{"statId":"7","delta":16},{"statId":"36","delta":7},{"statId":"49","delta":7}],"sockets":[]},{"chanceType":"STAT","stats":[{"statId":"61","delta":104},{"statId":"62","delta":104},{"statId":"63","delta":104},{"statId":"64","delta":104}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:35 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1b-121.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"1","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1863","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1537","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/113990?id=113990&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2121, 113916, '', '', 'Charbreath Firecloak', 'a335ee', 'inv_cape_draenorraid_d_01plate_warrior', 'Charbreath Firecloak<br /><br />Binds when picked up<br />Item Level 670<br />Cloak	Cloth<br />58 Armor<br />+136 Strength<br />+204 Stamina<br />+95 Critical Strike<br />+84 Haste<br />Requires Level 100<br />', 100, 670, '', '', 4, 'en_US', 1479323917, '{"id":113916,"disenchantingSkillRank":0,"description":"","name":"Charbreath Firecloak","icon":"inv_cape_draenorraid_d_01plate_warrior","stackable":1,"itemBind":1,"bonusStats":[{"stat":4,"amount":136},{"stat":36,"amount":84},{"stat":32,"amount":95},{"stat":7,"amount":204}],"itemSpells":[],"buyPrice":1559756,"itemClass":4,"itemSubClass":1,"containerSlots":0,"inventoryType":16,"equippable":true,"itemLevel":670,"maxCount":0,"maxDurability":0,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":311951,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":0,"sourceType":"NONE"},"baseArmor":58,"hasSockets":false,"isAuctionable":false,"armor":58,"displayInfoId":139023,"nameDescription":"","nameDescriptionColor":"000000","upgradable":true,"heroicTooltip":false,"context":"raid-normal","bonusLists":[],"availableContexts":["raid-normal","raid-heroic","raid-mythic"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[560,563,40,41,42],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"armor","delta":3},{"statId":"4","delta":9},{"statId":"7","delta":13},{"statId":"32","delta":6},{"statId":"36","delta":5}],"sockets":[]},{"chanceType":"STAT","stats":[{"statId":"61","delta":78},{"statId":"62","delta":78},{"statId":"63","delta":78}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:35 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1e-126.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"2","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1864","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1498","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/113916?id=113916&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2122, 113896, '', '', 'Fleshmelter Bracers', 'a335ee', 'inv_plate_raiddeathknight_o_01bracer', 'Fleshmelter Bracers<br /><br />Binds when picked up<br />Item Level 670<br />Wrist	Plate<br />154 Armor<br />+204 Stamina<br />+69 Haste<br />+104 Mastery<br />+136 Strenght or Intelect<br />Durability 55 / 55 <br />Requires Level 100<br />', 100, 670, '', '', 4, 'en_US', 1479323918, '{"id":113896,"disenchantingSkillRank":0,"description":"","name":"Fleshmelter Bracers","icon":"inv_plate_raiddeathknight_o_01bracer","stackable":1,"itemBind":1,"bonusStats":[{"stat":74,"amount":136},{"stat":49,"amount":104},{"stat":36,"amount":69},{"stat":7,"amount":204}],"itemSpells":[],"buyPrice":1047981,"itemClass":4,"itemSubClass":4,"containerSlots":0,"inventoryType":9,"equippable":true,"itemLevel":670,"maxCount":0,"maxDurability":55,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":209596,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":0,"sourceType":"NONE"},"baseArmor":154,"hasSockets":false,"isAuctionable":false,"armor":154,"displayInfoId":136968,"nameDescription":"","nameDescriptionColor":"000000","upgradable":true,"heroicTooltip":false,"context":"raid-normal","bonusLists":[],"availableContexts":["raid-normal","raid-heroic","raid-mythic"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[560,563,40,41,42,43],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"armor","delta":3},{"statId":"74","delta":9},{"statId":"7","delta":13},{"statId":"36","delta":4},{"statId":"49","delta":6}],"sockets":[]},{"chanceType":"STAT","stats":[{"statId":"61","delta":78},{"statId":"62","delta":78},{"statId":"63","delta":78},{"statId":"64","delta":78}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:36 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1b-112.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"2","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1866","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1530","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/113896?id=113896&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2123, 113906, '', '', 'Gauntlets of Dramatic Blows', 'a335ee', 'inv_plate_raiddeathknight_o_01glove', 'Gauntlets of Dramatic Blows<br /><br />Binds when picked up<br />Item Level 670<br />Hands	Plate<br />220 Armor<br />+273 Stamina<br />+112 Critical Strike<br />+127 Mastery<br />+182 Strenght or Intelect<br />Durability 55 / 55 <br />Requires Level 100<br />', 100, 670, '', '', 4, 'en_US', 1479323918, '{"id":113906,"disenchantingSkillRank":0,"description":"","name":"Gauntlets of Dramatic Blows","icon":"inv_plate_raiddeathknight_o_01glove","stackable":1,"itemBind":1,"bonusStats":[{"stat":74,"amount":182},{"stat":49,"amount":127},{"stat":32,"amount":112},{"stat":7,"amount":273}],"itemSpells":[],"buyPrice":982695,"itemClass":4,"itemSubClass":4,"containerSlots":0,"inventoryType":10,"equippable":true,"itemLevel":670,"maxCount":0,"maxDurability":55,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":196539,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":0,"sourceType":"NONE"},"baseArmor":220,"hasSockets":false,"isAuctionable":false,"armor":220,"displayInfoId":136965,"nameDescription":"","nameDescriptionColor":"000000","upgradable":true,"heroicTooltip":false,"context":"raid-normal","bonusLists":[],"availableContexts":["raid-normal","raid-heroic","raid-mythic"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[560,563,40,41,42,43],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"armor","delta":4},{"statId":"74","delta":10},{"statId":"7","delta":16},{"statId":"32","delta":7},{"statId":"49","delta":7}],"sockets":[]},{"chanceType":"STAT","stats":[{"statId":"61","delta":104},{"statId":"62","delta":104},{"statId":"63","delta":104},{"statId":"64","delta":104}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:37 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1b-118.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"3","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1867","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1543","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/113906?id=113906&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2124, 113659, '', '', 'Fleshchewer Greatbelt', 'a335ee', 'inv_plate_raidwarrior_o_01belt', 'Fleshchewer Greatbelt<br /><br />Binds when picked up<br />Item Level 655<br />Waist	Plate<br />190 Armor<br />+237 Stamina<br />+116 Critical Strike<br />+88 Haste<br />+158 Strenght or Intelect<br />Durability 55 / 55 <br />Requires Level 100<br />', 100, 655, '', '', 4, 'en_US', 1479323919, '{"id":113659,"disenchantingSkillRank":0,"description":"","name":"Fleshchewer Greatbelt","icon":"inv_plate_raidwarrior_o_01belt","stackable":1,"itemBind":1,"bonusStats":[{"stat":74,"amount":158},{"stat":32,"amount":116},{"stat":36,"amount":88},{"stat":7,"amount":237}],"itemSpells":[],"buyPrice":931775,"itemClass":4,"itemSubClass":4,"containerSlots":0,"inventoryType":6,"equippable":true,"itemLevel":655,"maxCount":0,"maxDurability":55,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":186355,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":0,"sourceType":"NONE"},"baseArmor":190,"hasSockets":false,"isAuctionable":false,"armor":190,"displayInfoId":139972,"nameDescription":"","nameDescriptionColor":"000000","upgradable":true,"heroicTooltip":false,"context":"raid-normal","bonusLists":[],"availableContexts":["raid-normal","raid-heroic","raid-mythic"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[560,563,40,41,42,43],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"armor","delta":3},{"statId":"74","delta":9},{"statId":"7","delta":14},{"statId":"32","delta":7},{"statId":"36","delta":5}],"sockets":[]},{"chanceType":"STAT","stats":[{"statId":"61","delta":90},{"statId":"62","delta":90},{"statId":"63","delta":90},{"statId":"64","delta":90}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:37 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1b-127.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"1","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1868","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1525","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/113659?id=113659&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2125, 113961, '', '', 'Iron Bellow Sabatons', 'a335ee', 'inv_plate_raidwarrior_o_01boots', 'Iron Bellow Sabatons<br /><br />Binds when picked up<br />Item Level 670<br />Feet	Plate<br />242 Armor<br />+273 Stamina<br />+95 Critical Strike<br />+137 Haste<br />+182 Strenght or Intelect<br />Durability 80 / 80 <br />Requires Level 100<br />', 100, 670, '', '', 4, 'en_US', 1479323920, '{"id":113961,"disenchantingSkillRank":0,"description":"","name":"Iron Bellow Sabatons","icon":"inv_plate_raidwarrior_o_01boots","stackable":1,"itemBind":1,"bonusStats":[{"stat":74,"amount":182},{"stat":32,"amount":95},{"stat":36,"amount":137},{"stat":7,"amount":273}],"itemSpells":[],"buyPrice":1474679,"itemClass":4,"itemSubClass":4,"containerSlots":0,"inventoryType":8,"equippable":true,"itemLevel":670,"maxCount":0,"maxDurability":80,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":294935,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":0,"sourceType":"NONE"},"baseArmor":242,"hasSockets":false,"isAuctionable":false,"armor":242,"displayInfoId":132729,"nameDescription":"","nameDescriptionColor":"000000","upgradable":true,"heroicTooltip":false,"context":"raid-normal","bonusLists":[],"availableContexts":["raid-normal","raid-heroic","raid-mythic"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[560,563,40,41,42,43],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"armor","delta":4},{"statId":"74","delta":10},{"statId":"7","delta":16},{"statId":"32","delta":5},{"statId":"36","delta":8}],"sockets":[]},{"chanceType":"STAT","stats":[{"statId":"61","delta":104},{"statId":"62","delta":104},{"statId":"63","delta":104},{"statId":"64","delta":104}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:38 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1b-112.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"1","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1870","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1531","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/113961?id=113961&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2126, 116830, '', '', 'Researcher\'s Ring', '1eff00', 'inv_ringwod_7d', 'Researcher\'s Ring<br /><br />Binds when picked up<br />Item Level 588<br />Finger	Miscellaneous<br />+64 Strength<br />+95 Stamina<br />+44 Versatility<br />+40 Mastery<br />', 0, 588, '', '', 2, 'en_US', 1479323921, '{"id":116830,"disenchantingSkillRank":0,"description":"","name":"Researcher\'s Ring","icon":"inv_ringwod_7d","stackable":1,"itemBind":1,"bonusStats":[{"stat":40,"amount":44},{"stat":49,"amount":40},{"stat":4,"amount":64},{"stat":7,"amount":95}],"itemSpells":[],"buyPrice":593678,"itemClass":4,"itemSubClass":0,"containerSlots":0,"inventoryType":11,"equippable":true,"itemLevel":588,"maxCount":0,"maxDurability":0,"minFactionId":0,"minReputation":0,"quality":2,"sellPrice":118735,"requiredSkill":0,"requiredLevel":0,"requiredSkillRank":0,"itemSource":{"sourceId":0,"sourceType":"NONE"},"baseArmor":0,"hasSockets":false,"isAuctionable":false,"armor":0,"displayInfoId":0,"nameDescription":"","nameDescriptionColor":"000000","upgradable":true,"heroicTooltip":false,"context":"","bonusLists":[],"availableContexts":[""],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[15,171],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"QUALITY","id":3},"stats":[{"statId":"ilevel","delta":10},{"statId":"4","delta":6},{"statId":"7","delta":10},{"statId":"40","delta":4},{"statId":"49","delta":4}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"QUALITY","id":4},"stats":[{"statId":"ilevel","delta":20},{"statId":"4","delta":13},{"statId":"7","delta":20},{"statId":"40","delta":9},{"statId":"49","delta":9}],"sockets":[]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:39 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1b-112.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"1","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1871","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1365","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/116830?id=116830&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2127, 113599, '', '', 'Grunt\'s Solid Signet', 'a335ee', 'inv_ringwod_d_4', 'Grunt\'s Solid Signet<br /><br />Binds when picked up<br />Item Level 655<br />Finger	Miscellaneous<br />+119 Strength<br />+178 Stamina<br />+84 Critical Strike<br />+71 Haste<br />Requires Level 100<br />', 100, 655, '', '', 4, 'en_US', 1479323921, '{"id":113599,"disenchantingSkillRank":0,"description":"","name":"Grunt\'s Solid Signet","icon":"inv_ringwod_d_4","stackable":1,"itemBind":1,"bonusStats":[{"stat":4,"amount":119},{"stat":36,"amount":71},{"stat":32,"amount":84},{"stat":7,"amount":178}],"itemSpells":[],"buyPrice":1255368,"itemClass":4,"itemSubClass":0,"containerSlots":0,"inventoryType":11,"equippable":true,"itemLevel":655,"maxCount":0,"maxDurability":0,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":251073,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":0,"sourceType":"NONE"},"baseArmor":0,"hasSockets":false,"isAuctionable":false,"armor":0,"displayInfoId":0,"nameDescription":"","nameDescriptionColor":"000000","upgradable":true,"heroicTooltip":false,"context":"raid-normal","bonusLists":[],"availableContexts":["raid-normal","raid-heroic","raid-mythic"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[560,563,40,41,42],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"4","delta":7},{"statId":"7","delta":11},{"statId":"32","delta":5},{"statId":"36","delta":5}],"sockets":[]},{"chanceType":"STAT","stats":[{"statId":"61","delta":68},{"statId":"62","delta":68},{"statId":"63","delta":68}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:40 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1d-113.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"1","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1872","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1439","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/113599?id=113599&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2128, 113645, '', '', 'Tectus\' Beating Heart', 'a335ee', 'inv_misc_trinket6oog_stonefist3', 'Tectus\' Beating Heart<br /><br />Binds when picked up<br />Item Level 655<br />Trinket	Miscellaneous<br />+173 Strength<br />Requires Level 100<br />Equip: Your attacks have a chance to grant ^3.4782 Critical Strike for 10 sec.  (Approximately 0.92 procs per minute)<br />', 100, 655, '', '', 4, 'en_US', 1479323922, '{"id":113645,"disenchantingSkillRank":0,"description":"","name":"Tectus\' Beating Heart","icon":"inv_misc_trinket6oog_stonefist3","stackable":1,"itemBind":1,"bonusStats":[{"stat":4,"amount":173}],"itemSpells":[{"spellId":177041,"spell":{"id":177041,"name":"Item - Attacks Proc Critical Strike [Tectus\' Beating Heart]","icon":"spell_shadow_siphonmana","description":"Your attacks have a chance to grant ^3.4782 Critical Strike for 10 sec.  (Approximately 0.92 procs per minute)","castTime":"Passive"},"nCharges":0,"consumable":false,"categoryId":0,"trigger":"ON_EQUIP"}],"buyPrice":1803234,"itemClass":4,"itemSubClass":0,"containerSlots":0,"inventoryType":12,"equippable":true,"itemLevel":655,"maxCount":0,"maxDurability":0,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":360646,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":0,"sourceType":"NONE"},"baseArmor":0,"hasSockets":false,"isAuctionable":false,"armor":0,"displayInfoId":0,"nameDescription":"","nameDescriptionColor":"000000","upgradable":false,"heroicTooltip":false,"context":"raid-normal","bonusLists":[],"availableContexts":["raid-normal","raid-heroic","raid-mythic"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[560,563,40,41,42],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"4","delta":9}],"sockets":[]},{"chanceType":"STAT","stats":[{"statId":"61","delta":90},{"statId":"62","delta":90},{"statId":"63","delta":90}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:40 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1d-125.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"2","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1873","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1665","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/113645?id=113645&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2129, 115328, '', '', 'Grandiose Greataxe of the Decimator', 'a335ee', 'inv_axe_2h_draenorquest_b_01', 'Grandiose Greataxe of the Decimator<br /><br />Binds when picked up<br />Item Level 645<br />Two-Hand	Axe<br />993 - 1491 Damage	Speed 3.6<br />(344.9 dps)<br />+192 Strength<br />+288 Stamina<br />+512 Critical Strike<br />+256 Haste<br />+256 Versatility<br />+256 Mastery<br />Durability 120 / 120 <br />Requires Level 100<br />', 100, 645, '', '', 4, 'en_US', 1479323922, '{"id":115328,"disenchantingSkillRank":0,"description":"","name":"Grandiose Greataxe of the Decimator","icon":"inv_axe_2h_draenorquest_b_01","stackable":1,"itemBind":1,"bonusStats":[{"stat":40,"amount":256},{"stat":32,"amount":512},{"stat":49,"amount":256},{"stat":4,"amount":192},{"stat":36,"amount":256},{"stat":7,"amount":288}],"itemSpells":[],"buyPrice":3459437,"itemClass":2,"itemSubClass":1,"containerSlots":0,"weaponInfo":{"damage":{"min":993,"max":1491,"exactMin":993,"exactMax":1490},"weaponSpeed":3.6,"dps":344.8611},"inventoryType":17,"equippable":true,"itemLevel":645,"maxCount":0,"maxDurability":120,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":691887,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":0,"sourceType":"NONE"},"baseArmor":0,"hasSockets":false,"isAuctionable":false,"armor":0,"displayInfoId":128531,"nameDescription":"","nameDescriptionColor":"000000","upgradable":true,"heroicTooltip":false,"context":"","bonusLists":[486,487,488,489,490],"availableContexts":[""],"bonusSummary":{"defaultBonusLists":[486,487,488,489,490],"chanceBonusLists":[39,38,37,36,35,34,33,32,31,30,19,29,28,27,26,21,25,24,23,22,20,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,61,62,63,64,65,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,560,563,40,41,42,43],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Fireflash","id":13150},"stats":[{"statId":"32","delta":97,"maxDelta":146},{"statId":"36","delta":97,"maxDelta":146}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Peerless","id":13151},"stats":[{"statId":"32","delta":97,"maxDelta":146},{"statId":"49","delta":97,"maxDelta":146}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Quickblade","id":13152},"stats":[{"statId":"32","delta":97,"maxDelta":146},{"statId":"40","delta":97,"maxDelta":146}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Feverflare","id":13156},"stats":[{"statId":"36","delta":97,"maxDelta":146},{"statId":"49","delta":97,"maxDelta":146}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Aurora","id":13157},"stats":[{"statId":"36","delta":97,"maxDelta":146},{"statId":"40","delta":97,"maxDelta":146}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_SUFFIX","name":"of the Harmonious","id":13161},"stats":[{"statId":"40","delta":97,"maxDelta":146},{"statId":"49","delta":97,"maxDelta":146}],"sockets":[]},{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"4","delta":11},{"statId":"7","delta":17},{"statId":"32","delta":29},{"statId":"36","delta":15},{"statId":"40","delta":15},{"statId":"49","delta":15}],"sockets":[]},{"chanceType":"STAT","stats":[{"statId":"61","delta":110},{"statId":"62","delta":110},{"statId":"63","delta":110},{"statId":"64","delta":110}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:41 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1e-123.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"1","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1875","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"3419","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/115328?id=115328&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2130, 124925, '', '', 'Wild Combatant\'s Chain Helm', '0070dd', 'inv_helm_mail_draenorhonors2_c_01', 'Wild Combatant\'s Chain Helm<br />Warlords Season 2<br />Binds when picked up<br />Item Level 670<br />Head	Mail<br />177 Armor<br />+242 Agility<br />+364 Stamina<br />+162 Critical Strike<br />+162 Mastery<br />Classes: Hunter <br />Races: Human, Human, Dwarf, Dwarf, Night Elf, Night Elf, Gnome, Gnome, Draenei, Draenei, Worgen, Pandaren<br />Durability 85 / 85 <br />Requires Level 100<br />', 100, 670, '', '', 3, 'en_US', 1479323926, '{"id":124925,"disenchantingSkillRank":0,"description":"","name":"Wild Combatant\'s Chain Helm","icon":"inv_helm_mail_draenorhonors2_c_01","stackable":1,"allowableClasses":[3],"allowableRaces":[1,1,3,3,4,4,7,7,11,11,22,25],"itemBind":1,"bonusStats":[{"stat":32,"amount":162},{"stat":49,"amount":162},{"stat":7,"amount":364},{"stat":3,"amount":242}],"itemSpells":[],"buyPrice":0,"itemClass":4,"itemSubClass":3,"containerSlots":0,"inventoryType":1,"equippable":true,"itemLevel":670,"itemSet":{"id":1222,"name":"Gladiator\'s Pursuit","setBonuses":[{"description":"For 6 sec after using Arcane Shot, your PvP power is increased by 795.","threshold":2},{"description":"Increases PvP power by 500.","threshold":2},{"description":"Increases the regeneration of your Focus by 25%.","threshold":4},{"description":"Increases PvP Power by 1,000.","threshold":4}],"items":[127050,127073,127084,127095,127106]},"maxCount":0,"maxDurability":85,"minFactionId":0,"minReputation":0,"quality":3,"sellPrice":189160,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":82880,"sourceType":"VENDOR"},"baseArmor":177,"hasSockets":false,"isAuctionable":false,"armor":177,"displayInfoId":142242,"nameDescription":"Warlords Season 2","nameDescriptionColor":"00ff00","upgradable":true,"heroicTooltip":false,"context":"pvp-unranked","bonusLists":[],"availableContexts":["pvp-unranked"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[546,608,608],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"armor","delta":5},{"statId":"3","delta":15},{"statId":"7","delta":21},{"statId":"32","delta":9},{"statId":"49","delta":9}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"},{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:44 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1d-125.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"1","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1877","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1879","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/124925?id=124925&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2131, 124897, '', '', 'Wild Combatant\'s Necklace of Cruelty', '0070dd', 'inv_60pvp_neck2a', 'Wild Combatant\'s Necklace of Cruelty<br />Warlords Season 2<br />Binds when picked up<br />Item Level 670<br />Neck	Miscellaneous<br />+136 Agility<br />+204 Stamina<br />+97 Critical Strike<br />+84 Haste<br />Races: Human, Human, Dwarf, Dwarf, Night Elf, Night Elf, Gnome, Gnome, Draenei, Draenei, Worgen, Pandaren<br />Requires Level 100<br />', 100, 670, '', '', 3, 'en_US', 1479323926, '{"id":124897,"disenchantingSkillRank":0,"description":"","name":"Wild Combatant\'s Necklace of Cruelty","icon":"inv_60pvp_neck2a","stackable":1,"allowableRaces":[1,1,3,3,4,4,7,7,11,11,22,25],"itemBind":1,"bonusStats":[{"stat":36,"amount":84},{"stat":32,"amount":97},{"stat":7,"amount":204},{"stat":3,"amount":136}],"itemSpells":[],"buyPrice":0,"itemClass":4,"itemSubClass":0,"containerSlots":0,"inventoryType":2,"equippable":true,"itemLevel":670,"maxCount":0,"maxDurability":0,"minFactionId":0,"minReputation":0,"quality":3,"sellPrice":113335,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":82880,"sourceType":"VENDOR"},"baseArmor":0,"hasSockets":false,"isAuctionable":false,"armor":0,"displayInfoId":0,"nameDescription":"Warlords Season 2","nameDescriptionColor":"00ff00","upgradable":true,"heroicTooltip":false,"context":"pvp-unranked","bonusLists":[],"availableContexts":["pvp-unranked"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[546,608,608],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"3","delta":9},{"statId":"7","delta":13},{"statId":"32","delta":6},{"statId":"36","delta":5}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"},{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:45 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1d-125.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"1","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1878","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1389","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/124897?id=124897&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2132, 126092, '', '', 'Warmongering Combatant\'s Spaulders', '0070dd', 'inv_shoulder_mail_draenorhonors2_c_01', 'Warmongering Combatant\'s Spaulders<br />Warlords Season 3<br />Binds when picked up<br />Item Level 700<br />Shoulder	Mail<br />186 Armor<br />+361 Stamina<br />+161 Critical Strike<br />+161 Haste<br />+241 Agility or Intellect<br />Races: Human, Human, Dwarf, Dwarf, Night Elf, Night Elf, Gnome, Gnome, Draenei, Draenei, Worgen, Pandaren<br />Durability 85 / 85 <br />Requires Level 100<br />', 100, 700, '', '', 3, 'en_US', 1479323927, '{"id":126092,"disenchantingSkillRank":0,"description":"","name":"Warmongering Combatant\'s Spaulders","icon":"inv_shoulder_mail_draenorhonors2_c_01","stackable":1,"allowableRaces":[1,1,3,3,4,4,7,7,11,11,22,25],"itemBind":1,"bonusStats":[{"stat":73,"amount":241},{"stat":32,"amount":161},{"stat":36,"amount":161},{"stat":7,"amount":361}],"itemSpells":[],"buyPrice":0,"itemClass":4,"itemSubClass":3,"containerSlots":0,"inventoryType":3,"equippable":true,"itemLevel":700,"maxCount":0,"maxDurability":85,"minFactionId":0,"minReputation":0,"quality":3,"sellPrice":200638,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":0,"sourceType":"NONE"},"baseArmor":186,"hasSockets":false,"isAuctionable":false,"armor":186,"displayInfoId":142260,"nameDescription":"Warlords Season 3","nameDescriptionColor":"00ff00","upgradable":true,"heroicTooltip":false,"context":"pvp-unranked","bonusLists":[],"availableContexts":["pvp-unranked"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[546,608,608],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"armor","delta":5},{"statId":"73","delta":14},{"statId":"7","delta":21},{"statId":"32","delta":9},{"statId":"36","delta":9}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"},{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:45 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1b-109.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"2","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1879","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1446","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/126092?id=126092&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2133, 124686, '', '', 'Wild Gladiator\'s Cape of Prowess', 'a335ee', 'inv_cape_draenorpvp_d_02_leather_blue', 'Wild Gladiator\'s Cape of Prowess<br />Warlords Season 2<br />Binds when picked up<br />Item Level 700<br />Cloak	Cloth<br />72 Armor<br />+180 Agility<br />+271 Stamina<br />+112 Haste<br />+129 Mastery<br />Races: Human, Human, Dwarf, Dwarf, Night Elf, Night Elf, Gnome, Gnome, Draenei, Draenei, Worgen, Pandaren<br />Requires Level 100<br />', 100, 700, '', '', 4, 'en_US', 1479323927, '{"id":124686,"disenchantingSkillRank":0,"description":"","name":"Wild Gladiator\'s Cape of Prowess","icon":"inv_cape_draenorpvp_d_02_leather_blue","stackable":1,"allowableRaces":[1,1,3,3,4,4,7,7,11,11,22,25],"itemBind":1,"bonusStats":[{"stat":49,"amount":129},{"stat":36,"amount":112},{"stat":3,"amount":180},{"stat":7,"amount":271}],"itemSpells":[],"buyPrice":0,"itemClass":4,"itemSubClass":1,"containerSlots":0,"inventoryType":16,"equippable":true,"itemLevel":700,"maxCount":0,"maxDurability":0,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":328888,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":77440,"sourceType":"VENDOR"},"baseArmor":72,"hasSockets":false,"isAuctionable":false,"armor":72,"displayInfoId":139399,"nameDescription":"Warlords Season 2","nameDescriptionColor":"00ff00","upgradable":true,"heroicTooltip":false,"context":"","bonusLists":[],"availableContexts":[""],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[],"bonusChances":[]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:46 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1b-115.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"3","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1880","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1025","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/124686?id=124686&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}');
INSERT INTO `roster_api_items` (`id`, `item_id`, `context`, `bl`, `item_name`, `item_color`, `item_texture`, `item_tooltip`, `level`, `item_level`, `item_type`, `item_subtype`, `item_rarity`, `locale`, `timestamp`, `json`) VALUES
(2134, 124783, '', '', 'Wild Gladiator\'s Armor', 'a335ee', 'inv_chest_mail_raidshaman_p_01', 'Wild Gladiator\'s Armor<br />Warlords Season 2<br />Binds when picked up<br />Item Level 700<br />Chest	Mail<br />248 Armor<br />+481 Stamina<br />+214 Critical Strike<br />+214 Mastery<br />+321 Agility or Intellect<br />Races: Human, Human, Dwarf, Dwarf, Night Elf, Night Elf, Gnome, Gnome, Draenei, Draenei, Worgen, Pandaren<br />Durability 165 / 165 <br />Requires Level 100<br />', 100, 700, '', '', 4, 'en_US', 1479323928, '{"id":124783,"disenchantingSkillRank":0,"description":"","name":"Wild Gladiator\'s Armor","icon":"inv_chest_mail_raidshaman_p_01","stackable":1,"allowableRaces":[1,1,3,3,4,4,7,7,11,11,22,25],"itemBind":1,"bonusStats":[{"stat":73,"amount":321},{"stat":49,"amount":214},{"stat":32,"amount":214},{"stat":7,"amount":481}],"itemSpells":[],"buyPrice":0,"itemClass":4,"itemSubClass":3,"containerSlots":0,"inventoryType":5,"equippable":true,"itemLevel":700,"maxCount":0,"maxDurability":165,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":458440,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":77440,"sourceType":"VENDOR"},"baseArmor":248,"hasSockets":false,"isAuctionable":false,"armor":248,"displayInfoId":142328,"nameDescription":"Warlords Season 2","nameDescriptionColor":"00ff00","upgradable":true,"heroicTooltip":false,"context":"","bonusLists":[],"availableContexts":[""],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[],"bonusChances":[]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:46 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1e-123.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"1","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1881","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1012","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/124783?id=124783&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2135, 124781, '', '', 'Wild Gladiator\'s Armbands of Cruelty', 'a335ee', 'inv_bracer_mail_raidhunter_p_01', 'Wild Gladiator\'s Armbands of Cruelty<br />Warlords Season 2<br />Binds when picked up<br />Item Level 700<br />Wrist	Mail<br />108 Armor<br />+271 Stamina<br />+112 Critical Strike<br />+129 Mastery<br />+180 Agility or Intellect<br />Races: Human, Human, Dwarf, Dwarf, Night Elf, Night Elf, Gnome, Gnome, Draenei, Draenei, Worgen, Pandaren<br />Durability 55 / 55 <br />Requires Level 100<br />', 100, 700, '', '', 4, 'en_US', 1479323928, '{"id":124781,"disenchantingSkillRank":0,"description":"","name":"Wild Gladiator\'s Armbands of Cruelty","icon":"inv_bracer_mail_raidhunter_p_01","stackable":1,"allowableRaces":[1,1,3,3,4,4,7,7,11,11,22,25],"itemBind":1,"bonusStats":[{"stat":73,"amount":180},{"stat":32,"amount":112},{"stat":49,"amount":129},{"stat":7,"amount":271}],"itemSpells":[],"buyPrice":0,"itemClass":4,"itemSubClass":3,"containerSlots":0,"inventoryType":9,"equippable":true,"itemLevel":700,"maxCount":0,"maxDurability":55,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":228835,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":77440,"sourceType":"VENDOR"},"baseArmor":108,"hasSockets":false,"isAuctionable":false,"armor":108,"displayInfoId":141770,"nameDescription":"Warlords Season 2","nameDescriptionColor":"00ff00","upgradable":true,"heroicTooltip":false,"context":"","bonusLists":[],"availableContexts":[""],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[],"bonusChances":[]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:47 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1b-118.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"1","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1883","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1026","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/124781?id=124781&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2136, 124784, '', '', 'Wild Gladiator\'s Gauntlets', 'a335ee', 'inv_glove_mail_raidhunter_p_01', 'Wild Gladiator\'s Gauntlets<br />Warlords Season 2<br />Binds when picked up<br />Item Level 700<br />Hands	Mail<br />155 Armor<br />+361 Stamina<br />+161 Critical Strike<br />+161 Mastery<br />+241 Agility or Intellect<br />Races: Human, Human, Dwarf, Dwarf, Night Elf, Night Elf, Gnome, Gnome, Draenei, Draenei, Worgen, Pandaren<br />Durability 55 / 55 <br />Requires Level 100<br />', 100, 700, '', '', 4, 'en_US', 1479323929, '{"id":124784,"disenchantingSkillRank":0,"description":"","name":"Wild Gladiator\'s Gauntlets","icon":"inv_glove_mail_raidhunter_p_01","stackable":1,"allowableRaces":[1,1,3,3,4,4,7,7,11,11,22,25],"itemBind":1,"bonusStats":[{"stat":73,"amount":241},{"stat":32,"amount":161},{"stat":49,"amount":161},{"stat":7,"amount":361}],"itemSpells":[],"buyPrice":0,"itemClass":4,"itemSubClass":3,"containerSlots":0,"inventoryType":10,"equippable":true,"itemLevel":700,"maxCount":0,"maxDurability":55,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":231388,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":77440,"sourceType":"VENDOR"},"baseArmor":155,"hasSockets":false,"isAuctionable":false,"armor":155,"displayInfoId":141751,"nameDescription":"Warlords Season 2","nameDescriptionColor":"00ff00","upgradable":true,"heroicTooltip":false,"context":"","bonusLists":[],"availableContexts":[""],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[],"bonusChances":[]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:47 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1e-123.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"2","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1884","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1016","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/124784?id=124784&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2137, 124774, '', '', 'Wild Gladiator\'s Waistguard of Cruelty', 'a335ee', 'inv_belt_mail_raidhunter_p_01', 'Wild Gladiator\'s Waistguard of Cruelty<br />Warlords Season 2<br />Binds when picked up<br />Item Level 700<br />Waist	Mail<br />139 Armor<br />+361 Stamina<br />+172 Haste<br />+149 Mastery<br />+241 Agility or Intellect<br />Races: Human, Human, Dwarf, Dwarf, Night Elf, Night Elf, Gnome, Gnome, Draenei, Draenei, Worgen, Pandaren<br />Durability 55 / 55 <br />Requires Level 100<br />', 100, 700, '', '', 4, 'en_US', 1479323929, '{"id":124774,"disenchantingSkillRank":0,"description":"","name":"Wild Gladiator\'s Waistguard of Cruelty","icon":"inv_belt_mail_raidhunter_p_01","stackable":1,"allowableRaces":[1,1,3,3,4,4,7,7,11,11,22,25],"itemBind":1,"bonusStats":[{"stat":73,"amount":241},{"stat":49,"amount":149},{"stat":36,"amount":172},{"stat":7,"amount":361}],"itemSpells":[],"buyPrice":0,"itemClass":4,"itemSubClass":3,"containerSlots":0,"inventoryType":6,"equippable":true,"itemLevel":700,"maxCount":0,"maxDurability":55,"minFactionId":0,"minReputation":0,"quality":4,"sellPrice":222868,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":77440,"sourceType":"VENDOR"},"baseArmor":139,"hasSockets":false,"isAuctionable":false,"armor":139,"displayInfoId":141773,"nameDescription":"Warlords Season 2","nameDescriptionColor":"00ff00","upgradable":true,"heroicTooltip":false,"context":"","bonusLists":[],"availableContexts":[""],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[],"bonusChances":[]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:48 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1e-123.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"3","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1885","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1026","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/124774?id=124774&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2138, 124926, '', '', 'Wild Combatant\'s Chain Leggings', '0070dd', 'inv_pant_mail_draenorhonors2_c_01', 'Wild Combatant\'s Chain Leggings<br />Warlords Season 2<br />Binds when picked up<br />Item Level 670<br />Legs	Mail<br />191 Armor<br />+242 Agility<br />+364 Stamina<br />+162 Haste<br />+162 Mastery<br />Classes: Hunter <br />Races: Human, Human, Dwarf, Dwarf, Night Elf, Night Elf, Gnome, Gnome, Draenei, Draenei, Worgen, Pandaren<br />Durability 100 / 100 <br />Requires Level 100<br />', 100, 670, '', '', 3, 'en_US', 1479323930, '{"id":124926,"disenchantingSkillRank":0,"description":"","name":"Wild Combatant\'s Chain Leggings","icon":"inv_pant_mail_draenorhonors2_c_01","stackable":1,"allowableClasses":[3],"allowableRaces":[1,1,3,3,4,4,7,7,11,11,22,25],"itemBind":1,"bonusStats":[{"stat":49,"amount":162},{"stat":36,"amount":162},{"stat":7,"amount":364},{"stat":3,"amount":242}],"itemSpells":[],"buyPrice":0,"itemClass":4,"itemSubClass":3,"containerSlots":0,"inventoryType":7,"equippable":true,"itemLevel":670,"itemSet":{"id":1222,"name":"Gladiator\'s Pursuit","setBonuses":[{"description":"For 6 sec after using Arcane Shot, your PvP power is increased by 795.","threshold":2},{"description":"Increases PvP power by 500.","threshold":2},{"description":"Increases the regeneration of your Focus by 25%.","threshold":4},{"description":"Increases PvP Power by 1,000.","threshold":4}],"items":[127050,127073,127084,127095,127106]},"maxCount":0,"maxDurability":100,"minFactionId":0,"minReputation":0,"quality":3,"sellPrice":253650,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":82880,"sourceType":"VENDOR"},"baseArmor":191,"hasSockets":false,"isAuctionable":false,"armor":191,"displayInfoId":142244,"nameDescription":"Warlords Season 2","nameDescriptionColor":"00ff00","upgradable":true,"heroicTooltip":false,"context":"pvp-unranked","bonusLists":[],"availableContexts":["pvp-unranked"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[546,608,608],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"armor","delta":5},{"statId":"3","delta":15},{"statId":"7","delta":21},{"statId":"36","delta":9},{"statId":"49","delta":9}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"},{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:48 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1e-127.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"1","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1886","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1884","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/124926?id=124926&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2139, 124971, '', '', 'Wild Combatant\'s Footguards of Prowess', '0070dd', 'inv_boot_mail_draenorhonors2_c_01', 'Wild Combatant\'s Footguards of Prowess<br />Warlords Season 2<br />Binds when picked up<br />Item Level 670<br />Feet	Mail<br />150 Armor<br />+273 Stamina<br />+112 Critical Strike<br />+130 Haste<br />+182 Agility or Intellect<br />Races: Human, Human, Dwarf, Dwarf, Night Elf, Night Elf, Gnome, Gnome, Draenei, Draenei, Worgen, Pandaren<br />Durability 65 / 65 <br />Requires Level 100<br />', 100, 670, '', '', 3, 'en_US', 1479323930, '{"id":124971,"disenchantingSkillRank":0,"description":"","name":"Wild Combatant\'s Footguards of Prowess","icon":"inv_boot_mail_draenorhonors2_c_01","stackable":1,"allowableRaces":[1,1,3,3,4,4,7,7,11,11,22,25],"itemBind":1,"bonusStats":[{"stat":73,"amount":182},{"stat":36,"amount":130},{"stat":32,"amount":112},{"stat":7,"amount":273}],"itemSpells":[],"buyPrice":0,"itemClass":4,"itemSubClass":3,"containerSlots":0,"inventoryType":8,"equippable":true,"itemLevel":670,"maxCount":0,"maxDurability":65,"minFactionId":0,"minReputation":0,"quality":3,"sellPrice":184062,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":82880,"sourceType":"VENDOR"},"baseArmor":150,"hasSockets":false,"isAuctionable":false,"armor":150,"displayInfoId":142239,"nameDescription":"Warlords Season 2","nameDescriptionColor":"00ff00","upgradable":true,"heroicTooltip":false,"context":"pvp-unranked","bonusLists":[],"availableContexts":["pvp-unranked"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[546,608,608],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"armor","delta":4},{"statId":"73","delta":10},{"statId":"7","delta":16},{"statId":"32","delta":7},{"statId":"36","delta":8}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"},{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:48 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1d-125.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"2","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1887","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1452","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/124971?id=124971&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}'),
(2140, 124899, '', '', 'Wild Combatant\'s Ring of Cruelty', '0070dd', 'inv_60pvp_ring4b', 'Wild Combatant\'s Ring of Cruelty<br />Warlords Season 2<br />Binds when picked up<br />Item Level 670<br />Finger	Miscellaneous<br />+136 Agility<br />+204 Stamina<br />+97 Critical Strike<br />+84 Mastery<br />Races: Human, Human, Dwarf, Dwarf, Night Elf, Night Elf, Gnome, Gnome, Draenei, Draenei, Worgen, Pandaren<br />Requires Level 100<br />', 100, 670, '', '', 3, 'en_US', 1479323930, '{"id":124899,"disenchantingSkillRank":0,"description":"","name":"Wild Combatant\'s Ring of Cruelty","icon":"inv_60pvp_ring4b","stackable":1,"allowableRaces":[1,1,3,3,4,4,7,7,11,11,22,25],"itemBind":1,"bonusStats":[{"stat":49,"amount":84},{"stat":32,"amount":97},{"stat":7,"amount":204},{"stat":3,"amount":136}],"itemSpells":[],"buyPrice":0,"itemClass":4,"itemSubClass":0,"containerSlots":0,"inventoryType":11,"equippable":true,"itemLevel":670,"maxCount":0,"maxDurability":0,"minFactionId":0,"minReputation":0,"quality":3,"sellPrice":167459,"requiredSkill":0,"requiredLevel":100,"requiredSkillRank":0,"itemSource":{"sourceId":82880,"sourceType":"VENDOR"},"baseArmor":0,"hasSockets":false,"isAuctionable":false,"armor":0,"displayInfoId":0,"nameDescription":"Warlords Season 2","nameDescriptionColor":"00ff00","upgradable":true,"heroicTooltip":false,"context":"pvp-unranked","bonusLists":[],"availableContexts":["pvp-unranked"],"bonusSummary":{"defaultBonusLists":[],"chanceBonusLists":[546,608,608],"bonusChances":[{"chanceType":"UPGRADE","upgrade":{"upgradeType":"NAME_DESCRIPTION","name":"Warforged","id":11428},"stats":[{"statId":"ilevel","delta":6},{"statId":"3","delta":9},{"statId":"7","delta":13},{"statId":"32","delta":6},{"statId":"49","delta":5}],"sockets":[]},{"chanceType":"SOCKET","stats":[],"sockets":[{"socketType":"PRISMATIC"},{"socketType":"PRISMATIC"}]}]},"artifactId":0,"header":{"http_code":"HTTP/1.1 200 OK","Content-Language":"en-US","Content-Type":"application/json;charset=UTF-8","Date":"Wed, 16 Nov 2016 19:18:49 GMT","Retry-After":"600","Server":"Apache","Vary":"Accept-Encoding","X-Frame-Options":"SAMEORIGIN","X-Mashery-Responder":"prod-j-worker-us-east-1e-120.mashery.com","X-Plan-QPS-Allotted":"100","X-Plan-QPS-Current":"1","X-Plan-Quota-Allotted":"36000","X-Plan-Quota-Current":"1888","X-Plan-Quota-Reset":"Wednesday, November 16, 2016 8:00:00 PM GMT","Content-Length":"1386","Connection":"Close"},"http_code":200,"last_url":"https://us.api.battle.net/wow/item/124899?id=124899&apikey=hmtxw3wkj7h4hku972fd37ms299ne6vv&locale=en_US"}');

so this table is supposed to have indexes but they dont export? odd...

item_id context bl and locale are supposed to be the factors if the item exists or not.item_id and locale are required but bl and context can be blank

so i have the an item in the database and i query it say 124899, enUS so i have one of these in there but what if i had 2,

and a bl was set of 517 and a context of 88

so i query to see if the basic item is there item_id = 124899 locale = enUS it returns 2 matches not the basic item

also with inserting the items say i have the modified item in the database but i want to add the basic it queries to see if item_id = 124899 locale = enUS exists and gets a yes when it should get a no..

no any ideas?

November 13, 2016

sorry its late here

i added some data to my table

i made a request for an item with context and bl populated

then made a request for an item with context and bl empty and received the info for the row with the fields populated.

my only workarround was to make sure all fields are listed in the request.

November 13, 2016

ty

ive done so and when querying for one of the items that should have multiple if the other fields are omitted it returns one with the unique fields filled instead of empty..

seems i need to always query full fields ...

November 13, 2016

so i have a table with several fields

id | idx | context | bl | bonus | name

so what i have is `id` is the primary AI field for the table, But here is my issue i need the remaining columns to be unique BUT based on each other so i could have data like

'1', '18457', '', '', '6','some name 1'

'2', '18457', 'ct1', '', '6','some name 1'

'3', '18457', '', '45,67,415', '7','some name 1'

so rite now i cant do this but the same idx can appear more then once but only if the other fields are different .. is this possible?

July 26, 2015

$q->answers is in json format you need to decode it as well in order for php to use it

June 4, 2015

sendmail is the default daemon for php on windows and unix based systems i recomend using it...

June 3, 2015

foreach($items as $i => $item){
$a=$item['cid'];
}

this should work -> is used in objects not arrays ususaly

June 1, 2015

i would make sure $SQL->query is returning a array which its probably not you can use print_r($announcements); to see if it is .. i think you will find that its returning a resources not an array

May 7, 2015

node js is an awesome thing for chat systems i developed a facebook like chat application for it at one time messages are instant and you have the client js do the work the server just stores and relays the message

April 27, 2015

http://php.net/manual/en/function.array-diff.php

April 26, 2015

you would place that code in a file for ajax to call to

then run a ajax command to fetch the contents of the file

then use jquery to empty a master div then its the same div's contents to what you fetched

April 23, 2015

add the 'tag' => $_GET['tag'] in the array with the page number

$this->url($this->route, array('page' => $page, 'tag' => $_GET['tag'] )

Posted April 20, 2015 · April 20, 2015

if the user is logged int o your site there must be a session or cookie for the use that you can call on on any page to get there info and then run an update query but you would also need your payment system to post that info back to you if not unless it open in a new window then closes. there should be a confirm or purchases summary page that you can edit ...

April 19, 2015

urls and directory listings always use / not \

\cms\site\');

the \ before the ' escapes it so the script will not read it change the \ in the path to / and you should be fine ...

Posted April 19, 2015 · April 19, 2015

at this point im still not fallowing if you can get the email to show isant that what you want? what needs to update based on the users email?

Posted April 18, 2015 · April 18, 2015

can we see the code for the update query...

Posted April 18, 2015 · April 18, 2015

can you post more code where you are having the issue ... also try setting $_SESSION['user_email'] = $users->email; on the page where you can get the email to display

Posted April 18, 2015 · April 18, 2015

remember you need to fallow the same query style all the time so if you have something like

$userQuery->execute(['user_id' => $_SESSION['user_id']]);

for the update you have to add the email the same way

$userQuery->execute(['user_id' => $_SESSION['user_id'], 'user_email' => 'user@user.com']);

and use the :user_email in your query

April 16, 2015

how is the date stored in your database? is it already formatted? if so try

date("jS F h:i A", strtotime($date));

April 16, 2015

have you tryed dumping the post array to see if there are values in them when the page sends the info to it? var_dump($_POST); would show it.

April 13, 2015

you would need to use a while statement to list the data (if multiple rows) but we would need more info to help you like how its stored in the database (schema) and what type of mysql connection you are using

April 13, 2015

hard to help the main guts of the plugin are hidden as the filter widget_jobify_blog_posts makes the query and you would need to edit that function in the plugin

April 13, 2015

ok i have this function i wrote for you should work ....

/*	create thumb
*
*	@$path	path to the origional image
*	@$src	sorce image to resize
*	@$name	the name with out extention
*	@$ext	the extention
*	@$w	(default null) set the new width no required
*	@$h	(default null) set the new height not required
*	!!! $width or $hight one must be set
*/
function _createThumb($path, $src, $name, $ext, $w=null, $h=null)
	{
		$mime = getimagesize($src);

		switch($mime['mime'])
		{
			case 'image/png':
				$src_img = imagecreatefrompng($src);
			break;
			case 'image/jpg':
				$src_img = imagecreatefromjpeg($src);
			break;
			case 'image/jpeg':
				$src_img = imagecreatefromjpeg($src);
			break;
			case 'image/pjpeg':
				$src_img = imagecreatefromjpeg($src);
			break;
			default : return "Unsupported picture type!"; break;
		}
		
		$width = imageSX($src_img);
		$height = imageSY($src_img);
		
		if (isset($w) && !isset($h))
		{
			$ratio = $width/$w;
		}
		elseif(!isset($w) && isset($h))
		{
			$ratio = $height/$h;
		}
		else
		{
			$ratio = '1';
		}
		// allways make sure ratio is 1 or more less is bad
		if ($ratio < 1){$ratio = 1;}
		
		$nwidth = floor($width/$ratio);
		$nheight = floor($height/$ratio);
		
		$dst_img        =   ImageCreateTrueColor($nwidth,$nheight);

		imagecopyresampled($dst_img,$src_img,0,0,0,0,$nwidth,$nheight,$width,$height);
		
		$new_thumb_loc = $path.$name.'-thumbnail.'.$ext;

		if($mime['mime']=='image/png'){ $result = imagepng($dst_img,$new_thumb_loc,; }
		if($mime['mime']=='image/jpg'){ $result = imagejpeg($dst_img,$new_thumb_loc,80); }
		if($mime['mime']=='image/jpeg'){ $result = imagejpeg($dst_img,$new_thumb_loc,80); }
		if($mime['mime']=='image/pjpeg'){ $result = imagejpeg($dst_img,$new_thumb_loc,80); }

		imagedestroy($dst_img);
		imagedestroy($src_img);
		return true;
	}

then use it like this notice the changes in your script

$image_name = time().substr(str_replace(" ", "_", $ext), 5);
$actual_image_name = $image_name.".".$ext;
$tmp = $_FILES['photoimg']['tmp_name'];
if(move_uploaded_file($tmp, $path.$actual_image_name))
	{
	mysqli_query($db,"INSERT INTO `media` (title, description, image) VALUES ('$imgtitle', '$imgdesc', '$actual_image_name')");
		//	create thumb
		_createThumb($path, $path.$actual_image_name, $image_name, $ext, '400', null);
		// end thumb
		header('Location: media.php');
	}

February 24, 2015

one could change

 foreach($respon['HotelInformationResponse']['HotelImages']['HotelImage'] as $img)

to

 foreach($respon['HotelInformationResponse']['HotelImages']['HotelImage'] as $index => $img)

and it "should" work. as long as there is data in the $img array

Sign In

blacknight

Posts

Joined

Last visited

Content Type

Profiles

Forums

Posts posted by blacknight

Mysql rows with unique keys help

Mysql rows with unique keys help

Mysql rows with unique keys help

Mysql rows with unique keys help

Mysql rows with unique keys help

Get and parse data from MySQL

php mail function can't send email

PHP Parse Array

Warning: Invalid argument supplied for foreach()

AJAX and PHP chat application?

Array compare

AJAX mysql query update every 3 seconds

Pagination with Tags - HELP

How to update users in the DB by their email

Testing on WAMP

How to update users in the DB by their email

How to update users in the DB by their email

How to update users in the DB by their email

How to update users in the DB by their email

Is there a way to format the date output of a function?

PHP Form is sending blank emails

Help me for php

Wordpress widget - How to display one post category rather than all

PHP - Upload image, store it, add mysql entry + create thumbnail.

illegal string offset php error

Browse

Activity

Important Information