summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
authorspre123 <spre123@54d463be-8e91-2dee-dedb-b68131a5f0ec>2012-10-25 07:27:43 +0000
committerspre123 <spre123@54d463be-8e91-2dee-dedb-b68131a5f0ec>2012-10-25 07:27:43 +0000
commitd0857bd997934c8e1522764ff56fb340be0153dc (patch)
treecaab52aa249014f847e1cebe4eeb36f04369f91b /sql-files
parent2bc5a3ccaee0c675d283386940a977a0e4225901 (diff)
downloadhercules-d0857bd997934c8e1522764ff56fb340be0153dc.tar.gz
hercules-d0857bd997934c8e1522764ff56fb340be0153dc.tar.bz2
hercules-d0857bd997934c8e1522764ff56fb340be0153dc.tar.xz
hercules-d0857bd997934c8e1522764ff56fb340be0153dc.zip
Fixed bCastrate function in item_combo_db. bugreport:6815
Fixed Item 13694, Freyas Crown Box Changed getitem to the official rentitem Item Script(verified By Joseph and muad). Continuation of bugreport:6714 git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16828 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/item_db.sql8
-rw-r--r--sql-files/item_db_re.sql2
2 files changed, 5 insertions, 5 deletions
diff --git a/sql-files/item_db.sql b/sql-files/item_db.sql
index d1a9601f8..f98ea95f2 100644
--- a/sql-files/item_db.sql
+++ b/sql-files/item_db.sql
@@ -4965,9 +4965,9 @@ REPLACE INTO `item_db` VALUES (12388,'Runstone_Crush','Rhydo Runestone For Appre
REPLACE INTO `item_db` VALUES (12389,'Runstone_Storm','Pertz Runestone For Apprentice',11,NULL,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'getmapxy .@map$,.@x,.@y,0; if(.@map$=="job3_rune02") { itemskill "RK_STORMBLAST",1; },NULL,NULL);
REPLACE INTO `item_db` VALUES (12390,'Runstone_Millennium','Verkana Runestone For Apprentice',11,NULL,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'getmapxy .@map$,.@x,.@y,0; if(.@map$=="job3_rune02") { itemskill "RK_MILLENNIUMSHIELD",1; },NULL,NULL);
REPLACE INTO `item_db` VALUES (12391,'Lucky_Egg_C','Lucky Egg',2,NULL,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
-REPLACE INTO `item_db` VALUES (12392,'Repair_A','Repair A',0,220,NULL,70,NULL,NULL,NULL,NULL,0x00000400,8,2,NULL,NULL,NULL,NULL,NULL,/*madoheal rand(200,300),0;*/,NULL,NULL);
-REPLACE INTO `item_db` VALUES (12393,'Repair_B','Repair B',0,500,NULL,70,NULL,NULL,NULL,NULL,0x00000400,8,2,NULL,NULL,NULL,NULL,NULL,/*'madoheal rand(300,400),0;*/,NULL,NULL);
-REPLACE INTO `item_db` VALUES (12394,'Repair_C','Repair C',0,1100,NULL,70,NULL,NULL,NULL,NULL,0x00000400,8,2,NULL,NULL,NULL,NULL,NULL,/*'madoheal rand(400,500),0;*/,NULL,NULL);
+REPLACE INTO `item_db` VALUES (12392,'Repair_A','Repair A',0,220,NULL,70,NULL,NULL,NULL,NULL,0x00000400,8,2,NULL,NULL,NULL,NULL,NULL,'/*madoheal rand(200,300),0;*/',NULL,NULL);
+REPLACE INTO `item_db` VALUES (12393,'Repair_B','Repair B',0,500,NULL,70,NULL,NULL,NULL,NULL,0x00000400,8,2,NULL,NULL,NULL,NULL,NULL,'/*madoheal rand(300,400),0;*/',NULL,NULL);
+REPLACE INTO `item_db` VALUES (12394,'Repair_C','Repair C',0,1100,NULL,70,NULL,NULL,NULL,NULL,0x00000400,8,2,NULL,NULL,NULL,NULL,NULL,'/*madoheal rand(400,500),0;*/',NULL,NULL);
REPLACE INTO `item_db` VALUES (12395,'Tantanmen','Tantan Noodle',2,20,NULL,50,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'pet 1519;',NULL,NULL);
REPLACE INTO `item_db` VALUES (12396,'Fools_Day_Box','Gift Box?',11,20,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'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;',NULL,NULL);
REPLACE INTO `item_db` VALUES (12397,'Fools_Day_Box2','Gift Box?',11,20,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'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;',NULL,NULL);
@@ -5714,7 +5714,7 @@ REPLACE INTO `item_db` VALUES (13690,'Chung_E_Cake_Box','Green Maiden Cake Box',
REPLACE INTO `item_db` VALUES (13691,'Freyja_Overcoat_Box','Freya\'s Clothes Box',18,NULL,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'rentitem 2369,604800;',NULL,NULL);
REPLACE INTO `item_db` VALUES (13692,'Freyja_Boots_Box','Freya\'s Boots Box',18,NULL,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'rentitem 2428,604800;',NULL,NULL);
REPLACE INTO `item_db` VALUES (13693,'Freyja_Cape_Box','Freya\'s Manteau Box',18,NULL,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'rentitem 2533,604800;',NULL,NULL);
-REPLACE INTO `item_db` VALUES (13694,'Freyja_Crown_Box','Freya\'s Crown Box',18,NULL,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'getitem 5306,1,604800;',NULL,NULL);
+REPLACE INTO `item_db` VALUES (13694,'Freyja_Crown_Box','Freya\'s Crown Box',18,NULL,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'rentitem 5306,604800;',NULL,NULL);
REPLACE INTO `item_db` VALUES (13695,'Battle_Manual25_Box','Field Manual 25% Box',18,NULL,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'getitem 14532,10;',NULL,NULL);
REPLACE INTO `item_db` VALUES (13696,'Battle_Manual100_Box','Field Manual 100% Box',18,NULL,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'getitem 14533,10;',NULL,NULL);
REPLACE INTO `item_db` VALUES (13697,'J_Blessing10_Box','Blessing Scroll 10 Box',18,NULL,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'getitem 12215,10;',NULL,NULL);
diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql
index 460362569..176812c1c 100644
--- a/sql-files/item_db_re.sql
+++ b/sql-files/item_db_re.sql
@@ -6296,7 +6296,7 @@ REPLACE INTO `item_db_re` VALUES (13690,'Chung_E_Cake_Box','Green Maiden Cake Bo
REPLACE INTO `item_db_re` VALUES (13691,'Freyja_Overcoat_Box','Freya\'s Clothes Box',18,NULL,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'rentitem 2369,604800;',NULL,NULL);
REPLACE INTO `item_db_re` VALUES (13692,'Freyja_Boots_Box','Freya\'s Boots Box',18,NULL,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'rentitem 2428,604800;',NULL,NULL);
REPLACE INTO `item_db_re` VALUES (13693,'Freyja_Cape_Box','Freya\'s Manteau Box',18,NULL,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'rentitem 2533,604800;',NULL,NULL);
-REPLACE INTO `item_db_re` VALUES (13694,'Freyja_Crown_Box','Freya\'s Crown Box',18,NULL,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'getitem 5306,1,604800;',NULL,NULL);
+REPLACE INTO `item_db_re` VALUES (13694,'Freyja_Crown_Box','Freya\'s Crown Box',18,NULL,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'rentitem 5306,604800;',NULL,NULL);
REPLACE INTO `item_db_re` VALUES (13695,'Battle_Manual25_Box','Field Manual 25% Box',18,NULL,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'getitem 14532,10;',NULL,NULL);
REPLACE INTO `item_db_re` VALUES (13696,'Battle_Manual100_Box','Field Manual 100% Box',18,NULL,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'getitem 14533,10;',NULL,NULL);
REPLACE INTO `item_db_re` VALUES (13697,'J_Blessing10_Box','Blessing Scroll 10 Box',18,NULL,NULL,10,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,NULL,NULL,NULL,NULL,NULL,'getitem 12215,10;',NULL,NULL);
generated by cgit v1.2.3-60-g2f50 (git 2.42.0) at 2024-06-28 23:39:24 +0000