diff options
author | brianluau <brianluau@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2010-02-10 20:46:34 +0000 |
---|---|---|
committer | brianluau <brianluau@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2010-02-10 20:46:34 +0000 |
commit | 6638bbec78c5a1be1881ddf13afdc575840aa96f (patch) | |
tree | 7ec563b90b511ce1164450282cc44078cccc4130 /sql-files/item_db.sql | |
parent | 0034a439b74142f27a93b422ef66eaa90ddb7ab3 (diff) | |
download | hercules-6638bbec78c5a1be1881ddf13afdc575840aa96f.tar.gz hercules-6638bbec78c5a1be1881ddf13afdc575840aa96f.tar.bz2 hercules-6638bbec78c5a1be1881ddf13afdc575840aa96f.tar.xz hercules-6638bbec78c5a1be1881ddf13afdc575840aa96f.zip |
- Fixed a misleading description. (bugreport:4008)
- Changed the confusing Rare Drop Announce. (bugreport:4037)
- Fixed an extra space in item script. (bugreport:4032)
- Renamed the upgrade_svn file in last commit to match revision number.
- Updated SQL item/mob databases to latest.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14243 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files/item_db.sql')
-rw-r--r-- | sql-files/item_db.sql | 76 |
1 files changed, 38 insertions, 38 deletions
diff --git a/sql-files/item_db.sql b/sql-files/item_db.sql index 52949d737..0896fd2fa 100644 --- a/sql-files/item_db.sql +++ b/sql-files/item_db.sql @@ -654,7 +654,7 @@ REPLACE INTO `item_db` VALUES (1277,'Katar_Of_Raging_Blaze_','Katar of Raging Bl REPLACE INTO `item_db` VALUES (1278,'Katar_Of_Piercing_Wind_','Katar of Piercing Wind',4,45000,NULL,1200,105,NULL,1,3,0x00001000,7,2,34,3,55,1,16,'bonus bAtkEle,Ele_Wind; bonus2 bAddEff,Eff_Sleep,500;',NULL,NULL); REPLACE INTO `item_db` VALUES (1279,'BF_Katar1','Brave Carnage Katar',4,NULL,NULL,0,130,NULL,1,0,0x00001000,7,2,34,3,80,1,16,'bonus bStr,1; bonus bDex,1; bonus bLuk,1; bonus2 bAddRace,RC_DemiHuman,70; bonus2 bIgnoreDefRate,RC_DemiHuman,20; bonus bUnbreakableWeapon,0;',NULL,NULL); REPLACE INTO `item_db` VALUES (1280,'BF_Katar2','Valorous Carnage Katar',4,NULL,NULL,0,130,NULL,1,0,0x00001000,7,2,34,3,80,1,16,'bonus bStr,1; bonus bDex,1; bonus bLuk,1; bonus2 bAddRace,RC_DemiHuman,70; bonus bCritAtkRate,20; bonus bAspdRate,5; bonus bUnbreakableWeapon,0;',NULL,NULL); -REPLACE INTO `item_db` VALUES (1281,'Krieger_Katar1','Glorious Bloody Roar',4,0,NULL,0,140,NULL,1,0,0x00001000,7,2,34,4,80,1,16,'bonus2 bAddRace,RC_DemiHuman,70; bonus2 bIgnoreDefRate,RC_DemiHuman,20; bonus bUnbreakableWeapon,0; if(getrefine() > 5) { bonus2 bAddRace,RC_DemiHuman,(getrefine()-4)*(getrefine()-4); bonus2 bIgnoreDefRate,RC_DemiHuman,5; } if(getrefine() > 8) autobonus \"{ bonus bAspdRate,100; }\",70,3000,BF_WEAPON,\"{ specialeffect2 EF_POTI ON_BERSERK; }\";',NULL,NULL); +REPLACE INTO `item_db` VALUES (1281,'Krieger_Katar1','Glorious Bloody Roar',4,0,NULL,0,140,NULL,1,0,0x00001000,7,2,34,4,80,1,16,'bonus2 bAddRace,RC_DemiHuman,70; bonus2 bIgnoreDefRate,RC_DemiHuman,20; bonus bUnbreakableWeapon,0; if(getrefine() > 5) { bonus2 bAddRace,RC_DemiHuman,(getrefine()-4)*(getrefine()-4); bonus2 bIgnoreDefRate,RC_DemiHuman,5; } if(getrefine() > 8) autobonus \"{ bonus bAspdRate,100; }\",70,3000,BF_WEAPON,\"{ specialeffect2 EF_POTION_BERSERK; }\";',NULL,NULL); REPLACE INTO `item_db` VALUES (1282,'Krieger_Katar2','Glorious Jamadhar',4,0,NULL,0,140,NULL,1,0,0x00001000,7,2,34,4,80,1,16,'bonus2 bAddRace,RC_DemiHuman,70; bonus2 bIgnoreDefRate,RC_DemiHuman,20; bonus bUnbreakableWeapon,0; if(getrefine() > 5) { bonus2 bAddRace,RC_DemiHuman,(getrefine()-4)*(getrefine()-4); bonus bCritAtkRate,5; } if(getrefine() > 8) autobonus \"{ bonus bAspdRate,100; }\",70,3000,BF_WEAPON,\"{ specialeffect2 EF_POTION_BERSERK; }\";',NULL,NULL); REPLACE INTO `item_db` VALUES (1283,'Katar_Of_Speed','Katar Of Speed',4,0,NULL,0,175,NULL,1,0,0x00001000,7,2,34,4,0,1,16,'bonus2 bSkillAtk,\"AS_SONICBLOW\",25; bonus bAspdRate,3;',NULL,NULL); REPLACE INTO `item_db` VALUES (1284,'Krishna','Krishna',4,0,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); @@ -707,8 +707,8 @@ REPLACE INTO `item_db` VALUES (1380,'BF_Two_Handed_Axe2','Brave Insane Battle Ax REPLACE INTO `item_db` VALUES (1381,'N_Battle_Axe','Novice Battle Axe',4,1,NULL,0,100,NULL,1,0,0x000444A3,7,2,34,1,1,0,7,NULL,NULL,NULL); REPLACE INTO `item_db` VALUES (1382,'Krieger_Twohand_Axe1','Glorious Two-Handed Axe',4,0,NULL,0,220,NULL,1,0,0x000444A2,7,2,34,4,80,1,7,'bonus2 bAddRace,RC_DemiHuman,70; bonus2 bIgnoreDefRate,RC_DemiHuman,20; bonus bUnbreakableWeapon,0; if(getrefine() > 5) { bonus2 bAddRace,RC_DemiHuman,(getrefine()-3)*(getrefine()-3); bonus2 bIgnoreDefRate,RC_DemiHuman,5; bonus3 bAutoSpell,\"NPC_CRITICALWOUND\",1,50; } if(getrefine() > 8) { bonus3 bAutoSpell,\"NPC_CRITICALWOUND\",1,100; bonus4 bAutoSpellOnSkill,\"MC_MAMMONITE\",\"NPC_CRITICALWOUND\",2,200; bonus4 bAutoSpellOnSkill,\"WS_CARTTERMINATION\",\"NPC_CRITICALWOUND\",2,200; }',NULL,NULL); REPLACE INTO `item_db` VALUES (1383,'Holy_Celestial_Axe','Celestial Axe',4,0,NULL,1500,250,NULL,1,0,0x000444A2,7,2,34,4,60,1,7,'bonus2 bAddRace,RC_Undead,10; bonus3 bAutoSpell,\"AL_BLESSING\",5,50;',NULL,NULL); -REPLACE INTO `item_db` VALUES (1384,'Veteran_Axe','Veteran Axe',4,0,NULL,3000,250,NULL,1,2,0x000444A2,7,2,34,3,80,1,7,'if(getskilllv(\"BS_DAGGER\")==3) { bonus bAtk,10; } if(getskilllv(\"BS_SWORD\")==3) { bonus bAtk,10; } if(getskilllv(\"BS_TWOHANDSWORD\")==3) { bonus bAtk,10; } if(getskilllv(\"BS_KNUCKLE\")==3) { bonus bAtk,10; } if(getskilllv(\"BS_SPEAR\")==3) { bonus bAtk,10; } if(getskilllv(\"BS_AXE\")==3) { bonus bAtk,10; } if(getskilllv(\"BS_MACE\")==3) { bonus bAtk,10; } bonus bAtkEle,Ele_Neutral; bonus bVit,2;',NULL,NULL); -REPLACE INTO `item_db` VALUES (1385,'Bradium_Stonehammer','Bradium Stone Hammer',4,0,NULL,2700,210,NULL,1,0,0x000444A2,2,2,34,4,75,1,7,'bonus bAtkEle,Ele_Neutral; bonus2 bSkillAtk,\"BS_HAMMERFALL\",2*getrefine();',NULL,NULL); +REPLACE INTO `item_db` VALUES (1384,'Veteran_Axe','Veteran Axe',4,0,NULL,3000,250,NULL,1,2,0x000444A2,7,2,34,3,80,1,7,'if(getskilllv(\"BS_DAGGER\")==3) { bonus bAtk,10; } if(getskilllv(\"BS_SWORD\")==3) { bonus bAtk,10; } if(getskilllv(\"BS_TWOHANDSWORD\")==3) { bonus bAtk,10; } if(getskilllv(\"BS_KNUCKLE\")==3) { bonus bAtk,10; } if(getskilllv(\"BS_SPEAR\")==3) { bonus bAtk,10; } if(getskilllv(\"BS_AXE\")==3) { bonus bAtk,10; } if(getskilllv(\"BS_MACE\")==3) { bonus bAtk,10; } bonus bVit,2;',NULL,NULL); +REPLACE INTO `item_db` VALUES (1385,'Bradium_Stonehammer','Bradium Stone Hammer',4,0,NULL,2700,210,NULL,1,0,0x000444A2,2,2,34,4,75,1,7,'bonus3 bAddEffOnSkill,\"BS_HAMMERFALL\",Eff_Stun,50+(20*getrefine());',NULL,NULL); REPLACE INTO `item_db` VALUES (1386,'Doom_Slayer_I','Doom Slayer',4,20,NULL,0,20,NULL,1,0,0x000444A2,7,2,34,4,0,0,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` VALUES (1387,'Giant_Axe','Giganto Axe',4,0,NULL,4000,330,NULL,1,1,0x000444A2,2,2,34,3,50,1,6,'bonus2 bSkillAtk,\"WS_CARTTERMINATION\",15; if(readparam(bStr)>=95) { bonus bHit,10; bonus bAspdRate,3; }',NULL,NULL); REPLACE INTO `item_db` VALUES (1388,'Two_Handed_Axe_C','Two-Handed Axe',4,0,NULL,0,220,NULL,1,0,0x000444A2,7,2,34,3,1,0,7,'bonus2 bAddSize,0,40; bonus2 bAddSize,1,40; bonus2 bAddSize,2,40;',NULL,NULL); @@ -741,7 +741,7 @@ REPLACE INTO `item_db` VALUES (1425,'BF_Spear1','Assaulter Spear',4,NULL,NULL,0, REPLACE INTO `item_db` VALUES (1426,'Krieger_Onehand_Spear1','Glorious Spear',4,0,NULL,0,130,NULL,3,0,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` VALUES (1427,'Spear_Of_Excellent','Spear Of Excellent',4,0,NULL,0,160,NULL,3,0,0x00004082,7,2,2,3,1,0,4,'bonus2 bSkillAtk,\"SM_MAGNUM\",25; bonus bStr,2;',NULL,NULL); REPLACE INTO `item_db` VALUES (1428,'Long_Horn_M','Long Horn',4,20,NULL,1000,150,NULL,3,0,0x00004082,2,2,2,4,65,1,4,'bonus bAtkEle,Ele_Holy; bonus2 bAddEff,Eff_Bleeding,500; skill \"TF_DETOXIFY\",1; bonus bUnbreakableWeapon,0; if(isequipped(2115)) bonus3 bAutoSpellWhenHit,\"HP_ASSUMPTIO\",2,5;',NULL,NULL); -REPLACE INTO `item_db` VALUES (1429,'Hunting_Spear_M','Hunting Spear',4,0,NULL,4200,180,NULL,3,0,0x00004082,2,2,34,4,60,1,4,'bonus bAtkEle,Ele_Neutral; bonus bIgnoreDefRace,RC_Brute; bonus3 bAddMonsterDropItem,517,RC_Brute,1000; bonus3 bAutoSpell,\"LK_JOINTBEAT\",3,500;',NULL,NULL); +REPLACE INTO `item_db` VALUES (1429,'Hunting_Spear_M','Hunting Spear',4,0,NULL,4200,180,NULL,3,0,0x00004082,2,2,34,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` VALUES (1430,'Pike_C','Pike',4,0,NULL,0,74,NULL,3,0,0x00004082,7,2,2,1,1,0,4,'bonus2 bAddSize,0,70; bonus2 bAddSize,1,70; bonus2 bAddSize,2,70;',NULL,NULL); # 2-Handed Spears REPLACE INTO `item_db` VALUES (1451,'Guisarme','Guisarme',4,13000,NULL,1000,84,NULL,3,2,0x00004082,7,2,34,2,18,1,5,NULL,NULL,NULL); @@ -831,7 +831,7 @@ REPLACE INTO `item_db` VALUES (1544,'Lunakaligo','Lunakaligo',4,20,NULL,700,110, REPLACE INTO `item_db` VALUES (1545,'N_Mace','Novice Mace',4,1,NULL,0,57,NULL,1,0,0x0004C5B3,7,2,2,1,2,0,8,NULL,NULL,NULL); REPLACE INTO `item_db` VALUES (1546,'Krieger_Onehand_Mace1','Glorious Morning Star',4,0,NULL,0,130,NULL,1,0,0x0004C5B3,7,2,2,4,80,1,8,'bonus2 bAddRace,RC_DemiHuman,75; 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,5; } if(getrefine() > 8) { bonus2 bAddEff,Eff_Stun,2000; bonus bAspdRate,5; }',NULL,NULL); REPLACE INTO `item_db` VALUES (1547,'Mace_Of_Madness','Mace Of Madness',4,0,NULL,0,150,NULL,1,0,0x0004C5B2,7,2,2,2,1,0,8,'bonus2 bSkillAtk,\"MC_CARTREVOLUTION\",25; bonus bStr,2;',NULL,NULL); -REPLACE INTO `item_db` VALUES (1548,'Veteran_Hammer','Veteran Hammer',4,0,NULL,1800,160,NULL,1,2,0x00008110,7,2,2,3,80,1,8,'bonus bAtkEle,Ele_Neutral; bonus2 bSkillAtk,\"AL_HEAL\",getskilllv(\"AL_DP\"); bonus bCriticalRate,getskilllv(\"PR_MACEMASTERY\")*2; bonus bInt,1; bonus bLuk,1;',NULL,NULL); +REPLACE INTO `item_db` VALUES (1548,'Veteran_Hammer','Veteran Hammer',4,0,NULL,1800,160,NULL,1,2,0x00008110,7,2,2,3,80,1,8,'bonus2 bSkillAtk,\"AL_HEAL\",getskilllv(\"AL_DP\"); bonus bCriticalRate,getskilllv(\"PR_MACEMASTERY\")*2; bonus bInt,1; bonus bLuk,1;',NULL,NULL); # 1549,Pilebuncker # Books REPLACE INTO `item_db` VALUES (1550,'Book','Book',4,30000,NULL,600,85,NULL,1,3,0x00410100,7,2,2,2,14,1,15,NULL,NULL,NULL); @@ -863,7 +863,7 @@ REPLACE INTO `item_db` VALUES (1575,'BF_Book2','Valorous Battle Strategy Book',4 REPLACE INTO `item_db` VALUES (1576,'Krieger_Book1','Glorious Tablet',4,0,NULL,0,90,NULL,1,0,0x00410100,7,2,2,4,80,1,15,'bonus bMatkRate,15; bonus2 bAddRace,RC_DemiHuman,80; bonus2 bIgnoreDefRate,RC_DemiHuman,25; bonus bUnbreakableWeapon,0; if(getrefine() > 5) { bonus2 bAddRace,RC_DemiHuman,(getrefine()-4)*(getrefine()-4); bonus2 bIgnoreDefRate,RC_DemiHuman,5; } if(getrefine() > 8) autobonus \"{ bonus bBaseAtk,200; }\",30,3000,BF_WEAPON,\"{ specialeffect2 EF_BASH3D; }\";',NULL,NULL); REPLACE INTO `item_db` VALUES (1577,'Krieger_Book2','Glorious Apocalipse',4,0,NULL,0,90,NULL,1,0,0x00410100,7,2,2,4,80,1,15,'bonus bMatkRate,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 bCastrate,-5; bonus bDelayRate,-5; }',NULL,NULL); REPLACE INTO `item_db` VALUES (1578,'Book_Of_Prayer','Book Of Prayer',4,0,NULL,0,140,NULL,1,0,0x00410100,7,2,2,3,1,0,15,'bonus bVit,2; bonus bMdef,2; bonus bMaxSPrate,10;',NULL,NULL); -REPLACE INTO `item_db` VALUES (1579,'Death_Note_M','Ledger of Death',4,0,NULL,1000,137,NULL,1,0,0x00410100,7,2,2,4,85,1,15,'bonus bAtkEle,Ele_Neutral; 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` VALUES (1579,'Death_Note_M','Ledger of Death',4,0,NULL,1000,137,NULL,1,0,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` VALUES (1580,'Encyclopedia_C','Giant Encyclopedia',4,0,NULL,0,145,NULL,1,0,0x00410100,7,2,2,3,0,0,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` VALUES (1599,'Angra_Manyu','Angra Manyu',4,1,NULL,10,200,NULL,2,0,0xFFFFFFFF,7,2,2,1,1,1,8,'bonus bAllStats,50; bonus bBaseAtk,3800; bonus2 bHPDrainRate,1000,100;',NULL,NULL); # Staffs @@ -909,8 +909,8 @@ REPLACE INTO `item_db` VALUES (1639,'N_Rod','Novice_Rod',4,1,NULL,0,15,NULL,1,0, REPLACE INTO `item_db` VALUES (1640,'Krieger_Onehand_Staff1','Glorious Arc Wand',4,0,NULL,0,70,NULL,1,0,0x00018314,7,2,2,4,80,1,10,'bonus2 bMagicAddRace,RC_DemiHuman,15; bonus2 bIgnoreMdefRate,RC_DemiHuman,25; bonus bUnbreakableWeapon,0; if(getrefine() > 5) bonus2 bIgnoreMdefRate,RC_DemiHuman,5; if(getrefine() > 8) { bonus bMatkRate,5; bonus bCastrate,-5; bonus bDelayRate,-5; }',NULL,NULL); REPLACE INTO `item_db` VALUES (1641,'Krieger_Onehand_Staff2','Glorious Staff of Recovery',4,0,NULL,0,70,NULL,1,0,0x00018314,7,2,2,4,80,1,10,'bonus bHealPower,14; bonus bDelayRate,-10; bonus bUnbreakableWeapon,0; if(getrefine() > 5) { bonus2 bIgnoreMdefRate,RC_DemiHuman,5; bonus bHealPower,5+(getrefine()-5)*2; } if(getrefine() > 8) bonus5 bAutoSpellOnSkill,\"AL_HEAL\",\"AL_HEAL\",10,100,1; if(getrefine() > 9) { bonus bHealPower,10; }',NULL,NULL); REPLACE INTO `item_db` VALUES (1642,'Staff_Of_Darkness','Staff Of Darkness',4,0,NULL,0,100,NULL,1,0,0x00818315,7,2,2,2,1,0,10,'bonus bCastrate,-5; bonus bMatkRate,15; bonus bInt,2;',NULL,NULL); -REPLACE INTO `item_db` VALUES (1643,'Dead_Tree_Cane','Withered Branch Staff',4,0,NULL,100,100,NULL,1,0,0x00818315,7,2,2,4,70,1,10,'bonus bMatk,15; bonus bAtkEle,Ele_Neutral; if (getrefine()==6) { bonus bInt,5; bonus bMaxHP,-200; bonus bMaxSP,-100; } else if (getrefine()==7) { bonus bInt,6; bonus bMaxHP,-400; bonus bMaxSP,-200; } else if (getrefine()==8) { bonus bInt,7; bonus bMaxHP,-600; bonus bMaxSP,-300; } else if (getrefine()==9) { bonus bInt,8; bonus bMaxHP,-700; bonus bMaxSP,-400; } else if (getrefine()==10) { bonus bInt,9; bonus bMaxHP,-1000; bonus bMaxSP,-500; } else { bonus bInt,4; }',NULL,NULL); -REPLACE INTO `item_db` VALUES (1644,'Piercing_Staff_M','Staff of Piercing',4,0,NULL,500,80,NULL,1,0,0x00018314,2,2,2,3,70,1,10,'bonus bAtkEle,Ele_Neutral; bonus bInt,4; bonus bMatkRate,15; bonus bIgnoreMdefRate,10+getrefine();',NULL,NULL); +REPLACE INTO `item_db` VALUES (1643,'Dead_Tree_Cane','Withered Branch Staff',4,0,NULL,100,100,NULL,1,0,0x00818315,7,2,2,4,70,1,10,'bonus bMatk,15; if (getrefine()==6) { bonus bInt,5; bonus bMaxHP,-200; bonus bMaxSP,-100; } else if (getrefine()==7) { bonus bInt,6; bonus bMaxHP,-400; bonus bMaxSP,-200; } else if (getrefine()==8) { bonus bInt,7; bonus bMaxHP,-600; bonus bMaxSP,-300; } else if (getrefine()==9) { bonus bInt,8; bonus bMaxHP,-700; bonus bMaxSP,-400; } else if (getrefine()==10) { bonus bInt,9; bonus bMaxHP,-1000; bonus bMaxSP,-500; } else { bonus bInt,4; }',NULL,NULL); +REPLACE INTO `item_db` VALUES (1644,'Piercing_Staff_M','Staff of Piercing',4,0,NULL,500,80,NULL,1,0,0x00018314,2,2,2,3,70,1,10,'bonus bInt,4; bonus bMatkRate,15; bonus bIgnoreMdefRate,10+getrefine();',NULL,NULL); REPLACE INTO `item_db` VALUES (1645,'Lich_Bone_Wand_M','Lich\'s Bone Wand',4,0,NULL,800,60,NULL,1,0,0x00018314,2,2,2,3,70,1,10,'bonus bInt,1; bonus bDex,1; bonus bAtkEle,Ele_Undead; bonus bMatkRate,20; bonus3 bAutoSpellWhenHit,\"NPC_WIDECURSE\",5,10+getrefine(); if(getrefine()>=9){ bonus bMatkRate,3; bonus bMaxSP,300; }',NULL,NULL); # 1646,La'cryma_Stick # 1647,Croce_Staff @@ -1083,7 +1083,7 @@ REPLACE INTO `item_db` VALUES (1983,'Rante_C','Rante Whip',4,0,NULL,0,170,NULL,2 REPLACE INTO `item_db` VALUES (2000,'Destruction_Rod','Staff of Destruction',4,20,NULL,2500,130,NULL,1,1,0x00000200,2,2,34,4,80,1,10,'bonus bMatkRate,25+getrefine()/2; bonus bInt,3; bonus bAgi,10; bonus bUseSPrate,(getrefine()*2); bonus3 bAutoSpellWhenHit,\"WZ_JUPITEL\",5,(getrefine()*20); bonus2 bCastrate,366,-50;',NULL,NULL); REPLACE INTO `item_db` VALUES (2001,'Divine_Cross','Divine Cross',4,20,NULL,1500,120,NULL,1,0,0x00008100,7,2,34,4,70,1,10,'bonus bAtkEle,Ele_Holy; bonus bMatkRate,15; bonus bDex,4; bonus2 bSubRace,RC_Demon,15; bonus2 bSubRace,RC_Undead,15; if (isequipped(2677) || isequipped(2711)) { bonus bMatkRate,10; bonus bDex,2; bonus2 bSubRace,RC_Demon,10; bonus2 bSubRace,RC_Undead,10; };',NULL,NULL); REPLACE INTO `item_db` VALUES (2002,'Krieger_Twohand_Staff1','Glorious Destruction Staff',4,0,NULL,0,70,NULL,1,0,0x00018314,7,2,34,4,80,1,10,'bonus bMatkRate,getrefine(); bonus2 bMagicAddRace,RC_DemiHuman,15; bonus2 bIgnoreMdefRate,RC_DemiHuman,25; bonus bUnbreakableWeapon,0; if(getrefine() > 5) { bonus2 bMagicAddRace,RC_DemiHuman,(getrefine()-5)*2; bonus2 bIgnoreMdefRate,RC_DemiHuman,(getrefine()-5)*2; } if(getrefine() > 8) { bonus5 bAutoSpellOnSkill,\"WZ_STORMGUST\",\"MG_SAFETYWALL\",10,200,1; bonus5 bAutoSpellOnSkill,\"WZ_METEOR\",\"MG_SAFETYWALL\",10,200,1; bonus5 bAutoSpellOnSkill,\"WZ_VERMILION\",\"MG_SAFETYWALL\",10,200,1; }',NULL,NULL); -REPLACE INTO `item_db` VALUES (2003,'Destruction_Rod_M','Staff of Destruction',4,20,NULL,2500,130,NULL,1,0,0x00000200,2,2,34,4,80,1,10,'bonus bAtkEle,Ele_Neutral; bonus bMatkRate,25+getrefine()/2; bonus bInt,3; bonus bAgi,10; bonus bUseSPrate,(getrefine()*2); bonus3 bAutoSpellWhenHit,\"WZ_JUPITEL\",5,(getrefine()*20); bonus2 bCastrate,366,-50;',NULL,NULL); +REPLACE INTO `item_db` VALUES (2003,'Destruction_Rod_M','Staff of Destruction',4,20,NULL,2500,130,NULL,1,0,0x00000200,2,2,34,4,80,1,10,'bonus bMatkRate,25+getrefine()/2; bonus bInt,3; bonus bAgi,10; bonus bUseSPrate,(getrefine()*2); bonus3 bAutoSpellWhenHit,\"WZ_JUPITEL\",5,(getrefine()*20); bonus2 bCastrate,366,-50;',NULL,NULL); # 2004,Kronos # 2005,Dea_Staff # Shields @@ -1116,11 +1116,11 @@ REPLACE INTO `item_db` VALUES (2125,'Strong_Shield','Strong Shield',5,20,NULL,25 REPLACE INTO `item_db` VALUES (2126,'Guyak_Shield','Guyak Shield',5,20,NULL,700,NULL,3,NULL,0,0xFFFFFFFE,7,2,32,NULL,75,1,1,'bonus bMDef,3;',NULL,NULL); REPLACE INTO `item_db` VALUES (2127,'Secular_Mission','Secular Mission',5,20,NULL,0,NULL,10,NULL,0,0xFFFFFFFF,7,2,32,1,1,0,1,'bonus2 bSubRace,RC_NonBoss,25; bonus2 bSubRace,RC_Boss,25;',NULL,NULL); REPLACE INTO `item_db` VALUES (2128,'Herald_Of_GOD_','Sacred Mission',5,128000,NULL,1600,NULL,5,NULL,1,0x00004000,7,2,32,NULL,83,1,3,'bonus bVit,3; bonus bInt,2; bonus bMdef,3; bonus bUnbreakableShield,0;',NULL,NULL); -REPLACE INTO `item_db` VALUES (2129,'Exorcism_Bible','Sacred Scripture',5,20,NULL,600,NULL,5,NULL,0,0x00008100,7,2,32,NULL,50,1,1,'bonus bHPrecovRate,3; bonus bSPrecovRate,3; bonus bInt,1; if(isequipped(1631)) bonus2 bSkillAtk,\"PR_MAGNUS\",20; bonus3 bAutoSpellWhenHit,\"PR_TURNUNDEAD\",1,10;',NULL,NULL); +REPLACE INTO `item_db` VALUES (2129,'Exorcism_Bible','Sacred Scripture',5,20,NULL,600,NULL,5,NULL,0,0x00008100,7,2,32,NULL,50,1,1,'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` VALUES (2130,'Cross_Shield','Cross Shield',5,20,NULL,2000,NULL,6,NULL,1,0x00004000,7,2,32,NULL,80,1,1,'bonus bStr,1; bonus2 bSkillAtk,\"PA_SHIELDCHAIN\",30; bonus2 bSkillAtk,\"CR_SHIELDBOOMERANG\",30; bonus bUseSPrate,10;',NULL,NULL); REPLACE INTO `item_db` VALUES (2131,'Magic_Study_Vol1','Magic Bible Vol1',5,20,NULL,1000,NULL,2,NULL,1,0x00010204,2,2,32,NULL,70,1,1,'bonus bMDef,3; bonus bInt,2; bonus2 bAddEffWhenHit,Eff_Stun,1000;',NULL,NULL); REPLACE INTO `item_db` VALUES (2132,'Shelter_Resistance','Shell Of Resistance',5,0,NULL,0,NULL,9,NULL,0,0xFFFFFFFF,2,2,32,NULL,0,0,1,'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` VALUES (2133,'Tournament_Shield','Tournament Shield',5,20,NULL,1000,NULL,5,NULL,1,0x00004082,2,2,32,NULL,50,1,3,'bonus bAtkRate,1; if( BaseClass == Job_Lord_Knight ) bonus bAspdRate,-5; if( isequipped(1420) || isequipped(1421) || isequipped(1422) ) { bonus bAtkRate,4; bonus bDef,2; }',NULL,NULL); +REPLACE INTO `item_db` VALUES (2133,'Tournament_Shield','Tournament Shield',5,20,NULL,1000,NULL,5,NULL,1,0x00004082,2,2,32,NULL,50,1,3,'bonus bAtkRate,1; if( Class == Job_Lord_Knight ) bonus bAspdRate,-5; if( isequipped(1420) || isequipped(1421) || isequipped(1422) ) { bonus bAtkRate,4; bonus bDef,2; }',NULL,NULL); REPLACE INTO `item_db` VALUES (2134,'Shield_Of_Naga','Shield of Naga',5,20,NULL,500,NULL,3,NULL,1,0x00CFFF80,2,2,32,NULL,70,1,3,'bonus bMdef,3; autobonus2 \"{ bonus bShortWeaponDamageReturn,(getrefine()*3); }\",10,5000,BF_WEAPON,\"{ specialeffect2 EF_GUARD; }\";',NULL,NULL); REPLACE INTO `item_db` VALUES (2135,'Shadow_Guard','Shadow Guard',5,20,NULL,800,NULL,4,NULL,1,0x00020000,2,2,32,NULL,70,1,3,'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` VALUES (2136,'Cracked_Buckler','Cracked Buckler',5,0,NULL,0,NULL,5,NULL,0,0xFFFFFFFF,2,2,32,NULL,0,1,2,'bonus bAgi,2; bonus2 bAddEle,Ele_Neutral,-10; bonus3 bAutoSpellWhenHit,\"PR_KYRIE\",1,50; bonus bMdef,1;',NULL,NULL); @@ -1300,7 +1300,7 @@ REPLACE INTO `item_db` VALUES (2365,'Orleans_Gown','Robes of Orleans',5,20,NULL, REPLACE INTO `item_db` VALUES (2366,'Divine_Cloth','Divine Clothes',5,20,NULL,1500,NULL,6,NULL,1,0xFFFFFFFE,2,2,16,NULL,55,1,0,'bonus2 bResEff,Eff_Curse,500; bonus2 bResEff,Eff_Silence,500; bonus2 bResEff,Eff_Stun,500; bonus2 bResEff,Eff_Stone,500; bonus2 bResEff,Eff_Sleep,500;',NULL,NULL); REPLACE INTO `item_db` VALUES (2367,'Sniping_Suit','Sniping Suit',5,20,NULL,750,NULL,5,NULL,1,0x00000800,2,2,16,NULL,50,1,0,'bonus bMdef,5; bonus bCritical,6+(readparam(bLuk)/10); bonus bDelayRate,-23;',NULL,NULL); REPLACE INTO `item_db` VALUES (2368,'Golden_Armor','Golden Armor',5,20,NULL,2000,NULL,4,NULL,0,0xFFFFFFFF,7,2,16,NULL,NULL,1,0,'bonus bMdef,4;',NULL,NULL); -REPLACE INTO `item_db` VALUES (2369,'Freyja_Overcoat','Freya\'s Clothes',5,0,NULL,500,NULL,12,NULL,0,0xFFFFFFFE,7,2,16,NULL,0,1,0,'bonus2 bSubRace,RC_DemiHuman,10; if ((isequipped(2428)) && (isequipped(2533)) && (isequipped(5306))) { bonus2 bSubRace,RC_DemiHuman,10; bonus bMaxHPrate,20; bonus2 bResEff,Eff_Freeze,10000; skill \"WZ_FIREPILLAR\",10; }',NULL,NULL); +REPLACE INTO `item_db` VALUES (2369,'Freyja_Overcoat','Freya\'s Clothes',5,0,NULL,500,NULL,12,NULL,0,0xFFFFFFFE,7,2,16,NULL,0,1,0,'bonus bUnbreakableArmor,0; bonus2 bSubRace,RC_DemiHuman,10; if ((isequipped(2428)) && (isequipped(2533)) && (isequipped(5306))) { bonus2 bSubRace,RC_DemiHuman,10; bonus bMaxHPrate,20; bonus2 bResEff,Eff_Freeze,10000; skill \"WZ_FIREPILLAR\",10; }',NULL,NULL); REPLACE INTO `item_db` VALUES (2370,'Used_Mage_Coat','Used Mage Coat',5,0,NULL,0,NULL,15,NULL,0,0xFFFFFFFF,7,2,16,1,1,0,0,'bonus bMaxHP,300; bonus bMaxSP,30; bonus bBaseAtk,10; bonus bAGI,1;',NULL,NULL); REPLACE INTO `item_db` VALUES (2371,'G_Strings_','Pantie',5,1000,NULL,100,NULL,4,NULL,1,0xFFFFFFFF,7,2,16,NULL,0,1,0,NULL,NULL,NULL); REPLACE INTO `item_db` VALUES (2372,'Mage_Coat_','Mage Coat',5,20,NULL,600,NULL,5,NULL,1,0x00810204,7,2,16,NULL,50,1,0,'bonus bMdef,5; bonus bInt,1;',NULL,NULL); @@ -2377,7 +2377,7 @@ REPLACE INTO `item_db` VALUES (5206,'Romantic_White_Flower','White Petal',5,20,N REPLACE INTO `item_db` VALUES (5207,'Gold_Spirit_Chain','Angel Blessing',5,20,NULL,100,NULL,0,NULL,0,0xFFFFFFFF,7,2,256,NULL,0,0,260,'bonus bLuk,1; bonus2 bSubEle,Ele_Holy,5;',NULL,NULL); REPLACE INTO `item_db` VALUES (5208,'Rideword_Hat','Rideword Hat',5,20,NULL,300,NULL,2,NULL,1,0xFFFFFFFE,7,2,256,NULL,40,1,262,'bonus2 bHPDrainRate,50,8; bonus2 bSPDrainRate,10,4; bonus2 bHPLossRate,10,5000;',NULL,NULL); REPLACE INTO `item_db` VALUES (5209,'Yellow_Baseball_Cap','iRO Baseball Cap',5,20,NULL,300,NULL,2,NULL,0,0xFFFFFFFE,7,2,256,NULL,0,1,263,NULL,NULL,NULL); -REPLACE INTO `item_db` VALUES (5210,'Flying_Angel','Flying Angel',5,20,NULL,300,NULL,1,NULL,0,0xFFFFFFFF,7,2,256,NULL,10,1,264,'bonus bCastrate,-3; bonus bAspdRate,3;',NULL,NULL); +REPLACE INTO `item_db` VALUES (5210,'Flying_Angel','Flying Angel',5,20,NULL,300,NULL,1,NULL,0,0xFFFFFFFF,7,2,256,NULL,10,1,264,'bonus bCastrate,-3; bonus bAspdRate,3; bonus bInt,1; bonus bAgi,1;',NULL,NULL); REPLACE INTO `item_db` VALUES (5211,'Dress_Hat','Ribbon Hat',5,0,NULL,200,NULL,2,NULL,1,0xFFFFFFFF,7,2,256,NULL,20,1,265,'bonus bMdef,7; bonus bStr,1; bonus bInt,1; if(getrefine() >= 7) {bonus bAtkRate,3; bonus bMAtkRate,3; bonus2 bSkillHeal,\"AL_HEAL\",6;} else { bonus bAtkRate,2; bonus bMAtkRate,2; bonus2 bSkillHeal,\"AL_HEAL\",5;}',NULL,NULL); REPLACE INTO `item_db` VALUES (5212,'Satellite_Hairband','Solar Panels',5,0,NULL,1000,NULL,3,NULL,1,0xFFFFFFFF,7,2,256,NULL,30,1,266,'bonus bMaxHP,50; bonus bMaxSP,10; skill \"AL_RUWACH\",1;',NULL,'sc_end SC_RUWACH;'); REPLACE INTO `item_db` VALUES (5213,'Black_Bunny_Band','Rabbit Ears',5,0,NULL,200,NULL,2,NULL,0,0xFFFFFFFF,7,2,256,NULL,0,1,267,'bonus bAgi,2; bonus bMdef,3;',NULL,NULL); @@ -2425,7 +2425,7 @@ REPLACE INTO `item_db` VALUES (5254,'Deviling_Hat','Deviling Hat',5,20,NULL,350, REPLACE INTO `item_db` VALUES (5255,'Triple_Poring_Hat','Poring Tower',5,20,NULL,600,NULL,3,NULL,0,0xFFFFFFFF,7,2,256,NULL,20,0,299,'bonus bLuk,3; bonus3 bAutoSpell,\"BS_GREED\",1,50;',NULL,NULL); REPLACE INTO `item_db` VALUES (5256,'Valkyrie_Feather_Band','Valkyrie Feather Band',5,20,NULL,100,NULL,1,NULL,1,0xFFFFFFFF,7,2,256,NULL,20,1,300,'bonus bInt,1; bonus3 bAutoSpellWhenHit,\"AL_HEAL\",1,10;',NULL,NULL); REPLACE INTO `item_db` VALUES (5257,'Soulless_Wing','Soul Ring',5,20,NULL,300,NULL,2,NULL,0,0xFFFFFFFE,7,2,256,NULL,20,1,301,'bonus bMdef,2; bonus3 bAutoSpellWhenHit,\"HP_ASSUMPTIO\",1,10;',NULL,NULL); -REPLACE INTO `item_db` VALUES (5258,'Afro_Wig','Dokebi\'s Wig',5,20,NULL,100,NULL,0,NULL,0,0xFFFFFFFF,7,2,768,NULL,10,1,302,'bonus3 bAutoSpellWhenHit,\"NV_FIRSTAID\",1,300; bonus2 bSubEle,Ele_Neutral,1;',NULL,NULL); +REPLACE INTO `item_db` VALUES (5258,'Afro_Wig','Dokebi\'s Wig',5,20,NULL,100,NULL,0,NULL,1,0xFFFFFFFF,7,2,768,NULL,10,1,302,'bonus3 bAutoSpellWhenHit,\"NV_FIRSTAID\",1,300; bonus2 bSubEle,Ele_Neutral,1;',NULL,NULL); REPLACE INTO `item_db` VALUES (5259,'Elephant_Hat_','Elephant Hat',5,20,NULL,500,NULL,3,NULL,0,0xFFFFFFFF,7,2,256,NULL,0,1,215,'bonus bVit,1; bonus3 bAutoSpell,\"WZ_WATERBALL\",3,10; skill \"AL_HOLYWATER\",1;',NULL,NULL); REPLACE INTO `item_db` VALUES (5260,'Cookie_Hat','Cookie Hat',5,20,NULL,500,NULL,2,NULL,0,0xFFFFFFFF,7,2,256,NULL,0,1,217,'bonus bAgi,1; bonus bFlee2,5; bonus bCritAtkRate,5;',NULL,NULL); REPLACE INTO `item_db` VALUES (5261,'Silver_Tiara_','Silver Tiara',5,20,NULL,500,NULL,2,NULL,0,0xFFFFFFFF,7,2,256,NULL,0,1,218,'bonus bInt,2; if (BaseClass == Job_Mage) bonus bMatkRate,(JobLevel/20); if (Baseclass == Job_Acolyte) bonus bUseSPrate,-(JobLevel/10); if (BaseClass == Job_Archer) bonus bMaxSP,(JobLevel*2);',NULL,NULL); @@ -2566,7 +2566,7 @@ REPLACE INTO `item_db` VALUES (5395,'Tiraya_Bonnet','Tiraya Bonnet',5,20,NULL,50 REPLACE INTO `item_db` VALUES (5396,'Jasper_Crest','Jasper Crest',5,20,NULL,700,NULL,2,NULL,0,0xFFFFFFFF,7,2,256,NULL,0,1,399,'bonus bDex,3; bonus bVit,1;',NULL,NULL); # REPLACE INTO `item_db` VALUES (5397,'Scuba_Mask','Scuba Gear',5,20,NULL,100,NULL,0,NULL,0,0xFFFFFFFF,7,2,512,NULL,0,0,400,'bonus2 bSubEle,Ele_Water,10;',NULL,NULL); REPLACE INTO `item_db` VALUES (5398,'Bone_Head','Bone Head',5,20,NULL,1200,NULL,5,NULL,1,0x000444A2,2,2,256,NULL,85,1,401,'bonus bStr,2; bonus bMdef,5; bonus2 bResEff,Eff_Stun,500; bonus2 bResEff,Eff_Bleeding,500;',NULL,NULL); -REPLACE INTO `item_db` VALUES (5399,'Mandragora_Cap','Mandragora Cap',5,20,NULL,300,NULL,1,NULL,1,0xFFFFFFFF,2,2,256,NULL,85,0,402,'bonus bVit,3; bonus3 bAutoSpellWhenHit,\"DC_SCREAM\",5,10;',NULL,NULL); +REPLACE INTO `item_db` VALUES (5399,'Mandragora_Cap','Mandragora Cap',5,20,NULL,300,NULL,1,NULL,1,0xFFFFFFFF,2,2,256,NULL,85,0,402,'bonus bVit,3; bonus3 bAutoSpellWhenHit,\"DC_SCREAM\",5,30;',NULL,NULL); REPLACE INTO `item_db` VALUES (5400,'Fox_Hat','Fox Mask',5,20,NULL,200,NULL,1,NULL,0,0xFFFFFFFF,7,0,769,NULL,0,1,403,'bonus bLuk,1;',NULL,NULL); REPLACE INTO `item_db` VALUES (5401,'Black_Glasses','Black Glasses',5,20,NULL,200,NULL,1,NULL,0,0xFFFFFFFF,7,2,512,NULL,70,0,404,'bonus bInt,1; bonus bMdef,2;',NULL,NULL); REPLACE INTO `item_db` VALUES (5402,'Mischievous_Fairy','Naughty Fairy',5,20,NULL,200,NULL,1,NULL,0,0xFFFFFFFF,7,2,512,NULL,70,0,405,'bonus bFlee2,3;',NULL,NULL); @@ -2610,28 +2610,28 @@ REPLACE INTO `item_db` VALUES (5439,'Fillet_Red','Red Ribbon',5,NULL,NULL,100,NU REPLACE INTO `item_db` VALUES (5440,'Fillet_Blue','Blue Ribbon',5,NULL,NULL,100,NULL,1,NULL,0,0xFFFFFFFE,7,2,256,NULL,0,0,441,'bonus bMaxSP,20;',NULL,NULL); REPLACE INTO `item_db` VALUES (5441,'Fillet_White','White Ribbon',5,NULL,NULL,100,NULL,1,NULL,0,0xFFFFFFFE,7,2,256,NULL,0,0,442,'bonus bMaxSP,20;',NULL,NULL); REPLACE INTO `item_db` VALUES (5442,'Necktie','Neck Tie',5,NULL,NULL,100,NULL,3,NULL,1,0xFFFFFFFF,7,2,256,NULL,70,1,443,'bonus bVit,1; bonus bHit,-5; bonus bUseSPrate,5; if(isequipped(5040)) { bonus bAspdRate,3; bonus bCastrate,3; }',NULL,NULL); -# 5443,Status_Of_Baby_Angel +REPLACE INTO `item_db` VALUES (5443,'Status_Of_Baby_Angel','Cherub Hat',5,NULL,NULL,600,NULL,3,NULL,1,0xFFFFFFFF,7,2,256,NULL,0,1,444,'bonus bMdef,2; bonus4 bAutoSpellWhenHit,\"PR_STRECOVERY\",1,20,0;',NULL,NULL); REPLACE INTO `item_db` VALUES (5444,'Hair_Brush','Hair Brush',5,NULL,NULL,100,NULL,0,NULL,0,0xFFFFFFFF,7,2,256,NULL,0,1,445,'bonus bCritical,6;',NULL,NULL); REPLACE INTO `item_db` VALUES (5445,'Candy_Cane_In_The_Mouth','Lollipop',5,NULL,NULL,100,NULL,0,NULL,0,0xFFFFFFFF,7,2,1,NULL,0,1,446,'bonus bMaxSP,5;',NULL,NULL); REPLACE INTO `item_db` VALUES (5446,'Cat_Foot_Hairpin','Cat\'s Footprint Hairpin',5,NULL,NULL,200,NULL,0,NULL,1,0xFFFFFFFF,7,2,256,NULL,0,1,447,'bonus bFlee,5; bonus bFlee2,3;',NULL,NULL); REPLACE INTO `item_db` VALUES (5447,'Frog_Cap','Frog Hat',5,NULL,NULL,500,NULL,3,NULL,0,0xFFFFFFFF,7,2,256,NULL,70,1,448,'bonus bMdef,1; bonus2 bAddRace,RC_Insect,12; bonus2 bMagicAddRace,RC_Insect,12;',NULL,NULL); REPLACE INTO `item_db` VALUES (5448,'Solo_Play_Box1','Solo Play Box1',5,NULL,NULL,300,NULL,0,NULL,1,0xFFFFFFFF,7,2,769,NULL,0,1,449,NULL,NULL,NULL); REPLACE INTO `item_db` VALUES (5449,'Solo_Play_Box2','Solo Play Box2',5,NULL,NULL,300,NULL,0,NULL,1,0xFFFFFFFF,7,2,769,NULL,0,1,450,NULL,NULL,NULL); -# 5450,Sun_Cap -# 5451,Dragonhelm_Gold -# 5452,Dragonhelm_Silver -# 5453,Dragonhelm_Copper +# REPLACE INTO `item_db` VALUES (5450,'Sun_Cap','Solar Hat',5,NULL,NULL,1000,NULL,0,NULL,0,0xFFFFFFFE,7,2,256,NULL,20,1,451,NULL,NULL,NULL); +# REPLACE INTO `item_db` VALUES (5451,'Dragonhelm_Gold','RWC 2008 Dragon Helm Gold',5,NULL,NULL,2500,NULL,7,NULL,0,0xFFFFFFFF,7,2,256,NULL,0,0,452,'bonus bAspdRate,10; bonus bAllStats,3; bonus2 bAddRace,RC_DemiHuman,5;',NULL,NULL); +# REPLACE INTO `item_db` VALUES (5452,'Dragonhelm_Silver','RWC 2008 Dragon Helm Silver',5,NULL,NULL,2500,NULL,5,NULL,0,0xFFFFFFFF,7,2,256,NULL,0,0,453,'bonus bAspdRate,7; bonus bAllStats,2; bonus2 bAddRace,RC_DemiHuman,3;',NULL,NULL); +# REPLACE INTO `item_db` VALUES (5453,'Dragonhelm_Copper','RWC 2008 Dragon Helm Copper',5,NULL,NULL,2500,NULL,0,NULL,0,0xFFFFFFFF,7,2,256,NULL,0,0,454,'bonus bAspdRate,5; bonus bAllStats,2; bonus2 bAddRace,RC_DemiHuman,1;',NULL,NULL); REPLACE INTO `item_db` VALUES (5454,'Dog_Cap_','Puppy Hat',5,NULL,NULL,500,NULL,3,NULL,1,0xFFFFFFFF,7,2,256,NULL,0,1,234,NULL,NULL,NULL); -REPLACE INTO `item_db` VALUES (5455,'Geographer_Band_','Decorative Geographer',5,NULL,NULL,500,NULL,1,NULL,1,0xFFFFFFFF,7,2,256,NULL,0,1,456,NULL,NULL,NULL); -REPLACE INTO `item_db` VALUES (5456,'Vacation_Hat_','Summer Hat',5,NULL,NULL,200,NULL,0,NULL,1,0xFFFFFFFF,7,2,256,NULL,0,1,457,NULL,NULL,NULL); +REPLACE INTO `item_db` VALUES (5455,'Geographer_Band_','Decorative Geographer',5,NULL,NULL,500,NULL,1,NULL,1,0xFFFFFFFF,7,2,256,NULL,0,1,238,'bonus3 bAutoSpell,\"AL_HEAL\",5,50; bonus3 bAutoSpellWhenHit,\"AL_HEAL\",5,30;',NULL,NULL); +REPLACE INTO `item_db` VALUES (5456,'Vacation_Hat_','Summer Hat',5,NULL,NULL,200,NULL,0,NULL,1,0xFFFFFFFF,7,2,256,NULL,0,1,315,'bonus bHPrecovRate,20; bonus bSPrecovRate,15;',NULL,NULL); REPLACE INTO `item_db` VALUES (5457,'Spring_Rabbit_Hat','Spring Rabbit Hat',5,NULL,NULL,300,NULL,2,NULL,0,0xFFFFFFFE,7,2,256,NULL,0,1,455,'bonus bAgi,3;',NULL,NULL); REPLACE INTO `item_db` VALUES (5458,'Pinwheel_Cap','Pinwheel Cap',5,NULL,NULL,200,NULL,2,NULL,0,0xFFFFFFFF,7,2,256,NULL,0,1,456,'bonus bHPrecovRate,5; bonus bHPrecovRate,5;',NULL,NULL); -# 5459,Drooping_Bunny_Chusuk -# 5460,Adv_Dragon_Skull -# 5461,Adv_Whisper_Mask -# 5462,Spiked_Scarf -# 5463,Rainbow_Scarf -# 5464,Zaha_Doll_Hat +REPLACE INTO `item_db` VALUES (5459,'Drooping_Bunny_Chusuk','Drooping_Bunny',5,NULL,NULL,100,NULL,1,NULL,0,0xFFFFFFFF,7,2,256,NULL,0,1,249,'bonus bDex,1; bonus bFlee,2;',NULL,NULL); +# REPLACE INTO `item_db` VALUES (5460,'Adv_Dragon_Skull','Evolved Dragon Skull Hat',5,NULL,NULL,1000,NULL,7,NULL,0,0xFFFFFFFF,7,2,256,NULL,60,1,457,'bonus bAllStats,2; bonus bMaxHPrate,3;',NULL,NULL); +# REPLACE INTO `item_db` VALUES (5461,'Adv_Whisper_Mask','Evolved Whisper Mask',5,NULL,NULL,300,NULL,1,NULL,0,0xFFFFFFFF,7,2,769,NULL,50,1,458,'bonus bDex,3; bonus2 bSubEle,Ele_Ghost,20;',NULL,NULL); +# REPLACE INTO `item_db` VALUES (5462,'Spiked_Scarf','Spiked Scarf',5,NULL,NULL,100,NULL,1,NULL,0,0xFFFFFFFF,7,2,1,NULL,90,1,459,'bonus bVit,1; bonus2 bAddRace,RC_DemiHuman,1; bonus2 bSubRace,RC_DemiHuman,1;',NULL,NULL); +# REPLACE INTO `item_db` VALUES (5463,'Rainbow_Scarf','Rainbow Scarf',5,NULL,NULL,100,NULL,1,NULL,0,0xFFFFFFFF,7,2,1,NULL,90,1,460,'bonus bInt,1; bonus bMdef,2; bonus bMatkRate,1;',NULL,NULL); +# REPLACE INTO `item_db` VALUES (5464,'Zaha_Doll_Hat','Zaha Doll Hat',5,NULL,NULL,0,NULL,1,NULL,0,0xFFFFFFFF,7,2,256,NULL,0,0,461,'bonus bInt,2; skill \"PR_MAGNIFICAT\",3;',NULL,NULL); REPLACE INTO `item_db` VALUES (5465,'Celestial_Hat','Sky Hat',5,NULL,NULL,500,NULL,3,NULL,1,0xFFFFFFFF,7,2,256,NULL,40,1,462,'bonus bLuk,2; bonus bMdef,5; if(getrefine()>4) bonus bLuk,getrefine();',NULL,NULL); REPLACE INTO `item_db` VALUES (5466,'Wind_Milestone','Wind Milestone',5,NULL,NULL,100,NULL,2,NULL,0,0xFFFFFFFF,7,2,256,NULL,30,1,463,'bonus bAgi,2; skill \"AL_TELEPORT\",1;',NULL,NULL); REPLACE INTO `item_db` VALUES (5467,'Helm_Of_Dragoon','Dragoon Helm',5,NULL,NULL,200,NULL,5,NULL,0,0xFFFFFFFF,7,2,256,NULL,50,1,464,'bonus2 bAddRace,RC_Dragon,20; bonus3 bAutoSpell,\"NPC_WIDEBLEEDING\",1,30; bonus3 bAutoSpell,\"NPC_WIDEFREEZE\",1,30; bonus3 bAutoSpell,\"NPC_WIDESILENCE\",1,30; bonus3 bAutoSpell,\"NPC_WIDESTONE\",1,30; bonus3 bAutoSpell,\"NPC_WIDECONFUSE\",1,30; bonus3 bAutoSpell,\"NPC_WIDESLEEP\",1,30;',NULL,NULL); @@ -2644,27 +2644,27 @@ REPLACE INTO `item_db` VALUES (5473,'Forceps_Hairpin','Nipper Crab Hairpin',5,NU REPLACE INTO `item_db` VALUES (5474,'Notice_Board','Notice Board',5,NULL,NULL,700,NULL,2,NULL,0,0xFFFFFFFF,7,2,256,NULL,10,1,471,NULL,NULL,NULL); REPLACE INTO `item_db` VALUES (5475,'Cube_Mask','Cube Mask',5,NULL,NULL,100,NULL,1,NULL,0,0xFFFFFFFF,7,2,513,NULL,0,1,472,NULL,NULL,NULL); REPLACE INTO `item_db` VALUES (5476,'Hairband_Of_Grandpeco','Grand Peco Hairband',5,NULL,NULL,800,NULL,2,NULL,0,0xFFFFFFFF,7,2,768,NULL,30,1,473,'bonus bStr,2; bonus bMaxHPrate,-10; bonus2 bAddRace2,3,15;',NULL,NULL); -# 5477,Bro_Flag +# REPLACE INTO `item_db` VALUES (5477,'Bro_Flag','Brazilian Flag Hat',5,NULL,NULL,100,NULL,1,NULL,0,0xFFFFFFFF,7,2,256,NULL,30,1,474,'skill \"SM_BASH\",1;',NULL,NULL); REPLACE INTO `item_db` VALUES (5478,'Classic_Hat','Classic Hat',5,NULL,NULL,500,NULL,3,NULL,1,0xFFFFFFFF,7,2,256,NULL,0,1,475,'bonus bStr,2; bonus bMaxHP,300;',NULL,NULL); REPLACE INTO `item_db` VALUES (5479,'Shaman\'s_Hair_Ornament','Shaman\'s Hair Ornament',5,NULL,NULL,300,NULL,2,NULL,0,0xFFFFFFFF,7,2,256,NULL,1,1,476,'bonus bMdef,3; bonus2 bSubEle,Ele_Neutral,5;',NULL,NULL); REPLACE INTO `item_db` VALUES (5480,'Bizofnil_Wing_Deco','Feather Of Vizofnir',5,NULL,NULL,1000,NULL,6,NULL,1,0xFFFFFFFF,7,2,256,NULL,1,1,477,'bonus bAllStats,2; bonus2 bSubEle,Ele_Neutral,5; bonus2 bSubEle,Ele_Water,5; bonus2 bSubEle,Ele_Earth,5; bonus2 bSubEle,Ele_Fire,5; bonus2 bSubEle,Ele_Wind,5; bonus2 bSubEle,Ele_Poison,5; bonus2 bSubEle,Ele_Holy,5; bonus2 bSubEle,Ele_Dark,5; bonus2 bSubEle,Ele_Ghost,5; bonus2 bSubEle,Ele_Undead,5; bonus2 bHPRegenRate,2,10000; bonus2 bSPRegenRate,1,10000;',NULL,NULL); REPLACE INTO `item_db` VALUES (5481,'Hermose_Cap','Hermose Cap',5,NULL,NULL,1000,NULL,2,NULL,0,0xFFFFFFFF,7,2,256,NULL,1,1,478,'bonus bAspdRate,5; bonus bAtkRate,3;',NULL,NULL); -REPLACE INTO `item_db` VALUES (5482,'Dark_Knight_Mask','Dark Knight Mask',5,NULL,NULL,3000,NULL,5,NULL,0,0xFFFFFFFF,7,2,1,NULL,1,1,479,'bonus bStr,3; if(isequipped(2779) && isequipped(2780)) { bonus bMatkRate,10; bonus bInt,5; }',NULL,NULL); -REPLACE INTO `item_db` VALUES (5483,'Odin_Mask','Odin Mask',5,NULL,NULL,100,NULL,1,NULL,0,0xFFFFFFFF,7,2,1,NULL,1,1,480,'bonus2 bSubRace,RC_Boss,2;',NULL,NULL); -# 5484,Taiwan_Flag_Hat +REPLACE INTO `item_db` VALUES (5482,'Dark_Knight_Mask','Dark Knight Mask',5,NULL,NULL,3000,NULL,5,NULL,0,0xFFFFFFFF,7,2,769,NULL,1,1,479,'bonus bStr,3; if(isequipped(2779) && isequipped(2780)) { bonus bMatkRate,10; bonus bInt,5; }',NULL,NULL); +REPLACE INTO `item_db` VALUES (5483,'Odin_Mask','Odin Mask',5,NULL,NULL,100,NULL,1,NULL,0,0xFFFFFFFF,7,2,512,NULL,1,1,480,'bonus2 bSubRace,RC_Boss,2;',NULL,NULL); +# REPLACE INTO `item_db` VALUES (5484,'Taiwan_Flag_Hat','Holidays Hat',5,NULL,NULL,500,NULL,4,NULL,0,0xFFFFFFFF,7,2,256,NULL,0,1,482,'bonus bAllStats,5; bonus2 bResEff,Eff_Stun,500;',NULL,NULL); REPLACE INTO `item_db` VALUES (5485,'Tiger_Face','Tiger Face',5,NULL,NULL,1000,NULL,3,NULL,0,0xFFFFFFFF,7,2,769,NULL,60,1,483,'bonus2 bSubRace,RC_Brute,5; bonus2 bAddRace,RC_Brute,5; bonus2 bMagicAddRace,RC_Brute,5;',NULL,NULL); REPLACE INTO `item_db` VALUES (5486,'J_Anniversary_Hat','Anniversary Hat',5,NULL,NULL,300,NULL,3,NULL,0,0xFFFFFFFF,7,2,256,NULL,0,1,395,'bonus bAllStats,2;',NULL,NULL); REPLACE INTO `item_db` VALUES (5487,'J_Poringcake_Hat','Poring cake Hat',5,NULL,NULL,500,NULL,1,NULL,0,0xFFFFFFFF,7,2,256,NULL,0,1,417,'bonus bLuk,2;',NULL,NULL); REPLACE INTO `item_db` VALUES (5488,'J_Twin_Santahat','Twin Santa hat',5,NULL,NULL,100,NULL,1,NULL,0,0xFFFFFFFF,7,2,256,NULL,0,1,390,'bonus bLuk,1; bonus bMdef,1;',NULL,NULL); -# 5489,Love_Daddy -# 5490,Anubis_Helm -# 5491,Hat_Of_Outlaw +# REPLACE INTO `item_db` VALUES (5489,'Love_Daddy','Love Daddy Hat',5,NULL,NULL,100,NULL,0,NULL,0,0xFFFFFFFF,7,2,256,NULL,0,1,484,'bonus bDex,2;',NULL,NULL); +# REPLACE INTO `item_db` VALUES (5490,'Anubis_Helm','Anubis Helm',5,NULL,NULL,0,NULL,3,NULL,0,0xFFFFFFFF,7,2,256,NULL,70,1,485,'bonus2 bSubRace,RC_Boss,10; bonus2 bSkillHeal2,\"AL_HEAL\",10; bonus2 bAddItemHealRate,IG_Recovery,10;',NULL,NULL); +# REPLACE INTO `item_db` VALUES (5491,'Hat_Of_Outlaw','Bandit Hat',5,NULL,NULL,800,NULL,3,NULL,0,0xFFFFFFFF,7,2,256,NULL,0,1,486,'bonus bStr,2; bonus2 bSubEle,Ele_Fire,10;',NULL,NULL); REPLACE INTO `item_db` VALUES (5492,'Boy\'s_Cap_I','Boys Cap',5,0,NULL,0,NULL,5,NULL,0,0xFFFFFFFE,7,2,256,NULL,0,1,102,'bonus2 bAddRace,RC_DemiHuman,5;',NULL,NULL); REPLACE INTO `item_db` VALUES (5493,'Ulle_Cap_I','Ulle\'s Cap',5,0,NULL,0,NULL,3,NULL,0,0xFFFFFFFE,7,2,256,NULL,0,1,254,'bonus bDex,2; bonus bAgi,1; if(isequipped(2353) && readparam(bDex)>=70) bonus bUseSPrate,-10;',NULL,NULL); REPLACE INTO `item_db` VALUES (5494,'Spinx_Helm_I','Sphinx Hat',5,0,NULL,0,NULL,5,NULL,0,0x00004082,7,2,769,NULL,0,0,137,'bonus bStr,5;',NULL,NULL); -# 5495,Power_Of_Thor -# 5496,Dice_Hat -# 5497,King_Tiger_Doll_Hat +# REPLACE INTO `item_db` VALUES (5495,'Power_Of_Thor','Power Of Thor',5,0,NULL,500,NULL,6,NULL,0,0xFFFFFFFF,7,2,256,NULL,75,0,493,'bonus bFlee,5; bonus bAllStats,1;',NULL,NULL); +# REPLACE INTO `item_db` VALUES (5496,'Dice_Hat','Dice Hat',5,0,NULL,500,NULL,3,NULL,0,0xFFFFFFFF,7,2,256,NULL,50,0,494,'bonus bLuk,4;',NULL,NULL); +# REPLACE INTO `item_db` VALUES (5497,'King_Tiger_Doll_Hat','King Tiger Doll Hat',5,0,NULL,400,NULL,3,NULL,0,0xFFFFFFFF,7,2,256,NULL,30,0,495,'bonus bStr,2;',NULL,NULL); REPLACE INTO `item_db` VALUES (5498,'Wondering_Wolf_King_Hel','Wandering Wolf Hat',5,NULL,NULL,600,NULL,5,NULL,0,0xFFFFFFFE,7,2,768,NULL,50,0,490,'bonus bFlee,10; bonus bVit,5;',NULL,NULL); # 5499,Pizza_Hat # 5500,Icecream_Hat |