summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
authorHaru <haru@dotalux.com>2017-08-22 02:32:32 +0200
committerHaru <haru@dotalux.com>2017-09-17 17:48:31 +0200
commit015f2760dbfeb45132813830e4f5e1bda54f3eee (patch)
tree45f9be74f40ee7a01df47c9a592c86dc3def2f6a /sql-files
parent05d428177f3d8d31a801864325b9d801fa1d4d55 (diff)
downloadhercules-015f2760dbfeb45132813830e4f5e1bda54f3eee.tar.gz
hercules-015f2760dbfeb45132813830e4f5e1bda54f3eee.tar.bz2
hercules-015f2760dbfeb45132813830e4f5e1bda54f3eee.tar.xz
hercules-015f2760dbfeb45132813830e4f5e1bda54f3eee.zip
Item DB SQL Update
Signed-off-by: Haru <haru@dotalux.com>
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/item_db_re.sql54
1 files changed, 27 insertions, 27 deletions
diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql
index 3867ebb8f..8c65f3a5d 100644
--- a/sql-files/item_db_re.sql
+++ b/sql-files/item_db_re.sql
@@ -6939,7 +6939,7 @@ REPLACE INTO `item_db` VALUES ('13291','Starfish','Starfish','10','7','0','0','5
REPLACE INTO `item_db` VALUES ('13292','Dried_Squid','Dried Squid','10','7','10','5','20','50','0','0','0','0','33554432','63','2','32768','0','0',NULL,'0','1','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','bonus bAtkEle,Ele_Neutral; bonus2 bAddEff,Eff_Stun,1000;','','');
REPLACE INTO `item_db` VALUES ('13293','Flying_Fish','Flying Fish','10','6','10','5','20','50','0','0','0','0','33554432','63','2','32768','0','0',NULL,'0','1','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','bonus bAtkEle,Ele_Neutral; bonus3 bAutoSpell,NPC_CRITICALWOUND,1,3;','','');
REPLACE INTO `item_db` VALUES ('13294','Explosive_Kunai','Explosive Kunai','10','7','100','50','30','50','0','0','0','0','33554432','63','2','32768','0','100',NULL,'0','1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtkEle,Ele_Neutral;','','');
-REPLACE INTO `item_db` VALUES ('13295','Light_Shuriken','Light Shuriken','10','1','0','0','5','5','0','0','0','0','18446744073709551615','63','2','32768','0','0',NULL,'0','1','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','','','');
+REPLACE INTO `item_db` VALUES ('13295','Light_Shuriken','Light Shuriken','10','6','0','0','5','5','0','0','0','0','18446744073709551615','63','2','32768','0','0',NULL,'0','1','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('13300','Huuma_Bird_Wing','Huuma Wing Shuriken','4','22','90000','45000','3000','150','0','0','1','0','570425344','1','2','34','4','65',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0; bonus bAtkEle,Ele_Wind; bonus bDex,-2; bonus bAgi,-1;','','');
REPLACE INTO `item_db` VALUES ('13301','Huuma_Giant_Wheel','Huuma Giant Wheel Shuriken','4','22','40000','20000','2500','50','0','0','1','3','570425344','1','2','34','4','42',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0; bonus2 bAddEff,Eff_Bleeding,100;','','');
REPLACE INTO `item_db` VALUES ('13302','Huuma_Giant_Wheel_','Huuma Giant Wheel Shuriken','4','22','40000','20000','2500','50','0','0','1','4','570425344','1','2','34','4','42',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0; bonus2 bAddEff,Eff_Bleeding,100;','','');
@@ -8040,19 +8040,19 @@ REPLACE INTO `item_db` VALUES ('15067','Rune_Suit','Rune Suit','5','0','0','0','
REPLACE INTO `item_db` VALUES ('15068','Im_Angels_Protection','Advanced Angelic Protection','5','0','10000','5000','600','0','0','40','0','1','1','47','2','16','0','99',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,30;','','');
REPLACE INTO `item_db` VALUES ('15073','Anti_Magic_Suit','Anti-Magic Suit','5','0','20','10','1500','0','0','50','0','1','18446744073709551615','63','2','16','0','99',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHPrate,5; bonus bMdef,10; if (getrefine()>6) { bonus bMdef,5; } if (getrefine()>8) { bonus bMaxHPrate,2; }','','');
REPLACE INTO `item_db` VALUES ('15074','Geffen_Mage_Robe','Geffen Magic Robe','5','0','20','10','1000','0','0','40','0','1','18446744073709551615','63','2','16','0','99',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUseSPrate,-10; bonus bVariableCastrate,15; bonus bNoCastCancel,0; if (getrefine()>6) { bonus bUseSPrate,-5; } if (getrefine()>8) { bonus bVariableCastrate,-5; }','','');
-REPLACE INTO `item_db` VALUES ('15089','Lounge_Suit','Menswear','4','1','20','10','300','0','0','40','0','0','18446744073709551614','63','2','16','0','80',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAspdRate,3+((getrefine()>=7)?2:0); bonus bDelayrate,-3-((getrefine()>=7)?2:0); bonus bVariableCastrate,-3-((getrefine()>=7)?2:0);','','');
+REPLACE INTO `item_db` VALUES ('15089','Lounge_Suit','Menswear','5','0','20','10','300','0','0','40','0','0','18446744073709551614','63','2','16','0','80',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAspdRate,3+((getrefine()>=7)?2:0); bonus bDelayrate,-3-((getrefine()>=7)?2:0); bonus bVariableCastrate,-3-((getrefine()>=7)?2:0);','','');
REPLACE INTO `item_db` VALUES ('15090','Armor_Of_Gray','Gray Armor','5','0','0','0','2400','0','0','90','0','1','414954','56','2','16','0','120',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,10; bonus2 bSubEle,Ele_Holy,10+(getrefine()/2);','','');
REPLACE INTO `item_db` VALUES ('15091','Gray_Robe','Gray Robe','5','0','0','0','1300','0','0','55','0','1','99092','56','2','16','0','120',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSubEle,Ele_Holy,10+(getrefine()/2);','','');
REPLACE INTO `item_db` VALUES ('15116','Airship_Armor','Armor Of Airship','5','0','20','10','700','0','0','100','0','0','18446744073709551615','63','2','16','0','125',NULL,'1','0','0','0','0','0','0','467',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP,1000; bonus bMaxSP,100; bonus bMdef,10; bonus bAllStats,1;','','');
REPLACE INTO `item_db` VALUES ('15117','Felock_Armor','Tarlock\'s Armor','5','0','20','10','750','0','0','70','0','0','18446744073709551615','63','2','16','0','125',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP,500; bonus bMaxSP,50; bonus bMdef,10; bonus bAllStats,1; if (getrefine()>=7) { bonus bMaxHP,500; bonus bMaxSP,50; } if (getrefine()>=9) { bonus bMaxHP,200; bonus bMaxSP,20; } if (getrefine()>=12) { bonus bMaxHP,300; bonus bMaxSP,30; }','','');
REPLACE INTO `item_db` VALUES ('15123','Whikebain_Suit','Whikebain Suit','5','0','10','5','9000','0','0','56','0','1','4096','56','2','16','0','105',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus3 bAutoSpell,DC_WINKCHARM,1,20; /* Custom - IDRO */ if(getrefine()>4) { bonus bCritAtkRate,4; } if(getrefine()>6) { bonus bCritAtkRate,6; }','','');
-REPLACE INTO `item_db` VALUES ('15126','Female_Poring_Balloon','Private Doram Suits','4','1','20','10','700','0','0','80','0','1','0','63','2','16','0','100',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP, 500; bonus bMaxSP, 100; bonus bDex, getrefine() / 3; bonus bInt, getrefine() / 3;','','');
+REPLACE INTO `item_db` VALUES ('15126','Female_Poring_Balloon','Private Doram Suits','5','0','20','10','700','0','0','80','0','1','0','63','2','16','0','100',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP, 500; bonus bMaxSP, 100; bonus bDex, getrefine() / 3; bonus bInt, getrefine() / 3;','','');
REPLACE INTO `item_db` VALUES ('15128','Female_Poring_Egg','Excellion Suit','5','0','20','10','1000','0','0','100','0','0','18446744073709551615','63','2','16','0','99',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bVit,6; bonus bMaxHPrate,(getrefine()/3)*4; if(BaseLevel>130) { bonus bVit,4; }','','');
-REPLACE INTO `item_db` VALUES ('15129','Blue_Bellflower_Hat','Luxury Doram Suit','4','1','20','10','800','0','0','100','0','1','0','63','2','16','0','140',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHPrate, 10; bonus bMaxSPrate, 10; bonus bDex, getrefine() / 2; bonus bInt, getrefine() / 2;','','');
+REPLACE INTO `item_db` VALUES ('15129','Blue_Bellflower_Hat','Luxury Doram Suit','5','0','20','10','800','0','0','100','0','1','0','63','2','16','0','140',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHPrate, 10; bonus bMaxSPrate, 10; bonus bDex, getrefine() / 2; bonus bInt, getrefine() / 2;','','');
REPLACE INTO `item_db` VALUES ('15138','Aegir_Armor','Aegir Armor','5','0','200000','100000','1600','0','0','25','0','1','18446744073709551615','63','2','16','0','40',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP, 500; bonus bMaxSP, 50; bonus bUnbreakableArmor, 0;','','');
REPLACE INTO `item_db` VALUES ('15150','White_Shirt','White Shirt','5','0','20','10','50','0','0','25','0','1','0','63','2','16','0','6',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP,70; bonus bFlee,5;','','');
-REPLACE INTO `item_db` VALUES ('15151','White_Eco_Shirt','White Eco-Shirt','4','1','20','10','100','0','0','40','0','1','0','63','2','16','0','15',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP,150; bonus bFlee,10;','','');
-REPLACE INTO `item_db` VALUES ('15156','Elegant_Doram_Suit','Elegant Doram Suit','4','1','20','10','900','0','0','120','0','1','0','63','2','16','0','175',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHPrate, 15; bonus bMaxSPrate, 15; bonus bDex, getrefine(); bonus bInt, getrefine(); if (getrefine() > 9) bonus bUseSPrate, -5;','','');
+REPLACE INTO `item_db` VALUES ('15151','White_Eco_Shirt','White Eco-Shirt','5','0','20','10','100','0','0','40','0','1','0','63','2','16','0','15',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP,150; bonus bFlee,10;','','');
+REPLACE INTO `item_db` VALUES ('15156','Elegant_Doram_Suit','Elegant Doram Suit','5','0','20','10','900','0','0','120','0','1','0','63','2','16','0','175',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHPrate, 15; bonus bMaxSPrate, 15; bonus bDex, getrefine(); bonus bInt, getrefine(); if (getrefine() > 9) bonus bUseSPrate, -5;','','');
REPLACE INTO `item_db` VALUES ('16000','Erde','Erde','4','8','20','10','500','130','0','0','1','2','312754','58','2','2','3','50',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillAtk,AM_ACIDTERROR,20; bonus2 bSkillAtk,AM_DEMONSTRATION,20; bonus bMaxSP,50; bonus bHealPower,10;','','');
REPLACE INTO `item_db` VALUES ('16001','Red_Square_Bag','Red Square Bag','4','8','20','10','500','130','0','0','1','2','312754','58','2','2','3','50',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','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; }','','');
REPLACE INTO `item_db` VALUES ('16002','Stunner_C','Stunner','4','8','0','0','0','175','0','0','1','0','33040','63','2','2','3','0',NULL,'0','0','0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddEff,Eff_Stun,1000; bonus2 bAddSize,Size_Small,40; bonus2 bAddSize,Size_Medium,40; bonus2 bAddSize,Size_Large,40;','','');
@@ -9765,11 +9765,11 @@ REPLACE INTO `item_db` VALUES ('22046','Airship_Boots','Boots of Airship','5','0
REPLACE INTO `item_db` VALUES ('22047','Felock_Boots','Tarlock\'s Boots','5','0','20','10','250','0','0','13','0','0','18446744073709551615','63','2','64','0','125',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAgi,1; bonus bAspdRate,5; if(getrefine()>6) { bonus bAgi,1; bonus bAspdRate,5; } if(getrefine()>8) { bonus bAgi,1; bonus bAspdRate,5; } if(getrefine()>11) { bonus bAspd,1; }','','');
REPLACE INTO `item_db` VALUES ('22059','Aegir_Shoes','Egir Shoes','5','0','200000','100000','300','0','0','13','0','1','18446744073709551615','63','2','64','0','40',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP, 500; bonus bMaxSP, 50; bonus bUnbreakableShoes, 0;','','');
REPLACE INTO `item_db` VALUES ('22067','Witch_Shoes','Witch Shoes','5','0','3500','1750','400','0','0','10','0','0','18446744073709551614','63','2','64','0','0',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','skill ALL_CATCRY, 1; bonus bUnbreakableShoes, 1; autobonus3 \"{ }\", 1000, 7000, ALL_CATCRY, \"{ montransform LOLI_RURI, 420000; }\";','','');
-REPLACE INTO `item_db` VALUES ('22076','Wooden_Slipper','Wooden Slipper','4','1','20','10','50','0','0','10','0','1','0','63','2','64','0','9',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bHPRegenRate,2,10000;','','');
-REPLACE INTO `item_db` VALUES ('22077','Red_Eco_Friendly_Shoes','Red Eco-Friendly Shoes','4','1','20','10','100','0','0','20','0','1','0','63','2','64','0','18',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bCritical,5; bonus2 bHPRegenRate,4,10000; bonus2 bSPRegenRate,1,10000;','','');
-REPLACE INTO `item_db` VALUES ('22083','Private_Doram_Shoes','Private Doram Shoes','4','1','20','10','500','0','0','25','0','1','0','63','2','64','0','100',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP, 100; bonus bMaxSP, 50; bonus bHPrecovRate, getrefine() * 10 / 3; bonus bSPrecovRate, getrefine() * 10 / 3;','','');
-REPLACE INTO `item_db` VALUES ('22084','Luxury_Doram_Shoes','Luxury Doram Shoes','4','1','20','10','600','0','0','30','0','1','0','63','2','64','0','140',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP, 300; bonus bMaxSP, 100; bonus bHPrecovRate, 20 * getrefine() / 3; bonus bSPrecovRate, 20 * getrefine() / 3;','','');
-REPLACE INTO `item_db` VALUES ('22085','Elegant_Doram_Shoes','Elegant Doram Shoes','4','1','20','10','700','0','0','35','0','1','0','63','2','64','0','175',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHPrate, 10; bonus bMaxSPrate, 5; bonus bMaxHP, 100 * getrefine() / 2; bonus bMaxSP, 20 * getrefine() / 2; if ((getrefine() / 2) >= 4) bonus2 bSkillUseSP, SU_LOPE, 5;','','');
+REPLACE INTO `item_db` VALUES ('22076','Wooden_Slipper','Wooden Slipper','5','0','20','10','50','0','0','10','0','1','0','63','2','64','0','9',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bHPRegenRate,2,10000;','','');
+REPLACE INTO `item_db` VALUES ('22077','Red_Eco_Friendly_Shoes','Red Eco-Friendly Shoes','5','0','20','10','100','0','0','20','0','1','0','63','2','64','0','18',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bCritical,5; bonus2 bHPRegenRate,4,10000; bonus2 bSPRegenRate,1,10000;','','');
+REPLACE INTO `item_db` VALUES ('22083','Private_Doram_Shoes','Private Doram Shoes','5','0','20','10','500','0','0','25','0','1','0','63','2','64','0','100',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP, 100; bonus bMaxSP, 50; bonus bHPrecovRate, getrefine() * 10 / 3; bonus bSPrecovRate, getrefine() * 10 / 3;','','');
+REPLACE INTO `item_db` VALUES ('22084','Luxury_Doram_Shoes','Luxury Doram Shoes','5','0','20','10','600','0','0','30','0','1','0','63','2','64','0','140',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP, 300; bonus bMaxSP, 100; bonus bHPrecovRate, 20 * getrefine() / 3; bonus bSPrecovRate, 20 * getrefine() / 3;','','');
+REPLACE INTO `item_db` VALUES ('22085','Elegant_Doram_Shoes','Elegant Doram Shoes','5','0','20','10','700','0','0','35','0','1','0','63','2','64','0','175',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHPrate, 10; bonus bMaxSPrate, 5; bonus bMaxHP, 100 * getrefine() / 2; bonus bMaxSP, 20 * getrefine() / 2; if ((getrefine() / 2) >= 4) bonus2 bSkillUseSP, SU_LOPE, 5;','','');
REPLACE INTO `item_db` VALUES ('22508','Para_Team_Mark_','Eden Group Mark','11','0','0','0','0','0','0','0','0','0','18446744073709551615','63','2','0','0','0',NULL,'0','1','0','0','0','0','1200000','507',NULL,'0',NULL,'0',NULL,'0','warp \"moc_para01\", 171, 115;','','');
REPLACE INTO `item_db` VALUES ('22514','Candy_Holder','Candy Holder','11','0','20','10','10','0','0','0','0','0','18446744073709551615','63','2','0','0','0',NULL,'0','1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('22515','Key_Of_Twisted_Time','Twisted Key of Time','3','0','10','5','300','0','0','0','0','0','18446744073709551615','63','2','0','0','0',NULL,'0','1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
@@ -10075,22 +10075,22 @@ REPLACE INTO `item_db` VALUES ('28365','Vit_Gloves','Vit Gloves','5','0','0','0'
REPLACE INTO `item_db` VALUES ('28366','Dex_Gloves','Dex Gloves','5','0','0','0','100','0','0','0','0','1','18446744073709551615','63','2','136','0','120',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,2; bonus bVariableCastrate,-5;','','');
REPLACE INTO `item_db` VALUES ('28367','Luk_Gloves','Luk Gloves','5','0','0','0','100','0','0','0','0','1','18446744073709551615','63','2','136','0','120',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bLuk,2; bonus bFlee2,5;','','');
REPLACE INTO `item_db` VALUES ('28372','Imperial_Ring','Imperial Ring','5','0','0','0','500','0','0','3','0','1','18446744073709551615','63','2','136','0','50',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,1; bonus bInt,1; bonus bMaxHPrate,3; bonus bMaxSPrate,3;','','');
-REPLACE INTO `item_db` VALUES ('28374','Foxtail_Ring','Foxtail Ring','4','1','20','10','100','0','0','0','0','0','0','63','2','136','0','1',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bExpAddRace,RC_All,5; .@lvl = min(BaseLevel/5,10); bonus bAtk,2*.@lvl; bonus bMatk,2*.@lvl; bonus bMaxHP,10*.@lvl; bonus bMaxSP,5*.@lvl;','','');
-REPLACE INTO `item_db` VALUES ('28380','Fresh_Grass_Necklace','Fresh Grass Necklace','4','1','20','10','100','0','0','0','0','1','0','63','2','136','0','100',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bFlee2,5; bonus2 bSkillCooldown,SU_SCAROFTAROU,-5000;','','');
-REPLACE INTO `item_db` VALUES ('28381','Cute_Grass_Necklace','Cute Grass Necklace','4','1','20','10','10','0','0','0','0','1','0','63','2','136','0','100',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHealPower,5; bonus2 bSkillCooldown,SU_TUNAPARTY,-7000;','','');
-REPLACE INTO `item_db` VALUES ('28382','Charm_Grass_Necklace','Charm Grass Necklace','4','1','20','10','10','0','0','0','0','1','0','63','2','136','0','100',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,5; bonus2 bVariableCastrate,SU_CN_METEOR,-1000;','','');
-REPLACE INTO `item_db` VALUES ('28413','Lesser_Mackerel_Talisman','Lesser Mackerel Talisman','4','1','0','0','100','0','0','1','0','1','0','63','2','136','0','100',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bVit,1;','','');
-REPLACE INTO `item_db` VALUES ('28414','Intermediate_Mackerel_Talisman','Intermediate Mackerel Talisman','4','1','0','0','100','0','0','1','0','1','0','63','2','136','0','140',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bVit,2;','','');
-REPLACE INTO `item_db` VALUES ('28415','Greater_Mackerel_Talisman','Greater Mackerel Talisman','4','1','0','0','100','0','0','1','0','1','0','63','2','136','0','175',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bVit,3;','','');
-REPLACE INTO `item_db` VALUES ('28416','Lesser_Leaf_Talisman','Lesser Leaf Talisman','4','1','0','0','100','0','0','1','0','1','0','63','2','136','0','100',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,1;','','');
-REPLACE INTO `item_db` VALUES ('28417','Intermediate_Leaf_Talisman','Intermediate Leaf Talisman','4','1','0','0','100','0','0','1','0','1','0','63','2','136','0','140',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,2;','','');
-REPLACE INTO `item_db` VALUES ('28418','Greater_Leaf_Talisman','Greater Leaf Talisman','4','1','0','0','100','0','0','1','0','1','0','63','2','136','0','175',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,3;','','');
-REPLACE INTO `item_db` VALUES ('28419','Lesser_Rabbit_Talisman','Lesser Rabbit Talisman','4','1','0','0','100','0','0','1','0','1','0','63','2','136','0','100',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,1;','','');
-REPLACE INTO `item_db` VALUES ('28420','Intermediate_Rabbit_Talisman','Intermediate Rabbit Talisman','4','1','0','0','100','0','0','1','0','1','0','63','2','136','0','140',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,2;','','');
-REPLACE INTO `item_db` VALUES ('28421','Greater_Rabbit_Talisman','Greater Rabbit Talisman','4','1','0','0','100','0','0','1','0','1','0','63','2','136','0','175',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,3;','','');
-REPLACE INTO `item_db` VALUES ('28422','Shiny_Branch_Talisman','Shiny Branch Talisman','4','1','0','0','100','0','0','1','0','1','0','63','2','136','0','100',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bVariableCastrate,SU_SV_STEMSPEAR,-50; bonus2 bSkillAtk,SU_SV_STEMSPEAR,(readparam(bInt)/2)+(20 * getskilllv(SU_SV_STEMSPEAR)); //Need to confirm damage formula','','');
-REPLACE INTO `item_db` VALUES ('28423','Fresh_Tuna_Talisman','Fresh Tuna Talisman','4','1','0','0','100','0','0','1','0','1','0','63','2','136','0','100',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillCooldown,SU_TUNAPARTY,-5000; bonus3 bAutoSpellWhenHit,SU_TUNAPARTY,max(1,getskilllv(SU_TUNAPARTY)),10;','','');
-REPLACE INTO `item_db` VALUES ('28424','Chubby_Worm_Talisman','Chubby Worm Talisman','4','1','0','0','100','0','0','1','0','1','0','63','2','136','0','100',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bVariableCastrate,SU_PICKYPECK,-50; bonus2 bSkillAtk,SU_PICKYPECK,(readparam(bDex)/2)+(20 * getskilllv(SU_PICKYPECK)); //Need to confirm damage formula','','');
+REPLACE INTO `item_db` VALUES ('28374','Foxtail_Ring','Foxtail Ring','5','0','20','10','100','0','0','0','0','0','0','63','2','136','0','1',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bExpAddRace,RC_All,5; .@lvl = min(BaseLevel/5,10); bonus bAtk,2*.@lvl; bonus bMatk,2*.@lvl; bonus bMaxHP,10*.@lvl; bonus bMaxSP,5*.@lvl;','','');
+REPLACE INTO `item_db` VALUES ('28380','Fresh_Grass_Necklace','Fresh Grass Necklace','5','0','20','10','100','0','0','0','0','1','0','63','2','136','0','100',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bFlee2,5; bonus2 bSkillCooldown,SU_SCAROFTAROU,-5000;','','');
+REPLACE INTO `item_db` VALUES ('28381','Cute_Grass_Necklace','Cute Grass Necklace','5','0','20','10','10','0','0','0','0','1','0','63','2','136','0','100',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHealPower,5; bonus2 bSkillCooldown,SU_TUNAPARTY,-7000;','','');
+REPLACE INTO `item_db` VALUES ('28382','Charm_Grass_Necklace','Charm Grass Necklace','5','0','20','10','10','0','0','0','0','1','0','63','2','136','0','100',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,5; bonus2 bVariableCastrate,SU_CN_METEOR,-1000;','','');
+REPLACE INTO `item_db` VALUES ('28413','Lesser_Mackerel_Talisman','Lesser Mackerel Talisman','5','0','0','0','100','0','0','1','0','1','0','63','2','136','0','100',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bVit,1;','','');
+REPLACE INTO `item_db` VALUES ('28414','Intermediate_Mackerel_Talisman','Intermediate Mackerel Talisman','5','0','0','0','100','0','0','1','0','1','0','63','2','136','0','140',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bVit,2;','','');
+REPLACE INTO `item_db` VALUES ('28415','Greater_Mackerel_Talisman','Greater Mackerel Talisman','5','0','0','0','100','0','0','1','0','1','0','63','2','136','0','175',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bVit,3;','','');
+REPLACE INTO `item_db` VALUES ('28416','Lesser_Leaf_Talisman','Lesser Leaf Talisman','5','0','0','0','100','0','0','1','0','1','0','63','2','136','0','100',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,1;','','');
+REPLACE INTO `item_db` VALUES ('28417','Intermediate_Leaf_Talisman','Intermediate Leaf Talisman','5','0','0','0','100','0','0','1','0','1','0','63','2','136','0','140',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,2;','','');
+REPLACE INTO `item_db` VALUES ('28418','Greater_Leaf_Talisman','Greater Leaf Talisman','5','0','0','0','100','0','0','1','0','1','0','63','2','136','0','175',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,3;','','');
+REPLACE INTO `item_db` VALUES ('28419','Lesser_Rabbit_Talisman','Lesser Rabbit Talisman','5','0','0','0','100','0','0','1','0','1','0','63','2','136','0','100',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,1;','','');
+REPLACE INTO `item_db` VALUES ('28420','Intermediate_Rabbit_Talisman','Intermediate Rabbit Talisman','5','0','0','0','100','0','0','1','0','1','0','63','2','136','0','140',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,2;','','');
+REPLACE INTO `item_db` VALUES ('28421','Greater_Rabbit_Talisman','Greater Rabbit Talisman','5','0','0','0','100','0','0','1','0','1','0','63','2','136','0','175',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,3;','','');
+REPLACE INTO `item_db` VALUES ('28422','Shiny_Branch_Talisman','Shiny Branch Talisman','5','0','0','0','100','0','0','1','0','1','0','63','2','136','0','100',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bVariableCastrate,SU_SV_STEMSPEAR,-50; bonus2 bSkillAtk,SU_SV_STEMSPEAR,(readparam(bInt)/2)+(20 * getskilllv(SU_SV_STEMSPEAR)); //Need to confirm damage formula','','');
+REPLACE INTO `item_db` VALUES ('28423','Fresh_Tuna_Talisman','Fresh Tuna Talisman','5','0','0','0','100','0','0','1','0','1','0','63','2','136','0','100',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillCooldown,SU_TUNAPARTY,-5000; bonus3 bAutoSpellWhenHit,SU_TUNAPARTY,max(1,getskilllv(SU_TUNAPARTY)),10;','','');
+REPLACE INTO `item_db` VALUES ('28424','Chubby_Worm_Talisman','Chubby Worm Talisman','5','0','0','0','100','0','0','1','0','1','0','63','2','136','0','100',NULL,'0','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bVariableCastrate,SU_PICKYPECK,-50; bonus2 bSkillAtk,SU_PICKYPECK,(readparam(bDex)/2)+(20 * getskilllv(SU_PICKYPECK)); //Need to confirm damage formula','','');
REPLACE INTO `item_db` VALUES ('28604','Scarlet_Bible','Crimson Bible','4','15','20','10','450','45','0','0','1','2','4260096','63','2','2','3','70',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0; bonus bAtk,((min(getrefine(),15)) ** (2)); bonus bMatk,((min(getrefine(),15)) ** (2))/2; if(BaseLevel>70) { bonus bAtk,(((BaseLevel-70)/10)*5); }','','');
REPLACE INTO `item_db` VALUES ('28605','Book_of_Vicious_Mind','Book of Vicious Mind','4','15','20','10','950','95','0','0','1','1','4260096','63','2','2','4','160',NULL,'1','0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtk,((min(getrefine(),15)) ** (2)); bonus bMatk,((min(getrefine(),15)) ** (2)); bonus bUnbreakableWeapon,0;','','');
REPLACE INTO `item_db` VALUES ('28703','Infinity_Dagger','Infinity Dagger','4','1','20','10','500','125','100','0','1','1','579821295','63','2','2','4','100',NULL,'1','0','0','0','0','0','0','467',NULL,'0',NULL,'0',NULL,'0','','','');