Template:Sandbox/Aurelain/SpellsNavbox/row: Difference between revisions

From Heroes of Might and Magic: Olden Era Official Wiki
Browse history interactively
← Older editNewer edit →
No edit summary
No edit summary
Line 29: Line 29:
     S.school = '{{{school}}}'
     S.school = '{{{school}}}'
     AND S.id not like '%_special'
     AND S.id not like '%_special'
    AND S.id not like '%astral_summon_%'
    AND S.id ~='bonus_magic_kill_summon'
    AND S.id ~='neutral_1_magic_back_to_garrison'
    AND S.id ~='neutral_1_magic_mana_transfer'
    AND S.id ~='night_bonus_magic_1_magic'
    AND S.id ~='primal_bonus_magic_1_magic'
     AND T.type = 'spell'
     AND T.type = 'spell'
     AND T.language = '{{{lang|en}}}'
     AND T.language = '{{{lang|en}}}'

Revision as of 20:37, 22 June 2026


Input: 

{{Sandbox/Aurelain/SpellsNavbox/row
|lang=en
|school=day
}}

Output:
| No results

|

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '~='bonus_magic_kill_summon'\x0A AND `S`.`id` ~='neutral_1_magic_back_to_ga...' at line 4

Function: CargoSQLQuery::run Query: SELECT `E`.`_pageID` AS `cargo_backlink_page_id_E`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`S`.`_pageID` AS `cargo_backlink_page_id_S`,`S`.`id` AS `id`,`T`.`language` AS `lang`,`T`.`name` AS `name`,`E`.`name` AS `name_en` FROM `mw4v_cargo__Spell` `S` LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`S`.`id`=`T`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `E` ON ((`S`.`id`=`E`.`target_id`)) WHERE `S`.`school` = 'day' 

   AND `S`.`id` not like '%_special'
   AND `S`.`id` not like '%astral_summon_%'
   AND `S`.`id` ~='bonus_magic_kill_summon'
   AND `S`.`id` ~='neutral_1_magic_back_to_garrison'
   AND `S`.`id` ~='neutral_1_magic_mana_transfer'
   AND `S`.`id` ~='night_bonus_magic_1_magic'
   AND `S`.`id` ~='primal_bonus_magic_1_magic'
   AND `T`.`type` = 'spell'
   AND `T`.`language` = 'en'
   AND `E`.`type` = 'spell'
   AND `E`.`language` = 'en'  ORDER BY `S`.`rank` LIMIT 100

}


Retrieved from "https://wiki.hoodedhorse.com/Heroes_of_Might_and_Magic_Olden_Era/index.php?title=Template:Sandbox/Aurelain/SpellsNavbox/row&oldid=25510"