landsandboat/sql/guild_item_points.sql

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for guild_item_points
-- ----------------------------
DROP TABLE IF EXISTS `guild_item_points`;
CREATE TABLE `guild_item_points` (
  `guildid` tinyint(1) unsigned NOT NULL,
  `itemid` smallint(5) unsigned NOT NULL,
  `rank` smallint(1) unsigned NOT NULL,
  `points` smallint(5) unsigned NOT NULL DEFAULT '0',
  `max_points` smallint(5) unsigned NOT NULL DEFAULT '0',
  `pattern` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`guildid`,`itemid`,`pattern`)
) ENGINE=Aria TRANSACTIONAL=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records
-- ----------------------------

-- Fishing / Amateur
INSERT INTO `guild_item_points` VALUES (0,4360,0,24,3600,0); -- Bastore Sardine (24 / 3600)
INSERT INTO `guild_item_points` VALUES (0,4472,0,30,3840,1); -- Crayfish (30 / 3840)
INSERT INTO `guild_item_points` VALUES (0,4360,0,24,3600,2); -- Bastore Sardine (24 / 3600)
INSERT INTO `guild_item_points` VALUES (0,4401,0,30,3840,3); -- Moat Carp (30 / 3840)
INSERT INTO `guild_item_points` VALUES (0,4472,0,30,3840,4); -- Crayfish (30 / 3840)
INSERT INTO `guild_item_points` VALUES (0,4314,0,300,7680,5); -- Bibikibo (300 / 7680)
INSERT INTO `guild_item_points` VALUES (0,4401,0,30,3840,6); -- Moat Carp (30 / 3840)
INSERT INTO `guild_item_points` VALUES (0,4443,0,24,3600,7); -- Cobalt Jellyfish (24 / 3600)

-- Fishing / Recruit
INSERT INTO `guild_item_points` VALUES (0,4515,1,60,5040,0); -- Copper Frog (60 / 5040)
INSERT INTO `guild_item_points` VALUES (0,4289,1,45,4800,1); -- Forest Carp (45 / 4800)
INSERT INTO `guild_item_points` VALUES (0,4514,1,60,5040,2); -- Quus (60 / 5040)
INSERT INTO `guild_item_points` VALUES (0,4379,1,60,5040,3); -- Cheval Salmon (60 / 5040)
INSERT INTO `guild_item_points` VALUES (0,5473,1,279,7920,4); -- Bastore Sweeper (279 / 7920)
INSERT INTO `guild_item_points` VALUES (0,5473,1,279,7920,5); -- Bastore Sweeper (279 / 7920)
INSERT INTO `guild_item_points` VALUES (0,4313,1,675,11280,6); -- Blindfish (675 / 11280)
INSERT INTO `guild_item_points` VALUES (0,4403,1,60,5040,7); -- Yellow Globe (60 / 5040)

-- Fishing / Initiate
INSERT INTO `guild_item_points` VALUES (0,4464,2,138,6720,0); -- Pipira (138 / 6720)
INSERT INTO `guild_item_points` VALUES (0,4469,2,300,8640,1); -- Giant Catfish (300 / 8640)
INSERT INTO `guild_item_points` VALUES (0,4361,2,156,6960,2); -- Nebimonite (156 / 6960)
INSERT INTO `guild_item_points` VALUES (0,4426,2,156,6960,3); -- Tricolored Carp (156 / 6960)
INSERT INTO `guild_item_points` VALUES (0,4315,2,720,12000,4); -- Lungfish (720 / 12000)
INSERT INTO `guild_item_points` VALUES (0,5121,2,714,12000,5); -- Moorish Idol (714 / 12000)
INSERT INTO `guild_item_points` VALUES (0,4290,2,156,6960,6); -- Elshimo Frog (156 / 6960)
INSERT INTO `guild_item_points` VALUES (0,4483,2,156,6960,7); -- Tiger Cod (156 / 6960)

-- Fishing / Novice
INSERT INTO `guild_item_points` VALUES (0,4354,3,78,6720,0); -- Shining Trout (78 / 6720)
INSERT INTO `guild_item_points` VALUES (0,4528,3,375,9840,1); -- Crystal Bass (375 / 9840)
INSERT INTO `guild_item_points` VALUES (0,4482,3,240,8640,2); -- Nosteau Herring (240 / 8640)
INSERT INTO `guild_item_points` VALUES (0,5141,3,1350,15120,3); -- Veydal Wrasse (1350 / 15120)
INSERT INTO `guild_item_points` VALUES (0,4480,3,300,9120,4); -- Gugru Tuna (300 / 9120)
INSERT INTO `guild_item_points` VALUES (0,4580,3,375,9840,5); -- Coral Butterfly (375 / 9840)
INSERT INTO `guild_item_points` VALUES (0,4354,3,78,6720,6); -- Shining Trout (78 / 6720)
INSERT INTO `guild_item_points` VALUES (0,4481,3,96,6960,7); -- Ogre Eel (96 / 6960)

-- Fishing / Apprentice
INSERT INTO `guild_item_points` VALUES (0,4462,4,900,13440,0); -- Monke-Onke (900 / 13440)
INSERT INTO `guild_item_points` VALUES (0,4306,4,576,11760,1); -- Giant Donko (576 / 11760)
INSERT INTO `guild_item_points` VALUES (0,4383,4,576,11760,2); -- Gold Lobster (576 / 11760)
INSERT INTO `guild_item_points` VALUES (0,4470,4,459,10800,3); -- Icefish (459 / 10800)
INSERT INTO `guild_item_points` VALUES (0,4385,4,93,7440,4); -- Zafmlug Bass (93 / 7440)
INSERT INTO `guild_item_points` VALUES (0,4383,4,576,11760,5); -- Gold Lobster (576 / 11760)
INSERT INTO `guild_item_points` VALUES (0,4429,4,576,11760,6); -- Black Eel (576 / 11760)
INSERT INTO `guild_item_points` VALUES (0,4385,4,93,7440,7); -- Zafmlug Bass (93 / 7440)

-- Fishing / Journeyman
INSERT INTO `guild_item_points` VALUES (0,4427,5,900,13680,0); -- Gold Carp (900 / 13680)
INSERT INTO `guild_item_points` VALUES (0,4579,5,525,11760,1); -- Elshimo Newt (525 / 11760)
INSERT INTO `guild_item_points` VALUES (0,4479,5,900,13680,2); -- Bhefhel Marlin (900 / 13680)
INSERT INTO `guild_item_points` VALUES (0,4402,5,900,13680,3); -- Red Terrapin (900 / 13680)
INSERT INTO `guild_item_points` VALUES (0,4399,5,900,13680,4); -- Bluetail (900 / 13680)
INSERT INTO `guild_item_points` VALUES (0,4479,5,900,13680,5); -- Bhefhel Marlin (900 / 13680)
INSERT INTO `guild_item_points` VALUES (0,4317,5,120,8400,6); -- Trilobite (120 / 8400)
INSERT INTO `guild_item_points` VALUES (0,4399,5,900,13680,7); -- Bluetail (900 / 13680)

-- Fishing / Craftsman
INSERT INTO `guild_item_points` VALUES (0,4473,6,1320,15360,0); -- Crescent Fish (1320 / 15360)
INSERT INTO `guild_item_points` VALUES (0,4473,6,1320,15360,1); -- Crescent Fish (1320 / 15360)
INSERT INTO `guild_item_points` VALUES (0,5466,6,1536,16080,2); -- Trumpet Shell (1536 / 16080)
INSERT INTO `guild_item_points` VALUES (0,4288,6,1200,15120,3); -- Zebra Eel (1200 / 15120)
INSERT INTO `guild_item_points` VALUES (0,4471,6,1200,15120,4); -- Bladefish (1200 / 15120)
INSERT INTO `guild_item_points` VALUES (0,4288,6,1200,15120,5); -- Zebra Eel (1200 / 15120)
INSERT INTO `guild_item_points` VALUES (0,4473,6,1320,15360,6); -- Crescent Fish (1320 / 15360)
INSERT INTO `guild_item_points` VALUES (0,4485,6,1200,15120,7); -- Noble Lady (1200 / 15120)

-- Fishing / Artisan
INSERT INTO `guild_item_points` VALUES (0,4477,7,1500,16080,0); -- Gavial Fish (1500 / 16080)
INSERT INTO `guild_item_points` VALUES (0,4307,7,1800,16800,1); -- Jungle Catfish (1800 / 16800)
INSERT INTO `guild_item_points` VALUES (0,4478,7,1500,16080,2); -- Three-eyed Fish (1500 / 16080)
INSERT INTO `guild_item_points` VALUES (0,4307,7,1800,16800,3); -- Jungle Catfish (1800 / 16800)
INSERT INTO `guild_item_points` VALUES (0,4451,7,1500,16080,4); -- Silver Shark (1500 / 16080)
INSERT INTO `guild_item_points` VALUES (0,4478,7,1500,16080,5); -- Three-eyed Fish (1500 / 16080)
INSERT INTO `guild_item_points` VALUES (0,4477,7,1500,16080,6); -- Gavial Fish (1500 / 16080)
INSERT INTO `guild_item_points` VALUES (0,4451,7,1500,16080,7); -- Silver Shark (1500 / 16080)

-- Fishing / Adept
INSERT INTO `guild_item_points` VALUES (0,4454,8,1800,17040,0); -- Emperor Fish (1800 / 17040)
INSERT INTO `guild_item_points` VALUES (0,4454,8,1800,17040,1); -- Emperor Fish (1800 / 17040)
INSERT INTO `guild_item_points` VALUES (0,4461,8,1800,17040,2); -- Bastore Bream (1800 / 17040)
INSERT INTO `guild_item_points` VALUES (0,4304,8,2100,17520,3); -- Grimmonite (2100 / 17520)
INSERT INTO `guild_item_points` VALUES (0,4474,8,1800,17040,4); -- Gigant Squid (1800 / 17040)
INSERT INTO `guild_item_points` VALUES (0,4304,8,2100,17520,5); -- Grimmonite (2100 / 17520)
INSERT INTO `guild_item_points` VALUES (0,4474,8,1800,17040,6); -- Gigant Squid (1800 / 17040)
INSERT INTO `guild_item_points` VALUES (0,4304,8,2100,17520,7); -- Grimmonite (2100 / 17520)

-- Fishing / Veteran
INSERT INTO `guild_item_points` VALUES (0,4475,9,2100,17520,0); -- Sea Zombie (2100 / 17520)
INSERT INTO `guild_item_points` VALUES (0,4476,9,2100,17520,1); -- Titanictus (2100 / 17520)
INSERT INTO `guild_item_points` VALUES (0,4475,9,2100,17520,2); -- Sea Zombie (2100 / 17520)
INSERT INTO `guild_item_points` VALUES (0,4316,9,2850,18720,3); -- Armored Pisces (2850 / 18720)
INSERT INTO `guild_item_points` VALUES (0,4476,9,2100,17520,4); -- Titanictus (2100 / 17520)
INSERT INTO `guild_item_points` VALUES (0,4463,9,2100,17520,5); -- Takitaro (2100 / 17520)
INSERT INTO `guild_item_points` VALUES (0,4463,9,2100,17520,6); -- Takitaro (2100 / 17520)
INSERT INTO `guild_item_points` VALUES (0,4384,9,2100,17520,7); -- Black Sole (2100 / 17520)

-- Woodworking / Amateur
INSERT INTO `guild_item_points` VALUES (1,17095,0,105,5040,0); -- Ash Pole (105 / 5040)
INSERT INTO `guild_item_points` VALUES (1,17122,0,120,5040,0); -- Ash Pole +1 (120 / 5040)
INSERT INTO `guild_item_points` VALUES (1,17868,0,52,4080,1); -- Humus (52 / 4080)
INSERT INTO `guild_item_points` VALUES (1,17869,0,97,4080,1); -- Rich Humus (97 / 4080)
INSERT INTO `guild_item_points` VALUES (1,22,0,94,4800,2); -- Workbench (94 / 4800)
INSERT INTO `guild_item_points` VALUES (1,22,0,94,4800,3); -- Workbench (94 / 4800)
INSERT INTO `guild_item_points` VALUES (1,12289,0,30,3840,4); -- Lauan Shield (30 / 3840)
INSERT INTO `guild_item_points` VALUES (1,12333,0,38,3840,4); -- Lauan Shield +1 (38 / 3840)
INSERT INTO `guild_item_points` VALUES (1,16832,0,27,3840,5); -- Harpoon (27 / 3840)
INSERT INTO `guild_item_points` VALUES (1,16862,0,30,3840,5); -- Harpoon +1 (30 / 3840)
INSERT INTO `guild_item_points` VALUES (1,12289,0,30,3840,6); -- Lauan Shield (30 / 3840)
INSERT INTO `guild_item_points` VALUES (1,12333,0,38,3840,6); -- Lauan Shield +1 (38 / 3840)
INSERT INTO `guild_item_points` VALUES (1,17868,0,52,4080,7); -- Humus (52 / 4080)
INSERT INTO `guild_item_points` VALUES (1,17869,0,97,4080,7); -- Rich Humus (97 / 4080)

-- Woodworking / Recruit
INSERT INTO `guild_item_points` VALUES (1,17153,1,134,6240,0); -- Self Bow (134 / 6240)
INSERT INTO `guild_item_points` VALUES (1,17176,1,154,6240,0); -- Self Bow +1 (154 / 6240)
INSERT INTO `guild_item_points` VALUES (1,12985,1,325,8400,1); -- Holly Clogs (325 / 8400)
INSERT INTO `guild_item_points` VALUES (1,12991,1,406,8400,1); -- Holly Clogs +1 (406 / 8400)
INSERT INTO `guild_item_points` VALUES (1,17389,1,135,6240,2); -- Bamboo Fishing Rod (135 / 6240)
INSERT INTO `guild_item_points` VALUES (1,23,1,158,6480,3); -- Maple Table (158 / 6480)
INSERT INTO `guild_item_points` VALUES (1,17050,1,74,5280,4); -- Willow Wand (74 / 5280)
INSERT INTO `guild_item_points` VALUES (1,17138,1,119,5280,4); -- Willow Wand +1 (119 / 5280)
INSERT INTO `guild_item_points` VALUES (1,17216,1,45,4800,5); -- Light Crossbow (45 / 4800)
INSERT INTO `guild_item_points` VALUES (1,17228,1,53,4800,5); -- Light Crossbow +1 (53 / 4800)
INSERT INTO `guild_item_points` VALUES (1,17096,1,423,9360,6); -- Holly Pole (423 / 9360)
INSERT INTO `guild_item_points` VALUES (1,17124,1,435,9360,6); -- Holly Pole +1 (435 / 9360)
INSERT INTO `guild_item_points` VALUES (1,12290,1,121,6000,7); -- Maple Shield  (121 / 6000)
INSERT INTO `guild_item_points` VALUES (1,12330,1,152,6000,7); -- Maple Shield +1 (152 / 6000)

-- Woodworking / Initiate
INSERT INTO `guild_item_points` VALUES (1,17051,2,261,8160,0); -- Yew Wand (261 / 8160)
INSERT INTO `guild_item_points` VALUES (1,17140,2,414,8160,0); -- Yew Wand +1 (414 / 8160)
INSERT INTO `guild_item_points` VALUES (1,1179,2,25,5280,1); -- Shihei (25 / 5280)
INSERT INTO `guild_item_points` VALUES (1,92,2,246,8160,2); -- Tarutaru Stool (246 / 8160)
INSERT INTO `guild_item_points` VALUES (1,17354,2,500,10320,3); -- Harp (500 / 10320)
INSERT INTO `guild_item_points` VALUES (1,17374,2,600,10320,3); -- Harp +1 (600 / 10320)
INSERT INTO `guild_item_points` VALUES (1,16834,2,400,9600,4); -- Brass Spear (400 / 9600)
INSERT INTO `guild_item_points` VALUES (1,16864,2,410,9600,4); -- Brass Spear +1 (410 / 9600)
INSERT INTO `guild_item_points` VALUES (1,12291,2,363,9360,5); -- Elm Shield (363 / 9360)
INSERT INTO `guild_item_points` VALUES (1,12319,2,457,9360,5); -- Elm Shield +1 (457 / 9360)
INSERT INTO `guild_item_points` VALUES (1,17090,2,601,11040,6); -- Elm Staff (601 / 11040)
INSERT INTO `guild_item_points` VALUES (1,17126,2,887,11040,6); -- Elm Staff +1 (887 / 11040)
INSERT INTO `guild_item_points` VALUES (1,17025,2,290,8640,7); -- Chestnut Club (290 / 8640)
INSERT INTO `guild_item_points` VALUES (1,17139,2,447,8640,7); -- Solid Club (447 / 8640)

-- Woodworking / Novice
INSERT INTO `guild_item_points` VALUES (1,17217,3,471,10560,0); -- Crossbow (471 / 10560)
INSERT INTO `guild_item_points` VALUES (1,17225,3,471,10560,0); -- Crossbow +1 (471 / 10560)
INSERT INTO `guild_item_points` VALUES (1,17155,3,1250,14640,1); -- Composite Bow (1250 / 14640)
INSERT INTO `guild_item_points` VALUES (1,17179,3,1300,14640,1); -- Composite Bow +1 (1300 / 14640)
INSERT INTO `guild_item_points` VALUES (1,17162,3,3116,18720,2); -- Great Bow (3116 / 18720)
INSERT INTO `guild_item_points` VALUES (1,17180,3,3496,18720,2); -- Great Bow  +1 (3496 / 18720)
INSERT INTO `guild_item_points` VALUES (1,17424,3,300,9120,3); -- Spiked Club (300 / 9120)
INSERT INTO `guild_item_points` VALUES (1,17425,3,330,9120,3); -- Spiked Club +1 (330 / 9120)
INSERT INTO `guild_item_points` VALUES (1,12986,3,612,11520,4); -- Chestnut Sabots (612 / 11520)
INSERT INTO `guild_item_points` VALUES (1,13022,3,646,11520,4); -- Chestnut Sabots +1 (646 / 11520)
INSERT INTO `guild_item_points` VALUES (1,17052,3,714,12240,5); -- Chestnut Wand (714 / 12240)
INSERT INTO `guild_item_points` VALUES (1,17141,3,1134,12240,5); -- Solid Wand (1134 / 12240)
INSERT INTO `guild_item_points` VALUES (1,12292,3,830,12960,6); -- Mahogany Shield (830 / 12960)
INSERT INTO `guild_item_points` VALUES (1,12334,3,1043,12960,6); -- Strong Shield (1043 / 12960)
INSERT INTO `guild_item_points` VALUES (1,16835,3,840,12960,7); -- Spear (840 / 12960)
INSERT INTO `guild_item_points` VALUES (1,16865,3,870,12960,7); -- Spear +1 (870 / 12960)

-- Woodworking / Apprentice
INSERT INTO `guild_item_points` VALUES (1,12987,4,1344,15120,0); -- Ebony Sabots (1344 / 15120)
INSERT INTO `guild_item_points` VALUES (1,13023,4,1400,15120,0); -- Ebony Sabots +1 (1400 / 15120)
INSERT INTO `guild_item_points` VALUES (1,17091,4,1218,14880,1); -- Oak Staff (1218 / 14880)
INSERT INTO `guild_item_points` VALUES (1,17127,4,1798,14880,1); -- Oak Staff +1 (1798 / 14880)
INSERT INTO `guild_item_points` VALUES (1,16845,4,1535,15840,2); -- Lance (1535 / 15840)
INSERT INTO `guild_item_points` VALUES (1,16876,4,1561,15840,2); -- Lance +1 (1561 / 15840)
INSERT INTO `guild_item_points` VALUES (1,17218,4,1710,16320,3); -- Zamburak (1710 / 16320)
INSERT INTO `guild_item_points` VALUES (1,17229,4,1748,16320,3); -- Zamburak +1 (1748 / 16320)
INSERT INTO `guild_item_points` VALUES (1,17027,4,1248,14880,4); -- Oak Cudgel (1248 / 14880)
INSERT INTO `guild_item_points` VALUES (1,17142,4,1768,14880,4); -- Oak Cudgel +1 (1768 / 14880)
INSERT INTO `guild_item_points` VALUES (1,16836,4,1350,15120,5); -- Halberd (1350 / 15120)
INSERT INTO `guild_item_points` VALUES (1,16866,4,1400,15120,5); -- Halberd +1 (1400 / 15120)
INSERT INTO `guild_item_points` VALUES (1,17053,4,1360,15360,6); -- Rose Wand (1360 / 15360)
INSERT INTO `guild_item_points` VALUES (1,17143,4,2160,15360,6); -- Rose Wand +1 (2160 / 15360)
INSERT INTO `guild_item_points` VALUES (1,12293,4,1950,16800,7); -- Oak Shield (1950 / 16800)
INSERT INTO `guild_item_points` VALUES (1,12331,4,2450,16800,7); -- Oak Shield +1 (2450 / 16800)

