From 26629f49bb2ecefcd94326346cbb7967015525d2 Mon Sep 17 00:00:00 2001 From: Paradox924X Date: Sat, 15 Mar 2008 18:51:07 +0000 Subject: Updated Poring Tower to not refinable. (bugreport: 1050) Renamed custom Stylist to Stylist#customstylist to avoid conflicts with official one. (bugreport: 1042 Updated Airship Typing Challenge to not fail you when you get both strings correct. (bugreport: 1008) Fixed Job_Change Function to properly jobchange babies. (bugreport: 943) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12368 54d463be-8e91-2dee-dedb-b68131a5f0ec --- sql-files/item_db.sql | 2 +- sql-files/upgrade_svn12368.sql | 1 + 2 files changed, 2 insertions(+), 1 deletion(-) create mode 100644 sql-files/upgrade_svn12368.sql (limited to 'sql-files') diff --git a/sql-files/item_db.sql b/sql-files/item_db.sql index 7791230e8..58b894423 100644 --- a/sql-files/item_db.sql +++ b/sql-files/item_db.sql @@ -2151,7 +2151,7 @@ REPLACE INTO `item_db` VALUES (5251,'Blank_Ear','Blank Ear',5,NULL,10,10,NULL,0, REPLACE INTO `item_db` VALUES (5252,'Drooping_Ninetails','Drooping Ninetails',5,NULL,10,300,NULL,1,NULL,0,0xFFFFFFFF,7,2,256,NULL,20,1,296,' bonus bAgi,1; bonus bDex,1; bonus3 bAutoSpellWhenHit,75,1,30; ',NULL,NULL); REPLACE INTO `item_db` VALUES (5253,'Lif_Doll_Hat','Drooping Lif',5,NULL,10,200,NULL,1,NULL,1,0xFFFFFFFF,7,2,256,NULL,20,1,297,' bonus bInt,1; bonus bMdef,getrefine(); bonus bDef,getrefine()*-1; ',NULL,NULL); REPLACE INTO `item_db` VALUES (5254,'Deviling_Hat','Deviling Hat',5,NULL,10,350,NULL,1,NULL,0,0xFFFFFFFF,7,2,256,NULL,20,1,298,' bonus bStr,1; bonus bCritical,3; bonus2 bSubRace,RC_Angel,-20; if(getrefine()>=6){ bonus bCritical,getrefine()-5; } ',NULL,NULL); -REPLACE INTO `item_db` VALUES (5255,'Triple_Poring_Hat','Poring Tower',5,NULL,10,600,NULL,3,NULL,0,0xFFFFFFFF,7,2,256,NULL,20,1,299,' bonus bLuk,3; bonus3 bAutoSpell,1013,1,20; ',NULL,NULL); +REPLACE INTO `item_db` VALUES (5255,'Triple_Poring_Hat','Poring Tower',5,NULL,10,600,NULL,3,NULL,0,0xFFFFFFFF,7,2,256,NULL,20,0,299,' bonus bLuk,3; bonus3 bAutoSpell,1013,1,20; ',NULL,NULL); REPLACE INTO `item_db` VALUES (5256,'Valkyrie_Feather_Band','Valkyrie Feather Band',5,NULL,10,100,NULL,1,NULL,1,0xFFFFFFFF,7,2,256,NULL,20,1,300,' bonus bInt,1; bonus3 bAutoSpellWhenHit,28,1,10; ',NULL,NULL); REPLACE INTO `item_db` VALUES (5257,'Soulless_Ring','Soul Ring',5,NULL,10,300,NULL,2,NULL,0,0xFFFFFFFE,7,2,256,NULL,20,1,301,' bonus bMdef,2; bonus3 bAutoSpellWhenHit,361,1,10; ',NULL,NULL); REPLACE INTO `item_db` VALUES (5258,'Dokebi\'s_Wig','Dokebi\'s Wig',5,NULL,10,100,NULL,0,NULL,0,0xFFFFFFFF,7,2,768,NULL,10,1,302,' bonus3 bAutoSpellWhenHit,142,1,300; bonus2 bSubEle,Ele_Neutral,1; ',NULL,NULL); diff --git a/sql-files/upgrade_svn12368.sql b/sql-files/upgrade_svn12368.sql new file mode 100644 index 000000000..62429a19b --- /dev/null +++ b/sql-files/upgrade_svn12368.sql @@ -0,0 +1 @@ +UPDATE `item_db` SET `refineable` = '0' WHERE `item_db`.`id` = '5255'; \ No newline at end of file -- cgit v1.2.3-60-g2f50