diff options
| author | shennetsind <ind@henn.et> | 2013-06-24 17:40:54 -0300 |
|---|---|---|
| committer | shennetsind <ind@henn.et> | 2013-06-24 17:40:54 -0300 |
| commit | 5b40d0c2937c2fe4f8e133271d05602543d86277 (patch) | |
| tree | a8af29674a49faa9ab2f260172d713d4692c3fb7 | |
| parent | 02bb58d320f16ddc30ac3d1e6508cf08997f583a (diff) | |
| download | hercules-5b40d0c2937c2fe4f8e133271d05602543d86277.tar.gz hercules-5b40d0c2937c2fe4f8e133271d05602543d86277.tar.bz2 hercules-5b40d0c2937c2fe4f8e133271d05602543d86277.tar.xz hercules-5b40d0c2937c2fe4f8e133271d05602543d86277.zip | |
Fixed db2sql
Wasn't taking in account the delay_consume flag which actually means the item type is 11 not 2.
Also added a extra warning in the item packages parser.
Special Thanks to ossi0110 for bringing this up.
Signed-off-by: shennetsind <ind@henn.et>
| -rw-r--r-- | db/pre-re/item_db.txt | 12 | ||||
| -rw-r--r-- | db/re/item_db.txt | 12 | ||||
| -rw-r--r-- | sql-files/item_db.sql | 185 | ||||
| -rw-r--r-- | sql-files/item_db_re.sql | 226 | ||||
| -rw-r--r-- | src/map/itemdb.c | 6 | ||||
| -rw-r--r-- | src/plugins/db2sql.c | 6 |
6 files changed, 225 insertions, 222 deletions
diff --git a/db/pre-re/item_db.txt b/db/pre-re/item_db.txt index 20351d08c..9a85151ab 100644 --- a/db/pre-re/item_db.txt +++ b/db/pre-re/item_db.txt @@ -5294,12 +5294,12 @@ 12986,Pet_Egg_Scroll_Box9,Adventurer Pack Box,18,20,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ getitem 12992,1; },{},{} 12987,Pet_Egg_Scroll_Box10,Pet Egg Scroll Box 10,18,20,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ getitem 12993,1; },{},{} 12988,Pet_Egg_Scroll_Box11,Pet Egg Scroll Box 11,18,20,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ getitem 12994,1; },{},{} -12989,Pet_Egg_Scroll6,Pet Egg Scroll 6,11,,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ packageitem(); },{},{} -12990,Pet_Egg_Scroll7,Pet Egg Scroll 7,11,,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ packageitem(); },{},{} -12991,Pet_Egg_Scroll8,Party Hard Pack,11,,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ packageitem(); },{},{} -12992,Pet_Egg_Scroll9,Adventurer Pack,11,,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ packageitem(); },{},{} -12993,Pet_Egg_Scroll10,Pet Egg Scroll 10,11,,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ packageitem(); },{},{} -12994,Pet_Egg_Scroll11,Pet Egg Scroll 11,11,,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ packageitem(); },{},{} +12989,Pet_Egg_Scroll6,Pet Egg Scroll 6,2,,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ packageitem(); },{},{} +12990,Pet_Egg_Scroll7,Pet Egg Scroll 7,2,,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ packageitem(); },{},{} +12991,Pet_Egg_Scroll8,Party Hard Pack,2,,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ packageitem(); },{},{} +12992,Pet_Egg_Scroll9,Adventurer Pack,2,,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ packageitem(); },{},{} +12993,Pet_Egg_Scroll10,Pet Egg Scroll 10,2,,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ packageitem(); },{},{} +12994,Pet_Egg_Scroll11,Pet Egg Scroll 11,2,,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ packageitem(); },{},{} 12995,White_Herb_Box,White Herb Box,18,20,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ getitem 509,15; },{},{} 12996,Blue_Herb_Box,Blue Herb Box,18,20,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ getitem 510,15; },{},{} 12997,Elunium_Box,Elunium Box,18,20,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ getitem 985,5; },{},{} diff --git a/db/re/item_db.txt b/db/re/item_db.txt index 60f49bcee..5571437b8 100644 --- a/db/re/item_db.txt +++ b/db/re/item_db.txt @@ -6097,12 +6097,12 @@ 12986,Pet_Egg_Scroll_Box9,Adventurer Pack Box,18,20,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ getitem 12992,1; },{},{} 12987,Pet_Egg_Scroll_Box10,Pet Egg Scroll Box 10,18,20,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ getitem 12993,1; },{},{} 12988,Pet_Egg_Scroll_Box11,Pet Egg Scroll Box 11,18,20,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ getitem 12994,1; },{},{} -12989,Pet_Egg_Scroll6,Pet Egg Scroll 6,11,,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ packageitem(); },{},{} -12990,Pet_Egg_Scroll7,Pet Egg Scroll 7,11,,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ packageitem(); },{},{} -12991,Pet_Egg_Scroll8,Party Hard Pack,11,,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ packageitem(); },{},{} -12992,Pet_Egg_Scroll9,Adventurer Pack,11,,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ packageitem(); },{},{} -12993,Pet_Egg_Scroll10,Pet Egg Scroll 10,11,,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ packageitem(); },{},{} -12994,Pet_Egg_Scroll11,Pet Egg Scroll 11,11,,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ packageitem(); },{},{} +12989,Pet_Egg_Scroll6,Pet Egg Scroll 6,2,,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ packageitem(); },{},{} +12990,Pet_Egg_Scroll7,Pet Egg Scroll 7,2,,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ packageitem(); },{},{} +12991,Pet_Egg_Scroll8,Party Hard Pack,2,,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ packageitem(); },{},{} +12992,Pet_Egg_Scroll9,Adventurer Pack,2,,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ packageitem(); },{},{} +12993,Pet_Egg_Scroll10,Pet Egg Scroll 10,2,,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ packageitem(); },{},{} +12994,Pet_Egg_Scroll11,Pet Egg Scroll 11,2,,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ packageitem(); },{},{} 12995,White_Herb_Box,White Herb Box,18,20,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ getitem 509,15; },{},{} 12996,Blue_Herb_Box,Blue Herb Box,18,20,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ getitem 510,15; },{},{} 12997,Elunium_Box,Elunium Box,18,20,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ getitem 985,5; },{},{} diff --git a/sql-files/item_db.sql b/sql-files/item_db.sql index 45bbf9d39..cdde18699 100644 --- a/sql-files/item_db.sql +++ b/sql-files/item_db.sql @@ -125,17 +125,17 @@ INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy (597, 'Lovely_Choco_Tart', 'Lovely Choco-Tart', 0, 20, 10, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemheal rand(10,400),0;', '', ''), (598, 'Light_Red_Pot', 'Light Red Potion', 0, 50, 25, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemheal rand(45,65),0;', '', ''), (599, 'Light_Orange_Pot', 'Light Orange Potion', 0, 200, 100, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemheal rand(105,145),0;', '', ''), -(601, 'Wing_Of_Fly', 'Fly Wing', 2, 60, 30, 50, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "AL_TELEPORT",1;', '', ''), -(602, 'Wing_Of_Butterfly', 'Butterfly Wing', 2, 300, 150, 50, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "AL_TELEPORT",3;', '', ''), +(601, 'Wing_Of_Fly', 'Fly Wing', 11, 60, 30, 50, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "AL_TELEPORT",1;', '', ''), +(602, 'Wing_Of_Butterfly', 'Butterfly Wing', 11, 300, 150, 50, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "AL_TELEPORT",3;', '', ''), (603, 'Old_Blue_Box', 'Old Blue Box', 2, 10000, 5000, 200, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'getrandgroupitem 603,1;', '', ''), (604, 'Branch_Of_Dead_Tree', 'Dead Branch', 2, 50, 25, 50, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'monster "this",-1,-1,"--ja--",-1,1,"";', '', ''), -(605, 'Anodyne', 'Anodyne', 2, 2000, 1000, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "SM_ENDURE",1;', '', ''), -(606, 'Aloebera', 'Aloevera', 2, 1500, 750, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "SM_SELFPROVOKE",1;', '', ''), +(605, 'Anodyne', 'Anodyne', 11, 2000, 1000, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "SM_ENDURE",1;', '', ''), +(606, 'Aloebera', 'Aloevera', 11, 1500, 750, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "SM_SELFPROVOKE",1;', '', ''), (607, 'Yggdrasilberry', 'Yggdrasil Berry', 0, 5000, 2500, 300, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'percentheal 100,100;', '', ''), (608, 'Seed_Of_Yggdrasil', 'Yggdrasil Seed', 0, 5000, 2500, 300, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'percentheal 50,50;', '', ''), (609, 'Amulet', 'Amulet', 2, 100, 50, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), -(610, 'Leaf_Of_Yggdrasil', 'Yggdrasil Leaf', 2, 4000, 2000, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "ALL_RESURRECTION",1;', '', ''), -(611, 'Spectacles', 'Magnifier', 2, 40, 20, 50, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MC_IDENTIFY",1;', '', ''), +(610, 'Leaf_Of_Yggdrasil', 'Yggdrasil Leaf', 11, 4000, 2000, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "ALL_RESURRECTION",1;', '', ''), +(611, 'Spectacles', 'Magnifier', 11, 40, 20, 50, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MC_IDENTIFY",1;', '', ''), (612, 'Portable_Furnace', 'Mini Furnace', 2, 150, 75, 200, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'produce 21;', '', ''), (613, 'Iron_Hammer', 'Iron Hammer', 2, 1000, 500, 200, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'produce 1;', '', ''), (614, 'Golden_Hammer', 'Golden Hammer', 2, 3000, 1500, 300, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'produce 2;', '', ''), @@ -200,21 +200,21 @@ INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy (683, 'Exorcize_Herb', 'Herb of Incantation', 2, 0, 0, 50, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start SC_PLUSMAGICPOWER,60000,30;', '', ''), (684, 'Durian', 'Durian', 2, 15000, 7500, 300, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start SC_PLUSATTACKPOWER,60000,10; sc_start SC_PLUSMAGICPOWER,60000,10;', '', ''), (685, 'RAMADAN', 'Ramadan', 0, 5000, 2500, 300, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'percentheal 100,50;', '', ''), -(686, 'Earth_Scroll_1_3', 'Level 3 Earth Spike', 2, 1000, 500, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "WZ_EARTHSPIKE",3;', '', ''), -(687, 'Earth_Scroll_1_5', 'Level 5 Earth Spike', 2, 2000, 1000, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "WZ_EARTHSPIKE",5;', '', ''), -(688, 'Cold_Scroll_1_3', 'Level 3 Cold Bolt', 2, 1000, 500, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MG_COLDBOLT",3;', '', ''), -(689, 'Cold_Scroll_1_5', 'Level 5 Cold Bolt', 2, 2000, 1000, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MG_COLDBOLT",5;', '', ''), -(690, 'Fire_Scroll_1_3', 'Level 3 Fire Bolt', 2, 1000, 500, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MG_FIREBOLT",3;', '', ''), -(691, 'Fire_Scroll_1_5', 'Level 5 Fire Bolt', 2, 2000, 1000, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MG_FIREBOLT",5;', '', ''), -(692, 'Wind_Scroll_1_3', 'Level 3 Lightening Bolt', 2, 1000, 500, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MG_LIGHTNINGBOLT",3;', '', ''), -(693, 'Wind_Scroll_1_5', 'Level 5 Lightening Bolt', 2, 2000, 1000, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MG_LIGHTNINGBOLT",5;', '', ''), -(694, 'Ghost_Scroll_1_3', 'Level 3 Soul Strike', 2, 1000, 500, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MG_SOULSTRIKE",3;', '', ''), -(695, 'Ghost_Scroll_1_5', 'Level 5 Soul Strike', 2, 2000, 1000, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MG_SOULSTRIKE",5;', '', ''), -(696, 'Fire_Scroll_2_1', 'Level 1 Fire Ball', 2, 1000, 500, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MG_FIREBALL",1;', '', ''), -(697, 'Fire_Scroll_2_5', 'Level 5 Fire Ball', 2, 2000, 1000, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MG_FIREBALL",5;', '', ''), -(698, 'Fire_Scroll_3_1', 'Level 1 Fire Wall', 2, 1000, 500, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MG_FIREWALL",1;', '', ''), -(699, 'Fire_Scroll_3_5', 'Level 5 Fire Wall', 2, 2000, 1000, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MG_FIREWALL",5;', '', ''), -(700, 'Cold_Scroll_2_1', 'Level 1 Frost Diver', 2, 1000, 500, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MG_FROSTDIVER",1;', '', ''), +(686, 'Earth_Scroll_1_3', 'Level 3 Earth Spike', 11, 1000, 500, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "WZ_EARTHSPIKE",3;', '', ''), +(687, 'Earth_Scroll_1_5', 'Level 5 Earth Spike', 11, 2000, 1000, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "WZ_EARTHSPIKE",5;', '', ''), +(688, 'Cold_Scroll_1_3', 'Level 3 Cold Bolt', 11, 1000, 500, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MG_COLDBOLT",3;', '', ''), +(689, 'Cold_Scroll_1_5', 'Level 5 Cold Bolt', 11, 2000, 1000, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MG_COLDBOLT",5;', '', ''), +(690, 'Fire_Scroll_1_3', 'Level 3 Fire Bolt', 11, 1000, 500, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MG_FIREBOLT",3;', '', ''), +(691, 'Fire_Scroll_1_5', 'Level 5 Fire Bolt', 11, 2000, 1000, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MG_FIREBOLT",5;', '', ''), +(692, 'Wind_Scroll_1_3', 'Level 3 Lightening Bolt', 11, 1000, 500, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MG_LIGHTNINGBOLT",3;', '', ''), +(693, 'Wind_Scroll_1_5', 'Level 5 Lightening Bolt', 11, 2000, 1000, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MG_LIGHTNINGBOLT",5;', '', ''), +(694, 'Ghost_Scroll_1_3', 'Level 3 Soul Strike', 11, 1000, 500, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MG_SOULSTRIKE",3;', '', ''), +(695, 'Ghost_Scroll_1_5', 'Level 5 Soul Strike', 11, 2000, 1000, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MG_SOULSTRIKE",5;', '', ''), +(696, 'Fire_Scroll_2_1', 'Level 1 Fire Ball', 11, 1000, 500, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MG_FIREBALL",1;', '', ''), +(697, 'Fire_Scroll_2_5', 'Level 5 Fire Ball', 11, 2000, 1000, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MG_FIREBALL",5;', '', ''), +(698, 'Fire_Scroll_3_1', 'Level 1 Fire Wall', 11, 1000, 500, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MG_FIREWALL",1;', '', ''), +(699, 'Fire_Scroll_3_5', 'Level 5 Fire Wall', 11, 2000, 1000, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MG_FIREWALL",5;', '', ''), +(700, 'Cold_Scroll_2_1', 'Level 1 Frost Diver', 11, 1000, 500, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MG_FROSTDIVER",1;', '', ''), (701, 'Ora_Ora', 'Ora Ora', 3, 55000, 27500, 200, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), (702, 'Animal_Blood', 'Animal Gore', 3, 450, 225, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), (703, 'Hinalle', 'Hinalle', 3, 500, 250, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), @@ -4292,10 +4292,10 @@ INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy (11710, 'Sakura_Mist', 'Sakura Mist', 0, 800, 400, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemheal rand(50,70),rand(10,12);', '', ''), (11711, 'Sakura_Milk_Tea', 'Sakura Milk Tea', 0, 800, 400, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemheal rand(50,70),rand(10,12);', '', ''), (11712, 'First_Leaf_Tea', 'Flower', 0, 800, 400, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemheal rand(50,70),rand(10,12);', '', ''), -(12000, 'Cold_Scroll_2_5', 'Level 5 Frost Diver', 2, 2000, 1000, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MG_FROSTDIVER",5;', '', ''), -(12001, 'Holy_Scroll_1_3', 'Level 3 Heal', 2, 2000, 1000, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "AL_HEAL",3;', '', ''), -(12002, 'Holy_Scroll_1_5', 'Level 5 Heal', 2, 2000, 1000, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "AL_HEAL",5;', '', ''), -(12003, 'Holy_Scroll_2_1', 'Level 1 Teleport', 2, 1000, 500, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "AL_TELEPORT",1;', '', ''), +(12000, 'Cold_Scroll_2_5', 'Level 5 Frost Diver', 11, 2000, 1000, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MG_FROSTDIVER",5;', '', ''), +(12001, 'Holy_Scroll_1_3', 'Level 3 Heal', 11, 2000, 1000, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "AL_HEAL",3;', '', ''), +(12002, 'Holy_Scroll_1_5', 'Level 5 Heal', 11, 2000, 1000, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "AL_HEAL",5;', '', ''), +(12003, 'Holy_Scroll_2_1', 'Level 1 Teleport', 11, 1000, 500, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "AL_TELEPORT",1;', '', ''), (12004, 'Arrow_Container', 'Quiver', 2, 2, 1, 250, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'getitem 1750,500;', '', ''), (12005, 'Iron_Arrow_Container', 'Iron Arrow Quiver', 2, 2, 1, 250, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'getitem 1770,500;', '', ''), (12006, 'Steel_Arrow_Container', 'Steel Arrow Quiver', 2, 2, 1, 250, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'getitem 1753,500;', '', ''), @@ -4311,8 +4311,8 @@ INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy (12016, 'Speed_Up_Potion', 'Speed Potion', 2, 2, 1, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start SC_MOVHASTE_INFINITY,5000,0;', '', ''), (12017, 'Slow_Down_Potion', 'Slow Potion', 2, 2, 1, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start SC_SlowDown,5000,0;', '', ''), (12018, 'Fire_Cracker', 'Firecracker', 2, 2, 1, 20, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'end;', '', ''), -(12019, 'Holy_Egg', 'Holy Egg', 2, 2, 1, 150, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "ALL_RESURRECTION",2;', '', ''), -(12020, 'Water_Of_Darkness', 'Cursed Water', 2, 2, 1, 30, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "ITEM_ENCHANTARMS",8;', '', ''), +(12019, 'Holy_Egg', 'Holy Egg', 11, 2, 1, 150, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "ALL_RESURRECTION",2;', '', ''), +(12020, 'Water_Of_Darkness', 'Cursed Water', 11, 2, 1, 30, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "ITEM_ENCHANTARMS",8;', '', ''), (12021, 'Pork_Belly', 'Pork', 0, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemheal rand(70,99),0;', '', ''), (12022, 'Spareribs', 'Galbi', 0, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemheal rand(70,99),0;', '', ''), (12023, 'Giftbox_China', 'Wrapped Box', 2, 1000, 500, 200, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'getrandgroupitem 12023,1;', '', ''), @@ -4321,10 +4321,10 @@ INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy (12026, 'Egg_Girl', 'Dano Festival Egg', 2, 1000, 500, 200, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'getrandgroupitem 12026,1;', '', ''), (12027, 'Giggling_Box', 'Giggling Box', 2, 1000, 500, 200, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'percentheal 9,0; if(rand(1000)<300) sc_start SC_Curse,30000,0;', '', ''), (12028, 'Box_Of_Thunder', 'Box of Thunder', 2, 1000, 500, 200, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start SC_MOVHASTE_HORSE,20000,0;', '', ''), -(12029, 'Gloomy_Box', 'Box of Gloom', 2, 1000, 500, 200, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "AC_CONCENTRATION",1;', '', ''), +(12029, 'Gloomy_Box', 'Box of Gloom', 11, 1000, 500, 200, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "AC_CONCENTRATION",1;', '', ''), (12030, 'Box_Of_Grudge', 'Box of Resentment', 2, 1000, 500, 200, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start SC_PLUSATTACKPOWER,60000,20;', '', ''), (12031, 'Sleepy_Box', 'Box of Drowsiness', 2, 1000, 500, 200, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start SC_PLUSMAGICPOWER,60000,20;', '', ''), -(12032, 'Box_Of_Storm', 'Box of Storms', 2, 1000, 500, 200, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "ITEM_ENCHANTARMS",2;', '', ''), +(12032, 'Box_Of_Storm', 'Box of Storms', 11, 1000, 500, 200, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "ITEM_ENCHANTARMS",2;', '', ''), (12033, 'Box_Of_Sunlight', 'Box of Sunlight', 2, 1000, 500, 200, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start SC_CLAIRVOYANCE,30000,0;', '', ''), (12034, 'Painting_Box', 'Box of Panting', 2, 1000, 500, 200, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'percentheal 0,9; if(rand(1000)<300) sc_start SC_Silence,30000,0;', '', ''), (12035, 'Lotto_Box01', 'Lotto Box 01', 2, 0, 0, 20, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'getitem rand(7361,7370),1;', '', ''), @@ -4406,10 +4406,10 @@ INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy (12111, 'Food_Package', 'Bundle of Food', 2, 10000, 5000, 200, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'getrandgroupitem 12111,1; getrandgroupitem 12111,1; getrandgroupitem 12111,1;', '', ''), (12112, 'Tropical_Sograt', 'Tropical Sograt', 2, 1000, 500, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start SC_Curse,10000,1;', '', ''), (12113, 'Vermilion_The_Beach', 'Vermilion on the Beach', 2, 1000, 500, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start SC_Stun,10000,1;', '', ''), -(12114, 'Elemental_Fire', 'Elemental Converter', 2, 2, 1, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "ITEM_ENCHANTARMS",4;', '', ''), -(12115, 'Elemental_Water', 'Elemental Converter', 2, 2, 1, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "ITEM_ENCHANTARMS",2;', '', ''), -(12116, 'Elemental_Earth', 'Elemental Converter', 2, 2, 1, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "ITEM_ENCHANTARMS",3;', '', ''), -(12117, 'Elemental_Wind', 'Elemental Converter', 2, 2, 1, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "ITEM_ENCHANTARMS",5;', '', ''), +(12114, 'Elemental_Fire', 'Elemental Converter', 11, 2, 1, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "ITEM_ENCHANTARMS",4;', '', ''), +(12115, 'Elemental_Water', 'Elemental Converter', 11, 2, 1, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "ITEM_ENCHANTARMS",2;', '', ''), +(12116, 'Elemental_Earth', 'Elemental Converter', 11, 2, 1, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "ITEM_ENCHANTARMS",3;', '', ''), +(12117, 'Elemental_Wind', 'Elemental Converter', 11, 2, 1, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "ITEM_ENCHANTARMS",5;', '', ''), (12118, 'Resist_Fire', 'Fireproof Potion', 2, 2, 1, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start4 SC_ARMOR_ELEMENT,1200000,-15,0,20,0;', '', ''), (12119, 'Resist_Water', 'Coldproof Potion', 2, 2, 1, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start4 SC_ARMOR_ELEMENT,1200000,20,0,0,-15;', '', ''), (12120, 'Resist_Earth', 'Earthproof Potion', 2, 2, 1, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start4 SC_ARMOR_ELEMENT,1200000,0,20,-15,0;', '', ''), @@ -4493,7 +4493,7 @@ INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy (12197, 'Salty_Rice_Cake', 'Salty Rice Cake', 0, 20, 10, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'percentheal 10,10;', '', ''), (12198, 'Lucky_Rice_Cake', 'Lucky Rice Cake', 2, 20, 10, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start SC_INCLUK,1200000,21;', '', ''), (12199, 'Rice_Scroll', 'Scroll of Magic', 2, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), -(12200, 'Event_Cake', 'X-mas Cake', 2, 20, 10, 50, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "PR_MAGNIFICAT",3;', '', ''), +(12200, 'Event_Cake', 'X-mas Cake', 11, 20, 10, 50, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "PR_MAGNIFICAT",3;', '', ''), (12201, 'Red_Box_C', 'Commonplace Red Box', 2, 20, 10, 200, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), (12202, 'Str_Dish10_', 'Steamed Tongue', 0, 2, 1, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start SC_FOOD_STR_CASH,1800000,10; percentheal 15,5;', '', ''), (12203, 'Agi_Dish10_', 'Steamed Scorpion', 0, 2, 1, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start SC_FOOD_AGI_CASH,1800000,10; percentheal 15,5;', '', ''), @@ -4506,7 +4506,7 @@ INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy (12210, 'Bubble_Gum', 'Bubble Gum', 2, 2, 1, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start SC_CASH_RECEIVEITEM,1800000,200;', '', ''), (12211, 'Kafra_Card', 'Kafra Card', 2, 2, 1, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'callfunc "F_CashStore";', '', ''), (12212, 'Giant_Fly_Wing', 'Giant Fly Wing', 2, 2, 1, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'callfunc "F_CashPartyCall";', '', ''), -(12213, 'Neuralizer', 'Neuralizer', 2, 2, 1, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'callfunc "F_CashReset";', '', ''), +(12213, 'Neuralizer', 'Neuralizer', 11, 2, 1, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'callfunc "F_CashReset";', '', ''), (12214, 'Convex_Mirror', 'Convex Mirror', 2, 2, 1, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start SC_CASH_BOSS_ALARM,600000,0;', '', ''), (12215, 'Blessing_10_Scroll', 'LV10 Blessing Scroll', 2, 2, 1, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'skilleffect "AL_BLESSING",0; sc_start SC_BLESSING,240000,10;', '', ''), (12216, 'Inc_Agi_10_Scroll', 'LV10 Agil Scroll', 2, 2, 1, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'if(Hp>15) { skilleffect "AL_INCAGI",0; sc_start SC_INC_AGI,240000,10; heal -15,0; }', '', ''), @@ -4526,7 +4526,7 @@ INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy (12233, 'Kvass', 'Kvass', 0, 20, 10, 200, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'percentheal 100,100;', '', ''), (12234, 'Cacao99', 'Fierce Cacao 99%', 0, 20, 10, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'percentheal 25,0;', '', ''), (12235, 'Strawberry_Choco', 'Chocolate Strawberry', 2, 20, 10, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'percentheal 0,5; skilleffect "AL_BLESSING",0; sc_start SC_BLESSING,240000,10;', '', ''), -(12236, 'Choco_Tart', 'Chocolate Tart', 2, 20, 10, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'percentheal 5,0; itemskill "AL_ANGELUS",5;', '', ''), +(12236, 'Choco_Tart', 'Chocolate Tart', 11, 20, 10, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'percentheal 5,0; itemskill "AL_ANGELUS",5;', '', ''), (12237, 'Choco_Lump', 'Junky Chocolate', 2, 0, 0, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'percentheal 0,5; sc_start SC_Poison,18000,0; sc_start SC_BLOODING,18000,0;', '', ''), (12238, 'New_Year_Rice_Cake_1', 'New Year Rice Cake', 2, 20, 10, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'if(rand(1000)<100) sc_start SC_DPoison,10000,0; sc_start SC_Poison,50000,0;', '', ''), (12239, 'New_Year_Rice_Cake_2', 'New Year Rice Cake', 2, 20, 10, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'if(rand(1000)<100) sc_start SC_DPoison,10000,0; sc_start SC_Poison,50000,0;', '', ''), @@ -4601,7 +4601,7 @@ INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy (12308, 'Magic_Castle', 'Magic Magic Powder', 2, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'setfont 8;', '', ''), (12309, 'Bulging_Head', 'JJangu Magic Powder', 2, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'setfont 9;', '', ''), (12310, 'Spray_Of_Flowers', 'Spray Of Flowers', 2, 0, 0, 50, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start SC_INCFLEE,600000,10;', '', ''), -(12311, 'Large_Spray_Of_Flowers', 'Huge Spray Of Flowers', 2, 0, 0, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "ALL_PARTYFLEE",1;', '', ''), +(12311, 'Large_Spray_Of_Flowers', 'Huge Spray Of Flowers', 11, 0, 0, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "ALL_PARTYFLEE",1;', '', ''), (12312, 'Thick_Manual50', 'Thick Battle Manual', 2, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start SC_CASH_PLUSEXP,3600000,50;', '', ''), (12313, 'Protection_Of_Angel', 'Guardian Angel', 2, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), (12314, 'Noive_Box', 'Noive Box', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), @@ -4613,9 +4613,9 @@ INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy (12320, 'Pineapple_Juice', 'Schwartzwald Pine Jubilee', 2, 0, 0, 300, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start SC_INCHIT,600000,10; sc_start SC_INCFLEE2,600000,20;', '', ''), (12321, 'Spicy_Sandwich', 'Arunafeltz Desert Sandwich', 2, 0, 0, 300, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start SC_CRITICALPERCENT,600000,7;', '', ''), (12322, 'Chocolate_Pie', 'Chocolate Pie', 0, 0, 0, 50, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'percentheal 5,5;', '', ''), -(12323, 'N_Fly_Wing', 'Novice Fly Wing', 2, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "AL_TELEPORT",1;', '', ''), -(12324, 'N_Butterfly_Wing', 'Novice Butterfly Wing', 2, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "AL_TELEPORT",3;', '', ''), -(12325, 'N_Magnifier', 'Novice Magnifier', 2, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MC_IDENTIFY",1;', '', ''), +(12323, 'N_Fly_Wing', 'Novice Fly Wing', 11, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "AL_TELEPORT",1;', '', ''), +(12324, 'N_Butterfly_Wing', 'Novice Butterfly Wing', 11, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "AL_TELEPORT",3;', '', ''), +(12325, 'N_Magnifier', 'Novice Magnifier', 11, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MC_IDENTIFY",1;', '', ''), (12326, 'J_Firecracker', 'Large Firecracker', 2, 2, 1, 20, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), (12327, 'Charm_Of_Luck', 'Charm Of Luck', 2, 1000, 500, 50, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), (12328, 'Charm_Of_Happiness', 'Charm Of Happiness', 2, 1800, 900, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start SC_INCLUK,3600000,20;', '', ''), @@ -4640,8 +4640,8 @@ INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy (12347, 'Acorn_Jelly', 'Acorn Jelly', 2, 11, 5, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "ALL_REVERSEORCISH",1;', '', ''), (12348, 'Manuk''s_Faith', 'Manuk''s Faith', 2, 0, 0, 50, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'specialeffect2 EF_POTION_BERSERK; sc_start SC_MANU_MATK,600000,10;', '', ''), (12349, 'Cornus''_Tears', 'Cornus'' Tears', 2, 0, 0, 50, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'specialeffect2 EF_POTION_BERSERK; sc_start SC_SPL_MATK,600000,10;', '', ''), -(12350, 'Angeling_Potion', 'Angeling Potion', 2, 20, 10, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'skilleffect "AL_BLESSING",0; sc_start SC_BLESSING,120000,5; itemskill "AL_ANGELUS",5;', '', ''), -(12351, 'Shout_Megaphone', 'Scream Megaphone', 2, 20, 10, 50, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MC_LOUD",1;', '', ''), +(12350, 'Angeling_Potion', 'Angeling Potion', 11, 20, 10, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'skilleffect "AL_BLESSING",0; sc_start SC_BLESSING,120000,5; itemskill "AL_ANGELUS",5;', '', ''), +(12351, 'Shout_Megaphone', 'Scream Megaphone', 11, 20, 10, 50, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "MC_LOUD",1;', '', ''), (12352, 'Dun_Tele_Scroll3', 'Dungeon Teleport Scroll 3', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), (12353, 'Tiny_Waterbottle', 'Small Bottle', 2, 800, 400, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start SC_PROPERTYWATER,90000,1;', '', ''), (12354, 'Buche_De_Noel', 'Buche De Noel', 2, 2, 1, 50, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'specialeffect2 EF_ANGELUS; sc_start SC_INCMHPRATE,600000,3; sc_start SC_INCMSPRATE,600000,3; sc_start SC_INCHITRATE,600000,3; sc_start SC_CRITICALPERCENT,600000,7;', '', ''), @@ -4674,20 +4674,20 @@ INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy (12381, 'ValkyrieA_Scroll', 'Ancient Languages Scroll', 2, 10, 5, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'if(strcharinfo(3)=="job3_arch02") { mercenary_create 2037,1800000; }', '', ''), (12382, 'ValkyrieB_Scroll', 'Ancient Languages Scroll', 2, 10, 5, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'if(strcharinfo(3)=="job3_arch02") { mercenary_create 2038,1800000; }', '', ''), (12383, 'Vulcan_Bullet_Magazine', 'Vulcan Bullet Magazine', 2, 11000, 5500, 500, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), -(12384, 'Rainbow_Ruby_Water', 'Rainbow Ruby', 2, 0, 0, 50, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), -(12385, 'Rainbow_Ruby_Fire', 'Rainbow Ruby', 2, 0, 0, 50, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), -(12386, 'Rainbow_Ruby_Wind', 'Rainbow Ruby', 2, 0, 0, 50, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), -(12387, 'Rainbow_Ruby_Earth', 'Rainbow Ruby', 2, 0, 0, 50, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), -(12388, 'Runstone_Crush', 'Rhydo Runestone For Apprentice', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), -(12389, 'Runstone_Storm', 'Pertz Runestone For Apprentice', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), -(12390, 'Runstone_Millennium', 'Verkana Runestone For Apprentice', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), +(12384, 'Rainbow_Ruby_Water', 'Rainbow Ruby', 11, 0, 0, 50, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), +(12385, 'Rainbow_Ruby_Fire', 'Rainbow Ruby', 11, 0, 0, 50, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), +(12386, 'Rainbow_Ruby_Wind', 'Rainbow Ruby', 11, 0, 0, 50, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), +(12387, 'Rainbow_Ruby_Earth', 'Rainbow Ruby', 11, 0, 0, 50, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), +(12388, 'Runstone_Crush', 'Rhydo Runestone For Apprentice', 11, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), +(12389, 'Runstone_Storm', 'Pertz Runestone For Apprentice', 11, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), +(12390, 'Runstone_Millennium', 'Verkana Runestone For Apprentice', 11, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), (12391, 'Lucky_Egg_C', 'Lucky Egg', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'packageitem();', '', ''), (12392, 'Repair_A', 'Repair A', 0, 220, 110, 70, 0, 0, 0, 0, 1024, 8, 2, 0, 0, 0, 0, 0, '', '', ''), (12393, 'Repair_B', 'Repair B', 0, 500, 250, 70, 0, 0, 0, 0, 1024, 8, 2, 0, 0, 0, 0, 0, '', '', ''), (12394, 'Repair_C', 'Repair C', 0, 1100, 550, 70, 0, 0, 0, 0, 1024, 8, 2, 0, 0, 0, 0, 0, '', '', ''), (12395, 'Tantanmen', 'Tantan Noodle', 2, 20, 10, 50, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'pet 1519;', '', ''), -(12396, 'Fools_Day_Box', 'Gift Box?', 2, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'if(rand(1,10)==1) itemskill "AL_TELEPORT",1; else if(rand(1,10)==2) itemskill "AL_TELEPORT",3; else if(rand(1,10)==3) percentheal 50,0; else if(rand(1,10)==4) percentheal 0,50; else if(rand(1,10)==5) end; else if(rand(1,10)==6) getitem 512,1; else if(rand(1,10)==7) itemskill "ALL_REVERSEORCISH",1; else if(rand(1,10)==8) specialeffect2 247; else if(rand(1,10)==9) specialeffect2 338; else specialeffect2 10;', '', ''), -(12397, 'Fools_Day_Box2', 'Gift Box?', 2, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'if(rand(1,10)==1) itemskill "TF_DETOXIFY",1; else if(rand(1,10)==2) itemskill "TF_PICKSTONE",1; else if(rand(1,10)==3) itemskill "BA_FROSTJOKER",1; else if(rand(1,10)==4) itemskill "DC_SCREAM",1; else if(rand(1,10)==5) end; else if(rand(1,10)==6) getitem 909,1; else if(rand(1,10)==7) itemskill "AL_RUWACH",1; else if(rand(1,10)==8) specialeffect2 328; else if(rand(1,10)==9) specialeffect2 68; else specialeffect2 196;', '', ''), +(12396, 'Fools_Day_Box', 'Gift Box?', 11, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'if(rand(1,10)==1) itemskill "AL_TELEPORT",1; else if(rand(1,10)==2) itemskill "AL_TELEPORT",3; else if(rand(1,10)==3) percentheal 50,0; else if(rand(1,10)==4) percentheal 0,50; else if(rand(1,10)==5) end; else if(rand(1,10)==6) getitem 512,1; else if(rand(1,10)==7) itemskill "ALL_REVERSEORCISH",1; else if(rand(1,10)==8) specialeffect2 247; else if(rand(1,10)==9) specialeffect2 338; else specialeffect2 10;', '', ''), +(12397, 'Fools_Day_Box2', 'Gift Box?', 11, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'if(rand(1,10)==1) itemskill "TF_DETOXIFY",1; else if(rand(1,10)==2) itemskill "TF_PICKSTONE",1; else if(rand(1,10)==3) itemskill "BA_FROSTJOKER",1; else if(rand(1,10)==4) itemskill "DC_SCREAM",1; else if(rand(1,10)==5) end; else if(rand(1,10)==6) getitem 909,1; else if(rand(1,10)==7) itemskill "AL_RUWACH",1; else if(rand(1,10)==8) specialeffect2 328; else if(rand(1,10)==9) specialeffect2 68; else specialeffect2 196;', '', ''), (12398, 'PCBang_Gift_Box', 'PCBang Gift Box', 2, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), (12399, 'Castle_Treasure_Box', 'Castle Treasure Box', 2, 20, 10, 1000, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), (12400, 'Water_Of_Blessing_', 'Water Of Blessing ', 2, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), @@ -4874,12 +4874,12 @@ INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy (12591, 'Vending_Search_Scroll3', 'Universal Catalog Bronze', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'searchstores 10,1;', '', ''), (12701, 'Old_Blue_Box_F', 'Old Blue Box', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), (12702, 'Old_Bleu_Box', 'Old Navy Box', 2, 0, 0, 200, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'getrandgroupitem 12702,1; getrandgroupitem 12702,1;', '', ''), -(12703, 'Holy_Egg_2', 'Holy Egg', 2, 0, 0, 50, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), +(12703, 'Holy_Egg_2', 'Holy Egg', 11, 0, 0, 50, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), (12704, 'Elixir_Of_Life', 'Elixir of Life', 0, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 85, 0, 0, 'percentheal 100,0;', '', ''), (12705, 'Noble_Nameplate', 'Noble Nameplate', 2, 0, 0, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 90, 0, 0, 'sc_start SC_CASH_PLUSEXP,1800000,100;', '', ''), -(12706, 'Lucky_Cookie01', 'Lucky Cookie', 2, 0, 0, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "PR_GLORIA",5;', '', ''), -(12707, 'Lucky_Cookie02', 'Lucky Cookie', 2, 0, 0, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "PR_MAGNIFICAT",1;', '', ''), -(12708, 'Lucky_Cookie03', 'Lucky Cookie', 2, 0, 0, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "PR_IMPOSITIO",3;', '', ''), +(12706, 'Lucky_Cookie01', 'Lucky Cookie', 11, 0, 0, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "PR_GLORIA",5;', '', ''), +(12707, 'Lucky_Cookie02', 'Lucky Cookie', 11, 0, 0, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "PR_MAGNIFICAT",1;', '', ''), +(12708, 'Lucky_Cookie03', 'Lucky Cookie', 11, 0, 0, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "PR_IMPOSITIO",3;', '', ''), (12709, 'Guyak_Candy', 'Guyak Candy', 0, 0, 0, 150, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'percentheal 30,30;', '', ''), (12710, 'Guyak_Pudding', 'Guyak Pudding', 2, 0, 0, 200, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), (12711, 'Pretzel', 'Pretzel', 0, 2, 1, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemheal rand(50,90),0;', '', ''), @@ -4896,15 +4896,15 @@ INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy (12722, 'Poison_Fever', 'Pyrexia', 0, 2, 1, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'if(rand(10000)<10) sc_start SC_PYREXIA,300000,0;', '', ''), (12723, 'Poison_Laughing', 'Magic Mushroom', 0, 2, 1, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'if(rand(10000)<10) sc_start SC_MAGICMUSHROOM,300000,0;', '', ''), (12724, 'Poison_Fatigue', 'Venom Bleed', 0, 2, 1, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'if(rand(10000)<10) sc_start SC_VENOMBLEED,15000,0;', '', ''), -(12725, 'Runstone_Nosiege', 'Nauthiz Rune', 2, 100, 50, 100, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 'itemskill "RK_REFRESH",1;', '', ''), -(12726, 'Runstone_Rhydo', 'Raido Rune', 2, 100, 50, 100, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 'itemskill "RK_CRUSHSTRIKE",1;', '', ''), -(12727, 'Runstone_Verkana', 'Berkana Rune', 2, 100, 50, 100, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 'itemskill "RK_MILLENNIUMSHIELD",1;', '', ''), -(12728, 'Runstone_Isia', 'Isa Rune', 2, 100, 50, 100, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 'itemskill "RK_VITALITYACTIVATION",1;', '', ''), -(12729, 'Runstone_Asir', 'Othila Rune', 2, 100, 50, 100, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 'itemskill "RK_FIGHTINGSPIRIT",1;', '', ''), -(12730, 'Runstone_Urj', 'Uruz Rune', 2, 100, 50, 100, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 'itemskill "RK_ABUNDANCE",1;', '', ''), -(12731, 'Runstone_Turisus', 'Thurisaz Rune', 2, 100, 50, 100, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 'itemskill "RK_GIANTGROWTH",1;', '', ''), -(12732, 'Runstone_Pertz', 'Wyrd Rune', 2, 100, 50, 100, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 'itemskill "RK_STORMBLAST",1;', '', ''), -(12733, 'Runstone_Hagalas', 'Hagalaz Rune', 2, 100, 50, 100, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 'itemskill "RK_STONEHARDSKIN",1;', '', ''), +(12725, 'Runstone_Nosiege', 'Nauthiz Rune', 11, 100, 50, 100, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 'itemskill "RK_REFRESH",1;', '', ''), +(12726, 'Runstone_Rhydo', 'Raido Rune', 11, 100, 50, 100, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 'itemskill "RK_CRUSHSTRIKE",1;', '', ''), +(12727, 'Runstone_Verkana', 'Berkana Rune', 11, 100, 50, 100, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 'itemskill "RK_MILLENNIUMSHIELD",1;', '', ''), +(12728, 'Runstone_Isia', 'Isa Rune', 11, 100, 50, 100, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 'itemskill "RK_VITALITYACTIVATION",1;', '', ''), +(12729, 'Runstone_Asir', 'Othila Rune', 11, 100, 50, 100, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 'itemskill "RK_FIGHTINGSPIRIT",1;', '', ''), +(12730, 'Runstone_Urj', 'Uruz Rune', 11, 100, 50, 100, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 'itemskill "RK_ABUNDANCE",1;', '', ''), +(12731, 'Runstone_Turisus', 'Thurisaz Rune', 11, 100, 50, 100, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 'itemskill "RK_GIANTGROWTH",1;', '', ''), +(12732, 'Runstone_Pertz', 'Wyrd Rune', 11, 100, 50, 100, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 'itemskill "RK_STORMBLAST",1;', '', ''), +(12733, 'Runstone_Hagalas', 'Hagalaz Rune', 11, 100, 50, 100, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 'itemskill "RK_STONEHARDSKIN",1;', '', ''), (12734, 'Runstone_Quality', 'Luxurious Rune', 0, 2, 1, 100, 0, 0, 0, 0, 128, 8, 2, 0, 0, 0, 0, 0, 'makerune 5;', '', ''), (12735, 'Runstone_Ancient', 'Ancient Rune', 0, 2, 1, 100, 0, 0, 0, 0, 128, 8, 2, 0, 0, 0, 0, 0, 'makerune 11;', '', ''), (12736, 'Runstone_Mystic', 'Mystic Rune', 0, 2, 1, 100, 0, 0, 0, 0, 128, 8, 2, 0, 0, 0, 0, 0, 'makerune 14;', '', ''), @@ -4947,7 +4947,7 @@ INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy (12773, 'Victory_Hat_Box2', 'Victory Hat Box2', 2, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'packageitem();', '', ''), (12786, 'Change_Slot_Card', 'Character Position Change Coupon', 2, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'set SlotChange, SlotChange + 1;', '', ''), (12790, 'Change_Name_Card', 'Name Change Coupon', 2, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'set CharRename, CharRename + 1;', '', ''), -(12848, 'Falcon_Flute', 'Falcon Flute', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'if(getskilllv("HT_FALCON")) { if(checkoption(Option_Wug)||checkoption(Option_Wugrider)) end; if(checkfalcon()==1) { setfalcon 0; } else { setfalcon 1; } }', '', ''), +(12848, 'Falcon_Flute', 'Falcon Flute', 11, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'if(getskilllv("HT_FALCON")) { if(checkoption(Option_Wug)||checkoption(Option_Wugrider)) end; if(checkfalcon()==1) { setfalcon 0; } else { setfalcon 1; } }', '', ''), (12900, 'Battle_Manual_Box', 'Battle Manual Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'getitem 12208,10;', '', ''), (12901, 'Insurance_Package', 'Insurance Package', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'getitem 12209,10;', '', ''), (12902, 'Bubble_Gum_Box', 'Bubble Gum Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'getitem 12210,10;', '', ''), @@ -4976,7 +4976,7 @@ INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy (12925, 'Pet_Egg_Scroll1', 'Kafra Item Mall Prize Package', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'packageitem();', '', ''), (12926, 'Pet_Egg_Scroll2', 'December Lucky Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'packageitem();', '', ''), (12927, 'J_Aspersio_5_Scroll_Box', 'Aspersio Scroll Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'getitem 12928,10;', '', ''), -(12928, 'J_Aspersio_5_Scroll', 'Sacred Scroll', 2, 2, 1, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "PR_ASPERSIO",5;', '', ''), +(12928, 'J_Aspersio_5_Scroll', 'Sacred Scroll', 11, 2, 1, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "PR_ASPERSIO",5;', '', ''), (12929, 'Pet_Egg_Scroll_Box3', 'Pet Egg Box 3', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'getitem 12932,1;', '', ''), (12930, 'Pet_Egg_Scroll_Box4', 'Pet Egg Box 4', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'getitem 12933,1;', '', ''), (12931, 'Pet_Egg_Scroll_Box5', 'Pet Egg Box 5', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'getitem 12934,1;', '', ''), @@ -5016,9 +5016,9 @@ INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy (12965, 'Emergency_Box1', 'Emergency Level 1 Scroll Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'getitem 12968,1;', '', ''), (12966, 'Emergency_Box2', 'Emergency Level 2 Scroll Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'getitem 12969,1;', '', ''), (12967, 'Emergency_Box3', 'Emergency Level 3 Scroll Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'getitem 12970,1;', '', ''), -(12968, 'Emergency_Scroll1', 'Emergency Level 1 Scroll', 2, 2, 1, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "GD_EMERGENCYCALL",1;', '', ''), -(12969, 'Emergency_Scroll2', 'Emergency Level 2 Scroll', 2, 2, 1, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "GD_EMERGENCYCALL",1;', '', ''), -(12970, 'Emergency_Scroll3', 'Emergency Level 3 Scroll', 2, 2, 1, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "GD_EMERGENCYCALL",1;', '', ''), +(12968, 'Emergency_Scroll1', 'Emergency Level 1 Scroll', 11, 2, 1, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "GD_EMERGENCYCALL",1;', '', ''), +(12969, 'Emergency_Scroll2', 'Emergency Level 2 Scroll', 11, 2, 1, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "GD_EMERGENCYCALL",1;', '', ''), +(12970, 'Emergency_Scroll3', 'Emergency Level 3 Scroll', 11, 2, 1, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "GD_EMERGENCYCALL",1;', '', ''), (12971, 'Teleport_Box1', 'Teleport Scroll Box 1', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'getitem 12977,10;', '', ''), (12972, 'Teleport_Box2', 'Teleport Scroll Box 2', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'getitem 12978,10;', '', ''), (12973, 'Teleport_Box3', 'Teleport Scroll Box 3', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'getitem 12979,10;', '', ''), @@ -5106,9 +5106,9 @@ INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy (13106, 'Gold_Lux', 'Gold Lux', 4, 100000, 50000, 500, 20, 0, 7, 0, 16777216, 7, 2, 34, 3, 12, 1, 17, 'bonus bHit,-10; if(getskilllv("GS_GLITTERING")>0) bonus3 bAutoSpell,"GS_GLITTERING",getskilllv("GS_GLITTERING"),100;', '', ''), (13107, 'Wasteland_Outlaw', 'Wasteland''s Outlaw', 4, 20, 10, 580, 68, 0, 7, 2, 16777216, 7, 2, 34, 3, 70, 1, 17, 'bonus bHit,readparam(bAgi)/10; bonus bAspdRate,readparam(bAgi)/14;', '', ''), (13108, 'BF_Pistol1', 'Soldier Revolver', 4, 0, 0, 0, 70, 0, 7, 0, 16777216, 7, 2, 34, 3, 80, 1, 17, 'bonus bDex,2; bonus bHit,-10; bonus2 bAddRace,RC_DemiHuman,55; bonus2 bIgnoreDefRate,RC_DemiHuman,20; autobonus "{ bonus bAspdRate,100; }",10,3000,BF_WEAPON,"{ specialeffect2 EF_POTION_BERSERK; }"; bonus bUnbreakableWeapon,0;', '', ''), -(13109, 'Wasteland_Outlaw_C', 'Wasteland Outlaw', 4, 20, 10, 0, 100, 0, 7, 0, 16777216, 7, 2, 34, 3, 0, 0, 17, 'bonus bHit,readparam(bAgi)/10; bonus bAspdRate,readparam(bAgi)/14; bonus2 bAddRace,RC_NonBoss,10; bonus2 bAddRace,RC_Boss,10; bonus bMatkRate,10;', '', ''), -(13110, 'Krieger_Pistol1', 'Glorious Pistol', 4, 0, 0, 0, 80, 0, 7, 0, 16777216, 7, 2, 34, 4, 80, 1, 17, 'bonus2 bAddRace,RC_DemiHuman,55; bonus2 bIgnoreDefRate,RC_DemiHuman,20; bonus bUnbreakableWeapon,0; if(getrefine()>5){ bonus2 bAddRace,RC_DemiHuman,pow(getrefine()-4,2); bonus2 bIgnoreDefRate,RC_DemiHuman,5; } if(getrefine()>8) { bonus4 bAutoSpellOnSkill,"GS_RAPIDSHOWER","GS_GLITTERING",1,1000; bonus2 bSkillAtk,"GS_RAPIDSHOWER",getrefine()*2; }', '', ''); +(13109, 'Wasteland_Outlaw_C', 'Wasteland Outlaw', 4, 20, 10, 0, 100, 0, 7, 0, 16777216, 7, 2, 34, 3, 0, 0, 17, 'bonus bHit,readparam(bAgi)/10; bonus bAspdRate,readparam(bAgi)/14; bonus2 bAddRace,RC_NonBoss,10; bonus2 bAddRace,RC_Boss,10; bonus bMatkRate,10;', '', ''); INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy`, `price_sell`, `weight`, `atk`, `defence`, `range`, `slots`, `equip_jobs`, `equip_upper`, `equip_genders`, `equip_locations`, `weapon_level`, `equip_level`, `refineable`, `view`, `script`, `equip_script`, `unequip_script`) VALUES +(13110, 'Krieger_Pistol1', 'Glorious Pistol', 4, 0, 0, 0, 80, 0, 7, 0, 16777216, 7, 2, 34, 4, 80, 1, 17, 'bonus2 bAddRace,RC_DemiHuman,55; bonus2 bIgnoreDefRate,RC_DemiHuman,20; bonus bUnbreakableWeapon,0; if(getrefine()>5){ bonus2 bAddRace,RC_DemiHuman,pow(getrefine()-4,2); bonus2 bIgnoreDefRate,RC_DemiHuman,5; } if(getrefine()>8) { bonus4 bAutoSpellOnSkill,"GS_RAPIDSHOWER","GS_GLITTERING",1,1000; bonus2 bSkillAtk,"GS_RAPIDSHOWER",getrefine()*2; }', '', ''), (13112, 'P_Revolver1', 'Eden Revlover I', 4, 0, 0, 0, 4, 0, 7, 0, 16777216, 7, 2, 34, 1, 26, 0, 17, 'bonus bHit,-5;', '', ''), (13113, 'P_Revolver2', 'Eden Revlover II', 4, 0, 0, 0, 60, 0, 7, 0, 16777216, 7, 2, 34, 1, 40, 0, 17, 'bonus bHit,-5;', '', ''), (13150, 'Branch', 'Branch', 4, 3000, 1500, 500, 50, 0, 9, 3, 16777216, 7, 2, 34, 1, 1, 1, 18, '', '', ''), @@ -5399,11 +5399,11 @@ INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy (13673, 'Vesper_Core02_Box1', 'Refined Vesper Core 02 Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'rentitem 2697,604800;', '', ''), (13674, 'Vesper_Core03_Box1', 'Refined Vesper Core 03 Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'rentitem 2698,604800;', '', ''), (13675, 'Vesper_Core04_Box1', 'Refined Vesper Core 04 Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'rentitem 2699,604800;', '', ''), -(13676, 'Drooping_Kitty_Box1', 'Refined Drooping Cat Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'rentitem 5279,1209600;', '', ''), +(13676, 'Drooping_Kitty_Box1', 'Refined Drooping Cat Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'rentitem 5279,1209600;', '', ''); +INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy`, `price_sell`, `weight`, `atk`, `defence`, `range`, `slots`, `equip_jobs`, `equip_upper`, `equip_genders`, `equip_locations`, `weapon_level`, `equip_level`, `refineable`, `view`, `script`, `equip_script`, `unequip_script`) VALUES (13677, 'Magestic_Goat_Box1', 'Refined Majestic Goat Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'rentitem 5280,1209600;', '', ''), (13678, 'Deviruchi_Cap_Box1', 'Refined Deviruchi Hat Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'rentitem 5281,1209600;', '', ''), -(13679, 'Executioner_Box1', 'Refined Executioner Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'rentitem 1174,604800;', '', ''); -INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy`, `price_sell`, `weight`, `atk`, `defence`, `range`, `slots`, `equip_jobs`, `equip_upper`, `equip_genders`, `equip_locations`, `weapon_level`, `equip_level`, `refineable`, `view`, `script`, `equip_script`, `unequip_script`) VALUES +(13679, 'Executioner_Box1', 'Refined Executioner Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'rentitem 1174,604800;', '', ''), (13680, 'Brood_Axe_Box1', 'Refined Bloody Axe Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'rentitem 1373,604800;', '', ''), (13681, 'Tomahawk_Box1', 'Refined Tomahawk Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'rentitem 1374,604800;', '', ''), (13682, 'Bow_Of_Rudra_Box1', 'Refined Rudra Bow Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'rentitem 1729,604800;', '', ''), @@ -5730,12 +5730,12 @@ INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy (14018, 'F_Spritual_Tunic_Box', 'Spiritual Tunic Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'rentitem 2384,604800;', '', ''), (14019, 'F_Recuperative_Box', 'Recuvative Armor Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'rentitem 2385,604800;', '', ''), (14020, 'F_Shelter_Resist_Box', 'Shell Of Resistance Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'rentitem 2132,604800;', '', ''), -(14021, 'F_Sylphid_Manteau_Box', 'Silf Manteau Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'rentitem 2543,604800;', '', ''), +(14021, 'F_Sylphid_Manteau_Box', 'Silf Manteau Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'rentitem 2543,604800;', '', ''); +INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy`, `price_sell`, `weight`, `atk`, `defence`, `range`, `slots`, `equip_jobs`, `equip_upper`, `equip_genders`, `equip_locations`, `weapon_level`, `equip_level`, `refineable`, `view`, `script`, `equip_script`, `unequip_script`) VALUES (14022, 'F_Refresh_Shoes_Box', 'Refresh Shoes Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'rentitem 2439,604800;', '', ''), (14023, 'F_Toast_Box', 'Crunch Toast Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'rentitem 5391,604800;', '', ''), (14024, 'F_Robo_Eye_Box', 'Robo Eye Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'getitem 5325,1;', '', ''), -(14025, 'F_Twin_Ribbon_Box', 'Maiden''s Twin Ribbon Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'getitem 5187,1;', '', ''); -INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy`, `price_sell`, `weight`, `atk`, `defence`, `range`, `slots`, `equip_jobs`, `equip_upper`, `equip_genders`, `equip_locations`, `weapon_level`, `equip_level`, `refineable`, `view`, `script`, `equip_script`, `unequip_script`) VALUES +(14025, 'F_Twin_Ribbon_Box', 'Maiden''s Twin Ribbon Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'getitem 5187,1;', '', ''), (14027, 'F_Fish_Head_Hat_Box', 'Fish Head Hat Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'getitem 5380,1;', '', ''), (14028, 'F_Santa_Poring_Hat_Box', 'SantaPoring Cap Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'getitem 5381,1;', '', ''), (14029, 'F_Bell_Ribbon_Box', 'Bell Ribbon Box', 18, 20, 10, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'getitem 5382,1;', '', ''), @@ -6029,11 +6029,11 @@ INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy (14509, 'Light_Center_Pot', 'Light Concentration Potion', 2, 800, 400, 20, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start SC_ATTHASTE_POTION1,1800000,0;', '', ''), (14510, 'Light_Awakening_Pot', 'Light Awakening Potion', 2, 1500, 750, 20, 0, 0, 0, 0, 4294442735, 7, 2, 0, 0, 40, 0, 0, 'sc_start SC_ATTHASTE_POTION2,1800000,0;', '', ''), (14511, 'Light_Berserk_Pot', 'Light Berserk Potion', 2, 3000, 1500, 20, 0, 0, 0, 0, 31868582, 7, 2, 0, 0, 85, 0, 0, 'sc_start SC_ATTHASTE_POTION3,1800000,0;', '', ''), -(14512, 'Meteor_10_Scroll', 'Meteor Storm Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "WZ_METEOR",10;', '', ''), -(14513, 'Storm_10_Scroll', 'Storm Gust Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "WZ_STORMGUST",10;', '', ''), -(14514, 'Vermilion_10_Scroll', 'Lord of Vermilion Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "WZ_VERMILION",10;', '', ''), -(14515, 'Lex_Aeterna_Scroll', 'Lex Aeterna Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "PR_LEXAETERNA",1;', '', ''), -(14516, 'Magnificat_5_Scroll', 'Magnificat Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "PR_MAGNIFICAT",5;', '', ''), +(14512, 'Meteor_10_Scroll', 'Meteor Storm Scroll', 11, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "WZ_METEOR",10;', '', ''), +(14513, 'Storm_10_Scroll', 'Storm Gust Scroll', 11, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "WZ_STORMGUST",10;', '', ''), +(14514, 'Vermilion_10_Scroll', 'Lord of Vermilion Scroll', 11, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "WZ_VERMILION",10;', '', ''), +(14515, 'Lex_Aeterna_Scroll', 'Lex Aeterna Scroll', 11, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "PR_LEXAETERNA",1;', '', ''), +(14516, 'Magnificat_5_Scroll', 'Magnificat Scroll', 11, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "PR_MAGNIFICAT",5;', '', ''), (14517, 'CP_Helm_Scroll', 'Chemical Protection Helm Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'unitskilluseid getcharid(3),237,5;', '', ''), (14518, 'CP_Shield_Scroll', 'Chemical Protection Shield Scrol', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'unitskilluseid getcharid(3),235,5;', '', ''), (14519, 'CP_Armor_Scroll', 'Chemical Protection Armor Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'unitskilluseid getcharid(3),236,5;', '', ''), @@ -6046,7 +6046,7 @@ INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy (14526, 'Oriental_Pastry', 'Oriental Pastry', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start SC_PLUSMAGICPOWER,180000,10;', '', ''), (14527, 'Dun_Tele_Scroll1', 'Dungeon Teleport Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'callfunc "F_CashDungeon";', '', ''), (14528, 'PVP_Tele_Scroll', 'PVP Teleport Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), -(14529, 'Greed_Scroll', 'Greed Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "BS_GREED",1;', '', ''), +(14529, 'Greed_Scroll', 'Greed Scroll', 11, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "BS_GREED",1;', '', ''), (14530, 'Flee_30_Scroll', 'Evasion Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start SC_INCFLEE,1800000,30;', '', ''), (14531, 'Accuracy_30_Scroll', 'Concentration Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start SC_INCHIT,1800000,30;', '', ''), (14532, 'Battle_Manual25', 'Field Manual 25%', 2, 2, 1, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start SC_CASH_PLUSEXP,1800000,25;', '', ''), @@ -6060,11 +6060,11 @@ INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy (14540, 'Holy_Armor_S', 'Holy Armor Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'specialeffect2 91; sc_start4 SC_ARMOR_PROPERTY,1800000,1,Ele_Holy,1,0;', '', ''), (14541, 'S_Def_Potion', 'Small Defense Potion', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'specialeffect2 EF_GUARD; sc_start SC_PROTECT_DEF,60000,3;', '', ''), (14542, 'B_Def_Potion', 'Big Defense Potion', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'specialeffect2 EF_GUARD; sc_start SC_PROTECT_DEF,180000,3;', '', ''), -(14543, 'S_Mdef_Potion', 'Small Magic Defense Potion', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'specialeffect2 EF_SPELLBREAKER; sc_start SC_PROTECT_MDEF,60000,3;', '', ''), +(14543, 'S_Mdef_Potion', 'Small Magic Defense Potion', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'specialeffect2 EF_SPELLBREAKER; sc_start SC_PROTECT_MDEF,60000,3;', '', ''); +INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy`, `price_sell`, `weight`, `atk`, `defence`, `range`, `slots`, `equip_jobs`, `equip_upper`, `equip_genders`, `equip_locations`, `weapon_level`, `equip_level`, `refineable`, `view`, `script`, `equip_script`, `unequip_script`) VALUES (14544, 'B_Mdef_Potion', 'Big Magic Defense Potion', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'specialeffect2 EF_SPELLBREAKER; sc_start SC_PROTECT_MDEF,180000,3;', '', ''), (14545, 'Battle_Manual_X3', 'Field Manual 300%', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start SC_CASH_PLUSEXP,1800000,300;', '', ''), -(14546, 'Fire_Cracker_Love', 'I Love You Firecracker', 2, 2, 1, 20, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'end;', '', ''); -INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy`, `price_sell`, `weight`, `atk`, `defence`, `range`, `slots`, `equip_jobs`, `equip_upper`, `equip_genders`, `equip_locations`, `weapon_level`, `equip_level`, `refineable`, `view`, `script`, `equip_script`, `unequip_script`) VALUES +(14546, 'Fire_Cracker_Love', 'I Love You Firecracker', 2, 2, 1, 20, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'end;', '', ''), (14547, 'Fire_Cracker_Wday', 'Whiteday Firecracker', 2, 2, 1, 20, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'end;', '', ''), (14548, 'Fire_Cracker_Valentine', 'Valentine''s Day Firecracker', 2, 2, 1, 20, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'end;', '', ''), (14549, 'Fire_Cracker_Bday', 'Birthday Firecracker', 2, 2, 1, 20, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'end;', '', ''), @@ -6105,14 +6105,14 @@ INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy (14584, 'WOB_Rachel', 'Red Butterfly Wing', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'callfunc "F_CashCity",3;', '', ''), (14585, 'WOB_Local', 'Blue Butterfly Wing', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'callfunc "F_CashCity",4;', '', ''), (14586, 'Spark_Candy', 'Jumping Candy', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, '', '', ''), -(14587, 'Repair_Scroll_', 'Equipment Repair Spell Book', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "BS_REPAIRWEAPON",1;', '', ''), -(14588, 'Pty_Blessing_Scroll', 'Party Blessing 10 Scroll', 2, 10, 5, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "CASH_BLESSING",10;', '', ''), -(14589, 'Pty_Inc_Agi_Scroll', 'Party Increase Agi 10 Scroll', 2, 10, 5, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "CASH_INCAGI",10;', '', ''), -(14590, 'Pty_Assumptio_Scroll', 'Party Assumptio 5 Scroll', 2, 10, 5, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "CASH_ASSUMPTIO",5;', '', ''), +(14587, 'Repair_Scroll_', 'Equipment Repair Spell Book', 11, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "BS_REPAIRWEAPON",1;', '', ''), +(14588, 'Pty_Blessing_Scroll', 'Party Blessing 10 Scroll', 11, 10, 5, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "CASH_BLESSING",10;', '', ''), +(14589, 'Pty_Inc_Agi_Scroll', 'Party Increase Agi 10 Scroll', 11, 10, 5, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "CASH_INCAGI",10;', '', ''), +(14590, 'Pty_Assumptio_Scroll', 'Party Assumptio 5 Scroll', 11, 10, 5, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "CASH_ASSUMPTIO",5;', '', ''), (14591, 'Siege_Teleport_Scroll', 'WoE Teleport Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'callfunc "F_CashSeigeTele";', '', ''), (14592, 'Job_Manual50', 'JOB Battle Manual', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start SC_CASH_PLUSONLYJOBEXP,1800000,50;', '', ''), -(14593, 'Magic_Power_Scroll', 'Mystical Amplification Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "HW_MAGICPOWER",10;', '', ''), -(14594, 'Quagmire_Scroll', 'Quagmire Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "WZ_QUAGMIRE",5;', '', ''), +(14593, 'Magic_Power_Scroll', 'Mystical Amplification Scroll', 11, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "HW_MAGICPOWER",10;', '', ''), +(14594, 'Quagmire_Scroll', 'Quagmire Scroll', 11, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'itemskill "WZ_QUAGMIRE",5;', '', ''), (14595, 'Unsealed_Magic_Spell', 'Unsealed Magic Spell', 2, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'warp "yuno_fild09",255,127;', '', ''), (14596, 'Pierre_Treasurebox', 'Pierre''s Treasure Box', 2, 0, 0, 100, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'getrandgroupitem 14596,1; getrandgroupitem 14596,1; getrandgroupitem 14596,1; getrandgroupitem 14596,1; getrandgroupitem 14596,1; getrandgroupitem 14596,1;', '', ''), (14597, 'PhreeoniS', 'Phreeoni Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 'sc_start SC_ITEMSCRIPT,180000,4121;', '', ''), @@ -6178,3 +6178,4 @@ INSERT INTO `item_db` (`id`, `name_english`, `name_japanese`, `type`, `price_buy (19505, 'T_Cigarette', 'T Cigarette', 5, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 4096, 0, 0, 0, 54, '', '', ''), (19506, 'T_Valkyrie_Feather_Band', 'T Valkyrie Feather Band', 5, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 1024, 0, 0, 1, 300, '', '', ''), (19507, 'Clear_Sun', 'Clear Sun', 5, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 1024, 0, 1, 0, 654, '', '', ''); + diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql index 5a1bef302..1df585585 100644 --- a/sql-files/item_db_re.sql +++ b/sql-files/item_db_re.sql @@ -127,17 +127,17 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (597, 'Lovely_Choco_Tart', 'Lovely Choco-Tart', 0, 20, 10, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemheal rand(10,400),0;', '', ''), (598, 'Light_Red_Pot', 'Light Red Potion', 0, 50, 25, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemheal rand(45,65),0;', '', ''), (599, 'Light_Orange_Pot', 'Light Orange Potion', 0, 200, 100, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemheal rand(105,145),0;', '', ''), -(601, 'Wing_Of_Fly', 'Fly Wing', 2, 60, 30, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "AL_TELEPORT",1;', '', ''), -(602, 'Wing_Of_Butterfly', 'Butterfly Wing', 2, 300, 150, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "AL_TELEPORT",3;', '', ''), +(601, 'Wing_Of_Fly', 'Fly Wing', 11, 60, 30, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "AL_TELEPORT",1;', '', ''), +(602, 'Wing_Of_Butterfly', 'Butterfly Wing', 11, 300, 150, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "AL_TELEPORT",3;', '', ''), (603, 'Old_Blue_Box', 'Old Blue Box', 2, 10000, 5000, 200, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'getrandgroupitem 603,1;', '', ''), (604, 'Branch_Of_Dead_Tree', 'Dead Branch', 2, 50, 25, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'monster "this",-1,-1,"--ja--",-1,1,"";', '', ''), -(605, 'Anodyne', 'Anodyne', 2, 2000, 1000, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "SM_ENDURE",1;', '', ''), -(606, 'Aloebera', 'Aloevera', 2, 1500, 750, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "SM_SELFPROVOKE",1;', '', ''), +(605, 'Anodyne', 'Anodyne', 11, 2000, 1000, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "SM_ENDURE",1;', '', ''), +(606, 'Aloebera', 'Aloevera', 11, 1500, 750, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "SM_SELFPROVOKE",1;', '', ''), (607, 'Yggdrasilberry', 'Yggdrasil Berry', 0, 5000, 2500, 300, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'percentheal 100,100;', '', ''), (608, 'Seed_Of_Yggdrasil', 'Yggdrasil Seed', 0, 5000, 2500, 300, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'percentheal 50,50;', '', ''), (609, 'Amulet', 'Amulet', 2, 100, 50, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''), -(610, 'Leaf_Of_Yggdrasil', 'Yggdrasil Leaf', 2, 4000, 2000, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "ALL_RESURRECTION",1;', '', ''), -(611, 'Spectacles', 'Magnifier', 2, 40, 20, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MC_IDENTIFY",1;', '', ''), +(610, 'Leaf_Of_Yggdrasil', 'Yggdrasil Leaf', 11, 4000, 2000, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "ALL_RESURRECTION",1;', '', ''), +(611, 'Spectacles', 'Magnifier', 11, 40, 20, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MC_IDENTIFY",1;', '', ''), (612, 'Portable_Furnace', 'Mini Furnace', 2, 150, 75, 200, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'produce 21;', '', ''), (613, 'Iron_Hammer', 'Iron Hammer', 2, 1000, 500, 200, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'produce 1;', '', ''), (614, 'Golden_Hammer', 'Golden Hammer', 2, 3000, 1500, 300, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'produce 2;', '', ''), @@ -202,21 +202,21 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (683, 'Exorcize_Herb', 'Herb of Incantation', 2, 0, 0, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start SC_PLUSMAGICPOWER,60000,30;', '', ''), (684, 'Durian', 'Durian', 2, 15000, 7500, 300, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start SC_PLUSATTACKPOWER,60000,10; sc_start SC_PLUSMAGICPOWER,60000,10;', '', ''), (685, 'RAMADAN', 'Ramadan', 0, 5000, 2500, 300, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'percentheal 100,50;', '', ''), -(686, 'Earth_Scroll_1_3', 'Level 3 Earth Spike', 2, 1000, 500, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "WZ_EARTHSPIKE",3;', '', ''), -(687, 'Earth_Scroll_1_5', 'Level 5 Earth Spike', 2, 2000, 1000, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "WZ_EARTHSPIKE",5;', '', ''), -(688, 'Cold_Scroll_1_3', 'Level 3 Cold Bolt', 2, 1000, 500, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MG_COLDBOLT",3;', '', ''), -(689, 'Cold_Scroll_1_5', 'Level 5 Cold Bolt', 2, 2000, 1000, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MG_COLDBOLT",5;', '', ''), -(690, 'Fire_Scroll_1_3', 'Level 3 Fire Bolt', 2, 1000, 500, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MG_FIREBOLT",3;', '', ''), -(691, 'Fire_Scroll_1_5', 'Level 5 Fire Bolt', 2, 2000, 1000, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MG_FIREBOLT",5;', '', ''), -(692, 'Wind_Scroll_1_3', 'Level 3 Lightening Bolt', 2, 1000, 500, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MG_LIGHTNINGBOLT",3;', '', ''), -(693, 'Wind_Scroll_1_5', 'Level 5 Lightening Bolt', 2, 2000, 1000, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MG_LIGHTNINGBOLT",5;', '', ''), -(694, 'Ghost_Scroll_1_3', 'Level 3 Soul Strike', 2, 1000, 500, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MG_SOULSTRIKE",3;', '', ''), -(695, 'Ghost_Scroll_1_5', 'Level 5 Soul Strike', 2, 2000, 1000, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MG_SOULSTRIKE",5;', '', ''), -(696, 'Fire_Scroll_2_1', 'Level 1 Fire Ball', 2, 1000, 500, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MG_FIREBALL",1;', '', ''), -(697, 'Fire_Scroll_2_5', 'Level 5 Fire Ball', 2, 2000, 1000, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MG_FIREBALL",5;', '', ''), -(698, 'Fire_Scroll_3_1', 'Level 1 Fire Wall', 2, 1000, 500, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MG_FIREWALL",1;', '', ''), -(699, 'Fire_Scroll_3_5', 'Level 5 Fire Wall', 2, 2000, 1000, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MG_FIREWALL",5;', '', ''), -(700, 'Cold_Scroll_2_1', 'Level 1 Frost Diver', 2, 1000, 500, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MG_FROSTDIVER",1;', '', ''), +(686, 'Earth_Scroll_1_3', 'Level 3 Earth Spike', 11, 1000, 500, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "WZ_EARTHSPIKE",3;', '', ''), +(687, 'Earth_Scroll_1_5', 'Level 5 Earth Spike', 11, 2000, 1000, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "WZ_EARTHSPIKE",5;', '', ''), +(688, 'Cold_Scroll_1_3', 'Level 3 Cold Bolt', 11, 1000, 500, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MG_COLDBOLT",3;', '', ''), +(689, 'Cold_Scroll_1_5', 'Level 5 Cold Bolt', 11, 2000, 1000, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MG_COLDBOLT",5;', '', ''), +(690, 'Fire_Scroll_1_3', 'Level 3 Fire Bolt', 11, 1000, 500, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MG_FIREBOLT",3;', '', ''), +(691, 'Fire_Scroll_1_5', 'Level 5 Fire Bolt', 11, 2000, 1000, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MG_FIREBOLT",5;', '', ''), +(692, 'Wind_Scroll_1_3', 'Level 3 Lightening Bolt', 11, 1000, 500, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MG_LIGHTNINGBOLT",3;', '', ''), +(693, 'Wind_Scroll_1_5', 'Level 5 Lightening Bolt', 11, 2000, 1000, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MG_LIGHTNINGBOLT",5;', '', ''), +(694, 'Ghost_Scroll_1_3', 'Level 3 Soul Strike', 11, 1000, 500, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MG_SOULSTRIKE",3;', '', ''), +(695, 'Ghost_Scroll_1_5', 'Level 5 Soul Strike', 11, 2000, 1000, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MG_SOULSTRIKE",5;', '', ''), +(696, 'Fire_Scroll_2_1', 'Level 1 Fire Ball', 11, 1000, 500, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MG_FIREBALL",1;', '', ''), +(697, 'Fire_Scroll_2_5', 'Level 5 Fire Ball', 11, 2000, 1000, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MG_FIREBALL",5;', '', ''), +(698, 'Fire_Scroll_3_1', 'Level 1 Fire Wall', 11, 1000, 500, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MG_FIREWALL",1;', '', ''), +(699, 'Fire_Scroll_3_5', 'Level 5 Fire Wall', 11, 2000, 1000, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MG_FIREWALL",5;', '', ''), +(700, 'Cold_Scroll_2_1', 'Level 1 Frost Diver', 11, 1000, 500, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MG_FROSTDIVER",1;', '', ''), (701, 'Ora_Ora', 'Ora Ora', 3, 55000, 27500, 200, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), (702, 'Animal_Blood', 'Animal Gore', 3, 450, 225, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), (703, 'Hinalle', 'Hinalle', 3, 500, 250, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), @@ -423,9 +423,9 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (1051, 'Detonator', 'Detonator', 3, 450, 225, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), (1052, 'Single_Cell', 'Single Cell', 3, 46, 23, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), (1053, 'Tooth_Of_Ancient_Fish', 'Ancient Tooth', 3, 548, 274, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), -(1054, 'Lip_Of_Ancient_Fish', 'Ancient Lips', 3, 1000, 500, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), -(1055, 'Earthworm_Peeling', 'Earthworm Peeling', 3, 196, 98, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''); +(1054, 'Lip_Of_Ancient_Fish', 'Ancient Lips', 3, 1000, 500, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''); INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_buy`, `price_sell`, `weight`, `atk`, `matk`, `defence`, `range`, `slots`, `equip_jobs`, `equip_upper`, `equip_genders`, `equip_locations`, `weapon_level`, `equip_level_min`, `equip_level_max`, `refineable`, `view`, `script`, `equip_script`, `unequip_script`) VALUES +(1055, 'Earthworm_Peeling', 'Earthworm Peeling', 3, 196, 98, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), (1056, 'Grit', 'Grit', 3, 306, 153, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), (1057, 'Moth_Dust', 'Moth Dust', 3, 138, 69, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), (1058, 'Wing_Of_Moth', 'Moth Wings', 3, 200, 100, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), @@ -736,9 +736,9 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (1405, 'Spear_', 'Spear', 4, 1700, 850, 850, 44, 0, 0, 3, 4, 16514, 7, 2, 2, 1, 4, 0, 1, 4, '', '', ''), (1406, 'Spear__', 'Spear', 4, 1700, 850, 850, 44, 0, 0, 3, 0, 16514, 7, 2, 2, 1, 4, 0, 1, 4, '', '', ''), (1407, 'Pike', 'Pike', 4, 3450, 1725, 1000, 60, 0, 0, 3, 3, 16514, 7, 2, 2, 1, 4, 0, 1, 4, '', '', ''), -(1408, 'Pike_', 'Pike', 4, 3450, 1725, 1000, 60, 0, 0, 3, 4, 16514, 7, 2, 2, 1, 4, 0, 1, 4, '', '', ''), -(1409, 'Pike__', 'Pike', 4, 3450, 1725, 1000, 60, 0, 0, 3, 0, 16514, 7, 2, 2, 1, 4, 0, 1, 4, '', '', ''); +(1408, 'Pike_', 'Pike', 4, 3450, 1725, 1000, 60, 0, 0, 3, 4, 16514, 7, 2, 2, 1, 4, 0, 1, 4, '', '', ''); INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_buy`, `price_sell`, `weight`, `atk`, `matk`, `defence`, `range`, `slots`, `equip_jobs`, `equip_upper`, `equip_genders`, `equip_locations`, `weapon_level`, `equip_level_min`, `equip_level_max`, `refineable`, `view`, `script`, `equip_script`, `unequip_script`) VALUES +(1409, 'Pike__', 'Pike', 4, 3450, 1725, 1000, 60, 0, 0, 3, 0, 16514, 7, 2, 2, 1, 4, 0, 1, 4, '', '', ''), (1410, 'Lance', 'Lance', 4, 60000, 30000, 2500, 185, 0, 0, 3, 0, 16514, 7, 2, 34, 3, 33, 0, 1, 5, '', '', ''), (1411, 'Lance_', 'Lance', 4, 60000, 30000, 2500, 185, 0, 0, 3, 0, 16514, 7, 2, 34, 3, 33, 0, 1, 5, '', '', ''), (1412, 'Lance__', 'Lance', 4, 60000, 30000, 2500, 185, 0, 0, 3, 0, 16514, 7, 2, 34, 3, 33, 0, 1, 5, '', '', ''), @@ -1011,9 +1011,9 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (1750, 'Arrow', 'Arrow', 10, 1, 0, 1, 25, 0, 0, 0, 0, 661576, 7, 2, 32768, 0, 1, 0, 0, 1, '', '', ''), (1751, 'Silver_Arrow', 'Silver Arrow', 10, 3, 1, 2, 30, 0, 0, 0, 0, 661576, 7, 2, 32768, 0, 1, 0, 0, 1, 'bonus bAtkEle,Ele_Holy;', '', ''), (1752, 'Fire_Arrow', 'Fire Arrow', 10, 3, 1, 2, 30, 0, 0, 0, 0, 661576, 7, 2, 32768, 0, 1, 0, 0, 1, 'bonus bAtkEle,Ele_Fire;', '', ''), -(1753, 'Steel_Arrow', 'Steel Arrow', 10, 4, 2, 2, 40, 0, 0, 0, 0, 661576, 7, 2, 32768, 0, 1, 0, 0, 1, '', '', ''), -(1754, 'Crystal_Arrow', 'Crystal Arrow', 10, 3, 1, 2, 30, 0, 0, 0, 0, 661576, 7, 2, 32768, 0, 1, 0, 0, 1, 'bonus bAtkEle,Ele_Water;', '', ''); +(1753, 'Steel_Arrow', 'Steel Arrow', 10, 4, 2, 2, 40, 0, 0, 0, 0, 661576, 7, 2, 32768, 0, 1, 0, 0, 1, '', '', ''); INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_buy`, `price_sell`, `weight`, `atk`, `matk`, `defence`, `range`, `slots`, `equip_jobs`, `equip_upper`, `equip_genders`, `equip_locations`, `weapon_level`, `equip_level_min`, `equip_level_max`, `refineable`, `view`, `script`, `equip_script`, `unequip_script`) VALUES +(1754, 'Crystal_Arrow', 'Crystal Arrow', 10, 3, 1, 2, 30, 0, 0, 0, 0, 661576, 7, 2, 32768, 0, 1, 0, 0, 1, 'bonus bAtkEle,Ele_Water;', '', ''), (1755, 'Arrow_Of_Wind', 'Arrow of Wind', 10, 3, 1, 2, 30, 0, 0, 0, 0, 661576, 7, 2, 32768, 0, 1, 0, 0, 1, 'bonus bAtkEle,Ele_Wind;', '', ''), (1756, 'Stone_Arrow', 'Stone Arrow', 10, 3, 1, 2, 30, 0, 0, 0, 0, 661576, 7, 2, 32768, 0, 1, 0, 0, 1, 'bonus bAtkEle,Ele_Earth;', '', ''), (1757, 'Immatrial_Arrow', 'Immaterial Arrow', 10, 3, 1, 1, 30, 0, 0, 0, 0, 661576, 7, 2, 32768, 0, 1, 0, 0, 1, 'bonus bAtkEle,Ele_Ghost;', '', ''), @@ -1306,9 +1306,9 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (2273, 'Doctor_Cap', 'Doctor Band', 5, 20, 10, 100, 0, 0, 5, 0, 0, 4294967294, 7, 2, 256, 0, 0, 0, 1, 60, 'bonus bInt,1;', '', ''), (2274, 'Ghost_Bandana', 'Ghost Bandana', 5, 20, 10, 100, 0, 0, 0, 0, 0, 4294967294, 7, 2, 256, 0, 0, 0, 1, 61, 'bonus bAgi,2; bonus2 bSubEle,Ele_Ghost,10;', '', ''), (2275, 'Red_Bandana', 'Red Bandana', 5, 20, 10, 100, 0, 0, 4, 0, 0, 4294967295, 7, 2, 256, 0, 0, 0, 1, 62, '', '', ''), -(2276, 'Eagle_Eyes', 'Angled Glasses', 5, 20, 10, 100, 0, 0, 2, 0, 0, 4294967295, 7, 2, 512, 0, 0, 0, 0, 63, '', '', ''), -(2277, 'Nurse_Cap', 'Nurse Cap', 5, 20, 10, 100, 0, 0, 4, 0, 0, 33040, 7, 2, 256, 0, 0, 0, 1, 64, 'bonus bInt,1;', '', ''); +(2276, 'Eagle_Eyes', 'Angled Glasses', 5, 20, 10, 100, 0, 0, 2, 0, 0, 4294967295, 7, 2, 512, 0, 0, 0, 0, 63, '', '', ''); INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_buy`, `price_sell`, `weight`, `atk`, `matk`, `defence`, `range`, `slots`, `equip_jobs`, `equip_upper`, `equip_genders`, `equip_locations`, `weapon_level`, `equip_level_min`, `equip_level_max`, `refineable`, `view`, `script`, `equip_script`, `unequip_script`) VALUES +(2277, 'Nurse_Cap', 'Nurse Cap', 5, 20, 10, 100, 0, 0, 4, 0, 0, 33040, 7, 2, 256, 0, 0, 0, 1, 64, 'bonus bInt,1;', '', ''), (2278, 'Mr_Smile', 'Mr. Smile', 5, 60, 30, 100, 0, 0, 1, 0, 0, 4294967295, 7, 2, 513, 0, 0, 0, 0, 65, '', '', ''), (2279, 'Bomb_Wick', 'Bomb Wick', 5, 20, 10, 100, 0, 0, 1, 0, 0, 4294967295, 7, 2, 256, 0, 0, 0, 0, 66, '', '', ''), (2280, 'Sahkkat', 'Sakkat', 5, 20, 10, 300, 0, 0, 4, 0, 0, 4294967295, 7, 2, 256, 0, 0, 0, 1, 67, 'bonus bAgi,1;', '', ''), @@ -1604,9 +1604,9 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (2583, 'Holy_Cape', 'Holy Cape', 5, 20, 10, 100, 0, 0, 5, 0, 1, 4294967295, 7, 2, 4, 0, 50, 0, 1, 0, 'bonus bDex,-5; bonus bMdef,5;', '', ''), (2584, 'Wanderer_Outer', 'Wanderer Outer', 5, 20, 10, 500, 0, 0, 8, 0, 1, 4294967295, 7, 2, 4, 0, 0, 0, 1, 0, '', '', ''), (2585, 'Muffler_Of_Valor', 'Muffler Of Valor', 5, 0, 0, 0, 0, 0, 4, 0, 0, 4294967295, 7, 2, 4, 0, 0, 0, 0, 0, '', '', ''), -(2586, 'Siege_Manteau', 'Siege Manteau', 5, 10, 5, 600, 0, 0, 32, 0, 1, 4294967294, 7, 2, 4, 0, 95, 0, 1, 0, 'bonus bMdef,1; bonus2 bSubRace,RC_DemiHuman,2;', '', ''), -(2587, 'Siege_Muffler', 'Siege Muffler', 5, 10, 5, 400, 0, 0, 15, 0, 1, 4294967295, 7, 2, 4, 0, 95, 0, 1, 0, 'bonus bMdef,10; bonus2 bSubRace,RC_DemiHuman,2;', '', ''); +(2586, 'Siege_Manteau', 'Siege Manteau', 5, 10, 5, 600, 0, 0, 32, 0, 1, 4294967294, 7, 2, 4, 0, 95, 0, 1, 0, 'bonus bMdef,1; bonus2 bSubRace,RC_DemiHuman,2;', '', ''); INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_buy`, `price_sell`, `weight`, `atk`, `matk`, `defence`, `range`, `slots`, `equip_jobs`, `equip_upper`, `equip_genders`, `equip_locations`, `weapon_level`, `equip_level_min`, `equip_level_max`, `refineable`, `view`, `script`, `equip_script`, `unequip_script`) VALUES +(2587, 'Siege_Muffler', 'Siege Muffler', 5, 10, 5, 400, 0, 0, 15, 0, 1, 4294967295, 7, 2, 4, 0, 95, 0, 1, 0, 'bonus bMdef,10; bonus2 bSubRace,RC_DemiHuman,2;', '', ''), (2588, 'Ragamuffin_Cape_', 'Ragamuffin Cape', 5, 56000, 28000, 500, 0, 0, 4, 0, 1, 4294967294, 7, 2, 4, 0, 40, 0, 1, 0, 'bonus bMdef,10;', '', ''), (2589, 'Fallen_Angel_Wing', 'Fallen Angel Wing', 5, 0, 0, 200, 0, 0, 18, 0, 0, 4294967295, 7, 2, 4, 0, 0, 0, 1, 3, 'bonus bLuk,2; bonus bMdef,18;', '', ''), (2590, 'Buwaya_Skin_Clothes', 'Buwaya Skin Clothes', 5, 20, 10, 200, 0, 0, 8, 0, 0, 4294967295, 7, 2, 4, 0, 1, 0, 1, 0, 'bonus bHealpower2,getrefine()/3; bonus bAddItemHealRate,getrefine()/3; bonus2 bSubEle,Ele_Water,10; bonus2 bSubEle,Ele_Wind,10; bonus2 bSubEle,Ele_Earth,10; bonus2 bSubEle,Ele_Fire,10;', '', ''), @@ -1909,9 +1909,9 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (2896, 'Medal_Of_Valor2', 'Medal Of Valor2', 5, 0, 0, 0, 0, 0, 4, 0, 0, 4294967295, 7, 2, 136, 0, 0, 0, 0, 0, '', '', ''), (2897, '2011RWC_Necklace_J', '2011RWC Necklace J', 5, 0, 0, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 136, 0, 0, 0, 0, 0, '', '', ''), (2898, 'Dark_Rosary', 'Dark Rosary', 5, 20, 10, 100, 0, 0, 0, 0, 1, 4294967295, 7, 2, 136, 0, 90, 0, 0, 0, 'bonus bMdef,15;', '', ''), -(2899, 'Sound_Amplification_Device', 'Sound Amplification Device', 5, 20, 10, 100, 0, 0, 0, 0, 1, 526336, 7, 2, 136, 0, 90, 0, 0, 0, 'bonus2 bSkillAtk,"WM_METALICSOUND",25; bonus bVariableCastrate,-50;', '', ''), -(2900, 'Morrigane''s_Belt_', 'Morrigane''s Belt', 5, 30000, 15000, 200, 0, 0, 0, 0, 1, 4294967294, 7, 2, 136, 0, 61, 0, 0, 0, '', '', ''); +(2899, 'Sound_Amplification_Device', 'Sound Amplification Device', 5, 20, 10, 100, 0, 0, 0, 0, 1, 526336, 7, 2, 136, 0, 90, 0, 0, 0, 'bonus2 bSkillAtk,"WM_METALICSOUND",25; bonus bVariableCastrate,-50;', '', ''); INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_buy`, `price_sell`, `weight`, `atk`, `matk`, `defence`, `range`, `slots`, `equip_jobs`, `equip_upper`, `equip_genders`, `equip_locations`, `weapon_level`, `equip_level_min`, `equip_level_max`, `refineable`, `view`, `script`, `equip_script`, `unequip_script`) VALUES +(2900, 'Morrigane''s_Belt_', 'Morrigane''s Belt', 5, 30000, 15000, 200, 0, 0, 0, 0, 1, 4294967294, 7, 2, 136, 0, 61, 0, 0, 0, '', '', ''), (2901, 'Morrigane''s_Pendant_', 'Morrigane''s Pendant', 5, 30000, 15000, 200, 0, 0, 0, 0, 1, 4294967294, 7, 2, 136, 0, 61, 0, 0, 0, 'bonus bStr,2;', '', ''), (2902, 'Morpheus''s_Ring_', 'Morpheus''s Ring', 5, 30000, 15000, 100, 0, 0, 0, 0, 1, 4294967294, 7, 2, 136, 0, 33, 0, 0, 0, 'bonus bInt,1;', '', ''), (2903, 'Morpheus''s_Armlet_', 'Morpheus''s Armlet', 5, 30000, 15000, 100, 0, 0, 0, 0, 1, 4294967294, 7, 2, 136, 0, 33, 0, 0, 0, 'bonus bInt,1;', '', ''), @@ -2231,9 +2231,9 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (4280, 'Geographer_Card', 'Geographer Card', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 'bonus3 bAutoSpellWhenHit,"AL_BLESSING",2+8*(getskilllv("AL_BLESSING")==10),30;', '', ''), (4281, 'Zipper_Bear_Card', 'Zipper Bear Card', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 'bonus bBaseAtk,30; bonus2 bSPDrainValue,-1,0; if(BaseClass==Job_Merchant) bonus bUnbreakableWeapon,0;', '', ''), (4282, 'Tengu_Card', 'Tengu Card', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 136, 0, 0, 0, 0, 0, 'bonus bAddMonsterDropChainItem,ITMCHAIN_HEAL;', '', ''), -(4283, 'Greatest_General_Card', 'Greatest General Card', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 136, 0, 0, 0, 0, 0, 'bonus3 bAutoSpell,"MO_CALLSPIRITS",5,2+18*(BaseClass==Job_Acolyte);', '', ''), -(4284, 'Chepet_Card', 'Chepet Card', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 'bonus4 bAutoSpell,"AL_HEAL",5,50,1;', '', ''); +(4283, 'Greatest_General_Card', 'Greatest General Card', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 136, 0, 0, 0, 0, 0, 'bonus3 bAutoSpell,"MO_CALLSPIRITS",5,2+18*(BaseClass==Job_Acolyte);', '', ''); INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_buy`, `price_sell`, `weight`, `atk`, `matk`, `defence`, `range`, `slots`, `equip_jobs`, `equip_upper`, `equip_genders`, `equip_locations`, `weapon_level`, `equip_level_min`, `equip_level_max`, `refineable`, `view`, `script`, `equip_script`, `unequip_script`) VALUES +(4284, 'Chepet_Card', 'Chepet Card', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 'bonus4 bAutoSpell,"AL_HEAL",5,50,1;', '', ''), (4285, 'Choco_Card', 'Choco Card', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 'bonus bFlee2,5; bonus bFlee,10;', '', ''), (4286, 'Karakasa_Card', 'Karakasa Card', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 'bonus2 bAddEffWhenHit,Eff_Confusion,300+600*(readparam(bStr)>=77);', '', ''), (4287, 'Kapha_Card', 'Kapha Card', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 'if(getrefine()<6) bonus bMdef,8;', '', ''), @@ -2507,9 +2507,9 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (4705, 'Strength6', 'STR+6', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 'bonus bStr,6;', '', ''), (4706, 'Strength7', 'STR+7', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 'bonus bStr,7;', '', ''), (4707, 'Strength8', 'STR+8', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 'bonus bStr,8;', '', ''), -(4708, 'Strength9', 'STR+9', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 'bonus bStr,9;', '', ''), -(4709, 'Strength10', 'STR+10', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 'bonus bStr,10;', '', ''); +(4708, 'Strength9', 'STR+9', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 'bonus bStr,9;', '', ''); INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_buy`, `price_sell`, `weight`, `atk`, `matk`, `defence`, `range`, `slots`, `equip_jobs`, `equip_upper`, `equip_genders`, `equip_locations`, `weapon_level`, `equip_level_min`, `equip_level_max`, `refineable`, `view`, `script`, `equip_script`, `unequip_script`) VALUES +(4709, 'Strength10', 'STR+10', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 'bonus bStr,10;', '', ''), (4710, 'Inteligence1', 'INT+1', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 'bonus bInt,1;', '', ''), (4711, 'Inteligence2', 'INT+2', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 'bonus bInt,2;', '', ''), (4712, 'Inteligence3', 'INT+3', 6, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 'bonus bInt,3;', '', ''), @@ -2874,9 +2874,9 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (5206, 'Romantic_White_Flower', 'Romantic White Flower', 5, 20, 10, 100, 0, 0, 0, 0, 0, 4294967294, 7, 2, 1, 0, 0, 0, 0, 259, 'bonus2 bSubRace,RC_Plant,3;', '', ''), (5207, 'Gold_Spirit_Chain', 'Angel Blessing', 5, 20, 10, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 256, 0, 0, 0, 0, 260, 'bonus bLuk,1; bonus2 bSubEle,Ele_Holy,5;', '', ''), (5208, 'Rideword_Hat', 'Rideword Hat', 5, 20, 10, 300, 0, 0, 2, 0, 1, 4294967294, 7, 2, 256, 0, 40, 0, 1, 262, 'bonus2 bHPDrainRate,50,8; bonus2 bSPDrainRate,10,4; bonus2 bHPLossRate,10,5000;', '', ''), -(5209, 'Yellow_Baseball_Cap', 'Love Dad Cap', 5, 20, 10, 300, 0, 0, 2, 0, 0, 4294967295, 7, 2, 256, 0, 0, 0, 1, 263, '', '', ''), -(5210, 'Flying_Angel', 'Flapping Angel Wing', 5, 20, 10, 300, 0, 0, 1, 0, 0, 4294967295, 7, 2, 256, 0, 10, 0, 1, 264, 'bonus bVariableCastrate,-3; bonus bAspdRate,3; bonus bInt,1; bonus bAgi,1;', '', ''); +(5209, 'Yellow_Baseball_Cap', 'Love Dad Cap', 5, 20, 10, 300, 0, 0, 2, 0, 0, 4294967295, 7, 2, 256, 0, 0, 0, 1, 263, '', '', ''); INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_buy`, `price_sell`, `weight`, `atk`, `matk`, `defence`, `range`, `slots`, `equip_jobs`, `equip_upper`, `equip_genders`, `equip_locations`, `weapon_level`, `equip_level_min`, `equip_level_max`, `refineable`, `view`, `script`, `equip_script`, `unequip_script`) VALUES +(5210, 'Flying_Angel', 'Flapping Angel Wing', 5, 20, 10, 300, 0, 0, 1, 0, 0, 4294967295, 7, 2, 256, 0, 10, 0, 1, 264, 'bonus bVariableCastrate,-3; bonus bAspdRate,3; bonus bInt,1; bonus bAgi,1;', '', ''), (5211, 'Dress_Hat', 'Dress Hat', 5, 0, 0, 200, 0, 0, 2, 0, 1, 4294967295, 7, 2, 256, 0, 20, 0, 1, 265, 'bonus bMdef,7; bonus bStr,1; bonus bInt,1; bonus2 bAddRace,RC_NonBoss,2; bonus2 bAddRace,RC_Boss,2; bonus bMAtkRate,2; bonus bHealPower,5; if(getrefine()>=7) { bonus2 bAddRace,RC_NonBoss,1; bonus2 bAddRace,RC_Boss,1; bonus bMAtkRate,1; bonus bHealPower,1; }', '', ''), (5212, 'Satellite_Hairband', 'Satellite Hairband', 5, 0, 0, 1000, 0, 0, 3, 0, 1, 4294967295, 7, 2, 256, 0, 30, 0, 1, 266, 'bonus bMaxHP,50; bonus bMaxSP,10; skill "AL_RUWACH",1;', '', 'sc_end SC_RUWACH;'), (5213, 'Black_Bunny_Band', 'Sheila Hairnet', 5, 0, 0, 200, 0, 0, 2, 0, 0, 4294967295, 7, 2, 256, 0, 1, 0, 1, 267, 'bonus bAgi,2; bonus bMdef,3;', '', ''), @@ -3162,9 +3162,9 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (5494, 'Spinx_Helm_I', 'Sphinx Hat', 5, 0, 0, 0, 0, 0, 5, 0, 0, 16514, 7, 2, 257, 0, 0, 0, 0, 137, 'bonus bStr,5;', '', ''), (5495, 'Power_Of_Thor', 'Power Of Thor', 5, 20, 10, 100, 0, 0, 6, 0, 1, 4294967295, 7, 2, 256, 0, 0, 0, 1, 493, 'bonus bInt,1; bonus bDex,1; bonus bMdef,3; bonus bFlee,5;', '', ''), (5496, 'Dice_Hat', 'Dice Hat', 5, 20, 10, 300, 0, 0, 3, 0, 0, 4294967295, 7, 2, 256, 0, 50, 0, 0, 494, 'bonus bLuk,4;', '', ''), -(5497, 'King_Tiger_Doll_Hat', 'King Tiger Doll Hat', 5, 20, 10, 400, 0, 0, 3, 0, 1, 4294967294, 7, 2, 256, 0, 0, 0, 1, 495, 'bonus bStr,2;', '', ''), -(5498, 'Wondering_Wolf_Helm', 'Wandering Wolf Helm', 5, 20, 10, 600, 0, 0, 5, 0, 0, 4294967294, 7, 2, 768, 0, 20, 0, 0, 490, 'bonus bVit,5; bonus bFlee,10;', '', ''); +(5497, 'King_Tiger_Doll_Hat', 'King Tiger Doll Hat', 5, 20, 10, 400, 0, 0, 3, 0, 1, 4294967294, 7, 2, 256, 0, 0, 0, 1, 495, 'bonus bStr,2;', '', ''); INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_buy`, `price_sell`, `weight`, `atk`, `matk`, `defence`, `range`, `slots`, `equip_jobs`, `equip_upper`, `equip_genders`, `equip_locations`, `weapon_level`, `equip_level_min`, `equip_level_max`, `refineable`, `view`, `script`, `equip_script`, `unequip_script`) VALUES +(5498, 'Wondering_Wolf_Helm', 'Wandering Wolf Helm', 5, 20, 10, 600, 0, 0, 5, 0, 0, 4294967294, 7, 2, 768, 0, 20, 0, 0, 490, 'bonus bVit,5; bonus bFlee,10;', '', ''), (5499, 'Pizza_Hat', 'Pizza Hat', 5, 20, 10, 600, 0, 0, 0, 0, 0, 4294967295, 7, 2, 256, 0, 0, 0, 0, 487, 'skill "SM_PROVOKE",1;', '', ''), (5500, 'Icecream_Hat', 'Icecream Hat', 5, 0, 0, 300, 0, 0, 6, 0, 0, 4294967295, 7, 2, 256, 0, 30, 0, 1, 488, 'bonus bMdef,3; skill "MG_FROSTDIVER",3;', '', ''), (5501, 'Pirate''s_Pride', 'Pirate''s Pride', 5, 0, 0, 100, 0, 0, 6, 0, 0, 4294967295, 7, 2, 256, 0, 10, 0, 0, 496, 'bonus2 bAddRace2,6,5; bonus2 bSubRace2,6,5;', '', ''), @@ -3454,9 +3454,9 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (5841, 'Shaman_Hat_', 'Shaman_Hat', 5, 20, 10, 100, 0, 0, 1, 0, 1, 4294967295, 7, 2, 256, 0, 30, 0, 1, 596, 'bonus bLuk,2; bonus3 bSubEle,Ele_Neutral,3,BF_MAGIC; bonus3 bSubEle,Ele_Water,3,BF_MAGIC; bonus3 bSubEle,Ele_Earth,3,BF_MAGIC; bonus3 bSubEle,Ele_Fire,3,BF_MAGIC; bonus3 bSubEle,Ele_Wind,3,BF_MAGIC; bonus3 bSubEle,Ele_Poison,3,BF_MAGIC; bonus3 bSubEle,Ele_Holy,3,BF_MAGIC; bonus3 bSubEle,Ele_Dark,3,BF_MAGIC; bonus3 bSubEle,Ele_Ghost,3,BF_MAGIC; bonus3 bSubEle,Ele_Undead,3,BF_MAGIC;', '', ''), (5842, 'Loyal_Ring1', 'Loyal Ring1', 5, 0, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 136, 0, 1, 0, 1, 0, '', '', ''), (5843, 'Loyal_Ring2', 'Loyal Ring2', 5, 0, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 136, 0, 1, 0, 1, 0, 'bonus bAllStats,2;', '', ''), -(5844, 'Loyal_Ring3', 'Loyal Ring3', 5, 0, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 136, 0, 1, 0, 1, 0, 'bonus bAllStats,3;', '', ''), -(5845, 'Buzzy_Ball_Board', 'Buzzy Ball Board', 5, 50, 25, 400, 0, 0, 0, 0, 0, 4294967295, 7, 2, 256, 0, 1, 0, 1, 641, '', '', ''); +(5844, 'Loyal_Ring3', 'Loyal Ring3', 5, 0, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 136, 0, 1, 0, 1, 0, 'bonus bAllStats,3;', '', ''); INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_buy`, `price_sell`, `weight`, `atk`, `matk`, `defence`, `range`, `slots`, `equip_jobs`, `equip_upper`, `equip_genders`, `equip_locations`, `weapon_level`, `equip_level_min`, `equip_level_max`, `refineable`, `view`, `script`, `equip_script`, `unequip_script`) VALUES +(5845, 'Buzzy_Ball_Board', 'Buzzy Ball Board', 5, 50, 25, 400, 0, 0, 0, 0, 0, 4294967295, 7, 2, 256, 0, 1, 0, 1, 641, '', '', ''), (5846, 'Buzzy_Ball_Gum', 'Buzzy Ball Gum', 5, 50, 25, 100, 0, 0, 1, 0, 0, 4294967295, 7, 2, 1, 0, 1, 0, 0, 572, 'bonus bMdef,5;', '', ''), (5851, 'Summer_Knight', 'Summer Knight', 5, 20, 10, 0, 0, 0, 1, 0, 0, 4294967295, 7, 2, 768, 0, 60, 0, 0, 138, '', '', ''), (5856, 'Passion_FB_Hat', 'Passion FB Hat', 5, 20, 10, 600, 0, 0, 2, 0, 1, 4294967295, 7, 2, 256, 0, 1, 0, 1, 671, 'bonus bStr,2; bonus bDex,2;', '', ''), @@ -3892,9 +3892,9 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (6434, 'Fix_Kit', 'Fix Kit', 3, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), (6436, 'Sea_God''s_Call', 'Sea God''s Call', 3, 20, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), (6437, 'Scaraba_Perfume', 'Scaraba Perfume', 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), -(6438, 'Unbreakable_Weap', 'Unbreakable Weap', 3, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), -(6440, 'General_Lubrication', 'General Lubrication', 3, 20, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''); +(6438, 'Unbreakable_Weap', 'Unbreakable Weap', 3, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''); INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_buy`, `price_sell`, `weight`, `atk`, `matk`, `defence`, `range`, `slots`, `equip_jobs`, `equip_upper`, `equip_genders`, `equip_locations`, `weapon_level`, `equip_level_min`, `equip_level_max`, `refineable`, `view`, `script`, `equip_script`, `unequip_script`) VALUES +(6440, 'General_Lubrication', 'General Lubrication', 3, 20, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), (6441, 'High_RankLubricant', 'High Ranked Lubricant', 3, 20, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), (6442, 'Octopus_Hunt_Stick', 'Octopus Hunting Stick', 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), (6443, 'Sillit_Pong_Bottle', 'Sillit Pong Bottle', 3, 20, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), @@ -4342,9 +4342,9 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (7302, 'KRATHONG', 'Krathong', 3, 2, 1, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), (7303, 'Bag_Of_Rice', 'Straw Rice Bag', 3, 0, 0, 800, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), (7304, 'Witch''s_Spell_Book', 'Witch''s Spell Scroll', 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), -(7305, 'Authority_Of_Nine_World', 'Symbol of the Nine Realms', 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), -(7306, 'Fragment_Of_Soul', 'Piece of Spirit', 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''); +(7305, 'Authority_Of_Nine_World', 'Symbol of the Nine Realms', 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''); INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_buy`, `price_sell`, `weight`, `atk`, `matk`, `defence`, `range`, `slots`, `equip_jobs`, `equip_upper`, `equip_genders`, `equip_locations`, `weapon_level`, `equip_level_min`, `equip_level_max`, `refineable`, `view`, `script`, `equip_script`, `unequip_script`) VALUES +(7306, 'Fragment_Of_Soul', 'Piece of Spirit', 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), (7307, 'Whisper_Of_Soul', 'Spiritual Whispers', 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), (7308, 'Witch''s_Potion', 'Witch''s Tonic', 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), (7309, 'Wing_Of_Crow', 'Crow Wing', 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), @@ -4798,9 +4798,9 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (7820, 'Morroc_Skin', 'Piece of Morocc Skin', 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), (7821, 'Green_Apple', 'Green Apple', 3, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), (7822, 'Whole_Barbecue', 'Whole Barbecue', 3, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), -(7823, 'Meat_Veg_Skewer', 'Meat Veg Skewer', 3, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), -(7824, 'Spirit_Liquor', 'Spirit Liquor', 3, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''); +(7823, 'Meat_Veg_Skewer', 'Meat Veg Skewer', 3, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''); INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_buy`, `price_sell`, `weight`, `atk`, `matk`, `defence`, `range`, `slots`, `equip_jobs`, `equip_upper`, `equip_genders`, `equip_locations`, `weapon_level`, `equip_level_min`, `equip_level_max`, `refineable`, `view`, `script`, `equip_script`, `unequip_script`) VALUES +(7824, 'Spirit_Liquor', 'Spirit Liquor', 3, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), (7825, 'Heroic_Stone', 'Heroic Stone', 3, 20, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), (7826, 'Continental_Guard_Paper', 'Continental Guard Paper', 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), (7827, 'Mineral_Report', 'Mineral Evals', 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''), @@ -5198,10 +5198,10 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (11711, 'Sakura_Milk_Tea', 'Sakura Milk Tea', 0, 800, 400, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemheal rand(50,70),rand(10,12);', '', ''), (11712, 'First_Leaf_Tea', 'Flower', 0, 800, 400, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemheal rand(50,70),rand(10,12);', '', ''), (11713, 'Julia''s_Candy', 'Julia''s Candy', 0, 0, 0, 30, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemheal rand(40,45),0;', '', ''), -(12000, 'Cold_Scroll_2_5', 'Level 5 Frost Diver', 2, 2000, 1000, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MG_FROSTDIVER",5;', '', ''), -(12001, 'Holy_Scroll_1_3', 'Level 3 Heal', 2, 2000, 1000, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "AL_HEAL",3;', '', ''), -(12002, 'Holy_Scroll_1_5', 'Level 5 Heal', 2, 2000, 1000, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "AL_HEAL",5;', '', ''), -(12003, 'Holy_Scroll_2_1', 'Level 1 Teleport', 2, 1000, 500, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "AL_TELEPORT",1;', '', ''), +(12000, 'Cold_Scroll_2_5', 'Level 5 Frost Diver', 11, 2000, 1000, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MG_FROSTDIVER",5;', '', ''), +(12001, 'Holy_Scroll_1_3', 'Level 3 Heal', 11, 2000, 1000, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "AL_HEAL",3;', '', ''), +(12002, 'Holy_Scroll_1_5', 'Level 5 Heal', 11, 2000, 1000, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "AL_HEAL",5;', '', ''), +(12003, 'Holy_Scroll_2_1', 'Level 1 Teleport', 11, 1000, 500, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "AL_TELEPORT",1;', '', ''), (12004, 'Arrow_Container', 'Quiver', 2, 2, 1, 250, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'getitem 1750,500;', '', ''), (12005, 'Iron_Arrow_Container', 'Iron Arrow Quiver', 2, 2, 1, 250, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'getitem 1770,500;', '', ''), (12006, 'Steel_Arrow_Container', 'Steel Arrow Quiver', 2, 2, 1, 250, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'getitem 1753,500;', '', ''), @@ -5217,8 +5217,8 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (12016, 'Speed_Up_Potion', 'Speed Potion', 2, 2, 1, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start SC_MOVHASTE_INFINITY,5000,0;', '', ''), (12017, 'Slow_Down_Potion', 'Slow Potion', 2, 2, 1, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start SC_SlowDown,5000,0;', '', ''), (12018, 'Fire_Cracker', 'Firecracker', 2, 2, 1, 20, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'end;', '', ''), -(12019, 'Holy_Egg', 'Holy Egg', 2, 2, 1, 150, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "ALL_RESURRECTION",2;', '', ''), -(12020, 'Water_Of_Darkness', 'Cursed Water', 2, 2, 1, 30, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "ITEM_ENCHANTARMS",8;', '', ''), +(12019, 'Holy_Egg', 'Holy Egg', 11, 2, 1, 150, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "ALL_RESURRECTION",2;', '', ''), +(12020, 'Water_Of_Darkness', 'Cursed Water', 11, 2, 1, 30, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "ITEM_ENCHANTARMS",8;', '', ''), (12021, 'Pork_Belly', 'Pork', 0, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemheal rand(70,99),0;', '', ''), (12022, 'Spareribs', 'Galbi', 0, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemheal rand(70,99),0;', '', ''), (12023, 'Giftbox_China', 'Wrapped Box', 2, 1000, 500, 200, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'getrandgroupitem 12023,1;', '', ''); @@ -5228,10 +5228,10 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (12026, 'Egg_Girl', 'Dano Festival Egg', 2, 1000, 500, 200, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'getrandgroupitem 12026,1;', '', ''), (12027, 'Giggling_Box', 'Giggling Box', 2, 1000, 500, 200, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'percentheal 9,0; if(rand(1000)<300) sc_start SC_Curse,30000,0;', '', ''), (12028, 'Box_Of_Thunder', 'Box of Thunder', 2, 1000, 500, 200, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start SC_MOVHASTE_HORSE,20000,0;', '', ''), -(12029, 'Gloomy_Box', 'Box of Gloom', 2, 1000, 500, 200, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "AC_CONCENTRATION",1;', '', ''), +(12029, 'Gloomy_Box', 'Box of Gloom', 11, 1000, 500, 200, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "AC_CONCENTRATION",1;', '', ''), (12030, 'Box_Of_Grudge', 'Box of Resentment', 2, 1000, 500, 200, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start SC_PLUSATTACKPOWER,60000,20;', '', ''), (12031, 'Sleepy_Box', 'Box of Drowsiness', 2, 1000, 500, 200, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start SC_PLUSMAGICPOWER,60000,20;', '', ''), -(12032, 'Box_Of_Storm', 'Box of Storms', 2, 1000, 500, 200, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "ITEM_ENCHANTARMS",2;', '', ''), +(12032, 'Box_Of_Storm', 'Box of Storms', 11, 1000, 500, 200, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "ITEM_ENCHANTARMS",2;', '', ''), (12033, 'Box_Of_Sunlight', 'Box of Sunlight', 2, 1000, 500, 200, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start SC_CLAIRVOYANCE,30000,0;', '', ''), (12034, 'Painting_Box', 'Box of Panting', 2, 1000, 500, 200, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'percentheal 0,9; if(rand(1000)<300) sc_start SC_Silence,30000,0;', '', ''), (12035, 'Lotto_Box01', 'Lotto Box 01', 2, 0, 0, 20, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'getitem rand(7361,7370),1;', '', ''), @@ -5313,10 +5313,10 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (12111, 'Food_Package', 'Bundle of Food', 2, 10000, 5000, 200, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'getrandgroupitem 12111,1; getrandgroupitem 12111,1; getrandgroupitem 12111,1;', '', ''), (12112, 'Tropical_Sograt', 'Tropical Sograt', 2, 1000, 500, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start SC_Curse,10000,1;', '', ''), (12113, 'Vermilion_The_Beach', 'Vermilion on the Beach', 2, 1000, 500, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start SC_Stun,10000,1;', '', ''), -(12114, 'Elemental_Fire', 'Elemental Converter', 2, 2, 1, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "ITEM_ENCHANTARMS",4;', '', ''), -(12115, 'Elemental_Water', 'Elemental Converter', 2, 2, 1, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "ITEM_ENCHANTARMS",2;', '', ''), -(12116, 'Elemental_Earth', 'Elemental Converter', 2, 2, 1, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "ITEM_ENCHANTARMS",3;', '', ''), -(12117, 'Elemental_Wind', 'Elemental Converter', 2, 2, 1, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "ITEM_ENCHANTARMS",5;', '', ''), +(12114, 'Elemental_Fire', 'Elemental Converter', 11, 2, 1, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "ITEM_ENCHANTARMS",4;', '', ''), +(12115, 'Elemental_Water', 'Elemental Converter', 11, 2, 1, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "ITEM_ENCHANTARMS",2;', '', ''), +(12116, 'Elemental_Earth', 'Elemental Converter', 11, 2, 1, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "ITEM_ENCHANTARMS",3;', '', ''), +(12117, 'Elemental_Wind', 'Elemental Converter', 11, 2, 1, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "ITEM_ENCHANTARMS",5;', '', ''), (12118, 'Resist_Fire', 'Fireproof Potion', 2, 2, 1, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start4 SC_ARMOR_ELEMENT,1200000,-15,0,20,0;', '', ''), (12119, 'Resist_Water', 'Coldproof Potion', 2, 2, 1, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start4 SC_ARMOR_ELEMENT,1200000,20,0,0,-15;', '', ''), (12120, 'Resist_Earth', 'Earthproof Potion', 2, 2, 1, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start4 SC_ARMOR_ELEMENT,1200000,0,20,-15,0;', '', ''), @@ -5399,7 +5399,7 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (12197, 'Salty_Rice_Cake', 'Salty Rice Cake', 0, 20, 10, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'percentheal 10,10;', '', ''), (12198, 'Lucky_Rice_Cake', 'Lucky Rice Cake', 2, 20, 10, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start SC_INCLUK,1200000,21;', '', ''), (12199, 'Rice_Scroll', 'Scroll of Magic', 2, 0, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''), -(12200, 'Event_Cake', 'X-mas Cake', 2, 20, 10, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "PR_MAGNIFICAT",3;', '', ''), +(12200, 'Event_Cake', 'X-mas Cake', 11, 20, 10, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "PR_MAGNIFICAT",3;', '', ''), (12201, 'Red_Box_C', 'Commonplace Red Box', 2, 20, 10, 200, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''), (12202, 'Str_Dish10_', 'Steamed Tongue', 0, 2, 1, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start SC_FOOD_STR_CASH,1800000,10; percentheal 15,5;', '', ''), (12203, 'Agi_Dish10_', 'Steamed Scorpion', 0, 2, 1, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start SC_FOOD_AGI_CASH,1800000,10; percentheal 15,5;', '', ''), @@ -5412,7 +5412,7 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (12210, 'Bubble_Gum', 'Bubble Gum', 2, 2, 1, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start SC_CASH_RECEIVEITEM,1800000,200;', '', ''), (12211, 'Kafra_Card', 'Kafra Card', 2, 2, 1, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'callfunc "F_CashStore";', '', ''), (12212, 'Giant_Fly_Wing', 'Giant Fly Wing', 2, 2, 1, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'callfunc "F_CashPartyCall";', '', ''), -(12213, 'Neuralizer', 'Neuralizer', 2, 2, 1, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'callfunc "F_CashReset";', '', ''), +(12213, 'Neuralizer', 'Neuralizer', 11, 2, 1, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'callfunc "F_CashReset";', '', ''), (12214, 'Convex_Mirror', 'Convex Mirror', 2, 2, 1, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start SC_CASH_BOSS_ALARM,600000,0;', '', ''), (12215, 'Blessing_10_Scroll', 'LV10 Blessing Scroll', 2, 2, 1, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'skilleffect "AL_BLESSING",0; sc_start SC_BLESSING,240000,10;', '', ''), (12216, 'Inc_Agi_10_Scroll', 'LV10 Agil Scroll', 2, 2, 1, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'if(Hp>15) { skilleffect "AL_INCAGI",0; sc_start SC_INC_AGI,240000,10; heal -15,0; }', '', ''), @@ -5432,7 +5432,7 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (12233, 'Kvass', 'Kvass', 0, 20, 10, 200, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'percentheal 100,100;', '', ''), (12234, 'Cacao99', 'Fierce Cacao 99%', 0, 20, 10, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'percentheal 25,0;', '', ''), (12235, 'Strawberry_Choco', 'Chocolate Strawberry', 2, 20, 10, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'percentheal 0,5; skilleffect "AL_BLESSING",0; sc_start SC_BLESSING,240000,10;', '', ''), -(12236, 'Choco_Tart', 'Chocolate Tart', 2, 20, 10, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'percentheal 5,0; itemskill "AL_ANGELUS",5;', '', ''), +(12236, 'Choco_Tart', 'Chocolate Tart', 11, 20, 10, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'percentheal 5,0; itemskill "AL_ANGELUS",5;', '', ''), (12237, 'Choco_Lump', 'Junky Chocolate', 2, 0, 0, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'percentheal 0,5; sc_start SC_Poison,18000,0; sc_start SC_BLOODING,18000,0;', '', ''), (12238, 'New_Year_Rice_Cake_1', 'New Year Rice Cake', 2, 20, 10, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'if(rand(1000)<100) sc_start SC_DPoison,10000,0; sc_start SC_Poison,50000,0;', '', ''), (12239, 'New_Year_Rice_Cake_2', 'New Year Rice Cake', 2, 20, 10, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'if(rand(1000)<100) sc_start SC_DPoison,10000,0; sc_start SC_Poison,50000,0;', '', ''), @@ -5507,7 +5507,7 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (12308, 'Magic_Castle', 'Magic Magic Powder', 2, 0, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'setfont 8;', '', ''), (12309, 'Bulging_Head', 'JJangu Magic Powder', 2, 0, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'setfont 9;', '', ''), (12310, 'Spray_Of_Flowers', 'Spray Of Flowers', 2, 0, 0, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start SC_INCFLEE,600000,10;', '', ''), -(12311, 'Large_Spray_Of_Flowers', 'Huge Spray Of Flowers', 2, 0, 0, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "ALL_PARTYFLEE",1;', '', ''), +(12311, 'Large_Spray_Of_Flowers', 'Huge Spray Of Flowers', 11, 0, 0, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "ALL_PARTYFLEE",1;', '', ''), (12312, 'Thick_Manual50', 'Thick Battle Manual', 2, 0, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start SC_CASH_PLUSEXP,3600000,50;', '', ''), (12313, 'Protection_Of_Angel', 'Guardian Angel', 2, 0, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''), (12314, 'Noive_Box', 'Noive Box', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''), @@ -5519,9 +5519,9 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (12320, 'Pineapple_Juice', 'Schwartzwald Pine Jubilee', 2, 0, 0, 300, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start SC_INCHIT,600000,10; sc_start SC_INCFLEE2,600000,20;', '', ''), (12321, 'Spicy_Sandwich', 'Arunafeltz Desert Sandwich', 2, 0, 0, 300, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start SC_CRITICALPERCENT,600000,7;', '', ''), (12322, 'Chocolate_Pie', 'Chocolate Pie', 0, 0, 0, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'percentheal 5,5;', '', ''), -(12323, 'N_Fly_Wing', 'Novice Fly Wing', 2, 0, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "AL_TELEPORT",1;', '', ''), -(12324, 'N_Butterfly_Wing', 'Novice Butterfly Wing', 2, 0, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "AL_TELEPORT",3;', '', ''), -(12325, 'N_Magnifier', 'Novice Magnifier', 2, 0, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MC_IDENTIFY",1;', '', ''), +(12323, 'N_Fly_Wing', 'Novice Fly Wing', 11, 0, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "AL_TELEPORT",1;', '', ''), +(12324, 'N_Butterfly_Wing', 'Novice Butterfly Wing', 11, 0, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "AL_TELEPORT",3;', '', ''), +(12325, 'N_Magnifier', 'Novice Magnifier', 11, 0, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MC_IDENTIFY",1;', '', ''), (12326, 'J_Firecracker', 'Large Firecracker', 2, 2, 1, 20, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''), (12327, 'Charm_Of_Luck', 'Charm Of Luck', 2, 1000, 500, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''); INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_buy`, `price_sell`, `weight`, `atk`, `matk`, `defence`, `range`, `slots`, `equip_jobs`, `equip_upper`, `equip_genders`, `equip_locations`, `weapon_level`, `equip_level_min`, `equip_level_max`, `refineable`, `view`, `script`, `equip_script`, `unequip_script`) VALUES @@ -5547,8 +5547,8 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (12347, 'Acorn_Jelly', 'Acorn Jelly', 2, 11, 5, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "ALL_REVERSEORCISH",1;', '', ''), (12348, 'Manuk''s_Faith', 'Manuk''s Faith', 2, 0, 0, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'specialeffect2 EF_POTION_BERSERK; sc_start SC_MANU_MATK,600000,10;', '', ''), (12349, 'Cornus''_Tears', 'Cornus'' Tears', 2, 0, 0, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'specialeffect2 EF_POTION_BERSERK; sc_start SC_SPL_MATK,600000,10;', '', ''), -(12350, 'Angeling_Potion', 'Angeling Potion', 2, 20, 10, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'skilleffect "AL_BLESSING",0; sc_start SC_BLESSING,120000,5; itemskill "AL_ANGELUS",5;', '', ''), -(12351, 'Shout_Megaphone', 'Scream Megaphone', 2, 20, 10, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MC_LOUD",1;', '', ''), +(12350, 'Angeling_Potion', 'Angeling Potion', 11, 20, 10, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'skilleffect "AL_BLESSING",0; sc_start SC_BLESSING,120000,5; itemskill "AL_ANGELUS",5;', '', ''), +(12351, 'Shout_Megaphone', 'Scream Megaphone', 11, 20, 10, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "MC_LOUD",1;', '', ''), (12352, 'Dun_Tele_Scroll3', 'Dungeon Teleport Scroll 3', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''), (12353, 'Tiny_Waterbottle', 'Small Bottle', 2, 800, 400, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start SC_PROPERTYWATER,90000,1;', '', ''), (12354, 'Buche_De_Noel', 'Buche De Noel', 2, 2, 1, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'specialeffect2 EF_ANGELUS; sc_start SC_INCMHPRATE,600000,3; sc_start SC_INCMSPRATE,600000,3; sc_start SC_INCHITRATE,600000,3; sc_start SC_CRITICALPERCENT,600000,7;', '', ''), @@ -5581,20 +5581,20 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (12381, 'ValkyrieA_Scroll', 'Ancient Languages Scroll', 2, 10, 5, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'if(strcharinfo(3)=="job3_arch02") { mercenary_create 2037,1800000; }', '', ''), (12382, 'ValkyrieB_Scroll', 'Ancient Languages Scroll', 2, 10, 5, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'if(strcharinfo(3)=="job3_arch02") { mercenary_create 2038,1800000; }', '', ''), (12383, 'Vulcan_Bullet_Magazine', 'Vulcan Bullet Magazine', 2, 11000, 5500, 500, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''), -(12384, 'Rainbow_Ruby_Water', 'Rainbow Ruby', 2, 0, 0, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'if(strcharinfo(3)=="job3_war02") { itemskill "WL_FROSTMISTY",5; }', '', ''), -(12385, 'Rainbow_Ruby_Fire', 'Rainbow Ruby', 2, 0, 0, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'if(strcharinfo(3)=="job3_war02") { itemskill "WL_CRIMSONROCK",5; }', '', ''), -(12386, 'Rainbow_Ruby_Wind', 'Rainbow Ruby', 2, 0, 0, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'if(strcharinfo(3)=="job3_war02") { itemskill "WL_CHAINLIGHTNING",5; }', '', ''), -(12387, 'Rainbow_Ruby_Earth', 'Rainbow Ruby', 2, 0, 0, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'if(strcharinfo(3)=="job3_war02") { itemskill "WL_EARTHSTRAIN",5; }', '', ''), -(12388, 'Runstone_Crush', 'Rhydo Runestone For Apprentice', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'if(strcharinfo(3)=="job3_rune02") { itemskill "RK_CRUSHSTRIKE",1; }', '', ''), -(12389, 'Runstone_Storm', 'Pertz Runestone For Apprentice', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'if(strcharinfo(3)=="job3_rune02") { itemskill "RK_STORMBLAST",1; }', '', ''), -(12390, 'Runstone_Millennium', 'Verkana Runestone For Apprentice', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'if(strcharinfo(3)=="job3_rune02") { itemskill "RK_MILLENNIUMSHIELD",1; }', '', ''), +(12384, 'Rainbow_Ruby_Water', 'Rainbow Ruby', 11, 0, 0, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'if(strcharinfo(3)=="job3_war02") { itemskill "WL_FROSTMISTY",5; }', '', ''), +(12385, 'Rainbow_Ruby_Fire', 'Rainbow Ruby', 11, 0, 0, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'if(strcharinfo(3)=="job3_war02") { itemskill "WL_CRIMSONROCK",5; }', '', ''), +(12386, 'Rainbow_Ruby_Wind', 'Rainbow Ruby', 11, 0, 0, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'if(strcharinfo(3)=="job3_war02") { itemskill "WL_CHAINLIGHTNING",5; }', '', ''), +(12387, 'Rainbow_Ruby_Earth', 'Rainbow Ruby', 11, 0, 0, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'if(strcharinfo(3)=="job3_war02") { itemskill "WL_EARTHSTRAIN",5; }', '', ''), +(12388, 'Runstone_Crush', 'Rhydo Runestone For Apprentice', 11, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'if(strcharinfo(3)=="job3_rune02") { itemskill "RK_CRUSHSTRIKE",1; }', '', ''), +(12389, 'Runstone_Storm', 'Pertz Runestone For Apprentice', 11, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'if(strcharinfo(3)=="job3_rune02") { itemskill "RK_STORMBLAST",1; }', '', ''), +(12390, 'Runstone_Millennium', 'Verkana Runestone For Apprentice', 11, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'if(strcharinfo(3)=="job3_rune02") { itemskill "RK_MILLENNIUMSHIELD",1; }', '', ''), (12391, 'Lucky_Egg_C', 'Lucky Egg', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'packageitem();', '', ''), (12392, 'Repair_A', 'Repair A', 0, 220, 110, 70, 0, 0, 0, 0, 0, 1024, 8, 2, 0, 0, 0, 0, 0, 0, '', '', ''), (12393, 'Repair_B', 'Repair B', 0, 500, 250, 70, 0, 0, 0, 0, 0, 1024, 8, 2, 0, 0, 0, 0, 0, 0, '', '', ''), (12394, 'Repair_C', 'Repair C', 0, 1100, 550, 70, 0, 0, 0, 0, 0, 1024, 8, 2, 0, 0, 0, 0, 0, 0, '', '', ''), (12395, 'Tantanmen', 'Tantan Noodle', 2, 20, 10, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'pet 1519;', '', ''), -(12396, 'Fools_Day_Box', 'Gift Box?', 2, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'if(rand(1,10)==1) itemskill "AL_TELEPORT",1; else if(rand(1,10)==2) itemskill "AL_TELEPORT",3; else if(rand(1,10)==3) percentheal 50,0; else if(rand(1,10)==4) percentheal 0,50; else if(rand(1,10)==5) end; else if(rand(1,10)==6) getitem 512,1; else if(rand(1,10)==7) itemskill "ALL_REVERSEORCISH",1; else if(rand(1,10)==8) specialeffect2 247; else if(rand(1,10)==9) specialeffect2 338; else specialeffect2 10;', '', ''), -(12397, 'Fools_Day_Box2', 'Gift Box?', 2, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'if(rand(1,10)==1) itemskill "TF_DETOXIFY",1; else if(rand(1,10)==2) itemskill "TF_PICKSTONE",1; else if(rand(1,10)==3) itemskill "BA_FROSTJOKER",1; else if(rand(1,10)==4) itemskill "DC_SCREAM",1; else if(rand(1,10)==5) end; else if(rand(1,10)==6) getitem 909,1; else if(rand(1,10)==7) itemskill "AL_RUWACH",1; else if(rand(1,10)==8) specialeffect2 328; else if(rand(1,10)==9) specialeffect2 68; else specialeffect2 196;', '', ''), +(12396, 'Fools_Day_Box', 'Gift Box?', 11, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'if(rand(1,10)==1) itemskill "AL_TELEPORT",1; else if(rand(1,10)==2) itemskill "AL_TELEPORT",3; else if(rand(1,10)==3) percentheal 50,0; else if(rand(1,10)==4) percentheal 0,50; else if(rand(1,10)==5) end; else if(rand(1,10)==6) getitem 512,1; else if(rand(1,10)==7) itemskill "ALL_REVERSEORCISH",1; else if(rand(1,10)==8) specialeffect2 247; else if(rand(1,10)==9) specialeffect2 338; else specialeffect2 10;', '', ''), +(12397, 'Fools_Day_Box2', 'Gift Box?', 11, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'if(rand(1,10)==1) itemskill "TF_DETOXIFY",1; else if(rand(1,10)==2) itemskill "TF_PICKSTONE",1; else if(rand(1,10)==3) itemskill "BA_FROSTJOKER",1; else if(rand(1,10)==4) itemskill "DC_SCREAM",1; else if(rand(1,10)==5) end; else if(rand(1,10)==6) getitem 909,1; else if(rand(1,10)==7) itemskill "AL_RUWACH",1; else if(rand(1,10)==8) specialeffect2 328; else if(rand(1,10)==9) specialeffect2 68; else specialeffect2 196;', '', ''), (12398, 'PCBang_Gift_Box', 'PCBang Gift Box', 2, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''), (12399, 'Castle_Treasure_Box', 'Castle Treasure Box', 2, 20, 10, 1000, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''), (12400, 'Water_Of_Blessing_', 'Water Of Blessing ', 2, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''), @@ -5789,7 +5789,7 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (12619, 'C_Grade_Coin_Bag', 'C Grade Coin Bag', 2, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''), (12620, 'D_Grade_Coin_Bag', 'D Grade Coin Bag', 2, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''), (12621, 'E_Grade_Coin_Bag', 'E Grade Coin Bag', 2, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''), -(12622, 'Reins_Of_Mount', 'Reins Of Mount', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'setmounting();', '', ''), +(12622, 'Reins_Of_Mount', 'Reins Of Mount', 11, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'setmounting();', '', ''), (12623, 'Advanced_Weapons_Box', 'Advanced Weapons Box', 2, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'getrandgroupitem 12623,1;', '', ''), (12624, 'Delicious_Jelly', 'Delicious Jelly', 0, 20, 10, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'percentheal 3,3;', '', ''), (12636, 'Malangdo_Canned_Specialties', 'Malangdo Canned Specialties', 2, 20, 10, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'warp "malangdo",140,114;', '', ''), @@ -5815,12 +5815,12 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (12700, 'Upside_Down_Shirt', 'Upside Down Shirt', 2, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'warp "malaya",242,211;', '', ''), (12701, 'Old_Blue_Box_F', 'Old Blue Box', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''), (12702, 'Old_Bleu_Box', 'Old Navy Box', 2, 0, 0, 200, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'getrandgroupitem 12702,1; getrandgroupitem 12702,1;', '', ''), -(12703, 'Holy_Egg_2', 'Holy Egg', 2, 0, 0, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''), +(12703, 'Holy_Egg_2', 'Holy Egg', 11, 0, 0, 50, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''), (12704, 'Elixir_Of_Life', 'Elixir of Life', 0, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 85, 0, 0, 0, 'percentheal 100,0;', '', ''), (12705, 'Noble_Nameplate', 'Noble Nameplate', 2, 0, 0, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 90, 0, 0, 0, 'sc_start SC_CASH_PLUSEXP,1800000,100;', '', ''), -(12706, 'Lucky_Cookie01', 'Lucky Cookie', 2, 0, 0, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "PR_GLORIA",5;', '', ''), -(12707, 'Lucky_Cookie02', 'Lucky Cookie', 2, 0, 0, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "PR_MAGNIFICAT",1;', '', ''), -(12708, 'Lucky_Cookie03', 'Lucky Cookie', 2, 0, 0, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "PR_IMPOSITIO",3;', '', ''), +(12706, 'Lucky_Cookie01', 'Lucky Cookie', 11, 0, 0, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "PR_GLORIA",5;', '', ''), +(12707, 'Lucky_Cookie02', 'Lucky Cookie', 11, 0, 0, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "PR_MAGNIFICAT",1;', '', ''), +(12708, 'Lucky_Cookie03', 'Lucky Cookie', 11, 0, 0, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "PR_IMPOSITIO",3;', '', ''), (12709, 'Guyak_Candy', 'Guyak Candy', 0, 0, 0, 150, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'percentheal 30,30;', '', ''), (12710, 'Guyak_Pudding', 'Guyak Pudding', 2, 0, 0, 200, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''), (12711, 'Pretzel', 'Pretzel', 0, 2, 1, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemheal rand(50,90),0;', '', ''), @@ -5837,15 +5837,15 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (12722, 'Poison_Fever', 'Pyrexia', 0, 2, 1, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'if(rand(10000)<10) sc_start SC_PYREXIA,300000,0;', '', ''), (12723, 'Poison_Laughing', 'Magic Mushroom', 0, 2, 1, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'if(rand(10000)<10) sc_start SC_MAGICMUSHROOM,300000,0;', '', ''), (12724, 'Poison_Fatigue', 'Venom Bleed', 0, 2, 1, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'if(rand(10000)<10) sc_start SC_VENOMBLEED,15000,0;', '', ''), -(12725, 'Runstone_Nosiege', 'Nauthiz Rune', 2, 100, 50, 100, 0, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 0, 'itemskill "RK_REFRESH",1;', '', ''), -(12726, 'Runstone_Rhydo', 'Raido Rune', 2, 100, 50, 100, 0, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 0, 'itemskill "RK_CRUSHSTRIKE",1;', '', ''), -(12727, 'Runstone_Verkana', 'Berkana Rune', 2, 100, 50, 100, 0, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 0, 'itemskill "RK_MILLENNIUMSHIELD",1;', '', ''), -(12728, 'Runstone_Isia', 'Isa Rune', 2, 100, 50, 100, 0, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 0, 'itemskill "RK_VITALITYACTIVATION",1;', '', ''), -(12729, 'Runstone_Asir', 'Othila Rune', 2, 100, 50, 100, 0, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 0, 'itemskill "RK_FIGHTINGSPIRIT",1;', '', ''), -(12730, 'Runstone_Urj', 'Uruz Rune', 2, 100, 50, 100, 0, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 0, 'itemskill "RK_ABUNDANCE",1;', '', ''), -(12731, 'Runstone_Turisus', 'Thurisaz Rune', 2, 100, 50, 100, 0, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 0, 'itemskill "RK_GIANTGROWTH",1;', '', ''), -(12732, 'Runstone_Pertz', 'Wyrd Rune', 2, 100, 50, 100, 0, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 0, 'itemskill "RK_STORMBLAST",1;', '', ''), -(12733, 'Runstone_Hagalas', 'Hagalaz Rune', 2, 100, 50, 100, 0, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 0, 'itemskill "RK_STONEHARDSKIN",1;', '', ''), +(12725, 'Runstone_Nosiege', 'Nauthiz Rune', 11, 100, 50, 100, 0, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 0, 'itemskill "RK_REFRESH",1;', '', ''), +(12726, 'Runstone_Rhydo', 'Raido Rune', 11, 100, 50, 100, 0, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 0, 'itemskill "RK_CRUSHSTRIKE",1;', '', ''), +(12727, 'Runstone_Verkana', 'Berkana Rune', 11, 100, 50, 100, 0, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 0, 'itemskill "RK_MILLENNIUMSHIELD",1;', '', ''), +(12728, 'Runstone_Isia', 'Isa Rune', 11, 100, 50, 100, 0, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 0, 'itemskill "RK_VITALITYACTIVATION",1;', '', ''), +(12729, 'Runstone_Asir', 'Othila Rune', 11, 100, 50, 100, 0, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 0, 'itemskill "RK_FIGHTINGSPIRIT",1;', '', ''), +(12730, 'Runstone_Urj', 'Uruz Rune', 11, 100, 50, 100, 0, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 0, 'itemskill "RK_ABUNDANCE",1;', '', ''), +(12731, 'Runstone_Turisus', 'Thurisaz Rune', 11, 100, 50, 100, 0, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 0, 'itemskill "RK_GIANTGROWTH",1;', '', ''), +(12732, 'Runstone_Pertz', 'Wyrd Rune', 11, 100, 50, 100, 0, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 0, 'itemskill "RK_STORMBLAST",1;', '', ''), +(12733, 'Runstone_Hagalas', 'Hagalaz Rune', 11, 100, 50, 100, 0, 0, 0, 0, 0, 4294967295, 8, 2, 0, 0, 0, 0, 0, 0, 'itemskill "RK_STONEHARDSKIN",1;', '', ''), (12734, 'Runstone_Quality', 'Luxurious Rune', 0, 2, 1, 100, 0, 0, 0, 0, 0, 128, 8, 2, 0, 0, 0, 0, 0, 0, 'makerune 5;', '', ''), (12735, 'Runstone_Ancient', 'Ancient Rune', 0, 2, 1, 100, 0, 0, 0, 0, 0, 128, 8, 2, 0, 0, 0, 0, 0, 0, 'makerune 11;', '', ''), (12736, 'Runstone_Mystic', 'Mystic Rune', 0, 2, 1, 100, 0, 0, 0, 0, 0, 128, 8, 2, 0, 0, 0, 0, 0, 0, 'makerune 14;', '', ''), @@ -5874,9 +5874,9 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (12759, 'Loyal_Ring3_Box', 'Loyal Ring3 Box', 2, 10, 5, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''), (12760, 'Bubble_Gum_Green', 'Bubble Gum Green', 2, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''), (12761, 'Bubble_Gum_Yellow', 'Bubble Gum Yellow', 2, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''), -(12762, 'Bubble_Gum_Orange', 'Bubble Gum Orange', 2, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''), -(12763, 'Bubble_Gum_Red', 'Bubble Gum Red', 2, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''); +(12762, 'Bubble_Gum_Orange', 'Bubble Gum Orange', 2, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''); INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_buy`, `price_sell`, `weight`, `atk`, `matk`, `defence`, `range`, `slots`, `equip_jobs`, `equip_upper`, `equip_genders`, `equip_locations`, `weapon_level`, `equip_level_min`, `equip_level_max`, `refineable`, `view`, `script`, `equip_script`, `unequip_script`) VALUES +(12763, 'Bubble_Gum_Red', 'Bubble Gum Red', 2, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''), (12764, 'Fools_Day_Box_Tw', 'Fools Day Box Tw', 2, 0, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''), (12765, 'Summer_Knight_Box', 'Summer Knight Box', 2, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''), (12766, 'Reward_Job_BM25', 'Reward Job BM25', 2, 0, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''), @@ -5890,7 +5890,7 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (12775, 'Ancient_Spirit_Amulet', 'Ancient Spirit Amulet', 2, 20, 10, 600, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''), (12786, 'Change_Slot_Card', 'Character Position Change Coupon', 2, 0, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'set SlotChange, SlotChange + 1;', '', ''), (12790, 'Char_Rename_Card', 'Character Name Change Coupon', 2, 0, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'set CharRename, CharRename + 1;', '', ''), -(12848, 'Falcon_Flute', 'Falcon Flute', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'if(getskilllv("HT_FALCON")) { if(checkoption(Option_Wug)||checkoption(Option_Wugrider)) end; if(checkfalcon()==1) { setfalcon 0; } else { setfalcon 1; } }', '', ''), +(12848, 'Falcon_Flute', 'Falcon Flute', 11, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'if(getskilllv("HT_FALCON")) { if(checkoption(Option_Wug)||checkoption(Option_Wugrider)) end; if(checkfalcon()==1) { setfalcon 0; } else { setfalcon 1; } }', '', ''), (12900, 'Battle_Manual_Box', 'Battle Manual Box', 18, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'getitem 12208,10;', '', ''), (12901, 'Insurance_Package', 'Insurance Package', 18, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'getitem 12209,10;', '', ''), (12902, 'Bubble_Gum_Box', 'Bubble Gum Box', 18, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'getitem 12210,10;', '', ''), @@ -5919,7 +5919,7 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (12925, 'Pet_Egg_Scroll1', 'Kafra Item Mall Prize Package', 18, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'packageitem();', '', ''), (12926, 'Pet_Egg_Scroll2', 'December Lucky Box', 18, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'packageitem();', '', ''), (12927, 'J_Aspersio_5_Scroll_Box', 'Aspersio Scroll Box', 18, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'getitem 12928,10;', '', ''), -(12928, 'J_Aspersio_5_Scroll', 'Sacred Scroll', 2, 2, 1, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "PR_ASPERSIO",5;', '', ''), +(12928, 'J_Aspersio_5_Scroll', 'Sacred Scroll', 11, 2, 1, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "PR_ASPERSIO",5;', '', ''), (12929, 'Pet_Egg_Scroll_Box3', 'Pet Egg Box 3', 18, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'getitem 12932,1;', '', ''), (12930, 'Pet_Egg_Scroll_Box4', 'Pet Egg Box 4', 18, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'getitem 12933,1;', '', ''), (12931, 'Pet_Egg_Scroll_Box5', 'Pet Egg Box 5', 18, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'getitem 12934,1;', '', ''), @@ -5959,9 +5959,9 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (12965, 'Emergency_Box1', 'Emergency Level 1 Scroll Box', 18, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'getitem 12968,1;', '', ''), (12966, 'Emergency_Box2', 'Emergency Level 2 Scroll Box', 18, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'getitem 12969,1;', '', ''), (12967, 'Emergency_Box3', 'Emergency Level 3 Scroll Box', 18, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'getitem 12970,1;', '', ''), -(12968, 'Emergency_Scroll1', 'Emergency Level 1 Scroll', 2, 2, 1, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "GD_EMERGENCYCALL",1;', '', ''), -(12969, 'Emergency_Scroll2', 'Emergency Level 2 Scroll', 2, 2, 1, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "GD_EMERGENCYCALL",1;', '', ''), -(12970, 'Emergency_Scroll3', 'Emergency Level 3 Scroll', 2, 2, 1, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "GD_EMERGENCYCALL",1;', '', ''), +(12968, 'Emergency_Scroll1', 'Emergency Level 1 Scroll', 11, 2, 1, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "GD_EMERGENCYCALL",1;', '', ''), +(12969, 'Emergency_Scroll2', 'Emergency Level 2 Scroll', 11, 2, 1, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "GD_EMERGENCYCALL",1;', '', ''), +(12970, 'Emergency_Scroll3', 'Emergency Level 3 Scroll', 11, 2, 1, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "GD_EMERGENCYCALL",1;', '', ''), (12971, 'Teleport_Box1', 'Teleport Scroll Box 1', 18, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'getitem 12977,10;', '', ''), (12972, 'Teleport_Box2', 'Teleport Scroll Box 2', 18, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'getitem 12978,10;', '', ''), (12973, 'Teleport_Box3', 'Teleport Scroll Box 3', 18, 20, 10, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'getitem 12979,10;', '', ''), @@ -7054,11 +7054,11 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (14509, 'Light_Center_Pot', 'Light Concentration Potion', 2, 800, 400, 20, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start SC_ATTHASTE_POTION1,1800000,0;', '', ''), (14510, 'Light_Awakening_Pot', 'Light Awakening Potion', 2, 1500, 750, 20, 0, 0, 0, 0, 0, 4294442735, 7, 2, 0, 0, 40, 0, 0, 0, 'sc_start SC_ATTHASTE_POTION2,1800000,0;', '', ''), (14511, 'Light_Berserk_Pot', 'Light Berserk Potion', 2, 3000, 1500, 20, 0, 0, 0, 0, 0, 31868582, 7, 2, 0, 0, 85, 0, 0, 0, 'sc_start SC_ATTHASTE_POTION3,1800000,0;', '', ''), -(14512, 'Meteor_10_Scroll', 'Meteor Storm Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "WZ_METEOR",10;', '', ''), -(14513, 'Storm_10_Scroll', 'Storm Gust Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "WZ_STORMGUST",10;', '', ''), -(14514, 'Vermilion_10_Scroll', 'Lord of Vermilion Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "WZ_VERMILION",10;', '', ''), -(14515, 'Lex_Aeterna_Scroll', 'Lex Aeterna Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "PR_LEXAETERNA",1;', '', ''), -(14516, 'Magnificat_5_Scroll', 'Magnificat Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "PR_MAGNIFICAT",5;', '', ''), +(14512, 'Meteor_10_Scroll', 'Meteor Storm Scroll', 11, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "WZ_METEOR",10;', '', ''), +(14513, 'Storm_10_Scroll', 'Storm Gust Scroll', 11, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "WZ_STORMGUST",10;', '', ''), +(14514, 'Vermilion_10_Scroll', 'Lord of Vermilion Scroll', 11, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "WZ_VERMILION",10;', '', ''), +(14515, 'Lex_Aeterna_Scroll', 'Lex Aeterna Scroll', 11, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "PR_LEXAETERNA",1;', '', ''), +(14516, 'Magnificat_5_Scroll', 'Magnificat Scroll', 11, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "PR_MAGNIFICAT",5;', '', ''), (14517, 'CP_Helm_Scroll', 'Chemical Protection Helm Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'unitskilluseid getcharid(3),237,5;', '', ''), (14518, 'CP_Shield_Scroll', 'Chemical Protection Shield Scrol', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'unitskilluseid getcharid(3),235,5;', '', ''), (14519, 'CP_Armor_Scroll', 'Chemical Protection Armor Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'unitskilluseid getcharid(3),236,5;', '', ''), @@ -7071,7 +7071,7 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (14526, 'Oriental_Pastry', 'Oriental Pastry', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start SC_PLUSMAGICPOWER,180000,10;', '', ''), (14527, 'Dun_Tele_Scroll1', 'Dungeon Teleport Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'callfunc "F_CashDungeon";', '', ''), (14528, 'PVP_Tele_Scroll', 'PVP Teleport Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, '', '', ''), -(14529, 'Greed_Scroll', 'Greed Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "BS_GREED",1;', '', ''), +(14529, 'Greed_Scroll', 'Greed Scroll', 11, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "BS_GREED",1;', '', ''), (14530, 'Flee_30_Scroll', 'Evasion Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start SC_INCFLEE,1800000,30;', '', ''), (14531, 'Accuracy_30_Scroll', 'Concentration Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start SC_INCHIT,1800000,30;', '', ''), (14532, 'Battle_Manual25', 'Field Manual 25%', 2, 2, 1, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start SC_CASH_PLUSEXP,1800000,25;', '', ''), @@ -7130,14 +7130,14 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (14584, 'WOB_Rachel', 'Red Butterfly Wing', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'callfunc "F_CashCity",3;', '', ''), (14585, 'WOB_Local', 'Blue Butterfly Wing', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'callfunc "F_CashCity",4;', '', ''), (14586, 'Spark_Candy', 'Jumping Candy', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'bonus2 bHPLossRate,100,10000;', '', ''), -(14587, 'Repair_Scroll_', 'Equipment Repair Spell Book', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "BS_REPAIRWEAPON",1;', '', ''), -(14588, 'Pty_Blessing_Scroll', 'Party Blessing 10 Scroll', 2, 10, 5, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "CASH_BLESSING",10;', '', ''), -(14589, 'Pty_Inc_Agi_Scroll', 'Party Increase Agi 10 Scroll', 2, 10, 5, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "CASH_INCAGI",10;', '', ''), -(14590, 'Pty_Assumptio_Scroll', 'Party Assumptio 5 Scroll', 2, 10, 5, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "CASH_ASSUMPTIO",5;', '', ''), +(14587, 'Repair_Scroll_', 'Equipment Repair Spell Book', 11, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "BS_REPAIRWEAPON",1;', '', ''), +(14588, 'Pty_Blessing_Scroll', 'Party Blessing 10 Scroll', 11, 10, 5, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "CASH_BLESSING",10;', '', ''), +(14589, 'Pty_Inc_Agi_Scroll', 'Party Increase Agi 10 Scroll', 11, 10, 5, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "CASH_INCAGI",10;', '', ''), +(14590, 'Pty_Assumptio_Scroll', 'Party Assumptio 5 Scroll', 11, 10, 5, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "CASH_ASSUMPTIO",5;', '', ''), (14591, 'Siege_Teleport_Scroll', 'WoE Teleport Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'callfunc "F_CashSeigeTele";', '', ''), (14592, 'Job_Manual50', 'JOB Battle Manual', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start SC_CASH_PLUSONLYJOBEXP,1800000,50;', '', ''), -(14593, 'Magic_Power_Scroll', 'Mystical Amplification Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "HW_MAGICPOWER",10;', '', ''), -(14594, 'Quagmire_Scroll', 'Quagmire Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "WZ_QUAGMIRE",5;', '', ''), +(14593, 'Magic_Power_Scroll', 'Mystical Amplification Scroll', 11, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "HW_MAGICPOWER",10;', '', ''), +(14594, 'Quagmire_Scroll', 'Quagmire Scroll', 11, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'itemskill "WZ_QUAGMIRE",5;', '', ''), (14595, 'Unsealed_Magic_Spell', 'Unsealed Magic Spell', 2, 0, 0, 0, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'warp "yuno_fild09",255,127;', '', ''), (14596, 'Pierre_Treasurebox', 'Pierre''s Treasure Box', 2, 0, 0, 100, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'getrandgroupitem 14596,1; getrandgroupitem 14596,1; getrandgroupitem 14596,1; getrandgroupitem 14596,1; getrandgroupitem 14596,1; getrandgroupitem 14596,1;', '', ''), (14597, 'PhreeoniS', 'Phreeoni Scroll', 2, 0, 0, 10, 0, 0, 0, 0, 0, 4294967295, 7, 2, 0, 0, 0, 0, 0, 0, 'sc_start SC_ITEMSCRIPT,180000,4121;', '', ''), @@ -7817,4 +7817,4 @@ INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_ (21002, 'Velum_Katzbalger', 'Vellum Katzbalger', 4, 20, 10, 2500, 100, 0, 0, 1, 0, 16514, 7, 2, 34, 4, 95, 0, 1, 3, 'bonus2 bSPVanishRate,10000,8;', '', ''), (21003, 'Muramasa_', 'Muramasa ', 4, 20, 10, 1000, 155, 0, 0, 1, 2, 16514, 7, 2, 34, 4, 48, 0, 1, 3, '', '', ''), (21004, 'Alca_Bringer_', 'Alca Bringer ', 4, 20, 10, 3400, 280, 0, 0, 2, 2, 125, 7, 2, 34, 3, 100, 0, 1, 3, '', '', ''), -(21005, 'Metal_Two_Hand_Sword', 'Metal Two Hand Sword', 4, 20, 10, 0, 95, 0, 0, 1, 1, 16514, 7, 2, 34, 3, 1, 0, 1, 3, '', '', '');
\ No newline at end of file +(21005, 'Metal_Two_Hand_Sword', 'Metal Two Hand Sword', 4, 20, 10, 0, 95, 0, 0, 1, 1, 16514, 7, 2, 34, 3, 1, 0, 1, 3, '', '', ''); diff --git a/src/map/itemdb.c b/src/map/itemdb.c index 6fd8b166c..5fae29500 100644 --- a/src/map/itemdb.c +++ b/src/map/itemdb.c @@ -760,7 +760,7 @@ void itemdb_read_packages(void) { int r = 0, m = 0; data->package = &itemdb->packages[count]; - + itemdb->packages[count].id = data->nameid; itemdb->packages[count].random_list = NULL; itemdb->packages[count].must_items = NULL; @@ -814,7 +814,9 @@ void itemdb_read_packages(void) { itemdb->packages[count].random_list[r].id = data ? data->nameid : 0; itemdb->packages[count].random_list[r].qty = icount; - itemdb->packages[count].random_list[r].rate = rate; + if( (itemdb->packages[count].random_list[r].rate = rate) == 10000 ) { + ShowWarning("itemdb_read_packages: item '%s' in '%s' has 100% drop rate!! set this item as 'Random: false' or other items won't drop!!!\n",itname,config_setting_name(itg)); + } itemdb->packages[count].random_list[r].hours = expire; itemdb->packages[count].random_list[r].announce = announce == true ? 1 : 0; itemdb->packages[count].random_list[r].named = named == true ? 1 : 0; diff --git a/src/plugins/db2sql.c b/src/plugins/db2sql.c index c4d4adff1..8db4a006f 100644 --- a/src/plugins/db2sql.c +++ b/src/plugins/db2sql.c @@ -17,7 +17,7 @@ HPExport struct hplugin_info pinfo = { "DB2SQL", // Plugin name SERVER_TYPE_MAP,// Which server types this plugin works with? - "0.3", // Plugin version + "0.4", // Plugin version HPM_VERSION, // HPM Version (don't change, macro is automatically updated) }; @@ -55,10 +55,10 @@ int db2sql(char** str, const char* source, int line, int scriptopt) { /* renewal has the 'matk' and 'equip_level' is now 'equip_level_min', and there is a new 'equip_level_max' field */ #ifdef RENEWAL if( SQL_SUCCESS != SQL->StmtPrepare(stmt, "REPLACE INTO `%s` (`id`,`name_english`,`name_japanese`,`type`,`price_buy`,`price_sell`,`weight`,`atk`,`matk`,`defence`,`range`,`slots`,`equip_jobs`,`equip_upper`,`equip_genders`,`equip_locations`,`weapon_level`,`equip_level_min`,`equip_level_max`,`refineable`,`view`,`script`,`equip_script`,`unequip_script`) VALUES ('%u',?,?,'%u','%u','%u','%u','%u','%u','%u','%u','%u','%u','%u','%u','%u','%u','%u','%u','%u','%u',?,?,?)",iMap->item_db_re_db, - it->nameid,it->type,it->value_buy,it->value_sell,it->weight,it->atk,it->matk,it->def,it->range,it->slot,(unsigned int)strtoul(str[11+offset],NULL,0),atoi(str[12+offset]),atoi(str[13+offset]),atoi(str[14+offset]),it->wlv,it->elv,it->elvmax,atoi(str[17+offset]),it->look) ) + it->nameid,it->flag.delay_consume?IT_DELAYCONSUME:it->type,it->value_buy,it->value_sell,it->weight,it->atk,it->matk,it->def,it->range,it->slot,(unsigned int)strtoul(str[11+offset],NULL,0),atoi(str[12+offset]),atoi(str[13+offset]),atoi(str[14+offset]),it->wlv,it->elv,it->elvmax,atoi(str[17+offset]),it->look) ) #else if( SQL_SUCCESS != SQL->StmtPrepare(stmt, "REPLACE INTO `%s` (`id`,`name_english`,`name_japanese`,`type`,`price_buy`,`price_sell`,`weight`,`atk`,`defence`,`range`,`slots`,`equip_jobs`,`equip_upper`,`equip_genders`,`equip_locations`,`weapon_level`,`equip_level`,`refineable`,`view`,`script`,`equip_script`,`unequip_script`) VALUES ('%u',?,?,'%u','%u','%u','%u','%u','%u','%u','%u','%u','%u','%u','%u','%u','%u','%u','%u',?,?,?)",iMap->item_db_db, - it->nameid,it->type,it->value_buy,it->value_sell,it->weight,it->atk,it->def,it->range,it->slot,(unsigned int)strtoul(str[11],NULL,0),atoi(str[12]),atoi(str[13]),atoi(str[14]),it->wlv,it->elv,atoi(str[17]),it->look) ) + it->nameid,it->flag.delay_consume?IT_DELAYCONSUME:it->type,it->value_buy,it->value_sell,it->weight,it->atk,it->def,it->range,it->slot,(unsigned int)strtoul(str[11],NULL,0),atoi(str[12]),atoi(str[13]),atoi(str[14]),it->wlv,it->elv,atoi(str[17]),it->look) ) #endif SqlStmt_ShowDebug(stmt); else { |