From b4394a18cec9b82862f0fb8823c6b141e006851f Mon Sep 17 00:00:00 2001 From: Paradox924X Date: Mon, 1 Oct 2007 01:34:55 +0000 Subject: Fixed Gemini-S58 Card. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11335 54d463be-8e91-2dee-dedb-b68131a5f0ec --- sql-files/item_db.sql | 2 +- sql-files/upgrade_svn11335.sql | 1 + 2 files changed, 2 insertions(+), 1 deletion(-) create mode 100644 sql-files/upgrade_svn11335.sql (limited to 'sql-files') diff --git a/sql-files/item_db.sql b/sql-files/item_db.sql index fc914bb79..ad29dd8af 100644 --- a/sql-files/item_db.sql +++ b/sql-files/item_db.sql @@ -1763,7 +1763,7 @@ REPLACE INTO `item_db` VALUES (4350,'Rawrel_Card','Laurell Weinder Card',6,NULL, REPLACE INTO `item_db` VALUES (4351,'Kavac_Card','Kavach Icarus Card',6,NULL,10,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,NULL,NULL,NULL,NULL,' if(getrefine()<=4) { bonus bFlee,20; bonus bFlee2,1; } else { bonus bFlee,10; } ',NULL,NULL); REPLACE INTO `item_db` VALUES (4352,'B_Ygnizem_Card','General Egnigem Cenia Card',6,NULL,10,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,64,NULL,NULL,NULL,NULL,' bonus bMaxHPrate,10; bonus bMaxSPrate,10; bonus2 bHPRegenRate,50,10000; bonus2 bSPRegenRate,10,10000; ',NULL,NULL); REPLACE INTO `item_db` VALUES (4353,'Removal_Card','Remover Card',6,NULL,10,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,' bonus bMaxHP,800-40*getrefine(); bonus bHPrecovRate,10; ',NULL,NULL); -REPLACE INTO `item_db` VALUES (4354,'Gemini_Card','Gemini-S58 Card',6,NULL,10,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,769,NULL,NULL,NULL,NULL,' if(readparam(bAgi)>=90) { bonus2 bResEff,Eff_Silence,3000; bonus2 bResEff,Eff_Stun,3000; } if(readparam(bVit)>=80) { bonus2 bResEff,Eff_Stone,3000; bonus2 bResEff,Eff_Sleep,3000; } ',NULL,NULL); +REPLACE INTO `item_db` VALUES (4354,'Gemini_Card','Gemini-S58 Card',6,NULL,10,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,769,NULL,NULL,NULL,NULL,' if(readparam(bAgi)>=90) { bonus2 bResEff,Eff_Silence,3000; bonus2 bResEff,Eff_Stun,3000; } if(readparam(bVit)>=80) { bonus2 bResEff,Eff_Stone,5000; bonus2 bResEff,Eff_Sleep,5000; } ',NULL,NULL); REPLACE INTO `item_db` VALUES (4355,'Gremlin_Card','Gremlin Card',6,NULL,10,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,' bonus3 bAddMonsterDropItem,12043,RC_Brute,50; ',NULL,NULL); REPLACE INTO `item_db` VALUES (4356,'Beholder_Card','Beholder Card',6,NULL,10,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,' skill 275,1; ',NULL,NULL); REPLACE INTO `item_db` VALUES (4357,'Lord_Knight_Card','Lord Knight Card',6,NULL,10,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,769,NULL,NULL,NULL,NULL,' skill 359,1; bonus bMaxHPrate,-50; ',NULL,NULL); diff --git a/sql-files/upgrade_svn11335.sql b/sql-files/upgrade_svn11335.sql new file mode 100644 index 000000000..19ab802af --- /dev/null +++ b/sql-files/upgrade_svn11335.sql @@ -0,0 +1 @@ +UPDATE `ragnarok`.`item_db` SET `script` = ' if(readparam(bAgi)>=90) { bonus2 bResEff,Eff_Silence,3000; bonus2 bResEff,Eff_Stun,3000; } if(readparam(bVit)>=80) { bonus2 bResEff,Eff_Stone,5000; bonus2 bResEff,Eff_Sleep,5000; } ' WHERE `item_db`.`id` =4354 LIMIT 1 ; \ No newline at end of file -- cgit v1.2.3-70-g09d2