Template talk:Passive skill table

This talk page is for discussing Template:Passive skill table.

Sign your posts using four tildes (~~~~)
Start a new topic at the bottom under a ==level 2 heading==
Indent replies using colons (:)
Keep it civil
Assume good faith
Don't remove past discussions

The Template should be corrected. In some passive skills there are IDs with zero values and the template uses them in queries. For example:

{{Query base passive skills
|where=
  passive_skill_stats.id = "attack_ailment_damage_+%_while_wielding_melee_weapon"
}}

No results found for the given query. Melee Damage and Life - in this passive skill is id attack_ailment_damage_+%_while_wielding_melee_weapon, but the value is 0. Maybe should make sure that the requests do not get id with values equal to 0?--Ruba159753 (talk) 22:28, 20 June 2019 (UTC)

Add another condition that the value has to be larger than 0:

{{Query base passive skills
|where=
     passive_skill_stats.id = "attack_ailment_damage_+%_while_wielding_melee_weapon"
 AND passive_skill_stats.value > 0
}}

No results found for the given query.

I don't think it's possible to also add passive_skill_stats.value > 0 to {{Query base passive skills}} because the user has decided to use the condition passive_skill_stats.id. The sql query wont understand which row to use when not using passive_skill_stats.id and just break everything. You could use passive_skills.stat_text to just search the shown stat text, but that will yield more work when translating it. --Illviljan (talk) 10:13, 21 June 2019 (UTC)

Template talk:Passive skill table

Navigation menu