* Some drop and item fixes

- also updated sql files
- time for players to test all the new stuff now :x

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11128 54d463be-8e91-2dee-dedb-b68131a5f0ec

3 files changed, 7 insertions, 5 deletions

diff --git a/db/Changelog.txt b/db/Changelog.txt
index a1148a319..5bde4deba 100644
--- a/db/Changelog.txt
+++ b/db/Changelog.txt
@@ -28,6 +28,8 @@
 
 ========================
 09/04
+	* Some drop and item fixes [Playtester]
+	- also updated sql files
 	* Added drops to Cursed Abbey mobs [Playtester]
 	* Updated several item scripts to use bonus3 autospells rather than bonus4
 	  ones. [Skotlex]
diff --git a/db/item_db.txt b/db/item_db.txt
index 380f9bfcc..ea2192f61 100644
--- a/db/item_db.txt
+++ b/db/item_db.txt
@@ -1717,7 +1717,7 @@
 4423,Galion_Card,Galion_Card,6,,10,10,,,,,,,,136,,,,,{ bonus bHit,5; bonus2 bAddEle,Ele_Water,5; },{},{}
 4424,Stapo_Card,Stapo_Card,6,,10,10,,,,,,,,136,,,,,{ skill 151,1; skill 152,1; },{},{}
 4425,Atroce_Card,Atroce_Card,6,,10,10,,,,,,,,2,,,,,{ bonus bBaseAtk,25; },{},{}
-4426,Byorgue_Card,Byorgue_Card,6,,10,10,,,,,,,,16,,,,,{ if (BaseJob == Job_Rogue) { bonus bMatkRate,10; bonus bAtkRate,10; },},{}
+4426,Byorgue_Card,Byorgue_Card,6,,10,10,,,,,,,,16,,,,,{ if(BaseJob == Job_Rogue){ bonus bMatkRate,10; bonus bAtkRate,10; } },{},{}
 4427,Sword_Guardian_Card,Sword_Guardian_Card,6,,10,10,,,,,,,,2,,,,,{ bonus bHit,5; bonus bCritical,5; if (getiteminfo(getequipid(4),11) == 2 || getiteminfo(getequipid(4),11) == 3) bonus2 bSkillAtk,62,25; },{},{}
 4428,Bow_Guardian_Card,Bow_Guardian_Card,6,,10,10,,,,,,,,2,,,,,{ bonus bHit,5; bonus bCritical,5; if (getiteminfo(getequipid(4),11) == 11) bonus2 bSkillAtk,47,50; },{},{}
 4429,Salamander_Card,Salamander_Card,6,,10,10,,,,,,,,4,,,,,{ bonus2 bSkillAtk,80,40; bonus2 bSkillAtk,83,40; },{},{}
@@ -1729,7 +1729,7 @@
 4435,Zombie_Slaughter_Card,Zombie_Slaughter_Card,6,,10,10,,,,,,,,64,,,,,{ bonus2 bAddRace,RC_DemiHuman,1; bonus2 bMagicAddRace,DemiHuman,1; bonus bHPGainValue,50;  if(isequipped(4435)) bonus bSPGainValue,2; },{},{}
 4436,Ragged_Zombie_Card,Ragged_Zombie_Card,6,,10,10,,,,,,,,136,,,,,{ bonus2 bCriticalAddRace,RC_DemiHuman,5; bonus2 bAddRace,RC_DemiHuman,1; bonus2 bMagicAddRace,DemiHuman,1; bonus2 bAddEff2,Eff_Bleeding,50; },{},{}
 4437,Hell_Poodle_Card,Hell_Poodle_Card,6,,10,10,,,,,,,,136,,,,,{ bonus bHit,1; bonus2 bAddItemHealRate,517,100; bonus2 bAddEff,Eff_Bleeding,100; },{},{}
