I'll try to put this post together as best I can.
I'll start with a few notes:
I found the missing modelIDs for quite a few items. You can add these to your existing database by executing the commands below in your sql manager of choice. Please note that you may also need to add these to Item_basic as well. I found a few other modelIDs in addition to these, such as the Iaso gear, Khepri, etc. I will add those later when I have some time:
Code: Select all
*Removed these, credit to GalkaSmash for finding all of the modelIDs a few days ago. Much appreciated work.
**Another quick edit: I noticed that some of the modelIDs that I found were indeed actually not on the list (marked with a -- needs mID), so I'll reupload those. First one that I can see is Tessera Saio. I'll upload that right away since I did the mods for it as well. Should now have almost all armor model IDs currently in retail.
INSERT INTO `item_armor` VALUES(10485, 'tessera_saio', 99, 496674, 330, 0, 0, 32, 0);
Code: Select all
//Empyrean Armor +2, Neo-Nyzul, Legion/Provenance Abjuration HQ gear, Tessera Saio
-- Orison
INSERT INTO `item_mods` VALUES(11066, 1, 30);
INSERT INTO `item_mods` VALUES(11066, 5, 50);
INSERT INTO `item_mods` VALUES(11066, 13, 10);
INSERT INTO `item_mods` VALUES(11066, 374, 10);
INSERT INTO `item_mods` VALUES(11086, 1, 49);
INSERT INTO `item_mods` VALUES(11086, 2, 45);
INSERT INTO `item_mods` VALUES(11086, 5, 45);
INSERT INTO `item_mods` VALUES(11086, 112, 20);
INSERT INTO `item_mods` VALUES(11086, 369, 2);
INSERT INTO `item_mods` VALUES(11086, 125, 25);
INSERT INTO `item_mods` VALUES(11106, 1, 22);
INSERT INTO `item_mods` VALUES(11106, 2, 25);
INSERT INTO `item_mods` VALUES(11106, 5, 25);
INSERT INTO `item_mods` VALUES(11106, 27, -8);
INSERT INTO `item_mods` VALUES(11126, 1, 41);
INSERT INTO `item_mods` VALUES(11126, 13, 7);
INSERT INTO `item_mods` VALUES(11146, 1, 18);
INSERT INTO `item_mods` VALUES(11146, 2, 30);
INSERT INTO `item_mods` VALUES(11146, 5, 30);
INSERT INTO `item_mods` VALUES(11146, 13, 8);
INSERT INTO `item_mods` VALUES(11146, 113, 20);
INSERT INTO `item_mods` VALUES(11554, 1, 8);
INSERT INTO `item_mods` VALUES(11554, 5, 10);
INSERT INTO `item_mods` VALUES(11554, 374, 3);
INSERT INTO `item_mods` VALUES(11554, 27, -4);
INSERT INTO `item_mods` VALUES(11705, 374, 2);
INSERT INTO `item_mods` VALUES(11705, 27, -3);
INSERT INTO `item_mods` VALUES(11615, 2, 33);
INSERT INTO `item_mods` VALUES(11615, 5, 33);
INSERT INTO `item_mods` VALUES(11615, 170, 5);
-- Goetia
INSERT INTO `item_mods` VALUES(11067, 1, 29);
INSERT INTO `item_mods` VALUES(11067, 12, 8);
INSERT INTO `item_mods` VALUES(11067, 115, 15);
INSERT INTO `item_mods` VALUES(11067, 27, -6);
INSERT INTO `item_mods` VALUES(11087, 1, 50);
INSERT INTO `item_mods` VALUES(11087, 5, 45);
INSERT INTO `item_mods` VALUES(11087, 30, 11);
INSERT INTO `item_mods` VALUES(11087, 28, 11);
INSERT INTO `item_mods` VALUES(11087, 369, 2);
INSERT INTO `item_mods` VALUES(11127, 1, 41);
INSERT INTO `item_mods` VALUES(11127, 5, 55);
INSERT INTO `item_mods` VALUES(11127, 30, 7);
INSERT INTO `item_mods` VALUES(11127, 28, 7);
INSERT INTO `item_mods` VALUES(11107, 1, 23);
INSERT INTO `item_mods` VALUES(11107, 12, 7);
INSERT INTO `item_mods` VALUES(11107, 28, 8);
INSERT INTO `item_mods` VALUES(11147, 1, 17);
INSERT INTO `item_mods` VALUES(11147, 12, 10);
INSERT INTO `item_mods` VALUES(11147, 116, 15);
INSERT INTO `item_mods` VALUES(11147, 27, -10);
INSERT INTO `item_mods` VALUES(16203, 1, 7);
INSERT INTO `item_mods` VALUES(16203, 5, 10);
INSERT INTO `item_mods` VALUES(16203, 12, 7);
INSERT INTO `item_mods` VALUES(16203, 115, 7);
INSERT INTO `item_mods` VALUES(11706, 30, 3);
INSERT INTO `item_mods` VALUES(11706, 28, 3);
INSERT INTO `item_mods` VALUES(11593, 12, 7);
INSERT INTO `item_mods` VALUES(11593, 30, 4);
-- Estoqueur
INSERT INTO `item_mods` VALUES(11068, 1, 31);
INSERT INTO `item_mods` VALUES(11068, 5, 40);
INSERT INTO `item_mods` VALUES(11068, 12, 8);
INSERT INTO `item_mods` VALUES(11068, 13, 8);
INSERT INTO `item_mods` VALUES(11068, 30, 7);
INSERT INTO `item_mods` VALUES(11068, 28, 7);
INSERT INTO `item_mods` VALUES(11088, 1, 52);
INSERT INTO `item_mods` VALUES(11088, 12, 12);
INSERT INTO `item_mods` VALUES(11088, 13, 12);
INSERT INTO `item_mods` VALUES(11088, 30, 10);
INSERT INTO `item_mods` VALUES(11088, 369, 2);
INSERT INTO `item_mods` VALUES(11108, 1, 22);
INSERT INTO `item_mods` VALUES(11108, 13, 6);
INSERT INTO `item_mods` VALUES(11108, 30, 7);
INSERT INTO `item_mods` VALUES(11128, 1, 42);
INSERT INTO `item_mods` VALUES(11128, 5, 65);
INSERT INTO `item_mods` VALUES(11128, 12, 9);
INSERT INTO `item_mods` VALUES(11128, 30, 6);
INSERT INTO `item_mods` VALUES(11128, 28, 6);
INSERT INTO `item_mods` VALUES(11108, 114, 15);
INSERT INTO `item_mods` VALUES(11148, 1, 19);
INSERT INTO `item_mods` VALUES(11148, 13, 13);
INSERT INTO `item_mods` VALUES(11148, 113, 15);
INSERT INTO `item_mods` VALUES(11148, 27, -7);
INSERT INTO `item_mods` VALUES(11707, 30, 3);
INSERT INTO `item_mods` VALUES(11707, 170, 2);
INSERT INTO `item_mods` VALUES(11594, 2, 20);
INSERT INTO `item_mods` VALUES(11594, 5, 20);
INSERT INTO `item_mods` VALUES(11594, 13, 8);
INSERT INTO `item_mods` VALUES(16204, 1, 8);
INSERT INTO `item_mods` VALUES(16204, 13, 5);
INSERT INTO `item_mods` VALUES(16204, 113, 6);
-- Ravager
INSERT INTO `item_mods` VALUES(11064, 1, 38);
INSERT INTO `item_mods` VALUES(11064, 8, 8);
INSERT INTO `item_mods` VALUES(11064, 10, 8);
INSERT INTO `item_mods` VALUES(11064, 25, 14);
INSERT INTO `item_mods` VALUES(11064, 23, 14);
INSERT INTO `item_mods` VALUES(11064, 165, 3);
INSERT INTO `item_mods` VALUES(11064, 288, 4);
INSERT INTO `item_mods` VALUES(11084, 1, 68);
INSERT INTO `item_mods` VALUES(11084, 25, 20);
INSERT INTO `item_mods` VALUES(11084, 23, 20);
INSERT INTO `item_mods` VALUES(11084, 85, 7);
INSERT INTO `item_mods` VALUES(11084, 73, 8);
INSERT INTO `item_mods` VALUES(11144, 1, 27);
INSERT INTO `item_mods` VALUES(11144, 25, 7);
INSERT INTO `item_mods` VALUES(11144, 167, 5);
INSERT INTO `item_mods` VALUES(11124, 1, 54);
INSERT INTO `item_mods` VALUES(11124, 23, 15);
INSERT INTO `item_mods` VALUES(11124, 288, 5);
INSERT INTO `item_mods` VALUES(11124, 167, 7);
INSERT INTO `item_mods` VALUES(11104, 1, 32);
INSERT INTO `item_mods` VALUES(11104, 8, 9);
INSERT INTO `item_mods` VALUES(11104, 9, 9);
INSERT INTO `item_mods` VALUES(11104, 25, 12);
INSERT INTO `item_mods` VALUES(11104, 84, 5);
INSERT INTO `item_mods` VALUES(19253, 8, 4);
INSERT INTO `item_mods` VALUES(19253, 23, 8);
INSERT INTO `item_mods` VALUES(11703, 23, 3);
INSERT INTO `item_mods` VALUES(11703, 288, 1);
INSERT INTO `item_mods` VALUES(11591, 8, 3);
INSERT INTO `item_mods` VALUES(11591, 288, 2);
-- Tantra
INSERT INTO `item_mods` VALUES(11065, 1, 36);
INSERT INTO `item_mods` VALUES(11065, 8, 7);
INSERT INTO `item_mods` VALUES(11065, 167, 7);
INSERT INTO `item_mods` VALUES(11065, 289, 10);
INSERT INTO `item_mods` VALUES(11085, 1, 64);
INSERT INTO `item_mods` VALUES(11085, 8, 12);
INSERT INTO `item_mods` VALUES(11085, 10, 12);
INSERT INTO `item_mods` VALUES(11085, 25, 15);
INSERT INTO `item_mods` VALUES(11085, 23, 15);
INSERT INTO `item_mods` VALUES(11125, 1, 49);
INSERT INTO `item_mods` VALUES(11125, 23, 10);
INSERT INTO `item_mods` VALUES(11125, 25, 10);
INSERT INTO `item_mods` VALUES(11125, 73, 6);
INSERT INTO `item_mods` VALUES(11125, 167, 6);
INSERT INTO `item_mods` VALUES(11125, 292, 7);
INSERT INTO `item_mods` VALUES(11105, 1, 27);
INSERT INTO `item_mods` VALUES(11105, 25, 10);
INSERT INTO `item_mods` VALUES(11105, 80, 7);
INSERT INTO `item_mods` VALUES(11105, 167, 3);
INSERT INTO `item_mods` VALUES(11145, 1, 25);
INSERT INTO `item_mods` VALUES(11145, 8, 8);
INSERT INTO `item_mods` VALUES(11145, 25, 8);
INSERT INTO `item_mods` VALUES(11704, 2, 10);
INSERT INTO `item_mods` VALUES(11704, 292, 1);
INSERT INTO `item_mods` VALUES(11592, 25, 5);
INSERT INTO `item_mods` VALUES(11592, 292, 2);
INSERT INTO `item_mods` VALUES(19254, 8, 4);
INSERT INTO `item_mods` VALUES(19254, 10, 4);
INSERT INTO `item_mods` VALUES(19254, 25, 6);
-- Raider
INSERT INTO `item_mods` VALUES(11069, 1, 36);
INSERT INTO `item_mods` VALUES(11069, 25, 12);
INSERT INTO `item_mods` VALUES(11069, 302, 3);
INSERT INTO `item_mods` VALUES(11069, 167, 6);
INSERT INTO `item_mods` VALUES(11089, 1, 64);
INSERT INTO `item_mods` VALUES(11089, 9, 10);
INSERT INTO `item_mods` VALUES(11089, 81, 5);
INSERT INTO `item_mods` VALUES(11089, 167, 5);
INSERT INTO `item_mods` VALUES(11129, 1, 48);
INSERT INTO `item_mods` VALUES(11129, 9, 7);
INSERT INTO `item_mods` VALUES(11129, 165, 4);
INSERT INTO `item_mods` VALUES(11129, 167, 5);
INSERT INTO `item_mods` VALUES(11109, 1, 28);
INSERT INTO `item_mods` VALUES(11109, 8, 8);
INSERT INTO `item_mods` VALUES(11109, 9, 8);
INSERT INTO `item_mods` VALUES(11109, 23, 16);
INSERT INTO `item_mods` VALUES(11109, 25, 12);
INSERT INTO `item_mods` VALUES(11149, 1, 23);
INSERT INTO `item_mods` VALUES(11149, 11, 15);
INSERT INTO `item_mods` VALUES(11149, 68, 11);
INSERT INTO `item_mods` VALUES(11149, 303, 1);
INSERT INTO `item_mods` VALUES(19260, 25, 3);
INSERT INTO `item_mods` VALUES(19260, 259, 3);
INSERT INTO `item_mods` VALUES(11736, 1, 11);
INSERT INTO `item_mods` VALUES(11736, 9, 3);
INSERT INTO `item_mods` VALUES(11736, 14, 3);
INSERT INTO `item_mods` VALUES(11736, 302, 1);
INSERT INTO `item_mods` VALUES(11708, 68, 3);
INSERT INTO `item_mods` VALUES(11708, 302, 1);
-- Creed
INSERT INTO `item_mods` VALUES(11070, 1, 44);
INSERT INTO `item_mods` VALUES(11070, 2, 40);
INSERT INTO `item_mods` VALUES(11070, 5, 40);
INSERT INTO `item_mods` VALUES(11070, 109, 7);
INSERT INTO `item_mods` VALUES(11070, 170, 5);
INSERT INTO `item_mods` VALUES(11090, 1, 77);
INSERT INTO `item_mods` VALUES(11090, 2, 65);
INSERT INTO `item_mods` VALUES(11090, 5, 65);
INSERT INTO `item_mods` VALUES(11090, 23, 20);
INSERT INTO `item_mods` VALUES(11090, 25, 20);
INSERT INTO `item_mods` VALUES(11090, 27, 10);
INSERT INTO `item_mods` VALUES(11130, 1, 58);
INSERT INTO `item_mods` VALUES(11130, 2, 50);
INSERT INTO `item_mods` VALUES(11130, 167, 4);
INSERT INTO `item_mods` VALUES(11130, 161, -5);
INSERT INTO `item_mods` VALUES(11110, 1, 35);
INSERT INTO `item_mods` VALUES(11110, 8, 11);
INSERT INTO `item_mods` VALUES(11110, 10, 11);
INSERT INTO `item_mods` VALUES(11110, 82, 7);
INSERT INTO `item_mods` VALUES(11110, 167, 4);
INSERT INTO `item_mods` VALUES(11150, 1, 30);
INSERT INTO `item_mods` VALUES(11150, 25, 14);
INSERT INTO `item_mods` VALUES(11150, 27, 7);
INSERT INTO `item_mods` VALUES(11150, 167, 4);
INSERT INTO `item_mods` VALUES(11750, 1, 10);
INSERT INTO `item_mods` VALUES(11750, 2, 40);
INSERT INTO `item_mods` VALUES(11750, 29, 4);
INSERT INTO `item_mods` VALUES(11750, 27, 5);
INSERT INTO `item_mods` VALUES(11595, 369, 1);
INSERT INTO `item_mods` VALUES(11709, 2, 30);
INSERT INTO `item_mods` VALUES(11709, 109, 3);
-- Bale
INSERT INTO `item_mods` VALUES(11071, 1, 42);
INSERT INTO `item_mods` VALUES(11071, 8, 7);
INSERT INTO `item_mods` VALUES(11071, 9, 7);
INSERT INTO `item_mods` VALUES(11071, 86, 7);
INSERT INTO `item_mods` VALUES(11071, 288, 3);
INSERT INTO `item_mods` VALUES(11071, 167, 6);
INSERT INTO `item_mods` VALUES(11091, 1, 71);
INSERT INTO `item_mods` VALUES(11091, 23, 38);
INSERT INTO `item_mods` VALUES(11091, 165, 4);
INSERT INTO `item_mods` VALUES(11091, 167, 3);
INSERT INTO `item_mods` VALUES(11131, 1, 53);
INSERT INTO `item_mods` VALUES(11131, 8, 12);
INSERT INTO `item_mods` VALUES(11131, 25, 15);
INSERT INTO `item_mods` VALUES(11131, 23, 15);
INSERT INTO `item_mods` VALUES(11131, 116, 15);
INSERT INTO `item_mods` VALUES(11111, 1, 31);
INSERT INTO `item_mods` VALUES(11111, 25, 10);
INSERT INTO `item_mods` VALUES(11111, 23, 10);
INSERT INTO `item_mods` VALUES(11111, 83, 5);
INSERT INTO `item_mods` VALUES(11111, 167, 5);
INSERT INTO `item_mods` VALUES(11151, 1, 27);
INSERT INTO `item_mods` VALUES(11151, 8, 9);
INSERT INTO `item_mods` VALUES(11151, 12, 9);
INSERT INTO `item_mods` VALUES(11151, 13, 9);
INSERT INTO `item_mods` VALUES(11151, 30, 8);
INSERT INTO `item_mods` VALUES(11151, 28, 8);
INSERT INTO `item_mods` VALUES(11710, 8, 4);
INSERT INTO `item_mods` VALUES(11710, 23, 8);
INSERT INTO `item_mods` VALUES(11616, 8, 5);
INSERT INTO `item_mods` VALUES(11616, 25, 8);
INSERT INTO `item_mods` VALUES(11616, 23, 8);
INSERT INTO `item_mods` VALUES(11616, 369, 1);
INSERT INTO `item_mods` VALUES(11737, 8, 6);
INSERT INTO `item_mods` VALUES(11737, 12, 6);
INSERT INTO `item_mods` VALUES(11737, 25, 6);
-- Ferine
INSERT INTO `item_mods` VALUES(11072, 1, 37);
INSERT INTO `item_mods` VALUES(11072, 9, 8);
INSERT INTO `item_mods` VALUES(11072, 14, 8);
INSERT INTO `item_mods` VALUES(11072, 25, 8);
INSERT INTO `item_mods` VALUES(11072, 167, 6);
INSERT INTO `item_mods` VALUES(11092, 1, 67);
INSERT INTO `item_mods` VALUES(11092, 25, 18);
INSERT INTO `item_mods` VALUES(11092, 23, 18);
INSERT INTO `item_mods` VALUES(11092, 68, 18);
INSERT INTO `item_mods` VALUES(11092, 84, 7);
INSERT INTO `item_mods` VALUES(11092, 167, 2);
INSERT INTO `item_mods` VALUES(11132, 1, 51);
INSERT INTO `item_mods` VALUES(11132, 14, 10);
INSERT INTO `item_mods` VALUES(11132, 25, 7);
INSERT INTO `item_mods` VALUES(11132, 23, 7);
INSERT INTO `item_mods` VALUES(11132, 167, 7);
INSERT INTO `item_mods` VALUES(11112, 1, 29);
INSERT INTO `item_mods` VALUES(11112, 8, 11);
INSERT INTO `item_mods` VALUES(11112, 23, 15);
INSERT INTO `item_mods` VALUES(11112, 165, 3);
INSERT INTO `item_mods` VALUES(11152, 1, 25);
INSERT INTO `item_mods` VALUES(11152, 8, 7);
INSERT INTO `item_mods` VALUES(11152, 9, 7);
INSERT INTO `item_mods` VALUES(11152, 25, 8);
INSERT INTO `item_mods` VALUES(11152, 288, 3);
INSERT INTO `item_mods` VALUES(11617, 14, 6);
INSERT INTO `item_mods` VALUES(11617, 25, 7);
INSERT INTO `item_mods` VALUES(11617, 23, 7);
INSERT INTO `item_mods` VALUES(11555, 9, 4);
INSERT INTO `item_mods` VALUES(11555, 14, 4);
INSERT INTO `item_mods` VALUES(11555, 25, 7);
INSERT INTO `item_mods` VALUES(11711, 364, 2);
-- Aoidos'
INSERT INTO `item_mods` VALUES(11073, 1, 33);
INSERT INTO `item_mods` VALUES(11073, 14, 8);
INSERT INTO `item_mods` VALUES(11073, 27, -7);
INSERT INTO `item_mods` VALUES(11093, 1, 51);
INSERT INTO `item_mods` VALUES(11093, 14, 10);
INSERT INTO `item_mods` VALUES(11093, 119, 10)
INSERT INTO `item_mods` VALUES(11093, 121, 10)
INSERT INTO `item_mods` VALUES(11133, 1, 42);
INSERT INTO `item_mods` VALUES(11133, 30, 7);
INSERT INTO `item_mods` VALUES(11133, 119, 10);
INSERT INTO `item_mods` VALUES(11113, 1, 24);
INSERT INTO `item_mods` VALUES(11113, 14, 12);
INSERT INTO `item_mods` VALUES(11113, 30, 8);
INSERT INTO `item_mods` VALUES(11113, 119, 8);
INSERT INTO `item_mods` VALUES(11113, 120, 8);
INSERT INTO `item_mods` VALUES(11113, 121, 8);
INSERT INTO `item_mods` VALUES(11153, 1, 18);
INSERT INTO `item_mods` VALUES(11153, 14, 11);
INSERT INTO `item_mods` VALUES(11153, 169, 12);
INSERT INTO `item_mods` VALUES(11153, 370, 2);
INSERT INTO `item_mods` VALUES(11712, 14, 4);
INSERT INTO `item_mods` VALUES(11738, 1, 6);
-- Sylvan
INSERT INTO `item_mods` VALUES(11074, 1, 34);
INSERT INTO `item_mods` VALUES(11074, 26, 13);
INSERT INTO `item_mods` VALUES(11074, 24, 13);
INSERT INTO `item_mods` VALUES(11074, 289, 10);
INSERT INTO `item_mods` VALUES(11094, 1, 61);
INSERT INTO `item_mods` VALUES(11094, 8, 12);
INSERT INTO `item_mods` VALUES(11094, 11, 12);
INSERT INTO `item_mods` VALUES(11094, 26, 20);
INSERT INTO `item_mods` VALUES(11094, 27, -9);
INSERT INTO `item_mods` VALUES(11134, 1, 46);
INSERT INTO `item_mods` VALUES(11134, 24, 12);
INSERT INTO `item_mods` VALUES(11134, 165, 3);
INSERT INTO `item_mods` VALUES(11134, 73, 9);
INSERT INTO `item_mods` VALUES(11114, 1, 25);
INSERT INTO `item_mods` VALUES(11114, 8, 10);
INSERT INTO `item_mods` VALUES(11114, 104, 7);
INSERT INTO `item_mods` VALUES(11114, 73, 7);
INSERT INTO `item_mods` VALUES(11154, 1, 22);
INSERT INTO `item_mods` VALUES(11154, 11, 15);
INSERT INTO `item_mods` VALUES(11154, 105, 7);
INSERT INTO `item_mods` VALUES(11154, 27, -8);
INSERT INTO `item_mods` VALUES(11713, 11, 4);
INSERT INTO `item_mods` VALUES(11713, 27, -2);
INSERT INTO `item_mods` VALUES(11596, 11, 6);
INSERT INTO `item_mods` VALUES(11596, 24, 8);
INSERT INTO `item_mods` VALUES(11596, 27, -3);
INSERT INTO `item_mods` VALUES(16205, 1, 9);
INSERT INTO `item_mods` VALUES(16205, 8, 6);
INSERT INTO `item_mods` VALUES(16205, 73, 5);
INSERT INTO `item_mods` VALUES(16205, 27, -3);
-- Unkai
INSERT INTO `item_mods` VALUES(11075, 1, 41);
INSERT INTO `item_mods` VALUES(11075, 9, 7);
INSERT INTO `item_mods` VALUES(11075, 73, 8);
INSERT INTO `item_mods` VALUES(11075, 167, 6);
INSERT INTO `item_mods` VALUES(11095, 1, 70);
INSERT INTO `item_mods` VALUES(11095, 25, 17);
INSERT INTO `item_mods` VALUES(11095, 23, 17);
INSERT INTO `item_mods` VALUES(11095, 89, 7);
INSERT INTO `item_mods` VALUES(11095, 73, 10);
INSERT INTO `item_mods` VALUES(11095, 306, 10);
INSERT INTO `item_mods` VALUES(11135, 1, 54);
INSERT INTO `item_mods` VALUES(11135, 8, 8);
INSERT INTO `item_mods` VALUES(11135, 9, 8);
INSERT INTO `item_mods` VALUES(11135, 73, 7);
INSERT INTO `item_mods` VALUES(11135, 167, 4);
INSERT INTO `item_mods` VALUES(11115, 1, 31);
INSERT INTO `item_mods` VALUES(11115, 8, 10);
INSERT INTO `item_mods` VALUES(11115, 11, 10);
INSERT INTO `item_mods` VALUES(11115, 25, 8);
INSERT INTO `item_mods` VALUES(11115, 26, 12);
INSERT INTO `item_mods` VALUES(11115, 24, 12);
INSERT INTO `item_mods` VALUES(11155, 1, 28);
INSERT INTO `item_mods` VALUES(11155, 8, 8);
INSERT INTO `item_mods` VALUES(11155, 25, 15);
INSERT INTO `item_mods` VALUES(11155, 23, 15);
INSERT INTO `item_mods` VALUES(11714, 73, 1);
INSERT INTO `item_mods` VALUES(11714, 306, 3);
INSERT INTO `item_mods` VALUES(11597, 8, 3);
INSERT INTO `item_mods` VALUES(11597, 25, 5);
INSERT INTO `item_mods` VALUES(11597, 73, 3);
INSERT INTO `item_mods` VALUES(16206, 1, 14);
INSERT INTO `item_mods` VALUES(16206, 8, 5);
INSERT INTO `item_mods` VALUES(16206, 23, 14);
INSERT INTO `item_mods` VALUES(16206, 306, 5);
-- Iga
INSERT INTO `item_mods` VALUES(11076, 1, 37);
INSERT INTO `item_mods` VALUES(11076, 9, 10);
INSERT INTO `item_mods` VALUES(11076, 167, 6);
INSERT INTO `item_mods` VALUES(11076, 259, 5);
INSERT INTO `item_mods` VALUES(11096, 1, 62);
INSERT INTO `item_mods` VALUES(11096, 8, 12);
INSERT INTO `item_mods` VALUES(11096, 9, 12);
INSERT INTO `item_mods` VALUES(11096, 25, 17);
INSERT INTO `item_mods` VALUES(11096, 23, 17);
INSERT INTO `item_mods` VALUES(11096, 165, 5);
INSERT INTO `item_mods` VALUES(11136, 1, 48);
INSERT INTO `item_mods` VALUES(11136, 25, 8);
INSERT INTO `item_mods` VALUES(11136, 88, 5);
INSERT INTO `item_mods` VALUES(11136, 167, 7);
INSERT INTO `item_mods` VALUES(11116, 1, 27);
INSERT INTO `item_mods` VALUES(11116, 9, 10);
INSERT INTO `item_mods` VALUES(11116, 11, 10);
INSERT INTO `item_mods` VALUES(11116, 25, 8);
INSERT INTO `item_mods` VALUES(11116, 68, 8);
INSERT INTO `item_mods` VALUES(11156, 1, 23);
INSERT INTO `item_mods` VALUES(11156, 8, 5);
INSERT INTO `item_mods` VALUES(11156, 9, 5);
INSERT INTO `item_mods` VALUES(11156, 167, 4);
INSERT INTO `item_mods` VALUES(11715, 68, 5);
INSERT INTO `item_mods` VALUES(11715, 259, 1);
INSERT INTO `item_mods` VALUES(11598, 25, 7);
INSERT INTO `item_mods` VALUES(11598, 68, 7);
INSERT INTO `item_mods` VALUES(16207, 1, 10);
INSERT INTO `item_mods` VALUES(16207, 9, 5);
INSERT INTO `item_mods` VALUES(16207, 165, 3);
INSERT INTO `item_mods` VALUES(16207, 73, 5);
-- Lancer's
INSERT INTO `item_mods` VALUES(11077, 1, 40);
INSERT INTO `item_mods` VALUES(11077, 23, 20);
INSERT INTO `item_mods` VALUES(11077, 87, 7);
INSERT INTO `item_mods` VALUES(11077, 167, 6);
INSERT INTO `item_mods` VALUES(11097, 1, 66);
INSERT INTO `item_mods` VALUES(11097, 8, 14);
INSERT INTO `item_mods` VALUES(11097, 9, 14);
INSERT INTO `item_mods` VALUES(11097, 25, 14);
INSERT INTO `item_mods` VALUES(11097, 23, 14);
INSERT INTO `item_mods` VALUES(11097, 73, 10);
INSERT INTO `item_mods` VALUES(11137, 1, 52);
INSERT INTO `item_mods` VALUES(11137, 8, 9);
INSERT INTO `item_mods` VALUES(11137, 10, 9);
INSERT INTO `item_mods` VALUES(11137, 23, 18);
INSERT INTO `item_mods` VALUES(11117, 1, 30);
INSERT INTO `item_mods` VALUES(11117, 8, 8);
INSERT INTO `item_mods` VALUES(11117, 9, 8);
INSERT INTO `item_mods` VALUES(11117, 25, 10);
INSERT INTO `item_mods` VALUES(11117, 288, 4);
INSERT INTO `item_mods` VALUES(11157, 1, 26);
INSERT INTO `item_mods` VALUES(11157, 25, 12);
INSERT INTO `item_mods` VALUES(11157, 23, 12);
INSERT INTO `item_mods` VALUES(11157, 10, 10);
INSERT INTO `item_mods` VALUES(11157, 167, 5);
INSERT INTO `item_mods` VALUES(11716, 25, 4);
INSERT INTO `item_mods` VALUES(11599, 8, 5);
INSERT INTO `item_mods` VALUES(11599, 25, 5);
INSERT INTO `item_mods` VALUES(16208, 1, 9);
INSERT INTO `item_mods` VALUES(16208, 25, 5);
INSERT INTO `item_mods` VALUES(16208, 167, 1);
-- Caller's
INSERT INTO `item_mods` VALUES(11078, 1, 28);
INSERT INTO `item_mods` VALUES(11078, 5, 30);
INSERT INTO `item_mods` VALUES(11078, 117, 9);
INSERT INTO `item_mods` VALUES(11078, 369, 2);
INSERT INTO `item_mods` VALUES(11098, 1, 50);
INSERT INTO `item_mods` VALUES(11098, 5, 60);
INSERT INTO `item_mods` VALUES(11098, 117, 10);
INSERT INTO `item_mods` VALUES(11098, 371, -4);
INSERT INTO `item_mods` VALUES(11138, 1, 40);
INSERT INTO `item_mods` VALUES(11138, 5, 45);
INSERT INTO `item_mods` VALUES(11138, 117, 6);
INSERT INTO `item_mods` VALUES(11118, 1, 23);
INSERT INTO `item_mods` VALUES(11118, 5, 50);
INSERT INTO `item_mods` VALUES(11158, 1, 17);
INSERT INTO `item_mods` VALUES(11158, 5, 25);
INSERT INTO `item_mods` VALUES(11158, 371, -3);
INSERT INTO `item_mods` VALUES(11717, 5, 30);
INSERT INTO `item_mods` VALUES(11717, 357, -1);
INSERT INTO `item_mods` VALUES(11619, 117, 9);
INSERT INTO `item_mods` VALUES(11739, 1, 4);
INSERT INTO `item_mods` VALUES(11739, 5, 20);
INSERT INTO `item_mods` VALUES(11739, 312, 2);
INSERT INTO `item_mods` VALUES(11739, 27, 2);
-- Mavi
INSERT INTO `item_mods` VALUES(11079, 1, 34);
INSERT INTO `item_mods` VALUES(11079, 25, 12);
INSERT INTO `item_mods` VALUES(11079, 82, 7);
INSERT INTO `item_mods` VALUES(11079, 167, 6);
INSERT INTO `item_mods` VALUES(11099, 1, 60);
INSERT INTO `item_mods` VALUES(11099, 25, 12);
INSERT INTO `item_mods` VALUES(11099, 30, 12);
INSERT INTO `item_mods` VALUES(11099, 167, 3);
INSERT INTO `item_mods` VALUES(11099, 369, 2);
INSERT INTO `item_mods` VALUES(11139, 1, 47);
INSERT INTO `item_mods` VALUES(11139, 8, 8);
INSERT INTO `item_mods` VALUES(11139, 9, 8);
INSERT INTO `item_mods` VALUES(11139, 122, 15);
INSERT INTO `item_mods` VALUES(11139, 167, 4);
INSERT INTO `item_mods` VALUES(11119, 1, 26);
INSERT INTO `item_mods` VALUES(11119, 13, 10);
INSERT INTO `item_mods` VALUES(11119, 28, 10);
INSERT INTO `item_mods` VALUES(11119, 27, -4);
INSERT INTO `item_mods` VALUES(11159, 1, 23);
INSERT INTO `item_mods` VALUES(11159, 12, 10);
INSERT INTO `item_mods` VALUES(11159, 30, 8);
INSERT INTO `item_mods` VALUES(11159, 28, 8);
INSERT INTO `item_mods` VALUES(11159, 27, -6);
INSERT INTO `item_mods` VALUES(11718, 2, 20);
INSERT INTO `item_mods` VALUES(11718, 5, 20);
INSERT INTO `item_mods` VALUES(11718, 30, 2);
INSERT INTO `item_mods` VALUES(11600, 5, 20);
INSERT INTO `item_mods` VALUES(11600, 82, 4);
INSERT INTO `item_mods` VALUES(11600, 122, 4);
INSERT INTO `item_mods` VALUES(19255, 122, 5);
-- Navarch's
INSERT INTO `item_mods` VALUES(11080, 1, 35);
INSERT INTO `item_mods` VALUES(11080, 11, 10);
INSERT INTO `item_mods` VALUES(11080, 26, 16);
INSERT INTO `item_mods` VALUES(11080, 359, 10);
INSERT INTO `item_mods` VALUES(11100, 1, 61);
INSERT INTO `item_mods` VALUES(11100, 26, 14);
INSERT INTO `item_mods` VALUES(11100, 24, 14);
INSERT INTO `item_mods` VALUES(11100, 30, 10);
INSERT INTO `item_mods` VALUES(11140, 1, 47);
INSERT INTO `item_mods` VALUES(11140, 9, 8);
INSERT INTO `item_mods` VALUES(11140, 11, 8);
INSERT INTO `item_mods` VALUES(11140, 73, 8);
INSERT INTO `item_mods` VALUES(11120, 1, 26);
INSERT INTO `item_mods` VALUES(11120, 25, 16);
INSERT INTO `item_mods` VALUES(11120, 26, 16);
INSERT INTO `item_mods` VALUES(11120, 165, 5);
INSERT INTO `item_mods` VALUES(11160, 1, 22);
INSERT INTO `item_mods` VALUES(11160, 11, 13);
INSERT INTO `item_mods` VALUES(11160, 30, 10);
INSERT INTO `item_mods` VALUES(11719, 26, 3);
INSERT INTO `item_mods` VALUES(11719, 30, 2);
INSERT INTO `item_mods` VALUES(11601, 28, 3);
INSERT INTO `item_mods` VALUES(11601, 105, 5);
INSERT INTO `item_mods` VALUES(16209, 1, 9);
INSERT INTO `item_mods` VALUES(16209, 26, 7);
INSERT INTO `item_mods` VALUES(16209, 30, 7);
-- Cirque
INSERT INTO `item_mods` VALUES(11081, 1, 33);
INSERT INTO `item_mods` VALUES(11081, 80, 5);
INSERT INTO `item_mods` VALUES(11081, 288, 3);
INSERT INTO `item_mods` VALUES(11081, 167, 6);
INSERT INTO `item_mods` VALUES(11001, 1, 59);
INSERT INTO `item_mods` VALUES(11001, 9, 10);
INSERT INTO `item_mods` VALUES(11001, 25, 20);
INSERT INTO `item_mods` VALUES(11001, 23, 20);
INSERT INTO `item_mods` VALUES(11001, 167, 3);
INSERT INTO `item_mods` VALUES(11141, 1, 46);
INSERT INTO `item_mods` VALUES(11141, 25, 10);
INSERT INTO `item_mods` VALUES(11141, 23, 10);
INSERT INTO `item_mods` VALUES(11141, 167, 4);
INSERT INTO `item_mods` VALUES(11141, 173, -10);
INSERT INTO `item_mods` VALUES(11121, 1, 26);
INSERT INTO `item_mods` VALUES(11121, 8, 6);
INSERT INTO `item_mods` VALUES(11121, 9, 6);
INSERT INTO `item_mods` VALUES(11121, 11, 6);
INSERT INTO `item_mods` VALUES(11121, 73, 6);
INSERT INTO `item_mods` VALUES(11121, 167, 4);
INSERT INTO `item_mods` VALUES(11161, 1, 22);
INSERT INTO `item_mods` VALUES(11161, 8, 8);
INSERT INTO `item_mods` VALUES(11161, 9, 8);
INSERT INTO `item_mods` VALUES(11161, 12, 8);
INSERT INTO `item_mods` VALUES(11161, 25, 12);
INSERT INTO `item_mods` VALUES(11602, 25, 5);
INSERT INTO `item_mods` VALUES(11602, 173, -10);
INSERT INTO `item_mods` VALUES(11751, 1, 6);
INSERT INTO `item_mods` VALUES(11751, 9, 6);
INSERT INTO `item_mods` VALUES(11751, 167, 6);
-- Charis
INSERT INTO `item_mods` VALUES(11082, 1, 32);
INSERT INTO `item_mods` VALUES(11082, 25, 8);
INSERT INTO `item_mods` VALUES(11082, 23, 8);
INSERT INTO `item_mods` VALUES(11082, 73, 7);
INSERT INTO `item_mods` VALUES(11082, 167, 6);
INSERT INTO `item_mods` VALUES(11102, 1, 61);
INSERT INTO `item_mods` VALUES(11102, 9, 12);
INSERT INTO `item_mods` VALUES(11102, 14, 12);
INSERT INTO `item_mods` VALUES(11102, 289, 10);
INSERT INTO `item_mods` VALUES(11102, 259, 10);
INSERT INTO `item_mods` VALUES(11142, 1, 45);
INSERT INTO `item_mods` VALUES(11142, 68, 15);
INSERT INTO `item_mods` VALUES(11142, 81, 5);
INSERT INTO `item_mods` VALUES(11142, 167, 5);
INSERT INTO `item_mods` VALUES(11122, 1, 25);
INSERT INTO `item_mods` VALUES(11122, 9, 9);
INSERT INTO `item_mods` VALUES(11122, 11, 9);
INSERT INTO `item_mods` VALUES(11122, 25, 8);
INSERT INTO `item_mods` VALUES(11122, 175, 10);
INSERT INTO `item_mods` VALUES(11162, 1, 21);
INSERT INTO `item_mods` VALUES(11162, 9, 8);
INSERT INTO `item_mods` VALUES(11162, 14, 8);
INSERT INTO `item_mods` VALUES(11162, 73, 8);
INSERT INTO `item_mods` VALUES(11162, 167, 4);
INSERT INTO `item_mods` VALUES(11721, 289, 3);
INSERT INTO `item_mods` VALUES(19256, 9, 5);
INSERT INTO `item_mods` VALUES(11603, 259, 3);
INSERT INTO `item_mods` VALUES(11603, 289, 5);
-- Savant's
INSERT INTO `item_mods` VALUES(11083, 1, 30);
INSERT INTO `item_mods` VALUES(11083, 5, 45);
INSERT INTO `item_mods` VALUES(11083, 113, 10);
INSERT INTO `item_mods` VALUES(11103, 1, 52);
INSERT INTO `item_mods` VALUES(11103, 12, 12);
INSERT INTO `item_mods` VALUES(11103, 13, 12);
INSERT INTO `item_mods` VALUES(11103, 28, 11);
INSERT INTO `item_mods` VALUES(11103, 30, 11);
INSERT INTO `item_mods` VALUES(11103, 369, 2);
INSERT INTO `item_mods` VALUES(11143, 1, 40);
INSERT INTO `item_mods` VALUES(11143, 13, 11);
INSERT INTO `item_mods` VALUES(11143, 114, 10);
INSERT INTO `item_mods` VALUES(11123, 1, 23);
INSERT INTO `item_mods` VALUES(11123, 5, 20);
INSERT INTO `item_mods` VALUES(11123, 12, 9);
INSERT INTO `item_mods` VALUES(11123, 13, 9);
INSERT INTO `item_mods` VALUES(11123, 27, -4);
INSERT INTO `item_mods` VALUES(11163, 1, 19);
INSERT INTO `item_mods` VALUES(11163, 5, 35);
INSERT INTO `item_mods` VALUES(11163, 12, 8);
INSERT INTO `item_mods` VALUES(11163, 115, 10);
INSERT INTO `item_mods` VALUES(11722, 334, 1);
INSERT INTO `item_mods` VALUES(11620, 12, 5);
INSERT INTO `item_mods` VALUES(11620, 13, 5);
INSERT INTO `item_mods` VALUES(11620, 30, 3);
INSERT INTO `item_mods` VALUES(11620, 28, 3);
INSERT INTO `item_mods` VALUES(19247, 115, 4);
INSERT INTO `item_mods` VALUES(19247, 114, 4);
INSERT INTO `item_mods` VALUES(19247, 113, 4);
-- Thaumas
INSERT INTO `item_mods` VALUES(10906, 1, 34);
INSERT INTO `item_mods` VALUES(10906, 8, 6);
INSERT INTO `item_mods` VALUES(10906, 11, 14);
INSERT INTO `item_mods` VALUES(10906, 24, 6);
INSERT INTO `item_mods` VALUES(10906, 30, 6);
INSERT INTO `item_mods` VALUES(10906, 28, 6);
INSERT INTO `item_mods` VALUES(10906, 165, 4);
INSERT INTO `item_mods` VALUES(10479, 1, 63);
INSERT INTO `item_mods` VALUES(10479, 25, 12);
INSERT INTO `item_mods` VALUES(10479, 288, 3);
INSERT INTO `item_mods` VALUES(10479, 302, 3);
INSERT INTO `item_mods` VALUES(10479, 167, 4);
INSERT INTO `item_mods` VALUES(10559, 1, 47);
INSERT INTO `item_mods` VALUES(10559, 2, 40);
INSERT INTO `item_mods` VALUES(10559, 8, 9);
INSERT INTO `item_mods` VALUES(10559, 11, 9);
INSERT INTO `item_mods` VALUES(10559, 25, 14);
INSERT INTO `item_mods` VALUES(10559, 23, 14);
INSERT INTO `item_mods` VALUES(10559, 167, 6);
INSERT INTO `item_mods` VALUES(10528, 1, 28);
INSERT INTO `item_mods` VALUES(10528, 9, 8);
INSERT INTO `item_mods` VALUES(10528, 10, 8);
INSERT INTO `item_mods` VALUES(10528, 11, 8);
INSERT INTO `item_mods` VALUES(10528, 25, 9);
INSERT INTO `item_mods` VALUES(10528, 170, 4);
INSERT INTO `item_mods` VALUES(10528, 167, 3);
INSERT INTO `item_mods` VALUES(10625, 1, 26);
INSERT INTO `item_mods` VALUES(10625, 9, 9);
INSERT INTO `item_mods` VALUES(10625, 11, 9);
INSERT INTO `item_mods` VALUES(10625, 13, 9);
INSERT INTO `item_mods` VALUES(10625, 23, 14);
INSERT INTO `item_mods` VALUES(10625, 24, 14);
INSERT INTO `item_mods` VALUES(10625, 288, 3);
-- Phorcys
INSERT INTO `item_mods` VALUES(10901, 1, 36);
INSERT INTO `item_mods` VALUES(10901, 25, 10);
INSERT INTO `item_mods` VALUES(10901, 23, 10);
INSERT INTO `item_mods` VALUES(10901, 73, 5);
INSERT INTO `item_mods` VALUES(10901, 167, 7);
INSERT INTO `item_mods` VALUES(10901, 289, 5);
INSERT INTO `item_mods` VALUES(10474, 1, 70);
INSERT INTO `item_mods` VALUES(10474, 8, 16);
INSERT INTO `item_mods` VALUES(10474, 62, 5);
INSERT INTO `item_mods` VALUES(10474, 28, 7);
INSERT INTO `item_mods` VALUES(10554, 1, 51);
INSERT INTO `item_mods` VALUES(10554, 9, 10);
INSERT INTO `item_mods` VALUES(10554, 10, 10);
INSERT INTO `item_mods` VALUES(10554, 23, 24);
INSERT INTO `item_mods` VALUES(10554, 73, 6);
INSERT INTO `item_mods` VALUES(10554, 167, 6);
INSERT INTO `item_mods` VALUES(10523, 1, 31);
INSERT INTO `item_mods` VALUES(10523, 8, 9);
INSERT INTO `item_mods` VALUES(10523, 10, 9);
INSERT INTO `item_mods` VALUES(10523, 12, 9);
INSERT INTO `item_mods` VALUES(10523, 13, 9);
INSERT INTO `item_mods` VALUES(10523, 23, 15);
INSERT INTO `item_mods` VALUES(10523, 288, 2);
INSERT INTO `item_mods` VALUES(10620, 1, 28);
INSERT INTO `item_mods` VALUES(10620, 25, 12);
INSERT INTO `item_mods` VALUES(10620, 288, 3);
INSERT INTO `item_mods` VALUES(10620, 161, -5);
-- Nares
INSERT INTO `item_mods` VALUES(10911, 1, 29);
INSERT INTO `item_mods` VALUES(10911, 12, 12);
INSERT INTO `item_mods` VALUES(10911, 28, 5);
INSERT INTO `item_mods` VALUES(10911, 170, 10);
INSERT INTO `item_mods` VALUES(10484, 1, 53);
INSERT INTO `item_mods` VALUES(10484, 12, 9);
INSERT INTO `item_mods` VALUES(10484, 13, 9);
INSERT INTO `item_mods` VALUES(10484, 14, 9);
INSERT INTO `item_mods` VALUES(10484, 30, 14);
INSERT INTO `item_mods` VALUES(10484, 28, 8);
INSERT INTO `item_mods` VALUES(10484, 27, -5);
INSERT INTO `item_mods` VALUES(10564, 1, 42);
INSERT INTO `item_mods` VALUES(10564, 3, 4);
INSERT INTO `item_mods` VALUES(10564, 6, 4);
INSERT INTO `item_mods` VALUES(10564, 13, 14);
INSERT INTO `item_mods` VALUES(10564, 374, 7);
INSERT INTO `item_mods` VALUES(10564, 369, 2);
INSERT INTO `item_mods` VALUES(10533, 1, 24);
INSERT INTO `item_mods` VALUES(10533, 6, 3);
INSERT INTO `item_mods` VALUES(10533, 28, 13);
INSERT INTO `item_mods` VALUES(10533, 71, 4);
INSERT INTO `item_mods` VALUES(10533, 312, 8);
INSERT INTO `item_mods` VALUES(10630, 1, 21);
INSERT INTO `item_mods` VALUES(10630, 3, 3);
INSERT INTO `item_mods` VALUES(10630, 6, 3);
INSERT INTO `item_mods` VALUES(10630, 13, 8);
INSERT INTO `item_mods` VALUES(10630, 14, 8);
INSERT INTO `item_mods` VALUES(10630, 30, 7);
INSERT INTO `item_mods` VALUES(10630, 28, 7);
-- Tenryu +1
INSERT INTO `item_mods` VALUES(10406, 1, 36);
INSERT INTO `item_mods` VALUES(10406, 8, 9);
INSERT INTO `item_mods` VALUES(10406, 11, 9);
INSERT INTO `item_mods` VALUES(10406, 25, 12);
INSERT INTO `item_mods` VALUES(10406, 23, 12);
INSERT INTO `item_mods` VALUES(10406, 289, 10);
INSERT INTO `item_mods` VALUES(10490, 1, 63);
INSERT INTO `item_mods` VALUES(10490, 8, 9);
INSERT INTO `item_mods` VALUES(10490, 11, 9);
INSERT INTO `item_mods` VALUES(10490, 25, 20);
INSERT INTO `item_mods` VALUES(10490, 68, 10);
INSERT INTO `item_mods` VALUES(10490, 73, 8);
INSERT INTO `item_mods` VALUES(10571, 1, 50);
INSERT INTO `item_mods` VALUES(10571, 8, 8);
INSERT INTO `item_mods` VALUES(10571, 9, 8);
INSERT INTO `item_mods` VALUES(10571, 11, 8);
INSERT INTO `item_mods` VALUES(10571, 25, 12);
INSERT INTO `item_mods` VALUES(10571, 23, 12);
INSERT INTO `item_mods` VALUES(10571, 73, 6);
INSERT INTO `item_mods` VALUES(10540, 1, 30);
INSERT INTO `item_mods` VALUES(10540, 8, 8);
INSERT INTO `item_mods` VALUES(10540, 11, 8);
INSERT INTO `item_mods` VALUES(10540, 25, 10);
INSERT INTO `item_mods` VALUES(10540, 23, 10);
INSERT INTO `item_mods` VALUES(10540, 289, 7);
INSERT INTO `item_mods` VALUES(10540, 167, 4);
INSERT INTO `item_mods` VALUES(10637, 1, 28);
INSERT INTO `item_mods` VALUES(10637, 8, 7);
INSERT INTO `item_mods` VALUES(10637, 11, 7);
INSERT INTO `item_mods` VALUES(10637, 23, 13);
INSERT INTO `item_mods` VALUES(10637, 68, 8);
INSERT INTO `item_mods` VALUES(10637, 27, 8);
-- Iaso
INSERT INTO `item_mods` VALUES(10409, 1, 30);
INSERT INTO `item_mods` VALUES(10409, 13, 10);
INSERT INTO `item_mods` VALUES(10409, 112, 10);
INSERT INTO `item_mods` VALUES(10409, 374, 11);
INSERT INTO `item_mods` VALUES(10409, 27, -5);
INSERT INTO `item_mods` VALUES(10493, 1, 54);
INSERT INTO `item_mods` VALUES(10493, 111, 18);
INSERT INTO `item_mods` VALUES(10493, 112, 18);
INSERT INTO `item_mods` VALUES(10493, 114, 18);
INSERT INTO `item_mods` VALUES(10493, 167, 4);
INSERT INTO `item_mods` VALUES(10574, 1, 40);
INSERT INTO `item_mods` VALUES(10574, 2, 50);
INSERT INTO `item_mods` VALUES(10574, 161, -4);
INSERT INTO `item_mods` VALUES(10543, 1, 27);
INSERT INTO `item_mods` VALUES(10543, 14, 12);
INSERT INTO `item_mods` VALUES(10543, 30, 10);
INSERT INTO `item_mods` VALUES(10543, 27, -6);
INSERT INTO `item_mods` VALUES(10640, 1, 28);
INSERT INTO `item_mods` VALUES(10640, 374, 4);
INSERT INTO `item_mods` VALUES(10640, 169, 12);
-- Huginn
INSERT INTO `item_mods` VALUES(10405, 1, 41);
INSERT INTO `item_mods` VALUES(10405, 2, 30);
INSERT INTO `item_mods` VALUES(10405, 5, 30);
INSERT INTO `item_mods` VALUES(10405, 8, 9);
INSERT INTO `item_mods` VALUES(10405, 9, 9);
INSERT INTO `item_mods` VALUES(10405, 10, 9);
INSERT INTO `item_mods` VALUES(10405, 25, 15);
INSERT INTO `item_mods` VALUES(10405, 23, 15);
INSERT INTO `item_mods` VALUES(10489, 1, 79);
INSERT INTO `item_mods` VALUES(10489, 2, 50);
INSERT INTO `item_mods` VALUES(10489, 5, 50);
INSERT INTO `item_mods` VALUES(10489, 8, 13);
INSERT INTO `item_mods` VALUES(10489, 10, 13);
INSERT INTO `item_mods` VALUES(10489, 23, 23);
INSERT INTO `item_mods` VALUES(10570, 1, 52);
INSERT INTO `item_mods` VALUES(10570, 2, 50);
INSERT INTO `item_mods` VALUES(10570, 5, 50);
INSERT INTO `item_mods` VALUES(10570, 8, 10);
INSERT INTO `item_mods` VALUES(10570, 10, 10);
INSERT INTO `item_mods` VALUES(10570, 12, 10);
INSERT INTO `item_mods` VALUES(10570, 13, 10);
INSERT INTO `item_mods` VALUES(10570, 25, 12);
INSERT INTO `item_mods` VALUES(10570, 23, 16);
INSERT INTO `item_mods` VALUES(10539, 1, 38);
INSERT INTO `item_mods` VALUES(10539, 2, 40);
INSERT INTO `item_mods` VALUES(10539, 5, 40);
INSERT INTO `item_mods` VALUES(10539, 8, 12);
INSERT INTO `item_mods` VALUES(10539, 10, 12);
INSERT INTO `item_mods` VALUES(10539, 25, 13);
INSERT INTO `item_mods` VALUES(10636, 1, 37);
INSERT INTO `item_mods` VALUES(10636, 2, 35);
INSERT INTO `item_mods` VALUES(10636, 5, 35);
INSERT INTO `item_mods` VALUES(10636, 8, 9);
INSERT INTO `item_mods` VALUES(10636, 10, 9);
INSERT INTO `item_mods` VALUES(10636, 23, 14);
INSERT INTO `item_mods` VALUES(10636, 167, 5);
-- Spurrina
INSERT INTO `item_mods` VALUES(10408, 1, 35);
INSERT INTO `item_mods` VALUES(10408, 5, 60);
INSERT INTO `item_mods` VALUES(10408, 12, 8);
INSERT INTO `item_mods` VALUES(10408, 13, 10);
INSERT INTO `item_mods` VALUES(10408, 30, 10);
INSERT INTO `item_mods` VALUES(10492, 1, 54);
INSERT INTO `item_mods` VALUES(10492, 5, 100);
INSERT INTO `item_mods` VALUES(10492, 28, 15);
INSERT INTO `item_mods` VALUES(10492, 27, -7);
INSERT INTO `item_mods` VALUES(10492, 369, 1);
INSERT INTO `item_mods` VALUES(10573, 1, 42);
INSERT INTO `item_mods` VALUES(10573, 5, 80);
INSERT INTO `item_mods` VALUES(10573, 12, 6);
INSERT INTO `item_mods` VALUES(10573, 68, 10);
INSERT INTO `item_mods` VALUES(10573, 115, 16);
INSERT INTO `item_mods` VALUES(10573, 116, 16);
INSERT INTO `item_mods` VALUES(10542, 1, 29);
INSERT INTO `item_mods` VALUES(10542, 5, 60);
INSERT INTO `item_mods` VALUES(10542, 168, 20);
INSERT INTO `item_mods` VALUES(10639, 1, 29);
INSERT INTO `item_mods` VALUES(10639, 5, 50);
INSERT INTO `item_mods` VALUES(10639, 13, 8);
INSERT INTO `item_mods` VALUES(10639, 30, 6);
INSERT INTO `item_mods` VALUES(10639, 114, 13);
-- Khepri
INSERT INTO `item_mods` VALUES(10407, 1, 35);
INSERT INTO `item_mods` VALUES(10407, 8, 12);
INSERT INTO `item_mods` VALUES(10407, 9, 12);
INSERT INTO `item_mods` VALUES(10407, 25, 13);
INSERT INTO `item_mods` VALUES(10491, 1, 64);
INSERT INTO `item_mods` VALUES(10491, 8, 15);
INSERT INTO `item_mods` VALUES(10491, 9, 15);
INSERT INTO `item_mods` VALUES(10491, 11, 15);
INSERT INTO `item_mods` VALUES(10491, 25, 18);
INSERT INTO `item_mods` VALUES(10491, 26, 22);
INSERT INTO `item_mods` VALUES(10491, 370, 2);
INSERT INTO `item_mods` VALUES(10572, 1, 49);
INSERT INTO `item_mods` VALUES(10572, 8, 12);
INSERT INTO `item_mods` VALUES(10572, 9, 12);
INSERT INTO `item_mods` VALUES(10572, 23, 10);
INSERT INTO `item_mods` VALUES(10572, 68, 5);
INSERT INTO `item_mods` VALUES(10572, 289, 8);
INSERT INTO `item_mods` VALUES(10541, 1, 30);
INSERT INTO `item_mods` VALUES(10541, 8, 9);
INSERT INTO `item_mods` VALUES(10541, 12, 9);
INSERT INTO `item_mods` VALUES(10541, 13, 9);
INSERT INTO `item_mods` VALUES(10541, 30, 6);
INSERT INTO `item_mods` VALUES(10541, 122, 8);
INSERT INTO `item_mods` VALUES(10638, 1, 29);
INSERT INTO `item_mods` VALUES(10638, 26, 18);
INSERT INTO `item_mods` VALUES(10638, 24, 15);
INSERT INTO `item_mods` VALUES(10638, 161, -3);
INSERT INTO `item_mods` VALUES(10638, 27, -7);
-- Tessera Saio
INSERT INTO `item_mods` VALUES(10485, 1, 66);
INSERT INTO `item_mods` VALUES(10485, 8, 13);
INSERT INTO `item_mods` VALUES(10485, 9, 13);
INSERT INTO `item_mods` VALUES(10485, 11, 13);
INSERT INTO `item_mods` VALUES(10485, 23, 17);
INSERT INTO `item_mods` VALUES(10485, 24, 17);
INSERT INTO `item_mods` VALUES(10485, 28, 5);
INSERT INTO `item_mods` VALUES(10485, 167, 3);
It is worth noting that in order to use the @additem command to give yourself some of the newer items in game, you will need to go into Itemutils.h in the src folder and edit the "#define MAX_ITEMID xxxxx" line to include higher values that match the newer items. For the above items this may not be the case, but for things like the new Salvage gear the values are higher than what is currently set. (I set mine to 29000, whether or not that effects anything else in the code I do not know. Armor reaches into the 27000 range now it looks like.)
As a side note I also noticed the bitwise calculation in the "jobs" column of item_armor appears to be off by 1 for a number of items.
I also attached a .txt file that lists all of the modifiers I encountered that are currently not implemented as far as I can tell (there are quite a few.) When they become available I will update the armor again. It is possible that a number of pieces of gear from the list require scripts.