blacknight Posted November 13, 2016 Share Posted 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? Quote Link to comment Share on other sites More sharing options...
Jacques1 Posted November 13, 2016 Share Posted November 13, 2016 A uniqueness constraint can span more than one column, if that's what you mean. CREATE TABLE ... ( ... UNIQUE (col_1, col_2, ..., col_n) ); Then only the combinations of the columns have to be unique, not an individual column. Quote Link to comment Share on other sites More sharing options...
blacknight Posted November 13, 2016 Author Share Posted 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 ... Quote Link to comment Share on other sites More sharing options...
Jacques1 Posted November 13, 2016 Share Posted November 13, 2016 I have no idea what you've just said. Quote Link to comment Share on other sites More sharing options...
blacknight Posted November 13, 2016 Author Share Posted 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. Quote Link to comment Share on other sites More sharing options...
kicken Posted November 14, 2016 Share Posted November 14, 2016 It'd probably help if you provided queries, table definitions and sample data. It's not clear what you're attempting to do or trying to ask. Provide your CREATE TABLE statement, some sample data, and your SELECT queries along with your expected results. Quote Link to comment Share on other sites More sharing options...
blacknight Posted November 16, 2016 Author Share Posted 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? Quote Link to comment Share on other sites More sharing options...
kicken Posted November 16, 2016 Share Posted November 16, 2016 If you care what the values of bl and context are, which it sounds like you do, then you need to query against them. It sounds like you're defining a "basic item" to be an item that exists where those two fields are blank. As such if you want to query for basic items you need to use the conditions WHERE item_id=? AND locale=? AND context='' AND bl='' If my understanding is incorrect then maybe try expanding on what the idea behind the table/data is and how things are represented (ie, what exactly makes something a "basic item" vs other types of items). P.S. bl is not a very descriptive name, I'd consider changing it. Quote Link to comment Share on other sites More sharing options...
blacknight Posted November 17, 2016 Author Share Posted 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.