summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
authorHercules.ws <Hercules@efficiently.awesome>2014-08-08 21:04:29 +0200
committerHerculesWSAPI <Hercules@efficiently.awesome>2014-08-08 21:04:29 +0200
commitc57745995dcde9ff5d784227127d52ebd4c93ba3 (patch)
treeab567682ddc8aae4a2ecdba1e98800db82544813 /sql-files
parentf8e02277b74493c1d531cd454f371f1e8016a73a (diff)
downloadhercules-c57745995dcde9ff5d784227127d52ebd4c93ba3.tar.gz
hercules-c57745995dcde9ff5d784227127d52ebd4c93ba3.tar.bz2
hercules-c57745995dcde9ff5d784227127d52ebd4c93ba3.tar.xz
hercules-c57745995dcde9ff5d784227127d52ebd4c93ba3.zip
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/item_db_re.sql14
1 files changed, 7 insertions, 7 deletions
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;','','');