jTynne - Jul 13, 2013 18:41
I'm not sure if the _J items are used in any scripts, but they're missing their effects (see below):
(4768, 'Str1_J', 'STR+1', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, '', '', ''),
(4769, 'Str2_J', 'STR+2', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, '', '', ''),
(4770, 'Str3_J', 'STR+3', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, '', '', ''),
(4771, 'Int1_J', 'INT+1', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, '', '', ''),
(4772, 'Int2_J', 'INT+2', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, '', '', ''),
(4773, 'Int3_J', 'INT+3', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, '', '', ''),
(4774, 'Vit1_J', 'VIT+1', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, '', '', ''),
(4775, 'Vit2_J', 'VIT+2', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, '', '', ''),
(4776, 'Vit3_J', 'VIT+3', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, '', '', ''),
(4777, 'Agi1_J', 'AGI+1', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, '', '', ''),
(4778, 'Agi2_J', 'AGI+2', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, '', '', ''),
(4779, 'Agi3_J', 'AGI+3', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, '', '', ''),
(4780, 'Dex1_J', 'DEX+1', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, '', '', ''),
(4781, 'Dex2_J', 'DEX+2', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, '', '', ''),
(4782, 'Dex3_J', 'DEX+3', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, '', '', ''),
(4783, 'Luk1_J', 'LUK+1', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, '', '', ''),
(4784, 'Luk2_J', 'LUK+2', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, '', '', ''),
(4785, 'Luk3_J', 'LUK+3', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, '', '', ''),
Bishop Mora Enchants missing effects:
(4803, 'Recovery_Lv1', 'Recovery Lv1', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, '', '', ''),
(4803, 'Recovery_Lv1', 'Recovery Lv1', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, '', '', ''),
(4804, 'Coluceo_Heal30', 'Catholic Lv1', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, '', '', ''),
Advanced_Weapons_Box needs to be renamed to High_Weapon_Box to match the item_group.conf name.
Then one I'm confused about,
(20600, 'Fantastic_Aura', 'Fantastic Aura', 5, 0, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 16384, 0, 1, 0, 0, 0, 'bonus bUnbreakableHelm,0;', '', ''),
Do we have support added for the "Floor" costume slot? 16384 I'm guessing is Floor at least.
And some missing headgears that are commented out in rA's item_db_re.sql file, but work fine in-game:
#REPLACE INTO `item_db_re` VALUES (542,'Festive_Cookie','Festival Cookie',0,10,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'itemheal rand(325,405),0;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (543,'Festive_Rainbow_Cake','Festival Rainbow Cake',0,10,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'itemheal rand(325,405),0;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (2238,'Weird_Moustache','Moustache',5,2,NULL,100,NULL,0,NULL,0,0xFFFFFFFF,7,2,1,NULL,'0',0,22,NULL,NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5551,'Holy_Egg_Hat','Holy Egg Hat',5,20,NULL,0,NULL,1,NULL,0,0xFFFFFFFF,7,2,256,NULL,'0',1,537,NULL,NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (2361,'Blue_Aodai','Blue Robe',5,20,NULL,500,NULL,0,NULL,0,0xFFFFFFFE,7,2,16,NULL,'1',1,0,'bonus bAllStats,3; bonus bMdef,5;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (2362,'Red_Aodai','Red Robe',5,20,NULL,500,NULL,0,NULL,0,0xFFFFFFFE,7,2,16,NULL,'1',1,0,'bonus bAllStats,3; bonus bMdef,5;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (2363,'White_Aodai','White Robe',5,20,NULL,500,NULL,0,NULL,0,0x00000001,7,2,16,NULL,'1',1,0,'bonus bAllStats,3; bonus bMdef,5;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (2632,'Korean_Trinket','Korean Trinket',5,125000,NULL,100,NULL,1,NULL,0,0xFFFFFFFE,7,2,136,NULL,'65',0,0,'bonus bVit,1; bonus bDex,1; bonus bLuk,1;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (2633,'Jade_Ring','Jade Ring',5,204000,NULL,100,NULL,0,NULL,0,0xFFFFFFFE,7,2,136,NULL,'80',0,0,'bonus bStr,2; bonus bInt,1;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (4845,'Sea_Energy','Sea Energy',6,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5484,'Taiwan_Flag_Hat','Holidays Hat',5,20,NULL,500,NULL,4,NULL,0,0xFFFFFFFF,7,2,256,NULL,'0',0,482,'bonus bAllStats,5; bonus2 bResEff,Eff_Stun,500;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5534,'Fox_Hat_J','Fox Hat',5,20,NULL,100,NULL,1,NULL,0,0xFFFFFFFF,7,2,513,NULL,'70',0,403,'bonus bAgi,1; bonus bFlee2,2;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5551,'Holy_Egg_Hat','Holy Egg Hat',5,20,NULL,0,NULL,1,NULL,0,0xFFFFFFFF,7,2,256,NULL,'0',1,537,NULL,NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5571,'Rasta_Wig','Rasta_Wig',5,20,NULL,100,NULL,1,NULL,0,0xFFFFFFFF,7,2,256,NULL,'0',1,552,'bonus bStr,1;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5576,'Japan_Winecup','Wine Cup',5,20,NULL,100,NULL,1,NULL,0,0xFFFFFFFF,7,2,1,NULL,'0',0,557,NULL,NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5580,'Red_Beret','Red Beret',5,20,NULL,100,NULL,1,NULL,0,0xFFFFFFFF,7,2,256,NULL,'0',0,559,'bonus bAllStats,3; bonus bMdef,3;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5588,'Leo_Crown','Leo Crown',5,20,NULL,300,NULL,3,NULL,0,0xFFFFFFFF,7,2,256,NULL,'70',1,565,'bonus bStr,2; bonus2 bSubEle,Ele_Fire,5; if(getrefine()>6) { bonus bDef,1; bonus bFlee,10; bonus3 bAutoSpell,"TK_SEVENWIND",4,50; }',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5589,'Leo_Diadem','Leo Diadem',5,20,NULL,300,NULL,3,NULL,0,0xFFFFFFFF,7,2,256,NULL,'70',1,566,'bonus bDex,2; bonus2 bSubEle,Ele_Fire,5; if(getrefine()>6) { bonus bFlee,10; bonus bAspdRate,3; autobonus "{ bonus bSplashRange,1; }",10,10000,BF_WEAPON,"{ specialeffect2 EF_ENHANCE; }"; }',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5591,'Desert_Prince','Desert Prince',5,20,NULL,100,NULL,1,NULL,1,0xFFFFFFFF,7,2,256,NULL,'30',0,567,NULL,NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5595,'Eye_Of_Juno','Eye Of Juno',5,20,NULL,400,NULL,2,NULL,1,0xFFFFFFFF,7,2,256,NULL,'1',1,570,'bonus bMdef,2;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5598,'Virgo_Crown','Virgo Crown',5,20,NULL,300,NULL,3,NULL,1,0xFFFFFFFF,7,2,256,NULL,'70',1,573,'bonus bDex,2; bonus bAspdRate,1; if(getrefine()>6) { bonus2 bSubEle,Ele_Earth,5; autobonus "{ bonus bDex,20; }",10,6000,BF_WEAPON,"{ specialeffect2 EF_ENHANCE; }"; }',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5599,'Virgo_Diadem','Virgo Diadem',5,20,NULL,300,NULL,3,NULL,1,0xFFFFFFFF,7,2,256,NULL,'70',1,574,'bonus bAspdRate,3; bonus2 bSubEle,Ele_Earth,5; if(getrefine()>6) bonus3 bAutoSpell,"MO_BALKYOUNG",1,50;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5601,'Br_Beret','Brazil Beret',5,20,NULL,100,NULL,1,NULL,0,0xFFFFFFFF,7,2,256,NULL,'1',1,576,'bonus bAllStats,3; bonus bMdef,1;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5602,'Jaguar_Hat_J','Jaguar Hat J',5,20,NULL,300,NULL,0,NULL,1,0xFFFFFFFF,7,2,513,NULL,'50',0,530,NULL,NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5606,'Campume_Hat','Champune Hat',5,500,NULL,1200,NULL,4,NULL,1,0xFFFFFFFF,7,2,256,NULL,'3',1,580,'bonus bAllStats,1;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5607,'Lyria_Doll_Hat','Lyria Doll Hat',5,0,NULL,500,NULL,0,NULL,1,0xFFFFFFFF,7,2,256,NULL,'60',0,581,NULL,NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5608,'Dorothy_Doll_Hat','Dorothy Doll Hat',5,0,NULL,500,NULL,0,NULL,1,0xFFFFFFFF,7,2,256,NULL,'60',0,582,NULL,NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5656,'Scooter_Hat_J','Scooter Helmet',5,20,NULL,1000,NULL,7,NULL,1,0xFFFFFFFF,7,2,256,NULL,'50',1,588,'bonus bUnbreakableHelm,0;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5662,'Libra_Crown','Libra Crown',5,10,NULL,300,NULL,3,NULL,0,0xFFFFFFFF,7,2,256,NULL,'1',1,593,'bonus bDex,3;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5663,'Libra_Diadem','Libra Diadem',5,10,NULL,300,NULL,3,NULL,0,0xFFFFFFFF,7,2,256,NULL,'1',1,594,'bonus bDex,3;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5670,'Aniv_Star_Hat','Aniv Star Hat',5,20,NULL,300,NULL,0,NULL,0,0xFFFFFFFF,7,2,256,NULL,'1',1,599,NULL,NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5672,'Southern_Cross','Southern Cross',5,20,NULL,600,NULL,3,NULL,1,0xFFFFFFFF,7,2,256,NULL,'50',1,601,'bonus bInt,1;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5673,'Home_Cherry_Blossom','Home Cherry Blossom',5,20,NULL,100,NULL,2,NULL,1,0xFFFFFFFF,7,2,256,NULL,'30',1,602,NULL,NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5674,'Pig_Moneybox','Pig Moneybox',5,20,NULL,1000,NULL,3,NULL,0,0xFFFFFFFF,7,2,256,NULL,'10',0,603,NULL,NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5675,'Poring_Letter','Poring Letter',5,20,NULL,100,NULL,0,NULL,0,0xFFFFFFFF,7,2,1,NULL,'10',0,604,NULL,NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5676,'Scorpio_Crown','Scorpio Crown',5,20,NULL,300,NULL,3,NULL,0,0xFFFFFFFF,7,2,256,NULL,'1',1,605,NULL,NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5677,'Scorpio_Diadem','Scorpio Diadem',5,20,NULL,300,NULL,3,NULL,1,0xFFFFFFFF,7,2,256,NULL,'1',1,606,'bonus bDex,2;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5678,'Notation_Hairband','Notation Hairband',5,200,NULL,100,NULL,5,NULL,0,0xFFFFFFFF,7,2,256,NULL,'1',1,607,NULL,NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5679,'Engineer_Cap','Engineer Cap',5,20,NULL,200,NULL,2,NULL,1,0xFFFFFFFF,7,2,256,NULL,'10',1,608,NULL,NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5680,'Hawkeyes','Hawkeyes',5,20,NULL,100,NULL,0,NULL,0,0xFFFFFFFF,7,2,512,NULL,'10',0,609,NULL,NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5689,'Queen_Ant_Diadem','Queen Ant Diadem',5,20,NULL,300,NULL,1,NULL,1,0xFFFFFFFF,7,2,256,NULL,'75',1,612,NULL,NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5693,'No_Fear_Underware','No Fear Underwear',5,0,NULL,0,NULL,10,NULL,0,0xFFFFFFFF,7,2,256,NULL,'20',0,30,'bonus bStr,1; bonus bInt,1; bonus bDex,1;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5694,'No_Fear_P_Headgear','No Fear P Headgear',5,0,NULL,0,NULL,1,NULL,1,0xFFFFFFFE,7,2,256,NULL,'20',0,614,'bonus bVit,1;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5739,'Sagittarius_Crown','Sagittarius Crown',5,20,NULL,300,NULL,3,NULL,0,0xFFFFFFFF,7,2,256,NULL,'1',1,617,'bonus bDex,2;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5740,'Sagittarius_Diadem','Sagittarius Diadem',5,20,NULL,300,NULL,3,NULL,0,0xFFFFFFFF,7,2,256,NULL,'1',1,618,'bonus bDex,2; bonus bMdef,3;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5744,'Capricon_Crown','Capricon Crown',5,20,NULL,300,NULL,3,NULL,1,0xFFFFFFFF,7,2,256,NULL,'1',1,621,'bonus bVit,2; bonus bDex,2;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5745,'Capricon_Diadem','Capricon Diadem',5,20,NULL,300,NULL,3,NULL,0,0xFFFFFFFF,7,2,256,NULL,'1',1,622,'bonus bDex,2; bonus bMdef,5;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5761,'Sloth_Hat','Sloth Hat',5,20,NULL,800,NULL,3,NULL,1,0xFFFFFFFF,7,2,256,NULL,'1',1,638,'bonus bAgi,2; bonus3 bAutoSpell,"AS_SONICBLOW",5,50;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5762,'Duneyrr_Helm','Duneyrr Helm',5,20,NULL,100,NULL,5,NULL,0,0xFFFFFFFF,7,2,256,NULL,'1',1,639,'bonus bAllStats,1; bonus bMdef,5; bonus2 bSubRace,RC_DemiHuman,2; bonus2 bSubRace,RC_Brute,2;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5772,'Red_Navy_Hat','Red Navy Hat',5,3000,NULL,500,NULL,1,NULL,0,0xFFFFFFFF,7,2,256,NULL,'95',1,651,NULL,NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5773,'Navy_Beret','Navy Beret',5,3000,NULL,500,NULL,1,NULL,0,0xFFFFFFFF,7,2,256,NULL,'95',1,652,NULL,NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5774,'Red_Pirate_Hat','Red Pirate Hat',5,3000,NULL,500,NULL,1,NULL,0,0xFFFFFFFF,7,2,256,NULL,'95',1,496,NULL,NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5777,'Remover_Hat','Remover Hat',5,20,NULL,800,NULL,2,NULL,0,0xFFFFFFFF,7,2,256,NULL,'30',0,655,'bonus bMdef,1;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5778,'Blue_Arara_Hat','Blue Arara Hat',5,20,NULL,100,NULL,3,NULL,1,0xFFFFFFFF,7,2,256,NULL,'1',1,656,'bonus bStr,2;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5779,'Drooping_Boto','Drooping Boto',5,20,NULL,100,NULL,3,NULL,1,0xFFFFFFFF,7,2,256,NULL,'1',1,657,'bonus bInt,2;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5780,'Tendrilion_Hat','Tendrilion Hat',5,20,NULL,100,NULL,0,NULL,0,0xFFFFFFFF,7,2,256,NULL,'1',1,658,NULL,NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5783,'YellowBunny_Hairband','YellowBunny Hairband',5,20,NULL,200,NULL,0,NULL,1,0xFFFFFFFF,7,2,256,NULL,'1',1,662,'bonus bStr,1; bonus bInt,1; bonus bDex,2;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5784,'PinkBunny_Hairband','PinkBunny Hairband',5,20,NULL,200,NULL,0,NULL,1,0xFFFFFFFF,7,2,256,NULL,'1',1,663,'bonus bStr,1; bonus bInt,2; bonus bDex,1;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5785,'Green_Bunny_Hairband','Green Bunny Hairband',5,20,NULL,200,NULL,0,NULL,1,0xFFFFFFFF,7,2,256,NULL,'1',1,664,'bonus bStr,2; bonus bInt,1; bonus bDex,1;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5789,'Thanatos_Mal_Mask','Thanatos Mal Mask',5,20,NULL,100,NULL,3,NULL,0,0xFFFFFFFF,7,2,513,NULL,'30',0,667,'bonus bVit,1;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5791,'Tenkaippin_Ramen','Tenkaippin Ramen',5,20,NULL,500,NULL,1,NULL,0,0xFFFFFFFF,7,2,256,NULL,'30',0,668,'bonus bInt,-1; bonus bDex,4;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5795,'Red_Dress_Hat','Red Dress Hat',5,20,NULL,0,NULL,0,NULL,0,0xFFFFFFFF,7,2,256,NULL,'1',1,670,'bonus bMdef,7;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5813,'Red_Ph.D_Hat','Red Ph.D Hat',5,1000,NULL,500,NULL,0,NULL,0,0xFFFFFFFF,7,2,256,NULL,'0',1,481,'bonus bInt,1;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5847,'Fools_Day_Helmet','Fools Day Helmet',5,0,NULL,0,NULL,0,NULL,0,0xFFFFFFFF,7,2,256,NULL,'1',0,647,'bonus bInt,5; bonus bVit,-3;',NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5848,'Robin_Eyepatch','Robin Eyepatch',5,20,NULL,0,NULL,0,NULL,0,0xFFFFFFFF,7,2,512,NULL,'1',0,50,NULL,NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5849,'Doctor_Hairband','Doctor Hairband',5,20,NULL,0,NULL,0,NULL,0,0xFFFFFFFF,7,2,256,NULL,'1',0,60,NULL,NULL,NULL);
#REPLACE INTO `item_db_re` VALUES (5850,'Golden_Savage_Hat','Golden Savage Hat',5,20,NULL,500,NULL,5,NULL,0,0xFFFFFFFF,7,2,256,NULL,'50',1,648,NULL,NULL,NULL);
I'll post more as I find 'em!
jTynne - Jul 17, 2013 4:09
Here's the updated SQL inserts for the missing items listed above.
INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_buy`, `price_sell`, `weight`, `atk`, `matk`, `defence`, `range`, `slots`, `equip_jobs`, `equip_upper`, `equip_genders`, `equip_locations`, `weapon_level`, `equip_level_min`, `equip_level_max`, `refineable`, `view`, `script`, `equip_script`, `unequip_script`) VALUES
(542, 'Festive_Cookie', 'Festival Cookie', 0, 10, NULL, 10, 0, 0, NULL, NULL, NULL, 4294967295, 7, 2, NULL, NULL, NULL, 0, NULL, NULL, 'itemheal rand(325,405),0;', NULL, NULL),
(543, 'Festive_Rainbow_Cake', 'Festival Rainbow Cake', 0, 10, NULL, 10, 0, 0, NULL, NULL, NULL, 4294967295, 7, 2, NULL, NULL, NULL, 0, NULL, NULL, 'itemheal rand(325,405),0;', NULL, NULL),
(2238, 'Weird_Moustache', 'Moustache', 5, 2, NULL, 100, 0, 0, 0, NULL, 0, 4294967295, 7, 2, 1, NULL, 0, 0, 0, 22, NULL, NULL, NULL),
(5551, 'Holy_Egg_Hat', 'Holy Egg Hat', 5, 20, NULL, 0, 0, 0, 1, NULL, 0, 4294967295, 7, 2, 256, NULL, 0, 0, 1, 537, NULL, NULL, NULL),
(2361, 'Blue_Aodai', 'Blue Robe', 5, 20, NULL, 500, 0, 0, 0, NULL, 0, 4294967294, 7, 2, 16, NULL, 1, 0, 1, 0, 'bonus bAllStats,3; bonus bMdef,5;', NULL, NULL),
(2362, 'Red_Aodai', 'Red Robe', 5, 20, NULL, 500, 0, 0, 0, NULL, 0, 4294967294, 7, 2, 16, NULL, 1, 0, 1, 0, 'bonus bAllStats,3; bonus bMdef,5;', NULL, NULL),
(2363, 'White_Aodai', 'White Robe', 5, 20, NULL, 500, 0, 0, 0, NULL, 0, 1, 7, 2, 16, NULL, 1, 0, 1, 0, 'bonus bAllStats,3; bonus bMdef,5;', NULL, NULL),
(2632, 'Korean_Trinket', 'Korean Trinket', 5, 125000, NULL, 100, 0, 0, 1, NULL, 0, 4294967294, 7, 2, 136, NULL, 65, 0, 0, 0, 'bonus bVit,1; bonus bDex,1; bonus bLuk,1;', NULL, NULL),
(2633, 'Jade_Ring', 'Jade Ring', 5, 204000, NULL, 100, 0, 0, 0, NULL, 0, 4294967294, 7, 2, 136, NULL, 80, 0, 0, 0, 'bonus bStr,2; bonus bInt,1;', NULL, NULL),
(4845, 'Sea_Energy', 'Sea Energy', 6, 0, NULL, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 16, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL),
(5484, 'Taiwan_Flag_Hat', 'Holidays Hat', 5, 20, NULL, 500, 0, 0, 4, NULL, 0, 4294967295, 7, 2, 256, NULL, 0, 0, 0, 482, 'bonus bAllStats,5; bonus2 bResEff,Eff_Stun,500;', NULL, NULL),
(5534, 'Fox_Hat_J', 'Fox Hat', 5, 20, NULL, 100, 0, 0, 1, NULL, 0, 4294967295, 7, 2, 513, NULL, 70, 0, 0, 403, 'bonus bAgi,1; bonus bFlee2,2;', NULL, NULL),
(5571, 'Rasta_Wig', 'Rasta_Wig', 5, 20, NULL, 100, 0, 0, 1, NULL, 0, 4294967295, 7, 2, 256, NULL, 0, 0, 1, 552, 'bonus bStr,1;', NULL, NULL),
(5576, 'Japan_Winecup', 'Wine Cup', 5, 20, NULL, 100, 0, 0, 1, NULL, 0, 4294967295, 7, 2, 1, NULL, 0, 0, 0, 557, NULL, NULL, NULL),
(5580, 'Red_Beret', 'Red Beret', 5, 20, NULL, 100, 0, 0, 1, NULL, 0, 4294967295, 7, 2, 256, NULL, 0, 0, 0, 559, 'bonus bAllStats,3; bonus bMdef,3;', NULL, NULL),
(5588, 'Leo_Crown', 'Leo Crown', 5, 20, NULL, 300, 0, 0, 3, NULL, 0, 4294967295, 7, 2, 256, NULL, 70, 0, 1, 565, 'bonus bStr,2; bonus2 bSubEle,Ele_Fire,5; if(getrefine()>6) { bonus bDef,1; bonus bFlee,10; bonus3 bAutoSpell,"TK_SEVENWIND",4,50; }', NULL, NULL),
(5589, 'Leo_Diadem', 'Leo Diadem', 5, 20, NULL, 300, 0, 0, 3, NULL, 0, 4294967295, 7, 2, 256, NULL, 70, 0, 1, 566, 'bonus bDex,2; bonus2 bSubEle,Ele_Fire,5; if(getrefine()>6) { bonus bFlee,10; bonus bAspdRate,3; autobonus "{ bonus bSplashRange,1; }",10,10000,BF_WEAPON,"{ specialeffect2 EF_ENHANCE; }"; }', NULL, NULL),
(5591, 'Desert_Prince', 'Desert Prince', 5, 20, NULL, 100, 0, 0, 1, NULL, 1, 4294967295, 7, 2, 256, NULL, 30, 0, 0, 567, NULL, NULL, NULL),
(5595, 'Eye_Of_Juno', 'Eye Of Juno', 5, 20, NULL, 400, 0, 0, 2, NULL, 1, 4294967295, 7, 2, 256, NULL, 1, 0, 1, 570, 'bonus bMdef,2;', NULL, NULL),
(5598, 'Virgo_Crown', 'Virgo Crown', 5, 20, NULL, 300, 0, 0, 3, NULL, 1, 4294967295, 7, 2, 256, NULL, 70, 0, 1, 573, 'bonus bDex,2; bonus bAspdRate,1; if(getrefine()>6) { bonus2 bSubEle,Ele_Earth,5; autobonus "{ bonus bDex,20; }",10,6000,BF_WEAPON,"{ specialeffect2 EF_ENHANCE; }"; }', NULL, NULL),
(5599, 'Virgo_Diadem', 'Virgo Diadem', 5, 20, NULL, 300, 0, 0, 3, NULL, 1, 4294967295, 7, 2, 256, NULL, 70, 0, 1, 574, 'bonus bAspdRate,3; bonus2 bSubEle,Ele_Earth,5; if(getrefine()>6) bonus3 bAutoSpell,"MO_BALKYOUNG",1,50;', NULL, NULL),
(5601, 'Br_Beret', 'Brazil Beret', 5, 20, NULL, 100, 0, 0, 1, NULL, 0, 4294967295, 7, 2, 256, NULL, 1, 0, 1, 576, 'bonus bAllStats,3; bonus bMdef,1;', NULL, NULL),
(5602, 'Jaguar_Hat_J', 'Jaguar Hat J', 5, 20, NULL, 300, 0, 0, 0, NULL, 1, 4294967295, 7, 2, 513, NULL, 50, 0, 0, 530, NULL, NULL, NULL),
(5606, 'Campume_Hat', 'Champune Hat', 5, 500, NULL, 1200, 0, 0, 4, NULL, 1, 4294967295, 7, 2, 256, NULL, 3, 0, 1, 580, 'bonus bAllStats,1;', NULL, NULL),
(5607, 'Lyria_Doll_Hat', 'Lyria Doll Hat', 5, 0, NULL, 500, 0, 0, 0, NULL, 1, 4294967295, 7, 2, 256, NULL, 60, 0, 0, 581, NULL, NULL, NULL),
(5608, 'Dorothy_Doll_Hat', 'Dorothy Doll Hat', 5, 0, NULL, 500, 0, 0, 0, NULL, 1, 4294967295, 7, 2, 256, NULL, 60, 0, 0, 582, NULL, NULL, NULL),
(5656, 'Scooter_Hat_J', 'Scooter Helmet', 5, 20, NULL, 1000, 0, 0, 7, NULL, 1, 4294967295, 7, 2, 256, NULL, 50, 0, 1, 588, 'bonus bUnbreakableHelm,0;', NULL, NULL),
(5662, 'Libra_Crown', 'Libra Crown', 5, 10, NULL, 300, 0, 0, 3, NULL, 0, 4294967295, 7, 2, 256, NULL, 1, 0, 1, 593, 'bonus bDex,3;', NULL, NULL),
(5663, 'Libra_Diadem', 'Libra Diadem', 5, 10, NULL, 300, 0, 0, 3, NULL, 0, 4294967295, 7, 2, 256, NULL, 1, 0, 1, 594, 'bonus bDex,3;', NULL, NULL),
(5670, 'Aniv_Star_Hat', 'Aniv Star Hat', 5, 20, NULL, 300, 0, 0, 0, NULL, 0, 4294967295, 7, 2, 256, NULL, 1, 0, 1, 599, NULL, NULL, NULL),
(5672, 'Southern_Cross', 'Southern Cross', 5, 20, NULL, 600, 0, 0, 3, NULL, 1, 4294967295, 7, 2, 256, NULL, 50, 0, 1, 601, 'bonus bInt,1;', NULL, NULL),
(5673, 'Home_Cherry_Blossom', 'Home Cherry Blossom', 5, 20, NULL, 100, 0, 0, 2, NULL, 1, 4294967295, 7, 2, 256, NULL, 30, 0, 1, 602, NULL, NULL, NULL),
(5674, 'Pig_Moneybox', 'Pig Moneybox', 5, 20, NULL, 1000, 0, 0, 3, NULL, 0, 4294967295, 7, 2, 256, NULL, 10, 0, 0, 603, NULL, NULL, NULL),
(5675, 'Poring_Letter', 'Poring Letter', 5, 20, NULL, 100, 0, 0, 0, NULL, 0, 4294967295, 7, 2, 1, NULL, 10, 0, 0, 604, NULL, NULL, NULL),
(5676, 'Scorpio_Crown', 'Scorpio Crown', 5, 20, NULL, 300, 0, 0, 3, NULL, 0, 4294967295, 7, 2, 256, NULL, 1, 0, 1, 605, NULL, NULL, NULL),
(5677, 'Scorpio_Diadem', 'Scorpio Diadem', 5, 20, NULL, 300, 0, 0, 3, NULL, 1, 4294967295, 7, 2, 256, NULL, 1, 0, 1, 606, 'bonus bDex,2;', NULL, NULL),
(5678, 'Notation_Hairband', 'Notation Hairband', 5, 200, NULL, 100, 0, 0, 5, NULL, 0, 4294967295, 7, 2, 256, NULL, 1, 0, 1, 607, NULL, NULL, NULL),
(5679, 'Engineer_Cap', 'Engineer Cap', 5, 20, NULL, 200, 0, 0, 2, NULL, 1, 4294967295, 7, 2, 256, NULL, 10, 0, 1, 608, NULL, NULL, NULL),
(5680, 'Hawkeyes', 'Hawkeyes', 5, 20, NULL, 100, 0, 0, 0, NULL, 0, 4294967295, 7, 2, 512, NULL, 10, 0, 0, 609, NULL, NULL, NULL),
(5689, 'Queen_Ant_Diadem', 'Queen Ant Diadem', 5, 20, NULL, 300, 0, 0, 1, NULL, 1, 4294967295, 7, 2, 256, NULL, 75, 0, 1, 612, NULL, NULL, NULL),
(5693, 'No_Fear_Underware', 'No Fear Underwear', 5, 0, NULL, 0, 0, 0, 10, NULL, 0, 4294967295, 7, 2, 256, NULL, 20, 0, 0, 30, 'bonus bStr,1; bonus bInt,1; bonus bDex,1;', NULL, NULL),
(5694, 'No_Fear_P_Headgear', 'No Fear P Headgear', 5, 0, NULL, 0, 0, 0, 1, NULL, 1, 4294967294, 7, 2, 256, NULL, 20, 0, 0, 614, 'bonus bVit,1;', NULL, NULL),
(5739, 'Sagittarius_Crown', 'Sagittarius Crown', 5, 20, NULL, 300, 0, 0, 3, NULL, 0, 4294967295, 7, 2, 256, NULL, 1, 0, 1, 617, 'bonus bDex,2;', NULL, NULL),
(5740, 'Sagittarius_Diadem', 'Sagittarius Diadem', 5, 20, NULL, 300, 0, 0, 3, NULL, 0, 4294967295, 7, 2, 256, NULL, 1, 0, 1, 618, 'bonus bDex,2; bonus bMdef,3;', NULL, NULL),
(5744, 'Capricon_Crown', 'Capricon Crown', 5, 20, NULL, 300, 0, 0, 3, NULL, 1, 4294967295, 7, 2, 256, NULL, 1, 0, 1, 621, 'bonus bVit,2; bonus bDex,2;', NULL, NULL),
(5745, 'Capricon_Diadem', 'Capricon Diadem', 5, 20, NULL, 300, 0, 0, 3, NULL, 0, 4294967295, 7, 2, 256, NULL, 1, 0, 1, 622, 'bonus bDex,2; bonus bMdef,5;', NULL, NULL),
(5761, 'Sloth_Hat', 'Sloth Hat', 5, 20, NULL, 800, 0, 0, 3, NULL, 1, 4294967295, 7, 2, 256, NULL, 1, 0, 1, 638, 'bonus bAgi,2; bonus3 bAutoSpell,"AS_SONICBLOW",5,50;', NULL, NULL),
(5762, 'Duneyrr_Helm', 'Duneyrr Helm', 5, 20, NULL, 100, 0, 0, 5, NULL, 0, 4294967295, 7, 2, 256, NULL, 1, 0, 1, 639, 'bonus bAllStats,1; bonus bMdef,5; bonus2 bSubRace,RC_DemiHuman,2; bonus2 bSubRace,RC_Brute,2;', NULL, NULL),
(5772, 'Red_Navy_Hat', 'Red Navy Hat', 5, 3000, NULL, 500, 0, 0, 1, NULL, 0, 4294967295, 7, 2, 256, NULL, 95, 0, 1, 651, NULL, NULL, NULL),
(5773, 'Navy_Beret', 'Navy Beret', 5, 3000, NULL, 500, 0, 0, 1, NULL, 0, 4294967295, 7, 2, 256, NULL, 95, 0, 1, 652, NULL, NULL, NULL),
(5774, 'Red_Pirate_Hat', 'Red Pirate Hat', 5, 3000, NULL, 500, 0, 0, 1, NULL, 0, 4294967295, 7, 2, 256, NULL, 95, 0, 1, 496, NULL, NULL, NULL),
(5777, 'Remover_Hat', 'Remover Hat', 5, 20, NULL, 800, 0, 0, 2, NULL, 0, 4294967295, 7, 2, 256, NULL, 30, 0, 0, 655, 'bonus bMdef,1;', NULL, NULL),
(5778, 'Blue_Arara_Hat', 'Blue Arara Hat', 5, 20, NULL, 100, 0, 0, 3, NULL, 1, 4294967295, 7, 2, 256, NULL, 1, 0, 1, 656, 'bonus bStr,2;', NULL, NULL),
(5779, 'Drooping_Boto', 'Drooping Boto', 5, 20, NULL, 100, 0, 0, 3, NULL, 1, 4294967295, 7, 2, 256, NULL, 1, 0, 1, 657, 'bonus bInt,2;', NULL, NULL),
(5780, 'Tendrilion_Hat', 'Tendrilion Hat', 5, 20, NULL, 100, 0, 0, 0, NULL, 0, 4294967295, 7, 2, 256, NULL, 1, 0, 1, 658, NULL, NULL, NULL),
(5783, 'YellowBunny_Hairband', 'YellowBunny Hairband', 5, 20, NULL, 200, 0, 0, 0, NULL, 1, 4294967295, 7, 2, 256, NULL, 1, 0, 1, 662, 'bonus bStr,1; bonus bInt,1; bonus bDex,2;', NULL, NULL),
(5784, 'PinkBunny_Hairband', 'PinkBunny Hairband', 5, 20, NULL, 200, 0, 0, 0, NULL, 1, 4294967295, 7, 2, 256, NULL, 1, 0, 1, 663, 'bonus bStr,1; bonus bInt,2; bonus bDex,1;', NULL, NULL),
(5785, 'Green_Bunny_Hairband', 'Green Bunny Hairband', 5, 20, NULL, 200, 0, 0, 0, NULL, 1, 4294967295, 7, 2, 256, NULL, 1, 0, 1, 664, 'bonus bStr,2; bonus bInt,1; bonus bDex,1;', NULL, NULL),
(5789, 'Thanatos_Mal_Mask', 'Thanatos Mal Mask', 5, 20, NULL, 100, 0, 0, 3, NULL, 0, 4294967295, 7, 2, 513, NULL, 30, 0, 0, 667, 'bonus bVit,1;', NULL, NULL),
(5791, 'Tenkaippin_Ramen', 'Tenkaippin Ramen', 5, 20, NULL, 500, 0, 0, 1, NULL, 0, 4294967295, 7, 2, 256, NULL, 30, 0, 0, 668, 'bonus bInt,-1; bonus bDex,4;', NULL, NULL),
(5795, 'Red_Dress_Hat', 'Red Dress Hat', 5, 20, NULL, 0, 0, 0, 0, NULL, 0, 4294967295, 7, 2, 256, NULL, 1, 0, 1, 670, 'bonus bMdef,7;', NULL, NULL),
(5813, 'Red_Ph.D_Hat', 'Red Ph.D Hat', 5, 1000, NULL, 500, 0, 0, 0, NULL, 0, 4294967295, 7, 2, 256, NULL, 0, 0, 1, 481, 'bonus bInt,1;', NULL, NULL),
(5847, 'Fools_Day_Helmet', 'Fools Day Helmet', 5, 0, NULL, 0, 0, 0, 0, NULL, 0, 4294967295, 7, 2, 256, NULL, 1, 0, 0, 647, 'bonus bInt,5; bonus bVit,-3;', NULL, NULL),
(5848, 'Robin_Eyepatch', 'Robin Eyepatch', 5, 20, NULL, 0, 0, 0, 0, NULL, 0, 4294967295, 7, 2, 512, NULL, 1, 0, 0, 50, NULL, NULL, NULL),
(5849, 'Doctor_Hairband', 'Doctor Hairband', 5, 20, NULL, 0, 0, 0, 0, NULL, 0, 4294967295, 7, 2, 256, NULL, 1, 0, 0, 60, NULL, NULL, NULL),
(5850, 'Golden_Savage_Hat', 'Golden Savage Hat', 5, 20, NULL, 500, 0, 0, 5, NULL, 0, 4294967295, 7, 2, 256, NULL, 50, 0, 1, 648, NULL, NULL, NULL);