item armor gear

Forum rules
NO LONGER BEING MAINTAINED!
Post Reply
GreatMonkey
Posts: 1
Joined: Mon Aug 06, 2012 11:44 am

item armor gear

Post by GreatMonkey » Fri Aug 24, 2012 8:40 pm

Please post here if you find any armor that is incorrect. If you can, please post a link to the wiki or BGwiki.

Ex. Argent Coat
It gives -200 DEF when it should give 5 DEF
http://wiki.bluegartr.com/bg/Argent_Coat

PrBlahBlahtson
Developer
Posts: 539
Joined: Sun Jul 22, 2012 12:17 am

Re: item armor gear

Post by PrBlahBlahtson » Fri Aug 24, 2012 9:02 pm

Mercurial Spear is invisible.

So's Nightfall, but I actually posted a fix to that... somewhere. Don't think it ever got trunked.

PrBlahBlahtson
Developer
Posts: 539
Joined: Sun Jul 22, 2012 12:17 am

Re: item armor gear

Post by PrBlahBlahtson » Sat Sep 29, 2012 5:06 pm

Started trying to fill in missing armor mID data, since there's about 600 weapon mIDs. Using this query at the moment:

Code: Select all

SELECT * FROM item_armor WHERE mID = 0 AND slot NOT IN (1,2,3,4,8,512,1024,6144,24576,32768) ORDER BY slot;
Will probably offer a patch once I've made better progress, but here's thus far:

Code: Select all

UPDATE `item_armor` SET mID = '244' WHERE itemId IN (11967, 11968); -- Dream Pants
UPDATE `item_armor` SET mID = '243' WHERE itemId IN (11965,11966); -- Dream Trousers
UPDATE `item_armor` SET mID = '307' WHERE itemId IN (10250, 10429); -- Moogle outfit
UPDATE `item_armor` SET mID = '327' WHERE itemId IN (10452, 10502, 10602,10878); -- Rubeus
UPDATE `item_armor` SET mID = '29' WHERE itemId IN (10456, 10457, 10506, 10507, 10604, 10605, 10884, 10885, 11974, 11975); -- Avant
UPDATE `item_armor` SET mID = '300' WHERE itemId IN (11863, 11869); -- Ocelomeh Harness
UPDATE `item_armor` SET mID = '301' WHERE itemId IN (10865,10868,11864,11870); -- Nefer
UPDATE `item_armor` SET mID = '302' WHERE itemId IN (11865, 11871); -- Mekira Toshugai
UPDATE `item_armor` SET mID = '24' WHERE itemId = 10871; -- Pandinus Beret
-- Ruach, Hecates, Appetence crowns, either 130 or 131
UPDATE `item_armor` SET mID = '230' WHERE itemId = 10879; -- Hreysti Helm
UPDATE `item_armor` SET mID = '236' WHERE itemId = 16369; -- Blizer Poleyn
UPDATE `item_armor` SET mID = '237' WHERE itemId = 16370; -- Desultor Tassets
UPDATE `item_armor` SET mID = '238' WHERE itemId = 16371; -- Tatsumaki Sitagoromo
UPDATE `item_armor` SET mID = '223' WHERE itemId = 11861; -- Hikogami Yukata
UPDATE `item_armor` SET mID = '233' WHERE itemId = 11862; -- Himegami Yukata
UPDATE `item_armor` SET mID = '16' WHERE itemId = 14162; -- Agronas Leggings
UPDATE `item_armor` SET mID = '33' WHERE itemId = 16151; -- Leonine Mask
UPDATE `item_armor` SET mID = '234' WHERE itemId IN (12999,14041); -- Susurrus
UPDATE `item_armor` SET mID = '115' WHERE itemId IN (11428, 11429, 11782, 11783, 11832, 11833, 11882, 11883, 11932, 11933); -- Lore
UPDATE `item_armor` SET mID = '202' WHERE itemId IN (13000, 14042); -- Praeda
UPDATE `item_armor` SET mID = '240' WHERE itemId IN (11415, 11505, 12747, 13778, 14258); -- Teal
-- Relic +2
UPDATE `item_armor` SET mID = '65' WHERE itemId IN (10650, 10670, 10690, 10710, 10730);
UPDATE `item_armor` SET mID = '67' WHERE itemId IN (10651, 10671, 10691, 10711, 10731);
UPDATE `item_armor` SET mID = '69' WHERE itemId IN (10652, 10672, 10692, 10712, 10732);
UPDATE `item_armor` SET mID = '71' WHERE itemId IN (10653, 10673, 10693, 10713, 10733);
UPDATE `item_armor` SET mID = '73' WHERE itemId IN (10654, 10674, 10694, 10714, 10734);
UPDATE `item_armor` SET mID = '75' WHERE itemId IN (10655, 10675, 10695, 10715, 10735);
UPDATE `item_armor` SET mID = '77' WHERE itemId IN (10656, 10676, 10696, 10716, 10736);
UPDATE `item_armor` SET mID = '79' WHERE itemId IN (10657, 10677, 10697, 10717, 10737);
UPDATE `item_armor` SET mID = '81' WHERE itemId IN (10658, 10678, 10698, 10718, 10738);
UPDATE `item_armor` SET mID = '83' WHERE itemId IN (10659, 10679, 10699, 10719, 10739);
UPDATE `item_armor` SET mID = '85' WHERE itemId IN (10660, 10680, 10700, 10720, 10740);
UPDATE `item_armor` SET mID = '87' WHERE itemId IN (10661, 10681, 10701, 10721, 10741);
UPDATE `item_armor` SET mID = '89' WHERE itemId IN (10662, 10682, 10702, 10722, 10742);
UPDATE `item_armor` SET mID = '91' WHERE itemId IN (10663, 10683, 10703, 10723, 10743);
UPDATE `item_armor` SET mID = '93' WHERE itemId IN (10664, 10684, 10704, 10724, 10744);
UPDATE `item_armor` SET mID = '95' WHERE itemId IN (10665, 10685, 10705, 10725, 10745);
UPDATE `item_armor` SET mID = '168' WHERE itemId IN (10666, 10686, 10706, 10726, 10746);
UPDATE `item_armor` SET mID = '170' WHERE itemId IN (10667, 10687, 10707, 10727, 10747);
UPDATE `item_armor` SET mID = '172' WHERE itemId IN (10668, 10688, 10708, 10728, 10748);
UPDATE `item_armor` SET mID = '174' WHERE itemId IN (10669, 10689, 10709, 10729, 10749);
Also, Decennial set is 0x14c (items not added yet, may do that too) and the third swimsuit set seems to be around 0x14e.

