Template:SpellInfobox: Difference between revisions
No edit summary |
No edit summary |
||
| Line 41: | Line 41: | ||
R3.bonus_description = level3, | R3.bonus_description = level3, | ||
R4.bonus_description = level4, | R4.bonus_description = level4, | ||
S.excaption_in_tooltip_sid = immunities | |||
CONCAT('{{{masterful|}}}') = masterful | CONCAT('{{{masterful|}}}') = masterful | ||
| format = | | format = | ||
| Line 54: | Line 55: | ||
{{SpellInfobox | {{SpellInfobox | ||
|lang=en | |lang=en | ||
|id= | |id=day_2_magic_sharp_edge | ||
|masterful= | |masterful= This version of the spell makes the target always deal maximum Damage. | ||
}} | }} | ||
<pre><nowiki> | <pre><nowiki> | ||
{{SpellInfobox | {{SpellInfobox | ||
|lang=en | |lang=en | ||
|id= | |id=day_2_magic_sharp_edge | ||
|masterful= | |masterful= This version of the spell makes the target always deal maximum Damage. | ||
}} | }} | ||
</nowiki></pre> | </nowiki></pre> | ||
Revision as of 06:23, 25 June 2026
Function: CargoSQLQuery::run Query: SELECT `R`.`_pageID` AS `cargo_backlink_page_id_R`,`R4`.`_pageID` AS `cargo_backlink_page_id_R4`,`R3`.`_pageID` AS `cargo_backlink_page_id_R3`,`R2`.`_pageID` AS `cargo_backlink_page_id_R2`,`R1`.`_pageID` AS `cargo_backlink_page_id_R1`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`S`.`_pageID` AS `cargo_backlink_page_id_S`,`T`.`language` AS `lang`,`S`.`id` AS `id`,`T`.`name` AS `name`,`S`.`rank` AS `tier`,`R`.`mana_cost` AS `mana`,`S`.`school` AS `school`,`S`.`used_on_map` AS `map_spell`,`R1`.`description` AS `effect`,`R2`.`bonus_description` AS `level2`,`R3`.`bonus_description` AS `level3`,`R4`.`bonus_description` AS `level4`,`S`.`excaption_in_tooltip_sid` = immunities
CONCAT('This version of the spell makes the target always deal maximum Damage.') = masterful AS `S excaption in tooltip sid = immunities
CONCAT( This version of the spell makes the target always deal maximum Damage ) = masterful` FROM `mw4v_cargo__Spell` `S` LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`S`.`id`=`T`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `R1` ON ((`S`.`id`=`R1`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `R2` ON ((`S`.`id`=`R2`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `R3` ON ((`S`.`id`=`R3`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `R4` ON ((`S`.`id`=`R4`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__SpellRank` `R` ON ((`S`.`id`=`R`.`spell_id`)) WHERE `S`.`id` = 'day_2_magic_sharp_edge'
AND `T`.`type` = 'spell'
AND `T`.`language` = 'en'
AND `R`.`level` = 1
AND `R1`.`language` = 'en'
AND `R1`.`variant` = 1
AND `R2`.`language` = 'en'
AND `R2`.`variant` = 2
AND `R3`.`language` = 'en'
AND `R3`.`variant` = 3
AND `R4`.`language` = 'en'
AND `R4`.`variant` = 4 ORDER BY `R`.`_pageID`,`R4`.`_pageID`,`R3`.`_pageID`,`R2`.`_pageID`,`R1`.`_pageID` LIMIT 100
{{SpellInfobox
|lang=en
|id=day_2_magic_sharp_edge
|masterful= This version of the spell makes the target always deal maximum Damage.
}}
Function: CargoSQLQuery::run Query: SELECT `R`.`_pageID` AS `cargo_backlink_page_id_R`,`R4`.`_pageID` AS `cargo_backlink_page_id_R4`,`R3`.`_pageID` AS `cargo_backlink_page_id_R3`,`R2`.`_pageID` AS `cargo_backlink_page_id_R2`,`R1`.`_pageID` AS `cargo_backlink_page_id_R1`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`S`.`_pageID` AS `cargo_backlink_page_id_S`,`T`.`language` AS `lang`,`S`.`id` AS `id`,`T`.`name` AS `name`,`S`.`rank` AS `tier`,`R`.`mana_cost` AS `mana`,`S`.`school` AS `school`,`S`.`used_on_map` AS `map_spell`,`R1`.`description` AS `effect`,`R2`.`bonus_description` AS `level2`,`R3`.`bonus_description` AS `level3`,`R4`.`bonus_description` AS `level4`,`S`.`excaption_in_tooltip_sid` = immunities
CONCAT('Affecte tous les ennemis.') = masterful AS `S excaption in tooltip sid = immunities
CONCAT( Affecte tous les ennemis ) = masterful` FROM `mw4v_cargo__Spell` `S` LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`S`.`id`=`T`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `R1` ON ((`S`.`id`=`R1`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `R2` ON ((`S`.`id`=`R2`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `R3` ON ((`S`.`id`=`R3`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `R4` ON ((`S`.`id`=`R4`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__SpellRank` `R` ON ((`S`.`id`=`R`.`spell_id`)) WHERE `S`.`id` = 'night_2_magic_web'
AND `T`.`type` = 'spell'
AND `T`.`language` = 'fr'
AND `R`.`level` = 1
AND `R1`.`language` = 'fr'
AND `R1`.`variant` = 1
AND `R2`.`language` = 'fr'
AND `R2`.`variant` = 2
AND `R3`.`language` = 'fr'
AND `R3`.`variant` = 3
AND `R4`.`language` = 'fr'
AND `R4`.`variant` = 4 ORDER BY `R`.`_pageID`,`R4`.`_pageID`,`R3`.`_pageID`,`R2`.`_pageID`,`R1`.`_pageID` LIMIT 100
{{SpellInfobox
|lang=fr
|id=night_2_magic_web
|masterful=Affecte tous les ennemis.
}}
Function: CargoSQLQuery::run Query: SELECT `R`.`_pageID` AS `cargo_backlink_page_id_R`,`R4`.`_pageID` AS `cargo_backlink_page_id_R4`,`R3`.`_pageID` AS `cargo_backlink_page_id_R3`,`R2`.`_pageID` AS `cargo_backlink_page_id_R2`,`R1`.`_pageID` AS `cargo_backlink_page_id_R1`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`S`.`_pageID` AS `cargo_backlink_page_id_S`,`T`.`language` AS `lang`,`S`.`id` AS `id`,`T`.`name` AS `name`,`S`.`rank` AS `tier`,`R`.`mana_cost` AS `mana`,`S`.`school` AS `school`,`S`.`used_on_map` AS `map_spell`,`R1`.`description` AS `effect`,`R2`.`bonus_description` AS `level2`,`R3`.`bonus_description` AS `level3`,`R4`.`bonus_description` AS `level4`,`S`.`excaption_in_tooltip_sid` = immunities
CONCAT() = masterful AS `S excaption in tooltip sid = immunities CONCAT( ) = masterful` FROM `mw4v_cargo__Spell` `S` LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`S`.`id`=`T`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `R1` ON ((`S`.`id`=`R1`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `R2` ON ((`S`.`id`=`R2`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `R3` ON ((`S`.`id`=`R3`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `R4` ON ((`S`.`id`=`R4`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__SpellRank` `R` ON ((`S`.`id`=`R`.`spell_id`)) WHERE `S`.`id` = 'space_7_magic_shackles' AND `T`.`type` = 'spell' AND `T`.`language` = 'en' AND `R`.`level` = 1 AND `R1`.`language` = 'en' AND `R1`.`variant` = 1 AND `R2`.`language` = 'en' AND `R2`.`variant` = 2 AND `R3`.`language` = 'en' AND `R3`.`variant` = 3 AND `R4`.`language` = 'en' AND `R4`.`variant` = 4 ORDER BY `R`.`_pageID`,`R4`.`_pageID`,`R3`.`_pageID`,`R2`.`_pageID`,`R1`.`_pageID` LIMIT 100
{{SpellInfobox
|lang=en
|id=space_7_magic_shackles
}}
Function: CargoSQLQuery::run Query: SELECT `R`.`_pageID` AS `cargo_backlink_page_id_R`,`R4`.`_pageID` AS `cargo_backlink_page_id_R4`,`R3`.`_pageID` AS `cargo_backlink_page_id_R3`,`R2`.`_pageID` AS `cargo_backlink_page_id_R2`,`R1`.`_pageID` AS `cargo_backlink_page_id_R1`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`S`.`_pageID` AS `cargo_backlink_page_id_S`,`T`.`language` AS `lang`,`S`.`id` AS `id`,`T`.`name` AS `name`,`S`.`rank` AS `tier`,`R`.`mana_cost` AS `mana`,`S`.`school` AS `school`,`S`.`used_on_map` AS `map_spell`,`R1`.`description` AS `effect`,`R2`.`bonus_description` AS `level2`,`R3`.`bonus_description` AS `level3`,`R4`.`bonus_description` AS `level4`,`S`.`excaption_in_tooltip_sid` = immunities
CONCAT() = masterful AS `S excaption in tooltip sid = immunities CONCAT( ) = masterful` FROM `mw4v_cargo__Spell` `S` LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`S`.`id`=`T`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `R1` ON ((`S`.`id`=`R1`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `R2` ON ((`S`.`id`=`R2`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `R3` ON ((`S`.`id`=`R3`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `R4` ON ((`S`.`id`=`R4`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__SpellRank` `R` ON ((`S`.`id`=`R`.`spell_id`)) WHERE `S`.`id` = 'primal_10_magic_primordial_purity' AND `T`.`type` = 'spell' AND `T`.`language` = 'en' AND `R`.`level` = 1 AND `R1`.`language` = 'en' AND `R1`.`variant` = 1 AND `R2`.`language` = 'en' AND `R2`.`variant` = 2 AND `R3`.`language` = 'en' AND `R3`.`variant` = 3 AND `R4`.`language` = 'en' AND `R4`.`variant` = 4 ORDER BY `R`.`_pageID`,`R4`.`_pageID`,`R3`.`_pageID`,`R2`.`_pageID`,`R1`.`_pageID` LIMIT 100
{{SpellInfobox
|lang=en
|id=primal_10_magic_primordial_purity
}}
Function: CargoSQLQuery::run Query: SELECT `R`.`_pageID` AS `cargo_backlink_page_id_R`,`R4`.`_pageID` AS `cargo_backlink_page_id_R4`,`R3`.`_pageID` AS `cargo_backlink_page_id_R3`,`R2`.`_pageID` AS `cargo_backlink_page_id_R2`,`R1`.`_pageID` AS `cargo_backlink_page_id_R1`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`S`.`_pageID` AS `cargo_backlink_page_id_S`,`T`.`language` AS `lang`,`S`.`id` AS `id`,`T`.`name` AS `name`,`S`.`rank` AS `tier`,`R`.`mana_cost` AS `mana`,`S`.`school` AS `school`,`S`.`used_on_map` AS `map_spell`,`R1`.`description` AS `effect`,`R2`.`bonus_description` AS `level2`,`R3`.`bonus_description` AS `level3`,`R4`.`bonus_description` AS `level4`,`S`.`excaption_in_tooltip_sid` = immunities
CONCAT() = masterful AS `S excaption in tooltip sid = immunities CONCAT( ) = masterful` FROM `mw4v_cargo__Spell` `S` LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`S`.`id`=`T`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `R1` ON ((`S`.`id`=`R1`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `R2` ON ((`S`.`id`=`R2`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `R3` ON ((`S`.`id`=`R3`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `R4` ON ((`S`.`id`=`R4`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__SpellRank` `R` ON ((`S`.`id`=`R`.`spell_id`)) WHERE `S`.`id` = 'neutral_magic_dimension_door' AND `T`.`type` = 'spell' AND `T`.`language` = 'en' AND `R`.`level` = 1 AND `R1`.`language` = 'en' AND `R1`.`variant` = 1 AND `R2`.`language` = 'en' AND `R2`.`variant` = 2 AND `R3`.`language` = 'en' AND `R3`.`variant` = 3 AND `R4`.`language` = 'en' AND `R4`.`variant` = 4 ORDER BY `R`.`_pageID`,`R4`.`_pageID`,`R3`.`_pageID`,`R2`.`_pageID`,`R1`.`_pageID` LIMIT 100
{{SpellInfobox
|lang=en
|id=neutral_magic_dimension_door
}}
Function: CargoSQLQuery::run Query: SELECT `R`.`_pageID` AS `cargo_backlink_page_id_R`,`R4`.`_pageID` AS `cargo_backlink_page_id_R4`,`R3`.`_pageID` AS `cargo_backlink_page_id_R3`,`R2`.`_pageID` AS `cargo_backlink_page_id_R2`,`R1`.`_pageID` AS `cargo_backlink_page_id_R1`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`S`.`_pageID` AS `cargo_backlink_page_id_S`,`T`.`language` AS `lang`,`S`.`id` AS `id`,`T`.`name` AS `name`,`S`.`rank` AS `tier`,`R`.`mana_cost` AS `mana`,`S`.`school` AS `school`,`S`.`used_on_map` AS `map_spell`,`R1`.`description` AS `effect`,`R2`.`bonus_description` AS `level2`,`R3`.`bonus_description` AS `level3`,`R4`.`bonus_description` AS `level4`,`S`.`excaption_in_tooltip_sid` = immunities
CONCAT() = masterful AS `S excaption in tooltip sid = immunities CONCAT( ) = masterful` FROM `mw4v_cargo__Spell` `S` LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`S`.`id`=`T`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `R1` ON ((`S`.`id`=`R1`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `R2` ON ((`S`.`id`=`R2`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `R3` ON ((`S`.`id`=`R3`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `R4` ON ((`S`.`id`=`R4`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__SpellRank` `R` ON ((`S`.`id`=`R`.`spell_id`)) WHERE `S`.`id` = 'night_17_magic_read_minds' AND `T`.`type` = 'spell' AND `T`.`language` = 'en' AND `R`.`level` = 1 AND `R1`.`language` = 'en' AND `R1`.`variant` = 1 AND `R2`.`language` = 'en' AND `R2`.`variant` = 2 AND `R3`.`language` = 'en' AND `R3`.`variant` = 3 AND `R4`.`language` = 'en' AND `R4`.`variant` = 4 ORDER BY `R`.`_pageID`,`R4`.`_pageID`,`R3`.`_pageID`,`R2`.`_pageID`,`R1`.`_pageID` LIMIT 100
{{SpellInfobox
|lang=en
|id=night_17_magic_read_minds
}}


