Ability effects

[Bozzax]

Oi!

This is a .sql of ability effects

1. contains errors and is an alpha version
2. abilities are broken down into sub parts (effects). Example hit XX and debuff YY would be 2 effects (one ability)
3. then ability_stats in wardb is "so so" but are cleaned/merged into this as "integer" in columns lvl40-lvl1
4. "missing" ability_stats has been "calculated" and are "decimals" in columns lvl40-lvl1. These needs to be corrected at some point guess a community effort is required
5. abilities that affect other abilities needs more love before useable

https://drive.google.com/file/d/0B9HeNw ... sp=sharing

Waaaagh!!

EDIT: made a new dump including the table structure

[Bozzax]

Uhm anyone knowz what abilities that ignored "normal stackin" rulez? (If any)

[Tesq]

report it on bug tracker not here ---->https://github.com/WarEmu/WarBugs/issues?q=is%3Aopen

[Bozzax]

report it on bug tracker not here ---->https://github.com/WarEmu/WarBugs/issues?q=is%3Aopen

Oh Tesq these are not bugs instead it is a table of WARs abilities broken down into sub effects. I was wondering if anyone know what abilities stacked incorrectly (in the old game) so I could add this stacking abnormalities to the table as well. If I do remember it correctly Slayer had some ability that buffed WS "incorrectly". I was hoping to add this and stuff like WP group cleanse not needing LOS while DoK did.

-- ----------------------------
-- Table structure for ability_effects
-- ----------------------------

Spoiler:

