summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
authorHercules.ws <Hercules@efficiently.awesome>2015-04-06 15:38:03 +0200
committerHerculesWSAPI <Hercules@efficiently.awesome>2015-04-06 15:38:03 +0200
commit4294ba882c66d6cb6b41a6e82130b4c4e3daf909 (patch)
treecf1948fe593f421441625b2a348ae283b3e33c06 /sql-files
parent565ab0cd0f6c5e1dac89894fba92d4b7b7e043dc (diff)
downloadhercules-4294ba882c66d6cb6b41a6e82130b4c4e3daf909.tar.gz
hercules-4294ba882c66d6cb6b41a6e82130b4c4e3daf909.tar.bz2
hercules-4294ba882c66d6cb6b41a6e82130b4c4e3daf909.tar.xz
hercules-4294ba882c66d6cb6b41a6e82130b4c4e3daf909.zip
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/item_db_re.sql14
1 files changed, 7 insertions, 7 deletions
diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql
index 9359cdac7..61b4dee1b 100644
--- a/sql-files/item_db_re.sql
+++ b/sql-files/item_db_re.sql
@@ -5620,7 +5620,7 @@ REPLACE INTO `item_db` VALUES ('12187','Green_Box','Old Green Box','2','50000','
REPLACE INTO `item_db` VALUES ('12188','Magical_Moon_Cake','Grace Moon Cake','0','20','10','300','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;','','');
REPLACE INTO `item_db` VALUES ('12189','Red_Box_','Old Red Box','2','50000','25000','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 12189,1;','','');
REPLACE INTO `item_db` VALUES ('12190','Moon_Cake','Moon Cake','2','2','1','300','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 ('12191','Special_Moon_Cake','Special Moon Cake','2','2','1','500','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_ASPDPOTION0,600000,4; sc_start SC_SpeedUp0,600000,0;','','');
+REPLACE INTO `item_db` VALUES ('12191','Special_Moon_Cake','Special Moon Cake','2','2','1','500','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_ATTHASTE_POTION1,600000,4; sc_start SC_MOVHASTE_HORSE,600000,0;','','');
REPLACE INTO `item_db` VALUES ('12192','Pumpkin_Pie','Pumpkin Pie','0','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','percentheal 5,5;','','');
REPLACE INTO `item_db` VALUES ('12193','Brezel','Pretzel','2','20','10','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','','','');
REPLACE INTO `item_db` VALUES ('12194','Hometown_Gift','Hometown Gift','2','20','10','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','getrandgroupitem 12194,1; getrandgroupitem 12194,1; getrandgroupitem 12194,1;','','');
@@ -6111,7 +6111,7 @@ REPLACE INTO `item_db` VALUES ('12692','Old_C_Album_Shield','Shield Card Album',
REPLACE INTO `item_db` VALUES ('12693','Old_C_Album_Garment','Garment Card Album','2','20','10','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','','','');
REPLACE INTO `item_db` VALUES ('12694','Old_C_Album_Shoes','Shoes Card Album','2','20','10','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','','','');
REPLACE INTO `item_db` VALUES ('12695','Old_C_Album_Acc','Accessory Card Album','2','20','10','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','','','');
-REPLACE INTO `item_db` VALUES ('12696','RWC_Cele_Fire','RWC Celebration Firecracker','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','sc_start SC_STRFOOD,10000,3; sc_start SC_VITFOOD,10000,3; sc_start SC_INTFOOD,10000,3; sc_start SC_DEXFOOD,10000,3; sc_start SC_AGIFOOD,10000,3; sc_start SC_LUKFOOD,10000,3;','','');
+REPLACE INTO `item_db` VALUES ('12696','RWC_Cele_Fire','RWC Celebration Firecracker','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','sc_start SC_FOOD_STR,10000,3; sc_start SC_FOOD_AGI,10000,3; sc_start SC_FOOD_VIT,10000,3; sc_start SC_FOOD_DEX,10000,3; sc_start SC_FOOD_INT,10000,3; sc_start SC_FOOD_LUK,10000,3;','','');
REPLACE INTO `item_db` VALUES ('12697','RWC_Cele_Fire2','RWC Celebration Firecracker 2','11','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','','','');
REPLACE INTO `item_db` VALUES ('12698','Old_C_Album_Weapon','Weapon Card Album','2','20','10','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','','','');
REPLACE INTO `item_db` VALUES ('12699','Tikbalang_Belt','Tikbalang Harness','2','20','10','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','pet 2313;','','');
@@ -6161,7 +6161,7 @@ REPLACE INTO `item_db` VALUES ('12742','Valentine_Gift_Box1','Valentine Gift Box
REPLACE INTO `item_db` VALUES ('12743','Valentine_Gift_Box2','Valentine Gift Box','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 ('12744','Chocotate_Box','Chocolate Box','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 ('12745','Skull_Scroll','Vivid Notation','2','20','10','10','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 ('12746','Destruction_Scroll','Destruction Scroll','2','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','autobonus \"{bonus2 bAddRace,RC_Boss,5}\",10000,1800000; autobonus \"{bonus2 bAddRace,RC_Angel,5;}\",10000,1800000; autobonus \"{bonus2 bAddEle,Ele_Holy,5;}\",10000,1800000;','','');
+REPLACE INTO `item_db` VALUES ('12746','Destruction_Scroll','Destruction Scroll','2','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','autobonus \"{bonus2 bAddRace,RC_Boss,5;}\",10000,1800000; autobonus \"{bonus2 bAddRace,RC_Angel,5;}\",10000,1800000; autobonus \"{bonus2 bAddEle,Ele_Holy,5;}\",10000,1800000;','','');
REPLACE INTO `item_db` VALUES ('12747','Royal_Scroll','Royal Scroll','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','autobonus \"{bonus2 bSubRace,RC_Boss,5;}\",10000,1800000;','','');
REPLACE INTO `item_db` VALUES ('12748','Immune_Scroll','Immune Scroll','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','autobonus \"{bonus2 bAddEle,Ele_Neutral,-5;}\",10000,1800000;','','');
REPLACE INTO `item_db` VALUES ('12749','Mystic_Scroll','Mystic Scroll','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','sc_start SC_PLUSMAGICPOWER,180000,5;','','');
@@ -6512,7 +6512,7 @@ REPLACE INTO `item_db` VALUES ('13268','Mysterious_Powder','Mysterious Powder','
REPLACE INTO `item_db` VALUES ('13269','Boost500_To_Throw','Throwing Boost500','10','100','50','10','0','0','0','0','0','262144','63','2','32768','0','99',NULL,'0','9','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_BOOST500,500000,10;','','');
REPLACE INTO `item_db` VALUES ('13270','Full_SwingK_To_Throw','Full SwingK Throw','10','100','50','50','0','0','0','0','0','262144','63','2','32768','0','99',NULL,'0','9','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_FULL_SWING_K,500000,50;','','');
REPLACE INTO `item_db` VALUES ('13271','Mana_Plus_To_Throw','Mana + Throw','10','100','50','50','0','0','0','0','0','262144','63','2','32768','0','99',NULL,'0','9','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_MANA_PLUS,500000,50;','','');
-REPLACE INTO `item_db` VALUES ('13272','Cure_Free_To_Throw','Cure Free Throw','10','100','50','50','0','0','0','0','0','262144','63','2','32768','0','99',NULL,'0','9','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_end SC_SILENCE; sc_end SC_BLOODING; sc_end SC_POISON; sc_end SC_CURSE; sc_end SC_ORCISH; sc_end SC_CHANGEUNDEAD; heal 500,0;','','');
+REPLACE INTO `item_db` VALUES ('13272','Cure_Free_To_Throw','Cure Free Throw','10','100','50','50','0','0','0','0','0','262144','63','2','32768','0','99',NULL,'0','9','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_end SC_SILENCE; sc_end SC_BLOODING; sc_end SC_POISON; sc_end SC_CURSE; sc_end SC_ORCISH; sc_end SC_PROPERTYUNDEAD; heal 500,0;','','');
REPLACE INTO `item_db` VALUES ('13273','Stamina_Up_M_To_Throw','Throwing Muramura(M)','10','100','50','10','0','0','0','0','0','262144','63','2','32768','0','99',NULL,'0','9','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_MUSTLE_M,500000,5;','','');
REPLACE INTO `item_db` VALUES ('13274','Digestive_F_To_Throw','Throwing Falmons(F)','10','100','50','10','0','0','0','0','0','262144','63','2','32768','0','99',NULL,'0','9','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_LIFE_FORCE_F,500000,5;','','');
REPLACE INTO `item_db` VALUES ('13275','HP_Inc_PotS_To_Throw','HP Increase Potion(Small) Throw','10','100','50','20','0','0','0','0','0','262144','63','2','32768','0','99',NULL,'0','9','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_INCMHPRATE,500000,1; sc_start SC_INCMHP,500000,(500+(10/3)*BaseLevel); percentheal 2,0;','','');
@@ -7020,8 +7020,8 @@ REPLACE INTO `item_db` VALUES ('13924','L_Orc_Hero_Helm_Box','Orc Hero Headdress
REPLACE INTO `item_db` VALUES ('13925','Year_Of_Mouse_Scroll','Mouse Scroll','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','packageitem();','','');
REPLACE INTO `item_db` VALUES ('13926','Crusader_Card_Box','Crusader Card Box','18','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem 4371,1; getitem 4311,1; getitem 4319,1; getitem 4331,1;','','');
REPLACE INTO `item_db` VALUES ('13927','Alchemist_Card_Box','Alchemist Card Box','18','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem 4281,1; getitem 4233,1; getitem 4343,1; getitem 4186,1; getitem 4036,1;','','');
-REPLACE INTO `item_db` VALUES ('13928','Rogue_Card_Box','Bard Dancer Card Box','18','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem 4039,1; getitem 4210,1; getitem 4257,1; getitem 4230,1; getitem 4348,1;','','');
-REPLACE INTO `item_db` VALUES ('13929','Bard_Dancer_Card_Box','Rogue Card Box','18','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem 4297,1; getitem 4234,1; getitem 4178,1; getitem 4381,1; getitem 4252,1;','','');
+REPLACE INTO `item_db` VALUES ('13928','Rogue_Card_Box','Rogue Card Box','18','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem 4039,1; getitem 4210,1; getitem 4257,1; getitem 4230,1; getitem 4348,1;','','');
+REPLACE INTO `item_db` VALUES ('13929','Bard_Dancer_Card_Box','Bard Dancer Card Box','18','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem 4297,1; getitem 4234,1; getitem 4178,1; getitem 4381,1; getitem 4252,1;','','');
REPLACE INTO `item_db` VALUES ('13930','Sage_Card_Box','Sage card box','18','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem 4382,1; getitem 4258,1; getitem 4325,1; getitem 4208,1; getitem 4327,1;','','');
REPLACE INTO `item_db` VALUES ('13931','Monk_Card_Box','Monk Card Box','18','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem 4312,1; getitem 4332,1; getitem 4185,1; getitem 4293,1;','','');
REPLACE INTO `item_db` VALUES ('13932','Sylph_Box','Sylph Box','18','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem 4345,4;','','');
@@ -8120,7 +8120,7 @@ REPLACE INTO `item_db` VALUES ('18597','Mercury_Helm','Mercury Riser','5','45000
REPLACE INTO `item_db` VALUES ('18598','Mini_Tree_J','Holy xmas Tree','5','20','10','50','0','0','0','0','1','4294967295','63','2','256','0','0',NULL,'0','727','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,20;','','');
REPLACE INTO `item_db` VALUES ('18599','Black_Devil_Mask','Black Devil\'s Mask','5','20','10','100','0','0','0','0','0','4294967295','63','2','512','0','0',NULL,'0','760','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAllStats,2;','','');
REPLACE INTO `item_db` VALUES ('18600','Cat_Ears_Beret','Cat Ear Beret','5','20','10','300','0','0','5','0','1','4294967295','63','2','256','0','0',NULL,'1','761','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtkRate,5; if(getrefine() > 5 && getrefine() <= 12) { bonus2 bAddRace,RC_DemiHuman,(getrefine() - 5); bonus2 AddRaceTolerance,RC_DemiHuman,(getrefine() - 5); } if(getrefine() > 12) { bonus2 bAddRace,RC_DemiHuman,7; bonus2 AddRaceTolerance,RC_DemiHuman,7; }','','');
-REPLACE INTO `item_db` VALUES ('18601','Red_Bread_Hat','Red Pom Band','5','20','10','300','0','0','0','0','1','4294967295','63','2','256','0','0',NULL,'1','762','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,5; if(getrefine() > 5 && getrefine() <= 12) { bonus2 bAddRaceTolerance,RC_DemiHuman,(getrefine() - 5); bonus2 bMagicAddRace,RC_DemiHuman,(getrefine() - 5); } if(getrefine() > 12) { bonus2 bAddRaceTolerance,RC_DemiHuman,7; bonus2 bMagicAddRace,RC_DemiHuman,7; }','','');
+REPLACE INTO `item_db` VALUES ('18601','Red_Bread_Hat','Red Pom Band','5','20','10','300','0','0','0','0','1','4294967295','63','2','256','0','0',NULL,'1','762','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,5; bonus bMatkRate,5; if(getrefine()>5) { bonus2 bAddRaceTolerance,RC_DemiHuman,(getrefine()-5); bonus2 bMagicAddRace,RC_DemiHuman,(getrefine()-5); }','','');
REPLACE INTO `item_db` VALUES ('18602','Watermelon_Slice','Watermelon Bite','5','20','10','100','0','0','0','0','0','4294967295','63','2','1','0','30',NULL,'0','763','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableHelm,0; bonus bMdef,4; bonus2 bAddEle,Ele_Fire,4;','','');
REPLACE INTO `item_db` VALUES ('18603','Black_Devil_Mask_','Black Devil\'s Mask','5','20','10','100','0','0','0','0','1','4294967295','63','2','512','0','0',NULL,'0','760','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAllStats,1;','','');
REPLACE INTO `item_db` VALUES ('18604','Falcon_Mask','Falcon Mask','5','10','5','30','0','0','0','0','1','4294967295','63','2','513','0','50',NULL,'0','782','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');