summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
authorParadox924X <Paradox924X@54d463be-8e91-2dee-dedb-b68131a5f0ec>2007-10-01 01:34:55 +0000
committerParadox924X <Paradox924X@54d463be-8e91-2dee-dedb-b68131a5f0ec>2007-10-01 01:34:55 +0000
commitb4394a18cec9b82862f0fb8823c6b141e006851f (patch)
tree73d6ddaef621c5a8f244f0ddd801bf9ed959ffcb /sql-files
parenteb285c3eae61ab8ba4758ee6a7c987120df855f9 (diff)
downloadhercules-b4394a18cec9b82862f0fb8823c6b141e006851f.tar.gz
hercules-b4394a18cec9b82862f0fb8823c6b141e006851f.tar.bz2
hercules-b4394a18cec9b82862f0fb8823c6b141e006851f.tar.xz
hercules-b4394a18cec9b82862f0fb8823c6b141e006851f.zip
Fixed Gemini-S58 Card.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11335 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/item_db.sql2
-rw-r--r--sql-files/upgrade_svn11335.sql1
2 files changed, 2 insertions, 1 deletions
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