summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorHercules.ws <Hercules@efficiently.awesome>2015-12-17 13:17:19 +0100
committerHerculesWSAPI <Hercules@efficiently.awesome>2015-12-17 13:17:19 +0100
commitad76f44e3986ee9d1851e6f0066fbf688ddbc518 (patch)
tree827a4f4fa688f2fe0998e9934cd5a9cd89ca28c4
parent59c2cc871fb8846578feca602c62a3b0291b76d9 (diff)
downloadhercules-ad76f44e3986ee9d1851e6f0066fbf688ddbc518.tar.gz
hercules-ad76f44e3986ee9d1851e6f0066fbf688ddbc518.tar.bz2
hercules-ad76f44e3986ee9d1851e6f0066fbf688ddbc518.tar.xz
hercules-ad76f44e3986ee9d1851e6f0066fbf688ddbc518.zip
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
-rw-r--r--sql-files/item_db_re.sql11
1 files changed, 6 insertions, 5 deletions
diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql
index e7dcf538f..641ecfafd 100644
--- a/sql-files/item_db_re.sql
+++ b/sql-files/item_db_re.sql
@@ -8640,6 +8640,7 @@ REPLACE INTO `item_db` VALUES ('19015','C_Kamas_Hairband','Costume Kama\'s Hairb
REPLACE INTO `item_db` VALUES ('19019','Elemental_Crown','Elemental Crown','5','0','0','500','0','0','10','0','1','4294967295','63','2','256','0','50',NULL,'1','1219','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,3; bonus bLongAtkRate,4; bonus bDex,(getrefine()/2); if(BaseLevel>130) { bonus bDex,getrefine(); }','','');
REPLACE INTO `item_db` VALUES ('19020','Survive_Circlet','Survive Circlet','5','20','10','500','0','0','10','0','1','4294967295','63','2','256','0','50',NULL,'1','1220','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,3; bonus bMatkRate,4; if(BaseLevel<100) { bonus bInt,getrefine()/2; } else { bonus bInt,getrefine(); }','','');
REPLACE INTO `item_db` VALUES ('19021','Gigant_Helm','Gigant Helm','5','20','10','500','0','0','10','0','1','4294967295','63','2','256','0','50',NULL,'1','1221','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,3; bonus bAtkRate,4; if(BaseLevel<100) { bonus bStr,getrefine()/2; } else { bonus bStr,getrefine(); } /* +Giant Lance, when using Joint Beat, auto cast Lv.1 Spiral pierce, */ /* every refine of lance increase the chance of trigger and increase damage of spiral pierce by 5%. */','','');
+REPLACE INTO `item_db` VALUES ('19022','C_Floating_Stone_Of_Intelligence','Floating Stone Of Intelligence','5','0','0','0','0','0','0','0','0','4294967295','63','2','2048','0','0',NULL,'1','1230','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','sc_start SC_FSTONE, -1, 0;','sc_end SC_FSTONE;');
REPLACE INTO `item_db` VALUES ('19023','Queen_Scaraba_Crown','Queen Scaraba Crown','5','0','0','1500','0','0','0','0','1','4294967295','63','2','257','0','70',NULL,'1','1231','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDefRate,-50; bonus bMdefRate,-50; bonus2 bSubRace,RC_Insect,getrefine(); bonus3 bAutoSpell,NPC_WIDECONFUSE,2,100+(getrefine()*10); /* Custom - JRO */','','');
REPLACE INTO `item_db` VALUES ('19024','Protect_Feathers','Protect Feathers','5','20','10','500','0','0','0','0','0','4294967295','63','2','512','0','70',NULL,'0','1232','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,2; bonus2 bAddRaceTolerance,RC_DemiPlayer,2; bonus bAspdRate,-5; if(readparam(bVit)>=108) { bonus bAspdRate,-5; bonus2 bAddRaceTolerance,RC_DemiPlayer,2; } if(readparam(bVit)>=120) { bonus bMdef,3; bonus bMaxHPrate,3; }','','');
REPLACE INTO `item_db` VALUES ('19025','Puppy_Ears_Hat_','Puppy Ears Hat','5','0','0','200','0','0','3','0','1','4294967295','63','2','256','0','10',NULL,'1','827','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,3; bonus2 bMagicAddRace,RC_Brute,5; bonus2 bAddRace,RC_Brute,5; bonus2 bAddRaceTolerance,RC_Brute,5; bonus3 bAddMonsterDropItem,7938,RC_Brute,100;','','');
@@ -9013,7 +9014,7 @@ REPLACE INTO `item_db` VALUES ('19866','C_Blue_Pajamas','Costume Blue Pajamas','
REPLACE INTO `item_db` VALUES ('19867','C_Red_Pajamas','Costume Red Pajamas','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','501','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('19868','C_Showy_High_Cap','Costume Showy High Cap','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','830','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('19869','C_Antiquity_Helmet','Costume Antiquity Helmet','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','846','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
-REPLACE INTO `item_db` VALUES ('19871','C_DecorationOfMusic_Accessory','Decoration of Music','5','20','10','0','0','0','0','0','0','4294967295','63','2','2048','0','0',NULL,'0','1074','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','sc_start SC_DECORATION_OF_MUSIC,-1,0;','sc_end SC_DECORATION_OF_MUSIC;');
+REPLACE INTO `item_db` VALUES ('19871','C_Music_Decoration','Decoration of Music','5','20','10','0','0','0','0','0','0','4294967295','63','2','2048','0','0',NULL,'0','1074','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','sc_start SC_DECORATION_OF_MUSIC, -1, 0;','sc_end SC_DECORATION_OF_MUSIC;');
REPLACE INTO `item_db` VALUES ('19873','C_Carnival_Hat','Costume Carnival Hat','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','505','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('19874','C_Carnival_Circlet','Costume Carnival Circlet','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','506','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('19875','C_Love_Rabbit_Hood','Costume Love Rabbit Hood','5','0','0','0','0','0','0','0','0','4294967295','63','2','7168','0','0',NULL,'1','549','0','0','0','0','384',NULL,'0',NULL,'0',NULL,'0','','','');
@@ -9180,7 +9181,7 @@ REPLACE INTO `item_db` VALUES ('20058','C_Hot_Blood_Headband','Costume Hot Blood
REPLACE INTO `item_db` VALUES ('20059','C_Welding_Mask','Costume Welding Mask','5','0','0','0','0','0','0','0','0','4294967295','63','2','6144','0','0',NULL,'1','79','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('20060','C_Construction_Helmet','Costume Construction Helmet','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','95','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('20061','C_Demo_Mask','Costume Demo Mask','5','0','0','0','0','0','0','0','0','4294967295','63','2','4096','0','0',NULL,'1','52','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
-REPLACE INTO `item_db` VALUES ('20062','C_Angel_Stair','Costume Angel Stair','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
+REPLACE INTO `item_db` VALUES ('20062','C_Angel_Stair','Costume Angel Stair','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','sc_start SC_HAT_EFFECT, -1, 0;','sc_end SC_HAT_EFFECT;');
REPLACE INTO `item_db` VALUES ('20063','C_Yellow_Brain_Hat','Costume Yellow Brain Hat','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','1228','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('20064','C_Blue_Brain_Hat','Costume Blue Brain Hat','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','1229','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('20065','C_Grand_Peco_Hairband','Costume Grand Peco Hairband','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','473','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
@@ -9271,7 +9272,7 @@ REPLACE INTO `item_db` VALUES ('20150','C_Wind_Fan','Costume Wind Fan','5','0','
REPLACE INTO `item_db` VALUES ('20151','C_Poison_Spore_Hat','Costume Poison Spore Hat','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','899','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('20152','C_Straw_Rice_Bag','Costume Straw Rice Bag','5','0','0','0','0','0','0','0','0','4294967295','63','2','7168','0','0',NULL,'1','1273','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('20153','C_Monochrome_Cap','Costume Monochrome Cap','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','1274','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
-REPLACE INTO `item_db` VALUES ('20154','C_Falling_Maple_leafs','Costume Falling Maple leafs','5','0','0','0','0','0','0','0','0','4294967295','63','2','4096','0','0',NULL,'1','1275','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
+REPLACE INTO `item_db` VALUES ('20154','C_Falling_Maple_leafs','Costume Falling Maple leafs','5','0','0','0','0','0','0','0','0','4294967295','63','2','4096','0','0',NULL,'1','1275','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','sc_start SC_MAPLE_FALLS, -1, 0;','sc_end SC_MAPLE_FALLS;');
REPLACE INTO `item_db` VALUES ('20155','C_Lady_Feather_Hat','Costume Lady Feather Hat','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','1276','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('20156','C_Fan_in_Mouth','Costume Fan in Mouth','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','857','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('20157','C_Blue_Fish','Costume Blue Fish','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','149','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
@@ -9363,7 +9364,7 @@ REPLACE INTO `item_db` VALUES ('20242','C_Snownow_Hat','Costume Snownow Hat','5'
REPLACE INTO `item_db` VALUES ('20243','C_Choco_Mint_Bonnet','Costume Choco Mint Bonnet','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','1314','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('20244','C_Zealotus_Mask','Costume Zealotus Mask','5','0','0','0','0','0','0','0','0','4294967295','63','2','3072','0','0',NULL,'1','200','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('20245','C_Cat_Paw_Hairpin','Costume Cat Paw Hairpin','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','447','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
-REPLACE INTO `item_db` VALUES ('20246','C_Decoration_of_Time','Costume Decoration of Time','5','0','0','0','0','0','0','0','0','4294967295','63','2','2048','0','0',NULL,'1','1309','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
+REPLACE INTO `item_db` VALUES ('20246','C_Decoration_of_Time','Costume Decoration of Time','5','0','0','0','0','0','0','0','0','4294967295','63','2','2048','0','0',NULL,'1','1309','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','sc_start SC_TIME_ACCESSORY, -1, 0;','sc_end SC_TIME_ACCESSORY;');
REPLACE INTO `item_db` VALUES ('20247','C_Black_Hand_of_Fate','Costume Black Hand of Fate','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','1310','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('20248','C_Black_Strong_Hair','Costume Black Strong Hair','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','1315','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('20249','C_Red_Strong_Hair','Costume Red Strong Hair','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','1316','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
@@ -9399,7 +9400,7 @@ REPLACE INTO `item_db` VALUES ('20281','C_Kindergarten_Hat','Costume Kindergarte
REPLACE INTO `item_db` VALUES ('20282','C_White_Student_Cap','Costume White Student Cap','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','877','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('20283','C_Over_Protector','Costume Over Protector','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','1329','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('20284','C_Sakura_Hat','Costume Sakura Hat','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','1330','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
-REPLACE INTO `item_db` VALUES ('20285','C_Dancing_Fallen_Sakura','Costume Dancing Fallen Sakura','5','0','0','0','0','0','0','0','0','4294967295','63','2','4096','0','0',NULL,'1','1331','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
+REPLACE INTO `item_db` VALUES ('20285','C_Dancing_Fallen_Sakura','Costume Dancing Fallen Sakura','5','0','0','0','0','0','0','0','0','4294967295','63','2','4096','0','0',NULL,'1','1331','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','sc_start SC_BLOSSOM_FLUTTERING, -1, 0;','sc_end SC_BLOSSOM_FLUTTERING;');
REPLACE INTO `item_db` VALUES ('20286','C_Under_Rim_Glasses_Red','Costume Under Rim Glasses Red','5','0','0','0','0','0','0','0','0','4294967295','63','2','2048','0','0',NULL,'1','1332','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('20287','C_Mans_Medal(Gold)','Costume Man\'s Medal(Gold)','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','1333','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('20288','C_Bijou_Hat','Costume Bijou Hat','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','1334','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');