Jump to content

[BUG] Item_Attr

Cunoo
 Share

Recommended Posts

Cunoo Proficient

Cunoo 209

Posted
Posted

Hi guys,

I have one little problem..
I edit my tables in mysql, just I delete bonuses what I dont want in game..
Problem is if I add or change bonuses in item (71084, 71085), dont working set table and I have enable all bonuses in items..

Here my table:
  

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for item_attr
-- ----------------------------
DROP TABLE IF EXISTS `item_attr`;
CREATE TABLE `item_attr` (
  `apply` enum('MAX_HP','CON','INT','STR','DEX','ATT_SPEED','CAST_SPEED','HP_REGEN','POISON_PCT','CRITICAL_PCT','PENETRATE_PCT','ATTBONUS_HUMAN','STEAL_HP','BLOCK','DODGE','RESIST_WARRIOR','RESIST_ASSASSIN','RESIST_SURA','RESIST_SHAMAN','RESIST_MAGIC','REFLECT_MELEE','MAGIC_ATT_GRADE','ATT_GRADE_BONUS','IMMUNE_STUN','IMMUNE_SLOW','IMMUNE_FALL') NOT NULL DEFAULT 'MAX_HP',
  `prob` varchar(100) NOT NULL DEFAULT '',
  `value` varchar(100) NOT NULL DEFAULT '',
  `weapon` varchar(100) NOT NULL DEFAULT '',
  `body` varchar(100) NOT NULL DEFAULT '',
  `wrist` varchar(100) NOT NULL DEFAULT '',
  `foots` varchar(100) NOT NULL DEFAULT '',
  `neck` varchar(100) NOT NULL DEFAULT '',
  `head` varchar(100) NOT NULL DEFAULT '',
  `shield` varchar(100) NOT NULL DEFAULT '',
  `ear` varchar(100) NOT NULL DEFAULT '',
  `belt` varchar(100) NOT NULL,
  PRIMARY KEY (`apply`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of item_attr
-- ----------------------------
INSERT INTO `item_attr` VALUES ('MAX_HP', '35', '3000', '0', '1', '1', '1', '1', '1', '0', '0', '1');
INSERT INTO `item_attr` VALUES ('CON', '11', '15', '1', '0', '0', '0', '0', '0', '1', '0', '1');
INSERT INTO `item_attr` VALUES ('INT', '11', '15', '1', '0', '0', '0', '0', '0', '1', '0', '1');
INSERT INTO `item_attr` VALUES ('STR', '11', '15', '1', '0', '0', '0', '0', '0', '1', '0', '1');
INSERT INTO `item_attr` VALUES ('DEX', '11', '15', '1', '0', '0', '0', '0', '0', '1', '0', '1');
INSERT INTO `item_attr` VALUES ('ATT_SPEED', '8', '10', '0', '0', '0', '1', '0', '1', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('CAST_SPEED', '8', '30', '1', '1', '1', '0', '0', '1', '0', '0', '1');
INSERT INTO `item_attr` VALUES ('HP_REGEN', '65', '50', '0', '0', '1', '0', '1', '1', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('POISON_PCT', '8', '10', '1', '0', '0', '0', '0', '1', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('CRITICAL_PCT', '18', '15', '1', '0', '0', '1', '1', '0', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('PENETRATE_PCT', '30', '15', '1', '0', '1', '0', '1', '0', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('ATTBONUS_HUMAN', '10', '20', '1', '0', '1', '0', '0', '1', '1', '1', '0');
INSERT INTO `item_attr` VALUES ('STEAL_HP', '50', '20', '0', '1', '1', '0', '0', '0', '0', '0', '1');
INSERT INTO `item_attr` VALUES ('BLOCK', '10', '15', '0', '0', '0', '0', '0', '0', '1', '0', '0');
INSERT INTO `item_attr` VALUES ('DODGE', '10', '15', '0', '0', '0', '1', '0', '1', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('RESIST_WARRIOR', '18', '20', '0', '1', '0', '1', '1', '0', '0', '1', '1');
INSERT INTO `item_attr` VALUES ('RESIST_ASSASSIN', '18', '20', '0', '1', '0', '1', '1', '0', '0', '1', '1');
INSERT INTO `item_attr` VALUES ('RESIST_SURA', '18', '20', '0', '1', '0', '1', '1', '0', '0', '1', '1');
INSERT INTO `item_attr` VALUES ('RESIST_SHAMAN', '18', '20', '0', '1', '0', '1', '1', '0', '0', '1', '1');
INSERT INTO `item_attr` VALUES ('RESIST_MAGIC', '25', '20', '0', '1', '1', '0', '0', '1', '0', '0', '1');
INSERT INTO `item_attr` VALUES ('REFLECT_MELEE', '18', '30', '0', '1', '0', '0', '0', '0', '1', '0', '1');
INSERT INTO `item_attr` VALUES ('MAGIC_ATT_GRADE', '9', '150', '0', '1', '0', '0', '0', '0', '0', '0', '1');
INSERT INTO `item_attr` VALUES ('ATT_GRADE_BONUS', '9', '150', '0', '1', '0', '0', '0', '0', '0', '0', '1');
INSERT INTO `item_attr` VALUES ('IMMUNE_STUN', '3', '100', '0', '0', '0', '0', '0', '0', '1', '0', '0');
INSERT INTO `item_attr` VALUES ('IMMUNE_SLOW', '3', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1');
INSERT INTO `item_attr` VALUES ('IMMUNE_FALL', '3', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1');

Anyone know, where is problem?

Edit: I mean problem is I delete defence (sword, dagger, bla bla...) and repair with resist (sura, war, bla bla) how I can fixed this but I dont want classic resist in 1/5 bonus..

Link to comment
Share on other sites
  • Replies 8
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

xUniverse Contributor

xUniverse 18

Posted
Posted

Do you try without deleting the defenses (sword, dagger, etc) but setting the prob as 0? (I know that it isn't a solution, but it's a way to avoid the problem and it works fine for me) 

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for item_attr
-- ----------------------------
DROP TABLE IF EXISTS `item_attr`;
CREATE TABLE `item_attr` (
  `apply` enum('MAX_HP','MAX_SP','CON','INT','STR','DEX','ATT_SPEED','MOV_SPEED','CAST_SPEED','HP_REGEN','SP_REGEN','POISON_PCT','STUN_PCT','SLOW_PCT','CRITICAL_PCT','PENETRATE_PCT','ATTBONUS_HUMAN','ATTBONUS_ANIMAL','ATTBONUS_ORC','ATTBONUS_MILGYO','ATTBONUS_UNDEAD','ATTBONUS_DEVIL','STEAL_HP','STEAL_SP','MANA_BURN_PCT','DAMAGE_SP_RECOVER','BLOCK','DODGE','RESIST_SWORD','RESIST_TWOHAND','RESIST_DAGGER','RESIST_BELL','RESIST_FAN','RESIST_BOW','RESIST_FIRE','RESIST_ELEC','RESIST_MAGIC','RESIST_WIND','REFLECT_MELEE','REFLECT_CURSE','POISON_REDUCE','KILL_SP_RECOVER','EXP_DOUBLE_BONUS','GOLD_DOUBLE_BONUS','ITEM_DROP_BONUS','POTION_BONUS','KILL_HP_RECOVER','IMMUNE_STUN','IMMUNE_SLOW','IMMUNE_FALL','SKILL','BOW_DISTANCE','ATT_GRADE_BONUS','DEF_GRADE_BONUS','MAGIC_ATT_GRADE','MAGIC_DEF_GRADE','CURSE_PCT','MAX_STAMINA','ATTBONUS_WARRIOR','ATTBONUS_ASSASSIN','ATTBONUS_SURA','ATTBONUS_SHAMAN','ATTBONUS_MONSTER','MALL_ATTBONUS','MALL_DEFBONUS','MALL_EXPBONUS','MALL_ITEMBONUS','MALL_GOLDBONUS','MAX_HP_PCT','MAX_SP_PCT','SKILL_DAMAGE_BONUS','NORMAL_HIT_DAMAGE_BONUS','SKILL_DEFEND_BONUS','NORMAL_HIT_DEFEND_BONUS','PC_BANG_EXP_BONUS','PC_BANG_DROP_BONUS','EXTRACT_HP_PCT','RESIST_WARRIOR','RESIST_ASSASSIN','RESIST_SURA','RESIST_SHAMAN','ENERGY','DEF_GRADE','COSTUME_ATTR_BONUS','MAGIC_ATTBONUS_PER','MELEE_MAGIC_ATTBONUS_PER','RESIST_ICE','RESIST_EARTH','RESIST_DARK','ANTI_CRITICAL_PCT','ANTI_PENETRATE_PCT','BLEEDING_REDUCE','BLEEDING_PCT','ATTBONUS_WOLFMAN','RESIST_WOLFMAN','RESIST_CLAW','ANTI_RESIST_MAGIC') NOT NULL DEFAULT 'MAX_HP',
  `prob` varchar(100) NOT NULL DEFAULT '',
  `value` varchar(100) NOT NULL DEFAULT '',
  `weapon` varchar(100) NOT NULL DEFAULT '',
  `body` varchar(100) NOT NULL DEFAULT '',
  `wrist` varchar(100) NOT NULL DEFAULT '',
  `foots` varchar(100) NOT NULL DEFAULT '',
  `neck` varchar(100) NOT NULL DEFAULT '',
  `head` varchar(100) NOT NULL DEFAULT '',
  `shield` varchar(100) NOT NULL DEFAULT '',
  `ear` varchar(100) NOT NULL DEFAULT '',
  `belt` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`apply`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of item_attr
-- ----------------------------
INSERT INTO `item_attr` VALUES ('MAX_HP', '35', '3000', '0', '1', '1', '1', '1', '1', '0', '0', '1');
INSERT INTO `item_attr` VALUES ('CON', '11', '15', '1', '0', '0', '0', '0', '0', '1', '0', '1');
INSERT INTO `item_attr` VALUES ('INT', '11', '15', '1', '0', '0', '0', '0', '0', '1', '0', '1');
INSERT INTO `item_attr` VALUES ('STR', '11', '15', '1', '0', '0', '0', '0', '0', '1', '0', '1');
INSERT INTO `item_attr` VALUES ('DEX', '11', '15', '1', '0', '0', '0', '0', '0', '1', '0', '1');
INSERT INTO `item_attr` VALUES ('ATT_SPEED', '8', '10', '0', '0', '0', '1', '0', '1', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('CAST_SPEED', '8', '30', '1', '1', '1', '0', '0', '1', '0', '0', '1');
INSERT INTO `item_attr` VALUES ('HP_REGEN', '65', '50', '0', '0', '1', '0', '1', '1', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('POISON_PCT', '8', '10', '1', '0', '0', '0', '0', '1', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('CRITICAL_PCT', '18', '15', '1', '0', '0', '1', '1', '0', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('PENETRATE_PCT', '30', '15', '1', '0', '1', '0', '1', '0', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('ATTBONUS_HUMAN', '10', '20', '1', '0', '1', '0', '0', '1', '1', '1', '0');
INSERT INTO `item_attr` VALUES ('STEAL_HP', '50', '20', '0', '1', '1', '0', '0', '0', '0', '0', '1');
INSERT INTO `item_attr` VALUES ('BLOCK', '10', '15', '0', '0', '0', '0', '0', '0', '1', '0', '0');
INSERT INTO `item_attr` VALUES ('DODGE', '10', '15', '0', '0', '0', '1', '0', '1', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('RESIST_WARRIOR', '18', '20', '0', '1', '0', '1', '1', '0', '0', '1', '1');
INSERT INTO `item_attr` VALUES ('RESIST_ASSASSIN', '18', '20', '0', '1', '0', '1', '1', '0', '0', '1', '1');
INSERT INTO `item_attr` VALUES ('RESIST_SURA', '18', '20', '0', '1', '0', '1', '1', '0', '0', '1', '1');
INSERT INTO `item_attr` VALUES ('RESIST_SHAMAN', '18', '20', '0', '1', '0', '1', '1', '0', '0', '1', '1');
INSERT INTO `item_attr` VALUES ('RESIST_MAGIC', '25', '20', '0', '1', '1', '0', '0', '1', '0', '0', '1');
INSERT INTO `item_attr` VALUES ('REFLECT_MELEE', '18', '30', '0', '1', '0', '0', '0', '0', '1', '0', '1');
INSERT INTO `item_attr` VALUES ('RESIST_SWORD', '0', '15', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('RESIST_TWOHAND', '0', '15', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('RESIST_DAGGER', '0', '15', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('RESIST_BELL', '0', '15', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('RESIST_FAN', '0', '15', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('MAGIC_ATT_GRADE', '9', '150', '0', '1', '0', '0', '0', '0', '0', '0', '1');
INSERT INTO `item_attr` VALUES ('ATT_GRADE_BONUS', '9', '150', '0', '1', '0', '0', '0', '0', '0', '0', '1');
INSERT INTO `item_attr` VALUES ('IMMUNE_STUN', '3', '100', '0', '0', '0', '0', '0', '0', '1', '0', '0');
INSERT INTO `item_attr` VALUES ('IMMUNE_SLOW', '3', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1');
INSERT INTO `item_attr` VALUES ('IMMUNE_FALL', '3', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1');

 

Link to comment
Share on other sites
Cunoo Proficient

Cunoo 209

Posted
  • Author
Posted
On 11/13/2018 at 12:26 AM, xUniverse said:

Do you try without deleting the defenses (sword, dagger, etc) but setting the prob as 0? (I know that it isn't a solution, but it's a way to avoid the problem and it works fine for me) 


SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for item_attr
-- ----------------------------
DROP TABLE IF EXISTS `item_attr`;
CREATE TABLE `item_attr` (
  `apply` enum('MAX_HP','MAX_SP','CON','INT','STR','DEX','ATT_SPEED','MOV_SPEED','CAST_SPEED','HP_REGEN','SP_REGEN','POISON_PCT','STUN_PCT','SLOW_PCT','CRITICAL_PCT','PENETRATE_PCT','ATTBONUS_HUMAN','ATTBONUS_ANIMAL','ATTBONUS_ORC','ATTBONUS_MILGYO','ATTBONUS_UNDEAD','ATTBONUS_DEVIL','STEAL_HP','STEAL_SP','MANA_BURN_PCT','DAMAGE_SP_RECOVER','BLOCK','DODGE','RESIST_SWORD','RESIST_TWOHAND','RESIST_DAGGER','RESIST_BELL','RESIST_FAN','RESIST_BOW','RESIST_FIRE','RESIST_ELEC','RESIST_MAGIC','RESIST_WIND','REFLECT_MELEE','REFLECT_CURSE','POISON_REDUCE','KILL_SP_RECOVER','EXP_DOUBLE_BONUS','GOLD_DOUBLE_BONUS','ITEM_DROP_BONUS','POTION_BONUS','KILL_HP_RECOVER','IMMUNE_STUN','IMMUNE_SLOW','IMMUNE_FALL','SKILL','BOW_DISTANCE','ATT_GRADE_BONUS','DEF_GRADE_BONUS','MAGIC_ATT_GRADE','MAGIC_DEF_GRADE','CURSE_PCT','MAX_STAMINA','ATTBONUS_WARRIOR','ATTBONUS_ASSASSIN','ATTBONUS_SURA','ATTBONUS_SHAMAN','ATTBONUS_MONSTER','MALL_ATTBONUS','MALL_DEFBONUS','MALL_EXPBONUS','MALL_ITEMBONUS','MALL_GOLDBONUS','MAX_HP_PCT','MAX_SP_PCT','SKILL_DAMAGE_BONUS','NORMAL_HIT_DAMAGE_BONUS','SKILL_DEFEND_BONUS','NORMAL_HIT_DEFEND_BONUS','PC_BANG_EXP_BONUS','PC_BANG_DROP_BONUS','EXTRACT_HP_PCT','RESIST_WARRIOR','RESIST_ASSASSIN','RESIST_SURA','RESIST_SHAMAN','ENERGY','DEF_GRADE','COSTUME_ATTR_BONUS','MAGIC_ATTBONUS_PER','MELEE_MAGIC_ATTBONUS_PER','RESIST_ICE','RESIST_EARTH','RESIST_DARK','ANTI_CRITICAL_PCT','ANTI_PENETRATE_PCT','BLEEDING_REDUCE','BLEEDING_PCT','ATTBONUS_WOLFMAN','RESIST_WOLFMAN','RESIST_CLAW','ANTI_RESIST_MAGIC') NOT NULL DEFAULT 'MAX_HP',
  `prob` varchar(100) NOT NULL DEFAULT '',
  `value` varchar(100) NOT NULL DEFAULT '',
  `weapon` varchar(100) NOT NULL DEFAULT '',
  `body` varchar(100) NOT NULL DEFAULT '',
  `wrist` varchar(100) NOT NULL DEFAULT '',
  `foots` varchar(100) NOT NULL DEFAULT '',
  `neck` varchar(100) NOT NULL DEFAULT '',
  `head` varchar(100) NOT NULL DEFAULT '',
  `shield` varchar(100) NOT NULL DEFAULT '',
  `ear` varchar(100) NOT NULL DEFAULT '',
  `belt` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`apply`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of item_attr
-- ----------------------------
INSERT INTO `item_attr` VALUES ('MAX_HP', '35', '3000', '0', '1', '1', '1', '1', '1', '0', '0', '1');
INSERT INTO `item_attr` VALUES ('CON', '11', '15', '1', '0', '0', '0', '0', '0', '1', '0', '1');
INSERT INTO `item_attr` VALUES ('INT', '11', '15', '1', '0', '0', '0', '0', '0', '1', '0', '1');
INSERT INTO `item_attr` VALUES ('STR', '11', '15', '1', '0', '0', '0', '0', '0', '1', '0', '1');
INSERT INTO `item_attr` VALUES ('DEX', '11', '15', '1', '0', '0', '0', '0', '0', '1', '0', '1');
INSERT INTO `item_attr` VALUES ('ATT_SPEED', '8', '10', '0', '0', '0', '1', '0', '1', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('CAST_SPEED', '8', '30', '1', '1', '1', '0', '0', '1', '0', '0', '1');
INSERT INTO `item_attr` VALUES ('HP_REGEN', '65', '50', '0', '0', '1', '0', '1', '1', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('POISON_PCT', '8', '10', '1', '0', '0', '0', '0', '1', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('CRITICAL_PCT', '18', '15', '1', '0', '0', '1', '1', '0', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('PENETRATE_PCT', '30', '15', '1', '0', '1', '0', '1', '0', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('ATTBONUS_HUMAN', '10', '20', '1', '0', '1', '0', '0', '1', '1', '1', '0');
INSERT INTO `item_attr` VALUES ('STEAL_HP', '50', '20', '0', '1', '1', '0', '0', '0', '0', '0', '1');
INSERT INTO `item_attr` VALUES ('BLOCK', '10', '15', '0', '0', '0', '0', '0', '0', '1', '0', '0');
INSERT INTO `item_attr` VALUES ('DODGE', '10', '15', '0', '0', '0', '1', '0', '1', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('RESIST_WARRIOR', '18', '20', '0', '1', '0', '1', '1', '0', '0', '1', '1');
INSERT INTO `item_attr` VALUES ('RESIST_ASSASSIN', '18', '20', '0', '1', '0', '1', '1', '0', '0', '1', '1');
INSERT INTO `item_attr` VALUES ('RESIST_SURA', '18', '20', '0', '1', '0', '1', '1', '0', '0', '1', '1');
INSERT INTO `item_attr` VALUES ('RESIST_SHAMAN', '18', '20', '0', '1', '0', '1', '1', '0', '0', '1', '1');
INSERT INTO `item_attr` VALUES ('RESIST_MAGIC', '25', '20', '0', '1', '1', '0', '0', '1', '0', '0', '1');
INSERT INTO `item_attr` VALUES ('REFLECT_MELEE', '18', '30', '0', '1', '0', '0', '0', '0', '1', '0', '1');
INSERT INTO `item_attr` VALUES ('RESIST_SWORD', '0', '15', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('RESIST_TWOHAND', '0', '15', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('RESIST_DAGGER', '0', '15', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('RESIST_BELL', '0', '15', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('RESIST_FAN', '0', '15', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('MAGIC_ATT_GRADE', '9', '150', '0', '1', '0', '0', '0', '0', '0', '0', '1');
INSERT INTO `item_attr` VALUES ('ATT_GRADE_BONUS', '9', '150', '0', '1', '0', '0', '0', '0', '0', '0', '1');
INSERT INTO `item_attr` VALUES ('IMMUNE_STUN', '3', '100', '0', '0', '0', '0', '0', '0', '1', '0', '0');
INSERT INTO `item_attr` VALUES ('IMMUNE_SLOW', '3', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1');
INSERT INTO `item_attr` VALUES ('IMMUNE_FALL', '3', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1');

 

Thanks, but I know it this.. I need know where is in source table with bonuses/structure table for fix this by myself..

Link to comment
Share on other sites
Cunoo Proficient

Cunoo 209

Posted
  • Author
Posted (edited)
47 minutes ago, xP3NG3Rx said:

First of all what you want to fix?
If you don't want to set for example MAX_HP in armors just set the value of the body column to 0 at the MAX_HP row.

Look in my post table.. And now look screenshot.. I dont have problem with 1/0 (enable/disable) I have problem if is not my table original and I want change bonuses..

Spoiler

https://metin2.download/picture/GIJ1rKas4zgBxa131bZmQ1hn22NKVe5p/.png

screenshot: 20% stun, 20% mystic, 20% orc, 20% human, 30% undead, just I dont have set this in my table..

Edited by Metin2 Dev
Core X - External 2 Internal
Link to comment
Share on other sites
flexio Collaborator

flexio 83

Posted
Posted 
  `apply` enum('MAX_HP','CON','INT','STR','DEX','ATT_SPEED','CAST_SPEED','HP_REGEN','POISON_PCT','CRITICAL_PCT','PENETRATE_PCT','ATTBONUS_HUMAN','STEAL_HP','BLOCK','DODGE','RESIST_WARRIOR','RESIST_ASSASSIN','RESIST_SURA','RESIST_SHAMAN','RESIST_MAGIC','REFLECT_MELEE','MAGIC_ATT_GRADE','ATT_GRADE_BONUS','IMMUNE_STUN','IMMUNE_SLOW','IMMUNE_FALL') NOT NULL DEFAULT 'MAX_HP',

apply value may be different from index in core.

 

find enum EApplyTypes in common/length.h and compare index with item_attr apply

 

 

 

EDIT:

(slovakia lang) Z apply nic nemazej, názvy představují čísla a ty musí být přesně podle jádra. Například "ATTBONUS_ANIMAL" je číslo 18 v jádru, takže musí být i číslo 18 v item_attr.

 

 

Link to comment
Share on other sites
Cunoo Proficient

Cunoo 209

Posted
  • Author
Posted
11 minutes ago, flexio said: 

  `apply` enum('MAX_HP','CON','INT','STR','DEX','ATT_SPEED','CAST_SPEED','HP_REGEN','POISON_PCT','CRITICAL_PCT','PENETRATE_PCT','ATTBONUS_HUMAN','STEAL_HP','BLOCK','DODGE','RESIST_WARRIOR','RESIST_ASSASSIN','RESIST_SURA','RESIST_SHAMAN','RESIST_MAGIC','REFLECT_MELEE','MAGIC_ATT_GRADE','ATT_GRADE_BONUS','IMMUNE_STUN','IMMUNE_SLOW','IMMUNE_FALL') NOT NULL DEFAULT 'MAX_HP',

apply value may be different from index in core.

 

find enum EApplyTypes in common/length.h and compare index with item_attr apply

 

 

Yeeeeeeeeeeeeeeees this is what I want find!!

Thank you so much.

Link to comment
Share on other sites
  • Honorable Member
xP3NG3Rx Perfect

xP3NG3Rx 19047

Posted
  • Honorable Member
Posted

Now I can see, your english is terrible sorry, I didn't understand what was your problem just after the 3rd read.
And actually you removed the bonuses from the enum of apply in the database, what is non-sense to me why.
You have to keep up to date the apply enum in the database with the applies in the source.
 

Link to comment
Share on other sites
Cunoo Proficient

Cunoo 209

Posted
  • Author
Posted (edited)
3 hours ago, xP3NG3Rx said:

Now I can see, your english is terrible sorry, I didn't understand what was your problem just after the 3rd read.
And actually you removed the bonuses from the enum of apply in the database, what is non-sense to me why.
You have to keep up to date the apply enum in the database with the applies in the source.
 

Yes it is... I know.. :D And thank you, for informations.


Solved! Thanks all for help.
 

Spoiler

https://metin2.download/picture/GIJ1rKas4zgBxa131bZmQ1hn22NKVe5p/.png

 

Edited by Metin2 Dev
Core X - External 2 Internal
Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
 Share
Go to topic listing

Announcements



  • Similar Content

  • Activity

    1. 5

      Renewal Icons Affectshower - Skills & Dews & Water & Fish & ETC

      thx
      Hulk in Programming & Scripts
    2. 0

      Metin2 effect script files (MSE and MSA file) how can convert

      Metin2 effect script files (MSE and MSA file) How can I convert a Unity particle system or 3ds Max animation file?
      tengri in Community Support - Questions & Answers
    3. 10

      Multi Language System

      First of all thanks for the release. If anyone try to use this multilang system, here's some tip for the quests because making different quest states for each language as in the example will be a nightmare. translate.lua: --Default arrays gameforge.blacksmith = {} gameforge.blacksmith._10_npcChat = {} gameforge.blacksmith._20_sayTitle = {} gameforge.blacksmith._30_say = {} gameforge.blacksmith._40_sayTitle = {} gameforge.blacksmith._50_sayReward = {} --EN gameforge.blacksmith._10_npcChat["en"] = "I want to upgrade something. " gameforge.blacksmith._20_sayTitle["en"] = "Blacksmith " gameforge.blacksmith._30_say["en"] = "Greetings![ENTER]I am responsible for upgrading items. If you want[ENTER]to upgrade an item, just bring it to me. " gameforge.blacksmith._40_sayTitle["en"] = "Information: " gameforge.blacksmith._50_sayReward["en"] = "Drag an item from your inventory onto the[ENTER]Blacksmith. " --HU gameforge.blacksmith._10_npcChat["hu"] = "Szeretnék valamit feljavíttatni. " gameforge.blacksmith._20_sayTitle["hu"] = "Kovács " gameforge.blacksmith._30_say["hu"] = "Üdvözöllek![ENTER]Én felelek a tárgyak feljavításáért. Ha fel[ENTER]szeretnél javíttatni egy tárgyat, hozd csak ide[ENTER]nekem. " gameforge.blacksmith._40_sayTitle["hu"] = "Információ: " gameforge.blacksmith._50_sayReward["hu"] = "Húzz rá egy tárgyat a leltáradból a Kovácsra. " questlib.lua: function get_lang_name() if get_lang() == 1 then return "hu" end return "en" end blacksmith.quest: quest blacksmith begin state start begin when blacksmith.chat.gameforge.blacksmith._10_npcChat[get_lang_name()] begin say_title(gameforge.blacksmith._20_sayTitle[get_lang_name()]) say(gameforge.blacksmith._30_say[get_lang_name()]) wait() say_title(gameforge.blacksmith._40_sayTitle[get_lang_name()]) say_reward(gameforge.blacksmith._50_sayReward[get_lang_name()]) end end end Some caching mechanism to the get_lang_name() would be nice too. Also do not use this in notice_all because it will notice all in the player's language... Maybe use ["en"] to display notice_alls in english for everyone or code some translating mechanism for the client (e.g. replace chars when displaying the messages depending on the current lang). +1 note: the default qc did not like the [get_lang_name()] in the when statement but a friend gave me a "fixed" qc which you can download here.
      • 1
      • Love
      TMP4 in Features & Metin2 Systems
    4. 0

      We are looking for a C++ and Python programmer

      We are looking for a C++ and Python programmer for systems development and warfare for Metin2
      boloca in Paid Support / Searching / Recruiting
    5. 0

      [Quest Scheduler Request] Is there a way to make a quest run independet of player events? Lets say start quest automatically at server startup?

      The idea is, i want this quest to run regardless of player actions, at the moment it seems to start at player login ideally the quest would start at day Y(could have daily flag) hour X so basically a scheduler, so it won't be dependent on any player events quest test_npcmove begin state start begin when letter begin chat("Started") set_state("spawn_monster_in_map_boss_1") end end -- State to check for/spawn boss 1 state spawn_monster_in_map_boss_1 begin when letter begin chat("Spawning first boss") local mob_vnum = 102 -- Adjust VNUM for boss 1 local map_index = 352 local mobs = find_mobs_in_map(mob_vnum, map_index) local vid_boss1 = 0 local mobs_str = "BOSS 1 VIDs: {" .. table.concat(mobs, ", ") .. "}" chat(mobs_str) chat("Player X: " .. 339 .. " Y: " .. 363) if table.getn(mobs) > 0 then vid_boss1 = mobs[1] chat("Boss 1 found, using existing with VID: " .. tostring(vid_boss1)) else local vids = spawn_monster_in_map(mob_vnum, 1, false, map_index, 339, 363 + 10, true) vid_boss1 = vids[1] if vids[1] ~= nil then vid_boss1 = vids[1] chat("Boss 1 spawned with VID: " .. tostring(vid_boss1)) else vids = find_mobs_in_map(mob_vnum, map_index) vid_boss1 = vids[1] chat("Boss 2 fetched vid for spwaned mob: " .. tostring(vid_boss1)) end end pc.setqf("vid_boss1", vid_boss1) set_state("spawn_monster_in_map_boss_2") end end -- State to check for/spawn boss 2 state spawn_monster_in_map_boss_2 begin when letter begin local mob_vnum = 101 -- Adjust VNUM for boss 2 local map_index = 352 local mobs = find_mobs_in_map(mob_vnum, map_index) local vid_boss2 = 0 local mobs_str = "BOSS 2 VIDs: {" .. table.concat(mobs, ", ") .. "}" chat(mobs_str) if table.getn(mobs) > 0 then vid_boss2 = mobs[1] chat("Boss 2 found, using existing with VID: " .. tostring(vid_boss2)) else local vids = spawn_monster_in_map(mob_vnum, 1, false, map_index, 339, 363 - 10, true) vid_boss2 = vids[1] if vids[1] ~= nil then vid_boss2 = vids[1] chat("Boss 1 spawned with VID: " .. tostring(vid_boss2)) else vids = find_mobs_in_map(mob_vnum, map_index) vid_boss2 = vids[1] chat("Boss 2 fetched vid for spwaned mob: " .. tostring(vid_boss2)) end end pc.setqf("vid_boss2", vid_boss2) set_state("move_bosses") end end -- State to move both bosses state move_bosses begin when letter begin local vid_boss1 = pc.getqf("vid_boss1") local vid_boss2 = pc.getqf("vid_boss2") local target_x = 339 local target_y = 363 mob_move(vid_boss1, target_x, target_y) mob_move(vid_boss2, target_x, target_y) chat("Both bosses moved to player's position.") set_state("bosses_fight") end end -- State where bosses fight state bosses_fight begin when letter begin local vid_boss1 = pc.getqf("vid_boss1") local vid_boss2 = pc.getqf("vid_boss2") local map_index = 352 chat("Boss 1 VID: " .. tostring(vid_boss1)) chat("Boss 2 VID: " .. tostring(vid_boss2)) local success2, message2 = set_pc_can_attack_monster(vid_boss1, false, map_index) local success3, message3 = set_pc_can_attack_monster(vid_boss2, false, map_index) chat("Attempt to make boss 1 invinciple " .. tostring(success2) .. " - " .. message2) chat("Attempt to make boss 2 invinciple " .. tostring(success3) .. " - " .. message3) -- Attempt to make boss 1 attack boss 2 local success1, message1 = attack_mob(vid_boss1, vid_boss2, map_index) if success1 ~= nil and message1 ~= nil then chat("Attack attempt from Boss 1 to Boss 2: " .. tostring(success1) .. " - " .. message1) else chat("Attack attempt from Boss 1 to Boss 2: success or message is nil") end -- Attempt to make boss 2 attack boss 1 local success2, message2 = attack_mob(vid_boss2, vid_boss1, map_index) if success2 ~= nil and message2 ~= nil then chat("Attack attempt from Boss 2 to Boss 1: " .. tostring(success2) .. " - " .. message2) else chat("Attack attempt from Boss 2 to Boss 1: success or message is nil") end chat("Bosses are now set to fight each other.") chat("---------------------------------END------------------------------------") set_state("bosses_alive") end end state bosses_alive begin when letter begin chat("Checking if boss died") local vid_boss1 = pc.getqf("vid_boss1") local vid_boss2 = pc.getqf("vid_boss2") local map_index = 352 -- Check if Boss 1 is alive local is_boss1_alive, boss1_msg = is_mob_alive_in_map(vid_boss1, map_index) chat("Boss 1 alive check: " .. tostring(is_boss1_alive) .. " - " .. boss1_msg) -- Check if Boss 2 is alive local is_boss2_alive, boss2_msg = is_mob_alive_in_map(vid_boss2, map_index) chat("Boss 2 alive check: " .. tostring(is_boss2_alive) .. " - " .. boss2_msg) -- Determine the next state based on the bosses' statuses if not is_boss1_alive or not is_boss2_alive then if is_mob_alive_in_map(vid_boss1, map_index) then local success2, message2 = set_pc_can_attack_monster(vid_boss1, true, map_index) chat("Resetting invicibility for boss1 " .. tostring(success2) .. " - " .. message2) end if is_mob_alive_in_map(vid_boss2, map_index) then local success3, message3 = set_pc_can_attack_monster(vid_boss2, true, map_index) chat("Resetting invicibility for boss2 " .. tostring(success3) .. " - " .. message3) end chat("One of the bosses is dead. Resetting quest.") set_state("start") else chat("Both bosses are alive. Continuing the fight.") set_state("bosses_alive") end end end end And the last state, called bosses_alive seems to also reexecute only at player relog (login) Is there a way to make it so the states are independent of player events and just execute as soon as sv starts?
      astroNOT in Community Support - Questions & Answers
    6. 111

      Ulthar SF V2 (TMP4 Base)

      Can someone help me? .. rafinement still not working for me..
      robertbode in Binaries
    7. 0

      Quest function when 102.kill definition whereabouts help

      Hello, So I m trying to find where this vnum.kill function is defined on serverside, seems quite tricky, if anybody knows where it is defined and what name it has, please lmk Thanks, Gabi might be this guy void CQuestManager::Kill(unsigned int pc, unsigned int npc) { //m_CurrentNPCRace = npc; PC * pPC; sys_log(0, "CQuestManager::Kill QUEST_KILL_EVENT (pc=%d, npc=%d)", pc, npc); if ((pPC = GetPC(pc))) { if (!CheckQuestLoaded(pPC)) return; // kill call script if (npc >= MAIN_RACE_MAX_NUM) //@fixme109 m_mapNPC[npc].OnKill(*pPC); //@warme004 m_mapNPC[QUEST_NO_NPC].OnKill(*pPC); #ifdef ENABLE_PARTYKILL // party_kill call script LPCHARACTER ch = GetCurrentCharacterPtr(); LPPARTY pParty = ch->GetParty(); LPCHARACTER leader = pParty ? pParty->GetLeaderCharacter() : ch; if (leader) { m_pCurrentPartyMember = ch; if (npc >= MAIN_RACE_MAX_NUM) //@fixme109 m_mapNPC[npc].OnPartyKill(*GetPC(leader->GetPlayerID())); //@warme004 m_mapNPC[QUEST_NO_NPC].OnPartyKill(*GetPC(leader->GetPlayerID())); pPC = GetPC(pc); } #endif } else sys_err("QUEST: no such pc id : %d", pc); }
      astroNOT in Community Support - Questions & Answers
    8. 5

      [M2 FILTER] Customized Client Filter

      ENB Mode, a graphic enhancer for dx that people used on SA:MP to make it look better, i didn't see a metin2 server using this since 2017 . [Hidden Content]
      envy in Features & Metin2 Systems
    9. 19

      Chat / Whisper Emoji

      Simpson1 in Features & Metin2 Systems

  • Recently Browsing

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.