-4438,Banshee_Card,Banshee_Card,6,,10,10,,,,,,,,769,,,,,{ if (BaseClass == Job_Mage) { bonus bMaxSP,100; bonus bMaxHP,-100; bonus2 bSkillAtk,11,20; bonus2 bSkillAtk,13,20; bonus2 bSkillAtk,400,20; },},{}
+4438,Banshee_Card,Banshee_Card,6,,10,10,,,,,,,,769,,,,,{ if(BaseClass == Job_Mage){ bonus bMaxSP,100; bonus bMaxHP,-100; bonus2 bSkillAtk,11,20; bonus2 bSkillAtk,13,20; bonus2 bSkillAtk,400,20; } },{},{}
 4439,Flame_Skull_Card,Flame_Skull_Card,6,,10,10,,,,,,,,32,,,,,{ bonus2 bResEff,Eff_Blind,3000; bonus2 bResEff,Eff_Stun,3000; bonus2 bResEff,Eff_Curse,3000; bonus2 bResEff,Eff_Stone,3000; bonus2 bAddEffWhenHit,Eff_Blind,100; bonus2 bAddEffWhenHit,Eff_Stun,100; bonus2 bAddEffWhenHit,Eff_Curse,100; bonus2 bAddEffWhenHit,Eff_Stone,100; },{},{}
 4440,Necromancer_Card,Necromancer_Card,6,,10,10,,,,,,,,2,,,,,{ if (getiteminfo(getequipid(4),11) == 10) { bonus bInt,1; bonus bIgnoreMdefRate,2; } },{},{}
 4441,Fallen_Bishop_Hibram_Card,Fallen_Bishop_Hibram_Card,6,,10,10,,,,,,,,64,,,,,{ bonus bMAtkRate,10; bonus bMaxSPrate,-50; bonus2 bAddRace,RC_Angel,50; bonus2 bAddRace,RC_DemiHuman,50; },{},{}
diff --git a/db/mob_db.txt b/db/mob_db.txt
index 0df25a234..a6449fbb8 100644
--- a/db/mob_db.txt
+++ b/db/mob_db.txt
@@ -851,7 +851,7 @@
 1815,EVENT_RICECAKE,Rice Cake,Rice Cake,12,20,0,0,0,1,1,2,100,99,1,1,1,1,1,1,0,0,1,0,20,0x40,2000,1320,0,300,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
 1816,EVENT_GOURD,Gourd,Gourd,12,1000,0,0,0,1,1,2,100,99,1,1,1,1,1,1,0,0,1,0,20,0x40,2000,96,96,96,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
 
-1829,SWORD_GUADIAN,Sword Guardian,Sword Master,86,152533,0,155013,122604,2,7590,9140,60,33,1,40,54,65,125,65,14,16,2,7,80,0x37B5,170,140,384,288,0,0,0,0,0,0,0,0,7069,3000,1370,30,1163,50,1168,1,0,0,0,0,0,0,1422,5,1176,5,0,0
+1829,SWORD_GUADIAN,Sword Guardian,Sword Master,86,152533,0,155013,122604,2,7590,9140,60,33,1,40,54,65,125,65,14,16,2,7,80,0x37B5,170,140,384,288,0,0,0,0,0,0,0,0,7069,3000,1370,30,1163,50,1168,1,0,0,0,0,2122,3,1422,5,1176,5,0,0
 1830,BOW_GUARDIAN,Bow Guardian,Bow Master,80,80404,0,50149,23006,12,1840,2520,40,62,1,80,33,90,165,55,14,16,2,7,80,0x37B5,170,76,384,288,0,0,0,0,0,0,0,0,7069,3000,1723,30,1701,50,0,0,0,0,0,0,0,0,2367,3,2701,1,0,0
 1831,SALAMANDER,Salamander,Salamander,91,97934,0,72000,55000,2,7590,10860,65,50,1,55,44,45,180,25,10,12,2,0,63,0x37B5,160,140,384,288,0,0,0,0,0,0,0,0,7097,3000,994,30,716,100,2680,1,1370,5,2621,1,0,0,1920,3,2364,2,0,0
 1832,IFRIT,Ifrit,Ifrit,99,7700000,0,3154321,3114520,3,13530,17000,40,50,1,180,25,190,199,50,10,12,2,0,83,0x37B5,130,212,384,360,1577160,10000,603,5500,617,5000,616,2000,994,10000,2677,3000,2678,100,2679,100,1471,2000,1133,2000,1473,2000,2345,100,0,0,0,0
