From a823dedd45238a623ab9b950f7408e59ab2c961f Mon Sep 17 00:00:00 2001
From: "Hercules.ws" <Hercules@efficiently.awesome>
Date: Mon, 6 Apr 2015 16:22:03 +0200
Subject: ItemDB SQL Sync

Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
---
 sql-files/item_db_re.sql | 14 +++++++-------
 1 file changed, 7 insertions(+), 7 deletions(-)

(limited to 'sql-files/item_db_re.sql')

diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql
index 61b4dee1b..2ba3d6e7d 100644
--- a/sql-files/item_db_re.sql
+++ b/sql-files/item_db_re.sql
@@ -1273,7 +1273,7 @@ REPLACE INTO `item_db` VALUES ('2173','Crescent_Armguard','Crescent Armguard','5
 REPLACE INTO `item_db` VALUES ('2174','Lumiere_Shield','Lumiere Shield','5','20','10','1300','0','0','50','0','1','4294967295','63','2','32','0','65',NULL,'1','3','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db` VALUES ('2175','Esprit_Shield','Spirit Shield','5','20','10','1300','0','0','50','0','1','4294967295','63','2','32','0','65',NULL,'1','3','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db` VALUES ('2176','Dark_Book','Black Book','5','20','10','500','0','0','80','0','1','4294967295','63','2','32','0','65',NULL,'1','5','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,5;','','');
-REPLACE INTO `item_db` VALUES ('2177','Shield_Of_Death','Shield Of Death','5','20','10','2000','0','0','150','0','1','2147483647','63','2','32','0','90',NULL,'1','3','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace,RC_Boss,2; bonus2 bSubRace,RC_NonBoss,-10;','','');
+REPLACE INTO `item_db` VALUES ('2177','Shield_Of_Death','Shield Of Death','5','20','10','2000','0','0','150','0','1','4294967295','63','2','32','0','90',NULL,'1','3','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace,RC_Boss,2; bonus2 bSubRace,RC_NonBoss,-10;','','');
 REPLACE INTO `item_db` VALUES ('2181','Hervor','Hervor','5','20','10','1500','0','0','100','0','0','4294967295','63','2','32','0','90',NULL,'0','2','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,5; bonus2 bSubRace,RC_NonBoss,30; bonus2 bSubRace,RC_Boss,30; bonus bUnbreakableShield,1;','','');
 REPLACE INTO `item_db` VALUES ('2185','Magic_Reflector','Magic Reflector','5','20','10','1000','0','0','50','0','0','4294967295','63','2','32','0','90',NULL,'0','2','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if (getrefine()>8) { bonus bMagicDamageReturn,9; } else if (getrefine()>6) { bonus bMagicDamageReturn,6; } else { bonus bMagicDamageReturn,3; }','','');
 REPLACE INTO `item_db` VALUES ('2186','Revised_Encyclopedia','Revised Encyclopedia','5','20','10','1000','0','0','50','1','2','4260096','63','2','32','0','70',NULL,'1','15','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMatk,5; bonus bInt,3; bonus bDex,2; bonus bCritical,3; if (getrefine()>6) { bonus bCritical,2; } if (getrefine()>8) { bonus bMatk,5; } if (isequipped(1564)) { bonus bAspdRate,getequiprefinerycnt(EQI_HAND_R); }','','');
@@ -9171,9 +9171,9 @@ REPLACE INTO `item_db` VALUES ('22042','Terraria','Terraria','5','10','5','300',
 REPLACE INTO `item_db` VALUES ('22043','AGI_Complement','AGI Complement','5','10','5','350','0','0','25','0','1','1024','56','2','64','0','100',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAspdRate,5+(getrefine()/4);','','');
 REPLACE INTO `item_db` VALUES ('22044','Reinforced_Parts_Booster','Reinforced Parts - Booster','5','10','5','1000','0','0','23','0','1','1024','56','2','64','0','100',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillUseSP,NC_HOVERING,15; if(getrefine()>=7) { bonus2 bSkillUseSP,NC_HOVERING,-20; }','','');
 REPLACE INTO `item_db` VALUES ('22045','Beach_Sandals','Summer Sandals','5','10','5','200','0','0','5','0','0','4294967295','63','2','64','0','0',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bFlee,5; bonus3 bAutoSpellWhenHit,AL_INCAGI,10,300;','','');
-REPLACE INTO `item_db` VALUES ('22046','Boots_of_Airship','Boots of Airship','5','20','10','0','0','0','26','0','0','2147483647','63','2','64','0','125',NULL,'0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','bonus bAgi,1; bonus bAspdRate,10;','','');
-REPLACE INTO `item_db` VALUES ('22047','Tarlock\'s_Boots','Tarlock\'s Boots','5','20','10','250','0','0','13','0','0','2147483647','63','2','64','0','125',NULL,'1','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','Egir_Shoes_','Egir Shoes','5','20','10','300','0','0','13','0','0','2147483647','63','2','64','0','40',NULL,'1','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 ('22046','Boots_of_Airship','Boots of Airship','5','20','10','0','0','0','26','0','0','4294967295','63','2','64','0','125',NULL,'0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','bonus bAgi,1; bonus bAspdRate,10;','','');
+REPLACE INTO `item_db` VALUES ('22047','Tarlock\'s_Boots','Tarlock\'s Boots','5','20','10','250','0','0','13','0','0','4294967295','63','2','64','0','125',NULL,'1','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','Egir_Shoes_','Egir Shoes','5','20','10','300','0','0','13','0','0','4294967295','63','2','64','0','40',NULL,'1','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','3500','1750','400','0','0','10','0','0','2147483646','63','2','64','0','0',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','skill ALL_CATCRY, 1; bonus bUnbreakableShoes,0; autobonus3 \"{ }\",1000,7000,ALL_CATCRY,\"{ montransform 1505,420000; }\";','','');
 REPLACE INTO `item_db` VALUES ('22514','Candy_Holder','Candy Holder','11','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db` VALUES ('22515','Twisted_Key_of_Time','Twisted Key of Time','3','10','5','300','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
@@ -9444,8 +9444,8 @@ REPLACE INTO `item_db` VALUES ('28201','South_Cross','Southern Cross','4','28000
 REPLACE INTO `item_db` VALUES ('28202','Southern_Cross_','Southern Cross','4','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` VALUES ('28203','Half_BF_Rifle1','Half BF Rifle1','4','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 bIgnoreDefRate,RC_DemiHuman,10; bonus bUnbreakableWeapon,0;','','');
 REPLACE INTO `item_db` VALUES ('28204','Half_BF_Shotgun1','Half BF Shotgun1','4','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 bIgnoreDefRate,RC_DemiHuman,10; autobonus \"{ bonus bBaseAtk,80; bonus2 bHPLossRate,100,1000; }\",30,6000,BF_WEAPON,\"{ specialeffect2 EF_BASH3D; }\"; bonus bUnbreakableWeapon,0;','','');
-REPLACE INTO `item_db` VALUES ('28310','Sarah\'s_Left_Earring','Sarah\'s Left Earring','5','0','0','100','0','0','0','0','0','2147483647','63','2','136','0','145',NULL,'0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','skill AL_HEAL,1;','','');
-REPLACE INTO `item_db` VALUES ('28311','Sarah\'s_Right_Earring','Sarah\'s Right Earring','5','0','0','100','0','0','0','0','0','2147483647','63','2','136','0','145',NULL,'0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','skill AL_TELEPORT,1;','','');
+REPLACE INTO `item_db` VALUES ('28310','Sarah\'s_Left_Earring','Sarah\'s Left Earring','5','0','0','100','0','0','0','0','0','4294967295','63','2','136','0','145',NULL,'0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','skill AL_HEAL,1;','','');
+REPLACE INTO `item_db` VALUES ('28311','Sarah\'s_Right_Earring','Sarah\'s Right Earring','5','0','0','100','0','0','0','0','0','4294967295','63','2','136','0','145',NULL,'0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','skill AL_TELEPORT,1;','','');
 REPLACE INTO `item_db` VALUES ('28326','Broken_Chips_01','Broken Chips 01','5','10','5','100','0','0','0','0','1','4294967295','63','2','136','0','100',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,4;','','');
 REPLACE INTO `item_db` VALUES ('28327','Broken_Chips_02','Broken Chips 02','5','10','5','100','0','0','0','0','1','4294967295','63','2','136','0','100',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,4;','','');
 REPLACE INTO `item_db` VALUES ('28332','Jewerly_Ring','Jewerly Ring','5','10','5','100','0','0','0','0','0','4294967295','63','2','136','0','1',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bLuk,20; autobonus \"{ bonus bAspd,2; }\",50,2000,BF_WEAPON|BF_MAGIC;','','');
@@ -9454,4 +9454,4 @@ REPLACE INTO `item_db` VALUES ('28604','Crimson_Bible','Crimson Bible','4','20',
 REPLACE INTO `item_db` VALUES ('28605','Book_of_Vicious_Mind','Book of Vicious Mind','4','20','10','950','95','0','0','1','1','4260096','63','2','2','4','160',NULL,'1','15','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtk,pow(min(getrefine(),15),2); bonus bMatk,pow(min(getrefine(),15),2); bonus bUnbreakableWeapon,0;','','');
 REPLACE INTO `item_db` VALUES ('28705','Crimson_Dagger','Crimson Dagger','4','20','10','550','55','0','0','1','2','579821295','63','2','2','3','70',NULL,'1','1','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtk,pow(min(getrefine(),15),2); bonus bMatk,pow(min(getrefine(),15),2)/2; if(BaseLevel>70) bonus bAtk,(((BaseLevel-70)/10)*5);','','');
 REPLACE INTO `item_db` VALUES ('28706','Dagger_of_Vicious_Mind','Dagger of Vicious Mind','4','20','10','1050','105','50','0','1','1','579821295','63','2','2','4','160',NULL,'1','1','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtk,pow(min(getrefine(),15),2); bonus bMatk,pow(min(getrefine(),15),2)/2;','','');
-REPLACE INTO `item_db` VALUES ('28900','Praetorian_Shield','Praetorian Shield','5','20','10','3000','0','0','30','0','1','2147483647','63','2','32','0','100',NULL,'1','1','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','skill LG_SHIELDSPELL,1; .@rate = 20+(getrefine()); bonus3 bAutoSpellWhenHit,HP_ASSUMPTIO,3,.@rate; bonus bDef,getrefine()*10; bonus bMdef,getrefine();','','');
+REPLACE INTO `item_db` VALUES ('28900','Praetorian_Shield','Praetorian Shield','5','20','10','3000','0','0','30','0','1','4294967295','63','2','32','0','100',NULL,'1','1','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','skill LG_SHIELDSPELL,1; .@rate = 20+(getrefine()); bonus3 bAutoSpellWhenHit,HP_ASSUMPTIO,3,.@rate; bonus bDef,getrefine()*10; bonus bMdef,getrefine();','','');
-- 
cgit v1.2.3-70-g09d2

