From ebbfc0353bf96593906fdc7a73afdbfe2eec8991 Mon Sep 17 00:00:00 2001
From: "Hercules.ws" <Hercules@efficiently.awesome>
Date: Mon, 26 Oct 2015 14:50:18 +0100
Subject: ItemDB SQL Sync

Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
---
 sql-files/item_db_re.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(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 dd8e4302c..b442d5951 100644
--- a/sql-files/item_db_re.sql
+++ b/sql-files/item_db_re.sql
@@ -1210,7 +1210,7 @@ REPLACE INTO `item_db` VALUES ('2000','Destruction_Rod','Staff of Destruction','
 REPLACE INTO `item_db` VALUES ('2001','Divine_Cross','Divine Cross','4','20','10','1500','120','210','0','1','0','33024','63','2','34','4','70',NULL,'1','23','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtkEle,Ele_Holy; bonus bDex,4; bonus2 bAddRaceTolerance,RC_Demon,15; bonus2 bAddRaceTolerance,RC_Undead,15;','','');
 REPLACE INTO `item_db` VALUES ('2002','Krieger_Twohand_Staff1','Glorious Destruction Staff','4','20','10','0','70','210','0','1','0','8487700','63','2','34','4','80',NULL,'1','23','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus bMatkRate,getrefine(); bonus2 bMagicAddRace,RC_DemiPlayer,15; bonus2 bIgnoreMdefRate,RC_DemiPlayer,25; bonus bUnbreakableWeapon,0; if(getrefine()>5) { bonus2 bMagicAddRace,RC_DemiPlayer,(min(getrefine(),14)-5)*2; bonus2 bIgnoreMdefRate,RC_DemiPlayer,5+(min(getrefine(),14)-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; }','','');
 REPLACE INTO `item_db` VALUES ('2003','Destruction_Rod_M','Staff of Destruction','4','20','10','2500','130','280','0','1','1','512','58','2','34','4','80',NULL,'1','23','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','bonus bMatkRate,getrefine()/2; bonus bInt,3; bonus bAgi,10; bonus bUseSPrate,(getrefine()*2); bonus3 bAutoSpellWhenHit,WZ_JUPITEL,5,(getrefine()*20); bonus2 bVariableCastrate,HW_MAGICPOWER,-50;','','');
-REPLACE INTO `item_db` VALUES ('2004','Kronos','Kronos','4','20','10','1000','30','240','0','1','0','66052','58','2','34','4','50',NULL,'1','23','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,3+(getrefine()/2); bonus bMaxHP,300+(50*getrefine()/2); autobonus \"{ bonus bMatkRate,12; bonus buseSPRate,20; }\",1,5000,BF_MAGIC,\"{ specialeffect2 EF_ENHANCE; }\";','','');
+REPLACE INTO `item_db` VALUES ('2004','Kronos','Kronos','4','20','10','1000','30','240','0','1','0','66052','58','2','34','4','50',NULL,'1','23','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,3+(getrefine()/2); bonus bMaxHP,300+(50*getrefine()/2); autobonus \"{ bonus bMatkRate,12; bonus bUseSPrate,20; }\",1,5000,BF_MAGIC,\"{ specialeffect2 EF_ENHANCE; }\";','','');
 REPLACE INTO `item_db` VALUES ('2005','Dea_Staff','Dea Staff','4','20','10','1000','30','220','0','1','1','33040','58','2','34','3','50',NULL,'1','23','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtkEle,Ele_Holy; bonus bMatkRate,getrefine()/2; bonus bInt,6; bonus bVit,2; autobonus3 \"{ }\",20,1000,AL_HEAL,\"{ specialeffect2 EF_MAGICALATTHIT; heal 0,200; }\";','','');
 REPLACE INTO `item_db` VALUES ('2006','G_Staff_Of_Light','Guardian Of Light Wand','4','20','10','1900','80','150','0','1','0','8454660','63','2','34','4','60',NULL,'1','23','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtkEle,Ele_Holy; bonus bInt,6;','','');
 REPLACE INTO `item_db` VALUES ('2007','Golden_Rod_Staff','Golden Rod Staff','4','20','10','900','30','230','0','1','2','512','56','2','34','4','100',NULL,'1','23','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtkEle,Ele_Wind; bonus bInt,3; bonus2 bSkillAtk,WZ_JUPITEL,12;','','');
-- 
cgit v1.2.3-70-g09d2


From adf5e1462631f6e82cdf4c6b56313b19939a0d3a Mon Sep 17 00:00:00 2001
From: "Hercules.ws" <Hercules@efficiently.awesome>
Date: Mon, 26 Oct 2015 16:28:22 +0100
Subject: ItemDB SQL Sync

Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
---
 sql-files/item_db_re.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 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 b442d5951..706a229c8 100644
--- a/sql-files/item_db_re.sql
+++ b/sql-files/item_db_re.sql
@@ -9111,7 +9111,7 @@ REPLACE INTO `item_db` VALUES ('20095','C_Red_Ribbon','Costume Red Ribbon','5','
 REPLACE INTO `item_db` VALUES ('20096','C_Blue_Ribbonn','Costume Blue Ribbonn','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','441','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db` VALUES ('20097','C_White_Ribbon','Costume White Ribbon','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','442','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db` VALUES ('20098','C_Vampire_Hairband','Costume Vampire Hairband','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','1238','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
-REPLACE INTO `item_db` VALUES ('20099','C_Ljosalfar','Costume Ljosalfar','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','1239','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
+REPLACE INTO `item_db` VALUES ('20099','C_Ljosalfar','Costume Ljosalfar','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','1239','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','sc_start SC_LJOSALFAR,-1,0;','sc_end SC_LJOSALFAR;');
 REPLACE INTO `item_db` VALUES ('20100','C_Volume_Fhat','Costume Volume Fhat','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','1240','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db` VALUES ('20101','C_Bragi_Wing_Ears','Costume Bragi Wing Ears','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','1241','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db` VALUES ('20102','C_Horse_King_J','Costume Horse King_J','5','0','0','0','0','0','0','0','0','4294967295','63','2','7168','0','0',NULL,'1','1189','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
@@ -9221,7 +9221,7 @@ REPLACE INTO `item_db` VALUES ('20205','C_Fancy_Flower','Costume Fancy Flower','
 REPLACE INTO `item_db` VALUES ('20206','C_Chicken_Hat1','Costume Chicken Hat1','5','0','0','0','0','0','0','0','0','4294967295','63','2','7168','0','0',NULL,'1','1296','0','0','0','0','467',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db` VALUES ('20207','C_Striped_Hairband','Costume Striped Hairband','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','133','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db` VALUES ('20208','C_Necktie','Costume Necktie','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','443','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
-REPLACE INTO `item_db` VALUES ('20209','C_Mermaid_Bubbles','Costume Mermaid Bubbles','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','1299','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
+REPLACE INTO `item_db` VALUES ('20209','C_Mermaid_Bubbles','Costume Mermaid Bubbles','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','1299','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','sc_start SC_MERMAID_LONGING,-1,0;','sc_end SC_MERMAID_LONGING;');
 REPLACE INTO `item_db` VALUES ('20210','C_Chicken_Hat2','Costume Chicken Hat2','5','0','0','0','0','0','0','0','0','4294967295','63','2','7168','0','0',NULL,'1','1297','0','0','0','0','467',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db` VALUES ('20211','C_Chicken_Hat3','Costume Chicken Hat3','5','0','0','0','0','0','0','0','0','4294967295','63','2','7168','0','0',NULL,'1','1298','0','0','0','0','467',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db` VALUES ('20212','C_Loki_&_Nidhoggur_dolls','Costume Loki & Nidhoggur dolls','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','1304','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
-- 
cgit v1.2.3-70-g09d2

