summaryrefslogtreecommitdiff
path: root/sql-files/item_db.sql
diff options
context:
space:
mode:
authorHercules.ws <Hercules@efficiently.awesome>2015-11-22 14:28:03 +0100
committerHerculesWSAPI <Hercules@efficiently.awesome>2015-11-22 14:28:03 +0100
commitbb8205a2b88f42b3d55b9e30d7a30d7113a1789a (patch)
treedc476a6d02e4ec317ff1a9cd0d1b7428316971fb /sql-files/item_db.sql
parentef5711d061b33849e7ce1d82a4fcd68bc50090a3 (diff)
downloadhercules-bb8205a2b88f42b3d55b9e30d7a30d7113a1789a.tar.gz
hercules-bb8205a2b88f42b3d55b9e30d7a30d7113a1789a.tar.bz2
hercules-bb8205a2b88f42b3d55b9e30d7a30d7113a1789a.tar.xz
hercules-bb8205a2b88f42b3d55b9e30d7a30d7113a1789a.zip
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
Diffstat (limited to 'sql-files/item_db.sql')
-rw-r--r--sql-files/item_db.sql18
1 files changed, 9 insertions, 9 deletions
diff --git a/sql-files/item_db.sql b/sql-files/item_db.sql
index b32d43fd9..1ac39234e 100644
--- a/sql-files/item_db.sql
+++ b/sql-files/item_db.sql
@@ -4504,7 +4504,7 @@ REPLACE INTO `item_db` VALUES ('12194','Hometown_Gift','Hometown Gift','2','20',
REPLACE INTO `item_db` VALUES ('12195','Plain_Rice_Cake','Plain Rice Cake','0','20','10','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','percentheal 0,20;','','');
REPLACE INTO `item_db` VALUES ('12196','Hearty_Rice_Cake','Hearty Rice Cake','0','20','10','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','percentheal 50,0;','','');
REPLACE INTO `item_db` VALUES ('12197','Salty_Rice_Cake','Salty Rice Cake','0','20','10','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','percentheal 10,10;','','');
-REPLACE INTO `item_db` VALUES ('12198','Lucky_Rice_Cake','Lucky Rice Cake','2','20','10','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_INCLUK,1200000,21;','','');
+REPLACE INTO `item_db` VALUES ('12198','Lucky_Rice_Cake','Lucky Rice Cake','2','20','10','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_FOOD_LUK,1200000,21;','','');
REPLACE INTO `item_db` VALUES ('12199','Rice_Scroll','Scroll of Magic','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('12200','Event_Cake','X-mas Cake','11','20','10','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','itemskill PR_MAGNIFICAT,3;','','');
REPLACE INTO `item_db` VALUES ('12201','Red_Box_C','Commonplace Red Box','2','20','10','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
@@ -4630,8 +4630,8 @@ REPLACE INTO `item_db` VALUES ('12323','N_Fly_Wing','Novice Fly Wing','11','0','
REPLACE INTO `item_db` VALUES ('12324','N_Butterfly_Wing','Novice Butterfly Wing','11','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','507',NULL,'1',NULL,'0',NULL,'0','itemskill AL_TELEPORT,3;','','');
REPLACE INTO `item_db` VALUES ('12325','N_Magnifier','Novice Magnifier','11','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','507',NULL,'1',NULL,'0',NULL,'0','itemskill MC_IDENTIFY,1;','','');
REPLACE INTO `item_db` VALUES ('12326','J_Firecracker','Large Firecracker','2','2','1','20','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
-REPLACE INTO `item_db` VALUES ('12327','Charm_Of_Luck','Charm Of Luck','2','1000','500','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
-REPLACE INTO `item_db` VALUES ('12328','Charm_Of_Happiness','Charm Of Happiness','2','1800','900','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_INCLUK,3600000,20;','','');
+REPLACE INTO `item_db` VALUES ('12327','Charm_Of_Luck','Charm Of Luck','2','1000','500','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_FOOD_LUK,3600000,20;','','');
+REPLACE INTO `item_db` VALUES ('12328','Charm_Of_Happiness','Charm Of Happiness','2','1800','900','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_FOOD_STR,20000,10; sc_start SC_FOOD_DEX,20000,10; sc_start SC_FOOD_AGI,20000,10; sc_start SC_FOOD_INT,20000,10; sc_start SC_FOOD_VIT,20000,10; sc_start SC_FOOD_LUK,20000,10;','','');
REPLACE INTO `item_db` VALUES ('12329','Recall_MaleGM','Summon Male GameMaster Scroll','2','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','mercenary_create 2000,1800000;','','');
REPLACE INTO `item_db` VALUES ('12330','Recall_FemaleGM','Summon Female GameMaster Scroll','2','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','mercenary_create 2001,1800000;','','');
REPLACE INTO `item_db` VALUES ('12331','Ginseng','Ginseng','0','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','percentheal 6,0;','','');
@@ -4704,7 +4704,7 @@ REPLACE INTO `item_db` VALUES ('12397','Fools_Day_Box2','Gift Box?','11','20','1
REPLACE INTO `item_db` VALUES ('12398','PCBang_Gift_Box','PCBang Gift Box','2','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('12399','Castle_Treasure_Box','Castle Treasure Box','2','20','10','1000','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('12400','Water_Of_Blessing_','Water Of Blessing ','2','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
-REPLACE INTO `item_db` VALUES ('12401','Rune_Kn_Test_Int','Rune Kn Test Int','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_INCINT,300000,40;','','');
+REPLACE INTO `item_db` VALUES ('12401','Rune_Kn_Test_Int','Rune Kn Test Int','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_FOOD_INT,300000,40;','','');
REPLACE INTO `item_db` VALUES ('12402','29Fruit','29Fruit','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('12403','Lucky_Egg_C2','Lucky Egg2','2','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('12404','Acti_Potion','Acti Potion','2','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','','','');
@@ -4738,7 +4738,7 @@ REPLACE INTO `item_db` VALUES ('12431','Minor_Brisket','Minor Stew','2','0','0',
REPLACE INTO `item_db` VALUES ('12432','Siroma_Icetea','Siroma Iced Tea','2','0','0','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_SIROMA_ICE_TEA,300000,20;','','');
REPLACE INTO `item_db` VALUES ('12433','Drocera_Herb_Stew','Drosera Herb Salad','2','0','0','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_DROCERA_HERB_STEAMED,300000,20;','','');
REPLACE INTO `item_db` VALUES ('12434','Petti_Tail_Noodle','Petite Tail Noodles','2','0','0','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_PUTTI_TAILS_NOODLES,300000,20;','','');
-REPLACE INTO `item_db` VALUES ('12435','Black_Thing','Black Mass','2','0','0','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start2 SC_STOMACHACHE,60000,rand(5,10),25;','','');
+REPLACE INTO `item_db` VALUES ('12435','Black_Thing','Black Mass','2','0','0','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_STOMACHACHE,60000,rand(5,10);','','');
REPLACE INTO `item_db` VALUES ('12436','Vitata500','Vitata 500','0','10','5','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start2 SC_VITATA_500,500000,20,5; itemheal 0,200;','','');
REPLACE INTO `item_db` VALUES ('12437','Enrich_Celermine_Juice','Concentrated Ceromain Soup','2','10','5','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_EXTRACT_SALAMINE_JUICE,500000,10;','','');
REPLACE INTO `item_db` VALUES ('12438','F_Giant_Fly_Wing','F Giant Fly Wing','2','2','1','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
@@ -5359,8 +5359,8 @@ REPLACE INTO `item_db` VALUES ('13620','Super_Pet_Egg4','Super Pet Egg 4','2','2
REPLACE INTO `item_db` VALUES ('13621','Greed_Box30','Greed Scroll 30 Box','18','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 14529,30;','','');
REPLACE INTO `item_db` VALUES ('13622','Greed_Box50','Greed Scroll 50 Box','18','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 14529,50;','','');
REPLACE INTO `item_db` VALUES ('13623','Greed_Box100','Greed Scroll 100 Box','18','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 14529,100;','','');
-REPLACE INTO `item_db` VALUES ('13624','Flee_30_Scroll_Box','Evasion Scroll Box','18','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 14530,1;','','');
-REPLACE INTO `item_db` VALUES ('13625','Accuracy_30_Scroll_Box','Concentration Scroll Box','18','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 14531,1;','','');
+REPLACE INTO `item_db` VALUES ('13624','Flee_30_Scroll_Box','Evasion Scroll Box','18','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Flee_30_Scroll,1;','','');
+REPLACE INTO `item_db` VALUES ('13625','Accuracy_30_Scroll_Box','Concentration Scroll Box','18','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Accuracy_30_Scroll,1;','','');
REPLACE INTO `item_db` VALUES ('13626','Super_Card_Pet_Egg_Box1','Super Card Pet Egg Box 1','18','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 13630,1;','','');
REPLACE INTO `item_db` VALUES ('13627','Super_Card_Pet_Egg_Box2','Super Card Pet Egg Box 2','18','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 13631,1;','','');
REPLACE INTO `item_db` VALUES ('13628','Super_Card_Pet_Egg_Box3','Super Card Pet Egg Box 3','18','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 13632,1;','','');
@@ -6057,8 +6057,8 @@ REPLACE INTO `item_db` VALUES ('14526','Oriental_Pastry','Oriental Pastry','2','
REPLACE INTO `item_db` VALUES ('14527','Dun_Tele_Scroll1','Dungeon Teleport Scroll','2','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','callfunc \"F_CashDungeon\",1;','','');
REPLACE INTO `item_db` VALUES ('14528','PVP_Tele_Scroll','PVP Teleport Scroll','2','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('14529','Greed_Scroll','Greed Scroll','11','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'1',NULL,'0',NULL,'0','itemskill BS_GREED,1;','','');
-REPLACE INTO `item_db` VALUES ('14530','Flee_30_Scroll','Evasion Scroll','2','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_INCFLEE,1800000,30;','','');
-REPLACE INTO `item_db` VALUES ('14531','Accuracy_30_Scroll','Concentration Scroll','2','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_INCHIT,1800000,30;','','');
+REPLACE INTO `item_db` VALUES ('14530','Flee_30_Scroll','Evasion Scroll','2','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_FOOD_BASICAVOIDANCE,1800000,30;','','');
+REPLACE INTO `item_db` VALUES ('14531','Accuracy_30_Scroll','Concentration Scroll','2','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_FOOD_BASICHIT,1800000,30;','','');
REPLACE INTO `item_db` VALUES ('14532','Battle_Manual25','Field Manual 25%','2','2','1','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'1',NULL,'0',NULL,'0','sc_start SC_CASH_PLUSEXP,1800000,25;','','');
REPLACE INTO `item_db` VALUES ('14533','Battle_Manual100','Field Manual 100%','2','2','1','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','sc_start SC_CASH_PLUSEXP,1800000,100;','','');
REPLACE INTO `item_db` VALUES ('14534','Small_Life_Potion','Small Life Potion','2','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','specialeffect2 320; sc_start4 SC_S_LIFEPOTION,600000,-5,5,0,0;','','');