Updated item IDs and modIDs

Post Reply
babblebab
Posts: 40
Joined: Sat Dec 01, 2012 9:50 pm

Updated item IDs and modIDs

Post by babblebab » Thu Feb 14, 2013 2:15 pm

I took a little time to add stats and modelIDs to some of the newer items that have been introduced since the level cap increase, for anyone interested.
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);
Next are the actual modIDs for the gear, again you can add these to your existing database by executing the commands below. I apologize for the long list:

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);
I will work on the Voidwatch gear next hopefully, as well as the newer Salvage gear.

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.
Attachments
todo_modid.txt
(8.91 KiB) Downloaded 207 times
Last edited by babblebab on Thu Feb 14, 2013 11:11 pm, edited 14 times in total.
Top
GalkaSmash
Posts: 31
Joined: Sat Oct 06, 2012 2:42 pm

Re: Updated item IDs and modIDs

Post by GalkaSmash » Thu Feb 14, 2013 3:04 pm

Every mID was actually fixed/added in a patch 3 days ago so sadly a lot of that work is redundant(thread I'd posted about 4 days ago: http://forums.dspt.info/viewtopic.php?f=20&t=839 - I fixed the job offset as well in the page 2 .patch file), in terms of item_armor.sql, HOWEVER none of the item_mod.sql lines were done so that could be very useful and put into a patch itself. I did notice in your comment lines for each set you're missing a space between the -- and comment that will mess it up if you actually included it into an SQL with those as headers. I do the same thing by mistake from time to time (although you did comment out the whole block at the top, all the same).

I only completed the mID while I worked because it made sense while I filled out those ID lists on the wiki. Update your server when you've got a chance and query:

Code: Select all

SELECT itemID, name, mID FROM item_armor WHERE mID = 0 AND slot IN (16,32,64,128,256) AND name NOT LIKE "hexed_%" AND name NOT LIKE "%bangles" AND name NOT LIKE "%hairpin" AND name NOT LIKE "%headband" AND name NOT LIKE "%armbands" AND name NOT LIKE "%hairpin_+1" AND name NOT LIKE "%headband_+1" AND name NOT LIKE "%bangles_+1" AND name NOT LIKE "%bracelets" AND name NOT LIKE "%band" AND name NOT LIKE "%armlets";
Changes made can be viewed here.
https://code.google.com/p/onetimexi/sou ... _armor.sql

Any weapons I haven't done the user mvd1987 has been holding onto, waiting for him to post a patch for those. Still if you've got a lot of item_mod.sql and item_weapon.sql done for things that are missing I bet there would be a lot of people interested. (I'll probably use your item_mods) - anyways if you keep doing stats for them I'd be really interested in getting those possibly put in a few patches for completion sake. I'm always on the chat in case you're worried about more overlap.

Edit: and if you want to view all the mIDs before I get them into the wiki, I update my work publicly on the server forum that I do my main GM & community work with under the Darkstar subboard so that its open and accessible as I go. http://fantasyworldforum.forums3.com/th ... 3be329dd45
wandering the real world for awhile until I figure out where to hand in this damn quest, orz.
Top
babblebab
Posts: 40
Joined: Sat Dec 01, 2012 9:50 pm

Re: Updated item IDs and modIDs

Post by babblebab » Thu Feb 14, 2013 8:17 pm

Hey, I had no intention of stealing your work. My apologies. A few of the model IDs I found I noticed were marked on your list with a "-- needs mID" so I went ahead and added those so we can have almost 100% of the modelIDs in the database.

The bitwise also seems to still be off on quite a few items.

I appreciate all the work you put into finding a lot of the missing stuff!

I uploaded the armor mods I did simply as a list so I could go back and double check the values I used more easily, also so I can go back in the future and add the missing mods as they become available. If you wanted to import it all at the same time as fresh database you could copy each section of mods I did and paste them at the end of your item_mod.sql file in something like notepad++, save it and then import it.

I went back and cleaned it up a bit. When I finish some of the other gear sets I'll upload them in a less confusing way.
Top
GalkaSmash
Posts: 31
Joined: Sat Oct 06, 2012 2:42 pm

Re: Updated item IDs and modIDs

Post by GalkaSmash » Fri Feb 15, 2013 2:15 am

babblebab wrote:Hey, I had no intention of stealing your work. My apologies.
I don't look at it this way at all, I just didn't want you spending hours doing it only to stub your toe and find out its in there.
A few of the model IDs I found I noticed were marked on your list with a "-- needs mID" so I went ahead and added those so we can have almost 100% of the modelIDs in the database.
I actually put those in the .patch on page 2, it isn't in the trunk yet until somebody notices it there( http://forums.dspt.info/viewtopic.php?f ... t=10#p4448 !) and tags it on a revision; but there are 2 mittens left that needed their ID confirmed, I have people hunt them down in retail for me if I can't find the correct mID so its helpful.
The bitwise also seems to still be off on quite a few items.
A lot of that is in the second .patch, if you run that .patch file to your server itself you'll see the Diff for changes, I probably missed some still, there was such a large amount offset that its unlikely I found them all in one go, I fixed most of the wrong values that came on sets, and if I was adding a unique mID shield or weapon that I'd found I went ahead and cleaned up the entries surrounding it.
I uploaded the armor mods I did simply as a list so I could go back and double check the values I used more easily, also so I can go back in the future and add the missing mods as they become available. If you wanted to import it all at the same time as fresh database you could copy each section of mods I did and paste them at the end of your item_mod.sql file in something like notepad++, save it and then import it.

I went back and cleaned it up a bit. When I finish some of the other gear sets I'll upload them in a less confusing way.
np, I usually work the same way, but I haven't had time to do the item_mod or item_weapon list, although I know a lot of item_mod are out there.
wandering the real world for awhile until I figure out where to hand in this damn quest, orz.
Top
babblebab
Posts: 40
Joined: Sat Dec 01, 2012 9:50 pm

Re: Updated item IDs and modIDs

Post by babblebab » Fri Feb 15, 2013 3:56 am

A lot of that is in the second .patch, if you run that .patch file to your server itself you'll see the Diff for changes, I probably missed some still, there was such a large amount offset that its unlikely I found them all in one go, I fixed most of the wrong values that came on sets, and if I was adding a unique mID shield or weapon that I'd found I went ahead and cleaned up the entries surrounding it.
Ah, I see it now! Awesome work, the bitwise values were gonna be a long fix I felt like.
np, I usually work the same way, but I haven't had time to do the item_mod or item_weapon list, although I know a lot of item_mod are out there.
Gotcha, I'll continue to work on the item_mod list over the next few days then.
Any weapons I haven't done the user mvd1987 has been holding onto, waiting for him to post a patch for those.
I'll wait for that to pop up before I go any further on weapons. Thanks again for the info!
Top
PrBlahBlahtson
Developer
Posts: 539
Joined: Sun Jul 22, 2012 12:17 am

Re: Updated item IDs and modIDs

Post by PrBlahBlahtson » Fri Feb 15, 2013 3:45 pm

You'll need to convert your haste values, btw. :) r2608 converted to precise values, but you can steal the correct values from something else that has the same haste (i.e. Blitz Ring has 1% haste, so 384, 11 is correct.)

And I'd also like to say it's a pleasure to see two people communicating like this.
Top
babblebab
Posts: 40
Joined: Sat Dec 01, 2012 9:50 pm

Re: Updated item IDs and modIDs

Post by babblebab » Fri Feb 15, 2013 8:19 pm

Thanks! I'll look into the new haste value formula and convert what I've done.
I've since finished a few more gear sets, so I'll hopefully have that up here later tonight or tomorrow some time.
Top
PrBlahBlahtson
Developer
Posts: 539
Joined: Sun Jul 22, 2012 12:17 am

Re: Updated item IDs and modIDs

Post by PrBlahBlahtson » Sun Feb 17, 2013 2:09 pm

Realized something as I was waking up that's kind of going to either upset you guys, or make your lives extremely easy.

POLUtils -> Item Data -> Armor or Weapons -> Export as XML

A healthy amount of Find and Replace and/or RegEx to convert those into SQL tables with the appropriate data, some UPDATE item_armor SET job = new_armor.jobmask WHERE item_armor.itemid = new_armor.itemid; and we're pretty much done fixing jobs in an afternoon.

item_weapons and item_mods wouldn't be too much more difficult.
Top
GalkaSmash
Posts: 31
Joined: Sat Oct 06, 2012 2:42 pm

Re: Updated item IDs and modIDs

Post by GalkaSmash » Sun Feb 17, 2013 3:35 pm

Thankfully it wasn't too hard to change the few that I did anyways, whoever put in the incorrect ones did so in groups, not sure if there are any left that are incorrect at the moment but they're easy enough to change as they're found.

I haven't had the time to grab the last few mID for bow but running a query on just ranged slot and filling in the gaps from 1 to 110 or so shouldn't be too hard.
wandering the real world for awhile until I figure out where to hand in this damn quest, orz.
Top
Post Reply

Return to “Contributing”