blacknight

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

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?

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.

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 ...

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?

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

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