DROP TABLE IF EXISTS `ability_effects`;
CREATE TABLE `ability_effects` (
`id` smallint(6) DEFAULT NULL,
`Seqno` smallint(6) DEFAULT NULL,
`Class` varchar(255) DEFAULT NULL,
`Name` varchar(255) DEFAULT NULL,
`Prerequirement` varchar(255) DEFAULT NULL,
`Cast on` varchar(255) DEFAULT NULL,
`Triggered by` varchar(255) DEFAULT NULL,
`Trigger` varchar(255) DEFAULT NULL,
`Chance` tinyint(4) DEFAULT NULL,
`Affecting` varchar(255) DEFAULT NULL,
`Effect` varchar(255) DEFAULT NULL,
`Behaviour` varchar(255) DEFAULT NULL,
`Mult` decimal(5,3) DEFAULT NULL,
`Value` smallint(6) DEFAULT NULL,
`OverTime` tinyint(4) DEFAULT NULL,
`Duration` smallint(6) DEFAULT NULL,
`Charges` tinyint(4) DEFAULT NULL,
`Stacks` tinyint(4) DEFAULT NULL,
`Ticks Every` decimal(5,3) DEFAULT NULL,
`Internal CD` tinyint(4) DEFAULT NULL,
`Ability` varchar(255) DEFAULT NULL,
`lvl40` varchar(255) DEFAULT NULL,
`lvl39` varchar(255) DEFAULT NULL,
`lvl38` varchar(255) DEFAULT NULL,
`lvl37` varchar(255) DEFAULT NULL,
`lvl36` varchar(255) DEFAULT NULL,
`lvl35` varchar(255) DEFAULT NULL,
`lvl34` varchar(255) DEFAULT NULL,
`lvl33` varchar(255) DEFAULT NULL,
`lvl32` varchar(255) DEFAULT NULL,
`lvl31` varchar(255) DEFAULT NULL,
`lvl30` varchar(255) DEFAULT NULL,
`lvl29` varchar(255) DEFAULT NULL,
`lvl28` varchar(255) DEFAULT NULL,
`lvl27` varchar(255) DEFAULT NULL,
`lvl26` varchar(255) DEFAULT NULL,
`lvl25` varchar(255) DEFAULT NULL,
`lvl24` varchar(255) DEFAULT NULL,
`lvl23` varchar(255) DEFAULT NULL,
`lvl22` varchar(255) DEFAULT NULL,
`lvl21` varchar(255) DEFAULT NULL,
`lvl20` varchar(255) DEFAULT NULL,
`lvl19` varchar(255) DEFAULT NULL,
`lvl18` varchar(255) DEFAULT NULL,
`lvl17` varchar(255) DEFAULT NULL,
`lvl16` varchar(255) DEFAULT NULL,
`lvl15` varchar(255) DEFAULT NULL,
`lvl14` varchar(255) DEFAULT NULL,
`lvl13` varchar(255) DEFAULT NULL,
`lvl12` varchar(255) DEFAULT NULL,
`lvl11` varchar(255) DEFAULT NULL,
`lvl10` varchar(255) DEFAULT NULL,
`lvl9` varchar(255) DEFAULT NULL,
`lvl8` varchar(255) DEFAULT NULL,
`lvl7` varchar(255) DEFAULT NULL,
`lvl6` varchar(255) DEFAULT NULL,
`lvl5` varchar(255) DEFAULT NULL,
`lvl4` varchar(255) DEFAULT NULL,
`lvl3` varchar(255) DEFAULT NULL,
`lvl2` varchar(255) DEFAULT NULL,
`lvl1` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;--
----------------------------
-- Records of ability_effects
-- ----------------------------
INSERT INTO `ability_effects` VALUES ('9304', '2135', 'Archmage', 'Arcane Suppression', '', '', '', '', null, 'self_aoe20', 'disable_knock_back', '', null, null, null, null, null, null, null, null, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `ability_effects` VALUES ('9304', '2136', 'Archmage', 'Arcane Suppression', '', '', '', '', null, 'self_aoe20', 'disable_silence', '', null, null, null, '3', null, null, null, null, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `ability_effects` VALUES ('9257', '2100', 'Archmage', 'Balance Essence', '', '', '', '', null, 'enemy', 'damage_physical', 'lifetap_ally', '1.500', '323', null, null, null, null, null, null, '', '323', '316', '309', '303', '296', '289', '283', '276', '269', '263', '256', '249', '243', '236', '229', '223', '216', '209', '203', '196', '189', '183', '176', '169', '163', '156', '149', '143', '136', '129', '123', '116', '109', '103', '96', '89', '83', '76', '69', '63');
... many more well you get it
...

[Luth]

report it on bug tracker not here ---->https://github.com/WarEmu/WarBugs/issues?q=is%3Aopen

Oh Tesq these are not bugs instead it is a table of WARs abilities broken down into sub effects. I was wondering if anyone know what abilities stacked incorrectly (in the old game) so I could add this stacking abnormalities to the table as well. If I do remember it correctly Slayer had some ability that buffed WS "incorrectly". I was hoping to add this and stuff like WP group cleanse not needing LOS while DoK did.

The slayer WS Buff is "Fierceness " and afaik the stacking was unreliable (sometimes it didn't work on the slayer but other players and vice versa). I don't know if this was fixed.

Another Slayer buff/debuff issue in the old game with "Inevitable Doom":
- it is an ailment but can't be cleansed
- if the enemy had the debuff on it, he was able to remove the debuff with a right-klick on it

[Bozzax]

Version 2 (20141004)
+ Damages parsed instead of calculated
+ Ability types added (ail, hex, curse, buff, dam ... etc)
+ Several other corrections

Spoiler:

/*
Navicat MySQL Data Transfer

Source Server : waremu
Source Server Version : 50619
Source Host : localhost:3306
Source Database : war_world

Target Server Type : MYSQL
Target Server Version : 50619
File Encoding : 65001

Date: 2014-10-04 18:18:40
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for ability_effects
-- ----------------------------
DROP TABLE IF EXISTS `ability_effects`;
CREATE TABLE `ability_effects` (
`id` smallint(6) DEFAULT NULL,
`seqno` smallint(6) DEFAULT NULL,
`class` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`type` varchar(255) DEFAULT NULL,
`prereq` varchar(255) DEFAULT NULL,
`cast on` varchar(255) DEFAULT NULL,
`triggered by` varchar(255) DEFAULT NULL,
`trigger condition` varchar(255) DEFAULT NULL,
`chance` tinyint(4) DEFAULT NULL,
`affecting` varchar(255) DEFAULT NULL,
`effect` varchar(255) DEFAULT NULL,
`behaviour` varchar(255) DEFAULT NULL,
`mult` decimal(5,2) DEFAULT NULL,
`value` smallint(6) DEFAULT NULL,
`over time` tinyint(4) DEFAULT NULL,
`duration` smallint(6) DEFAULT NULL,
`charges` tinyint(4) DEFAULT NULL,
`stacks` tinyint(4) DEFAULT NULL,
`ticks every` decimal(5,2) DEFAULT NULL,
`internal CD` tinyint(4) DEFAULT NULL,
`ability` varchar(255) DEFAULT NULL,
`DescX` text,
`value40` smallint(6) DEFAULT NULL,
`value39` smallint(6) DEFAULT NULL,
`value38` smallint(6) DEFAULT NULL,
`value37` smallint(6) DEFAULT NULL,
`value36` smallint(6) DEFAULT NULL,
`value35` smallint(6) DEFAULT NULL,
`value34` smallint(6) DEFAULT NULL,
`value33` smallint(6) DEFAULT NULL,
`value32` smallint(6) DEFAULT NULL,
`value31` smallint(6) DEFAULT NULL,
`value30` smallint(6) DEFAULT NULL,
`value29` smallint(6) DEFAULT NULL,
`value28` smallint(6) DEFAULT NULL,
`value27` smallint(6) DEFAULT NULL,
`value26` smallint(6) DEFAULT NULL,
`value25` smallint(6) DEFAULT NULL,
`value24` smallint(6) DEFAULT NULL,
`value23` smallint(6) DEFAULT NULL,
`value22` smallint(6) DEFAULT NULL,
`value21` smallint(6) DEFAULT NULL,
`value20` smallint(6) DEFAULT NULL,
`value19` smallint(6) DEFAULT NULL,
`value18` smallint(6) DEFAULT NULL,
`value17` smallint(6) DEFAULT NULL,
`value16` smallint(6) DEFAULT NULL,
`value15` smallint(6) DEFAULT NULL,
`value14` smallint(6) DEFAULT NULL,
`value13` smallint(6) DEFAULT NULL,
`value12` smallint(6) DEFAULT NULL,
`value11` smallint(6) DEFAULT NULL,
`value10` smallint(6) DEFAULT NULL,
`value9` smallint(6) DEFAULT NULL,
`value8` smallint(6) DEFAULT NULL,
`value7` smallint(6) DEFAULT NULL,
`value6` smallint(6) DEFAULT NULL,
`value5` smallint(6) DEFAULT NULL,
`value4` smallint(6) DEFAULT NULL,
`value3` smallint(6) DEFAULT NULL,
`value2` smallint(6) DEFAULT NULL,
`value1` smallint(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

https://drive.google.com/file/d/0B9HeNw ... sp=sharing

Warspec 3.0 which has been parsed
https://drive.google.com/file/d/0B9HeNw ... sp=sharing

Ps. Can someone with write access rename the wardb ability_effects file to ability_effects.sql and update it with new data please

[nalgol]

the damages are off enraged blow ( chosen ) lvl 1 says 41 damage that is wrong its 15 base damage
so i guess all other damages are wrong as well

you can find that out if you set strength to 0 and remove your weapon then the ability info gives you the right damage
you then have to add weapondamage *1,5
+ strength \5 * 1,5 t
to the base damage to get your real ability damage

[Bozzax]

Not sure I follow you but this why it is 41 in the file

<specline>Path of Corruption</specline>
<name>Enraged Blow</name>
<cooldown>No cooldown</cooldown>
<descriptions>
<desc id="1">A powerful blow that does 41 damage and has significantly increased threat against monsters</desc>

Spoiler:

<desc id="2">A powerful blow that does 43 damage and has significantly increased threat against monsters</desc>
<desc id="3">A powerful blow that does 46 damage and has significantly increased threat against monsters</desc>
<desc id="4">A powerful blow that does 48 damage and has significantly increased threat against monsters</desc>
<desc id="5">A powerful blow that does 51 damage and has significantly increased threat against monsters</desc>
<desc id="6">A powerful blow that does 53 damage and has significantly increased threat against monsters</desc>
<desc id="7">A powerful blow that does 56 damage and has significantly increased threat against monsters</desc>
<desc id="8">A powerful blow that does 58 damage and has significantly increased threat against monsters</desc>
<desc id="9">A powerful blow that does 61 damage and has significantly increased threat against monsters</desc>
<desc id="10">A powerful blow that does 63 damage and has significantly increased threat against monsters</desc>
<desc id="11">A powerful blow that does 66 damage and has significantly increased threat against monsters</desc>
<desc id="12">A powerful blow that does 68 damage and has significantly increased threat against monsters</desc>
<desc id="13">A powerful blow that does 71 damage and has significantly increased threat against monsters</desc>
<desc id="14">A powerful blow that does 73 damage and has significantly increased threat against monsters</desc>
<desc id="15">A powerful blow that does 76 damage and has significantly increased threat against monsters</desc>
<desc id="16">A powerful blow that does 78 damage and has significantly increased threat against monsters</desc>
<desc id="17">A powerful blow that does 81 damage and has significantly increased threat against monsters</desc>
<desc id="18">A powerful blow that does 83 damage and has significantly increased threat against monsters</desc>
<desc id="19">A powerful blow that does 86 damage and has significantly increased threat against monsters</desc>
<desc id="20">A powerful blow that does 88 damage and has significantly increased threat against monsters</desc>
<desc id="21">A powerful blow that does 91 damage and has significantly increased threat against monsters</desc>
<desc id="22">A powerful blow that does 93 damage and has significantly increased threat against monsters</desc>
<desc id="23">A powerful blow that does 96 damage and has significantly increased threat against monsters</desc>
<desc id="24">A powerful blow that does 98 damage and has significantly increased threat against monsters</desc>
<desc id="25">A powerful blow that does 101 damage and has significantly increased threat against monsters</desc>
<desc id="26">A powerful blow that does 103 damage and has significantly increased threat against monsters</desc>
<desc id="27">A powerful blow that does 106 damage and has significantly increased threat against monsters</desc>
<desc id="28">A powerful blow that does 108 damage and has significantly increased threat against monsters</desc>
<desc id="29">A powerful blow that does 111 damage and has significantly increased threat against monsters</desc>
<desc id="30">A powerful blow that does 113 damage and has significantly increased threat against monsters</desc>
<desc id="31">A powerful blow that does 116 damage and has significantly increased threat against monsters</desc>
<desc id="32">A powerful blow that does 118 damage and has significantly increased threat against monsters</desc>
<desc id="33">A powerful blow that does 121 damage and has significantly increased threat against monsters</desc>
<desc id="34">A powerful blow that does 123 damage and has significantly increased threat against monsters</desc>
<desc id="35">A powerful blow that does 126 damage and has significantly increased threat against monsters</desc>
<desc id="36">A powerful blow that does 128 damage and has significantly increased threat against monsters</desc>
<desc id="37">A powerful blow that does 131 damage and has significantly increased threat against monsters</desc>
<desc id="38">A powerful blow that does 133 damage and has significantly increased threat against monsters</desc>
<desc id="39">A powerful blow that does 136 damage and has significantly increased threat against monsters</desc>
<desc id="40">A powerful blow that does 138 damage and has significantly increased threat against monsters</desc>

</descriptions>

[nalgol]

yeah but thats wrong its supposed to be 15 without any modifications from weapon or stats
see here http://web.archive.org/web/200809271217 ... px?id=8315

duno where that line A powerful blow that does 41 damage and has significantly increased threat against monsters comes from but it got the wrong base damage it includes weapon damage and strength bonus

[Tesq]

report it on bug tracker not here ---->https://github.com/WarEmu/WarBugs/issues?q=is%3Aopen

Oh Tesq these are not bugs instead it is a table of WARs abilities broken down into sub effects. I was wondering if anyone know what abilities stacked incorrectly (in the old game) so I could add this stacking abnormalities to the table as well. If I do remember it correctly Slayer had some ability that buffed WS "incorrectly". I was hoping to add this and stuff like WP group cleanse not needing LOS while DoK did.

-- ----------------------------
-- Table structure for ability_effects
-- ----------------------------

Spoiler:

DROP TABLE IF EXISTS `ability_effects`;
CREATE TABLE `ability_effects` (
`id` smallint(6) DEFAULT NULL,
`Seqno` smallint(6) DEFAULT NULL,
`Class` varchar(255) DEFAULT NULL,
`Name` varchar(255) DEFAULT NULL,
`Prerequirement` varchar(255) DEFAULT NULL,
`Cast on` varchar(255) DEFAULT NULL,
`Triggered by` varchar(255) DEFAULT NULL,
`Trigger` varchar(255) DEFAULT NULL,
`Chance` tinyint(4) DEFAULT NULL,
`Affecting` varchar(255) DEFAULT NULL,
`Effect` varchar(255) DEFAULT NULL,
`Behaviour` varchar(255) DEFAULT NULL,
`Mult` decimal(5,3) DEFAULT NULL,
`Value` smallint(6) DEFAULT NULL,
`OverTime` tinyint(4) DEFAULT NULL,
`Duration` smallint(6) DEFAULT NULL,
`Charges` tinyint(4) DEFAULT NULL,
`Stacks` tinyint(4) DEFAULT NULL,
`Ticks Every` decimal(5,3) DEFAULT NULL,
`Internal CD` tinyint(4) DEFAULT NULL,
`Ability` varchar(255) DEFAULT NULL,
`lvl40` varchar(255) DEFAULT NULL,
`lvl39` varchar(255) DEFAULT NULL,
`lvl38` varchar(255) DEFAULT NULL,
`lvl37` varchar(255) DEFAULT NULL,
`lvl36` varchar(255) DEFAULT NULL,
`lvl35` varchar(255) DEFAULT NULL,
`lvl34` varchar(255) DEFAULT NULL,
`lvl33` varchar(255) DEFAULT NULL,
`lvl32` varchar(255) DEFAULT NULL,
`lvl31` varchar(255) DEFAULT NULL,
`lvl30` varchar(255) DEFAULT NULL,
`lvl29` varchar(255) DEFAULT NULL,
`lvl28` varchar(255) DEFAULT NULL,
`lvl27` varchar(255) DEFAULT NULL,
`lvl26` varchar(255) DEFAULT NULL,
`lvl25` varchar(255) DEFAULT NULL,
`lvl24` varchar(255) DEFAULT NULL,
`lvl23` varchar(255) DEFAULT NULL,
`lvl22` varchar(255) DEFAULT NULL,
`lvl21` varchar(255) DEFAULT NULL,
`lvl20` varchar(255) DEFAULT NULL,
`lvl19` varchar(255) DEFAULT NULL,
`lvl18` varchar(255) DEFAULT NULL,
`lvl17` varchar(255) DEFAULT NULL,
`lvl16` varchar(255) DEFAULT NULL,
`lvl15` varchar(255) DEFAULT NULL,
`lvl14` varchar(255) DEFAULT NULL,
`lvl13` varchar(255) DEFAULT NULL,
`lvl12` varchar(255) DEFAULT NULL,
`lvl11` varchar(255) DEFAULT NULL,
`lvl10` varchar(255) DEFAULT NULL,
`lvl9` varchar(255) DEFAULT NULL,
`lvl8` varchar(255) DEFAULT NULL,
`lvl7` varchar(255) DEFAULT NULL,
`lvl6` varchar(255) DEFAULT NULL,
`lvl5` varchar(255) DEFAULT NULL,
`lvl4` varchar(255) DEFAULT NULL,
`lvl3` varchar(255) DEFAULT NULL,
`lvl2` varchar(255) DEFAULT NULL,
`lvl1` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;--
----------------------------
-- Records of ability_effects
-- ----------------------------
INSERT INTO `ability_effects` VALUES ('9304', '2135', 'Archmage', 'Arcane Suppression', '', '', '', '', null, 'self_aoe20', 'disable_knock_back', '', null, null, null, null, null, null, null, null, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `ability_effects` VALUES ('9304', '2136', 'Archmage', 'Arcane Suppression', '', '', '', '', null, 'self_aoe20', 'disable_silence', '', null, null, null, '3', null, null, null, null, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `ability_effects` VALUES ('9257', '2100', 'Archmage', 'Balance Essence', '', '', '', '', null, 'enemy', 'damage_physical', 'lifetap_ally', '1.500', '323', null, null, null, null, null, null, '', '323', '316', '309', '303', '296', '289', '283', '276', '269', '263', '256', '249', '243', '236', '229', '223', '216', '209', '203', '196', '189', '183', '176', '169', '163', '156', '149', '143', '136', '129', '123', '116', '109', '103', '96', '89', '83', '76', '69', '63');
... many more well you get it
...

I tough, it would be better if other dev know about it, i didn't know at that time you were alredy giving them help, just tough it was a third part help
anyway


CHOSEN
"Tooth of Tzeentch" is quite bugged, at least i never had the damage increase on my attack and seems even not on my group mates

"Oppression" about this i always see a damage reduction when using this skill but some chosen on KA-KN told around that was buggy, so a check would be appreciate

-about engraged blow, it should be 15 spiritul damage that they were changed to 41 physic damage, somewhere before 1.3.6 patch if not mistake, you could leave it as 15 spiritual damage, cos resistences values in game are those nerfed after 1.3.6

KoBS + BG :

both their knock back have an auto de-active when enemy is immune to be KB, i mean skill cannot be used when enemys are immune, this is just power-up that was done on these 2 classes and never removed, it should be changed as well to match the normal meccanich other kb in game have, cos there are no other cc that have auto de-active
Even kobs and bg knock down works normaly