Off topic: Is there any interest in a sort of pool/post for queries that will perform a set of customizations on your server? i.e. changes Sekkanoki to L40, or adds some missing job traits, or grants Nyzul WSs when you cap your skill.

Edit: Updated with tonight's bored work. 318 missing, but some of those are hairpins/bangles, which really do use mID 0.
Last edited by PrBlahBlahtson on Sat Sep 29, 2012 8:09 pm, edited 1 time in total.

User avatar
whasf
Site Admin
Posts: 1312
Joined: Thu Jul 19, 2012 9:11 pm

Re: item armor gear

Post by whasf » Sat Sep 29, 2012 8:04 pm

Honestly i wouldn't worry about spending time on the modifications yet, let's get the basic/core working first
-- Whasf

beefypotatoes
Posts: 13
Joined: Sat Jun 29, 2013 12:55 pm

Re: item armor gear

Post by beefypotatoes » Tue Jul 02, 2013 5:32 pm

Hope this is an ok place to post this. Discovered these missing values while playing a server running svn version r3597.

Chocobo shirt [wiki]:
- Add 2 defense.
- Set MId to 309
- Enable charges (note that the charges are not actually useable yet).

Code: Select all

INSERT INTO `item_mods` (`itemId`, `modId`, `value`) VALUES ('10293', '1', '2');
UPDATE `item_armor` SET `MId` = '309' WHERE `item_armor`.`itemId` =10293;
INSERT INTO `item_usable` (`itemid`, `subid`, `name`, `validTargets`, `activation`, `animation`, `animationTime`, `maxCharges`, `useDelay`, `reuseDelay`, `aoe`) VALUES ('10293', '0', 'chocobo_shirt', '1', '4', '0', '0', '1', '30', '72000', '0');
I could not find a way to give latent effects with a level limitation (supposed to be level 30 or lower), so I just added them as permanent stats.
This will add 50 Acc, Racc, and Macc

Code: Select all

INSERT INTO `item_mods` (`itemId`, `modId`, `value`) VALUES ('10293', '25', '50');
INSERT INTO `item_mods` (`itemId`, `modId`, `value`) VALUES ('10293', '26', '50');
INSERT INTO `item_mods` (`itemId`, `modId`, `value`) VALUES ('10293', '30', '50');

kevincondor
Posts: 1
Joined: Mon Jul 08, 2013 7:12 am

Re: item armor gear

Post by kevincondor » Mon Jul 08, 2013 7:17 am

Wyrm Armlet and Saurian Helm dosent iincrement wyvern healing breath

http://wiki.ffxiclopedia.org/wiki/Wyrm_Armet
http://wiki.ffxiclopedia.org/wiki/Saurian_Helm

and on DNC items that have waltz potency +% (like AF body and relic hat) dont work

Post Reply