diff options
author | Hercules.ws <Hercules@efficiently.awesome> | 2014-09-20 15:25:15 +0200 |
---|---|---|
committer | HerculesWSAPI <Hercules@efficiently.awesome> | 2014-09-20 15:25:15 +0200 |
commit | 1c1e10a5804ccde4daddd59d2f5d9916aa0d26db (patch) | |
tree | c2d28c04fad41d67259408d8d9bd5f10bb986cea /sql-files | |
parent | b0006317e5cc4a48cd5b8a501b94813cd3b93670 (diff) | |
download | hercules-1c1e10a5804ccde4daddd59d2f5d9916aa0d26db.tar.gz hercules-1c1e10a5804ccde4daddd59d2f5d9916aa0d26db.tar.bz2 hercules-1c1e10a5804ccde4daddd59d2f5d9916aa0d26db.tar.xz hercules-1c1e10a5804ccde4daddd59d2f5d9916aa0d26db.zip |
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
Diffstat (limited to 'sql-files')
-rw-r--r-- | sql-files/item_db.sql | 34 | ||||
-rw-r--r-- | sql-files/item_db_re.sql | 34 |
2 files changed, 34 insertions, 34 deletions
diff --git a/sql-files/item_db.sql b/sql-files/item_db.sql index e87148367..cb5d41c7d 100644 --- a/sql-files/item_db.sql +++ b/sql-files/item_db.sql @@ -79,7 +79,7 @@ REPLACE INTO `item_db` VALUES ('532','Banana_Juice','Banana Juice','0','20','10' REPLACE INTO `item_db` VALUES ('533','Grape_Juice','Grape Juice','0','250','125','40','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal 0,rand(15,25);','',''); REPLACE INTO `item_db` VALUES ('534','Carrot_Juice','Carrot Juice','0','20','10','40','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(27,33),0;','',''); REPLACE INTO `item_db` VALUES ('535','Pumpkin','Pumpkin','0','15','7','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','itemheal 19,0;','',''); -REPLACE INTO `item_db` VALUES ('536','Ice_Cream','Ice Cream','0','150','75','80','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(105,145),0; sc_start SC_FREEZE,10000,0,2500,0;','',''); +REPLACE INTO `item_db` VALUES ('536','Ice_Cream','Ice Cream','0','150','75','80','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(105,145),0; sc_start SC_FREEZE,10000,0,2500,SCFLAG_NONE;','',''); REPLACE INTO `item_db` VALUES ('537','Pet_Food','Pet Food','0','1000','500','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(50,90),0;','',''); REPLACE INTO `item_db` VALUES ('538','Well_Baked_Cookie','Well-baked Cookie','0','1000','500','30','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(160,200),0;','',''); REPLACE INTO `item_db` VALUES ('539','Piece_Of_Cake','Piece of Cake','0','3000','1500','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','itemheal rand(270,330),0;','',''); @@ -90,12 +90,12 @@ REPLACE INTO `item_db` VALUES ('545','Red_Slim_Potion','Condensed Red Potion','0 REPLACE INTO `item_db` VALUES ('546','Yellow_Slim_Potion','Condensed Yellow Potion','0','600','300','30','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(175,235),0;','',''); REPLACE INTO `item_db` VALUES ('547','White_Slim_Potion','Condensed White Potion','0','1650','825','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(325,405),0;','',''); REPLACE INTO `item_db` VALUES ('548','Cheese','Cheese','0','2800','1400','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal 0,rand(10,15);','',''); -REPLACE INTO `item_db` VALUES ('549','Nice_Sweet_Potato','Yam','0','180','90','80','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(50,100),0; sc_start SC_STUN,3000,0,1500,0;','',''); +REPLACE INTO `item_db` VALUES ('549','Nice_Sweet_Potato','Yam','0','180','90','80','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(50,100),0; sc_start SC_STUN,3000,0,1500,SCFLAG_NONE;','',''); REPLACE INTO `item_db` VALUES ('550','Popped_Rice','Rice Cake','0','10','5','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(10,15),0;','',''); REPLACE INTO `item_db` VALUES ('551','Shusi','Sushi','0','1','0','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(50,60),0;','',''); REPLACE INTO `item_db` VALUES ('552','KETUPAT','Ketupat','0','1','0','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','itemheal rand(70,90),rand(20,30);','',''); REPLACE INTO `item_db` VALUES ('553','Bun','Bao','0','1','0','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(35,70),0;','',''); -REPLACE INTO `item_db` VALUES ('554','Mojji','Mochi','0','400','200','80','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(105,145),0; sc_start SC_STUN,3000,0; sc_start SC_BLIND,2000,0,1500,0;','',''); +REPLACE INTO `item_db` VALUES ('554','Mojji','Mochi','0','400','200','80','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(105,145),0; sc_start SC_STUN,3000,0; sc_start SC_BLIND,2000,0,1500,SCFLAG_NONE;','',''); REPLACE INTO `item_db` VALUES ('555','Rice_Cake','Traditional Rice Cake','0','100','50','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','itemheal rand(105,145),0;','',''); REPLACE INTO `item_db` VALUES ('556','Long_Rice_Cake','Rice Cake Stick','0','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','itemheal rand(20,25),0;','',''); REPLACE INTO `item_db` VALUES ('557','Hash_Rice_Cake','Neatly Sliced Rice Cake','0','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','itemheal rand(25,30),0;','',''); @@ -209,7 +209,7 @@ REPLACE INTO `item_db` VALUES ('675','Silver_Coin','Silver Coin','3','5000','250 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;','',''); -REPLACE INTO `item_db` VALUES ('679','Gold_Pill','Pilule','2','5000','2500','300','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_DPOISON,10000,0,1000,0; sc_start SC_POISON,50000,0;','',''); +REPLACE INTO `item_db` VALUES ('679','Gold_Pill','Pilule','2','5000','2500','300','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_DPOISON,10000,0,1000,SCFLAG_NONE; sc_start SC_POISON,50000,0;','',''); REPLACE INTO `item_db` VALUES ('680','Magical_Carnation','Magic Carnation','0','0','0','1000','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','percentheal 0,20;','',''); REPLACE INTO `item_db` VALUES ('681','Memory_Of_Wedding','Sweet Memory of Marriage','2','50000','25000','10','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(getpartnerid()) sc_start SC_WEDDING,600000,0;','',''); REPLACE INTO `item_db` VALUES ('682','Realgar_Wine','Distilled Fighting Spirit','2','0','0','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','sc_start SC_PLUSATTACKPOWER,60000,30;','',''); @@ -4332,14 +4332,14 @@ REPLACE INTO `item_db` VALUES ('12023','Giftbox_China','Wrapped Box','2','1000', REPLACE INTO `item_db` VALUES ('12024','Red_Pouch_Of_Surprise','Red Pouch','2','50','25','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','monster \"this\",-1,-1,\"--ja--\",-4,1,\"\";','',''); REPLACE INTO `item_db` VALUES ('12025','Egg_Boy','Dano Festival Egg','2','1000','500','200','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 12025,1;','',''); REPLACE INTO `item_db` VALUES ('12026','Egg_Girl','Dano Festival Egg','2','1000','500','200','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 12026,1;','',''); -REPLACE INTO `item_db` VALUES ('12027','Giggling_Box','Giggling Box','2','1000','500','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','percentheal 9,0; sc_start SC_CURSE,30000,0,3000,0;','',''); +REPLACE INTO `item_db` VALUES ('12027','Giggling_Box','Giggling Box','2','1000','500','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','percentheal 9,0; sc_start SC_CURSE,30000,0,3000,SCFLAG_NONE;','',''); REPLACE INTO `item_db` VALUES ('12028','Box_Of_Thunder','Box of Thunder','2','1000','500','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','sc_start SC_MOVHASTE_HORSE,20000,0;','',''); REPLACE INTO `item_db` VALUES ('12029','Gloomy_Box','Box of Gloom','11','1000','500','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','itemskill AC_CONCENTRATION,1;','',''); REPLACE INTO `item_db` VALUES ('12030','Box_Of_Grudge','Box of Resentment','2','1000','500','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','sc_start SC_PLUSATTACKPOWER,60000,20;','',''); REPLACE INTO `item_db` VALUES ('12031','Sleepy_Box','Box of Drowsiness','2','1000','500','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','sc_start SC_PLUSMAGICPOWER,60000,20;','',''); REPLACE INTO `item_db` VALUES ('12032','Box_Of_Storm','Box of Storms','11','1000','500','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','itemskill ITEM_ENCHANTARMS,2;','',''); REPLACE INTO `item_db` VALUES ('12033','Box_Of_Sunlight','Box of Sunlight','2','1000','500','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','sc_start SC_CLAIRVOYANCE,30000,0;','',''); -REPLACE INTO `item_db` VALUES ('12034','Painting_Box','Box of Panting','2','1000','500','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','percentheal 0,9; sc_start SC_SILENCE,30000,0,3000,0;','',''); +REPLACE INTO `item_db` VALUES ('12034','Painting_Box','Box of Panting','2','1000','500','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','percentheal 0,9; sc_start SC_SILENCE,30000,0,3000,SCFLAG_NONE;','',''); REPLACE INTO `item_db` VALUES ('12035','Lotto_Box01','Lotto Box 01','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 12035,1;','',''); REPLACE INTO `item_db` VALUES ('12036','Lotto_Box02','Lotto Box 02','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 12036,1;','',''); REPLACE INTO `item_db` VALUES ('12037','Lotto_Box03','Lotto Box 03','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 12037,1;','',''); @@ -4440,7 +4440,7 @@ REPLACE INTO `item_db` VALUES ('12131','Lucky_Potion','Lucky Potion','0','2','1' REPLACE INTO `item_db` VALUES ('12132','Red_Bag','Santa\'s Bag','2','0','0','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_XMAS,600000,0;','',''); REPLACE INTO `item_db` VALUES ('12133','Ice_Cream_','McDonald\'s Ice Cone','0','0','0','80','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if(gettime(5)!=MDiceCone) { set MDiceCone,gettime(5); percentheal 50,50; }','',''); REPLACE INTO `item_db` VALUES ('12134','Red_Envelope','Red Envelope','2','1','0','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','set Zeny,Zeny+rand(1000,10000);','',''); -REPLACE INTO `item_db` VALUES ('12135','Green_Ale','Green Ale','2','20','10','30','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','percentheal 50,50; sc_start SC_CONFUSION,10000,0,1000,0;','',''); +REPLACE INTO `item_db` VALUES ('12135','Green_Ale','Green Ale','2','20','10','30','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','percentheal 50,50; sc_start SC_CONFUSION,10000,0,1000,SCFLAG_NONE;','',''); REPLACE INTO `item_db` VALUES ('12136','Women\'s_Bundle','Women\'s Bundle','2','0','0','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem callfunc(\"F_RandMes\",4,558,529,2668,7518),1;','',''); REPLACE INTO `item_db` VALUES ('12137','1st_Stage_Prize','First Stage Prize','2','0','0','0','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 ('12138','2nd_Stage_Prize','Second Stage Prize','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); @@ -4540,8 +4540,8 @@ REPLACE INTO `item_db` VALUES ('12234','Cacao99','Fierce Cacao 99%','0','20','10 REPLACE INTO `item_db` VALUES ('12235','Strawberry_Choco','Chocolate Strawberry','2','20','10','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'1',NULL,'0',NULL,'0','percentheal 0,5; skilleffect AL_BLESSING,0; sc_start SC_BLESSING,240000,10;','',''); REPLACE INTO `item_db` VALUES ('12236','Choco_Tart','Chocolate Tart','11','20','10','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'1',NULL,'0',NULL,'0','percentheal 5,0; itemskill AL_ANGELUS,5;','',''); REPLACE INTO `item_db` VALUES ('12237','Choco_Lump','Junky Chocolate','2','0','0','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'1',NULL,'0',NULL,'0','percentheal 0,5; sc_start SC_POISON,18000,0; sc_start SC_BLOODING,18000,0;','',''); -REPLACE INTO `item_db` VALUES ('12238','New_Year_Rice_Cake_1','New Year Rice Cake','2','20','10','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_DPOISON,10000,0,1000,0; sc_start SC_POISON,50000,0;','',''); -REPLACE INTO `item_db` VALUES ('12239','New_Year_Rice_Cake_2','New Year Rice Cake','2','20','10','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_DPOISON,10000,0,1000,0; sc_start SC_POISON,50000,0;','',''); +REPLACE INTO `item_db` VALUES ('12238','New_Year_Rice_Cake_1','New Year Rice Cake','2','20','10','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_DPOISON,10000,0,1000,SCFLAG_NONE; sc_start SC_POISON,50000,0;','',''); +REPLACE INTO `item_db` VALUES ('12239','New_Year_Rice_Cake_2','New Year Rice Cake','2','20','10','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_DPOISON,10000,0,1000,SCFLAG_NONE; sc_start SC_POISON,50000,0;','',''); REPLACE INTO `item_db` VALUES ('12240','Old_Yellow_Box','Old Yellow Box','2','20','10','200','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 12240,1;','',''); REPLACE INTO `item_db` VALUES ('12241','M_Center_Potion','Mercenary Concentration Potion','2','800','400','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','mercenary_sc_start SC_ATTHASTE_POTION1,1800000,0;','',''); REPLACE INTO `item_db` VALUES ('12242','M_Awakening_Potion','Mercenary Awakening Potion','2','1500','750','150','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','mercenary_sc_start SC_ATTHASTE_POTION2,1800000,0;','',''); @@ -4898,14 +4898,14 @@ REPLACE INTO `item_db` VALUES ('12713','Monster_Extract','Monster Extract','2',' REPLACE INTO `item_db` VALUES ('12714','Easter_Scroll','Easter Scroll','2','1','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','467',NULL,'0',NULL,'0',NULL,'0','getrandgroupitem 12714,1;','',''); REPLACE INTO `item_db` VALUES ('12715','Black_Treasure_Box','Black Treasure Box','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','','',''); REPLACE INTO `item_db` VALUES ('12716','Indian_Rice_Cake','Indian Rice Cake','2','0','0','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 ('12717','Poison_Paralysis','Paralyze','0','2','1','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','sc_start SC_PARALYSE,300000,0,10,2;','',''); -REPLACE INTO `item_db` VALUES ('12718','Poison_Leech','Leech End','0','2','1','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','sc_start SC_LEECHESEND,300000,0,10,2;','',''); -REPLACE INTO `item_db` VALUES ('12719','Poison_Oblivion','Oblivion Curse','0','2','1','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','sc_start SC_OBLIVIONCURSE,300000,0,10,2;','',''); -REPLACE INTO `item_db` VALUES ('12720','Poison_Contamination','Disheart','0','2','1','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','sc_start SC_DEATHHURT,300000,0,10,2;','',''); -REPLACE INTO `item_db` VALUES ('12721','Poison_Numb','Toxin','0','2','1','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','sc_start SC_TOXIN,300000,0,10,2;','',''); -REPLACE INTO `item_db` VALUES ('12722','Poison_Fever','Pyrexia','0','2','1','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','sc_start SC_PYREXIA,300000,0,10,2;','',''); -REPLACE INTO `item_db` VALUES ('12723','Poison_Laughing','Magic Mushroom','0','2','1','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','sc_start SC_MAGICMUSHROOM,300000,0,10,2;','',''); -REPLACE INTO `item_db` VALUES ('12724','Poison_Fatigue','Venom Bleed','0','2','1','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','sc_start SC_VENOMBLEED,15000,0,10,2;','',''); +REPLACE INTO `item_db` VALUES ('12717','Poison_Paralysis','Paralyze','0','2','1','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','sc_start SC_PARALYSE,300000,0,10,SCFLAG_FIXEDTICK;','',''); +REPLACE INTO `item_db` VALUES ('12718','Poison_Leech','Leech End','0','2','1','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','sc_start SC_LEECHESEND,300000,0,10,SCFLAG_FIXEDTICK;','',''); +REPLACE INTO `item_db` VALUES ('12719','Poison_Oblivion','Oblivion Curse','0','2','1','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','sc_start SC_OBLIVIONCURSE,300000,0,10,SCFLAG_FIXEDTICK;','',''); +REPLACE INTO `item_db` VALUES ('12720','Poison_Contamination','Disheart','0','2','1','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','sc_start SC_DEATHHURT,300000,0,10,SCFLAG_FIXEDTICK;','',''); +REPLACE INTO `item_db` VALUES ('12721','Poison_Numb','Toxin','0','2','1','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','sc_start SC_TOXIN,300000,0,10,SCFLAG_FIXEDTICK;','',''); +REPLACE INTO `item_db` VALUES ('12722','Poison_Fever','Pyrexia','0','2','1','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','sc_start SC_PYREXIA,300000,0,10,SCFLAG_FIXEDTICK;','',''); +REPLACE INTO `item_db` VALUES ('12723','Poison_Laughing','Magic Mushroom','0','2','1','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','sc_start SC_MAGICMUSHROOM,300000,0,10,SCFLAG_FIXEDTICK;','',''); +REPLACE INTO `item_db` VALUES ('12724','Poison_Fatigue','Venom Bleed','0','2','1','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','sc_start SC_VENOMBLEED,15000,0,10,SCFLAG_FIXEDTICK;','',''); REPLACE INTO `item_db` VALUES ('12725','Runstone_Nosiege','Nauthiz Rune','11','100','50','100','0','0','0','0','0','4294967295','8','2','0','0','0',NULL,'0','0','0','0','120000','475',NULL,'1',NULL,'20','1','0','itemskill RK_REFRESH,1;','',''); REPLACE INTO `item_db` VALUES ('12726','Runstone_Rhydo','Raido Rune','11','100','50','100','0','0','0','0','0','4294967295','8','2','0','0','0',NULL,'0','0','0','0','30000','475',NULL,'1',NULL,'20','1','0','itemskill RK_CRUSHSTRIKE,1;','',''); REPLACE INTO `item_db` VALUES ('12727','Runstone_Verkana','Berkana Rune','11','100','50','100','0','0','0','0','0','4294967295','8','2','0','0','0',NULL,'0','0','0','0','60000','475',NULL,'1',NULL,'20','1','0','itemskill RK_MILLENNIUMSHIELD,1;','',''); diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql index 1d65eb17a..ac7ecd0fb 100644 --- a/sql-files/item_db_re.sql +++ b/sql-files/item_db_re.sql @@ -79,7 +79,7 @@ REPLACE INTO `item_db_re` VALUES ('532','Banana_Juice','Banana Juice','0','20',' REPLACE INTO `item_db_re` VALUES ('533','Grape_Juice','Grape Juice','0','250','125','40','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal 0,rand(15,25);','',''); REPLACE INTO `item_db_re` VALUES ('534','Carrot_Juice','Carrot Juice','0','20','10','40','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(27,33),0;','',''); REPLACE INTO `item_db_re` VALUES ('535','Pumpkin','Pumpkin','0','15','7','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','itemheal 19,0;','',''); -REPLACE INTO `item_db_re` VALUES ('536','Ice_Cream','Ice Cream','0','150','75','80','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(105,145),0; sc_start SC_FREEZE,10000,0,2500,0;','',''); +REPLACE INTO `item_db_re` VALUES ('536','Ice_Cream','Ice Cream','0','150','75','80','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(105,145),0; sc_start SC_FREEZE,10000,0,2500,SCFLAG_NONE;','',''); REPLACE INTO `item_db_re` VALUES ('537','Pet_Food','Pet Food','0','1000','500','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(50,90),0;','',''); REPLACE INTO `item_db_re` VALUES ('538','Well_Baked_Cookie','Well-baked Cookie','0','1000','500','30','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(160,200),0;','',''); REPLACE INTO `item_db_re` VALUES ('539','Piece_Of_Cake','Piece of Cake','0','3000','1500','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','itemheal rand(270,330),0;','',''); @@ -92,12 +92,12 @@ REPLACE INTO `item_db_re` VALUES ('545','Red_Slim_Potion','Condensed Red Potion' REPLACE INTO `item_db_re` VALUES ('546','Yellow_Slim_Potion','Condensed Yellow Potion','0','600','300','30','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(175,235),0;','',''); REPLACE INTO `item_db_re` VALUES ('547','White_Slim_Potion','Condensed White Potion','0','1650','825','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(325,405),0;','',''); REPLACE INTO `item_db_re` VALUES ('548','Cheese','Cheese','0','2800','1400','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal 0,rand(10,15);','',''); -REPLACE INTO `item_db_re` VALUES ('549','Nice_Sweet_Potato','Yam','0','180','90','80','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(50,100),0; sc_start SC_STUN,3000,0,1500,0;','',''); +REPLACE INTO `item_db_re` VALUES ('549','Nice_Sweet_Potato','Yam','0','180','90','80','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(50,100),0; sc_start SC_STUN,3000,0,1500,SCFLAG_NONE;','',''); REPLACE INTO `item_db_re` VALUES ('550','Popped_Rice','Rice Cake','0','10','5','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(10,15),0;','',''); REPLACE INTO `item_db_re` VALUES ('551','Shusi','Sushi','0','1','0','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(50,60),0;','',''); REPLACE INTO `item_db_re` VALUES ('552','KETUPAT','Ketupat','0','1','0','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','itemheal rand(70,90),rand(20,30);','',''); REPLACE INTO `item_db_re` VALUES ('553','Bun','Bao','0','1','0','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(35,70),0;','',''); -REPLACE INTO `item_db_re` VALUES ('554','Mojji','Mochi','0','100','50','80','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(105,145),0; sc_start SC_STUN,3000,0; sc_start SC_BLIND,2000,0,1500,0;','',''); +REPLACE INTO `item_db_re` VALUES ('554','Mojji','Mochi','0','100','50','80','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(105,145),0; sc_start SC_STUN,3000,0; sc_start SC_BLIND,2000,0,1500,SCFLAG_NONE;','',''); REPLACE INTO `item_db_re` VALUES ('555','Rice_Cake','Traditional Rice Cake','0','100','50','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','itemheal rand(105,145),0;','',''); REPLACE INTO `item_db_re` VALUES ('556','Long_Rice_Cake','Rice Cake Stick','0','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','itemheal rand(20,25),0;','',''); REPLACE INTO `item_db_re` VALUES ('557','Hash_Rice_Cake','Neatly Sliced Rice Cake','0','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','itemheal rand(25,30),0;','',''); @@ -211,7 +211,7 @@ REPLACE INTO `item_db_re` VALUES ('675','Silver_Coin','Silver Coin','3','5000',' 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;','',''); -REPLACE INTO `item_db_re` VALUES ('679','Gold_Pill','Pilule','2','5000','2500','300','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_DPOISON,10000,0,1000,0; sc_start SC_POISON,50000,0;','',''); +REPLACE INTO `item_db_re` VALUES ('679','Gold_Pill','Pilule','2','5000','2500','300','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_DPOISON,10000,0,1000,SCFLAG_NONE; sc_start SC_POISON,50000,0;','',''); REPLACE INTO `item_db_re` VALUES ('680','Magical_Carnation','Magic Carnation','0','0','0','1000','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','percentheal 0,20;','',''); REPLACE INTO `item_db_re` VALUES ('681','Memory_Of_Wedding','Sweet Memory of Marriage','2','50000','25000','10','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 (getpartnerid()) sc_start SC_WEDDING,600000,0;','',''); REPLACE INTO `item_db_re` VALUES ('682','Realgar_Wine','Distilled Fighting Spirit','2','0','0','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','sc_start SC_PLUSATTACKPOWER,60000,30;','',''); @@ -5338,14 +5338,14 @@ REPLACE INTO `item_db_re` VALUES ('12023','Giftbox_China','Wrapped Box','2','100 REPLACE INTO `item_db_re` VALUES ('12024','Red_Pouch_Of_Surprise','Red Pouch','2','50','25','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','monster \"this\",-1,-1,\"--ja--\",-4,1,\"\";','',''); REPLACE INTO `item_db_re` VALUES ('12025','Egg_Boy','Dano Festival Egg','2','1000','500','200','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 12025,1;','',''); REPLACE INTO `item_db_re` VALUES ('12026','Egg_Girl','Dano Festival Egg','2','1000','500','200','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 12026,1;','',''); -REPLACE INTO `item_db_re` VALUES ('12027','Giggling_Box','Giggling Box','2','1000','500','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','percentheal 9,0; sc_start SC_CURSE,30000,0,3000,0;','',''); +REPLACE INTO `item_db_re` VALUES ('12027','Giggling_Box','Giggling Box','2','1000','500','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','percentheal 9,0; sc_start SC_CURSE,30000,0,3000,SCFLAG_NONE;','',''); REPLACE INTO `item_db_re` VALUES ('12028','Box_Of_Thunder','Box of Thunder','2','1000','500','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','sc_start SC_MOVHASTE_HORSE,20000,0;','',''); REPLACE INTO `item_db_re` VALUES ('12029','Gloomy_Box','Box of Gloom','11','1000','500','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','itemskill AC_CONCENTRATION,1;','',''); REPLACE INTO `item_db_re` VALUES ('12030','Box_Of_Grudge','Box of Resentment','2','1000','500','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','sc_start SC_PLUSATTACKPOWER,60000,20;','',''); REPLACE INTO `item_db_re` VALUES ('12031','Sleepy_Box','Box of Drowsiness','2','1000','500','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','sc_start SC_PLUSMAGICPOWER,60000,20;','',''); REPLACE INTO `item_db_re` VALUES ('12032','Box_Of_Storm','Box of Storms','11','1000','500','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','itemskill ITEM_ENCHANTARMS,2;','',''); REPLACE INTO `item_db_re` VALUES ('12033','Box_Of_Sunlight','Box of Sunlight','2','1000','500','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','sc_start SC_CLAIRVOYANCE,30000,0;','',''); -REPLACE INTO `item_db_re` VALUES ('12034','Painting_Box','Box of Panting','2','1000','500','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','percentheal 0,9; sc_start SC_SILENCE,30000,0,3000,0;','',''); +REPLACE INTO `item_db_re` VALUES ('12034','Painting_Box','Box of Panting','2','1000','500','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','percentheal 0,9; sc_start SC_SILENCE,30000,0,3000,SCFLAG_NONE;','',''); REPLACE INTO `item_db_re` VALUES ('12035','Lotto_Box01','Lotto Box 01','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 12035,1;','',''); REPLACE INTO `item_db_re` VALUES ('12036','Lotto_Box02','Lotto Box 02','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 12036,1;','',''); REPLACE INTO `item_db_re` VALUES ('12037','Lotto_Box03','Lotto Box 03','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 12037,1;','',''); @@ -5446,7 +5446,7 @@ REPLACE INTO `item_db_re` VALUES ('12131','Lucky_Potion','Lucky Potion','0','2', REPLACE INTO `item_db_re` VALUES ('12132','Red_Bag','Santa\'s Bag','2','0','0','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_XMAS,600000,0;','',''); REPLACE INTO `item_db_re` VALUES ('12133','Ice_Cream_','McDonald\'s Ice Cone','0','0','0','80','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if(gettime(5)!=MDiceCone) { set MDiceCone,gettime(5); percentheal 50,50; }','',''); REPLACE INTO `item_db_re` VALUES ('12134','Red_Envelope','Red Envelope','2','1','0','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','set Zeny,Zeny+rand(1000,10000);','',''); -REPLACE INTO `item_db_re` VALUES ('12135','Green_Ale','Green Ale','2','20','10','30','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','percentheal 50,50; sc_start SC_CONFUSION,10000,0,1000,0;','',''); +REPLACE INTO `item_db_re` VALUES ('12135','Green_Ale','Green Ale','2','20','10','30','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','percentheal 50,50; sc_start SC_CONFUSION,10000,0,1000,SCFLAG_NONE;','',''); REPLACE INTO `item_db_re` VALUES ('12136','Women\'s_Bundle','Women\'s Bundle','2','0','0','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem callfunc(\"F_RandMes\",4,558,529,2668,7518),1;','',''); REPLACE INTO `item_db_re` VALUES ('12137','1st_Stage_Prize','First Stage Prize','2','0','0','0','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 ('12138','2nd_Stage_Prize','Second Stage Prize','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); @@ -5546,8 +5546,8 @@ REPLACE INTO `item_db_re` VALUES ('12234','Cacao99','Fierce Cacao 99%','0','20', REPLACE INTO `item_db_re` VALUES ('12235','Strawberry_Choco','Chocolate Strawberry','2','20','10','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'1',NULL,'0',NULL,'0','percentheal 0,5; skilleffect AL_BLESSING,0; sc_start SC_BLESSING,240000,10;','',''); REPLACE INTO `item_db_re` VALUES ('12236','Choco_Tart','Chocolate Tart','11','20','10','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'1',NULL,'0',NULL,'0','percentheal 5,0; itemskill AL_ANGELUS,5;','',''); REPLACE INTO `item_db_re` VALUES ('12237','Choco_Lump','Junky Chocolate','2','0','0','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'1',NULL,'0',NULL,'0','percentheal 0,5; sc_start SC_POISON,18000,0; sc_start SC_BLOODING,18000,0;','',''); -REPLACE INTO `item_db_re` VALUES ('12238','New_Year_Rice_Cake_1','New Year Rice Cake','2','20','10','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_DPOISON,10000,0,1000,0; sc_start SC_POISON,50000,0;','',''); -REPLACE INTO `item_db_re` VALUES ('12239','New_Year_Rice_Cake_2','New Year Rice Cake','2','20','10','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_DPOISON,10000,0,1000,0; sc_start SC_POISON,50000,0;','',''); +REPLACE INTO `item_db_re` VALUES ('12238','New_Year_Rice_Cake_1','New Year Rice Cake','2','20','10','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_DPOISON,10000,0,1000,SCFLAG_NONE; sc_start SC_POISON,50000,0;','',''); +REPLACE INTO `item_db_re` VALUES ('12239','New_Year_Rice_Cake_2','New Year Rice Cake','2','20','10','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_DPOISON,10000,0,1000,SCFLAG_NONE; sc_start SC_POISON,50000,0;','',''); REPLACE INTO `item_db_re` VALUES ('12240','Old_Yellow_Box','Old Yellow Box','2','20','10','200','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 12240,1;','',''); REPLACE INTO `item_db_re` VALUES ('12241','M_Center_Potion','Mercenary Concentration Potion','2','800','400','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','mercenary_sc_start SC_ATTHASTE_POTION1,1800000,0;','',''); REPLACE INTO `item_db_re` VALUES ('12242','M_Awakening_Potion','Mercenary Awakening Potion','2','1500','750','150','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','mercenary_sc_start SC_ATTHASTE_POTION2,1800000,0;','',''); @@ -6013,14 +6013,14 @@ REPLACE INTO `item_db_re` VALUES ('12713','Monster_Extract','Monster Extract','2 REPLACE INTO `item_db_re` VALUES ('12714','Easter_Scroll','Easter Scroll','2','1','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','467',NULL,'0',NULL,'0',NULL,'0','getrandgroupitem 12714,1;','',''); REPLACE INTO `item_db_re` VALUES ('12715','Black_Treasure_Box','Black Treasure Chest','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','','',''); REPLACE INTO `item_db_re` VALUES ('12716','Indian_Rice_Cake','Indian Rice Cake','2','0','0','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_re` VALUES ('12717','Poison_Paralysis','Paralysis','0','2','1','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','sc_start SC_PARALYSE,300000,0,10,2;','',''); -REPLACE INTO `item_db_re` VALUES ('12718','Poison_Leech','Leech End','0','2','1','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','sc_start SC_LEECHESEND,300000,0,10,2;','',''); -REPLACE INTO `item_db_re` VALUES ('12719','Poison_Oblivion','Oblivion Curse','0','2','1','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','sc_start SC_OBLIVIONCURSE,300000,0,10,2;','',''); -REPLACE INTO `item_db_re` VALUES ('12720','Poison_Contamination','Death Hurt','0','2','1','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','sc_start SC_DEATHHURT,300000,0,10,2;','',''); -REPLACE INTO `item_db_re` VALUES ('12721','Poison_Numb','Toxin','0','2','1','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','sc_start SC_TOXIN,300000,0,10,2;','',''); -REPLACE INTO `item_db_re` VALUES ('12722','Poison_Fever','Pyrexia','0','2','1','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','sc_start SC_PYREXIA,300000,0,10,2;','',''); -REPLACE INTO `item_db_re` VALUES ('12723','Poison_Laughing','Magic Mushroom','0','2','1','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','sc_start SC_MAGICMUSHROOM,300000,0,10,2;','',''); -REPLACE INTO `item_db_re` VALUES ('12724','Poison_Fatigue','Venom Bleed','0','2','1','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','sc_start SC_VENOMBLEED,15000,0,10,2;','',''); +REPLACE INTO `item_db_re` VALUES ('12717','Poison_Paralysis','Paralysis','0','2','1','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','sc_start SC_PARALYSE,300000,0,10,SCFLAG_FIXEDTICK;','',''); +REPLACE INTO `item_db_re` VALUES ('12718','Poison_Leech','Leech End','0','2','1','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','sc_start SC_LEECHESEND,300000,0,10,SCFLAG_FIXEDTICK;','',''); +REPLACE INTO `item_db_re` VALUES ('12719','Poison_Oblivion','Oblivion Curse','0','2','1','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','sc_start SC_OBLIVIONCURSE,300000,0,10,SCFLAG_FIXEDTICK;','',''); +REPLACE INTO `item_db_re` VALUES ('12720','Poison_Contamination','Death Hurt','0','2','1','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','sc_start SC_DEATHHURT,300000,0,10,SCFLAG_FIXEDTICK;','',''); +REPLACE INTO `item_db_re` VALUES ('12721','Poison_Numb','Toxin','0','2','1','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','sc_start SC_TOXIN,300000,0,10,SCFLAG_FIXEDTICK;','',''); +REPLACE INTO `item_db_re` VALUES ('12722','Poison_Fever','Pyrexia','0','2','1','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','sc_start SC_PYREXIA,300000,0,10,SCFLAG_FIXEDTICK;','',''); +REPLACE INTO `item_db_re` VALUES ('12723','Poison_Laughing','Magic Mushroom','0','2','1','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','sc_start SC_MAGICMUSHROOM,300000,0,10,SCFLAG_FIXEDTICK;','',''); +REPLACE INTO `item_db_re` VALUES ('12724','Poison_Fatigue','Venom Bleed','0','2','1','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','sc_start SC_VENOMBLEED,15000,0,10,SCFLAG_FIXEDTICK;','',''); REPLACE INTO `item_db_re` VALUES ('12725','Runstone_Nosiege','Nosiege Runestone','11','2','1','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','120000','475',NULL,'1',NULL,'20','1','0','itemskill RK_REFRESH,1;','',''); REPLACE INTO `item_db_re` VALUES ('12726','Runstone_Rhydo','Rhydo Runestone','11','2','1','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','30000','475',NULL,'1',NULL,'20','1','0','itemskill RK_CRUSHSTRIKE,1;','',''); REPLACE INTO `item_db_re` VALUES ('12727','Runstone_Verkana','Verkana Runestone','11','2','1','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','60000','475',NULL,'1',NULL,'20','1','0','itemskill RK_MILLENNIUMSHIELD,1;','',''); |