summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql-files/item_db_re.sql18
1 files changed, 9 insertions, 9 deletions
diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql
index e86f498f8..29e580b47 100644
--- a/sql-files/item_db_re.sql
+++ b/sql-files/item_db_re.sql
@@ -675,8 +675,8 @@ REPLACE INTO `item_db_re` VALUES ('1289','P_Katar1','Eden Group Katar I','4','0'
REPLACE INTO `item_db_re` VALUES ('1290','Agent_Katar','Agent Katar','4','41000','20500','1200','170','0','0','1','1','4096','56','2','34','3','100',NULL,'1','16','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHit,readparam(bLuk)/2;','','');
REPLACE INTO `item_db_re` VALUES ('1291','Guillotine_Katar','Guillotine Katar','4','56000','28000','1500','200','0','0','1','1','4096','56','2','34','4','140',NULL,'1','16','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,2; bonus bFlee,-30; bonus2 bAddRace,RC_DemiHuman,50; bonus2 bSkillAtk,GC_CROSSIMPACT,30;','','');
REPLACE INTO `item_db_re` VALUES ('1292','Upg_Katar','Upgrade Katar','4','20','10','1000','80','0','0','1','1','4096','63','2','34','3','0',NULL,'1','16','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bBaseAtk,(getrefine()*10); bonus bCritAtkRate,(getrefine()*2); if(BaseLevel>70) bonus bBaseAtk,(((BaseLevel-70)/10)*10);','','');
-REPLACE INTO `item_db_re` VALUES ('1293','Velum_Jamadhar','Vellum Jamadhar','4','20','10','1200','170','0','0','1','0','4096','63','2','34','4','95',NULL,'1','16','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAspdRate,getrefine();','','');
-REPLACE INTO `item_db_re` VALUES ('1294','Velum_Scare','Vellum Scale','4','20','10','1200','50','0','0','1','0','4096','63','2','34','4','95',NULL,'1','16','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSPVanishRate,10000,10;','','');
+REPLACE INTO `item_db_re` VALUES ('1293','Velum_Jamadhar','Vellum Jamadhar','4','20','10','1200','170','0','0','1','0','4096','63','2','34','4','95',NULL,'1','16','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAspdRate,getrefine(); bonus4 bSetDefRace,RC_DemiHuman,10000,5000,1; bonus4 bSetMDefRace,RC_DemiHuman,10000,5000,1;','','');
+REPLACE INTO `item_db_re` VALUES ('1294','Velum_Scare','Vellum Scale','4','20','10','1200','50','0','0','1','0','4096','63','2','34','4','95',NULL,'1','16','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus3 bSPVanishRate,10000,10,BF_NORMAL;','','');
REPLACE INTO `item_db_re` VALUES ('1295','Blood_Tears_','Blood Tears ','4','20','10','1700','120','0','0','1','1','4096','58','2','34','4','55',NULL,'1','16','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db_re` VALUES ('1296','Metal_Katar','Metal Katar','4','20','10','0','75','0','0','1','1','4096','63','2','34','3','0',NULL,'1','16','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bBaseAtk,(getrefine()*5); bonus bCritAtkRate,getrefine(); set .@i,((BaseLevel/10)>12)?12:(BaseLevel/10); if(.@i>2) bonus bBaseAtk,((.@i-2)*5);','','');
REPLACE INTO `item_db_re` VALUES ('1298','Shiver_Katar','Katar Of Horror','4','60000','30000','2700','110','0','0','1','2','4096','56','2','34','4','105',NULL,'1','16','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
@@ -742,7 +742,7 @@ REPLACE INTO `item_db_re` VALUES ('1391','P_Two_Handed_Axe1','Eden Group Two Han
REPLACE INTO `item_db_re` 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_re` 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_re` 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_re` 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; bonus2 bSPVanishRate,10000,10;','','');
+REPLACE INTO `item_db_re` 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_re` 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; }','','');
REPLACE INTO `item_db_re` VALUES ('1397','Bradium_Stonehammer_','Bradium Stone Hammer','4','20','10','2700','210','0','0','1','2','1024','58','2','34','4','75',NULL,'1','7','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0;','','');
REPLACE INTO `item_db_re` VALUES ('1398','Metal_Two_Handed_Axe','Metal Two-Handed Axe','4','20','10','0','105','0','0','1','1','279714','63','2','34','3','0',NULL,'1','7','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0; bonus bBaseAtk,(getrefine()*7); set .@i,((BaseLevel/10)>12)?12:(BaseLevel/10); if(.@i>2) bonus bBaseAtk,((.@i-2)*5);','','');
@@ -6278,7 +6278,7 @@ REPLACE INTO `item_db_re` VALUES ('13068','Saurel','Saurel','4','0','0','0','160
REPLACE INTO `item_db_re` VALUES ('13069','Aztoe_Nail','Aztoe Nail','4','56000','28000','500','160','80','0','1','0','414946','58','2','2','4','110',NULL,'1','1','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtkEle,Ele_Wind; bonus2 bAddEff,Eff_Freeze,100+(getrefine()*50);','','');
REPLACE INTO `item_db_re` VALUES ('13070','Scarletto_Nail','Scarletto Nail','4','56000','28000','500','160','80','0','1','0','414946','58','2','2','4','110',NULL,'1','1','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtkEle,Ele_Fire; bonus2 bAddEff,Eff_Stone,100+(getrefine()*50);','','');
REPLACE INTO `item_db_re` VALUES ('13071','Upg_Dagger','Upgrade Dagger','4','20','10','600','55','0','0','1','1','579821295','63','2','2','3','0',NULL,'1','1','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bBaseAtk,(getrefine()*10); bonus bMatk,(getrefine()*5); if(BaseLevel>70) bonus bBaseAtk,(((BaseLevel-70)/10)*5);','','');
-REPLACE INTO `item_db_re` VALUES ('13072','Velum_Damascus','Vellum Damascus','4','20','10','1000','180','0','0','1','0','579821295','63','2','2','4','95',NULL,'1','1','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAspdRate,getrefine();','','');
+REPLACE INTO `item_db_re` VALUES ('13072','Velum_Damascus','Vellum Damascus','4','20','10','1000','180','0','0','1','0','579821295','63','2','2','4','95',NULL,'1','1','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAspdRate,getrefine(); bonus4 bSetDefRace,RC_DemiHuman,10000,5000,1; bonus4 bSetMDefRace,RC_DemiHuman,10000,5000,1;','','');
REPLACE INTO `item_db_re` VALUES ('13073','Counter_Dagger_','Dagger of Counter','4','120000','60000','550','140','0','0','1','1','8454660','63','2','2','4','55',NULL,'1','1','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db_re` VALUES ('13074','Ninja_Cutter','Ninja Cutter','4','0','0','0','0','0','0','1','0','570425344','1','2','2','4','99',NULL,'1','1','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db_re` VALUES ('13075','Kurenai','Kurenai','4','5000','2500','700','130','0','0','1','0','570425344','1','2','2','3','99',NULL,'1','1','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,3;','','');
@@ -7508,7 +7508,7 @@ REPLACE INTO `item_db_re` VALUES ('16016','Tuna','Tuna','4','0','0','0','180','0
REPLACE INTO `item_db_re` 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,(getrefine()?getrefine()*20:20);','','');
REPLACE INTO `item_db_re` 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_re` 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);','','');
-REPLACE INTO `item_db_re` VALUES ('16020','Velum_Stunner','Vellum Stunner','4','20','10','1500','170','0','0','1','0','312755','63','2','2','4','95',NULL,'1','8','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0; bonus2 bAddEff,Eff_Stun,1000+getrefine(); bonus bAspdRate,getrefine();','','');
+REPLACE INTO `item_db_re` VALUES ('16020','Velum_Stunner','Vellum Stunner','4','20','10','1500','170','0','0','1','0','312755','63','2','2','4','95',NULL,'1','8','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0; bonus2 bAddEff,Eff_Stun,1000+getrefine(); bonus bAspdRate,getrefine(); bonus4 bSetDefRace,RC_DemiHuman,10000,5000,1; bonus4 bSetMDefRace,RC_DemiHuman,10000,5000,1;','','');
REPLACE INTO `item_db_re` VALUES ('16021','Velum_Flail','Vellum Flail','4','20','10','1500','170','0','0','1','0','312755','63','2','2','4','95',NULL,'1','8','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0; bonus3 bAutoSpell,NPC_CRITICALWOUND,5,10; bonus bHit,getrefine(); bonus bCritical,getrefine();','','');
REPLACE INTO `item_db_re` VALUES ('16022','Nemesis_','Nemesis','4','20','10','900','120','0','0','1','2','33040','63','2','2','4','60',NULL,'1','8','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0; bonus bAtkEle,Ele_Holy;','','');
REPLACE INTO `item_db_re` VALUES ('16023','Metal_Mace','Metal Mace','4','20','10','0','80','0','0','1','1','312755','63','2','2','3','1',NULL,'1','8','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0; bonus bBaseAtk,(getrefine()*5); set .@i,((BaseLevel/10)>12)?12:(BaseLevel/10); if(.@i>2) bonus bBaseAtk,((.@i-2)*5);','','');
@@ -7860,7 +7860,7 @@ REPLACE INTO `item_db_re` VALUES ('18109','Catapult','Catapult','4','56000','280
REPLACE INTO `item_db_re` VALUES ('18110','Big_CrossBow','Big CrossBow','4','56000','28000','900','160','0','0','5','2','2048','56','2','34','4','110',NULL,'1','11','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillAtk,RA_ARROWSTORM,(getrefine()*5); bonus2 bSkillUseSP,RA_ARROWSTORM,(getrefine()*5); if(readparam(bAgi)>=120) { bonus bAspd,1; }','','');
REPLACE INTO `item_db_re` VALUES ('18111','Creeper_Bow','Creeper Bow','4','56000','28000','1500','150','0','0','5','2','526336','56','2','34','3','120',NULL,'1','11','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,1; bonus3 bAutoSpell,PF_SPIDERWEB,1,200;','','');
REPLACE INTO `item_db_re` VALUES ('18112','Upg_Bow','Upgrade Bow','4','20','10','600','60','0','0','5','1','526344','63','2','34','3','0',NULL,'1','11','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bBaseAtk,(getrefine()*7); bonus bLongAtkRate,(getrefine()*2); if(BaseJob==Job_Hunter) bonus bBaseAtk,20; if(BaseLevel>70) bonus bBaseAtk,(((BaseLevel-70)/10)*10);','','');
-REPLACE INTO `item_db_re` VALUES ('18113','Velum_Arbalest','Vellum Arbalest','4','20','10','1100','50','0','0','5','0','657480','63','2','34','4','95',NULL,'1','11','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSPVanishRate,10000,4; bonus bAspd,-5;','','');
+REPLACE INTO `item_db_re` VALUES ('18113','Velum_Arbalest','Vellum Arbalest','4','20','10','1100','50','0','0','5','0','657480','63','2','34','4','95',NULL,'1','11','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus3 bSPVanishRate,10000,4,BF_NORMAL; bonus bAspd,-5;','','');
REPLACE INTO `item_db_re` VALUES ('18114','Velum_CrossBow','Vellum CrossBow','4','20','10','1100','110','0','0','5','0','657480','63','2','34','4','95',NULL,'1','11','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace,RC_DemiHuman,30+getrefine(); bonus2 bIgnoreDefRate,RC_DemiHuman,30;','','');
REPLACE INTO `item_db_re` VALUES ('18115','Orc_Archer_Bow_','Orc Archer\'s Bow','4','20','10','1600','120','0','0','5','1','657416','63','2','34','3','65',NULL,'1','11','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db_re` VALUES ('18116','Metal_Bow','Metal Bow','4','20','10','0','50','0','0','5','1','526344','63','2','34','3','0',NULL,'1','11','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if(BaseJob==Job_Hunter && Upper!=2) bonus bBaseAtk,10; bonus bBaseAtk,(getrefine()*3); bonus bLongAtkRate,getrefine(); set .@i,((BaseLevel/10)>12)?12:(BaseLevel/10); if(.@i>2) bonus bBaseAtk,((.@i-2)*5);','','');
@@ -8345,7 +8345,7 @@ REPLACE INTO `item_db_re` VALUES ('20711','Manteau_Of_Diego','Manteau Of Diego',
REPLACE INTO `item_db_re` VALUES ('20724','Love_Dad_Wings_2012','Love Dad Wings 2012','5','0','0','100','0','0','15','0','1','4294967295','63','2','4','0','0',NULL,'1','5','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db_re` VALUES ('21000','Upg_Twohand_Sword','Upgrade Two-Hand Sword','4','20','10','1500','100','0','0','1','1','16514','63','2','34','3','0',NULL,'1','3','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bBaseAtk,(getrefine()*12); bonus bMatk,(getrefine()*5); if(BaseLevel>70) bonus bBaseAtk,(((BaseLevel-70)/10)*10);','','');
REPLACE INTO `item_db_re` VALUES ('21001','Velum_Claymore','Vellum Claymore','4','20','10','3500','260','0','0','2','0','16514','63','2','34','4','95',NULL,'1','3','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace,RC_DemiHuman,80; bonus2 bIgnoreDefRate,RC_DemiHuman,30; if(getrefine()>=6) { bonus2 bAddRace,RC_DemiHuman,40; } if(getrefine()>=9) { autobonus2 \"{ bonus bShortWeaponDamageReturn,20; bonus bMagicDamageReturn,20; }\",200,1000,BF_WEAPON,\"{ specialeffect2 EF_REFLECTSHIELD; }\"; }','','');
-REPLACE INTO `item_db_re` VALUES ('21002','Velum_Katzbalger','Vellum Katzbalger','4','20','10','2500','100','0','0','1','0','16514','63','2','34','4','95',NULL,'1','3','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSPVanishRate,10000,8;','','');
+REPLACE INTO `item_db_re` VALUES ('21002','Velum_Katzbalger','Vellum Katzbalger','4','20','10','2500','100','0','0','1','0','16514','63','2','34','4','95',NULL,'1','3','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus3 bSPVanishRate,10000,8,BF_NORMAL;','','');
REPLACE INTO `item_db_re` VALUES ('21003','Muramasa_','Muramasa','4','20','10','1000','155','0','0','1','2','16514','63','2','34','4','48',NULL,'1','3','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db_re` VALUES ('21004','Alca_Bringer_','Alca Bringer','4','20','10','3400','280','0','0','2','2','16512','56','2','34','3','100',NULL,'1','3','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db_re` VALUES ('21005','Metal_Two_Hand_Sword','Metal Two-Handed Sword','4','20','10','0','95','0','0','1','1','16514','63','2','34','3','0',NULL,'1','3','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
@@ -8354,5 +8354,5 @@ REPLACE INTO `item_db_re` VALUES ('22540','Runstone_Lux','Lux Anima Rune','11','
REPLACE INTO `item_db_re` VALUES ('28200','End_Of_The_Horizon','End Of The Horizon','5','2700000','1350000','2400','410','0','0','9','1','1073741824','63','2','34','4','110',NULL,'1','21','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db_re` VALUES ('28201','South_Cross','Southern Cross','5','2800000','1400000','2000','480','0','0','9','0','1073741824','63','2','34','4','141',NULL,'1','21','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus3 bAutoSpell,\"GC_CROSSIMPACT\",1,50;','','');
REPLACE INTO `item_db_re` VALUES ('28202','Southern_Cross_','Southern Cross','5','2800000','1400000','2000','480','0','0','9','1','1073741824','63','2','34','4','141',NULL,'1','21','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus3 bAutoSpell,\"GC_CROSSIMPACT\",1,50;','','');
-REPLACE INTO `item_db_re` VALUES ('28203','Half_BF_Rifle1','Half BF Rifle1','5','0','0','0','50','0','0','9','0','1090519040','63','2','34','3','80',NULL,'1','18','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,2; bonus bHit,8; bonus bCritical,8; bonus2 bAddRace,RC_DemiHuman,30; bonus2 bAddRace,RC_Player,30; bonus2 bVariableCastrate,\"GS_TRACKING\",-20; bonus2 bIgnoreDefRaceRate,RC_DemiHuman,10; bonus2 bIgnoreDefRaceRate,RC_Player,10; bonus bUnbreakableWeapon,0;','','');
-REPLACE INTO `item_db_re` VALUES ('28204','Half_BF_Shotgun1','Half BF Shotgun1','5','0','0','0','100','0','0','9','0','1090519040','63','2','34','3','80',NULL,'1','20','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,2; bonus bSplashRange,1; bonus2 bAddRace,RC_DemiHuman,30; bonus2 bAddRace,RC_Player,30; bonus2 bIgnoreDefRaceRate,RC_DemiHuman,10; bonus2 bIgnoreDefRaceRate,RC_Player,10; autobonus \"{ bonus bBaseAtk,80; bonus2 bHPLossRate,100,1000; }\",30,6000,BF_WEAPON,\"{ specialeffect2 EF_BASH3D; }\"; bonus bUnbreakableWeapon,0;','','');
+REPLACE INTO `item_db_re` VALUES ('28203','Half_BF_Rifle1','Half BF Rifle1','5','0','0','0','50','0','0','9','0','1090519040','63','2','34','3','80',NULL,'1','18','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,2; bonus bHit,8; bonus bCritical,8; bonus2 bAddRace,RC_DemiHuman,30; bonus2 bVariableCastrate,\"GS_TRACKING\",-20; bonus2 bIgnoreDefRaceRate,RC_DemiHuman,10; bonus bUnbreakableWeapon,0;','','');
+REPLACE INTO `item_db_re` VALUES ('28204','Half_BF_Shotgun1','Half BF Shotgun1','5','0','0','0','100','0','0','9','0','1090519040','63','2','34','3','80',NULL,'1','20','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,2; bonus bSplashRange,1; bonus2 bAddRace,RC_DemiHuman,30; bonus2 bIgnoreDefRaceRate,RC_DemiHuman,10; autobonus \"{ bonus bBaseAtk,80; bonus2 bHPLossRate,100,1000; }\",30,6000,BF_WEAPON,\"{ specialeffect2 EF_BASH3D; }\"; bonus bUnbreakableWeapon,0;','','');