diff options
author | euphyy <euphyy@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2012-11-23 18:30:42 +0000 |
---|---|---|
committer | euphyy <euphyy@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2012-11-23 18:30:42 +0000 |
commit | cb78bae6df1f1a989ffd09a46f92445ee2049f03 (patch) | |
tree | bcf39aa1e1d39b7491f60622626f26a4cef5abe9 /sql-files/item_db_re.sql | |
parent | efbd5d0dd7dbf038333d65d59d0becad59e6e2a4 (diff) | |
download | hercules-cb78bae6df1f1a989ffd09a46f92445ee2049f03.tar.gz hercules-cb78bae6df1f1a989ffd09a46f92445ee2049f03.tar.bz2 hercules-cb78bae6df1f1a989ffd09a46f92445ee2049f03.tar.xz hercules-cb78bae6df1f1a989ffd09a46f92445ee2049f03.zip |
* Removed duplicate isequipped() entries from item_db already written in item_combo_db (bugreport:6924).
* Moved a few remaining isequipped() entries to item_combo_db.
* Follow-up r16940: applied change to SQL and pre-re files, and renamed Size constants to Size_ for consistency.
* Follow-up r16947: fixed mob modes.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16955 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files/item_db_re.sql')
-rw-r--r-- | sql-files/item_db_re.sql | 106 |
1 files changed, 53 insertions, 53 deletions
diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql index 8b2e528d9..c2f8d6407 100644 --- a/sql-files/item_db_re.sql +++ b/sql-files/item_db_re.sql @@ -577,7 +577,7 @@ REPLACE INTO `item_db_re` VALUES (1186,'Death_Guidance','Death Guidance',4,20,NU REPLACE INTO `item_db_re` VALUES (1187,'Krieger_Twohand_Sword1','Glorious Claymore',4,20,NULL,0,'220',NULL,1,NULL,0x00004082,7,2,34,4,'80',1,3,'bonus2 bAddRace,RC_DemiHuman,70; bonus2 bIgnoreDefRate,RC_DemiHuman,25; bonus bUnbreakableWeapon,0; if(getrefine()>5) { bonus2 bAddRace,RC_DemiHuman,pow(((getrefine()>14)?14:getrefine())-3,1); bonus2 bIgnoreDefRate,RC_DemiHuman,5; } if(getrefine()>8) { bonus3 bAutoSpell,"LK_CONCENTRATION",getskilllv("LK_CONCENTRATION")>1?getskilllv("LK_CONCENTRATION"):1,30; bonus3 bAutoSpell,"LK_AURABLADE",getskilllv("LK_AURABLADE")>1?getskilllv("LK_AURABLADE"):1,30; }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1188,'Veteran_Sword','Veteran Sword',4,10000,NULL,2000,'180',NULL,1,1,0x00004082,7,2,34,4,'80',1,3,'if(getskilllv("SM_BASH")==10) { bonus2 bSkillAtk,"SM_BASH",50; } if(getskilllv("KN_BOWLINGBASH")==10) { bonus2 bSkillAtk,"KN_BOWLINGBASH",50; } bonus bStr,1; bonus bDex,1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1189,'Krasnaya','Krasnaya',4,20,NULL,3800,'200',NULL,2,3,0x00004082,2,2,34,2,'50',1,3,'if(readparam(bStr)>=95) { bonus bAtk,20; }',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (1190,'Claymore_C','Claymore',4,NULL,NULL,0,'220',NULL,1,NULL,0x00004080,7,2,34,3,'1',NULL,3,'bonus2 bAddSize,0,40; bonus2 bAddSize,1,40; bonus2 bAddSize,2,40;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (1190,'Claymore_C','Claymore',4,NULL,NULL,0,'220',NULL,1,NULL,0x00004080,7,2,34,3,'1',NULL,3,'bonus2 bAddSize,Size_Small,40; bonus2 bAddSize,Size_Medium,40; bonus2 bAddSize,Size_Large,40;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1191,'Alca_Bringer','Alca Bringer',4,20,NULL,3400,'280',NULL,2,NULL,0x00004082,7,2,34,3,'100',1,3,'bonus bAspd,(getrefine()/2);',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1192,'P_Slayer1','Eden Slayer I',4,NULL,NULL,0,'162',NULL,1,NULL,0x00004082,7,2,34,2,'26',NULL,3,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (1193,'P_Slayer2','Eden Slayer II',4,NULL,NULL,0,'185',NULL,1,NULL,0x00004082,7,2,34,2,'40',NULL,3,NULL,NULL,NULL); @@ -673,7 +673,7 @@ REPLACE INTO `item_db_re` VALUES (1282,'Krieger_Katar2','Glorious Jamadhar',4,20 REPLACE INTO `item_db_re` VALUES (1283,'Katar_Of_Speed','Katar Of Speed',4,20,NULL,0,'175',NULL,1,NULL,0x00001000,7,2,34,4,NULL,NULL,16,'bonus2 bSkillAtk,"AS_SONICBLOW",25; bonus bAspdRate,3;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1284,'Krishna','Krishna',4,20,NULL,1200,'120',NULL,1,2,0x00001000,2,2,34,3,'50',1,16,'bonus2 bSkillAtk,"AS_GRIMTOOTH",10; if(getskilllv("AS_SONICBLOW")) { bonus3 bAutoSpell,"AS_SONICBLOW",getskilllv("AS_SONICBLOW"),5; }else{ bonus3 bAutoSpell,"AS_SONICBLOW",1,5; }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1285,'Cakram','Chakram',4,20,NULL,1000,'130',NULL,1,2,0x00001000,2,2,34,3,'50',1,16,'if(getskilllv("AS_KATAR")==10) { bonus bHit,10; } bonus2 bSkillAtk,"ASC_METEORASSAULT",20;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (1286,'Jamadhar_C','Jamadhar',4,NULL,NULL,0,'200',NULL,1,NULL,0x00001000,7,2,34,3,'1',NULL,16,'bonus bUnbreakableWeapon,0; bonus2 bAddSize,0,40; bonus2 bAddSize,1,40; bonus2 bAddSize,2,40;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (1286,'Jamadhar_C','Jamadhar',4,NULL,NULL,0,'200',NULL,1,NULL,0x00001000,7,2,34,3,'1',NULL,16,'bonus bUnbreakableWeapon,0; bonus2 bAddSize,Size_Small,40; bonus2 bAddSize,Size_Medium,40; bonus2 bAddSize,Size_Large,40;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1287,'Durga','Durga',4,20,NULL,1200,'190',NULL,1,1,0x00001000,7,2,34,3,'100',1,16,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (1288,'Bloody_Fear_C','Bloody Fear',4,1,NULL,0,'145',NULL,1,NULL,0x00001000,7,2,34,4,'1',NULL,16,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (1289,'P_Katar1','Eden Katar I',4,NULL,NULL,0,'155',NULL,1,NULL,0x00001000,7,2,34,3,'60',NULL,16,NULL,NULL,NULL); @@ -694,7 +694,7 @@ REPLACE INTO `item_db_re` VALUES (1308,'Golden_Axe','Golden Axe',4,20,NULL,3000, REPLACE INTO `item_db_re` VALUES (1309,'Orcish_Axe_','Orcish Axe',4,20,NULL,1500,'75',NULL,1,4,0x000654E3,7,2,2,3,'3',1,6,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (1310,'Krieger_Onehand_Axe1','Glorious Cleaver',4,20,NULL,0,'130',NULL,1,NULL,0x000444A2,7,2,2,4,'80',1,6,'bonus2 bAddRace,RC_DemiHuman,75; bonus2 bIgnoreDefRate,RC_DemiHuman,20; bonus bUnbreakableWeapon,0; if(getrefine()>5) { bonus2 bAddRace,RC_DemiHuman,pow(((getrefine()>14)?14:getrefine())-4,2); bonus2 bIgnoreDefRate,RC_DemiHuman,5; bonus bAspdRate,5; } if(getrefine()>8) { bonus bAspdRate,5; bonus3 bAutoSpell,"NPC_CRITICALWOUND",1,50; bonus4 bAutoSpellOnSkill,"MC_MAMMONITE","NPC_CRITICALWOUND",2,200; }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1311,'Vecer_Axe','Vecer Axe',4,20,NULL,1500,'140',NULL,1,2,0x000444A2,2,2,2,3,'50',1,6,'if(readparam(bLuk)>=90) { bonus bAtk,20; } if(readparam(bDex)>=90) { bonus bCritical,5; } if(readparam(bDex)>=90||readparam(bLuk)>=90) { bonus2 bSkillAtk,"MC_MAMMONITE",15; }',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (1312,'Orcish_Axe_C','Orcish Axe',4,NULL,NULL,0,'110',NULL,1,NULL,0x000654E3,7,2,2,3,'1',NULL,6,'bonus2 bAddSize,0,70; bonus2 bAddSize,1,70; bonus2 bAddSize,2,70;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (1312,'Orcish_Axe_C','Orcish Axe',4,NULL,NULL,0,'110',NULL,1,NULL,0x000654E3,7,2,2,3,'1',NULL,6,'bonus2 bAddSize,Size_Small,70; bonus2 bAddSize,Size_Medium,70; bonus2 bAddSize,Size_Large,70;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1313,'Tourist_Axe','Tourist Axe',4,NULL,NULL,500,'77',NULL,1,NULL,0x000654E3,7,2,2,1,'1',NULL,6,'bonus bStr,2;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1314,'F_Tomahawk_C','Tomahawk',4,2,NULL,0,'200',NULL,1,NULL,0x000444A2,7,2,34,4,NULL,NULL,7,'bonus bAtkEle,Ele_Wind;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1315,'F_Right_Epsilon_C','Light Epsilon',4,1,NULL,0,'229',NULL,1,NULL,0x000444A2,7,2,34,4,'1',NULL,7,'bonus bAtkEle,Ele_Holy; bonus bStr,10;',NULL,NULL); @@ -723,9 +723,9 @@ REPLACE INTO `item_db_re` VALUES (1371,'Doom_Slayer_','Doom Slayer',4,20,NULL,60 REPLACE INTO `item_db_re` VALUES (1372,'Right_Epsilon_C','Light Epsilon',4,1,NULL,0,'229',NULL,1,NULL,0x000444A2,7,2,34,4,'1',NULL,7,'bonus bAtkEle,Ele_Holy; skill "AL_HEAL",3; bonus2 bAddRace,RC_Demon,3; bonus bStr,10; bonus bSpeedRate,25;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1373,'Brood_Axe_C','Refined Bloody Axe',4,2,NULL,0,'205',NULL,1,NULL,0x000444A2,7,2,34,4,NULL,NULL,7,'bonus bStr,20; bonus bSpeedRate,25; bonus bAspdRate,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1374,'Tomahawk_C','Tomahawk',4,2,NULL,0,'200',NULL,1,NULL,0x000444A2,7,2,34,4,NULL,NULL,7,'bonus bAtkEle,Ele_Wind; skill "ITM_TOMAHAWK",1;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (1375,'Berdysz','Berdysz',4,20,NULL,2500,'200',NULL,1,2,0x000444A2,2,2,34,3,'70',1,7,'bonus2 bSubSize,1,13; bonus2 bSubSize,2,15;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (1375,'Berdysz','Berdysz',4,20,NULL,2500,'200',NULL,1,2,0x000444A2,2,2,34,3,'70',1,7,'bonus2 bSubSize,Size_Medium,13; bonus2 bSubSize,Size_Large,15;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1376,'Heart_Breaker','Heart Breaker',4,20,NULL,2000,'175',NULL,1,1,0x000444A2,2,2,34,4,'70',1,7,'bonus bCritical,20+getrefine(); bonus bAspdRate,5; if((Class==Job_Whitesmith)||(Class==Job_Creator)) bonus3 bAutoSpell,"BS_HAMMERFALL",3,30;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (1377,'Hurricane_Fury','Hurricane\'s Fury',4,20,NULL,3500,'332',NULL,1,1,0x000444A2,2,2,34,4,'80',1,7,'bonus2 bSubSize,1,10+getrefine(); bonus bAspdRate,getrefine(); bonus3 bAutoSpell,"NPC_PULSESTRIKE",5,20;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (1377,'Hurricane_Fury','Hurricane\'s Fury',4,20,NULL,3500,'332',NULL,1,1,0x000444A2,2,2,34,4,'80',1,7,'bonus2 bSubSize,Size_Medium,10+getrefine(); bonus bAspdRate,getrefine(); bonus3 bAutoSpell,"NPC_PULSESTRIKE",5,20;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1378,'Great_Axe_C','Refined Great Axe',4,1,NULL,0,'215',NULL,1,NULL,0x000444A2,7,2,34,4,NULL,NULL,7,'bonus bStr,5; bonus bHit,20; bonus2 bAddSkillBlow,"MC_MAMMONITE",5; bonus2 bAddEff,Eff_Stun,1500;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1379,'BF_Two_Handed_Axe1','Valorous Insane Battle Axe',4,20,NULL,0,'200',NULL,1,NULL,0x000444A2,7,2,34,3,'80',1,7,'bonus bStr,3; bonus2 bAddRace,RC_DemiHuman,55; bonus2 bIgnoreDefRate,RC_DemiHuman,20; bonus bUnbreakableWeapon,0;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1380,'BF_Two_Handed_Axe2','Brave Insane Battle Axe',4,20,NULL,0,'200',NULL,1,NULL,0x000444A2,7,2,34,3,'80',1,7,'bonus bStr,3; bonus2 bAddRace,RC_DemiHuman,55; autobonus "{bonus bBreakArmorRate,10000;}",20,3000,BF_WEAPON,"{specialeffect2 EF_POTION_BERSERK;}"; bonus bUnbreakableWeapon,0;',NULL,NULL); @@ -736,7 +736,7 @@ REPLACE INTO `item_db_re` VALUES (1384,'Veteran_Axe','Veteran Axe',4,10000,NULL, REPLACE INTO `item_db_re` VALUES (1385,'Bradium_Stonehammer','Bradium Stone Hammer',4,20,NULL,2700,'210',NULL,1,NULL,0x000444A2,2,2,34,4,'75',1,7,'bonus3 bAddEffOnSkill,"BS_HAMMERFALL",Eff_Stun,500+(200*getrefine());',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1386,'Doom_Slayer_I','Doom Slayer',4,NULL,NULL,0,'20',NULL,1,NULL,0x000444A2,7,2,34,4,NULL,NULL,7,'if(readparam(bStr)>=95){ bonus bBaseAtk,400; bonus2 bAddEff,Eff_Stun,3000; bonus bAspdRate,-25; bonus bUseSPrate,100; bonus bBreakArmorRate,500; }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1387,'Giant_Axe','Giant Axe',4,20,NULL,4000,'330',NULL,1,1,0x000444A2,2,2,34,3,'50',1,7,'bonus2 bSkillAtk,"WS_CARTTERMINATION",15; if(readparam(bStr)>=95) { bonus bHit,10; bonus bAspdRate,3; }',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (1388,'Two_Handed_Axe_C','Two-Handed Axe',4,NULL,NULL,0,'220',NULL,1,NULL,0x000444A2,7,2,34,3,'1',NULL,7,'bonus2 bAddSize,0,40; bonus2 bAddSize,1,40; bonus2 bAddSize,2,40;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (1388,'Two_Handed_Axe_C','Two-Handed Axe',4,NULL,NULL,0,'220',NULL,1,NULL,0x000444A2,7,2,34,3,'1',NULL,7,'bonus2 bAddSize,Size_Small,40; bonus2 bAddSize,Size_Medium,40; bonus2 bAddSize,Size_Large,40;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1389,'E_Tomahawk_C','Tomahawk',4,2,NULL,0,'200',NULL,1,NULL,0x000444A2,7,2,34,4,NULL,NULL,7,'bonus bAtkEle,Ele_Wind;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1390,'E_Right_Epsilon_C','Light Epsilon',4,1,NULL,0,'229',NULL,1,NULL,0x000444A2,7,2,34,4,'1',NULL,7,'bonus bAtkEle,Ele_Holy; bonus bStr,10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1391,'P_Two_Handed_Axe1','Eden Two-Handed Axe I',4,NULL,NULL,0,'195',NULL,1,NULL,0x000444A2,7,2,34,3,'60',NULL,7,NULL,NULL,NULL); @@ -769,13 +769,13 @@ REPLACE INTO `item_db_re` VALUES (1420,'Long_Horn','Long Horn',4,20,NULL,1000,'1 REPLACE INTO `item_db_re` VALUES (1421,'Battle_Hook','Battle Hook',4,20,NULL,900,'140',NULL,3,1,0x00004082,2,2,2,4,'65',1,4,'bonus2 bAddEff,Eff_Stun,500; bonus2 bAddRace,RC_DemiHuman,20; skill "KN_PIERCE",3;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1422,'Hunting_Spear','Hunting Spear',4,20,NULL,4200,'180',NULL,3,1,0x00004082,2,2,2,4,'60',1,4,'bonus bIgnoreDefRace,RC_Brute; bonus3 bAddMonsterDropItem,517,RC_Brute,1000; bonus3 bAutoSpell,"LK_JOINTBEAT",3,100;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1423,'Pole_XO','Pole XO',4,20,NULL,0,'120',NULL,3,NULL,0x00004082,7,2,2,1,NULL,NULL,4,'bonus2 bAddRace,RC_Boss,50; bonus2 bAddRace,RC_NonBoss,50;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (1424,'Skewer_C','Refined Brocca',4,1,NULL,0,'149',NULL,3,NULL,0x00004082,7,2,2,4,NULL,NULL,4,'bonus bIgnoreDefRace,RC_NonBoss; bonus2 bAddSize,1,20;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (1424,'Skewer_C','Refined Brocca',4,1,NULL,0,'149',NULL,3,NULL,0x00004082,7,2,2,4,NULL,NULL,4,'bonus bIgnoreDefRace,RC_NonBoss; bonus2 bAddSize,Size_Medium,20;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1425,'BF_Spear1','Assaulter Spear',4,20,NULL,0,'60',NULL,3,NULL,0x00004082,7,2,2,3,'80',1,4,'bonus bStr,2; bonus2 bAddRace,RC_DemiHuman,95; bonus2 bIgnoreDefRate,RC_DemiHuman,20; bonus bUnbreakableWeapon,0; if(BaseJob==Job_Crusader) bonus bAspdRate,20;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1426,'Krieger_Onehand_Spear1','Glorious Spear',4,20,NULL,0,'130',NULL,3,NULL,0x00004082,7,2,2,4,'80',1,4,'bonus2 bAddRace,RC_DemiHuman,95; bonus2 bIgnoreDefRate,RC_DemiHuman,20; bonus bUnbreakableWeapon,0; if(getrefine()>5) { bonus2 bAddRace,RC_DemiHuman,(getrefine()-4)*(getrefine()-4); bonus2 bIgnoreDefRate,RC_DemiHuman,5; bonus bAspdRate,10; } if(getrefine()>8) { if(BaseJob==Job_Knight) bonus4 bAutoSpellOnSkill,"KN_PIERCE","NPC_CRITICALWOUND",2,200; else if(BaseJob==Job_Crusader) bonus3 bAutoSpell,"PA_PRESSURE",5,100; }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1427,'Spear_Of_Excellent','Spear Of Excellent',4,20,NULL,0,'160',NULL,3,NULL,0x00004082,7,2,2,3,NULL,NULL,4,'bonus2 bSkillAtk,"SM_MAGNUM",25; bonus bStr,2;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1428,'Long_Horn_M','Long Horn',4,20,NULL,1000,'150',NULL,3,1,0x00004082,2,2,2,4,'65',1,4,'bonus bAtkEle,Ele_Holy; bonus2 bAddEff,Eff_Bleeding,500; skill "TF_DETOXIFY",1; bonus bUnbreakableWeapon,0;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1429,'Hunting_Spear_M','Hunting Spear',4,20,NULL,4200,'180',NULL,3,1,0x00004082,2,2,2,4,'60',1,4,'bonus bIgnoreDefRace,RC_Brute; bonus3 bAddMonsterDropItem,517,RC_Brute,1000; bonus3 bAutoSpell,"LK_JOINTBEAT",3,500;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (1430,'Pike_C','Pike',4,NULL,NULL,0,'74',NULL,3,NULL,0x00004082,7,2,2,1,'1',NULL,4,'bonus2 bAddSize,0,70; bonus2 bAddSize,1,70; bonus2 bAddSize,2,70;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (1430,'Pike_C','Pike',4,NULL,NULL,0,'74',NULL,3,NULL,0x00004082,7,2,2,1,'1',NULL,4,'bonus2 bAddSize,Size_Small,70; bonus2 bAddSize,Size_Medium,70; bonus2 bAddSize,Size_Large,70;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1431,'F_Pole_Axe_C','Pole Axe',4,1,NULL,4800,'195',NULL,3,NULL,0x00004082,7,2,2,3,'1',NULL,4,'bonus bStr,1; bonus bInt,2; bonus bDex,1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1432,'E_Pole_Axe_C','Pole Axe',4,1,NULL,4800,'195',NULL,3,NULL,0x00004082,7,2,2,3,'1',NULL,4,'bonus bStr,1; bonus bInt,2; bonus bDex,1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1433,'Imperial_Spear','Imperial Spear',4,20,NULL,1800,'180:50',NULL,3,1,0x00004082,7,2,2,3,'102',1,4,'bonus2 bSkillAtk,"LG_CANNONSPEAR",20+getrefine()/2; bonus2 bSkillAtk,"LG_BANISHINGPOINT",20+getrefine()/2;',NULL,NULL); @@ -821,7 +821,7 @@ REPLACE INTO `item_db_re` VALUES (1483,'Ivory_Lance','Ivory Lance',4,20,NULL,100 REPLACE INTO `item_db_re` VALUES (1484,'Cardo','Cardo',4,20,NULL,5600,'150',NULL,3,1,0x00000080,2,2,34,4,'70',1,5,'bonus bAspdRate,-10; bonus bDef,getrefine()/2;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1485,'Battle_Fork','Battle Fork',4,20,NULL,700,'112',NULL,3,4,0x00004082,2,2,34,2,'50',1,5,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (1486,'Krieger_Twohand_Spear1','Glorious Lance',4,20,NULL,0,'220',NULL,3,NULL,0x00004082,7,2,34,4,'80',1,5,'bonus2 bAddRace,RC_DemiHuman,70; bonus2 bIgnoreDefRate,RC_DemiHuman,25; bonus bUnbreakableWeapon,0; if(getrefine()>5) { bonus2 bAddRace,RC_DemiHuman,pow(((getrefine()>14)?14:getrefine())-4,2); bonus2 bIgnoreDefRate,RC_DemiHuman,5; } if(getrefine()>8) { if(BaseJob==Job_Knight) bonus4 bAutoSpellOnSkill,"KN_PIERCE","NPC_CRITICALWOUND",2,200; else if(BaseJob==Job_Crusader) bonus3 bAutoSpell,"PA_PRESSURE",5,200; }',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (1487,'Lance_C','Lance',4,NULL,NULL,0,'220',NULL,3,NULL,0x00004082,7,2,34,3,'1',NULL,5,'bonus2 bAddSize,0,50; bonus2 bAddSize,1,50; bonus2 bAddSize,2,50;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (1487,'Lance_C','Lance',4,NULL,NULL,0,'220',NULL,3,NULL,0x00004082,7,2,34,3,'1',NULL,5,'bonus2 bAddSize,Size_Small,50; bonus2 bAddSize,Size_Medium,50; bonus2 bAddSize,Size_Large,50;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1488,'Ahlspiess_C','Ahlspiess',4,20,NULL,0,'135',NULL,3,NULL,0x00004080,7,2,34,4,'1',1,5,'bonus bIgnoreDefRace,RC_NonBoss; bonus bIgnoreDefRace,RC_Boss; bonus2 bAddRace,RC_DemiHuman,10; bonus3 bAutoSpell,"KN_PIERCE",5,30;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1489,'Marlin','Marlin',4,NULL,NULL,0,'220',NULL,3,NULL,0x00004082,2,2,34,1,'50',NULL,5,'bonus bUnbreakableWeapon,0; bonus3 bAddEffOnSkill,"KN_PIERCE",Eff_Bleeding,1000; bonus3 bAddEffOnSkill,"LK_SPIRALPIERCE",Eff_Bleeding,1000; bonus2 bSkillAtk,"LK_SPIRALPIERCE",100; bonus2 bSkillAtk,"LG_INSPIRATION",50; if(BaseLevel>99) { bonus bBaseAtk,30; }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1490,'Gigantic_Lance','Gigantic Lance',4,20,NULL,20000,'20',NULL,3,NULL,0x00000080,7,2,34,4,'140',1,5,'bonus bAspd,-10; if(readparam(bStr)>=120){ bonus bBaseAtk,300; }',NULL,'heal 0,-600;'); @@ -908,7 +908,7 @@ REPLACE INTO `item_db_re` VALUES (1576,'Krieger_Book1','Glorious Tablet',4,20,NU REPLACE INTO `item_db_re` VALUES (1577,'Krieger_Book2','Glorious Apocalypse',4,20,NULL,0,'90:115',NULL,1,NULL,0x00410100,7,2,2,4,'80',1,15,'bonus2 bAddRace,RC_DemiHuman,80; bonus2 bIgnoreDefRate,RC_DemiHuman,25; bonus bUnbreakableWeapon,0; if(getrefine()>5) bonus2 bIgnoreDefRate,RC_DemiHuman,5; if(getrefine()>8) { bonus bMatkRate,5; bonus bVariableCastrate,-5; bonus bDelayRate,-5; }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1578,'Book_Of_Prayer','Book Of Prayer',4,20,NULL,0,'140',NULL,1,NULL,0x00410100,7,2,2,3,NULL,NULL,15,'bonus bVit,2; bonus bMdef,2; bonus bMaxSPrate,10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1579,'Death_Note_M','Book of the Dead',4,20,NULL,1000,'137',NULL,1,2,0x00410100,7,2,2,4,'85',1,15,'bonus bMatkRate,15; bonus bStr,3; bonus bInt,3; bonus bLuk,-20; bonus2 bWeaponComaRace,RC_DemiHuman,10; bonus bAspdRate,getrefine(); if(BaseJob==Job_Sage) bonus3 bAutoSpell,"NPC_HELLJUDGEMENT",5,20;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (1580,'Encyclopedia_C','Giant Encyclopedia',4,NULL,NULL,0,'145:100',NULL,1,NULL,0x00410100,7,2,2,3,NULL,NULL,15,'bonus bMatkRate,15; bonus bInt,3; bonus bDex,2; bonus bCritical,20+((readparam(bLuk)*2)/10); bonus2 bAddSize,0,40; bonus2 bAddSize,1,40; bonus2 bAddSize,2,40;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (1580,'Encyclopedia_C','Giant Encyclopedia',4,NULL,NULL,0,'145:100',NULL,1,NULL,0x00410100,7,2,2,3,NULL,NULL,15,'bonus bMatkRate,15; bonus bInt,3; bonus bDex,2; bonus bCritical,20+((readparam(bLuk)*2)/10); bonus2 bAddSize,Size_Small,40; bonus2 bAddSize,Size_Medium,40; bonus2 bAddSize,Size_Large,40;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1581,'F_Diary_Of_Great_Sage_C','Diary Of Great Sage',4,1,NULL,0,'135',NULL,1,2,0x00410100,7,2,2,3,'1',NULL,15,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (1582,'E_Diary_Of_Great_Sage_C','Diary Of Great Sage',4,1,NULL,0,'135',NULL,1,2,0x00410100,7,2,2,3,'1',NULL,15,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (1583,'P_Book1','Eden Book I',4,NULL,NULL,0,'135:110',NULL,1,NULL,0x00410100,7,2,2,3,'60',NULL,15,NULL,NULL,NULL); @@ -949,7 +949,7 @@ REPLACE INTO `item_db_re` VALUES (1627,'Staffy','Staffy',4,20,NULL,0,'40:120',NU REPLACE INTO `item_db_re` VALUES (1628,'Survival_Rod_C','Refined Survivor\'s Rod',4,1,NULL,0,'71:145',NULL,1,NULL,0x00818314,7,2,2,3,NULL,NULL,10,'bonus bDex,4; bonus bMatkRate,20; bonus bMaxHP,500;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1629,'Walking_Stick','Gentleman\'s Staff',4,20,NULL,500,'40:125',NULL,1,1,0x00818314,7,2,2,4,'50',1,10,'bonus bDex,1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1630,'Release_Of_Wish','Release of Wish',4,20,NULL,500,'30:125',NULL,1,NULL,0x00810204,7,2,2,3,'50',1,10,'bonus bInt,3; bonus bHealPower,5; autobonus "{bonus2 bSPRegenRate,100,2000; bonus2 bHPRegenRate,50,2000;}",10,10000,BF_MAGIC,"{specialeffect2 EF_HEAL;}";',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (1631,'Holy_Stick','Holy Stick',4,20,NULL,500,'50:140',NULL,1,1,0x00008100,7,2,2,4,'70',1,10,'bonus bAtkEle,Ele_Holy; bonus bMatkRate,15; bonus2 bVariableCastrate,156,-25; bonus2 bVariableCastrate,77,-25; bonus2 bVariableCastrate,79,-25;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (1631,'Holy_Stick','Holy Stick',4,20,NULL,500,'50:140',NULL,1,1,0x00008100,7,2,2,4,'70',1,10,'bonus bAtkEle,Ele_Holy; bonus bMatkRate,15; bonus2 bVariableCastrate,"AL_HOLYLIGHT",-25; bonus2 bVariableCastrate,"PR_TURNUNDEAD",-25; bonus2 bVariableCastrate,"PR_MAGNUS",-25;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1632,'BF_Staff1','Warlock\'s Magic Wand',4,20,NULL,0,'70:125',NULL,1,NULL,0x00818314,7,2,2,3,'80',1,10,'bonus bInt,4; bonus bDex,3; bonus bMatkRate,15; bonus2 bIgnoreMdefRate,RC_DemiHuman,25; bonus3 bAddEff,Eff_Stun,500,ATF_SKILL; bonus bUnbreakableWeapon,0;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1633,'BF_Staff2','Warlock\'s Battle Wand',4,20,NULL,0,'70:125',NULL,1,NULL,0x00818314,7,2,2,3,'80',1,10,'bonus bInt,3; bonus bDex,3; bonus bMatkRate,15; bonus2 bMagicAddRace,RC_DemiHuman,15; bonus3 bAddEff,Eff_Stun,500,ATF_SKILL; bonus bUnbreakableWeapon,0;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1634,'BF_Staff3','Strong Recovery Wand',4,20,NULL,0,'70:125',NULL,1,NULL,0x00818314,7,2,2,3,'80',1,10,'bonus bMatkRate,15; bonus bHealPower,14; bonus2 bSPRegenRate,5,10000; bonus bUnbreakableWeapon,0;',NULL,NULL); @@ -975,10 +975,10 @@ REPLACE INTO `item_db_re` VALUES (1653,'Staff_Of_Healing_C','Staff of Healing',4 REPLACE INTO `item_db_re` VALUES (1654,'Mental_Stick','Mental Stick',4,20,NULL,500,'40:170',NULL,1,1,0x00818315,7,2,2,3,'102',1,10,'if(getrefine()>5) { bonus2 bSkillAtk,"SO_PSYCHIC_WAVE",(getrefine()-5)*2; bonus bMaxHPRate,-(getrefine()-5)*2; } bonus2 bSkillVariableCast,"SO_PSYCHIC_WAVE",-3000; bonus2 bSkillUseSP,"SO_PSYCHIC_WAVE",-60;',NULL,'itemheal 0,-100;'); #1655, #1656, -REPLACE INTO `item_db_re` VALUES (1657,'Mercy_Staff1','Mercy Staff I',4,20,NULL,500,'30:160',NULL,1,2,0x00000100,7,2,2,3,'100',1,10,'bonus bInt,2; bonus bAtkEle,Ele_Holy; bonus bHealPower,10; if(isequipped(2471,2569,15029)){ bonus bHealPower,25; };',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (1657,'Mercy_Staff1','Mercy Staff I',4,20,NULL,500,'30:160',NULL,1,2,0x00000100,7,2,2,3,'100',1,10,'bonus bInt,2; bonus bAtkEle,Ele_Holy; bonus bHealPower,10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1658,'P_Staff3','Eden Staff III',4,NULL,NULL,0,'60:170',NULL,1,NULL,0x00818314,7,2,2,3,'60',NULL,10,'bonus bInt,4;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1659,'Light_of_Recovery','Light of Recovery',4,56000,NULL,400,'30:160',NULL,1,1,0x00000100,7,2,2,4,'110',1,10,'bonus bAtkEle,Ele_Holy; bonus bUnbreakableWeapon,0; bonus bHealPower,(getrefine()*3/2); bonus bUseSPrate,(getrefine()*3);',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (1660,'Mercy_Staff2','Mercy Staff II',4,20,NULL,500,'30:180',NULL,1,1,0x00000100,7,2,2,3,'130',1,10,'bonus bAtkEle,Ele_Holy; bonus bInt,4; bonus bHealPower,20; if(isequipped(2471,2569,15029)){ bonus bHealPower,45; bonus3 bAutoSpellWhenHit,"AB_SILENTIUM",1,10; };',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (1660,'Mercy_Staff2','Mercy Staff II',4,20,NULL,500,'30:180',NULL,1,1,0x00000100,7,2,2,3,'130',1,10,'bonus bAtkEle,Ele_Holy; bonus bInt,4; bonus bHealPower,20;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1661,'Mental_Destroyer','Mental Destroyer',4,20,NULL,1400,'100:50',NULL,1,NULL,0x00000200,7,2,2,4,'95',1,10,'bonus bInt,10; bonus bMdef,20; bonus bUnbreakableWeapon,0; bonus2 bSPVanishRate,10000,5; if(getrefine()>5) { bonus2 bSPVanishRate,10000,5; }',NULL,NULL); # Bows REPLACE INTO `item_db_re` VALUES (1701,'Bow','Bow',4,1000,NULL,500,'15',NULL,5,3,0x000A0848,7,2,34,1,'4',1,11,NULL,NULL,NULL); @@ -1081,12 +1081,12 @@ REPLACE INTO `item_db_re` VALUES (1820,'Electric_Fist','Electric Fist',4,20,NULL REPLACE INTO `item_db_re` VALUES (1821,'Seismic_Fist','Seismic Fist',4,20,NULL,650,'80',NULL,1,3,0x00008100,7,2,2,3,'75',1,12,'bonus3 bAutoSpell,"SA_SEISMICWEAPON",5,10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1822,'Combo_Battle_Glove','Combo Battle Glove',4,20,NULL,500,'30',NULL,1,4,0x00008100,7,2,2,3,'60',1,12,'bonus2 bSkillAtk,"MO_TRIPLEATTACK",15; bonus2 bSkillAtk,"MO_CHAINCOMBO",15; bonus2 bSkillAtk,"MO_COMBOFINISH",20;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1823,'BF_Knuckle1','Valorous Battle Fist',4,20,NULL,0,'30',NULL,1,NULL,0x00008100,7,2,2,3,'80',1,12,'bonus bStr,2; bonus bAgi,1; bonus2 bAddRace,RC_DemiHuman,95; bonus2 bIgnoreDefRate,RC_DemiHuman,20; bonus4 bAutoSpell,"CH_SOULCOLLECT",1,5,0; bonus bUnbreakableWeapon,0;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (1824,'BF_Knuckle2','Brave Battle Fist',4,20,NULL,0,'30',NULL,1,NULL,0x00008100,7,2,2,3,'80',1,12,'bonus bStr,2; bonus bInt,1; bonus2 bAddRace,RC_DemiHuman,95; bonus2 bVariableCastrate,271,-25; autobonus "{bonus2 bVariableCastrate,271,-100;}",50,6000,BF_WEAPON,"{specialeffect2 EF_SUFFRAGIUM;}"; bonus bUnbreakableWeapon,0;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (1824,'BF_Knuckle2','Brave Battle Fist',4,20,NULL,0,'30',NULL,1,NULL,0x00008100,7,2,2,3,'80',1,12,'bonus bStr,2; bonus bInt,1; bonus2 bAddRace,RC_DemiHuman,95; bonus2 bVariableCastrate,"MO_EXTREMITYFIST",-25; autobonus "{bonus2 bVariableCastrate,\\\"MO_EXTREMITYFIST\\\",-100;}",50,6000,BF_WEAPON,"{specialeffect2 EF_SUFFRAGIUM;}"; bonus bUnbreakableWeapon,0;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1825,'Horn_Of_Hilthrion','Horn of Hillslion',4,20,NULL,600,'95',NULL,1,3,0x00008000,2,2,2,3,'60',1,12,'bonus3 bAutoSpell,"NPC_CRITICALWOUND",1,100; bonus4 bAutoSpellOnSkill,"CH_PALMSTRIKE","MO_INVESTIGATE",1,100; bonus3 bAutoSpell,"MO_CALLSPIRITS",5,100;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1826,'Krieger_Knuckle1','Glorious Claw',4,20,NULL,0,'30',NULL,1,NULL,0x00008100,7,2,2,4,'80',1,12,'bonus2 bAddRace,RC_DemiHuman,95; bonus2 bIgnoreDefRate,RC_DemiHuman,20; bonus bUnbreakableWeapon,0; if(getrefine()>5) { bonus2 bAddRace,RC_DemiHuman,pow(((getrefine()>14)?14:getrefine())-4,2); bonus2 bIgnoreDefRate,RC_DemiHuman,5; } if(getrefine()>8) { bonus3 bAutoSpell,"MO_INVESTIGATE",5,(getrefine()*10-50); bonus3 bAutoSpell,"AL_DECAGI",1,(getrefine()*10-50); }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1827,'Krieger_Knuckle2','Glorious Fist',4,20,NULL,0,'30',NULL,1,NULL,0x00008100,7,2,2,4,'80',1,12,'bonus2 bAddRace,RC_DemiHuman,95; bonus2 bIgnoreDefRate,RC_DemiHuman,20; bonus bUnbreakableWeapon,0; if(getrefine()>5) { bonus2 bAddRace,RC_DemiHuman,pow(((getrefine()>14)?14:getrefine())-4,2); bonus2 bIgnoreDefRate,RC_DemiHuman,5; } if(getrefine()>8) { bonus2 bVariableCastrate,"MO_EXTREMITYFIST",-100; bonus4 bautospellonskill,"MO_EXPLOSIONSPIRITS","CH_SOULCOLLECT",1,1000; bonus bFixedCastrate,-100; }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1828,'Monk_Knuckle','Monk Knuckle',4,20,NULL,0,'150',NULL,1,NULL,0x00008100,7,2,2,4,NULL,NULL,12,'bonus bInt,2; bonus2 bSkillAtk,"MO_FINGEROFFENSIVE",25;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (1829,'Fist_C','Fist',4,NULL,NULL,0,'150',NULL,1,NULL,0x00008100,7,2,2,3,'1',NULL,12,'bonus2 bAddSize,0,40; bonus2 bAddSize,1,40; bonus2 bAddSize,2,40;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (1829,'Fist_C','Fist',4,NULL,NULL,0,'150',NULL,1,NULL,0x00008100,7,2,2,3,'1',NULL,12,'bonus2 bAddSize,Size_Small,40; bonus2 bAddSize,Size_Medium,40; bonus2 bAddSize,Size_Large,40;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1830,'Sura_Rampage','Sura Rampage',4,20,NULL,500,'142',NULL,1,1,0x00008100,7,2,2,3,'102',1,12,' bonus2 bSkillAtk,"SR_EARTHSHAKER",20; bonus2 bSkillAtk,"SR_SKYNETBLOW",20; bonus bUseSPrate,5; if(getrefine()>6) { bonus bUseSPrate,-1*(getrefine()-6); }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1831,'P_Knuckle1','Eden Knuckle I',4,NULL,NULL,0,'120',NULL,1,NULL,0x00008100,7,2,2,3,'60',NULL,12,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (1832,'Bellum_Claw','Bellum Claw',4,20,NULL,650,'160',NULL,1,NULL,0x00008100,7,2,2,4,'95',1,12,'bonus2 bAddRace,RC_DemiHuman,100; if(getrefine()>7) { bonus2 bAddRace,RC_DemiHuman,20; } if(getrefine()>9) { bonus2 bVariableCastrate,271,-100; bonus4 bAutoSpellOnSkill,"MO_EXPLOSIONSPIRITS","CH_SOULCOLLECT",1,10000; bonus2 bHPLossRate,500,3000; }',NULL,NULL); @@ -1119,7 +1119,7 @@ REPLACE INTO `item_db_re` VALUES (1925,'Cello','Cello',4,20,NULL,700,'110',NULL, REPLACE INTO `item_db_re` VALUES (1926,'Harp_Of_Nepenthes','Harp of Nepenthes',4,20,NULL,1000,'120',NULL,1,2,0x00080000,2,1,2,4,'60',1,13,'bonus bInt,2; if( getrefine()>9 ) { bonus3 bAddEffOnSkill,"BA_MUSICALSTRIKE",Eff_Stun,2000; } else { bonus3 bAddEffOnSkill,"BA_MUSICALSTRIKE",Eff_Stun,1000; }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1927,'Krieger_Instrument1','Glorious Guitar',4,20,NULL,0,'50',NULL,1,NULL,0x00080000,7,1,2,4,'80',1,13,'bonus2 bAddRace,RC_DemiHuman,95; bonus2 bIgnoreDefRate,RC_DemiHuman,20; bonus bUnbreakableWeapon,0; if(getrefine()>5) { bonus2 bAddRace,RC_DemiHuman,pow(((getrefine()>14)?14:getrefine())-4,2); bonus2 bIgnoreDefRate,RC_DemiHuman,5; } if(getrefine()>8) bonus4 bAutoSpellOnSkill,"CG_ARROWVULCAN","CG_TAROTCARD",5,100;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1928,'Berserk_Guitar_I','Spirited Guitar',4,NULL,NULL,0,'40',NULL,1,NULL,0x00080000,2,1,2,4,NULL,NULL,13,'bonus bAspdRate,100; bonus bHPrecovRate,-100; bonus2 bHPLossRate,50,5000; bonus bDex,-readparam(bDex);',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (1929,'Guitar_C','Guitar',4,NULL,NULL,0,'177',NULL,1,NULL,0x00080000,7,1,2,3,'1',NULL,13,'bonus2 bAddSize,0,40; bonus2 bAddSize,1,40; bonus2 bAddSize,2,40;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (1929,'Guitar_C','Guitar',4,NULL,NULL,0,'177',NULL,1,NULL,0x00080000,7,1,2,3,'1',NULL,13,'bonus2 bAddSize,Size_Small,40; bonus2 bAddSize,Size_Medium,40; bonus2 bAddSize,Size_Large,40;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1930,'Green_Whistle','Green Whistle',4,20,NULL,800,'170:50',NULL,1,1,0x00080000,7,1,2,3,'102',1,13,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (1931,'P_Guitar1','Eden Guitar I',4,NULL,NULL,0,'125',NULL,1,NULL,0x00080000,7,1,2,3,'60',NULL,13,NULL,NULL,NULL); # Whips @@ -1156,7 +1156,7 @@ REPLACE INTO `item_db_re` VALUES (1979,'Stem_Of_Nepenthes','Stem of Nepenthes',4 REPLACE INTO `item_db_re` VALUES (1980,'Whip_Of_Balance','Whip of Balance',4,20,NULL,700,'110',NULL,2,3,0x00080000,2,NULL,2,3,'70',1,14,'bonus bAgi,2; bonus bDex,3; bonus2 bAddSkillBlow,"DC_THROWARROW",2; bonus2 bAddSkillBlow,"CG_ARROWVULCAN",3;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1981,'Krieger_Whip1','Glorious Lariat',4,20,NULL,0,'50',NULL,2,NULL,0x00080000,7,NULL,2,4,'80',1,14,'bonus2 bAddRace,RC_DemiHuman,95; bonus2 bIgnoreDefRate,RC_DemiHuman,20; bonus bUnbreakableWeapon,0; if(getrefine()>5) { bonus2 bAddRace,RC_DemiHuman,pow(((getrefine()>14)?14:getrefine())-4,2); bonus2 bIgnoreDefRate,RC_DemiHuman,5; } if(getrefine()>8) bonus4 bAutoSpellOnSkill,"CG_ARROWVULCAN","CG_TAROTCARD",5,100;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1982,'Phenomena_Whip','Phenomena Whip',4,20,NULL,0,'160',NULL,2,NULL,0x00080000,7,NULL,2,4,NULL,NULL,14,'bonus bDex,2; bonus2 bSkillAtk,"DC_THROWARROW",25;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (1983,'Rante_C','Rante Whip',4,NULL,NULL,0,'170',NULL,2,NULL,0x00080000,7,NULL,2,3,'1',NULL,14,'bonus2 bAddSize,0,40; bonus2 bAddSize,1,40; bonus2 bAddSize,2,40;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (1983,'Rante_C','Rante Whip',4,NULL,NULL,0,'170',NULL,2,NULL,0x00080000,7,NULL,2,3,'1',NULL,14,'bonus2 bAddSize,Size_Small,40; bonus2 bAddSize,Size_Medium,40; bonus2 bAddSize,Size_Large,40;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1984,'Stem_Whip','Stem Whip',4,20,NULL,800,'170:50',NULL,1,1,0x00080000,7,NULL,2,3,'102',1,14,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (1985,'Rosebine','Rosebine',4,20,NULL,1000,'100:130',NULL,1,NULL,0x00080000,7,NULL,2,4,'110',1,14,'bonus bInt,2; bonus bAgi,-2; bonus3 bAutoSpell,"WM_VOICEOFSIREN",1,20;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1986,'P_Tail1','Eden Tail I',4,NULL,NULL,0,'125',NULL,2,NULL,0x00080000,7,NULL,2,3,'60',NULL,14,NULL,NULL,NULL); @@ -1188,43 +1188,43 @@ REPLACE INTO `item_db_re` VALUES (2105,'Shield','Shield',5,56000,NULL,1300,NULL, REPLACE INTO `item_db_re` VALUES (2106,'Shield_','Shield',5,56000,NULL,1300,NULL,60,NULL,1,0x00004082,7,2,32,NULL,NULL,1,3,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (2107,'Mirror_Shield','Mirror Shield',5,60000,NULL,1000,NULL,45,NULL,NULL,0x00404082,7,2,32,NULL,NULL,1,4,'bonus bMdef,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2108,'Mirror_Shield_','Mirror Shield',5,60000,NULL,1000,NULL,45,NULL,1,0x00404082,7,2,32,NULL,NULL,1,4,'bonus bMdef,5;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (2109,'Memorize_Book','Memory Book',5,20,NULL,1000,NULL,25,NULL,NULL,0x00810204,7,2,32,NULL,NULL,1,5,'bonus bInt,1; bonus bMdef,2; if (isequipped(2717,2239)) { bonus bHPrecovRate,15; bonus bSPrecovRate,15; bonus bMatkRate,7; };',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (2109,'Memorize_Book','Memory Book',5,20,NULL,1000,NULL,25,NULL,NULL,0x00810204,7,2,32,NULL,NULL,1,5,'bonus bInt,1; bonus bMdef,2;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2110,'Holy_Guard','Holy Guard',5,85000,NULL,1400,NULL,110,NULL,NULL,0x00004000,7,2,32,NULL,'68',NULL,4,'bonus bVit,2; bonus bMdef,2;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2111,'Herald_Of_GOD','Sacred Mission',5,128000,NULL,1600,NULL,120,NULL,NULL,0x00004000,7,2,32,NULL,'83',1,4,'bonus bVit,3; bonus bInt,2; bonus bMdef,3; bonus bUnbreakableShield,0;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2112,'Novice_Guard','Novice Guard',5,1,NULL,1,NULL,20,NULL,NULL,0x00000001,7,2,32,NULL,NULL,NULL,1,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (2113,'Novice_Shield','Novice Shield',5,5000,NULL,1000,NULL,20,NULL,1,0x00000001,7,2,32,NULL,'40',1,3,'bonus2 bSubEle,Ele_Water,20; bonus2 bSubEle,Ele_Earth,20; bonus2 bSubEle,Ele_Fire,20; bonus2 bSubEle,Ele_Wind,20; bonus2 bSubEle,Ele_Poison,20; bonus2 bSubEle,Ele_Ghost,20; bonus2 bSubEle,Ele_Undead,20;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (2114,'Stone_Buckler','Stone Buckler',5,30000,NULL,1500,NULL,45,NULL,1,0xFFFFFFFE,7,2,32,NULL,'65',1,2,'bonus2 bSubSize,2,5; if (isequipped(2353,5122)) { bonus bStr,2; bonus bDef,5; bonus bMdef,5; if(BaseClass == Job_Swordman) bonus bDef,6; }',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (2115,'Valkyrja\'s_Shield','Valkyrja\'s Shield',5,30000,NULL,500,NULL,80,NULL,1,0xFFFFFFFE,7,2,32,NULL,'65',1,4,'bonus2 bSubEle,Ele_Water,20; bonus2 bSubEle,Ele_Fire,20; bonus2 bSubEle,Ele_Dark,20; bonus2 bSubEle,Ele_Undead,20; bonus bMdef,5; if(isequipped(2353,5124)) { bonus bDef,2-getrefine()-getequiprefinerycnt(EQI_HEAD_TOP); bonus bMdef,5+getrefine()+getequiprefinerycnt(EQI_HEAD_TOP); }',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (2114,'Stone_Buckler','Stone Buckler',5,30000,NULL,1500,NULL,45,NULL,1,0xFFFFFFFE,7,2,32,NULL,'65',1,2,'bonus2 bSubSize,Size_Large,5;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (2115,'Valkyrja\'s_Shield','Valkyrja\'s Shield',5,30000,NULL,500,NULL,80,NULL,1,0xFFFFFFFE,7,2,32,NULL,'65',1,4,'bonus2 bSubEle,Ele_Water,20; bonus2 bSubEle,Ele_Fire,20; bonus2 bSubEle,Ele_Dark,20; bonus2 bSubEle,Ele_Undead,20; bonus bMdef,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2116,'Angel\'s_Safeguard','Angelic Guard',5,10000,NULL,400,NULL,30,NULL,1,0x00000001,7,2,32,NULL,'20',1,1,'bonus2 bSubRace,RC_Demon,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2117,'Arm_Guard','Arm Guard',5,10000,NULL,150,NULL,50,NULL,NULL,0x02000000,7,2,32,NULL,'20',1,1,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (2118,'Arm_Guard_','Arm Guard',5,10000,NULL,150,NULL,50,NULL,1,0x02000000,7,2,32,NULL,'20',1,1,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (2119,'Improved_Arm_Guard','Advanced Arm Guard',5,40000,NULL,150,NULL,45,NULL,NULL,0x02000000,7,2,32,NULL,'50',1,1,'bonus bMdef,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2120,'Improved_Arm_Guard_','Advanced Arm Guard',5,40000,NULL,150,NULL,45,NULL,1,0x02000000,7,2,32,NULL,'50',1,1,'bonus bMdef,5;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (2121,'Memorize_Book_','Memory Book',5,20,NULL,1000,NULL,25,NULL,1,0x00810204,7,2,32,NULL,NULL,1,5,'bonus bInt,1; bonus bMdef,2; if (isequipped(2717,2239)) { bonus bHPrecovRate,15; bonus bSPrecovRate,15; bonus bMatkRate,7; };',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (2122,'Platinum_Shield','Platinum Shield',5,20,NULL,1200,NULL,95,NULL,NULL,0xFFFFFFFE,2,2,32,NULL,'68',1,4,'bonus bMdef,5; bonus2 bSubSize,1,15; bonus2 bSubSize,2,15; bonus2 bSubRace,RC_Undead,10; bonus5 bAutoSpellWhenHit,NPC_MAGICMIRROR,2,150,BF_MAGIC,0;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (2123,'Orleans_Server','Orleans\'s Server',5,20,NULL,1000,NULL,75,NULL,1,0xFFFFFFFE,2,2,32,NULL,'55',1,4,'bonus bMdef,2; bonus bMagicDamageReturn,5; if (isequipped(2701)) bonus bVariableCastrate,-10;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (2124,'Thorny_Buckler','Thorny Buckler',5,20,NULL,1000,NULL,85,NULL,1,0xFFFFFFFE,2,2,32,NULL,'55',1,2,'bonus bMdef,2; if (isequipped(2702)) { bonus bAspdRate,10; bonus bShortWeaponDamageReturn,5; }',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (2121,'Memorize_Book_','Memory Book',5,20,NULL,1000,NULL,25,NULL,1,0x00810204,7,2,32,NULL,NULL,1,5,'bonus bInt,1; bonus bMdef,2;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (2122,'Platinum_Shield','Platinum Shield',5,20,NULL,1200,NULL,95,NULL,NULL,0xFFFFFFFE,2,2,32,NULL,'68',1,4,'bonus bMdef,5; bonus2 bSubSize,Size_Medium,15; bonus2 bSubSize,Size_Large,15; bonus2 bSubRace,RC_Undead,10; bonus5 bAutoSpellWhenHit,NPC_MAGICMIRROR,2,150,BF_MAGIC,0;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (2123,'Orleans_Server','Orleans\'s Server',5,20,NULL,1000,NULL,75,NULL,1,0xFFFFFFFE,2,2,32,NULL,'55',1,4,'bonus bMdef,2; bonus bMagicDamageReturn,5;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (2124,'Thorny_Buckler','Thorny Buckler',5,20,NULL,1000,NULL,85,NULL,1,0xFFFFFFFE,2,2,32,NULL,'55',1,2,'bonus bMdef,2;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2125,'Strong_Shield','Strong Shield',5,20,NULL,2500,NULL,90,NULL,1,0xFFFFFFFE,2,2,32,NULL,'75',1,4,'bonus bNoKnockback,0; bonus2 bSubEle,Ele_Neutral,-20; bonus2 bSubEle,Ele_Fire,-20; bonus2 bSubEle,Ele_Water,-20; bonus2 bSubEle,Ele_Wind,-20; bonus2 bSubEle,Ele_Earth,-20; bonus2 bSubEle,Ele_Dark,-20; bonus2 bSubEle,Ele_Holy,-20; bonus2 bSubEle,Ele_Ghost,-20;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2126,'Guyak_Shield','Guyak Shield',5,20,NULL,700,NULL,3,NULL,NULL,0xFFFFFFFE,7,2,32,NULL,'1',1,2,'bonus bMdef,2; bonus bMagicDamageReturn,2; autobonus2 "{bonus bShortWeaponDamageReturn,5;}",20,1000,BF_WEAPON,"{specialeffect2 EF_REFLECTSHIELD;}";',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2127,'Secular_Mission','Secular Mission',5,20,NULL,0,NULL,10,NULL,NULL,0xFFFFFFFF,7,2,32,NULL,NULL,NULL,4,'bonus2 bSubRace,RC_NonBoss,25; bonus2 bSubRace,RC_Boss,25;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2128,'Herald_Of_GOD_','Sacred Mission',5,128000,NULL,1600,NULL,120,NULL,1,0x00004000,7,2,32,NULL,'83',1,4,'bonus bVit,3; bonus bInt,2; bonus bMdef,3; bonus bUnbreakableShield,0;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (2129,'Exorcism_Bible','Exorcism Bible',5,20,NULL,600,NULL,80,NULL,NULL,0x00008100,7,2,32,NULL,'50',1,5,'bonus bHPrecovRate,3; bonus bSPrecovRate,3; bonus bInt,1; if(isequipped(1631)) { bonus2 bSkillAtk,"PR_MAGNUS",20; bonus3 bAutoSpellWhenHit,"PR_TURNUNDEAD",1,20; }',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (2129,'Exorcism_Bible','Exorcism Bible',5,20,NULL,600,NULL,80,NULL,NULL,0x00008100,7,2,32,NULL,'50',1,5,'bonus bHPrecovRate,3; bonus bSPrecovRate,3; bonus bInt,1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2130,'Cross_Shield','Cross Shield',5,20,NULL,2000,NULL,130,NULL,1,0x00004000,7,2,32,NULL,'80',1,4,'bonus bStr,1; bonus2 bSkillAtk,PA_SHIELDCHAIN,30; bonus2 bSkillAtk,CR_SHIELDBOOMERANG,30; bonus bUseSPrate,10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2131,'Magic_Study_Vol1','Magic Bible Vol1',5,20,NULL,1000,NULL,18,NULL,1,0x00810204,2,2,32,NULL,'70',1,5,'bonus bMdef,3; bonus bInt,2; bonus2 bAddEffWhenHit,Eff_Stun,1000;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2132,'Shelter_Resistance','Shell Of Resistance',5,20,NULL,0,NULL,9,NULL,NULL,0xFFFFFFFF,2,2,32,NULL,NULL,NULL,2,'bonus2 bSubEle,Ele_Neutral,20; bonus2 bSubEle,Ele_Water,20; bonus2 bSubEle,Ele_Earth,20; bonus2 bSubEle,Ele_Fire,20; bonus2 bSubEle,Ele_Wind,20; bonus2 bSubEle,Ele_Poison,20; bonus2 bSubEle,Ele_Holy,20; bonus2 bSubEle,Ele_Dark,20; bonus2 bSubEle,Ele_Ghost,20; bonus2 bSubEle,Ele_Undead,20; bonus bShortWeaponDamageReturn,1;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (2133,'Tournament_Shield','Tournament Shield',5,20,NULL,1000,NULL,105,NULL,1,0x00004082,2,2,32,NULL,'50',1,4,'bonus2 bAddRace,RC_NonBoss,1; bonus2 bAddRace,RC_Boss,1; if( Class == Job_Lord_Knight ) bonus bAspdRate,-5; if( isequipped(1420) || isequipped(1421) || isequipped(1422) ) { bonus2 bAddRace,RC_NonBoss,4; bonus2 bAddRace,RC_Boss,4; bonus bDef,2; }',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (2133,'Tournament_Shield','Tournament Shield',5,20,NULL,1000,NULL,105,NULL,1,0x00004082,2,2,32,NULL,'50',1,4,'bonus2 bAddRace,RC_NonBoss,1; bonus2 bAddRace,RC_Boss,1; if( Class == Job_Lord_Knight ) bonus bAspdRate,-5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2134,'Shield_Of_Naga','Shield of Naga',5,20,NULL,500,NULL,35,NULL,1,0x00CFFF80,2,2,32,NULL,'70',1,2,'bonus bMdef,3; autobonus2 "{bonus bShortWeaponDamageReturn,(getrefine()*3);}",10,5000,BF_WEAPON,"{specialeffect2 EF_GUARD;}";',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (2135,'Shadow_Guard','Shadow Guard',5,20,NULL,800,NULL,52,NULL,1,0x00020000,2,2,32,NULL,'70',1,2,'if( isequipped(2426) ) { bonus2 bAddEff,Eff_Blind,500; autobonus "{bonus bFlee,20;}",200,10000,BF_WEAPON,"{specialeffect2 EF_INCAGILITY;}"; }',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (2135,'Shadow_Guard','Shadow Guard',5,20,NULL,800,NULL,52,NULL,1,0x00020000,2,2,32,NULL,'70',1,2,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (2136,'Cracked_Buckler','Cracked Buckler',5,NULL,NULL,0,NULL,5,NULL,NULL,0xFFFFFFFF,7,2,32,NULL,NULL,NULL,2,'bonus bAgi,2; bonus2 bAddEle,Ele_Neutral,-10; bonus3 bAutoSpellWhenHit,"PR_KYRIE",1,50; bonus bMdef,1;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (2137,'Valkyrja\'s_Shield_C','Neo Valkyrja\'s Shield',5,NULL,NULL,0,NULL,5,NULL,NULL,0xFFFFFFFE,2,2,32,NULL,'95',NULL,4,'bonus2 bSubEle,Ele_Water,20; bonus2 bSubEle,Ele_Fire,20; bonus2 bSubEle,Ele_Dark,20; bonus2 bSubEle,Ele_Undead,20; bonus bMdef,5; if(isequipped(2353,5124)) { bonus bDef,2-getrefine()-getequiprefinerycnt(EQI_HEAD_TOP); bonus bMdef,5+getrefine()+getequiprefinerycnt(EQI_HEAD_TOP); }',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (2137,'Valkyrja\'s_Shield_C','Neo Valkyrja\'s Shield',5,NULL,NULL,0,NULL,5,NULL,NULL,0xFFFFFFFE,2,2,32,NULL,'95',NULL,4,'bonus2 bSubEle,Ele_Water,20; bonus2 bSubEle,Ele_Fire,20; bonus2 bSubEle,Ele_Dark,20; bonus2 bSubEle,Ele_Undead,20; bonus bMdef,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2138,'Bradium_Shield','Bradium Shield',5,20,NULL,1800,NULL,98,NULL,1,0x00CFFF80,2,2,32,NULL,'65',1,3,'bonus2 bSkillAtk,CR_SHIELDBOOMERANG,60; bonus bAgi,-1; bonus bMaxHP,500;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2139,'Flame_Thrower','Flame Thrower',5,20000,NULL,2000,NULL,60,NULL,NULL,0xFFFFFFFF,7,2,32,NULL,'99',NULL,1,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (2140,'Energy_Rune_Guard','Energy Rune Guard',5,20,NULL,0,NULL,70,NULL,1,0x00000080,7,2,32,NULL,'99',1,4,'bonus bMaxSPrate,2;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (2141,'Freyja_SShield7','Freyja Spirit Shield',5,NULL,NULL,300,NULL,5,NULL,NULL,0xFFFFFFFF,7,2,32,NULL,'20',NULL,1,'bonus2 bSubSize,1,25;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (2142,'Freyja_SShield30','Freyja Spirit Shield',5,NULL,NULL,300,NULL,5,NULL,NULL,0xFFFFFFFF,7,2,32,NULL,'20',NULL,1,'bonus2 bSubSize,1,25;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (2143,'Freyja_SShield60','Freyja Spirit Shield',5,NULL,NULL,300,NULL,5,NULL,NULL,0xFFFFFFFF,7,2,32,NULL,'20',NULL,1,'bonus2 bSubSize,1,25;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (2144,'Freyja_SShield90','Freyja Spirit Shield',5,NULL,NULL,300,NULL,5,NULL,NULL,0xFFFFFFFF,7,2,32,NULL,'20',NULL,1,'bonus2 bSubSize,1,25;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (2145,'Time_Keepr_Shield','Time Keeper Shield',5,30000,NULL,0,NULL,20,NULL,NULL,0xFFFFFFFF,7,2,32,NULL,'1',1,3,'bonus bMdef,1; bonus2 bSubEle,Ele_Neutral,10; bonus2 bSubSize,1,25;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (2141,'Freyja_SShield7','Freyja Spirit Shield',5,NULL,NULL,300,NULL,5,NULL,NULL,0xFFFFFFFF,7,2,32,NULL,'20',NULL,1,'bonus2 bSubSize,Size_Medium,25;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (2142,'Freyja_SShield30','Freyja Spirit Shield',5,NULL,NULL,300,NULL,5,NULL,NULL,0xFFFFFFFF,7,2,32,NULL,'20',NULL,1,'bonus2 bSubSize,Size_Medium,25;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (2143,'Freyja_SShield60','Freyja Spirit Shield',5,NULL,NULL,300,NULL,5,NULL,NULL,0xFFFFFFFF,7,2,32,NULL,'20',NULL,1,'bonus2 bSubSize,Size_Medium,25;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (2144,'Freyja_SShield90','Freyja Spirit Shield',5,NULL,NULL,300,NULL,5,NULL,NULL,0xFFFFFFFF,7,2,32,NULL,'20',NULL,1,'bonus2 bSubSize,Size_Medium,25;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (2145,'Time_Keepr_Shield','Time Keeper Shield',5,30000,NULL,0,NULL,20,NULL,NULL,0xFFFFFFFF,7,2,32,NULL,'1',1,3,'bonus bMdef,1; bonus2 bSubEle,Ele_Neutral,10; bonus2 bSubSize,Size_Medium,25;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2146,'Siver_Guard','Silver Guard',5,12500,NULL,300,NULL,60,NULL,1,0xFFFFFFFF,7,2,32,NULL,'22',1,1,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (2147,'Round_Buckler','Round Buckleer',5,24000,NULL,600,NULL,90,NULL,1,0xFFFFFFFE,2,2,32,NULL,'22',1,2,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (2148,'Rotha_Shield','Rosa Shield',5,56000,NULL,1300,NULL,130,NULL,1,0x00004082,7,2,32,NULL,'100',1,3,NULL,NULL,NULL); @@ -1239,7 +1239,7 @@ REPLACE INTO `item_db_re` VALUES (2156,'Bible_Of_Promise1','Bible Of Promise Vol #2157, #2158, #2159, -REPLACE INTO `item_db_re` VALUES (2160,'Giant_Shield','Giant Shield',5,56000,NULL,2800,NULL,130,NULL,1,0x00004082,7,2,32,NULL,'100',1,4,'bonus2 bSubSize,2,5; if(getrefine()>=9){ bonus2 bSubSize,2,5; }',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (2160,'Giant_Shield','Giant Shield',5,56000,NULL,2800,NULL,130,NULL,1,0x00004082,7,2,32,NULL,'100',1,4,'bonus2 bSubSize,Size_Large,5; if(getrefine()>=9){ bonus2 bSubSize,Size_Large,5; }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2161,'Geffenia_Tomb_of_Water','Geffenia Tomb of Water',5,56000,NULL,1000,NULL,30,NULL,NULL,0x00000200,7,2,32,NULL,'100',1,5,'bonus bMdef,2; bonus bInt,1; if(readparam(bInt)>=120){ bonus bEquipmentMatk,10; bonus bMaxHP,800; }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2162,'Bible_Of_Promise2','Bible Of Promise Vol2',5,20,NULL,500,NULL,20,NULL,1,0x00000100,7,2,32,NULL,'140',1,5,'bonus bMdef,5; bonus bHealPower,5; skill "ALL_ODINS_POWER",2;',NULL,NULL); #2163, @@ -1254,7 +1254,7 @@ REPLACE INTO `item_db_re` VALUES (2171,'Fox_Wrist_Guard','Fox Wrist Guard',5,400 REPLACE INTO `item_db_re` VALUES (2172,'Wolf_Wrist_Guard','Wolf Wrist Guard',5,45000,NULL,250,NULL,70,NULL,1,0x02000000,7,2,32,NULL,'100',1,1,'autobonus "{bonus bBaseAtk,100; bonus bFlee,-50;}",10,5000,BF_WEAPON,"{specialeffect2 EF_ENHANCE;}";',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2173,'Crescent_Wrist_Guard','Crescent Wrist Guard',5,45000,NULL,250,NULL,45,NULL,1,0x02000000,7,2,32,NULL,'100',1,1,'bonus bDelayRate,-2;',NULL,NULL); # GM Shield -REPLACE INTO `item_db_re` VALUES (2199,'Ahura_Mazda','Ahura Mazdah',5,1,NULL,10,NULL,10000,NULL,NULL,0xFFFFFFFF,7,2,32,NULL,'1',1,0,'bonus bAllStats,50; bonus bMdef,99; bonus bShortWeaponDamageReturn,100; bonus2 bSubRace,RC_DemiHuman,95; skill "CR_FULLPROTECTION",5; Skill "WZ_ESTIMATION",1; Skill "ST_FULLSTRIP",5; Skill "HW_MAGICPOWER", 10; bonus bMaxHPRate,200; bonus bNoKnockback,0; bonus bDelayRate,-20; bonus bSpeedRate,25; bonus bIntravision,0;','sc_start4 SC_ENDURE,60000,10,0,0,1;','sc_end SC_ENDURE;'); +REPLACE INTO `item_db_re` VALUES (2199,'Ahura_Mazda','Ahura Mazdah',5,1,NULL,10,NULL,10000,NULL,NULL,0xFFFFFFFF,7,2,32,NULL,'1',1,0,'bonus bAllStats,50; bonus bMdef,99; bonus bShortWeaponDamageReturn,100; bonus2 bSubRace,RC_DemiHuman,95; skill "CR_FULLPROTECTION",5; skill "WZ_ESTIMATION",1; skill "ST_FULLSTRIP",5; skill "HW_MAGICPOWER", 10; bonus bMaxHPRate,200; bonus bNoKnockback,0; bonus bDelayRate,-20; bonus bSpeedRate,25; bonus bIntravision,0;','sc_start4 SC_ENDURE,60000,10,0,0,1;','sc_end SC_ENDURE;'); # Headgears # =================================================================== REPLACE INTO `item_db_re` VALUES (2201,'Sunglasses','Sunglasses',5,5000,NULL,100,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,512,NULL,NULL,NULL,12,'bonus2 bResEff,Eff_Blind,500;',NULL,NULL); @@ -1842,7 +1842,7 @@ REPLACE INTO `item_db_re` VALUES (2794,'Magic_Stone_Ring','Magic Stone Ring',5,N REPLACE INTO `item_db_re` VALUES (2795,'Green_Apple_Ring','Green Apple Ring',5,NULL,NULL,0,NULL,NULL,NULL,NULL,0xFFFFFFFE,7,2,136,NULL,'99',NULL,0,'if(JobLevel<30) { bonus bAllStats,6-(JobLevel/5); }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2796,'Magical_Stone','Rocks',5,NULL,NULL,200,NULL,NULL,NULL,NULL,0x00810204,7,2,136,NULL,'99',NULL,0,'bonus2 bAddDamageClass,2047,10; bonus2 bAddDefClass,2048,-10; bonus3 bAddClassDropItem,6152,2047,70;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2797,'Magical_Stone_','Rocks',5,NULL,NULL,200,NULL,NULL,NULL,NULL,0x00810204,7,2,136,NULL,'99',NULL,0,'bonus2 bAddDamageClass,2049,10; bonus2 bAddDefClass,2050,-10; bonus3 bAddClassDropItem,6151,2049,70;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (2798,'Will_Of_Exhausted_Angel','Will Of Exhausted Angel',5,NULL,NULL,200,NULL,NULL,NULL,NULL,0x00008100,7,2,136,NULL,'99',NULL,0,'getmapxy .@map$,.@x,.@y,0; if(.@map$=="job3_arch02") { bonus2 bAddDefClass,1761,50; bonus2 bAddDefClass,1762,50; }',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (2798,'Will_Of_Exhausted_Angel','Will Of Exhausted Angel',5,NULL,NULL,200,NULL,NULL,NULL,NULL,0x00008100,7,2,136,NULL,'99',NULL,0,'if(strcharinfo(3)=="job3_arch02") { bonus2 bAddDefClass,1761,50; bonus2 bAddDefClass,1762,50; }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2799,'Kuirpenring','Kuirpenring',5,NULL,NULL,100,NULL,NULL,NULL,1,0xFFFFFFFF,7,2,136,NULL,NULL,NULL,0,'bonus bMdef,1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2800,'Accelerator','Accelerator',5,100000,NULL,100,NULL,NULL,NULL,1,0x00000400,8,2,136,NULL,'99',NULL,0,'bonus bAgi,2;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2801,'Hovering_Booster','Hovering Booster',5,100000,NULL,2000,NULL,NULL,NULL,1,0x00000400,8,2,136,NULL,'99',NULL,0,'bonus bAgi,1;',NULL,NULL); @@ -2018,7 +2018,7 @@ REPLACE INTO `item_db_re` VALUES (4078,'Savage_Card','Savage Card',6,20,NULL,10, REPLACE INTO `item_db_re` VALUES (4079,'Mantis_Card','Mantis Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus bStr,3;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4080,'Flora_Card','Flora Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,'bonus2 bAddRace,RC_Fish,20;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4081,'Hode_Card','Hode Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,NULL,NULL,NULL,NULL,'bonus2 bSubEle,Ele_Earth,30; bonus bFlee,5;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (4082,'Desert_Wolf_Card','Desert Wolf Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,'bonus2 bAddSize,0,15; bonus bBaseAtk,5;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (4082,'Desert_Wolf_Card','Desert Wolf Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,'bonus2 bAddSize,Size_Small,15; bonus bBaseAtk,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4083,'Rafflesia_Card','Rafflesia Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,32,NULL,NULL,NULL,NULL,'bonus2 bSubRace,RC_Fish,30;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4084,'Marine_Sphere_Card','Marine Sphere Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'skill "SM_MAGNUM",3;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4085,'Orc_Skeleton_Card','Orc Skeleton Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,'bonus2 bAddEle,Ele_Holy,20;',NULL,NULL); @@ -2028,7 +2028,7 @@ REPLACE INTO `item_db_re` VALUES (4088,'Frilldora_Card','Frilldora Card',6,20,NU REPLACE INTO `item_db_re` VALUES (4089,'Sword_Fish_Card','Swordfish Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,'bonus bDefEle,Ele_Water; bonus bDef,1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4090,'Munak_Card','Munak Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,32,NULL,NULL,NULL,NULL,'bonus2 bResEff,Eff_Stone,1500; bonus2 bSubEle,Ele_Earth,5; bonus bDef,1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4091,'Kobold_Card','Kobold Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus bStr,1; bonus bCritical,4;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (4092,'Skel_Worker_Card','Skeleton Worker Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,'bonus2 bAddSize,1,15; bonus bBaseAtk,5;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (4092,'Skel_Worker_Card','Skeleton Worker Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,'bonus2 bAddSize,Size_Medium,15; bonus bBaseAtk,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4093,'Obeaune_Card','Obeaune Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'skill "AL_CURE",1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4094,'Archer_Skeleton_Card','Archer Skeleton Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,'bonus bLongAtkRate,10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4095,'Marse_Card','Marse Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,NULL,NULL,NULL,NULL,'bonus2 bSubEle,Ele_Water,30; bonus bFlee,5;',NULL,NULL); @@ -2062,7 +2062,7 @@ REPLACE INTO `item_db_re` VALUES (4122,'Deviruchi_Card','Deviruchi Card',6,20,NU REPLACE INTO `item_db_re` VALUES (4123,'Eddga_Card','Eddga Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,64,NULL,NULL,NULL,NULL,'bonus bMaxHPrate,-25;','sc_start4 SC_ENDURE,60000,10,0,0,1;','sc_end SC_ENDURE;'); REPLACE INTO `item_db_re` VALUES (4124,'Medusa_Card','Medusa Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,32,NULL,NULL,NULL,NULL,'bonus2 bSubRace,RC_Demon,15; bonus2 bResEff,Eff_Stone,10000;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4125,'Deviace_Card','Deviace Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,'bonus2 bAddRace,RC_DemiHuman,7; bonus2 bAddRace,RC_Brute,7; bonus2 bAddRace,RC_Plant,7; bonus2 bAddRace,RC_Insect,7;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (4126,'Minorous_Card','Minorous Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,'bonus2 bAddSize,2,15; bonus bBaseAtk,5;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (4126,'Minorous_Card','Minorous Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,'bonus2 bAddSize,Size_Large,15; bonus bBaseAtk,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4127,'Nightmare_Card','Nightmare Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,769,NULL,NULL,NULL,NULL,'bonus2 bResEff,Eff_Sleep,10000; bonus bAgi,1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4128,'Golden_Bug_Card','Golden Thief Bug Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,32,NULL,NULL,NULL,NULL,'bonus bNoMagicDamage,100; bonus bUseSPrate,100;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4129,'Baphomet__Card','Bapho Jr. Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,NULL,NULL,NULL,NULL,'bonus bAgi,3; bonus bCritical,1;',NULL,NULL); @@ -2143,7 +2143,7 @@ REPLACE INTO `item_db_re` VALUES (4203,'Mutant_Dragon_Card','Mutant Dragonoid Ca REPLACE INTO `item_db_re` VALUES (4204,'Mini_Demon_Card','Mini Demon Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,64,NULL,NULL,NULL,NULL,'bonus2 bSubRace,RC_Brute,-20; bonus2 bExpAddRace,RC_Brute,10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4205,'Mimic_Card','Mimic Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus2 bAddMonsterDropItem,603,10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4206,'Mystcase_Card','Myst Case Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,769,NULL,NULL,NULL,NULL,'bonus2 bAddMonsterDropItem,644,30;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (4207,'Mysteltainn_Card','Mysteltainn Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,32,NULL,NULL,NULL,NULL,'bonus2 bSubSize,0,25; bonus bDef,1;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (4207,'Mysteltainn_Card','Mysteltainn Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,32,NULL,NULL,NULL,NULL,'bonus2 bSubSize,Size_Small,25; bonus bDef,1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4208,'Miyabi_Ningyo_Card','Miyabi Doll Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,64,NULL,NULL,NULL,NULL,'bonus bMaxSPrate,10; bonus2 bSkillAtk,"MG_FROSTDIVER",5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4209,'Violy_Card','Violy Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus3 bAutoSpell,"BA_FROSTJOKER",1+4*(getskilllv("BA_FROSTJOKER")==5),20;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4210,'Wander_Man_Card','Wanderer Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,NULL,NULL,NULL,NULL,'if(!isequipped(4172,4257,4230,4272)) bonus3 bAutoSpell,"RG_INTIMIDATE",1,20; if(BaseClass==Job_Thief) bonus bFlee,20;',NULL,NULL); @@ -2186,11 +2186,11 @@ REPLACE INTO `item_db_re` VALUES (4246,'Assulter_Card','Assaulter Card',6,20,NUL REPLACE INTO `item_db_re` VALUES (4247,'Aster_Card','Aster Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,'bonus bBaseAtk,5; bonus2 bAddDamageClass,1074,30;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4248,'Ancient_Mummy_Card','Ancient Mummy Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,32,NULL,NULL,NULL,NULL,'bonus3 bAutoSpellWhenHit,"AL_CRUCIS",5,30;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4249,'Ancient_Worm_Card','Ancient Worm Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,64,NULL,NULL,NULL,NULL,'bonus2 bSubRace,RC_Demon,-20; bonus2 bExpAddRace,RC_Demon,10;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (4250,'Executioner_Card','Executioner Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,32,NULL,NULL,NULL,NULL,'bonus2 bSubSize,2,25; bonus bDef,1;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (4250,'Executioner_Card','Executioner Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,32,NULL,NULL,NULL,NULL,'bonus2 bSubSize,Size_Large,25; bonus bDef,1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4251,'Elder_Card','Elder Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,'bonus2 bAddRace2,5,40;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4252,'Alligator_Card','Alligator Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus bLongAtkDef,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4253,'Alice_Card','Alice Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,32,NULL,NULL,NULL,NULL,'bonus2 bSubRace,RC_Boss,40; bonus2 bSubRace,RC_NonBoss,-40;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (4254,'Tirfing_Card','Ogretooth Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,32,NULL,NULL,NULL,NULL,'bonus2 bSubSize,1,25; bonus bDef,1;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (4254,'Tirfing_Card','Ogretooth Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,32,NULL,NULL,NULL,NULL,'bonus2 bSubSize,Size_Medium,25; bonus bDef,1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4255,'Orc_Lady_Card','Orc Lady Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,'bonus2 bAddRace2,3,30;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4256,'Orc_Archer_Card','Orc Archer Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus3 bAddMonsterDropItem,12034,RC_DemiHuman,100;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4257,'Wild_Rose_Card','Wild Rose Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,64,NULL,NULL,NULL,NULL,'bonus bAgi,1; if(BaseClass==Job_Thief) bonus bFlee2,5;',NULL,NULL); @@ -2199,7 +2199,7 @@ REPLACE INTO `item_db_re` VALUES (4259,'Wooden_Golem_Card','Wooden Golem Card',6 REPLACE INTO `item_db_re` VALUES (4260,'Wootan_Shooter_Card','Wootan Shooter Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,769,NULL,NULL,NULL,NULL,'bonus bDef,1; bonus2 bResEff,Eff_Confusion,2000;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4261,'Wootan_Fighter_Card','Wootan Fighter Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,769,NULL,NULL,NULL,NULL,'bonus bDef,1; bonus2 bResEff,Eff_Bleeding,2000;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4262,'Evil_Cloud_Hermit_Card','Cloud Hermit Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus3 bAddMonsterDropItem,12029,RC_Plant,100;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (4263,'Incant_Samurai_Card','Samurai Spector Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,'bonus bIgnoreDefRace,RC_NonBoss; bonus bHPrecovRate,-100; bonus2 bHPLossRate,666,10000;',NULL,'if( (Hp <= 999) && !getmapflag(strcharinfo(3),6) && !getmapflag(strcharinfo(3),7) && !getmapflag(strcharinfo(3),8) ) { heal (1 - Hp), 0; } else { heal -999, 0; }'); +REPLACE INTO `item_db_re` VALUES (4263,'Incant_Samurai_Card','Samurai Spector Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,'bonus bIgnoreDefRace,RC_NonBoss; bonus bHPrecovRate,-100; bonus2 bHPLossRate,666,10000;',NULL,'if((Hp <= 999) && !getmapflag(strcharinfo(3),mf_pvp) && !getmapflag(strcharinfo(3),mf_pvp_noparty) && !getmapflag(strcharinfo(3),mf_pvp_noguild)) { heal (1-Hp),0; } else { heal -999,0; }'); REPLACE INTO `item_db_re` VALUES (4264,'Wind_Ghost_Card','Wind Ghost Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus3 bAutoSpell,"WZ_JUPITEL",3+7*(getskilllv("WZ_JUPITEL")==10),20;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4265,'Li_Me_Mang_Ryang_Card','Jing Guai Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus3 bAddMonsterDropItem,12033,RC_Angel,100;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4266,'Eclipse_Card','Eclipse Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,NULL,NULL,NULL,NULL,'bonus bVit,1;',NULL,NULL); @@ -2263,7 +2263,7 @@ REPLACE INTO `item_db_re` VALUES (4323,'Garm_Baby_Card','Hatii Babe Card',6,20,N REPLACE INTO `item_db_re` VALUES (4324,'Garm_Card','Hatii Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,'bonus2 bAddEffWhenHit,Eff_Freeze,5000;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4325,'Harpy_Card','Harpy Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,NULL,NULL,NULL,NULL,'bonus2 bSubEle,Ele_Neutral,15; bonus2 bSkillAtk,"MG_NAPALMBEAT",5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4326,'See_Otter_Card','Sea-Otter Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus2 bAddItemHealRate,IG_Fish,50; bonus3 bAddMonsterDropItem,551,RC_Fish,300; bonus3 bAddMonsterDropItem,544,RC_Fish,300;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (4327,'Blood_Butterfly_Card','Bloody Butterfly Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus bVariableCastrate,30; bonus bNoCastCancel,0; bonus2 bSkillAtk,18,5;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (4327,'Blood_Butterfly_Card','Bloody Butterfly Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus bVariableCastrate,30; bonus bNoCastCancel,0; bonus2 bSkillAtk,"MG_FIREWALL",5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4328,'Hyegun_Card','Yao Jun Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,NULL,NULL,NULL,NULL,'bonus bFlee,15; bonus bCritical,1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4329,'Phendark_Card','Phendark Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,'bonus2 bSPGainRace,RC_DemiHuman,5;',NULL,'heal 0,-5;'); REPLACE INTO `item_db_re` VALUES (4330,'Dark_Snake_Lord_Card','Evil Snake Lord Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,769,NULL,NULL,NULL,NULL,'bonus bInt,3; bonus2 bResEff,Eff_Blind,10000; bonus2 bResEff,Eff_Curse,10000;',NULL,NULL); @@ -2349,10 +2349,10 @@ REPLACE INTO `item_db_re` VALUES (4409,'Agav_Card','Agav Card',6,20,NULL,10,NULL REPLACE INTO `item_db_re` VALUES (4410,'Echio_Card','Echio Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,'bonus bBaseAtk,15; if(BaseClass==Job_Swordman) bonus bMaxHP,500;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4411,'Vanberk_Card','Vanberk Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,769,NULL,NULL,NULL,NULL,'bonus bStr,2; autobonus "{bonus bCritical,100;}",5,5000,0,"{specialeffect2 EF_ENHANCE;}";',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4412,'Isilla_Card','Isilla Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,769,NULL,NULL,NULL,NULL,'bonus bInt,2; autobonus "{bonus bVariableCastrate,-50; bonus bFlee,30;}",50,5000,BF_MAGIC,"{specialeffect2 EF_SUFFRAGIUM;}";',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (4413,'Hodremlin_Card','Hodremlin Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,32,NULL,NULL,NULL,NULL,'bonus2 bSubSize,0,15; bonus2 bSubSize,1,15; bonus2 bSubSize,2,15; autobonus2 "{bonus bFlee2,30;}",3,10000,BF_WEAPON|BF_MAGIC,"{specialeffect2 EF_WIND;}";',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (4413,'Hodremlin_Card','Hodremlin Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,32,NULL,NULL,NULL,NULL,'bonus2 bSubSize,Size_Small,15; bonus2 bSubSize,Size_Medium,15; bonus2 bSubSize,Size_Large,15; autobonus2 "{bonus bFlee2,30;}",3,10000,BF_WEAPON|BF_MAGIC,"{specialeffect2 EF_WIND;}";',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4414,'Seeker_Card','Seeker Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,32,NULL,NULL,NULL,NULL,'skill "MG_STONECURSE",1; bonus2 bResEff,Eff_Stone,3000; bonus bMdef,10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4415,'Snowier_Card','Snowier Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus2 bAddMonsterDropItem,536,2000; bonus2 bAddItemHealRate,536,100;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (4416,'Siroma_Card','Siroma Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus2 bSkillAtk,14,25; bonus2 bVariableCastrate,14,-25;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (4416,'Siroma_Card','Siroma Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus2 bSkillAtk,"MG_COLDBOLT",25; bonus2 bVariableCastrate,"MG_COLDBOLT",-25;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4417,'Ice_Titan_Card','Ice Titan Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,64,NULL,NULL,NULL,NULL,'bonus bVit,2; autobonus2 "{bonus bDef,10;}",3,10000,BF_WEAPON|BF_MAGIC,"{specialeffect2 EF_FREEZED;}";',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4418,'Gazeti_Card','Gazeti Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus3 bAutoSpell,"MG_COLDBOLT",2,100;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4419,'Ktullanux_Card','Ktullanux Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,'bonus2 bAddEle,Ele_Fire,50; bonus5 bAutoSpellWhenHit,"WZ_FROSTNOVA",10,20,BF_WEAPON|BF_MAGIC,0;',NULL,NULL); @@ -2915,7 +2915,7 @@ REPLACE INTO `item_db_re` VALUES (5303,'Flower_Coronet','Flower Crown',5,20,NULL REPLACE INTO `item_db_re` VALUES (5304,'Cap_Of_Blindness','Cap Of Blindness',5,20,NULL,800,NULL,4,NULL,1,0xFFFFFFFF,7,2,769,NULL,'50',1,326,'bonus2 bResEff,Eff_Curse,700; bonus2 bResEff,Eff_Blind,10000;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5305,'Pirate_Dagger','Pirate Dagger',5,20,NULL,100,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,1,NULL,NULL,NULL,327,'bonus bBaseAtk,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5306,'Freyja_Crown','Freya\'s Crown',5,NULL,NULL,500,NULL,12,NULL,NULL,0xFFFFFFFE,7,2,256,NULL,NULL,NULL,328,'bonus2 bSubRace,RC_DemiHuman,5;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (5307,'Carmen_Miranda\'s_Hat','Carmen Miranda\'s Hat',5,20,NULL,400,NULL,3,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,NULL,1,329,'bonus bMdef,3; bonus3 bAutoSpellWhenHit,DC_WINKCHARM,1,50;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (5307,'Carmen_Miranda\'s_Hat','Carmen Miranda\'s Hat',5,20,NULL,400,NULL,3,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,NULL,1,329,'bonus bMdef,3; bonus3 bAutoSpellWhenHit,"DC_WINKCHARM",1,50;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5308,'Brazilian_Flag_Hat','Brazil National Flag Hat',5,20,NULL,300,NULL,3,NULL,1,0xFFFFFFFF,7,2,256,NULL,NULL,1,330,'bonus bSpeedAddRate,25;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5309,'Mahican','Wool Mask',5,20,NULL,200,NULL,1,NULL,NULL,0xFFFFFFFF,7,2,769,NULL,NULL,1,331,'skill "RG_GRAFFITI",1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5310,'Bulb_Hairband','Shining Electric Bulb Hairband',5,20,NULL,100,NULL,3,NULL,1,0xFFFFFFFF,7,2,256,NULL,NULL,1,332,'bonus2 bSubEle,Ele_Dark,10; skill "MG_SIGHT",1;',NULL,'sc_end SC_SIGHT;'); @@ -2925,7 +2925,7 @@ REPLACE INTO `item_db_re` VALUES (5313,'Diadem','Diadem',5,20,NULL,100,NULL,3,NU REPLACE INTO `item_db_re` VALUES (5314,'Hockey_Mask','Hockey Mask',5,20,NULL,100,NULL,1,NULL,NULL,0xFFFFFFFF,7,2,513,NULL,'50',NULL,336,'bonus2 bAddRace,RC_DemiHuman,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5315,'Observer','Observer',5,20,NULL,100,NULL,1,NULL,NULL,0xFFFFFFFF,7,2,512,NULL,'35',NULL,337,'skill "WZ_ESTIMATION",1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5316,'Umbrella_Hat','Umbrella Hat',5,20,NULL,100,NULL,2,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'50',1,338,'bonus2 bSubEle,Ele_Water,3;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (5317,'Fisherman_Hat','Fisherman\'s Hat',5,20,NULL,100,NULL,2,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'50',1,339,'bonus3 bAutoSpell,WZ_WATERBALL,3,50;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (5317,'Fisherman_Hat','Fisherman\'s Hat',5,20,NULL,100,NULL,2,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'50',1,339,'bonus3 bAutoSpell,"WZ_WATERBALL",3,50;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5318,'Poring_Party_Hat','Poring Party Hat',5,20,NULL,0,NULL,2,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,NULL,1,340,'bonus bAllStats,3;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5319,'Hellomother_Hat','Hello Mother Hat',5,20,NULL,200,NULL,2,NULL,NULL,0xFFFFFFFE,7,2,256,NULL,'10',1,341,'bonus bLuk,3;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5320,'Champion_Wreath','Champion Wreath',5,20,NULL,500,NULL,4,NULL,NULL,0xFFFFFFFE,7,2,256,NULL,NULL,1,261,'bonus bAllStats,2; bonus4 bAutoSpellWhenHit,"AL_HEAL",1,50,0;',NULL,NULL); @@ -3422,7 +3422,7 @@ REPLACE INTO `item_db_re` VALUES (5811,'Santa_Beard','Santa\'s Beard',5,20,NULL, REPLACE INTO `item_db_re` VALUES (5812,'Hat_Of_Expert','Hat Of Expert',5,NULL,NULL,0,NULL,2,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,NULL,1,16,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (5813,'Red_Ph.D_Hat','Red Ph.D Hat',5,1000,NULL,500,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,NULL,1,481,'bonus bInt,1;',NULL,NULL); #5814,Ati_Atihan_Hat3 -REPLACE INTO `item_db_re` VALUES (5815,'Cowboy_Hat_J','Purple Cowboy Hat',5,20,NULL,500,NULL,2,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,NULL,1,475,'bonus bStr,1; bonus2 bSubSize,0,5; bonus2 bSubSize,1,5; bonus2 bSubSize,2,5;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (5815,'Cowboy_Hat_J','Purple Cowboy Hat',5,20,NULL,500,NULL,2,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,NULL,1,475,'bonus bStr,1; bonus2 bSubSize,Size_Small,5; bonus2 bSubSize,Size_Medium,5; bonus2 bSubSize,Size_Large,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5816,'Classic_Hat_J','Classic Hat',5,20,NULL,500,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,NULL,1,411,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (5817,'Valentine_Pledge','Valentine Pledge',5,20,NULL,0,NULL,3,NULL,NULL,0xFFFFFFFF,7,2,136,NULL,NULL,NULL,0,'bonus bAllStats,2; bonus bMdef,3;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5818,'Carnival_Hat','Carnival Hat',5,NULL,NULL,0,NULL,6,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,NULL,1,505,'bonus bAllStats,3;',NULL,NULL); @@ -5298,7 +5298,7 @@ REPLACE INTO `item_db_re` VALUES (12217,'Aspersio_5_Scroll','LV5 Aspersio Scroll REPLACE INTO `item_db_re` VALUES (12218,'Assumptio_5_Scroll','LV5 Assumptio Scroll',2,2,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'skilleffect "HP_ASSUMPTIO",0; sc_start SC_ASSUMPTIO,100000,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (12219,'Wind_Walk_10_Scroll','LV10 Wind Walker Scroll',2,2,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'skilleffect "SN_WINDWALK",0; sc_start SC_WINDWALK,250000,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (12220,'Adrenaline_Scroll','LV5 Adrenaline Scroll',2,2,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'if(getiteminfo(getequipid(EQI_HAND_R),14)==6||getiteminfo(getequipid(EQI_HAND_R),14)==7) { skilleffect "BS_ADRENALINE",0; sc_start SC_ADRENALINE,150000,5; }',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (12221,'Megaphone_','Megaphone',2,2,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'input @Megaphone$; announce strcharinfo(0) + ": " + @megaphone$,bc_all,0xFF0000; end;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (12221,'Megaphone_','Megaphone',2,2,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'input @megaphone$; announce strcharinfo(0) + ": " + @megaphone$,bc_all,0xFF0000; end;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (12225,'Sweet_Candy_Striper','Sweet Candy Cane',2,20,NULL,50,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'pet 1245;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (12226,'Examination1','Examination 1',0,20,NULL,50,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'sc_start SC_SpeedUp0,5400000,0; percentheal 100,100; sc_start SC_STRFOOD,5400000,10; sc_start SC_DEXFOOD,5400000,5; sc_start SC_ATKPOTION,5400000,22; sc_start SC_MATKFOOD,5400000,15;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (12227,'Examination2','Examination 2',0,20,NULL,50,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'sc_start SC_SpeedUp0,5400000,0; percentheal 100,100; sc_start SC_INTFOOD,5400000,8; sc_start SC_VITFOOD,5400000,7; sc_start SC_LUKFOOD,5400000,7; sc_start SC_ATKPOTION,5400000,10;',NULL,NULL); @@ -5332,7 +5332,7 @@ REPLACE INTO `item_db_re` VALUES (12254,'Luk_Dish10_M','Cooked Nine Tail',2,NULL REPLACE INTO `item_db_re` VALUES (12255,'Vit_Dish10_M','Immortal Stew',2,NULL,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'sc_start SC_VITFOOD,3600000,10; percentheal 25,0;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (12256,'PRO_Gift_Box','PRO Gift Box',2,NULL,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (12257,'Cold_Medicine','Cold Medicine',0,20,NULL,100,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,'50',NULL,NULL,'percentheal 25,25;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (12258,'Bombring_Box','Bomb Poring Box',2,NULL,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'getmapxy .@map$,.@x,.@y,0; if(.@map$=="job3_rang02") { monster "this",-1,-1,"--ja--",1904,1,""; }',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (12258,'Bombring_Box','Bomb Poring Box',2,NULL,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'if(strcharinfo(3)=="job3_rang02") { monster "this",-1,-1,"--ja--",1904,1,""; }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (12259,'Miracle_Medicine','Miracle Tonic',2,NULL,NULL,0,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'getexp 3000000,1500000;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (12260,'Cool_Summer_Outfit','Cool Summer Outfit',2,NULL,NULL,100,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'sc_start SC_Summer,600000,0;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (12261,'Secret_Medicine','Leap of Fantasy',2,NULL,NULL,0,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'getexp 2000000,1000000;',NULL,NULL); @@ -5458,7 +5458,7 @@ REPLACE INTO `item_db_re` VALUES (12380,'Desert_Wolf_Babe_Scroll','Job Change Fl REPLACE INTO `item_db_re` VALUES (12381,'ValkyrieA_Scroll','Ancient Languages Scroll',2,10,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'if(strcharinfo(3)=="job3_arch02") { mercenary_create 2037,1800000; }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (12382,'ValkyrieB_Scroll','Ancient Languages Scroll',2,10,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'if(strcharinfo(3)=="job3_arch02") { mercenary_create 2038,1800000; }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (12383,'Vulcan_Bullet_Magazine','Vulcan Bullet Magazine',2,11000,NULL,500,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `item_db_re` VALUES (12384,'Rainbow_Ruby_Water','Rainbow Ruby',11,NULL,NULL,50,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'if(strcharinfo(3)=="job3_war02") { itemSkill "WL_FROSTMISTY",5; }',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (12384,'Rainbow_Ruby_Water','Rainbow Ruby',11,NULL,NULL,50,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'if(strcharinfo(3)=="job3_war02") { itemskill "WL_FROSTMISTY",5; }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (12385,'Rainbow_Ruby_Fire','Rainbow Ruby',11,NULL,NULL,50,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'if(strcharinfo(3)=="job3_war02") { itemskill "WL_CRIMSONROCK",5; }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (12386,'Rainbow_Ruby_Wind','Rainbow Ruby',11,NULL,NULL,50,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'if(strcharinfo(3)=="job3_war02") { itemskill "WL_CHAINLIGHTNING",5; }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (12387,'Rainbow_Ruby_Earth','Rainbow Ruby',11,NULL,NULL,50,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'if(strcharinfo(3)=="job3_war02") { itemskill "WL_EARTHSTRAIN",5; }',NULL,NULL); @@ -7094,7 +7094,7 @@ REPLACE INTO `item_db_re` VALUES (15056,'Special_Ninja_Suit_','Special Ninja Sui # More Maces REPLACE INTO `item_db_re` VALUES (16000,'Erde','Erde',4,20,NULL,500,'130',NULL,1,2,0x0004C5B2,2,2,2,4,'50',1,8,'bonus2 bSkillAtk,"AM_ACIDTERROR",20; bonus2 bSkillAtk,"AM_DEMONSTRATION",20; bonus bMaxSP,50; bonus bHealPower,10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (16001,'Red_Square_Bag','Red Square Bag',4,20,NULL,500,'130',NULL,1,2,0x0004C5B2,2,2,2,3,'50',1,8,'bonus bMaxHP,200; bonus2 bSkillAtk,"AM_ACIDTERROR",20; bonus2 bSkillAtk,"AM_DEMONSTRATION",20; bonus2 bAddMonsterDropItem,501,50; bonus2 bAddMonsterDropItem,502,20; bonus2 bAddMonsterDropItem,503,20; bonus2 bAddMonsterDropItem,504,20; bonus2 bAddMonsterDropItem,505,10; if(readparam(bStr)>=95) bonus2 bAddEff,Eff_Stun,500;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (16002,'Stunner_C','Stunner',4,NULL,NULL,0,'175',NULL,1,NULL,0x00008110,7,2,2,3,'1',NULL,8,'bonus2 bAddEff,Eff_Stun,1000; bonus2 bAddSize,0,40; bonus2 bAddSize,1,40; bonus2 bAddSize,2,40;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (16002,'Stunner_C','Stunner',4,NULL,NULL,0,'175',NULL,1,NULL,0x00008110,7,2,2,3,'1',NULL,8,'bonus2 bAddEff,Eff_Stun,1000; bonus2 bAddSize,Size_Small,40; bonus2 bAddSize,Size_Medium,40; bonus2 bAddSize,Size_Large,40;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (16003,'Carga_Mace','Carga Mace',4,20,NULL,1500,'175',NULL,1,2,0x0004C5B2,7,2,2,3,'100',1,8,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (16004,'P_Mace1','Eden Mace I',4,NULL,NULL,0,'142',NULL,1,NULL,0x0004C5B2,7,2,2,2,'26',NULL,8,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (16005,'P_Mace2','Eden Mace II',4,NULL,NULL,0,'163',NULL,1,NULL,0x0004C5B2,7,2,2,2,'40',NULL,8,NULL,NULL,NULL); |