From c57745995dcde9ff5d784227127d52ebd4c93ba3 Mon Sep 17 00:00:00 2001 From: "Hercules.ws" Date: Fri, 8 Aug 2014 21:04:29 +0200 Subject: ItemDB SQL Sync Signed-off-by: HerculesWSAPI --- sql-files/item_db_re.sql | 14 +++++++------- 1 file changed, 7 insertions(+), 7 deletions(-) (limited to 'sql-files') diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql index 7e7277669..4d1d8de97 100644 --- a/sql-files/item_db_re.sql +++ b/sql-files/item_db_re.sql @@ -2388,7 +2388,7 @@ REPLACE INTO `item_db_re` VALUES ('4411','Vanberk_Card','Vanberk Card','6','20', REPLACE INTO `item_db_re` VALUES ('4412','Isilla_Card','Isilla Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','769','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,2; autobonus \"{ bonus bVariableCastrate,-50; bonus bFlee,30; }\",50,5000,BF_MAGIC,\"{ specialeffect2 EF_SUFFRAGIUM; }\";','',''); REPLACE INTO `item_db_re` VALUES ('4413','Hodremlin_Card','Hodremlin Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','32','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSubSize,Size_Small,15; bonus2 bSubSize,Size_Medium,15; bonus2 bSubSize,Size_Large,15; autobonus2 \"{ bonus bFlee2,30; }\",3,10000,BF_WEAPON|BF_MAGIC,\"{ specialeffect2 EF_WIND; }\";','',''); REPLACE INTO `item_db_re` VALUES ('4414','Seeker_Card','Seeker Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','32','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','skill MG_STONECURSE,1; bonus2 bResEff,Eff_Stone,3000; bonus bMdef,10;','',''); -REPLACE INTO `item_db_re` VALUES ('4415','Snowier_Card','Snowier Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddMonsterDropItem,536,2000; bonus2 bAddItemHealRate,536,500;','',''); +REPLACE INTO `item_db_re` VALUES ('4415','Snowier_Card','Snowier Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddMonsterDropItem,536,500; bonus2 bAddItemHealRate,536,100;','',''); REPLACE INTO `item_db_re` VALUES ('4416','Siroma_Card','Siroma Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillAtk,MG_COLDBOLT,25; bonus2 bVariableCastrate,MG_COLDBOLT,-25;','',''); REPLACE INTO `item_db_re` VALUES ('4417','Ice_Titan_Card','Ice Titan Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','64','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bVit,2; autobonus2 \"{ bonus bDef,10; }\",3,10000,BF_WEAPON|BF_MAGIC,\"{ specialeffect2 EF_FREEZED; }\";','',''); REPLACE INTO `item_db_re` VALUES ('4418','Gazeti_Card','Gazeti Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus3 bAutoSpell,MG_COLDBOLT,2,100;','',''); @@ -2430,17 +2430,17 @@ REPLACE INTO `item_db_re` VALUES ('4454','Light_Up_Card1','No name card','6','20 REPLACE INTO `item_db_re` VALUES ('4455','Light_Up_Card2','No name card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db_re` VALUES ('4456','Nidhogg_Shadow_Card','Nidhoggur Shadow Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','16','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,5; if (Class == Job_High_Wizard || Class == Job_Baby_Warlock || Class == Job_Warlock || Class == Job_Warlock_T) bonus bFixedCastrate,-50;','',''); REPLACE INTO `item_db_re` VALUES ('4457','Nahtzigger_Card','Naght Seiger Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','16','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillAtk,MG_NAPALMBEAT,30; bonus2 bSkillAtk,MG_SOULSTRIKE,30; bonus2 bSkillAtk,HW_NAPALMVULCAN,30; bonus2 bSkillAtk,GS_MAGICALBULLET,30; bonus2 bSkillAtk,WL_SOULEXPANSION,30;','',''); -REPLACE INTO `item_db_re` VALUES ('4458','Duneirre_Card','Duneyrr Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','769','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bBaseAtk,10; autobonus \"{ bonus bFlee2,10; }\",10,4000,0,\"{ specialeffect2 EF_ENHANCE; }\";','',''); -REPLACE INTO `item_db_re` VALUES ('4459','Lata_Card','Rata Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','769','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMatk,10; autobonus \"{ bonus bFixedCastrate,-50; }\",10,4000,BF_MAGIC,\"{ specialeffect2 EF_SUFFRAGIUM; }\";','',''); -REPLACE INTO `item_db_re` VALUES ('4460','Ringco_Card','Rhyncho Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','769','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHealPower,4; bonus bUseSPrate,5;','',''); -REPLACE INTO `item_db_re` VALUES ('4461','Pillar_Card','Phylla Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','769','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,1; bonus bAgi,1; autobonus \"{ bonus bCritical,20; }\",4,4000,0,\"{ specialeffect2 EF_ENHANCE; }\";','',''); +REPLACE INTO `item_db_re` VALUES ('4458','Duneirre_Card','Duneyrr Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','769','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bBaseAtk,10; autobonus \"{ bonus bFlee2,10; }\",10,10000,0,\"{ specialeffect2 EF_ENHANCE; }\";','',''); +REPLACE INTO `item_db_re` VALUES ('4459','Lata_Card','Rata Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','769','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMatk,10; autobonus \"{ bonus bFixedCastrate,-50; }\",5,4000,BF_MAGIC,\"{ specialeffect2 EF_SUFFRAGIUM; }\";','',''); +REPLACE INTO `item_db_re` VALUES ('4460','Ringco_Card','Rhyncho Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','769','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHealPower,4; bonus2 bSkillUseSP,\"AL_HEAL\",-15;','',''); +REPLACE INTO `item_db_re` VALUES ('4461','Pillar_Card','Phylla Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','769','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,1; bonus bAgi,1; autobonus \"{ bonus bCritical,20; }\",15,4000,0,\"{ specialeffect2 EF_ENHANCE; }\";','',''); REPLACE INTO `item_db_re` VALUES ('4462','Hardrock_Mommos_Card','Hardrock Mammoth Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','16','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDef,5; if(getrefine()>=12) { bonus bDef,20; bonus bMaxHPrate,10; } if(getrefine()>=14) { bonus bMaxHPrate,3; }','',''); REPLACE INTO `item_db_re` VALUES ('4463','Tendrilion_Card','Tendrillion Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bCritical,5; if(getrefine()>=12) { bonus bBaseAtk,35; } if(getrefine()>=14) { bonus bCritical,10; }','',''); REPLACE INTO `item_db_re` VALUES ('4464','Aunoe_Card','Aunoe Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bCritAtkRate,20;','',''); REPLACE INTO `item_db_re` VALUES ('4465','Panat_Card','Fanat Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bBaseAtk,10; if(getiteminfo(getequipid(EQI_HAND_R),11)==3) { if(getrefine()>=10) { bonus bAspd,1; } if(getrefine()>=14) { bonus bAspd,1; } }','',''); REPLACE INTO `item_db_re` VALUES ('4466','Beholder_Master_Card','Beholder Master Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bLongAtkRate,3; if(getiteminfo(getequipid(EQI_HAND_R),11)==11) { if(getrefine()>=10) { bonus bAspd,1; } if(getrefine()>=14) { bonus bAspd,1; } }','',''); REPLACE INTO `item_db_re` VALUES ('4467','Heavy_Metaling_Card','Heavy Metaling Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','64','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,2; if(BaseClass==Job_Merchant) { bonus2 bSkillAtk,MC_CARTREVOLUTION,50; }','',''); -REPLACE INTO `item_db_re` VALUES ('4468','Pinguicula_Dark_Card','Dark Pinguicula Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','769','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bBaseAtk,10; bonus2 bAddMonsterDropItem,7932,30; bonus2 bAddMonsterDropItem,7933,30; bonus2 bAddMonsterDropItem,7934,30; bonus2 bAddMonsterDropItem,7935,30; bonus2 bAddMonsterDropItem,7936,30; bonus2 bAddMonsterDropItem,7937,30;','',''); +REPLACE INTO `item_db_re` VALUES ('4468','Pinguicula_Dark_Card','Dark Pinguicula Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','769','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bBaseAtk,10; bonus2 bAddMonsterDropItem,7932,10; bonus2 bAddMonsterDropItem,7933,10; bonus2 bAddMonsterDropItem,7934,10; bonus2 bAddMonsterDropItem,7935,10; bonus2 bAddMonsterDropItem,7936,10; bonus2 bAddMonsterDropItem,7937,10;','',''); REPLACE INTO `item_db_re` VALUES ('4469','Naga_Card','Naga Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bMagicAddRace,RC_Fish,10;','',''); REPLACE INTO `item_db_re` VALUES ('4470','Nepenthes_Card','Nepenthes Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bMagicAddRace,RC_Plant,10;','',''); REPLACE INTO `item_db_re` VALUES ('4471','Egg_Of_Draco_Card','Draco Egg Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bMagicAddRace,RC_Dragon,10;','',''); @@ -2490,7 +2490,7 @@ REPLACE INTO `item_db_re` VALUES ('4514','Pom_Spider_Card','Pom Spider Card','6' REPLACE INTO `item_db_re` VALUES ('4515','Alnoldi_Card','Alnoldi Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','32','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSubRace,RC_Plant,30;','',''); REPLACE INTO `item_db_re` VALUES ('4516','Comodo_Card','Comodo Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','16','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDef,50; bonus bFlee,-25;','',''); REPLACE INTO `item_db_re` VALUES ('4517','Cendrawasih_Card','Cendrawasih Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','769','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,2; if(BaseClass==Job_Mage) { bonus bInt,getrefine()/3; }','',''); -REPLACE INTO `item_db_re` VALUES ('4518','Banaspaty_Card','Banaspaty Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddEff,Eff_Burning,500;','',''); +REPLACE INTO `item_db_re` VALUES ('4518','Banaspaty_Card','Banaspaty Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddEff,Eff_Burning,1500;','',''); REPLACE INTO `item_db_re` VALUES ('4519','Butoijo_Card','Butoijo Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace,RC_Angel,20;','',''); REPLACE INTO `item_db_re` VALUES ('4520','Leak_Card','Leak Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','4','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,3; bonus2 bAddEff,Eff_Confusion,5000; bonus3 bAddEff,Eff_Confusion,5000,ATF_SKILL;','',''); REPLACE INTO `item_db_re` VALUES ('4521','Sedora_Card','Sedora Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bCritAtkRate,15;','',''); -- cgit v1.2.3-60-g2f50