summaryrefslogtreecommitdiff
path: root/sql-files/item_db_re.sql
diff options
context:
space:
mode:
authorHercules.ws <Hercules@efficiently.awesome>2015-05-17 02:37:33 +0200
committerHerculesWSAPI <Hercules@efficiently.awesome>2015-05-17 02:37:33 +0200
commit53c8d6755372b34f0f6b53433b57fa061e1cc7a8 (patch)
tree1d561aa1b4a898e75fc1a09e1ed55fc25a2c18c2 /sql-files/item_db_re.sql
parent22c461b21d8f54e86e2317e83b18bebcadaf8339 (diff)
downloadhercules-53c8d6755372b34f0f6b53433b57fa061e1cc7a8.tar.gz
hercules-53c8d6755372b34f0f6b53433b57fa061e1cc7a8.tar.bz2
hercules-53c8d6755372b34f0f6b53433b57fa061e1cc7a8.tar.xz
hercules-53c8d6755372b34f0f6b53433b57fa061e1cc7a8.zip
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
Diffstat (limited to 'sql-files/item_db_re.sql')
-rw-r--r--sql-files/item_db_re.sql12
1 files changed, 6 insertions, 6 deletions
diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql
index 8a135e979..5a5dd1a7a 100644
--- a/sql-files/item_db_re.sql
+++ b/sql-files/item_db_re.sql
@@ -581,7 +581,7 @@ REPLACE INTO `item_db` VALUES ('1194','F_Executioner_C','Rental Executioner','4'
REPLACE INTO `item_db` VALUES ('1195','E_Executioner_C','E Executioner C','4','2','1','0','190','0','0','1','0','16514','63','2','34','4','0',NULL,'0','3','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtkEle,Ele_Dark;','','');
REPLACE INTO `item_db` VALUES ('1196','Chrome_Twohand_Sword','Two-Handed Chrome Metal Sword','4','20','10','400','280','0','0','1','0','16514','58','2','34','3','110',NULL,'1','3','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0; bonus bAgi,3; bonus bMaxHPrate,-10;','','');
REPLACE INTO `item_db` VALUES ('1197','P_Slayer3','Eden Group Slayer III','4','0','0','0','200','0','0','1','0','16514','63','2','34','3','60',NULL,'0','3','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','','','');
-REPLACE INTO `item_db` VALUES ('1198','Hairtail','Hairtail','4','0','0','0','220','0','0','3','0','16514','63','2','34','1','50',NULL,'0','3','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0; bonus bCritical,20; bonus bCritAtkRate,50; if(BaseLevel>99) { bonus bBaseAtk,50; }','','');
+REPLACE INTO `item_db` VALUES ('1198','Hairtail','Hairtail','4','0','0','0','220','0','0','3','0','16514','63','2','34','1','50',NULL,'0','3','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0; bonus bCritical,20; bonus bCritAtkRate,50; bonus4 bAddEff,Eff_Cold,300,ATF_SHORT,3000; if(BaseLevel>99) { bonus bBaseAtk,50; }','','');
REPLACE INTO `item_db` VALUES ('1199','Ebony_Toe_Nail','Ebony Toe Nail','4','56000','28000','1000','250','150','0','1','0','16512','56','2','34','4','120',NULL,'1','3','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('1201','Knife','Knife','4','50','25','400','17','0','0','1','3','579821295','63','2','2','1','0',NULL,'1','1','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('1202','Knife_','Knife','4','50','25','400','17','0','0','1','4','579821295','63','2','2','1','0',NULL,'1','1','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
@@ -740,7 +740,7 @@ REPLACE INTO `item_db` VALUES ('1389','E_Tomahawk_C','E Tomahawk C','4','2','1',
REPLACE INTO `item_db` VALUES ('1390','E_Right_Epsilon_C','E Right Epsilon C','4','1','0','0','229','0','0','1','0','279714','63','2','34','4','0',NULL,'0','7','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtkEle,Ele_Holy; bonus bStr,10;','','');
REPLACE INTO `item_db` VALUES ('1391','P_Two_Handed_Axe1','Eden Group Two Handed Axe I','4','0','0','0','195','0','0','1','0','279714','63','2','34','3','60',NULL,'0','7','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('1392','Ygnus_Stale','Ygnus Stale','4','56000','28000','1900','250','0','0','1','1','279714','58','2','34','4','95',NULL,'1','7','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtkEle,Ele_Fire; bonus bUnbreakableWeapon,0;','','');
-REPLACE INTO `item_db` VALUES ('1393','End_Sektura','End Sektura','4','56000','28000','1900','250','0','0','1','1','279714','58','2','34','4','95',NULL,'1','7','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtkEle,Ele_Water; bonus bUnbreakableWeapon,0;','','');
+REPLACE INTO `item_db` VALUES ('1393','End_Sektura','End Sektura','4','56000','28000','1900','250','0','0','1','1','279714','58','2','34','4','95',NULL,'1','7','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtkEle,Ele_Water; bonus4 bAddEff,Eff_Cold,300,ATF_SHORT,3000; bonus4 bAddEff,Eff_Cold,100,ATF_SELF,3000; bonus bUnbreakableWeapon,0;','','');
REPLACE INTO `item_db` VALUES ('1394','Upg_Two_Handed_Axe','Upgrade Two-Handed Axe','4','20','10','2000','110','0','0','1','1','279714','63','2','34','3','0',NULL,'1','7','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bBaseAtk,(getrefine()*14); if(BaseLevel>70) bonus bBaseAtk,(((BaseLevel-70)/10)*10);','','');
REPLACE INTO `item_db` VALUES ('1395','Velum_Buster','Vellum Buster','4','20','10','2500','50','0','0','1','0','279714','63','2','34','4','95',NULL,'1','7','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0; bonus3 bSPVanishRate,10000,10,BF_NORMAL;','','');
REPLACE INTO `item_db` VALUES ('1396','Velum_Guillotine','Vellum Guillotine','4','20','10','5500','300','0','0','1','0','279714','63','2','34','4','95',NULL,'1','7','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0; bonus2 bAddRace,RC_DemiHuman,40; bonus2 bIgnoreDefRate,RC_DemiHuman,30; if(getrefine()>=6) { bonus2 bSkillAtk,NC_AXEBOOMERANG,80; bonus2 bSkillAtk,NC_POWERSWING,80; } if(getrefine()>=9) { bonus2 bAddRace,RC_DemiHuman,60; }','','');
@@ -824,7 +824,7 @@ REPLACE INTO `item_db` VALUES ('1485','Battle_Fork','Battle Fork','4','20','10',
REPLACE INTO `item_db` VALUES ('1486','Krieger_Twohand_Spear1','Glorious Lance','4','20','10','0','220','0','0','3','0','16514','63','2','34','4','80',NULL,'1','5','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace,RC_DemiHuman,70; bonus2 bIgnoreDefRate,RC_DemiHuman,25; bonus bUnbreakableWeapon,0; if(getrefine()>5) { bonus2 bAddRace,RC_DemiHuman,pow(min(getrefine(),14)-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; }','','');
REPLACE INTO `item_db` VALUES ('1487','Lance_C','Lance','4','0','0','0','220','0','0','3','0','16514','63','2','34','3','0',NULL,'0','5','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0; bonus2 bAddSize,Size_Small,50; bonus2 bAddSize,Size_Medium,50; bonus2 bAddSize,Size_Large,50;','','');
REPLACE INTO `item_db` VALUES ('1488','Ahlspiess_C','Ahlspiess','4','20','10','0','135','0','0','3','0','16512','63','2','34','4','0',NULL,'1','5','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','bonus bIgnoreDefRace,RC_NonBoss; bonus bIgnoreDefRace,RC_Boss; bonus2 bAddRace,RC_DemiHuman,10; bonus3 bAutoSpell,KN_PIERCE,5,30;','','');
-REPLACE INTO `item_db` VALUES ('1489','Spearfish_','Marlin','4','0','0','0','220','0','0','3','0','16514','63','2','34','1','50',NULL,'0','5','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','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; }','','');
+REPLACE INTO `item_db` VALUES ('1489','Spearfish_','Marlin','4','0','0','0','220','0','0','3','0','16514','63','2','34','1','50',NULL,'0','5','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','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; //bonus4 bAddEff,Eff_FrosMisty,100,ATF_SHORT,3000; //Need to be Frost Misty if(BaseLevel>99) { bonus bBaseAtk,30; }','','');
REPLACE INTO `item_db` VALUES ('1490','Giant_Lance','Giant Lance','4','20','10','20000','20','0','0','3','0','128','56','2','34','4','140',NULL,'1','5','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAspd,-10; bonus2 bSkillCooldown,LK_SPIRALPIERCE,20000; if(readparam(bStr)>=120) { bonus bBaseAtk,300; }','','heal 0,-600;');
REPLACE INTO `item_db` VALUES ('1491','Upg_Lance','Upgrade Spear','4','20','10','1500','105','0','0','3','1','16514','63','2','34','3','0',NULL,'1','5','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bBaseAtk,(getrefine()*12); if(BaseLevel>70) bonus bBaseAtk,(((BaseLevel-70)/10)*10);','','');
REPLACE INTO `item_db` VALUES ('1492','Velum_Glaive','Vellum Glaive','4','20','10','4500','250','0','0','3','0','16514','63','2','34','4','95',NULL,'1','5','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace,RC_DemiHuman,80; if(getrefine()>=6) { bonus2 bSkillAtk,LK_SPIRALPIERCE,100; bonus2 bSkillAtk,KN_SPEARBOOMERANG,50; } if(getrefine()>=9) { autobonus2 \"{ bonus bShortWeaponDamageReturn,20; bonus bMagicDamageReturn,20; }\",100,2000,BF_WEAPON|BF_MAGIC,\"{ specialeffect2 EF_REFLECTSHIELD; }\"; }','','');
@@ -2532,7 +2532,7 @@ REPLACE INTO `item_db` VALUES ('4518','Banaspaty_Card','Banaspaty Card','6','20'
REPLACE INTO `item_db` VALUES ('4519','Butoijo_Card','Butoijo Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace,RC_Angel,20;','','');
REPLACE INTO `item_db` VALUES ('4520','Leak_Card','Leak Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','4','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,3; bonus2 bAddEff,Eff_Confusion,5000; bonus3 bAddEff,Eff_Confusion,5000,ATF_SKILL;','','');
REPLACE INTO `item_db` VALUES ('4521','Sedora_Card','Sedora Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bCritAtkRate,15;','','');
-REPLACE INTO `item_db` VALUES ('4522','Sropho_Card','Sropho Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddEff,Eff_Cold,500;','','');
+REPLACE INTO `item_db` VALUES ('4522','Sropho_Card','Sropho Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus4 bAddEff,Eff_Cold,500,ATF_SHORT,3000;','','');
REPLACE INTO `item_db` VALUES ('4523','Pot_Dofle_Card','Pot Dofle Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','16','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDefEle,Ele_Water; bonus2 bAddRaceTolerance,RC_Fish,10;','','');
REPLACE INTO `item_db` VALUES ('4524','King_Dramoh_Card','King Dramoh Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','769','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,2; if(BaseClass==Job_Swordman) { bonus bStr,getrefine()/3; }','','');
REPLACE INTO `item_db` VALUES ('4525','Kraken_Card','Kraken Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','4','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bFlee,10; skill TF_HIDING,1; skill RG_RAID,1; bonus3 bAddEffOnSkill,RG_RAID,Eff_Bleeding,1000;','','sc_end SC_HIDING;');
@@ -7651,8 +7651,8 @@ REPLACE INTO `item_db` VALUES ('16011','Adventure_Mace','Adventure Mace','4','0'
REPLACE INTO `item_db` VALUES ('16012','Academy_Mace','Academy Mace','4','0','0','1000','110','0','0','1','1','33040','63','2','2','1','0',NULL,'1','8','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('16013','Mace_Of_Judgement','Mace Of Judgement','4','20','10','1200','140','180','0','1','2','256','56','2','2','3','100',NULL,'1','8','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,1; bonus bInt,1; autobonus \"{ bonus2 bMagicAddRace,RC_Demon,20; }\",30,7000,BF_MAGIC,\"{ specialeffect2 EF_SPELLBREAKER; }\"; autobonus \"{ bonus2 bAddRace,RC_Demon,20; }\",5,7000,BF_WEAPON,\"{ specialeffect2 EF_ENHANCE; }\";','','');
REPLACE INTO `item_db` VALUES ('16014','P_Mace3','Eden Group Mace3','4','0','0','0','172','0','0','1','0','312754','63','2','2','3','60',NULL,'0','8','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','','','');
-REPLACE INTO `item_db` VALUES ('16015','Cat_Club','Cat Club','4','20','10','700','88','0','0','1','3','312755','63','2','2','1','0',NULL,'1','8','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace,RC_Brute,15;','','');
-REPLACE INTO `item_db` VALUES ('16016','Tuna','Tuna','4','0','0','0','180','0','0','1','0','312754','63','2','2','1','50',NULL,'0','8','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0; bonus2 bAddEff,Eff_Stun,150; bonus3 bAutoSpell,SM_BASH,5,20; if(BaseLevel>99) bonus bBaseAtk,20;','','');
+REPLACE INTO `item_db` VALUES ('16015','Cat_Club','Cat Club','4','20','10','700','88','0','0','1','3','312755','63','2','2','1','0',NULL,'1','8','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace,RC_Brute,15; bonus4 bAddEff,Eff_Deepsleep,300,ATF_SHORT,5000;','','');
+REPLACE INTO `item_db` VALUES ('16016','Tuna','Tuna','4','0','0','0','180','0','0','1','0','312754','63','2','2','1','50',NULL,'0','8','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0; bonus2 bAddEff,Eff_Stun,150; bonus3 bAutoSpell,SM_BASH,5,20; bonus4 bAddEff,Eff_Cold,100,ATF_SHORT,3000; if(BaseLevel>99) bonus bBaseAtk,20;','','');
REPLACE INTO `item_db` VALUES ('16017','Bloody_Cross','Bloody Cross','4','20','10','1500','170','0','0','1','0','33040','58','2','2','4','100',NULL,'1','8','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtkEle,Ele_Dark; bonus3 bAutoSpell,WL_HELLINFERNO,1,max(getrefine(),1)*20;','','');
REPLACE INTO `item_db` VALUES ('16018','Mace_Of_Judgement2','Empowered Mace Of Judgement','4','20','10','1200','170','180','0','1','1','256','56','2','2','4','130',NULL,'1','8','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,2; bonus bInt,2; autobonus \"{ bonus2 bMagicAddRace,RC_Demon,40; }\",60,7000,BF_MAGIC,\"{ specialeffect2 EF_SPELLBREAKER; }\"; autobonus \"{ bonus2 bAddRace,RC_Demon,40; }\",10,7000,BF_WEAPON,\"{ specialeffect2 EF_ENHANCE; }\";','','');
REPLACE INTO `item_db` VALUES ('16019','Upg_Mace','Upgrade Mace','4','20','10','800','80','0','0','1','1','312755','63','2','2','3','0',NULL,'1','8','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bBaseAtk,(getrefine()*10); bonus bHealPower,getrefine(); if(BaseLevel>70) bonus bBaseAtk,(((BaseLevel-70)/10)*5);','','');