-- Woodworking / Journeyman
INSERT INTO `guild_item_points` VALUES (1,17355,5,2500,18000,0); -- Rose Harp (2500 / 18000)
INSERT INTO `guild_item_points` VALUES (1,17376,5,3000,18000,0); -- Rose Harp +1 (3000 / 18000)
INSERT INTO `guild_item_points` VALUES (1,17030,5,1102,14640,1); -- Great Club (1102 / 14640)
INSERT INTO `guild_item_points` VALUES (1,17408,5,1160,14640,1); -- Great Club +1 (1160 / 14640)
INSERT INTO `guild_item_points` VALUES (1,16847,5,2580,18000,2); -- Mythril Lance (2580 / 18000)
INSERT INTO `guild_item_points` VALUES (1,16877,5,2640,18000,2); -- Mythril Lance +1 (2640 / 18000)
INSERT INTO `guild_item_points` VALUES (1,17219,5,2550,18000,3); -- Arbalest (2550 / 18000)
INSERT INTO `guild_item_points` VALUES (1,17226,5,2625,18000,3); -- Arbalest +1 (2625 / 18000)
INSERT INTO `guild_item_points` VALUES (1,16871,5,4070,19686,4); -- Kamayari (4070 / 19686)
INSERT INTO `guild_item_points` VALUES (1,16872,5,4162,19686,4); -- Kamayari +1 (4162 / 19686)
INSERT INTO `guild_item_points` VALUES (1,17164,5,4080,19680,5); -- War Bow (4080 / 19680)
INSERT INTO `guild_item_points` VALUES (1,17173,5,4160,19680,5); -- War Bow +1 (4160 / 19680)
INSERT INTO `guild_item_points` VALUES (1,17098,5,1560,16080,6); -- Oak Pole (1560 / 16080)
INSERT INTO `guild_item_points` VALUES (1,17120,5,1620,16080,6); -- Oak Pole +1 (1620 / 16080)
INSERT INTO `guild_item_points` VALUES (1,17156,5,2465,18000,7); -- Kaman (2465 / 18000)
INSERT INTO `guild_item_points` VALUES (1,17182,5,2550,18000,7); -- Kaman +1 (2550 / 18000)

-- Woodworking / Craftsman
INSERT INTO `guild_item_points` VALUES (1,49,6,1278,15360,0); -- Coffer (1278 / 15360)
INSERT INTO `guild_item_points` VALUES (1,17157,6,3655,19440,1); -- Rapid Bow (3655 / 19440)
INSERT INTO `guild_item_points` VALUES (1,17189,6,3762,19440,1); -- Rapid Bow +1 (3762 / 19440)
INSERT INTO `guild_item_points` VALUES (1,17054,6,1912,17040,2); -- Ebony Wand (1912 / 17040)
INSERT INTO `guild_item_points` VALUES (1,17427,6,3037,17040,2); -- Ebony Wand +1 (3037 / 17040)
INSERT INTO `guild_item_points` VALUES (1,16839,6,2415,18000,3); -- Partisan (2415 / 18000)
INSERT INTO `guild_item_points` VALUES (1,16874,6,2520,18000,3); -- Partisan +1 (2520 / 18000)
INSERT INTO `guild_item_points` VALUES (1,51,6,195,9600,4); -- Chest (195 / 9600)
INSERT INTO `guild_item_points` VALUES (1,17092,6,2310,17760,5); -- Mahogany Staff (2310 / 17760)
INSERT INTO `guild_item_points` VALUES (1,17520,6,2310,17760,5); -- Heavy Staff (2310 / 17760)
INSERT INTO `guild_item_points` VALUES (1,17350,6,1200,15120,6); -- Angel's Flute (1200 / 15120)
INSERT INTO `guild_item_points` VALUES (1,17378,6,1280,15120,6); -- Angel's Flute +1 (1280 / 15120)
INSERT INTO `guild_item_points` VALUES (1,17099,6,7200,21600,7); -- Mahogany Pole (7200 / 21600)
INSERT INTO `guild_item_points` VALUES (1,17521,6,7700,21600,7); -- Mahogany Pole +1 (7700 / 21600)

-- Woodworking / Artisan
INSERT INTO `guild_item_points` VALUES (1,56,7,4900,20400,0); -- Commode (4900 / 20400)
INSERT INTO `guild_item_points` VALUES (1,12295,7,2817,18480,1); -- Round Shield (2817 / 18480)
INSERT INTO `guild_item_points` VALUES (1,12352,7,2990,18480,1); -- Round Shield +1 (2990 / 18480)
INSERT INTO `guild_item_points` VALUES (1,95,7,2500,18000,2); -- Water Barrel (2500 / 18000)
INSERT INTO `guild_item_points` VALUES (1,59,7,4594,20160,3); -- Chiffonier (4594 / 20160)
INSERT INTO `guild_item_points` VALUES (1,30,7,7010,21360,4); -- Bureau (7010 / 21360)
INSERT INTO `guild_item_points` VALUES (1,104,7,427,11760,5); -- Tarutaru Folding Screen (427 / 11760)
INSERT INTO `guild_item_points` VALUES (1,17100,7,4350,19920,6); -- Ebony Pole (4350 / 19920)
INSERT INTO `guild_item_points` VALUES (1,17525,7,4495,19920,6); -- Ebony Pole +1 (4495 / 19920)
INSERT INTO `guild_item_points` VALUES (1,18093,7,4826,20400,7); -- Couse (4826 / 20400)
INSERT INTO `guild_item_points` VALUES (1,18094,7,5776,20400,7); -- Couse +1 (5776 / 20400)

-- Woodworking / Adept
INSERT INTO `guild_item_points` VALUES (1,16849,8,2650,18480,0); -- Cermet Lance (2650 / 18480)
INSERT INTO `guild_item_points` VALUES (1,16879,8,3312,18480,0); -- Cermet Lance +1 (3312 / 18480)
INSERT INTO `guild_item_points` VALUES (1,17359,8,7000,21360,1); -- Mythic Harp (7000 / 21360)
INSERT INTO `guild_item_points` VALUES (1,17834,8,7140,21360,1); -- Mythic Harp +1 (7140 / 21360)
INSERT INTO `guild_item_points` VALUES (1,17101,8,4740,20400,2); -- Mythic Pole (4740 / 20400)
INSERT INTO `guild_item_points` VALUES (1,17526,8,5727,20400,2); -- Mythic Pole +1 (5727 / 20400)
INSERT INTO `guild_item_points` VALUES (1,358,8,7070,21360,3); -- Credenza (7070 / 21360)
INSERT INTO `guild_item_points` VALUES (1,17221,8,5425,20640,4); -- Repeating Crossbow (5425 / 20640)
INSERT INTO `guild_item_points` VALUES (1,17233,8,6200,20640,4); -- Machine Crossbow (6200 / 20640)
INSERT INTO `guild_item_points` VALUES (1,12364,8,2560,18240,5); -- Nymph Shield (2560 / 18240)
INSERT INTO `guild_item_points` VALUES (1,12365,8,2760,18240,5); -- Nymph Shield +1 (2760 / 18240)
INSERT INTO `guild_item_points` VALUES (1,61,8,12750,22560,6); -- Armoire (12750 / 22560)
INSERT INTO `guild_item_points` VALUES (1,55,8,3200,18960,7); -- Cabinet (3200 / 18960)

-- Woodworking / Veteran
INSERT INTO `guild_item_points` VALUES (1,16840,9,7950,21600,0); -- Ox Tongue (7950 / 21600)
INSERT INTO `guild_item_points` VALUES (1,16894,9,7950,21600,0); -- Ox Tongue +1 (7950 / 21600)
INSERT INTO `guild_item_points` VALUES (1,17205,9,11305,22320,1); -- Gendawa (11305 / 22320)
INSERT INTO `guild_item_points` VALUES (1,17206,9,12255,22320,1); -- Gendawa +1 (12255 / 22320)
INSERT INTO `guild_item_points` VALUES (1,18142,9,18550,23040,2); -- Shigeto Bow (18550 / 23040)
INSERT INTO `guild_item_points` VALUES (1,18143,9,18550,23040,2); -- Shigeto Bow +1 (18550 / 23040)
INSERT INTO `guild_item_points` VALUES (1,17102,9,1200,15600,3); -- Eight-Sided Pole (1200 / 15600)
INSERT INTO `guild_item_points` VALUES (1,17568,9,1800,15600,3); -- Eight-Sided Pole +1 (1800 / 15600)
INSERT INTO `guild_item_points` VALUES (1,139,9,13430,22560,4); -- Star Globe (13430 / 22560)
INSERT INTO `guild_item_points` VALUES (1,17364,9,5697,20880,5); -- Cythara Anglica (5697 / 20880)
INSERT INTO `guild_item_points` VALUES (1,17837,9,7022,20880,5); -- Cythara Anglica +1 (7022 / 20880)
INSERT INTO `guild_item_points` VALUES (1,76,9,14625,22560,6); -- Royal Bookshelf (14625 / 22560)
INSERT INTO `guild_item_points` VALUES (1,77,9,14600,22560,7); -- Bookshelf (14600 / 22560)

-- Blacksmithing / Amateur
INSERT INTO `guild_item_points` VALUES (2,16390,0,61,4320,0); -- Bronze Knuckles (61 / 4320)
INSERT INTO `guild_item_points` VALUES (2,16440,0,61,4320,0); -- Bronze Knuckles +1 (61 / 4320)
INSERT INTO `guild_item_points` VALUES (2,16535,0,67,4320,1); -- Bronze Sword (67 / 4320)
INSERT INTO `guild_item_points` VALUES (2,16623,0,75,4320,1); -- Bronze Sword +1 (75 / 4320)
INSERT INTO `guild_item_points` VALUES (2,16530,0,168,6000,2); -- Xiphos (168 / 6000)
INSERT INTO `guild_item_points` VALUES (2,16624,0,188,6000,2); -- Xiphos +1 (188 / 6000)
INSERT INTO `guild_item_points` VALUES (2,1021,0,125,5280,3); -- Hatchet (125 / 5280)
INSERT INTO `guild_item_points` VALUES (2,16768,0,86,4800,4); -- Bronze Zaghnal (86 / 4800)
INSERT INTO `guild_item_points` VALUES (2,16778,0,93,4800,4); -- Bronze Zaghnal +1 (93 / 4800)
INSERT INTO `guild_item_points` VALUES (2,12432,0,290,7440,5); -- Faceguard (290 / 7440)
INSERT INTO `guild_item_points` VALUES (2,12487,0,342,7440,5); -- Faceguard +1 (342 / 7440)
INSERT INTO `guild_item_points` VALUES (2,17034,0,47,4080,6); -- Bronze Mace (47 / 4080)
INSERT INTO `guild_item_points` VALUES (2,17086,0,57,4080,6); -- Bronze Mace +1 (57 / 4080)
INSERT INTO `guild_item_points` VALUES (2,16640,0,79,4560,7); -- Bronze Axe (79 / 4560)
INSERT INTO `guild_item_points` VALUES (2,16646,0,86,4560,7); -- Bronze Axe +1 (86 / 4560)

-- Blacksmithing / Recruit
INSERT INTO `guild_item_points` VALUES (2,12816,1,358,8640,0); -- Scale Cuisses (358 / 8640)
INSERT INTO `guild_item_points` VALUES (2,12863,1,410,8640,0); -- Solid Cuisses (410 / 8640)
INSERT INTO `guild_item_points` VALUES (2,12944,1,217,7200,1); -- Scale Greaves (217 / 7200)
INSERT INTO `guild_item_points` VALUES (2,13024,1,269,7200,1); -- Solid Greaves (269 / 7200)
INSERT INTO `guild_item_points` VALUES (2,12299,1,189,6960,2); -- Aspis (189 / 6960)
INSERT INTO `guild_item_points` VALUES (2,12325,1,233,6960,2); -- Aspis +1 (233 / 6960)
INSERT INTO `guild_item_points` VALUES (2,17042,1,85,5520,3); -- Bronze Hammer (85 / 5520)
INSERT INTO `guild_item_points` VALUES (2,17144,1,100,5520,3); -- Bronze Hammer +1 (100 / 5520)
INSERT INTO `guild_item_points` VALUES (2,16450,1,406,9120,4); -- Dagger (406 / 9120)
INSERT INTO `guild_item_points` VALUES (2,16736,1,484,9120,4); -- Dagger +1 (484 / 9120)
INSERT INTO `guild_item_points` VALUES (2,12560,1,446,9600,5); -- Scale Mail (446 / 9600)
INSERT INTO `guild_item_points` VALUES (2,12661,1,498,9600,5); -- Solid Mail (498 / 9600)
INSERT INTO `guild_item_points` VALUES (2,12688,1,238,7440,6); -- Scale Finger Gauntlets (238 / 7440)
INSERT INTO `guild_item_points` VALUES (2,12768,1,290,7440,6); -- Solid Finger Gauntlets (290 / 7440)
INSERT INTO `guild_item_points` VALUES (2,12576,1,64,5040,7); -- Bronze Harness (64 / 5040)
INSERT INTO `guild_item_points` VALUES (2,12607,1,64,5040,7); -- Bronze Harness +1 (64 / 5040)

-- Blacksmithing / Initiate
INSERT INTO `guild_item_points` VALUES (2,17035,2,808,12480,0); -- Mace (808 / 12480)
INSERT INTO `guild_item_points` VALUES (2,17145,2,980,12480,0); -- Mace +1 (980 / 12480)
INSERT INTO `guild_item_points` VALUES (2,13871,2,3024,18480,1); -- Iron Visor (3024 / 18480)
INSERT INTO `guild_item_points` VALUES (2,13872,2,3078,18480,1); -- Iron Visor +1 (3078 / 18480)
INSERT INTO `guild_item_points` VALUES (2,16466,2,485,10320,2); -- Knife (485 / 10320)
INSERT INTO `guild_item_points` VALUES (2,16614,2,578,10320,2); -- Knife +1 (578 / 10320)
INSERT INTO `guild_item_points` VALUES (2,16552,2,905,12960,3); -- Scimitar (905 / 12960)
INSERT INTO `guild_item_points` VALUES (2,16625,2,998,12960,3); -- Scimitar +1 (998 / 12960)
INSERT INTO `guild_item_points` VALUES (2,16406,2,1440,15120,4); -- Baghnakhs (1440 / 15120)
INSERT INTO `guild_item_points` VALUES (2,16444,2,1740,15120,4); -- Baghnakhs +1 (1740 / 15120)
INSERT INTO `guild_item_points` VALUES (2,16566,2,1536,15600,5); -- Longsword (1536 / 15600)
INSERT INTO `guild_item_points` VALUES (2,16628,2,1689,15600,5); -- Longsword +1 (1689 / 15600)
INSERT INTO `guild_item_points` VALUES (2,16704,2,168,7200,6); -- Butterfly Axe (168 / 7200)
INSERT INTO `guild_item_points` VALUES (2,16716,2,183,7200,6); -- Butterfly Axe +1 (183 / 7200)
INSERT INTO `guild_item_points` VALUES (2,16392,2,873,12720,7); -- Metal Knuckles (873 / 12720)
INSERT INTO `guild_item_points` VALUES (2,16437,2,873,12720,7); -- Metal Knuckles +1 (873 / 12720)

-- Blacksmithing / Novice
INSERT INTO `guild_item_points` VALUES (2,12300,3,680,12000,0); -- Targe (680 / 12000)
INSERT INTO `guild_item_points` VALUES (2,12335,3,1000,12000,0); -- Targe +1 (1000 / 12000)
INSERT INTO `guild_item_points` VALUES (2,16524,3,2128,17040,1); -- Fleuret (2128 / 17040)
INSERT INTO `guild_item_points` VALUES (2,16803,3,3648,17040,1); -- Fleuret +1 (3648 / 17040)
INSERT INTO `guild_item_points` VALUES (2,16513,3,2146,17040,2); -- Tuck (2146 / 17040)
INSERT INTO `guild_item_points` VALUES (2,16617,3,2432,17040,2); -- Tuck +1 (2432 / 17040)
INSERT INTO `guild_item_points` VALUES (2,16900,3,300,9120,3); -- Wakizashi (300 / 9120)
INSERT INTO `guild_item_points` VALUES (2,16918,3,302,9120,3); -- Wakizashi +1 (302 / 9120)
INSERT INTO `guild_item_points` VALUES (2,17060,3,442,10320,4); -- Rod (442 / 10320)
INSERT INTO `guild_item_points` VALUES (2,17146,3,702,10320,4); -- Rod +1 (702 / 10320)
INSERT INTO `guild_item_points` VALUES (2,13783,3,4644,20160,5); -- Iron Scale Mail (4644 / 20160)
INSERT INTO `guild_item_points` VALUES (2,13784,3,5184,20160,5); -- Iron Scale Mail +1 (5184 / 20160)
INSERT INTO `guild_item_points` VALUES (2,17036,3,2256,17280,6); -- Mythril Mace (2256 / 17280)
INSERT INTO `guild_item_points` VALUES (2,17147,3,2736,17280,6); -- Mythril Mace +1 (2736 / 17280)
INSERT INTO `guild_item_points` VALUES (2,16705,3,910,13200,7); -- Greataxe (910 / 13200)
INSERT INTO `guild_item_points` VALUES (2,16717,3,991,13200,7); -- Greataxe +1 (991 / 13200)

-- Blacksmithing / Apprentice
INSERT INTO `guild_item_points` VALUES (2,16919,4,933,13680,0); -- Shinobi-Gatana (933 / 13680)
INSERT INTO `guild_item_points` VALUES (2,16920,4,942,13680,0); -- Shinobi-Gatana +1 (942 / 13680)
INSERT INTO `guild_item_points` VALUES (2,16775,4,6900,21120,1); -- Mythril Scythe (6900 / 21120)
INSERT INTO `guild_item_points` VALUES (2,16782,4,6900,21120,1); -- Mythril Scythe +1 (6900 / 21120)
INSERT INTO `guild_item_points` VALUES (2,16553,4,4850,20160,2); -- Tulwar (4850 / 20160)
INSERT INTO `guild_item_points` VALUES (2,16636,4,5330,20160,2); -- Tulwar +1 (5330 / 20160)
INSERT INTO `guild_item_points` VALUES (2,16475,4,2484,17760,3); -- Mythril Kukri (2484 / 17760)
INSERT INTO `guild_item_points` VALUES (2,16750,4,2944,17760,3); -- Mythril Kukri +1 (2944 / 17760)
INSERT INTO `guild_item_points` VALUES (2,16706,4,5152,20400,4); -- Heavy Axe (5152 / 20400)
INSERT INTO `guild_item_points` VALUES (2,16718,4,5612,20400,4); -- Heavy Axe +1 (5612 / 20400)
INSERT INTO `guild_item_points` VALUES (2,16644,4,5400,20640,5); -- Mythril Axe (5400 / 20640)
INSERT INTO `guild_item_points` VALUES (2,16665,4,5940,20640,5); -- Mythril Axe +1 (5940 / 20640)
INSERT INTO `guild_item_points` VALUES (2,16567,4,7750,21600,6); -- Knight's Sword (7750 / 21600)
INSERT INTO `guild_item_points` VALUES (2,16800,4,8525,21600,6); -- Knight's Sword +1 (8525 / 21600)
INSERT INTO `guild_item_points` VALUES (2,16584,4,5250,20400,7); -- Mythril Claymore (5250 / 20400)
INSERT INTO `guild_item_points` VALUES (2,16639,4,5275,20400,7); -- Fine Claymore (5275 / 20400)

-- Blacksmithing / Journeyman
INSERT INTO `guild_item_points` VALUES (2,16413,5,4320,19920,0); -- Darksteel Claws (4320 / 19920)
INSERT INTO `guild_item_points` VALUES (2,16697,5,5220,19920,0); -- Darksteel Claws +1 (5220 / 19920)
INSERT INTO `guild_item_points` VALUES (2,12544,5,5460,20640,1); -- Breastplate (5460 / 20640)
INSERT INTO `guild_item_points` VALUES (2,13724,5,6060,20640,1); -- Breastplate +1 (6060 / 20640)
INSERT INTO `guild_item_points` VALUES (2,16590,5,6758,21120,2); -- Greatsword (6758 / 21120)
INSERT INTO `guild_item_points` VALUES (2,16932,5,7562,21120,2); -- Greatsword +1 (7562 / 21120)
INSERT INTO `guild_item_points` VALUES (2,12416,5,3540,19200,3); -- Sallet (3540 / 19200)
INSERT INTO `guild_item_points` VALUES (2,13831,5,4140,19200,3); -- Sallet +1 (4140 / 19200)
INSERT INTO `guild_item_points` VALUES (2,16960,5,667,12480,4); -- Uchigatana (667 / 12480)
INSERT INTO `guild_item_points` VALUES (2,16978,5,728,12480,4); -- Uchigatana +1 (728 / 12480)
INSERT INTO `guild_item_points` VALUES (2,17265,5,1866,16800,5); -- Tanegashima (1866 / 16800)
INSERT INTO `guild_item_points` VALUES (2,17266,5,1875,16800,5); -- Tanegashima +1 (1875 / 16800)
INSERT INTO `guild_item_points` VALUES (2,16519,5,8600,21600,6); -- Schlaeger (8600 / 21600)
INSERT INTO `guild_item_points` VALUES (2,16813,5,9675,21600,6); -- Schlaeger +1 (9675 / 21600)
INSERT INTO `guild_item_points` VALUES (2,16545,5,3344,18960,7); -- Broadsword (3344 / 18960)
INSERT INTO `guild_item_points` VALUES (2,16634,5,3572,18960,7); -- Broadsword +1 (3572 / 18960)

-- Blacksmithing / Craftsman
INSERT INTO `guild_item_points` VALUES (2,12715,6,3300,18960,0); -- Kote (3300 / 18960)
INSERT INTO `guild_item_points` VALUES (2,13996,6,3300,18960,0); -- Kote +1 (3300 / 18960)
INSERT INTO `guild_item_points` VALUES (2,12459,6,3604,19440,1); -- Zunari Kabuto (3604 / 19440)
INSERT INTO `guild_item_points` VALUES (2,13865,6,3604,19440,1); -- Zunari Kabuto +1 (3604 / 19440)
INSERT INTO `guild_item_points` VALUES (2,16902,6,2310,17760,2); -- Sakurafubuki (2310 / 17760)
INSERT INTO `guild_item_points` VALUES (2,16922,6,2442,17760,2); -- Sakurafubuki +1 (2442 / 17760)
INSERT INTO `guild_item_points` VALUES (2,13111,6,2722,18480,3); -- Nodowa (2722 / 18480)
INSERT INTO `guild_item_points` VALUES (2,13124,6,3547,18480,3); -- Nodowa +1 (3547 / 18480)
INSERT INTO `guild_item_points` VALUES (2,12683,6,5170,20400,4); -- Darksteel Mufflers (5170 / 20400)
INSERT INTO `guild_item_points` VALUES (2,13976,6,6270,20400,4); -- Darksteel Mufflers +1 (6270 / 20400)
INSERT INTO `guild_item_points` VALUES (2,16476,6,5940,20880,5); -- Darksteel Kukri (5940 / 20880)
INSERT INTO `guild_item_points` VALUES (2,16763,6,7040,20880,5); -- Darksteel Kukri +1 (7040 / 20880)
INSERT INTO `guild_item_points` VALUES (2,16915,6,2325,17760,6); -- Hien (2325 / 17760)
INSERT INTO `guild_item_points` VALUES (2,16916,6,2402,17760,6); -- Hien +1 (2402 / 17760)
INSERT INTO `guild_item_points` VALUES (2,16796,6,6976,21360,7); -- Mythril Zaghnal (6976 / 21360)
INSERT INTO `guild_item_points` VALUES (2,16797,6,7616,21360,7); -- Mythril Zaghnal +1 (7616 / 21360)