@@ -871,10 +871,10 @@
 1868,G_BANSHEE,Banshee,Banshee,81,35111,0,0,0,1,1666,2609,30,55,30,74,1,120,75,1,10,12,1,6,47,0x3795,150,576,504,504,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
 1869,FLAME_SKULL,Flame Skull,Flame Skull,60,10800,0,3000,2600,1,100,1200,20,40,50,100,30,40,140,110,10,12,0,6,68,0x3195,150,972,648,432,0,0,0,0,0,0,0,0,957,3000,7005,1000,990,10,13170,3,2425,2,0,0,0,0,0,0,0,0,0,0
 1870,NECROMANCER,Necromancer,Necromancer,88,98000,0,45000,35000,1,3500,4000,0,30,1,50,1,190,166,10,10,12,1,1,89,0x37B5,150,1816,1320,420,0,0,0,0,0,0,0,0,932,3000,7005,1000,7752,1000,7099,1000,2609,10,1624,3,2532,2,0,0,0,0,0,0
-1871,FALLINGBISHOP,Falling Bishop,Falling Bishop,80,3333333,0,3333333,3333333,1,3220,5040,50,0,1,80,15,126,120,20,10,12,1,6,47,0x37B5,150,432,1152,360,0,0,0,0,0,0,0,0,523,3000,985,1000,1614,10,1615,10,1420,5,1422,5,2677,2,0,0,0,0,0,0
+1871,FALLINGBISHOP,Falling Bishop,Falling Bishop,80,3333333,0,3333333,3333333,1,3220,5040,50,0,1,80,15,126,120,20,10,12,1,6,47,0x37B5,150,432,1152,360,1666666,10000,607,5500,617,5000,617,5000,523,3000,985,1000,1614,10,1615,10,1420,5,1422,5,2677,2,0,0,0,0,0,0
 1872,BEELZEBUB_FLY,Beelzebub Fly,Hell Fly,66,500000,0,0,0,1,1200,2000,25,15,33,105,60,15,72,30,10,12,0,4,84,0x37B5,100,676,576,480,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
 1873,BEELZEBUB,Beelzebub,Beelzebub,98,6666666,0,0,0,1,4100,4960,40,35,6,110,200,250,120,66,10,12,0,6,88,0x37B5,100,100,576,480,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
-1874,BEELZEBUB_,Beelzebub,Beelzebub,98,6666666,0,6666666,6666666,2,10000,13410,40,40,6,110,200,250,166,66,10,12,2,6,88,0x37B5,100,212,504,432,3333333,10000,607,5500,617,5000,617,5000,7754,3000,985,2000,742,2000,1565,9,2000,9,2122,6,2423,6,2702,3,0,0,0,0
+1874,BEELZEBUB_,Beelzebub,Beelzebub,98,6666666,0,6666666,6666666,2,10000,13410,40,40,6,110,200,250,166,66,10,12,2,6,88,0x37B5,100,212,504,432,3333333,10000,607,5500,617,5000,617,5000,7754,3000,985,2000,742,2000,1565,9,2000,9,2423,6,2702,3,0,0,0,0,0,0
 1875,TRISTAN_3RD,Tristan 3RD,Tristan III,80,43000,0,1,1,2,1366,1626,25,30,5,10,10,69,70,1,10,12,1,1,89,0x3695,175,1816,1152,360,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
 
 //Moscovia monsters (with sense info)