Jump to content

Mysql rows with unique keys help

blacknight

By blacknight
in MySQL Help

 Share

Recommended Posts

blacknight Member

blacknight

Posted
Posted

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?
 
Link to comment
https://forums.phpfreaks.com/topic/302527-mysql-rows-with-unique-keys-help/
Share on other sites
blacknight Member

blacknight

Posted
  • Author
Posted

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

blacknight Member

blacknight

Posted
  • Author
Posted

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.

kicken Prolific Member

kicken

Posted
Posted

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.

blacknight Member

blacknight

Posted
  • Author
Posted

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?

kicken Prolific Member

kicken

Posted
Posted

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.

blacknight Member

blacknight

Posted
  • Author
Posted

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

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.