ItemDB SQL Sync

Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>

2 files changed, 62 insertions, 7 deletions

diff --git a/sql-files/item_db.sql b/sql-files/item_db.sql
index d53c956a9..0aec0d9a4 100644
--- a/sql-files/item_db.sql
+++ b/sql-files/item_db.sql
@@ -4699,8 +4699,8 @@ REPLACE INTO `item_db` VALUES ('12392','RepairA','Repair A','0','220','110','70'
 REPLACE INTO `item_db` VALUES ('12393','RepairB','Repair B','0','500','250','70','0','0','0','0','0','1024','8','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db` VALUES ('12394','RepairC','Repair C','0','1100','550','70','0','0','0','0','0','1024','8','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db` VALUES ('12395','Tantanmen','Tantan Noodle','2','20','10','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','pet 1519;','','');
-REPLACE INTO `item_db` VALUES ('12396','Fools_Day_Box','Gift Box?','11','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','73',NULL,'1',NULL,'0',NULL,'0','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) percentheal 50,50; else if (rand(1,10) == 6) getitem Apple,1; else if (rand(1,10) == 7) itemskill ALL_REVERSEORCISH,1; else if (rand(1,10) == 8) specialeffect2 EF_MAPPILLAR2; else if (rand(1,10) == 9) specialeffect2 EF_ANGEL2; else specialeffect2 EF_COIN;','','');
-REPLACE INTO `item_db` VALUES ('12397','Fools_Day_Box2','Gift Box?','11','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','73',NULL,'1',NULL,'0',NULL,'0','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) percentheal 50,50; else if (rand(1,10) == 6) getitem Jellopy,1; else if (rand(1,10) == 7) itemskill AL_RUWACH,1; else if (rand(1,10) == 8) specialeffect2 EF_BEGINASURA; else if (rand(1,10) == 9) specialeffect2 EF_MVP; else specialeffect2 EF_CURSEATTACK;','','');
+REPLACE INTO `item_db` VALUES ('12396','Fools_Day_Box','Gift Box?','11','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','73',NULL,'1',NULL,'0',NULL,'0','.@i = rand(1,10); if (.@i == 1) itemskill AL_TELEPORT,1; else if (.@i == 2) itemskill AL_TELEPORT,3; else if (.@i == 3) percentheal 50,0; else if (.@i == 4) percentheal 0,50; else if (.@i == 5) percentheal 50,50; else if (.@i == 6) getitem Apple,1; else if (.@i == 7) itemskill ALL_REVERSEORCISH,1; else if (.@i == 8) specialeffect2 EF_MAPPILLAR2; else if (.@i == 9) specialeffect2 EF_ANGEL2; else specialeffect2 EF_COIN;','','');
+REPLACE INTO `item_db` VALUES ('12397','Fools_Day_Box2','Gift Box?','11','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','73',NULL,'1',NULL,'0',NULL,'0','.@i = rand(1,10); if (.@i == 1) itemskill TF_DETOXIFY,1; else if (.@i == 2) itemskill TF_PICKSTONE,1; else if (.@i == 3) itemskill BA_FROSTJOKER,1; else if (.@i == 4) itemskill DC_SCREAM,1; else if (.@i == 5) percentheal 50,50; else if (.@i == 6) getitem Jellopy,1; else if (.@i == 7) itemskill AL_RUWACH,1; else if (.@i == 8) specialeffect2 EF_BEGINASURA; else if (.@i == 9) specialeffect2 EF_MVP; else specialeffect2 EF_CURSEATTACK;','','');
 REPLACE INTO `item_db` VALUES ('12398','PCBang_Gift_Box','PCBang Gift Box','2','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db` VALUES ('12399','Castle_Treasure_Box','Castle Treasure Box','2','20','10','1000','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db` VALUES ('12400','Water_Of_Blessing_','Water Of Blessing ','2','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql
index d8b8f7ffa..6cff7bd74 100644
--- a/sql-files/item_db_re.sql
+++ b/sql-files/item_db_re.sql
@@ -2626,7 +2626,7 @@ REPLACE INTO `item_db` VALUES ('4555','Scrat_Card','Scrat Card','6','20','10','1
 REPLACE INTO `item_db` VALUES ('4556','Fenrir_Card','Fenrir Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','769','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMatk,50; bonus bMatk,(getrefine()*5); bonus bFixedCastrate,-70;','','');
 REPLACE INTO `item_db` VALUES ('4557','Weakened_Fenrir_Card','Weakened Fenrir Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','769','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMatk,25;','','');
 REPLACE INTO `item_db` VALUES ('4558','Chun_Tree_Card','Chun Tree Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','4','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSubEle,Ele_Earth,20; bonus3 bAutoSpellWhenHit,PR_KYRIE,2,20;','','');
-REPLACE INTO `item_db` VALUES ('4559','Devil_Morocc_Card','Devil Morocc Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','64','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAspd,1; bonus bMaxHPrate,-10;','','');
+REPLACE INTO `item_db` VALUES ('4559','Devil_Morocc_Card','Devil Morocc Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','64','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAspd,1; bonus bMaxSPrate,-10;','','');
 REPLACE INTO `item_db` VALUES ('4560','Clown_Card','Clown Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','16','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bFlee,20; if(readparam(bVit)>=110) { bonus bFlee,20; } if(getiteminfo(getequipid(EQI_HAND_R),11)==13) { skill BA_POEMBRAGI,10; }','','');
 REPLACE INTO `item_db` VALUES ('4561','Professor_Card','Professor Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','16','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMatkRate,7; if(readparam(bDex)>=110) { bonus bMatkRate,7; } bonus5 bAutoSpellWhenHit,SA_LANDPROTECTOR,5,70,BF_MAGIC,0;','','');
 REPLACE INTO `item_db` VALUES ('4562','Champion_Card','Champion Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','16','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtkRate,7; if(readparam(bAgi)>=110) { bonus bAtkRate,7; } bonus5 bAutoSpellWhenHit,MO_INVESTIGATE,5,70,BF_WEAPON,1;','','');
@@ -2694,7 +2694,62 @@ REPLACE INTO `item_db` VALUES ('4637','Immortal_Corps_Card','Immortal Corps Card
 REPLACE INTO `item_db` VALUES ('4638','Watcher_Card','Watcher Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','16','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtk,30; /* When attacked by enemy, drain 5 SP from user. */','','');
 REPLACE INTO `item_db` VALUES ('4639','Taffy_Card','Taffy Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtkRate,1;','','');
 REPLACE INTO `item_db` VALUES ('4640','Frozen_Wolf_Card','Frozen Wolf Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMatkRate,1;','','');
-REPLACE INTO `item_db` VALUES ('4641','Zombie_Guard_Card','Zombie Guard Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','32','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
+REPLACE INTO `item_db` VALUES ('4641','Zombie_Guard_Card','Zombie Guard Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','32','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bSPrecovRate,-100; /*Each time you get a physical attack, recover SP by 1.*/','','');
+REPLACE INTO `item_db` VALUES ('4642','Infinite_Toad_Card','Infinite Toad Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','64','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bFlee2,2; if (getrefine() > 6) bonus bFlee2,2; if (getrefine() > 8) bonus bFlee2,3;','','');
+REPLACE INTO `item_db` VALUES ('4643','Infinite_Vagabond_Wolf_Card','Infinite Vagabond Wolf Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','64','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtk,10; if (getrefine() > 6) bonus bAtk,10; if (getrefine() > 8) bonus bAtk,15;','','');
+REPLACE INTO `item_db` VALUES ('4644','Infinite_Vocal_Card','Infinite Vocal Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','64','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,5; if (getrefine() > 6) bonus bMdef,10; if (getrefine() > 8) bonus bMdef,15;','','');
+REPLACE INTO `item_db` VALUES ('4645','Infinite_Eclipse_Card','Infinite Eclipse Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','64','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP,300; if (getrefine() > 6) bonus bMaxHP,300; if (getrefine() > 8) bonus bMaxHP,400;','','');
+REPLACE INTO `item_db` VALUES ('4646','Infinite_Chimera_Card','Infinite Chimera Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','4','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHPrate,8; bonus bMaxSPrate,4;','','');
+REPLACE INTO `item_db` VALUES ('4647','Infinite_Osiris_Card','Infinite_Osiris_Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHPGainValue,300;','','');
+REPLACE INTO `item_db` VALUES ('4648','Infinite_Eddga_Card','Infinite_Eddga_Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','64','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus3 bAutoSpellWhenHit,SM_PROVOKE,10,500;','','');
+REPLACE INTO `item_db` VALUES ('4649','Infinite_Phreeoni_Card','Infinite Phreeoni Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bCritical,100;','','');
+REPLACE INTO `item_db` VALUES ('4650','Infinite_Orc_Hero_Card','Infinite Orc Hero Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','769','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bVit,3; /* When received magical attack, give 100% chance to stun the attacker. */','','');
+REPLACE INTO `item_db` VALUES ('4651','Infinite_Tao_Gunka_Card','Infinite Tao Gunka Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','16','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP,10000; bonus bAgi,-10;','','');
+REPLACE INTO `item_db` VALUES ('4652','Nightmare_Amon_Ra_Card','Nightmare Amon Ra Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','16','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bMagicAddEle,Ele_Shadow,50; bonus2 bMagicAddEle,Ele_Undead,50; bonus2 bMagicAddRace,RC_Demon,50; bonus2 bMagicAddRace,RC_Undead,50;','','');
+REPLACE INTO `item_db` VALUES ('4653','Nightmare_Arclouse_Card','Nightmare Arclouse Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','32','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSubRace,RC_Brute,20; bonus2 bSubRace,RC_Undead,20;','','');
+REPLACE INTO `item_db` VALUES ('4654','Nightmare_Mimic_Card','Nightmare Mimic Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bMagicAddRace,RC_Brute,5; bonus2 bMagicAddRace,RC_Undead,5;','','');
+REPLACE INTO `item_db` VALUES ('4655','Nightmare_Minorous_Card','Nightmare Minorous Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace,RC_Brute,10; bonus2 bAddRace,RC_Undead,10;','','');
+REPLACE INTO `item_db` VALUES ('4656','Nightmare_Mummy_Card','Nightmare Mummy Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','64','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
+REPLACE INTO `item_db` VALUES ('4657','Nightmare_Ancient_Mummy_Card','Nightmare Ancient Mummy Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','4','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSubEle,Ele_Neutral,15; bonus2 bMagicAtkEle,Ele_Fire,3+(getrefine()*3);','','');
+REPLACE INTO `item_db` VALUES ('4658','Nightmare_Verit_Card','Nightmare Verit Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','64','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMatkRate,5; if (getrefine() > 6) bonus bMatkRate,3; if (getrefine() > 8) bonus bMatkRate,2;','','');
+REPLACE INTO `item_db` VALUES ('4659','Eggring_Card','Eggring Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','16','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bLuk,2; bonus bMaxHP,50;','','');
+REPLACE INTO `item_db` VALUES ('4660','Scout_Basilisk_Card','Scout Basilisk Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','32','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSubSize,Size_Small,5; bonus2 bSubSize,Size_Medium,5;','','');
+REPLACE INTO `item_db` VALUES ('4661','Charge_Basilisk_Card','Charge Basilisk Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','32','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSubSize,Size_Small,-15; bonus2 bSubSize,Size_Medium,20; bonus2 bSubSize,Size_Large,20;','','');
+REPLACE INTO `item_db` VALUES ('4662','Big_Eggring_Card','Big Eggring Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','4','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtk,25; bonus bMatk,25; bonus bAspdRate,10; bonus bMaxHP,1000; bonus bLongAtkRate,5; bonus bCritAtkRate,10; bonus bAtk,-5/(readparam(bStr)*10); bonus bAspdRate,-2/(readparam(bAgi)*10); bonus bMatk,-5/(readparam(bInt)*10); bonus bMaxHP,-200/(readparam(bVit)*10); bonus bLongAtkRate,-1/(readparam(bDex)*10); bonus bCritAtkRate,-2/(readparam(bLuk)*10);','','');
+REPLACE INTO `item_db` VALUES ('4663','Leaf_Lunatic_Card','Leaf Lunatic Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','64','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxSP,5;','','');
+REPLACE INTO `item_db` VALUES ('4664','Grass_Fabre_Card','Grass Fabre Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','16','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bLuk,1; bonus bMaxHP,100;','','');
+REPLACE INTO `item_db` VALUES ('4665','Wild_Hornet_Card','Wild Hornet Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtk,5;','','');
+REPLACE INTO `item_db` VALUES ('4666','Swift_Roda_Frog_Card','Swift Roda Frog Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','16','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxSP,10; bonus bMaxHP,300;','','');
+REPLACE INTO `item_db` VALUES ('4667','Hunter_Wolf_Card','Hunter Wolf Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','64','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxSP,30;','','');
+REPLACE INTO `item_db` VALUES ('4668','Trance_Spore_Card','Trance Spore Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','769','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bVit,1; bonus bInt,1;','','');
+REPLACE INTO `item_db` VALUES ('4669','Jungle_Mandragora_Card','Jungle Mandragora Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bMagicAddEle,Ele_Wind,3; if (getrefine() > 6) bonus2 bMagicAddEle,Ele_Wind,5; if (getrefine() > 8) bonus2 bMagicAddEle,Ele_Wind,7;','','');
+REPLACE INTO `item_db` VALUES ('4670','Fruit_Pom_Spider','Fruit Pom Spider','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bMagicAddEle,Ele_Fire,3; if (getrefine() > 6) bonus2 bMagicAddEle,Ele_Fire,5; if (getrefine() > 8) bonus2 bMagicAddEle,Ele_Fire,7;','','');
+REPLACE INTO `item_db` VALUES ('4671','Sorcerer_Celia_Card','Sorcerer Celia Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','4','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if (BaseLevel == 175) bonus bAllStats,10; if (getrefine() >= 10) bonus bAllStats,10; if (Class == Job_Sorcerer || Class == Job_Sorcerer_T) { bonus bMaxHPrate,10; bonus bMatkRate,10; }','','');
+REPLACE INTO `item_db` VALUES ('4672','Sura_Chen_Card','Sura Chen Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','4','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if (BaseLevel == 175) bonus bAllStats,10; if (getrefine() >= 10) bonus bAllStats,10; if (Class == Job_Sura || Class == Job_Sura_T) { bonus bMaxHPrate,10; bonus bAtkRate,10; }','','');
+REPLACE INTO `item_db` VALUES ('4673','Minstrel_Alphoccio_Card','Minstrel Alphoccio Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','4','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if (BaseLevel == 175) bonus bAllStats,10; if (getrefine() >= 10) bonus bAllStats,10; if (Class == Job_Minstrel || Class == Job_Minstrel_T) { bonus bMaxHPrate,15; bonus bMaxSPrate,10; }','','');
+REPLACE INTO `item_db` VALUES ('4674','Guillotine_Cross_Eremes_Card','Guillotine Cross Eremes Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','4','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if (BaseLevel == 175) bonus bAllStats,10; if (getrefine() >= 10) bonus bAllStats,10; if (Class == Job_Guillotine_Cross || Class == Job_Guillotine_Cross_T) { bonus bFlee2,10; bonus bAtkRate,15; }','','');
+REPLACE INTO `item_db` VALUES ('4675','Arch_Bishop_Magaleta_Card','Arch Bishop Magaleta Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','4','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if (BaseLevel == 175) bonus bAllStats,10; if (getrefine() >= 10) bonus bAllStats,10; if (Class == Job_Arch_Bishop || Class == Job_Arch_Bishop_T) { bonus bMaxHPrate,10; bonus bHealPower,15; }','','');
+REPLACE INTO `item_db` VALUES ('4676','Ranger_Cecil_Card','Ranger Cecil Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','4','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if (BaseLevel == 175) bonus bAllStats,10; if (getrefine() >= 10) bonus bAllStats,10; if (Class == Job_Ranger || Class == Job_Ranger_T) { bonus bCritical,20; bonus bLongAtkRate,15; }','','');
+REPLACE INTO `item_db` VALUES ('4677','Mechanic_Howard_Card','Merchanic Howard Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','4','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if (BaseLevel == 175) bonus bAllStats,10; if (getrefine() >= 10) bonus bAllStats,10; if (Class == Job_Mechanic || Class == Job_Mechanic_T) { bonus bHit,20; bonus bAtkRate,15; }','','');
+REPLACE INTO `item_db` VALUES ('4678','Warlock_Kathryne_Card','Warlock Kathryne Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','4','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if (BaseLevel == 175) bonus bAllStats,10; if (getrefine() >= 10) bonus bAllStats,10; if (Class == Job_Warlock || Class == Job_Warlock_T) { bonus bMdef,80; bonus bMatkRate,15; }','','');
+REPLACE INTO `item_db` VALUES ('4679','Rune_Knight_Seyren_Card','Rune Knight Seyren Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','4','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if (BaseLevel == 175) bonus bAllStats,10; if (getrefine() >= 10) bonus bAllStats,10; if (Class == Job_Rune_Knight || Class == Job_Rune_Knight_T) { bonus bAspd,2; bonus bAtkRate,15; }','','');
+REPLACE INTO `item_db` VALUES ('4680','Royal_Guard_Randel_Card','Royal Guard Randel Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','4','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if (BaseLevel == 175) bonus bAllStats,10; if (getrefine() >= 10) bonus bAllStats,10; if (Class == Job_Royal_Guard || Class == Job_Royal_Guard_T) { bonus bDef,350; bonus bAtkRate,10; }','','');
+REPLACE INTO `item_db` VALUES ('4681','Genetic_Flamel_Card','Genetic Flamel Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','4','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if (BaseLevel == 175) bonus bAllStats,10; if (getrefine() >= 10) bonus bAllStats,10; if (Class == Job_Genetic || Class == Job_Genetic_T) { bonus bFlee,20; bonus bAtkRate,15; }','','');
+REPLACE INTO `item_db` VALUES ('4682','Shadow_Chaser_Gertie_Card','Shadow Chaser Gertie Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','4','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if (BaseLevel == 175) bonus bAllStats,10; if (getrefine() >= 10) bonus bAllStats,10; if (Class == Job_Shadow_Chaser || Class == Job_Shadow_Chaser_T) { bonus bAtkRate,5; bonus bMatkRate,15; }','','');
+REPLACE INTO `item_db` VALUES ('4683','Wanderer_Trentini_Card','Wanderer Trentini Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','4','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if (BaseLevel == 175) bonus bAllStats,10; if (getrefine() >= 10) bonus bAllStats,10; if (Class == Job_Wanderer || Class == Job_Wanderer_T) { bonus bMaxHPrate,10; bonus bMaxSPrate,15; }','','');
+REPLACE INTO `item_db` VALUES ('4684','True_Eremes_Guile_Card','True Eremes Guile Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillAtk,GC_CROSSIMPACT,100; if (getrefine() >= 10) bonus2 bSkillAtk,GC_CROSSIMPACT,200;','','');
+REPLACE INTO `item_db` VALUES ('4685','True_Margaretha_Sorin_Card','True Margaretha Sorin Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillAtk,AB_JUDEX,100; if (getrefine() >= 10) bonus2 bSkillAtk,AB_JUDEX,200;','','');
+REPLACE INTO `item_db` VALUES ('4686','True_Kathryne_Keyron_Card','True Kathryne Keyron Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillAtk,WL_HELLINFERNO,100; if (getrefine() >= 10) bonus2 bSkillAtk,WL_HELLINFERNO,200;','','');
+REPLACE INTO `item_db` VALUES ('4687','True_Cecil_Damon_Card','True Cecil Damon Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillAtk,RA_AIMEDBOLT,100; if (getrefine() >= 10) bonus2 bSkillAtk,RA_AIMEDBOLT,200;','','');
+REPLACE INTO `item_db` VALUES ('4688','True_Howard_Alt-Eisen_Card','True Howard Alt-Eisen Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillAtk,NC_POWERSWING,100; if (getrefine() >= 10) bonus2 bSkillAtk,NC_POWERSWING,200;','','');
+REPLACE INTO `item_db` VALUES ('4689','True_Seyren_Windsor_Card','True Seyren Windsor Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillAtk,RK_SONICWAVE,100; if (getrefine() >= 10) bonus2 bSkillAtk,RK_SONICWAVE,200;','','');
+REPLACE INTO `item_db` VALUES ('4690','True_Randel_Lawrence_Card','True Randel Lawrence Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillAtk,LG_BANISHINGPOINT,100; if (getrefine() >= 10) bonus2 bSkillAtk,LG_BANISHINHPOINT,200;','','');
+REPLACE INTO `item_db` VALUES ('4691','True_Flamel_Emure_Card','True Flamel Emure Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillAtk,GN_CARTCANNON,100; if (getrefine() >= 10) bonus2 bSkillAtk,GN_CARTCANNON,200;','','');
+REPLACE INTO `item_db` VALUES ('4692','True_Celia_Alde_Card','True Celia Alde Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillAtk,SO_CLOUD_KILL,100; if (getrefine() >= 10) bonus2 bSkillAtk,SO_CLOUDKILL,200;','','');
+REPLACE INTO `item_db` VALUES ('4693','True_Chen_Liu_Card','True Chen Liu Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillAtk,SR_DRAGONCOMBO,100; if (getrefine() >= 10) bonus2 bSkillAtk,SR_DRAGONCOMBO,200;','','');
+REPLACE INTO `item_db` VALUES ('4694','True_Gertie_Card','True Gertie Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillAtk,SC_FEINTBOMB,100; if (getrefine() >= 10) bonus2 bSkillAtk,SC_FEINTBOMB,200;','','');
+REPLACE INTO `item_db` VALUES ('4695','True_Trentini_Card','True Trentini Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillAtk,WM_METALICSOUND,100; if (getrefine() >= 10) bonus2 bSkillAtk,WM_METALICSOUND,200;','','');
+REPLACE INTO `item_db` VALUES ('4696','True_Alphoccio_Card','True Alphoccio Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillAtk,WM_REVERBERATION,100; if (getrefine() >= 10) bonus2 bSkillAtk,WM_REVERBERATION,200;','','');
 REPLACE INTO `item_db` VALUES ('4700','Strength1','STR+1','6','20','10','10','0','0','0','0','0','4294967295','63','2','16','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,1;','','');
 REPLACE INTO `item_db` VALUES ('4701','Strength2','STR+2','6','20','10','10','0','0','0','0','0','4294967295','63','2','16','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,2;','','');
 REPLACE INTO `item_db` VALUES ('4702','Strength3','STR+3','6','20','10','10','0','0','0','0','0','4294967295','63','2','16','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,3;','','');
@@ -3740,7 +3795,7 @@ REPLACE INTO `item_db` VALUES ('5906','Oni_Horns_','Oni Horns','5','20','10','20
 REPLACE INTO `item_db` VALUES ('5907','Sea_Captain_Hat','Sea Captain Hat','5','20','10','200','0','0','20','0','1','1024','56','2','256','0','100',NULL,'1','1128','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillAtk,NC_AXETORNADO,20; bonus2 bSkillAtk,NC_AXEBOOMERANG,20; if(getrefine()>6) { bonus2 bSkillAtk,NC_AXETORNADO,getskilllv(BS_WEAPONRESEARCH); } if(getrefine()>8) { bonus2 bSkillAtk,NC_AXETORNADO,getskilllv(NC_TRAININGAXE); }','','');
 REPLACE INTO `item_db` VALUES ('5918','Gambler_Seal','Gambler Seal','5','20','10','500','0','0','0','0','0','4294967295','63','2','512','0','70',NULL,'0','1202','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bCritical,3; bonus bCritAtkRate,3;','','');
 REPLACE INTO `item_db` VALUES ('5921','Fish_Monster\'s_Grill','Fish Monster\'s Grill','5','0','0','200','0','0','1','0','0','4294967295','63','2','512','0','10',NULL,'1','1218','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
-REPLACE INTO `item_db` VALUES ('5932','Birdcage_of_paradise','Birdcage of paradise','5','20','10','800','0','0','6','0','0','4294967295','63','2','256','0','40',NULL,'1','1286','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bLuk,5; bonus bCritical,5; bonus bFlee2,5; if(BaseClass==Job_Ranger||BaseClass==Job_Ranger_T) { skill HT_BLITZBEAT,5*getrefine(); if (isequipped(Ixion_Wing)) { skill HT_BLITZBEAT,5*getequiprefinerycnt(EQI_HAND_R); } }','','');
+REPLACE INTO `item_db` VALUES ('5932','Birdcage_Of_Paradise','Birdcage Of Paradise','5','20','10','800','0','0','6','0','0','4294967295','63','2','256','0','40',NULL,'1','1286','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bLuk,5; bonus bCritical,5; bonus bFlee2,5; if (Class == Job_Ranger || Class == Job_Ranger_T) { skill HT_BLITZBEAT,5*getrefine(); }','','');
 REPLACE INTO `item_db` VALUES ('5933','Crow_Tengu_Mask','Crow Tengu Mask','5','20','10','300','0','0','0','0','0','4294967295','63','2','512','0','80',NULL,'1','1287','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtkRate,1; bonus bLongAtkRate,2; if(readparam(bStr)>=108) { bonus bAtkRate,1; bonus bLongAtkRate,2; } if(readparam(bStr)>=120) { bonus bAtkRate,2; bonus bLongAtkRate,3; }','','');
 REPLACE INTO `item_db` VALUES ('5934','Happy_Balloon','Happy Balloon','5','0','0','100','0','0','0','0','0','4294967295','63','2','1','0','10',NULL,'0','1289','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableHelm,0; bonus bMdef,5; bonus2 bAddMonsterDropItem,644,30; /*Custom - JRO*/ /*+Mistcase card, when base Luk is 77 or more, Has change to drops \\\'Happy Box\\\' when killing a monster.*/','','');
 REPLACE INTO `item_db` VALUES ('5941','Joystick_Hat','Joystick Hat','5','0','0','100','0','0','0','0','0','4294967295','63','2','256','0','0',NULL,'1','1305','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,5; bonus bLuk,5; bonus4 bAutoSpell,BS_ADRENALINE,5,100,0; bonus5 bAutoSpellWhenHit,AC_CONCENTRATION,5,100,BF_WEAPON,0;','','');
@@ -5916,8 +5971,8 @@ REPLACE INTO `item_db` VALUES ('12392','RepairA','Repair A','0','275','137','100
 REPLACE INTO `item_db` VALUES ('12393','RepairB','Repair B','0','625','312','140','0','0','0','0','0','1024','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','if(checkmount() == MOUNT_MADO) itemheal rand(300,400),0;','','');
 REPLACE INTO `item_db` VALUES ('12394','RepairC','Repair C','0','1375','687','180','0','0','0','0','0','1024','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','if(checkmount() == MOUNT_MADO) itemheal rand(400,500),0;','','');
 REPLACE INTO `item_db` VALUES ('12395','Tantanmen','Tantan Noodle','2','20','10','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','pet 1519;','','');
-REPLACE INTO `item_db` VALUES ('12396','Fools_Day_Box','Gift Box?','11','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'1',NULL,'0',NULL,'0','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) percentheal 50,50; else if (rand(1,10) == 6) getitem Apple,1; else if (rand(1,10) == 7) itemskill ALL_REVERSEORCISH,1; else if (rand(1,10) == 8) specialeffect2 EF_MAPPILLAR2; else if (rand(1,10) == 9) specialeffect2 EF_ANGEL2; else specialeffect2 EF_COIN;','','');
-REPLACE INTO `item_db` VALUES ('12397','Fools_Day_Box2','Gift Box?','11','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'1',NULL,'0',NULL,'0','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) percentheal 50,50; else if (rand(1,10) == 6) getitem Jellopy,1; else if (rand(1,10) == 7) itemskill AL_RUWACH,1; else if (rand(1,10) == 8) specialeffect2 EF_BEGINASURA; else if (rand(1,10) == 9) specialeffect2 EF_MVP; else specialeffect2 EF_CURSEATTACK;','','');
+REPLACE INTO `item_db` VALUES ('12396','Fools_Day_Box','Gift Box?','11','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'1',NULL,'0',NULL,'0','.@i = rand(1,10); if (.@i == 1) itemskill AL_TELEPORT,1; else if (.@i == 2) itemskill AL_TELEPORT,3; else if (.@i == 3) percentheal 50,0; else if (.@i == 4) percentheal 0,50; else if (.@i == 5) percentheal 50,50; else if (.@i == 6) getitem Apple,1; else if (.@i == 7) itemskill ALL_REVERSEORCISH,1; else if (.@i == 8) specialeffect2 EF_MAPPILLAR2; else if (.@i == 9) specialeffect2 EF_ANGEL2; else specialeffect2 EF_COIN;','','');
+REPLACE INTO `item_db` VALUES ('12397','Fools_Day_Box2','Gift Box?','11','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'1',NULL,'0',NULL,'0','.@i = rand(1,10); if (.@i == 1) itemskill TF_DETOXIFY,1; else if (.@i == 2) itemskill TF_PICKSTONE,1; else if (.@i == 3) itemskill BA_FROSTJOKER,1; else if (.@i == 4) itemskill DC_SCREAM,1; else if (.@i == 5) percentheal 50,50; else if (.@i == 6) getitem Jellopy,1; else if (.@i == 7) itemskill AL_RUWACH,1; else if (.@i == 8) specialeffect2 EF_BEGINASURA; else if (.@i == 9) specialeffect2 EF_MVP; else specialeffect2 EF_CURSEATTACK;','','');
 REPLACE INTO `item_db` VALUES ('12398','PCBang_Gift_Box','PCRoom Gift Box','2','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db` VALUES ('12399','Castle_Treasure_Box','Castle Treasure Box','2','20','10','1000','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db` VALUES ('12400','Water_Of_Blessing_','Water Of Blessing','2','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');