From 715af9d93adf4e07f11ff09a6a1b55d49d32849d Mon Sep 17 00:00:00 2001 From: "Hercules.ws" Date: Mon, 3 Nov 2014 16:25:04 +0100 Subject: ItemDB SQL Sync Signed-off-by: HerculesWSAPI --- sql-files/item_db.sql | 5 +++-- sql-files/item_db_re.sql | 5 +++-- 2 files changed, 6 insertions(+), 4 deletions(-) (limited to 'sql-files') diff --git a/sql-files/item_db.sql b/sql-files/item_db.sql index af1be6b11..1e4598a8d 100644 --- a/sql-files/item_db.sql +++ b/sql-files/item_db.sql @@ -201,11 +201,11 @@ REPLACE INTO `item_db` VALUES ('667','Gift_Box_4','Gift Box','2','1000','500','2 REPLACE INTO `item_db` VALUES ('668','Handsei','Red Envelope','2','0','0','20','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','Zeny += rand(1000,10000);','',''); REPLACE INTO `item_db` VALUES ('669','Rice_Cake_Soup','Tempting Rice-Cake Soup','0','500','250','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','percentheal -100,-100;','',''); REPLACE INTO `item_db` VALUES ('670','Gold_Coin_Moneybag','Bag of Gold Coins','3','100000','50000','400','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 ('671','Gold_Coin','Gold Coin','3','10000','5000','40','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 ('671','Gold_Coin','Gold Roulette Coin','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','set TmpRouletteGold,TmpRouletteGold + 1;','',''); REPLACE INTO `item_db` VALUES ('672','Copper_Coin_Moneybag','Bag of Bronze Coins','3','1000','500','400','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 ('673','Copper_Coin','Bronze Coin','3','100','50','40','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 ('674','Mithril_Coin','Mithril Coin','3','5000','2500','40','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 ('675','Silver_Coin','Silver Coin','3','5000','2500','40','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 ('675','Silver_Coin','Silver Roulette Coin','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','set TmpRouletteSilver,TmpRouletteSilver + 1;','',''); REPLACE INTO `item_db` VALUES ('676','Silver_Coin_Moneybag','Bag of Silver Coins','3','50000','25000','400','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 ('677','White_Gold_Coin','Platinum Coin','3','2000','1000','40','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 ('678','Poison_Bottle','Poison Bottle','2','5000','2500','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','if(Class==Job_Assassin_Cross) { sc_start SC_DPOISON,60000,0; sc_start SC_ATTHASTE_INFINITY,60000,0; } else percentheal -100,-100;','',''); @@ -6181,3 +6181,4 @@ REPLACE INTO `item_db` VALUES ('19505','T_Cigarette','T Cigarette','5','0','0',' REPLACE INTO `item_db` VALUES ('19506','T_Valkyrie_Feather_Band','T Valkyrie Feather Band','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','300','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('19507','Clear_Sun','Clear Sun','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','1',NULL,'0','654','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('22540','Runstone_Luxanima','Lux Anima Rune','11','2','1','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','60000','0',NULL,'0',NULL,'20','1','0','itemskill RK_LUXANIMA,1;','',''); +REPLACE INTO `item_db` VALUES ('22837','Integer_Time','Integer Time','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','50',NULL,'0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','set TmpRouletteBronze,TmpRouletteBronze + 1;','',''); diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql index bedba41bc..b2bd489fe 100644 --- a/sql-files/item_db_re.sql +++ b/sql-files/item_db_re.sql @@ -203,11 +203,11 @@ REPLACE INTO `item_db_re` VALUES ('667','Gift_Box_4','Gift Box','2','1000','500' REPLACE INTO `item_db_re` VALUES ('668','Handsei','New Year\'s Red Envelope','2','0','0','20','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','Zeny += rand(1000,10000);','',''); REPLACE INTO `item_db_re` VALUES ('669','Rice_Cake_Soup','Tempting Rice-Cake Soup','0','500','250','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','percentheal -100,-100;','',''); REPLACE INTO `item_db_re` VALUES ('670','Gold_Coin_Moneybag','Bag of Gold Coins','3','100000','50000','400','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_re` VALUES ('671','Gold_Coin','Gold Coin','3','10000','5000','40','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_re` VALUES ('671','Gold_Coin','Gold Roulette Coin','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','set TmpRouletteGold,TmpRouletteGold + 1;','',''); REPLACE INTO `item_db_re` VALUES ('672','Copper_Coin_Moneybag','Bag of Bronze Coins','3','1000','500','400','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_re` VALUES ('673','Copper_Coin','UGC Token','3','100','50','40','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_re` VALUES ('674','Mithril_Coin','Mithril Coin','3','5000','2500','40','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_re` VALUES ('675','Silver_Coin','Silver Coin','3','5000','2500','40','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_re` VALUES ('675','Silver_Coin','Silver Roulette Coin','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','set TmpRouletteSilver,TmpRouletteSilver + 1;','',''); REPLACE INTO `item_db_re` VALUES ('676','Silver_Coin_Moneybag','Bag of Silver Coins','3','50000','25000','400','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_re` VALUES ('677','White_Gold_Coin','Platinum Coin','3','2000','1000','40','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_re` VALUES ('678','Poison_Bottle','Poison Bottle','2','5000','2500','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','if(Class == Job_Assassin_Cross || Class == Job_Guillotine_Cross || Class == Job_Guillotine_Cross_T) { sc_start SC_DPOISON,60000,0; sc_start SC_ATTHASTE_INFINITY,60000,9; } else percentheal -100,-100;','',''); @@ -8367,6 +8367,7 @@ REPLACE INTO `item_db_re` VALUES ('22514','Candy_Holder','Candy Holder','11','20 REPLACE INTO `item_db_re` VALUES ('22540','Runstone_Lux','Lux Anima Rune','11','2','1','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','60000','0',NULL,'0',NULL,'20','1','0','itemskill RK_LUXANIMA,1;','',''); REPLACE INTO `item_db_re` VALUES ('22669','HALLOWEEN_G_BOX','Halloween Box','2','0','0','20','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getrandgroupitem 22669,1;','',''); REPLACE INTO `item_db_re` VALUES ('22670','DARK_INVITATION','Invitation of Darkness','2','10','5','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','.@r = rand(1,3); if (.@r == 1) { specialeffect2 EF_DEVIL; warp \"niflheim\",193,186; } else if(.@r == 2) { heal -500,-1000; sc_start SC_STUN,3000,0; } else { specialeffect2 EF_DEVIL; warp \"niflheim\",347,255; }','',''); +REPLACE INTO `item_db_re` VALUES ('22837','Integer_Time','Integer Time','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','50',NULL,'0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','set TmpRouletteBronze,TmpRouletteBronze + 1;','',''); REPLACE INTO `item_db_re` VALUES ('22838','Something_Candy_Holder','Something Candy Holder','2','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','getrandgroupitem 22838,1;','',''); 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;','',''); -- cgit v1.2.3-60-g2f50