-- Blacksmithing / Artisan
INSERT INTO `guild_item_points` VALUES (2,16577,7,12150,22320,0); -- Bastard Sword (12150 / 22320)
INSERT INTO `guild_item_points` VALUES (2,16828,7,13257,22320,0); -- Bastard Sword +1 (13257 / 22320)
INSERT INTO `guild_item_points` VALUES (2,16789,7,12535,22320,1); -- Darksteel Scythe (12535 / 22320)
INSERT INTO `guild_item_points` VALUES (2,16790,7,12650,22320,1); -- Darksteel Scythe +1 (12650 / 22320)
INSERT INTO `guild_item_points` VALUES (2,16759,7,5670,20880,2); -- Darksteel Kris (5670 / 20880)
INSERT INTO `guild_item_points` VALUES (2,16760,7,6720,20880,2); -- Darksteel Kris +1 (6720 / 20880)
INSERT INTO `guild_item_points` VALUES (2,16967,7,3740,19440,3); -- Mikazuki (3740 / 19440)
INSERT INTO `guild_item_points` VALUES (2,16989,7,3808,19440,3); -- Mikazuki +1 (3808 / 19440)
INSERT INTO `guild_item_points` VALUES (2,12452,7,7020,21360,4); -- Darksteel Cap (7020 / 21360)
INSERT INTO `guild_item_points` VALUES (2,13863,7,7020,21360,4); -- Darksteel Cap +1 (7020 / 21360)
INSERT INTO `guild_item_points` VALUES (2,12839,7,8580,21840,5); -- Darksteel Subligar (8580 / 21840)
INSERT INTO `guild_item_points` VALUES (2,14234,7,9880,21840,5); -- Darksteel Subligar +1 (9880 / 21840)
INSERT INTO `guild_item_points` VALUES (2,13812,7,9000,21840,6); -- Holy Breastplate (9000 / 21840)
INSERT INTO `guild_item_points` VALUES (2,13813,7,9500,21840,6); -- Divine Breastplate (9500 / 21840)
INSERT INTO `guild_item_points` VALUES (2,16526,7,9100,21840,7); -- Schwert (9100 / 21840)
INSERT INTO `guild_item_points` VALUES (2,17635,7,9262,21840,7); -- Schwert +1 (9262 / 21840)

-- Blacksmithing / Adept
INSERT INTO `guild_item_points` VALUES (2,12684,8,6345,21120,0); -- Thick Mufflers (6345 / 21120)
INSERT INTO `guild_item_points` VALUES (2,14012,8,6480,21120,0); -- Thick Mufflers +1 (6480 / 21120)
INSERT INTO `guild_item_points` VALUES (2,12547,8,11830,22320,1); -- Darksteel Cuirass (11830 / 22320)
INSERT INTO `guild_item_points` VALUES (2,13756,8,13130,22320,1); -- Darksteel Cuirass +1 (13130 / 22320)
INSERT INTO `guild_item_points` VALUES (2,17046,8,5880,20880,2); -- Darksteel Maul (5880 / 20880)
INSERT INTO `guild_item_points` VALUES (2,17432,8,6492,20880,2); -- Darksteel Maul +1 (6492 / 20880)
INSERT INTO `guild_item_points` VALUES (2,12931,8,5720,20880,3); -- Darksteel Sabatons (5720 / 20880)
INSERT INTO `guild_item_points` VALUES (2,14105,8,7020,20880,3); -- Darksteel Sabatons +1 (7020 / 20880)
INSERT INTO `guild_item_points` VALUES (2,16658,8,8287,21600,4); -- Darksteel Tabar (8287 / 21600)
INSERT INTO `guild_item_points` VALUES (2,16683,8,8925,21600,4); -- Darksteel Tabar +1 (8925 / 21600)
INSERT INTO `guild_item_points` VALUES (2,18858,8,5075,20400,5); -- Flanged Mace (5075 / 20400)
INSERT INTO `guild_item_points` VALUES (2,18860,8,5625,20400,5); -- Flanged Mace +1 (5625 / 20400)
INSERT INTO `guild_item_points` VALUES (2,16596,8,14850,22560,6); -- Flamberge (14850 / 22560)
INSERT INTO `guild_item_points` VALUES (2,16941,8,14987,22560,6); -- Flamberge +1 (14987 / 22560)
INSERT INTO `guild_item_points` VALUES (2,12803,8,6500,21120,7); -- Darksteel Cuisses (6500 / 21120)
INSERT INTO `guild_item_points` VALUES (2,14229,8,7150,21120,7); -- Darksteel Cuisses +1 (7150 / 21120)

