summaryrefslogtreecommitdiff
path: root/sql-files/item_db_re.sql
diff options
context:
space:
mode:
authorHercules.ws <Hercules@efficiently.awesome>2014-08-07 12:01:30 +0200
committerHerculesWSAPI <Hercules@efficiently.awesome>2014-08-07 12:01:30 +0200
commit7c6f45590e10ff0002830418fcff604c90bafb8a (patch)
tree952a1707d38c1024cbf491e3c38fb64b8d6ed9f1 /sql-files/item_db_re.sql
parentb05ba2d2dc31bad470a8703bc69a5a651d05a718 (diff)
downloadhercules-7c6f45590e10ff0002830418fcff604c90bafb8a.tar.gz
hercules-7c6f45590e10ff0002830418fcff604c90bafb8a.tar.bz2
hercules-7c6f45590e10ff0002830418fcff604c90bafb8a.tar.xz
hercules-7c6f45590e10ff0002830418fcff604c90bafb8a.zip
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
Diffstat (limited to 'sql-files/item_db_re.sql')
-rw-r--r--sql-files/item_db_re.sql18
1 files changed, 9 insertions, 9 deletions
diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql
index 29e580b47..7e7277669 100644
--- a/sql-files/item_db_re.sql
+++ b/sql-files/item_db_re.sql
@@ -574,7 +574,7 @@ REPLACE INTO `item_db_re` VALUES ('1187','Krieger_Twohand_Sword1','Glorious Clay
REPLACE INTO `item_db_re` VALUES ('1188','Veteran_Sword','Veteran Sword','4','10000','5000','2000','180','0','0','1','1','16514','63','2','34','4','80',NULL,'1','3','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if(getskilllv(SM_BASH)==10) { bonus2 bSkillAtk,SM_BASH,50; } if(getskilllv(KN_BOWLINGBASH)==10) { bonus2 bSkillAtk,KN_BOWLINGBASH,50; } bonus bStr,1; bonus bDex,1;','','');
REPLACE INTO `item_db_re` VALUES ('1189','Krasnaya','Krasnaya','4','20','10','3800','200','0','0','2','3','16514','58','2','34','2','50',NULL,'1','3','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if(readparam(bStr)>=95) { bonus bBaseAtk,20; }','','');
REPLACE INTO `item_db_re` VALUES ('1190','Claymore_C','Claymore','4','0','0','0','220','0','0','1','0','16512','63','2','34','3','0',NULL,'0','3','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0; bonus2 bAddSize,Size_Small,40; bonus2 bAddSize,Size_Medium,40; bonus2 bAddSize,Size_Large,40;','','');
-REPLACE INTO `item_db_re` VALUES ('1191','Alca_Bringer','Alca Bringer','4','20','10','3400','280','0','0','2','0','16512','56','2','34','3','100',NULL,'1','3','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAspd,(getrefine()/2);','','');
+REPLACE INTO `item_db_re` VALUES ('1191','Alca_Bringer','Alca Bringer','4','20','10','3400','280','0','0','2','0','128','56','2','34','3','100',NULL,'1','3','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAspd,(getrefine()/2);','','');
REPLACE INTO `item_db_re` VALUES ('1192','P_Slayer1','Eden Slayer I','4','0','0','0','162','0','0','1','0','16514','63','2','34','2','26',NULL,'0','3','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db_re` VALUES ('1193','P_Slayer2','Eden Slayer II','4','0','0','0','185','0','0','1','0','16514','63','2','34','2','40',NULL,'0','3','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db_re` VALUES ('1194','F_Executioner_C','Rental Executioner','4','2','1','0','190','0','0','1','0','16514','63','2','34','4','0',NULL,'0','3','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtkEle,Ele_Dark;','','');
@@ -1523,8 +1523,8 @@ REPLACE INTO `item_db_re` VALUES ('2471','Shoes_Of_Affection','Shoes Of Affectio
REPLACE INTO `item_db_re` VALUES ('2472','Shoes_Of_Judgement','Shoes Of Judgement','5','20','10','300','0','0','12','0','0','256','56','2','64','0','100',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillAtk,AB_JUDEX,30; bonus2 bSkillUseSP,AB_JUDEX,-40; bonus bMaxSP,150;','','');
REPLACE INTO `item_db_re` VALUES ('2473','Para_Team_Boots4','Eden Group Boots IV','5','0','0','0','0','0','20','0','0','4294967295','63','2','64','0','60',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAgi,1; bonus bVit,1; bonus bHPrecovRate,28; bonus bSPrecovRate,12;','','');
REPLACE INTO `item_db_re` VALUES ('2474','Lehmannza_Shoes','Lehmannza Shoes','5','20','10','500','0','0','3','0','1','4294967295','63','2','64','0','60',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,3;','','');
-REPLACE INTO `item_db_re` VALUES ('2475','Ur_Greave','Ur\'s Greaves','5','20','10','900','0','0','32','0','1','16512','56','2','64','0','100',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxSP,40; if(getequiprefinerycnt(EQI_SHOES)>7) bonus bMaxHPrate,getequiprefinerycnt(EQI_SHOES)-7;','','');
-REPLACE INTO `item_db_re` VALUES ('2476','Peuz_Greave','Peuz\'s Greaves','5','20','10','900','0','0','32','0','1','16512','56','2','64','0','100',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxSP,40; bonus bAgi,-7+(getequiprefinerycnt(EQI_SHOES)>8)?8:getequiprefinerycnt(EQI_SHOES);','','');
+REPLACE INTO `item_db_re` VALUES ('2475','Ur_Greave','Ur\'s Greaves','5','20','10','900','0','0','32','0','1','128','56','2','64','0','100',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxSP,40; if(getequiprefinerycnt(EQI_SHOES)>7) bonus bMaxHPrate,getequiprefinerycnt(EQI_SHOES)-7;','','');
+REPLACE INTO `item_db_re` VALUES ('2476','Peuz_Greave','Peuz\'s Greaves','5','20','10','900','0','0','32','0','1','128','56','2','64','0','100',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxSP,40; bonus bAgi,-7+(getequiprefinerycnt(EQI_SHOES)>8)?8:getequiprefinerycnt(EQI_SHOES);','','');
REPLACE INTO `item_db_re` VALUES ('2477','Sabah_Shoes','Sapha Shoes','5','20','10','400','0','0','18','0','1','4096','56','2','64','0','100',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxSP,30; bonus bLuk,3;','','');
REPLACE INTO `item_db_re` VALUES ('2478','Nab_Shoes','Nab Shoes','5','20','10','400','0','0','18','0','1','4096','56','2','64','0','100',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bFlee,3; bonus bInt,2;','','');
REPLACE INTO `item_db_re` VALUES ('2479','White_Wing_Boots','White Wing Boots','5','20','10','400','0','0','18','0','1','2048','56','2','64','0','100',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAgi,2; bonus2 bSkillUseSP,RA_AIMEDBOLT,10;','','');
@@ -1614,8 +1614,8 @@ REPLACE INTO `item_db_re` VALUES ('2570','Shawl_Of_Judgement','Shawl Of Judgemen
REPLACE INTO `item_db_re` VALUES ('2571','Para_Team_Manteau2','Eden Group Manteau II','5','0','0','0','0','0','18','0','0','4294967295','63','2','4','0','60',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bFlee,12; bonus2 bSubEle,Ele_Neutral,10;','','');
REPLACE INTO `item_db_re` VALUES ('2572','Katabart_Sholder','Katabart Sholder','5','20','10','3000','0','0','4','0','0','4294967295','63','2','4','0','70',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db_re` VALUES ('2573','Archangel_Wing','Eternal Wings','5','20','10','200','0','0','18','0','1','4294967295','63','2','4','0','0',NULL,'1','1','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
-REPLACE INTO `item_db_re` VALUES ('2574','Ur_Manteau','Ur\'s Manteau','5','20','10','600','0','0','20','0','0','16512','56','2','4','0','100',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHPrate,2; bonus2 bSubEle,Ele_Neutral,10;','','');
-REPLACE INTO `item_db_re` VALUES ('2575','Peuz_Manteau','Peuz\'s Manteau','5','20','10','600','0','0','16','0','0','16512','56','2','4','0','100',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bFlee,10; bonus bCritical,10;','','');
+REPLACE INTO `item_db_re` VALUES ('2574','Ur_Manteau','Ur\'s Manteau','5','20','10','600','0','0','20','0','0','128','56','2','4','0','100',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHPrate,2; bonus2 bSubEle,Ele_Neutral,10;','','');
+REPLACE INTO `item_db_re` VALUES ('2575','Peuz_Manteau','Peuz\'s Manteau','5','20','10','600','0','0','16','0','0','128','56','2','4','0','100',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bFlee,10; bonus bCritical,10;','','');
REPLACE INTO `item_db_re` VALUES ('2576','Bravery_Bag','Heroic Backpack','5','20','10','200','0','0','20','0','1','4294967295','63','2','4','0','0',NULL,'1','2','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','skill BS_GREED,1; if(getrefine()>6) { if(readparam(bStr)>=90) { bonus bBaseAtk,20; } if(readparam(bInt)>=90) { bonus bMatk,30; } if(readparam(bVit)>=90) { bonus2 bSubEle,Ele_Neutral,10; } if(readparam(bAgi)>=90) { bonus bAspdRate,8; } if(readparam(bDex)>=90) { bonus bLongAtkRate,5; } if(readparam(bLuk)>=90) { bonus bCritAtkRate,10; } } if(getrefine()>8) { if(readparam(bStr)>=90) { bonus bBaseAtk,10; } if(readparam(bInt)>=90) { bonus bMatk,20; } if(readparam(bVit)>=90) { bonus2 bSubEle,Ele_Neutral,5; } if(readparam(bAgi)>=90) { bonus bAspd,1; } if(readparam(bDex)>=90) { bonus bLongAtkRate,5; } if(readparam(bLuk)>=90) { bonus bCritAtkRate,5; } }','','');
REPLACE INTO `item_db_re` VALUES ('2577','Sabah_Hood','Sapha Hood','5','20','10','100','0','0','13','0','0','4096','56','2','4','0','100',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bFlee,12; bonus bCritical,getrefine();','','');
REPLACE INTO `item_db_re` VALUES ('2578','Nab_Hood','Nab Hood','5','20','10','100','0','0','13','0','0','4096','56','2','4','0','100',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bFlee,getrefine()*2; bonus bBaseAtk,getrefine()*2;','','');
@@ -1916,8 +1916,8 @@ REPLACE INTO `item_db_re` VALUES ('2879','Badge_Giorredart','Algol Badge','5','2
REPLACE INTO `item_db_re` VALUES ('2880','Ring_Lupak','Rufaku Ring','5','20','10','200','0','0','1','0','0','4294967295','63','2','136','0','10',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,1;','','');
REPLACE INTO `item_db_re` VALUES ('2881','Orleans_Necklace','Orlean\'s Necklace','5','20','10','100','0','0','0','0','1','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,2;','','');
REPLACE INTO `item_db_re` VALUES ('2882','Ecoro_Cardslip','Card Sleeves ECO ?RO','5','20','10','100','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bVit,1; bonus bLuk,1;','','');
-REPLACE INTO `item_db_re` VALUES ('2883','Ur_Seal','Ur\'s Seal','5','20','10','200','0','0','4','0','1','16512','56','2','136','0','100',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHPrate,2; bonus2 bSkillUseSP,LK_SPIRALPIERCE,5; bonus2 bSkillUseSP,RK_HUNDREDSPEAR,5;','','');
-REPLACE INTO `item_db_re` VALUES ('2884','Peuz_Seal','Peuz\'s Seal','5','20','10','200','0','0','3','0','1','16512','56','2','136','0','100',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bBaseAtk,20; bonus bMaxSP,20;','','');
+REPLACE INTO `item_db_re` VALUES ('2883','Ur_Seal','Ur\'s Seal','5','20','10','200','0','0','4','0','1','128','56','2','136','0','100',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHPrate,2; bonus2 bSkillUseSP,LK_SPIRALPIERCE,5; bonus2 bSkillUseSP,RK_HUNDREDSPEAR,5;','','');
+REPLACE INTO `item_db_re` VALUES ('2884','Peuz_Seal','Peuz\'s Seal','5','20','10','200','0','0','3','0','1','128','56','2','136','0','100',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bBaseAtk,20; bonus bMaxSP,20;','','');
REPLACE INTO `item_db_re` VALUES ('2885','Mother_Heart','Mother\'s Heart','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','1','60','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bBaseAtk,15; bonus bMatk,15; bonus2 bExpAddRace,RC_Boss,15; bonus2 bExpAddRace,RC_NonBoss,15;','','');
REPLACE INTO `item_db_re` VALUES ('2886','Sabah_Ring','Sapha Ring','5','20','10','100','0','0','0','0','0','4096','56','2','136','0','100',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bCritical,3; bonus2 bSkillUseSP,GC_DARKILLUSION,5;','','');
REPLACE INTO `item_db_re` VALUES ('2887','Nab_Ring','Nab Ring','5','20','10','100','0','0','0','0','0','4096','56','2','136','0','100',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bBaseAtk,10; bonus bMatk,20;','','');
@@ -7462,8 +7462,8 @@ REPLACE INTO `item_db_re` VALUES ('15032','Tidung','Tidung','5','10','5','500','
REPLACE INTO `item_db_re` VALUES ('15033','Tutorial_Mattle','Tutorial Mantle','5','0','0','600','0','0','37','0','0','4294967295','63','2','16','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db_re` VALUES ('15034','Tutorial_Mattle_','Tutorial Mantle','5','0','0','600','0','0','37','0','1','4294967295','63','2','16','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db_re` VALUES ('15035','2010Love_Daddy','2010 Love Daddy Shirt','5','10','5','100','0','0','6','0','0','4294967295','63','2','16','0','0',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAllStats,1; bonus bMaxHP,150; bonus bMaxSP,150; bonus2 bResEff,Eff_Stone,9000; bonus2 bResEff,Eff_Freeze,9000; bonus2 bResEff,Eff_Stun,9000; bonus2 bResEff,Eff_Sleep,9000; bonus2 bResEff,Eff_Silence,9000; bonus2 bResEff,Eff_Curse,9000; bonus2 bResEff,Eff_Confusion,9000; bonus2 bResEff,Eff_Blind,9000; bonus2 bResEff,Eff_Poison,9000; bonus2 bResEff,Eff_Bleeding,9000;','','');
-REPLACE INTO `item_db_re` VALUES ('15036','Ur_Plate','Ur\'s Plate','5','20','10','3000','0','0','110','0','0','16512','56','2','16','0','100',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,10; bonus bMaxHPrate,getequiprefinerycnt(EQI_ARMOR); bonus2 bSubRace,RC_DemiHuman,5; bonus2 bSubEle,Ele_Neutral,5;','','');
-REPLACE INTO `item_db_re` VALUES ('15037','Peuz_Plate','Peuz\'s Plate','5','20','10','3000','0','0','110','0','0','16512','56','2','16','0','100',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,10; bonus bBaseAtk,20; bonus bFlee,17;','','');
+REPLACE INTO `item_db_re` VALUES ('15036','Ur_Plate','Ur\'s Plate','5','20','10','3000','0','0','110','0','0','128','56','2','16','0','100',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,10; bonus bMaxHPrate,getequiprefinerycnt(EQI_ARMOR); bonus2 bSubRace,RC_DemiHuman,5; bonus2 bSubEle,Ele_Neutral,5;','','');
+REPLACE INTO `item_db_re` VALUES ('15037','Peuz_Plate','Peuz\'s Plate','5','20','10','3000','0','0','110','0','0','128','56','2','16','0','100',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,10; bonus bBaseAtk,20; bonus bFlee,17;','','');
REPLACE INTO `item_db_re` VALUES ('15038','Sabah_Cloth','Sapha\'s Cloth','5','20','10','100','0','0','45','0','1','4096','56','2','16','0','100',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bLuk,3; bonus3 bAutoSpell,ASC_METEORASSAULT,(getskilllv(ASC_METEORASSAULT)?getskilllv(ASC_METEORASSAULT):1),20;','','');
REPLACE INTO `item_db_re` VALUES ('15039','Nab_Cloth','Nab\'s Cloth','5','20','10','100','0','0','45','0','1','4096','56','2','16','0','100',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,2; bonus bInt,2;','','');
REPLACE INTO `item_db_re` VALUES ('15040','Prison_Uniform','Prison Uniform','5','10','5','1500','0','0','5','0','0','4294967295','63','2','16','0','50',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','set .@rate,(getrefine()>10)?10:getrefine(); bonus bHit,.@rate; bonus bFlee,.@rate;','','');