-- Blacksmithing / Veteran
INSERT INTO `guild_item_points` VALUES (2,12309,9,6440,21120,0); -- Ritter Shield (6440 / 21120)
INSERT INTO `guild_item_points` VALUES (2,12358,9,7840,21120,0); -- Ritter Shield +1 (7840 / 21120)
INSERT INTO `guild_item_points` VALUES (2,17038,9,11925,22320,1); -- Buzdygan (11925 / 22320)
INSERT INTO `guild_item_points` VALUES (2,17460,9,13250,22320,1); -- Buzdygan +1 (13250 / 22320)
INSERT INTO `guild_item_points` VALUES (2,16452,9,4637,20160,2); -- Misericorde (4637 / 20160)
INSERT INTO `guild_item_points` VALUES (2,17620,9,5962,20160,2); -- Misericorde +1 (5962 / 20160)
INSERT INTO `guild_item_points` VALUES (2,16547,9,8820,21840,3); -- Anelace (8820 / 21840)
INSERT INTO `guild_item_points` VALUES (2,17657,9,10220,21840,3); -- Anelace +1 (10220 / 21840)
INSERT INTO `guild_item_points` VALUES (2,17252,9,8082,21840,4); -- Culverin (8082 / 21840)
INSERT INTO `guild_item_points` VALUES (2,18147,9,9407,21840,4); -- Culverin +1 (9407 / 21840)
INSERT INTO `guild_item_points` VALUES (2,16653,9,5565,20880,5); -- Nadziak (5565 / 20880)
INSERT INTO `guild_item_points` VALUES (2,16685,9,6890,20880,5); -- Nadziak +1 (6890 / 20880)
INSERT INTO `guild_item_points` VALUES (2,16659,9,7440,22320,6); -- Tabarzin (7440 / 22320)
INSERT INTO `guild_item_points` VALUES (2,17935,9,7440,22320,6); -- Tabarzin +1 (7440 / 22320
INSERT INTO `guild_item_points` VALUES (2,16470,9,2890,18720,7); -- Gully (2890 / 18720)
INSERT INTO `guild_item_points` VALUES (2,17621,9,4590,18720,7); -- Gully +1 (4590 / 18720)

-- Goldsmithing / Amateur
INSERT INTO `guild_item_points` VALUES (3,12449,0,327,7920,0); -- Brass Cap (327 / 7920)
INSERT INTO `guild_item_points` VALUES (3,12528,0,388,7920,0); -- Brass Cap +1 (388 / 7920)
INSERT INTO `guild_item_points` VALUES (3,16551,0,194,6240,1); -- Sapara (194 / 6240)
INSERT INTO `guild_item_points` VALUES (3,16801,0,214,6240,1); -- Sapara +1 (214 / 6240)
INSERT INTO `guild_item_points` VALUES (3,12496,0,39,3840,2); -- Copper Hairpin (39 / 3840)
INSERT INTO `guild_item_points` VALUES (3,12526,0,79,3840,2); -- Copper Hairpin +1 (79 / 3840)
INSERT INTO `guild_item_points` VALUES (3,12496,0,39,3840,3); -- Copper Hairpin (39 / 3840)
INSERT INTO `guild_item_points` VALUES (3,12526,0,79,3840,3); -- Copper Hairpin +1 (79 / 3840)
INSERT INTO `guild_item_points` VALUES (3,16551,0,194,6240,4); -- Sapara (194 / 6240)
INSERT INTO `guild_item_points` VALUES (3,16801,0,214,6240,4); -- Sapara +1 (214 / 6240)
INSERT INTO `guild_item_points` VALUES (3,13454,0,19,3600,5); -- Copper Ring (19 / 3600)
INSERT INTO `guild_item_points` VALUES (3,13492,0,27,3600,5); -- Copper Ring +1 (27 / 3600)
INSERT INTO `guild_item_points` VALUES (3,12449,0,327,7920,6); -- Brass Cap (327 / 7920)
INSERT INTO `guild_item_points` VALUES (3,12528,0,388,7920,6); -- Brass Cap +1 (388 / 7920)
INSERT INTO `guild_item_points` VALUES (3,13454,0,19,3600,7); -- Copper Ring (19 / 3600)
INSERT INTO `guild_item_points` VALUES (3,13492,0,27,3600,7); -- Copper Ring +1 (27 / 3600)

-- Goldsmithing / Recruit
INSERT INTO `guild_item_points` VALUES (3,12497,1,259,7680,0); -- Brass Hairpin (259 / 7680)
INSERT INTO `guild_item_points` VALUES (3,12529,1,264,7680,0); -- Brass Hairpin +1 (264 / 7680)
INSERT INTO `guild_item_points` VALUES (3,16407,1,338,8400,1); -- Brass Baghnakhs (338 / 8400)
INSERT INTO `guild_item_points` VALUES (3,16441,1,338,8400,1); -- Brass Baghnakhs +1 (338 / 8400)
INSERT INTO `guild_item_points` VALUES (3,16449,1,186,6720,2); -- Brass Dagger (186 / 6720)
INSERT INTO `guild_item_points` VALUES (3,16740,1,221,6720,2); -- Brass Dagger +1 (221 / 6720)
INSERT INTO `guild_item_points` VALUES (3,16769,1,140,6240,3); -- Brass Zaghnal (140 / 6240)
INSERT INTO `guild_item_points` VALUES (3,16772,1,181,6240,3); -- Brass Zaghnal +1 (181 / 6240)
INSERT INTO `guild_item_points` VALUES (3,16391,1,180,6720,4); -- Brass Knuckles (180 / 6720)
INSERT INTO `guild_item_points` VALUES (3,16689,1,222,6720,4); -- Brass Knuckles +1 (222 / 6720)
INSERT INTO `guild_item_points` VALUES (3,12961,1,248,7440,5); -- Brass Leggings (248 / 7440)
INSERT INTO `guild_item_points` VALUES (3,13027,1,309,7440,5); -- Brass Leggings +1 (309 / 7440)
INSERT INTO `guild_item_points` VALUES (3,12577,1,497,10080,6); -- Brass Harness (497 / 10080)
INSERT INTO `guild_item_points` VALUES (3,12664,1,558,10080,6); -- Brass Harness +1 (558 / 10080)
INSERT INTO `guild_item_points` VALUES (3,16641,1,312,8160,7); -- Brass Axe (312 / 8160)
INSERT INTO `guild_item_points` VALUES (3,16661,1,343,8160,7); -- Brass Axe +1 (343 / 8160)

-- Goldsmithing / Initiate
INSERT INTO `guild_item_points` VALUES (3,12473,2,414,9600,0); -- Poet's Circlet (414 / 9600)
INSERT INTO `guild_item_points` VALUES (3,12530,2,495,9600,0); -- Sage's Circlet (495 / 9600)
INSERT INTO `guild_item_points` VALUES (3,12433,2,800,12480,1); -- Brass Mask (800 / 12480)
INSERT INTO `guild_item_points` VALUES (3,12532,2,832,12480,1); -- Brass Mask +1 (832 / 12480)
INSERT INTO `guild_item_points` VALUES (3,17081,2,138,6720,2); -- Brass Rod (138 / 6720)
INSERT INTO `guild_item_points` VALUES (3,17148,2,219,6720,2); -- Brass Rod +1 (219 / 6720)
INSERT INTO `guild_item_points` VALUES (3,12495,2,345,9120,3); -- Silver Hairpin (345 / 9120)
INSERT INTO `guild_item_points` VALUES (3,12531,2,364,9120,3); -- Silver Hairpin +1 (364 / 9120)
INSERT INTO `guild_item_points` VALUES (3,17043,2,463,10080,4); -- Brass Hammer (463 / 10080)
INSERT INTO `guild_item_points` VALUES (3,17149,2,544,10080,4); -- Brass Hammer +1 (544 / 10080)
INSERT INTO `guild_item_points` VALUES (3,13196,2,357,9120,5); -- Silver Belt (357 / 9120)
INSERT INTO `guild_item_points` VALUES (3,13223,2,441,9120,5); -- Silver Belt +1 (441 / 9120)
INSERT INTO `guild_item_points` VALUES (3,12689,2,432,9840,6); -- Brass Finger Gauntlets (432 / 9840)
INSERT INTO `guild_item_points` VALUES (3,12771,2,544,9840,6); -- Brass Finger Gauntlets (544 / 9840)
INSERT INTO `guild_item_points` VALUES (3,13327,2,250,8160,7); -- Silver Earring (250 / 8160)
INSERT INTO `guild_item_points` VALUES (3,13370,2,350,8160,7); -- Silver Earring +1 (350 / 8160)

-- Goldsmithing / Novice
INSERT INTO `guild_item_points` VALUES (3,13083,3,810,12720,0); -- Chain Choker (810 / 12720)
INSERT INTO `guild_item_points` VALUES (3,13066,3,1110,12720,0); -- Red Choker (1110 / 12720)
INSERT INTO `guild_item_points` VALUES (3,12817,3,672,12000,1); -- Brass Cuisses (672 / 12000)
INSERT INTO `guild_item_points` VALUES (3,12893,3,752,12000,1); -- Brass Cuisses +1 (752 / 12000)
INSERT INTO `guild_item_points` VALUES (3,13209,3,1020,13680,2); -- Chain Belt (1020 / 13680)
INSERT INTO `guild_item_points` VALUES (3,13213,3,1320,13680,2); -- Chain Belt +1 (1320 / 13680)
INSERT INTO `guild_item_points` VALUES (3,12425,3,2850,18240,3); -- Silver Mask (2850 / 18240)
INSERT INTO `guild_item_points` VALUES (3,12533,3,3350,18240,3); -- Silver Mask +1 (3350 / 18240)
INSERT INTO `guild_item_points` VALUES (3,17686,3,669,12000,4); -- Spark Bilbo (669 / 12000)
INSERT INTO `guild_item_points` VALUES (3,17687,3,706,12000,4); -- Spark Bilbo +1 (706 / 12000)
INSERT INTO `guild_item_points` VALUES (3,13082,3,1020,13680,5); -- Chain Gorget (1020 / 13680)
INSERT INTO `guild_item_points` VALUES (3,13059,3,1320,13680,5); -- Fine Gorget (1320 / 13680)
INSERT INTO `guild_item_points` VALUES (3,12681,3,2350,17520,6); -- Silver Mittens (2350 / 17520)
INSERT INTO `guild_item_points` VALUES (3,12772,3,2850,17520,6); -- Silver Mittens +1 (2850 / 17520)
INSERT INTO `guild_item_points` VALUES (3,18076,3,240,8640,7); -- Spark Spear (240 / 8640)
INSERT INTO `guild_item_points` VALUES (3,18077,3,390,8640,7); -- Spark Spear +1 (390 / 8640)

-- Goldsmithing / Apprentice
INSERT INTO `guild_item_points` VALUES (3,12426,4,4275,19920,0); -- Banded Helm (4275 / 19920)
INSERT INTO `guild_item_points` VALUES (3,13832,4,5025,19920,0); -- Banded Helm +1 (5025 / 19920)
INSERT INTO `guild_item_points` VALUES (3,12301,4,3117,18270,1); -- Buckler (3117 / 18270)
INSERT INTO `guild_item_points` VALUES (3,12327,4,3842,18270,1); -- Buckler +1 (3842 / 18270)
INSERT INTO `guild_item_points` VALUES (3,16456,4,1976,16800,2); -- Mythril Baselard (1976 / 16800)
INSERT INTO `guild_item_points` VALUES (3,16752,4,2028,16800,2); -- Fine Baselard (2028 / 16800)
INSERT INTO `guild_item_points` VALUES (3,13446,4,750,12720,3); -- Mythril Ring (750 / 12720)
INSERT INTO `guild_item_points` VALUES (3,13519,4,1050,12720,3); -- Mythril Ring +1 (1050 / 12720)
INSERT INTO `guild_item_points` VALUES (3,12553,4,4400,19920,4); -- Silver Mail (4400 / 19920)
INSERT INTO `guild_item_points` VALUES (3,12666,4,4900,19920,4); -- Silver Mail +1 (4900 / 19920)
INSERT INTO `guild_item_points` VALUES (3,12938,4,3225,18960,5); -- Sollerets (3225 / 18960)
INSERT INTO `guild_item_points` VALUES (3,13047,4,3975,18960,5); -- Sollerets +1 (3975 / 18960)
INSERT INTO `guild_item_points` VALUES (3,13979,4,992,13920,6); -- Silver Bangles (992 / 13920)
INSERT INTO `guild_item_points` VALUES (3,13980,4,1054,13920,6); -- Silver Bangles +1 (1054 / 13920)
INSERT INTO `guild_item_points` VALUES (3,13328,4,750,12720,7); -- Mythril Earring (750 / 12720)
INSERT INTO `guild_item_points` VALUES (3,13371,4,1050,12720,7); -- Mythril Earring +1 (1050 / 12720)

-- Goldsmithing / Journeyman
INSERT INTO `guild_item_points` VALUES (3,13445,5,1750,16560,0); -- Gold Ring (1750 / 16560)
INSERT INTO `guild_item_points` VALUES (3,13520,5,2450,16560,0); -- Gold Ring +1 (2450 / 16560)
INSERT INTO `guild_item_points` VALUES (3,17988,5,6037,20880,1); -- Spark Kris (6037 / 20880)
INSERT INTO `guild_item_points` VALUES (3,17989,5,6912,20880,1); -- Spark Kris +1 (6912 / 20880)
INSERT INTO `guild_item_points` VALUES (3,13084,5,2805,18480,2); -- Mythril Gorget (2805 / 18480)
INSERT INTO `guild_item_points` VALUES (3,13067,5,3630,18480,2); -- Mythril Gorget +1 (3630 / 18480)
INSERT INTO `guild_item_points` VALUES (3,17512,5,1794,16560,3); -- Hydro Baghnakhs (1794 / 16560)
INSERT INTO `guild_item_points` VALUES (3,17513,5,1872,16560,3); -- Hydro Baghnakhs +1 (1872 / 16560)
INSERT INTO `guild_item_points` VALUES (3,12307,5,3168,18960,4); -- Heater Shield (3168 / 18960)
INSERT INTO `guild_item_points` VALUES (3,12328,5,3828,18960,4); -- Heater Shield +1 (3828 / 18960)
INSERT INTO `guild_item_points` VALUES (3,13315,5,1750,16560,5); -- Gold Earring (1750 / 16560)
INSERT INTO `guild_item_points` VALUES (3,13372,5,2450,16560,5); -- Gold Earring +1 (2450 / 16560)
INSERT INTO `guild_item_points` VALUES (3,16518,5,3100,18720,6); -- Mythril Degen (3100 / 18720)
INSERT INTO `guild_item_points` VALUES (3,16815,5,3150,18720,6); -- Mythril Degen +1 (3150 / 18720)
INSERT INTO `guild_item_points` VALUES (3,17281,5,1260,15120,7); -- Wingedge (1260 / 15120)
INSERT INTO `guild_item_points` VALUES (3,17288,5,1560,15120,7); -- Wingedge +1 (1560 / 15120)

-- Goldsmithing / Craftsman
INSERT INTO `guild_item_points` VALUES (3,12801,6,3547,19200,0); -- Mythril Cuisses (3547 / 19200)
INSERT INTO `guild_item_points` VALUES (3,14211,6,3630,19200,0); -- Mythril Cuisses +1 (3630 / 19200)
INSERT INTO `guild_item_points` VALUES (3,13983,6,3870,19680,1); -- Gold Bangles (3870 / 19680)
INSERT INTO `guild_item_points` VALUES (3,13984,6,4470,19680,1); -- Gold Bangles +1 (4470 / 19680)
INSERT INTO `guild_item_points` VALUES (3,12929,6,3630,19440,2); -- Mythril Leggings (3630 / 19440)
INSERT INTO `guild_item_points` VALUES (3,14086,6,4455,19440,2); -- Mythril Leggings +1 (4455 / 19440)
INSERT INTO `guild_item_points` VALUES (3,13447,6,6200,20880,3); -- Platinum Ring (6200 / 20880)
INSERT INTO `guild_item_points` VALUES (3,13498,6,8800,20880,3); -- Platinum Ring +1 (8800 / 20880)
INSERT INTO `guild_item_points` VALUES (3,12673,6,3960,19680,4); -- Mythril Gauntlets (3960 / 19680)
INSERT INTO `guild_item_points` VALUES (3,13958,6,4785,19680,4); -- Mythril Gauntlets +1 (4785 / 19680)
INSERT INTO `guild_item_points` VALUES (3,12545,6,7507,21360,5); -- Mythril Breastplate (7507 / 21360)
INSERT INTO `guild_item_points` VALUES (3,13737,6,8332,21360,5); -- Mythril Breastplate +1 (8332 / 21360)
INSERT INTO `guild_item_points` VALUES (3,16514,6,3037,18720,6); -- Mailbreaker (3037 / 18720)
INSERT INTO `guild_item_points` VALUES (3,16618,6,3150,18720,6); -- Mailbreaker +1 (3150 / 18720)
INSERT INTO `guild_item_points` VALUES (3,12801,6,3547,19200,7); -- Mythril Cuisses (3547 / 19200)
INSERT INTO `guild_item_points` VALUES (3,14211,6,3630,19200,7); -- Mythril Cuisses +1 (3630 / 19200)

-- Goldsmithing / Artisan
INSERT INTO `guild_item_points` VALUES (3,16421,7,6370,21120,0); -- Gold Patas (6370 / 21120)
INSERT INTO `guild_item_points` VALUES (3,17489,7,6492,21120,0); -- Gold Patas +1 (6492 / 21120)
INSERT INTO `guild_item_points` VALUES (3,16395,7,5637,20640,1); -- Diamond Knuckles (5637 / 20640)
INSERT INTO `guild_item_points` VALUES (3,17480,7,5775,20640,1); -- Diamond Knuckles +1 (5775 / 20640)
INSERT INTO `guild_item_points` VALUES (3,16569,7,14640,22560,2); -- Gold Sword (14640 / 22560)
INSERT INTO `guild_item_points` VALUES (3,17641,7,14792,22560,2); -- Gold Sword +1 (14792 / 22560)
INSERT INTO `guild_item_points` VALUES (3,16962,7,3250,18960,3); -- Ashura (3250 / 18960)
INSERT INTO `guild_item_points` VALUES (3,16979,7,3300,18960,3); -- Ashura +1 (3300 / 18960)
INSERT INTO `guild_item_points` VALUES (3,17285,7,3990,19680,4); -- Moonring Blade (3990 / 19680)
INSERT INTO `guild_item_points` VALUES (3,17279,7,4095,19680,4); -- Moonring Blade +1 (4095 / 19680)
INSERT INTO `guild_item_points` VALUES (3,12930,7,4950,20400,5); -- Gold Sabatons (4950 / 20400)
INSERT INTO `guild_item_points` VALUES (3,14087,7,6075,20400,5); -- Gilt Sabatons (6075 / 20400)
INSERT INTO `guild_item_points` VALUES (3,12303,7,4080,19920,6); -- Gold Buckler (4080 / 19920)
INSERT INTO `guild_item_points` VALUES (3,12353,7,4207,19920,6); -- Gilt Buckler (4207 / 19920)
INSERT INTO `guild_item_points` VALUES (3,12802,7,3937,19680,7); -- Gold Cuisses (3937 / 19680)
INSERT INTO `guild_item_points` VALUES (3,14212,7,4050,19680,7); -- Gilt Cuisses (4050 / 19680)

-- Goldsmithing / Adept
INSERT INTO `guild_item_points` VALUES (3,16972,8,7950,21600,0); -- Kazaridachi (7950 / 21600)
INSERT INTO `guild_item_points` VALUES (3,17805,8,7950,21600,0); -- Kazaridachi +1 (7950 / 21600)
INSERT INTO `guild_item_points` VALUES (3,12310,8,5640,20880,1); -- Diamond Shield (5640 / 20880)
INSERT INTO `guild_item_points` VALUES (3,12355,8,6815,20880,1); -- Diamond Shield +1 (6815 / 20880)
INSERT INTO `guild_item_points` VALUES (3,16842,8,5460,20640,2); -- Golden Spear (5460 / 20640)
INSERT INTO `guild_item_points` VALUES (3,16875,8,6435,20640,2); -- Golden Spear +1 (6435 / 20640)
INSERT INTO `guild_item_points` VALUES (3,13985,8,5697,20880,3); -- Platinum Bangles (5697 / 20880)
INSERT INTO `guild_item_points` VALUES (3,13986,8,7022,20880,3); -- Platinum Bangles +1 (7022 / 20880)
INSERT INTO `guild_item_points` VALUES (3,17039,8,8342,21600,4); -- Platinum Mace (8342 / 21600)
INSERT INTO `guild_item_points` VALUES (3,17431,8,8697,21600,4); -- Platinum Mace +1 (8697 / 21600)
INSERT INTO `guild_item_points` VALUES (3,16527,8,10920,22080,5); -- Epee (10920 / 22080)
INSERT INTO `guild_item_points` VALUES (3,16619,8,11895,22080,5); -- Epee +1 (11895 / 22080)
INSERT INTO `guild_item_points` VALUES (3,13087,8,3780,19680,6); -- Jeweled Collar (3780 / 19680)
INSERT INTO `guild_item_points` VALUES (3,13130,8,4060,19680,6); -- Jeweled Collar +1 (4060 / 19680)
INSERT INTO `guild_item_points` VALUES (3,16541,8,13545,22560,7); -- Jagdplaute (13545 / 22560)
INSERT INTO `guild_item_points` VALUES (3,17636,8,13702,22560,7); -- Jagdplaute +1 (13702 / 22560)

-- Goldsmithing / Veteran
INSERT INTO `guild_item_points` VALUES (3,16520,9,17340,22800,0); -- Verdun (17340 / 22800)
INSERT INTO `guild_item_points` VALUES (3,17656,9,17977,22800,0); -- Verdun +1 (17977 / 22800)
INSERT INTO `guild_item_points` VALUES (3,16453,9,22200,23040,1); -- Orichalcum Dagger (22200 / 23040)
INSERT INTO `guild_item_points` VALUES (3,17992,9,22800,23040,1); -- Triton's Dagger (22800 / 23040)
INSERT INTO `guild_item_points` VALUES (3,13185,9,1800,17040,2); -- Muscle Belt (1800 / 17040)
INSERT INTO `guild_item_points` VALUES (3,13279,9,2925,17040,2); -- Muscle Belt +1 (2925 / 17040)
INSERT INTO `guild_item_points` VALUES (3,13097,9,21105,23040,3); -- Brisingamen (21105 / 23040)
INSERT INTO `guild_item_points` VALUES (3,13162,9,22680,23040,3); -- Brisingamen +1 (22680 / 23040)
INSERT INTO `guild_item_points` VALUES (3,13466,9,29750,23280,4); -- Orichalcum Ring (29750 / 23280)
INSERT INTO `guild_item_points` VALUES (3,14616,9,31450,23280,4); -- Triton Ring (31450 / 23280)
INSERT INTO `guild_item_points` VALUES (3,12387,9,22312,23040,5); -- Koenig Shield (22312 / 23040)
INSERT INTO `guild_item_points` VALUES (3,12388,9,23587,23040,5); -- Kaiser Shield (23587 / 23040)
INSERT INTO `guild_item_points` VALUES (3,33,9,24500,23280,6); -- Millionaire Desk (24500 / 23280)
INSERT INTO `guild_item_points` VALUES (3,13329,9,29750,23280,7); -- Orichalcum Earring (29750 / 23280)
INSERT INTO `guild_item_points` VALUES (3,13434,9,31450,23280,7); -- Triton Earring (31450 / 23280)

-- Clothcraft / Amateur
INSERT INTO `guild_item_points` VALUES (4,12720,0,303,7680,0); -- Gloves (303 / 7680)
INSERT INTO `guild_item_points` VALUES (4,12773,0,373,7680,0); -- Gloves +1 (373 / 7680)
INSERT INTO `guild_item_points` VALUES (4,12848,0,211,6480,1); -- Brais (211 / 6480)
INSERT INTO `guild_item_points` VALUES (4,12896,0,282,6480,1); -- Brais +1 (282 / 6480)
INSERT INTO `guild_item_points` VALUES (4,13583,0,85,4800,2); -- Cape (85 / 4800)
INSERT INTO `guild_item_points` VALUES (4,13605,0,111,4800,2); -- Cape +1 (111 / 4800)
INSERT INTO `guild_item_points` VALUES (4,12976,0,282,7440,3); -- Gaiters (282 / 7440)
INSERT INTO `guild_item_points` VALUES (4,13030,0,352,7440,3); -- Gaiters +1 (352 / 7440)
INSERT INTO `guild_item_points` VALUES (4,12592,0,549,5280,4); -- Doublet (549 / 5280)
INSERT INTO `guild_item_points` VALUES (4,12591,0,549,5280,4); -- Doublet +1 (549 / 5280)
INSERT INTO `guild_item_points` VALUES (4,13583,0,85,4800,5); -- Cape (85 / 4800)
INSERT INTO `guild_item_points` VALUES (4,13605,0,111,4800,5); -- Cape +1 (111 / 4800)
INSERT INTO `guild_item_points` VALUES (4,12464,0,176,4560,6); -- Headgear (176 / 4560)
INSERT INTO `guild_item_points` VALUES (4,12471,0,183,4560,6); -- Headgear +1 (183 / 4560)
INSERT INTO `guild_item_points` VALUES (4,14290,0,110,5040,7); -- Vagabond's Hose (110 / 5040)
INSERT INTO `guild_item_points` VALUES (4,14291,0,118,5040,7); -- Nomad's Hose (118 / 5040)

-- Clothcraft / Recruit
INSERT INTO `guild_item_points` VALUES (4,12608,1,280,7920,0); -- Tunic (280 / 7920)
INSERT INTO `guild_item_points` VALUES (4,12616,1,312,7920,0); -- Tunic +1 (312 / 7920)
INSERT INTO `guild_item_points` VALUES (4,12593,1,858,12480,1); -- Cotton Doublet (858 / 12480)
INSERT INTO `guild_item_points` VALUES (4,12669,1,2518,12480,1); -- Cotton Doublet +1 (2518 / 12480)
INSERT INTO `guild_item_points` VALUES (4,12584,1,249,7440,2); -- Kenpogi (249 / 7440)
INSERT INTO `guild_item_points` VALUES (4,12668,1,280,7440,2); -- Kenpogi +1 (280 / 7440)
INSERT INTO `guild_item_points` VALUES (4,12968,1,127,6000,3); -- Kyahan (127 / 6000)
INSERT INTO `guild_item_points` VALUES (4,13031,1,159,6000,3); -- Kyahan +1 (159 / 6000)
INSERT INTO `guild_item_points` VALUES (4,12712,1,137,6240,4); -- Tekko (137 / 6240)
INSERT INTO `guild_item_points` VALUES (4,12774,1,168,6240,4); -- Tekko +1 (168 / 6240)
INSERT INTO `guild_item_points` VALUES (4,12864,1,187,6720,5); -- Slacks (187 / 6720)
INSERT INTO `guild_item_points` VALUES (4,12898,1,218,6720,5); -- Slacks +1 (218 / 6720)
INSERT INTO `guild_item_points` VALUES (4,13584,1,506,10080,6); -- Cotton Cape (506 / 10080)
INSERT INTO `guild_item_points` VALUES (4,13601,1,660,10080,6); -- Cotton Cape +1 (660 / 10080)
INSERT INTO `guild_item_points` VALUES (4,13806,1,118,6000,7); -- Vagabond's Tunica (118 / 6000)
INSERT INTO `guild_item_points` VALUES (4,13807,1,126,6000,7); -- Nomad's Tunica (126 / 6000)

-- Clothcraft / Initiate
INSERT INTO `guild_item_points` VALUES (4,12713,2,675,11760,0); -- Cotton Tekko (675 / 11760)
INSERT INTO `guild_item_points` VALUES (4,12777,2,829,11760,0); -- Cotton Tekko +1 (829 / 11760)
INSERT INTO `guild_item_points` VALUES (4,12969,2,629,11280,1); -- Cotton Kyahan (629 / 11280)
INSERT INTO `guild_item_points` VALUES (4,13033,2,783,11280,1); -- Cotton Kyahan +1 (783 / 11280)
INSERT INTO `guild_item_points` VALUES (4,12585,2,460,10080,2); -- Cotton Dogi (460 / 10080)
INSERT INTO `guild_item_points` VALUES (4,12624,2,476,10080,2); -- Cotton Dogi +1 (476 / 10080)
INSERT INTO `guild_item_points` VALUES (4,12457,2,814,12480,3); -- Cotton Hachimaki (814 / 12480)
INSERT INTO `guild_item_points` VALUES (4,12537,2,967,12480,3); -- Cotton Hachimaki +1 (967 / 12480)
INSERT INTO `guild_item_points` VALUES (4,12594,2,2500,17760,4); -- Gambison (2500 / 17760)
INSERT INTO `guild_item_points` VALUES (4,12625,2,2550,17760,4); -- Gambison +1 (2550 / 17760)
INSERT INTO `guild_item_points` VALUES (4,12729,2,349,9120,5); -- Linen Cuffs (349 / 9120)
INSERT INTO `guild_item_points` VALUES (4,12778,2,430,9120,5); -- Linen Cuffs +1 (430 / 9120)
INSERT INTO `guild_item_points` VALUES (4,13204,2,99,6240,6); -- Heko Obi (99 / 6240)
INSERT INTO `guild_item_points` VALUES (4,13190,2,131,6240,6); -- Heko Obi +1 (131 / 6240)
INSERT INTO `guild_item_points` VALUES (4,12601,2,617,11280,7); -- Linen Robe (617 / 11280)
INSERT INTO `guild_item_points` VALUES (4,12626,2,617,11280,7); -- Linen Robe +1 (617 / 11280)

-- Clothcraft / Novice
INSERT INTO `guild_item_points` VALUES (4,12970,3,1836,16560,0); -- Soil Kyahan (1836 / 16560)
INSERT INTO `guild_item_points` VALUES (4,13035,3,1872,16560,0); -- Soil Kyahan +1 (1872 / 16560)
INSERT INTO `guild_item_points` VALUES (4,14423,3,3120,18720,1); -- Mist Tunic (3120 / 18720)
INSERT INTO `guild_item_points` VALUES (4,14855,3,1395,15120,2); -- Mist Mitts (1395 / 15120)
INSERT INTO `guild_item_points` VALUES (4,12610,3,1748,16320,3); -- Cloak (1748 / 16320)
INSERT INTO `guild_item_points` VALUES (4,12670,3,1794,16320,3); -- Cloak +1 (1794 / 16320)
INSERT INTO `guild_item_points` VALUES (4,12714,3,1584,15840,4); -- Soil Tekko (1584 / 15840)
INSERT INTO `guild_item_points` VALUES (4,12781,3,1944,15840,4); -- Soil Tekko +1 (1944 / 15840)
INSERT INTO `guild_item_points` VALUES (4,12842,3,2304,17520,5); -- Soil Sitabaki (2304 / 17520)
INSERT INTO `guild_item_points` VALUES (4,12905,3,2664,17520,5); -- Soil Sitabaki +1 (2664 / 17520)
INSERT INTO `guild_item_points` VALUES (4,14324,3,2460,17760,6); -- Mist Slacks (2460 / 17760)
INSERT INTO `guild_item_points` VALUES (4,12458,3,1116,14160,7); -- Soil Hachimaki (1116 / 14160)
INSERT INTO `guild_item_points` VALUES (4,12539,3,1152,14160,7); -- Soil Hachimaki +1 (1152 / 14160)

-- Clothcraft / Apprentice
INSERT INTO `guild_item_points` VALUES (4,12723,4,3440,19200,0); -- Wool Bracers (3440 / 19200)
INSERT INTO `guild_item_points` VALUES (4,12783,4,4240,19200,0); -- Wool Bracers +1 (4240 / 19200)
INSERT INTO `guild_item_points` VALUES (4,12979,4,3200,18960,1); -- Wool Socks (3200 / 18960)
INSERT INTO `guild_item_points` VALUES (4,13036,4,4000,18960,1); -- Wool Socks +1 (4000 / 18960)
INSERT INTO `guild_item_points` VALUES (4,12858,4,2108,17280,2); -- Wool Slops (2108 / 17280)
INSERT INTO `guild_item_points` VALUES (4,12906,4,2448,17280,2); -- Wool Slops +1 (2448 / 17280)
INSERT INTO `guild_item_points` VALUES (4,12467,4,1155,14640,3); -- Wool Cap (1155 / 14640)
INSERT INTO `guild_item_points` VALUES (4,12541,4,1251,14640,3); -- Wool Cap +1 (1251 / 14640)
INSERT INTO `guild_item_points` VALUES (4,12602,4,2584,18000,4); -- Wool Robe (2584 / 18000)
INSERT INTO `guild_item_points` VALUES (4,12627,4,2584,18000,4); -- Wool Robe +1 (2584 / 18000)
INSERT INTO `guild_item_points` VALUES (4,13085,4,180,8400,5); -- Hemp Gorget (180 / 8400)
INSERT INTO `guild_item_points` VALUES (4,13068,4,320,8400,5); -- Hemp Gorget +1 (320 / 8400)
INSERT INTO `guild_item_points` VALUES (4,12851,4,4800,20160,6); -- Wool Hose (4800 / 20160)
INSERT INTO `guild_item_points` VALUES (4,12907,4,4880,20160,6); -- Wool Hose +1 (4880 / 20160)
INSERT INTO `guild_item_points` VALUES (4,12730,4,1462,15600,7); -- Wool Cuffs (1462 / 15600)
INSERT INTO `guild_item_points` VALUES (4,12782,4,1802,15600,7); -- Wool Cuffs +1 (1802 / 15600)

-- Clothcraft / Journeyman
INSERT INTO `guild_item_points` VALUES (4,12739,5,2550,18000,0); -- Black Mitts (2550 / 18000)
INSERT INTO `guild_item_points` VALUES (4,12794,5,2720,18000,0); -- Mage's Mitts (2720 / 18000)
INSERT INTO `guild_item_points` VALUES (4,12603,5,4256,19920,1); -- Velvet Robe (4256 / 19920)
INSERT INTO `guild_item_points` VALUES (4,13726,5,4816,19920,1); -- Mage's Robe (4816 / 19920)
INSERT INTO `guild_item_points` VALUES (4,13568,5,250,9600,2); -- Scarlet Ribbon (250 / 9600)
INSERT INTO `guild_item_points` VALUES (4,13833,5,350,9600,2); -- Noble's Ribbon (350 / 9600)
INSERT INTO `guild_item_points` VALUES (4,13586,5,2178,17520,3); -- Red Cape (2178 / 17520)
INSERT INTO `guild_item_points` VALUES (4,13611,5,2838,17520,3); -- Red Cape +1 (2838 / 17520)
INSERT INTO `guild_item_points` VALUES (4,12865,5,1150,14640,4); -- Black Slacks (1150 / 14640)
INSERT INTO `guild_item_points` VALUES (4,12917,5,1342,14640,4); -- Mage's Slacks (1342 / 14640)
INSERT INTO `guild_item_points` VALUES (4,13577,5,1386,15600,5); -- Black Cape (1386 / 15600)
INSERT INTO `guild_item_points` VALUES (4,13610,5,1806,15600,5); -- Black Cape +1 (1806 / 15600)
INSERT INTO `guild_item_points` VALUES (4,13750,5,2508,18000,6); -- Linen Doublet (2508 / 18000)
INSERT INTO `guild_item_points` VALUES (4,13751,5,2552,18000,6); -- Linen Doublet +1 (2552 / 18000)
INSERT INTO `guild_item_points` VALUES (4,13205,5,613,12240,7); -- Silver Obi (613 / 12240)
INSERT INTO `guild_item_points` VALUES (4,13224,5,824,12240,7); -- Silver Obi +1 (824 / 12240)

-- Clothcraft / Craftsman
INSERT INTO `guild_item_points` VALUES (4,12604,6,7030,21360,0); -- Silk Coat (7030 / 21360)
INSERT INTO `guild_item_points` VALUES (4,12652,6,7030,21360,0); -- Silk Coat +1 (7030 / 21360)
INSERT INTO `guild_item_points` VALUES (4,12503,6,2280,17760,1); -- Silk Headband (2280 / 17760)
INSERT INTO `guild_item_points` VALUES (4,13851,6,2375,17760,1); -- Silk Headband +1 (2375 / 17760)
INSERT INTO `guild_item_points` VALUES (4,12867,6,5100,20400,2); -- White Slacks (5100 / 20400)
INSERT INTO `guild_item_points` VALUES (4,12926,6,5950,20400,2); -- White Slacks +1 (5950 / 20400)
INSERT INTO `guild_item_points` VALUES (4,13752,6,4992,20400,3); -- Wool Doublet (4992 / 20400)
INSERT INTO `guild_item_points` VALUES (4,13753,6,5632,20400,3); -- Wool Doublet +1 (5632 / 20400)
INSERT INTO `guild_item_points` VALUES (4,13590,6,2025,17280,4); -- Green Ribbon (2025 / 17280)
INSERT INTO `guild_item_points` VALUES (4,13854,6,2137,17280,4); -- Green Ribbon +1 (2137 / 17280)
INSERT INTO `guild_item_points` VALUES (4,12611,6,7200,21600,5); -- White Cloak (7200 / 21600)
INSERT INTO `guild_item_points` VALUES (4,12651,6,7650,21600,5); -- White Cloak +1 (7650 / 21600)
INSERT INTO `guild_item_points` VALUES (4,12860,6,5735,20880,6); -- Silk Slops (5735 / 20880)
INSERT INTO `guild_item_points` VALUES (4,12927,6,6660,20880,6); -- Silk Slops +1 (6660 / 20880)
INSERT INTO `guild_item_points` VALUES (4,12731,6,2408,18000,7); -- Velvet Cuffs (2408 / 18000)
INSERT INTO `guild_item_points` VALUES (4,12793,6,2968,18000,7); -- Mage's Cuffs (2968 / 18000)

-- Clothcraft / Artisan
INSERT INTO `guild_item_points` VALUES (4,12468,7,3055,18960,0); -- Green Beret (3055 / 18960)
INSERT INTO `guild_item_points` VALUES (4,13866,7,3250,18960,0); -- Green Beret +1 (3250 / 18960)
INSERT INTO `guild_item_points` VALUES (4,12612,7,6375,21120,1); -- Silk Cloak (6375 / 21120)
INSERT INTO `guild_item_points` VALUES (4,13777,7,6500,21120,1); -- Silk Cloak +1 (6500 / 21120)
INSERT INTO `guild_item_points` VALUES (4,12972,7,3382,19200,2); -- Shinobi Kyahan (3382 / 19200)
INSERT INTO `guild_item_points` VALUES (4,14082,7,4207,19200,2); -- Shinobi Kyahan +1 (4207 / 19200)
INSERT INTO `guild_item_points` VALUES (4,12716,7,3630,19200,3); -- Shinobi Tekko (3630 / 19200)
INSERT INTO `guild_item_points` VALUES (4,13955,7,4455,19200,3); -- Shinobi Tekko +1 (4455 / 19200)
INSERT INTO `guild_item_points` VALUES (4,13579,7,3217,18960,4); -- Jester's Cape (3217 / 18960)
INSERT INTO `guild_item_points` VALUES (4,13620,7,4192,18960,4); -- Jester's Cape +1 (4192 / 18960)
INSERT INTO `guild_item_points` VALUES (4,12740,7,4830,20400,5); -- Silk Mitts (4830 / 20400)
INSERT INTO `guild_item_points` VALUES (4,14000,7,5980,20400,5); -- Silk Mitts +1 (5980 / 20400)
INSERT INTO `guild_item_points` VALUES (4,12844,7,3465,19200,6); -- Shinobi Hakama (3465 / 19200)
INSERT INTO `guild_item_points` VALUES (4,12925,7,3547,19200,6); -- Shinobi Hakama +1 (3547 / 19200)
INSERT INTO `guild_item_points` VALUES (4,12716,7,3630,19440,7); -- Shinobi Tekko (3630 / 19440)
INSERT INTO `guild_item_points` VALUES (4,13955,7,4455,19440,7); -- Shinobi Tekko +1 (4455 / 19440)

-- Clothcraft / Adept
INSERT INTO `guild_item_points` VALUES (4,14023,8,3225,19200,0); -- Arhat's Tekko (3225 / 19200)
INSERT INTO `guild_item_points` VALUES (4,14028,8,3762,19200,0); -- Arhat's Tekko +1 (3762 / 19200)
INSERT INTO `guild_item_points` VALUES (4,13208,8,3840,19680,1); -- Rainbow Obi (3840 / 19680)
INSERT INTO `guild_item_points` VALUES (4,13235,8,3840,19680,1); -- Prism Obi (3840 / 19680)
INSERT INTO `guild_item_points` VALUES (4,12861,8,7750,21600,2); -- Noble's Slacks (7750 / 21600)
INSERT INTO `guild_item_points` VALUES (4,14239,8,9000,21600,2); -- Aristocrat's Slacks (9000 / 21600)
INSERT INTO `guild_item_points` VALUES (4,12504,8,5300,20640,3); -- Rainbow Headband (5300 / 20640)
INSERT INTO `guild_item_points` VALUES (4,13858,8,5962,20640,3); -- Rainbow Headband +1 (5962 / 20640)
INSERT INTO `guild_item_points` VALUES (4,12733,8,5590,20640,4); -- Noble's Mitts (5590 / 20640)
INSERT INTO `guild_item_points` VALUES (4,13999,8,6880,20640,4); -- Aristocrat's Mitts (6880 / 20640)
INSERT INTO `guild_item_points` VALUES (4,14129,8,3762,19680,5); -- Arhat's Sune-Ate (3762 / 19680)
INSERT INTO `guild_item_points` VALUES (4,14136,8,4300,19680,5); -- Arhat's Sune-Ate +1 (4300 / 19680)
INSERT INTO `guild_item_points` VALUES (4,14253,8,4300,19920,6); -- Arhat's Hakama (4300 / 19920)
INSERT INTO `guild_item_points` VALUES (4,14256,8,4837,19920,6); -- Arhat's Hakama +1 (4837 / 19920)
INSERT INTO `guild_item_points` VALUES (4,13881,8,3225,19200,7); -- Arhat's Jinpachi (3225 / 19200)
INSERT INTO `guild_item_points` VALUES (4,13886,8,3762,19200,7); -- Arhat's Jinpachi +1 (3762 / 19200)

-- Clothcraft / Veteran
INSERT INTO `guild_item_points` VALUES (4,14819,9,15000,22560,0); -- Rasetsu Tekko (15000 / 22560)
INSERT INTO `guild_item_points` VALUES (4,14820,9,16250,22560,0); -- Rasetsu Tekko +1 (16250 / 22560)
INSERT INTO `guild_item_points` VALUES (4,14299,9,12375,22320,1); -- Rasetsu Hakama (12375 / 22320)
INSERT INTO `guild_item_points` VALUES (4,14300,9,13625,22320,1); -- Rasetsu Hakama +1 (13625 / 22320)
INSERT INTO `guild_item_points` VALUES (4,13212,9,3600,19440,2); -- Tarutaru Sash (3600 / 19440)
INSERT INTO `guild_item_points` VALUES (4,13188,9,4200,19440,2); -- Tarutaru Sash +1 (4200 / 19440)
INSERT INTO `guild_item_points` VALUES (4,14301,9,3750,19680,3); -- Errant Slops (3750 / 19680)
INSERT INTO `guild_item_points` VALUES (4,14302,9,5000,19680,3); -- Mahatma Slops (5000 / 19680)
INSERT INTO `guild_item_points` VALUES (4,13929,9,4500,20160,4); -- Errant Hat (4500 / 20160)
INSERT INTO `guild_item_points` VALUES (4,13930,9,5750,20160,4); -- Mahatma Hat (5750 / 20160)
INSERT INTO `guild_item_points` VALUES (4,14178,9,12000,22320,5); -- Rasetsu Sune-Ate (12000 / 22320)
INSERT INTO `guild_item_points` VALUES (4,14179,9,13250,22320,5); -- Rasetsu Sune-Ate +1 (13250 / 22320)
INSERT INTO `guild_item_points` VALUES (4,14078,9,6875,21360,6); -- Errant Cuffs (6875 / 21360)
INSERT INTO `guild_item_points` VALUES (4,14079,9,8125,21360,6); -- Mahatma Cuffs (8125 / 21360)
INSERT INTO `guild_item_points` VALUES (4,13925,9,13750,22560,7); -- Rasetsu Jinpachi (13750 / 22560)
INSERT INTO `guild_item_points` VALUES (4,13926,9,15000,22560,7); -- Rasetsu Jinpachi (15000 / 22560)

-- Leathercraft / Amateur
INSERT INTO `guild_item_points` VALUES (5,12568,0,92,4800,0); -- Leather Vest (92 / 4800)
INSERT INTO `guild_item_points` VALUES (5,12599,0,153,4800,0); -- Leather Vest +1 (153 / 4800)
INSERT INTO `guild_item_points` VALUES (5,12696,0,90,4800,1); -- Leather Gloves (90 / 4800)
INSERT INTO `guild_item_points` VALUES (5,12784,0,110,4800,1); -- Leather Gloves +1 (110 / 4800)
INSERT INTO `guild_item_points` VALUES (5,14068,0,63,4320,2); -- Vagabond's Gloves (63 / 4320)
INSERT INTO `guild_item_points` VALUES (5,14069,0,71,4320,2); -- Nomad's Gloves (71 / 4320)
INSERT INTO `guild_item_points` VALUES (5,12952,0,84,4560,3); -- Leather Highboots (84 / 4560)
INSERT INTO `guild_item_points` VALUES (5,12971,0,104,4560,3); -- Leather Highboots +1 (104 / 4560)
INSERT INTO `guild_item_points` VALUES (5,12440,0,52,4080,4); -- Leather Bandana (52 / 4080)
INSERT INTO `guild_item_points` VALUES (5,12542,0,120,4080,4); -- Leather Bandana +1 (120 / 4080)
INSERT INTO `guild_item_points` VALUES (5,12824,0,134,5520,5); -- Leather Trousers (134 / 5520)
INSERT INTO `guild_item_points` VALUES (5,12908,0,154,5520,5); -- Leather Trousers +1 (154 / 5520)
INSERT INTO `guild_item_points` VALUES (5,14169,0,63,4320,6); -- Vagabond's Boots (63 / 4320)
INSERT INTO `guild_item_points` VALUES (5,14170,0,71,4320,6); -- Nomad's Boots (71 / 4320)
INSERT INTO `guild_item_points` VALUES (5,16385,0,24,3600,7); -- Cesti (24 / 3600)
INSERT INTO `guild_item_points` VALUES (5,16690,0,32,3600,7); -- Cesti +1 (32 / 3600)

-- Leathercraft / Recruit
INSERT INTO `guild_item_points` VALUES (5,12992,1,121,6000,0); -- Solea (121 / 6000)
INSERT INTO `guild_item_points` VALUES (5,13037,1,152,6000,0); -- Solea +1 (152 / 6000)
INSERT INTO `guild_item_points` VALUES (5,12441,1,177,6270,1); -- Lizard Helm (177 / 6270)
INSERT INTO `guild_item_points` VALUES (5,12480,1,177,6270,1); -- Lizard Helm +1 (177 / 6270)
INSERT INTO `guild_item_points` VALUES (5,13192,1,85,5520,2); -- Leather Belt (85 / 5520)
INSERT INTO `guild_item_points` VALUES (5,13210,1,111,5520,2); -- Leather Belt +1 (111 / 5520)
INSERT INTO `guild_item_points` VALUES (5,16386,1,252,7680,3); -- Lizard Cesti (252 / 7680)
INSERT INTO `guild_item_points` VALUES (5,16398,1,333,7680,3); -- Burning Cesti (333 / 7680)
INSERT INTO `guild_item_points` VALUES (5,13592,1,81,5280,4); -- Lizard Mantle (81 / 5280)
INSERT INTO `guild_item_points` VALUES (5,13608,1,95,5280,4); -- Lizard Mantle +1 (95 / 5280)
INSERT INTO `guild_item_points` VALUES (5,14171,1,180,6720,5); -- Fisherman's Boots (180 / 6720)
INSERT INTO `guild_item_points` VALUES (5,14172,1,519,6720,5); -- Angler's Boots (519 / 6720)
INSERT INTO `guild_item_points` VALUES (5,12569,1,245,7440,6); -- Lizard Jerkin (245 / 7440)
INSERT INTO `guild_item_points` VALUES (5,13697,1,259,7440,6); -- Fine Jerkin (259 / 7440)
INSERT INTO `guild_item_points` VALUES (5,14070,1,360,8640,7); -- Fisherman's Gloves (360 / 8640)
INSERT INTO `guild_item_points` VALUES (5,14071,1,986,8640,7); -- Angler's Gloves (986 / 8640)

-- Leathercraft / Initiate
INSERT INTO `guild_item_points` VALUES (5,12442,2,1102,13920,0); -- Studded Bandana (1102 / 13920)
INSERT INTO `guild_item_points` VALUES (5,13824,2,1140,13920,0); -- Strong Bandana (1140 / 13920)
INSERT INTO `guild_item_points` VALUES (5,12698,2,1710,16090,1); -- Studded Gloves (1710 / 16090)
INSERT INTO `guild_item_points` VALUES (5,12786,2,2090,16090,1); -- Studded Gloves +1 (2090 / 16090)
INSERT INTO `guild_item_points` VALUES (5,14072,2,519,10560,2); -- Chocobo Gloves (519 / 10560)
INSERT INTO `guild_item_points` VALUES (5,14073,2,570,10560,2); -- Rider's Gloves (570 / 10560)
INSERT INTO `guild_item_points` VALUES (5,13588,2,552,10800,3); -- Dhalmel Mantle (552 / 10800)
INSERT INTO `guild_item_points` VALUES (5,13600,2,706,10800,3); -- Dhalmel Mantle +1 (706 / 10800)
INSERT INTO `guild_item_points` VALUES (5,13194,2,330,8880,4); -- Warrior's Belt (330 / 8880)
INSERT INTO `guild_item_points` VALUES (5,13240,2,400,8880,4); -- Warrior's Belt +1 (400 / 8880)
INSERT INTO `guild_item_points` VALUES (5,14173,2,519,10560,5); -- Chocobo Boots (519 / 10560)
INSERT INTO `guild_item_points` VALUES (5,14174,2,570,10560,5); -- Rider's Boots (570 / 10560)
INSERT INTO `guild_item_points` VALUES (5,12993,2,748,12000,6); -- Sandals (748 / 12000)
INSERT INTO `guild_item_points` VALUES (5,13048,2,939,12000,6); -- Mages' Sandals (939 / 12000)
INSERT INTO `guild_item_points` VALUES (5,13469,2,250,8160,7); -- Leather Ring (250 / 8160)
INSERT INTO `guild_item_points` VALUES (5,13499,2,350,8160,7); -- Leather Ring +1 (350 / 8160)

-- Leathercraft / Novice
INSERT INTO `guild_item_points` VALUES (5,15312,3,1305,14880,0); -- Mist Pumps (1305 / 14880)
INSERT INTO `guild_item_points` VALUES (5,13089,3,608,11520,1); -- Wolf Gorget (608 / 11520)
INSERT INTO `guild_item_points` VALUES (5,13070,3,684,11520,1); -- Wolf Gorget +1 (684 / 11520)
INSERT INTO `guild_item_points` VALUES (5,13571,3,1224,14640,2); -- Wolf Mantle (1224 / 14640)
INSERT INTO `guild_item_points` VALUES (5,13609,3,1564,14640,2); -- Wolf Mantle +1 (1564 / 14640)
INSERT INTO `guild_item_points` VALUES (5,14176,3,665,12000,3); -- Field Boots (665 / 12000)
INSERT INTO `guild_item_points` VALUES (5,14177,3,1140,12000,3); -- Worker Boots (1140 / 12000)
INSERT INTO `guild_item_points` VALUES (5,12994,3,1104,14160,4); -- Shoes (1104 / 14160)
INSERT INTO `guild_item_points` VALUES (5,13040,3,1196,14160,4); -- Shoes +1 (1196 / 14160)
INSERT INTO `guild_item_points` VALUES (5,13195,3,506,10800,5); -- Magic Belt (506 / 10800)
INSERT INTO `guild_item_points` VALUES (5,13219,3,660,10800,5); -- Magic Belt +1 (660 / 10800)
INSERT INTO `guild_item_points` VALUES (5,12699,3,1624,15840,6); -- Cuir Gloves (1624 / 15840)
INSERT INTO `guild_item_points` VALUES (5,12787,3,1680,15840,6); -- Cuir Gloves +1 (1680 / 15840)
INSERT INTO `guild_item_points` VALUES (5,12570,3,2280,17520,7); -- Studded Vest (2280 / 17520)
INSERT INTO `guild_item_points` VALUES (5,13707,3,2318,17520,7); -- Studded Vest +1 (2318 / 17520)

-- Leathercraft / Apprentice
INSERT INTO `guild_item_points` VALUES (5,13271,4,3250,18960,0); -- Corsette (3250 / 18960)
INSERT INTO `guild_item_points` VALUES (5,13272,4,3750,18960,0); -- Corsette +1 (3750 / 18960)
INSERT INTO `guild_item_points` VALUES (5,13570,4,900,13440,1); -- Ram Mantle (900 / 13440)
INSERT INTO `guild_item_points` VALUES (5,13575,4,1000,13440,1); -- Ram Mantle +1 (1000 / 13440)
INSERT INTO `guild_item_points` VALUES (5,12955,4,1736,16320,2); -- Cuir Highboots (1736 / 16320)
INSERT INTO `guild_item_points` VALUES (5,13041,4,1792,16320,2); -- Cuir Highboots +1 (1792 / 16320)
INSERT INTO `guild_item_points` VALUES (5,12571,4,1960,16800,3); -- Cuir Bouilli (1960 / 16800)
INSERT INTO `guild_item_points` VALUES (5,13709,4,2072,16800,3); -- Cuir Bouilli +1 (2072 / 16800)
INSERT INTO `guild_item_points` VALUES (5,13200,4,1680,16080,4); -- Waistbelt (1680 / 16080)
INSERT INTO `guild_item_points` VALUES (5,13214,4,1740,16080,4); -- Waistbelt +1 (1740 / 16080)
INSERT INTO `guild_item_points` VALUES (5,12827,4,1008,13920,5); -- Cuir Trousers (1008 / 13920)
INSERT INTO `guild_item_points` VALUES (5,12911,4,1232,13920,5); -- Cuir Trousers +1 (1232 / 13920)
INSERT INTO `guild_item_points` VALUES (5,13810,4,1297,15120,6); -- Chocobo Jack Coat (1297 / 15120)
INSERT INTO `guild_item_points` VALUES (5,13811,4,1349,15120,6); -- Rider's Jack Coat (1349 / 15120)
INSERT INTO `guild_item_points` VALUES (5,13203,4,506,11280,7); -- Barbarian's Belt (506 / 11280)
INSERT INTO `guild_item_points` VALUES (5,13225,4,660,11280,7); -- Brave Belt (660 / 11280)

-- Leathercraft / Journeyman
INSERT INTO `guild_item_points` VALUES (5,12444,5,2240,17520,0); -- Raptor Helm (2240 / 17520)
INSERT INTO `guild_item_points` VALUES (5,13835,5,2400,17520,0); -- Dino Helm (2400 / 17520)
INSERT INTO `guild_item_points` VALUES (5,12700,5,3600,19200,1); -- Raptor Gloves (3600 / 19200)
INSERT INTO `guild_item_points` VALUES (5,12795,5,3760,19200,1); -- Dino Gloves (3760 / 19200)
INSERT INTO `guild_item_points` VALUES (5,16388,5,1140,14640,2); -- Himantes (1140 / 14640)
INSERT INTO `guild_item_points` VALUES (5,16699,5,1720,14640,2); -- Himantes +1 (1720 / 14640)
INSERT INTO `guild_item_points` VALUES (5,12956,5,3360,18960,3); -- Raptor Ledelsens (3360 / 18960)
INSERT INTO `guild_item_points` VALUES (5,13049,5,4160,18960,3); -- Dino Ledelsens (4160 / 18960)
INSERT INTO `guild_item_points` VALUES (5,13593,5,1280,15120,4); -- Raptor Mantle (1280 / 15120)
INSERT INTO `guild_item_points` VALUES (5,13612,5,1440,15120,4); -- Dino Mantle (1440 / 15120)
INSERT INTO `guild_item_points` VALUES (5,12828,5,2160,17280,5); -- Raptor Trousers (2160 / 17280)
INSERT INTO `guild_item_points` VALUES (5,12919,5,2320,17280,5); -- Dino Trousers (2320 / 17280)
INSERT INTO `guild_item_points` VALUES (5,12995,5,1700,16320,6); -- Moccasins (1700 / 16320)
INSERT INTO `guild_item_points` VALUES (5,13050,5,1785,16320,6); -- Moccasins +1 (1785 / 16320)
INSERT INTO `guild_item_points` VALUES (5,12294,5,1280,15120,7); -- Leather Shield (1280 / 15120)
INSERT INTO `guild_item_points` VALUES (5,12329,5,1360,15120,7); -- Leather Shield +1 (1360 / 15120)

-- Leathercraft / Craftsman
INSERT INTO `guild_item_points` VALUES (5,13698,6,2687,18240,0); -- Beak Helm (2687 / 18240)
INSERT INTO `guild_item_points` VALUES (5,13701,6,2795,18240,0); -- Beak Helm +1 (2795 / 18240)
INSERT INTO `guild_item_points` VALUES (5,13700,6,3600,19200,1); -- Beak Gloves (3600 / 19200)
INSERT INTO `guild_item_points` VALUES (5,13960,6,3760,19200,1); -- Beak Gloves +1 (3760 / 19200)
INSERT INTO `guild_item_points` VALUES (5,13597,6,1612,16320,2); -- Beak Mantle (1612 / 16320)
INSERT INTO `guild_item_points` VALUES (5,13621,6,1720,16320,2); -- Beak Mantle +1 (1720 / 16320)
INSERT INTO `guild_item_points` VALUES (5,12980,6,2860,18480,3); -- Battle Boots (2860 / 18480)
INSERT INTO `guild_item_points` VALUES (5,14104,6,3190,18480,3); -- Battle Boots +1 (3190 / 18480)
INSERT INTO `guild_item_points` VALUES (5,12829,6,3225,18960,4); -- Beak Trousers (3225 / 18960)
INSERT INTO `guild_item_points` VALUES (5,14213,6,3225,18960,4); -- Beak Trousers +1 (3225 / 18960)
INSERT INTO `guild_item_points` VALUES (5,13702,6,4515,20160,5); -- Beak Ledelsens (4515 / 20160)
INSERT INTO `guild_item_points` VALUES (5,14088,6,4622,20160,5); -- Beak Ledelsens +1 (4622 / 20160)
INSERT INTO `guild_item_points` VALUES (5,13699,6,2150,17520,6); -- Beak Jerkin (2150 / 17520)
INSERT INTO `guild_item_points` VALUES (5,13739,6,2257,17520,6); -- Beak Jerkin +1 (2257 / 17520)
INSERT INTO `guild_item_points` VALUES (5,13546,6,770,13200,7); -- Hard Leather Ring (770 / 13200)
INSERT INTO `guild_item_points` VALUES (5,13547,6,880,13200,7); -- Tiger Ring (880 / 13200)

-- Leathercraft / Artisan
INSERT INTO `guild_item_points` VALUES (5,12996,7,4485,20160,0); -- Silk Pumps (4485 / 20160)
INSERT INTO `guild_item_points` VALUES (5,14115,7,5635,20160,0); -- Silk Pumps +1 (5635 / 20160)
INSERT INTO `guild_item_points` VALUES (5,12702,7,1912,17040,1); -- Tiger Gloves (1912 / 17040)
INSERT INTO `guild_item_points` VALUES (5,13992,7,2040,17040,1); -- Feral Gloves (2040 / 17040)
INSERT INTO `guild_item_points` VALUES (5,16389,7,1980,17280,2); -- Coeurl Cesti (1980 / 17280)
INSERT INTO `guild_item_points` VALUES (5,17473,7,2070,17280,2); -- Torama Cesti (2070 / 17280)
INSERT INTO `guild_item_points` VALUES (5,13589,7,1250,15360,3); -- Tiger Mantle (1250 / 15360)
INSERT INTO `guild_item_points` VALUES (5,13602,7,1375,15360,3); -- Feral Mantle (1375 / 15360)
INSERT INTO `guild_item_points` VALUES (5,12852,7,3680,19440,4); -- Battle Hose (3680 / 19440)
INSERT INTO `guild_item_points` VALUES (5,14237,7,3795,19440,4); -- Battle Hose +1 (3795 / 19440)
INSERT INTO `guild_item_points` VALUES (5,12830,7,2040,17280,5); -- Tiger Trousers (2040 / 17280)
INSERT INTO `guild_item_points` VALUES (5,14232,7,2160,17280,5); -- Feral Trousers (2160 / 17280)
INSERT INTO `guild_item_points` VALUES (5,13641,7,2200,17520,6); -- Black Mantle (2200 / 17520)
INSERT INTO `guild_item_points` VALUES (5,13642,7,3300,17520,6); -- Black Mantle +1 (3300 / 17520)
INSERT INTO `guild_item_points` VALUES (5,13198,7,2178,17520,7); -- Swordbelt (2178 / 17520)
INSERT INTO `guild_item_points` VALUES (5,13232,7,2838,17520,7); -- Swordbelt +1 (2838 / 17520)

-- Leathercraft / Adept
INSERT INTO `guild_item_points` VALUES (5,13705,8,4560,20160,0); -- Ogre Jerkin (4560 / 20160)
INSERT INTO `guild_item_points` VALUES (5,14366,8,5760,20160,0); -- Ogre Jerkin +1 (5760 / 20160)
INSERT INTO `guild_item_points` VALUES (5,13704,8,4200,19920,1); -- Ogre Mask (4200 / 19920)
INSERT INTO `guild_item_points` VALUES (5,13907,8,5400,19920,1); -- Ogre Mask +1 (5400 / 19920)
INSERT INTO `guild_item_points` VALUES (5,13595,8,2100,17520,2); -- Coeurl Mantle (2100 / 17520)
INSERT INTO `guild_item_points` VALUES (5,13603,8,2800,17520,2); -- Torama Mantle (2800 / 17520)
INSERT INTO `guild_item_points` VALUES (5,13197,8,4785,20400,3); -- Koenigs Belt (4785 / 20400)
INSERT INTO `guild_item_points` VALUES (5,13239,8,6235,20400,3); -- Kaiser Belt (6235 / 20400)
INSERT INTO `guild_item_points` VALUES (5,13708,8,5040,20400,4); -- Ogre Ledelsens (5040 / 20400)
INSERT INTO `guild_item_points` VALUES (5,14159,8,6240,20400,4); -- Ogre Ledelsens +1 (6240 / 20400)
INSERT INTO `guild_item_points` VALUES (5,12447,8,3500,19440,5); -- Coeurl Mask (3500 / 19440)
INSERT INTO `guild_item_points` VALUES (5,13862,8,4200,19440,5); -- Torama Mask (4200 / 19440)
INSERT INTO `guild_item_points` VALUES (5,13706,8,3600,19440,6); -- Ogre Gloves (3600 / 19440)
INSERT INTO `guild_item_points` VALUES (5,14057,8,4800,19440,6); -- Ogre Gloves +1 (4800 / 19440)
INSERT INTO `guild_item_points` VALUES (5,12880,8,4800,20400,7); -- Ogre Trousers (4800 / 20400)
INSERT INTO `guild_item_points` VALUES (5,14279,8,6000,20400,7); -- Ogre Trousers +1 (6000 / 20400)

-- Leathercraft / Veteran
INSERT INTO `guild_item_points` VALUES (5,15307,9,6492,21120,0); -- Bison Gamashes (6492 / 21120)
INSERT INTO `guild_item_points` VALUES (5,15308,9,7717,21120,0); -- Brave's Gamashes (7717 / 21120)
INSERT INTO `guild_item_points` VALUES (5,14319,9,6247,21120,1); -- Bison Kecks (6247 / 21120)
INSERT INTO `guild_item_points` VALUES (5,14320,9,7472,21120,1); -- Brave's Kecks (7472 / 21120)
INSERT INTO `guild_item_points` VALUES (5,14372,9,4800,20400,2); -- Cardinal Vest (4800 / 20400)
INSERT INTO `guild_item_points` VALUES (5,14373,9,6000,20400,2); -- Bachelor Vest (6000 / 20400)
INSERT INTO `guild_item_points` VALUES (5,14850,9,4042,19920,3); -- Bison Wristbands (4042 / 19920)
INSERT INTO `guild_item_points` VALUES (5,14851,9,5267,19920,3); -- Brave's Wristbands (5267 / 19920)
INSERT INTO `guild_item_points` VALUES (5,13918,9,1080,15120,4); -- Tiger Mask (1080 / 15120)
INSERT INTO `guild_item_points` VALUES (5,13919,9,2280,15120,4); -- Feral Mask (2280 / 15120)
INSERT INTO `guild_item_points` VALUES (5,14317,9,6737,21360,5); -- Barone Cosciales (6737 / 21360)
INSERT INTO `guild_item_points` VALUES (5,14318,9,7962,21360,5); -- Conte Cosciales (7962 / 21360)
INSERT INTO `guild_item_points` VALUES (5,13918,9,1080,15120,6); -- Tiger Mask (1080 / 15120)
INSERT INTO `guild_item_points` VALUES (5,13919,9,2280,15120,6); -- Feral Mask (2280 / 15120)
INSERT INTO `guild_item_points` VALUES (5,14182,9,2500,18240,7); -- Errant Pigaches (2500 / 18240)
INSERT INTO `guild_item_points` VALUES (5,14183,9,3750,18240,7); -- Mahatma Pigaches (3750 / 18240)

-- Bonecraft / Amateur
INSERT INTO `guild_item_points` VALUES (6,12505,0,112,5040,0); -- Bone Hairpin (112 / 5040)
INSERT INTO `guild_item_points` VALUES (6,13825,0,187,5040,0); -- Bone Hairpin +1 (187 / 5040)
INSERT INTO `guild_item_points` VALUES (6,13442,0,151,5760,1); -- Shell Ring (151 / 5760)
INSERT INTO `guild_item_points` VALUES (6,13494,0,212,5760,1); -- Shell Ring +1 (212 / 5760)
INSERT INTO `guild_item_points` VALUES (6,12505,0,112,5040,2); -- Bone Hairpin (112 / 5040)
INSERT INTO `guild_item_points` VALUES (6,13825,0,187,5040,2); -- Bone Hairpin +1 (187 / 5040)
INSERT INTO `guild_item_points` VALUES (6,13313,0,151,5760,3); -- Shell Earring (151 / 5760)
INSERT INTO `guild_item_points` VALUES (6,13314,0,212,5760,3); -- Shell Earring +1 (212 / 5760)
INSERT INTO `guild_item_points` VALUES (6,13442,0,151,5760,4); -- Shell Ring (151 / 5760)
INSERT INTO `guild_item_points` VALUES (6,13494,0,212,5760,4); -- Shell Ring +1 (212 / 5760)
INSERT INTO `guild_item_points` VALUES (6,16405,0,29,3840,5); -- Cat Baghnakhs (29 / 3840)
INSERT INTO `guild_item_points` VALUES (6,17476,0,35,3840,5); -- Cat Baghnakhs +1 (35 / 3840)
INSERT INTO `guild_item_points` VALUES (6,16405,0,29,3840,6); -- Cat Baghnakhs (29 / 3840)
INSERT INTO `guild_item_points` VALUES (6,17476,0,35,3840,6); -- Cat Baghnakhs +1 (35 / 3840)
INSERT INTO `guild_item_points` VALUES (6,13313,0,151,5760,7); -- Shell Earring (151 / 5760)
INSERT INTO `guild_item_points` VALUES (6,13314,0,212,5760,7); -- Shell Earring +1 (212 / 5760)

-- Bonecraft / Recruit
INSERT INTO `guild_item_points` VALUES (6,12710,1,544,10320,0); -- Bone Mittens (544 / 10320)
INSERT INTO `guild_item_points` VALUES (6,12788,1,664,10320,0); -- Bone Mittens +1 (664 / 10320)
INSERT INTO `guild_item_points` VALUES (6,12454,1,652,11280,1); -- Bone Mask (652 / 11280)
INSERT INTO `guild_item_points` VALUES (6,13826,1,773,11280,1); -- Bone Mask +1 (773 / 11280)
INSERT INTO `guild_item_points` VALUES (6,13076,1,141,6240,2); -- Fang Necklace (141 / 6240)
INSERT INTO `guild_item_points` VALUES (6,13061,1,235,6240,2); -- Spike Necklace (235 / 6240)
INSERT INTO `guild_item_points` VALUES (6,12454,1,652,11280,3); -- Bone Mask (652 / 11280)
INSERT INTO `guild_item_points` VALUES (6,13826,1,773,11280,3); -- Bone Mask +1 (773 / 11280)
INSERT INTO `guild_item_points` VALUES (6,13076,1,141,6240,4); -- Fang Necklace (141 / 6240)
INSERT INTO `guild_item_points` VALUES (6,13061,1,235,6240,4); -- Spike Necklace (235 / 6240)
INSERT INTO `guild_item_points` VALUES (6,13441,1,302,8160,5); -- Bone Ring (302 / 8160)
INSERT INTO `guild_item_points` VALUES (6,13500,1,423,8160,5); -- Bone Ring +1 (423 / 8160)
INSERT INTO `guild_item_points` VALUES (6,12710,1,544,10320,6); -- Bone Mittens (544 / 10320)
INSERT INTO `guild_item_points` VALUES (6,12788,1,664,10320,6); -- Bone Mittens +1 (664 / 10320)
INSERT INTO `guild_item_points` VALUES (6,13321,1,302,8160,7); -- Bone Earring (302 / 8160)
INSERT INTO `guild_item_points` VALUES (6,13362,1,423,8160,7); -- Bone Earring +1 (423 / 8160)

-- Bonecraft / Initiate
INSERT INTO `guild_item_points` VALUES (6,12582,2,362,9120,0); -- Bone Harness (362 / 9120)
INSERT INTO `guild_item_points` VALUES (6,13716,2,374,9120,0); -- Bone Harness +1 (374 / 9120)
INSERT INTO `guild_item_points` VALUES (6,12507,2,950,13200,1); -- Horn Hairpin (950 / 13200)
INSERT INTO `guild_item_points` VALUES (6,13828,2,988,13200,1); -- Horn Hairpin +1 (988 / 13200)
INSERT INTO `guild_item_points` VALUES (6,12966,2,495,10320,2); -- Bone Leggings (495 / 10320)
INSERT INTO `guild_item_points` VALUES (6,13042,2,616,10320,2); -- Bone Leggings +1 (616 / 10320)
INSERT INTO `guild_item_points` VALUES (6,17351,2,860,12720,3); -- Gemshorn (860 / 12720)
INSERT INTO `guild_item_points` VALUES (6,17370,2,1032,12720,3); -- Gemshorn +1 (1032 / 12720)
INSERT INTO `guild_item_points` VALUES (6,16649,2,362,9120,4); -- Bone Pick (362 / 9120)
INSERT INTO `guild_item_points` VALUES (6,16668,2,374,9120,4); -- Bone Pick +1 (374 / 9120)
INSERT INTO `guild_item_points` VALUES (6,12834,2,362,9120,5); -- Bone Subligar (362 / 9120)
INSERT INTO `guild_item_points` VALUES (6,12912,2,374,9120,5); -- Bone Subligar +1 (374 / 9120)
INSERT INTO `guild_item_points` VALUES (6,12711,2,282,8400,6); -- Beetle Mittens (282 / 8400)
INSERT INTO `guild_item_points` VALUES (6,12789,2,306,8400,6); -- Beetle Mittens +1 (306 / 8400)
INSERT INTO `guild_item_points` VALUES (6,16642,2,205,7680,7); -- Bone Axe (205 / 7680)
INSERT INTO `guild_item_points` VALUES (6,16666,2,317,7680,7); -- Bone Axe +1 (317 / 7680)

-- Bonecraft / Novice
INSERT INTO `guild_item_points` VALUES (6,13459,3,1200,14400,0); -- Horn Ring (1200 / 14400)
INSERT INTO `guild_item_points` VALUES (6,13502,3,1680,14400,0); -- Horn Ring +1 (1680 / 14400)
INSERT INTO `guild_item_points` VALUES (6,17026,3,768,12480,1); -- Bone Cudgel (768 / 12480)
INSERT INTO `guild_item_points` VALUES (6,17033,3,1088,12480,1); -- Bone Cudgel +1 (1088 / 12480)
INSERT INTO `guild_item_points` VALUES (6,12967,3,966,13440,2); -- Beetle Leggings (966 / 13440)
INSERT INTO `guild_item_points` VALUES (6,13043,3,1202,13440,2); -- Beetle Leggings +1 (1202 / 13440)
INSERT INTO `guild_item_points` VALUES (6,12583,3,471,10560,3); -- Beetle Harness (471 / 10560)
INSERT INTO `guild_item_points` VALUES (6,13717,3,495,10560,3); -- Beetle Harness +1 (495 / 10560)
INSERT INTO `guild_item_points` VALUES (6,12835,3,471,10560,4); -- Beetle Subligar (471 / 10560)
INSERT INTO `guild_item_points` VALUES (6,12913,3,495,10560,4); -- Beetle Subligar +1 (495 / 10560)
INSERT INTO `guild_item_points` VALUES (6,12414,3,615,11520,5); -- Turtle Shield (615 / 11520)
INSERT INTO `guild_item_points` VALUES (6,12413,3,735,11520,5); -- Turtle Shield +1 (735 / 11520)
INSERT INTO `guild_item_points` VALUES (6,15315,3,3797,19440,6); -- Shade Leggings (3797 / 19440)
INSERT INTO `guild_item_points` VALUES (6,15319,3,3989,19440,6); -- Shade Leggings +1 (3989 / 19440)
INSERT INTO `guild_item_points` VALUES (6,13090,3,448,10320,7); -- Beetle Gorget (448 / 10320)
INSERT INTO `guild_item_points` VALUES (6,13062,3,542,10320,7); -- Green Gorget (542 / 10320)

-- Bonecraft / Apprentice
INSERT INTO `guild_item_points` VALUES (6,17352,4,780,12960,0); -- Horn (780 / 12960)
INSERT INTO `guild_item_points` VALUES (6,17371,4,840,12960,0); -- Horn +1 (840 / 12960)
INSERT INTO `guild_item_points` VALUES (6,12837,4,1540,15840,1); -- Carapace Subligar (1540 / 15840)
INSERT INTO `guild_item_points` VALUES (6,12914,4,1610,15840,1); -- Carapace Subligar +1 (1610 / 15840)
INSERT INTO `guild_item_points` VALUES (6,13461,4,1812,16560,2); -- Carapace Ring (1812 / 16560)
INSERT INTO `guild_item_points` VALUES (6,13503,4,2537,16560,2); -- Carapace Ring +1 (2537 / 16560)
INSERT INTO `guild_item_points` VALUES (6,13715,4,1470,15600,3); -- Carapace Leggings (1470 / 15600)
INSERT INTO `guild_item_points` VALUES (6,13044,4,1540,15600,3); -- Carapace Leggings +1 (1540 / 15600)
INSERT INTO `guild_item_points` VALUES (6,13713,4,1050,14160,4); -- Carapace Mittens (1050 / 14160)
INSERT INTO `guild_item_points` VALUES (6,12790,4,1120,14160,4); -- Carapace Mittens +1 (1120 / 14160)
INSERT INTO `guild_item_points` VALUES (6,13711,4,1050,14160,5); -- Carapace Mask (1050 / 14160)
INSERT INTO `guild_item_points` VALUES (6,13829,4,1120,14160,5); -- Carapace Mask +1 (1120 / 14160)
INSERT INTO `guild_item_points` VALUES (6,13091,4,2310,17520,6); -- Carapace Gorget (2310 / 17520)
INSERT INTO `guild_item_points` VALUES (6,13063,4,3010,17520,6); -- Blue Gorget (3010 / 17520)
INSERT INTO `guild_item_points` VALUES (6,17610,4,750,12720,7); -- Bone Knife (750 / 12720)
INSERT INTO `guild_item_points` VALUES (6,17611,4,825,12720,7); -- Bone Knife +1 (825 / 12720)

-- Bonecraft / Journeyman
INSERT INTO `guild_item_points` VALUES (6,16794,5,825,13440,0); -- Bone Scythe (825 / 13440)
INSERT INTO `guild_item_points` VALUES (6,16795,5,907,13440,0); -- Bone Scythe +1 (907 / 13440)
INSERT INTO `guild_item_points` VALUES (6,13458,5,450,11040,1); -- Scorpion Ring (450 / 11040)
INSERT INTO `guild_item_points` VALUES (6,13513,5,600,11040,1); -- Scorpion Ring +1 (600 / 11040)
INSERT INTO `guild_item_points` VALUES (6,17257,5,2000,17040,2); -- Bandit's Gun (2000 / 17040)
INSERT INTO `guild_item_points` VALUES (6,17258,5,2100,17040,2); -- Bandit's Gun +1 (2100 / 17040)
INSERT INTO `guild_item_points` VALUES (6,13324,5,1750,16560,3); -- Tortoise Earring (1750 / 16560)
INSERT INTO `guild_item_points` VALUES (6,13363,5,2450,16560,3); -- Tortoise Earring +1 (2450 / 16560)
INSERT INTO `guild_item_points` VALUES (6,12506,5,750,12960,4); -- Shell Hairpin (750 / 12960)
INSERT INTO `guild_item_points` VALUES (6,13836,5,850,12960,4); -- Shell Hairpin +1 (850 / 12960)
INSERT INTO `guild_item_points` VALUES (6,13981,5,3332,18960,5); -- Turtle Bangles (3332 / 18960)
INSERT INTO `guild_item_points` VALUES (6,13982,5,4107,18960,5); -- Turtle Bangles +1 (4107 / 18960)
INSERT INTO `guild_item_points` VALUES (6,17612,5,1025,14160,6); -- Beetle Knife (1025 / 14160)
INSERT INTO `guild_item_points` VALUES (6,17613,5,1127,14160,6); -- Beetle Knife +1 (1127 / 14160)
INSERT INTO `guild_item_points` VALUES (6,17062,5,1122,14640,7); -- Bone Rod (1122 / 14640)
INSERT INTO `guild_item_points` VALUES (6,17410,5,1782,14640,7); -- Bone Rod +1 (1782 / 14640)

-- Bonecraft / Craftsman
INSERT INTO `guild_item_points` VALUES (6,17361,6,1845,16800,0); -- Crumhorn (1845 / 16800)
INSERT INTO `guild_item_points` VALUES (6,17377,6,1947,16800,0); -- Crumhorn +1 (1947 / 16800)
INSERT INTO `guild_item_points` VALUES (6,17847,6,1947,16800,0); -- Crumhorn +2 (1947 / 16800)
INSERT INTO `guild_item_points` VALUES (6,12838,6,1575,16080,1); -- Scorpion Subligar (1575 / 16080)
INSERT INTO `guild_item_points` VALUES (6,14208,6,1680,16080,1); -- Scorpion Subligar +1 (1680 / 16080)
INSERT INTO `guild_item_points` VALUES (6,17259,6,4320,19920,2); -- Pirate's Gun (4320 / 19920)
INSERT INTO `guild_item_points` VALUES (6,17260,6,4352,19920,2); -- Pirate's Gun +1 (4352 / 19920)
INSERT INTO `guild_item_points` VALUES (6,12963,6,1575,16080,3); -- Scorpion Leggings (1575 / 16080)
INSERT INTO `guild_item_points` VALUES (6,14083,6,1680,16080,3); -- Scorpion Leggings +1 (1680 / 16080)
INSERT INTO `guild_item_points` VALUES (6,12707,6,1050,14400,4); -- Scorpion Mittens (1050 / 14400)
INSERT INTO `guild_item_points` VALUES (6,13956,6,1155,14400,4); -- Scorpion Mittens +1 (1155 / 14400)
INSERT INTO `guild_item_points` VALUES (6,12451,6,1050,14400,5); -- Scorpion Mask (1050 / 14400)
INSERT INTO `guild_item_points` VALUES (6,12482,6,1150,14400,5); -- Scorpion Mask +1 (1150 / 14400)
INSERT INTO `guild_item_points` VALUES (6,16420,6,1230,15120,6); -- Bone Patas (1230 / 15120)
INSERT INTO `guild_item_points` VALUES (6,17477,6,1332,15120,6); -- Bone Patas +1 (1332 / 15120)
INSERT INTO `guild_item_points` VALUES (6,13325,6,2500,18000,7); -- Fang Earring (2500 / 18000)
INSERT INTO `guild_item_points` VALUES (6,13369,6,3500,18000,7); -- Spike Earring (3500 / 18000)

-- Bonecraft / Artisan
INSERT INTO `guild_item_points` VALUES (6,12453,7,2992,18720,0); -- Coral Cap (2992 / 18720)
INSERT INTO `guild_item_points` VALUES (6,13864,7,3150,18720,0); -- Merman's Cap (3150 / 18720)
INSERT INTO `guild_item_points` VALUES (6,13108,7,1560,16320,1); -- Coral Gorget (1560 / 16320)
INSERT INTO `guild_item_points` VALUES (6,13123,7,1690,16320,1); -- Merman's Gorget (1690 / 16320)
INSERT INTO `guild_item_points` VALUES (6,12819,7,4375,19920,2); -- Coral Cuisses (4375 / 19920)
INSERT INTO `guild_item_points` VALUES (6,14230,7,4500,19920,2); -- Coral Cuisses +1 (4500 / 19920)
INSERT INTO `guild_item_points` VALUES (6,12435,7,3000,18720,3); -- Coral Visor (3000 / 18720)
INSERT INTO `guild_item_points` VALUES (6,13859,7,3120,18720,3); -- Coral Visor +1 (3120 / 18720)
INSERT INTO `guild_item_points` VALUES (6,12709,7,6412,21120,4); -- Coral Mittens (6412 / 21120)
INSERT INTO `guild_item_points` VALUES (6,13995,7,7837,21120,4); -- Merman's Mittens (7837 / 21120)
INSERT INTO `guild_item_points` VALUES (6,12508,7,3262,19200,5); -- Coral Hairpin (3262 / 19200)
INSERT INTO `guild_item_points` VALUES (6,13850,7,3375,19200,5); -- Merman's Hairpin (3375 / 19200)
INSERT INTO `guild_item_points` VALUES (6,16422,7,3625,19440,6); -- Tigerfangs (3625 / 19440)
INSERT INTO `guild_item_points` VALUES (6,17490,7,3770,19440,6); -- Feral Fangs (3770 / 19440)
INSERT INTO `guild_item_points` VALUES (6,16525,7,3840,19680,7); -- Hornet Fleuret (3840 / 19680)
INSERT INTO `guild_item_points` VALUES (6,17634,7,3960,19680,7); -- Hornet Fleuret +1 (3960 / 19680)

-- Bonecraft / Adept
INSERT INTO `guild_item_points` VALUES (6,12436,8,7840,21600,0); -- Dragon Mask (7840 / 21600)
INSERT INTO `guild_item_points` VALUES (6,13860,8,8120,21600,0); -- Dragon Mask +1 (8120 / 21600)
INSERT INTO `guild_item_points` VALUES (6,13987,8,3600,19440,1); -- Coral Bangles (3600 / 19440)
INSERT INTO `guild_item_points` VALUES (6,13988,8,4162,19440,1); -- Merman's Bangles (4162 / 19440)
INSERT INTO `guild_item_points` VALUES (6,12820,8,9487,21840,2); -- Dragon Cuisses (9487 / 21840)
INSERT INTO `guild_item_points` VALUES (6,14231,8,9762,21840,2); -- Dragon Cuisses +1 (9762 / 21840)
INSERT INTO `guild_item_points` VALUES (6,12948,8,6090,20880,3); -- Dragon Greaves (6090 / 20880)
INSERT INTO `guild_item_points` VALUES (6,14107,8,7200,20880,3); -- Dragon Greaves +1 (7200 / 20880)
INSERT INTO `guild_item_points` VALUES (6,12692,8,6900,21360,4); -- Dragon Finger Gauntlets (6900 / 21360)
INSERT INTO `guild_item_points` VALUES (6,13991,8,7200,21360,4); -- Dragon Finger Gauntlets +1 (7200 / 21360)
INSERT INTO `guild_item_points` VALUES (6,13312,8,3750,19680,5); -- Coral Earring (3750 / 19680)
INSERT INTO `guild_item_points` VALUES (6,13406,8,5250,19680,5); -- Merman's Earring (5250 / 19680)
INSERT INTO `guild_item_points` VALUES (6,16548,8,16280,22800,6); -- Coral Sword (16280 / 22800)
INSERT INTO `guild_item_points` VALUES (6,16620,8,16280,22800,6); -- Merman's Sword (16280 / 22800)
INSERT INTO `guild_item_points` VALUES (6,12308,8,5400,20640,7); -- Darksteel Shield (5400 / 20640)
INSERT INTO `guild_item_points` VALUES (6,12346,8,6525,20640,7); -- Darksteel Shield +1 (6525 / 20640)

-- Bonecraft / Veteran
INSERT INTO `guild_item_points` VALUES (6,12693,9,2000,17520,0); -- Gavial Finger Gauntlets (2000 / 17520)
INSERT INTO `guild_item_points` VALUES (6,14829,9,2625,17520,0); -- Gavial Finger Gauntlets +1 (2625 / 17520)
INSERT INTO `guild_item_points` VALUES (6,12751,9,5940,20880,1); -- Scorpion Gauntlets (5940 / 20880)
INSERT INTO `guild_item_points` VALUES (6,12717,9,7040,20880,1); -- Scorpion Gauntlets +1 (7040 / 20880)
INSERT INTO `guild_item_points` VALUES (6,14008,9,5850,20880,2); -- Carapace Gauntlets (5850 / 20880)
INSERT INTO `guild_item_points` VALUES (6,14009,9,6825,20880,2); -- Carapace Gauntlets +1 (6825 / 20880)
INSERT INTO `guild_item_points` VALUES (6,13846,9,6490,21120,3); -- Scorpion Helm (6490 / 21120)
INSERT INTO `guild_item_points` VALUES (6,12461,9,7590,21120,3); -- Scorpion Helm +1 (7590 / 21120)
INSERT INTO `guild_item_points` VALUES (6,13878,9,6337,21120,4); -- Carapace Helm (6337 / 21120)
INSERT INTO `guild_item_points` VALUES (6,13879,9,7312,21120,4); -- Carapace Helm +1 (7312 / 21120)
INSERT INTO `guild_item_points` VALUES (6,13789,9,13455,22560,5); -- Carapace Breastplate (13455 / 22560)
INSERT INTO `guild_item_points` VALUES (6,13790,9,14430,22560,5); -- Carapace Breastplate +1 (14430 / 22560)
INSERT INTO `guild_item_points` VALUES (6,12621,9,13860,22560,6); -- Scorpion Breastplate (13860 / 22560)
INSERT INTO `guild_item_points` VALUES (6,12589,9,14960,22560,6); -- Scorpion Breastplate +1 (14960 / 22560)
INSERT INTO `guild_item_points` VALUES (6,13922,9,3570,19440,7); -- Demon Helm (3570 / 19440)
INSERT INTO `guild_item_points` VALUES (6,13923,9,4845,19440,7); -- Demon Helm +1 (4845 / 19440)

-- Alchemy / Amateur
INSERT INTO `guild_item_points` VALUES (7,4166,0,80,4560,0); -- Deodorizer (80 / 4560)
INSERT INTO `guild_item_points` VALUES (7,13683,0,210,6480,1); -- Water Tank (210 / 6480)
INSERT INTO `guild_item_points` VALUES (7,4148,0,79,4560,2); -- Antidote (79 / 4560)
INSERT INTO `guild_item_points` VALUES (7,1164,0,10,3360,3); -- Tsurara (10 / 3360)
INSERT INTO `guild_item_points` VALUES (7,913,0,30,3840,4); -- Beeswax (30 / 3840)
INSERT INTO `guild_item_points` VALUES (7,4162,0,150,5760,5); -- Silencing Potion (150 / 5760)
INSERT INTO `guild_item_points` VALUES (7,4166,0,80,4560,6); -- Deodorizer (80 / 4560)
INSERT INTO `guild_item_points` VALUES (7,4148,0,79,4560,7); -- Antidote (79 / 4560)

-- Alchemy / Recruit
INSERT INTO `guild_item_points` VALUES (7,16429,1,825,12240,0); -- Silence Baghnakhs (825 / 12240)
INSERT INTO `guild_item_points` VALUES (7,16438,1,825,12240,0); -- Silence Baghnakhs +1 (825 / 12240)
INSERT INTO `guild_item_points` VALUES (7,4157,1,100,5760,1); -- Poison Potion (100 / 5760)
INSERT INTO `guild_item_points` VALUES (7,16495,1,406,9120,2); -- Silence Dagger (406 / 9120)
INSERT INTO `guild_item_points` VALUES (7,16508,1,406,9120,2); -- Silence Dagger +1 (406 / 9120)
INSERT INTO `guild_item_points` VALUES (7,914,1,300,8160,3); -- Mercury (300 / 8160)
INSERT INTO `guild_item_points` VALUES (7,16572,1,705,11520,4); -- Bee Spatha (705 / 11520)
INSERT INTO `guild_item_points` VALUES (7,16611,1,775,11520,4); -- Bee Spatha +1 (775 / 11520)
INSERT INTO `guild_item_points` VALUES (7,2109,1,100,5760,5); -- Bittern (100 / 5760)
INSERT INTO `guild_item_points` VALUES (7,4151,1,200,6960,6); -- Echo Drops (200 / 6960)
INSERT INTO `guild_item_points` VALUES (7,16495,1,406,9120,7); -- Silence Dagger (406 / 9120)
INSERT INTO `guild_item_points` VALUES (7,16508,1,406,9120,7); -- Silence Dagger +1 (406 / 9120)

-- Alchemy / Initiate
INSERT INTO `guild_item_points` VALUES (7,16496,2,959,13200,0); -- Poison Dagger (959 / 13200)
INSERT INTO `guild_item_points` VALUES (7,16741,2,1142,13200,0); -- Poison Dagger +1 (1142 / 13200)
INSERT INTO `guild_item_points` VALUES (7,16906,2,894,12960,1); -- Mokuto (894 / 12960)
INSERT INTO `guild_item_points` VALUES (7,16925,2,902,12960,1); -- Mokuto +1 (902 / 12960)
INSERT INTO `guild_item_points` VALUES (7,16472,2,1226,14400,2); -- Poison Knife (1226 / 14400)
INSERT INTO `guild_item_points` VALUES (7,16742,2,1453,14400,2); -- Poison Knife +1 (1453 / 14400)
INSERT INTO `guild_item_points` VALUES (7,4165,2,300,8640,3); -- Silent Oil (300 / 8640)
INSERT INTO `guild_item_points` VALUES (7,16906,2,894,12960,4); -- Mokuto (894 / 12960)
INSERT INTO `guild_item_points` VALUES (7,16925,2,902,12960,4); -- Mokuto +1 (902 / 12960)
INSERT INTO `guild_item_points` VALUES (7,16458,2,330,8800,5); -- Poison Baselard (330 / 8800)
INSERT INTO `guild_item_points` VALUES (7,16743,2,457,8800,5); -- Python Baselard (457 / 8800)
INSERT INTO `guild_item_points` VALUES (7,4150,2,519,10560,6); -- Eye Drops (519 / 10560)
INSERT INTO `guild_item_points` VALUES (7,16496,2,959,13200,7); -- Poison Dagger (959 / 13200)
INSERT INTO `guild_item_points` VALUES (7,16741,2,1142,13200,7); -- Poison Dagger +1 (1142 / 13200)

-- Alchemy / Novice
INSERT INTO `guild_item_points` VALUES (7,16410,3,638,11760,0); -- Poison Baghnakhs (638 / 11760)
INSERT INTO `guild_item_points` VALUES (7,16692,3,748,11760,0); -- Poison Baghnakhs +1 (748 / 11760)
INSERT INTO `guild_item_points` VALUES (7,16417,3,2400,17520,1); -- Poison Claws (2400 / 17520)
INSERT INTO `guild_item_points` VALUES (7,16439,3,2400,17520,1); -- Poison Claws +1 (2400 / 17520)
INSERT INTO `guild_item_points` VALUES (7,16454,3,100,6960,2); -- Blind Dagger (100 / 6960)
INSERT INTO `guild_item_points` VALUES (7,16493,3,120,6960,2); -- Blind Dagger +1 (120 / 6960)
INSERT INTO `guild_item_points` VALUES (7,16471,3,135,7440,3); -- Blind Knife (135 / 7440)
INSERT INTO `guild_item_points` VALUES (7,16490,3,161,7440,3); -- Blind Knife +1 (161 / 7440)
INSERT INTO `guild_item_points` VALUES (7,16907,3,1200,14400,4); -- Busuto (1200 / 14400)
INSERT INTO `guild_item_points` VALUES (7,16927,3,1230,14400,4); -- Busuto +1 (1230 / 14400)
INSERT INTO `guild_item_points` VALUES (7,16387,3,992,13680,5); -- Poison Cesti (992 / 13680)
INSERT INTO `guild_item_points` VALUES (7,16700,3,1312,13680,5); -- Poison Cesti +1 (1312 / 13680)
INSERT INTO `guild_item_points` VALUES (7,16594,3,3488,19200,6); -- Inferno Sword (3488 / 19200)
INSERT INTO `guild_item_points` VALUES (7,16928,3,3488,19200,6); -- Hellfire Sword (3488 / 19200)
INSERT INTO `guild_item_points` VALUES (7,16478,3,1620,15840,7); -- Poison Kukri (1620 / 15840)
INSERT INTO `guild_item_points` VALUES (7,16489,3,1620,15840,7); -- Poison Kukri +1 (1620 / 15840)

-- Alchemy / Apprentice
INSERT INTO `guild_item_points` VALUES (7,16543,4,1320,15120,0); -- Fire Sword (1320 / 15120)
INSERT INTO `guild_item_points` VALUES (7,16621,4,1320,15120,0); -- Flame Sword (1320 / 15120)
INSERT INTO `guild_item_points` VALUES (7,16501,4,2480,17760,1); -- Acid Knife (2480 / 17760)
INSERT INTO `guild_item_points` VALUES (7,17608,4,2880,17760,1); -- Corrosive Knife (2880 / 17760)
INSERT INTO `guild_item_points` VALUES (7,16905,4,1240,14880,2); -- Bokuto (1240 / 14880)
INSERT INTO `guild_item_points` VALUES (7,16926,4,1426,14880,2); -- Bokuto +1 (1426 / 14880)
INSERT INTO `guild_item_points` VALUES (7,17605,4,1717,16320,3); -- Acid Dagger (1717 / 16320)
INSERT INTO `guild_item_points` VALUES (7,17606,4,2003,16320,3); -- Corrosive Dagger (2003 / 16320)
INSERT INTO `guild_item_points` VALUES (7,16403,4,2464,17760,4); -- Poison Katars (2464 / 17760)
INSERT INTO `guild_item_points` VALUES (7,16693,4,3024,17760,4); -- Poison Katars +1 (3024 / 17760)
INSERT INTO `guild_item_points` VALUES (7,16588,4,979,13920,5); -- Flame Claymore (979 / 13920)
INSERT INTO `guild_item_points` VALUES (7,16929,4,979,13920,5); -- Burning Claymore (979 / 13920)
INSERT INTO `guild_item_points` VALUES (7,13684,4,210,8640,6); -- Potion Tank (210 / 8640)
INSERT INTO `guild_item_points` VALUES (7,16709,4,349,10080,7); -- Inferno Axe (349 / 10080)
INSERT INTO `guild_item_points` VALUES (7,16713,4,380,10080,7); -- Hellfire Axe (380 / 10080)

-- Alchemy / Journeyman
INSERT INTO `guild_item_points` VALUES (7,16908,5,1200,14880,0); -- Yoto (1200 / 14880)
INSERT INTO `guild_item_points` VALUES (7,17768,5,1350,14880,0); -- Yoto +1 (1350 / 14880)
INSERT INTO `guild_item_points` VALUES (7,16523,5,5600,20640,1); -- Holy Degen (5600 / 20640)
INSERT INTO `guild_item_points` VALUES (7,16817,5,6300,20640,1); -- Holy Degen +1 (6300 / 20640)
INSERT INTO `guild_item_points` VALUES (7,16430,5,2976,18720,2); -- Acid Claws (2976 / 18720)
INSERT INTO `guild_item_points` VALUES (7,17487,5,3596,18720,2); -- Corrosive Claws (3596 / 18720)
INSERT INTO `guild_item_points` VALUES (7,17041,5,3102,18270,3); -- Holy Mace (3102 / 18270)
INSERT INTO `guild_item_points` VALUES (7,17411,5,3762,18270,3); -- Holy Mace +1 (3762 / 18270)
INSERT INTO `guild_item_points` VALUES (7,16581,5,4300,19920,4); -- Holy Sword (4300 / 19920)
INSERT INTO `guild_item_points` VALUES (7,16816,5,4800,19920,4); -- Holy Sword +1 (4800 / 19920)
INSERT INTO `guild_item_points` VALUES (7,16973,5,2300,17520,5); -- Homura (2300 / 17520)
INSERT INTO `guild_item_points` VALUES (7,16986,5,2392,17520,5); -- Homura +1 (2392 / 17520)
INSERT INTO `guild_item_points` VALUES (7,16973,5,2300,17520,6); -- Homura (2300 / 17520)
INSERT INTO `guild_item_points` VALUES (7,16986,5,2392,17520,6); -- Homura +1 (2392 / 17520)
INSERT INTO `guild_item_points` VALUES (7,13682,5,210,9120,7); -- Ether Tank (210 / 9120)

-- Alchemy / Craftsman
INSERT INTO `guild_item_points` VALUES (7,16479,6,2944,18720,0); -- Acid Kukri (2944 / 18720)
INSERT INTO `guild_item_points` VALUES (7,16494,6,3404,18720,0); -- Corrosive Kukri (3404 / 18720)
INSERT INTO `guild_item_points` VALUES (7,16539,6,9460,21840,1); -- Cermet Sword (9460 / 21840)
INSERT INTO `guild_item_points` VALUES (7,16825,6,10560,21840,1); -- Cermet Sword +1 (10560 / 21840)
INSERT INTO `guild_item_points` VALUES (7,16414,6,5280,20640,2); -- Cermet Claws (5280 / 20640)
INSERT INTO `guild_item_points` VALUES (7,17488,6,6380,20640,2); -- Cermet Claws +1 (6380 / 20640)
INSERT INTO `guild_item_points` VALUES (7,16554,6,10185,22080,3); -- Hanger (10185 / 22080)
INSERT INTO `guild_item_points` VALUES (7,17642,6,11235,22080,3); -- Hanger +1 (11235 / 22080)
INSERT INTO `guild_item_points` VALUES (7,16549,6,4928,20400,4); -- Divine Sword (4928 / 20400)
INSERT INTO `guild_item_points` VALUES (7,16826,6,5488,20400,4); -- Divine Sword +1 (5488 / 20400)
INSERT INTO `guild_item_points` VALUES (7,16459,6,3720,19440,5); -- Acid Baselard (3720 / 19440)
INSERT INTO `guild_item_points` VALUES (7,17607,6,4320,19440,5); -- Corrosive Baselard (4320 / 19440)
INSERT INTO `guild_item_points` VALUES (7,16568,6,8200,22080,6); -- Saber (8200 / 22080)
INSERT INTO `guild_item_points` VALUES (7,16612,6,11275,22080,6); -- Saber +1 (11275 / 22080)
INSERT INTO `guild_item_points` VALUES (7,16469,6,5850,20800,7); -- Cermet Knife (5850 / 20800)
INSERT INTO `guild_item_points` VALUES (7,17609,6,6975,20800,7); -- Cermet Knife +1 (6975 / 20800)

-- Alchemy / Artisan
INSERT INTO `guild_item_points` VALUES (7,16477,7,8910,21840,0); -- Cermet Kukri (8910 / 21840)
INSERT INTO `guild_item_points` VALUES (7,17603,7,9075,21840,0); -- Cermet Kukri +1 (9075 / 21840)
INSERT INTO `guild_item_points` VALUES (7,16401,7,6710,21120,1); -- Jamadhars (6710 / 21120)
INSERT INTO `guild_item_points` VALUES (7,17482,7,6862,21120,1); -- Jamadhars +1 (6862 / 21120)
INSERT INTO `guild_item_points` VALUES (7,16418,7,5040,20400,2); -- Venom Claws (5040 / 20400)
INSERT INTO `guild_item_points` VALUES (7,16425,7,5040,20400,2); -- Venom Claws +1 (5040 / 20400)
INSERT INTO `guild_item_points` VALUES (7,16505,7,7290,21360,3); -- Venom Kukri (7290 / 21360)
INSERT INTO `guild_item_points` VALUES (7,17604,7,7425,21360,3); -- Venom Kukri +1 (7425 / 21360)
INSERT INTO `guild_item_points` VALUES (7,16560,7,12250,22320,4); -- Cutlass (12250 / 22320)
INSERT INTO `guild_item_points` VALUES (7,17639,7,12372,22320,4); -- Cutlass +1 (12372 / 22320)
INSERT INTO `guild_item_points` VALUES (7,16507,7,6370,21120,5); -- Venom Baselard (6370 / 21120)
INSERT INTO `guild_item_points` VALUES (7,16510,7,6370,21120,5); -- Venom Baselard +1 (6370 / 21120)
INSERT INTO `guild_item_points` VALUES (7,16503,7,8450,21600,6); -- Stun Knife (8450 / 21600)
INSERT INTO `guild_item_points` VALUES (7,17600,7,8612,21600,6); -- Stun Knife +1 (8612 / 21600)
INSERT INTO `guild_item_points` VALUES (7,17080,7,3192,18960,7); -- Holy Maul (3192 / 18960)
INSERT INTO `guild_item_points` VALUES (7,17114,7,3752,18960,7); -- Holy Maul +1 (3752 / 18960)

-- Alchemy / Adept
INSERT INTO `guild_item_points` VALUES (7,16499,8,5670,20880,0); -- Venom Kris (5670 / 20880)
INSERT INTO `guild_item_points` VALUES (7,16761,8,6195,20880,0); -- Venom Kris +1 (6195 / 20880)
INSERT INTO `guild_item_points` VALUES (7,16609,8,12375,22320,1); -- Bloody Sword (12375 / 22320)
INSERT INTO `guild_item_points` VALUES (7,17646,8,13062,22320,1); -- Carnage Sword (13062 / 22320)
INSERT INTO `guild_item_points` VALUES (7,16431,8,6480,21120,2); -- Stun Claws (6480 / 21120)
INSERT INTO `guild_item_points` VALUES (7,17486,8,6615,21120,2); -- Stun Claws +1 (6615 / 21120)
INSERT INTO `guild_item_points` VALUES (7,16506,8,9585,22080,3); -- Stun Kukri (9585 / 22080)
INSERT INTO `guild_item_points` VALUES (7,17614,8,9762,22080,3); -- Stun Kukri +1 (9762 / 22080)
INSERT INTO `guild_item_points` VALUES (7,16860,8,3150,18960,4); -- Holy Lance (3150 / 18960)
INSERT INTO `guild_item_points` VALUES (7,16880,8,4275,18960,4); -- Holy Lance +1 (4275 / 18960)
INSERT INTO `guild_item_points` VALUES (7,16528,8,7600,21600,5); -- Bloody Rapier (7600 / 21600)
INSERT INTO `guild_item_points` VALUES (7,16824,8,8550,21600,5); -- Carnage Rapier (8550 / 21600)
INSERT INTO `guild_item_points` VALUES (7,16432,8,7370,21360,6); -- Stun Jamadhars (7370 / 21360)
INSERT INTO `guild_item_points` VALUES (7,17484,8,7537,21360,6); -- Stun Jamadhars +1 (7537 / 21360)
INSERT INTO `guild_item_points` VALUES (7,17085,8,3060,18960,7); -- Holy Wand (3060 / 18960)
INSERT INTO `guild_item_points` VALUES (7,17434,8,3240,18960,7); -- Holy Wand +1 (3240 / 18960)

-- Alchemy / Veteran
INSERT INTO `guild_item_points` VALUES (7,4209,9,900,14400,0); -- Mind Potion (900 / 14400)
INSERT INTO `guild_item_points` VALUES (7,4211,9,750,13920,1); -- Charisma Potion (750 / 13920)
INSERT INTO `guild_item_points` VALUES (7,4201,9,900,14400,2); -- Dexterity Potion (900 / 14400)
INSERT INTO `guild_item_points` VALUES (7,4207,9,840,14400,3); -- Intelligence Potion (840 / 14400)
INSERT INTO `guild_item_points` VALUES (7,4203,9,750,13920,4); -- Vitality Potion (750 / 13920)
INSERT INTO `guild_item_points` VALUES (7,4205,9,810,14160,5); -- Agility Potion (810 / 14160)
INSERT INTO `guild_item_points` VALUES (7,12305,9,5565,20880,6); -- Ice Shield (5565 / 20880)
INSERT INTO `guild_item_points` VALUES (7,12357,9,6890,20880,6); -- Ice Shield +1 (6890 / 20880)
INSERT INTO `guild_item_points` VALUES (7,4199,9,900,14400,7); -- Strength Potion (900 / 14400)

-- Cooking / Amateur
INSERT INTO `guild_item_points` VALUES (8,17016,0,4,3360,0); -- Pet Food Alpha (4 / 3360)
INSERT INTO `guild_item_points` VALUES (8,4415,0,46,4080,1); -- Roasted Corn (46 / 4080)
INSERT INTO `guild_item_points` VALUES (8,4334,0,55,4080,1); -- Grilled Corn (55 / 4080)
INSERT INTO `guild_item_points` VALUES (8,4422,0,75,4560,2); -- Orange Juice (75 / 4560)
INSERT INTO `guild_item_points` VALUES (8,4535,0,150,5760,3); -- Boiled Crayfish (150 / 5760)
INSERT INTO `guild_item_points` VALUES (8,4338,0,180,5760,3); -- Steamed Crayfish (180 / 5760)
INSERT INTO `guild_item_points` VALUES (8,4422,0,75,4560,4); -- Orange Juice (75 / 4560)
INSERT INTO `guild_item_points` VALUES (8,4355,0,417,8880,5); -- Salmon Sub (417 / 8880)
INSERT INTO `guild_item_points` VALUES (8,4266,0,432,8880,5); -- Fulm-long Salmon Sub (432 / 8880)
INSERT INTO `guild_item_points` VALUES (8,4355,0,417,8880,6); -- Salmon Sub (417 / 8880)
INSERT INTO `guild_item_points` VALUES (8,4266,0,432,8880,6); -- Fulm-long Salmon Sub (432 / 8880)
INSERT INTO `guild_item_points` VALUES (8,4415,0,46,4080,7); -- Roasted Corn (46 / 4080)
INSERT INTO `guild_item_points` VALUES (8,4334,0,55,4080,7); -- Grilled Corn (55 / 4080)

-- Cooking / Recruit
INSERT INTO `guild_item_points` VALUES (8,4437,1,270,7680,0); -- Roast Mutton (270 / 7680)
INSERT INTO `guild_item_points` VALUES (8,4335,1,300,7680,0); -- Juicy Mutton (300 / 7680)
INSERT INTO `guild_item_points` VALUES (8,4416,1,420,9360,1); -- Pea Soup (420 / 9360)
INSERT INTO `guild_item_points` VALUES (8,4327,1,541,9360,1); -- Emerald Soup (541 / 9360)
INSERT INTO `guild_item_points` VALUES (8,4437,1,270,7680,2); -- Roast Mutton (270 / 7680)
INSERT INTO `guild_item_points` VALUES (8,4335,1,300,7680,2); -- Juicy Mutton (300 / 7680)
INSERT INTO `guild_item_points` VALUES (8,4408,1,52,5040,3); -- Tortilla (52 / 5040)
INSERT INTO `guild_item_points` VALUES (8,5181,1,78,5040,3); -- Tortilla Buena (78 / 5040)
INSERT INTO `guild_item_points` VALUES (8,4416,1,420,9360,4); -- Pea Soup (420 / 9360)
INSERT INTO `guild_item_points` VALUES (8,4327,1,541,9360,4); -- Emerald Soup (541 / 9360)
INSERT INTO `guild_item_points` VALUES (8,4537,1,195,6960,5); -- Roast Carp (195 / 6960)
INSERT INTO `guild_item_points` VALUES (8,4586,1,240,6960,5); -- Broiled Carp (240 / 6960)
INSERT INTO `guild_item_points` VALUES (8,4537,1,195,6960,6); -- Roast Carp (195 / 6960)
INSERT INTO `guild_item_points` VALUES (8,4586,1,240,6960,6); -- Broiled Carp (240 / 6960)
INSERT INTO `guild_item_points` VALUES (8,4408,1,52,5040,7); -- Tortilla (52 / 5040)
INSERT INTO `guild_item_points` VALUES (8,5181,1,78,5040,7); -- Tortilla Buena (78 / 5040)

-- Cooking / Initiate
INSERT INTO `guild_item_points` VALUES (8,4380,2,82,6000,0); -- Smoked Salmon (82 / 6000)
INSERT INTO `guild_item_points` VALUES (8,4438,2,540,10800,1); -- Dhalmel Steak (540 / 10800)
INSERT INTO `guild_item_points` VALUES (8,4519,2,585,10800,1); -- Wild Steak (585 / 10800)
INSERT INTO `guild_item_points` VALUES (8,4492,2,225,7920,2); -- Puls (225 / 7920)
INSERT INTO `guild_item_points` VALUES (8,4533,2,450,7920,2); -- Delicious Puls (450 / 7920)
INSERT INTO `guild_item_points` VALUES (8,4406,2,165,7200,3); -- Baked Apple (165 / 7200)
INSERT INTO `guild_item_points` VALUES (8,4336,2,195,7200,3); -- Sweet Baked Apple (195 / 7200)
INSERT INTO `guild_item_points` VALUES (8,4560,2,376,9360,4); -- Vegetable Soup (376 / 9360)
INSERT INTO `guild_item_points` VALUES (8,4323,2,664,9360,4); -- Vegetable Broth (664 / 9360)
INSERT INTO `guild_item_points` VALUES (8,4376,2,45,5520,5); -- Meat Jerky (45 / 5520)
INSERT INTO `guild_item_points` VALUES (8,4518,2,63,5520,5); -- Sheep Jerky (63 / 5520)
INSERT INTO `guild_item_points` VALUES (8,4456,2,675,11760,6); -- Boiled Crab (675 / 11760)
INSERT INTO `guild_item_points` VALUES (8,4342,2,825,11760,6); -- Steamed Crab (825 / 11760)
INSERT INTO `guild_item_points` VALUES (8,4436,2,120,6720,7); -- Baked Popoto (120 / 6720)
INSERT INTO `guild_item_points` VALUES (8,4282,2,127,6720,7); -- Pipin' Hot Popoto (127 / 6720)

-- Cooking / Novice
INSERT INTO `guild_item_points` VALUES (8,4419,3,1500,15600,0); -- Mushroom Soup (1500 / 15600)
INSERT INTO `guild_item_points` VALUES (8,4333,3,1740,15600,0); -- Witch Soup (1740 / 15600)
INSERT INTO `guild_item_points` VALUES (8,4555,3,558,11280,1); -- Windurst Salad (558 / 11280)
INSERT INTO `guild_item_points` VALUES (8,4321,3,613,11280,1); -- Timbre Timbers Salad (613 / 11280)
INSERT INTO `guild_item_points` VALUES (8,4510,3,9,5760,2); -- Acorn Cookie (9 / 5760)
INSERT INTO `guild_item_points` VALUES (8,4577,3,10,5760,2); -- Wild Cookie (10 / 5760)
INSERT INTO `guild_item_points` VALUES (8,4499,3,37,6240,3); -- Iron Bread (37 / 6240)
INSERT INTO `guild_item_points` VALUES (8,4573,3,114,6240,3); -- Steel Bread (114 / 6240)
INSERT INTO `guild_item_points` VALUES (8,4459,3,450,10320,4); -- Nebimonite Bake (450 / 10320)
INSERT INTO `guild_item_points` VALUES (8,4267,3,675,10320,4); -- Buttered Nebimonite (675 / 10320)
INSERT INTO `guild_item_points` VALUES (8,4364,3,45,6240,5); -- Black Bread (45 / 6240)
INSERT INTO `guild_item_points` VALUES (8,4591,3,60,6240,5); -- Pumpernickel (60 / 6240)
INSERT INTO `guild_item_points` VALUES (8,5196,3,252,8640,6); -- Buffalo Jerky (252 / 8640)
INSERT INTO `guild_item_points` VALUES (8,5207,3,567,8640,6); -- Bison Jerky (567 / 8640)
INSERT INTO `guild_item_points` VALUES (8,4404,3,225,8400,7); -- Roast Trout (225 / 8400)
INSERT INTO `guild_item_points` VALUES (8,4587,3,247,8400,7); -- Broiled Trout (247 / 8400)

-- Cooking / Apprentice
INSERT INTO `guild_item_points` VALUES (8,4420,4,441,10800,0); -- Tomato Soup (441 / 10800)
INSERT INTO `guild_item_points` VALUES (8,4341,4,1341,10800,0); -- Tomato Soup (1341 / 10800)
INSERT INTO `guild_item_points` VALUES (8,4413,4,120,7680,1); -- Apple Pie (120 / 7680)
INSERT INTO `guild_item_points` VALUES (8,4320,4,132,7680,1); -- Apple Pie +1 (132 / 7680)
INSERT INTO `guild_item_points` VALUES (8,4413,4,120,7680,2); -- Apple Pie (120 / 7680)
INSERT INTO `guild_item_points` VALUES (8,4320,4,132,7680,2); -- Apple Pie +1 (132 / 7680)
INSERT INTO `guild_item_points` VALUES (8,4398,4,270,9360,3); -- Fish Mithkabob (270 / 9360)
INSERT INTO `guild_item_points` VALUES (8,4575,4,306,9360,3); -- Fish Chiefkabob (306 / 9360)
INSERT INTO `guild_item_points` VALUES (8,4490,4,180,8400,4); -- Pickled Herring (180 / 8400)
INSERT INTO `guild_item_points` VALUES (8,5183,4,270,8400,4); -- Viking Herring (270 / 8400)
INSERT INTO `guild_item_points` VALUES (8,4490,4,180,8400,5); -- Pickled Herring (180 / 8400)
INSERT INTO `guild_item_points` VALUES (8,5183,4,270,8400,5); -- Viking Herring (270 / 8400)
INSERT INTO `guild_item_points` VALUES (8,4397,4,6,6480,6); -- Cinna-cookie (6 / 6480)
INSERT INTO `guild_item_points` VALUES (8,4520,4,7,6480,6); -- Coin Cookie (7 / 6480)
INSERT INTO `guild_item_points` VALUES (8,5750,4,558,11520,7); -- Goulash (558 / 11520)
INSERT INTO `guild_item_points` VALUES (8,5751,4,613,11520,7); -- Goulash +1 (613 / 11520)

-- Cooking / Journeyman
INSERT INTO `guild_item_points` VALUES (8,4572,5,247,9600,0); -- Beaugreen Saute (247 / 9600)
INSERT INTO `guild_item_points` VALUES (8,4293,5,865,9600,0); -- Monastic Saute (865 / 9600)
INSERT INTO `guild_item_points` VALUES (8,4563,5,384,10560,1); -- Pamama Tart (384 / 10560)
INSERT INTO `guild_item_points` VALUES (8,4287,5,918,10560,1); -- Opo-opo Tart (918 / 10560)
INSERT INTO `guild_item_points` VALUES (8,5168,5,184,8880,2); -- Bataquiche (184 / 8880)
INSERT INTO `guild_item_points` VALUES (8,5169,5,276,8880,2); -- Bataquiche +1 (276 / 8880)
INSERT INTO `guild_item_points` VALUES (8,4417,5,450,11040,3); -- Egg Soup (450 / 11040)
INSERT INTO `guild_item_points` VALUES (8,4521,5,525,11040,3); -- Humpty Soup (525 / 11040)
INSERT INTO `guild_item_points` VALUES (8,5598,5,600,12000,4); -- Sis Kebabi (600 / 12000)
INSERT INTO `guild_item_points` VALUES (8,5599,5,750,12000,4); -- Sis Kebabi +1 (750 / 12000)
INSERT INTO `guild_item_points` VALUES (8,4457,5,750,12960,5); -- Eel Kabob (750 / 12960)
INSERT INTO `guild_item_points` VALUES (8,4588,5,825,12960,5); -- Broiled Eel (825 / 12960)
INSERT INTO `guild_item_points` VALUES (8,5598,5,600,12000,6); -- Sis Kebabi (600 / 12000)
INSERT INTO `guild_item_points` VALUES (8,5599,5,750,12000,6); -- Sis Kebabi +1 (750 / 12000)
INSERT INTO `guild_item_points` VALUES (8,4391,5,9,7200,7); -- Bretzel (9 / 7200)
INSERT INTO `guild_item_points` VALUES (8,5182,5,13,7200,7); -- Salty Bretzel (13 / 7200)

-- Cooking / Craftsman
INSERT INTO `guild_item_points` VALUES (8,4546,6,525,12000,0); -- Raisin Bread (525 / 12000)
INSERT INTO `guild_item_points` VALUES (8,5148,6,451,11520,1); -- Squid Sushi (451 / 11520)
INSERT INTO `guild_item_points` VALUES (8,5162,6,483,11520,1); -- Squid Sushi +1 (483 / 11520)
INSERT INTO `guild_item_points` VALUES (8,5572,6,622,12480,2); -- Irmik Helvasi (622 / 12480)
INSERT INTO `guild_item_points` VALUES (8,5573,6,661,12480,2); -- Irmik Helvasi +1 (661 / 12480)
INSERT INTO `guild_item_points` VALUES (8,4559,6,534,12000,3); -- Herb Quus (534 / 12000)
INSERT INTO `guild_item_points` VALUES (8,4294,6,879,12000,3); -- Herb Quus +1 (879 / 12000)
INSERT INTO `guild_item_points` VALUES (8,4433,6,778,13440,4); -- Dhalmel Stew (778 / 13440)
INSERT INTO `guild_item_points` VALUES (8,4589,6,855,13440,4); -- Wild Stew (855 / 13440)
INSERT INTO `guild_item_points` VALUES (8,4487,6,156,9120,5); -- Colored Egg (156 / 9120)
INSERT INTO `guild_item_points` VALUES (8,4595,6,345,9120,5); -- Party Egg (345 / 9120)
INSERT INTO `guild_item_points` VALUES (8,4506,6,607,12480,6); -- Mutton Tortilla (607 / 12480)
INSERT INTO `guild_item_points` VALUES (8,4348,6,880,12480,6); -- Mutton Tortilla +1 (880 / 12480)
INSERT INTO `guild_item_points` VALUES (8,5600,6,900,13920,7); -- Balik Sis (900 / 13920)
INSERT INTO `guild_item_points` VALUES (8,5601,6,975,13920,7); -- Balik Sis +1 (975 / 13920)

-- Cooking / Artisan
INSERT INTO `guild_item_points` VALUES (8,4547,7,693,13200,0); -- Boiled Cockatrice (693 / 13200)
INSERT INTO `guild_item_points` VALUES (8,4552,7,637,12960,1); -- Herb Crawler Eggs (637 / 12960)
INSERT INTO `guild_item_points` VALUES (8,4583,7,382,11280,2); -- Salmon Meuniere (382 / 11280)
INSERT INTO `guild_item_points` VALUES (8,4347,7,382,11280,2); -- Salmon Meuniere +1 (382 / 11280)
INSERT INTO `guild_item_points` VALUES (8,4440,7,618,12720,3); -- Whitefish Stew (618 / 12720)
INSERT INTO `guild_item_points` VALUES (8,4498,7,427,11760,4); -- Chocomilk (427 / 11760)
INSERT INTO `guild_item_points` VALUES (8,4283,7,1495,11760,4); -- Choco-delight (1495 / 11760)
INSERT INTO `guild_item_points` VALUES (8,4507,7,480,12000,5); -- Rarab Meatball (480 / 12000)
INSERT INTO `guild_item_points` VALUES (8,4349,7,810,12000,5); -- Bunny Ball (810 / 12000)
INSERT INTO `guild_item_points` VALUES (8,4554,7,2106,17520,6); -- Shallops Tropicale (2106 / 17520)
INSERT INTO `guild_item_points` VALUES (8,4418,7,1800,16800,7); -- Turtle Soup (1800 / 16800)
INSERT INTO `guild_item_points` VALUES (8,4337,7,2100,16800,7); -- Stamina Soup (2100 / 16800)

-- Cooking / Adept
INSERT INTO `guild_item_points` VALUES (8,5588,8,675,13440,0); -- Karni Yarik (675 / 13440)
INSERT INTO `guild_item_points` VALUES (8,5589,8,750,13440,0); -- Karni Yarik +1 (750 / 13440)
INSERT INTO `guild_item_points` VALUES (8,4561,8,1980,17280,1); -- Seafood Stew (1980 / 17280)
INSERT INTO `guild_item_points` VALUES (8,5660,8,228,10560,2); -- Pepperoni (228 / 10560)
INSERT INTO `guild_item_points` VALUES (8,4550,8,2208,17760,3); -- Bream Risotto (2208 / 17760)
INSERT INTO `guild_item_points` VALUES (8,4268,8,2688,17760,3); -- Sea Spray Risotto (2688 / 17760)
INSERT INTO `guild_item_points` VALUES (8,4582,8,457,12240,4); -- Bass Meuniere (457 / 12240)
INSERT INTO `guild_item_points` VALUES (8,4346,8,915,12240,4); -- Bass Meuniere +1 (915 / 12240)
INSERT INTO `guild_item_points` VALUES (8,4557,8,783,13920,5); -- Steamed Catfish  (783 / 13920)
INSERT INTO `guild_item_points` VALUES (8,4548,8,924,14400,6); -- Coeurl Sautee (924 / 14400)
INSERT INTO `guild_item_points` VALUES (8,4295,8,1449,14400,6); -- Royal Sautee (1449 / 14400)
INSERT INTO `guild_item_points` VALUES (8,4452,8,1725,16800,7); -- Shark Fin Soup (1725 / 16800)
INSERT INTO `guild_item_points` VALUES (8,4285,8,2100,16800,7); -- Ocean Soup (2100 / 16800)

-- Cooking / Veteran
INSERT INTO `guild_item_points` VALUES (8,5151,9,2550,18240,0); -- Urchin Sushi (2550 / 18240)
INSERT INTO `guild_item_points` VALUES (8,5160,9,3060,18240,0); -- Urchin Sushi +1 (3060 / 18240)
INSERT INTO `guild_item_points` VALUES (8,4271,9,210,10800,1); -- Rice Dumpling (210 / 10800)
INSERT INTO `guild_item_points` VALUES (8,5178,9,661,13440,2); -- Dorado Sushi (661 / 13440)
INSERT INTO `guild_item_points` VALUES (8,5179,9,991,13440,2); -- Dorado Sushi +1 (991 / 13440)
INSERT INTO `guild_item_points` VALUES (8,4353,9,2727,18480,3); -- Sea Bass Croute (2727 / 18480)
INSERT INTO `guild_item_points` VALUES (8,4584,9,2395,18000,4); -- Flounder Meuniere (2395 / 18000)
INSERT INTO `guild_item_points` VALUES (8,4345,9,3195,18000,4); -- Flounder Meuniere +1 (3195 / 18000)
INSERT INTO `guild_item_points` VALUES (8,4542,9,3330,19200,5); -- Brain Stew (3330 / 19200)
INSERT INTO `guild_item_points` VALUES (8,5180,9,4995,19200,5); -- Sophic Stew (4995 / 19200)
INSERT INTO `guild_item_points` VALUES (8,4270,9,147,10320,6); -- Sweet Rice Cake (147 / 10320)
INSERT INTO `guild_item_points` VALUES (8,4551,9,1350,16080,7); -- Salmon Croute (1350 / 16080)